PostGreSQL adaption

Below is the translation of the store.mysql file into store.postgres

Please add it.

CREATE TABLE ec_cart (
cookie_id VARCHAR(32) NOT NULL DEFAULT '0',
nid INTEGER NOT NULL DEFAULT 0,
qty INTEGER NOT NULL DEFAULT 0,
changed INTEGER NOT NULL DEFAULT 0,
data TEXT
);

CREATE INDEX ec_cart_cookie_id ON ec_cart (cookie_id);

CREATE TABLE ec_payment_adjust (
rid INTEGER NOT NULL DEFAULT 0,
operator CHAR(1) NOT NULL DEFAULT '+',
operand DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
CONSTRAINT ec_payment_adjust_pk PRIMARY KEY (rid),
CHECK (rid>=0),
CHECK (operand>=0)
);

CREATE TABLE ec_payment_status (
pid SERIAL,
name VARCHAR(32) NOT NULL DEFAULT '',
CONSTRAINT ec_payment_status_pk PRIMARY KEY (pid),
CHECK (pid>=0)
);

INSERT INTO ec_payment_status VALUES(1,'pending');

INSERT INTO ec_payment_status VALUES(2,'completed');

INSERT INTO ec_payment_status VALUES(3,'failed');

INSERT INTO ec_payment_status VALUES(4,'denied');

INSERT INTO ec_payment_status VALUES(5,'refunded');

INSERT INTO ec_payment_status VALUES(6,'canceled');

CREATE TABLE ec_paypal (
txnid INTEGER NOT NULL DEFAULT 0,
ppid VARCHAR(30) NOT NULL DEFAULT '0',
fee DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
CONSTRAINT ec_paypal_pk PRIMARY KEY (ppid)
);

CREATE TABLE ec_product (
nid INTEGER NOT NULL DEFAULT 0,
sku VARCHAR(75) DEFAULT NULL,
price DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
is_recurring SMALLINT NOT NULL DEFAULT 0,
price_interval SMALLINT NOT NULL DEFAULT 0,
price_unit VARCHAR(5) NOT NULL DEFAULT '',
price_cycle INTEGER NOT NULL DEFAULT 0,
auto_charge SMALLINT NOT NULL DEFAULT 0,
ptype VARCHAR(75) NOT NULL DEFAULT '',
hide_cart_link INTEGER NOT NULL DEFAULT 0,
CHECK (nid>=0),
CHECK (is_recurring>=0),
CHECK (price_interval>=0),
CHECK (auto_charge>=0),
CHECK (hide_cart_link>=0)
);

CREATE UNIQUE INDEX ec_product_KEY ON ec_product (nid);

CREATE TABLE ec_product_availability (
aid SERIAL,
message VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT ec_product_availability_pk PRIMARY KEY (aid)
);

INSERT INTO ec_product_availability VALUES(1,'--none--');

INSERT INTO ec_product_availability VALUES(2,'Usually ships in 24 hours.');

INSERT INTO ec_product_availability VALUES(3,'Usually ships in 2-3 days.');

INSERT INTO ec_product_availability VALUES(4,'Usually ships in 1-2 weeks.');

INSERT INTO ec_product_availability VALUES(5,'Usually ships in 4-6 weeks.');

CREATE TABLE ec_product_file (
nid INTEGER NOT NULL DEFAULT 0,
fpath VARCHAR(128) NOT NULL DEFAULT '',
size INTEGER NOT NULL DEFAULT 0,
CHECK (nid>=0)
);

CREATE UNIQUE INDEX ec_product_file_KEY ON ec_product_file (nid);

CREATE TABLE ec_product_parcel (
nid INTEGER NOT NULL DEFAULT 0,
mnid INTEGER NOT NULL DEFAULT 0,
CHECK (nid>=0),
CHECK (mnid>=0)
);

CREATE UNIQUE INDEX ec_product_parcel_KEY ON ec_product_parcel (nid);

CREATE TABLE ec_product_tangible (
nid INTEGER NOT NULL DEFAULT 0,
stock INTEGER NOT NULL DEFAULT 0,
manage_stock INTEGER NOT NULL DEFAULT 0,
availability INTEGER NOT NULL DEFAULT 0,
CHECK (nid>=0),
CHECK (manage_stock>=0)
);

CREATE UNIQUE INDEX ec_product_tangible_KEY ON ec_product_tangible (nid);

CREATE TABLE ec_renewal (
txnid INTEGER NOT NULL DEFAULT 0,
rtxnid INTEGER NOT NULL DEFAULT 0,
rnid INTEGER NOT NULL DEFAULT 0,
CHECK (txnid>=0),
CHECK (rtxnid>=0),
CHECK (rnid>=0)
);

CREATE INDEX ec_renewal_txnid_x1 ON ec_renewal (txnid);

CREATE TABLE ec_shipping_shipping (
item_slot VARCHAR(25) NOT NULL DEFAULT '0',
price_slot VARCHAR(25) NOT NULL DEFAULT '0'
);

CREATE INDEX ec_shipping_shipping_item_slot ON ec_shipping_shipping (item_slot);

CREATE INDEX ec_shipping_shipping_priceslot ON ec_shipping_shipping (price_slot);

INSERT INTO ec_shipping_shipping VALUES('1','0.00');

INSERT INTO ec_shipping_shipping VALUES('2-4','0.00');

