# osCommerce, Open Source E-Commerce Solutions
# http://www.oscommerce.com
#
# Database Backup For Infoelec Growshop
# Copyright (c) 2008 Infoelec Growshop
#
# Database: infoelec_osc1
# Database Server: localhost
#
# Backup Date: 03/02/2008 21:18:40

drop table if exists address_book;
create table address_book (
  address_book_id int(11) not null auto_increment,
  customers_id int(11) default '0' not null ,
  entry_gender char(1) not null ,
  entry_company varchar(32) ,
  entry_firstname varchar(32) not null ,
  entry_lastname varchar(32) not null ,
  entry_street_address varchar(64) not null ,
  entry_suburb varchar(32) ,
  entry_postcode varchar(10) not null ,
  entry_city varchar(32) not null ,
  entry_state varchar(32) ,
  entry_country_id int(11) default '0' not null ,
  entry_zone_id int(11) default '0' not null ,
  PRIMARY KEY (address_book_id),
  KEY idx_address_book_customers_id (customers_id)
);

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 ('2', '2', '', NULL, 'Luis', 'Leitão', 'Pct. Prof. Dr. Bento Jesus Caraça, nº 15 - 4º Esq', NULL, '2745-082', 'Queluz', NULL, '171', '0');
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 ('3', '3', '', NULL, 'Pedro', 'Santos', '12 The Place, Dunboyne Castle', NULL, 'Dunboyne', 'County Meath', NULL, '103', '0');
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', '', NULL, 'Jorge', 'Miguel', 'Rua Teófilo Braga, nº53', NULL, '7090-286', 'Viana do Alentejo', NULL, '171', '0');
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 ('5', '5', '', NULL, 'Cristiana', 'Pereira', 'Pct. Prof. Dr. Bento Jesus Caraça, nº 15 - 4º Esq', NULL, '2745-082', 'Queluz', NULL, '171', '0');
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 ('6', '6', '', NULL, 'Nuno', 'Rodrigues', 'Rua condessa cuba n 10', NULL, '2780', 'Oeiras', NULL, '171', '0');
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 ('7', '7', '', NULL, 'Marcelo', 'Rodrigues', 'Rua da Cidade de Bruxelas', NULL, '2725-852', 'Cacém', NULL, '171', '0');
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 ('8', '8', '', NULL, 'Maria', 'Casoma', 'Rua António Joaquim Araújo,nº38,3ºdt', NULL, '2300-555', 'Tomar', NULL, '171', '0');
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 ('9', '9', '', NULL, 'Eduardo', 'Fortes', 'travessa do lagar,nº1', NULL, '2450-051', 'fanhais', NULL, '171', '0');
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 ('10', '10', '', NULL, 'Hugo', 'André', 'Vivenda Romão, S/n - Freiria', NULL, '2785-511 S', 'Cascais', NULL, '171', '0');
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 ('11', '11', '', NULL, 'pablo', 'hernandez', 'rua do patrocinio nº 16-A', NULL, '1350', 'Lisboa', NULL, '171', '0');
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 ('12', '12', '', NULL, 'Alexandre', 'Oliveira', 'Rua Gonçalves Crespo nº12 R/C', NULL, '2650-241', 'Amadora', NULL, '171', '0');
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 ('13', '13', '', NULL, 'Jose', 'Engrola', 'baldios lote 1 pedrogao do alentejo', NULL, '7960-024', 'pedrogao do alentejo', NULL, '171', '0');
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 ('14', '13', '', NULL, 'jose', 'Engrola', 'baldios lote 1 pedrogao do alentejo', NULL, '7960-024 v', 'pedrogao do alentejo', NULL, '171', '0');
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 ('15', '13', '', NULL, 'jose', 'Engrola', 'baldios lote 1', NULL, '7960-024 p', 'vidigueira', NULL, '171', '0');
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 ('16', '13', '', NULL, 'jose', 'Engrola', 'baldios lote 1 PEDROGAO DO ALENTEJO', NULL, '7960-024', 'vidigueira', NULL, '171', '0');
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 ('17', '14', '', NULL, 'Antonio', 'Braz', 'Caminho currais de ourem - Arm.C - Codiceira', NULL, '2710', 'S.João das Lampas - Terrugem - S', NULL, '171', '0');
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 ('18', '15', '', NULL, 'dinis', 'dias', 'Rua do Patrocínio, nº26-A', NULL, '1350', 'Lisboa', NULL, '171', '0');
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 ('19', '16', '', NULL, 'Tiago', 'Amarante', 'Little Chippings, Crewkerne Road', NULL, 'TA20-4DL', 'Chard, Somerset', NULL, '222', '0');
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 ('22', '19', '', NULL, 'João', 'Sousa', 'Rua cardal', NULL, '1150-088', 'lisboa', NULL, '171', '0');
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 ('21', '18', '', NULL, 'tel', 'mix', 'rua lindo vale 475 1º andar', NULL, '4000', 'porto', NULL, '171', '0');
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 ('23', '20', '', NULL, 'Ricardo', 'Fernandes', 'Rua Arqueólogo Mário Cardoso 11', NULL, '4800-035', 'Guimarães', NULL, '171', '0');
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 ('24', '21', '', NULL, 'Infoelec', 'Growshop', 'R. Dr. Manuel de Arriaga, Nº 17', NULL, '2745-152', 'Queluz', NULL, '171', '0');
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 ('25', '22', '', NULL, 'jadson', 'freire', 'alameda praia de siriuba,qe,lote 20,condominio verdes mares casa', NULL, '41600065', 'salvador', NULL, '30', '0');
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 ('26', '23', '', NULL, 'Paulo', 'Lopes', 'sitio da graça - caminho florinda', NULL, '9200-077', 'Machico - Madeira', NULL, '171', '0');
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 ('27', '24', '', NULL, 'pedro', 'carmo', 'largo republicaa turquia nº4 1esq', NULL, '1640', 'lisboa', NULL, '171', '0');
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 ('28', '24', '', NULL, 'pedro', 'carmo', 'rua rio minho boa agua 1 quinta do conde lote 311 312', NULL, '2975-329', 'sesimbra', NULL, '171', '0');
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 ('29', '25', '', NULL, 'Hugo', 'Loja', 'R. Dr. Manuel de Arriaga, Nº 17', NULL, '2745-153', 'Queluz', NULL, '171', '0');
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 ('30', '26', '', NULL, 'nuno', 'santos', 'Praceta S.Lazaro Nº10 R\\C Direito', NULL, '2005', 'santarem', NULL, '171', '0');
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 ('31', '27', '', NULL, 'pedro', 'luis', 'Rua miguel russel nº15 r/c frente', NULL, '2855-120', 'corroios', NULL, '171', '0');
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 ('32', '28', '', NULL, 'Hugo', 'Gonzalez', 'Rua Sol Nascente nº7 - Costa de Lavos', NULL, '3090-458 L', 'Fig Foz', NULL, '171', '0');
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 ('33', '29', '', NULL, 'jose', 'dorey', 'marina de albufeira lote 2A 1A', NULL, '8200', 'Albufeira', NULL, '171', '0');
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 ('34', '30', '', NULL, 'Sergio', 'Silva', 'Praceta 1º maio, nº 14, 5º esq', NULL, '2745-000', 'monte abraao - queluz', NULL, '171', '0');
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 ('35', '31', '', NULL, 'Joao', 'Rita', 'Rua da Nordela N 9', NULL, '9500-674', 'Ponta Delgada', NULL, '171', '0');
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 ('36', '32', '', NULL, 'Benur', 'Saraiva', 'horacio sousa rocha 35', NULL, '7080-025', 'Vendas Novas', NULL, '171', '0');
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 ('37', '33', '', NULL, 'Alexandre', 'Vieira', 'Rua Bartolomeu Dias, 8B', NULL, '8800-608', 'Tavira', NULL, '171', '0');
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 ('38', '34', '', NULL, 'silvia yuka', 'takahashi', 'rua itua 1932', NULL, '21940-180', 'rio de janeiro', NULL, '30', '0');
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 ('39', '34', '', NULL, 'silvia yuka', 'takahashi', 'rua itua 1932 , ilha do governador', NULL, '21940-180', 'rio de janeiro', NULL, '30', '0');
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 ('40', '35', '', NULL, 'Miguel', 'Martins', 'Tapada da torre Lote 32', NULL, '2230-161 S', 'Sardoal', NULL, '171', '0');
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 ('41', '36', '', NULL, 'Bruno', 'Arede', 'Praceta do tojal nº5 3º dt', NULL, '2735', 'agulava', NULL, '171', '0');
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 ('42', '37', '', NULL, 'vitor hugo', 'freitas', 'rua das flores', NULL, '9970-323', 'santa cruz das flores', NULL, '171', '0');
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 ('43', '38', '', NULL, 'Ricardo', 'Ramos', 'R. Fernando Magalhaes, Zona 9, Lote4, 5ºesq', NULL, '22675', 'Odivelas', NULL, '171', '0');
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 ('44', '39', '', NULL, 'luis', 'barbosa', 'R António F F Gomes Nº 158 7º Esq', NULL, '4700-105', 'braga', NULL, '171', '0');
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 ('45', '40', '', NULL, 'Joaquim', 'Ramalho', 'Estrada dos Remédios nº107', NULL, '2520-223', 'Peniche', NULL, '171', '0');
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 ('46', '41', '', NULL, 'hugo', 'marreiros', 'rua candido azevedo de melo n 2', NULL, '2520-385', 'peniche', NULL, '171', '0');
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 ('47', '42', '', NULL, 'L.', 'Fernandes', 'rua senhora da boa viagem nº54 Apúlia', NULL, '4740', 'braga', NULL, '171', '0');
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 ,
  address_summary varchar(48) not null ,
  PRIMARY KEY (address_format_id)
);

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');
insert into address_format (address_format_id, address_format, address_summary) values ('2', '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('3', '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('4', '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
insert into address_format (address_format_id, address_format, address_summary) values ('5', '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');
drop table if exists banners;
create table banners (
  banners_id int(11) not null auto_increment,
  banners_title varchar(64) not null ,
  banners_url varchar(255) not null ,
  banners_image varchar(64) not null ,
  banners_group varchar(10) not null ,
  banners_html_text text ,
  expires_impressions int(7) default '0' ,
  expires_date datetime ,
  date_scheduled datetime ,
  date_added datetime default '0000-00-00 00:00:00' not null ,
  date_status_change datetime ,
  status int(1) default '1' not null ,
  PRIMARY KEY (banners_id)
);

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 ('1', 'Infoelec Growshop', 'www.growshop.infoelec.net', 'banners/button_banner.gif', '468x50', '', '0', NULL, NULL, '2006-11-09 02:08:06', NULL, '1');
drop table if exists banners_history;
create table banners_history (
  banners_history_id int(11) not null auto_increment,
  banners_id int(11) default '0' not null ,
  banners_shown int(5) default '0' not null ,
  banners_clicked int(5) default '0' not null ,
  banners_history_date datetime default '0000-00-00 00:00:00' not null ,
  PRIMARY KEY (banners_history_id)
);

insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('1', '1', '75', '1', '2006-11-09 02:08:14');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('2', '1', '425', '1', '2006-11-10 00:04:09');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('3', '1', '83', '0', '2006-11-11 09:25:24');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('4', '1', '126', '1', '2006-11-12 00:13:15');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('5', '1', '136', '0', '2006-11-13 00:00:07');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('6', '1', '316', '0', '2006-11-14 00:04:27');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('7', '1', '197', '0', '2006-11-15 02:25:18');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('8', '1', '103', '0', '2006-11-16 00:06:46');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('9', '1', '57', '0', '2006-11-17 09:12:10');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('10', '1', '136', '0', '2006-11-18 00:24:59');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('11', '1', '116', '1', '2006-11-19 00:16:11');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('12', '1', '52', '0', '2006-11-20 00:09:59');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('13', '1', '35', '0', '2006-11-21 10:37:06');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('14', '1', '126', '0', '2006-11-22 01:36:11');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('15', '1', '119', '0', '2006-11-23 00:09:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('16', '1', '58', '0', '2006-11-24 06:21:25');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('17', '1', '48', '0', '2006-11-25 02:54:44');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('18', '1', '57', '0', '2006-11-26 00:27:13');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('19', '1', '74', '1', '2006-11-27 03:15:24');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('20', '1', '25', '0', '2006-11-28 02:19:59');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('21', '1', '5', '0', '2006-11-29 11:57:09');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('22', '1', '12', '0', '2006-11-30 10:25:47');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('23', '1', '7', '0', '2006-12-01 21:56:04');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('24', '1', '7', '0', '2006-12-01 21:56:04');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('25', '1', '4', '0', '2006-12-02 02:21:24');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('26', '1', '87', '0', '2006-12-03 03:29:47');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('27', '1', '131', '0', '2006-12-04 00:40:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('28', '1', '15', '0', '2006-12-05 11:53:18');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('29', '1', '59', '0', '2006-12-06 04:45:29');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('30', '1', '103', '0', '2006-12-07 01:23:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('31', '1', '8', '0', '2006-12-08 12:34:06');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('32', '1', '34', '0', '2006-12-09 10:53:31');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('33', '1', '5', '0', '2006-12-10 23:39:03');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('34', '1', '59', '0', '2006-12-11 00:02:51');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('35', '1', '16', '0', '2006-12-12 00:10:33');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('36', '1', '52', '0', '2006-12-13 01:08:18');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('37', '1', '7', '0', '2006-12-14 22:11:11');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('38', '1', '1', '0', '2006-12-15 14:56:06');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('39', '1', '50', '0', '2006-12-16 11:27:35');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('40', '1', '7', '0', '2006-12-17 16:39:52');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('41', '1', '8', '0', '2006-12-18 22:53:41');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('42', '1', '49', '0', '2006-12-19 15:03:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('43', '1', '141', '0', '2006-12-20 00:04:54');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('44', '1', '94', '0', '2006-12-21 01:57:29');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('45', '1', '27', '0', '2006-12-22 00:22:37');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('46', '1', '25', '0', '2006-12-23 00:08:32');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('47', '1', '39', '0', '2006-12-24 00:48:29');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('48', '1', '60', '0', '2006-12-25 18:00:27');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('49', '1', '93', '0', '2006-12-26 00:10:56');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('50', '1', '178', '0', '2006-12-27 02:04:19');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('51', '1', '45', '0', '2006-12-28 19:35:20');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('52', '1', '21', '0', '2006-12-29 12:50:01');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('53', '1', '21', '0', '2006-12-29 12:50:01');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('54', '1', '2', '0', '2006-12-30 20:44:22');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('55', '1', '3', '0', '2006-12-31 00:33:01');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('56', '1', '12', '0', '2007-01-01 21:44:37');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('57', '1', '87', '0', '2007-01-02 08:38:51');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('58', '1', '89', '0', '2007-01-03 00:22:06');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('59', '1', '45', '0', '2007-01-04 02:54:44');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('60', '1', '89', '0', '2007-01-05 06:44:17');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('61', '1', '30', '0', '2007-01-06 22:00:09');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('62', '1', '45', '0', '2007-01-07 14:30:26');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('63', '1', '36', '0', '2007-01-08 12:15:55');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('64', '1', '121', '0', '2007-01-09 00:21:57');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('65', '1', '91', '0', '2007-01-10 00:09:19');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('66', '1', '93', '0', '2007-01-11 01:22:38');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('67', '1', '67', '0', '2007-01-12 00:59:16');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('68', '1', '55', '0', '2007-01-13 00:51:50');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('69', '1', '26', '0', '2007-01-14 16:42:31');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('70', '1', '60', '0', '2007-01-15 01:22:16');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('71', '1', '59', '0', '2007-01-16 01:21:41');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('72', '1', '54', '0', '2007-01-17 11:32:50');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('73', '1', '34', '0', '2007-01-18 10:06:45');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('74', '1', '54', '0', '2007-01-19 15:43:17');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('75', '1', '1', '0', '2007-01-20 00:47:13');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('76', '1', '47', '0', '2007-01-21 02:16:52');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('77', '1', '51', '0', '2007-01-22 00:00:08');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('78', '1', '55', '1', '2007-01-23 00:11:53');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('79', '1', '54', '0', '2007-01-24 00:23:42');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('80', '1', '53', '1', '2007-01-25 00:24:31');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('81', '1', '43', '0', '2007-01-26 00:25:37');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('82', '1', '73', '0', '2007-01-27 00:22:50');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('83', '1', '30', '0', '2007-01-28 00:17:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('84', '1', '30', '0', '2007-01-29 01:07:49');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('85', '1', '209', '0', '2007-01-30 00:06:07');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('86', '1', '464', '0', '2007-01-31 00:03:57');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('87', '1', '341', '0', '2007-02-01 00:02:16');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('88', '1', '118', '0', '2007-02-02 00:13:08');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('89', '1', '44', '0', '2007-02-03 01:15:04');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('90', '1', '101', '0', '2007-02-04 00:04:58');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('91', '1', '43', '0', '2007-02-05 00:28:24');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('92', '1', '40', '0', '2007-02-06 00:41:52');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('93', '1', '15', '1', '2007-02-07 00:13:53');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('94', '1', '85', '0', '2007-02-08 00:23:05');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('95', '1', '42', '1', '2007-02-09 01:00:09');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('96', '1', '36', '0', '2007-02-10 00:18:36');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('97', '1', '10', '0', '2007-02-11 02:37:29');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('98', '1', '36', '0', '2007-02-12 00:19:11');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('99', '1', '26', '0', '2007-02-13 05:28:32');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('100', '1', '102', '0', '2007-02-14 00:22:41');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('101', '1', '38', '0', '2007-02-15 00:09:04');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('102', '1', '25', '0', '2007-02-16 07:33:34');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('103', '1', '11', '0', '2007-02-17 00:36:55');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('104', '1', '6', '0', '2007-02-18 07:28:36');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('105', '1', '60', '0', '2007-02-19 00:35:32');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('106', '1', '54', '0', '2007-02-20 03:32:22');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('107', '1', '47', '0', '2007-02-21 00:20:30');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('108', '1', '39', '0', '2007-02-22 06:36:05');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('109', '1', '36', '0', '2007-02-23 01:28:22');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('110', '1', '3', '0', '2007-02-24 17:00:22');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('111', '1', '6', '0', '2007-02-25 06:38:05');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('112', '1', '87', '0', '2007-02-26 00:52:28');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('113', '1', '35', '0', '2007-02-27 09:51:18');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('114', '1', '9', '0', '2007-02-28 07:51:39');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('115', '1', '111', '0', '2007-03-01 00:00:02');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('116', '1', '33', '0', '2007-03-02 01:15:49');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('117', '1', '9', '0', '2007-03-03 00:48:25');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('118', '1', '116', '0', '2007-03-04 00:12:25');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('119', '1', '115', '0', '2007-03-05 11:13:30');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('120', '1', '26', '0', '2007-03-06 07:06:38');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('121', '1', '135', '1', '2007-03-07 03:13:57');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('122', '1', '56', '0', '2007-03-08 00:45:52');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('123', '1', '156', '0', '2007-03-09 00:21:12');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('124', '1', '91', '0', '2007-03-10 00:47:10');
insert into banners_history (banners_history_id, banners_id, banners_shown, banners_clicked, banners_history_date) values ('125', '1', '242', '0', '2007-03-11 00:01:40');
drop table if exists categories;
create table categories (
  categories_id int(11) not null auto_increment,
  categories_image varchar(64) ,
  parent_id int(11) default '0' not null ,
  sort_order int(3) ,
  date_added datetime ,
  last_modified datetime ,
  PRIMARY KEY (categories_id),
  KEY idx_categories_parent_id (parent_id)
);

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('1', 'agrolite.jpg', '0', '1', '2006-11-09 02:08:06', '2007-03-09 00:45:37');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('2', '', '0', '2', '2006-11-09 02:08:06', '2007-03-06 18:44:03');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('41', 'instrumentos.jpg', '0', '7', '2006-12-23 22:17:00', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('4', 'ignitor_hps.jpg', '1', '0', '2006-11-09 02:08:06', '2006-11-10 19:36:43');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('5', '2x36w.JPG', '1', '0', '2006-11-09 02:08:06', '2006-11-10 19:34:06');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('6', 'cooltube.jpg', '1', '0', '2006-11-09 02:08:06', '2006-11-10 19:36:25');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('7', 'temporizador_ana.JPG', '1', '0', '2006-11-09 02:08:06', '2006-12-23 23:43:07');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('8', 'Balastro.jpg', '1', '0', '2006-11-09 02:08:06', '2006-11-10 19:37:42');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('9', 'reflector.jpg', '1', '0', '2006-11-09 02:08:06', '2006-11-10 19:39:47');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('26', 'hesi.jpg', '25', '0', '2006-12-22 02:07:47', '2007-03-10 21:47:42');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('24', 'vaso_11x11x12.jpg', '29', '0', '2006-12-21 02:12:35', '2006-12-23 02:53:28');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('25', '', '0', '5', '2006-12-22 00:03:47', '2006-12-23 22:19:45');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('22', '', '0', '1', '2006-11-09 03:50:48', '2006-11-09 23:27:12');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('23', 'kit_hps.jpg', '1', '0', '2006-11-09 22:03:23', '2006-11-10 19:37:11');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('16', 'mat_electrico.JPG', '1', '0', '2006-11-09 02:08:06', '2006-12-23 23:50:38');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('17', 'lamp_flur.jpg', '1', '0', '2006-11-09 02:08:06', '2006-11-09 02:25:53');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('29', '', '0', '5', '2006-12-23 02:52:21', '2007-11-19 14:00:29');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('30', 'bio-bizz-allmix.jpg', '29', '0', '2006-12-23 03:01:16', '2007-03-10 20:55:56');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('27', 'bio-bizz.jpg', '25', '0', '2006-12-22 02:22:03', '2007-03-10 21:47:18');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('28', 'canna.gif', '25', '0', '2006-12-22 03:04:14', '2007-03-10 21:47:06');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('21', '', '0', '6', '2006-11-09 02:32:40', '2006-12-23 22:18:52');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('67', 'nultriculture.jpg', '45', '0', '2007-11-09 14:14:25', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('32', 'rvk.jpg', '2', '0', '2006-12-23 03:22:51', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('33', 'tubo_alum.bmp', '2', '0', '2006-12-23 03:26:34', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('34', 'filtros_carbono.jpg', '2', '0', '2006-12-23 03:27:50', '2007-03-09 01:24:30');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('35', 'ventilador.gif', '2', '0', '2006-12-23 03:28:49', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('36', 'temostato.bmp', '2', '0', '2006-12-23 19:06:46', '2007-03-09 01:25:29');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('37', 'atman2.jpg', '21', '0', '2006-12-23 20:01:03', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('38', 'atman_air.jpg', '21', '0', '2006-12-23 20:09:38', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('39', 'mangueira.jpg', '21', '0', '2006-12-23 20:20:46', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('40', '', '22', '0', '2006-12-23 21:58:03', '2007-12-03 17:11:09');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('42', '', '0', '0', '2006-12-24 00:00:02', '2006-12-24 01:53:36');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('43', 'moinhos.jpg', '42', '0', '2006-12-24 00:40:06', '2006-12-24 00:42:18');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('44', 'mortalhas_smoking.jpg', '42', '0', '2006-12-24 00:48:18', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('45', '', '0', '9', '2006-12-24 03:13:12', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('46', 'ice-lator.jpg', '42', '0', '2007-03-09 00:49:29', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('47', 'disco_vaportec.jpg', '2', '0', '2007-03-09 01:22:02', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('48', 'grorox.jpg', '29', '0', '2007-03-10 20:57:22', '2007-03-10 21:29:37');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('49', 'biobizz_cocomix_50l.jpg', '29', '0', '2007-03-10 21:35:31', '2007-03-10 21:36:01');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('50', 'Biobizz_premix_5l.jpg', '25', '0', '2007-03-10 21:44:15', '2007-03-10 21:46:10');
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('52', 'ghe_logo.jpg', '25', '0', '2007-03-11 00:35:39', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('53', 'philips.jpg', '23', '0', '2007-03-11 21:35:42', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('54', 'sylvania.jpg', '23', '0', '2007-03-11 21:43:06', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('55', 'agrolite2.gif', '23', '0', '2007-03-11 21:43:48', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('56', 'osram.jpg', '23', '0', '2007-03-11 22:49:57', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('57', 'philips.jpg', '17', '0', '2007-03-11 23:23:30', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('58', 'sylvania.jpg', '17', '0', '2007-03-11 23:25:32', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('59', 'osram.jpg', '17', '0', '2007-03-11 23:25:51', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('60', 'agrolite2.gif', '17', '0', '2007-03-11 23:28:01', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('61', 'lorefar.jpg', '17', '0', '2007-03-11 23:58:25', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('62', '', '0', '10', '2007-06-21 01:50:12', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('63', '', '0', '11', '2007-06-21 01:50:47', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('64', '', '0', '12', '2007-06-21 01:51:21', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('65', 'ghe_logo.jpg', '45', '0', '2007-06-21 01:54:55', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('66', 'roots_closeup.jpg', '63', '0', '2007-07-10 18:09:53', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('68', 'carbonactive.jpg', '34', '0', '2007-12-08 09:24:56', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('69', 'filtros_carbono_450m3.jpg', '34', '0', '2007-12-08 09:38:35', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('70', 'MiniVacAll.jpg', '42', '0', '2007-12-12 16:38:43', NULL);
insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('71', '', '25', '0', '2007-12-12 17:00:04', NULL);
drop table if exists categories_description;
create table categories_description (
  categories_id int(11) default '0' not null ,
  language_id int(11) default '1' not null ,
  categories_name varchar(32) not null ,
  PRIMARY KEY (categories_id, language_id),
  KEY idx_categories_name (categories_name)
);

insert into categories_description (categories_id, language_id, categories_name) values ('1', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('2', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('42', '4', 'HeadShop');
insert into categories_description (categories_id, language_id, categories_name) values ('4', '1', 'Arrancadores');
insert into categories_description (categories_id, language_id, categories_name) values ('5', '1', 'Armaduras');
insert into categories_description (categories_id, language_id, categories_name) values ('6', '1', 'Cooltube');
insert into categories_description (categories_id, language_id, categories_name) values ('7', '1', 'Temporizadores');
insert into categories_description (categories_id, language_id, categories_name) values ('8', '1', 'Balastros');
insert into categories_description (categories_id, language_id, categories_name) values ('9', '1', 'Reflectores');
insert into categories_description (categories_id, language_id, categories_name) values ('41', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('2', '4', 'Controlo de Clima');
insert into categories_description (categories_id, language_id, categories_name) values ('41', '4', 'Instrumentos de Medida');
insert into categories_description (categories_id, language_id, categories_name) values ('1', '4', 'Iluminação');
insert into categories_description (categories_id, language_id, categories_name) values ('16', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('17', '1', 'Lâmpadas');
insert into categories_description (categories_id, language_id, categories_name) values ('5', '4', 'Armaduras');
insert into categories_description (categories_id, language_id, categories_name) values ('4', '4', 'Ignitores e Arrancadores');
insert into categories_description (categories_id, language_id, categories_name) values ('33', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('32', '4', 'Extractores');
insert into categories_description (categories_id, language_id, categories_name) values ('32', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('67', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('48', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('30', '4', 'Terra');
insert into categories_description (categories_id, language_id, categories_name) values ('29', '4', 'Substratos e Vasos');
insert into categories_description (categories_id, language_id, categories_name) values ('29', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('30', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('28', '4', 'Canna');
insert into categories_description (categories_id, language_id, categories_name) values ('28', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('27', '4', 'Bio-Bizz');
insert into categories_description (categories_id, language_id, categories_name) values ('27', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('26', '4', 'Hesi');
insert into categories_description (categories_id, language_id, categories_name) values ('26', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('25', '4', 'Fertilizantes');
insert into categories_description (categories_id, language_id, categories_name) values ('25', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('23', '4', 'Kit\'s de Iluminação');
insert into categories_description (categories_id, language_id, categories_name) values ('23', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('22', '4', 'Armarios');
insert into categories_description (categories_id, language_id, categories_name) values ('24', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('22', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('21', '4', 'Rega');
insert into categories_description (categories_id, language_id, categories_name) values ('17', '4', 'Lâmpadas');
insert into categories_description (categories_id, language_id, categories_name) values ('16', '4', 'Material Electrico');
insert into categories_description (categories_id, language_id, categories_name) values ('9', '4', 'Reflectores');
insert into categories_description (categories_id, language_id, categories_name) values ('8', '4', 'Reactancias e Balastros');
insert into categories_description (categories_id, language_id, categories_name) values ('7', '4', 'Temporizadores');
insert into categories_description (categories_id, language_id, categories_name) values ('42', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('24', '4', 'Vasos');
insert into categories_description (categories_id, language_id, categories_name) values ('21', '1', 'Rega');
insert into categories_description (categories_id, language_id, categories_name) values ('6', '4', 'Cooltube');
insert into categories_description (categories_id, language_id, categories_name) values ('33', '4', 'Tubos');
insert into categories_description (categories_id, language_id, categories_name) values ('34', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('34', '4', 'Filtros Carbono');
insert into categories_description (categories_id, language_id, categories_name) values ('35', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('35', '4', 'Ventilação');
insert into categories_description (categories_id, language_id, categories_name) values ('36', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('36', '4', 'Temperatura e Humidade');
insert into categories_description (categories_id, language_id, categories_name) values ('37', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('37', '4', 'Bombas de Água');
insert into categories_description (categories_id, language_id, categories_name) values ('38', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('38', '4', 'Bombas de Ar');
insert into categories_description (categories_id, language_id, categories_name) values ('39', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('39', '4', 'Mangueiras e Acessorios');
insert into categories_description (categories_id, language_id, categories_name) values ('40', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('40', '4', 'Homebox');
insert into categories_description (categories_id, language_id, categories_name) values ('45', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('43', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('43', '4', 'Moinhos');
insert into categories_description (categories_id, language_id, categories_name) values ('44', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('44', '4', 'Mortalhas e Filtros');
insert into categories_description (categories_id, language_id, categories_name) values ('45', '4', 'Sistemas de Cultivo');
insert into categories_description (categories_id, language_id, categories_name) values ('46', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('46', '4', 'Ice-o-Later');
insert into categories_description (categories_id, language_id, categories_name) values ('47', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('47', '4', 'Acessorios');
insert into categories_description (categories_id, language_id, categories_name) values ('48', '4', 'Argila - Perlite - Vermiculite');
insert into categories_description (categories_id, language_id, categories_name) values ('49', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('49', '4', 'Côco');
insert into categories_description (categories_id, language_id, categories_name) values ('50', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('50', '4', 'Fertilizantes Sólidos');
insert into categories_description (categories_id, language_id, categories_name) values ('52', '4', 'GHE');
insert into categories_description (categories_id, language_id, categories_name) values ('52', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('53', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('53', '4', 'Philips');
insert into categories_description (categories_id, language_id, categories_name) values ('54', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('54', '4', 'Sylvania');
insert into categories_description (categories_id, language_id, categories_name) values ('55', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('55', '4', 'Agrolite');
insert into categories_description (categories_id, language_id, categories_name) values ('56', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('56', '4', 'Osram');
insert into categories_description (categories_id, language_id, categories_name) values ('57', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('57', '4', 'Philips');
insert into categories_description (categories_id, language_id, categories_name) values ('58', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('58', '4', 'Sylvania');
insert into categories_description (categories_id, language_id, categories_name) values ('59', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('59', '4', 'Osram');
insert into categories_description (categories_id, language_id, categories_name) values ('60', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('60', '4', 'Agrolite');
insert into categories_description (categories_id, language_id, categories_name) values ('61', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('61', '4', 'Faro');
insert into categories_description (categories_id, language_id, categories_name) values ('62', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('62', '4', 'Controlo de Pragas');
insert into categories_description (categories_id, language_id, categories_name) values ('63', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('63', '4', 'Germinação e Clonagem');
insert into categories_description (categories_id, language_id, categories_name) values ('64', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('64', '4', 'Acessorios');
insert into categories_description (categories_id, language_id, categories_name) values ('65', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('65', '4', 'GHE');
insert into categories_description (categories_id, language_id, categories_name) values ('66', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('66', '4', 'Enraizamento');
insert into categories_description (categories_id, language_id, categories_name) values ('67', '4', 'Nultriculture');
insert into categories_description (categories_id, language_id, categories_name) values ('68', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('68', '4', 'CarbonActive');
insert into categories_description (categories_id, language_id, categories_name) values ('69', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('69', '4', 'Econofilters');
insert into categories_description (categories_id, language_id, categories_name) values ('70', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('70', '4', 'Armazenamento');
insert into categories_description (categories_id, language_id, categories_name) values ('71', '1', '');
insert into categories_description (categories_id, language_id, categories_name) values ('71', '4', 'Hy-Pro');
drop table if exists configuration;
create table configuration (
  configuration_id int(11) not null auto_increment,
  configuration_title varchar(64) not null ,
  configuration_key varchar(64) not null ,
  configuration_value varchar(255) not null ,
  configuration_description varchar(255) not null ,
  configuration_group_id int(11) default '0' not null ,
  sort_order int(5) ,
  last_modified datetime ,
  date_added datetime default '0000-00-00 00:00:00' not null ,
  use_function varchar(255) ,
  set_function varchar(255) ,
  PRIMARY KEY (configuration_id)
);

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', 'Store Name', 'STORE_NAME', 'Infoelec Growshop', 'The name of my store', '1', '1', '2006-11-09 02:09:45', '2006-11-09 02:08:06', NULL, NULL);
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 ('2', 'Store Owner', 'STORE_OWNER', 'Infoelec Growshop', 'The name of my store owner', '1', '2', '2006-11-09 04:09:05', '2006-11-09 02:08:06', NULL, NULL);
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 ('3', 'E-Mail Address', 'STORE_OWNER_EMAIL_ADDRESS', 'growshop@infoelec.net', 'The e-mail address of my store owner', '1', '3', '2006-11-09 02:11:42', '2006-11-09 02:08:06', NULL, NULL);
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 ('4', 'E-Mail From', 'EMAIL_FROM', 'Infoelec Growshop <growshop@infoelec.net>', 'The e-mail address used in (sent) e-mails', '1', '4', '2006-11-16 20:13:53', '2006-11-09 02:08:06', NULL, NULL);
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 ('5', 'Country', 'STORE_COUNTRY', '171', 'The country my store is located in <br><br><b>Note: Please remember to update the store zone.</b>', '1', '6', '2006-11-09 02:12:50', '2006-11-09 02:08:06', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
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 ('6', 'Zone', 'STORE_ZONE', '', 'The zone my store is located in', '1', '7', '2006-11-16 20:14:17', '2006-11-09 02:08:06', 'tep_cfg_get_zone_name', 'tep_cfg_pull_down_zone_list(');
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 ('7', 'Expected Sort Order', 'EXPECTED_PRODUCTS_SORT', 'desc', 'This is the sort order used in the expected products box.', '1', '8', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'asc\', \'desc\'),');
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 ('8', 'Expected Sort Field', 'EXPECTED_PRODUCTS_FIELD', 'date_expected', 'The column to sort by in the expected products box.', '1', '9', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'products_name\', \'date_expected\'),');
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 ('9', 'Switch To Default Language Currency', 'USE_DEFAULT_LANGUAGE_CURRENCY', 'true', 'Automatically switch to the language\'s currency when it is changed', '1', '10', '2006-11-09 02:13:26', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('10', 'Send Extra Order Emails To', 'SEND_EXTRA_ORDER_EMAILS_TO', 'growshop@infoelec.net, balcao@infoelec.net', 'Send extra order emails to the following email addresses, in this format: Name 1 &lt;email@address1&gt;, Name 2 &lt;email@address2&gt;', '1', '11', '2007-10-01 22:36:49', '2006-11-09 02:08:06', NULL, NULL);
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 ('11', 'Use Search-Engine Safe URLs (still in development)', 'SEARCH_ENGINE_FRIENDLY_URLS', 'false', 'Use search-engine safe urls for all site links', '1', '12', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('12', 'Display Cart After Adding Product', 'DISPLAY_CART', 'true', 'Display the shopping cart after adding a product (or return back to their origin)', '1', '14', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('13', 'Allow Guest To Tell A Friend', 'ALLOW_GUEST_TO_TELL_A_FRIEND', 'true', 'Allow guests to tell a friend about a product', '1', '15', '2006-11-09 02:13:46', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('14', 'Default Search Operator', 'ADVANCED_SEARCH_DEFAULT_OPERATOR', 'and', 'Default search operators', '1', '17', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'and\', \'or\'),');
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 ('15', 'Store Address and Phone', 'STORE_NAME_ADDRESS', 'Infoelec Growshop
R. Dr. Manuel de Arriaga, Nº 17
2745-153 Queluz
965714623
969890517', 'This is the Store Name, Address and Phone used on printable documents and displayed online', '1', '18', '2007-10-01 22:40:20', '2006-11-09 02:08:06', NULL, 'tep_cfg_textarea(');
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 ('16', 'Show Category Counts', 'SHOW_COUNTS', 'true', 'Count recursively how many products are in each category', '1', '19', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('17', 'Tax Decimal Places', 'TAX_DECIMAL_PLACES', '0', 'Pad the tax value this amount of decimal places', '1', '20', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('18', 'Display Prices with Tax', 'DISPLAY_PRICE_WITH_TAX', 'true', 'Display prices with tax included (true) or add the tax at the end (false)', '1', '21', '2007-03-10 20:54:21', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('19', 'First Name', 'ENTRY_FIRST_NAME_MIN_LENGTH', '2', 'Minimum length of first name', '2', '1', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('20', 'Last Name', 'ENTRY_LAST_NAME_MIN_LENGTH', '2', 'Minimum length of last name', '2', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('21', 'Date of Birth', 'ENTRY_DOB_MIN_LENGTH', '10', 'Minimum length of date of birth', '2', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('22', 'E-Mail Address', 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH', '6', 'Minimum length of e-mail address', '2', '4', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('23', 'Street Address', 'ENTRY_STREET_ADDRESS_MIN_LENGTH', '5', 'Minimum length of street address', '2', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('24', 'Company', 'ENTRY_COMPANY_MIN_LENGTH', '2', 'Minimum length of company name', '2', '6', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('25', 'Post Code', 'ENTRY_POSTCODE_MIN_LENGTH', '4', 'Minimum length of post code', '2', '7', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('26', 'City', 'ENTRY_CITY_MIN_LENGTH', '3', 'Minimum length of city', '2', '8', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('27', 'State', 'ENTRY_STATE_MIN_LENGTH', '2', 'Minimum length of state', '2', '9', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('28', 'Telephone Number', 'ENTRY_TELEPHONE_MIN_LENGTH', '3', 'Minimum length of telephone number', '2', '10', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('29', 'Password', 'ENTRY_PASSWORD_MIN_LENGTH', '5', 'Minimum length of password', '2', '11', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('30', 'Credit Card Owner Name', 'CC_OWNER_MIN_LENGTH', '3', 'Minimum length of credit card owner name', '2', '12', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('31', 'Credit Card Number', 'CC_NUMBER_MIN_LENGTH', '10', 'Minimum length of credit card number', '2', '13', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('32', 'Review Text', 'REVIEW_TEXT_MIN_LENGTH', '50', 'Minimum length of review text', '2', '14', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('33', 'Best Sellers', 'MIN_DISPLAY_BESTSELLERS', '1', 'Minimum number of best sellers to display', '2', '15', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('34', 'Also Purchased', 'MIN_DISPLAY_ALSO_PURCHASED', '1', 'Minimum number of products to display in the \'This Customer Also Purchased\' box', '2', '16', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('35', 'Address Book Entries', 'MAX_ADDRESS_BOOK_ENTRIES', '5', 'Maximum address book entries a customer is allowed to have', '3', '1', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('36', 'Search Results', 'MAX_DISPLAY_SEARCH_RESULTS', '20', 'Amount of products to list', '3', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('37', 'Page Links', 'MAX_DISPLAY_PAGE_LINKS', '5', 'Number of \'number\' links use for page-sets', '3', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('38', 'Special Products', 'MAX_DISPLAY_SPECIAL_PRODUCTS', '9', 'Maximum number of products on special to display', '3', '4', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('39', 'New Products Module', 'MAX_DISPLAY_NEW_PRODUCTS', '9', 'Maximum number of new products to display in a category', '3', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('40', 'Products Expected', 'MAX_DISPLAY_UPCOMING_PRODUCTS', '10', 'Maximum number of products expected to display', '3', '6', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('41', 'Manufacturers List', 'MAX_DISPLAY_MANUFACTURERS_IN_A_LIST', '0', 'Used in manufacturers box; when the number of manufacturers exceeds this number, a drop-down list will be displayed instead of the default list', '3', '7', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('42', 'Manufacturers Select Size', 'MAX_MANUFACTURERS_LIST', '1', 'Used in manufacturers box; when this value is \'1\' the classic drop-down list will be used for the manufacturers box. Otherwise, a list-box with the specified number of rows will be displayed.', '3', '7', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('43', 'Length of Manufacturers Name', 'MAX_DISPLAY_MANUFACTURER_NAME_LEN', '15', 'Used in manufacturers box; maximum length of manufacturers name to display', '3', '8', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('44', 'New Reviews', 'MAX_DISPLAY_NEW_REVIEWS', '6', 'Maximum number of new reviews to display', '3', '9', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('45', 'Selection of Random Reviews', 'MAX_RANDOM_SELECT_REVIEWS', '10', 'How many records to select from to choose one random product review', '3', '10', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('46', 'Selection of Random New Products', 'MAX_RANDOM_SELECT_NEW', '10', 'How many records to select from to choose one random new product to display', '3', '11', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('47', 'Selection of Products on Special', 'MAX_RANDOM_SELECT_SPECIALS', '10', 'How many records to select from to choose one random product special to display', '3', '12', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('48', 'Categories To List Per Row', 'MAX_DISPLAY_CATEGORIES_PER_ROW', '3', 'How many categories to list per row', '3', '13', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('49', 'New Products Listing', 'MAX_DISPLAY_PRODUCTS_NEW', '10', 'Maximum number of new products to display in new products page', '3', '14', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('50', 'Best Sellers', 'MAX_DISPLAY_BESTSELLERS', '10', 'Maximum number of best sellers to display', '3', '15', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('51', 'Also Purchased', 'MAX_DISPLAY_ALSO_PURCHASED', '6', 'Maximum number of products to display in the \'This Customer Also Purchased\' box', '3', '16', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('52', 'Customer Order History Box', 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX', '6', 'Maximum number of products to display in the customer order history box', '3', '17', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('53', 'Order History', 'MAX_DISPLAY_ORDER_HISTORY', '10', 'Maximum number of orders to display in the order history page', '3', '18', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('54', 'Small Image Width', 'SMALL_IMAGE_WIDTH', '100', 'The pixel width of small images', '4', '1', '2006-12-22 00:25:58', '2006-11-09 02:08:06', NULL, NULL);
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 ('55', 'Small Image Height', 'SMALL_IMAGE_HEIGHT', '100', 'The pixel height of small images', '4', '2', '2006-12-22 00:26:07', '2006-11-09 02:08:06', NULL, NULL);
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 ('56', 'Heading Image Width', 'HEADING_IMAGE_WIDTH', '57', 'The pixel width of heading images', '4', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('57', 'Heading Image Height', 'HEADING_IMAGE_HEIGHT', '40', 'The pixel height of heading images', '4', '4', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('58', 'Subcategory Image Width', 'SUBCATEGORY_IMAGE_WIDTH', '100', 'The pixel width of subcategory images', '4', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('59', 'Subcategory Image Height', 'SUBCATEGORY_IMAGE_HEIGHT', '100', 'The pixel height of subcategory images', '4', '6', '2007-03-11 21:44:52', '2006-11-09 02:08:06', NULL, NULL);
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 ('60', 'Calculate Image Size', 'CONFIG_CALCULATE_IMAGE_SIZE', 'true', 'Calculate the size of images?', '4', '7', '2006-12-22 00:26:17', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('61', 'Image Required', 'IMAGE_REQUIRED', 'true', 'Enable to display broken images. Good for development.', '4', '8', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('62', 'Gender', 'ACCOUNT_GENDER', 'false', 'Display gender in the customers account', '5', '1', '2006-11-09 02:16:56', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('63', 'Date of Birth', 'ACCOUNT_DOB', 'false', 'Display date of birth in the customers account', '5', '2', '2006-11-09 02:16:50', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('64', 'Company', 'ACCOUNT_COMPANY', 'false', 'Display company in the customers account', '5', '3', '2006-11-09 02:16:44', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('65', 'Suburb', 'ACCOUNT_SUBURB', 'false', 'Display suburb in the customers account', '5', '4', '2006-11-09 02:16:35', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('66', 'State', 'ACCOUNT_STATE', 'false', 'Display state in the customers account', '5', '5', '2006-11-09 02:16:29', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('67', 'Installed Modules', 'MODULE_PAYMENT_INSTALLED', 'cc.php;cod.php;cop.php;moneyorder.php;paypal.php;ptebanktransfer.php', 'List of payment module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: cc.php;cod.php;paypal.php)', '6', '0', '2007-10-02 22:54:22', '2006-11-09 02:08:06', NULL, NULL);
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 ('68', 'Installed Modules', 'MODULE_ORDER_TOTAL_INSTALLED', 'ot_subtotal.php;ot_zones.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', '2007-03-13 00:15:21', '2006-11-09 02:08:06', NULL, NULL);
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 ('69', 'Installed Modules', 'MODULE_SHIPPING_INSTALLED', 'flat.php;spu.php;table.php;zones.php', 'List of shipping module filenames separated by a semi-colon. This is automatically updated. No need to edit. (Example: ups.php;flat.php;item.php)', '6', '0', '2007-10-02 23:37:38', '2006-11-09 02:08:06', NULL, NULL);
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 ('186', 'Set Order Status', 'MODULE_PAYMENT_COD_ORDER_STATUS_ID', '2', 'Set the status of orders made with this payment module to this value', '6', '0', NULL, '2007-03-14 14:13:04', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');
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 ('185', 'Sort order of display.', 'MODULE_PAYMENT_COD_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', NULL, '2007-03-14 14:13:04', NULL, NULL);
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 ('184', 'Payment Zone', 'MODULE_PAYMENT_COD_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', NULL, '2007-03-14 14:13:04', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
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 ('74', 'Enable Credit Card Module', 'MODULE_PAYMENT_CC_STATUS', 'False', 'Do you want to accept credit card payments?', '6', '0', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('75', 'Split Credit Card E-Mail Address', 'MODULE_PAYMENT_CC_EMAIL', '', 'If an e-mail address is entered, the middle digits of the credit card number will be sent to the e-mail address (the outside digits are stored in the database with the middle digits censored)', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('76', 'Sort order of display.', 'MODULE_PAYMENT_CC_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('77', 'Payment Zone', 'MODULE_PAYMENT_CC_ZONE', '2', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', NULL, '2006-11-09 02:08:06', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
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 ('78', 'Set Order Status', 'MODULE_PAYMENT_CC_ORDER_STATUS_ID', '0', 'Set the status of orders made with this payment module to this value', '6', '0', NULL, '2006-11-09 02:08:06', 'tep_get_order_status_name', 'tep_cfg_pull_down_order_statuses(');
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 ('79', 'Enable Flat Shipping', 'MODULE_SHIPPING_FLAT_STATUS', 'False', 'Do you want to offer flat rate shipping?', '6', '0', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('80', 'Shipping Cost', 'MODULE_SHIPPING_FLAT_COST', '13.50', 'The shipping cost for all orders using this shipping method.', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('81', 'Tax Class', 'MODULE_SHIPPING_FLAT_TAX_CLASS', '0', 'Use the following tax class on the shipping fee.', '6', '0', NULL, '2006-11-09 02:08:06', 'tep_get_tax_class_title', 'tep_cfg_pull_down_tax_classes(');
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 ('82', 'Shipping Zone', 'MODULE_SHIPPING_FLAT_ZONE', '2', 'If a zone is selected, only enable this shipping method for that zone.', '6', '0', NULL, '2006-11-09 02:08:06', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
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 ('83', 'Sort Order', 'MODULE_SHIPPING_FLAT_SORT_ORDER', '0', 'Sort order of display.', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('84', 'Default Currency', 'DEFAULT_CURRENCY', 'EUR', 'Default Currency', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('85', 'Default Language', 'DEFAULT_LANGUAGE', 'pt', 'Default Language', '6', '0', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('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, '2006-11-09 02:08:06', NULL, NULL);
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 ('87', 'Display Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_STATUS', 'true', 'Do you want to display the order shipping cost?', '6', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('88', 'Sort Order', 'MODULE_ORDER_TOTAL_SHIPPING_SORT_ORDER', '2', 'Sort order of display.', '6', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('89', 'Allow Free Shipping', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING', 'false', 'Do you want to allow free shipping?', '6', '3', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('90', 'Free Shipping For Orders Over', 'MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER', '200', 'Provide free shipping for orders over the set amount.', '6', '4', NULL, '2006-11-09 02:08:06', 'currencies->format', NULL);
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 ('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, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'national\', \'international\', \'both\'),');
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 ('92', 'Display Sub-Total', 'MODULE_ORDER_TOTAL_SUBTOTAL_STATUS', 'true', 'Do you want to display the order sub-total cost?', '6', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('93', 'Sort Order', 'MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER', '1', 'Sort order of display.', '6', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('94', 'Display Tax', 'MODULE_ORDER_TOTAL_TAX_STATUS', 'false', 'Do you want to display the order tax value?', '6', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('95', 'Sort Order', 'MODULE_ORDER_TOTAL_TAX_SORT_ORDER', '3', 'Sort order of display.', '6', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('96', 'Display Total', 'MODULE_ORDER_TOTAL_TOTAL_STATUS', 'true', 'Do you want to display the total order value?', '6', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('97', 'Sort Order', 'MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER', '4', 'Sort order of display.', '6', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('98', 'Country of Origin', 'SHIPPING_ORIGIN_COUNTRY', '171', 'Select the country of origin to be used in shipping quotes.', '7', '1', '2006-11-09 02:17:09', '2006-11-09 02:08:06', 'tep_get_country_name', 'tep_cfg_pull_down_country_list(');
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 ('99', 'Postal Code', 'SHIPPING_ORIGIN_ZIP', '2745-153', 'Enter the Postal Code (ZIP) of the Store to be used in shipping quotes.', '7', '2', '2007-10-01 22:45:42', '2006-11-09 02:08:06', NULL, NULL);
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 ('100', 'Enter the Maximum Package Weight you will ship', 'SHIPPING_MAX_WEIGHT', '50', 'Carriers have a max weight limit for a single package. This is a common one for all.', '7', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('101', 'Package Tare weight.', 'SHIPPING_BOX_WEIGHT', '3', 'What is the weight of typical packaging of small to medium packages?', '7', '4', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('102', 'Larger packages - percentage increase.', 'SHIPPING_BOX_PADDING', '10', 'For 10% enter 10', '7', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('103', 'Display Product Image', 'PRODUCT_LIST_IMAGE', '1', 'Do you want to display the Product Image?', '8', '1', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('104', 'Display Product Manufaturer Name', 'PRODUCT_LIST_MANUFACTURER', '0', 'Do you want to display the Product Manufacturer Name?', '8', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('105', 'Display Product Model', 'PRODUCT_LIST_MODEL', '0', 'Do you want to display the Product Model?', '8', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('106', 'Display Product Name', 'PRODUCT_LIST_NAME', '2', 'Do you want to display the Product Name?', '8', '4', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('107', 'Display Product Price', 'PRODUCT_LIST_PRICE', '3', 'Do you want to display the Product Price', '8', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('108', 'Display Product Quantity', 'PRODUCT_LIST_QUANTITY', '0', 'Do you want to display the Product Quantity?', '8', '6', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('109', 'Display Product Weight', 'PRODUCT_LIST_WEIGHT', '0', 'Do you want to display the Product Weight?', '8', '7', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('110', 'Display Buy Now column', 'PRODUCT_LIST_BUY_NOW', '4', 'Do you want to display the Buy Now column?', '8', '8', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('111', 'Display Category/Manufacturer Filter (0=disable; 1=enable)', 'PRODUCT_LIST_FILTER', '1', 'Do you want to display the Category/Manufacturer Filter?', '8', '9', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('112', 'Location of Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', 'PREV_NEXT_BAR_LOCATION', '2', 'Sets the location of the Prev/Next Navigation Bar (1-top, 2-bottom, 3-both)', '8', '10', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('113', 'Check stock level', 'STOCK_CHECK', 'false', 'Check to see if sufficent stock is available', '9', '1', '2007-11-22 14:44:13', '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('114', 'Subtract stock', 'STOCK_LIMITED', 'true', 'Subtract product in stock by product orders', '9', '2', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('115', 'Allow Checkout', 'STOCK_ALLOW_CHECKOUT', 'true', 'Allow customer to checkout even if there is insufficient stock', '9', '3', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('116', 'Mark product out of stock', 'STOCK_MARK_PRODUCT_OUT_OF_STOCK', '***', 'Display something on screen so customer can see which product has insufficient stock', '9', '4', '2006-11-10 14:54:37', '2006-11-09 02:08:06', NULL, NULL);
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 ('117', 'Stock Re-order level', 'STOCK_REORDER_LEVEL', '5', 'Define when stock needs to be re-ordered', '9', '5', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('118', 'Store Page Parse Time', 'STORE_PAGE_PARSE_TIME', 'false', 'Store the time it takes to parse a page', '10', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('119', 'Log Destination', 'STORE_PAGE_PARSE_TIME_LOG', '/var/log/www/tep/page_parse_time.log', 'Directory and filename of the page parse time log', '10', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('120', 'Log Date Format', 'STORE_PARSE_DATE_TIME_FORMAT', '%d/%m/%Y %H:%M:%S', 'The date format', '10', '3', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('121', 'Display The Page Parse Time', 'DISPLAY_PAGE_PARSE_TIME', 'true', 'Display the page parse time (store page parse time must be enabled)', '10', '4', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('122', 'Store Database Queries', 'STORE_DB_TRANSACTIONS', 'false', 'Store the database queries in the page parse time log (PHP4 only)', '10', '5', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('123', 'Use Cache', 'USE_CACHE', 'false', 'Use caching features', '11', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('124', 'Cache Directory', 'DIR_FS_CACHE', '/tmp/', 'The directory where the cached files are saved', '11', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('125', 'E-Mail Transport Method', 'EMAIL_TRANSPORT', 'sendmail', 'Defines if this server uses a local connection to sendmail or uses an SMTP connection via TCP/IP. Servers running on Windows and MacOS should change this setting to SMTP.', '12', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'sendmail\', \'smtp\'),');
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 ('126', 'E-Mail Linefeeds', 'EMAIL_LINEFEED', 'LF', 'Defines the character sequence used to separate mail headers.', '12', '2', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'LF\', \'CRLF\'),');
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 ('127', 'Use MIME HTML When Sending Emails', 'EMAIL_USE_HTML', 'false', 'Send e-mails in HTML format', '12', '3', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('128', 'Verify E-Mail Addresses Through DNS', 'ENTRY_EMAIL_ADDRESS_CHECK', 'false', 'Verify e-mail address through a DNS server', '12', '4', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('129', 'Send E-Mails', 'SEND_EMAILS', 'true', 'Send out e-mails', '12', '5', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('130', 'Enable download', 'DOWNLOAD_ENABLED', 'false', 'Enable the products download functions.', '13', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('131', 'Download by redirect', 'DOWNLOAD_BY_REDIRECT', 'false', 'Use browser redirection for download. Disable on non-Unix systems.', '13', '2', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('132', 'Expiry delay (days)', 'DOWNLOAD_MAX_DAYS', '7', 'Set number of days before the download link expires. 0 means no limit.', '13', '3', NULL, '2006-11-09 02:08:06', NULL, '');
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 ('133', 'Maximum number of downloads', 'DOWNLOAD_MAX_COUNT', '5', 'Set the maximum number of downloads. 0 means no download authorized.', '13', '4', NULL, '2006-11-09 02:08:06', NULL, '');
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 ('134', 'Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', '14', '1', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');
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 ('135', 'Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', '14', '2', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('136', 'Session Directory', 'SESSION_WRITE_DIRECTORY', '/tmp', 'If sessions are file based, store them in this directory.', '15', '1', NULL, '2006-11-09 02:08:06', NULL, NULL);
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 ('137', 'Force Cookie Use', 'SESSION_FORCE_COOKIE_USE', 'False', 'Force the use of sessions when cookies are only enabled.', '15', '2', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('138', 'Check SSL Session ID', 'SESSION_CHECK_SSL_SESSION_ID', 'False', 'Validate the SSL_SESSION_ID on every secure HTTPS page request.', '15', '3', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('139', 'Check User Agent', 'SESSION_CHECK_USER_AGENT', 'False', 'Validate the clients browser user agent on every page request.', '15', '4', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('140', 'Check IP Address', 'SESSION_CHECK_IP_ADDRESS', 'False', 'Validate the clients IP address on every page request.', '15', '5', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('141', 'Prevent Spider Sessions', 'SESSION_BLOCK_SPIDERS', 'False', 'Prevent known spiders from starting a session.', '15', '6', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('142', 'Recreate Session', 'SESSION_RECREATE', 'False', 'Recreate the session to generate a new session ID when the customer logs on or creates an account (PHP >=4.1 needed).', '15', '7', NULL, '2006-11-09 02:08:06', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('159', 'Payment Zone', 'MODULE_PAYMENT_MONEYORDER_ZONE', '0', 'If a zone is selected, only enable this payment method for that zone.', '6', '2', NULL, '2007-03-07 18:06:09', 'tep_get_zone_class_title', 'tep_cfg_pull_down_zone_classes(');
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 ('158', 'Sort order of display.', 'MODULE_PAYMENT_MONEYORDER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '0', NULL, '2007-03-07 18:06:09', NULL, NULL);
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 ('157', 'Make Payable to:', 'MODULE_PAYMENT_MONEYORDER_PAYTO', 'Infoelec', 'Who should payments be made payable to?', '6', '1', NULL, '2007-03-07 18:06:09', NULL, NULL);
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 ('156', 'Enable Check/Money Order Module', 'MODULE_PAYMENT_MONEYORDER_STATUS', 'False', 'Do you want to accept Check/Money Order payments?', '6', '1', NULL, '2007-03-07 18:06:09', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('149', 'Enable Table Method', 'MODULE_SHIPPING_TABLE_STATUS', 'True', 'Do you want to offer table rate shipping?', '6', '0', NULL, '2006-11-16 20:07:23', NULL, 'tep_cfg_select_option(array(\'True\', \'False\'),');
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 ('150', 'Shipping Table', 'MODULE_SHIPPING_TABLE_COST', '175:13.50,350:17.50', 'The shipping cost is based on the total cost or weight of items. Example: 25:8.50,50:5.50,etc.. Up to 25 charge 8.50, from there to 50 charge 5.50, etc', '6', '0', NULL, '2006-11-16 20:07:23', NULL, NULL);
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 ('151', 'Table Method', 'MODULE_SHIPPING_TABLE_MODE', 'price', 'The shipping cost is based on the order total or the total weight of the items ordered.', '6', '0', NULL, '2006-11-16 20:07:23', NULL, 'tep_cfg_select_option(array(\'weight\', \'price\'),');
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 ('152', 'Handling Fee', 'MODULE_SHIPPING_TABLE_HANDLING', '', 'Handling fee for this shipping method.', '6', '0', NULL, '2006-11-16 20:07:23', NULL, NULL);
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 ('153', 'Tax Class', 'MODULE_SHIPPING_TABLE_TAX_CLASS', '0', 'Use the following tax class on the