1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| CREATE TABLE `membres` (
`id_membre` int(11) NOT NULL auto_increment,
`pseudo` varchar(100) NOT NULL,
`pass` varchar(100) character set utf8 collate utf8_bin NOT NULL,
`date_enregistrement` datetime NOT NULL,
sexe char(12) NOT NULL,
PRIMARY KEY (`id_membre`),
UNIQUE KEY `pseudo` (`pseudo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `annonce` (
`id_annonce` INT(11) not null AUTO_INCREMENT,
`id_membre` INT(11) not null,
`choix` VARCHAR(255) not null,
`jours` CHAR(10) not null,
`timestamp`VARCHAR(255) not null,
`annonce` int(3) not null,
PRIMARY KEY (`id_annonce`),
INDEX (`id_membre`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE photo_profil (
id_photo_profil int(4) NOT NULL auto_increment,
id_membre int(11) NOT NULL,
chemin tinytext NOT NULL,
PRIMARY KEY (`id_photo_profil`),
UNIQUE (`id_membre`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8; |
Partager