14 lines
641 B
SQL
14 lines
641 B
SQL
CREATE TABLE `indiscores` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`refCmd` varchar(13) CHARACTER SET latin1 NOT NULL,
|
|
`nbLine` int(11) NOT NULL,
|
|
`nbLineAdd` int(11) DEFAULT NULL,
|
|
`nbLineIdValid` int(11) DEFAULT NULL,
|
|
`dateAdded` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateLoaded` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`nbLineProcess` int(11) DEFAULT NULL,
|
|
`dateStart` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateEnd` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=0 TRANSACTIONAL=0;
|