1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE `forum_membres` (
`membre_id` int(11) NOT NULL auto_increment,
`membre_pseudo` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`membre_mdp` varchar(32) character set latin1 collate latin1_general_ci NOT NULL,
`membre_email` varchar(250) character set latin1 collate latin1_general_ci NOT NULL,
`membre_msn` varchar(250) character set latin1 collate latin1_general_ci NOT NULL,
`membre_siteweb` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`membre_nom_siteweb` varchar(255) NOT NULL,
`membre_avatar` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`membre_texte` varchar(200) character set latin1 collate latin1_general_ci NOT NULL,
`membre_localisation` varchar(100) character set latin1 collate latin1_general_ci NOT NULL,
`membre_inscrit` int(11) NOT NULL,
`membre_derniere_visite` int(11) NOT NULL,
`membre_rang` varchar(255) default 'Membre',
`membre_post` int(11) NOT NULL,
PRIMARY KEY (`membre_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; |
Partager