Shopping_Cart Sql Sorgulatmak istedim Sql Aşağıdaki
Kod:
#
# Table structure for table 'nuke_store_category'
#
CREATE TABLE nuke_store_cat (
category text NOT NULL,
cat_id int(16) NOT NULL auto_increment,
cat_father_id int(16) DEFAULT '0' NOT NULL,
cat_image varchar(250) NOT NULL,
per_ship decimal(20,2) DEFAULT '0.00' NOT NULL,
item_ship decimal(20,2) DEFAULT '0.00' NOT NULL,
item_int_ship decimal(20,2) DEFAULT '0.00' NOT NULL,
per_int_ship decimal(20,2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY (cat_id, cat_id)
);
#
# Dumping data for table 'nuke_store_cat'
#
INSERT INTO nuke_store_category VALUES ( 'BOBINAS DE PLOTTER', '43', '0', 'albatecnica1.jpg', '0.00', '0.00', '0.00', '0.00');
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_config'
#
CREATE TABLE nuke_store_config (
site_email varchar(40) NOT NULL,
site_country varchar(225) NOT NULL,
site_tax decimal(10,2) DEFAULT '0.00' NOT NULL,
site_url varchar(225) NOT NULL,
site_url_ssl varchar(225) NOT NULL,
site_name varchar(50) NOT NULL,
site_phone varchar(50) NOT NULL,
site_fax varchar(50) NOT NULL,
site_address text NOT NULL,
site_dir varchar(225) NOT NULL,
site_currency varchar(20) NOT NULL,
bg_colour varchar(7) NOT NULL,
colour_1 varchar(7) NOT NULL,
colour_2 varchar(7) NOT NULL,
colour_3 varchar(7) NOT NULL,
colour_4 varchar(7) NOT NULL,
on_ssl char(1) DEFAULT 'N' NOT NULL,
pass varchar(32) NOT NULL,
user varchar(255) NOT NULL,
date int(16) DEFAULT '0' NOT NULL,
online char(1) DEFAULT 'Y' NOT NULL,
offmsg text NOT NULL,
sale char(1) DEFAULT 'N' NOT NULL,
site_business varchar(225) NOT NULL,
site_c o o k i e int(16) DEFAULT '0' NOT NULL,
site_language varchar(225) NOT NULL,
banned_ip text NOT NULL,
admin_ip text NOT NULL,
stats_disp char(1) DEFAULT 'Y' NOT NULL,
sale_disp char(1) DEFAULT 'Y' NOT NULL,
pop_disp char(1) DEFAULT 'Y' NOT NULL,
spot_disp char(1) DEFAULT 'Y' NOT NULL,
prod_limit int(16) DEFAULT '0' NOT NULL,
prod_order varchar(30) NOT NULL,
cat_rows int(16) DEFAULT '0' NOT NULL,
cat_order varchar(30) NOT NULL,
cat_format varchar(30) NOT NULL,
cart_thumb char(1) DEFAULT 'Y' NOT NULL,
refer_url char(1) DEFAULT 's' NOT NULL,
welcome_note text NOT NULL,
site_notify char(1) DEFAULT 'Y' NOT NULL,
pay_default varchar(30) NOT NULL
);
#
# Dumping data for table 'nuke_store_config'
#
INSERT INTO nuke_store_config VALUES ( 'tucorreo@tudominio.com', 'España', '16.00', 'http://www.tudominio.com', '', 'Tu título', '000-000000', '000-000000', 'C/Calle,15
02002
Albacete,
España.', '/home/chs/tudominio.com/home/html', 'eur', '#F2F3F4', '#FFFFFF', '#999999', '#EFF5FA', '#E9EAF4', 'N', 'e3afed0047b08059d0fada10f400c1e5', 'Admin', '1', 'Y', '<p align=\"center\">¡Por ahora, la tienda está fuera de linea, la activaremos en breve!</p>', 'Y', 'Tu sitio', '86400', 'spanish', '', '', 'Y', 'Y', 'N', 'Y', '10', 'title asc', '2', 'category asc', 'b', 'Y', 'b', 'Hola, bienvenido a nuestra Tienda Online.', 'Y', 'Postal');
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_countries'
#
CREATE TABLE nuke_store_countries (
country text NOT NULL,
country_id int(3) DEFAULT '0' NOT NULL,
status char(1) DEFAULT 'i' NOT NULL,
PRIMARY KEY (country_id, country_id)
);
#
# Dumping data for table 'nuke_store_countries'
#
INSERT INTO nuke_store_countries VALUES ( 'Albania', '2', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Algeria', '3', 'e');
INSERT INTO nuke_store_countries VALUES ( 'American Samoa', '4', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Andorra', '5', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Angola', '6', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Anguilla', '7', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Antarctica', '8', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Antigua And Barbuda', '9', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Argentina', '10', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Armenia', '11', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Aruba', '12', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Australia', '13', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Austria', '14', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Azerbaijan', '15', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bahamas', '16', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bahrain', '17', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bangladesh', '18', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Barbados', '19', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Belarus', '20', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Belgium', '21', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Belize', '22', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Benin', '23', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bermuda', '24', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bhutan', '25', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bolivia', '26', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bosnia and Herzegovina', '27', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Botswana', '28', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bouvet Island', '29', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Brazil', '30', 'e');
INSERT INTO nuke_store_countries VALUES ( 'British Indian Ocean Territory', '31', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Brunei Darussalam', '32', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Bulgaria', '33', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Burkina Faso', '34', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Burma', '35', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Burundi', '36', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cambodia', '37', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cameroon', '38', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Canada', '39', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cape Verde', '40', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cayman Islands', '41', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Central African Republic', '42', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Chad', '43', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Chile', '44', 'e');
INSERT INTO nuke_store_countries VALUES ( 'China', '45', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Christmas Island', '46', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cocos Keeling Islands', '47', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Colombia', '48', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Comoros', '49', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Congo', '50', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Congo the Democratic Republic of the', '51', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cook Islands', '52', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Costa Rica', '53', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cote d Ivoire', '54', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Croatia', '55', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Cyprus', '56', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Czech Republic', '57', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Denmark', '59', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Djibouti', '60', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Dominica', '61', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Dominican Republic', '62', 'e');
INSERT INTO nuke_store_countries VALUES ( 'East Timor', '63', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Ecuador', '64', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Egypt', '65', 'e');
INSERT INTO nuke_store_countries VALUES ( 'El Salvador', '66', 'e');
INSERT INTO nuke_store_countries VALUES ( 'England', '67', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Equatorial Guinea', '68', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Eritrea', '69', 'e');
INSERT INTO nuke_store_countries VALUES ( 'España', '70', 'n');
INSERT INTO nuke_store_countries VALUES ( 'Estonia', '71', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Ethiopia', '72', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Falkland Islands', '73', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Faroe Islands', '74', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Fiji', '75', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Finland', '76', 'e');
INSERT INTO nuke_store_countries VALUES ( 'France', '77', 'e');
INSERT INTO nuke_store_countries VALUES ( 'French Guiana', '78', 'e');
INSERT INTO nuke_store_countries VALUES ( 'French Polynesia', '79', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Gabon', '81', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Gambia', '82', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Georgia', '83', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Germany', '84', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Ghana', '85', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Gibraltar', '86', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Great Britain', '87', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Greece', '88', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Greenland', '89', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Grenada', '90', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guadeloupe', '91', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guam', '92', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guatemala', '93', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guinea', '94', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guinea-Bissau', '95', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Guyana', '96', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Haiti', '97', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Heard and Mc Donald Islands', '98', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Honduras', '99', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Hong Kong', '100', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Hungary', '101', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Iceland', '102', 'e');
INSERT INTO nuke_store_countries VALUES ( 'India', '103', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Indonesia', '104', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Ireland', '105', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Israel', '106', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Italy', '107', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Jamaica', '108', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Japan', '109', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Jordan', '110', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Kazakhstan', '111', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Kenya', '112', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Kiribati', '113', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Korea North', '114', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Korea Republic of', '115', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Korea South', '116', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Kuwait', '117', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Kyrgyzstan', '118', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Lao Peoples Democratic Republic', '119', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Latvia', '120', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Lebanon', '121', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Lesotho', '122', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Liberia', '123', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Liechtenstein', '124', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Lithuania', '125', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Luxembourg', '126', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Macau', '127', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Macedonia', '128', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Madagascar', '129', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Malawi', '130', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Malaysia', '131', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Maldives', '132', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mali', '133', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Malta', '134', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Marshall Islands', '135', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Martinique', '136', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mauritania', '137', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mauritius', '138', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mayotte', '139', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mexico', '140', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Micronesia Federated States of', '141', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Moldova Republic of', '142', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Monaco', '143', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mongolia', '144', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Montserrat', '145', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Morocco', '146', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Mozambique', '147', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Myanmar', '148', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Namibia', '149', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Nauru', '150', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Nepal', '151', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Netherlands', '152', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Netherlands Antilles', '153', 'e');
INSERT INTO nuke_store_countries VALUES ( 'New Caledonia', '154', 'e');
INSERT INTO nuke_store_countries VALUES ( 'New Zealand', '155', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Nicaragua', '156', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Niger', '157', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Nigeria', '158', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Niue', '159', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Norfolk Island', '160', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Northern Ireland', '161', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Northern Mariana Islands', '162', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Norway', '163', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Oman', '164', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Pakistan', '165', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Palau', '166', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Panama', '167', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Papua New Guinea', '168', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Paraguay', '169', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Peru', '170', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Philippines', '171', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Pitcairn', '172', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Poland', '173', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Portugal', '174', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Puerto Rico', '175', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Qatar', '176', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Reunion', '177', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Romania', '178', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Russia', '179', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Russian Federation', '180', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Rwanda', '181', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Saint Kitts and Nevis', '182', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Saint Lucia', '183', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Saint Vincent and the Grenadines', '184', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Samoa Independent', '185', 'e');
INSERT INTO nuke_store_countries VALUES ( 'San Marino', '186', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Sao Tome and Principe', '187', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Saudi Arabia', '188', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Scotland', '189', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Senegal', '190', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Seychelles', '191', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Sierra Leone', '192', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Singapore', '193', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Slovakia', '194', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Slovenia', '195', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Solomon Islands', '196', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Somalia', '197', 'e');
INSERT INTO nuke_store_countries VALUES ( 'South Africa', '198', 'e');
INSERT INTO nuke_store_countries VALUES ( 'South Georgia and the South Sandwich Islands', '199', 'e');
INSERT INTO nuke_store_countries VALUES ( 'South Korea', '200', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Spain', '201', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Sri Lanka', '202', 'e');
INSERT INTO nuke_store_countries VALUES ( 'St. Helena', '203', 'e');
INSERT INTO nuke_store_countries VALUES ( 'St. Pierre and Miquelon', '204', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Suriname', '205', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Svalbard and Jan Mayen Islands', '206', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Swaziland', '207', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Sweden', '208', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Switzerland', '209', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Taiwan', '210', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tajikistan', '211', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tanzania', '212', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Thailand', '213', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Togo', '214', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tokelau', '215', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tonga', '216', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Trinidad', '217', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Trinidad and Tobago', '218', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tunisia', '219', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Turkey', '220', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Turkmenistan', '221', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Turks and Caicos Islands', '222', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Tuvalu', '223', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Uganda', '224', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Ukraine', '225', 'e');
INSERT INTO nuke_store_countries VALUES ( 'United Arab Emirates', '226', 'e');
INSERT INTO nuke_store_countries VALUES ( 'United Kingdom', '227', 'e');
INSERT INTO nuke_store_countries VALUES ( 'United States', '228', 'e');
INSERT INTO nuke_store_countries VALUES ( 'United States Minor Outlying Islands', '229', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Uruguay', '230', 'e');
INSERT INTO nuke_store_countries VALUES ( 'USA', '231', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Uzbekistan', '232', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Vanuatu', '233', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Vatican City State Holy See', '234', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Venezuela', '235', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Viet Nam', '236', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Virgin Islands British', '237', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Virgin Islands U.S.', '238', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Wales', '239', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Wallis and Futuna Islands', '240', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Western Sahara', '241', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Yemen', '242', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Zambia', '243', 'e');
INSERT INTO nuke_store_countries VALUES ( 'Zimbabwe', '244', 'e');
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_customer'
#
CREATE TABLE nuke_store_customer (
email varchar(50) NOT NULL,
password varchar(100) NOT NULL,
name varchar(100) NOT NULL,
add_1 varchar(100) NOT NULL,
add_2 varchar(100) NOT NULL,
town varchar(100) NOT NULL,
county varchar(100) NOT NULL,
postcode varchar(15) NOT NULL,
country varchar(20) NOT NULL,
phone varchar(20) NOT NULL,
customer_id bigint(32) NOT NULL auto_increment,
date int(16) DEFAULT '0' NOT NULL,
time varchar(10) NOT NULL,
ip varchar(30) NOT NULL,
perm char(1) DEFAULT 'Y' NOT NULL,
PRIMARY KEY (customer_id)
);
#
# Dumping data for table 'nuke_store_customer'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_docs'
#
CREATE TABLE nuke_store_docs (
doc_name varchar(255) NOT NULL,
doc_content text NOT NULL,
doc_id int(16) NOT NULL auto_increment,
KEY doc_id (doc_id)
);
#
# Dumping data for table 'nuke_store_docs'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_gateways'
#
CREATE TABLE nuke_store_gateways (
gateway varchar(50) NOT NULL,
status char(1) NOT NULL,
acc varchar(50) NOT NULL,
cust1 varchar(50) NOT NULL,
cust2 varchar(50) NOT NULL,
cust3 varchar(50) NOT NULL
);
#
# Dumping data for table 'nuke_store_gateways'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_inventory'
#
CREATE TABLE nuke_store_inventory (
product varchar(60) NOT NULL,
quantity int(16) DEFAULT '1' NOT NULL,
description text NOT NULL,
image varchar(250) NOT NULL,
price decimal(30,2) DEFAULT '0.00' NOT NULL,
title varchar(250) DEFAULT '0' NOT NULL,
cat_id int(16) DEFAULT '0' NOT NULL,
popularity int(64) DEFAULT '0' NOT NULL,
sale_price decimal(30,2) DEFAULT '0.00' NOT NULL,
PRIMARY KEY (product),
UNIQUE product (product)
);
#
# Dumping data for table 'nuke_store_inventory'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_options_bot'
#
CREATE TABLE nuke_store_options_bot (
assign_id int(32) NOT NULL auto_increment,
product varchar(60) DEFAULT '0' NOT NULL,
option_id int(32) DEFAULT '0' NOT NULL,
value_id int(32) DEFAULT '0' NOT NULL,
option_price decimal(30,2) DEFAULT '0.00' NOT NULL,
option_symbol char(1) NOT NULL,
PRIMARY KEY (assign_id)
);
#
# Dumping data for table 'nuke_store_options_bot'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_options_mid'
#
CREATE TABLE nuke_store_options_mid (
value_id int(16) NOT NULL auto_increment,
value_name varchar(30) NOT NULL,
father_id int(16) DEFAULT '0' NOT NULL,
PRIMARY KEY (value_id)
);
#
# Dumping data for table 'nuke_store_options_mid'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_options_top'
#
CREATE TABLE nuke_store_options_top (
option_id int(16) NOT NULL auto_increment,
option_name varchar(30) NOT NULL,
PRIMARY KEY (option_id)
);
#
# Dumping data for table 'nuke_store_options_top'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_order_inv'
#
CREATE TABLE nuke_store_order_inv (
product varchar(225) NOT NULL,
title varchar(225) NOT NULL,
quantity int(32) DEFAULT '0' NOT NULL,
price decimal(30,2) DEFAULT '0.00' NOT NULL,
cart_order_id varchar(30) NOT NULL,
id int(32) NOT NULL auto_increment,
product_options text NOT NULL,
PRIMARY KEY (id),
KEY id (id)
);
#
# Dumping data for table 'nuke_store_order_inv'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_order_sum'
#
CREATE TABLE nuke_store_order_sum (
cart_order_id varchar(30) NOT NULL,
name varchar(225) NOT NULL,
add_1 varchar(225) NOT NULL,
add_2 varchar(225) NOT NULL,
town varchar(225) NOT NULL,
county varchar(225) NOT NULL,
postcode varchar(225) NOT NULL,
country varchar(225) NOT NULL,
name_d varchar(225) NOT NULL,
add_1_d varchar(225) NOT NULL,
add_2_d varchar(225) NOT NULL,
town_d varchar(225) NOT NULL,
county_d varchar(225) NOT NULL,
postcode_d varchar(225) NOT NULL,
country_d varchar(225) NOT NULL,
phone varchar(225) NOT NULL,
subtotal decimal(30,2) DEFAULT '0.00' NOT NULL,
prod_total decimal(30,2) DEFAULT '0.00' NOT NULL,
total_tax decimal(30,2) DEFAULT '0.00' NOT NULL,
total_ship decimal(30,2) DEFAULT '0.00' NOT NULL,
status int(16) DEFAULT '1' NOT NULL,
sec_order_id varchar(30) NOT NULL,
ip varchar(225) NOT NULL,
date varchar(20) NOT NULL,
time varchar(10) NOT NULL,
email varchar(225) NOT NULL,
comments text NOT NULL,
ship_date varchar(50) NOT NULL,
gateway varchar(50) NOT NULL,
customer_comments text NOT NULL,
PRIMARY KEY (cart_order_id)
);
#
# Dumping data for table 'nuke_store_order_sum'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_search'
#
CREATE TABLE nuke_store_search (
searchstr varchar(255) NOT NULL,
hits int(64) DEFAULT '0' NOT NULL,
id int(64) NOT NULL auto_increment,
PRIMARY KEY (id)
);
#
# Dumping data for table 'nuke_store_search'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_shopping'
#
CREATE TABLE nuke_store_shopping (
session tinytext NOT NULL,
product tinytext NOT NULL,
quantity int(16) DEFAULT '0' NOT NULL,
product_options text NOT NULL,
id int(32) NOT NULL auto_increment,
date int(16) DEFAULT '0' NOT NULL,
KEY id (id)
);
#
# Dumping data for table 'nuke_store_shopping'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_store_stats'
#
CREATE TABLE nuke_store_stats (
date varchar(11) DEFAULT '0' NOT NULL,
hits int(64) DEFAULT '0' NOT NULL
);
Bu forumda yeni başlıklar açamazsınız Bu forumdaki başlıklara cevap veremezsiniz Bu forumdaki mesajlarınızı değiştiremezsiniz Bu forumdaki mesajlarınızı silemezsiniz Bu forumdaki anketlerde oy kullanamazsınız
Arama
Rütbeliler
Profil
Giriş
