impossible pour moi d importer le fichier sql .MySQL a répondu:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`cst_civilite` varchar(5) NOT NULL,
`cst_prenom` varchar(50) NOT NULL,
`cs' at line 7
Code : Tout sélectionner
DROP TABLE IF EXISTS `smi_cst`;
CREATE TABLE IF NOT EXISTS `smi_cst` (
`cst_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cst_datecrea` date NOT NULL DEFAULT '0000-00-00',
`cst_datemod` date NOT NULL DEFAULT '0000-00-00',
`cst_codest` varchar(20) NOT NULL,
`cst_codefonc` varchar(5) NOT NULL,
`cst_civilite` varchar(5) NOT NULL,
`cst_prenom` varchar(50) NOT NULL,
`cst_nom` varchar(50) NOT NULL,
`cst_adr1` varchar(50) NOT NULL,
`cst_adr2` varchar(50) DEFAULT NULL,
`cst_dep` varchar(30) NOT NULL,
`cst_ville` int(10) unsigned NOT NULL,
`cst_codepays` char(3) NOT NULL,
`cst_telf` varchar(20) NOT NULL,
`cst_fax` varchar(20) NOT NULL,
`cst_telp` varchar(20) NOT NULL,
`cst_email` varchar(50) DEFAULT NULL,
`cst_mess` varchar(50) DEFAULT NULL,
`cst_nota` text,
PRIMARY KEY (`cst_id`),
KEY `cst_codest` (`cst_codest`),
KEY `cst_codefonc` (`cst_codefonc`),
KEY `cst_civilite` (`cst_civilite`),
KEY `cst_nom` (`cst_nom`),
KEY `cst_dep` (`cst_dep`),
KEY `cst_codepays` (`cst_codepays`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 COMMENT='Contacts sous-traitants';
