14 lines
712 B
SQL
14 lines
712 B
SQL
CREATE TABLE `surveillances_entity` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`RefCmd` varchar(13) CHARACTER SET utf8 NOT NULL,
|
|
`Siren` varchar(9) CHARACTER SET utf8 NOT NULL,
|
|
`Nic` varchar(5) CHARACTER SET utf8 NOT NULL,
|
|
`Ref` varchar(255) CHARACTER SET utf8 NOT NULL,
|
|
`Source` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
|
|
`Login` varchar(50) CHARACTER SET utf8 NOT NULL,
|
|
`Email` varchar(255) CHARACTER SET utf8 NOT NULL,
|
|
`IsValid` tinyint(1) NOT NULL,
|
|
`Done` enum('added','updated','deleted') CHARACTER SET utf8 DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=Aria DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci PAGE_CHECKSUM=0 TRANSACTIONAL=0 COMMENT='Surveillances - Stockage des lignes ';
|