· 6 years ago · Jun 09, 2019, 01:22 PM
1DROP TABLE IF EXISTS `dima_lspd_amendes`;
2CREATE TABLE IF NOT EXISTS `dima_lspd_amendes` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `ch` int(11) NOT NULL,
5 `amount` int(11) NOT NULL,
6 `reason` text NOT NULL,
7 `officer` int(11) NOT NULL,
8 `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
9 `done` int(11) NOT NULL DEFAULT '0',
10 PRIMARY KEY (`id`)
11) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;