Modulo tienda
Estructura tablas
CREATE TABLE `CLI_PRODUCTS` (
`PRODUCT_ID` int(7) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`PRICE` decimal(7,2) DEFAULT NULL,
`CLASS` int(7) DEFAULT '1',
`WEIGHT` int(4) DEFAULT NULL,
`STOCK` int(4) DEFAULT NULL,
`STOCKMIN` int(4) DEFAULT NULL,
`ONLY_COMPLETE_BOX` int(1) DEFAULT '0',
`UNITS_PER_BOX` int(5) DEFAULT '12',
`DOWNLOAD_COUNT` int(7) DEFAULT '0',
`PRODUCT_ORDER` int(5) DEFAULT NULL,
`DESCRIPTION` text COLLATE utf8_unicode_ci,
`DESCRIPTION_en` text COLLATE utf8_unicode_ci,
`ACTIVE` int(1) DEFAULT '1',
`SIZES` int(1) DEFAULT '0',
`CREATED_BY` int(5) DEFAULT NULL,
`CREATION_DATE` datetime DEFAULT NULL,
`LAST_UPDATED_BY` int(5) DEFAULT NULL,
`LAST_UPDATE_DATE` datetime DEFAULT NULL,
`ID_TIPO` int(5) DEFAULT '1',
`ID_BODEGA` int(5) DEFAULT '1',
`ID_DENOMINACION` int(5) DEFAULT '1',
`FILE_NAME` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`FILE_NAME_BIG` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`FICHA` text COLLATE utf8_unicode_ci,
`FICHA_en` text COLLATE utf8_unicode_ci,
`VARIEDAD` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`FICHA_PDF` text COLLATE utf8_unicode_ci,
`FICHA_PDF_en` text COLLATE utf8_unicode_ci,
`VOLUME` int(3) DEFAULT '3',
`PENIN` int(2) DEFAULT NULL,
`PARKER` int(2) DEFAULT NULL,
`DEKANTER` int(2) DEFAULT NULL,
`DEKANTER_HR` int(1) DEFAULT NULL,
`VINOUS` int(2) DEFAULT NULL,
`NAME_en` varchar(100) COLLATE utf8_unicode_ci DEFAULT '',
`WFCP` int(1) DEFAULT NULL,
`DO_HIDDEN` int(1) DEFAULT NULL, -- Ocultar DO en ficha
`FOOTER` text COLLATE utf8_unicode_ci,
`FOOTER_en` text COLLATE utf8_unicode_ci,
`QRCODE` int(1) DEFAULT NULL,
`QRCODE_URL` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`QRCODE_URL_en` varchar(150) COLLATE utf8_unicode_ci DEFAULT '',
`ORGANIC` int(1) DEFAULT NULL,
`QRCODE_IMG_ES` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`QRCODE_IMG_EN` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`SUBTITLE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`SUBTITLE_en` varchar(50) COLLATE utf8_unicode_ci DEFAULT '',
PRIMARY KEY (`PRODUCT_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_c
CREATE TABLE `CLI_BODEGAS` (
`ID` int(5) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`FILE_NAME` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`DESCRIPTION` text COLLATE utf8_unicode_ci,
`ID_ORDER` int(8) DEFAULT NULL,
`ACTIVE` int(1) DEFAULT '1',
`SUBTITLE` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`FILE_NAME_LOGO_MINI` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`LAT` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
`LON` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
`WEB` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `CLI_TIPOS` (
`ID` int(5) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`FILE_NAME` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`DESCRIPTION` text COLLATE utf8_unicode_ci,
`ID_ORDER` int(8) DEFAULT NULL,
`ACTIVE` int(1) DEFAULT '1',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `CLI_DENOMINACIONES` (
`ID` int(5) unsigned NOT NULL AUTO_INCREMENT,
`NAME` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`FILE_NAME` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`DESCRIPTION` text COLLATE utf8_unicode_ci,
`ID_ORDER` int(8) DEFAULT NULL,
`ACTIVE` int(1) DEFAULT '1',
`FILE_MAP` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `CLI_PRODUCTS_TAGS` (
`ID` int(5) unsigned NOT NULL AUTO_INCREMENT,
`PRODUCT_ID` int(5) DEFAULT NULL,
`TAG_ID` int(5) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=220 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci