DROP INDEX SYS_PK_BANNERDATA
DELETE FROM BANNERDATA
DROP TABLE BANNERDATA
CREATE TABLE BANNERDATA(FAVCATEGORY VARCHAR NOT NULL ,BANNERNAME VARCHAR NOT NULL , CONSTRAINT SYS_PK_BANNERDATA PRIMARY KEY (FAVCATEGORY) )
INSERT INTO BANNERDATA VALUES(?,?)
	column=FAVCATEGORY datatype=VARCHAR value='BIRDS'
	column=BANNERNAME datatype=VARCHAR value='banner_birds.gif'

	column=FAVCATEGORY datatype=VARCHAR value='CATS'
	column=BANNERNAME datatype=VARCHAR value='banner_cats.gif'

	column=FAVCATEGORY datatype=VARCHAR value='DOGS'
	column=BANNERNAME datatype=VARCHAR value='banner_dogs.gif'

	column=FAVCATEGORY datatype=VARCHAR value='FISH'
	column=BANNERNAME datatype=VARCHAR value='banner_fish.gif'

	column=FAVCATEGORY datatype=VARCHAR value='REPTILES'
	column=BANNERNAME datatype=VARCHAR value='banner_reptiles.gif'

	Number of Rows=5

DROP INDEX SYS_PK_CATEGORYDETAILS
DELETE FROM CATEGORYDETAILS
DROP TABLE CATEGORYDETAILS
CREATE TABLE CATEGORYDETAILS(CATID VARCHAR NOT NULL ,NAME VARCHAR NOT NULL , CONSTRAINT SYS_PK_CATEGORYDETAILS PRIMARY KEY (CATID) )
INSERT INTO CATEGORYDETAILS VALUES(?,?)
	column=CATID datatype=VARCHAR value='BIRDS'
	column=NAME datatype=VARCHAR value='Birds'

	column=CATID datatype=VARCHAR value='CATS'
	column=NAME datatype=VARCHAR value='Cats'

	column=CATID datatype=VARCHAR value='DOGS'
	column=NAME datatype=VARCHAR value='Dogs'

	column=CATID datatype=VARCHAR value='FISH'
	column=NAME datatype=VARCHAR value='Fish'

	column=CATID datatype=VARCHAR value='REPTILES'
	column=NAME datatype=VARCHAR value='Reptiles'

	Number of Rows=5

