· 8 years ago · Aug 13, 2018, 10:58 PM
1CREATE TABLE IF NOT EXISTS `panel_MSG` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `id_receveur` int(11) NOT NULL,
4 `date_emission` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
5 `titre` text NOT NULL,
6 `messages` text NOT NULL,
7 `new` tinyint(1) NOT NULL DEFAULT '1',
8 `save` tinyint(1) NOT NULL DEFAULT '0',
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;