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 30 31 32 33 34 35 36 37 38 39 40 41
|
--
-- Structure de la table `membre`
--
CREATE TABLE `membre` (
`id` int(11) NOT NULL,
`sid` int(11) NOT NULL default '0',
`pseudo` varchar(80) NOT NULL,
`pass_md5` text NOT NULL,
`nom` varchar(80) NOT NULL default '',
`prenom` varchar(80) NOT NULL default '',
`adresse` text NOT NULL,
`cp` text NOT NULL,
`ville` text NOT NULL,
`spec` text NOT NULL,
`urlblog` varchar(150) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`photoarticle` text NOT NULL,
`lecteurarticle` text NOT NULL,
`parrain` varchar(80) NOT NULL default '',
`affichages` bigint(20) NOT NULL default '0',
`affich` bigint(20) NOT NULL default '0',
`cat` int(11) NOT NULL,
`newsletter` varchar(4) NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`clic` bigint(20) NOT NULL default '0',
`clic2` bigint(20) NOT NULL default '0',
`clic3` bigint(20) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `affichages` (`affichages`),
KEY `cat` (`cat`),
KEY `email` (`email`),
KEY `nom` (`nom`),
KEY `parrain` (`parrain`),
KEY `prenom` (`prenom`),
KEY `pseudo` (`pseudo`),
KEY `sid` (`sid`),
KEY `urlblog` (`urlblog`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=latin1; |
Partager