-- MySQL dump 10.11 -- -- Host: localhost Database: -- ------------------------------------------------------ -- Server version 5.0.51a /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `cdcol` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cdcol` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `cdcol`; -- -- Table structure for table `cds` -- DROP TABLE IF EXISTS `cds`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `cds` ( `titel` varchar(200) default NULL, `interpret` varchar(200) default NULL, `jahr` int(11) default NULL, `id` bigint(20) unsigned NOT NULL auto_increment, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `cds` -- LOCK TABLES `cds` WRITE; /*!40000 ALTER TABLE `cds` DISABLE KEYS */; INSERT INTO `cds` VALUES ('Beauty','Ryuichi Sakamoto',1990,1),('Goodbye Country (Hello Nightclub)','Groove Armada',2001,4),('Glee','Bran Van 3000',1997,5); /*!40000 ALTER TABLE `cds` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `delicias_carro` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `delicias_carro` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `delicias_carro`; -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `address` ( `address_id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `company` varchar(32) collate utf8_unicode_ci default NULL, `firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `address_1` varchar(64) collate utf8_unicode_ci NOT NULL default '', `address_2` varchar(64) collate utf8_unicode_ci default NULL, `postcode` varchar(10) collate utf8_unicode_ci NOT NULL default '', `city` varchar(32) collate utf8_unicode_ci NOT NULL default '', `country_id` int(11) NOT NULL default '0', `zone_id` int(11) NOT NULL default '0', PRIMARY KEY (`address_id`), KEY `customer_id` (`customer_id`) ) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `address` -- LOCK TABLES `address` WRITE; /*!40000 ALTER TABLE `address` DISABLE KEYS */; INSERT INTO `address` VALUES (16,12,'','juana elizabeth','rodríguez páez','melchor ocampo 73 sur','belizario domínguez 406','82400','escuinapa',138,2169),(18,14,'DPC','Martha','Juárez','Tlahuac 4565','Lomas Estrella','09890','D.F',138,2153),(19,15,'textiles vilta','juan bosco','villanueava curiel','morelos 148-1 sur','','59600','zamora',138,2160),(11,9,'','Nelida','Alcala Gomez','Rio Panuco 1100 col. Vista Hermosa','','62290','Cuernavaca',138,2168),(12,9,'','Nelida ','Alcala Gomez','Rio Panuco 1100 Col. Vista Hermosa','','62290','Cuernavaca',138,2161),(17,13,'','Stefania','Bugnon-Berretti','Pico de Verapaz 22 Torre 1 PB','Jardines en la Montana, Tlalpan','14210','Mexico',138,2159),(15,11,'Deshidratados Alimenticios e Ind','violeta','zamudio','Calle 25 de Mayo # 137, Col Trabajadores.','','66149','Santa Catarina',138,2163),(20,16,'','JOSE ','PEDRAZA AGUILAR ','domicilio conocido','josefa ortiz de dominguez # 3 ahuacatlan de gepe. pinal de amole','76310','ahuacatlan de gpe.',138,2159),(21,17,'M2 Exhibit S.A. de C.V.','marcela','lopez','azores # 810','','03310','mexico d.f.',138,0),(22,17,'M2 Exhibit S.A. de C.V.','marcela','lopez','azores # 810','','03310','Mexico D.F.',138,0),(23,18,'H. Cámara de Diputados','José Alfonso','Luna Staines','Av. Congreso de la Unión N°66. Edificio E tercer piso ala sur','Circ. Fuente del Amor N° 17-1 (edificio)Col fuentes del Pedregal','14140','México, D.F.',138,2159),(24,18,'H. Cámara de Diputados','José Alfonso','Luna Staines','Circ. Fuente del Amor 17-1 (edificio)','Circ. Fuente del Amor N° 17-1 (edificio)Col fuentes del Pedregal','14140','México, D.F.',138,2159),(25,19,'','Ana Lucia','Marquez','Zacatecas 997','','85010','Ciudad Obregon',138,2170),(26,20,'ANDAD A.C.','CÉSAR','GARZA','ZACATECAS 155 COL ROMA','CERRO DE SANANDRES 100 ACMP. CHURUBUSCO','04200','D.F.',138,2169),(27,21,'amelain','jorge fidel ','alcocer perez','calle 8 de octubre s/n ','x calle chilam balam','77890','jose maria morelos',138,2167),(28,22,'Oxford','María Isabel','Gutiérrez Noriega','Av. Toluca #349 Edif. A Depto 301 ','Col. Olivar de los Padres','01780','D.F.',138,2159),(33,26,'','Laura','Gallegos de Areyzaga','29 Poniente No 2707 int 3 Col Benito Juarez','','72410','Puebla',138,2165),(30,23,'','delia berenice','perez ruiz','joaquin cardoso Num.898 Los naranjos','','21386','mexicali',138,2146),(31,24,'PEPSICO','Diana','Gage','Bosque de Duraznos 67, Col. Bosque de las Lomas','','11700','México',138,2153),(32,25,'Chaaj','Luis ','Díaz Barreiro','JJJJJJJJ','','','mexico',138,2153),(34,27,'','Irasema ','Cruz Perez','Salvador Díaz Miron # 4751','Entre calle Campestre y paseo de los cedros','93936','Veracruz',138,2174),(35,28,'','yamel','curi hallal','bufalo 501','','','mexico DF',138,2159),(36,29,'','ISAAC','ZALDIVAR SANDOVAL','CALLE PUEBLA NO. 5712-ALTOS','','72440','PUEBLA',138,2165),(37,30,'AYALA OLGUIN, Y CIA, S.C.','RAUL','QUINTANA GUTIERREZ','NUMANCIA NO. 356 VILLAS DEL REY','PJE. PATZCUARO 559-B','21000','MEXICALI',138,2146); /*!40000 ALTER TABLE `address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `category` ( `category_id` int(11) NOT NULL auto_increment, `image_id` int(11) NOT NULL default '0', `parent_id` int(11) NOT NULL default '0', `path` varchar(64) collate utf8_unicode_ci NOT NULL default '', `sort_order` int(3) default '0', `date_added` datetime default NULL, `date_modified` datetime default NULL, PRIMARY KEY (`category_id`) ) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; INSERT INTO `category` VALUES (29,72,0,'29',9,'2008-02-27 12:01:03','2008-02-27 13:02:35'),(19,51,0,'19',5,'2007-08-30 18:22:13','2008-01-27 12:21:37'),(20,42,0,'20',2,'2007-08-30 20:56:18','2008-01-16 15:10:40'),(22,58,0,'22',8,'2008-01-24 13:38:27','2008-01-27 12:25:24'),(23,51,0,'23',4,'2008-01-24 13:57:20','2008-01-27 12:21:29'),(24,60,0,'24',3,'2008-01-27 12:20:44','2008-01-27 12:21:18'),(25,57,0,'25',1,'2008-01-27 12:22:45','2008-01-27 19:19:57'),(26,57,0,'26',7,'2008-01-27 12:24:57','2008-01-27 12:25:14'),(27,57,0,'27',9,'2008-01-27 12:58:26','2008-01-27 12:58:43'),(28,57,0,'28',0,'2008-01-27 13:27:43',NULL),(30,57,0,'30',12,'2008-02-27 12:12:19','2008-02-27 13:03:15'),(31,57,0,'31',11,'2008-02-27 12:12:34','2008-02-27 13:03:05'),(32,57,0,'32',10,'2008-02-27 12:12:55','2008-02-27 13:04:29'),(33,51,0,'33',0,'2008-04-21 11:18:42',NULL); /*!40000 ALTER TABLE `category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_description` -- DROP TABLE IF EXISTS `category_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `category_description` ( `category_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`category_id`,`language_id`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `category_description` -- LOCK TABLES `category_description` WRITE; /*!40000 ALTER TABLE `category_description` DISABLE KEYS */; INSERT INTO `category_description` VALUES (20,1,'Panes'),(19,1,'Pasteles'),(26,1,'Sin huevo'),(22,1,'Sin lácteos'),(23,1,'Pastas'),(24,1,'Panqués'),(25,1,'Galletas'),(27,1,'Productos de Temporada'),(28,1,'Cereales'),(29,1,'Sin lácteos ni huevo'),(31,1,'Caducidad Prolongada'),(32,1,'Caducidad Corta'),(30,1,'Entrega Exclusiva en D.F.'),(33,1,'Golosinas'); /*!40000 ALTER TABLE `category_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `country` ( `country_id` int(11) NOT NULL auto_increment, `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', `iso_code_2` varchar(2) collate utf8_unicode_ci NOT NULL default '', `iso_code_3` varchar(3) collate utf8_unicode_ci NOT NULL default '', `address_format` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`country_id`) ) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `country` -- LOCK TABLES `country` WRITE; /*!40000 ALTER TABLE `country` DISABLE KEYS */; INSERT INTO `country` VALUES (138,'Mexico','MX','MEX',''); /*!40000 ALTER TABLE `country` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupon` -- DROP TABLE IF EXISTS `coupon`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `coupon` ( `coupon_id` int(11) NOT NULL auto_increment, `code` varchar(10) collate utf8_unicode_ci NOT NULL, `discount` decimal(15,4) NOT NULL, `prefix` varchar(1) collate utf8_unicode_ci NOT NULL, `shipping` int(1) NOT NULL, `date_start` datetime NOT NULL, `date_end` datetime NOT NULL, `uses_total` int(11) NOT NULL, `uses_customer` varchar(11) collate utf8_unicode_ci NOT NULL, `status` int(1) NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`coupon_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `coupon` -- LOCK TABLES `coupon` WRITE; /*!40000 ALTER TABLE `coupon` DISABLE KEYS */; INSERT INTO `coupon` VALUES (1,'1234','10.0000','-',1,'2007-01-01 00:00:00','2008-01-01 00:00:00',1000,'1000',1,'2007-08-23 17:38:27'); /*!40000 ALTER TABLE `coupon` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupon_description` -- DROP TABLE IF EXISTS `coupon_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `coupon_description` ( `coupon_id` int(11) NOT NULL, `language_id` int(11) NOT NULL, `name` varchar(128) collate utf8_unicode_ci NOT NULL, `description` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`coupon_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `coupon_description` -- LOCK TABLES `coupon_description` WRITE; /*!40000 ALTER TABLE `coupon_description` DISABLE KEYS */; INSERT INTO `coupon_description` VALUES (1,1,'Coupon (-10%)','10% Discount to all customer with special offer coupon code.'); /*!40000 ALTER TABLE `coupon_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupon_product` -- DROP TABLE IF EXISTS `coupon_product`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `coupon_product` ( `coupon_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, PRIMARY KEY (`coupon_id`,`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `coupon_product` -- LOCK TABLES `coupon_product` WRITE; /*!40000 ALTER TABLE `coupon_product` DISABLE KEYS */; INSERT INTO `coupon_product` VALUES (1,1),(1,2),(1,3),(1,4); /*!40000 ALTER TABLE `coupon_product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coupon_redeem` -- DROP TABLE IF EXISTS `coupon_redeem`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `coupon_redeem` ( `coupon_redeem_id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL, `order_id` int(11) NOT NULL, `date_added` datetime NOT NULL, `coupon_id` int(11) NOT NULL, PRIMARY KEY (`coupon_redeem_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `coupon_redeem` -- LOCK TABLES `coupon_redeem` WRITE; /*!40000 ALTER TABLE `coupon_redeem` DISABLE KEYS */; /*!40000 ALTER TABLE `coupon_redeem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currency` -- DROP TABLE IF EXISTS `currency`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `currency` ( `currency_id` int(11) NOT NULL auto_increment, `title` varchar(32) collate utf8_unicode_ci NOT NULL default '', `code` varchar(3) collate utf8_unicode_ci NOT NULL default '', `symbol_left` varchar(12) collate utf8_unicode_ci default NULL, `symbol_right` varchar(12) collate utf8_unicode_ci default NULL, `decimal_place` char(1) collate utf8_unicode_ci default NULL, `value` float(13,8) default NULL, `date_modified` datetime default NULL, PRIMARY KEY (`currency_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `currency` -- LOCK TABLES `currency` WRITE; /*!40000 ALTER TABLE `currency` DISABLE KEYS */; INSERT INTO `currency` VALUES (6,'Pesos Mexico','MXN','$','MXN','0',1.00000000,'2008-03-06 17:53:16'),(7,'Dólares Americanos','USD','$','USD','2',0.08695652,'2008-03-06 17:54:07'); /*!40000 ALTER TABLE `currency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `customer` ( `customer_id` int(11) NOT NULL auto_increment, `firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `email` varchar(96) collate utf8_unicode_ci NOT NULL default '', `telephone` varchar(32) collate utf8_unicode_ci NOT NULL default '', `fax` varchar(32) collate utf8_unicode_ci NOT NULL default '', `password` varchar(40) collate utf8_unicode_ci NOT NULL default '', `newsletter` int(1) NOT NULL default '0', `address_id` int(11) NOT NULL default '0', `cart` text collate utf8_unicode_ci NOT NULL, `status` int(1) default '0', `ip` varchar(15) collate utf8_unicode_ci default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`customer_id`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer` VALUES (14,'Martha','Juárez','martha.juarez@innovex.com','56567459','56567459','f2803ba621c14dc0d7208ed4194ed7ab',1,18,'a:3:{i:45;s:1:\"1\";i:26;s:1:\"1\";i:46;s:1:\"1\";}',1,'63.69.85.2','2008-03-31 20:07:43'),(12,'juana elizabeth','rodríguez páez','jerpaez@hotmail.com','016959531606','','ebe6941ee8a10c14dc933ae37a0f43fc',1,16,'a:0:{}',1,'189.174.181.243','2008-03-25 15:54:43'),(15,'juan bosco','villanueava curiel','textilesvilta@hotmail.com','01-351-512-33-10','01-351-512-33-10','528359f6f67ff506208b2bf755403965',1,19,'a:0:{}',1,'189.168.63.105','2008-04-01 15:15:20'),(9,'Nelida','Alcala Gomez','julianaprudencio@prodigy.net.mx','777 3 15 86 28','','e0addfd90789dde9d3da39feed1cfcec',1,11,'a:0:{}',1,'201.145.15.138','2008-02-19 14:19:53'),(13,'Stefania','Bugnon-Berretti','steberretti@yahoo.com','55 54466629','','fcce0ceb54ff4935646bc9702ba44dc9',1,17,'a:0:{}',1,'189.146.105.119','2008-03-28 23:26:57'),(11,'violeta','zamudio','violeta.zamudio@daisamx.com','81-83-36-17-47','','61689cde0e23e8bc11f3e4035d6847dd',1,15,'a:2:{i:10;s:1:\"1\";i:9;s:1:\"1\";}',1,'189.152.116.135','2008-03-13 15:43:40'),(16,'JOSE ','PEDRAZA AGUILAR ','leeoo_3@hotmail.com','01 441 29 13091','','51e4a5611b485ee7d5dcd421c092563b',1,20,'a:6:{i:18;s:1:\"1\";i:26;s:1:\"1\";i:9;s:1:\"1\";i:31;s:1:\"1\";i:10;s:1:\"1\";i:25;s:1:\"1\";}',1,'216.250.212.7','2008-04-02 17:31:19'),(17,'marcela','lopez','marcela@m2exhibit.com','56011224','','5f2f8cb69153d3b5727f8f91624e6c5a',1,21,'a:3:{i:10;s:1:\"1\";i:25;s:1:\"1\";i:14;s:1:\"1\";}',1,'189.146.172.170','2008-04-03 16:17:23'),(18,'José Alfonso','Luna Staines','lunastaineja@hotmail.com','56527319','','14c4f36143b4b09cbc320d7c95a50ee7',0,23,'a:5:{s:5:\"15:40\";s:1:\"1\";s:5:\"17:43\";s:1:\"1\";i:25;s:1:\"1\";i:26;s:1:\"1\";i:23;s:1:\"1\";}',1,'201.147.98.250','2008-04-11 13:59:16'),(19,'Ana Lucia','Marquez','luxxxy@hotmail.com','6444130746','','9eb46c8696d9464d04218e6ee1a6296c',1,25,'a:1:{i:9;s:1:\"1\";}',1,'189.194.85.54','2008-04-14 02:42:52'),(20,'CÉSAR','GARZA','cesar_garza_cobian@hotmail.com','55848844','53362699','8bdfd8f99d9f7383e209e27c3915d2c2',1,26,'a:1:{i:7;s:1:\"1\";}',1,'189.135.142.135','2008-04-23 14:53:52'),(21,'jorge fidel ','alcocer perez','amelainmorelos@hotmail.com','9971027307','','f3b59a4a1cac663d059e7227f75e3804',0,27,'a:0:{}',1,'189.151.31.254','2008-04-27 12:11:58'),(22,'María Isabel','Gutiérrez Noriega','calabaza3002@yahoo.com.mx','56682678','','2911b5d45ced0cd7390e683e16096fa7',1,28,'a:3:{s:5:\"15:39\";s:1:\"1\";i:8;s:1:\"1\";i:9;s:1:\"1\";}',1,'189.140.184.232','2008-05-01 22:41:31'),(23,'delia berenice','perez ruiz','delia.popss@hotmail.com','8423197','','3e21ab62fb17400301d9f0156b6c3031',1,30,'a:0:{}',1,'201.166.43.51','2008-05-05 01:34:28'),(24,'Diana','Gage','diana.gage@pepsico.com.mx','25824711','','8a10e89104b4c360063968e35ebd282e',1,31,'a:2:{i:23;s:1:\"1\";i:14;s:1:\"1\";}',1,'201.147.24.2','2008-05-06 11:47:15'),(25,'Luis ','Díaz Barreiro','diazbarreiro@gmail.com','26066948','','f1945577190e6d3badde474a7e71f6af',1,32,'a:0:{}',1,'201.103.44.230','2008-05-07 14:39:58'),(26,'Laura','Gallegos de Areyzaga','laurisgm@hotmail.com','222-888-9905','','63ad684122b13786a8c1a369838c15f7',1,33,'a:0:{}',1,'200.92.211.154','2008-05-14 12:12:32'),(27,'Irasema ','Cruz Perez','amesari_ver@yahoo.com.mx','2291433451','','9eef3c1fb1f6dd203318190bf5ad40ed',1,34,'a:3:{i:31;s:1:\"5\";i:45;s:1:\"1\";s:5:\"15:39\";s:1:\"1\";}',1,'189.129.141.139','2008-05-19 16:36:22'),(28,'yamel','curi hallal','ycuri@yahoo.com','55347793','','278c79856e0175d7ad85cdca20220911',0,35,'a:0:{}',1,'189.146.134.144','2008-05-25 16:59:19'),(29,'ISAAC','ZALDIVAR SANDOVAL','isaac.zaldivar@maxcom.net.mx','2229543633 celular','','b131b7bfc5201a438b2755001a9c10ba',0,36,'a:0:{}',1,'201.161.33.25','2008-05-29 23:57:30'),(30,'RAUL','QUINTANA GUTIERREZ','rqgtz@msn.com','6865597384','6865588030','2d0afcf20fb24d2d8cde277b0b6c3f53',1,37,'a:0:{}',1,'201.150.128.172','2008-06-04 00:07:22'); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `download` -- DROP TABLE IF EXISTS `download`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `download` ( `download_id` int(11) NOT NULL auto_increment, `filename` varchar(128) collate utf8_unicode_ci NOT NULL default '', `mask` varchar(128) collate utf8_unicode_ci NOT NULL default '', `remaining` int(11) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`download_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `download` -- LOCK TABLES `download` WRITE; /*!40000 ALTER TABLE `download` DISABLE KEYS */; INSERT INTO `download` VALUES (1,'test.txt','',1,'2006-12-06 09:49:57'); /*!40000 ALTER TABLE `download` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `download_description` -- DROP TABLE IF EXISTS `download_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `download_description` ( `download_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`download_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `download_description` -- LOCK TABLES `download_description` WRITE; /*!40000 ALTER TABLE `download_description` DISABLE KEYS */; /*!40000 ALTER TABLE `download_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `extension` -- DROP TABLE IF EXISTS `extension`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `extension` ( `extension_id` int(11) NOT NULL auto_increment, `code` varchar(32) collate utf8_unicode_ci NOT NULL default '', `type` varchar(32) collate utf8_unicode_ci NOT NULL default '', `directory` varchar(32) collate utf8_unicode_ci NOT NULL default '', `filename` varchar(128) collate utf8_unicode_ci NOT NULL default '', `controller` varchar(128) collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`extension_id`) ) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `extension` -- LOCK TABLES `extension` WRITE; /*!40000 ALTER TABLE `extension` DISABLE KEYS */; INSERT INTO `extension` VALUES (19,'total','calculate','calculate','total.php','calculate_total'),(39,'zone','shipping','shipping','zone.php','shipping_zone'),(1,'flat','shipping','shipping','flat.php','shipping_flat'),(20,'subtotal','calculate','calculate','subtotal.php','calculate_subtotal'),(21,'tax','calculate','calculate','tax.php','calculate_tax'),(22,'shipping','calculate','calculate','shipping.php','calculate_shipping'),(23,'header','module','module','header.php','module_catalog_header'),(24,'footer','module','module','footer.php','module_catalog_footer'),(25,'category','module','module','category.php','module_catalog_category'),(26,'information','module','module','information.php','module_catalog_information'),(27,'review','module','module','review.php','module_catalog_review'),(28,'cart','module','module','cart.php','module_catalog_cart'),(29,'header','module','module','header.php','module_admin_header'),(30,'footer','module','module','footer.php','module_admin_footer'),(31,'menu','module','module','menu.php','module_admin_menu'),(32,'cod','payment','payment','cod.php','payment_cod'),(33,'language','module','module','language.php','module_catalog_language'),(34,'search','module','module','search.php','module_catalog_search'),(35,'currency','module','module','currency.php','module_catalog_currency'),(36,'item','shipping','shipping','item.php','shipping_item'),(38,'coupon','calculate','calculate','coupon.php','calculate_coupon'),(18,'paypal','payment','payment','paypal.php','payment_paypal'); /*!40000 ALTER TABLE `extension` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `extension_description` -- DROP TABLE IF EXISTS `extension_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `extension_description` ( `extension_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `name` varchar(128) collate utf8_unicode_ci NOT NULL default '', `description` varchar(255) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`extension_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `extension_description` -- LOCK TABLES `extension_description` WRITE; /*!40000 ALTER TABLE `extension_description` DISABLE KEYS */; INSERT INTO `extension_description` VALUES (1,1,'Flat Rate','Flat Rate Shipping'),(19,1,'Calculate Total','Calculate Total'),(20,1,'Calculate Subtotal','Calculate Subtotal'),(22,1,'Calculate Shipping','Calculate Shipping'),(23,1,'Catalog Header','Catalog Header'),(24,1,'Catalog Footer','Catalog Footer'),(25,1,'Catalog Category','Catalog Category'),(26,1,'Catalog Information','Catalog Information'),(27,1,'Catalog Review','Catalog Review'),(28,1,'Catalog Cart','Catalog Cart'),(29,1,'Admin Header','Admin Header'),(32,1,'Efectivo Contra Entrega','Efectivo Contra Entrega'),(30,1,'Admin Footer','Admin Footer'),(31,1,'Admin Menu','Admin Menu'),(21,1,'Calculate Tax','Calculate Tax'),(33,1,'Catalog Language','Catalog Language'),(34,1,'Catalog Search','Catalog Search'),(35,1,'Catalog Currency','Catalog Currency'),(36,1,'Per Item Rate','Per Item Rate'),(38,1,'Calculate Coupon','Calculate Coupon'),(39,1,'Zone','Zone'),(18,1,'PayPal (Convierta a Dólares Esquina Superior Izquierda)','PayPal Payment Gateway'); /*!40000 ALTER TABLE `extension_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `geo_zone` -- DROP TABLE IF EXISTS `geo_zone`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `geo_zone` ( `geo_zone_id` int(11) NOT NULL auto_increment, `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', `description` varchar(255) collate utf8_unicode_ci NOT NULL default '', `date_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`geo_zone_id`) ) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `geo_zone` -- LOCK TABLES `geo_zone` WRITE; /*!40000 ALTER TABLE `geo_zone` DISABLE KEYS */; INSERT INTO `geo_zone` VALUES (1,'Interior de la República','Interior de la República','2008-02-17 13:05:21','0000-00-00 00:00:00'),(2,'DF y Área Metropolitana','DF y Área Metropolitana','2008-02-17 13:09:48','2007-08-28 23:24:40'),(3,'Sonora 1','Sonora 1',NULL,'2008-02-29 19:05:16'),(4,'Sonora 2','Sonora 2',NULL,'2008-02-29 19:05:29'),(5,'México D.F. 1 día (Caducidad Cor','México D.F.','2008-02-17 13:05:21','2008-02-17 13:05:21'),(6,'Pachuca 1 día (Caducidad Corta)','Pachuca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(7,'Toluca 1 día (Caducidad Corta)','Toluca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(8,'Morelia 1 día (Caducidad Corta)','Morelia','2008-02-17 13:05:21','2008-02-17 13:05:21'),(9,'Cuernavaca 1 día (Caducidad Cort','Cuernavaca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(10,'Puebla 1 día (Caducidad Corta)','Puebla','2008-02-17 13:05:21','2008-02-17 13:05:21'),(11,'Querétaro 1 día (Caducidad Corta','Querétaro','2008-02-17 13:05:21','2008-02-17 13:05:21'),(12,'Tlaxcala 1 día (Caducidad Corta)','Tlaxcala','2008-02-17 13:05:21','2008-02-17 13:05:21'),(13,'León 1 día (Caducidad Corta)','León','2008-02-17 13:05:21','2008-02-17 13:05:21'),(14,'Acapulco 1 día (Caducidad Corta)','Acapulco','2008-02-17 13:05:21','2008-02-17 13:05:21'),(15,'Puerto Vallarta 1 día (Caducidad','Puerto Vallarta','2008-02-17 13:05:21','2008-02-17 13:05:21'),(16,'Monterrey 1 día (Caducidad Corta','Monterrey','2008-02-17 13:05:21','2008-02-17 13:05:21'),(17,'Oaxaca 1 día (Caducidad Corta)','Oaxaca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(18,'San Luis Potosí 1 día (Caducidad','San Luis Potosí','2008-02-17 13:05:21','2008-02-17 13:05:21'),(19,'Veracruz 1 día (Caducidad Corta)','Veracruz','2008-02-17 13:05:21','2008-02-17 13:05:21'),(20,'Aguascalientes 1 día (Caducidad ','Aguascalientes','2008-02-17 13:05:21','2008-02-17 13:05:21'),(21,'Saltillo 1 día (Caducidad Corta)','Saltillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(22,'Torreón 1 día (Caducidad Corta)','Torreón','2008-02-17 13:05:21','2008-02-17 13:05:21'),(23,'Manzanillo 1 día (Caducidad Cort','Manzanillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(24,'Durango 1 día (Caducidad Corta)','Durango','2008-02-17 13:05:21','2008-02-17 13:05:21'),(25,'Guadalajara 1 día (Caducidad Cor','Guadalajara','2008-02-17 13:05:21','2008-02-17 13:05:21'),(26,'Tepic 1 día (Caducidad Corta)','Tepic','2008-02-17 13:05:21','2008-02-17 13:05:21'),(27,'Villahermosa 1 día (Caducidad Co','Villahermosa','2008-02-17 13:05:21','2008-02-17 13:05:21'),(28,'Ciudad Victoria 1 día (Caducidad','Ciudad Victoria','2008-02-17 13:05:21','2008-02-17 13:05:21'),(29,'Tampico 1 día (Caducidad Corta)','Tampico','2008-02-17 13:05:21','2008-02-17 13:05:21'),(30,'Campeche 1 día (Caducidad Corta)','Campeche','2008-02-17 13:05:21','2008-02-17 13:05:21'),(31,'Chihuahua 1 día (Caducidad Corta','Chihuahua','2008-02-17 13:05:21','2008-02-17 13:05:21'),(32,'Culiacán 1 día (Caducidad Corta)','Culiacán','2008-02-17 13:05:21','2008-02-17 13:05:21'),(33,'Mazatlán 1 día (Caducidad Corta)','Mazatlán','2008-02-17 13:05:21','2008-02-17 13:05:21'),(34,'Matamoros 1 día (Caducidad Corta','Matamoros','2008-02-17 13:05:21','2008-02-17 13:05:21'),(35,'Nuevo Laredo 1 día (Caducidad Co','Nuevo Laredo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(36,'Reynosa 1 día (Caducidad Corta)','Reynosa','2008-02-17 13:05:21','2008-02-17 13:05:21'),(37,'Mérida 1 día (Caducidad Corta)','Mérida','2008-02-17 13:05:21','2008-02-17 13:05:21'),(38,'Ciudad Juárez 1 día (Caducidad C','Ciudad Juárez','2008-02-17 13:05:21','2008-02-17 13:05:21'),(39,'Cancún 1 día (Caducidad Corta)','Cancún','2008-02-17 13:05:21','2008-02-17 13:05:21'),(40,'Hermosillo 1 día (Caducidad Cort','Hermosillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(41,'Nogales 1 día (Caducidad Corta)','Nogales','2008-02-17 13:05:21','2008-02-17 13:05:21'),(42,'Mexicali 1 día (Caducidad Corta)','Mexicali','2008-02-17 13:05:21','2008-02-17 13:05:21'),(43,'Tijuana 1 día (Caducidad Corta)','Tijuana','2008-02-17 13:05:21','2008-02-17 13:05:21'),(44,'México D.F. 2 días (Caducidad Pr','México D.F.','2008-02-17 13:05:21','2008-02-17 13:05:21'),(45,'Pachuca 2 días (Caducidad Prolon','Pachuca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(46,'Toluca 2 días (Caducidad Prolong','Toluca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(47,'Morelia 2 días (Caducidad Prolon','Morelia','2008-02-17 13:05:21','2008-02-17 13:05:21'),(48,'Cuernavaca 2 días (Caducidad Pro','Cuernavaca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(49,'Puebla 2 días (Caducidad Prolong','Puebla','2008-02-17 13:05:21','2008-02-17 13:05:21'),(50,'Querétaro 2 días (Caducidad Prol','Querétaro','2008-02-17 13:05:21','2008-02-17 13:05:21'),(51,'Tlaxcala 2 días (Caducidad Prolo','Tlaxcala','2008-02-17 13:05:21','2008-02-17 13:05:21'),(52,'León 2 días (Caducidad Prolongad','León','2008-02-17 13:05:21','2008-02-17 13:05:21'),(53,'Acapulco 2 días (Caducidad Prolo','Acapulco','2008-02-17 13:05:21','2008-02-17 13:05:21'),(54,'Puerto Vallarta 2 días (Caducida','Puerto Vallarta','2008-02-17 13:05:21','2008-02-17 13:05:21'),(55,'Monterrey 2 días (Caducidad Prol','Monterrey','2008-02-17 13:05:21','2008-02-17 13:05:21'),(56,'Oaxaca 2 días (Caducidad Prolong','Oaxaca','2008-02-17 13:05:21','2008-02-17 13:05:21'),(57,'San Luis Potosí 2 días (Caducida','San Luis Potosí','2008-02-17 13:05:21','2008-02-17 13:05:21'),(58,'Veracruz 2 días (Caducidad Prolo','Veracruz','2008-02-17 13:05:21','2008-02-17 13:05:21'),(59,'Aguascalientes 2 días (Caducidad','Aguascalientes','2008-02-17 13:05:21','2008-02-17 13:05:21'),(60,'Saltillo 2 días (Caducidad Prolo','Saltillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(61,'Torreón 2 días (Caducidad Prolon','Torreón','2008-02-17 13:05:21','2008-02-17 13:05:21'),(62,'Manzanillo 2 días (Caducidad Pro','Manzanillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(63,'Durango 2 días (Caducidad Prolon','Durango','2008-02-17 13:05:21','2008-02-17 13:05:21'),(64,'Guadalajara 2 días (Caducidad Pr','Guadalajara','2008-02-17 13:05:21','2008-02-17 13:05:21'),(65,'Tepic 2 días (Caducidad Prolonga','Tepic','2008-02-17 13:05:21','2008-02-17 13:05:21'),(66,'Villahermosa 2 días (Caducidad P','Villahermosa','2008-02-17 13:05:21','2008-02-17 13:05:21'),(67,'Ciudad Victoria 2 días (Caducida','Ciudad Victoria','2008-02-17 13:05:21','2008-02-17 13:05:21'),(68,'Tampico 2 días (Caducidad Prolon','Tampico','2008-02-17 13:05:21','2008-02-17 13:05:21'),(69,'Campeche 2 días (Caducidad Prolo','Campeche','2008-02-17 13:05:21','2008-02-17 13:05:21'),(70,'Chihuahua 2 días (Caducidad Prol','Chihuahua','2008-02-17 13:05:21','2008-02-17 13:05:21'),(71,'Culiacán 2 días (Caducidad Prolo','Culiacán','2008-02-17 13:05:21','2008-02-17 13:05:21'),(72,'Mazatlán 2 días (Caducidad Prolo','Mazatlán','2008-02-17 13:05:21','2008-02-17 13:05:21'),(73,'Matamoros 2 días (Caducidad Prol','Matamoros','2008-02-17 13:05:21','2008-02-17 13:05:21'),(74,'Nuevo Laredo 2 días (Caducidad P','Nuevo Laredo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(75,'Reynosa 2 días (Caducidad Prolon','Reynosa','2008-02-17 13:05:21','2008-02-17 13:05:21'),(76,'Mérida 2 días (Caducidad Prolong','Mérida','2008-02-17 13:05:21','2008-02-17 13:05:21'),(77,'Ciudad Juárez 2 días (Caducidad ','Ciudad Juárez','2008-02-17 13:05:21','2008-02-17 13:05:21'),(78,'Cancún 2 días (Caducidad Prolong','Cancún','2008-02-17 13:05:21','2008-02-17 13:05:21'),(79,'Hermosillo 2 días (Caducidad Pro','Hermosillo','2008-02-17 13:05:21','2008-02-17 13:05:21'),(80,'Nogales 2 días (Caducidad Prolon','Nogales','2008-02-17 13:05:21','2008-02-17 13:05:21'),(81,'Mexicali 2 días (Caducidad Prolo','Mexicali','2008-02-17 13:05:21','2008-02-17 13:05:21'),(82,'Tijuana 2 días (Caducidad Prolon','Tijuana','2008-02-17 13:05:21','2008-02-17 13:05:21'); /*!40000 ALTER TABLE `geo_zone` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `image` -- DROP TABLE IF EXISTS `image`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `image` ( `image_id` int(11) NOT NULL auto_increment, `filename` varchar(128) collate utf8_unicode_ci NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`image_id`) ) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `image` -- LOCK TABLES `image` WRITE; /*!40000 ALTER TABLE `image` DISABLE KEYS */; INSERT INTO `image` VALUES (51,'Coco-con-chocolate.jpg','2008-01-24 13:01:04'),(82,'choconuez.jpg','2008-02-13 17:22:21'),(53,'Barraenergetica_peq.jpg','2008-01-24 13:01:35'),(54,'Flor-de-chabacano2.jpg','2008-01-24 13:02:20'),(55,'Flor-de-chabacano.jpg','2008-01-24 13:02:49'),(56,'Flor-de-fresa.jpg','2008-01-24 13:03:10'),(57,'Galletadearandano_peq.jpg','2008-01-24 13:03:51'),(58,'Galletadelinaza_peq.jpg','2008-01-24 13:04:14'),(59,'Nuez.jpg','2008-01-24 13:04:47'),(60,'panquechocolate_peq.jpg','2008-01-24 13:05:14'),(61,'Saladita.jpg','2008-01-24 13:05:40'),(62,'pastel-chococh.jpg','2008-01-24 13:16:40'),(63,'pastel-nina2ch.jpg','2008-01-24 13:17:14'),(64,'pastel-ninach.jpg','2008-01-24 13:17:53'),(65,'ima_pan.gif','2008-01-24 13:55:15'),(66,'hojuelas_quinoa.gif','2008-01-27 19:46:26'),(67,'cempasuchitl.jpg','2008-01-27 19:46:56'),(68,'Chocolate.png','2008-01-27 19:47:44'),(69,'coco.jpg','2008-01-27 19:48:07'),(70,'elotes1.png','2008-01-27 19:52:20'),(71,'fideo2.jpg','2008-01-27 19:53:47'),(72,'fideo.jpg','2008-01-27 19:54:40'),(73,'manzana-1.jpg','2008-01-27 19:57:47'),(74,'quinoa.png','2008-01-27 20:03:29'),(75,'semillas-de-linaza.jpg','2008-01-27 20:04:30'),(76,'spaghetti.gif','2008-01-27 20:05:05'),(77,'tallarin9.jpg','2008-01-27 20:06:01'),(78,'tornillo.jpg','2008-01-27 20:06:23'),(79,'vainilla2.jpg','2008-01-27 20:06:39'),(80,'zanahoria.jpg','2008-01-27 20:06:58'),(81,'nodisponible.jpg','2008-01-27 20:13:01'),(83,'Fideo.jpg','2008-02-29 15:50:18'),(84,'Spaguetti.jpg','2008-02-29 15:50:33'),(86,'cocochocolate2.jpg','2008-02-29 15:57:54'),(87,'Tornillo.jpg','2008-02-29 15:58:54'),(88,'Tallarines.jpg','2008-02-29 15:59:07'),(89,'Waffles.jpg','2008-02-29 15:59:18'),(90,'Galleta de linaza.jpg','2008-02-29 15:59:30'),(91,'nodisponible.gif','2008-03-06 18:20:44'),(92,'available.gif','2008-03-06 18:26:13'),(93,'image005.jpg','2008-04-21 11:21:33'),(94,'image003.jpg','2008-04-21 11:21:57'),(95,'image007.jpg','2008-04-21 11:22:17'),(96,'coditos.jpg','2008-04-25 16:55:36'),(97,'conchitas.jpg','2008-04-25 16:55:54'),(98,'tubitos.jpg','2008-04-25 16:56:14'),(99,'espirales.jpg','2008-04-25 16:56:29'); /*!40000 ALTER TABLE `image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `image_description` -- DROP TABLE IF EXISTS `image_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `image_description` ( `image_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `title` varchar(64) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`image_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `image_description` -- LOCK TABLES `image_description` WRITE; /*!40000 ALTER TABLE `image_description` DISABLE KEYS */; INSERT INTO `image_description` VALUES (51,1,'choco_coco'),(82,1,'choco_nuez'),(53,1,'barra'),(54,1,'flor_chabacano2'),(55,1,'flor_chabacano'),(56,1,'flor_fresa'),(57,1,'arandano'),(58,1,'linaza'),(59,1,'nuez'),(60,1,'panque_chocolate'),(61,1,'saladita'),(62,1,'pastel_choco'),(63,1,'pastel_nina2'),(64,1,'pastel_nina'),(65,1,'Pan'),(66,1,'Hojuelas de Quinoa'),(67,1,'cempa'),(68,1,'chocolate'),(69,1,'coco'),(70,1,'elotes'),(71,1,'fideos2'),(72,1,'fideo'),(73,1,'manzana'),(74,1,'quinoa-flor'),(75,1,'Linaza-semillas'),(76,1,'spaghetti'),(77,1,'tallarin'),(78,1,'Tornillo'),(79,1,'Vainilla'),(80,1,'Zanahoria'),(81,1,'No Disponible'),(83,1,'fideo_a'),(84,1,'spaghetti2'),(86,1,'cocochocolate2'),(87,1,'tornillo'),(88,1,'tallarinx'),(89,1,'guafle'),(90,1,'linaza'),(91,1,'No disponible 2'),(92,1,'available'),(93,1,'Paletas'),(94,1,'mentas'),(95,1,'caramelos'),(96,1,'coditos_arroz'),(97,1,'conchitas_arroz'),(98,1,'tubitos_arroz'),(99,1,'espirales_arroz'); /*!40000 ALTER TABLE `image_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `information` -- DROP TABLE IF EXISTS `information`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `information` ( `information_id` int(11) NOT NULL auto_increment, `sort_order` int(3) NOT NULL default '0', PRIMARY KEY (`information_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `information` -- LOCK TABLES `information` WRITE; /*!40000 ALTER TABLE `information` DISABLE KEYS */; INSERT INTO `information` VALUES (9,0),(8,0); /*!40000 ALTER TABLE `information` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `information_description` -- DROP TABLE IF EXISTS `information_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `information_description` ( `information_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '0', `title` varchar(64) collate utf8_unicode_ci NOT NULL default '', `description` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`information_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `information_description` -- LOCK TABLES `information_description` WRITE; /*!40000 ALTER TABLE `information_description` DISABLE KEYS */; /*!40000 ALTER TABLE `information_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `language` -- DROP TABLE IF EXISTS `language`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `language` ( `language_id` int(11) NOT NULL auto_increment, `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', `code` varchar(2) collate utf8_unicode_ci NOT NULL default '', `image` varchar(64) collate utf8_unicode_ci default NULL, `directory` varchar(32) collate utf8_unicode_ci NOT NULL default '', `filename` varchar(64) collate utf8_unicode_ci NOT NULL default '', `sort_order` int(3) default NULL, PRIMARY KEY (`language_id`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `language` -- LOCK TABLES `language` WRITE; /*!40000 ALTER TABLE `language` DISABLE KEYS */; INSERT INTO `language` VALUES (1,'English','en','en.png','english','english.php',1); /*!40000 ALTER TABLE `language` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `manufacturer` -- DROP TABLE IF EXISTS `manufacturer`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `manufacturer` ( `manufacturer_id` int(11) NOT NULL auto_increment, `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', `image_id` int(11) NOT NULL default '0', `sort_order` int(3) NOT NULL default '0', PRIMARY KEY (`manufacturer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `manufacturer` -- LOCK TABLES `manufacturer` WRITE; /*!40000 ALTER TABLE `manufacturer` DISABLE KEYS */; /*!40000 ALTER TABLE `manufacturer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletter` -- DROP TABLE IF EXISTS `newsletter`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `newsletter` ( `newsletter_id` int(11) NOT NULL auto_increment, `subject` varchar(255) collate utf8_unicode_ci NOT NULL default '', `content` text collate utf8_unicode_ci NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`newsletter_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `newsletter` -- LOCK TABLES `newsletter` WRITE; /*!40000 ALTER TABLE `newsletter` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `option` -- DROP TABLE IF EXISTS `option`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `option` ( `option_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '0', `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`option_id`,`language_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `option` -- LOCK TABLES `option` WRITE; /*!40000 ALTER TABLE `option` DISABLE KEYS */; INSERT INTO `option` VALUES (8,1,'Decorado'),(9,1,'Sabor'),(10,1,'Tamaño'); /*!40000 ALTER TABLE `option` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `option_value` -- DROP TABLE IF EXISTS `option_value`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `option_value` ( `option_value_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '0', `option_id` int(11) NOT NULL default '0', `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`option_value_id`,`language_id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `option_value` -- LOCK TABLES `option_value` WRITE; /*!40000 ALTER TABLE `option_value` DISABLE KEYS */; INSERT INTO `option_value` VALUES (21,1,8,'Crema Chantilly'),(17,1,9,'Vainilla'),(19,1,9,'Chocolate'),(22,1,8,'Crema Chantilly de Chocolate'),(20,1,8,'Chocolate Fundido (Sin gluten)'),(23,1,10,'Pequeño (400 g. aprox.)'),(24,1,10,'Grande (800 g. aprox.)'); /*!40000 ALTER TABLE `option_value` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order` -- DROP TABLE IF EXISTS `order`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order` ( `order_id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL default '0', `reference` varchar(32) collate utf8_unicode_ci NOT NULL, `firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `lastname` varchar(32) collate utf8_unicode_ci default NULL, `telephone` varchar(32) collate utf8_unicode_ci NOT NULL default '', `fax` varchar(32) collate utf8_unicode_ci NOT NULL default '', `email` varchar(96) collate utf8_unicode_ci NOT NULL default '', `shipping_firstname` varchar(64) collate utf8_unicode_ci NOT NULL default '', `shipping_lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `shipping_company` varchar(32) collate utf8_unicode_ci default NULL, `shipping_address_1` varchar(64) collate utf8_unicode_ci NOT NULL default '', `shipping_address_2` varchar(32) collate utf8_unicode_ci default NULL, `shipping_city` varchar(32) collate utf8_unicode_ci NOT NULL default '', `shipping_postcode` varchar(10) collate utf8_unicode_ci NOT NULL default '', `shipping_zone` varchar(32) collate utf8_unicode_ci default NULL, `shipping_country` varchar(64) collate utf8_unicode_ci NOT NULL default '', `shipping_address_format` text collate utf8_unicode_ci NOT NULL, `shipping_method` varchar(128) collate utf8_unicode_ci NOT NULL default '', `payment_firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `payment_lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `payment_company` varchar(32) collate utf8_unicode_ci default NULL, `payment_address_1` varchar(64) collate utf8_unicode_ci NOT NULL default '', `payment_address_2` varchar(32) collate utf8_unicode_ci default NULL, `payment_city` varchar(32) collate utf8_unicode_ci NOT NULL default '', `payment_postcode` varchar(10) collate utf8_unicode_ci NOT NULL default '', `payment_zone` varchar(32) collate utf8_unicode_ci default NULL, `payment_country` varchar(64) collate utf8_unicode_ci NOT NULL default '', `payment_address_format` text collate utf8_unicode_ci NOT NULL, `payment_method` varchar(128) collate utf8_unicode_ci NOT NULL default '', `total` decimal(15,4) NOT NULL default '0.0000', `date_modified` datetime default NULL, `date_added` datetime default NULL, `order_status_id` int(5) NOT NULL default '0', `currency` varchar(3) collate utf8_unicode_ci default NULL, `value` decimal(14,6) default NULL, `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order` -- LOCK TABLES `order` WRITE; /*!40000 ALTER TABLE `order` DISABLE KEYS */; INSERT INTO `order` VALUES (23,12,'47E95-90F2C-F8136','juana elizabeth','rodríguez páez','016959531606','','jerpaez@hotmail.com','juana elizabeth','rodríguez páez','','melchor ocampo 73 sur','belizario domínguez 406','escuinapa','82400','Sinaloa','Mexico','','Culiacán 2 días (Caducidad Prolo','juana elizabeth','rodríguez páez','','melchor ocampo 73 sur','belizario domínguez 406','escuinapa','82400','Sinaloa','Mexico','','Transferencia Bancaria','234.5200','2008-03-25 15:57:32','2008-03-25 15:57:32',1,'MXN','1.000000','189.174.181.243'),(30,29,'483F7-B8778-4C246','ISAAC','ZALDIVAR SANDOVAL','2229543633 celular','','isaac.zaldivar@maxcom.net.mx','ISAAC','ZALDIVAR SANDOVAL','','CALLE PUEBLA NO. 5712-ALTOS','','PUEBLA','72440','Puebla','Mexico','','Puebla 1 día (Caducidad Corta)','ISAAC','ZALDIVAR SANDOVAL','','CALLE PUEBLA NO. 5712-ALTOS','','PUEBLA','72440','Puebla','Mexico','','Transferencia Bancaria','419.3200','2008-05-29 23:59:19','2008-05-29 23:59:19',1,'MXN','1.000000','201.161.33.25'),(31,30,'48461-829A9-82626','RAUL','QUINTANA GUTIERREZ','6865597384','6865588030','rqgtz@msn.com','RAUL','QUINTANA GUTIERREZ','AYALA OLGUIN, Y CIA, S.C.','NUMANCIA NO. 356 VILLAS DEL REY','PJE. PATZCUARO 559-B','MEXICALI','21000','Baja California Norte','Mexico','','Mexicali 2 días (Caducidad Prolo','RAUL','QUINTANA GUTIERREZ','AYALA OLGUIN, Y CIA, S.C.','NUMANCIA NO. 356 VILLAS DEL REY','PJE. PATZCUARO 559-B','MEXICALI','21000','Baja California Norte','Mexico','','Transferencia Bancaria','285.1500','2008-06-04 00:21:58','2008-06-04 00:21:58',1,'MXN','1.000000','201.150.128.172'),(25,13,'47EDB-8FA5A-C0E22','Stefania','Bugnon-Berretti','55 54466629','','steberretti@yahoo.com','Stefania','Bugnon-Berretti','','Pico de Verapaz 22 Torre 1 PB','Jardines en la Montana, Tlalpan','Mexico','14210','Mexico','Mexico','','Toluca 2 días (Caducidad Prolong','Stefania','Bugnon-Berretti','','Pico de Verapaz 22 Torre 1 PB','Jardines en la Montana, Tlalpan','Mexico','14210','Mexico','Mexico','','Transferencia Bancaria','198.8900','2008-04-09 11:12:35','2008-03-28 23:35:47',3,'MXN','1.000000','189.146.105.119'),(28,23,'481EA-4D1ED-80450','delia berenice','perez ruiz','8423197','','delia.popss@hotmail.com','delia berenice','perez ruiz','','joaquin cardoso Num.898 Los naranjos','calz.Hector teran teran Num.83 c','mexicali','21386','Baja California Norte','Mexico','','Mexicali 2 días (Caducidad Prolo','delia berenice','perez ruiz','','joaquin cardoso Num.898 Los naranjos','calz.Hector teran teran Num.83 c','mexicali','21386','Baja California Norte','Mexico','','Transferencia Bancaria','293.1500','2008-05-05 02:34:06','2008-05-05 02:34:06',1,'USD','0.086957','201.166.61.94'); /*!40000 ALTER TABLE `order` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_data` -- DROP TABLE IF EXISTS `order_data`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_data` ( `order_id` int(11) NOT NULL auto_increment, `reference` varchar(32) collate utf8_unicode_ci NOT NULL, `data` text collate utf8_unicode_ci NOT NULL, `expire` int(10) NOT NULL default '0', PRIMARY KEY (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_data` -- LOCK TABLES `order_data` WRITE; /*!40000 ALTER TABLE `order_data` DISABLE KEYS */; /*!40000 ALTER TABLE `order_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_download` -- DROP TABLE IF EXISTS `order_download`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_download` ( `order_download_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_product_id` int(11) NOT NULL default '0', `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', `filename` varchar(128) collate utf8_unicode_ci NOT NULL default '', `mask` varchar(128) collate utf8_unicode_ci NOT NULL default '', `remaining` int(3) NOT NULL default '0', PRIMARY KEY (`order_download_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_download` -- LOCK TABLES `order_download` WRITE; /*!40000 ALTER TABLE `order_download` DISABLE KEYS */; /*!40000 ALTER TABLE `order_download` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_history` -- DROP TABLE IF EXISTS `order_history`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_history` ( `order_history_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_status_id` int(5) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `notify` int(1) default '0', `comment` text collate utf8_unicode_ci, PRIMARY KEY (`order_history_id`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_history` -- LOCK TABLES `order_history` WRITE; /*!40000 ALTER TABLE `order_history` DISABLE KEYS */; INSERT INTO `order_history` VALUES (31,30,1,'2008-05-29 23:59:19',1,''),(29,28,1,'2008-05-05 02:34:06',1,''),(23,23,1,'2008-03-25 15:57:32',1,''),(27,25,3,'2008-04-09 11:12:35',1,''),(25,25,1,'2008-03-28 23:35:48',1,''),(32,31,1,'2008-06-04 00:21:58',1,'DESEO SABER SI NO MANEJAN ARINA PARA HOT CAKES...\r\n( FAVOR DE ENVIAR INFORMACION A MI E-MAIL )\r\nGRACIAS....'); /*!40000 ALTER TABLE `order_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_option` -- DROP TABLE IF EXISTS `order_option`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_option` ( `order_option_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `order_product_id` int(11) NOT NULL default '0', `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', `value` varchar(32) collate utf8_unicode_ci NOT NULL default '', `price` decimal(15,4) NOT NULL default '0.0000', `prefix` char(1) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`order_option_id`) ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_option` -- LOCK TABLES `order_option` WRITE; /*!40000 ALTER TABLE `order_option` DISABLE KEYS */; INSERT INTO `order_option` VALUES (12,30,57,'Tamaño','Pequeño (400 g. aprox.)','38.5000','+'),(11,28,51,'Tamaño','Grande (800 g. aprox.)','77.5000','+'); /*!40000 ALTER TABLE `order_option` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_product` -- DROP TABLE IF EXISTS `order_product`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_product` ( `order_product_id` int(11) NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', `model` varchar(12) collate utf8_unicode_ci NOT NULL default '', `price` decimal(15,4) NOT NULL default '0.0000', `discount` decimal(15,4) NOT NULL, `total` decimal(15,4) NOT NULL default '0.0000', `tax` decimal(15,4) NOT NULL default '0.0000', `quantity` int(4) NOT NULL default '0', PRIMARY KEY (`order_product_id`) ) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_product` -- LOCK TABLES `order_product` WRITE; /*!40000 ALTER TABLE `order_product` DISABLE KEYS */; INSERT INTO `order_product` VALUES (63,31,'Brownies','brownie01','40.0000','0.0000','40.0000','0.0000',1),(60,30,'Spaghetti','pasta01','96.8000','0.0000','96.8000','0.0000',1),(61,31,'Galletas Saladas','galleta05','42.0000','0.0000','42.0000','0.0000',1),(62,31,'Caramelos de Sabores','caramelos','32.5000','0.0000','32.5000','0.0000',1),(58,30,'Waffles','waffle01','35.0000','0.0000','35.0000','0.0000',1),(59,30,'Coditos de arroz libres de gluten.','coditos_arro','32.5000','0.0000','32.5000','0.0000',1),(52,28,'Waffles','waffle01','35.0000','0.0000','35.0000','0.0000',1),(51,28,'Panqué de Chocolate','panque01','77.5000','0.0000','77.5000','0.0000',1),(57,30,'Panqué de Chocolate','panque01','38.5000','0.0000','38.5000','0.0000',1),(34,23,'Galletas de Linaza','galleta07','50.0000','0.0000','50.0000','0.0000',1),(35,23,'Spaghetti','pasta01','88.0000','0.0000','88.0000','0.0000',1),(56,30,'Pound Cake','panque04','43.0000','0.0000','43.0000','0.0000',1),(55,30,'Bollos Blancos','pan01','35.0000','0.0000','35.0000','0.0000',1),(38,25,'Bollos Blancos','pan01','35.0000','0.0000','70.0000','0.0000',2),(39,25,'Fideos','pasta02','51.5000','0.0000','51.5000','0.0000',1),(50,28,'Paletas de Caramelo','paletas','32.5000','0.0000','32.5000','0.0000',1),(54,30,'Galletas Saladas','galleta05','42.0000','0.0000','42.0000','0.0000',1),(49,28,'Coditos de arroz libres de gluten.','coditos_arro','32.5000','0.0000','32.5000','0.0000',1),(64,31,'Galletas de Coco con Chocolate','galleta01','55.0000','0.0000','55.0000','0.0000',1); /*!40000 ALTER TABLE `order_product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_status` -- DROP TABLE IF EXISTS `order_status`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_status` ( `order_status_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '1', `name` varchar(32) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`order_status_id`,`language_id`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_status` -- LOCK TABLES `order_status` WRITE; /*!40000 ALTER TABLE `order_status` DISABLE KEYS */; INSERT INTO `order_status` VALUES (7,7,'Pending'),(2,7,'Processing'),(2,1,'Processing'),(12,1,'Canceled'),(3,7,'Shipped'),(3,1,'Shipped'),(5,7,'Pending'),(9,7,'Pending'),(1,1,'Pending'),(12,7,'Canceled'),(16,1,'Complete'); /*!40000 ALTER TABLE `order_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_total` -- DROP TABLE IF EXISTS `order_total`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `order_total` ( `order_total_id` int(10) unsigned NOT NULL auto_increment, `order_id` int(11) NOT NULL default '0', `title` varchar(255) collate utf8_unicode_ci NOT NULL default '', `text` varchar(255) collate utf8_unicode_ci NOT NULL default '', `value` decimal(15,4) NOT NULL default '0.0000', `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`order_total_id`), KEY `idx_orders_total_orders_id` (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `order_total` -- LOCK TABLES `order_total` WRITE; /*!40000 ALTER TABLE `order_total` DISABLE KEYS */; INSERT INTO `order_total` VALUES (95,28,'Subtotal:','$15,43USD','177.5000',0),(103,30,'Total:','$419MXN','419.3200',2),(82,23,'Total:','$235MXN','234.5200',2),(101,30,'Subtotal:','$323MXN','322.8000',0),(102,30,'Puebla 1 día (Caducidad Corta):','$97MXN','96.5200',1),(86,25,'Subtotal:','$122MXN','121.5000',0),(87,25,'Toluca 2 días (Caducidad Prolong:','$77MXN','77.3900',1),(81,23,'Culiacán 2 días (Caducidad Prolo:','$97MXN','96.5200',1),(80,23,'Subtotal:','$138MXN','138.0000',0),(88,25,'Total:','$199MXN','198.8900',2),(96,28,'Mexicali 2 días (Caducidad Prolo:','$10,06USD','115.6500',1),(97,28,'Total:','$25,49USD','293.1500',2),(104,31,'Subtotal:','$170MXN','169.5000',0),(105,31,'Mexicali 2 días (Caducidad Prolo:','$116MXN','115.6500',1),(106,31,'Total:','$285MXN','285.1500',2); /*!40000 ALTER TABLE `order_total` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product` -- DROP TABLE IF EXISTS `product`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product` ( `product_id` int(11) NOT NULL auto_increment, `quantity` int(4) NOT NULL default '0', `model` varchar(12) collate utf8_unicode_ci default NULL, `manufacturer_id` int(11) NOT NULL default '0', `image_id` int(11) NOT NULL default '0', `shipping` int(1) NOT NULL default '1', `price` decimal(15,4) NOT NULL default '0.0000', `sort_order` int(3) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime default NULL, `date_available` datetime default NULL, `weight` decimal(5,2) NOT NULL default '0.00', `weight_class_id` int(11) NOT NULL default '0', `status` int(1) NOT NULL default '0', `tax_class_id` int(11) NOT NULL default '0', `viewed` int(5) NOT NULL default '0', PRIMARY KEY (`product_id`), KEY `date_added` (`date_added`) ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product` -- LOCK TABLES `product` WRITE; /*!40000 ALTER TABLE `product` DISABLE KEYS */; INSERT INTO `product` VALUES (7,0,'galleta02',0,59,1,'55.0000',0,'2008-01-24 13:26:21','2008-03-06 18:36:38','2008-01-24 00:00:00','250.00',1,1,0,30),(6,0,'galleta01',0,86,1,'55.0000',0,'2008-01-24 12:30:11','2008-03-31 04:31:26','2008-03-02 00:00:00','250.00',1,1,0,69),(8,0,'galleta03',0,82,1,'55.0000',0,'2008-01-24 13:28:41','2008-03-31 03:58:14','2008-02-24 00:00:00','250.00',1,1,0,30),(9,0,'galleta04',0,56,1,'55.0000',0,'2008-01-24 13:30:35','2008-02-27 16:04:42','2008-01-24 00:00:00','250.00',2,1,0,38),(10,0,'galleta05',0,61,1,'42.0000',0,'2008-01-24 13:32:21','2008-02-27 16:06:05','2008-01-24 00:00:00','250.00',2,1,0,36),(11,0,'galleta06',0,57,1,'55.0000',0,'2008-01-24 13:34:06','2008-03-31 04:00:13','2008-03-24 00:00:00','250.00',1,1,0,65),(12,0,'galleta07',0,90,1,'50.0000',0,'2008-01-24 13:37:44','2008-02-29 16:00:42','2008-01-24 00:00:00','250.00',2,1,0,23),(13,0,'galleta08',0,79,1,'25.0000',0,'2008-01-24 13:42:54','2008-02-27 16:06:30','2008-01-24 00:00:00','250.00',2,1,0,17),(14,0,'pan01',0,92,1,'35.0000',0,'2008-01-24 13:54:52','2008-03-06 18:26:35','2008-01-24 00:00:00','400.00',1,1,0,24),(15,0,'panque01',0,60,1,'38.5000',0,'2008-01-24 12:30:11','2008-03-04 12:58:18','2008-01-27 00:00:00','400.00',1,1,0,70),(16,0,'panque02',0,92,1,'31.0000',0,'2008-01-27 12:45:07','2008-03-06 18:28:41','2008-01-27 00:00:00','400.00',1,1,0,27),(17,0,'panque03',0,92,1,'40.0000',0,'2008-01-27 12:49:14','2008-03-06 21:45:43','2008-01-27 00:00:00','400.00',1,1,0,16),(18,0,'panque04',0,60,1,'43.0000',0,'2008-01-27 12:52:31','2008-03-04 13:00:08','2008-01-27 00:00:00','400.00',1,1,0,20),(19,0,'waffle01',0,89,1,'35.0000',0,'2008-01-24 12:30:11','2008-03-06 18:30:17','2008-01-27 00:00:00','250.00',1,1,0,64),(20,0,'brownie01',0,68,1,'40.0000',0,'2008-01-27 12:56:57','2008-03-06 18:26:49','2008-01-27 00:00:00','250.00',1,1,0,13),(21,0,'temporada01',0,92,1,'45.0000',0,'2008-01-27 13:00:27','2008-03-06 18:28:13','2008-01-27 00:00:00','350.00',1,1,0,29),(22,0,'temporada02',0,92,1,'120.0000',0,'2008-01-27 13:02:23','2008-03-06 18:29:20','2008-01-27 00:00:00','1.00',1,1,0,34),(23,0,'temporada03',0,92,1,'120.0000',0,'2008-01-27 13:04:05','2008-03-06 18:30:05','2008-01-27 00:00:00','1.00',1,1,0,29),(24,0,'pastel01',0,63,1,'120.0000',0,'2008-01-24 12:30:11','2008-03-31 04:10:21','2008-01-02 00:00:00','999.99',1,1,0,62),(25,0,'pasta01',0,84,1,'96.8000',0,'2008-01-27 13:29:02','2008-03-25 18:51:52','2008-01-27 00:00:00','500.00',1,1,0,45),(26,0,'pasta02',0,83,1,'51.5000',2,'2008-01-24 12:30:11','2008-04-15 19:41:56','2008-01-24 00:00:00','250.00',1,1,0,46),(27,0,'pasta03',0,88,1,'51.5000',0,'2008-01-27 13:31:10','2008-03-25 18:52:18','2008-01-27 00:00:00','250.00',1,1,0,20),(28,0,'pasta04',0,78,1,'51.5000',0,'2008-01-27 13:32:14','2008-03-31 20:43:54','2008-01-27 00:00:00','250.00',1,1,0,20),(29,0,'cereal01',0,92,1,'26.0000',0,'2008-01-27 13:33:31','2008-03-10 13:07:46','2008-01-27 00:00:00','120.00',1,0,0,14),(30,0,'cereal02',0,92,1,'39.0000',0,'2008-01-27 13:34:35','2008-03-10 13:01:50','2008-01-27 00:00:00','300.00',1,0,0,5),(31,0,'barra01',0,53,1,'7.0000',0,'2008-01-27 19:45:18','2008-03-04 12:52:44','2008-01-27 00:00:00','40.00',1,1,0,64),(32,0,'panque09',0,92,1,'35.0000',0,'2008-01-27 20:58:12','2008-03-06 18:28:30','2008-01-27 00:00:00','400.00',1,1,0,24),(33,0,'rosca01',0,92,1,'45.0000',0,'2008-01-27 21:10:52','2008-03-06 18:29:52','2008-01-27 00:00:00','350.00',1,1,0,15),(43,0,'paletas',0,93,1,'32.5000',0,'2008-04-21 11:18:12','2008-04-21 11:25:53','2008-04-21 00:00:00','93.00',1,1,0,10),(44,0,'mentas',0,94,1,'32.5000',0,'2008-04-21 11:23:29','2008-04-21 11:25:11','2008-04-21 00:00:00','93.00',1,1,0,6),(45,0,'caramelos',0,95,1,'32.5000',0,'2008-01-23 12:30:11',NULL,'2008-04-21 00:00:00','93.00',1,1,0,22),(46,0,'coditos_arro',0,96,1,'32.5000',0,'2008-04-25 16:58:05','2008-04-25 18:28:23','2008-04-25 00:00:00','454.00',1,1,0,18),(47,0,'conchitas_ar',0,99,1,'32.5000',0,'2008-04-25 16:59:26','2008-04-25 18:31:12','2008-04-25 00:00:00','454.00',1,1,0,6),(48,0,'tubitos_arro',0,97,1,'32.5000',0,'2008-04-25 17:00:37','2008-04-25 19:07:27','2008-04-25 00:00:00','454.00',1,1,0,7),(49,0,'espirales_ar',0,98,1,'32.5000',0,'2008-04-25 17:02:26','2008-04-25 18:30:20','2008-04-25 00:00:00','340.00',1,1,0,6); /*!40000 ALTER TABLE `product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_description` -- DROP TABLE IF EXISTS `product_description`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_description` ( `product_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '1', `name` varchar(64) collate utf8_unicode_ci NOT NULL default '', `description` text collate utf8_unicode_ci, PRIMARY KEY (`product_id`,`language_id`), KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_description` -- LOCK TABLES `product_description` WRITE; /*!40000 ALTER TABLE `product_description` DISABLE KEYS */; INSERT INTO `product_description` VALUES (13,1,'Galletas de Vainilla','

Galletas de Vainilla (250 g)

\r\n

Caducidad Prolongada

\r\n
Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.
'),(18,1,'Pound Cake','

Delicioso Pound Cake

\r\n

 

\r\n

El Pound Cake es simplemente delicioso. Hecho a base de mantequilla, azúcar y huevo tiene una consistencia firme y una cubierta crujiente.

\r\n

Este producto se conserva durante diez días dentro del refrigerador, y quince si se congela al momento de recibirlo.

\r\n

 

\r\n

 

\r\n

 

\r\n

Caducidad Corta

'),(43,1,'Paletas de Caramelo','

Bolsa con 15 paletas orgánicas de caramelo libres de gluten de varios sabores de la marca Yummy Earth (93 g)

'),(16,1,'Panqué de Vainilla','

Delicioso panqué de vainilla

\r\n

\r\n

Un clásico, hecho con mantequilla y huevo de verdad. Un favorito en muchas mesas celíacas.

\r\n

Este producto se conserva durante diez días dentro del refrigerador, y quince si se congela al momento de recibirlo.

\r\n

\r\n

\r\n

\r\n

Caducidad Corta

'),(17,1,'Panqué de Zanahoria','

Delicioso Panqué

\r\n

Una opción sana y con mucha fibra. Las zanahorias se escogen especialmente frescas, dando por resultado un sabor sin igual.

\r\n

Debido a sus ingredientes, y a que (al igual que los demás) no contienen conservadores, estos productos tienen una caducidad muy limitada. Es necesario mantenerlos en refrigeración y consumirlos durante los primeros 4 días después de su compra. Estos productos sólo se surten dentro del Distrito Federal.

\r\n

 

\r\n

 

\r\n

 

\r\n

Entrega disponible sólo en el D.F.

'),(32,1,'Panqué de Calabaza','

Delicioso panqué de calabaza

\r\n

Calabacitas tiernas, otra opción muy natural y deliciosa. Los niños no se enterarán de que están comiendo verduras.

\r\n

Debido a sus ingredientes, y a que (al igual que los demás) no contienen conservadores, estos productos tienen una caducidad muy limitada. Es necesario mantenerlos en refrigeración y consumirlos durante los primeros 4 días después de su compra. Estos productos sólo se surten dentro del Distrito Federal.

\r\n

Entrega disponible sólo en el D.F.

'),(33,1,'Rosca de Reyes','

Rosca de Reyes

\r\n

¡Con muñequito! Disponible las primeras dos semanas de enero.

\r\n

Caducidad Corta

'),(24,1,'Pastel para Celebración','

Deliciosos pasteles para celebraciones finamente decorados.

\r\n

*Los materiales con los que se decoran nuestros pasteles también son libres de gluten.

\r\n

Entrega disponible sólo en el D.F.

'),(14,1,'Bollos Blancos','

Bollos blancos (400 g):

\r\n

Pan blanco ideal para tortas, versátil y de sabor suave. Se lleva bien con sabores dulces o salados. Ideales para tostar y comer con mantequilla y azúcar, mermelada, bacalao, atún o cualquier otro relleno dulce o salado que sea libre de gluten.

\r\n

Práctico paquete con 4 unidades

\r\n

 

\r\n

 

\r\n

 

\r\n

Caducidad Corta

'),(11,1,'Galleta de Arándanos','

Galleta de arándanos (250 g):

\r\n


\r\nEstas galletas son muy sabrosas y sanas, ya que además de su delicioso sabor, los arándanos (vaccinium macrocarpon) son considerados como una fruta sumamente saludable, ya que no contienen colesterol, y tienen un contenido de grasa y sodio sumamente bajo.

\r\n

 

\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
'),(10,1,'Galletas Saladas','
\r\n

Galletas Saladas (250 g):

\r\n


\r\nHechas a base de mantequilla. Solas saben deliciosas, pero se pueden combinar con todo aquello que no contenga gluten: ceviche, quesos libres de gluten, atún, guacamole, etc. Si se parten en pedazos pequeños, son el complemento ideal para cremas y sopas (recuerde, que sean libres de gluten).

\r\n\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
\r\n
'),(30,1,'Hojuelas de Quinoa','

Hojuelas de Quinoa (300 g)

\r\n

Estas hojuelas de quinoa son ideales para preparar un delicioso atole.

\r\n

Caducidad Prolongada

'),(44,1,'Caramelos de Menta','

Bolsa de caramelos orgánicos libres de gluten sabor menta marca Yummy Earth (93 g)

'),(45,1,'Caramelos de Sabores','

Bolsa de caramelos orgánicos libres de gluten de varios sabores marca Yummy Earth (93 g)

'),(15,1,'Panqué de Chocolate','

Delicioso Panqué

\r\n

Esponjoso y suave, la cocoa natural hace de este pastel una delicia para celíacos.

\r\n

Este producto se conserva durante diez días dentro del refrigerador, y quince si se congela al momento de recibirlo.

\r\n

Caducidad Corta

'),(46,1,'Coditos de arroz libres de gluten.','

Hechos de arroz entero.

\r\n

¡No se baten!
\r\nContenido neto 454 g
\r\nPrecio: $ 32.5 MXP

'),(19,1,'Waffles','

Deliciosos Waffles (250 g)

\r\n

Los waffles son una opción ideal para el desayuno, con mantequilla y mermelada son deliciosos.

\r\n

Estos productos se conservan durante diez días dentro del refrigerador, y quince si se congelan al momento de recibirlos. Es necesario poner especial cuidado al calentar los waffles, de hacerlo en una plancha o comal es necesario verificar que no se contamine con trazas de pan o de cualquier otro producto que contenga gluten.

\r\n

 

\r\n

Caducidad Corta

'),(20,1,'Brownies','

Brownies (250 g)

\r\n

Un sabor denso, con chispas de chocolate y nuez. Ideal con leche o una taza de café.

\r\n

Este producto se conserva durante diez días dentro del refrigerador, y quince si se congela al momento de recibirlo.

\r\n

Caducidad Corta

'),(9,1,'Galletas de flores de mermelada','

Flores de mermelada (250 g):

\r\n

De fresa o de chabacano, estas flores son las favoritas de muchos. Al igual que el resto de los ingredientes, la mermelada no contiene ni pectinas ni colorantes que contengan gluten.

\r\n

 

\r\n

 

\r\n

 

\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
'),(7,1,'Galleta de Nuez','

Galletas de Nuez (250 g):

\r\n

Nada sustituye el sabor de lo natural, estas galletas saben a nuez porque contienen nuez, pruébelas y se convencerá.

\r\n

 

\r\n

 

\r\n

 

\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
'),(8,1,'Galleta de Nuez con Chocolate','

Galletas de Nuez con chocolate (250 g):

\r\n

Otra combinación exitosa. Estas galletas de nuez con cocoa son una alternativa nutritiva y muy sabrosa para los niños.

\r\n

 Caducidad Prolongada

\r\n

 

\r\n

 

\r\n
Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.
'),(6,1,'Galletas de Coco con Chocolate','
\r\n

Galletas de Coco con chocolate (250 g):
\r\nUna deliciosa mezcla de coco rallado y deshidratado con chispas de chocolate. Ideal para llenar de energía una mañana.

\r\n\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
\r\n
'),(12,1,'Galletas de Linaza','

Galletas de linaza (250 g):
\r\n¡Libres de lácteos! Esta es una galleta especial para los celíacos que no pueden consumir lácteos. La linaza (Linum usitatissimum) es una fuente importante de ácidos grasos Omega 3, que benefician las funciones cardiovasculares.

\r\n
\r\n

Se recomienda guardar las galletas en una lata metálica limpia para conservar sus cualidades. Si llegaran a ablandarse, se pueden hornear nuevamente en una charola limpia por 2 minutos a 100 °C, y recuperarán su consistencia crujiente. Tienen una caducidad de 3 semanas a partir del día de su adquisición.

\r\n

Caducidad Prolongada

\r\n
'),(31,1,'Barra de Frutos Secos','

Deliciosa barra de frutos secos (40 g)

\r\n

Deliciosa barra de frutos secos, con coco, nueces, pasas, arándanos y almendras. Empaquetada en presentación individual, ideal para llevar a cualquier lado.

\r\n

Caducidad Prolongada

'),(29,1,'Cereal Inflado de Quinoa','

Cereal Inflado de Quinoa (120 g)

\r\n

Este cereal tiene un sabor muy parecido al de la nuez. Se puede consumir con leche y endulzar con azúcar o frutas como cualquier otro cereal para el desayuno.

\r\n


\r\nCaducidad Prolongada.

\r\n

 

'),(26,1,'Fideos','

Fideos (250 g)

\r\n

La sopa de fideos es un alimento básico en la dieta mexicana, estos son ideales y se preparan muy fácilmente.

\r\n

Caducidad Prolongada

'),(21,1,'Pan de Muerto','

Delicioso pan de Muerto (350 g)

\r\n

Nuestro delicioso pan de muerto es sabor naranja, con los tradicionales adornos de pan de muerto, bañado de mantequilla y espolvoreado con azúcar. Disponible durante noviembre.

\r\n

Caducidad Corta

'),(22,1,'Pay de Manzana','

Deliciosos pay de manzana

\r\n

El Pound Cake es simplemente delicioso. Hecho a base de mantequilla, azúcar y huevo tiene una consistencia firme y una cubierta crujiente.

\r\n


\r\nEste producto se conserva durante diez días dentro del refrigerador, y quince si se congela al momento de recibirlo.

\r\n

Entrega disponible sólo en el D.F.

\r\n

Se vende por kilo.

'),(25,1,'Spaghetti','

Spaghetti

\r\n

Una pasta versatil e indispensable en cualquier alacena celíaca. Hecha a base de maíz.

\r\n

Caducidad Prolongada

'),(27,1,'Tallarines','

Tallarines

\r\n

Deliciosos tallarines que si quedan \"al dente\". Hechos de harina de maíz, son los mejores acompañantes de cualquier salsa para pasta libre de gluten.

\r\n

Caducidad Prolongada

'),(28,1,'Tornillo','

Tornillo

\r\n

Deliciosos tallarines que si quedan \"al dente\". Hechos de harina de maíz, son los mejores acompañantes de cualquier salsa para pasta libre de gluten.
\r\nCaducidad Prolongada

\r\n

Caducidad Prolongada

'),(23,1,'Torta de Elote','

Deliciosa torta de elote

\r\n

 

\r\n

Hecha con Elote tipo Morelos (que es el más tierno y jugoso), se prepara cuando las condiciones de mercado lo permiten. Es dulce y deliciosa.
\r\nEntrega disponible sólo en el D.F.

\r\n

Entrega disponible sólo en el D.F.

'),(48,1,'Tubitos de arroz libres de gluten','

Hechos de arroz entero.
\r\nContenido neto 454 g
\r\nPrecio: $ 32.5 MXP

'),(47,1,'Conchitas de arroz libres de gluten.','

Hechas de arroz entero.

\r\n

¡No se baten!
\r\nContenido neto 454 g
\r\nPrecio: $ 32.5 MXP

'),(49,1,'Espirales de arroz libres de gluten.','

Hechos de arroz entero.

\r\n

¡No se baten!
\r\nContenido neto 340 g
\r\nPrecio: $ 32.5 MXP

'); /*!40000 ALTER TABLE `product_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_discount` -- DROP TABLE IF EXISTS `product_discount`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_discount` ( `product_discount_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL, `quantity` int(4) NOT NULL, `discount` decimal(15,4) NOT NULL, PRIMARY KEY (`product_discount_id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_discount` -- LOCK TABLES `product_discount` WRITE; /*!40000 ALTER TABLE `product_discount` DISABLE KEYS */; INSERT INTO `product_discount` VALUES (19,1,10,'20.0000'),(18,1,2,'10.0000'),(24,21,0,'0.0000'); /*!40000 ALTER TABLE `product_discount` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_to_category` -- DROP TABLE IF EXISTS `product_to_category`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_to_category` ( `product_id` int(11) NOT NULL default '0', `category_id` int(11) NOT NULL default '0', PRIMARY KEY (`product_id`,`category_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_to_category` -- LOCK TABLES `product_to_category` WRITE; /*!40000 ALTER TABLE `product_to_category` DISABLE KEYS */; INSERT INTO `product_to_category` VALUES (6,25),(7,25),(8,25),(9,25),(10,25),(11,25),(12,22),(12,25),(13,22),(13,25),(14,20),(15,20),(15,24),(16,20),(16,24),(17,20),(17,24),(18,20),(18,24),(19,24),(20,20),(21,20),(21,24),(21,27),(22,19),(22,20),(22,22),(22,27),(23,19),(23,20),(23,27),(24,19),(25,22),(25,23),(25,26),(25,29),(26,22),(26,23),(26,26),(26,29),(27,22),(27,23),(27,26),(27,29),(28,22),(28,23),(28,26),(28,29),(29,22),(29,26),(29,28),(29,29),(30,22),(30,26),(30,28),(30,29),(31,25),(32,20),(32,24),(33,19),(33,20),(33,27),(43,31),(43,33),(44,31),(44,33),(45,31),(45,33),(46,23),(46,31),(47,23),(47,31),(48,23),(48,31),(49,23),(49,31); /*!40000 ALTER TABLE `product_to_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_to_download` -- DROP TABLE IF EXISTS `product_to_download`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_to_download` ( `product_id` int(11) NOT NULL default '0', `download_id` int(11) NOT NULL default '0', PRIMARY KEY (`product_id`,`download_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_to_download` -- LOCK TABLES `product_to_download` WRITE; /*!40000 ALTER TABLE `product_to_download` DISABLE KEYS */; /*!40000 ALTER TABLE `product_to_download` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_to_image` -- DROP TABLE IF EXISTS `product_to_image`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_to_image` ( `product_id` int(11) NOT NULL default '0', `image_id` int(11) NOT NULL default '0', PRIMARY KEY (`product_id`,`image_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_to_image` -- LOCK TABLES `product_to_image` WRITE; /*!40000 ALTER TABLE `product_to_image` DISABLE KEYS */; INSERT INTO `product_to_image` VALUES (0,41),(0,42),(0,43),(0,44),(0,45),(0,46),(0,47),(0,48),(6,81),(9,54),(9,55),(12,58),(13,81),(16,79),(17,81),(20,92),(21,67),(22,81),(23,81),(24,64),(25,76),(26,72),(27,77),(28,78),(29,81),(30,81); /*!40000 ALTER TABLE `product_to_image` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_to_option` -- DROP TABLE IF EXISTS `product_to_option`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `product_to_option` ( `product_to_option_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `option_id` int(11) NOT NULL default '0', `option_value_id` int(11) NOT NULL default '0', `price` decimal(15,4) NOT NULL default '0.0000', `prefix` char(1) collate utf8_unicode_ci NOT NULL default '+', `sort_order` int(3) NOT NULL default '0', PRIMARY KEY (`product_to_option_id`) ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `product_to_option` -- LOCK TABLES `product_to_option` WRITE; /*!40000 ALTER TABLE `product_to_option` DISABLE KEYS */; INSERT INTO `product_to_option` VALUES (46,32,10,23,'0.0000','-',0),(45,32,10,24,'35.0000','+',1),(44,17,10,24,'40.0000','+',1),(43,17,10,23,'0.0000','-',0),(42,16,10,23,'0.0000','-',0),(41,16,10,24,'31.0000','+',1),(40,15,10,24,'39.0000','+',0),(39,15,10,23,'0.0000','+',0),(47,24,8,21,'0.0000','-',0),(48,24,8,20,'20.0000','+',0),(49,24,8,22,'0.0000','-',0),(50,24,9,17,'0.0000','-',0),(51,24,9,19,'0.0000','-',0); /*!40000 ALTER TABLE `product_to_option` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `review` -- DROP TABLE IF EXISTS `review`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `review` ( `review_id` int(11) NOT NULL auto_increment, `product_id` int(11) NOT NULL default '0', `customer_id` int(11) NOT NULL default '0', `author` varchar(64) collate utf8_unicode_ci NOT NULL default '', `text` text collate utf8_unicode_ci NOT NULL, `rating` int(1) default NULL, `status` int(1) NOT NULL default '0', `date_added` datetime default NULL, `date_modified` datetime default NULL, PRIMARY KEY (`review_id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `review` -- LOCK TABLES `review` WRITE; /*!40000 ALTER TABLE `review` DISABLE KEYS */; /*!40000 ALTER TABLE `review` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `session` -- DROP TABLE IF EXISTS `session`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `session` ( `session_id` varchar(32) collate utf8_unicode_ci NOT NULL default '', `expire` int(10) NOT NULL default '0', `value` text collate utf8_unicode_ci NOT NULL, `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', `url` varchar(255) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `session` -- LOCK TABLES `session` WRITE; /*!40000 ALTER TABLE `session` DISABLE KEYS */; INSERT INTO `session` VALUES ('88c7e756dfc26fbf8425605b3edcac9f',1212761510,'language|s:2:\"en\";currency|s:3:\"MXN\";search.search|s:7:\"cerveza\";search.page|N;','76.93.20.156','2008-06-06 09:11:50','/carro/index.php?controller=search'); /*!40000 ALTER TABLE `session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `setting` -- DROP TABLE IF EXISTS `setting`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `setting` ( `setting_id` int(11) NOT NULL auto_increment, `type` varchar(12) collate utf8_unicode_ci NOT NULL default '', `group` varchar(12) collate utf8_unicode_ci NOT NULL default '', `key` varchar(64) collate utf8_unicode_ci NOT NULL default '', `value` varchar(128) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`setting_id`), KEY `group` (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=7814 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `setting` -- LOCK TABLES `setting` WRITE; /*!40000 ALTER TABLE `setting` DISABLE KEYS */; INSERT INTO `setting` VALUES (3867,'catalog','footer','footer_status','1'),(4327,'global','cod','cod_sort_order','1'),(3981,'catalog','header','header_status','1'),(3864,'catalog','language','language_status','1'),(4329,'global','shipping','shipping_sort_order','2'),(7809,'global','config','config_image_resize','1'),(7810,'global','config','config_image_width','100'),(7808,'global','config','config_compress_level','4'),(3817,'global','total','total_sort_order','5'),(3815,'global','coupon','coupon_sort_order','4'),(4328,'global','shipping','shipping_status','1'),(3809,'global','subtotal','subtotal_sort_order','1'),(3808,'global','subtotal','subtotal_status','1'),(3814,'global','coupon','coupon_status','1'),(3813,'global','tax','tax_sort_order','3'),(3812,'global','tax','tax_status','1'),(7804,'global','config','config_email','contacto@chaaj.com'),(7805,'global','config','config_email_send','1'),(3869,'catalog','category','category_status','1'),(3816,'global','total','total_status','1'),(4326,'global','cod','cod_geo_zone_id','0'),(4325,'global','cod','cod_status','1'),(3863,'catalog','review','review_status','1'),(3876,'catalog','search','search_status','1'),(3868,'catalog','currency','currency_status','1'),(3865,'catalog','information','information_status','1'),(7807,'global','config','config_compress_output','0'),(4658,'global','item','item_sort_order','0'),(4657,'global','item','item_tax_class_id','0'),(7806,'global','config','config_cache_query','0'),(7802,'catalog','config','config_account_id','0'),(7803,'catalog','config','config_checkout_id','0'),(6079,'global','paypal','paypal_sort_order','1'),(7801,'catalog','config','config_vat','123456'),(7800,'catalog','config','config_stock_subtract','0'),(4668,'global','flat','flat_sort_order','0'),(4667,'global','flat','flat_tax_class_id','0'),(4656,'global','item','item_cost','10'),(4655,'global','item','item_geo_zone_id','2'),(4654,'global','item','item_status','0'),(4666,'global','flat','flat_cost','0'),(3870,'catalog','cart','cart_status','1'),(3875,'admin','menu','menu_status','1'),(4100,'admin','footer','footer_status','1'),(4093,'admin','header','header_status','1'),(6078,'global','paypal','paypal_currency','USD'),(6077,'global','paypal','paypal_test','0'),(7799,'catalog','config','config_stock_checkout','1'),(7797,'global','config','config_order_status_id','1'),(7798,'catalog','config','config_stock_check','0'),(7796,'global','config','config_tax','1'),(7795,'global','config','config_weight_class_id','1'),(7794,'global','config','config_currency','MXN'),(4665,'global','flat','flat_geo_zone_id','0'),(7811,'global','config','config_image_height','100'),(4664,'global','flat','flat_status','0'),(7793,'global','config','config_language','en'),(7792,'global','config','config_zone_id','2159'),(7791,'global','config','config_country_id','138'),(7790,'admin','config','config_ssl','0'),(7789,'admin','config','config_parse_time','0'),(7786,'catalog','config','config_ssl','0'),(7787,'admin','config','config_template','default'),(7788,'admin','config','config_max_rows','20'),(6076,'global','paypal','paypal_email','direcciongeneral@deliciasparaceliacos.com'),(7785,'catalog','config','config_parse_time','0'),(7784,'catalog','config','config_url_alias','1'),(7783,'catalog','config','config_max_rows','9'),(6075,'global','paypal','paypal_geo_zone_id','0'),(6074,'global','paypal','paypal_status','1'),(7782,'catalog','config','config_template',''),(7739,'global','zone','zone_sort_order','0'),(7738,'global','zone','zone_tax_class_id','0'),(7737,'global','zone','zone_66_status','1'),(7736,'global','zone','zone_27_status','1'),(7735,'global','zone','zone_58_status','1'),(7734,'global','zone','zone_19_status','1'),(7781,'global','config','config_fax',''),(7780,'global','config','config_telephone','(55) 5656-7459'),(7779,'global','config','config_address','México D.F.'),(7778,'global','config','config_owner','M. Juárez'),(7777,'global','config','config_store','Delicias Para Celiacos'),(7733,'global','zone','zone_61_status','1'),(7732,'global','zone','zone_22_status','1'),(7731,'global','zone','zone_46_status','1'),(7730,'global','zone','zone_7_status','1'),(7729,'global','zone','zone_51_status','1'),(7728,'global','zone','zone_12_status','1'),(7727,'global','zone','zone_82_status','1'),(7726,'global','zone','zone_43_status','1'),(7725,'global','zone','zone_65_status','1'),(7724,'global','zone','zone_26_status','1'),(7723,'global','zone','zone_68_status','1'),(7722,'global','zone','zone_29_status','1'),(7721,'global','zone','zone_4_status','0'),(7720,'global','zone','zone_3_status','0'),(7719,'global','zone','zone_57_status','1'),(7718,'global','zone','zone_18_status','1'),(7717,'global','zone','zone_60_status','1'),(7716,'global','zone','zone_21_status','1'),(7715,'global','zone','zone_75_status','1'),(7714,'global','zone','zone_36_status','1'),(7713,'global','zone','zone_50_status','1'),(7712,'global','zone','zone_11_status','1'),(7711,'global','zone','zone_54_status','1'),(7710,'global','zone','zone_15_status','1'),(7709,'global','zone','zone_49_status','1'),(7708,'global','zone','zone_10_status','1'),(7707,'global','zone','zone_45_status','1'),(7706,'global','zone','zone_6_status','1'),(7705,'global','zone','zone_56_status','1'),(7704,'global','zone','zone_17_status','1'),(7703,'global','zone','zone_74_status','1'),(7702,'global','zone','zone_35_status','1'),(7701,'global','zone','zone_80_status','1'),(7700,'global','zone','zone_41_status','1'),(7699,'global','zone','zone_47_status','1'),(7698,'global','zone','zone_8_status','1'),(7697,'global','zone','zone_55_status','1'),(7696,'global','zone','zone_16_status','1'),(7695,'global','zone','zone_44_status','0'),(7694,'global','zone','zone_5_status','1'),(7693,'global','zone','zone_81_status','1'),(7692,'global','zone','zone_42_status','1'),(7691,'global','zone','zone_76_status','1'),(7690,'global','zone','zone_37_status','1'),(7689,'global','zone','zone_72_status','1'),(7688,'global','zone','zone_33_status','1'),(7687,'global','zone','zone_73_status','1'),(7686,'global','zone','zone_34_status','1'),(7685,'global','zone','zone_62_status','1'),(7684,'global','zone','zone_23_status','1'),(7683,'global','zone','zone_52_status','1'),(7682,'global','zone','zone_13_status','1'),(7681,'global','zone','zone_1_status','0'),(7680,'global','zone','zone_79_status','1'),(7679,'global','zone','zone_40_status','1'),(7678,'global','zone','zone_64_status','1'),(7677,'global','zone','zone_25_status','1'),(7676,'global','zone','zone_63_status','1'),(7675,'global','zone','zone_24_status','1'),(7674,'global','zone','zone_2_status','0'),(7673,'global','zone','zone_71_status','1'),(7672,'global','zone','zone_32_status','1'),(7668,'global','zone','zone_28_status','1'),(7669,'global','zone','zone_67_status','1'),(7670,'global','zone','zone_9_status','1'),(7671,'global','zone','zone_48_status','1'),(7664,'global','zone','zone_31_status','1'),(7665,'global','zone','zone_70_status','1'),(7666,'global','zone','zone_38_status','1'),(7667,'global','zone','zone_77_status','1'),(7660,'global','zone','zone_30_status','1'),(7661,'global','zone','zone_69_status','1'),(7662,'global','zone','zone_39_status','1'),(7663,'global','zone','zone_78_status','1'),(7657,'global','zone','zone_53_status','1'),(7658,'global','zone','zone_20_status','1'),(7659,'global','zone','zone_59_status','1'),(7655,'global','zone','zone_66_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7656,'global','zone','zone_14_status','1'),(7653,'global','zone','zone_58_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7654,'global','zone','zone_27_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7652,'global','zone','zone_19_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7651,'global','zone','zone_61_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7650,'global','zone','zone_22_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7649,'global','zone','zone_46_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7648,'global','zone','zone_7_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7647,'global','zone','zone_51_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7646,'global','zone','zone_12_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7645,'global','zone','zone_82_cost','1:115.65,1.5:136.19,2:156.73,2.5:177.27,3:197.81,3.5:218.35,4:238.89,4.5:259.43,5:279.97,5.5:300.51,6:321.05,6.5:341.59,7:362.13'),(7644,'global','zone','zone_43_cost','1:133.04,1.5:154.05,2:175.06,2.5:196.07,3:217.08,3.5:238.09,4:259.1,4.5:280.11,5:301.12,5.5:322.13,6:343.14,6.5:364.15,7:385.16,'),(7643,'global','zone','zone_65_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7642,'global','zone','zone_26_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7641,'global','zone','zone_68_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7640,'global','zone','zone_29_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7639,'global','zone','zone_4_cost',''),(7638,'global','zone','zone_3_cost',''),(7637,'global','zone','zone_57_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7636,'global','zone','zone_18_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7635,'global','zone','zone_60_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7634,'global','zone','zone_21_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7633,'global','zone','zone_75_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7632,'global','zone','zone_36_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7628,'global','zone','zone_15_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7629,'global','zone','zone_54_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7631,'global','zone','zone_50_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7630,'global','zone','zone_11_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7627,'global','zone','zone_49_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7626,'global','zone','zone_10_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7624,'global','zone','zone_6_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7625,'global','zone','zone_45_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7623,'global','zone','zone_56_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7622,'global','zone','zone_17_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7621,'global','zone','zone_74_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7620,'global','zone','zone_35_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7618,'global','zone','zone_41_cost','1:129.57,1.5:149.59,2:169.61,2.5:189.63,3:209.65,3.5:229.67,4:249.69,4.5:269.71,5:289.73,5.5:309.75,6:329.77,6.5:349.79,7:369.81'),(7619,'global','zone','zone_80_cost','1:108.7,1.5:128.36,2:148.02,2.5:167.68,3:187.34,3.5:207,4:226.66,4.5:246.32,5:265.98,5.5:285.64,6:305.3,6.5:324.96,7:344.62,7.5:'),(7617,'global','zone','zone_47_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7616,'global','zone','zone_8_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7615,'global','zone','zone_55_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7613,'global','zone','zone_44_cost',''),(7614,'global','zone','zone_16_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7612,'global','zone','zone_5_cost','40:30'),(7611,'global','zone','zone_81_cost','1:115.65,1.5:136.19,2:156.73,2.5:177.27,3:197.81,3.5:218.35,4:238.89,4.5:259.43,5:279.97,5.5:300.51,6:321.05,6.5:341.59,7:362.13'),(7610,'global','zone','zone_42_cost','1:133.04,1.5:154.05,2:175.06,2.5:196.07,3:217.08,3.5:238.09,4:259.1,4.5:280.11,5:301.12,5.5:322.13,6:343.14,6.5:364.15,7:385.16,'),(7609,'global','zone','zone_76_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7608,'global','zone','zone_37_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7607,'global','zone','zone_72_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7605,'global','zone','zone_73_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7606,'global','zone','zone_33_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7604,'global','zone','zone_34_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7603,'global','zone','zone_62_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7602,'global','zone','zone_23_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7601,'global','zone','zone_52_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7599,'global','zone','zone_1_cost',''),(7600,'global','zone','zone_13_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7597,'global','zone','zone_40_cost','1:126.09,1.5:144.91,2:163.73,2.5:182.55,3:201.37,3.5:220.19,4:239.01,4.5:257.83,5:276.65,5.5:295.47,6:314.29,6.5:333.11,7:351.93'),(7598,'global','zone','zone_79_cost','1:102.61,1.5:120.97,2:139.33,2.5:157.69,3:176.05,3.5:194.41,4:212.77,4.5:231.13,5:249.49,5.5:267.85,6:286.21,6.5:304.57,7:322.93'),(7596,'global','zone','zone_64_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7594,'global','zone','zone_63_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7595,'global','zone','zone_25_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7592,'global','zone','zone_2_cost',''),(7593,'global','zone','zone_24_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7590,'global','zone','zone_32_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7591,'global','zone','zone_71_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7588,'global','zone','zone_9_cost','1:96.52,1.5:102.72,2:108.92,2.5:115.12,3:121.32,3.5:127.52,4:133.72,4.5:139.92,5:146.12,5.5:152.32,6:158.52,6.5:164.72,7:170.92,'),(7589,'global','zone','zone_48_cost','1:77.39,1.5:83.11,2:88.83,2.5:94.55,3:100.27,3.5:105.99,4:111.71,4.5:117.43,5:123.15,5.5:128.87,6:134.59,6.5:140.31,7:146.03,7.5'),(7587,'global','zone','zone_67_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7586,'global','zone','zone_28_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7585,'global','zone','zone_77_cost','1:102.61,1.5:120.97,2:139.33,2.5:157.69,3:176.05,3.5:194.41,4:212.77,4.5:231.13,5:249.49,5.5:267.85,6:286.21,6.5:304.57,7:322.93'),(7584,'global','zone','zone_38_cost','1:126.09,1.5:144.91,2:163.73,2.5:182.55,3:201.37,3.5:220.19,4:239.01,4.5:257.83,5:276.65,5.5:295.47,6:314.29,6.5:333.11,7:351.93'),(7580,'global','zone','zone_39_cost','1:126.09,1.5:144.91,2:163.73,2.5:182.55,3:201.37,3.5:220.19,4:239.01,4.5:257.83,5:276.65,5.5:295.47,6:314.29,6.5:333.11,7:351.93'),(7581,'global','zone','zone_78_cost','1:102.61,1.5:120.97,2:139.33,2.5:157.69,3:176.05,3.5:194.41,4:212.77,4.5:231.13,5:249.49,5.5:267.85,6:286.21,6.5:304.57,7:322.93'),(7583,'global','zone','zone_70_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7582,'global','zone','zone_31_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7579,'global','zone','zone_69_cost','1:96.52,1.5:113.58,2:130.64,2.5:147.7,3:164.76,3.5:181.82,4:198.88,4.5:215.94,5:233,5.5:250.06,6:267.12,6.5:284.18,7:301.24,7.5:'),(7578,'global','zone','zone_30_cost','1:122.61,1.5:140.13,2:157.65,2.5:175.17,3:192.69,3.5:210.21,4:227.73,4.5:245.25,5:262.77,5.5:280.29,6:297.81,6.5:315.33,7:332.85'),(7577,'global','zone','zone_59_cost','1:93.04,1.5:101.57,2:110.1,2.5:118.63,3:127.16,3.5:135.69,4:144.22,4.5:152.75,5:161.28,5.5:169.81,6:178.34,6.5:186.87,7:195.4,7.'),(7576,'global','zone','zone_20_cost','1:115.65,1.5:125.11,2:134.57,2.5:144.03,3:153.49,3.5:162.95,4:172.41,4.5:181.87,5:191.33,5.5:200.79,6:210.25,6.5:219.71,7:229.17'),(7574,'global','zone','zone_14_cost','1:104.35,1.5:111.73,2:119.11,2.5:126.49,3:133.87,3.5:141.25,4:148.63,4.5:156.01,5:163.39,5.5:170.77,6:178.15,6.5:185.53,7:192.91'),(7575,'global','zone','zone_53_cost','1:83.48,1.5:90.24,2:97,2.5:103.76,3:110.52,3.5:117.28,4:124.04,4.5:130.8,5:137.56,5.5:144.32,6:151.08,6.5:157.84,7:164.6,7.5:171'),(7812,'catalog','config','config_download','1'),(7813,'catalog','config','config_download_status','16'); /*!40000 ALTER TABLE `setting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax_class` -- DROP TABLE IF EXISTS `tax_class`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `tax_class` ( `tax_class_id` int(11) NOT NULL auto_increment, `title` varchar(32) collate utf8_unicode_ci NOT NULL default '', `description` varchar(255) collate utf8_unicode_ci NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_class_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `tax_class` -- LOCK TABLES `tax_class` WRITE; /*!40000 ALTER TABLE `tax_class` DISABLE KEYS */; INSERT INTO `tax_class` VALUES (6,'Taxable Goods','taxed stuff','2006-11-08 08:45:44','2007-07-26 13:54:08'); /*!40000 ALTER TABLE `tax_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax_rate` -- DROP TABLE IF EXISTS `tax_rate`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `tax_rate` ( `tax_rate_id` int(11) NOT NULL auto_increment, `geo_zone_id` int(11) NOT NULL default '0', `tax_class_id` int(11) NOT NULL default '0', `priority` int(5) default '1', `rate` decimal(7,4) NOT NULL default '0.0000', `description` varchar(255) collate utf8_unicode_ci NOT NULL default '', `date_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_rate_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `tax_rate` -- LOCK TABLES `tax_rate` WRITE; /*!40000 ALTER TABLE `tax_rate` DISABLE KEYS */; INSERT INTO `tax_rate` VALUES (10,1,6,1,'17.5000','UK VAT 17.5%','2007-08-08 23:33:27','2006-11-08 08:49:10'); /*!40000 ALTER TABLE `tax_rate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `url_alias` -- DROP TABLE IF EXISTS `url_alias`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `url_alias` ( `url_alias_id` int(11) NOT NULL auto_increment, `query` varchar(128) collate utf8_unicode_ci NOT NULL default '0', `alias` varchar(128) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`url_alias_id`), KEY `query` (`query`), KEY `alias` (`alias`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `url_alias` -- LOCK TABLES `url_alias` WRITE; /*!40000 ALTER TABLE `url_alias` DISABLE KEYS */; INSERT INTO `url_alias` VALUES (20,'http://comunn.net/carro','http://deliciasparaceliacos.com/carro'); /*!40000 ALTER TABLE `url_alias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `user` ( `user_id` int(11) NOT NULL auto_increment, `user_group_id` int(11) NOT NULL default '0', `username` varchar(20) collate utf8_unicode_ci NOT NULL default '', `password` varchar(32) collate utf8_unicode_ci NOT NULL default '', `firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '', `email` varchar(96) collate utf8_unicode_ci NOT NULL default '', `ip` varchar(15) collate utf8_unicode_ci NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (1,1,'admin','1183dd9004042b2f45a0cc7b9536613b','','','','63.69.85.2','2008-01-16 17:47:59'); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_group` -- DROP TABLE IF EXISTS `user_group`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `user_group` ( `user_group_id` int(11) NOT NULL auto_increment, `name` varchar(64) collate utf8_unicode_ci default NULL, `permission` text collate utf8_unicode_ci NOT NULL, PRIMARY KEY (`user_group_id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `user_group` -- LOCK TABLES `user_group` WRITE; /*!40000 ALTER TABLE `user_group` DISABLE KEYS */; INSERT INTO `user_group` VALUES (1,'Top Administrator','a:2:{s:6:\"access\";a:63:{i:0;s:6:\"backup\";i:1;s:16:\"calculate_coupon\";i:2;s:18:\"calculate_shipping\";i:3;s:18:\"calculate_subtotal\";i:4;s:13:\"calculate_tax\";i:5;s:15:\"calculate_total\";i:6;s:8:\"category\";i:7;s:7:\"country\";i:8;s:6:\"coupon\";i:9;s:8:\"currency\";i:10;s:8:\"customer\";i:11;s:8:\"download\";i:12;s:5:\"error\";i:13;s:9:\"extension\";i:14;s:8:\"geo_zone\";i:15;s:4:\"home\";i:16;s:5:\"image\";i:17;s:11:\"information\";i:18;s:8:\"language\";i:19;s:5:\"login\";i:20;s:6:\"logout\";i:21;s:4:\"mail\";i:22;s:12:\"manufacturer\";i:23;s:19:\"module_admin_footer\";i:24;s:19:\"module_admin_header\";i:25;s:17:\"module_admin_menu\";i:26;s:19:\"module_catalog_cart\";i:27;s:23:\"module_catalog_category\";i:28;s:23:\"module_catalog_currency\";i:29;s:21:\"module_catalog_footer\";i:30;s:21:\"module_catalog_header\";i:31;s:26:\"module_catalog_information\";i:32;s:23:\"module_catalog_language\";i:33;s:21:\"module_catalog_review\";i:34;s:21:\"module_catalog_search\";i:35;s:10:\"newsletter\";i:36;s:6:\"option\";i:37;s:12:\"option_value\";i:38;s:5:\"order\";i:39;s:12:\"order_status\";i:40;s:11:\"payment_cod\";i:41;s:14:\"payment_paypal\";i:42;s:10:\"permission\";i:43;s:7:\"product\";i:44;s:14:\"product_option\";i:45;s:13:\"report_online\";i:46;s:16:\"report_purchased\";i:47;s:11:\"report_sale\";i:48;s:13:\"report_viewed\";i:49;s:6:\"review\";i:50;s:11:\"server_info\";i:51;s:7:\"setting\";i:52;s:13:\"shipping_flat\";i:53;s:13:\"shipping_item\";i:54;s:13:\"shipping_zone\";i:55;s:9:\"tax_class\";i:56;s:8:\"tax_rate\";i:57;s:9:\"url_alias\";i:58;s:4:\"user\";i:59;s:10:\"user_group\";i:60;s:12:\"weight_class\";i:61;s:4:\"zone\";i:62;s:16:\"zone_to_geo_zone\";}s:6:\"modify\";a:62:{i:0;s:6:\"backup\";i:1;s:16:\"calculate_coupon\";i:2;s:18:\"calculate_shipping\";i:3;s:18:\"calculate_subtotal\";i:4;s:13:\"calculate_tax\";i:5;s:15:\"calculate_total\";i:6;s:8:\"category\";i:7;s:7:\"country\";i:8;s:6:\"coupon\";i:9;s:8:\"currency\";i:10;s:8:\"customer\";i:11;s:8:\"download\";i:12;s:9:\"extension\";i:13;s:8:\"geo_zone\";i:14;s:4:\"home\";i:15;s:5:\"image\";i:16;s:11:\"information\";i:17;s:8:\"language\";i:18;s:5:\"login\";i:19;s:6:\"logout\";i:20;s:4:\"mail\";i:21;s:12:\"manufacturer\";i:22;s:19:\"module_admin_footer\";i:23;s:19:\"module_admin_header\";i:24;s:17:\"module_admin_menu\";i:25;s:19:\"module_catalog_cart\";i:26;s:23:\"module_catalog_category\";i:27;s:23:\"module_catalog_currency\";i:28;s:21:\"module_catalog_footer\";i:29;s:21:\"module_catalog_header\";i:30;s:26:\"module_catalog_information\";i:31;s:23:\"module_catalog_language\";i:32;s:21:\"module_catalog_review\";i:33;s:21:\"module_catalog_search\";i:34;s:10:\"newsletter\";i:35;s:6:\"option\";i:36;s:12:\"option_value\";i:37;s:5:\"order\";i:38;s:12:\"order_status\";i:39;s:11:\"payment_cod\";i:40;s:14:\"payment_paypal\";i:41;s:10:\"permission\";i:42;s:7:\"product\";i:43;s:14:\"product_option\";i:44;s:13:\"report_online\";i:45;s:16:\"report_purchased\";i:46;s:11:\"report_sale\";i:47;s:13:\"report_viewed\";i:48;s:6:\"review\";i:49;s:11:\"server_info\";i:50;s:7:\"setting\";i:51;s:13:\"shipping_flat\";i:52;s:13:\"shipping_item\";i:53;s:13:\"shipping_zone\";i:54;s:9:\"tax_class\";i:55;s:8:\"tax_rate\";i:56;s:9:\"url_alias\";i:57;s:4:\"user\";i:58;s:10:\"user_group\";i:59;s:12:\"weight_class\";i:60;s:4:\"zone\";i:61;s:16:\"zone_to_geo_zone\";}}'),(7,'Demonstration','a:2:{s:6:\"access\";a:63:{i:0;s:6:\"backup\";i:1;s:16:\"calculate_coupon\";i:2;s:18:\"calculate_shipping\";i:3;s:18:\"calculate_subtotal\";i:4;s:13:\"calculate_tax\";i:5;s:15:\"calculate_total\";i:6;s:8:\"category\";i:7;s:7:\"country\";i:8;s:6:\"coupon\";i:9;s:8:\"currency\";i:10;s:8:\"customer\";i:11;s:8:\"download\";i:12;s:5:\"error\";i:13;s:9:\"extension\";i:14;s:8:\"geo_zone\";i:15;s:4:\"home\";i:16;s:5:\"image\";i:17;s:11:\"information\";i:18;s:8:\"language\";i:19;s:5:\"login\";i:20;s:6:\"logout\";i:21;s:4:\"mail\";i:22;s:12:\"manufacturer\";i:23;s:19:\"module_admin_footer\";i:24;s:19:\"module_admin_header\";i:25;s:17:\"module_admin_menu\";i:26;s:19:\"module_catalog_cart\";i:27;s:23:\"module_catalog_category\";i:28;s:23:\"module_catalog_currency\";i:29;s:21:\"module_catalog_footer\";i:30;s:21:\"module_catalog_header\";i:31;s:26:\"module_catalog_information\";i:32;s:23:\"module_catalog_language\";i:33;s:21:\"module_catalog_review\";i:34;s:21:\"module_catalog_search\";i:35;s:10:\"newsletter\";i:36;s:6:\"option\";i:37;s:12:\"option_value\";i:38;s:5:\"order\";i:39;s:12:\"order_status\";i:40;s:11:\"payment_cod\";i:41;s:14:\"payment_paypal\";i:42;s:10:\"permission\";i:43;s:7:\"product\";i:44;s:14:\"product_option\";i:45;s:13:\"report_online\";i:46;s:16:\"report_purchased\";i:47;s:11:\"report_sale\";i:48;s:13:\"report_viewed\";i:49;s:6:\"review\";i:50;s:11:\"server_info\";i:51;s:7:\"setting\";i:52;s:13:\"shipping_flat\";i:53;s:13:\"shipping_item\";i:54;s:13:\"shipping_zone\";i:55;s:9:\"tax_class\";i:56;s:8:\"tax_rate\";i:57;s:9:\"url_alias\";i:58;s:4:\"user\";i:59;s:10:\"user_group\";i:60;s:12:\"weight_class\";i:61;s:4:\"zone\";i:62;s:16:\"zone_to_geo_zone\";}s:6:\"modify\";N;}'); /*!40000 ALTER TABLE `user_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `weight_class` -- DROP TABLE IF EXISTS `weight_class`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `weight_class` ( `weight_class_id` int(11) NOT NULL auto_increment, `unit` varchar(4) collate utf8_unicode_ci NOT NULL default '', `language_id` int(11) NOT NULL default '0', `title` varchar(32) collate utf8_unicode_ci NOT NULL default '', PRIMARY KEY (`weight_class_id`,`language_id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `weight_class` -- LOCK TABLES `weight_class` WRITE; /*!40000 ALTER TABLE `weight_class` DISABLE KEYS */; INSERT INTO `weight_class` VALUES (1,'g',1,'Gram(s)'),(3,'oz',3,'Ounce(s)'),(3,'oz',2,'Ounce(s)'),(3,'oz',1,'Ounce(s)'),(4,'lb',1,'Pound(s)'),(4,'lb',2,'Pound(s)'),(4,'lb',3,'Pound(s)'),(2,'kg',1,'Kilogram(s)'); /*!40000 ALTER TABLE `weight_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `weight_rule` -- DROP TABLE IF EXISTS `weight_rule`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `weight_rule` ( `from_id` int(11) NOT NULL default '0', `to_id` int(11) NOT NULL default '0', `rule` decimal(15,4) NOT NULL default '0.0000' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `weight_rule` -- LOCK TABLES `weight_rule` WRITE; /*!40000 ALTER TABLE `weight_rule` DISABLE KEYS */; INSERT INTO `weight_rule` VALUES (1,2,'0.0000'),(1,4,'0.0000'),(1,3,'0.0000'),(2,4,'2.2046'),(3,1,'28.3495'),(3,2,'0.0283'),(3,4,'0.0625'),(4,1,'453.5923'),(4,2,'0.4535'),(4,3,'16.0000'),(2,3,'35.2739'),(2,1,'1000.0000'); /*!40000 ALTER TABLE `weight_rule` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zone` -- DROP TABLE IF EXISTS `zone`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `zone` ( `zone_id` int(11) NOT NULL auto_increment, `country_id` int(11) NOT NULL default '0', `code` varchar(32) NOT NULL default '', `name` varchar(32) NOT NULL default '', PRIMARY KEY (`zone_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3843 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `zone` -- LOCK TABLES `zone` WRITE; /*!40000 ALTER TABLE `zone` DISABLE KEYS */; INSERT INTO `zone` VALUES (2146,138,'BN','Baja California Norte'),(2147,138,'BS','Baja California Sur'),(2148,138,'CA','Campeche'),(2149,138,'CI','Chiapas'),(2150,138,'CH','Chihuahua'),(2151,138,'CZ','Coahuila de Zaragoza'),(2152,138,'CL','Colima'),(2153,138,'DF','Distrito Federal'),(2154,138,'DU','Durango'),(2155,138,'GA','Guanajuato'),(2156,138,'GE','Guerrero'),(2157,138,'HI','Hidalgo'),(2158,138,'JA','Jalisco'),(2159,138,'ME','Mexico'),(2160,138,'MI','Michoacan de Ocampo'),(2161,138,'MO','Morelos'),(2162,138,'NA','Nayarit'),(2163,138,'NL','Nuevo Leon'),(2164,138,'OA','Oaxaca'),(2165,138,'PU','Puebla'),(2166,138,'QA','Queretaro de Arteaga'),(2167,138,'QR','Quintana Roo'),(2168,138,'SA','San Luis Potosi'),(2169,138,'SI','Sinaloa'),(2170,138,'SO','Sonora'),(2171,138,'TB','Tabasco'),(2172,138,'TM','Tamaulipas'),(2173,138,'TL','Tlaxcala'),(2174,138,'VE','Veracruz-Llave'),(2175,138,'YU','Yucatan'),(2176,138,'ZA','Zacatecas'),(3842,138,'AGS','Aguascalientes'); /*!40000 ALTER TABLE `zone` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zone_to_geo_zone` -- DROP TABLE IF EXISTS `zone_to_geo_zone`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `zone_to_geo_zone` ( `zone_to_geo_zone_id` int(11) NOT NULL auto_increment, `country_id` int(11) NOT NULL default '0', `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`zone_to_geo_zone_id`) ) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `zone_to_geo_zone` -- LOCK TABLES `zone_to_geo_zone` WRITE; /*!40000 ALTER TABLE `zone_to_geo_zone` DISABLE KEYS */; INSERT INTO `zone_to_geo_zone` VALUES (7,138,2173,1,'2008-02-17 13:05:44','2008-02-29 19:05:47'),(8,138,2146,2,'2008-02-29 18:55:52','0000-00-00 00:00:00'),(9,138,2170,3,'2008-02-29 19:06:06','0000-00-00 00:00:00'),(6,138,2153,2,'2008-02-17 12:59:47','0000-00-00 00:00:00'),(10,138,2170,4,'2008-02-29 19:06:26','0000-00-00 00:00:00'),(11,138,2153,5,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(12,138,2157,6,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(13,138,2159,7,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(14,138,2160,8,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(15,138,2161,9,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(16,138,2165,10,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(17,138,2166,11,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(18,138,2173,12,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(19,138,2155,13,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(20,138,2156,14,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(21,138,2158,15,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(22,138,2163,16,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(23,138,2164,17,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(24,138,2168,18,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(25,138,2174,19,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(26,138,3842,20,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(27,138,2151,21,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(28,138,2151,22,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(29,138,2152,23,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(30,138,2154,24,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(31,138,2158,25,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(32,138,2162,26,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(33,138,2171,27,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(34,138,2172,28,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(35,138,2172,29,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(36,138,2148,30,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(37,138,2150,31,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(38,138,2169,32,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(39,138,2170,33,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(40,138,2172,34,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(41,138,2172,35,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(42,138,2172,36,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(43,138,2175,37,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(44,138,2150,38,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(45,138,2167,39,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(46,138,2170,40,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(47,138,2170,41,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(48,138,2146,42,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(49,138,2146,43,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(50,138,2153,44,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(51,138,2157,45,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(52,138,2159,46,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(53,138,2160,47,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(54,138,2161,48,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(55,138,2165,49,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(56,138,2166,50,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(57,138,2173,51,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(58,138,2155,52,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(59,138,2156,53,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(60,138,2158,54,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(61,138,2163,55,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(62,138,2164,56,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(63,138,2168,57,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(64,138,2174,58,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(65,138,3842,59,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(66,138,2151,60,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(67,138,2151,61,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(68,138,2152,62,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(69,138,2154,63,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(70,138,2158,64,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(71,138,2162,65,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(72,138,2171,66,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(73,138,2172,67,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(74,138,2172,68,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(75,138,2148,69,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(76,138,2150,70,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(77,138,2169,71,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(78,138,2170,72,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(79,138,2172,73,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(80,138,2172,74,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(81,138,2172,75,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(82,138,2175,76,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(83,138,2150,77,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(84,138,2167,78,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(85,138,2170,79,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(86,138,2170,80,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(87,138,2146,81,'2008-02-17 13:05:21','2008-02-17 13:05:21'),(88,138,2146,82,'2008-02-17 13:05:21','2008-02-17 13:05:21'); /*!40000 ALTER TABLE `zone_to_geo_zone` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `mysql` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `mysql`; -- -- Table structure for table `columns_priv` -- DROP TABLE IF EXISTS `columns_priv`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `columns_priv` ( `Host` char(60) collate utf8_bin NOT NULL default '', `Db` char(64) collate utf8_bin NOT NULL default '', `User` char(16) collate utf8_bin NOT NULL default '', `Table_name` char(64) collate utf8_bin NOT NULL default '', `Column_name` char(64) collate utf8_bin NOT NULL default '', `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '', PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `columns_priv` -- LOCK TABLES `columns_priv` WRITE; /*!40000 ALTER TABLE `columns_priv` DISABLE KEYS */; INSERT INTO `columns_priv` VALUES ('localhost','mysql','pma','user','Host','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','User','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Select_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Insert_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Update_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Delete_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Create_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Drop_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Reload_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Shutdown_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Process_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','File_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Grant_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','References_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Index_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Alter_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Show_db_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Super_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Create_tmp_table_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Lock_tables_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Execute_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Repl_slave_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','user','Repl_client_priv','2003-05-31 01:27:58','Select'),('localhost','mysql','pma','tables_priv','Host','2003-05-31 01:28:05','Select'),('localhost','mysql','pma','tables_priv','Db','2003-05-31 01:28:05','Select'),('localhost','mysql','pma','tables_priv','User','2003-05-31 01:28:05','Select'),('localhost','mysql','pma','tables_priv','Table_name','2003-05-31 01:28:05','Select'),('localhost','mysql','pma','tables_priv','Table_priv','2003-05-31 01:28:05','Select'),('localhost','mysql','pma','tables_priv','Column_priv','2003-05-31 01:28:05','Select'); /*!40000 ALTER TABLE `columns_priv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `db` -- DROP TABLE IF EXISTS `db`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `db` ( `Host` char(60) collate utf8_bin NOT NULL default '', `Db` char(64) collate utf8_bin NOT NULL default '', `User` char(16) collate utf8_bin NOT NULL default '', `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N', PRIMARY KEY (`Host`,`Db`,`User`), KEY `User` (`User`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Database privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `db` -- LOCK TABLES `db` WRITE; /*!40000 ALTER TABLE `db` DISABLE KEYS */; INSERT INTO `db` VALUES ('%','test','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','N','N','N','N','N','N','N'),('%','test\\_%','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','N','N','N','N','N','N','N'),('localhost','mysql','pma','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'),('localhost','phpmyadmin','pma','Y','Y','Y','Y','N','N','N','N','N','N','N','N','N','N','N','N','Y'); /*!40000 ALTER TABLE `db` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `func` -- DROP TABLE IF EXISTS `func`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `func` ( `name` binary(64) NOT NULL default ' ', `ret` tinyint(1) NOT NULL default '0', `dl` char(128) collate utf8_bin NOT NULL default '', `type` enum('function','aggregate') character set utf8 NOT NULL, PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='User defined functions'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `func` -- LOCK TABLES `func` WRITE; /*!40000 ALTER TABLE `func` DISABLE KEYS */; /*!40000 ALTER TABLE `func` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_category` -- DROP TABLE IF EXISTS `help_category`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `help_category` ( `help_category_id` smallint(5) unsigned NOT NULL default '0', `name` varchar(64) NOT NULL default '', `parent_category_id` smallint(5) unsigned default NULL, `url` varchar(128) NOT NULL default '', PRIMARY KEY (`help_category_id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help categories'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `help_category` -- LOCK TABLES `help_category` WRITE; /*!40000 ALTER TABLE `help_category` DISABLE KEYS */; /*!40000 ALTER TABLE `help_category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_keyword` -- DROP TABLE IF EXISTS `help_keyword`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `help_keyword` ( `help_keyword_id` int(10) unsigned NOT NULL default '0', `name` varchar(64) NOT NULL default '', PRIMARY KEY (`help_keyword_id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help keywords'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `help_keyword` -- LOCK TABLES `help_keyword` WRITE; /*!40000 ALTER TABLE `help_keyword` DISABLE KEYS */; /*!40000 ALTER TABLE `help_keyword` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_relation` -- DROP TABLE IF EXISTS `help_relation`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `help_relation` ( `help_topic_id` int(10) unsigned NOT NULL default '0', `help_keyword_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`help_keyword_id`,`help_topic_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='keyword-topic relation'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `help_relation` -- LOCK TABLES `help_relation` WRITE; /*!40000 ALTER TABLE `help_relation` DISABLE KEYS */; /*!40000 ALTER TABLE `help_relation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `help_topic` -- DROP TABLE IF EXISTS `help_topic`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `help_topic` ( `help_topic_id` int(10) unsigned NOT NULL default '0', `name` varchar(64) NOT NULL default '', `help_category_id` smallint(5) unsigned NOT NULL default '0', `description` text NOT NULL, `example` text NOT NULL, `url` varchar(128) NOT NULL default '', PRIMARY KEY (`help_topic_id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='help topics'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `help_topic` -- LOCK TABLES `help_topic` WRITE; /*!40000 ALTER TABLE `help_topic` DISABLE KEYS */; /*!40000 ALTER TABLE `help_topic` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `host` -- DROP TABLE IF EXISTS `host`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `host` ( `Host` char(60) collate utf8_bin NOT NULL default '', `Db` char(64) collate utf8_bin NOT NULL default '', `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N', PRIMARY KEY (`Host`,`Db`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Host privileges; Merged with database privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `host` -- LOCK TABLES `host` WRITE; /*!40000 ALTER TABLE `host` DISABLE KEYS */; /*!40000 ALTER TABLE `host` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `proc` -- DROP TABLE IF EXISTS `proc`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `proc` ( `db` char(64) character set utf8 collate utf8_bin NOT NULL default '', `name` char(64) NOT NULL default '', `type` enum('FUNCTION','PROCEDURE') NOT NULL, `specific_name` char(64) NOT NULL default '', `language` enum('SQL') NOT NULL default 'SQL', `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL default 'CONTAINS_SQL', `is_deterministic` enum('YES','NO') NOT NULL default 'NO', `security_type` enum('INVOKER','DEFINER') NOT NULL default 'DEFINER', `param_list` blob NOT NULL, `returns` char(64) NOT NULL default '', `body` longblob NOT NULL, `definer` char(77) character set utf8 collate utf8_bin NOT NULL default '', `created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `modified` timestamp NOT NULL default '0000-00-00 00:00:00', `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE') NOT NULL default '', `comment` char(64) character set utf8 collate utf8_bin NOT NULL default '', PRIMARY KEY (`db`,`name`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Stored Procedures'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `proc` -- LOCK TABLES `proc` WRITE; /*!40000 ALTER TABLE `proc` DISABLE KEYS */; INSERT INTO `proc` VALUES ('test','test_multi_sets','PROCEDURE','test_multi_sets','SQL','CONTAINS_SQL','YES','DEFINER','','','begin\n select user() as first_col;\n select user() as first_col, now() as second_col;\n select user() as first_col, now() as second_col, now() as third_col;\n end','root@localhost','2008-01-23 13:48:55','2008-01-23 13:48:55','',''); /*!40000 ALTER TABLE `proc` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `procs_priv` -- DROP TABLE IF EXISTS `procs_priv`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `procs_priv` ( `Host` char(60) collate utf8_bin NOT NULL default '', `Db` char(64) collate utf8_bin NOT NULL default '', `User` char(16) collate utf8_bin NOT NULL default '', `Routine_name` char(64) collate utf8_bin NOT NULL default '', `Routine_type` enum('FUNCTION','PROCEDURE') collate utf8_bin NOT NULL, `Grantor` char(77) collate utf8_bin NOT NULL default '', `Proc_priv` set('Execute','Alter Routine','Grant') character set utf8 NOT NULL default '', `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`), KEY `Grantor` (`Grantor`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Procedure privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `procs_priv` -- LOCK TABLES `procs_priv` WRITE; /*!40000 ALTER TABLE `procs_priv` DISABLE KEYS */; /*!40000 ALTER TABLE `procs_priv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tables_priv` -- DROP TABLE IF EXISTS `tables_priv`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `tables_priv` ( `Host` char(60) collate utf8_bin NOT NULL default '', `Db` char(64) collate utf8_bin NOT NULL default '', `User` char(16) collate utf8_bin NOT NULL default '', `Table_name` char(64) collate utf8_bin NOT NULL default '', `Grantor` char(77) collate utf8_bin NOT NULL default '', `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view') character set utf8 NOT NULL default '', `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '', PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`), KEY `Grantor` (`Grantor`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `tables_priv` -- LOCK TABLES `tables_priv` WRITE; /*!40000 ALTER TABLE `tables_priv` DISABLE KEYS */; INSERT INTO `tables_priv` VALUES ('localhost','mysql','pma','user','root@localhost','2003-05-31 01:27:58','','Select'),('localhost','mysql','pma','db','root@localhost','2003-05-31 01:28:04','Select',''),('localhost','mysql','pma','host','root@localhost','2003-05-31 01:28:04','Select',''),('localhost','mysql','pma','tables_priv','root@localhost','2003-05-31 01:28:05','','Select'); /*!40000 ALTER TABLE `tables_priv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_zone` -- DROP TABLE IF EXISTS `time_zone`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time_zone` ( `Time_zone_id` int(10) unsigned NOT NULL auto_increment, `Use_leap_seconds` enum('Y','N') NOT NULL default 'N', PRIMARY KEY (`Time_zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zones'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `time_zone` -- LOCK TABLES `time_zone` WRITE; /*!40000 ALTER TABLE `time_zone` DISABLE KEYS */; /*!40000 ALTER TABLE `time_zone` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_zone_leap_second` -- DROP TABLE IF EXISTS `time_zone_leap_second`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time_zone_leap_second` ( `Transition_time` bigint(20) NOT NULL default '0', `Correction` int(11) NOT NULL default '0', PRIMARY KEY (`Transition_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Leap seconds information for time zones'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `time_zone_leap_second` -- LOCK TABLES `time_zone_leap_second` WRITE; /*!40000 ALTER TABLE `time_zone_leap_second` DISABLE KEYS */; /*!40000 ALTER TABLE `time_zone_leap_second` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_zone_name` -- DROP TABLE IF EXISTS `time_zone_name`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time_zone_name` ( `Name` char(64) NOT NULL default '', `Time_zone_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`Name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone names'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `time_zone_name` -- LOCK TABLES `time_zone_name` WRITE; /*!40000 ALTER TABLE `time_zone_name` DISABLE KEYS */; /*!40000 ALTER TABLE `time_zone_name` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_zone_transition` -- DROP TABLE IF EXISTS `time_zone_transition`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time_zone_transition` ( `Time_zone_id` int(10) unsigned NOT NULL default '0', `Transition_time` bigint(20) NOT NULL default '0', `Transition_type_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`Time_zone_id`,`Transition_time`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transitions'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `time_zone_transition` -- LOCK TABLES `time_zone_transition` WRITE; /*!40000 ALTER TABLE `time_zone_transition` DISABLE KEYS */; /*!40000 ALTER TABLE `time_zone_transition` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `time_zone_transition_type` -- DROP TABLE IF EXISTS `time_zone_transition_type`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `time_zone_transition_type` ( `Time_zone_id` int(10) unsigned NOT NULL default '0', `Transition_type_id` int(10) unsigned NOT NULL default '0', `Offset` int(11) NOT NULL default '0', `Is_DST` tinyint(3) unsigned NOT NULL default '0', `Abbreviation` char(8) NOT NULL default '', PRIMARY KEY (`Time_zone_id`,`Transition_type_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Time zone transition types'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `time_zone_transition_type` -- LOCK TABLES `time_zone_transition_type` WRITE; /*!40000 ALTER TABLE `time_zone_transition_type` DISABLE KEYS */; /*!40000 ALTER TABLE `time_zone_transition_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `user` ( `Host` char(60) collate utf8_bin NOT NULL default '', `User` char(16) collate utf8_bin NOT NULL default '', `Password` char(41) character set latin1 collate latin1_bin NOT NULL default '', `Select_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Insert_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Update_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Delete_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Drop_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Reload_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Shutdown_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Process_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `File_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Grant_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `References_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Index_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Show_db_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Super_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_tmp_table_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Lock_tables_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Execute_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Repl_slave_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Repl_client_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Show_view_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Alter_routine_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `Create_user_priv` enum('N','Y') character set utf8 NOT NULL default 'N', `ssl_type` enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '', `ssl_cipher` blob NOT NULL, `x509_issuer` blob NOT NULL, `x509_subject` blob NOT NULL, `max_questions` int(11) unsigned NOT NULL default '0', `max_updates` int(11) unsigned NOT NULL default '0', `max_connections` int(11) unsigned NOT NULL default '0', `max_user_connections` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`Host`,`User`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Users and global privileges'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES ('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0),('linux','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0),('localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0),('linux','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0),('localhost','pma','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0),('%','delicias_carro','*9F4A313C1CB94DBC49B0E537143DA9EAA097A00F','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0),('localhost','delicias_carro','*9F4A313C1CB94DBC49B0E537143DA9EAA097A00F','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0); /*!40000 ALTER TABLE `user` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `phpmyadmin` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phpmyadmin` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `phpmyadmin`; -- -- Table structure for table `pma_bookmark` -- DROP TABLE IF EXISTS `pma_bookmark`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_bookmark` ( `id` int(11) NOT NULL auto_increment, `dbase` varchar(255) collate utf8_bin NOT NULL default '', `user` varchar(255) collate utf8_bin NOT NULL default '', `label` varchar(255) character set utf8 NOT NULL default '', `query` text collate utf8_bin NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Bookmarks'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_bookmark` -- LOCK TABLES `pma_bookmark` WRITE; /*!40000 ALTER TABLE `pma_bookmark` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_bookmark` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_column_info` -- DROP TABLE IF EXISTS `pma_column_info`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_column_info` ( `id` int(5) unsigned NOT NULL auto_increment, `db_name` varchar(64) collate utf8_bin NOT NULL default '', `table_name` varchar(64) collate utf8_bin NOT NULL default '', `column_name` varchar(64) collate utf8_bin NOT NULL default '', `comment` varchar(255) character set utf8 NOT NULL default '', `mimetype` varchar(255) character set utf8 NOT NULL default '', `transformation` varchar(255) collate utf8_bin NOT NULL default '', `transformation_options` varchar(255) collate utf8_bin NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Comments for Columns'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_column_info` -- LOCK TABLES `pma_column_info` WRITE; /*!40000 ALTER TABLE `pma_column_info` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_column_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_designer_coords` -- DROP TABLE IF EXISTS `pma_designer_coords`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_designer_coords` ( `db_name` varchar(64) collate utf8_bin NOT NULL default '', `table_name` varchar(64) collate utf8_bin NOT NULL default '', `x` int(11) default NULL, `y` int(11) default NULL, `v` tinyint(4) default NULL, `h` tinyint(4) default NULL, PRIMARY KEY (`db_name`,`table_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for Designer'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_designer_coords` -- LOCK TABLES `pma_designer_coords` WRITE; /*!40000 ALTER TABLE `pma_designer_coords` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_designer_coords` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_history` -- DROP TABLE IF EXISTS `pma_history`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_history` ( `id` bigint(20) unsigned NOT NULL auto_increment, `username` varchar(64) collate utf8_bin NOT NULL default '', `db` varchar(64) collate utf8_bin NOT NULL default '', `table` varchar(64) collate utf8_bin NOT NULL default '', `timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `sqlquery` text collate utf8_bin NOT NULL, PRIMARY KEY (`id`), KEY `username` (`username`,`db`,`table`,`timevalue`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='SQL history'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_history` -- LOCK TABLES `pma_history` WRITE; /*!40000 ALTER TABLE `pma_history` DISABLE KEYS */; INSERT INTO `pma_history` VALUES (1,'root','delicias_carro','','2008-02-13 20:48:31','(SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(`Db` USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`db` WHERE CONVERT(\'delicias_carro\' USING utf8) LIKE CONVERT(`Db` USING utf8) AND NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) UNION (SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(\'*\' USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`user` WHERE NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) ORDER BY `User` ASC, `Host` ASC, `Db` ASC;'),(2,'root','','','2008-02-13 20:48:50','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(3,'root','','','2008-02-13 21:27:22','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(4,'root','','','2008-02-13 21:28:21','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` WHERE CONVERT(User USING utf8) LIKE CONVERT(\'D%\' USING utf8) OR CONVERT(User USING utf8) LIKE CONVERT(\'d%\' USING utf8) ORDER BY `User` ASC, `Host` ASC;'),(5,'root','','','2008-02-13 21:30:25','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(6,'root','','','2008-02-13 21:30:57','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(7,'root','delicias_carro','','2008-02-13 21:31:07','(SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(`Db` USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`db` WHERE CONVERT(\'delicias_carro\' USING utf8) LIKE CONVERT(`Db` USING utf8) AND NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) UNION (SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(\'*\' USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`user` WHERE NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) ORDER BY `User` ASC, `Host` ASC, `Db` ASC;'),(8,'root','','','2008-02-13 21:31:20','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(9,'root','','','2008-02-13 21:32:14','SELECT `User`, `Host`, IF(`Password` = _latin1 \'\', \'N\', \'Y\') AS \'Password\', `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Index_priv`, `Alter_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_user_priv`, `Create_routine_priv`, `Alter_routine_priv` FROM `mysql`.`user` ORDER BY `User` ASC, `Host` ASC;'),(10,'root','delicias_carro','','2008-02-13 21:32:21','(SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(`Db` USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`db` WHERE CONVERT(\'delicias_carro\' USING utf8) LIKE CONVERT(`Db` USING utf8) AND NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) UNION (SELECT CONVERT(`User` USING utf8) AS `User`, CONVERT(`Host` USING utf8) AS `Host`, CONVERT(\'*\' USING utf8) AS `Db`, CONVERT(Select_priv USING utf8) AS Select_priv, CONVERT(Insert_priv USING utf8) AS Insert_priv, CONVERT(Update_priv USING utf8) AS Update_priv, CONVERT(Delete_priv USING utf8) AS Delete_priv, CONVERT(Create_priv USING utf8) AS Create_priv, CONVERT(Drop_priv USING utf8) AS Drop_priv, CONVERT(Grant_priv USING utf8) AS Grant_priv, CONVERT(References_priv USING utf8) AS References_priv FROM `mysql`.`user` WHERE NOT (CONVERT(Select_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Insert_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Update_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Delete_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Create_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Drop_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(Grant_priv USING utf8) = CONVERT(\'N\' USING utf8) AND CONVERT(References_priv USING utf8) = CONVERT(\'N\' USING utf8))) ORDER BY `User` ASC, `Host` ASC, `Db` ASC;'),(11,'root','delicias_carro','geo_zone','2008-03-06 17:20:57','SELECT * FROM `geo_zone`'),(12,'root','delicias_carro','geo_zone','2008-03-06 17:21:25','SELECT * FROM `geo_zone`'),(13,'root','delicias_carro','geo_zone','2008-03-06 17:23:25','insert into zone_to_geo_zone values (0,138,2153,5,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2157,6,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2159,7,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2160,8,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2161,9,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2165,10,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2166,11,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2173,12,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2155,13,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2156,14,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2158,15,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2163,16,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2164,17,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2168,18,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2174,19,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,3842,20,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2151,21,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2151,22,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2152,23,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2154,24,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2158,25,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2162,26,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2171,27,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,28,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,29,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2148,30,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2150,31,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2169,32,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,33,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,34,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,35,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,36,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2175,37,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2150,38,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2167,39,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,40,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,41,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2146,42,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2146,43,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n'),(14,'root','delicias_carro','geo_zone','2008-03-06 17:24:23','insert into zone_to_geo_zone values (0,138,2153,44,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2157,45,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2159,46,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2160,47,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2161,48,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2165,49,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2166,50,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2173,51,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2155,52,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2156,53,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2158,54,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2163,55,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2164,56,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2168,57,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2174,58,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,3842,59,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2151,60,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2151,61,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2152,62,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2154,63,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2158,64,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2162,65,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2171,66,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,67,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,68,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2148,69,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2150,70,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2169,71,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,72,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,73,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,74,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2172,75,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2175,76,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2150,77,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2167,78,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,79,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2170,80,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2146,81,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n\r\ninsert into zone_to_geo_zone values (0,138,2146,82,\'2008-02-17 13:05:21\',\'2008-02-17 13:05:21\');# Filas afectadas: 1\n'),(15,'root','delicias_carro','zone_to_geo_zone','2008-03-06 17:24:36','SELECT * FROM `zone_to_geo_zone`'),(16,'root','delicias_carro','zone_to_geo_zone','2008-03-06 17:24:40','SELECT * FROM `zone_to_geo_zone`'),(17,'root','delicias_carro','geo_zone','2008-03-06 17:24:59','SELECT * FROM `geo_zone`'),(18,'root','delicias_carro','geo_zone','2008-03-06 17:25:03','SELECT * FROM `geo_zone`'),(19,'root','delicias_carro','zone_to_geo_zone','2008-03-06 17:25:31','SELECT * FROM `zone_to_geo_zone`'),(20,'root','delicias_carro','geo_zone','2008-03-07 00:34:11','SELECT * FROM `geo_zone`'),(21,'root','delicias_carro','country','2008-03-07 01:08:48','SELECT * FROM `country`'),(22,'root','delicias_carro','country','2008-03-07 01:09:13','select * from country'),(23,'root','delicias_carro','country','2008-03-07 01:09:43','SELECT * FROM `country` WHERE like \'%xico%0;'),(24,'root','delicias_carro','country','2008-03-07 01:09:52','SELECT * FROM `country` WHERE name like \'%xico%0;'),(25,'root','delicias_carro','country','2008-03-07 01:10:01','SELECT * FROM `country` WHERE name like \'%xico%;'),(26,'root','delicias_carro','country','2008-03-07 01:10:17','SELECT * FROM `country` WHERE name like \'%xico%\''),(27,'root','delicias_carro','country','2008-03-07 01:10:58','delete from zone where country_id <> 138'),(28,'root','delicias_carro','country','2008-03-07 01:11:45','delete FROM country WHERE country_id <> 138'),(29,'root','delicias_carro','country','2008-03-07 01:11:48','SELECT * FROM `country`'),(30,'root','delicias_carro','zone','2008-03-07 01:11:58','SELECT * FROM `zone`'); /*!40000 ALTER TABLE `pma_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_pdf_pages` -- DROP TABLE IF EXISTS `pma_pdf_pages`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_pdf_pages` ( `db_name` varchar(64) collate utf8_bin NOT NULL default '', `page_nr` int(10) unsigned NOT NULL auto_increment, `page_descr` varchar(50) character set utf8 NOT NULL default '', PRIMARY KEY (`page_nr`), KEY `db_name` (`db_name`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='PDF Relationpages for PMA'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_pdf_pages` -- LOCK TABLES `pma_pdf_pages` WRITE; /*!40000 ALTER TABLE `pma_pdf_pages` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_pdf_pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_relation` -- DROP TABLE IF EXISTS `pma_relation`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_relation` ( `master_db` varchar(64) collate utf8_bin NOT NULL default '', `master_table` varchar(64) collate utf8_bin NOT NULL default '', `master_field` varchar(64) collate utf8_bin NOT NULL default '', `foreign_db` varchar(64) collate utf8_bin NOT NULL default '', `foreign_table` varchar(64) collate utf8_bin NOT NULL default '', `foreign_field` varchar(64) collate utf8_bin NOT NULL default '', PRIMARY KEY (`master_db`,`master_table`,`master_field`), KEY `foreign_field` (`foreign_db`,`foreign_table`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Relation table'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_relation` -- LOCK TABLES `pma_relation` WRITE; /*!40000 ALTER TABLE `pma_relation` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_relation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_table_coords` -- DROP TABLE IF EXISTS `pma_table_coords`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_table_coords` ( `db_name` varchar(64) collate utf8_bin NOT NULL default '', `table_name` varchar(64) collate utf8_bin NOT NULL default '', `pdf_page_number` int(11) NOT NULL default '0', `x` float unsigned NOT NULL default '0', `y` float unsigned NOT NULL default '0', PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table coordinates for phpMyAdmin\n PDF output'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_table_coords` -- LOCK TABLES `pma_table_coords` WRITE; /*!40000 ALTER TABLE `pma_table_coords` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_table_coords` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pma_table_info` -- DROP TABLE IF EXISTS `pma_table_info`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `pma_table_info` ( `db_name` varchar(64) collate utf8_bin NOT NULL default '', `table_name` varchar(64) collate utf8_bin NOT NULL default '', `display_field` varchar(64) collate utf8_bin NOT NULL default '', PRIMARY KEY (`db_name`,`table_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table information for\n phpMyAdmin'; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `pma_table_info` -- LOCK TABLES `pma_table_info` WRITE; /*!40000 ALTER TABLE `pma_table_info` DISABLE KEYS */; /*!40000 ALTER TABLE `pma_table_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `test` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test`; -- -- Table structure for table `testaa` -- DROP TABLE IF EXISTS `testaa`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testaa` ( `id` int(11) NOT NULL default '0', `name` char(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testaa` -- LOCK TABLES `testaa` WRITE; /*!40000 ALTER TABLE `testaa` DISABLE KEYS */; INSERT INTO `testaa` VALUES (1,'Alligator Descartes'),(3,'Jochen Wiedmann'),(2,'Tim Bunce'),(4,'Andreas König'),(5,NULL),(6,'?'),(7,'?'); /*!40000 ALTER TABLE `testaa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testab` -- DROP TABLE IF EXISTS `testab`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testab` ( `id` int(11) NOT NULL default '0', `name` char(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testab` -- LOCK TABLES `testab` WRITE; /*!40000 ALTER TABLE `testab` DISABLE KEYS */; INSERT INTO `testab` VALUES (1,'Alligator Descartes'),(3,'Jochen Wiedmann'),(2,'Tim Bunce'),(4,'Andreas König'),(5,NULL),(6,'?'),(7,'?'); /*!40000 ALTER TABLE `testab` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testac` -- DROP TABLE IF EXISTS `testac`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testac` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testac` -- LOCK TABLES `testac` WRITE; /*!40000 ALTER TABLE `testac` DISABLE KEYS */; INSERT INTO `testac` VALUES (162,'test'); /*!40000 ALTER TABLE `testac` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testad` -- DROP TABLE IF EXISTS `testad`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testad` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testad` -- LOCK TABLES `testad` WRITE; /*!40000 ALTER TABLE `testad` DISABLE KEYS */; INSERT INTO `testad` VALUES (162,'test'); /*!40000 ALTER TABLE `testad` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testae` -- DROP TABLE IF EXISTS `testae`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testae` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testae` -- LOCK TABLES `testae` WRITE; /*!40000 ALTER TABLE `testae` DISABLE KEYS */; INSERT INTO `testae` VALUES (162,'test'); /*!40000 ALTER TABLE `testae` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testaf` -- DROP TABLE IF EXISTS `testaf`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testaf` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testaf` -- LOCK TABLES `testaf` WRITE; /*!40000 ALTER TABLE `testaf` DISABLE KEYS */; INSERT INTO `testaf` VALUES (162,'test'); /*!40000 ALTER TABLE `testaf` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testag` -- DROP TABLE IF EXISTS `testag`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testag` ( `a` int(11) NOT NULL default '0', `b` double default NULL, PRIMARY KEY (`a`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testag` -- LOCK TABLES `testag` WRITE; /*!40000 ALTER TABLE `testag` DISABLE KEYS */; INSERT INTO `testag` VALUES (10000,1.22),(10001,0.3333333); /*!40000 ALTER TABLE `testag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testah` -- DROP TABLE IF EXISTS `testah`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testah` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testah` -- LOCK TABLES `testah` WRITE; /*!40000 ALTER TABLE `testah` DISABLE KEYS */; INSERT INTO `testah` VALUES (162,'test'); /*!40000 ALTER TABLE `testah` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testai` -- DROP TABLE IF EXISTS `testai`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testai` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testai` -- LOCK TABLES `testai` WRITE; /*!40000 ALTER TABLE `testai` DISABLE KEYS */; INSERT INTO `testai` VALUES (162,'test'); /*!40000 ALTER TABLE `testai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testak` -- DROP TABLE IF EXISTS `testak`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `testak` ( `object_id` int(11) default NULL, `object_title` varchar(64) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `testak` -- LOCK TABLES `testak` WRITE; /*!40000 ALTER TABLE `testak` DISABLE KEYS */; INSERT INTO `testak` VALUES (162,'test'); /*!40000 ALTER TABLE `testak` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-06-08 2:39:24