CREATE TABLE IF NOT EXISTS membre ( id int(11) NOT NULL AUTO_INCREMENT, login varchar(255) NOT NULL, pwd varchar(255) NOT NULL, mail varchar(255) NOT NULL, permission int(11) NOT NULL, prenom varchar(255) NOT NULL, date_inscription datetime NOT NULL, last_connexion datetime NOT NULL, avatar varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Last edit: Jouve 2012-04-19
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
--
-- Base de données:
minecraft--
--
-- Structure de la table
membre--
CREATE TABLE IF NOT EXISTS
membre(idint(11) NOT NULL AUTO_INCREMENT,loginvarchar(255) NOT NULL,pwdvarchar(255) NOT NULL,mailvarchar(255) NOT NULL,permissionint(11) NOT NULL,prenomvarchar(255) NOT NULL,date_inscriptiondatetime NOT NULL,last_connexiondatetime NOT NULL,avatarvarchar(255) NOT NULL,PRIMARY KEY (
id)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Last edit: Jouve 2012-04-19