1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE IF NOT EXISTS `campagne` (
`id_campagne` int(11) NOT NULL AUTO_INCREMENT,
`lbl_campagne` varchar(40) NOT NULL,
`nb_max_users` int(11) NOT NULL,
`type` int(11) NOT NULL,
PRIMARY KEY (`id_campagne`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
CREATE TABLE IF NOT EXISTS `membres` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_campagne` int(11) NOT NULL DEFAULT '0',
`login` varchar(20) NOT NULL,
`password` varchar(90) NOT NULL,
................................................
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; |
Partager