Code: Select all
CREATE TABLE cart (
orderid int(25) NOT NULL auto_increment,
userid int(25) NOT NULL default '0',
total decimal(11,2) NOT NULL default '0.00',
orderdate datetime NOT NULL default '0000-00-00 00:00:00',
approved varchar(5) NOT NULL default '',
PRIMARY KEY (orderid)
) TYPE=MyISAM;
INSERT INTO cart (orderid, userid, total, orderdate, approved) VALUES (1,1,'345.00','2006-01-08 01:17:33','No');
INSERT INTO cart (orderid, userid, total, orderdate, approved) VALUES (2,1,'375.00','2006-01-08 01:28:15','No');
INSERT INTO cart (orderid, userid, total, orderdate, approved) VALUES (3,1,'240.00','2006-01-08 02:10:47','No');
INSERT INTO cart (orderid, userid, total, orderdate, approved) VALUES (4,1,'342.00','2006-01-08 02:47:12','No');
CREATE TABLE ordercontent (
contentid int(25) NOT NULL auto_increment,
orderid int(25) NOT NULL default '0',
userid int(25) NOT NULL default '0',
itemdesc text NOT NULL,
subtotal decimal(11,2) NOT NULL default '0.00',
qty int(25) NOT NULL default '0',
PRIMARY KEY (contentid)
) TYPE=MyISAM;
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (1,1,1,'Slim Shady - ','15.00',0);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (2,1,1,'Elite Jacket - ','30.00',0);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (3,2,1,'Slim Shady - Bla BLa','15.00',10);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (4,2,1,'Elite Jacket - Test Test \" Bla','30.00',10);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (5,3,1,'Slim Shady - Bla BLa','15.00',4);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (6,3,1,'Elite Jacket - Test Test \" Bla','30.00',6);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (7,4,1,'Slim Shady - Bla BLa','15.00',4);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (8,4,1,'Elite Jacket - Test Test \" Bla','30.00',6);
INSERT INTO ordercontent (contentid, orderid, userid, itemdesc, subtotal, qty) VALUES (9,4,1,'Cher Cher - Bla BLa','34.00',3);