Code : Tout sélectionner
CREATE TABLE `bande` (
`id_bande` smallint(5) unsigned NOT NULL auto_increment,
`bande` smallint(5) unsigned default '0',
`mesure` text NOT NULL,
PRIMARY KEY (`id_bande`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
CREATE TABLE `concours` (
`id_concours` smallint(5) unsigned NOT NULL auto_increment,
`nom` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
`report` varchar(255) NOT NULL default '',
`lien` varchar(255) NOT NULL default '',
`info` varchar(255) NOT NULL default '',
PRIMARY KEY (`id_concours`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `concours_bande` (
`id_concours` smallint(5) unsigned NOT NULL default '0',
`id_bande` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id_concours`,`id_bande`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `concours_mode` (
`id_concours` smallint(5) unsigned NOT NULL default '0',
`id_mode` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id_concours`,`id_mode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `mode` (
`id_mode` smallint(5) unsigned NOT NULL auto_increment,
`mode` varchar(15) default NULL,
PRIMARY KEY (`id_mode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
