PHP Classes

File: database.sql

Recommend this page to a friend!
  Classes of Pierre-Henry Soria   Link2Payment   database.sql   Download  
File: database.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Link2Payment
Application to generate links for people to pay
Author: By
Last change:
Date: 1 year ago
Size: 1,261 bytes


Class file image Download
-- -- Copyright: (c) 2017-2022, Pierre-Henry Soria. All Rights Reserved. -- License: GNU General Public License <> -- 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 '', 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;