DROP TABLE IF EXISTS `acteurs`; CREATE TABLE `acteurs` ( `id_acteur` bigint(20) NOT NULL auto_increment, `nom_acteur` varchar(200) character set utf8 NOT NULL, `adresse` varchar(250) character set utf8 NOT NULL COMMENT ’adresse’, `code_postal` varchar(10) character set utf8 NOT NULL, `ville` varchar(200) character set utf8 NOT NULL, `mobile` tinytext character set utf8 NOT NULL COMMENT ’mobile’, `role` text character set utf8 NOT NULL COMMENT ’role’, `email` varchar(250) character set utf8 NOT NULL COMMENT ’mail’, `maj` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id_acteur`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;