leon 01/06/22 10:58:03
Modified: freetrade2/install/mysql build.sql
Removed: freetrade2/install/mysql newbuild.sql
Log:
New build script
Revision Changes Path
1.7 +749 -705 freetrade/freetrade2/install/mysql/build.sql
Index: build.sql
===================================================================
RCS file: /home/cvs/freetrade/freetrade2/install/mysql/build.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- build.sql 2001/06/22 17:33:40 1.6
+++ build.sql 2001/06/22 17:58:03 1.7
@@ -1,708 +1,749 @@
-/*
-** File: build.sql
-** Description: FreeTrade Database Schema
-**
-** Version: $Revision: 1.6 $
-** Created: 07/26/1999
-** Author: Leon Atkinson
-** Email: [EMAIL PROTECTED]
-** CVS Author: $Author: leon $
-** Last Revised: $Date: 2001/06/22 17:33:40 $
-**
-** Log : $Log: build.sql,v $
-** Log : Revision 1.6 2001/06/22 17:33:40 leon
-** Log : Future replacement for build.sql (yes, this is messy)
-** Log :
-** Log : Revision 1.5 2001/03/23 18:11:09 leon
-** Log : Changes submitted by Chris Mason.
-** Log :
-** Log : Revision 1.4 2000/07/18 18:57:14 leon
-** Log : Minor tweaks...adding some foreign keys
-** Log :
-** Log : Revision 1.3 2000/07/05 22:25:04 leon
-** Log : Cleaning it up a bit, adding indexes and foreign keys
-** Log :
-**
-** Copyright (c) 1999-2001 Whichever Group. All rights reserved.
-*/
-
-DROP TABLE IF EXISTS attribute;
-
-CREATE TABLE attribute (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- Graphic varchar(255),
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (DisplayPrecedence)
-
-);
-
-
-/*
-** Why CHAR(4) for the ID column instead of INT(11)?
-** One reason: to conform with ECML, which requires
-** the use of these four-character codes.
-*/
-
-DROP TABLE IF EXISTS billing_method;
-
-CREATE TABLE billing_method (
- ID CHAR(4) NOT NULL,
- Name varchar(255) NOT NULL,
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (DisplayPrecedence)
-);
-
-
-
-
-DROP TABLE IF EXISTS department;
-
-CREATE TABLE department (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- Graphic varchar(255),
- Parent int(11) NOT NULL,
- Description blob,
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (Parent),
- INDEX (DisplayPrecedence),
-
- FOREIGN KEY (Parent) REFERENCES department (ID)
-);
-
-
-DROP TABLE IF EXISTS department_item;
-
-CREATE TABLE department_item (
- Department int(11) NOT NULL,
- Item int(11) NOT NULL,
-
- PRIMARY KEY(Department, Item),
-
- FOREIGN KEY (Department) REFERENCES department (ID),
- FOREIGN KEY (Item) REFERENCES item (ID)
-);
-
-
-DROP TABLE IF EXISTS address;
-
-CREATE TABLE address (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name_Prefix VARCHAR(16),
- Name_First VARCHAR(255),
- Name_Middle VARCHAR(255),
- Name_Last VARCHAR(255) NOT NULL,
- Name_Suffix VARCHAR(16),
- Company VARCHAR(255),
- Street1 VARCHAR(255),
- Street2 VARCHAR(255),
- Street3 VARCHAR(255),
- City VARCHAR(255) NOT NULL,
- StateProv VARCHAR(255) NOT NULL,
- PostalCode VARCHAR(255) NOT NULL,
- CountryCode CHAR(2), /* ISO 3166 */
- Phone1 varchar(32),
- Phone2 varchar(32),
- Fax varchar(32),
- Email VARCHAR(255) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name_Last),
- INDEX (City),
- INDEX (StateProv),
- INDEX (PostalCode),
- INDEX (Email)
-);
-
-
-DROP TABLE IF EXISTS invoice;
-
-CREATE TABLE invoice (
- ID int(11) NOT NULL AUTO_INCREMENT,
- User int(11) NOT NULL,
- Active char(1) NOT NULL DEFAULT 'N',
- Created datetime NOT NULL,
-
- PRIMARY KEY (ID),
- INDEX (User),
- INDEX (Active),
- INDEX (Created),
-
- FOREIGN KEY (User) REFERENCES user (ID)
-);
-
-
-DROP TABLE IF EXISTS fee;
-
-CREATE TABLE fee (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name)
-);
-
-
-
-
-DROP TABLE IF EXISTS invoice_fee;
-
-CREATE TABLE invoice_fee (
- Invoice int(11) NOT NULL,
- Fee int(11) NOT NULL,
- Value float(11,2) NOT NULL,
-
- INDEX (Invoice),
- INDEX (Fee),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (Fee) REFERENCES fee (ID)
-);
-
-
-
-DROP TABLE IF EXISTS billing;
-
-CREATE TABLE billing (
- ID int(11) NOT NULL AUTO_INCREMENT,
-
- Invoice int(11) NOT NULL,
- Address int(11) NOT NULL,
- Method CHAR(4) NOT NULL,
-
- # name on card
- CreditCardOwner VARCHAR(255) NOT NULL,
- CreditCardNumber varchar(255) NOT NULL,
- CreditCardExpiration datetime NOT NULL,
-
- # Additional cardholder verification printed on card
- # but not encoded in magnetic strip. See ECML docs.
- CreditCardVerification varchar(4),
-
- PRIMARY KEY(ID),
- INDEX (Invoice),
- INDEX (Address),
- INDEX (Method),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (Address) REFERENCES address (ID),
- FOREIGN KEY (Method) REFERENCES billing_method (ID)
-);
-
-
-DROP TABLE IF EXISTS invoice_status;
-
-CREATE TABLE invoice_status (
- ID int(11) NOT NULL AUTO_INCREMENT,
-
- Invoice int(11) NOT NULL,
- Status int(11) NOT NULL,
- Created datetime NOT NULL,
- Description blob,
-
- PRIMARY KEY(ID),
- INDEX (Invoice),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (Status) REFERENCES status (ID)
-);
-
-
-DROP TABLE IF EXISTS status;
-
-CREATE TABLE status (
- ID int(11) NOT NULL AUTO_INCREMENT,
-
- Name varchar(255) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name)
-);
-
-
-
-
-DROP TABLE IF EXISTS invoice_sku;
-
-CREATE TABLE invoice_sku (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Invoice int(11) NOT NULL,
- SKU int(11) NOT NULL,
- Quantity int(11) NOT NULL,
- ExternalSKU varchar(255) NOT NULL,
- Name varchar(255) NOT NULL,
- ListPrice float(11,2) NOT NULL,
- SalePrice float(11,2) NOT NULL,
- Freight float(11,2) NOT NULL,
- Notes blob,
- Shipping int(11) NOT NULL,
- GiftWrap char(1) NOT NULL DEFAULT 'N',
-
- PRIMARY KEY(ID),
- INDEX (Invoice),
- INDEX (SKU),
- INDEX (ExternalSKU),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (SKU) REFERENCES sku (ID)
-);
-
-
-DROP TABLE IF EXISTS shipping;
-
-CREATE TABLE shipping (
- ID int(11) NOT NULL AUTO_INCREMENT,
-
- Invoice int(11) NOT NULL,
- Address int(11) NOT NULL,
- Method int(11) NOT NULL,
- Message varchar(50),
-
- PRIMARY KEY(ID),
- INDEX (Invoice),
- INDEX (Address),
- INDEX (Method),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (Address) REFERENCES address (ID),
- FOREIGN KEY (Method) REFERENCES shipping_method (ID)
-);
-
-
-
-DROP TABLE IF EXISTS item;
-
-CREATE TABLE item (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- Description blob,
- Keywords blob,
- Thumbnail varchar(255),
- Graphic varchar(255),
- LargeGraphic varchar(255),
- DisplayPrecedence int(11),
- Active char(1) NOT NULL DEFAULT 'N',
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (Active)
-);
-
-
-
-DROP TABLE IF EXISTS item_item;
-
-CREATE TABLE item_item (
- Item int(11) NOT NULL,
- Related_Item int(11) NOT NULL,
- Relationship int(11) NOT NULL,
-
- PRIMARY KEY (Item, Related_Item, Relationship),
- FOREIGN KEY (Item) REFERENCES item (ID),
- FOREIGN KEY (Related_Item) REFERENCES item (ID),
- FOREIGN KEY (Relationship) REFERENCES relationship (ID)
-);
-
-
-
-DROP TABLE IF EXISTS relationship;
-
-CREATE TABLE relationship (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (DisplayPrecedence)
-);
-
-
-
-DROP TABLE IF EXISTS sku;
-
-CREATE TABLE sku (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Item int(11) NOT NULL,
- ExternalSKU varchar(255) NOT NULL,
- Name varchar(255) NOT NULL,
- ListPrice float(11,2) NOT NULL,
- SalePrice float(11,2) NOT NULL,
- AdditionalShipping float(11,2) NOT NULL,
- DisplayPrecedence int(11) NOT NULL,
- Active char(1) NOT NULL DEFAULT 'N',
- InventoryAvailable int(11) NOT NULL,
- CanBackorder char(1) NOT NULL DEFAULT 'N',
-
- PRIMARY KEY(ID),
- INDEX (Item),
- INDEX (ExternalSKU),
- INDEX (Name),
- INDEX (DisplayPrecedence),
- INDEX (Active),
-
- FOREIGN KEY (Item) REFERENCES item (ID)
-);
-
-
-
-DROP TABLE IF EXISTS sku_variation;
-
-CREATE TABLE sku_variation (
- SKU int(11) NOT NULL,
- Variation int(11) NOT NULL,
-
- PRIMARY KEY (SKU, Variation),
-
- FOREIGN KEY (SKU) REFERENCES sku (ID),
- FOREIGN KEY (Variation) REFERENCES variation (ID)
-);
-
-
-DROP TABLE IF EXISTS seed;
-
-CREATE TABLE seed (
- seed int(11) NOT NULL DEFAULT 314
-);
-
-
-
-DROP TABLE IF EXISTS session;
-
-CREATE TABLE session
-(
- ID VARCHAR(16) NOT NULL,
- User INT,
- LastAction datetime,
- Invoice int(11),
-
- PRIMARY KEY(ID),
- INDEX (User),
- INDEX (Invoice),
-
- FOREIGN KEY (User) REFERENCES user (ID),
- FOREIGN KEY (Invoice) REFERENCES invoice (ID)
-);
-
-
-DROP TABLE IF EXISTS session_sku;
-
-CREATE TABLE session_sku (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Session varchar(24) NOT NULL,
- SKU int(11) NOT NULL,
- Quantity int(11) NOT NULL,
- Notes blob,
-
- PRIMARY KEY(ID),
- INDEX (Session),
- INDEX (SKU),
-
- FOREIGN KEY (Session) REFERENCES session (ID),
- FOREIGN KEY (SKU) REFERENCES sku (ID)
-);
-
-
-
-DROP TABLE IF EXISTS shipping_method;
-
-CREATE TABLE shipping_method (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (DisplayPrecedence)
-);
-
-
-
-
-
-DROP TABLE IF EXISTS user;
-
-CREATE TABLE user (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Login varchar(255) NOT NULL,
- Password varchar(255) NOT NULL,
- Address int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Login),
- INDEX (Address),
-
- FOREIGN KEY (Address) REFERENCES address (ID)
-);
-
-
-
-# this is for saving a wish list
-DROP TABLE IF EXISTS user_sku;
-
-CREATE TABLE user_sku (
- ID int(11) NOT NULL AUTO_INCREMENT,
- User int(11) NOT NULL,
- SKU int(11) NOT NULL,
- Quantity int(11) NOT NULL,
- Notes blob,
-
- PRIMARY KEY(ID),
- INDEX (User),
- INDEX (SKU),
-
- FOREIGN KEY (User) REFERENCES user (ID),
- FOREIGN KEY (SKU) REFERENCES sku (ID)
-);
-
-
-DROP TABLE IF EXISTS variation;
-
-CREATE TABLE variation (
- ID int(11) NOT NULL AUTO_INCREMENT,
- Name varchar(255) NOT NULL,
- Attribute int(11) NOT NULL,
- Description varchar(255),
- Graphic varchar(255),
- DisplayPrecedence int(11) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name),
- INDEX (Attribute),
- INDEX (DisplayPrecedence),
-
- FOREIGN KEY (Attribute) REFERENCES attribute (ID)
-);
-
-
-DROP TABLE IF EXISTS permission;
-
-CREATE TABLE permission
-(
- ID INT NOT NULL AUTO_INCREMENT,
- Name VARCHAR(255) NOT NULL,
-
- PRIMARY KEY(ID),
- INDEX (Name)
-);
-
-
-
-DROP TABLE IF EXISTS user_permission;
-
-CREATE TABLE user_permission
-(
- User INT(11) NOT NULL,
- Permission INT(11) NOT NULL,
-
- PRIMARY KEY (User, Permission),
- FOREIGN KEY (User) REFERENCES user (ID),
- FOREIGN KEY (Permission) REFERENCES permission (ID)
-);
-
-
-
-
-DROP TABLE IF EXISTS tax;
-
-CREATE TABLE tax (
- State char(2) NOT NULL,
- Rate float(4,5) NOT NULL,
- TaxShipping char(1) NOT NULL DEFAULT 'N',
-
- PRIMARY KEY(State)
-);
-
-
-
-
-DROP TABLE IF EXISTS coupon;
-
-CREATE TABLE coupon (
- ID int(11) DEFAULT '0' NOT NULL auto_increment,
- Name varchar(32) NOT NULL,
- DollarOff float(5,2),
- PercentageOff float(5,2),
- MinAmountPurchased float(5,2),
- StartDate timestamp(14),
- EndDate timestamp(14),
- NeverExpires int(1) DEFAULT '0',
- Combineable int(1) DEFAULT '0',
- DisplayPrecedence int(3),
-
- PRIMARY KEY (ID),
- INDEX (Name),
- INDEX (DisplayPrecedence)
-);
-
-DROP TABLE IF EXISTS coupon_user;
-
-CREATE TABLE coupon_user (
- Coupon int(11) NOT NULL,
- User int(11) NOT NULL,
-
- PRIMARY KEY (Coupon, User),
-
- FOREIGN KEY (Coupon) REFERENCES coupon (ID),
- FOREIGN KEY (User) REFERENCES user (ID)
-);
-
-
-DROP TABLE IF EXISTS invoice_coupon;
-
-CREATE TABLE invoice_coupon (
- Invoice int(11) NOT NULL,
- Coupon int(11) NOT NULL,
-
- PRIMARY KEY (Invoice, Coupon),
-
- FOREIGN KEY (Invoice) REFERENCES invoice (ID),
- FOREIGN KEY (Coupon) REFERENCES coupon (ID)
-);
-
-
-/*
-** Insert minimal rows to make the application work
-**
-*/
-
-#starting seed used for unique session keys
-INSERT INTO seed VALUES (123123123);
-
-
-#Create default billing methods (ECML Compliant)
-INSERT INTO billing_method VALUES ('VISA','Visa',1);
-INSERT INTO billing_method VALUES ('MAST','Mastercard',2);
-INSERT INTO billing_method VALUES ('AMER','American Express',3);
-INSERT INTO billing_method VALUES ('DISC','Discover',4);
-
-#Status codes
-INSERT INTO status VALUES (1, 'Created');
-INSERT INTO status VALUES (2, 'Cancelled');
-INSERT INTO status VALUES (3, 'Backordered');
-
-#Fees
-INSERT INTO fee VALUES (1, 'Shipping');
-INSERT INTO fee VALUES (2, 'Gift Wrap');
-INSERT INTO fee VALUES (3, 'Tax');
-INSERT INTO fee VALUES (4, 'Coupon');
-
-#Shipping Methods
-INSERT INTO shipping_method VALUES (1,'Shipping Method One',1);
-INSERT INTO shipping_method VALUES (2,'Shipping Method Two',2);
-
-# All 50 US States plus D.C.
-# Set your own tax rates according to state, local and federal
-# law, as well as nexus.
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AK', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AL', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AZ', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AR', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CO', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CT', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('DE', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('DC', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('FL', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('GA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('HI', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ID', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IL', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IN', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('KS', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('KY', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('LA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ME', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MD', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MI', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MN', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MS', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MO', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MT', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NE', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NV', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NH', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NJ', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NM', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NY', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NC', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ND', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OH', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OK', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OR', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('PA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('RI', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('SC', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('SD', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('TN', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('TX', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('UT', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('VT', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('VA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WV', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WI', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WY', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AA', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AE', 0, 'N');
-INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AP', 0, 'N');
-
-
-#create attribute for gift-wrapping
-INSERT INTO attribute VALUES (1,'Gift Wrap','',1);
-INSERT INTO variation VALUES (1,'Available',1,'This item may be
gift-wrapped.','',1);
-
-#create attribute for non-taxable items
-INSERT INTO attribute VALUES (2, 'Tax', '', 40);
-INSERT INTO variation VALUES(2, 'Not Taxable', 2, 'Not Taxable', '', 40);
-
-#create attribute for free shipping
-INSERT INTO attribute VALUES (3, 'Free Shipping', '', 50);
-INSERT INTO variation VALUES (3, 'Free Shipping', 3, 'Free Shipping', '', 50);
-
-#create permissions
-INSERT INTO permission VALUES (1, 'Login');
-INSERT INTO permission VALUES (2, 'Administrate');
-
-
-/*
-** Create an admin account
-*/
-
-#User
-insert into user values (1, 'admin','admin', 1);
-
-#Address
-insert into address values (1,
- '',
- 'Store',
- '',
- 'Administrator',
- '',
- 'Your Company',
- '123 Main Street',
- '',
- '',
- 'Martinez',
- 'CA',
- '94553',
- 'US',
- '123-123-1234',
- '',
- '',
- '');
-
-#Allow admin to login and use admin screens
-INSERT INTO user_permission VALUES (1, 1);
-INSERT INTO user_permission VALUES (1, 2);
+/*
+** File: build.sql
+** Description: FreeTrade Database Schema
+**
+** Version: $Revision: 1.7 $
+** Created: 07/26/1999
+** Author: Leon Atkinson
+** Email: [EMAIL PROTECTED]
+** CVS Author: $Author: leon $
+** Last Revised: $Date: 2001/06/22 17:58:03 $
+**
+*/
+
+
+/*
+** Global addresses for invoices and users
+*/
+DROP TABLE IF EXISTS address;
+CREATE TABLE address (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name_Prefix CHAR(16),
+ Name_First CHAR(255),
+ Name_Middle CHAR(255),
+ Name_Last CHAR(255) NOT NULL,
+ Name_Suffix CHAR(16),
+ Company CHAR(255),
+ Street1 CHAR(255),
+ Street2 CHAR(255),
+ Street3 CHAR(255),
+ City CHAR(255) NOT NULL,
+ StateProv CHAR(255) NOT NULL,
+ PostalCode CHAR(255) NOT NULL,
+ CountryCode CHAR(2), /* ISO 3166 */
+ Phone1 CHAR(32),
+ Phone2 CHAR(32),
+ Fax CHAR(32),
+ Email CHAR(255) NOT NULL,
+
+ PRIMARY KEY(ID)
+);
+
+
+/*
+** Attributes of SKUs (Color, Size)
+*/
+DROP TABLE IF EXISTS attribute;
+CREATE TABLE attribute (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(64) NOT NULL,
+ Graphic CHAR(255),
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (DisplayPrecedence, Name)
+);
+
+
+/*
+** Types of payment for an invoice (Visa, MasterCard)
+*/
+DROP TABLE IF EXISTS billing;
+CREATE TABLE billing (
+ ID INT NOT NULL AUTO_INCREMENT,
+ ECML CHAR(4),
+ Name CHAR(64) NOT NULL,
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (DisplayPrecedence)
+);
+
+
+/*
+** Discounts on invoices
+*/
+DROP TABLE IF EXISTS coupon;
+CREATE TABLE coupon (
+ ID INT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ Name CHAR(32) NOT NULL,
+ DollarOff DECIMAL(5,2),
+ PercentageOff DECIMAL(5,2),
+ MinAmountPurchased DECIMAL(5,2),
+ StartDate TIMESTAMP(14),
+ EndDate TIMESTAMP(14),
+ NeverExpires ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+ Combineable ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+ DisplayPrecedence INT,
+
+ PRIMARY KEY (ID),
+ INDEX (Name),
+ INDEX (DisplayPrecedence)
+);
+
+/*
+** Tracks when a user uses a coupon to prevent double uses
+** (Denormalized: invoice_coupon)
+*/
+DROP TABLE IF EXISTS coupon_user;
+CREATE TABLE coupon_user (
+ Coupon INT NOT NULL,
+ User INT NOT NULL,
+
+ PRIMARY KEY (Coupon, User),
+
+ FOREIGN KEY (Coupon) REFERENCES coupon (ID),
+ FOREIGN KEY (User) REFERENCES user (ID)
+);
+
+
+/*
+** Hierarchy of product categories
+*/
+DROP TABLE IF EXISTS department;
+CREATE TABLE department (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(64) NOT NULL,
+ Graphic CHAR(255),
+ Parent INT NOT NULL,
+ Description blob,
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Parent),
+ INDEX (DisplayPrecedence, Name),
+
+ FOREIGN KEY (Parent) REFERENCES department (ID)
+);
+
+
+/*
+** Matches items to multiple categories
+*/
+DROP TABLE IF EXISTS department_item;
+CREATE TABLE department_item (
+ Department INT NOT NULL,
+ Item INT NOT NULL,
+
+ PRIMARY KEY(Department, Item),
+
+ FOREIGN KEY (Department) REFERENCES department (ID),
+ FOREIGN KEY (Item) REFERENCES item (ID)
+);
+
+
+/*
+** Types of fees charged to an invoice
+*/
+DROP TABLE IF EXISTS fee;
+CREATE TABLE fee (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(64) NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Name)
+);
+
+
+/*
+** Container for orders placed in the system
+*/
+DROP TABLE IF EXISTS invoice;
+CREATE TABLE invoice (
+ ID INT NOT NULL AUTO_INCREMENT,
+ User INT NOT NULL,
+ Active ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+ Created DATETIME NOT NULL,
+
+ PRIMARY KEY (ID),
+ INDEX (User),
+
+ FOREIGN KEY (User) REFERENCES user (ID)
+);
+
+
+/*
+** Payment information for an invoice
+*/
+DROP TABLE IF EXISTS invoice_billing;
+CREATE TABLE invoice_billing (
+ ID INT NOT NULL AUTO_INCREMENT,
+
+ Invoice INT NOT NULL,
+ Billing INT NOT NULL,
+ Address INT NOT NULL,
+
+ # name on card
+ CreditCardOwner CHAR(64) NOT NULL,
+ CreditCardNumber CHAR(32) NOT NULL,
+ CreditCardExpiration DATETIME NOT NULL,
+
+ # Additional cardholder verification printed on card
+ # but not encoded in magnetic strip. See ECML docs.
+ CreditCardVerification CHAR(4),
+
+ PRIMARY KEY(ID),
+ INDEX (Invoice),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (Address) REFERENCES address (ID),
+ FOREIGN KEY (Billing) REFERENCES billing (ID)
+);
+
+
+/*
+** Coupons applied to an invoice
+** (Denormalized: coupon_user)
+*/
+DROP TABLE IF EXISTS invoice_coupon;
+CREATE TABLE invoice_coupon (
+ Invoice INT NOT NULL,
+ Coupon INT NOT NULL,
+
+ PRIMARY KEY (Invoice, Coupon),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (Coupon) REFERENCES coupon (ID)
+);
+
+
+/*
+** Fees applied to an invoice
+*/
+DROP TABLE IF EXISTS invoice_fee;
+CREATE TABLE invoice_fee (
+ Invoice INT NOT NULL,
+ Fee INT NOT NULL,
+ Value DECIMAL(11,2) NOT NULL,
+
+ INDEX (Invoice),
+ INDEX (Fee),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (Fee) REFERENCES fee (ID)
+);
+
+
+/*
+** Status reports on invoice (Created, Shipped)
+*/
+DROP TABLE IF EXISTS invoice_status;
+CREATE TABLE invoice_status (
+ ID INT NOT NULL AUTO_INCREMENT,
+
+ Invoice INT NOT NULL,
+ Status INT NOT NULL,
+ Created DATETIME NOT NULL,
+ Description CHAR(255),
+
+ PRIMARY KEY(ID),
+ INDEX (Invoice),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (Status) REFERENCES status (ID)
+);
+
+
+/*
+** Shipping destinations for an invoice
+*/
+DROP TABLE IF EXISTS invoice_shipping;
+CREATE TABLE invoice_shipping (
+ ID INT NOT NULL AUTO_INCREMENT,
+
+ Invoice INT NOT NULL,
+ Address INT NOT NULL,
+ Shipping INT NOT NULL,
+ Message CHAR(255),
+
+ PRIMARY KEY(ID),
+ INDEX (Invoice),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (Address) REFERENCES address (ID),
+ FOREIGN KEY (Shipping) REFERENCES shipping (ID)
+);
+
+
+/*
+** Line items (SKUs on an Invoice)
+*/
+DROP TABLE IF EXISTS invoice_sku;
+CREATE TABLE invoice_sku (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Invoice INT NOT NULL,
+ SKU INT NOT NULL,
+ Quantity INT NOT NULL,
+ ExternalSKU CHAR(64) NOT NULL,
+ Name CHAR(64) NOT NULL,
+ ListPrice DECIMAL(11,2) NOT NULL,
+ SalePrice DECIMAL(11,2) NOT NULL,
+ Freight DECIMAL(11,2) NOT NULL,
+ Shipping INT NOT NULL,
+ GiftWrap char(1) NOT NULL DEFAULT 'N',
+
+ PRIMARY KEY(ID),
+ INDEX (Invoice),
+ INDEX (SKU),
+ INDEX (ExternalSKU),
+
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID),
+ FOREIGN KEY (SKU) REFERENCES sku (ID)
+);
+
+
+/*
+** Variations applied to line items
+*/
+DROP TABLE IF EXISTS invoice_sku_variation;
+CREATE TABLE invoice_sku_variation (
+ InvoiceSKU INT NOT NULL,
+ Variation INT NOT NULL,
+ Qualifier CHAR(255),
+
+ PRIMARY KEY(InvoiceSKU, Variation)
+);
+
+
+/*
+** Items in the catalog, which have one or more SKUs
+*/
+DROP TABLE IF EXISTS item;
+CREATE TABLE item (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(64) NOT NULL,
+ Description BLOB,
+ Keywords VARCHAR(255),
+ Thumbnail VARCHAR(255),
+ Graphic VARCHAR(255),
+ LargeGraphic VARCHAR(255),
+ DisplayPrecedence INT,
+ Active ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+
+ PRIMARY KEY(ID),
+ INDEX (Name),
+ INDEX (Active)
+);
+
+
+/*
+** Arbitrary relationships between items for cross-selling
+*/
+DROP TABLE IF EXISTS item_item;
+CREATE TABLE item_item (
+ Item INT NOT NULL,
+ Related_Item INT NOT NULL,
+ Relationship INT NOT NULL,
+
+ PRIMARY KEY (Item, Related_Item, Relationship),
+ FOREIGN KEY (Item) REFERENCES item (ID),
+ FOREIGN KEY (Related_Item) REFERENCES item (ID),
+ FOREIGN KEY (Relationship) REFERENCES relationship (ID)
+);
+
+
+/*
+** Rights available in the system
+*/
+DROP TABLE IF EXISTS permission;
+CREATE TABLE permission
+(
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(255) NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Name)
+);
+
+
+/*
+** Types of relationships between items
+*/
+DROP TABLE IF EXISTS relationship;
+CREATE TABLE relationship (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(255) NOT NULL,
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (DisplayPrecedence, Name)
+);
+
+
+/*
+** Stores seed for random number generator
+*/
+DROP TABLE IF EXISTS seed;
+CREATE TABLE seed (
+ seed INT NOT NULL DEFAULT 314
+);
+
+
+/*
+** User sessions
+*/
+DROP TABLE IF EXISTS session;
+CREATE TABLE session
+(
+ ID CHAR(16) NOT NULL,
+ User INT,
+ LastAction DATETIME,
+ Invoice INT,
+
+ PRIMARY KEY(ID),
+ INDEX (User),
+ INDEX (Invoice),
+
+ FOREIGN KEY (User) REFERENCES user (ID),
+ FOREIGN KEY (Invoice) REFERENCES invoice (ID)
+);
+
+
+/*
+** Baskets (SKUs for session)
+*/
+DROP TABLE IF EXISTS session_sku;
+CREATE TABLE session_sku (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Session CHAR(24) NOT NULL,
+ SKU INT NOT NULL,
+ Quantity INT NOT NULL,
+ Notes blob,
+
+ PRIMARY KEY(ID),
+ INDEX (Session),
+ INDEX (SKU),
+
+ FOREIGN KEY (Session) REFERENCES session (ID),
+ FOREIGN KEY (SKU) REFERENCES sku (ID)
+);
+
+
+/*
+** Variations on basket items
+*/
+DROP TABLE IF EXISTS session_sku_variation;
+CREATE TABLE session_sku_variation (
+ SessionSKU INT NOT NULL,
+ Variation INT NOT NULL,
+ Qualifier CHAR(255),
+
+ PRIMARY KEY(SessionSKU, Variation)
+);
+
+
+/*
+** Types of shipping (UPS, FedEx)
+*/
+DROP TABLE IF EXISTS shipping;
+CREATE TABLE shipping (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(255) NOT NULL,
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (DisplayPrecedence, Name)
+);
+
+
+/*
+** Things that you can buy, grouped by 'item'
+*/
+DROP TABLE IF EXISTS sku;
+CREATE TABLE sku (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Item INT NOT NULL,
+ ExternalSKU CHAR(64) NOT NULL,
+ Name CHAR(64) NOT NULL,
+ ListPrice DECIMAL(11,2) NOT NULL,
+ SalePrice DECIMAL(11,2) NOT NULL,
+ AdditionalShipping DECIMAL(11,2) NOT NULL,
+ DisplayPrecedence INT NOT NULL,
+ Active ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+ InventoryAvailable INT NOT NULL,
+ CanBackorder ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+
+ PRIMARY KEY(ID),
+ INDEX (Item),
+ INDEX (ExternalSKU),
+ INDEX (DisplayPrecedence, Name),
+
+ FOREIGN KEY (Item) REFERENCES item (ID)
+);
+
+
+/*
+** Variations on SKUs
+*/
+DROP TABLE IF EXISTS sku_variation;
+CREATE TABLE sku_variation (
+ SKU INT NOT NULL,
+ Variation INT NOT NULL,
+
+ PRIMARY KEY (SKU, Variation),
+
+ FOREIGN KEY (SKU) REFERENCES sku (ID),
+ FOREIGN KEY (Variation) REFERENCES variation (ID)
+);
+
+
+/*
+** Types of status messages for invoices
+*/
+DROP TABLE IF EXISTS status;
+CREATE TABLE status (
+ ID INT NOT NULL AUTO_INCREMENT,
+
+ Name CHAR(64) NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Name)
+);
+
+
+/*
+** Sales tax rates for US States
+*/
+DROP TABLE IF EXISTS tax;
+CREATE TABLE tax (
+ State CHAR(2) NOT NULL,
+ Rate DECIMAL(4,5) NOT NULL,
+ TaxShipping ENUM('N', 'Y') NOT NULL DEFAULT 'N',
+
+ PRIMARY KEY(State)
+);
+
+
+/*
+** Customers and system administrators
+*/
+DROP TABLE IF EXISTS user;
+CREATE TABLE user (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Login CHAR(32) NOT NULL,
+ Password CHAR(32) NOT NULL,
+ Address INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Login),
+ INDEX (Address),
+
+ FOREIGN KEY (Address) REFERENCES address (ID)
+);
+
+
+/*
+** Permissions for users (login, admin)
+*/
+DROP TABLE IF EXISTS user_permission;
+CREATE TABLE user_permission
+(
+ User INT NOT NULL,
+ Permission INT NOT NULL,
+
+ PRIMARY KEY (User, Permission),
+
+ FOREIGN KEY (User) REFERENCES user (ID),
+ FOREIGN KEY (Permission) REFERENCES permission (ID)
+);
+
+
+/*
+** Wish list (SKUs for a user)
+*/
+DROP TABLE IF EXISTS user_sku;
+CREATE TABLE user_sku (
+ ID INT NOT NULL AUTO_INCREMENT,
+ User INT NOT NULL,
+ SKU INT NOT NULL,
+ Quantity INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (User),
+ INDEX (SKU),
+
+ FOREIGN KEY (User) REFERENCES user (ID),
+ FOREIGN KEY (SKU) REFERENCES sku (ID)
+);
+
+
+/*
+** Variations chosen for basket items
+*/
+DROP TABLE IF EXISTS user_sku_variation;
+CREATE TABLE user_sku_variation (
+ UserSKU INT NOT NULL,
+ Variation INT NOT NULL,
+ Qualifier CHAR(255),
+
+ PRIMARY KEY(UserSKU, Variation)
+);
+
+
+/*
+** Choices under an attribute (S,M,L for Size)
+*/
+DROP TABLE IF EXISTS variation;
+CREATE TABLE variation (
+ ID INT NOT NULL AUTO_INCREMENT,
+ Name CHAR(64) NOT NULL,
+ Attribute INT NOT NULL,
+ Description CHAR(64),
+ Graphic CHAR(255),
+ DisplayPrecedence INT NOT NULL,
+
+ PRIMARY KEY(ID),
+ INDEX (Attribute),
+ INDEX (DisplayPrecedence, Name),
+
+ FOREIGN KEY (Attribute) REFERENCES attribute (ID)
+);
+
+
+
+/*
+** Insert minimal rows to make the application work
+**
+*/
+
+#starting seed used for unique session keys
+INSERT INTO seed VALUES (123123123);
+
+
+#Create default billing methods (ECML Compliant)
+INSERT INTO billing VALUES (NULL, 'VISA','Visa',1);
+INSERT INTO billing VALUES (NULL, 'MAST','Mastercard',2);
+INSERT INTO billing VALUES (NULL, 'AMER','American Express',3);
+INSERT INTO billing VALUES (NULL, 'DISC','Discover',4);
+
+#Status codes
+INSERT INTO status VALUES (1, 'Created');
+INSERT INTO status VALUES (2, 'Cancelled');
+INSERT INTO status VALUES (3, 'Backordered');
+
+#Fees
+INSERT INTO fee VALUES (1, 'Shipping');
+INSERT INTO fee VALUES (2, 'Gift Wrap');
+INSERT INTO fee VALUES (3, 'Tax');
+INSERT INTO fee VALUES (4, 'Coupon');
+
+#Shipping Methods
+INSERT INTO shipping VALUES (1,'Shipping Method One',1);
+INSERT INTO shipping VALUES (2,'Shipping Method Two',2);
+
+# All 50 US States plus D.C.
+# Set your own tax rates according to state, local and federal
+# law, as well as nexus.
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AK', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AL', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AZ', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AR', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CO', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('CT', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('DE', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('DC', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('FL', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('GA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('HI', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ID', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IL', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('IN', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('KS', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('KY', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('LA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ME', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MD', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MI', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MN', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MS', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MO', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('MT', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NE', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NV', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NH', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NJ', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NM', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NY', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('NC', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('ND', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OH', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OK', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('OR', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('PA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('RI', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('SC', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('SD', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('TN', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('TX', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('UT', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('VT', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('VA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WV', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WI', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('WY', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AA', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AE', 0, 'N');
+INSERT INTO tax (State, Rate, TaxShipping) VALUES ('AP', 0, 'N');
+
+
+#create attribute for gift-wrapping
+INSERT INTO attribute VALUES (1,'Gift Wrap','',1);
+INSERT INTO variation VALUES (1,'Available',1,'This item may be
gift-wrapped.','',1);
+
+#create attribute for non-taxable items
+INSERT INTO attribute VALUES (2, 'Tax', '', 40);
+INSERT INTO variation VALUES(2, 'Not Taxable', 2, 'Not Taxable', '', 40);
+
+#create attribute for free shipping
+INSERT INTO attribute VALUES (3, 'Free Shipping', '', 50);
+INSERT INTO variation VALUES (3, 'Free Shipping', 3, 'Free Shipping', '', 50);
+
+#create permissions
+INSERT INTO permission VALUES (1, 'Login');
+INSERT INTO permission VALUES (2, 'Administrate');
+
+
+/*
+** Create an admin account
+*/
+
+#User
+insert into user values (1, 'admin','admin', 1);
+
+#Address
+insert into address values (1,
+ '',
+ 'Store',
+ '',
+ 'Administrator',
+ '',
+ 'Your Company',
+ '123 Main Street',
+ '',
+ '',
+ 'Martinez',
+ 'CA',
+ '94553',
+ 'US',
+ '123-123-1234',
+ '',
+ '',
+ '');
+
+#Allow admin to login and use admin screens
+INSERT INTO user_permission VALUES (1, 1);
+INSERT INTO user_permission VALUES (1, 2);
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
