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