-- MySQL dump 8.23
--
-- Host: localhost Database: bugmall
---------------------------------------------------------
-- Server version 3.23.58
--
-- Table structure for table `account_type`
--
DROP TABLE IF EXISTS account_type;
CREATE TABLE account_type (
id int(11) NOT NULL auto_increment,
sub_account_id int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
description text NOT NULL,
type int(4) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `account_type`
--
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (1,0,'Bank','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (2,0,'Accounts Receivable','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (3,0,'Other Current Asset','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (4,0,'Fixed Asset','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (5,0,'Other Asset','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (6,0,'Accounts Payable','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (7,0,'Credit Card','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (8,0,'Other Current Liability','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (9,0,'Long Term Liability','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (10,0,'Equity','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (11,0,'Income','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (12,0,'Cost of Goods Sold','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (13,0,'Expense','',1);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (14,0,'Other Income','',2);
INSERT INTO account_type (id, sub_account_id, name, description, type) VALUES (15,0,'Other Expense','',1);
--
-- Table structure for table `adclicks`
--
DROP TABLE IF EXISTS adclicks;
CREATE TABLE adclicks (
bannerID mediumint(9) NOT NULL default '0',
t_stamp timestamp(14) NOT NULL,
host varchar(255) NOT NULL default '',
KEY clientID (bannerID)
) TYPE=MyISAM;
--
-- Dumping data for table `adclicks`
--
--
-- Table structure for table `adviews`
--
DROP TABLE IF EXISTS adviews;
CREATE TABLE adviews (
bannerID mediumint(9) NOT NULL default '0',
t_stamp timestamp(14) NOT NULL,
host varchar(255) NOT NULL default '',
KEY clientID (bannerID)
) TYPE=MyISAM;
--
-- Dumping data for table `adviews`
--
--
-- Table structure for table `afiliate`
--
DROP TABLE IF EXISTS afiliate;
CREATE TABLE afiliate (
afiliate_id int(11) NOT NULL auto_increment,
afiliate_name varchar(255) NOT NULL default '',
afiliate_description varchar(255) NOT NULL default '',
afiliate_profit varchar(255) NOT NULL default '',
afiliate_id_aleatorio varchar(255) NOT NULL default '',
store_id int(11) NOT NULL default '0',
afiliate_password varchar(255) NOT NULL default '',
PRIMARY KEY (afiliate_id),
UNIQUE KEY billing_id (afiliate_id),
KEY store_id (store_id)
) TYPE=MyISAM;
--
-- Dumping data for table `afiliate`
--
--
-- Table structure for table `afiliate_id`
--
DROP TABLE IF EXISTS afiliate_id;
CREATE TABLE afiliate_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `afiliate_id`
--
INSERT INTO afiliate_id (id) VALUES (2);
--
-- Table structure for table `armazem_id`
--
DROP TABLE IF EXISTS armazem_id;
CREATE TABLE armazem_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `armazem_id`
--
INSERT INTO armazem_id (id) VALUES (2);
--
-- Table structure for table `armazens`
--
DROP TABLE IF EXISTS armazens;
CREATE TABLE armazens (
armazem_id int(11) NOT NULL auto_increment,
vendedor_id int(11) NOT NULL default '0',
armazem_nome varchar(128) NOT NULL default '',
armazem_descricao text,
armazem_thumb_image varchar(255) default NULL,
armazem_full_image varchar(255) default NULL,
armazem_publish char(1) default NULL,
empresa varchar(64) default NULL,
armazem_email varchar(255) default NULL,
armazem_telefone varchar(255) default NULL,
armazem_fax varchar(255) default NULL,
armazem_zone varchar(64) default NULL,
armazem_pais varchar(64) default NULL,
armazem_morada_1 varchar(64) default NULL,
armazem_morada_2 varchar(64) default NULL,
armazem_cidade varchar(64) default NULL,
cdate int(11) default NULL,
mdate int(11) default NULL,
PRIMARY KEY (armazem_id),
KEY vendedor_id (vendedor_id)
) TYPE=MyISAM;
--
-- Dumping data for table `armazens`
--
INSERT INTO armazens (armazem_id, vendedor_id, armazem_nome, armazem_descricao, armazem_thumb_image, armazem_full_image, armazem_publish, empresa, armazem_email, armazem_telefone, armazem_fax, armazem_zone, armazem_pais, armazem_morada_1, armazem_morada_2, armazem_cidade, cdate, mdate) VALUES (1,2,'Warehouse','Small description of warehouse','','','0','Company Owner of the Warehouse','warehouse@site.com','555-555-555555','',NULL,'223','Warehouse address','','Warehouse city',NULL,NULL);
--
-- Table structure for table `artigo_id`
--
DROP TABLE IF EXISTS artigo_id;
CREATE TABLE artigo_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `artigo_id`
--
INSERT INTO artigo_id (id) VALUES (31);
--
-- Table structure for table `artigos`
--
DROP TABLE IF EXISTS artigos;
CREATE TABLE artigos (
artigo_id int(11) NOT NULL auto_increment,
vendedor_id int(11) NOT NULL default '0',
artigo_pai_id int(11) NOT NULL default '0',
artigo_sku varchar(64) NOT NULL default '',
artigo_nome varchar(255) default NULL,
artigo_descricao text,
artigo_pequenadescricao varchar(50) NOT NULL default '',
artigo_thumb_image varchar(255) default NULL,
artigo_full_image varchar(255) default NULL,
artigo_publicar char(1) default NULL,
artigo_weight decimal(10,4) default NULL,
artigo_weight_uom varchar(255) default 'pounds.',
artigo_length decimal(10,4) default NULL,
artigo_width decimal(10,4) default NULL,
artigo_height decimal(10,4) default NULL,
artigo_lwh_uom varchar(255) default 'inches',
artigo_url varchar(255) default NULL,
categoria_id int(11) NOT NULL default '0',
artigo_disponivel_stock int(11) default NULL,
artigo_disponivel_data varchar(255) default NULL,
artigo_especial char(1) default NULL,
artigo_desconto varchar(255) default NULL,
artigo_preco_categoria varchar(255) default NULL,
artigo_preco_1 varchar(255) default NULL,
artigo_preco_2 varchar(255) default NULL,
artigo_preco_3 varchar(255) default NULL,
artigo_preco_4 varchar(255) default NULL,
artigo_preco_5 varchar(255) default NULL,
precocompra varchar(255) NOT NULL default '',
artigo_precocomiva int(11) default NULL,
artigo_primeira_pagina char(1) default NULL,
artigo_cores text,
memo text,
extra_1 varchar(255) default NULL,
extra_2 varchar(255) default NULL,
extra_3 varchar(255) default NULL,
extra_4 varchar(255) default NULL,
extra_5 varchar(255) default '0',
artigo_tamanhos text,
ship_code_id int(11) default NULL,
site_id int(11) NOT NULL default '1',
nr_hits bigint(20) NOT NULL default '0',
nr_vendas bigint(20) NOT NULL default '0',
artigo_preco_especial varchar(255) default NULL,
delivery_date tinyint(1) NOT NULL default '0',
data_criacao varchar(255) default '0',
marca_id int(11) NOT NULL default '0',
iva_id int(11) NOT NULL default '0',
obs text NOT NULL,
mfg_part_number varchar(255) NOT NULL default '',
minimum_quantity int(11) NOT NULL default '0',
category_special int(1) NOT NULL default '1',
id_aleatorio varchar(255) NOT NULL default '',
sort_order int(11) NOT NULL default '0',
campo_1 text NOT NULL,
campo_2 text NOT NULL,
campo_3 text NOT NULL,
campo_4 text NOT NULL,
campo_5 text NOT NULL,
campo_6 text NOT NULL,
campo_7 text NOT NULL,
campo_8 text NOT NULL,
campo_9 text NOT NULL,
campo_10 text NOT NULL,
campo_11 text NOT NULL,
campo_12 text NOT NULL,
campo_13 text NOT NULL,
campo_14 text NOT NULL,
campo_15 text NOT NULL,
campo_16 text NOT NULL,
campo_17 text NOT NULL,
campo_18 text NOT NULL,
campo_19 text NOT NULL,
campo_20 text NOT NULL,
average_retail_price double(11,2) NOT NULL default '0.00',
stock_reorder int(11) NOT NULL default '0',
template_id int(11) NOT NULL default '0',
custom_item_id int(11) NOT NULL default '0',
featured_type tinyint(2) NOT NULL default '0',
use_stock tinyint(2) NOT NULL default '0',
upc varchar(255) NOT NULL default '',
operator_id int(11) NOT NULL default '0',
created_on int(11) NOT NULL default '0',
updated_on int(11) NOT NULL default '0',
unit_id int(11) NOT NULL default '0',
type int(11) NOT NULL default '0',
featured_mall int(1) NOT NULL default '0',
brand_id int(11) NOT NULL default '0',
account_id int(11) NOT NULL default '0',
expire int(11) NOT NULL default '0',
sid varchar(255) NOT NULL default '',
download_1 varchar(255) NOT NULL default '',
download_2 varchar(255) NOT NULL default '',
download_3 varchar(255) NOT NULL default '',
recomended_price varchar(255) NOT NULL default '0',
privcatekey varchar(255) NOT NULL default '',
extra_price_str1 varchar(255) NOT NULL default '',
extra_price_str2 varchar(255) NOT NULL default '',
extra_price_str3 varchar(255) NOT NULL default '',
extra_price_value1 varchar(255) NOT NULL default '',
extra_price_value2 varchar(255) NOT NULL default '',
extra_price_value3 varchar(255) NOT NULL default '',
PRIMARY KEY (artigo_id),
KEY vendedor_id (vendedor_id),
KEY artigo_sku (artigo_sku),
KEY categoria_id (categoria_id),
KEY site_id (site_id),
KEY artigo_pai_id (artigo_pai_id),
KEY id_aleatorio (id_aleatorio),
KEY sort_order (sort_order),
KEY custom_item_id (custom_item_id),
KEY type (type),
KEY brand_id (brand_id),
KEY artigo_publicar (artigo_publicar),
KEY artigo_primeira_pagina (artigo_primeira_pagina),
KEY featured_type (featured_type),
KEY type_2 (type),
KEY sort_order_2 (sort_order),
KEY artigo_nome (artigo_nome),
KEY artigo_thumb_image (artigo_thumb_image)
) TYPE=MyISAM;
--
-- Dumping data for table `artigos`
--
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (11,0,0,'5525','Montblanc 5525 Money Clip Wallet','Collection: Meisterstuck
Material: Calfskin leather
Type: Money clip wallet
Color: Black
Size: 10.8 X 7.6 cm
This stylish wallet by Montblanc in calfskin comes with a gold-tone money clip and 6 credit card pockets.
- Made in Germany.
- Comes with Montblanc\\\'s Authenticity card and Service guide.
','Montblanc 5525 Money Clip Wallet',NULL,'wallet1.jpg','0',2.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,7,20,NULL,NULL,NULL,NULL,'289.95',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,12,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1176223462,1176223462,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (5,0,0,'SKU199','Featured Item','Featured Item ','Featured Item','82349516.jpg','82349516.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,9,NULL,NULL,NULL,NULL,'10',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,1,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1176752758,1176997216,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (6,0,0,'SKU2','Product name without image','
','','','','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,0,0,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1176993330,1176993330,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (7,0,0,'SKU5','Product name without image','
','','','','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,0,0,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1176993523,1176993523,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (8,0,0,'SKU6','Pick of the Week Item','Pick of the Week Item
','Pick of the Week Item','208360943.jpg','208360943.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,10,NULL,NULL,NULL,NULL,'100',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,1,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,2,0,'',0,1176993736,1176994312,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (9,0,0,'SKU7','Pick of the Month Item','Pick of the Month Item
','Pick of the Month Item','227466399.jpg','227466399.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'20',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,3,0,'',0,1176994397,1176994487,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (10,0,0,'SKU8','Gift Ideas','Gift Ideas
','Gift Ideas','995501131.jpg','995501131.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'10',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,4,0,'',0,1176994531,1176995085,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (12,0,0,'SKU9','Exclusive Items','Exclusive Items
','Exclusive Items','82349516.jpg','82349516.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'20',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,5,0,'',0,1176995188,1176995188,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (13,0,0,'SKU10','New Arrivals Item 1','New Arrivals Item 1
','New Arrivals Item 1','475882870.jpg','475882870.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'20',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,6,0,'',0,1176995376,1176995521,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (14,0,0,'SKU11','New Arrivals Item 2','New Arrivals Item 2
','New Arrivals Item 2','8980385.jpg','8980385.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,6,0,'',0,1176995423,1176995423,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (15,0,0,'SKU12','New Arrivals Item 3','New Arrivals Item 3
','New Arrivals Item 3','1280827486.jpg','1280827486.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'40',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,6,0,'',0,1176995447,1176995447,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (16,0,0,'SKU13','New Arrivals Item 4','New Arrivals Item 4
','New Arrivals Item 4','2143034556.gif','2143034556.gif','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'70',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,6,0,'',0,1176995483,1176995483,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (17,0,0,'SKU14','Top Picks','Top Picks
','Top Picks','handbag.jpg','handbag.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'90',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,7,0,'',0,1176995589,1176995589,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (18,0,0,'SKU15','Season Special','Season Special
','Season Special','2043708940.jpg','2043708940.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,8,0,'',0,1176995712,1176995712,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (19,0,0,'SKU16','Holiday Special','Holiday Special
','Holiday Special','1280827486.jpg','1280827486.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'55',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,9,0,'',0,1176995756,1176995756,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (20,0,0,'SKU18','Christmas Special','Christmas Special
','Christmas Special','82349516.jpg','82349516.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'22',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,10,0,'',0,1176995840,1176995840,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (21,0,0,'SKU19','Sale Items','Sale Items
','Sale Items','227466399.jpg','227466399.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'240',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,11,0,'',0,1176995948,1176995948,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (22,0,0,'SKU22','Banner Advertised','Banner Advertised
','Banner Advertised','475882870.jpg','475882870.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'33',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,12,0,'',0,1176996009,1176996009,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (23,0,0,'SKU30','Best Seller List Item 1','Best Seller List','Best Seller List Item 1','1322243590.jpg','1322243590.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'28',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,13,0,'',0,1176996053,1176996053,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (24,0,0,'SKU40','Best Bargains Online','Best Bargains Online
','Best Bargains Online','82349516.jpg','82349516.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'210',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,14,0,'',0,1176996107,1176996107,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (25,0,0,'SKU25','Bargains','Bargains
','Bargains','208360943.jpg','208360943.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'22',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,15,0,'',0,1176996158,1176996158,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (26,0,0,'SKU896','Bargin Item 3','Bargin Item 3
','Bargin Item 3','227466399.jpg','227466399.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'10',NULL,NULL,NULL,NULL,'',NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,15,0,'',0,1176998198,1176998198,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (27,0,0,'SPECIAL','Special Product','Special Product
','Special Product','handbag.jpg','handbag.jpg','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'10.00',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,3,0,'4',0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1177006038,1177006038,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (28,0,0,'SPECIALS2','Special Product 2','Special Product 2
','Special Product 2','2143034556.gif','2143034556.gif','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'20.00',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,2,0,'10',0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1177006671,1177006671,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (29,0,0,'AA','AA','AA
','AA','','','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',0,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1177362061,1177362061,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (30,0,0,'MANU1','Manufacturer Product 1','Manufacturer Product 1
','Manufacturer Product 1','','','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,1,0,NULL,0,'0',4,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1177363148,1177363753,0,0,0,0,0,0,'','','','','0','','','','','','','');
INSERT INTO artigos (artigo_id, vendedor_id, artigo_pai_id, artigo_sku, artigo_nome, artigo_descricao, artigo_pequenadescricao, artigo_thumb_image, artigo_full_image, artigo_publicar, artigo_weight, artigo_weight_uom, artigo_length, artigo_width, artigo_height, artigo_lwh_uom, artigo_url, categoria_id, artigo_disponivel_stock, artigo_disponivel_data, artigo_especial, artigo_desconto, artigo_preco_categoria, artigo_preco_1, artigo_preco_2, artigo_preco_3, artigo_preco_4, artigo_preco_5, precocompra, artigo_precocomiva, artigo_primeira_pagina, artigo_cores, memo, extra_1, extra_2, extra_3, extra_4, extra_5, artigo_tamanhos, ship_code_id, site_id, nr_hits, nr_vendas, artigo_preco_especial, delivery_date, data_criacao, marca_id, iva_id, obs, mfg_part_number, minimum_quantity, category_special, id_aleatorio, sort_order, campo_1, campo_2, campo_3, campo_4, campo_5, campo_6, campo_7, campo_8, campo_9, campo_10, campo_11, campo_12, campo_13, campo_14, campo_15, campo_16, campo_17, campo_18, campo_19, campo_20, average_retail_price, stock_reorder, template_id, custom_item_id, featured_type, use_stock, upc, operator_id, created_on, updated_on, unit_id, type, featured_mall, brand_id, account_id, expire, sid, download_1, download_2, download_3, recomended_price, privcatekey, extra_price_str1, extra_price_str2, extra_price_str3, extra_price_value1, extra_price_value2, extra_price_value3) VALUES (31,0,0,'MANU2','Manufacturer Product 2','Manufacturer Product 2
','Manufacturer Product 2','','','0',0.0000,'pounds.',NULL,NULL,NULL,'inches',NULL,3,0,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,1,0,0,NULL,0,'0',4,0,'','',0,1,'',0,'','','','','','','','','','','','','','','','','','','','',0.00,0,0,0,0,0,'',0,1177363713,1177363713,0,0,0,0,0,0,'','','','','0','','','','','','','');
--
-- Table structure for table `artigos_cat`
--
DROP TABLE IF EXISTS artigos_cat;
CREATE TABLE artigos_cat (
artigos_cat_id int(11) NOT NULL auto_increment,
artigo_id int(11) NOT NULL default '0',
categoria_id int(11) NOT NULL default '0',
id_aleatorio varchar(255) NOT NULL default '',
PRIMARY KEY (artigos_cat_id),
UNIQUE KEY artigos_cat_id (artigos_cat_id),
KEY artigo_id (artigo_id),
KEY categoria_id (categoria_id),
KEY id_aleatorio (id_aleatorio)
) TYPE=MyISAM;
--
-- Dumping data for table `artigos_cat`
--
INSERT INTO artigos_cat (artigos_cat_id, artigo_id, categoria_id, id_aleatorio) VALUES (4,4,3,'4');
INSERT INTO artigos_cat (artigos_cat_id, artigo_id, categoria_id, id_aleatorio) VALUES (5,4,3,'1037199409');
INSERT INTO artigos_cat (artigos_cat_id, artigo_id, categoria_id, id_aleatorio) VALUES (6,4,3,'984820447');
--
-- Table structure for table `artigos_cat_id`
--
DROP TABLE IF EXISTS artigos_cat_id;
CREATE TABLE artigos_cat_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `artigos_cat_id`
--
INSERT INTO artigos_cat_id (id) VALUES (2);
--
-- Table structure for table `artigos_tit`
--
DROP TABLE IF EXISTS artigos_tit;
CREATE TABLE artigos_tit (
titulo_1 text NOT NULL,
titulo_2 text NOT NULL,
titulo_3 text NOT NULL,
titulo_4 text NOT NULL,
titulo_5 text NOT NULL,
titulo_6 text NOT NULL,
titulo_7 text NOT NULL,
titulo_8 text NOT NULL,
titulo_9 text NOT NULL,
titulo_10 text NOT NULL,
titulo_11 text NOT NULL,
titulo_12 text NOT NULL,
titulo_13 text NOT NULL,
titulo_14 text NOT NULL,
titulo_15 text NOT NULL,
titulo_16 text NOT NULL,
titulo_17 text NOT NULL,
titulo_18 text NOT NULL,
titulo_19 text NOT NULL,
titulo_20 text NOT NULL,
type_1 int(11) NOT NULL default '0',
type_2 int(11) NOT NULL default '0',
type_3 int(11) NOT NULL default '0',
type_4 int(11) NOT NULL default '0',
type_5 int(11) NOT NULL default '0',
type_6 int(11) NOT NULL default '0',
type_7 int(11) NOT NULL default '0',
type_8 int(11) NOT NULL default '0',
type_9 int(11) NOT NULL default '0',
type_10 int(11) NOT NULL default '0',
type_11 int(11) NOT NULL default '0',
type_12 int(11) NOT NULL default '0',
type_13 int(11) NOT NULL default '0',
type_14 int(11) NOT NULL default '0',
type_15 int(11) NOT NULL default '0',
type_16 int(11) NOT NULL default '0',
type_17 int(11) NOT NULL default '0',
type_18 int(11) NOT NULL default '0',
type_19 int(11) NOT NULL default '0',
type_20 int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `artigos_tit`
--
INSERT INTO artigos_tit (titulo_1, titulo_2, titulo_3, titulo_4, titulo_5, titulo_6, titulo_7, titulo_8, titulo_9, titulo_10, titulo_11, titulo_12, titulo_13, titulo_14, titulo_15, titulo_16, titulo_17, titulo_18, titulo_19, titulo_20, type_1, type_2, type_3, type_4, type_5, type_6, type_7, type_8, type_9, type_10, type_11, type_12, type_13, type_14, type_15, type_16, type_17, type_18, type_19, type_20) VALUES ('','','','','','','','','','','','','','','','','','','','',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
--
-- Table structure for table `auction_id`
--
DROP TABLE IF EXISTS auction_id;
CREATE TABLE auction_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `auction_id`
--
INSERT INTO auction_id (id) VALUES (2);
--
-- Table structure for table `auctions`
--
DROP TABLE IF EXISTS auctions;
CREATE TABLE auctions (
auction_id int(11) NOT NULL auto_increment,
minimum_bid varchar(255) default '0',
bid_increment varchar(255) default '0',
data varchar(255) default '0',
reserve_price varchar(255) default '0',
artigo_id int(11) default '0',
store_id int(11) default '0',
duration varchar(255) default '0',
items_quantity int(11) default '0',
reserve_priceyn int(11) default '0',
auction_image1 varchar(255) NOT NULL default '',
auction_image2 varchar(255) NOT NULL default '',
auction_buyitnow int(11) default '0',
auction_specialpayment varchar(255) NOT NULL default '',
auction_shippinginstructions varchar(255) NOT NULL default '',
featured_type tinyint(2) NOT NULL default '0',
KEY auction_id (auction_id),
KEY featured_type (featured_type),
KEY artigo_id (artigo_id),
KEY store_id (store_id),
KEY data (data)
) TYPE=MyISAM;
--
-- Dumping data for table `auctions`
--
--
-- Table structure for table `bankinfo`
--
DROP TABLE IF EXISTS bankinfo;
CREATE TABLE bankinfo (
id int(11) NOT NULL auto_increment,
orderid int(11) NOT NULL default '0',
field_bankholdername varchar(255) default NULL,
field_banknumber varchar(255) default NULL,
field_routingnumber varchar(255) default NULL,
field_bankname varchar(255) default NULL,
field_banktype int(11) NOT NULL default '0',
field_bankaddress1 varchar(255) default NULL,
field_bankaddress2 varchar(255) default NULL,
field_bankaddress3 varchar(255) default NULL,
PRIMARY KEY (id),
KEY orderid (orderid)
) TYPE=MyISAM;
--
-- Dumping data for table `bankinfo`
--
--
-- Table structure for table `banners`
--
DROP TABLE IF EXISTS banners;
CREATE TABLE banners (
bannerID mediumint(9) NOT NULL auto_increment,
clientID mediumint(9) NOT NULL default '0',
banner longtext NOT NULL,
width smallint(6) NOT NULL default '0',
height smallint(6) NOT NULL default '0',
format enum('gif','jpeg','png','html','url') NOT NULL default 'gif',
url varchar(255) NOT NULL default '',
alt varchar(255) NOT NULL default '',
keyword varchar(255) NOT NULL default '',
bannertext varchar(255) NOT NULL default '',
active enum('true','false') NOT NULL default 'true',
store_id int(11) NOT NULL default '0',
category_id int(11) NOT NULL default '0',
PRIMARY KEY (bannerID)
) TYPE=MyISAM;
--
-- Dumping data for table `banners`
--
--
-- Table structure for table `banners_id`
--
DROP TABLE IF EXISTS banners_id;
CREATE TABLE banners_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `banners_id`
--
INSERT INTO banners_id (id) VALUES (2);
--
-- Table structure for table `bids`
--
DROP TABLE IF EXISTS bids;
CREATE TABLE bids (
bids_id int(11) NOT NULL auto_increment,
customer_id int(11) NOT NULL default '0',
auction_id int(11) NOT NULL default '0',
product_id int(11) NOT NULL default '0',
data varchar(255) NOT NULL default '',
value varchar(255) NOT NULL default '',
memo longtext NOT NULL,
PRIMARY KEY (bids_id),
UNIQUE KEY bids_id (bids_id),
KEY value (value),
KEY product_id (product_id),
KEY customer_id (customer_id),
KEY auction_id (auction_id)
) TYPE=MyISAM;
--
-- Dumping data for table `bids`
--
--
-- Table structure for table `bids_id`
--
DROP TABLE IF EXISTS bids_id;
CREATE TABLE bids_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `bids_id`
--
INSERT INTO bids_id (id) VALUES (2);
--
-- Table structure for table `brand_id`
--
DROP TABLE IF EXISTS brand_id;
CREATE TABLE brand_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `brand_id`
--
INSERT INTO brand_id (id) VALUES (2);
--
-- Table structure for table `brands`
--
DROP TABLE IF EXISTS brands;
CREATE TABLE brands (
brand_id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
description text NOT NULL,
vendor_id int(11) NOT NULL default '0',
thumbnail varchar(80) NOT NULL default '',
image varchar(80) NOT NULL default '',
store_id int(11) NOT NULL default '0',
PRIMARY KEY (brand_id),
UNIQUE KEY brand_id (brand_id)
) TYPE=MyISAM;
--
-- Dumping data for table `brands`
--
--
-- Table structure for table `bugmall`
--
DROP TABLE IF EXISTS bugmall;
CREATE TABLE bugmall (
idioma varchar(32) default NULL,
idioma_txt varchar(32) default NULL,
moeda_base varchar(32) default NULL,
moeda_base_char varchar(32) default NULL,
formato_moeda_base varchar(32) default NULL,
unidade_medida varchar(32) default NULL,
taxa1 varchar(32) default NULL,
taxa2 varchar(32) default NULL,
taxa3 varchar(32) default NULL,
taxa4 varchar(32) default NULL,
taxa5 varchar(32) default NULL,
taxa6 varchar(32) default NULL,
taxa7 varchar(32) default NULL,
taxa8 varchar(32) default NULL,
taxa9 varchar(32) default NULL,
taxa10 varchar(32) default NULL,
pais_taxa1 varchar(32) default NULL,
pais_taxa2 varchar(32) default NULL,
pais_taxa3 varchar(32) default NULL,
pais_taxa4 varchar(32) default NULL,
pais_taxa5 varchar(32) default NULL,
pais_taxa6 varchar(32) default NULL,
pais_taxa7 varchar(32) default NULL,
pais_taxa8 varchar(32) default NULL,
pais_taxa9 varchar(32) default NULL,
pais_taxa10 varchar(32) default NULL,
menu char(1) default NULL,
designacao_imposto varchar(32) default NULL,
init_cfgloja int(1) default NULL,
init_cfgmetpag int(1) default NULL,
init_cfgiva int(1) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table `bugmall`
--
INSERT INTO bugmall (idioma, idioma_txt, moeda_base, moeda_base_char, formato_moeda_base, unidade_medida, taxa1, taxa2, taxa3, taxa4, taxa5, taxa6, taxa7, taxa8, taxa9, taxa10, pais_taxa1, pais_taxa2, pais_taxa3, pais_taxa4, pais_taxa5, pais_taxa6, pais_taxa7, pais_taxa8, pais_taxa9, pais_taxa10, menu, designacao_imposto, init_cfgloja, init_cfgmetpag, init_cfgiva) VALUES ('English','EN','US$','US$','$','cm','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','VAT',0,0,0);
--
-- Table structure for table `cambios`
--
DROP TABLE IF EXISTS cambios;
CREATE TABLE cambios (
moeda1 varchar(32) default NULL,
moeda2 varchar(32) default NULL,
moeda3 varchar(32) default NULL,
moeda4 varchar(32) default NULL,
moeda5 varchar(32) default NULL,
cambio_moeda1 varchar(32) default NULL,
cambio_moeda2 varchar(32) default NULL,
cambio_moeda3 varchar(32) default NULL,
cambio_moeda4 varchar(32) default NULL,
cambio_moeda5 varchar(32) default NULL,
sigla1 varchar(6) default NULL,
sigla2 varchar(6) default NULL,
sigla3 varchar(6) default NULL,
sigla4 varchar(6) default NULL,
sigla5 varchar(6) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table `cambios`
--
--
-- Table structure for table `catalog_mall`
--
DROP TABLE IF EXISTS catalog_mall;
CREATE TABLE catalog_mall (
catalog_mall_id int(11) NOT NULL auto_increment,
name_catalog_mall varchar(255) NOT NULL default '',
description_catalog_mall varchar(255) NOT NULL default '',
PRIMARY KEY (catalog_mall_id),
UNIQUE KEY id (catalog_mall_id)
) TYPE=MyISAM;
--
-- Dumping data for table `catalog_mall`
--
--
-- Table structure for table `catalog_mall_id`
--
DROP TABLE IF EXISTS catalog_mall_id;
CREATE TABLE catalog_mall_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `catalog_mall_id`
--
INSERT INTO catalog_mall_id (id) VALUES (2);
--
-- Table structure for table `categoria_id`
--
DROP TABLE IF EXISTS categoria_id;
CREATE TABLE categoria_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `categoria_id`
--
INSERT INTO categoria_id (id) VALUES (3);
--
-- Table structure for table `categorias`
--
DROP TABLE IF EXISTS categorias;
CREATE TABLE categorias (
categoria_id int(11) NOT NULL auto_increment,
vendedor_id int(11) NOT NULL default '0',
categorias_nome varchar(128) NOT NULL default '',
categorias_descricao text,
header varchar(255) default NULL,
categorias_thumb_image varchar(255) default NULL,
categorias_full_image varchar(255) default NULL,
categorias_publicar char(1) default NULL,
categorias_pai varchar(64) default ' 0',
categorias_expandir char(1) default NULL,
categorias_descnsn char(1) default NULL,
categorias_ofertsn char(1) default NULL,
categorias_qtsup varchar(5) default NULL,
categorias_qtdesc varchar(5) default NULL,
categorias_desup varchar(5) default NULL,
categorias_dedesc varchar(5) default NULL,
site_id int(11) NOT NULL default '1',
markup int(11) NOT NULL default '0',
sort_order int(11) NOT NULL default '0',
type int(11) NOT NULL default '0',
PRIMARY KEY (categoria_id),
KEY categoria_id (categoria_id),
KEY vendedor_id (vendedor_id),
KEY type (type),
KEY categorias_publicar (categorias_publicar),
KEY categorias_pai (categorias_pai),
KEY sort_order (sort_order),
KEY categorias_nome (categorias_nome)
) TYPE=MyISAM;
--
-- Dumping data for table `categorias`
--
INSERT INTO categorias (categoria_id, vendedor_id, categorias_nome, categorias_descricao, header, categorias_thumb_image, categorias_full_image, categorias_publicar, categorias_pai, categorias_expandir, categorias_descnsn, categorias_ofertsn, categorias_qtsup, categorias_qtdesc, categorias_desup, categorias_dedesc, site_id, markup, sort_order, type) VALUES (3,0,'Test','
',NULL,'box-large.gif','box-large.gif','0','0','0',NULL,NULL,NULL,NULL,NULL,NULL,1,0,0,0);
--
-- Table structure for table `category_store`
--
DROP TABLE IF EXISTS category_store;
CREATE TABLE category_store (
category_store_id int(11) NOT NULL auto_increment,
category_id int(11) NOT NULL default '0',
store_id int(11) NOT NULL default '0',
PRIMARY KEY (category_store_id),
UNIQUE KEY category_store_id (category_store_id)
) TYPE=MyISAM;
--
-- Dumping data for table `category_store`
--
--
-- Table structure for table `category_store_id`
--
DROP TABLE IF EXISTS category_store_id;
CREATE TABLE category_store_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `category_store_id`
--
INSERT INTO category_store_id (id) VALUES (2);
--
-- Table structure for table `ccard`
--
DROP TABLE IF EXISTS ccard;
CREATE TABLE ccard (
ccard_id tinyint(11) NOT NULL auto_increment,
description varchar(255) NOT NULL default '',
return_value varchar(255) NOT NULL default '',
field_1 varchar(255) NOT NULL default '',
field_2 varchar(255) NOT NULL default '',
field_3 varchar(255) NOT NULL default '',
field_4 varchar(255) NOT NULL default '',
field_5 varchar(255) NOT NULL default '',
field_6 varchar(255) NOT NULL default '',
field_7 varchar(255) NOT NULL default '',
field_8 varchar(255) NOT NULL default '',
field_9 varchar(255) NOT NULL default '',
field_10 varchar(255) NOT NULL default '',
payment_url varchar(255) NOT NULL default '',
return_url varchar(255) NOT NULL default '',
field_value_1 varchar(255) NOT NULL default '',
field_value_2 varchar(255) NOT NULL default '',
field_value_3 varchar(255) NOT NULL default '',
field_value_4 varchar(255) NOT NULL default '',
field_value_5 varchar(255) NOT NULL default '',
field_value_6 varchar(255) NOT NULL default '',
field_value_7 varchar(255) NOT NULL default '',
field_value_8 varchar(255) NOT NULL default '',
field_value_9 varchar(255) NOT NULL default '',
field_value_10 varchar(255) NOT NULL default '',
ccard_type tinyint(11) NOT NULL default '0',
PRIMARY KEY (ccard_id),
UNIQUE KEY ccard_id (ccard_id)
) TYPE=MyISAM;
--
-- Dumping data for table `ccard`
--
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (1,'Cyber Cash','','merchant','merchant_key','auth_type','','','','','','','','http://cr.cybercash.com/cgi-bin/','','/* Your merchant ID goes here. */','/* Your merchant key goes here. */','mauthonly','','','','','','','',1);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (2,'Authorize.NET','1','x_Login','x_ADC_Relay_Response','x_ADC_URL','x_Version','','','','','','','https://www.authorize.net/gateway/transact.dll','','testing','TRUE','https://www.your-store.com/index.php?checkout=6','3.0','','','','','','',2);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (3,'Planet Payment','1','x_Login','x_ADC_Relay_Response','x_ADC_URL','','','','','','','','https://secure.planetpayment.com/gateway/transact.dll','','testing','TRUE','https://www.your-store.com/index.php?checkout=6','','','','','','','',3);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (4,'Paypal','','business','return','currency','','','','','','','','https://secure.paypal.com/cgi-bin/webscr','','your-email@your-store.com','updateorder.php?paymentstatus=2','currency','','','','','','','',4);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (5,'iBILL Gateteway Service','','iBill Account Number','iBill Account Password','','','','','','','','','https://secure.ibill.com/cgi-win/ccard/tpcard.exe','','/* Your iBill Account Number ID goes here. */','/* Your iBill Account Password ID goes here. */','','','','','','','','',5);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (6,'Verisign Payflow Pro','1','Your Verisign merchant ID','Your Verisign password','','','','','','','','','','','/* Your Verisign merchant ID goes here. */','/* Your Verisign password goes here. */','','','','','','','','',6);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (7,'Echo Payment System','','Echo Merchant Id','Merchant Pin Code','','','','','','','','','https://wwws.echo-inc.com/scripts/INR200.EXE','','/* Your Echo merchant ID goes here. */','/* Your Echo Pin Code goes here. */','','','','','','','','',7);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (8,'Quick Commerce','1','x_Login','','','','','','','','','','https://secure.quickcommerce.net/gateway/transact.dll','','Your Quick Commerce Login Goes Here','','','','','','','','','',8);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (9,'eMatic','','eMatic Login','eMatic Password','','','','','','','','','','','Your eMatic Login Goes Here','Your eMatic Password Goes Here','','','','','','','','',9);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (10,'SecPay','','Merchant Id','','','','','','','','','','https://www.secpay.com/java-bin/ValCard?','','Your Merchant ID Goes Here','','','','','','','','','',10);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (11,'SSB (Italy)','1','MID','VALUT','LINGUA','','','','','','','','http://telepaytest.ssb.net/tltest/index.php','','Valuta codice ISO (LIT EUR) (380 978)','(Identificatore merchant assegnato da SSB)','(ITA = italiano * US = USA inglese * FRA = francese * DEU = tedesco * ESP = spagnolo)','','','','','','','',11);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (12,'iPayment','','iPayment User Id','iPayment Currency','','','','','','','','','','','Your ePayment User Id Goes Here','Choose Currency','','','','','','','','',12);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (13,'MBNet (Portugal)','','','','','','','','','','','','','','','','','','','','','','','',13);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (14,'eWAY (Australia)','','','','','','','','','','','','','','','','','','','','','','','',14);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (15,'eMatters (Australia)','','','','','','','','','','','','','','','','','','','','','','','',15);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (16,'Blue Pay','1','Merchant ID','level','','','','','','','','','https://bluepay.onlinedatacorp.com/test/bluepaylitetest.asp','','Your Merchant ID goes here','TEST','','','','','','','','',16);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (17,'Worldpay','1','instId','testMode','lang','currency','','','','','','','https://select.worldpay.com/wcc/purchase','updateorder.php?paymentstatus=2','Your installation ID Goes Here','100','en','','','','','','','',17);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (18,'iTransact','1','home_page','ret_addr','mername','vendor_id','','','','','','','https://secure.paymentclearing.com/cgi-bin/rc/ord.cgi','updateorder.php?paymentstatus=2','Your Home Page Goes Here','Your Return Home Page Goes Here (index.php)','Your iTransact Merchant Name Goes Here','Your iTransact Vendor ID Goes Here','','','','','','',18);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (19,'PsiGate (HTML Posting)','','MerchantID','ThanksURL','NoThanksURL','Result','','','','','','','https://order.psigate.com/psigate. asp','','/* Your merchant ID goes here. */ The name of the Merchant','Redirect to this page on successful completion of a transaction','Redirect to this page on unsuccessful completion of a transaction','Result_ Live = 0 (Default) * Result_ Good = 1 * Result_ Duplicate = 2 * Result_ Decline = 3','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (20,'2Checkout','','sid','','','','','','','','','','https://www.2checkout.com/cgi-bin/sbuyers/cartpurchase.2c','','','','','','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (21,'BidPayXpress Payment Gateway','','tc_merchantid','','','','','','','','','','http://www.bidpayxpress.com/cgi-bin/MerchantGateway.exe/BidStartPay','','','','','','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (23,'BidPayXpress Payment Gateway - Type 2','','tc_merchantid','','','','','','','','','','http://www.bidpayxpress.com/cgi-bin/MerchantGateway.exe/BidStartPay','','','','','','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (24,'PaySystems IMA','','cid','password','','','','','','','','','http://ptpstest.paysystems.com/','','','','','','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (25,'SecurePay','','merchID','URL','','','','','','','','','https://www.securepay.com/secure1/index.asp','','','','','','','','','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (26,'CyberSource','','merchantID','keysDirectory','targetAPIVersion','sendToProduction','enableLog','logDirectory','URL','','','your_merchant_id','https://ics2ws.ic3.com/commerce/1.x/transactionProcessor/','','merchantID','../keys','1.10','true','true','../logs','https://ics2ws.ic3.com/commerce/1.x/transactionProcessor/','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (27,'nzNetPay','','merchantAccount','','','','','','','','','','https://www.NZNetPay.com/handle.php','','','','','','','','https://www.NZNetPay.com/handle.php','','','',0);
INSERT INTO ccard (ccard_id, description, return_value, field_1, field_2, field_3, field_4, field_5, field_6, field_7, field_8, field_9, field_10, payment_url, return_url, field_value_1, field_value_2, field_value_3, field_value_4, field_value_5, field_value_6, field_value_7, field_value_8, field_value_9, field_value_10, ccard_type) VALUES (28,'PayPal Pro','','username','password','path','instance','','','','','','','','','','','','','','','','','','',0);
--
-- Table structure for table `ccard_id`
--
DROP TABLE IF EXISTS ccard_id;
CREATE TABLE ccard_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `ccard_id`
--
INSERT INTO ccard_id (id) VALUES (29);
--
-- Table structure for table `ccard_info`
--
DROP TABLE IF EXISTS ccard_info;
CREATE TABLE ccard_info (
ccard_info_id int(11) NOT NULL auto_increment,
description varchar(255) NOT NULL default '',
value varchar(255) NOT NULL default '0',
site_id int(11) NOT NULL default '0',
PRIMARY KEY (ccard_info_id),
UNIQUE KEY ccard_info_id (ccard_info_id)
) TYPE=MyISAM;
--
-- Dumping data for table `ccard_info`
--
INSERT INTO ccard_info (ccard_info_id, description, value, site_id) VALUES (1,'Visa','1',0);
INSERT INTO ccard_info (ccard_info_id, description, value, site_id) VALUES (2,'Master Card','2',0);
INSERT INTO ccard_info (ccard_info_id, description, value, site_id) VALUES (3,'American Express','3',0);
INSERT INTO ccard_info (ccard_info_id, description, value, site_id) VALUES (4,'Discover','4',0);
--
-- Table structure for table `ccard_info_id`
--
DROP TABLE IF EXISTS ccard_info_id;
CREATE TABLE ccard_info_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `ccard_info_id`
--
INSERT INTO ccard_info_id (id) VALUES (5);
--
-- Table structure for table `ccard_website`
--
DROP TABLE IF EXISTS ccard_website;
CREATE TABLE ccard_website (
ccard_website tinyint(11) NOT NULL auto_increment,
field_value_1 varchar(255) NOT NULL default '',
field_value_2 varchar(255) NOT NULL default '',
field_value_3 varchar(255) NOT NULL default '',
field_value_4 varchar(255) NOT NULL default '',
field_value_5 varchar(255) NOT NULL default '',
field_value_6 varchar(255) NOT NULL default '',
field_value_7 varchar(255) NOT NULL default '',
field_value_8 varchar(255) NOT NULL default '',
field_value_9 varchar(255) NOT NULL default '',
field_value_10 varchar(255) NOT NULL default '',
website_id tinyint(11) NOT NULL default '0',
discount_rate tinyint(11) NOT NULL default '0',
ccard_type tinyint(11) NOT NULL default '0',
PRIMARY KEY (ccard_website)
) TYPE=MyISAM;
--
-- Dumping data for table `ccard_website`
--
--
-- Table structure for table `ccard_website_id`
--
DROP TABLE IF EXISTS ccard_website_id;
CREATE TABLE ccard_website_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `ccard_website_id`
--
INSERT INTO ccard_website_id (id) VALUES (2);
--
-- Table structure for table `ccredito`
--
DROP TABLE IF EXISTS ccredito;
CREATE TABLE ccredito (
ccredito_id int(11) NOT NULL auto_increment,
encomenda_id int(11) NOT NULL default '0',
nome_titular varchar(255) default NULL,
metodos_id int(11) default NULL,
nr_cartaocredito varchar(255) default NULL,
validade_ccredito varchar(11) default NULL,
total varchar(32) default NULL,
cvn int(20) NOT NULL default '0',
ccv int(20) NOT NULL default '0',
issuing_bank varchar(255) NOT NULL default '',
name_cheque varchar(255) NOT NULL default '',
type_cheque int(2) NOT NULL default '0',
date_cheque varchar(255) NOT NULL default '',
date_direct_deposit varchar(255) NOT NULL default '',
date_money_order varchar(255) NOT NULL default '',
exp_month char(3) NOT NULL default '',
exp_year char(3) NOT NULL default '',
card_type int(2) NOT NULL default '0',
cliente_id int(11) NOT NULL default '0',
trans_id bigint(11) NOT NULL default '0',
id_aleatorio bigint(11) NOT NULL default '0',
memo longtext NOT NULL,
tipo int(11) NOT NULL default '0',
ccard_type int(11) NOT NULL default '0',
PRIMARY KEY (ccredito_id)
) TYPE=MyISAM;
--
-- Dumping data for table `ccredito`
--
--
-- Table structure for table `ccredito_id`
--
DROP TABLE IF EXISTS ccredito_id;
CREATE TABLE ccredito_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `ccredito_id`
--
INSERT INTO ccredito_id (id) VALUES (3);
--
-- Table structure for table `cliente_id`
--
DROP TABLE IF EXISTS cliente_id;
CREATE TABLE cliente_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `cliente_id`
--
INSERT INTO cliente_id (id) VALUES (4);
--
-- Table structure for table `clientes`
--
DROP TABLE IF EXISTS clientes;
CREATE TABLE clientes (
cliente_id int(11) NOT NULL auto_increment,
clientes_id varchar(255) NOT NULL default '',
username varchar(255) NOT NULL default 'demo',
password varchar(255) default NULL,
morada_type char(2) default NULL,
morada_type_nome varchar(255) default NULL,
empresa varchar(255) default NULL,
title varchar(255) default NULL,
ultimo_nome varchar(255) default NULL,
primeiro_nome varchar(255) default NULL,
meio_nome varchar(255) default NULL,
telefone_1 varchar(255) default NULL,
telefone_2 varchar(255) default NULL,
fax varchar(255) default NULL,
morada_1 varchar(255) default NULL,
morada_2 varchar(255) default NULL,
cidade varchar(255) default NULL,
estado varchar(255) default NULL,
pais varchar(255) NOT NULL default 'US',
codigopostal varchar(65) default NULL,
email varchar(255) NOT NULL default 'demo@bug-mall.org',
obs text,
revendedor char(1) NOT NULL default '1',
permite_compras char(1) NOT NULL default '0',
grupocompras int(11) NOT NULL default '0',
extra_1 varchar(255) default NULL,
extra_2 varchar(255) default NULL,
extra_3 varchar(255) default NULL,
extra_4 varchar(255) default NULL,
extra_5 varchar(255) default NULL,
data_criacao varchar(255) default NULL,
site_id int(11) NOT NULL default '1',
nr_logins bigint(20) default '0',
total_compras bigint(20) NOT NULL default '0',
total_debito bigint(20) NOT NULL default '0',
total_credito bigint(20) NOT NULL default '0',
nrcontribuinte varchar(65) default NULL,
lastlogin_date varchar(255) NOT NULL default '',
billing_name1 varchar(255) NOT NULL default '',
billing_name2 varchar(255) NOT NULL default '',
billing_address1 varchar(255) NOT NULL default '',
billing_address2 varchar(255) NOT NULL default '',
billing_state int(11) NOT NULL default '0',
billing_country int(11) NOT NULL default '0',
billing_phone1 varchar(255) NOT NULL default '',
billing_phone2 varchar(255) NOT NULL default '',
billing_fax varchar(255) NOT NULL default '',
billing_email varchar(255) NOT NULL default '',
billing_mobile varchar(255) NOT NULL default '',
billing_memo longtext NOT NULL,
shipping_name1 varchar(255) NOT NULL default '',
shipping_name2 varchar(255) NOT NULL default '',
shipping_address1 varchar(255) NOT NULL default '',
shipping_address2 varchar(255) NOT NULL default '',
shipping_state int(11) NOT NULL default '0',
shipping_country int(11) NOT NULL default '0',
shipping_phone1 varchar(255) NOT NULL default '',
shipping_phone2 varchar(255) NOT NULL default '',
shipping_fax varchar(255) NOT NULL default '',
shipping_email varchar(255) NOT NULL default '',
shipping_mobile varchar(255) NOT NULL default '',
shipping_memo longtext NOT NULL,
contact_name1 varchar(255) NOT NULL default '',
contact_name2 varchar(255) NOT NULL default '',
contact_address1 varchar(255) NOT NULL default '',
contact_address2 varchar(255) NOT NULL default '',
contact_state int(11) NOT NULL default '0',
contact_country int(11) NOT NULL default '0',
contact_phone1 varchar(255) NOT NULL default '',
contact_phone2 varchar(255) NOT NULL default '',
contact_fax varchar(255) NOT NULL default '',
contact_email varchar(255) NOT NULL default '',
contact_mobile varchar(255) NOT NULL default '',
contact_memo longtext NOT NULL,
payment_name1 varchar(255) NOT NULL default '',
payment_name2 varchar(255) NOT NULL default '',
payment_address1 varchar(255) NOT NULL default '',
payment_address2 varchar(255) NOT NULL default '',
payment_state int(11) NOT NULL default '0',
payment_country int(11) NOT NULL default '0',
payment_phone1 varchar(255) NOT NULL default '',
payment_phone2 varchar(255) NOT NULL default '',
payment_fax varchar(255) NOT NULL default '',
payment_email varchar(255) NOT NULL default '',
payment_mobile varchar(255) NOT NULL default '',
payment_memo longtext NOT NULL,
operator_id int(11) NOT NULL default '0',
created_on int(11) NOT NULL default '0',
updated_on int(11) NOT NULL default '0',
print_template int(11) NOT NULL default '0',
shipping_id int(11) NOT NULL default '0',
payment_id int(11) NOT NULL default '0',
category_id int(11) NOT NULL default '0',
class_id int(11) NOT NULL default '0',
form_id int(11) NOT NULL default '0',
price_id int(11) NOT NULL default '0',
language_id int(3) NOT NULL default '0',
currency_id int(3) NOT NULL default '0',
PRIMARY KEY (cliente_id),
KEY username (username),
KEY site_id (site_id),
KEY email (email)
) TYPE=MyISAM;
--
-- Dumping data for table `clientes`
--
INSERT INTO clientes (cliente_id, clientes_id, username, password, morada_type, morada_type_nome, empresa, title, ultimo_nome, primeiro_nome, meio_nome, telefone_1, telefone_2, fax, morada_1, morada_2, cidade, estado, pais, codigopostal, email, obs, revendedor, permite_compras, grupocompras, extra_1, extra_2, extra_3, extra_4, extra_5, data_criacao, site_id, nr_logins, total_compras, total_debito, total_credito, nrcontribuinte, lastlogin_date, billing_name1, billing_name2, billing_address1, billing_address2, billing_state, billing_country, billing_phone1, billing_phone2, billing_fax, billing_email, billing_mobile, billing_memo, shipping_name1, shipping_name2, shipping_address1, shipping_address2, shipping_state, shipping_country, shipping_phone1, shipping_phone2, shipping_fax, shipping_email, shipping_mobile, shipping_memo, contact_name1, contact_name2, contact_address1, contact_address2, contact_state, contact_country, contact_phone1, contact_phone2, contact_fax, contact_email, contact_mobile, contact_memo, payment_name1, payment_name2, payment_address1, payment_address2, payment_state, payment_country, payment_phone1, payment_phone2, payment_fax, payment_email, payment_mobile, payment_memo, operator_id, created_on, updated_on, print_template, shipping_id, payment_id, category_id, class_id, form_id, price_id, language_id, currency_id) VALUES (3,'','paulo','qwerty123',NULL,NULL,'Bug Software LLC',NULL,'Andrade a','Paulo a',NULL,'305 748 4914',NULL,'','8345 NW 66 ST #5606','','Miami','18','223','33166','paulo@bug-software.com','','1','0',0,NULL,NULL,NULL,NULL,NULL,NULL,1,5,80,80,80,NULL,'','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','',0,1176221007,1176754546,0,0,0,0,0,0,0,0,0);
INSERT INTO clientes (cliente_id, clientes_id, username, password, morada_type, morada_type_nome, empresa, title, ultimo_nome, primeiro_nome, meio_nome, telefone_1, telefone_2, fax, morada_1, morada_2, cidade, estado, pais, codigopostal, email, obs, revendedor, permite_compras, grupocompras, extra_1, extra_2, extra_3, extra_4, extra_5, data_criacao, site_id, nr_logins, total_compras, total_debito, total_credito, nrcontribuinte, lastlogin_date, billing_name1, billing_name2, billing_address1, billing_address2, billing_state, billing_country, billing_phone1, billing_phone2, billing_fax, billing_email, billing_mobile, billing_memo, shipping_name1, shipping_name2, shipping_address1, shipping_address2, shipping_state, shipping_country, shipping_phone1, shipping_phone2, shipping_fax, shipping_email, shipping_mobile, shipping_memo, contact_name1, contact_name2, contact_address1, contact_address2, contact_state, contact_country, contact_phone1, contact_phone2, contact_fax, contact_email, contact_mobile, contact_memo, payment_name1, payment_name2, payment_address1, payment_address2, payment_state, payment_country, payment_phone1, payment_phone2, payment_fax, payment_email, payment_mobile, payment_memo, operator_id, created_on, updated_on, print_template, shipping_id, payment_id, category_id, class_id, form_id, price_id, language_id, currency_id) VALUES (4,'','test123','test123',NULL,NULL,'Bug Software LLC','0','Andrade','Paulo','','3057484914','','','8345 NW 66 ST #5606','','Miami','18','223','33166','test123@bug-software.com','','1','0',0,NULL,NULL,NULL,NULL,NULL,'1176696000',1,0,10,10,10,'','','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','','','','','',0,0,'','','','','','',0,0,0,0,0,0,0,0,0,0,0,0);
--
-- Table structure for table `clients`
--
DROP TABLE IF EXISTS clients;
CREATE TABLE clients (
clientID mediumint(9) NOT NULL auto_increment,
clientname varchar(255) NOT NULL default '',
contact varchar(255) default NULL,
email varchar(64) NOT NULL default '',
views mediumint(9) default NULL,
clicks mediumint(9) default NULL,
clientusername varchar(64) NOT NULL default '',
clientpassword varchar(64) NOT NULL default '',
PRIMARY KEY (clientID)
) TYPE=MyISAM;
--
-- Dumping data for table `clients`
--
--
-- Table structure for table `clients_id`
--
DROP TABLE IF EXISTS clients_id;
CREATE TABLE clients_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `clients_id`
--
INSERT INTO clients_id (id) VALUES (2);
--
-- Table structure for table `configuracoes`
--
DROP TABLE IF EXISTS configuracoes;
CREATE TABLE configuracoes (
config_id int(11) NOT NULL auto_increment,
simb_antes_string varchar(11) default NULL,
simb_depois_string varchar(11) default NULL,
separador_milhoes varchar(11) default NULL,
valor_conversao varchar(11) default NULL,
estilo_data_abrev varchar(11) default NULL,
separador_data_abrev varchar(11) default NULL,
estilo_data_extenso varchar(20) default NULL,
estilo_hora varchar(11) default NULL,
definicoes_regionais varchar(11) default NULL,
paises int(3) default NULL,
numero_novidades int(3) default NULL,
numero_linhas_listagem int(3) default NULL,
numero_top_vendas int(3) default NULL,
numero_prox_prod int(3) default NULL,
directorio_upload varchar(100) default NULL,
directorio_imag_url varchar(100) default NULL,
separador_decimal varchar(11) default NULL,
pais_id int(11) NOT NULL default '0',
validacao_email int(11) NOT NULL default '0',
preco_iva_loja int(1) NOT NULL default '0',
height_imagem_th varchar(11) NOT NULL default '',
width_imagem_th varchar(11) NOT NULL default '',
height_imagem varchar(11) NOT NULL default '',
width_imagem varchar(11) NOT NULL default '',
check_stock_level tinyint(1) NOT NULL default '1',
subtract_stock tinyint(1) NOT NULL default '1',
mark_product_out_stock tinyint(1) NOT NULL default '1',
stock_re_order_level tinyint(5) NOT NULL default '5',
display_stock_negative tinyint(1) NOT NULL default '1',
use_stocks tinyint(1) NOT NULL default '1',
ups_origin varchar(10) NOT NULL default '',
gateway_onvieworder int(1) NOT NULL default '0',
license longtext,
default_expire int(11) default NULL,
default_theme int(11) NOT NULL default '0',
default_malltheme int(11) NOT NULL default '0',
fax_gateway int(11) NOT NULL default '0',
PRIMARY KEY (config_id)
) TYPE=MyISAM;
--
-- Dumping data for table `configuracoes`
--
INSERT INTO configuracoes (config_id, simb_antes_string, simb_depois_string, separador_milhoes, valor_conversao, estilo_data_abrev, separador_data_abrev, estilo_data_extenso, estilo_hora, definicoes_regionais, paises, numero_novidades, numero_linhas_listagem, numero_top_vendas, numero_prox_prod, directorio_upload, directorio_imag_url, separador_decimal, pais_id, validacao_email, preco_iva_loja, height_imagem_th, width_imagem_th, height_imagem, width_imagem, check_stock_level, subtract_stock, mark_product_out_stock, stock_re_order_level, display_stock_negative, use_stocks, ups_origin, gateway_onvieworder, license, default_expire, default_theme, default_malltheme, fax_gateway) VALUES (1,'$','',',','1','%m/%d/%Y','','%A %d %B, %Y','%H:%M:%S','en_US',1,9,20,8,5,'/home/v6/webstore-v5/images/','/v6/webstore-v5/images/','.',223,1,1,'80','100','','',1,1,1,5,0,1,'90210',0,'',0,0,0,0);
--
-- Table structure for table `configuracoes_id`
--
DROP TABLE IF EXISTS configuracoes_id;
CREATE TABLE configuracoes_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `configuracoes_id`
--
INSERT INTO configuracoes_id (id) VALUES (2);
--
-- Table structure for table `criticas`
--
DROP TABLE IF EXISTS criticas;
CREATE TABLE criticas (
critica_id int(5) NOT NULL auto_increment,
critica_texto text NOT NULL,
critica_rating int(1) default NULL,
artigo_id int(11) NOT NULL default '0',
cliente_id int(11) NOT NULL default '0',
data_criacao varchar(255) NOT NULL default '',
aparece int(1) NOT NULL default '0',
PRIMARY KEY (critica_id),
KEY artigo_id (artigo_id),
KEY cliente_id (cliente_id)
) TYPE=MyISAM;
--
-- Dumping data for table `criticas`
--
INSERT INTO criticas (critica_id, critica_texto, critica_rating, artigo_id, cliente_id, data_criacao, aparece) VALUES (1,'Great product, perfect for me',6,4,0,'1177016993',0);
INSERT INTO criticas (critica_id, critica_texto, critica_rating, artigo_id, cliente_id, data_criacao, aparece) VALUES (2,'Great Product, good buy',6,4,3,'1177017171',0);
--
-- Table structure for table `criticas_id`
--
DROP TABLE IF EXISTS criticas_id;
CREATE TABLE criticas_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `criticas_id`
--
INSERT INTO criticas_id (id) VALUES (2);
--
-- Table structure for table `crossmercha`
--
DROP TABLE IF EXISTS crossmercha;
CREATE TABLE crossmercha (
artigo_id int(11) NOT NULL default '0',
artigo_cross_id int(11) NOT NULL default '0',
random int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `crossmercha`
--
--
-- Table structure for table `crossselling`
--
DROP TABLE IF EXISTS crossselling;
CREATE TABLE crossselling (
artigo_id int(11) NOT NULL default '0',
artigo_cross_id int(11) NOT NULL default '0',
random int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `crossselling`
--
--
-- Table structure for table `custom_item_id`
--
DROP TABLE IF EXISTS custom_item_id;
CREATE TABLE custom_item_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `custom_item_id`
--
INSERT INTO custom_item_id (id) VALUES (2);
--
-- Table structure for table `custom_items`
--
DROP TABLE IF EXISTS custom_items;
CREATE TABLE custom_items (
custom_item_id int(11) NOT NULL auto_increment,
item_id int(11) NOT NULL default '0',
category_id int(11) NOT NULL default '0',
qty int(11) NOT NULL default '0',
memo longtext NOT NULL,
id_aleatorio varchar(255) NOT NULL default '',
PRIMARY KEY (custom_item_id),
UNIQUE KEY custom_item_id (custom_item_id),
KEY item_id (item_id),
KEY category_id (category_id),
KEY id_aleatorio (id_aleatorio)
) TYPE=MyISAM;
--
-- Dumping data for table `custom_items`
--
--
-- Table structure for table `custom_product`
--
DROP TABLE IF EXISTS custom_product;
CREATE TABLE custom_product (
custom_product_id int(11) NOT NULL auto_increment,
custom_product_sku varchar(255) NOT NULL default '',
custom_product_description varchar(255) NOT NULL default '',
custom_product_category_1 int(11) NOT NULL default '0',
custom_product_category_2 int(11) NOT NULL default '0',
custom_product_category_3 int(11) NOT NULL default '0',
custom_product_category_4 int(11) NOT NULL default '0',
custom_product_category_5 int(11) NOT NULL default '0',
custom_product_category_6 int(11) NOT NULL default '0',
custom_product_category_7 int(11) NOT NULL default '0',
custom_product_category_8 int(11) NOT NULL default '0',
custom_product_category_9 int(11) NOT NULL default '0',
custom_product_category_10 int(11) NOT NULL default '0',
custom_product_category_11 int(11) NOT NULL default '0',
custom_product_category_12 int(11) NOT NULL default '0',
custom_product_category_13 int(11) NOT NULL default '0',
custom_product_category_14 int(11) NOT NULL default '0',
custom_product_category_15 int(11) NOT NULL default '0',
custom_product_category_id_1 varchar(255) NOT NULL default '',
custom_product_category_id_2 varchar(255) NOT NULL default '',
custom_product_category_id_3 varchar(255) NOT NULL default '',
custom_product_category_id_4 varchar(255) NOT NULL default '',
custom_product_category_id_5 varchar(255) NOT NULL default '',
custom_product_category_id_6 varchar(255) NOT NULL default '',
custom_product_category_id_7 varchar(255) NOT NULL default '',
custom_product_category_id_8 varchar(255) NOT NULL default '',
custom_product_category_id_9 varchar(255) NOT NULL default '',
custom_product_category_id_10 varchar(255) NOT NULL default '',
custom_product_category_id_11 varchar(255) NOT NULL default '',
custom_product_category_id_12 varchar(255) NOT NULL default '',
custom_product_category_id_13 varchar(255) NOT NULL default '',
custom_product_category_id_14 varchar(255) NOT NULL default '',
custom_product_category_id_15 varchar(255) NOT NULL default '',
store_id int(11) NOT NULL default '0',
vendor_id int(11) NOT NULL default '0',
PRIMARY KEY (custom_product_id),
UNIQUE KEY custom_product_id (custom_product_id)
) TYPE=MyISAM;
--
-- Dumping data for table `custom_product`
--
--
-- Table structure for table `custom_product_id`
--
DROP TABLE IF EXISTS custom_product_id;
CREATE TABLE custom_product_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `custom_product_id`
--
INSERT INTO custom_product_id (id) VALUES (2);
--
-- Table structure for table `department`
--
DROP TABLE IF EXISTS department;
CREATE TABLE department (
id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
description varchar(255) NOT NULL default '',
store_id int(11) NOT NULL default '0',
category_id int(11) NOT NULL default '0',
manufacturer_id int(11) NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;
--
-- Dumping data for table `department`
--
--
-- Table structure for table `department_id`
--
DROP TABLE IF EXISTS department_id;
CREATE TABLE department_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `department_id`
--
INSERT INTO department_id (id) VALUES (2);
--
-- Table structure for table `detalhe_encomendas`
--
DROP TABLE IF EXISTS detalhe_encomendas;
CREATE TABLE detalhe_encomendas (
encomenda_id int(11) NOT NULL default '0',
cliente_id int(11) NOT NULL default '0',
cliente_nome varchar(255) default NULL,
cliente_email varchar(255) default NULL,
data_encomenda varchar(255) default NULL,
metodo_pagamento_id int(11) NOT NULL default '0',
metodo_pagamento varchar(255) default NULL,
metodo_envio_id int(11) NOT NULL default '0',
metodo_envio varchar(255) default NULL,
artigo_id int(11) NOT NULL default '0',
artigo_designacao varchar(255) default NULL,
artigo_quantidade int(11) default NULL,
artigo_valor varchar(255) default NULL,
artigo_precocompra varchar(255) default NULL,
site_id int(11) NOT NULL default '1',
vendedor_id int(11) default NULL,
artigo_desconto varchar(255) default NULL,
processado_sn char(1) default NULL,
endereco_id int(11) NOT NULL default '0',
delivery_date varchar(255) NOT NULL default '',
atributos text,
memo text,
valor_portes varchar(255) default NULL,
art_site_id int(11) NOT NULL default '1',
orderstatus_id int(11) NOT NULL default '2',
paymentstatus_id int(11) NOT NULL default '1',
id_aleatorio varchar(255) NOT NULL default '',
tax_id int(11) NOT NULL default '0',
tax_value double NOT NULL default '0',
tax_rate double NOT NULL default '0',
operator_id int(11) NOT NULL default '0',
created_on int(11) NOT NULL default '0',
updated_on int(11) NOT NULL default '0',
voucher_id int(11) NOT NULL default '0',
KEY encomenda_id (encomenda_id),
KEY cliente_id (cliente_id),
KEY artigo_id (artigo_id),
KEY metodo_envio_id (metodo_envio_id),
KEY metodo_pagamento_id (metodo_pagamento_id),
KEY paymentstatus_id (paymentstatus_id),
KEY orderstatus_id (orderstatus_id),
KEY art_site_id (art_site_id),
KEY tax_id (tax_id),
KEY site_id (site_id),
KEY voucher_id (voucher_id)
) TYPE=MyISAM;
--
-- Dumping data for table `detalhe_encomendas`
--
INSERT INTO detalhe_encomendas (encomenda_id, cliente_id, cliente_nome, cliente_email, data_encomenda, metodo_pagamento_id, metodo_pagamento, metodo_envio_id, metodo_envio, artigo_id, artigo_designacao, artigo_quantidade, artigo_valor, artigo_precocompra, site_id, vendedor_id, artigo_desconto, processado_sn, endereco_id, delivery_date, atributos, memo, valor_portes, art_site_id, orderstatus_id, paymentstatus_id, id_aleatorio, tax_id, tax_value, tax_rate, operator_id, created_on, updated_on, voucher_id) VALUES (9,3,'Paulo a Andrade a','paulo@bug-software.com','1176696000',1,NULL,1,NULL,4,'Product name',1,'10','',1,0,'','1',0,'','','',NULL,1,2,1,'1252323099',0,0,0,0,0,0,0);
INSERT INTO detalhe_encomendas (encomenda_id, cliente_id, cliente_nome, cliente_email, data_encomenda, metodo_pagamento_id, metodo_pagamento, metodo_envio_id, metodo_envio, artigo_id, artigo_designacao, artigo_quantidade, artigo_valor, artigo_precocompra, site_id, vendedor_id, artigo_desconto, processado_sn, endereco_id, delivery_date, atributos, memo, valor_portes, art_site_id, orderstatus_id, paymentstatus_id, id_aleatorio, tax_id, tax_value, tax_rate, operator_id, created_on, updated_on, voucher_id) VALUES (8,4,'Paulo Andrade','test123@bug-software.com','1176696000',1,NULL,1,NULL,5,'TT',1,'10','',1,0,'','1',0,'','','',NULL,1,2,1,'1988156594',0,0,0,0,0,0,0);
--
-- Table structure for table `detalhe_orcamentos`
--
DROP TABLE IF EXISTS detalhe_orcamentos;
CREATE TABLE detalhe_orcamentos (
detalhes_orcamentos_id int(11) NOT NULL auto_increment,
orcamentos_id int(11) NOT NULL default '0',
nr_documento int(11) NOT NULL default '0',
cliente_id int(11) NOT NULL default '0',
vendedor_id int(11) NOT NULL default '0',
artigo_id int(11) NOT NULL default '0',
descricao text NOT NULL,
quantidade varchar(10) NOT NULL default '0',
valorunitario varchar(30) NOT NULL default '0',
taxa_iva varchar(10) NOT NULL default '0',
valortotal varchar(30) NOT NULL default '0',
apontador_id varchar(60) NOT NULL default '',
valoriva varchar(30) NOT NULL default '0',
desconto varchar(10) NOT NULL default '0',
valordesconto varchar(30) NOT NULL default '0',
data varchar(255) NOT NULL default '',
PRIMARY KEY (detalhes_orcamentos_id),
KEY cliente_id (cliente_id),
KEY apontador_id (apontador_id),
KEY artigo_id (artigo_id),
KEY nr_documento (nr_documento),
KEY orcamentos_id (orcamentos_id)
) TYPE=MyISAM;
--
-- Dumping data for table `detalhe_orcamentos`
--
--
-- Table structure for table `detalhe_orcamentos_id`
--
DROP TABLE IF EXISTS detalhe_orcamentos_id;
CREATE TABLE detalhe_orcamentos_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `detalhe_orcamentos_id`
--
INSERT INTO detalhe_orcamentos_id (id) VALUES (2);
--
-- Table structure for table `encomenda_id`
--
DROP TABLE IF EXISTS encomenda_id;
CREATE TABLE encomenda_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `encomenda_id`
--
INSERT INTO encomenda_id (id) VALUES (9);
--
-- Table structure for table `encomendas`
--
DROP TABLE IF EXISTS encomendas;
CREATE TABLE encomendas (
encomenda_id int(11) NOT NULL auto_increment,
cliente_id int(11) NOT NULL default '0',
cliente_nome varchar(255) default NULL,
cliente_email varchar(255) default NULL,
data_encomenda varchar(255) default NULL,
valor_total varchar(255) default NULL,
valor_portes varchar(255) default NULL,
metodo_pagamento_id int(11) NOT NULL default '0',
metodo_envio_id int(11) NOT NULL default '0',
id_aleatorio varchar(255) default NULL,
desconto varchar(5) default NULL,
processado_sn char(1) default NULL,
pago char(1) default NULL,
site_id int(11) NOT NULL default '1',
obs longtext NOT NULL,
moradaentrega varchar(11) NOT NULL default '',
cod_afiliate int(11) NOT NULL default '0',
delivery_date varchar(255) NOT NULL default '',
afiliate_id int(11) NOT NULL default '0',
paymentstatus_id int(11) NOT NULL default '1',
orderstatus_id int(11) NOT NULL default '2',
tax_value double NOT NULL default '0',
created_on int(11) NOT NULL default '0',
updated_on int(11) NOT NULL default '0',
operator_id int(11) NOT NULL default '0',
voucher_id int(11) NOT NULL default '0',
dyn_shippingid varchar(255) default NULL,
track_ip varchar(255) default NULL,
track_country_code varchar(255) default NULL,
track_country_code3 varchar(255) default NULL,
track_country_name varchar(255) default NULL,
track_region varchar(255) default NULL,
track_city varchar(255) default NULL,
track_longitude varchar(20) default NULL,
track_latitude varchar(20) default NULL,
track_postal_code varchar(50) default NULL,
customer_memo text,
vendor_memo text,
memo text,
tracking_order varchar(255) default NULL,
tracking_type int(11) NOT NULL default '0',
PRIMARY KEY (encomenda_id),
KEY cliente_id (cliente_id),
KEY metodo_pagamento_id (metodo_pagamento_id),
KEY metodo_envio_id (metodo_envio_id),
KEY voucher_id (voucher_id),
KEY operator_id (operator_id),
KEY created_on (created_on),
KEY updated_on (updated_on),
KEY paymentstatus_id (paymentstatus_id),
KEY orderstatus_id (orderstatus_id),
KEY afiliate_id (afiliate_id)
) TYPE=MyISAM;
--
-- Dumping data for table `encomendas`
--
INSERT INTO encomendas (encomenda_id, cliente_id, cliente_nome, cliente_email, data_encomenda, valor_total, valor_portes, metodo_pagamento_id, metodo_envio_id, id_aleatorio, desconto, processado_sn, pago, site_id, obs, moradaentrega, cod_afiliate, delivery_date, afiliate_id, paymentstatus_id, orderstatus_id, tax_value, created_on, updated_on, operator_id, voucher_id, dyn_shippingid, track_ip, track_country_code, track_country_code3, track_country_name, track_region, track_city, track_longitude, track_latitude, track_postal_code, customer_memo, vendor_memo, memo, tracking_order, tracking_type) VALUES (9,3,'Paulo a Andrade a','paulo@bug-software.com','1176696000','10','0',1,1,'379628503','0','1','0',1,'','',0,'',0,1,2,0,0,0,0,0,'','10.0.0.20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
INSERT INTO encomendas (encomenda_id, cliente_id, cliente_nome, cliente_email, data_encomenda, valor_total, valor_portes, metodo_pagamento_id, metodo_envio_id, id_aleatorio, desconto, processado_sn, pago, site_id, obs, moradaentrega, cod_afiliate, delivery_date, afiliate_id, paymentstatus_id, orderstatus_id, tax_value, created_on, updated_on, operator_id, voucher_id, dyn_shippingid, track_ip, track_country_code, track_country_code3, track_country_name, track_region, track_city, track_longitude, track_latitude, track_postal_code, customer_memo, vendor_memo, memo, tracking_order, tracking_type) VALUES (8,4,'Paulo Andrade','test123@bug-software.com','1176696000','10','0',1,1,'711409902','0','1','0',1,'','',0,'',0,1,2,0,0,0,0,0,'','10.0.0.20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
--
-- Table structure for table `enderecos`
--
DROP TABLE IF EXISTS enderecos;
CREATE TABLE enderecos (
endereco_id int(11) NOT NULL auto_increment,
cliente_id varchar(255) NOT NULL default '',
ultimo_nome varchar(255) default NULL,
primeiro_nome varchar(255) default NULL,
meio_nome varchar(255) default NULL,
telefone_1 varchar(255) default NULL,
morada_1 varchar(255) NOT NULL default '',
morada_2 varchar(255) default NULL,
cidade varchar(255) NOT NULL default '',
estado varchar(255) NOT NULL default '',
pais varchar(255) NOT NULL default '',
codigopostal varchar(32) NOT NULL default '',
obs varchar(255) default NULL,
id_aleatorio int(255) NOT NULL default '0',
PRIMARY KEY (endereco_id)
) TYPE=MyISAM;
--
-- Dumping data for table `enderecos`
--
--
-- Table structure for table `enderecos_id`
--
DROP TABLE IF EXISTS enderecos_id;
CREATE TABLE enderecos_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `enderecos_id`
--
INSERT INTO enderecos_id (id) VALUES (2);
--
-- Table structure for table `expedicao`
--
DROP TABLE IF EXISTS expedicao;
CREATE TABLE expedicao (
expedicao_id int(11) NOT NULL auto_increment,
expedicao_codigo varchar(20) NOT NULL default '',
expedicao_nome varchar(255) NOT NULL default '',
expedicao_grupo int(11) NOT NULL default '0',
allow_zero_cost tinyint(1) default NULL,
minimum_charge double default NULL,
additional_ship double default NULL,
active tinyint(1) default NULL,
lead_time double NOT NULL default '0',
handling double NOT NULL default '0',
country char(3) NOT NULL default '0',
criteria tinyint(1) NOT NULL default '0',
charge tinyint(1) NOT NULL default '0',
criteria_value varchar(15) NOT NULL default '',
apontador_id varchar(60) NOT NULL default '',
website_id int(11) NOT NULL default '0',
tax int(1) NOT NULL default '0',
zone_id int(11) NOT NULL default '0',
PRIMARY KEY (expedicao_id),
UNIQUE KEY expedicao_id (expedicao_id)
) TYPE=MyISAM;
--
-- Dumping data for table `expedicao`
--
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (1,'UPSGR','
UPS - Ground (Residential)',0,0,0,0,1,1,0,'0',0,0,'0','1460426825',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (2,'UPS2DA','UPS - 2nd Day Air',0,0,0,0,1,2,0,'0',0,0,'0','339243206',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (3,'UPSNDA','UPS - Next Day Air',0,0,0,0,1,1,0,'0',0,0,'0','1839906904',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (4,'USPSPPDC','
U.S.P.S. - Parcel Post w/ Dlvr. Conf.',0,0,0,0,1,1,0,'0',0,0,'0','836335408',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (5,'USPSPMDC','U.S.P.S. - Priority Mail w/ Dlvr. Conf.',0,0,0,0,1,1,0,'0',0,0,'0','1640431716',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (6,'FEGGG','
FedEx Ground - Guaranteed Ground',0,0,0,0,1,1,0,'0',0,0,'0','1739277327',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (7,'FEEPO','FedEx Express - Priority Overnight',0,0,0,0,1,1,0,'0',0,0,'0','1184996326',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (8,'FEEFO','FedEx Express - First Overnight',0,0,0,0,1,1,0,'0',0,0,'0','127376808',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (9,'EWWGPDHL','
Emery Worldwide - Gold Priority Deferred',0,0,0,0,1,2,0,'0',0,0,'0','2098464128',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (10,'EWGPSDHL','Emery Worldwide - Gold Priority Second D',0,0,0,0,1,2,0,'0',0,0,'0','1415224253',0,0,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (11,'PKUP','Customer Pickup At Store(s)',0,0,0,0,1,0,0,'0',0,0,'','327211158',0,1,0);
INSERT INTO expedicao (expedicao_id, expedicao_codigo, expedicao_nome, expedicao_grupo, allow_zero_cost, minimum_charge, additional_ship, active, lead_time, handling, country, criteria, charge, criteria_value, apontador_id, website_id, tax, zone_id) VALUES (12,'SPE','Other Shipping (Contact Store For Details)',0,0,0,0,1,0,0,'0',0,0,'0','1477543899',0,0,0);
--
-- Table structure for table `expedicao_id`
--
DROP TABLE IF EXISTS expedicao_id;
CREATE TABLE expedicao_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `expedicao_id`
--
INSERT INTO expedicao_id (id) VALUES (13);
--
-- Table structure for table `expedicao_table`
--
DROP TABLE IF EXISTS expedicao_table;
CREATE TABLE expedicao_table (
expedicao_id int(11) NOT NULL auto_increment,
amount double default '0',
greater_equal double default '0',
less double default '0',
apontador_id varchar(60) NOT NULL default '',
PRIMARY KEY (expedicao_id),
UNIQUE KEY expedicao_id (expedicao_id)
) TYPE=MyISAM;
--
-- Dumping data for table `expedicao_table`
--
--
-- Table structure for table `expedicao_table_id`
--
DROP TABLE IF EXISTS expedicao_table_id;
CREATE TABLE expedicao_table_id (
id int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `expedicao_table_id`
--
INSERT INTO expedicao_table_id (id) VALUES (2);
--
-- Table structure for table `extras`
--
DROP TABLE IF EXISTS extras;
CREATE TABLE extras (
idioma varchar(255) default NULL,
taxaiva_1 varchar(255) default NULL,
area_1 varchar(255) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table `extras`
--
--
-- Table structure for table `fds`
--
DROP TABLE IF EXISTS fds;
CREATE TABLE fds (
id int(11) NOT NULL auto_increment,
order_id int(11) NOT NULL default '0',
request_id int(11) NOT NULL default '0',
fraud_score varchar(255) NOT NULL default '',
country_match varchar(255) NOT NULL default '',
high_risk_country varchar(255) NOT NULL default '',
free_email varchar(255) NOT NULL default '',
anonymous_proxy varchar(255) NOT NULL default '',
bin_match varchar(255) NOT NULL default '',
bin_name_match varchar(255) NOT NULL default '',
open_proxy_score varchar(255) NOT NULL default '',
spam_source_score varchar(255) NOT NULL default '',
ip_distance varchar(255) NOT NULL