DROP INDEX SYS_PK_ITEM
DELETE FROM ITEM
DROP TABLE ITEM
CREATE TABLE ITEM(ITEMID VARCHAR NOT NULL ,PRODUCTID VARCHAR NOT NULL ,LISTPRICE DECIMAL NOT NULL ,UNITCOST DECIMAL NOT NULL ,SUPPID INTEGER,QTY INTEGER, CONSTRAINT SYS_PK_ITEM PRIMARY KEY (ITEMID) )
INSERT INTO ITEM VALUES(?,?,?,?,?,?)
	column=ITEMID datatype=VARCHAR value='EST-1'
	column=PRODUCTID datatype=VARCHAR value='FI-SW-01'
	column=LISTPRICE datatype=DECIMAL value='16.50'
	column=UNITCOST datatype=DECIMAL value='10.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-10'
	column=PRODUCTID datatype=VARCHAR value='K9-DL-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-11'
	column=PRODUCTID datatype=VARCHAR value='RP-SN-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-12'
	column=PRODUCTID datatype=VARCHAR value='RP-SN-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-13'
	column=PRODUCTID datatype=VARCHAR value='RP-LI-02'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-14'
	column=PRODUCTID datatype=VARCHAR value='FL-DSH-01'
	column=LISTPRICE datatype=DECIMAL value='58.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-15'
	column=PRODUCTID datatype=VARCHAR value='FL-DSH-01'
	column=LISTPRICE datatype=DECIMAL value='23.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-16'
	column=PRODUCTID datatype=VARCHAR value='FL-DLH-02'
	column=LISTPRICE datatype=DECIMAL value='93.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-17'
	column=PRODUCTID datatype=VARCHAR value='FL-DLH-02'
	column=LISTPRICE datatype=DECIMAL value='93.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-18'
	column=PRODUCTID datatype=VARCHAR value='AV-CB-01'
	column=LISTPRICE datatype=DECIMAL value='193.50'
	column=UNITCOST datatype=DECIMAL value='92.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-19'
	column=PRODUCTID datatype=VARCHAR value='AV-SB-02'
	column=LISTPRICE datatype=DECIMAL value='15.50'
	column=UNITCOST datatype=DECIMAL value='2.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-2'
	column=PRODUCTID datatype=VARCHAR value='FI-SW-01'
	column=LISTPRICE datatype=DECIMAL value='16.50'
	column=UNITCOST datatype=DECIMAL value='10.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-20'
	column=PRODUCTID datatype=VARCHAR value='FI-FW-02'
	column=LISTPRICE datatype=DECIMAL value='5.50'
	column=UNITCOST datatype=DECIMAL value='2.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-21'
	column=PRODUCTID datatype=VARCHAR value='FI-FW-02'
	column=LISTPRICE datatype=DECIMAL value='5.29'
	column=UNITCOST datatype=DECIMAL value='1.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-22'
	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=LISTPRICE datatype=DECIMAL value='135.50'
	column=UNITCOST datatype=DECIMAL value='1.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-23'
	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=LISTPRICE datatype=DECIMAL value='145.49'
	column=UNITCOST datatype=DECIMAL value='1.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-24'
	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=LISTPRICE datatype=DECIMAL value='255.50'
	column=UNITCOST datatype=DECIMAL value='92.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-25'
	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=LISTPRICE datatype=DECIMAL value='325.29'
	column=UNITCOST datatype=DECIMAL value='90.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-26'
	column=PRODUCTID datatype=VARCHAR value='K9-CW-01'
	column=LISTPRICE datatype=DECIMAL value='125.50'
	column=UNITCOST datatype=DECIMAL value='92.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-27'
	column=PRODUCTID datatype=VARCHAR value='K9-CW-01'
	column=LISTPRICE datatype=DECIMAL value='155.29'
	column=UNITCOST datatype=DECIMAL value='90.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-28'
	column=PRODUCTID datatype=VARCHAR value='K9-RT-01'
	column=LISTPRICE datatype=DECIMAL value='155.29'
	column=UNITCOST datatype=DECIMAL value='90.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-3'
	column=PRODUCTID datatype=VARCHAR value='FI-SW-02'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-4'
	column=PRODUCTID datatype=VARCHAR value='FI-FW-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-5'
	column=PRODUCTID datatype=VARCHAR value='FI-FW-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-8'
	column=PRODUCTID datatype=VARCHAR value='K9-PO-02'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	column=ITEMID datatype=VARCHAR value='EST-9'
	column=PRODUCTID datatype=VARCHAR value='K9-DL-01'
	column=LISTPRICE datatype=DECIMAL value='18.50'
	column=UNITCOST datatype=DECIMAL value='12.00'
	column=SUPPID datatype=INTEGER value='1'
	column=QTY datatype=INTEGER value='10000'

	Number of Rows=26

