1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
CREATE TABLE `essai` (
`ca` int(3) unsigned NOT NULL default '0',
`tit` tinytext NOT NULL,
`cat` set('A1','A2','A4','A5','A6','A7','A8','B1','B2','C1','C2','C3','D1','D2','D3','E1','E2','E3','F1','F2','G1','G2','G3','H1','I1','I2','I3','I4','I5','J1','J2','J3','J4','J5','J6','K1','K2','K3','K4','L1','L2','L3','L4','M1','N1','N2','N3','O1','O2','O3','O4','O5','P1','Q1','R1','S1','Z2') NOT NULL default 'R1',
`eu` varchar(11) NOT NULL default '00',
`ed` varchar(11) NOT NULL default '00',
`himg` varchar(6) character set latin1 collate latin1_bin NOT NULL default '0',
`descab` text NOT NULL,
`carcab` text NOT NULL,
`fab` varchar(20) NOT NULL default 'Belkin',
`win` enum('O','N') NOT NULL default 'O',
`mac` enum('O','N') NOT NULL default 'O',
`pro` tinytext NOT NULL,
`nou` enum('O','N') NOT NULL default 'N',
`bro` varchar(255) NOT NULL default '',
`prix` varchar(30) character set latin1 collate latin1_bin NOT NULL default '0',
PRIMARY KEY (`ca_id`),
FULLTEXT KEY `carcab` (`carcab`),
FULLTEXT KEY `descab` (`descab`),
FULLTEXT KEY `titcab` (`titcab`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager