ngzcsZtT

1CREATE TABLE IF NOT EXISTS `BT___CATEGORIES` (
2  `ID_____CATEGORY` bigint(20) NOT NULL AUTO_INCREMENT,
3  `NAME___CATEGORY` varchar(32) COLLATE utf8_spanish_ci NOT NULL,
4  `FATHER_CATEGORY` bigint(20) DEFAULT NULL,
5  PRIMARY KEY (`ID_____CATEGORY`),
6  KEY `FATHER_CATEGORY` (`FATHER_CATEGORY`)
7) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=185 ;
8
9CREATE TABLE IF NOT EXISTS `BT______INDICES` (
10  `ID________INDEX` bigint(20) NOT NULL AUTO_INCREMENT,
11  `TYPE______INDEX` varchar(12) COLLATE utf8_spanish_ci NOT NULL DEFAULT 'PRODUCT',
12  `OBJECT____INDEX` bigint(20) NOT NULL,
13  `FATHER____INDEX` bigint(20) NOT NULL,
14  `POSTER____INDEX` bigint(20) NOT NULL,
15  `CUSTOM____INDEX` varchar(8) COLLATE utf8_spanish_ci NOT NULL DEFAULT 'NEW',
16  `NAME______INDEX` varchar(32) COLLATE utf8_spanish_ci NOT NULL,
17  `CATEGORY__INDEX` varchar(32) COLLATE utf8_spanish_ci NOT NULL,
18  `PRICE_____INDEX` decimal(12,0) NOT NULL,
19  `UPDATE____INDEX` datetime NOT NULL,
20  PRIMARY KEY (`ID________INDEX`),
21  KEY `TYPE______INDEX` (`TYPE______INDEX`),
22  KEY `NAME______INDEX` (`NAME______INDEX`)
23) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=163 ;