DROP INDEX SYS_PK_LINEITEM
DELETE FROM LINEITEM
DROP TABLE LINEITEM
CREATE TABLE LINEITEM(ORDERID VARCHAR NOT NULL ,LINENUM INTEGER NOT NULL ,ITEMID VARCHAR NOT NULL ,QUANTITY INTEGER NOT NULL ,UNITPRICE DECIMAL NOT NULL , CONSTRAINT SYS_PK_LINEITEM PRIMARY KEY (LINENUM, ORDERID) )
DROP INDEX SYS_PK_ORDERS
DELETE FROM ORDERS
DROP TABLE ORDERS
CREATE TABLE ORDERS(ORDERID VARCHAR NOT NULL ,USERID VARCHAR NOT NULL ,ORDERDATE TIMESTAMP NOT NULL ,SHIPTOFIRSTNAME VARCHAR NOT NULL ,SHIPTOLASTNAME VARCHAR NOT NULL ,SHIPTOADDRESS1 VARCHAR NOT NULL ,SHIPTOADDRESS2 VARCHAR NOT NULL ,SHIPTOCITY VARCHAR NOT NULL ,SHIPTOSTATE VARCHAR,SHIPTOZIP VARCHAR NOT NULL ,SHIPTOCOUNTRY VARCHAR NOT NULL ,SHIPTOPHONENUMBER VARCHAR,BILLTOFIRSTNAME VARCHAR NOT NULL ,BILLTOLASTNAME VARCHAR,BILLTOADDRESS1 VARCHAR,BILLTOADDRESS2 VARCHAR,BILLTOCITY VARCHAR,BILLTOSTATE VARCHAR,BILLTOPOSTALCODE VARCHAR NOT NULL ,BILLTOCOUNTRY VARCHAR NOT NULL ,BILLTOPHONENUMBER VARCHAR,TOTALPRICE DECIMAL,CARDTYPE VARCHAR NOT NULL ,CARDNUMBER VARCHAR NOT NULL ,CARDEXPIREMONTH VARCHAR NOT NULL ,CARDEXPIREYEAR VARCHAR NOT NULL ,LOCALE VARCHAR NOT NULL , CONSTRAINT SYS_PK_ORDERS PRIMARY KEY (ORDERID) )
DROP INDEX SYS_PK_PRODUCT
DELETE FROM PRODUCT
DROP TABLE PRODUCT
CREATE TABLE PRODUCT(PRODUCTID VARCHAR NOT NULL ,CATID VARCHAR NOT NULL ,IMAGE VARCHAR, CONSTRAINT SYS_PK_PRODUCT PRIMARY KEY (PRODUCTID) )
INSERT INTO PRODUCT VALUES(?,?,?)
	column=PRODUCTID datatype=VARCHAR value='AV-CB-01'
	column=CATID datatype=VARCHAR value='BIRDS'
	column=IMAGE datatype=VARCHAR value='bird4.gif'

	column=PRODUCTID datatype=VARCHAR value='AV-SB-02'
	column=CATID datatype=VARCHAR value='BIRDS'
	column=IMAGE datatype=VARCHAR value='bird2.gif'

	column=PRODUCTID datatype=VARCHAR value='FI-FW-01'
	column=CATID datatype=VARCHAR value='FISH'
	column=IMAGE datatype=VARCHAR value='fish3.gif'

	column=PRODUCTID datatype=VARCHAR value='FI-FW-02'
	column=CATID datatype=VARCHAR value='FISH'
	column=IMAGE datatype=VARCHAR value='fish2.gif'

	column=PRODUCTID datatype=VARCHAR value='FI-SW-01'
	column=CATID datatype=VARCHAR value='FISH'
	column=IMAGE datatype=VARCHAR value='fish1.gif'

	column=PRODUCTID datatype=VARCHAR value='FI-SW-02'
	column=CATID datatype=VARCHAR value='FISH'
	column=IMAGE datatype=VARCHAR value='fish4.gif'

	column=PRODUCTID datatype=VARCHAR value='FL-DLH-02'
	column=CATID datatype=VARCHAR value='CATS'
	column=IMAGE datatype=VARCHAR value='cat1.gif'

	column=PRODUCTID datatype=VARCHAR value='FL-DSH-01'
	column=CATID datatype=VARCHAR value='CATS'
	column=IMAGE datatype=VARCHAR value='cat3.gif'

	column=PRODUCTID datatype=VARCHAR value='K9-CW-01'
	column=CATID datatype=VARCHAR value='DOGS'
	column=IMAGE datatype=VARCHAR value='dog4.gif'

	column=PRODUCTID datatype=VARCHAR value='K9-DL-01'
	column=CATID datatype=VARCHAR value='DOGS'
	column=IMAGE datatype=VARCHAR value='dog6.gif'

	column=PRODUCTID datatype=VARCHAR value='K9-PO-02'
	column=CATID datatype=VARCHAR value='DOGS'
	column=IMAGE datatype=VARCHAR value='dog3.gif'

	column=PRODUCTID datatype=VARCHAR value='K9-RT-01'
	column=CATID datatype=VARCHAR value='DOGS'
	column=IMAGE datatype=VARCHAR value='dog1.gif'

	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=CATID datatype=VARCHAR value='DOGS'
	column=IMAGE datatype=VARCHAR value='dog5.gif'

	column=PRODUCTID datatype=VARCHAR value='RP-LI-02'
	column=CATID datatype=VARCHAR value='REPTILES'
	column=IMAGE datatype=VARCHAR value='lizard1.gif'

	column=PRODUCTID datatype=VARCHAR value='RP-SN-01'
	column=CATID datatype=VARCHAR value='REPTILES'
	column=IMAGE datatype=VARCHAR value='snake1.gif'

	Number of Rows=15

