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
|
CREATE TABLE IF NOT EXISTS `mc_catalog_rel_product` (
`idrelproduct` int(6) NOT NULL,
`idcatalog` int(6) NOT NULL,
`idproduct` int(6) NOT NULL,
PRIMARY KEY (`idrelproduct`),
KEY `idcatalog` (`idcatalog`),
KEY `idproduct` (`idproduct`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `mc_catalog_product` (
`idproduct` int(6) NOT NULL AUTO_INCREMENT,
`idcatalog` int(6) NOT NULL,
`idclc` tinyint(3) NOT NULL,
`idcls` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`idproduct`),
KEY `idclc` (`idclc`),
KEY `idcatalog` (`idcatalog`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
CREATE TABLE IF NOT EXISTS `mc_catalog` (
`idcatalog` int(6) NOT NULL AUTO_INCREMENT,
`titlecatalog` varchar(125) NOT NULL,
`desccatalog` text NOT NULL,
PRIMARY KEY (`idcatalog`),
KEY `idclc` (`idlang`),
KEY `idadmin` (`idadmin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table du catalogue';
CREATE TABLE IF NOT EXISTS `mc_catalog_c` (
`idclc` tinyint(3) NOT NULL AUTO_INCREMENT,
`clibelle` varchar(125) NOT NULL,
`idlang` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`idclc`),
KEY `idlang` (`idlang`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table des catégories du catalogue' ;
CREATE TABLE IF NOT EXISTS `mc_catalog_s` (
`idcls` tinyint(3) NOT NULL AUTO_INCREMENT,
`slibelle` varchar(125) NOT NULL,
`idclc` tinyint(3) NOT NULL,
PRIMARY KEY (`idcls`),
KEY `idclc` (`idclc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='table des sous catégories du catalogue' ; |
Partager