databases/Metier/schema/execution.process_out.sql
2016-07-01 13:58:43 +02:00

11 lines
492 B
SQL

CREATE TABLE `process_out` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`dateStart` datetime NOT NULL,
`dateEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`unitTotal` int(11) NOT NULL DEFAULT '0',
`unitExec` int(11) NOT NULL DEFAULT '0',
`updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Execution des processus';