DROP INDEX SYS_PK_PRODUCTDETAILS
DELETE FROM PRODUCTDETAILS
DROP TABLE PRODUCTDETAILS
CREATE TABLE PRODUCTDETAILS(PRODUCTID VARCHAR NOT NULL ,NAME VARCHAR NOT NULL ,DESCN VARCHAR NOT NULL , CONSTRAINT SYS_PK_PRODUCTDETAILS PRIMARY KEY (PRODUCTID) )
INSERT INTO PRODUCTDETAILS VALUES(?,?,?)
	column=PRODUCTID datatype=VARCHAR value='AV-CB-01'
	column=NAME datatype=VARCHAR value='Amazon Parrot'
	column=DESCN datatype=VARCHAR value='Great companion for up to 75 years'

	column=PRODUCTID datatype=VARCHAR value='AV-SB-02'
	column=NAME datatype=VARCHAR value='Finch'
	column=DESCN datatype=VARCHAR value='Great stress reliever'

	column=PRODUCTID datatype=VARCHAR value='FI-FW-01'
	column=NAME datatype=VARCHAR value='Koi'
	column=DESCN datatype=VARCHAR value='Fresh Water Fish from Japan'

	column=PRODUCTID datatype=VARCHAR value='FI-FW-02'
	column=NAME datatype=VARCHAR value='Golden Fish'
	column=DESCN datatype=VARCHAR value='Fresh Water Fish from China'

	column=PRODUCTID datatype=VARCHAR value='FI-SW-01'
	column=NAME datatype=VARCHAR value='Angel Fish'
	column=DESCN datatype=VARCHAR value='Salt Water Fish from Australia'

	column=PRODUCTID datatype=VARCHAR value='FI-SW-02'
	column=NAME datatype=VARCHAR value='Tiger Shark'
	column=DESCN datatype=VARCHAR value='Salt Water Fish from Australia'

	column=PRODUCTID datatype=VARCHAR value='FL-DLH-02'
	column=NAME datatype=VARCHAR value='Persian'
	column=DESCN datatype=VARCHAR value='Friendly house cat, doubles as a princess'

	column=PRODUCTID datatype=VARCHAR value='FL-DSH-01'
	column=NAME datatype=VARCHAR value='Manx'
	column=DESCN datatype=VARCHAR value='Great for reducing mouse populations'

	column=PRODUCTID datatype=VARCHAR value='K9-CW-01'
	column=NAME datatype=VARCHAR value='Chihuahua'
	column=DESCN datatype=VARCHAR value='Great companion dog'

	column=PRODUCTID datatype=VARCHAR value='K9-DL-01'
	column=NAME datatype=VARCHAR value='Dalmation'
	column=DESCN datatype=VARCHAR value='Great dog for a Fire Station'

	column=PRODUCTID datatype=VARCHAR value='K9-PO-02'
	column=NAME datatype=VARCHAR value='Poodle'
	column=DESCN datatype=VARCHAR value='Cute dog from France'

	column=PRODUCTID datatype=VARCHAR value='K9-RT-01'
	column=NAME datatype=VARCHAR value='Golden Retriever'
	column=DESCN datatype=VARCHAR value='Great family dog'

	column=PRODUCTID datatype=VARCHAR value='K9-RT-02'
	column=NAME datatype=VARCHAR value='Labrador Retriever'
	column=DESCN datatype=VARCHAR value='Great hunting dog'

	column=PRODUCTID datatype=VARCHAR value='RP-LI-02'
	column=NAME datatype=VARCHAR value='Iguana'
	column=DESCN datatype=VARCHAR value='Friendly green friend'

	column=PRODUCTID datatype=VARCHAR value='RP-SN-01'
	column=NAME datatype=VARCHAR value='Rattlesnake'
	column=DESCN datatype=VARCHAR value='Doubles as a watch dog'

	Number of Rows=15

