mirror of
https://github.com/kennethreitz-archive/shopp.git
synced 2026-06-05 23:40:16 +00:00
Kenneth Reitz
329 lines
13 KiB
SQL
329 lines
13 KiB
SQL
<?php $setting = DatabaseObject::tablename('setting'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $setting; ?>;
|
|
CREATE TABLE <?php echo $setting; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
name varchar(255) NOT NULL default '',
|
|
value longtext NOT NULL,
|
|
autoload enum('on','off') NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $product = DatabaseObject::tablename('product'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $product; ?>;
|
|
CREATE TABLE <?php echo $product; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
name varchar(255) NOT NULL default '',
|
|
slug varchar(255) NOT NULL default '',
|
|
summary text NOT NULL,
|
|
description longtext NOT NULL,
|
|
published enum('on','off') NOT NULL,
|
|
featured enum('off','on') NOT NULL,
|
|
variations enum('off','on') NOT NULL,
|
|
options text NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY published (published),
|
|
KEY featured (featured),
|
|
KEY slug (slug),
|
|
FULLTEXT search (name,summary,description)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $price = DatabaseObject::tablename('price'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $price; ?>;
|
|
CREATE TABLE <?php echo $price; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
product bigint(20) unsigned NOT NULL default '0',
|
|
options text NOT NULL,
|
|
optionkey bigint(20) unsigned NOT NULL default '0',
|
|
label varchar(100) NOT NULL default '',
|
|
context enum('product','variation','addon') NOT NULL,
|
|
type enum('Shipped','Virtual','Download','Donation','N/A') NOT NULL,
|
|
sku varchar(100) NOT NULL default '',
|
|
price float(20,2) NOT NULL default '0.00',
|
|
saleprice float(20,2) NOT NULL default '0.00',
|
|
weight float(20,3) NOT NULL default '0',
|
|
shipfee float(20,2) NOT NULL default '0',
|
|
stock int(10) NOT NULL default '0',
|
|
inventory enum('off','on') NOT NULL,
|
|
sale enum('off','on') NOT NULL,
|
|
shipping enum('on','off') NOT NULL,
|
|
tax enum('on','off') NOT NULL,
|
|
donation varchar(255) NOT NULL default '',
|
|
sortorder int(10) unsigned NOT NULL default '0',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY product (product),
|
|
KEY catalog (product,type,inventory,stock),
|
|
KEY context (context)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $spec = DatabaseObject::tablename('spec'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $spec; ?>;
|
|
CREATE TABLE <?php echo $spec; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
product bigint(20) unsigned NOT NULL default '0',
|
|
name varchar(255) NOT NULL default '',
|
|
content text NOT NULL,
|
|
numeral float(20,4) NOT NULL default '0.0000',
|
|
sortorder int(10) unsigned NOT NULL default '0',
|
|
PRIMARY KEY id (id),
|
|
KEY product (product,name),
|
|
FULLTEXT name (name,content)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $category = DatabaseObject::tablename('category'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $category; ?>;
|
|
CREATE TABLE <?php echo $category; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
parent bigint(20) unsigned NOT NULL default '0',
|
|
name varchar(255) NOT NULL default '',
|
|
slug varchar(64) NOT NULL default '',
|
|
uri varchar(255) NOT NULL default '',
|
|
description text NOT NULL,
|
|
spectemplate enum('off','on') NOT NULL,
|
|
facetedmenus enum('off','on') NOT NULL,
|
|
variations enum('off','on') NOT NULL,
|
|
pricerange enum('disabled','auto','custom') NOT NULL,
|
|
priceranges text NOT NULL,
|
|
specs text NOT NULL,
|
|
options text NOT NULL,
|
|
prices text NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY parent (parent)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $tag = DatabaseObject::tablename('tag'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $tag; ?>;
|
|
CREATE TABLE <?php echo $tag; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
name varchar(255) NOT NULL default '',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $catalog = DatabaseObject::tablename('catalog'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $catalog; ?>;
|
|
CREATE TABLE <?php echo $catalog; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
product bigint(20) unsigned NOT NULL default '0',
|
|
category bigint(20) unsigned NOT NULL default '0',
|
|
tag bigint(20) unsigned NOT NULL default '0',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY product (product),
|
|
KEY category (category),
|
|
KEY tag (tag)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $asset = DatabaseObject::tablename('asset'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $asset; ?>;
|
|
CREATE TABLE <?php echo $asset; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
parent bigint(20) unsigned NOT NULL default '0',
|
|
context enum('product','price','category') NOT NULL default 'product',
|
|
src bigint(20) unsigned NOT NULL default '0',
|
|
name varchar(255) NOT NULL default '',
|
|
value varchar(255) NOT NULL default '',
|
|
properties text NOT NULL,
|
|
size bigint(20) unsigned NOT NULL default '0',
|
|
data longblob NOT NULL,
|
|
datatype enum('metadata','image','small','thumbnail','download') NOT NULL default 'metadata',
|
|
sortorder int(10) unsigned NOT NULL default '0',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY parent (parent,context),
|
|
KEY src (src)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $cart = DatabaseObject::tablename('cart'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $cart; ?>;
|
|
CREATE TABLE <?php echo $cart; ?> (
|
|
session varchar(32) NOT NULL,
|
|
customer bigint(20) unsigned NOT NULL default '0',
|
|
ip varchar(15) NOT NULL default '0.0.0.0',
|
|
data longtext NOT NULL,
|
|
contents longtext NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY session (session),
|
|
KEY customer (customer)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $customer = DatabaseObject::tablename('customer'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $customer; ?>;
|
|
CREATE TABLE <?php echo $customer; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
wpuser bigint(20) unsigned NOT NULL default '0',
|
|
password varchar(64) NOT NULL default '',
|
|
firstname varchar(32) NOT NULL default '',
|
|
lastname varchar(32) NOT NULL default '',
|
|
email varchar(96) NOT NULL default '',
|
|
phone varchar(24) NOT NULL default '',
|
|
company varchar(100) NOT NULL default '',
|
|
activation varchar(20) NOT NULL default '',
|
|
info longtext NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $shipping = DatabaseObject::tablename('shipping'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $shipping; ?>;
|
|
CREATE TABLE <?php echo $shipping; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
customer bigint(20) unsigned NOT NULL default '0',
|
|
address varchar(100) NOT NULL default '',
|
|
xaddress varchar(100) NOT NULL default '',
|
|
city varchar(100) NOT NULL default '',
|
|
state varchar(2) NOT NULL default '',
|
|
country varchar(2) NOT NULL default '',
|
|
postcode varchar(10) NOT NULL default '',
|
|
geocode varchar(16) NOT NULL default '',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY customer (customer)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $billing = DatabaseObject::tablename('billing'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $billing; ?>;
|
|
CREATE TABLE <?php echo $billing; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
customer bigint(20) unsigned NOT NULL default '0',
|
|
card varchar(4) NOT NULL default '',
|
|
cardtype varchar(32) NOT NULL default '',
|
|
cardexpires date NOT NULL default '0000-00-00',
|
|
cardholder varchar(96) NOT NULL default '',
|
|
address varchar(100) NOT NULL default '',
|
|
xaddress varchar(100) NOT NULL default '',
|
|
city varchar(100) NOT NULL default '',
|
|
state varchar(2) NOT NULL default '',
|
|
country varchar(2) NOT NULL default '',
|
|
postcode varchar(10) NOT NULL default '',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY customer (customer)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $purchase = DatabaseObject::tablename('purchase'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $purchase; ?>;
|
|
CREATE TABLE <?php echo $purchase; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
customer bigint(20) unsigned NOT NULL default '0',
|
|
shipping bigint(20) unsigned NOT NULL default '0',
|
|
billing bigint(20) unsigned NOT NULL default '0',
|
|
currency bigint(20) unsigned NOT NULL default '0',
|
|
ip varchar(15) NOT NULL default '0.0.0.0',
|
|
firstname varchar(32) NOT NULL default '',
|
|
lastname varchar(32) NOT NULL default '',
|
|
email varchar(96) NOT NULL default '',
|
|
phone varchar(24) NOT NULL default '',
|
|
company varchar(100) NOT NULL default '',
|
|
card varchar(4) NOT NULL default '',
|
|
cardtype varchar(32) NOT NULL default '',
|
|
cardexpires date NOT NULL default '0000-00-00',
|
|
cardholder varchar(96) NOT NULL default '',
|
|
address varchar(100) NOT NULL default '',
|
|
xaddress varchar(100) NOT NULL default '',
|
|
city varchar(100) NOT NULL default '',
|
|
state varchar(100) NOT NULL default '',
|
|
country varchar(2) NOT NULL default '',
|
|
postcode varchar(10) NOT NULL default '',
|
|
shipaddress varchar(100) NOT NULL default '',
|
|
shipxaddress varchar(100) NOT NULL default '',
|
|
shipcity varchar(100) NOT NULL default '',
|
|
shipstate varchar(100) NOT NULL default '',
|
|
shipcountry varchar(2) NOT NULL default '',
|
|
shippostcode varchar(10) NOT NULL default '',
|
|
geocode varchar(16) NOT NULL default '',
|
|
promos varchar(255) NOT NULL default '',
|
|
subtotal float(20,2) NOT NULL default '0.00',
|
|
freight float(20,2) NOT NULL default '0.00',
|
|
tax float(20,2) NOT NULL default '0.00',
|
|
total float(20,2) NOT NULL default '0.00',
|
|
discount float(20,2) NOT NULL default '0.00',
|
|
fees float(20,2) NOT NULL default '0.00',
|
|
transactionid varchar(64) NOT NULL default '',
|
|
transtatus varchar(64) NOT NULL default '',
|
|
gateway varchar(64) NOT NULL default '',
|
|
shipmethod varchar(100) NOT NULL default '',
|
|
shiptrack varchar(100) NOT NULL default '',
|
|
status tinyint(3) unsigned NOT NULL default '0',
|
|
data longtext NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY customer (customer)
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $purchased = DatabaseObject::tablename('purchased'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $purchased; ?>;
|
|
CREATE TABLE <?php echo $purchased; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
purchase bigint(20) unsigned NOT NULL default '0',
|
|
product bigint(20) unsigned NOT NULL default '0',
|
|
price bigint(20) unsigned NOT NULL default '0',
|
|
download bigint(20) unsigned NOT NULL default '0',
|
|
dkey varchar(255) NOT NULL default '',
|
|
name varchar(255) NOT NULL default '',
|
|
description text NOT NULL,
|
|
optionlabel varchar(255) NOT NULL default '',
|
|
sku varchar(100) NOT NULL default '',
|
|
quantity int(10) unsigned NOT NULL default '0',
|
|
downloads int(10) unsigned NOT NULL default '0',
|
|
unitprice float(20,2) NOT NULL default '0.00',
|
|
shipping float(20,2) NOT NULL default '0.00',
|
|
total float(20,2) NOT NULL default '0.00',
|
|
variation text NOT NULL,
|
|
data longtext NOT NULL,
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id),
|
|
KEY purchase (purchase),
|
|
KEY product (product),
|
|
KEY dkey (dkey(8))
|
|
) ENGINE=MyIsAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $promo = DatabaseObject::tablename('promo'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $promo; ?>;
|
|
CREATE TABLE <?php echo $promo; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
name varchar(255) NOT NULL default '',
|
|
status enum('disabled','enabled') default 'disabled',
|
|
type enum('Percentage Off','Amount Off','Free Shipping','Buy X Get Y Free') default 'Percentage Off',
|
|
scope enum('Catalog','Order') default 'Catalog',
|
|
discount float(20,2) NOT NULL default '0.00',
|
|
buyqty int(10) NOT NULL default '0',
|
|
getqty int(10) NOT NULL default '0',
|
|
search enum('all','any') default 'all',
|
|
code varchar(255) NOT NULL default '',
|
|
rules text NOT NULL,
|
|
starts datetime NOT NULL default '0000-00-00 00:00:00',
|
|
ends datetime NOT NULL default '0000-00-00 00:00:00',
|
|
created datetime NOT NULL default '0000-00-00 00:00:00',
|
|
modified datetime NOT NULL default '0000-00-00 00:00:00',
|
|
PRIMARY KEY id (id)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|
|
<?php $discount = DatabaseObject::tablename('discount'); ?>
|
|
DROP TABLE IF EXISTS <?php echo $discount; ?>;
|
|
CREATE TABLE <?php echo $discount; ?> (
|
|
id bigint(20) unsigned NOT NULL auto_increment,
|
|
promo bigint(20) unsigned NOT NULL default '0',
|
|
product bigint(20) unsigned NOT NULL default '0',
|
|
price bigint(20) unsigned NOT NULL default '0',
|
|
PRIMARY KEY id (id),
|
|
KEY lookup (product,price)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
|