-- MySQL dump 10.9 -- -- Host: localhost Database: artes11_loja -- ------------------------------------------------------ -- Server version 4.1.22-standard /*!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 */; /*!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 */; -- -- Table structure for table `address_book` -- DROP TABLE IF EXISTS `address_book`; CREATE TABLE `address_book` ( `address_book_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `entry_gender` char(1) NOT NULL default '', `entry_company` varchar(32) default NULL, `entry_firstname` varchar(32) NOT NULL default '', `entry_lastname` varchar(32) NOT NULL default '', `entry_street_address` varchar(64) NOT NULL default '', `entry_suburb` varchar(32) default NULL, `entry_postcode` varchar(10) NOT NULL default '', `entry_city` varchar(32) NOT NULL default '', `entry_state` varchar(32) default NULL, `entry_country_id` int(11) NOT NULL default '0', `entry_zone_id` int(11) NOT NULL default '0', PRIMARY KEY (`address_book_id`), KEY `idx_address_book_customers_id` (`customers_id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; -- -- Dumping data for table `address_book` -- LOCK TABLES `address_book` WRITE; /*!40000 ALTER TABLE `address_book` DISABLE KEYS */; INSERT INTO `address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES (4,4,'f',NULL,'Marcia','Rodrigues','Rua Caiowaá, 225','Perdizes','05018-000','São Paulo','',30,86),(5,5,'m',NULL,'sérgio','giichi hayashi','rua josé da silva, 1235, ap 11','jd.paulistano','14090-040','ribeirão preto','',30,86),(6,6,'f',NULL,'tere','silveira','santa cruz','centro','13300140','itu','',30,86),(7,7,'m',NULL,'Jair A Cvilikas','Cvilikas','rua Araci Vaz Callado 1371','Estreito','88070-750','Florianopolis','',30,85),(8,6,'f',NULL,'terezinha','assugeni','rua madre maria theodora 290','centro','13300140','itu','',30,86),(9,8,'m',NULL,'Ricardo Aparecido','Alves','Rua Bacurizinho 96','Jaçanã','02227-070','São Paulo','',30,86),(10,9,'m',NULL,'Kyle','Andrade','SQS 205 BLOCO K','ASA SUL','70235110','BRASILIA','',30,68),(11,10,'m',NULL,'CARLOS','SOUZA','r:brasilia 179','atalaia','06700590','cotia','',30,86); /*!40000 ALTER TABLE `address_book` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `address_format` -- DROP TABLE IF EXISTS `address_format`; CREATE TABLE `address_format` ( `address_format_id` int(11) NOT NULL auto_increment, `address_format` varchar(128) NOT NULL default '', `address_summary` varchar(48) NOT NULL default '', PRIMARY KEY (`address_format_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `address_format` -- LOCK TABLES `address_format` WRITE; /*!40000 ALTER TABLE `address_format` DISABLE KEYS */; INSERT INTO `address_format` (`address_format_id`, `address_format`, `address_summary`) VALUES (1,'$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'),(2,'$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'),(3,'$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'),(4,'$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country','$postcode / $country'),(5,'$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); /*!40000 ALTER TABLE `address_format` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banners` -- DROP TABLE IF EXISTS `banners`; CREATE TABLE `banners` ( `banners_id` int(11) NOT NULL auto_increment, `banners_title` varchar(64) NOT NULL default '', `banners_url` varchar(255) NOT NULL default '', `banners_image` varchar(64) NOT NULL default '', `banners_group` varchar(10) NOT NULL default '', `banners_html_text` text, `expires_impressions` int(7) default '0', `expires_date` datetime default NULL, `date_scheduled` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', PRIMARY KEY (`banners_id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; -- -- Dumping data for table `banners` -- LOCK TABLES `banners` WRITE; /*!40000 ALTER TABLE `banners` DISABLE KEYS */; INSERT INTO `banners` (`banners_id`, `banners_title`, `banners_url`, `banners_image`, `banners_group`, `banners_html_text`, `expires_impressions`, `expires_date`, `date_scheduled`, `date_added`, `date_status_change`, `status`) VALUES (2,'PHPmania','http://www.phpmania.org','banners/oscommerce.gif','468x50','',0,NULL,NULL,'2004-10-21 07:35:27',NULL,1); /*!40000 ALTER TABLE `banners` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banners_history` -- DROP TABLE IF EXISTS `banners_history`; CREATE TABLE `banners_history` ( `banners_history_id` int(11) NOT NULL auto_increment, `banners_id` int(11) NOT NULL default '0', `banners_shown` int(5) NOT NULL default '0', `banners_clicked` int(5) NOT NULL default '0', `banners_history_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`banners_history_id`) ) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=latin1; -- -- Dumping data for table `banners_history` -- LOCK TABLES `banners_history` WRITE; /*!40000 ALTER TABLE `banners_history` DISABLE KEYS */; INSERT INTO `banners_history` (`banners_history_id`, `banners_id`, `banners_shown`, `banners_clicked`, `banners_history_date`) VALUES (1,2,23,0,'2007-04-19 21:54:13'),(2,2,129,0,'2007-04-20 09:28:12'),(3,2,12,0,'2007-04-21 14:09:09'),(4,2,15,0,'2007-04-22 13:22:28'),(5,2,64,0,'2007-04-23 10:00:40'),(6,2,64,0,'2007-04-24 00:13:37'),(7,2,8,0,'2007-04-25 16:07:48'),(8,2,11,0,'2007-04-26 09:25:32'),(9,2,1,0,'2007-04-27 09:10:52'),(10,2,54,1,'2007-04-28 02:19:14'),(11,2,37,0,'2007-04-29 11:37:05'),(12,2,17,0,'2007-04-30 00:33:44'),(13,2,22,0,'2007-05-01 06:08:29'),(14,2,78,0,'2007-05-02 00:07:32'),(15,2,54,0,'2007-05-03 00:41:14'),(16,2,56,0,'2007-05-04 01:24:27'),(17,2,31,0,'2007-05-05 00:31:51'),(18,2,35,0,'2007-05-06 11:38:59'),(19,2,41,0,'2007-05-07 00:53:03'),(20,2,147,0,'2007-05-08 00:19:15'),(21,2,101,0,'2007-05-09 00:00:10'),(22,2,122,0,'2007-05-10 00:06:01'),(23,2,57,0,'2007-05-11 00:08:10'),(24,2,19,0,'2007-05-12 00:10:27'),(25,2,24,0,'2007-05-13 00:18:21'),(26,2,33,0,'2007-05-14 02:25:19'),(27,2,11,0,'2007-05-15 03:21:20'),(28,2,10,0,'2007-05-16 07:34:24'),(29,2,38,0,'2007-05-17 01:12:31'),(30,2,67,1,'2007-05-18 00:59:22'),(31,2,68,0,'2007-05-19 00:25:20'),(32,2,58,0,'2007-05-20 01:41:27'),(33,2,24,0,'2007-05-21 00:00:31'),(34,2,58,0,'2007-05-22 01:47:38'),(35,2,56,0,'2007-05-23 00:06:23'),(36,2,113,0,'2007-05-24 00:18:02'),(37,2,38,0,'2007-05-25 00:55:42'),(38,2,9,0,'2007-05-26 14:00:05'),(39,2,85,0,'2007-05-27 00:25:22'),(40,2,30,0,'2007-05-28 13:07:28'),(41,2,58,0,'2007-05-29 00:29:58'),(42,2,85,0,'2007-05-30 00:22:47'),(43,2,40,1,'2007-05-31 00:30:37'),(44,2,33,1,'2007-06-01 02:36:16'),(45,2,38,0,'2007-06-02 00:46:17'),(46,2,30,1,'2007-06-03 00:02:23'),(47,2,18,0,'2007-06-04 08:47:26'),(48,2,7,1,'2007-06-05 00:35:17'),(49,2,38,1,'2007-06-06 07:18:06'),(50,2,21,0,'2007-06-07 14:29:53'),(51,2,34,0,'2007-06-08 00:36:15'),(52,2,33,1,'2007-06-09 00:53:14'),(53,2,24,0,'2007-06-10 00:05:25'),(54,2,35,0,'2007-06-11 01:03:01'),(55,2,34,0,'2007-06-12 01:45:40'),(56,2,38,0,'2007-06-13 08:07:50'),(57,2,38,0,'2007-06-14 06:33:44'),(58,2,14,0,'2007-06-15 03:01:10'),(59,2,12,0,'2007-06-16 14:05:55'),(60,2,2,0,'2007-06-17 04:10:50'),(61,2,41,0,'2007-06-18 10:39:03'),(62,2,4,0,'2007-06-19 01:57:36'),(63,2,83,0,'2007-06-20 01:26:03'),(64,2,17,0,'2007-06-21 00:07:36'),(65,2,15,0,'2007-06-22 09:05:22'),(66,2,55,0,'2007-06-23 00:09:48'),(67,2,23,0,'2007-06-24 00:13:37'),(68,2,31,0,'2007-06-25 00:26:34'),(69,2,18,0,'2007-06-26 00:09:10'),(70,2,94,2,'2007-06-27 00:22:23'),(71,2,42,0,'2007-06-28 00:34:53'),(72,2,91,0,'2007-06-29 00:03:30'),(73,2,53,1,'2007-06-30 03:05:46'),(74,2,94,0,'2007-07-01 00:48:36'),(75,2,81,0,'2007-07-02 01:56:17'),(76,2,54,0,'2007-07-03 00:10:03'),(77,2,77,1,'2007-07-04 03:53:34'),(78,2,40,1,'2007-07-05 01:27:01'),(79,2,61,0,'2007-07-06 00:28:34'),(80,2,58,0,'2007-07-07 00:00:38'),(81,2,30,0,'2007-07-08 00:30:33'),(82,2,10,0,'2007-07-09 07:55:58'),(83,2,40,0,'2007-07-10 00:01:36'),(84,2,25,0,'2007-07-11 02:45:48'),(85,2,43,0,'2007-07-12 01:35:35'),(86,2,57,1,'2007-07-13 00:08:51'),(87,2,18,0,'2007-07-14 00:30:56'),(88,2,31,0,'2007-07-15 01:56:01'),(89,2,47,0,'2007-07-16 02:14:19'),(90,2,75,0,'2007-07-17 00:14:52'),(91,2,15,0,'2007-07-18 00:19:03'),(92,2,54,1,'2007-07-19 00:14:06'),(93,2,31,0,'2007-07-20 00:40:50'),(94,2,87,0,'2007-07-21 00:21:19'),(95,2,71,0,'2007-07-22 02:12:18'),(96,2,74,0,'2007-07-23 00:05:26'),(97,2,40,0,'2007-07-24 02:51:44'),(98,2,49,2,'2007-07-25 01:23:36'),(99,2,76,0,'2007-07-26 00:40:01'),(100,2,121,0,'2007-07-27 00:09:55'),(101,2,72,1,'2007-07-28 00:51:49'),(102,2,131,0,'2007-07-29 03:01:26'),(103,2,87,0,'2007-07-30 01:03:13'),(104,2,104,1,'2007-07-31 01:52:35'),(105,2,75,1,'2007-08-01 00:06:34'),(106,2,52,0,'2007-08-02 00:49:39'),(107,2,45,0,'2007-08-03 00:22:33'),(108,2,30,0,'2007-08-04 00:49:54'),(109,2,84,2,'2007-08-05 01:02:20'),(110,2,33,0,'2007-08-06 00:52:30'),(111,2,69,0,'2007-08-07 00:26:31'),(112,2,96,0,'2007-08-08 00:22:28'),(113,2,52,0,'2007-08-09 00:24:07'); /*!40000 ALTER TABLE `banners_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; CREATE TABLE `categories` ( `categories_id` int(11) NOT NULL auto_increment, `categories_image` varchar(64) default NULL, `parent_id` int(11) NOT NULL default '0', `sort_order` int(3) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`categories_id`), KEY `idx_categories_parent_id` (`parent_id`) ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=latin1; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` (`categories_id`, `categories_image`, `parent_id`, `sort_order`, `date_added`, `last_modified`) VALUES (22,'11111.jpg',0,2,'2007-04-20 12:36:21','2007-05-02 00:51:38'),(23,'11110.JPG',0,4,'2007-04-20 12:36:58','2007-05-02 00:53:22'),(25,'jus.jpg',0,3,'2007-04-24 00:53:34','2007-05-02 00:52:12'),(26,'111121.jpg',0,1,'2007-04-30 01:43:41','2007-05-02 00:53:58'),(27,'121.jpg',0,5,'2007-05-02 00:56:40',NULL),(32,NULL,0,8,'2007-05-11 00:29:19',NULL),(30,'1.jpg',0,7,'2007-05-02 17:52:24','2007-05-02 18:00:43'),(31,NULL,0,0,'2007-05-02 17:56:03',NULL),(34,NULL,0,0,'2007-08-03 21:06:52',NULL); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories_description` -- DROP TABLE IF EXISTS `categories_description`; CREATE TABLE `categories_description` ( `categories_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `categories_name` varchar(32) NOT NULL default '', PRIMARY KEY (`categories_id`,`language_id`), KEY `idx_categories_name` (`categories_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `categories_description` -- LOCK TABLES `categories_description` WRITE; /*!40000 ALTER TABLE `categories_description` DISABLE KEYS */; INSERT INTO `categories_description` (`categories_id`, `language_id`, `categories_name`) VALUES (31,4,'FONTES DE RESINA'),(23,4,'AGUIAS'),(22,4,'CAVALOS'),(26,4,'LUMINARIAS'),(25,4,'JUSTIÇAS'),(27,4,'LEÃO'),(32,4,'TROFÉU'),(30,4,'DECORATIVA'),(34,4,'FRUTEIRAS'); /*!40000 ALTER TABLE `categories_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `configuration` -- DROP TABLE IF EXISTS `configuration`; CREATE TABLE `configuration` ( `configuration_id` int(11) NOT NULL auto_increment, `configuration_title` varchar(64) NOT NULL default '', `configuration_key` varchar(64) NOT NULL default '', `configuration_value` varchar(255) NOT NULL default '', `configuration_description` varchar(255) NOT NULL default '', `configuration_group_id` int(11) NOT NULL default '0', `sort_order` int(5) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `use_function` varchar(255) default NULL, `set_function` varchar(255) default NULL, PRIMARY KEY (`configuration_id`) ) ENGINE=MyISAM AUTO_INCREMENT=1316 DEFAULT CHARSET=latin1; -- -- Dumping data for table `configuration` -- LOCK TABLES `configuration` WRITE; /*!40000 ALTER TABLE `configuration` DISABLE KEYS */; INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (1,'Nome da Loja','STORE_NAME','Tudo em Arte - Loja Virtual','O nome da sua loja',1,1,'2007-05-05 00:34:42','2004-10-03 10:13:34',NULL,NULL),(2,'Nome do Proprietário','STORE_OWNER','Valter Araujo','Nome do Proprietário da Loja',1,2,'2007-04-20 09:06:13','2004-10-03 10:13:34',NULL,NULL),(3,'E-Mail do Proprietário','STORE_OWNER_EMAIL_ADDRESS','clayton@tudoemarte.com','E-mail do proprietário da loja',1,3,'2007-05-05 00:31:01','2004-10-03 10:13:34',NULL,NULL),(4,'E-Mail dos pedidos','EMAIL_FROM','TudoemArte ','E-mail usado para o envio dos pedidos',1,4,'2007-05-05 00:28:09','2004-10-03 10:13:34',NULL,NULL),(5,'País','STORE_COUNTRY','30','País onde a loja está localizada',1,6,'2004-10-04 19:07:11','2004-10-03 10:13:34','tep_get_country_name','tep_cfg_pull_down_country_list('),(6,'Estado','STORE_ZONE','86','Estado onde a loja está localizada',1,7,'2007-04-20 09:07:43','2004-10-03 10:13:34','tep_cfg_get_zone_name','tep_cfg_pull_down_zone_list('),(7,'Ordem dos produtos','EXPECTED_PRODUCTS_SORT','asc','Esta é a ordem usada na caixa de seleção dos produtos',1,8,'2007-06-20 20:23:45','2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'asc\', \'desc\'),'),(8,'Como aparecerá a ordem dos produtos','EXPECTED_PRODUCTS_FIELD','date_expected','A ordem dos produtos que são mostrados',1,9,'2007-06-20 20:21:09','2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'products_name\', \'date_expected\'),'),(9,'Trocar a moeda corrente do idioma para padrão','USE_DEFAULT_LANGUAGE_CURRENCY','false','Mudar automaticamente para a moeda corrente padrão do idioma quando for mudado',1,10,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(10,'Avisar pedidos por e-mail','SEND_EXTRA_ORDER_EMAILS_TO','name 1 ,name 2 ','Enviar aviso para o e-mail da loja quando pedidos forem realizados: Name 1 <email@address1>, Name 2 <email@address2>',1,11,'2007-05-08 17:37:53','2004-10-03 10:13:34',NULL,NULL),(11,'Usar Search-Engine URLs Seguros (ainda em desenvolvimento)','SEARCH_ENGINE_FRIENDLY_URLS','false','Usar search-engine URLs seguros para todos links de site',1,12,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(12,'Mostrar produtos comprados','DISPLAY_CART','true','Mostrar todos os produtos depois de feito o pedido',1,14,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(13,'Enviar página para um amigo','ALLOW_GUEST_TO_TELL_A_FRIEND','true','Permitir que o visitante envie informações da loja e produtos para amigo',1,15,'2004-10-25 19:09:09','2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(14,'Usar o método de busca padrão','ADVANCED_SEARCH_DEFAULT_OPERATOR','and','Método de busca padrão',1,17,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'and\', \'or\'),'),(15,'Endereço e Telefone da loja','STORE_NAME_ADDRESS','TUDO EM ARTE\r\nR:BRASILIA 179 ATALAIA COTIA \r\nTEL : (11)46140794-46162645','Isto é o Nome de Loja, Endereço e Telefona para ser usado em documentos imprimíveis e exibidos online',1,18,'2007-04-30 01:26:17','2004-10-03 10:13:34',NULL,'tep_cfg_textarea('),(16,'Mostrar Quantidades nas categorias','SHOW_COUNTS','true','Mostra quantos produtos estão em cada categoria',1,19,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(17,'Taxas e Impostos','TAX_DECIMAL_PLACES','0','Adicionar o valor da taxa a ser cobrado',1,20,NULL,'2004-10-03 10:13:34',NULL,NULL),(18,'Mostrar preços com taxas','DISPLAY_PRICE_WITH_TAX','false','Mostrar preço com taxas(impostos) se tiver?',1,21,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(19,'Primeiro nome','ENTRY_FIRST_NAME_MIN_LENGTH','4','Quantidade mínima de letras para o primeiro nome',2,1,'2004-10-25 19:09:49','2004-10-03 10:13:34',NULL,NULL),(20,'Sobrenome','ENTRY_LAST_NAME_MIN_LENGTH','3','Quantidade mínima de letras para o sobrenome',2,2,'2004-10-25 19:10:06','2004-10-03 10:13:34',NULL,NULL),(21,'Data de Nascimento','ENTRY_DOB_MIN_LENGTH','10','Quantidade mínima de letras para a data',2,3,NULL,'2004-10-03 10:13:34',NULL,NULL),(22,'Seu E-Mail','ENTRY_EMAIL_ADDRESS_MIN_LENGTH','6','Quantidade mínima de letras para o e-mail',2,4,'2004-10-25 19:12:23','2004-10-03 10:13:34',NULL,NULL),(23,'Endereço','ENTRY_STREET_ADDRESS_MIN_LENGTH','5','Quantidade mínima de letras para o endereço',2,5,NULL,'2004-10-03 10:13:34',NULL,NULL),(24,'Empresa','ENTRY_COMPANY_MIN_LENGTH','2','Quantidade mínima de letras para o nome da Empresa',2,6,NULL,'2004-10-03 10:13:34',NULL,NULL),(25,'CEP','ENTRY_POSTCODE_MIN_LENGTH','8','Quantidade mínima de letras para o CEP',2,7,'2004-10-25 19:11:22','2004-10-03 10:13:34',NULL,NULL),(26,'Cidade','ENTRY_CITY_MIN_LENGTH','3','Quantidade mínima de letras para a Cidade',2,8,NULL,'2004-10-03 10:13:34',NULL,NULL),(27,'Estado','ENTRY_STATE_MIN_LENGTH','2','Quantidade mínima de letras para o estado',2,9,NULL,'2004-10-03 10:13:34',NULL,NULL),(28,'Número do Telefone','ENTRY_TELEPHONE_MIN_LENGTH','5','Quantidade mínima de números para o telefone',2,10,'2004-10-25 19:13:08','2004-10-03 10:13:34',NULL,NULL),(29,'Senha','ENTRY_PASSWORD_MIN_LENGTH','5','Quantidade mínima de letras para a senha',2,11,NULL,'2004-10-03 10:13:34',NULL,NULL),(30,'Nome do Titular do Cartão','CC_OWNER_MIN_LENGTH','3','Quantidade mínima de letras do nome do titular do cartão',2,12,NULL,'2004-10-03 10:13:34',NULL,NULL),(31,'Número do cartão de Crédito','CC_NUMBER_MIN_LENGTH','10','Quantidade mínima de números para o cartão de crédito',2,13,NULL,'2004-10-03 10:13:34',NULL,NULL),(32,'Comentários','REVIEW_TEXT_MIN_LENGTH','10','Quantidade mínima de letras em um comentário',2,14,'2004-10-26 06:18:39','2004-10-03 10:13:34',NULL,NULL),(33,'Mais Vendidos','MIN_DISPLAY_BESTSELLERS','1','Número mínimo de mais vendidos para exibição',2,15,NULL,'2004-10-03 10:13:34',NULL,NULL),(34,'Também Compraram','MIN_DISPLAY_ALSO_PURCHASED','1','Número mínimo de produtos para exibição em \\\'Clientes também Compraram\\\' box',2,16,NULL,'2004-10-03 10:13:34',NULL,NULL),(35,'Livro de Endereços','MAX_ADDRESS_BOOK_ENTRIES','5','Número máximo de endereços de entrega que um cliente pode ter',3,1,NULL,'2004-10-03 10:13:34',NULL,NULL),(36,'Resultado da Busca','MAX_DISPLAY_SEARCH_RESULTS','20','Número máximo de produtos a serem listados',3,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(37,'Links','MAX_DISPLAY_PAGE_LINKS','5','Número máximo de links em uma página',3,3,NULL,'2004-10-03 10:13:34',NULL,NULL),(38,'Ofertas','MAX_DISPLAY_SPECIAL_PRODUCTS','9','Máximo número de ofertas a serem exibidas',3,4,NULL,'2004-10-03 10:13:34',NULL,NULL),(39,'Novidades','MAX_DISPLAY_NEW_PRODUCTS','21','Máximo número de novos produtos a serem exibidos em uma categoria',3,5,'2007-05-27 01:32:03','2004-10-03 10:13:34',NULL,NULL),(40,'Lançamentos','MAX_DISPLAY_UPCOMING_PRODUCTS','10','Números máximo de lançamentos a serem exibidos',3,6,NULL,'2004-10-03 10:13:34',NULL,NULL),(41,'Lista de Fabricantes','MAX_DISPLAY_MANUFACTURERS_IN_A_LIST','0','Usado no box dos fabricantes; quando o número de fabricantes exceder este número o menu passará a ser de seleção',3,7,NULL,'2004-10-03 10:13:34',NULL,NULL),(42,'Tamanho da Caixa de seleção de fabricantes','MAX_MANUFACTURERS_LIST','1','Usado no box dos fabricantes; quando o valor é \\\'1\\\' a drop-down list é utilizada no box dos fabricantes.',3,7,NULL,'2004-10-03 10:13:34',NULL,NULL),(43,'Tamanho máximo do nome do Fabricante','MAX_DISPLAY_MANUFACTURER_NAME_LEN','15','Usado no box dos fabricantes; máximo número de letras do nome do fabricante a ser exibido',3,8,NULL,'2004-10-03 10:13:34',NULL,NULL),(44,'Comentários','MAX_DISPLAY_NEW_REVIEWS','6','Número máximo de comentários a serem exibidos',3,9,NULL,'2004-10-03 10:13:34',NULL,NULL),(45,'Seleção randômica de comentários','MAX_RANDOM_SELECT_REVIEWS','10','Número de comentários que serão utilizados na seleção',3,10,NULL,'2004-10-03 10:13:34',NULL,NULL),(46,'Seleção Randômica de Novidades','MAX_RANDOM_SELECT_NEW','10','Número de comentários que serão utilizados na seleção',3,11,NULL,'2004-10-03 10:13:34',NULL,NULL),(47,'Seleção Randômica de Ofertas','MAX_RANDOM_SELECT_SPECIALS','10','Quantos registros serão utilizados para selecionar ofertas a serem exibidas',3,12,NULL,'2004-10-03 10:13:34',NULL,NULL),(48,'Categorias a serem listadas','MAX_DISPLAY_CATEGORIES_PER_ROW','7','Número de categorias a serem listadas por fila',3,13,'2007-05-02 17:54:31','2004-10-03 10:13:34',NULL,NULL),(49,'Lista de Novos Produtos','MAX_DISPLAY_PRODUCTS_NEW','10','Número máximo de produtos a serem listados na página de novos produtos',3,14,'2007-05-02 00:48:57','2004-10-03 10:13:34',NULL,NULL),(50,'Mais Vendidos','MAX_DISPLAY_BESTSELLERS','5','Máximo número de mais vendidos a serem exibidos',3,15,'2004-10-10 21:07:24','2004-10-03 10:13:34',NULL,NULL),(51,'Também compraram','MAX_DISPLAY_ALSO_PURCHASED','6','Máximo número de indicações a serem exibidos no box \\\'Clientes também compraram\\\' box',3,16,NULL,'2004-10-03 10:13:34',NULL,NULL),(52,'Historico do Pedido do Cliente','MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX','6','Número máximo dos produtos a mostrar na caixa do histórico do pedido do cliente',3,17,NULL,'2004-10-03 10:13:34',NULL,NULL),(53,'Histórico do Pedido','MAX_DISPLAY_ORDER_HISTORY','10','Mostrar número máximo de pedidos na página do histórico de pedido',3,18,NULL,'2004-10-03 10:13:34',NULL,NULL),(54,'Largura da Imagem Pequena','SMALL_IMAGE_WIDTH','0','Em pixels',4,1,'2007-04-20 09:12:58','2004-10-03 10:13:34',NULL,NULL),(55,'Altura da Imagem Pequena','SMALL_IMAGE_HEIGHT','170','Em pixels',4,2,'2007-04-24 15:22:40','2004-10-03 10:13:34',NULL,NULL),(56,'Largura da Imagem do Cabeçalho','HEADING_IMAGE_WIDTH','0','Em pixels',4,3,'2007-04-20 16:46:23','2004-10-03 10:13:34',NULL,NULL),(57,'Altura da Imagem do Cabeçalho','HEADING_IMAGE_HEIGHT','60','Em pixels',4,4,'2007-04-20 12:51:34','2004-10-03 10:13:34',NULL,NULL),(58,'Largura da Imagem da Subcategoria','SUBCATEGORY_IMAGE_WIDTH','100','Em pixels',4,5,NULL,'2004-10-03 10:13:34',NULL,NULL),(59,'Altura da Imagem da Subcategoria','SUBCATEGORY_IMAGE_HEIGHT','57','Em pixels',4,6,NULL,'2004-10-03 10:13:34',NULL,NULL),(60,'Calcular tamanho da Imagem','CONFIG_CALCULATE_IMAGE_SIZE','true','Calcula o tamanho da imagem?',4,7,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(61,'Imagem Obrigatória','IMAGE_REQUIRED','true','Abilitar inserção obrigatória de imagens.',4,8,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(62,'Sexo (Masculino/Feminino)','ACCOUNT_GENDER','true','Ativar Sexo no cadastro de clientess',5,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(63,'Data de Nascimento','ACCOUNT_DOB','true','Ativar Data de nascimento no cadastro de clientes',5,2,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(64,'Empresa','ACCOUNT_COMPANY','false','Ativar Detalhes da Empresa no cadastro de clientes',5,3,'2004-10-15 06:56:52','2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(65,'Bairro','ACCOUNT_SUBURB','true','Ativar Bairro no cadastro de clientes',5,4,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(66,'Estado','ACCOUNT_STATE','true','Ativar Estado no cadastro de clientes',5,5,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(67,'Módulos instalados','MODULE_PAYMENT_INSTALLED','transferencia.php','Lista os arquivos de módulos de pagamento separados por um ponto e virgula. Esta listagem é automática.',6,0,'2007-04-20 17:26:24','2004-10-03 10:13:34',NULL,NULL),(68,'Installed Modules','MODULE_ORDER_TOTAL_INSTALLED','ot_subtotal.php;ot_shipping.php;ot_tax.php;ot_total.php','List of order_total module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ot_subtotal.php;ot_tax.php;ot_shipping.php;ot_total.php)',6,0,'2004-10-13 07:53:18','2004-10-03 10:13:34',NULL,NULL),(69,'Módulos instalados','MODULE_SHIPPING_INSTALLED','','Lista os arquivos de módulos de frete separados por um ponto e virgula. Esta listagem é automática.',6,0,'2004-10-26 21:55:56','2004-10-03 10:13:34',NULL,NULL),(84,'Default Currency','DEFAULT_CURRENCY','BR','Default Currency',6,0,NULL,'2004-10-03 10:13:34',NULL,NULL),(85,'Default Language','DEFAULT_LANGUAGE','br','Default Language',6,0,NULL,'2004-10-03 10:13:34',NULL,NULL),(86,'Default Order Status For New Orders','DEFAULT_ORDERS_STATUS_ID','1','When a new order is created, this order status will be assigned to it.',6,0,NULL,'2004-10-03 10:13:34',NULL,NULL),(87,'Display Shipping','MODULE_ORDER_TOTAL_SHIPPING_STATUS','true','Do you want to display the order shipping cost?',6,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(88,'Sort Order','MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER','2','Sort order of display.',6,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(89,'Allow Free Shipping','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING','false','Do you want to allow free shipping?',6,3,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(90,'Free Shipping For Orders Over','MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER','50','Provide free shipping for orders over the set amount.',6,4,NULL,'2004-10-03 10:13:34','currencies->format',NULL),(91,'Provide Free Shipping For Orders Made','MODULE_ORDER_TOTAL_SHIPPING_DESTINATION','national','Provide free shipping for orders sent to the set destination.',6,5,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'national\', \'international\', \'both\'),'),(92,'Display Sub-Total','MODULE_ORDER_TOTAL_SUBTOTAL_STATUS','true','Do you want to display the order sub-total cost?',6,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(93,'Sort Order','MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER','1','Sort order of display.',6,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(94,'Display Tax','MODULE_ORDER_TOTAL_TAX_STATUS','true','Do you want to display the order tax value?',6,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(95,'Sort Order','MODULE_ORDER_TOTAL_TAX_SORT_ORDER','3','Sort order of display.',6,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(96,'Display Total','MODULE_ORDER_TOTAL_TOTAL_STATUS','true','Do you want to display the total order value?',6,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(97,'Sort Order','MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER','4','Sort order of display.',6,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(98,'Código do País','SHIPPING_ORIGIN_COUNTRY','30','Entre o "ISO 3166" código do país onde se localiza a sua loja.',7,1,NULL,'2004-10-03 10:13:34','tep_get_country_name','tep_cfg_pull_down_country_list('),(99,'CEP','SHIPPING_ORIGIN_ZIP','06700590','Entre o CEP de sua Loja.',7,2,'2007-04-20 09:14:09','2004-10-03 10:13:34',NULL,NULL),(100,'Entre o peso máximo do pacote que irá entregar','SHIPPING_MAX_WEIGHT','50','Carriers have a max weight limit for a single package. This is a common one for all.',7,3,NULL,'2004-10-03 10:13:34',NULL,NULL),(101,'Peso Normal dos Pacotes.','SHIPPING_BOX_WEIGHT','','Qual é o peso normal dos pacotes que costuma entregar?',7,4,'2004-10-20 07:03:51','2004-10-03 10:13:34',NULL,NULL),(102,'Pacotes grandes Incrementar porcentagem.','SHIPPING_BOX_PADDING','0','Se for 10% coloque 10',7,5,'2004-10-20 07:04:03','2004-10-03 10:13:34',NULL,NULL),(103,'Mostrar Imagem do Produto','PRODUCT_LIST_IMAGE','1','Escolha 1 para sim ou 0 para não',8,1,NULL,'2004-10-03 10:13:34',NULL,NULL),(104,'Mostrar nome dos Fabricantes','PRODUCT_LIST_MANUFACTURER','0','Escolha 1 para sim ou 0 para não',8,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(105,'Mostrar modelo dos produtos','PRODUCT_LIST_MODEL','0','Escolha 1 para sim ou 0 para não',8,3,NULL,'2004-10-03 10:13:34',NULL,NULL),(106,'Mostrar nome dos produtos','PRODUCT_LIST_NAME','2','Escolha 1 para sim ou 0 para não',8,4,NULL,'2004-10-03 10:13:34',NULL,NULL),(107,'Exibir preços dos produtos','PRODUCT_LIST_PRICE','3','Escolha 1 para sim ou 0 para não',8,5,NULL,'2004-10-03 10:13:34',NULL,NULL),(108,'Mostrar quantidade dos produtos','PRODUCT_LIST_QUANTITY','0','Escolha 1 para sim ou 0 para não',8,6,NULL,'2004-10-03 10:13:34',NULL,NULL),(109,'Mostrar peso dos produtos','PRODUCT_LIST_WEIGHT','0','Escolha 1 para sim ou 0 para não',8,7,NULL,'2004-10-03 10:13:34',NULL,NULL),(110,'Mostrar coluna Compre Agora','PRODUCT_LIST_BUY_NOW','4','Escolha 1 para sim ou 0 para não',8,8,NULL,'2004-10-03 10:13:34',NULL,NULL),(111,'Exibir filtros categorias/fabricantes','PRODUCT_LIST_FILTER','1','Escolha 1 para sim ou 0 para não',8,9,NULL,'2004-10-03 10:13:34',NULL,NULL),(112,'Escolha a localização dos botões Anterior/Próxima','PREV_NEXT_BAR_LOCATION','2','1-topo, 2-em baixo, 3-nos dois lugares',8,10,NULL,'2004-10-03 10:13:34',NULL,NULL),(113,'Checar Estoque','STOCK_CHECK','true','Ativar checagem do estoque',9,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(114,'Subtrair do Estoque','STOCK_LIMITED','true','Subtrair produto do estoque quando for realizado um pedido',9,2,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(115,'Permitir ir ao caixa','STOCK_ALLOW_CHECKOUT','true','Permitir cliente ir ao caixa mesmo quando o estoque for insuficiente',9,3,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(116,'Marcar produtos fora de estoque','STOCK_MARK_PRODUCT_OUT_OF_STOCK','***','Exibir *** quando o produto não estiver disponível em estoque',9,4,NULL,'2004-10-03 10:13:34',NULL,NULL),(117,'Estoque baixo','STOCK_REORDER_LEVEL','5','Defina a quantidade crítica do seu estoque',9,5,NULL,'2004-10-03 10:13:34',NULL,NULL),(118,'Analisar o tempo na página da loja','STORE_PAGE_PARSE_TIME','false','Armazene o tempo que leva para analisar uma página',10,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(119,'Destino do log','STORE_PAGE_PARSE_TIME_LOG','/var/log/www/tep/page_parse_time.log','O diretório e nome do arquivo da página que analisará o tempo do log',10,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(120,'Formato da data do log','STORE_PARSE_DATE_TIME_FORMAT','%d/%m/%Y %H:%M:%S','O formato da data',10,3,NULL,'2004-10-03 10:13:34',NULL,NULL),(121,'Mostrar a página analise tempo','DISPLAY_PAGE_PARSE_TIME','true','Mostrar a página analise tempo (Deve estar habilitado)',10,4,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(122,'Armazene as informações do banco de dados','STORE_DB_TRANSACTIONS','false','Armazene as informações do banco de dados na página analise do tempo do log (PHP4 somente)',10,5,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(123,'Use Cache','USE_CACHE','false','Características use caching',11,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(124,'Diretório do cache','DIR_FS_CACHE','/tmp/','O diretório onde o arquivos cached serão armazenados',11,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(125,'E-Mail método de envio','EMAIL_TRANSPORT','sendmail','Defina se este servidor usa uma conexão de local para sendmail ou usa uma conexão de SMTP via TCP/IP. Os servidores que executam em Windows e MacOS deveram mudar este configurando para SMTP.',12,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),'),(126,'E-Mail Linefeeds','EMAIL_LINEFEED','LF','Defina a seqüência de caractere costuma-se separar cabeçalhos do email.',12,2,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'LF\', \'CRLF\'),'),(127,'Use MIME HTML quando enviar Emails','EMAIL_USE_HTML','false','Enviar e-mails em formato HTML',12,3,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(128,'Verifique endereços de E-mail por DNS','ENTRY_EMAIL_ADDRESS_CHECK','false','Verifique endereço de e-mail por um servidor de DNS',12,4,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(129,'Enviar E-mails','SEND_EMAILS','true','Enviar e-mails',12,5,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(130,'Ativar download','DOWNLOAD_ENABLED','false','Ativar as funções de download de produtos.',13,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(131,'Redirecionar o download','DOWNLOAD_BY_REDIRECT','false','Use redirecionamento de Browser para download. Desativar em sistemas Não Unix.',13,2,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(132,'Expiry demora (dias)','DOWNLOAD_MAX_DAYS','7','Configurar número de dias antes do link de download expirar. 0 não significa nenhum limite.',13,3,NULL,'2004-10-03 10:13:34',NULL,''),(133,'Número máximo de downloads','DOWNLOAD_MAX_COUNT','5','Configurar o número máximo de downloads. ( 0 ) significa nenhum download autorizado.',13,4,NULL,'2004-10-03 10:13:34',NULL,''),(134,'Ativar Compressão GZip','GZIP_COMPRESSION','false','Ativar compressão de HTTP GZip.',14,1,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'true\', \'false\'),'),(135,'Nível de compressão','GZIP_LEVEL','5','Use este nível de compressão 0-9 (0 = mínimo, 9 = máximo).',14,2,NULL,'2004-10-03 10:13:34',NULL,NULL),(136,'Diretório da sessão','SESSION_WRITE_DIRECTORY','/tmp','sessões são arquivo baseado, armazene eles neste diretório.',15,1,NULL,'2004-10-03 10:13:34',NULL,NULL),(137,'Forçar uso de Cookies','SESSION_FORCE_COOKIE_USE','False','Força o uso de cookie nas sessões só quando estiver habilitado.',15,2,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(138,'Checar sessão de SSL ID','SESSION_CHECK_SSL_SESSION_ID','False','Validar o SSL_SESSION_ID em todo pedido de página de HTTPS seguro.',15,3,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(139,'Checar agente de usuário','SESSION_CHECK_USER_AGENT','False','Validar o agente de usuário de clientes Browser em todo pedido de página.',15,4,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(140,'Checar endereço de IP','SESSION_CHECK_IP_ADDRESS','False','Validar o endereço de IP do cliente em todo pedido de página.',15,5,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(141,'Previnir sessões de Spider','SESSION_BLOCK_SPIDERS','False','Previnir de Spider antes de começar uma sessão.',15,6,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(142,'Recriar sessão','SESSION_RECREATE','False','Recreie a sessão para gerar uma nova sessão ID quando os logs do cliente em ou cria uma conta (precisa do PHP >=4.1 ).',15,7,NULL,'2004-10-03 10:13:34',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1175,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:42:06',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(541,'Sort Order','MODULE_SHIPPING_REMESSA_NACIONAL_2_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2004-10-10 18:21:36',NULL,NULL),(493,'Sort Order','MODULE_SHIPPING_REMESSA_NACIONAL_2_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2004-10-10 17:53:52',NULL,NULL),(517,'Sort Order','MODULE_SHIPPING_REMESSA_NACIONAL_2_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2004-10-10 18:10:55',NULL,NULL),(616,'Sort Order','MODULE_SHIPPING_REMESSA_NACIONAL_3_SORT_ORDER','1','Sort order of display.',6,0,NULL,'2004-10-12 18:06:53',NULL,NULL),(640,'Sort Order','MODULE_SHIPPING_REMESSA_NACIONAL_3_SORT_ORDER','0','Sort order of display.',6,0,NULL,'2004-10-12 18:24:39',NULL,NULL),(785,'Zone 2 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_2','BR,BH','Comma separated list of two character ISO country codes that are part of Zone 2.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(786,'Zone 2 Shipping Table','MODULE_SHIPPING_ZONES_COST_2','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 2 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 2 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(787,'Zone 2 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_2','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(788,'Zone 3 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_3','','Comma separated list of two character ISO country codes that are part of Zone 3.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(789,'Zone 3 Shipping Table','MODULE_SHIPPING_ZONES_COST_3','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 3 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 3 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(790,'Zone 3 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_3','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(791,'Zone 4 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_4','','Comma separated list of two character ISO country codes that are part of Zone 4.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(792,'Zone 4 Shipping Table','MODULE_SHIPPING_ZONES_COST_4','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 4 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 4 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(793,'Zone 4 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_4','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(794,'Zone 5 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_5','','Comma separated list of two character ISO country codes that are part of Zone 5.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(795,'Zone 5 Shipping Table','MODULE_SHIPPING_ZONES_COST_5','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 5 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 5 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(796,'Zone 5 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_5','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(797,'Zone 6 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_6','','Comma separated list of two character ISO country codes that are part of Zone 6.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(798,'Zone 6 Shipping Table','MODULE_SHIPPING_ZONES_COST_6','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 6 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 6 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(799,'Zone 6 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_6','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(800,'Zone 7 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_7','','Comma separated list of two character ISO country codes that are part of Zone 7.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(801,'Zone 7 Shipping Table','MODULE_SHIPPING_ZONES_COST_7','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 7 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 7 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(802,'Zone 7 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_7','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(803,'Zone 8 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_8','','Comma separated list of two character ISO country codes that are part of Zone 8.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(804,'Zone 8 Shipping Table','MODULE_SHIPPING_ZONES_COST_8','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 8 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 8 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(805,'Zone 8 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_8','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(806,'Zone 9 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_9','','Comma separated list of two character ISO country codes that are part of Zone 9.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(807,'Zone 9 Shipping Table','MODULE_SHIPPING_ZONES_COST_9','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 9 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 9 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(808,'Zone 9 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_9','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(809,'Zone 10 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_10','','Comma separated list of two character ISO country codes that are part of Zone 10.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(810,'Zone 10 Shipping Table','MODULE_SHIPPING_ZONES_COST_10','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 10 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 10 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(811,'Zone 10 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_10','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(812,'Zone 11 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_11','','Comma separated list of two character ISO country codes that are part of Zone 11.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(813,'Zone 11 Shipping Table','MODULE_SHIPPING_ZONES_COST_11','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 11 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 11 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(814,'Zone 11 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_11','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(815,'Zone 12 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_12','','Comma separated list of two character ISO country codes that are part of Zone 12.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(816,'Zone 12 Shipping Table','MODULE_SHIPPING_ZONES_COST_12','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 12 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 12 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(817,'Zone 12 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_12','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(818,'Zone 13 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_13','','Comma separated list of two character ISO country codes that are part of Zone 13.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(819,'Zone 13 Shipping Table','MODULE_SHIPPING_ZONES_COST_13','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 13 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 13 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(820,'Zone 13 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_13','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(821,'Zone 14 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_14','','Comma separated list of two character ISO country codes that are part of Zone 14.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(822,'Zone 14 Shipping Table','MODULE_SHIPPING_ZONES_COST_14','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 14 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 14 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(823,'Zone 14 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_14','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(824,'Zone 15 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_15','','Comma separated list of two character ISO country codes that are part of Zone 15.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(825,'Zone 15 Shipping Table','MODULE_SHIPPING_ZONES_COST_15','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 15 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 15 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(826,'Zone 15 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_15','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(827,'Zone 16 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_16','','Comma separated list of two character ISO country codes that are part of Zone 16.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(828,'Zone 16 Shipping Table','MODULE_SHIPPING_ZONES_COST_16','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 16 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 16 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(829,'Zone 16 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_16','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(830,'Zone 17 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_17','','Comma separated list of two character ISO country codes that are part of Zone 17.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(831,'Zone 17 Shipping Table','MODULE_SHIPPING_ZONES_COST_17','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 17 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 17 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(832,'Zone 17 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_17','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(833,'Zone 18 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_18','','Comma separated list of two character ISO country codes that are part of Zone 18.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(834,'Zone 18 Shipping Table','MODULE_SHIPPING_ZONES_COST_18','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 18 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 18 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(835,'Zone 18 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_18','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(836,'Zone 19 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_19','','Comma separated list of two character ISO country codes that are part of Zone 19.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(837,'Zone 19 Shipping Table','MODULE_SHIPPING_ZONES_COST_19','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 19 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 19 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(838,'Zone 19 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_19','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(839,'Zone 20 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_20','','Comma separated list of two character ISO country codes that are part of Zone 20.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(840,'Zone 20 Shipping Table','MODULE_SHIPPING_ZONES_COST_20','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 20 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 20 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(841,'Zone 20 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_20','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(842,'Zone 21 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_21','','Comma separated list of two character ISO country codes that are part of Zone 21.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(843,'Zone 21 Shipping Table','MODULE_SHIPPING_ZONES_COST_21','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 21 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 21 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(844,'Zone 21 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_21','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(845,'Zone 22 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_22','','Comma separated list of two character ISO country codes that are part of Zone 22.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(846,'Zone 22 Shipping Table','MODULE_SHIPPING_ZONES_COST_22','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 22 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 22 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(847,'Zone 22 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_22','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(848,'Zone 23 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_23','','Comma separated list of two character ISO country codes that are part of Zone 23.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(849,'Zone 23 Shipping Table','MODULE_SHIPPING_ZONES_COST_23','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 23 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 23 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(850,'Zone 23 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_23','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(851,'Zone 24 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_24','','Comma separated list of two character ISO country codes that are part of Zone 24.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(852,'Zone 24 Shipping Table','MODULE_SHIPPING_ZONES_COST_24','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 24 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 24 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(853,'Zone 24 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_24','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(854,'Zone 25 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_25','','Comma separated list of two character ISO country codes that are part of Zone 25.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(855,'Zone 25 Shipping Table','MODULE_SHIPPING_ZONES_COST_25','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 25 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 25 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(856,'Zone 25 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_25','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(857,'Zone 26 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_26','','Comma separated list of two character ISO country codes that are part of Zone 26.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(858,'Zone 26 Shipping Table','MODULE_SHIPPING_ZONES_COST_26','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 26 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 26 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(859,'Zone 26 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_26','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(860,'Zone 27 Countries','MODULE_SHIPPING_ZONES_COUNTRIES_27','','Comma separated list of two character ISO country codes that are part of Zone 27.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(861,'Zone 27 Shipping Table','MODULE_SHIPPING_ZONES_COST_27','3:8.50,7:10.50,99:20.00','Shipping rates to Zone 27 destinations based on a group of maximum order weights. Example: 3:8.50,7:10.50,... Weights less than or equal to 3 would cost 8.50 for Zone 27 destinations.',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(862,'Zone 27 Handling Fee','MODULE_SHIPPING_ZONES_HANDLING_27','0','Handling Fee for this shipping zone',6,0,NULL,'2004-10-12 18:39:47',NULL,NULL),(1153,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:42:01',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1217,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:42:25',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1239,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:44:38',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1283,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:48:25',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1305,'Entrega Correios Sedex','MODULE_SHIPPING_ENTREGA_REGIONS_STATUS','True','Ativar Entrega via sedex?',6,0,NULL,'2004-10-19 20:48:26',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1306,'Ativar o módulo Transferência','MODULE_PAYMENT_TRANSFERENCIA_STATUS','True','',6,1,NULL,'2007-04-20 17:26:23',NULL,'tep_cfg_select_option(array(\'True\', \'False\'),'),(1307,'Mensagem (Opções de Pagamento)','MODULE_PAYMENT_TRANSFERENCIA_TEXT_SELECTION','Depósito/Transferência Bancária (nome do banco aqui)','Texto a ser exibido para o cliente na tela do opções de pagamento:',6,4,NULL,'2007-04-20 17:26:23',NULL,NULL),(1308,'Mensagem (Instruções para o Cliente)','MODULE_PAYMENT_TRANSFERENCIA_TEXT_CONFIRMATION','Seu pedido será enviado quando confirmado o pagamento. Para agilizar o processo, envie o comprovante por fax: (xx)xxxx-xxxx ou email: cobranca@seusite.com.br.','Texto a ser exibido para o cliente na confirmação da compra',6,5,NULL,'2007-04-20 17:26:23',NULL,NULL),(1309,'Titular da Conta Bancária','MODULE_PAYMENT_TRANSFERENCIA_TITULAR','WAGNER OLIVEIRA DE SOUZA','Titular da Conta Bancária',6,3,NULL,'2007-04-20 17:26:23',NULL,NULL),(1310,'Nome do Banco','MODULE_PAYMENT_TRANSFERENCIA_BANCO','ITAU','Nome do Banco',6,4,NULL,'2007-04-20 17:26:23',NULL,NULL),(1311,'Agência','MODULE_PAYMENT_TRANSFERENCIA_AGENCIA','00183','Agência',6,5,NULL,'2007-04-20 17:26:23',NULL,NULL),(1312,'Conta Corrente','MODULE_PAYMENT_TRANSFERENCIA_CC','01779-7','Conta Corrente',6,2,NULL,'2007-04-20 17:26:23',NULL,NULL),(1313,'Status dos pedidos','MODULE_PAYMENT_TRANSFERENCIA_ORDER_STATUS_ID','0','Atualiza o status dos pedidos efetuados por este módulo de pagamento para este valor.',6,0,NULL,'2007-04-20 17:26:23','tep_get_order_status_name','tep_cfg_pull_down_order_statuses('),(1314,'Ordem de exibição.','MODULE_PAYMENT_TRANSFERENCIA_SORT_ORDER','0','Ordem de exibição',6,0,NULL,'2007-04-20 17:26:23',NULL,NULL),(1315,'Installed Modules','','','This is automatically updated. No need to edit.',6,0,NULL,'2007-06-01 12:08:10',NULL,NULL); /*!40000 ALTER TABLE `configuration` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `configuration_group` -- DROP TABLE IF EXISTS `configuration_group`; CREATE TABLE `configuration_group` ( `configuration_group_id` int(11) NOT NULL auto_increment, `configuration_group_title` varchar(64) NOT NULL default '', `configuration_group_description` varchar(255) NOT NULL default '', `sort_order` int(5) default NULL, `visible` int(1) default '1', PRIMARY KEY (`configuration_group_id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; -- -- Dumping data for table `configuration_group` -- LOCK TABLES `configuration_group` WRITE; /*!40000 ALTER TABLE `configuration_group` DISABLE KEYS */; INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (1,'Minha Loja','Informações gerais sobre a loja',1,1),(2,'Valores Mínimos','Valores mínimos para as funções / dados',2,1),(3,'Valores Máximos','Valores máximos para as funções / dados',3,1),(4,'Imagens','Parâmetros das Imagens',4,1),(5,'Detalhes do Cliente','Configuração da conta do cliente',5,1),(6,'Opções de Módulos','Livre de Configuração',6,0),(7,'Entrega/Pacotes','Opções de entrega da sua loja',7,1),(8,'Lista do Produto','Opções de configuração da lista de produtos',8,1),(9,'Estoque','Configurações do estoque',9,1),(10,'Log','Log configurações',10,1),(11,'Cache','Cache opcões',11,1),(12,'E-Mail Opções','Opções para o envio dos emails',12,1),(13,'Download','Downloadable products options',13,1),(14,'GZip Compressão','Opções de compressão',14,1),(15,'Sessões','Opções de sessões',15,1); /*!40000 ALTER TABLE `configuration_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `counter` -- DROP TABLE IF EXISTS `counter`; CREATE TABLE `counter` ( `startdate` char(8) default NULL, `counter` int(12) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `counter` -- LOCK TABLES `counter` WRITE; /*!40000 ALTER TABLE `counter` DISABLE KEYS */; INSERT INTO `counter` (`startdate`, `counter`) VALUES ('20070419',5513); /*!40000 ALTER TABLE `counter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `counter_history` -- DROP TABLE IF EXISTS `counter_history`; CREATE TABLE `counter_history` ( `month` char(8) default NULL, `counter` int(12) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `counter_history` -- LOCK TABLES `counter_history` WRITE; /*!40000 ALTER TABLE `counter_history` DISABLE KEYS */; /*!40000 ALTER TABLE `counter_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `countries` -- DROP TABLE IF EXISTS `countries`; CREATE TABLE `countries` ( `countries_id` int(11) NOT NULL auto_increment, `countries_name` varchar(64) NOT NULL default '', `countries_iso_code_2` char(2) NOT NULL default '', `countries_iso_code_3` char(3) NOT NULL default '', `address_format_id` int(11) NOT NULL default '0', PRIMARY KEY (`countries_id`), KEY `IDX_COUNTRIES_NAME` (`countries_name`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1; -- -- Dumping data for table `countries` -- LOCK TABLES `countries` WRITE; /*!40000 ALTER TABLE `countries` DISABLE KEYS */; INSERT INTO `countries` (`countries_id`, `countries_name`, `countries_iso_code_2`, `countries_iso_code_3`, `address_format_id`) VALUES (30,'Brasil','BR','BRA',1); /*!40000 ALTER TABLE `countries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currencies` -- DROP TABLE IF EXISTS `currencies`; CREATE TABLE `currencies` ( `currencies_id` int(11) NOT NULL auto_increment, `title` varchar(32) NOT NULL default '', `code` char(3) NOT NULL default '', `symbol_left` varchar(12) default NULL, `symbol_right` varchar(12) default NULL, `decimal_point` char(1) default NULL, `thousands_point` char(1) default NULL, `decimal_places` char(1) default NULL, `value` float(13,8) default NULL, `last_updated` datetime default NULL, PRIMARY KEY (`currencies_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `currencies` -- LOCK TABLES `currencies` WRITE; /*!40000 ALTER TABLE `currencies` DISABLE KEYS */; INSERT INTO `currencies` (`currencies_id`, `title`, `code`, `symbol_left`, `symbol_right`, `decimal_point`, `thousands_point`, `decimal_places`, `value`, `last_updated`) VALUES (3,'Real','BR','R$','','.',',','2',1.00000000,NULL); /*!40000 ALTER TABLE `currencies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; CREATE TABLE `customers` ( `customers_id` int(11) NOT NULL auto_increment, `customers_gender` char(1) NOT NULL default '', `customers_firstname` varchar(32) NOT NULL default '', `customers_lastname` varchar(32) NOT NULL default '', `customers_dob` datetime NOT NULL default '0000-00-00 00:00:00', `customers_email_address` varchar(96) NOT NULL default '', `customers_default_address_id` int(11) NOT NULL default '0', `customers_telephone` varchar(32) NOT NULL default '', `customers_fax` varchar(32) default NULL, `customers_password` varchar(40) NOT NULL default '', `customers_newsletter` char(1) default NULL, PRIMARY KEY (`customers_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` (`customers_id`, `customers_gender`, `customers_firstname`, `customers_lastname`, `customers_dob`, `customers_email_address`, `customers_default_address_id`, `customers_telephone`, `customers_fax`, `customers_password`, `customers_newsletter`) VALUES (5,'m','sérgio','giichi hayashi','1956-04-06 00:00:00','antiuidadessgh@uol.com.br',5,'(16)9992-9893','','bf63f6d58d630bd8e80b05efe684ffa4:0c','1'),(4,'f','Marcia','Rodrigues','1965-04-30 00:00:00','marciarodriguesc@uol.com.br',4,'11 38641100','11 38732260','31dd0744389ec514bc179fbb8ad89156:40',''),(6,'f','tere','silveira','1950-04-26 00:00:00','j.assugeni@hotmail.com',6,'1194154411','','eadabbe2c341f8abcaa463a860dec898:50','1'),(7,'m','Jair A Cvilikas','Cvilikas','1955-06-12 00:00:00','jacvilikas@gmail.com',7,'48 3240 21 32','','4a2573c12484880b44bf30f186e00cbd:24','1'),(8,'m','Ricardo Aparecido','Alves','1969-07-25 00:00:00','naturalbellasarts@bol.com.br',9,'11-62410486','','8eca363966e39bc759bab13e5b4f2cc5:ee','1'),(9,'m','Kyle','Andrade','1987-08-24 00:00:00','kailots@gmail.com',10,'61-9988-9394','','1c5791bc50573937553cef99572f47be:7a',''),(10,'m','CARLOS','SOUZA','1971-01-12 00:00:00','oliveirawagner@ig.com.br',11,'11-46140794','','ff38191633cfab907111f1281cbd8a8e:60','1'); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers_basket` -- DROP TABLE IF EXISTS `customers_basket`; CREATE TABLE `customers_basket` ( `customers_basket_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `products_id` tinytext NOT NULL, `customers_basket_quantity` int(2) NOT NULL default '0', `final_price` decimal(15,4) NOT NULL default '0.0000', `customers_basket_date_added` varchar(8) default NULL, PRIMARY KEY (`customers_basket_id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- -- Dumping data for table `customers_basket` -- LOCK TABLES `customers_basket` WRITE; /*!40000 ALTER TABLE `customers_basket` DISABLE KEYS */; INSERT INTO `customers_basket` (`customers_basket_id`, `customers_id`, `products_id`, `customers_basket_quantity`, `final_price`, `customers_basket_date_added`) VALUES (7,6,'128',1,'0.0000','20070722'),(5,4,'46',1,'0.0000','20070614'),(8,8,'149',1,'0.0000','20070730'); /*!40000 ALTER TABLE `customers_basket` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers_basket_attributes` -- DROP TABLE IF EXISTS `customers_basket_attributes`; CREATE TABLE `customers_basket_attributes` ( `customers_basket_attributes_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `products_id` tinytext NOT NULL, `products_options_id` int(11) NOT NULL default '0', `products_options_value_id` int(11) NOT NULL default '0', PRIMARY KEY (`customers_basket_attributes_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `customers_basket_attributes` -- LOCK TABLES `customers_basket_attributes` WRITE; /*!40000 ALTER TABLE `customers_basket_attributes` DISABLE KEYS */; /*!40000 ALTER TABLE `customers_basket_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers_info` -- DROP TABLE IF EXISTS `customers_info`; CREATE TABLE `customers_info` ( `customers_info_id` int(11) NOT NULL default '0', `customers_info_date_of_last_logon` datetime default NULL, `customers_info_number_of_logons` int(5) default NULL, `customers_info_date_account_created` datetime default NULL, `customers_info_date_account_last_modified` datetime default NULL, `global_product_notifications` int(1) default '0', PRIMARY KEY (`customers_info_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `customers_info` -- LOCK TABLES `customers_info` WRITE; /*!40000 ALTER TABLE `customers_info` DISABLE KEYS */; INSERT INTO `customers_info` (`customers_info_id`, `customers_info_date_of_last_logon`, `customers_info_number_of_logons`, `customers_info_date_account_created`, `customers_info_date_account_last_modified`, `global_product_notifications`) VALUES (4,NULL,0,'2007-06-14 07:39:47',NULL,0),(6,'2007-07-22 22:57:50',5,'2007-07-01 22:12:42',NULL,0),(5,NULL,0,'2007-06-18 10:55:39',NULL,0),(7,NULL,0,'2007-07-17 07:47:07',NULL,0),(8,NULL,0,'2007-07-30 14:37:30',NULL,0),(9,NULL,0,'2007-08-06 10:46:57',NULL,0),(10,NULL,0,'2007-08-07 23:31:17',NULL,0); /*!40000 ALTER TABLE `customers_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `geo_zones` -- DROP TABLE IF EXISTS `geo_zones`; CREATE TABLE `geo_zones` ( `geo_zone_id` int(11) NOT NULL auto_increment, `geo_zone_name` varchar(32) NOT NULL default '', `geo_zone_description` varchar(255) NOT NULL default '', `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`geo_zone_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `geo_zones` -- LOCK TABLES `geo_zones` WRITE; /*!40000 ALTER TABLE `geo_zones` DISABLE KEYS */; /*!40000 ALTER TABLE `geo_zones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; CREATE TABLE `languages` ( `languages_id` int(11) NOT NULL auto_increment, `name` varchar(32) NOT NULL default '', `code` char(2) NOT NULL default '', `image` varchar(64) default NULL, `directory` varchar(32) default NULL, `sort_order` int(3) default NULL, PRIMARY KEY (`languages_id`), KEY `IDX_LANGUAGES_NAME` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Dumping data for table `languages` -- LOCK TABLES `languages` WRITE; /*!40000 ALTER TABLE `languages` DISABLE KEYS */; INSERT INTO `languages` (`languages_id`, `name`, `code`, `image`, `directory`, `sort_order`) VALUES (4,'Português','br','icon.gif','portugues',1); /*!40000 ALTER TABLE `languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `manufacturers` -- DROP TABLE IF EXISTS `manufacturers`; CREATE TABLE `manufacturers` ( `manufacturers_id` int(11) NOT NULL auto_increment, `manufacturers_name` varchar(32) NOT NULL default '', `manufacturers_image` varchar(64) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, PRIMARY KEY (`manufacturers_id`), KEY `IDX_MANUFACTURERS_NAME` (`manufacturers_name`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; -- -- Dumping data for table `manufacturers` -- LOCK TABLES `manufacturers` WRITE; /*!40000 ALTER TABLE `manufacturers` DISABLE KEYS */; /*!40000 ALTER TABLE `manufacturers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `manufacturers_info` -- DROP TABLE IF EXISTS `manufacturers_info`; CREATE TABLE `manufacturers_info` ( `manufacturers_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `manufacturers_url` varchar(255) NOT NULL default '', `url_clicked` int(5) NOT NULL default '0', `date_last_click` datetime default NULL, PRIMARY KEY (`manufacturers_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `manufacturers_info` -- LOCK TABLES `manufacturers_info` WRITE; /*!40000 ALTER TABLE `manufacturers_info` DISABLE KEYS */; /*!40000 ALTER TABLE `manufacturers_info` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletters` -- DROP TABLE IF EXISTS `newsletters`; CREATE TABLE `newsletters` ( `newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `content` text NOT NULL, `module` varchar(255) NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', PRIMARY KEY (`newsletters_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `newsletters` -- LOCK TABLES `newsletters` WRITE; /*!40000 ALTER TABLE `newsletters` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `orders_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `customers_name` varchar(64) NOT NULL default '', `customers_company` varchar(32) default NULL, `customers_street_address` varchar(64) NOT NULL default '', `customers_suburb` varchar(32) default NULL, `customers_city` varchar(32) NOT NULL default '', `customers_postcode` varchar(10) NOT NULL default '', `customers_state` varchar(32) default NULL, `customers_country` varchar(32) NOT NULL default '', `customers_telephone` varchar(32) NOT NULL default '', `customers_email_address` varchar(96) NOT NULL default '', `customers_address_format_id` int(5) NOT NULL default '0', `delivery_name` varchar(64) NOT NULL default '', `delivery_company` varchar(32) default NULL, `delivery_street_address` varchar(64) NOT NULL default '', `delivery_suburb` varchar(32) default NULL, `delivery_city` varchar(32) NOT NULL default '', `delivery_postcode` varchar(10) NOT NULL default '', `delivery_state` varchar(32) default NULL, `delivery_country` varchar(32) NOT NULL default '', `delivery_address_format_id` int(5) NOT NULL default '0', `billing_name` varchar(64) NOT NULL default '', `billing_company` varchar(32) default NULL, `billing_street_address` varchar(64) NOT NULL default '', `billing_suburb` varchar(32) default NULL, `billing_city` varchar(32) NOT NULL default '', `billing_postcode` varchar(10) NOT NULL default '', `billing_state` varchar(32) default NULL, `billing_country` varchar(32) NOT NULL default '', `billing_address_format_id` int(5) NOT NULL default '0', `payment_method` varchar(32) NOT NULL default '', `cc_type` varchar(20) default NULL, `cc_owner` varchar(64) default NULL, `cc_number` varchar(32) default NULL, `cc_expires` varchar(4) default NULL, `last_modified` datetime default NULL, `date_purchased` datetime default NULL, `orders_status` int(5) NOT NULL default '0', `orders_date_finished` datetime default NULL, `currency` char(3) default NULL, `currency_value` decimal(14,6) default NULL, PRIMARY KEY (`orders_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` (`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`) VALUES (1,1,'Eder Silveira','','monteiro lobato 460 ap 103','partenon','porto alegre','90620-270','Rio Grande do Sul','Brasil','96876471','eder-silveira@trifacil.com.br',1,'Eder Silveira','','monteiro lobato 460 ap 103','partenon','porto alegre','90620-270','Rio Grande do Sul','Brasil',1,'Eder Silveira','','monteiro lobato 460 ap 103','partenon','porto alegre','90620-270','Rio Grande do Sul','Brasil',1,'','','','','',NULL,'2007-04-19 22:02:14',1,NULL,'BR','1.000000'),(4,6,'tere silveira','','santa cruz','centro','itu','13300140','Sao Paulo','Brasil','1194154411','j.assugeni@hotmail.com',1,'terezinha assugeni','','rua madre maria theodora 290','centro','itu','13300140','Sao Paulo','Brasil',1,'tere silveira','','santa cruz','centro','itu','13300140','Sao Paulo','Brasil',1,'Depósito/Transferência Bancária','','','','',NULL,'2007-07-22 23:01:59',1,NULL,'BR','1.000000'),(5,10,'CARLOS SOUZA','','r:brasilia 179','atalaia','cotia','06700590','Sao Paulo','Brasil','11-46140794','oliveirawagner@ig.com.br',1,'CARLOS SOUZA','','r:brasilia 179','atalaia','cotia','06700590','Sao Paulo','Brasil',1,'CARLOS SOUZA','','r:brasilia 179','atalaia','cotia','06700590','Sao Paulo','Brasil',1,'Depósito/Transferência Bancária','','','','',NULL,'2007-08-07 23:32:17',1,NULL,'BR','1.000000'); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_products` -- DROP TABLE IF EXISTS `orders_products`; CREATE TABLE `orders_products` ( `orders_products_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_name` varchar(64) NOT NULL default '', `products_price` decimal(15,4) NOT NULL default '0.0000', `final_price` decimal(15,4) NOT NULL default '0.0000', `products_tax` decimal(7,4) NOT NULL default '0.0000', `products_quantity` int(2) NOT NULL default '0', PRIMARY KEY (`orders_products_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_products` -- LOCK TABLES `orders_products` WRITE; /*!40000 ALTER TABLE `orders_products` DISABLE KEYS */; INSERT INTO `orders_products` (`orders_products_id`, `orders_id`, `products_id`, `products_model`, `products_name`, `products_price`, `final_price`, `products_tax`, `products_quantity`) VALUES (1,1,26,'MSIMEXP','Microsoft IntelliMouse Explorer','64.9500','64.9500','0.0000',1),(2,1,1,'MG200MMS','Matrox G200 MMS','299.9900','299.9900','0.0000',1),(5,4,128,'','FONTE DE RESINA SEM LUMINARIA ALT 0.65','210.0000','210.0000','0.0000',1),(6,5,176,'','FRUTEIRA COM 1 BACIA ALT 0,44','220.0000','220.0000','0.0000',1); /*!40000 ALTER TABLE `orders_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_products_attributes` -- DROP TABLE IF EXISTS `orders_products_attributes`; CREATE TABLE `orders_products_attributes` ( `orders_products_attributes_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `products_options` varchar(32) NOT NULL default '', `products_options_values` varchar(32) NOT NULL default '', `options_values_price` decimal(15,4) NOT NULL default '0.0000', `price_prefix` char(1) NOT NULL default '', PRIMARY KEY (`orders_products_attributes_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_products_attributes` -- LOCK TABLES `orders_products_attributes` WRITE; /*!40000 ALTER TABLE `orders_products_attributes` DISABLE KEYS */; INSERT INTO `orders_products_attributes` (`orders_products_attributes_id`, `orders_id`, `orders_products_id`, `products_options`, `products_options_values`, `options_values_price`, `price_prefix`) VALUES (1,1,1,'Modelo','PS/2','0.0000','+'),(2,1,2,'Memoria','4 mb','0.0000','+'),(3,1,2,'Modelo','Value','0.0000','+'); /*!40000 ALTER TABLE `orders_products_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_products_download` -- DROP TABLE IF EXISTS `orders_products_download`; CREATE TABLE `orders_products_download` ( `orders_products_download_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_products_id` int(11) NOT NULL default '0', `orders_products_filename` varchar(255) NOT NULL default '', `download_maxdays` int(2) NOT NULL default '0', `download_count` int(2) NOT NULL default '0', PRIMARY KEY (`orders_products_download_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_products_download` -- LOCK TABLES `orders_products_download` WRITE; /*!40000 ALTER TABLE `orders_products_download` DISABLE KEYS */; /*!40000 ALTER TABLE `orders_products_download` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_status` -- DROP TABLE IF EXISTS `orders_status`; CREATE TABLE `orders_status` ( `orders_status_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `orders_status_name` varchar(32) NOT NULL default '', PRIMARY KEY (`orders_status_id`,`language_id`), KEY `idx_orders_status_name` (`orders_status_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_status` -- LOCK TABLES `orders_status` WRITE; /*!40000 ALTER TABLE `orders_status` DISABLE KEYS */; INSERT INTO `orders_status` (`orders_status_id`, `language_id`, `orders_status_name`) VALUES (1,4,'Pendente'),(2,4,'Processando'),(3,4,'Enviado'); /*!40000 ALTER TABLE `orders_status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_status_history` -- DROP TABLE IF EXISTS `orders_status_history`; CREATE TABLE `orders_status_history` ( `orders_status_history_id` int(11) NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `orders_status_id` int(5) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `customer_notified` int(1) default '0', `comments` text, PRIMARY KEY (`orders_status_history_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_status_history` -- LOCK TABLES `orders_status_history` WRITE; /*!40000 ALTER TABLE `orders_status_history` DISABLE KEYS */; INSERT INTO `orders_status_history` (`orders_status_history_id`, `orders_id`, `orders_status_id`, `date_added`, `customer_notified`, `comments`) VALUES (1,1,1,'2007-04-19 22:02:14',1,'teste de envio de pedido'),(4,4,1,'2007-07-22 23:01:59',1,'Gostaria a fonte na cor BRANCA.....OBRIGADO'),(5,5,1,'2007-08-07 23:32:17',1,''); /*!40000 ALTER TABLE `orders_status_history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders_total` -- DROP TABLE IF EXISTS `orders_total`; CREATE TABLE `orders_total` ( `orders_total_id` int(10) unsigned NOT NULL auto_increment, `orders_id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `text` varchar(255) NOT NULL default '', `value` decimal(15,4) NOT NULL default '0.0000', `class` varchar(32) NOT NULL default '', `sort_order` int(11) NOT NULL default '0', PRIMARY KEY (`orders_total_id`), KEY `idx_orders_total_orders_id` (`orders_id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_total` -- LOCK TABLES `orders_total` WRITE; /*!40000 ALTER TABLE `orders_total` DISABLE KEYS */; INSERT INTO `orders_total` (`orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order`) VALUES (1,1,'Subtotal:','R$364.94','364.9400','ot_subtotal',1),(2,1,'MODULE_ORDER_TOTAL_TOTAL_TITLE:','R$364.94','364.9400','ot_total',4),(10,5,'Total:','R$220.00','220.0000','ot_total',4),(7,4,'Subtotal:','R$210.00','210.0000','ot_subtotal',1),(8,4,'Total:','R$210.00','210.0000','ot_total',4),(9,5,'Subtotal:','R$220.00','220.0000','ot_subtotal',1); /*!40000 ALTER TABLE `orders_total` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_quantity` int(4) NOT NULL default '0', `products_model` varchar(12) default NULL, `products_image` varchar(64) default NULL, `products_price` decimal(15,4) NOT NULL default '0.0000', `products_date_added` datetime NOT NULL default '0000-00-00 00:00:00', `products_last_modified` datetime default NULL, `products_date_available` datetime default NULL, `products_weight` decimal(5,2) NOT NULL default '0.00', `products_status` tinyint(1) NOT NULL default '0', `products_tax_class_id` int(11) NOT NULL default '0', `manufacturers_id` int(11) default NULL, `products_ordered` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`), KEY `idx_products_date_added` (`products_date_added`) ) ENGINE=MyISAM AUTO_INCREMENT=177 DEFAULT CHARSET=latin1; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` (`products_id`, `products_quantity`, `products_model`, `products_image`, `products_price`, `products_date_added`, `products_last_modified`, `products_date_available`, `products_weight`, `products_status`, `products_tax_class_id`, `manufacturers_id`, `products_ordered`) VALUES (67,5,'',',jus4.JPG','30.0000','2007-04-24 01:25:14','2007-04-24 01:35:31',NULL,'2.00',1,0,0,0),(32,9,'','cavalo1.jpg','110.0000','2007-04-20 12:43:36','2007-04-29 13:19:35',NULL,'6.00',1,0,0,1),(33,10,'','cavalo2[1].jpg','65.0000','2007-04-20 12:44:23','2007-04-29 13:31:41',NULL,'3.00',1,0,0,0),(34,10,'','cavalo3[1].jpg','350.0000','2007-04-20 12:45:18','2007-04-29 13:34:13',NULL,'15.00',1,0,0,0),(38,5,'','Imagem 380.jpg','270.0000','2007-04-23 14:48:03',NULL,NULL,'14.00',1,0,0,0),(42,5,'','13CAVALO-EMPINADO-COM-GRINA-27000.jpg','270.0000','2007-04-23 15:46:29',NULL,NULL,'14.00',1,0,0,0),(43,5,'','6407scd.jpg','100.0000','2007-04-23 23:17:03','2007-05-28 20:26:23',NULL,'4.00',1,0,0,0),(44,5,'','7a17scd.jpg','100.0000','2007-04-23 23:17:59','2007-05-28 20:23:24',NULL,'4.00',1,0,0,0),(45,5,'','43ecscd.jpg','45.0000','2007-04-23 23:25:03','2007-05-02 12:34:52',NULL,'2.00',1,0,0,0),(46,5,'','30.jpg','80.0000','2007-04-23 23:31:04','2007-05-28 20:25:12',NULL,'3.00',1,0,0,0),(47,5,'','6243scd.jpg','80.0000','2007-04-23 23:32:10',NULL,NULL,'4.00',1,0,0,0),(48,5,'','f289scd.jpg','150.0000','2007-04-23 23:33:54','2007-05-28 20:23:59',NULL,'7.00',1,0,0,0),(49,5,'','CENTAURO,,.jpg','220.0000','2007-04-23 23:40:30',NULL,NULL,'9.00',1,0,0,0),(50,5,'','CENTAURO.,..jpg','150.0000','2007-04-23 23:42:04','2007-05-28 20:27:10',NULL,'9.00',1,0,0,0),(51,5,'','CENTAURO,.jpg','140.0000','2007-04-23 23:45:02','2007-04-23 23:48:32',NULL,'7.00',1,0,0,0),(52,4,'','CENTAURO.jpg','180.0000','2007-04-23 23:47:33',NULL,NULL,'9.00',1,0,0,0),(53,5,'','CAVALO ARABE.JPG','600.0000','2007-04-24 00:15:15','2007-05-28 20:21:26',NULL,'30.00',1,0,0,0),(54,5,'','CAVALO BUSTO.JPG','220.0000','2007-04-24 00:16:48',NULL,NULL,'14.00',1,0,0,0),(55,5,'','CAVALO CESAR GRDE.JPG','200.0000','2007-04-24 00:18:39',NULL,NULL,'9.00',1,0,0,0),(56,5,'','CAVALO CESAR PQ.JPG','100.0000','2007-04-24 00:19:57',NULL,NULL,'7.00',1,0,0,0),(57,5,'','CAVALO EMPINADO SEM GRINA.JPG','250.0000','2007-04-24 00:21:40',NULL,NULL,'13.00',1,0,0,0),(58,5,'','CAVALO PAULO.JPG','100.0000','2007-04-24 00:23:45',NULL,NULL,'6.00',1,0,0,0),(59,5,'','CAVALO PAULO....JPG','110.0000','2007-04-24 00:24:53','2007-04-25 16:20:21',NULL,'5.00',1,0,0,0),(61,5,'','jus.jpg','400.0000','2007-04-24 01:15:38','2007-05-28 20:28:56',NULL,'14.00',1,0,0,0),(62,5,'','jus1.jpg','270.0000','2007-04-24 01:16:47',NULL,NULL,'112.00',1,0,0,0),(63,5,'','jus2.jpg','160.0000','2007-04-24 01:18:11',NULL,NULL,'7.00',1,0,0,0),(64,0,'','72.jpg','160.0000','2007-04-24 01:20:32','2007-07-10 00:18:38',NULL,'6.00',1,0,0,0),(65,5,'','just].jpg','75.0000','2007-04-24 01:22:02',NULL,NULL,'4.00',1,0,0,0),(66,5,'','66.jpg','110.0000','2007-04-24 01:23:19','2007-07-10 00:14:20',NULL,'6.00',1,0,0,0),(39,5,'','8bb8[1].jpg','230.0000','2007-04-23 14:57:59','2007-05-28 20:31:24',NULL,'12.00',1,0,0,0),(40,5,'','d3b5[1][1].jpg','450.0000','2007-04-23 15:05:46','2007-05-28 20:30:50',NULL,'30.00',1,0,0,0),(41,5,'','Nova imagem.JPG','80.0000','2007-04-23 15:14:52','2007-05-22 14:45:18',NULL,'5.00',1,0,0,0),(68,5,'','65.jpg','50.0000','2007-04-24 01:34:42','2007-07-10 00:07:18',NULL,'3.00',1,0,0,0),(69,5,'','8.jpg','100.0000','2007-04-30 01:59:32',NULL,NULL,'3.00',1,0,0,0),(70,5,'','9.jpg','100.0000','2007-05-01 23:24:41',NULL,NULL,'3.00',1,0,0,0),(71,5,'','10.jpg','100.0000','2007-05-01 23:28:18',NULL,NULL,'3.00',1,0,0,0),(72,5,'','11.jpg','100.0000','2007-05-01 23:29:53',NULL,NULL,'3.00',1,0,0,0),(73,5,'','7.jpg','110.0000','2007-05-01 23:33:01',NULL,NULL,'3.00',1,0,0,0),(167,5,'','1 40 CM.jpg','230.0000','2007-07-29 02:51:05',NULL,NULL,'6.00',1,0,0,0),(168,5,'','1 SAIA TULIPA EM VIDRO COLORIDO 37 190,00.jpg','180.0000','2007-07-29 02:58:01',NULL,NULL,'6.00',1,0,0,0),(77,5,'','4.jpg','100.0000','2007-05-01 23:41:13',NULL,NULL,'3.00',1,0,0,0),(79,5,'','6.jpg','110.0000','2007-05-01 23:44:12',NULL,NULL,'3.00',1,0,0,0),(80,5,'','12.jpg','100.0000','2007-05-01 23:54:38',NULL,NULL,'3.00',1,0,0,0),(81,5,'','13.jpg','110.0000','2007-05-02 00:06:54',NULL,NULL,'4.00',1,0,0,0),(82,5,'','14.jpg','100.0000','2007-05-02 00:07:59',NULL,NULL,'4.00',1,0,0,0),(83,5,'','15.jpg','100.0000','2007-05-02 00:09:06',NULL,NULL,'3.00',1,0,0,0),(84,5,'','16.jpg','100.0000','2007-05-02 00:39:37',NULL,NULL,'4.00',1,0,0,0),(85,5,'','17.jpg','100.0000','2007-05-02 00:40:25',NULL,NULL,'4.00',1,0,0,0),(86,5,'','100.jpg','110.0000','2007-05-02 00:43:25',NULL,NULL,'4.00',1,0,0,0),(87,5,'','101.jpg','100.0000','2007-05-02 00:44:39',NULL,NULL,'4.00',1,0,0,0),(88,5,'','18.jpg','100.0000','2007-05-02 00:45:31','2007-05-06 12:48:38',NULL,'4.00',1,0,0,0),(89,5,'','103.jpg','100.0000','2007-05-02 00:46:26',NULL,NULL,'4.00',1,0,0,0),(90,5,'','121.jpg','170.0000','2007-05-02 00:57:55',NULL,NULL,'8.00',1,0,0,0),(91,1,'','122.jpg','110.0000','2007-05-02 01:04:12',NULL,NULL,'7.00',1,0,0,0),(92,5,'','111121.jpg','300.0000','2007-05-02 01:10:55','2007-08-07 00:36:12',NULL,'15.00',1,0,0,0),(93,5,'','1010.jpg','560.0000','2007-05-02 01:11:57','2007-08-07 00:37:53',NULL,'25.00',1,0,0,0),(94,5,'','201..jpg','240.0000','2007-05-02 01:30:15',NULL,NULL,'14.00',1,0,0,0),(95,5,'','202.jpg','300.0000','2007-05-02 01:31:34','2007-08-07 00:40:07',NULL,'15.00',1,0,0,0),(96,5,'','206.jpg','300.0000','2007-05-02 01:32:31','2007-08-07 00:40:40',NULL,'13.00',1,0,0,0),(97,5,'','205.jpg','300.0000','2007-05-02 01:33:34','2007-08-07 00:41:17',NULL,'14.00',1,0,0,0),(98,5,'','204.jpg','250.0000','2007-05-02 01:34:53',NULL,NULL,'12.00',1,0,0,0),(99,5,'','207.jpg','560.0000','2007-05-02 01:35:57','2007-08-07 00:38:31',NULL,'15.00',1,0,0,0),(100,5,'','29.jpg','180.0000','2007-05-02 01:37:30','2007-05-06 13:12:27',NULL,'8.00',1,0,0,0),(101,5,'','208.jpg','150.0000','2007-05-02 02:24:07',NULL,NULL,'7.00',1,0,0,0),(102,5,'','209.jpg','150.0000','2007-05-02 02:25:07',NULL,NULL,'7.00',1,0,0,0),(103,5,'','210..JPG','620.0000','2007-05-02 02:26:35','2007-08-07 00:35:26',NULL,'15.00',1,0,0,0),(104,5,'','27.jpg','200.0000','2007-05-02 02:27:49','2007-08-07 00:42:58',NULL,'8.00',1,0,0,0),(105,5,'','212.jpg','170.0000','2007-05-02 02:29:15','2007-05-11 20:36:39',NULL,'8.00',1,0,0,0),(106,5,'','213.jpg','260.0000','2007-05-02 02:30:13','2007-08-07 00:41:50',NULL,'10.00',1,0,0,0),(107,5,'','215.jpg','220.0000','2007-05-02 02:31:25','2007-08-07 00:49:49',NULL,'8.00',1,0,0,0),(108,5,'','216.jpg','160.0000','2007-05-02 02:32:30','2007-08-07 00:48:13',NULL,'6.00',1,0,0,0),(109,5,'','217..jpg','100.0000','2007-05-02 02:35:16',NULL,NULL,'4.00',1,0,0,0),(110,5,'','218.JPG','1400.0000','2007-05-02 02:36:15',NULL,NULL,'45.00',1,0,0,0),(111,3,'','25.jpg','200.0000','2007-05-02 02:44:19','2007-08-07 00:42:24',NULL,'8.00',1,0,0,0),(112,3,'','28.jpg','160.0000','2007-05-02 02:45:36','2007-08-07 00:45:06',NULL,'7.00',1,0,0,0),(113,3,'','221.jpg','160.0000','2007-05-02 02:55:45','2007-08-07 00:49:04',NULL,'6.00',1,0,0,0),(114,3,'','222.jpg','160.0000','2007-05-02 02:56:50','2007-08-07 00:47:22',NULL,'6.00',1,0,0,0),(115,3,'','223.jpg','150.0000','2007-05-02 02:57:58',NULL,NULL,'6.00',1,0,0,0),(116,3,'','23.jpg','160.0000','2007-05-02 02:59:00','2007-08-07 00:45:35',NULL,'6.00',1,0,0,0),(117,6,'','225.jpg','200.0000','2007-05-02 03:00:01','2007-07-10 00:41:54',NULL,'10.00',1,0,0,0),(118,3,'','228.JPG','130.0000','2007-05-02 03:15:12',NULL,NULL,'6.00',1,0,0,0),(119,3,'','229.JPG','100.0000','2007-05-02 03:15:56',NULL,NULL,'6.00',1,0,0,0),(120,3,'','230.JPG','130.0000','2007-05-02 03:23:06',NULL,NULL,'7.00',1,0,0,0),(121,3,'','231.jpg','210.0000','2007-05-02 03:41:11',NULL,NULL,'9.00',1,0,0,0),(122,3,'','232.jpg','180.0000','2007-05-02 03:43:07',NULL,NULL,'8.00',1,0,0,0),(123,3,'','233.jpg','110.0000','2007-05-02 03:44:40',NULL,NULL,'4.00',1,0,0,0),(124,3,'','15..jpg','100.0000','2007-05-02 03:54:02',NULL,NULL,'4.00',1,0,0,0),(125,6,'','14..jpg','100.0000','2007-05-02 04:28:45',NULL,NULL,'4.00',1,0,0,0),(126,5,'','236.jpg','180.0000','2007-05-02 12:11:52','2007-08-07 00:44:17',NULL,'7.00',1,0,0,0),(127,3,'','FONTE.jpg','250.0000','2007-05-02 12:19:04','2007-05-02 18:19:56',NULL,'10.00',1,0,0,0),(128,2,'','FONTE,.jpg','210.0000','2007-05-02 12:20:43','2007-05-02 12:23:07',NULL,'10.00',1,0,0,1),(129,5,'','321.jpg','180.0000','2007-05-02 18:07:13','2007-07-17 21:21:25',NULL,'5.00',1,0,0,0),(130,5,'','322.jpg','180.0000','2007-05-02 18:14:10','2007-07-17 21:22:17',NULL,'5.00',1,0,0,0),(131,3,'','9711[1].jpg','80.0000','2007-05-03 14:53:15',NULL,NULL,'2.00',1,0,0,0),(132,6,'','303.jpg','80.0000','2007-05-03 14:59:57','2007-05-03 15:13:09',NULL,'3.00',1,0,0,0),(133,5,'','305.jpg','80.0000','2007-05-03 15:17:26',NULL,NULL,'3.00',1,0,0,0),(134,5,'','304.jpg','80.0000','2007-05-03 15:21:20',NULL,NULL,'3.00',1,0,0,0),(135,4,'','306.jpg','170.0000','2007-05-03 15:25:14',NULL,NULL,'6.00',1,0,0,0),(136,5,'','34.jpg','600.0000','2007-05-06 11:59:56',NULL,NULL,'30.00',1,0,0,0),(137,3,'','26.jpg','160.0000','2007-05-06 13:15:52','2007-08-07 00:46:07',NULL,'5.00',1,0,0,0),(138,5,'','22.jpg','160.0000','2007-05-06 13:17:44','2007-08-07 00:46:40',NULL,'5.00',1,0,0,0),(139,5,'','32.jpg','120.0000','2007-05-06 13:21:17',NULL,NULL,'4.00',1,0,0,0),(140,3,'','33.jpg','250.0000','2007-05-06 13:24:30',NULL,NULL,'12.00',1,0,0,0),(141,5,'','24.jpg','170.0000','2007-05-06 13:28:08',NULL,NULL,'7.00',1,0,0,0),(142,5,'','31.jpg','60.0000','2007-05-06 13:30:42',NULL,NULL,'3.00',1,0,0,0),(143,5,'','1.jpg','120.0000','2007-05-11 00:37:01',NULL,NULL,'5.00',1,0,0,0),(144,5,'',', 2,,.jpg','130.0000','2007-05-11 00:40:29','2007-05-11 20:45:55',NULL,'5.00',1,0,0,0),(145,5,'','3,,.jpg','130.0000','2007-05-11 00:44:27',NULL,NULL,'4.00',1,0,0,0),(146,5,'','4,,.jpg','130.0000','2007-05-11 00:46:11',NULL,NULL,'5.00',1,0,0,0),(147,5,'','555.jpg','130.0000','2007-05-11 00:48:00','2007-06-03 00:19:56',NULL,'5.00',1,0,0,0),(148,5,'','7,,.jpg','26.0000','2007-05-11 00:55:53','2007-05-18 01:03:49',NULL,'2.00',1,0,0,0),(149,5,'','6,,.jpg','45.0000','2007-05-11 00:59:03','2007-05-11 01:13:22',NULL,'2.00',1,0,0,0),(150,5,'','37.jpg','1500.0000','2007-05-17 22:02:35','2007-08-07 00:32:54',NULL,'45.00',1,0,0,0),(151,5,'','39.jpg','130.0000','2007-05-17 22:10:34','2007-05-17 22:52:40',NULL,'5.00',1,0,0,0),(152,4,'','38.jpg','130.0000','2007-05-17 22:14:49','2007-05-17 22:49:19',NULL,'5.00',1,0,0,0),(153,5,'','42.jpg','450.0000','2007-06-06 14:19:04','2007-06-06 14:20:29',NULL,'0.00',1,0,0,0),(154,5,'','40.jpg','250.0000','2007-06-06 14:47:04',NULL,'2007-06-07 00:00:00','0.00',1,0,0,0),(155,5,'','41.jpg','260.0000','2007-06-06 14:53:27',NULL,NULL,'0.00',1,0,0,0),(156,5,'','43.jpg','75.0000','2007-06-06 15:09:41',NULL,NULL,'0.00',1,0,0,0),(157,5,'','40,.jpg','290.0000','2007-06-06 17:30:55',NULL,NULL,'0.00',1,0,0,0),(158,5,'','44.jpg','100.0000','2007-06-06 17:39:22',NULL,NULL,'0.00',1,0,0,0),(159,3,'','62.jpg','150.0000','2007-07-06 00:18:18',NULL,NULL,'6.00',1,0,0,0),(160,3,'','63.jpg','150.0000','2007-07-06 00:24:07',NULL,NULL,'0.00',1,0,0,0),(162,5,'','71.jpg','100.0000','2007-07-10 00:26:45',NULL,NULL,'5.00',1,0,0,0),(163,3,'','68.jpg','100.0000','2007-07-10 00:29:42',NULL,NULL,'5.00',1,0,0,0),(164,3,'','69.jpg','100.0000','2007-07-10 00:34:33',NULL,NULL,'5.00',1,0,0,0),(165,3,'','70.jpg','100.0000','2007-07-10 00:37:05',NULL,NULL,'4.00',1,0,0,0),(166,3,'','67.jpg','100.0000','2007-07-10 00:39:39',NULL,NULL,'5.00',1,0,0,0),(169,5,'','1 GOLFISTA ALT 34 200,00.jpg','190.0000','2007-07-29 03:00:54',NULL,NULL,'7.00',1,0,0,0),(170,5,'','Gu 08-07-07 015.jpg','200.0000','2007-08-03 00:15:50','2007-08-03 00:16:49',NULL,'12.00',1,0,0,0),(171,5,'','Gu 08-07-07 016.jpg','260.0000','2007-08-03 00:20:53',NULL,NULL,'16.00',1,0,0,0),(174,5,'','DSC00485.JPG','130.0000','2007-08-03 20:58:38',NULL,NULL,'0.00',1,0,0,0),(175,5,'','114.JPG','440.0000','2007-08-03 21:11:12','2007-08-04 13:44:52',NULL,'0.00',1,0,0,0),(176,4,'','112.JPG','220.0000','2007-08-03 21:16:29','2007-08-03 21:30:16',NULL,'0.00',1,0,0,1); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_attributes` -- DROP TABLE IF EXISTS `products_attributes`; CREATE TABLE `products_attributes` ( `products_attributes_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `options_id` int(11) NOT NULL default '0', `options_values_id` int(11) NOT NULL default '0', `options_values_price` decimal(15,4) NOT NULL default '0.0000', `price_prefix` char(1) NOT NULL default '', PRIMARY KEY (`products_attributes_id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_attributes` -- LOCK TABLES `products_attributes` WRITE; /*!40000 ALTER TABLE `products_attributes` DISABLE KEYS */; /*!40000 ALTER TABLE `products_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_attributes_download` -- DROP TABLE IF EXISTS `products_attributes_download`; CREATE TABLE `products_attributes_download` ( `products_attributes_id` int(11) NOT NULL default '0', `products_attributes_filename` varchar(255) NOT NULL default '', `products_attributes_maxdays` int(2) default '0', `products_attributes_maxcount` int(2) default '0', PRIMARY KEY (`products_attributes_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_attributes_download` -- LOCK TABLES `products_attributes_download` WRITE; /*!40000 ALTER TABLE `products_attributes_download` DISABLE KEYS */; INSERT INTO `products_attributes_download` (`products_attributes_id`, `products_attributes_filename`, `products_attributes_maxdays`, `products_attributes_maxcount`) VALUES (26,'unreal.zip',7,3); /*!40000 ALTER TABLE `products_attributes_download` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_description` -- DROP TABLE IF EXISTS `products_description`; CREATE TABLE `products_description` ( `products_id` int(11) NOT NULL auto_increment, `language_id` int(11) NOT NULL default '1', `products_name` varchar(64) NOT NULL default '', `products_description` text, `products_url` varchar(255) default NULL, `products_viewed` int(5) default '0', PRIMARY KEY (`products_id`,`language_id`), KEY `products_name` (`products_name`) ) ENGINE=MyISAM AUTO_INCREMENT=177 DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_description` -- LOCK TABLES `products_description` WRITE; /*!40000 ALTER TABLE `products_description` DISABLE KEYS */; INSERT INTO `products_description` (`products_id`, `language_id`, `products_name`, `products_description`, `products_url`, `products_viewed`) VALUES (42,4,'CAVALO EMPINADO','CAVALO EMPINADO \r\nALT 0.71','',13),(43,4,'CAVALO COM ARREIO','CAVALO \r\nALT 0.28','',12),(44,4,'CAVALO','CAVALO\r\nALT 0.28','',11),(45,4,'BUSTO DE CAVALO PQ','BUSTO DE CAVALO PQ COM BASE DE MARMORE\r\nALT 0.15','',12),(46,4,'CAVALINHO ALT 0.21','','',16),(47,4,'CAVALINHO DUPLO','','',9),(48,4,'CAVALO MEDIO','','',12),(49,4,'CAVALO DUPLO MEDIO','CAVALO DUPLO\r\nALT 0.38 X LARG 0.43','',15),(50,4,'CAVALO CORREDOR','CAVALO CORREDOR \r\nALT 0.32 X LARG 0.48','',6),(51,4,'CAVALO EMPINADO MEDIO','CAVALO EMPINADO \r\nALT 0.48','',11),(52,4,'CENTAURO','CENTAURO \r\nALT 0.48 X LARG 0.42','',7),(53,4,'CAVALO ARABE ALT 0.80 X LARG 0.54','CAVALO ARABE \r\nALT 0.80 X LARG 0.54','',21),(54,4,'CABEÇA DE CAVALO','CABEÇA DE CAVALO \r\nALT 0.56','',9),(55,4,'CAVALO EMPINADO GRANDE 2','CAVALO EMPINADO 2 \r\n ALT 0.48 X LARG 0.37','',16),(56,4,'CAVALO EMPINADO PQ','CAVALO EMPINADO PEQUENO\r\nALT 0.35 X LARG 0.25','',10),(57,4,'CAVALO EMPINADO GRANDE SEM GRINA','CAVALO EMPINADO GRANDE SEM GRINA\r\nALT 0.71','',11),(58,4,'CAVALO EMPINADO MEDIO','CAVALO EMPINADO MEDIO \r\nALT 0.36','',13),(59,4,'CAVALO EMPINADO MEDIO 1','CAVALO EMPINADO MEDIO 1\r\nALT 0.35','',10),(61,4,'justiça grande','justiça grande \r\nalt 1.05','',18),(62,4,'justiça media','justiça media \r\nalt 0.94','',13),(63,4,'justiça','justiça \r\nalt 0.58','',14),(64,4,'justiça 1','justiça 1 \r\nalt 0.56','',10),(65,4,'justiça pequena','JUSTIÇA PEQUENA\r\nALT 0.33','',14),(66,4,'JUSTIÇA BUSTO ALT 0.40','JUSTIÇA BUSTO \r\nALT 0.40','',9),(67,4,'BUSTO DE JUSTIÇA PEQUENO','BUSTO DE JUSTIÇA PEQUENO COM BASE DE MARMORE\r\nALT 0.15','',18),(68,4,'BUSTO DE JUSTIÇA MEDIO','BUSTO DE JUSTIÇA MEDIO COM BASE DE MARMORE\r\nALT 0.21','',23),(167,4,'DECOR ALT 40 CM','','',11),(168,4,'DECO COM SAIA TULIPA EM VIDRO COLORIDO ALT 37','1 190,00','',8),(169,4,'GOLFISTA ALT 34 CM','','',15),(77,4,'ABAJUR MULHER ALT 0.45','','',13),(170,4,'CAVALO EMPINADO MEDIO 2','','',7),(79,4,'ABAJUR MULHER DAMA ALT 0.59','','',8),(80,4,'ABAJUR ESCULTURA MULHER ALT 0.56','','',7),(81,4,'ABAJUR MENINO ALT 0.65','','',8),(82,4,'ABAJUR MENINO ANJO ALT 0.63','','',7),(83,4,'ABAJUR MULHER SENTADA ALT 0.41','','',16),(84,4,'MENINO ANJO ALT 0,35','','',15),(85,4,'MENINO ALT 0.35','','',4),(86,4,'DANÇARINA ALT 0.51','','',5),(87,4,'ABAJUR XUXA ALT 0.48','','',12),(88,4,'ABAJUR BAILARINA ALT 0.45','','',18),(89,4,'ABAJUR DECO ALT 0.41','','',9),(90,4,'LEÃO ALT 0.28 X 0.47','','',11),(91,4,'CABEÇA DE TIGRE DUPLO ALT 0.20 X 0.26 X 0.17','CABEÇA DE TIGRE DUPLO COM BASE DE MARMORE\r\nALT 0.20 X 0.26 X 0.17','',13),(92,4,'ARNOVO ALT 0.94','','',13),(93,4,'LIBELULA GRANDE ALT 1.05','','',4),(94,4,'LIBELULA MEDIA ALT 0.72','','',1),(95,4,'DECO PELADA ALT 0.92','','',7),(96,4,'PALOMA ALT 0.88','','',1),(97,4,'MULHER TOCHA ALT 0.95','','',1),(98,4,'GREGA ALT 0.96','','',5),(99,4,'GUERREIRO ALT 1.20','','',2),(100,4,'CHIPARROS ALT 0.47 X 0.47 X0.14','','',11),(101,4,'CHIPARROS COM LUMINARIA DE CANO ALT 0.80','','',3),(102,4,'CHIPARROS ALT 0.64','','',8),(103,4,'CHIPARROS GRANDE ALT 1.28','','',15),(104,4,'COLINETE ALT 0.79','','',8),(105,4,'ANJÃO ALT 0.75','','',12),(106,4,'CORAÇAO ALT 0.64','','',12),(107,4,'DECO PELADA GRANDE ALT 0.70','','',2),(108,4,'DECO PELADA MEDIA ALT 0.58','','',3),(109,4,'DECO PELADA PEQUENA ALT 0.49','','',10),(110,4,'COLINE ALT 2.10','','',12),(111,4,'CABELUDA ALT 0.64','','',11),(112,4,'NICOLI ALT 0.54','','',10),(113,4,'DECO ROMANA ALT 0.63','','',6),(114,4,'DECO ANTIGA ALT 0.62','','',10),(115,4,'MENINO ANJO ALT 0.60','','',3),(116,4,'ANJO COM LUMINARIA DE CANO ALT 0.53','','',9),(117,4,'PAR DE ANJINHOS ALT 0.34','','',12),(118,4,'PELADO COM LUMINARIA ALT 0.65','','',8),(119,4,'PELADO ALT 0.55','','',6),(120,4,'VELHO ARABE ALT 0.40','','',6),(121,4,'FERREIRO COM LUMINARIA ALT 0.68','','',9),(122,4,'FERREIRO COM LUMINARIA ALT 0.79','','',2),(123,4,'MULHER COM LUMINARIA ALT 0.50','','',7),(124,4,'BAILARINA COM LUMINARIA DE CANO ALT 0.60','','',7),(125,4,'MENINO ANJO COM LUMINARIA ALT 0.41','','',8),(126,4,'MULHER DO VASO ALT 0.62','','',6),(127,4,'FONTE DE RESINA COM LUMINARIA ALT 0.65','','',38),(128,4,'FONTE DE RESINA SEM LUMINARIA ALT 0.65','','',59),(129,4,'LINDA PEÇA FRANCESA ALT 0.53','','',24),(130,4,'LINDA PEÇA FRANCESA 1 ALT 0.53','','',17),(131,4,'INDIO COM AGUIA ALT 0.25','','',12),(132,4,'INDIO COM URSO ALT 0.27','','',15),(133,4,'INDIO COM AGUIA ALT 0.26','','',13),(134,4,'INDIO COM BUFALO ALT 0.28','','',22),(135,4,'INDIO EM PÉ GRDE ALT 0.39','','',19),(136,4,'CAVALO EMPINADO GRANDE 3 ALT 0.94','','',18),(137,4,'ANJO CONOCOPIO ALT 0.54','','',17),(138,4,'ANJO CUPIDO ALT 0.54','','',25),(139,4,'DANÇARINA 1 ALT 0.56','','',33),(140,4,'PRÉ-HISTORICO ALT 0.60','','',24),(141,4,'MULHER DO ESPELHO ALT 0.60','','',33),(142,4,'BUSTO MULHER ALT 0.21','','',27),(143,4,'TROFÉU ADVOGADO ALT 19 X 30 X 15','','',20),(144,4,'TROFÉU ODONTOLOGIA ALT 18 X 30 X 12','','',29),(145,4,'TROFÉU ADMINISTRAÇÃO ALT 18 X 30 X 12','','',25),(146,4,'TROFÉU ENGENHARIA ALT 18 X 30 X 12','','',26),(147,4,'TROFÉU MEDICINA ALT 18 X 30 X 12','','',27),(148,4,'MÃO HORIZONTAL MEDICINA ALT 11 X 4 X 10','','',32),(149,4,'PEDRA SIMBOLO DIREITO ALT 9 X 5 X 18','','',37),(150,4,'COLINE ALT 2.10','','',57),(151,4,'MULHER ALT 0.45','','',34),(152,4,'ESCULTURA MULHER ALT 0.45','','',36),(153,4,'AMIZADE ALT 1.08','','',35),(154,4,'GUIOMAR ALT 0,89','','',25),(155,4,'MULHER COM VASO ALT 0,85','','',25),(156,4,'URSO ALT 16 X 20 X 14','','',34),(157,4,'GUIOMAR COM RAMO ALT 0,89','','',26),(158,4,'LEÃO ALT 0.20 X 0.30 X 10','','',37),(159,4,'CAVALO COM POTRO ALT 19 X 19 X 29','CAVALO COM POTRO ALT 19 X 19 X 29','',19),(160,4,'CAVALO BIGA MEDIA ALT 22 X 11 X 29','CAVALO BIGA MEDIA ALT 22 X 11 X 29','',21),(162,4,'LUMINARIA COM CANO ALT 0,54','','',19),(163,4,'LUMINARIA COM CANO ALT 0,55','','',10),(164,4,'LUMINARIA COM CANO (1) ALT 0,50','','',19),(165,4,'LUMINARIA COM CANO (2) ALT 0,50','','',18),(166,4,'LUMINARIA COM CANO (3) ALT 0,50','','',16),(171,4,'CAVALO COM CAVALEIRO','','',8),(174,4,'BUSTO MENINA COM BASE DE MARMORE ALT 25 X 25 X 15','','',5),(175,4,'FRUTEIRA COM 3 BACIAS ALT 0,45','MEDIDAS DAS BACIAS \r\n*BACIA PEQUENA 22 X 7 CM DE PROFUNDIDADE\r\n*BACIA GRANDE 35 X 8 CM DE PROFUNDIDADE','',8),(176,4,'FRUTEIRA COM 1 BACIA ALT 0,44','MEDIDAS DAS BACIAS \r\n*BACIA PEQUENA 22 X 7 CM DE PROFUNDIDADE\r\n*BACIA GRANDE 35 X 8 CM DE PROFUNDIDADE','',6),(41,4,'AGUIA PEQUENA','AGUIA PEQUENA COM BASE DE MARMORE\r\nALT 0.21 X LARG 0.15','',18),(69,4,'ABAJUR BAILARINA CADEIRA','ABAJUR BAILARINA CADEIRA\r\nALT 0,46','',14),(70,4,'ABAJUR BAILARINA HARPA','ABAJUR BAILARINA HARPA\r\nALT 0.46','',8),(71,4,'ABAJUR BAILARINA VIOLONCELO','ABAJUR BAILARINA VIOLONCELO\r\nALT 0.46','',10),(39,4,'AGUIA MEDIA 2','AGUIA MEDIA 2 \r\nALT 0.54 X LARG 0.40','',13),(40,4,'AGUIA GRANDE','AGUIA GRANDE\r\nALT 0.71 X LARG 0.67','',22),(32,4,'Cavalo Ingles','CAVALO INGLES ALT 0,33 X LARG 0,37','',48),(73,4,'ABAJUR CAMPONESA FLORES','ABAJUR CAMPONESA FLORES\r\nALT 0.52','',7),(33,4,'Cavalo busto','BUSTO DE CAVALO ALT 0,28 COM BASE DE MARMORE','',15),(72,4,'ABAJUR BAILARINA SENTADA','ABAJUR BAILARINA SENTADA\r\nALT 0.46','',12),(34,4,'Biga','CAVALO BIGA \r\nALT 0.46 X LARG 0.56','',25),(38,4,'AGUIA MEDIA','','',22); /*!40000 ALTER TABLE `products_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_notifications` -- DROP TABLE IF EXISTS `products_notifications`; CREATE TABLE `products_notifications` ( `products_id` int(11) NOT NULL default '0', `customers_id` int(11) NOT NULL default '0', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`products_id`,`customers_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_notifications` -- LOCK TABLES `products_notifications` WRITE; /*!40000 ALTER TABLE `products_notifications` DISABLE KEYS */; INSERT INTO `products_notifications` (`products_id`, `customers_id`, `date_added`) VALUES (0,3,'2004-10-03 19:00:49'),(2,3,'2004-10-03 20:31:28'),(0,1,'2007-04-20 18:05:02'),(128,6,'2007-07-22 23:02:32'); /*!40000 ALTER TABLE `products_notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_options` -- DROP TABLE IF EXISTS `products_options`; CREATE TABLE `products_options` ( `products_options_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_name` varchar(32) NOT NULL default '', PRIMARY KEY (`products_options_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_options` -- LOCK TABLES `products_options` WRITE; /*!40000 ALTER TABLE `products_options` DISABLE KEYS */; INSERT INTO `products_options` (`products_options_id`, `language_id`, `products_options_name`) VALUES (1,4,'Cor'),(2,4,'Size'),(3,4,'Modelo'),(4,4,'Memoria'),(5,4,'Versão'); /*!40000 ALTER TABLE `products_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_options_values` -- DROP TABLE IF EXISTS `products_options_values`; CREATE TABLE `products_options_values` ( `products_options_values_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `products_options_values_name` varchar(64) NOT NULL default '', PRIMARY KEY (`products_options_values_id`,`language_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_options_values` -- LOCK TABLES `products_options_values` WRITE; /*!40000 ALTER TABLE `products_options_values` DISABLE KEYS */; INSERT INTO `products_options_values` (`products_options_values_id`, `language_id`, `products_options_values_name`) VALUES (1,4,'4 mb'),(2,4,'8 mb'),(3,4,'16 mb'),(4,4,'32 mb'),(5,4,'Value'),(6,4,'Premium'),(7,4,'Deluxe'),(8,4,'PS/2'),(9,4,'USB'),(10,4,'Download: Windows - English'),(13,4,'Box: Windows - English'); /*!40000 ALTER TABLE `products_options_values` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_options_values_to_products_options` -- DROP TABLE IF EXISTS `products_options_values_to_products_options`; CREATE TABLE `products_options_values_to_products_options` ( `products_options_values_to_products_options_id` int(11) NOT NULL auto_increment, `products_options_id` int(11) NOT NULL default '0', `products_options_values_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_options_values_to_products_options_id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_options_values_to_products_options` -- LOCK TABLES `products_options_values_to_products_options` WRITE; /*!40000 ALTER TABLE `products_options_values_to_products_options` DISABLE KEYS */; INSERT INTO `products_options_values_to_products_options` (`products_options_values_to_products_options_id`, `products_options_id`, `products_options_values_id`) VALUES (1,4,1),(2,4,2),(3,4,3),(4,4,4),(5,3,5),(6,3,6),(7,3,7),(8,3,8),(9,3,9),(10,5,10),(13,5,13); /*!40000 ALTER TABLE `products_options_values_to_products_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products_to_categories` -- DROP TABLE IF EXISTS `products_to_categories`; CREATE TABLE `products_to_categories` ( `products_id` int(11) NOT NULL default '0', `categories_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`,`categories_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `products_to_categories` -- LOCK TABLES `products_to_categories` WRITE; /*!40000 ALTER TABLE `products_to_categories` DISABLE KEYS */; INSERT INTO `products_to_categories` (`products_id`, `categories_id`) VALUES (32,22),(33,22),(34,22),(38,23),(39,23),(40,23),(41,23),(42,22),(43,22),(44,22),(45,22),(46,22),(47,22),(48,22),(49,22),(50,22),(51,22),(52,22),(53,22),(54,22),(55,22),(56,22),(57,22),(58,22),(59,22),(61,25),(62,25),(63,25),(64,25),(65,25),(66,25),(67,25),(68,25),(69,26),(70,26),(71,26),(72,26),(73,26),(77,26),(79,26),(80,26),(81,26),(82,26),(83,26),(84,26),(85,26),(86,26),(87,26),(88,26),(89,26),(90,27),(91,27),(92,26),(93,26),(94,26),(95,26),(96,26),(97,26),(98,26),(99,26),(100,26),(101,26),(102,26),(103,26),(104,26),(105,26),(106,26),(107,26),(108,26),(109,26),(110,26),(111,26),(112,26),(113,26),(114,26),(115,26),(116,26),(117,26),(118,26),(119,26),(120,26),(121,26),(122,26),(123,26),(124,26),(125,26),(126,26),(127,31),(128,31),(129,30),(130,30),(131,30),(132,30),(133,30),(134,30),(135,30),(136,22),(137,26),(138,26),(139,26),(140,30),(141,30),(142,30),(143,32),(144,32),(145,32),(146,32),(147,32),(148,32),(149,32),(150,30),(151,30),(152,30),(153,26),(154,26),(155,26),(156,30),(157,26),(158,27),(159,22),(160,22),(162,26),(163,26),(164,26),(165,26),(166,26),(167,26),(168,30),(169,30),(170,22),(171,22),(174,30),(175,34),(176,34); /*!40000 ALTER TABLE `products_to_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reviews` -- DROP TABLE IF EXISTS `reviews`; CREATE TABLE `reviews` ( `reviews_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `customers_id` int(11) default NULL, `customers_name` varchar(64) NOT NULL default '', `reviews_rating` int(1) default NULL, `date_added` datetime default NULL, `last_modified` datetime default NULL, `reviews_read` int(5) NOT NULL default '0', PRIMARY KEY (`reviews_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `reviews` -- LOCK TABLES `reviews` WRITE; /*!40000 ALTER TABLE `reviews` DISABLE KEYS */; INSERT INTO `reviews` (`reviews_id`, `products_id`, `customers_id`, `customers_name`, `reviews_rating`, `date_added`, `last_modified`, `reviews_read`) VALUES (1,128,6,'tere silveira',5,'2007-07-01 22:14:57',NULL,28); /*!40000 ALTER TABLE `reviews` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reviews_description` -- DROP TABLE IF EXISTS `reviews_description`; CREATE TABLE `reviews_description` ( `reviews_id` int(11) NOT NULL default '0', `languages_id` int(11) NOT NULL default '0', `reviews_text` text NOT NULL, PRIMARY KEY (`reviews_id`,`languages_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `reviews_description` -- LOCK TABLES `reviews_description` WRITE; /*!40000 ALTER TABLE `reviews_description` DISABLE KEYS */; INSERT INTO `reviews_description` (`reviews_id`, `languages_id`, `reviews_text`) VALUES (1,4,'Gostaria de saber se as fontes existem em cores brancas....desde já, muito obrigada , terezinha....'); /*!40000 ALTER TABLE `reviews_description` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `sesskey` varchar(32) NOT NULL default '', `expiry` int(11) unsigned NOT NULL default '0', `value` text NOT NULL, PRIMARY KEY (`sesskey`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` (`sesskey`, `expiry`, `value`) VALUES ('273540341f1deac6fc8c8c1f8fc6c4b2',1186695319,'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:2:\"22\";s:11:\"products_id\";s:2:\"49\";s:6:\"osCsid\";s:32:\"273540341f1deac6fc8c8c1f8fc6c4b2\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('b474c4804c7d3c4f79dfe2e1b721e066',1186661779,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:2:\"22\";s:11:\"products_id\";s:3:\"171\";s:6:\"osCsid\";s:32:\"b474c4804c7d3c4f79dfe2e1b721e066\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('38164fa020a17726be5f897e2a453b0a',1186664094,'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"products_new.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:4:\"page\";s:1:\"6\";s:6:\"osCsid\";s:32:\"38164fa020a17726be5f897e2a453b0a\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('e2be7ba796d32a59ef0157760ce78282',1186669753,'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:5:\"cPath\";s:2:\"30\";s:6:\"osCsid\";s:32:\"e2be7ba796d32a59ef0157760ce78282\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('c8b3ba02b85f15d3667d450520ff0d0d',1186676515,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('9b88266dfce15a201cf0fad9ead205fe',1186691828,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:2:\"32\";s:11:\"products_id\";s:3:\"145\";s:6:\"osCsid\";s:32:\"9b88266dfce15a201cf0fad9ead205fe\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('4ec6d37e5032507294f83063d565bf98',1186695346,'cart|O:12:\"shoppingcart\":5:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:6:\"cartID\";N;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:2:{i:0;a:4:{s:4:\"page\";s:19:\"product_reviews.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:3:\"156\";s:6:\"osCsid\";s:32:\"4ec6d37e5032507294f83063d565bf98\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:2:\"26\";s:11:\"products_id\";s:2:\"82\";s:6:\"osCsid\";s:32:\"4ec6d37e5032507294f83063d565bf98\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('b2c55f71f8057020f2f31229dfc8cc13',1186695313,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:3:{s:5:\"cPath\";s:2:\"26\";s:11:\"products_id\";s:3:\"153\";s:6:\"osCsid\";s:32:\"b2c55f71f8057020f2f31229dfc8cc13\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('6eab86fc0ccdec5f0da026a3e4ded593',1186695327,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:0:{}s:8:\"snapshot\";a:0:{}}'),('9e7271fa522c5d7373efc7ff4e148f02',1186695329,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:0:{}s:8:\"snapshot\";a:0:{}}'),('b5e8a4ed4684c4f144e36558cf2852f2',1186695408,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:19:\"product_reviews.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:11:\"products_id\";s:3:\"159\";s:6:\"osCsid\";s:32:\"b5e8a4ed4684c4f144e36558cf2852f2\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('032db4e9c228fcca0c4198bb6e20b32c',1186698079,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('a75d9ca164b4bad6f60160f2532fe9c8',1186699947,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'),('bfa34bed2fe340fe63561409aa2f39d9',1186700379,'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:9:\"portugues\";languages_id|s:1:\"4\";currency|s:2:\"BR\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:0:{}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}'); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `specials` -- DROP TABLE IF EXISTS `specials`; CREATE TABLE `specials` ( `specials_id` int(11) NOT NULL auto_increment, `products_id` int(11) NOT NULL default '0', `specials_new_products_price` decimal(15,4) NOT NULL default '0.0000', `specials_date_added` datetime default NULL, `specials_last_modified` datetime default NULL, `expires_date` datetime default NULL, `date_status_change` datetime default NULL, `status` int(1) NOT NULL default '1', PRIMARY KEY (`specials_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; -- -- Dumping data for table `specials` -- LOCK TABLES `specials` WRITE; /*!40000 ALTER TABLE `specials` DISABLE KEYS */; /*!40000 ALTER TABLE `specials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax_class` -- DROP TABLE IF EXISTS `tax_class`; CREATE TABLE `tax_class` ( `tax_class_id` int(11) NOT NULL auto_increment, `tax_class_title` varchar(32) NOT NULL default '', `tax_class_description` varchar(255) NOT NULL default '', `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_class_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tax_class` -- LOCK TABLES `tax_class` WRITE; /*!40000 ALTER TABLE `tax_class` DISABLE KEYS */; INSERT INTO `tax_class` (`tax_class_id`, `tax_class_title`, `tax_class_description`, `last_modified`, `date_added`) VALUES (1,'Taxable Goods','The following types of products are included non-food, services, etc','2004-10-03 10:13:34','2004-10-03 10:13:34'); /*!40000 ALTER TABLE `tax_class` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tax_rates` -- DROP TABLE IF EXISTS `tax_rates`; CREATE TABLE `tax_rates` ( `tax_rates_id` int(11) NOT NULL auto_increment, `tax_zone_id` int(11) NOT NULL default '0', `tax_class_id` int(11) NOT NULL default '0', `tax_priority` int(5) default '1', `tax_rate` decimal(7,4) NOT NULL default '0.0000', `tax_description` varchar(255) NOT NULL default '', `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`tax_rates_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; -- -- Dumping data for table `tax_rates` -- LOCK TABLES `tax_rates` WRITE; /*!40000 ALTER TABLE `tax_rates` DISABLE KEYS */; INSERT INTO `tax_rates` (`tax_rates_id`, `tax_zone_id`, `tax_class_id`, `tax_priority`, `tax_rate`, `tax_description`, `last_modified`, `date_added`) VALUES (1,0,1,0,'0.0000','','2004-10-25 19:18:49','2004-10-03 10:13:34'); /*!40000 ALTER TABLE `tax_rates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `whos_online` -- DROP TABLE IF EXISTS `whos_online`; CREATE TABLE `whos_online` ( `customer_id` int(11) default NULL, `full_name` varchar(64) NOT NULL default '', `session_id` varchar(128) NOT NULL default '', `ip_address` varchar(15) NOT NULL default '', `time_entry` varchar(14) NOT NULL default '', `time_last_click` varchar(14) NOT NULL default '', `last_page_url` varchar(64) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `whos_online` -- LOCK TABLES `whos_online` WRITE; /*!40000 ALTER TABLE `whos_online` DISABLE KEYS */; INSERT INTO `whos_online` (`customer_id`, `full_name`, `session_id`, `ip_address`, `time_entry`, `time_last_click`, `last_page_url`) VALUES (0,'Guest','a75d9ca164b4bad6f60160f2532fe9c8','200.225.159.38','1186698506','1186698506','/'),(0,'Guest','bfa34bed2fe340fe63561409aa2f39d9','189.6.252.132','1186698938','1186698938','/'); /*!40000 ALTER TABLE `whos_online` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zones` -- DROP TABLE IF EXISTS `zones`; CREATE TABLE `zones` ( `zone_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL default '0', `zone_code` varchar(32) NOT NULL default '', `zone_name` varchar(32) NOT NULL default '', PRIMARY KEY (`zone_id`) ) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1; -- -- Dumping data for table `zones` -- LOCK TABLES `zones` WRITE; /*!40000 ALTER TABLE `zones` DISABLE KEYS */; INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES (62,30,'AC','Acre'),(63,30,'AL','Alagoas'),(64,30,'AP','Amapa'),(65,30,'AM','Amazonas'),(66,30,'BA','Bahia'),(67,30,'CE','Ceara'),(68,30,'DF','Distrito Federal'),(69,30,'ES','Espirito Santo'),(70,30,'GO','Goias'),(71,30,'MA','Maranhao'),(72,30,'MT','Mato Grosso'),(73,30,'MS','Mato Grosso do Sul'),(74,30,'MG','Minas Gerais'),(75,30,'PA','Para'),(76,30,'PB','Paraiba'),(77,30,'PR','Parana'),(78,30,'PE','Pernambuco'),(79,30,'PI','Piaui'),(80,30,'RJ','Rio de Janeiro'),(81,30,'RN','Rio Grande do Norte'),(82,30,'RS','Rio Grande do Sul'),(83,30,'RO','Rondonia'),(84,30,'RR','Roraima'),(85,30,'SC','Santa Catarina'),(86,30,'SP','Sao Paulo'),(87,30,'SE','Sergipe'),(88,30,'TO','Tocantins'); /*!40000 ALTER TABLE `zones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zones_to_geo_zones` -- DROP TABLE IF EXISTS `zones_to_geo_zones`; CREATE TABLE `zones_to_geo_zones` ( `association_id` int(11) NOT NULL auto_increment, `zone_country_id` int(11) NOT NULL default '0', `zone_id` int(11) default NULL, `geo_zone_id` int(11) default NULL, `last_modified` datetime default NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`association_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `zones_to_geo_zones` -- LOCK TABLES `zones_to_geo_zones` WRITE; /*!40000 ALTER TABLE `zones_to_geo_zones` DISABLE KEYS */; /*!40000 ALTER TABLE `zones_to_geo_zones` ENABLE KEYS */; UNLOCK TABLES; /*!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 */;