1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE IF NOT EXISTS `mps` (
**`id_message` int(11) NOT NULL auto_increment,
**`id_destinataire` int(11) NOT NULL,
**`id_expediteur` int(11) default NULL,
**`content` text,
**`created` timestamp NOT NULL default CURRENT_TIMESTAMP,
**`lu` enum('0','1') default NULL,
**PRIMARY KEY* (`id_message`)
) ENGINE=MyISAM* DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
*
--
-- Contenu de la table `mps`
--
*
INSERT INTO `mps` (`id_message`, `id_destinataire`, `id_expediteur`, `content`, `created`, `lu`) VALUES
(1, 2, 1, 'bonjour monsieur ', '2013-06-04 17:49:51', NULL),
(2, 1, 2, 'Hey ! ', '2013-06-04 20:57:20', NULL),
(3, 3, 1, 'Coucou ! Ça va ? ', '2013-06-04 20:57:21', NULL),
(4, 0, 2, 'Test mp\n\n', '2013-06-04 20:57:21', NULL),
(5, 1, 3, 'Bien et toi ? ', '2013-06-04 20:57:26', NULL); |
Partager