20 lines
981 B
SQL
20 lines
981 B
SQL
CREATE TABLE `surveillances` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`refCmd` varchar(13) CHARACTER SET utf8 NOT NULL,
|
|
`nbLine` int(11) NOT NULL,
|
|
`nbLineLoaded` int(11) NOT NULL,
|
|
`nbLineIdValid` int(11) NOT NULL,
|
|
`reportNbAdd` int(11) DEFAULT NULL,
|
|
`reportNbUpdate` int(11) DEFAULT NULL,
|
|
`reportNbDelete` int(11) DEFAULT NULL,
|
|
`dateAdded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`dateLoaded` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateExec` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateReport` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`toReplace` tinyint(1) DEFAULT NULL,
|
|
`processNbLine` int(11) DEFAULT NULL,
|
|
`processDateStart` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`processDateEnd` 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 COMMENT='Gestion des chargement surveillances';
|