LtB87HxN

1CREATE TABLE IF NOT EXISTS `messagerie` (
2  `id` INT(6) NOT NULL AUTO_INCREMENT,
3  `uid` VARCHAR(17) NOT NULL,
4  `name_army` VARCHAR(64) NOT NULL,
5  `name_allied` VARCHAR(64) NOT NULL,
6  `name_guer` VARCHAR(64) NOT NULL,
7  `number` VARCHAR(10) NOT NULL,
8  `contacts_army` text NOT NULL,
9  `contacts_allied` text NOT NULL,
10  `contacts_guer` text NOT NULL,
11  `reception_army` text NOT NULL,
12  `reception_allied` text NOT NULL,
13  `reception_guer` text NOT NULL,
14  `deleted` tinyint(1) NOT NULL DEFAULT '0',
15  `active` tinyint(1) NOT NULL DEFAULT '0',
16  `insert_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
17  PRIMARY KEY (`id`)
18) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=2;