INSERT INTO ec_shipping_shipping VALUES('5','0.00');

INSERT INTO ec_shipping_shipping VALUES('6-11','0.00');

INSERT INTO ec_shipping_shipping VALUES('11-1100','0.00');

CREATE TABLE ec_subtotal_shipping (
item_slot VARCHAR(25) NOT NULL DEFAULT '0',
price_slot VARCHAR(25) NOT NULL DEFAULT '0'
);

CREATE INDEX ec_subtotal_shipping_item_slot ON ec_subtotal_shipping (item_slot);

CREATE INDEX ec_subtotal_shipping_priceslot ON ec_subtotal_shipping (price_slot);

INSERT INTO ec_subtotal_shipping VALUES('0-0.99','0.00');

INSERT INTO ec_subtotal_shipping VALUES('1.00-11.99','0.00');

INSERT INTO ec_subtotal_shipping VALUES('11.00-50.00','0.00');

INSERT INTO ec_subtotal_shipping VALUES('50.00-11000','0.00');

CREATE TABLE ec_per_product_shipping (
nid INTEGER NOT NULL DEFAULT 0,
shipping_fee DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
CONSTRAINT ec_per_product_shipping_pk PRIMARY KEY (nid),
CHECK (nid>=0),
CHECK (shipping_fee>=0)
);

CREATE TABLE ec_transaction (
txnid INTEGER NOT NULL DEFAULT 0,
uid INTEGER NOT NULL DEFAULT 0,
mail VARCHAR(64) NOT NULL DEFAULT '',
shipping_firstname VARCHAR(32) NOT NULL DEFAULT '',
shipping_lastname VARCHAR(32) NOT NULL DEFAULT '',
shipping_street1 VARCHAR(64) NOT NULL DEFAULT '',
shipping_street2 VARCHAR(64) NOT NULL DEFAULT '',
shipping_zip VARCHAR(11) NOT NULL DEFAULT '',
shipping_city VARCHAR(32) NOT NULL DEFAULT '',
shipping_state VARCHAR(32) NOT NULL DEFAULT '',
shipping_cost DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
shipping_country VARCHAR(2) NOT NULL DEFAULT '',
billing_firstname VARCHAR(32) NOT NULL DEFAULT '',
billing_lastname VARCHAR(32) NOT NULL DEFAULT '',
billing_street1 VARCHAR(64) NOT NULL DEFAULT '',
billing_street2 VARCHAR(64) NOT NULL DEFAULT '',
billing_zip VARCHAR(11) NOT NULL DEFAULT '',
billing_city VARCHAR(32) NOT NULL DEFAULT '',
billing_state VARCHAR(32) NOT NULL DEFAULT '',
billing_country VARCHAR(2) NOT NULL DEFAULT '',
payment_method VARCHAR(32) NOT NULL DEFAULT '',
payment_status VARCHAR(32) NOT NULL DEFAULT '1',
coupon INTEGER NOT NULL DEFAULT 0,
workflow INTEGER NOT NULL DEFAULT 1,
gross DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
expires INTEGER NOT NULL DEFAULT 0,
created INTEGER NOT NULL DEFAULT 0,
changed INTEGER NOT NULL DEFAULT 0,
CONSTRAINT ec_transaction_pk PRIMARY KEY (txnid),
CHECK (txnid>=0),
CHECK (uid>=0),
CHECK (coupon>=0),
CHECK (workflow>=0)
);

CREATE TABLE ec_transaction_product (
txnid INTEGER NOT NULL DEFAULT 0,
nid INTEGER NOT NULL DEFAULT 0,
title VARCHAR(128) DEFAULT NULL,
price DECIMAL(11, 2) NOT NULL DEFAULT 0.00,
qty INTEGER NOT NULL DEFAULT 0,
expires INTEGER NOT NULL DEFAULT 0,
data TEXT,
is_recurring SMALLINT NOT NULL DEFAULT 0,
price_interval SMALLINT NOT NULL DEFAULT 0,
price_unit VARCHAR(5) NOT NULL DEFAULT '',
price_cycle INTEGER NOT NULL DEFAULT 0,
auto_charge SMALLINT NOT NULL DEFAULT 0,
last_notify INTEGER NOT NULL DEFAULT 0,
CHECK (txnid>=0),
CHECK (nid>=0),
CHECK (qty>=0),
CHECK (expires>=0),
CHECK (is_recurring>=0),
CHECK (price_interval>=0),
CHECK (auto_charge>=0),
CHECK (last_notify>=0)
);

CREATE UNIQUE INDEX ec_transaction_product_KEY ON ec_transaction_product (txnid);

CREATE TABLE ec_transaction_workflow (
wid SERIAL,
name VARCHAR(32) NOT NULL DEFAULT '',
CONSTRAINT ec_transaction_workflow_pk PRIMARY KEY (wid),
CHECK (wid>=0)
);

INSERT INTO ec_transaction_workflow VALUES(1,'transaction received');

INSERT INTO ec_transaction_workflow VALUES(2,'invoiced');

INSERT INTO ec_transaction_workflow VALUES(3,'shipped');

INSERT INTO ec_transaction_workflow VALUES(4,'awaiting customer response');

INSERT INTO ec_transaction_workflow VALUES(5,'canceled');

INSERT INTO ec_transaction_workflow VALUES(6,'completed');