816dB3w2

1CREATE TABLE IF NOT EXISTS `transactionLog` (
2  `id` int(6) NOT NULL AUTO_INCREMENT,
3  `name` varchar(32) NOT NULL,
4  `pid` varchar(17) NOT NULL,
5  `cash` int(100) NOT NULL DEFAULT '0',
6  `bank` int(100) NOT NULL DEFAULT '0',
7  `type` enum('cash','card','loan') NOT NULL DEFAULT 'cash',
8  `text` text NOT NULL,
9  `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
10  PRIMARY KEY (`id`),
11  UNIQUE KEY `pid` (`pid`),
12  KEY `name` (`name`),
13) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;