WT4Evh3w

1CREATE TABLE IF NOT EXISTS `messagerie` (
2  `id` int(6) NOT NULL AUTO_INCREMENT,
3  `uid` varchar(17) NOT NULL,
4  `number_army` varchar(10) NOT NULL,
5  `number_allied` varchar(10) NOT NULL,
6  `number_guer` varchar(10) NOT NULL,
7  `contacts_army` text NOT NULL,
8  `contacts_allied` text NOT NULL,
9  `contacts_guer` text NOT NULL,
10  `reception_army` text NOT NULL,
11  `reception_allied` text NOT NULL,
12  `reception_guer` text NOT NULL,
13  `active` tinyint(1) NOT NULL DEFAULT '0',
14  `connected` tinyint(1) NOT NULL DEFAULT '0',
15  `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4;