leon 01/06/22 10:33:40
Modified: freetrade2/install/mysql build.sql
Added: freetrade2/install/mysql newbuild.sql
Log:
Future replacement for build.sql (yes, this is messy)
Revision Changes Path
1.6 +6 -3 freetrade/freetrade2/install/mysql/build.sql
Index: build.sql
===================================================================
RCS file: /home/cvs/freetrade/freetrade2/install/mysql/build.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- build.sql 2001/03/23 18:11:09 1.5
+++ build.sql 2001/06/22 17:33:40 1.6
@@ -2,14 +2,17 @@
** File: build.sql
** Description: FreeTrade Database Schema
**
-** Version: $Revision: 1.5 $
+** Version: $Revision: 1.6 $
** Created: 07/26/1999
** Author: Leon Atkinson
** Email: [EMAIL PROTECTED]
** CVS Author: $Author: leon $
-** Last Revised: $Date: 2001/03/23 18:11:09 $
+** 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 :
@@ -20,7 +23,7 @@
** Log : Cleaning it up a bit, adding indexes and foreign keys
** Log :
**
-** Copyright (c) 1999 Working Dogs. All rights reserved.
+** Copyright (c) 1999-2001 Whichever Group. All rights reserved.
*/
DROP TABLE IF EXISTS attribute;
1.1 freetrade/freetrade2/install/mysql/newbuild.sql
Index: newbuild.sql
===================================================================
/*
** File: build.sql
** Description: FreeTrade Database Schema
**
** Version: $Revision: 1.1 $
** Created: 07/26/1999
** Author: Leon Atkinson
** Email: [EMAIL PROTECTED]
** CVS Author: $Author: leon $
** Last Revised: $Date: 2001/06/22 17:33:40 $
**
*/
/*
** 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 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_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);
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
