database.sql

--
-- Copyright:     (c) 2017-2022, Pierre-Henry Soria. All Rights Reserved.
-- License:       GNU General Public License <https://www.gnu.org/licenses/gpl-3.0.en.html>
--

CREATE TABLE user (
  userId int(11) unsigned NOT NULL AUTO_INCREMENT,
  hash varchar(40) NOT NULL,
  email varchar(120) NOT NULL,
  password varchar(120) NOT NULL,
  fullname varchar(250) DEFAULT NULL,
  isTwoFactorAuth enum('1','0') DEFAULT '0',
  twoFactorAuthSecret varchar(40) DEFAULT NULL,
  ip varchar(45) NOT NULL DEFAULT '127.0.0.1',
  registrationDate datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY (hash),
  UNIQUE KEY (email),
  PRIMARY KEY (userId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE payment (
  userId int(11) unsigned NOT NULL,
  paymentGateway enum('stripe','paypal') NOT NULL DEFAULT 'stripe',
  publishableKey varchar(40) DEFAULT NULL,
  secretKey varchar(40) DEFAULT NULL,
  paypalEmail varchar(120) NOT NULL,
  businessName varchar(100) NOT NULL,
  itemName varchar(100) NOT NULL,
  currency char(3) NOT NULL DEFAULT 'USD',
  amount decimal(8, 2) NOT NULL DEFAULT '0.00',
  isBitcoin tinyint(1) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (userId),
  FOREIGN KEY (userId) REFERENCES user(userId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;