# MySQL dump 8.2 # # Host: localhost Database: #-------------------------------------------------------- # Server version 3.23.33 # # Table structure for table 'tblAddress' # CREATE TABLE tblAddress ( fldAddressID int(10) unsigned NOT NULL AUTO_INCREMENT, fldCompany varchar(40), fldStreet1 varchar(60) DEFAULT '' NOT NULL, fldStreet2 varchar(60), fldCity varchar(50) DEFAULT '' NOT NULL, fldRegion varchar(50) DEFAULT '' NOT NULL, fldPostCode varchar(20) DEFAULT '' NOT NULL, fldCountry varchar(50) DEFAULT '' NOT NULL, PRIMARY KEY (fldAddressID), KEY addr_key (fldStreet1,fldCity,fldRegion), KEY fldPostCode (fldPostCode), KEY fldCountry (fldCountry) ); # # Table structure for table 'tblCard' # CREATE TABLE tblCard ( CardName varchar(30) DEFAULT '' NOT NULL, selected char(1), fldType varchar(16), fldImageURL varchar(255), PRIMARY KEY (CardName) ); # # Dumping data for table 'tblCard' # INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Check','Y','CHECK',NULL); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('MasterCard','Y','CREDIT','images/mastercard.gif'); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Visa','Y','CREDIT','images/visa.gif'); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('American Express','N','CREDIT','images/amex2.gif'); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Novus/Discover','N','CREDIT','images/novusdiscover.jpg'); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Purchase Order','N','PURCHASE ORDER',NULL); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Account Number','N','ACCOUNT',NULL); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Money Order','N','MONEY ORDER',NULL); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('Diners Club','N','CREDIT','images/dinersclub.gif'); INSERT INTO tblCard (CardName,selected,fldType,fldImageURL) VALUES ('JCB','N','CREDIT','images/jcb.gif'); # # Table structure for table 'tblCatField' # CREATE TABLE tblCatField ( CatFieldID int(10) NOT NULL AUTO_INCREMENT, CatID int(10) DEFAULT '0' NOT NULL, Name varchar(100) NOT NULL, PRIMARY KEY CatID_Name (CatID, Name), KEY (CatFieldID) ); # # Table structure for table 'tblAttributes' # CREATE TABLE tblAttributes ( fldAttributeID int(10) unsigned NOT NULL AUTO_INCREMENT, CatID int(10) NOT NULL, ProductID char(20) DEFAULT '0' NOT NULL, fldAttribute varchar(150) NOT NULL, fldAttribValueIs ENUM('price','percent') NOT NULL, fldSelectionType ENUM('one','multiple') NOT NULL, PRIMARY KEY (fldAttributeID), KEY (CatID), KEY (ProductID), KEY (fldAttribute) ); # # Table structure for table 'tblAttribOptions' # CREATE TABLE tblAttribOptions ( fldAttrOptionID int(10) unsigned NOT NULL AUTO_INCREMENT, fldAttributeID int(10) unsigned NOT NULL, fldAttribOption varchar(150) NOT NULL, fldAttribURL varchar(255), fldAttribValue decimal(8,2), PRIMARY KEY (fldAttrOptionID), KEY (fldAttributeID), KEY (fldAttribOption) ); # # Table structure for table 'tblCategory' # CREATE TABLE tblCategory ( CatID int(10) NOT NULL AUTO_INCREMENT, CategoryName char(75), ParentID int(10) DEFAULT '0' NOT NULL, ContainSub char(1), fldIsTaxable char(1) DEFAULT 'Y' NOT NULL, fldRefundDays int(3), fldHasAttributes char(1) DEFAULT 'N' NOT NULL, PRIMARY KEY (CatID), KEY ParentID (ParentID) ); # # Table structure for table 'tblCategoryDel' # CREATE TABLE tblCategoryDel ( CatID int(10) NOT NULL, CategoryName char(75), ParentID int(10) DEFAULT '0' NOT NULL, ContainSub char(1), fldIsTaxable char(1) DEFAULT 'Y' NOT NULL, fldRefundDays int(3), fldHasAttributes char(1) DEFAULT 'N' NOT NULL, PRIMARY KEY (CatID), KEY ParentID (ParentID) ); # # Table structure for table 'tblCountry' # CREATE TABLE tblCountry ( fldCountry varchar(60) DEFAULT '' NOT NULL, fldCountry2 char(3) DEFAULT '' NOT NULL, PRIMARY KEY (fldCountry), KEY Country2 (fldCountry2) ); # # Dumping data for table 'tblCountry' # INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Albania','AL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Algeria','DZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('American Samoa','AS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Andorra','AD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Anguilla','AI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Antigua & Barbuda','AG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Argentina','AR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Aruba','AW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Australia','AU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Austria','AT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Azores','AP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bahamas','BS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bahrain','BH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bangladesh','BD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Barbados','BB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Belgium','BE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Belize','BZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Belarus','BY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Benin','BJ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bermuda','BM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bolivia','BO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bonaire','BL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bosnia','BA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Botswana','BW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Brazil','BR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('British Virgin Islands','VG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Brunei','BN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Bulgaria','BG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Burkina Faso','BF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Burundi','BI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cambodia','KH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cameroon','CM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Canada','CA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Canary Islands','IC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cape Verde Islands','CV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cayman Islands','KY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Central African Republic','CF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Chad','TD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Channel Islands','CD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Chile','CL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('China, Peoples Republic of','CN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Colombia','CO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Congo','CG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cook Islands','CK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Costa Rica','CR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Croatia','HR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Curacao','CB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Cyprus','CY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Czech Republic','CZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Denmark','DK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Djibouti','DJ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Dominica','DM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Dominican Republic','DO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ecuador','EC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Egypt','EG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('El Salvador','SV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('England','EN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Equitorial Guinea','GQ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Eritrea','ER'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Estonia','EE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ethiopia','ET'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Faeroe Islands','FO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Federated States of Micronesia','FM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Fiji','FJ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Finland','FI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('France','FR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('French Guiana','GF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('French Polynesia','PF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Gabon','GA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Gambia','GM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Georgia','GE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Germany','DE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ghana','GH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Gibraltar','GI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Greece','GR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Greenland','GL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Grenada','GD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guadeloupe','GP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guam','GU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guatemala','GT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guinea','GN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guinea-Bissau','GW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Guyana','GY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Haiti','HT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Holland','HO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Honduras','HN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Hong Kong','HK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Hungary','HU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Iceland','IS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('India','IN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Indonesia','ID'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Israel','IL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Italy','IT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ivory Coast','CI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Jamaica','JM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Japan','JP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Jordan','JO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kazakhstan','KZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kenya','KE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kiribati','KI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kosrae','KO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kuwait','KW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Kyrgyzstan','KG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Laos','LA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Latvia','LV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Lebanon','LB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Lesotho','LS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Liberia','LR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Liechtenstein','LI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Lithuania','LT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Luxembourg','LU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Macau','MO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Macedonia','MK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Madagascar','MG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Madeira','ME'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Malawi','MW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Malaysia','MY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Maldives','MV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Mali','ML'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Malta','MT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Marshall Islands','MH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Martinique','MQ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Mauritania','MR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Mauritius','MU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Mexico','MX'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Moldova','MD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Monaco','MC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Montserrat','MS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Morocco','MA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Mozambique','MZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Myanmar','MM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Namibia','NA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Nepal','NP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Netherlands','NL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Netherlands Antilles','AN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('New Caledonia','NC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('New Zealand','NZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Nicaragua','NI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Niger','NE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Nigeria','NG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Norfolk Island','NF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Northern Ireland','NB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Northern Mariana Islands','MP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Norway','NO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Oman','OM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Pakistan','PK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Palau','PW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Panama','PA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Papua New Guinea','PG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Paraguay','PY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Peru','PE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Philippines','PH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Poland','PL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ponape','PO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Portugal','PT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Puerto Rico','PR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Qatar','QA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Republic of Ireland','IE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Republic of Yemen','YE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Reunion','RE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Romania','RO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Rota','RT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Russia','RU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Rwanda','RW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Saba','SS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Saipan','SP'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Saudi Arabia','SA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Scotland','SF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Senegal','SN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Seychelles','SC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Sierra Leone','SL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Singapore','SG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Slovakia','SK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Slovenia','SI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Solomon Islands','SB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('South Africa','ZA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('South Korea','KR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Spain','ES'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Sri Lanka','LK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Barthelemy','NT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Christopher','SW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Croix','SX'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Eustatius','EU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. John','UV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Kitts & Nevis','KN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Lucia','LC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Maarten','MB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Martin','TB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Thomas','VL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('St. Vincent & the Grenadines','VC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Sudan','SD'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Suriname','SR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Swaziland','SZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Sweden','SE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Switzerland','CH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Syria','SY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tahiti','TA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Taiwan','TW'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tajikistan','TJ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tanzania','TZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Thailand','TH'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tinian','TI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Togo','TG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tonga','TO'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tortola','TL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Trinidad & Tobago','TT'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Truk','TU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tunisia','TN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Turkey','TR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Turks & Caicos Islands','TC'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Tuvalu','TV'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Uganda','UG'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Ukraine','UA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Union Island','UI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('United Arab Emirates','AE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('United Kingdom','GB'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('United States','US'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Uruguay','UY'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('US Virgin Islands','VI'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Uzbekistan','UZ'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Vanuatu','VU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Venezuela','VE'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Vietnam','VN'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Virgin Gorda','VR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Wake Island','WK'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Wales','WL'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Wallis & Futuna Islands','WF'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Western Samoa','WS'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Yap','YA'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Yugoslavia','YU'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Zaire','ZR'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Zambia','ZM'); INSERT INTO tblCountry (fldCountry,fldCountry2) VALUES ('Zimbabwe','ZW'); # # Table structure for table 'tblCreditCard' # CREATE TABLE tblCreditCard ( fldCardNumber varchar(40) NOT NULL, fldCardType varchar(20) NOT NULL, fldCustomerID int(10) unsigned DEFAULT '0' NOT NULL, fldExpireMonth int(2) DEFAULT '0' NOT NULL, fldExpireYear int(4) DEFAULT '0' NOT NULL, fldOrderID int(10) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (fldCardNumber,fldOrderID), KEY fldCustomerID (fldCustomerID) ); # # Dumping data for table 'tblCreditCard' # # # Table structure for table 'tblCustomer' # CREATE TABLE tblCustomer ( fldCustomerID int(10) unsigned NOT NULL AUTO_INCREMENT, fldFirstName varchar(40) NOT NULL, fldMI char(1), fldLastName varchar(40) NOT NULL, fldEmail varchar(100) DEFAULT '' NOT NULL, fldPhone varchar(16), fldFax varchar(10), fldPassword varchar(16), fldAddressID int(10) unsigned DEFAULT '0' NOT NULL, fldBalance float(16,4) DEFAULT '0.0000' NOT NULL, fldCurrency char(4) DEFAULT 'USD' NOT NULL, PRIMARY KEY (fldCustomerID), KEY name_key (fldFirstName,fldLastName), KEY fldEmail (fldEmail), KEY fldAddressID (fldAddressID) ); # # Dumping data for table 'tblCustomer' # # # Table structure for table 'tblHistory' # CREATE TABLE tblHistory ( fldVersion varchar(20) DEFAULT '0.00' NOT NULL, fldDate date, fldDatabase varchar(30), fldDbVersion varchar(20), PRIMARY KEY (fldVersion) ); # # Dumping data for table 'tblHistory' # INSERT INTO tblHistory (fldVersion,fldDate,fldDatabase,fldDbVersion) VALUES ('2.14',CURDATE(), 'mysql', TRIM("-log" FROM VERSION()) ); UPDATE tblHistory SET fldDbVersion = TRIM("-beta" FROM fldDbVersion) WHERE fldVersion='2.14'; UPDATE tblHistory SET fldDbVersion = TRIM("-alpha" FROM fldDbVersion) WHERE fldVersion='2.14'; UPDATE tblHistory SET fldDbVersion = TRIM("-gamma" FROM fldDbVersion) WHERE fldVersion='2.14'; # # Table structure for table 'tblLook' # CREATE TABLE tblLook ( categ_num int(2) DEFAULT '0' NOT NULL, bgcolor varchar(20), text varchar(20), link varchar(20), vlink varchar(20), alink varchar(20), logourl varchar(250), title varchar(150), title_color varchar(20), title_url varchar(250), media_url varchar(250), media_width int(4), media_height int(4), welcome_msg blob, footer_msg blob, thank_you_msg blob, shippingtype char(1), secureurl varchar(250), clink varchar(20), email_add varchar(250), bgimage varchar(250), fldAppLanguage varchar(255), fldAdminLanguage varchar(255), fldCurrencyText char(4), fldAdminWeight varchar(15), fldUseUPS char(1), fldCurrencyChar char(12), fldPayProcID int(10), fldCurrencyDecimal char(1), fldAllowSplitShip char(1), PRIMARY KEY (categ_num) ); # # Dumping data for table 'tblLook' # INSERT INTO tblLook (categ_num,bgcolor,text,link,vlink,alink,logourl,title,title_color,title_url,media_url,media_width,media_height,welcome_msg,footer_msg,thank_you_msg,shippingtype,secureurl,clink,email_add,bgimage,fldAppLanguage,fldAdminLanguage,fldCurrencyText,fldAdminWeight,fldUseUPS,fldCurrencyChar,fldPayProcID,fldCurrencyDecimal,fldAllowSplitShip) VALUES (1,'#FFFFFF','#005000','#000080','#800000','#FF0000','','AlaCart','#800080','','','','','Welcome to AlaCart','','Thank you message','W','','#008000','','','english','english','USD','lbs','Y','$',0,'.','Y'); # # Table structure for table 'tblOrderData' # CREATE TABLE tblOrderData ( fldOrderID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, fldSessionID varchar(22) DEFAULT '0' NOT NULL, fldOrderDate date DEFAULT '0000-00-00' NOT NULL, fldShipperID int(4) unsigned DEFAULT '0' NOT NULL, fldPaymentID int(10) unsigned DEFAULT '0' NOT NULL, fldStatus varchar(20) DEFAULT 'UNKNOWN' NOT NULL, fldOkToSplit char(1) DEFAULT 'Y' NOT NULL, fldIsSplit char(1) DEFAULT 'N' NOT NULL, fldComment varchar(255), fldErrExternal varchar(255), fldTaxCost float(16,4), fldCustomerID int(10), fldShipCost float(16,4), fldShipToID int(10), fldMerchantMsg varchar(255), PRIMARY KEY (fldOrderID), KEY fldStatus (fldStatus), KEY fldOrderDate (fldOrderDate) )AUTO_INCREMENT=100; # # Dumping data for table 'tblOrderData' # # # Table structure for table 'tblOrders' # CREATE TABLE tblOrders ( fldOrderItemID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, sessionid char(22) DEFAULT '0' NOT NULL, orderid char(32) DEFAULT '0' NOT NULL, ProductID char(20) DEFAULT '0' NOT NULL, quantity int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (fldOrderItemID), KEY sessionid (sessionid), KEY orderid (orderid) ); # # Dumping data for table 'tblOrders' # # # Table structure for table 'tblOrderAttributes' # CREATE TABLE tblOrderAttributes ( fldOrderItemID INT(10) UNSIGNED NOT NULL, fldAttrOptionID INT(10) UNSIGNED NOT NULL, KEY (fldOrderItemID) ); # # Dumping data for table 'tblOrdersAttributes' # # # Table structure for table 'tblPayProcessor' # CREATE TABLE tblPayProcessor ( fldPayProcID INT(10) UNSIGNED DEFAULT '0' NOT NULL, fldName varchar(16) DEFAULT '' NOT NULL, fldSelected char(1) DEFAULT 'N' NOT NULL, fldPassword varchar(255), fldUser varchar(150), fldData varchar(255), fldCardNumber varchar(60), fldStatus varchar(8), fldProcessor varchar(30), fldSaveCard char(1), fldUserData varchar(250), PRIMARY KEY (fldPayProcID), KEY fldName (fldName) ); # # Dumping data for table 'tblPayProcessor' # INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (1,'Manually', 'Y','','','','', 'LIVE','', 'Y', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (2,'Manually', 'N','','','','4111111111111111','TEST','', 'Y', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (3,'AuthorizeNet','N','','','','', 'LIVE','', 'Y', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (4,'AuthorizeNet','N','','','','4111111111111111','TEST','', 'Y', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (5,'VeriSign', 'N','','','','', 'LIVE','', 'N', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (6,'VeriSign', 'N','','','','', 'TEST','', 'N', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (7,'CyberCash', 'N','','','','', 'LIVE','', 'Y', ''); INSERT INTO tblPayProcessor (fldPayProcID,fldName,fldSelected,fldPassword,fldUser,fldData,fldCardNumber,fldStatus,fldProcessor,fldSaveCard,fldUserData) VALUES (8,'CyberCash', 'N','','','','4111111111111111','TEST','', 'Y', ''); # # Table structure for table 'tblPayment' # CREATE TABLE tblPayment ( fldPaymentID int(10) unsigned NOT NULL AUTO_INCREMENT, fldPaymentType varchar(20) DEFAULT 'UNKNOWN' NOT NULL, fldTypeNumber varchar(60) DEFAULT '0' NOT NULL, fldTransactionID varchar(255) DEFAULT '0' NOT NULL, fldPaymentOrderID varchar(255) DEFAULT '0', fldAmount float(16,4), fldCurrency char(4) DEFAULT 'USD' NOT NULL, fldStatus varchar(20), fldErrMsg varchar(150), fldTransactionType varchar(12), fldDate datetime, fldParentID varchar(255), fldAuthCode varchar(30), PRIMARY KEY (fldPaymentID), KEY fldTypeNumber (fldTypeNumber), KEY fldParentID (fldParentID), KEY fldPaymentOrderID (fldPaymentOrderID), KEY fldTransactionID (fldTransactionID) ); # # Dumping data for table 'tblPayment' # # # Table structure for table 'tblPersistence' # CREATE TABLE tblPersistence ( fldSessionID char(22) DEFAULT '0' NOT NULL, fldCustomerID int(10) unsigned DEFAULT '0' NOT NULL, fldLastModified date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (fldSessionID), KEY fldCustomerID (fldCustomerID), KEY fldLastModified (fldLastModified) ); # # Dumping data for table 'tblPersistence' # # # Table structure for table 'tblProduct' # CREATE TABLE tblProduct ( ProductID char(20) DEFAULT '0' NOT NULL, CatID int(10) DEFAULT '0' NOT NULL, ProductName char(100) NOT NULL, Price decimal(8,2), picture_url char(100), weight decimal(13,2), PRIMARY KEY (ProductID), KEY ProductName (ProductName), KEY CatID (CatID) ); # # Dumping data for table 'tblProduct' # # Table structure for table 'tblProduct' # CREATE TABLE tblProductDel ( ProductID char(20) DEFAULT '0' NOT NULL, CatID int(10) DEFAULT '0' NOT NULL, ProductName char(100) NOT NULL, Price decimal(8,2), picture_url char(100), weight decimal(13,2), PRIMARY KEY (ProductID), KEY ProductName (ProductName), KEY CatID (CatID) ); # # Dumping data for table 'tblProductDel' # # # Table structure for table 'tblProductField' # CREATE TABLE tblProductField ( FieldID int(30) NOT NULL AUTO_INCREMENT, ProductID varchar(20) DEFAULT '0' NOT NULL, FieldName varchar(100) NOT NULL, Value blob, PRIMARY KEY FieldID_Name (ProductID, FieldName), KEY (FieldID) ); # # Dumping data for table 'tblProductField' # # # Table structure for table 'tblRefundItems' # CREATE TABLE tblRefundItems ( fldRefundItemID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, fldOrderID INT(10) UNSIGNED NOT NULL, fldProductID varchar(20) DEFAULT '' NOT NULL, fldQuantity int(10) DEFAULT '0' NOT NULL, fldAmount float(16,4) DEFAULT '0.0000' NOT NULL, fldStatus varchar(12), fldAccessID varchar(20) DEFAULT '' NOT NULL, fldReason varchar(40), fldPaymentID int(10), PRIMARY KEY (fldRefundItemID), KEY fldOrderID (fldOrderID), KEY fldProductID (fldProductID), KEY fldAccessID (fldAccessID) ); # # Dumping data for table 'tblRefundItems' # # # Table structure for table 'tblRefundAttributes' # CREATE TABLE tblRefundAttributes ( fldRefundItemID INT(10) UNSIGNED NOT NULL, fldAttributeID INT(10) UNSIGNED NOT NULL, KEY (fldRefundItemID) ); # # Table structure for table 'tblRegions' # CREATE TABLE tblRegions ( fldRegionShort char(3) DEFAULT '' NOT NULL, fldRegionLong varchar(50) DEFAULT '' NOT NULL, KEY fldRegionShort (fldRegionShort), KEY fldRegionLong (fldRegionLong) ); # # Dumping data for table 'tblRegions' # INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AL','Alabama'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AK','Alaska'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AB','Alberta'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AS','American Samoa'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AZ','Arizona'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AR','Arkansas'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AA','Armed Forces - USA/Canada'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AE','Armed Forces - Europe'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('AP','Armed Forces - Pacific'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('BC','British Columbia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('CA','California'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('CO','Colorado'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('CT','Connecticut'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('DE','Delaware'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('DC','District of Columbia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('FM','Federated States of Micronesia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('FL','Florida'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('GA','Georgia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('GU','Guam'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('HI','Hawaii'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('ID','Idaho'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('IL','Illinois'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('IN','Indiana'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('IA','Iowa'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('KS','Kansas'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('KY','Kentucky'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('LA','Louisiana'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('ME','Maine'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MB','Manitoba'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MH','Marshall Islands'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MD','Maryland'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MA','Massachusetts'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MI','Michigan'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MN','Minnesota'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MS','Mississippi'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MO','Missouri'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MT','Montana'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NE','Nebraska'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NV','Nevada'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NB','New Brunswick'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NH','New Hampshire'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NJ','New Jersey'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NM','New Mexico'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NY','New York'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NF','Newfoundland'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NC','North Carolina'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('ND','North Dakota'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('MP','Northern Mariana Island'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NT','Northwest Territories'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('NS','Nova Scotia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('OH','Ohio'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('OK','Oklahoma'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('ON','Ontario'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('OR','Oregon'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('PW','Palau Island'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('PA','Pennsylvania'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('PE','Prince Edward Island'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('PR','Puerto Rico'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('QC','Quebec'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('RI','Rhode Island'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('SK','Saskatchewan'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('SC','South Carolina'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('SD','South Dakota'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('TN','Tennessee'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('TX','Texas'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('UT','Utah'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('VT','Vermont'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('VI','Virgin Islands'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('VA','Virginia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('WA','Washington'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('WV','West Virginia'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('WI','Wisconsin'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('WY','Wyoming'); INSERT INTO tblRegions (fldRegionShort,fldRegionLong) VALUES ('YT','Yukon Territory'); # # Table structure for table 'tblSetup' # CREATE TABLE tblSetup ( user_name varchar(30), password varchar(30), your_url varchar(250), cart_path varchar(100), fldTradeName varchar(60), fldOrderConfirm blob, fldOrderShip blob, return_home_url varchar(250), return_home_img_url varchar(250), fldOrderRefund blob, helpimage_url varchar(250), fldComputeTaxes char(1), fldEmailNotify char(1) DEFAULT 'N', fldMetaDescr varchar(255), fldMetaKeywords varchar(255), fldUseCheckoutCookie ENUM('Y','N') DEFAULT 'Y', fldRequirePhone ENUM('YES','NO') DEFAULT 'NO' NOT NULL ); # # Dumping data for table 'tblSetup' # INSERT INTO tblSetup (user_name,password,your_url,cart_path,fldTradeName,fldOrderConfirm,fldOrderShip,return_home_url,return_home_img_url,fldOrderRefund,helpimage_url,fldComputeTaxes,fldEmailNotify,fldMetaDescr,fldMetaKeywords,fldUseCheckoutCookie) VALUES ('admin','','','s-cart','Your Company Name','Thank you for buying from .\r\n\r\nYour order information is detailed above. As soon as your order is shipped you will be notified via email. In the mean time, if you have any questions regarding the status of your order, please contact us using the information below.\r\n\r\nHave a nice day.\r\n\r\n','Thank you for shopping with .\r\n\r\nHave a nice day.\r\n\r\n','','home01.gif','Your request for a refund has approved and the refund items have been returned.
To complete the process of receiving your refund, follow the directions below.
','help_btn.gif', 'Y','N','','','Y'); # # Table structure for table 'tblShipItems' # CREATE TABLE tblShipItems ( fldShipItemID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, fldOrderID INT(10) UNSIGNED NOT NULL, fldShipmentID int(10) DEFAULT '0' NOT NULL, fldProductID char(20) DEFAULT '' NOT NULL, fldQuantity int(10) DEFAULT '0' NOT NULL, fldUnitPrice float(16,4), fldRefundCount int(10), PRIMARY KEY (fldShipItemID), KEY fldOrderID (fldOrderID), KEY fldProductID (fldProductID), KEY fldShipmentID (fldShipmentID) ); # # Dumping data for table 'tblShipItems' # # # Table structure for table 'tblShipItemAttributes' # CREATE TABLE tblShipItemAttributes ( fldSiaID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, fldShipItemID INT(10) UNSIGNED NOT NULL, fldAttrOptionID INT(10) UNSIGNED NOT NULL, PRIMARY KEY (fldSiaID), KEY (fldShipItemID) ); # # Dumping data for table 'tblShipItemAttributes' # # # Table structure for table 'tblShipments' # CREATE TABLE tblShipments ( fldShipmentID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, fldOrderID INT(10) UNSIGNED NOT NULL, fldShipDate date, fldShipperID int(4), fldShipCost float(16,4), fldTaxCost float(16,4), fldPaymentID int(10) unsigned, fldTrackingID varchar(50), PRIMARY KEY (fldShipmentID), KEY fldOrderID (fldOrderID) )AUTO_INCREMENT=100; # # Dumping data for table 'tblShipments' # # # Table structure for table 'tblShippers' # CREATE TABLE tblShippers ( fldShipperID int(4) unsigned DEFAULT '0' NOT NULL, fldCarrier varchar(40), fldClass varchar(20), fldMethod varchar(40), PRIMARY KEY (fldShipperID) ); # # Dumping data for table 'tblShippers' # INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (1,'UPS','1DA','Next Day Air'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (2,'UPS','1DP','Next Day Air Saver'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (3,'UPS','2DM','2nd Day Air Early AM'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (4,'UPS','2DA','2nd Day Air'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (5,'UPS','3DS','3 Day Select'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (6,'UPS','GND','Ground'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (7,'UPS','STD','Canada Standard'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (8,'UPS','XPR','Worldwide Express'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (9,'UPS','XDM','Worldwide Express Plus'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (10,'UPS','XPD','Worldwide Expedited'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (11,'USPS','EXP','Express Mail'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (12,'USPS','PRI','Priority Mail'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (13,'USPS','1ST','First Class'); INSERT INTO tblShippers (fldShipperID,fldCarrier,fldClass,fldMethod) VALUES (14,'USPS','3RD','Third Class'); # # Table structure for table 'tblShipping' # CREATE TABLE tblShipping ( ShipID int(5) NOT NULL AUTO_INCREMENT, ShipAmount decimal(5,2), LowAmount decimal(5,2), HighAmount decimal(5,2), PRIMARY KEY (ShipID) ); # # Dumping data for table 'tblShipping' # # # Table structure for table 'tblTax' # CREATE TABLE tblTax ( TaxID int(5) NOT NULL AUTO_INCREMENT, TaxName char(50), TaxAmount decimal(4,2), PRIMARY KEY (TaxID) ); # # Dumping data for table 'tblTax' # # # Table structure for table 'tblTaxTable' # CREATE TABLE tblTaxTable ( fldTaxID int(5) unsigned NOT NULL AUTO_INCREMENT, fldTaxRegion varchar(50), fldTaxCountry varchar(50), fldTaxRate decimal(6,2), PRIMARY KEY (fldTaxID) ); # # Dumping data for table 'tblTaxTable' # INSERT INTO tblTaxTable (fldTaxID,fldTaxRegion,fldTaxCountry,fldTaxRate) VALUES (1,'MT','US',0.0); # # Table structure for table 'tblStatistics' # CREATE TABLE tblStatistics ( fldDate date NOT NULL, fldVisitors int(6) NOT NULL DEFAULT 0, fldSales int(6) NOT NULL DEFAULT 0, fldRefunds int(6) NOT NULL DEFAULT 0, PRIMARY KEY (fldDate) ); # # Dumping data for table 'tblStatistics' # # # Table structure for table 'tblUPS' # CREATE TABLE tblUPS ( fldUpsShipClass varchar(12) DEFAULT '' NOT NULL, fldUpsOrigPostalCode varchar(20) DEFAULT '' NOT NULL, fldUpsOrigCountry varchar(50) DEFAULT '' NOT NULL, fldUpsPackageType varchar(24), fldUpsPickupType varchar(30) DEFAULT '' NOT NULL, fldGround char(1), fldNextDayAir char(1), fld2ndDayAir char(1), fld3DaySelect char(1), fldCanadaStandard char(1), fldWorldExpress char(1), fldWorldExpressPlus char(1), fldWorldExpedited char(1), PRIMARY KEY (fldUpsShipClass) ); # # Dumping data for table 'tblUPS' # INSERT INTO tblUPS (fldUpsShipClass,fldUpsOrigPostalCode,fldUpsOrigCountry,fldUpsPackageType,fldUpsPickupType,fldGround,fldNextDayAir,fld2ndDayAir,fld3DaySelect,fldCanadaStandard,fldWorldExpress,fldWorldExpressPlus,fldWorldExpedited) VALUES ('DEFAULT','43952','US','CUSTOMER','RDP','Y','Y','Y','Y','N','N','N','N'); INSERT INTO tblUPS (fldUpsShipClass,fldUpsOrigPostalCode,fldUpsOrigCountry,fldUpsPackageType,fldUpsPickupType,fldGround,fldNextDayAir,fld2ndDayAir,fld3DaySelect,fldCanadaStandard,fldWorldExpress,fldWorldExpressPlus,fldWorldExpedited) VALUES ('EXPRESS','43952','US','UPS_ExpressBox','RDP','Y','Y','Y','Y','N','N','N','N'); INSERT INTO tblUPS (fldUpsShipClass,fldUpsOrigPostalCode,fldUpsOrigCountry,fldUpsPackageType,fldUpsPickupType,fldGround,fldNextDayAir,fld2ndDayAir,fld3DaySelect,fldCanadaStandard,fldWorldExpress,fldWorldExpressPlus,fldWorldExpedited) VALUES ('WORLDWIDE','43952','US','UPS_ExpressBox','RDP','Y','Y','Y','Y','N','N','N','N');