DROP INDEX SYS_PK_SUPPLIER
DELETE FROM SUPPLIER
DROP TABLE SUPPLIER
CREATE TABLE SUPPLIER(SUPPID INTEGER NOT NULL ,NAME VARCHAR NOT NULL ,STATUS CHAR(2),ADDR1 VARCHAR,ADDR2 VARCHAR,CITY VARCHAR,STATE VARCHAR,ZIP VARCHAR,PHONE VARCHAR, CONSTRAINT SYS_PK_SUPPLIER PRIMARY KEY (SUPPID) )
INSERT INTO SUPPLIER VALUES(?,?,?,?,?,?,?,?,?)
	column=SUPPID datatype=INTEGER value='1'
	column=NAME datatype=VARCHAR value='XYZ Pets'
	column=STATUS datatype=CHAR value='AC'
	column=ADDR1 datatype=VARCHAR value='600 Avon Way'
	column=ADDR2 datatype=VARCHAR value=<null>
	column=CITY datatype=VARCHAR value='Los Angeles'
	column=STATE datatype=VARCHAR value='CA'
	column=ZIP datatype=VARCHAR value='94024'
	column=PHONE datatype=VARCHAR value='212-947-0797'

	column=SUPPID datatype=INTEGER value='2'
	column=NAME datatype=VARCHAR value='ABC Pets'
	column=STATUS datatype=CHAR value='AC'
	column=ADDR1 datatype=VARCHAR value='700 Abalone Way'
	column=ADDR2 datatype=VARCHAR value=<null>
	column=CITY datatype=VARCHAR value='San Francisco'
	column=STATE datatype=VARCHAR value='CA'
	column=ZIP datatype=VARCHAR value='94024'
	column=PHONE datatype=VARCHAR value='415-947-0797'

	Number of Rows=2

DROP INDEX SYS_PK_USERACCOUNT
DELETE FROM USERACCOUNT
DROP TABLE USERACCOUNT
CREATE TABLE USERACCOUNT(USERID VARCHAR NOT NULL ,PWD VARCHAR,EMAIL VARCHAR,FIRSTNAME VARCHAR,LASTNAME VARCHAR,STATUS CHAR(2),ADDR1 VARCHAR,ADDR2 VARCHAR,CITY VARCHAR,STATE VARCHAR,ZIP VARCHAR,COUNTRY VARCHAR,PHONE VARCHAR,LANGPREF VARCHAR,FAVCATEGORY VARCHAR,MYLISTOPT INTEGER,BANNEROPT INTEGER, CONSTRAINT SYS_PK_USERACCOUNT PRIMARY KEY (USERID) )
INSERT INTO USERACCOUNT VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
	column=USERID datatype=VARCHAR value='j2ee'
	column=PWD datatype=VARCHAR value='j2ee'
	column=EMAIL datatype=VARCHAR value='yourname@yourdomain.com'
	column=FIRSTNAME datatype=VARCHAR value='ABC'
	column=LASTNAME datatype=VARCHAR value='XYX'
	column=STATUS datatype=CHAR value='OK'
	column=ADDR1 datatype=VARCHAR value='901 San Antonio Road'
	column=ADDR2 datatype=VARCHAR value='UCUP02-666'
	column=CITY datatype=VARCHAR value='Palo Alto'
	column=STATE datatype=VARCHAR value='CA'
	column=ZIP datatype=VARCHAR value='94303'
	column=COUNTRY datatype=VARCHAR value='USA'
	column=PHONE datatype=VARCHAR value='555-555-5555'
	column=LANGPREF datatype=VARCHAR value='en_US'
	column=FAVCATEGORY datatype=VARCHAR value='DOGS'
	column=MYLISTOPT datatype=INTEGER value='1'
	column=BANNEROPT datatype=INTEGER value='1'

	Number of Rows=1

CREATE UNIQUE INDEX SYS_PK_BANNERDATA ON BANNERDATA(FAVCATEGORY)
CREATE UNIQUE INDEX SYS_PK_CATEGORYDETAILS ON CATEGORYDETAILS(CATID)
CREATE UNIQUE INDEX SYS_PK_ITEM ON ITEM(ITEMID)
CREATE UNIQUE INDEX SYS_PK_LINEITEM ON LINEITEM(LINENUM,ORDERID)
CREATE UNIQUE INDEX SYS_PK_ORDERS ON ORDERS(ORDERID)
CREATE UNIQUE INDEX SYS_PK_PRODUCT ON PRODUCT(PRODUCTID)
CREATE UNIQUE INDEX SYS_PK_PRODUCTDETAILS ON PRODUCTDETAILS(PRODUCTID)
CREATE UNIQUE INDEX SYS_PK_SUPPLIER ON SUPPLIER(SUPPID)
CREATE UNIQUE INDEX SYS_PK_USERACCOUNT ON USERACCOUNT(USERID)
