13 lines
421 B
SQL
13 lines
421 B
SQL
CREATE TABLE IF NOT EXISTS `banking` (
|
|
`identifier` varchar(46) DEFAULT NULL,
|
|
`type` varchar(50) DEFAULT NULL,
|
|
`amount` int(64) DEFAULT NULL,
|
|
`time` bigint(20) DEFAULT NULL,
|
|
`ID` int(11) NOT NULL AUTO_INCREMENT,
|
|
`balance` int(11) DEFAULT 0,
|
|
`label` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`ID`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|
|
|
|
ALTER TABLE `users` ADD COLUMN `pincode` INT NULL;
|