jpetstore.script

simple spider 源码 better light faster java 书籍源码.

CREATE TABLE SUPPLIER(SUPPID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80),STATUS VARCHAR(2) NOT NULL,ADDR1 VARCHAR(80),ADDR2 VARCHAR(80),CITY VARCHAR(80),STATE VARCHAR(80),ZIP VARCHAR(5),PHONE VARCHAR(80))
CREATE TABLE SIGNON(USERNAME VARCHAR(25) NOT NULL PRIMARY KEY,PASSWORD VARCHAR(25) NOT NULL)
CREATE TABLE ACCOUNT(USERID VARCHAR(80) NOT NULL PRIMARY KEY,EMAIL VARCHAR(80) NOT NULL,FIRSTNAME VARCHAR(80) NOT NULL,LASTNAME VARCHAR(80) NOT NULL,STATUS VARCHAR(2),ADDR1 VARCHAR(80) NOT NULL,ADDR2 VARCHAR(40),CITY VARCHAR(80) NOT NULL,STATE VARCHAR(80) NOT NULL,ZIP VARCHAR(20) NOT NULL,COUNTRY VARCHAR(20) NOT NULL,PHONE VARCHAR(80) NOT NULL)
CREATE TABLE PROFILE(USERID VARCHAR(80) NOT NULL PRIMARY KEY,LANGPREF VARCHAR(80) NOT NULL,FAVCATEGORY VARCHAR(30),MYLISTOPT INTEGER,BANNEROPT INTEGER)
CREATE TABLE BANNERDATA(FAVCATEGORY VARCHAR(80) NOT NULL PRIMARY KEY,BANNERNAME VARCHAR(255))
CREATE TABLE ORDERS(ORDERID INTEGER NOT NULL PRIMARY KEY,USERID VARCHAR(80) NOT NULL,ORDERDATE DATE NOT NULL,SHIPADDR1 VARCHAR(80) NOT NULL,SHIPADDR2 VARCHAR(80),SHIPCITY VARCHAR(80) NOT NULL,SHIPSTATE VARCHAR(80) NOT NULL,SHIPZIP VARCHAR(20) NOT NULL,SHIPCOUNTRY VARCHAR(20) NOT NULL,BILLADDR1 VARCHAR(80) NOT NULL,BILLADDR2 VARCHAR(80),BILLCITY VARCHAR(80) NOT NULL,BILLSTATE VARCHAR(80) NOT NULL,BILLZIP VARCHAR(20) NOT NULL,BILLCOUNTRY VARCHAR(20) NOT NULL,COURIER VARCHAR(80) NOT NULL,TOTALPRICE DECIMAL(10,2) NOT NULL,BILLTOFIRSTNAME VARCHAR(80) NOT NULL,BILLTOLASTNAME VARCHAR(80) NOT NULL,SHIPTOFIRSTNAME VARCHAR(80) NOT NULL,SHIPTOLASTNAME VARCHAR(80) NOT NULL,CREDITCARD VARCHAR(80) NOT NULL,EXPRDATE VARCHAR(7) NOT NULL,CARDTYPE VARCHAR(80) NOT NULL,LOCALE VARCHAR(80) NOT NULL)
CREATE TABLE ORDERSTATUS(ORDERID INTEGER NOT NULL,LINENUM INTEGER NOT NULL,TIMESTAMP DATE NOT NULL,STATUS VARCHAR(2) NOT NULL,CONSTRAINT PK_ORDERSTATUS PRIMARY KEY(ORDERID,LINENUM))
CREATE TABLE LINEITEM(ORDERID INTEGER NOT NULL,LINENUM INTEGER NOT NULL,ITEMID VARCHAR(10) NOT NULL,QUANTITY INTEGER NOT NULL,UNITPRICE DECIMAL(10,2) NOT NULL,CONSTRAINT PK_LINEITEM PRIMARY KEY(ORDERID,LINENUM))
CREATE TABLE CATEGORY(CATID VARCHAR(10) NOT NULL PRIMARY KEY,NAME VARCHAR(80),DESCN VARCHAR(255))
CREATE TABLE PRODUCT(PRODUCTID VARCHAR(10) NOT NULL PRIMARY KEY,CATEGORY VARCHAR(10) NOT NULL,NAME VARCHAR(80),DESCN VARCHAR(255),CONSTRAINT FK_PRODUCT_1 FOREIGN KEY(CATEGORY) REFERENCES CATEGORY(CATID))
CREATE INDEX PRODUCTCAT ON PRODUCT(CATEGORY)
CREATE INDEX PRODUCTNAME ON PRODUCT(NAME)
CREATE TABLE ITEM(ITEMID VARCHAR(10) NOT NULL PRIMARY KEY,PRODUCTID VARCHAR(10) NOT NULL,LISTPRICE DECIMAL(10,2),UNITCOST DECIMAL(10,2),SUPPLIER INTEGER,STATUS VARCHAR(2),ATTR1 VARCHAR(80),ATTR2 VARCHAR(80),ATTR3 VARCHAR(80),ATTR4 VARCHAR(80),ATTR5 VARCHAR(80),CONSTRAINT FK_ITEM_1 FOREIGN KEY(PRODUCTID) REFERENCES PRODUCT(PRODUCTID),CONSTRAINT FK_ITEM_2 FOREIGN KEY(SUPPLIER) REFERENCES SUPPLIER(SUPPID))
CREATE INDEX ITEMPROD ON ITEM(PRODUCTID)
CREATE TABLE INVENTORY(ITEMID VARCHAR(10) NOT NULL PRIMARY KEY,QTY INTEGER NOT NULL)
CREATE TABLE SEQUENCE(NAME VARCHAR(30) NOT NULL PRIMARY KEY,NEXTID INTEGER NOT NULL)
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring"
CREATE ALIAS HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "org.hsqldb.Library.abs"
CREATE ALIAS POWER FOR "java.lang.Math.pow"
CREATE ALIAS CHAR FOR "org.hsqldb.Library.character"
CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat"
CREATE ALIAS PI FOR "org.hsqldb.Library.pi"
CREATE ALIAS RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
CREATE ALIAS SECOND FOR "org.hsqldb.Library.second"
CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate"
CREATE ALIAS MONTH FOR "org.hsqldb.Library.month"
CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase"
CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2"
CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat"
CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth"
CREATE ALIAS TAN FOR "java.lang.Math.tan"
CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians"
CREATE ALIAS FLOOR FOR "java.lang.Math.floor"
CREATE ALIAS NOW FOR "org.hsqldb.Library.now"
CREATE ALIAS ACOS FOR "java.lang.Math.acos"
CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek"
CREATE ALIAS CEILING FOR "java.lang.Math.ceil"
CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear"
CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase"
CREATE ALIAS WEEK FOR "org.hsqldb.Library.week"
CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex"
CREATE ALIAS ASIN FOR "java.lang.Math.asin"
CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate"
CREATE ALIAS EXP FOR "java.lang.Math.exp"
CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname"
CREATE ALIAS YEAR FOR "org.hsqldb.Library.year"
CREATE ALIAS LEFT FOR "org.hsqldb.Library.left"
CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic"
CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor"
CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim"
CREATE ALIAS COT FOR "org.hsqldb.Library.cot"
CREATE ALIAS COS FOR "java.lang.Math.cos"
CREATE ALIAS MOD FOR "org.hsqldb.Library.mod"
CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign"
CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees"
CREATE ALIAS LOG FOR "java.lang.Math.log"
CREATE ALIAS SIN FOR "java.lang.Math.sin"
CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime"
CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference"
CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert"
CREATE ALIAS SUBSTR FOR "org.hsqldb.Library.substring"
CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database"
CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute"
CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour"
CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity"
CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter"
CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate"
CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand"
CREATE ALIAS USER FOR "org.hsqldb.Library.user"
CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase"
CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim"
CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10"
CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right"
CREATE ALIAS ATAN FOR "java.lang.Math.atan"
CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase"
CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii"
CREATE ALIAS RAND FOR "java.lang.Math.random"
CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
INSERT INTO SUPPLIER VALUES(1,'XYZ Pets','AC','600 Avon Way','','Los Angeles','CA','94024','212-947-0797')
INSERT INTO SUPPLIER VALUES(2,'ABC Pets','AC','700 Abalone Way','','San Francisco ','CA','94024','415-947-0797')
INSERT INTO SIGNON VALUES('ACID','ACID')
INSERT INTO SIGNON VALUES('j2ee','j2ee')
INSERT INTO ACCOUNT VALUES('ACID','[e-mail]','ABC','XYX','OK','901 San Antonio Road','MS UCUP02-206','Palo Alto','CA','94303','USA','555-555-5555')
INSERT INTO ACCOUNT VALUES('j2ee','[e-mail]','ABC','XYX','OK','901 San Antonio Road','MS UCUP02-206','Palo Alto','CA','94303','USA','555-555-5555')
INSERT INTO PROFILE VALUES('ACID','english','CATS',1,1)
INSERT INTO PROFILE VALUES('j2ee','english','DOGS',1,1)
INSERT INTO BANNERDATA VALUES('BIRDS','<image src="../images/banner_birds.gif">')
INSERT INTO BANNERDATA VALUES('CATS','<image src="../images/banner_cats.gif">')
INSERT INTO BANNERDATA VALUES('DOGS','<image src="../images/banner_dogs.gif">')
INSERT INTO BANNERDATA VALUES('FISH','<image src="../images/banner_fish.gif">')
INSERT INTO BANNERDATA VALUES('REPTILES','<image src="../images/banner_reptiles.gif">')
INSERT INTO CATEGORY VALUES('BIRDS','Birds','<image src="../images/birds_icon.gif"><font size="5" color="blue"> Birds</font>')
INSERT INTO CATEGORY VALUES('CATS','Cats','<image src="../images/cats_icon.gif"><font size="5" color="blue"> Cats</font>')
INSERT INTO CATEGORY VALUES('DOGS','Dogs','<image src="../images/dogs_icon.gif"><font size="5" color="blue"> Dogs</font>')
INSERT INTO CATEGORY VALUES('FISH','Fish','<image src="../images/fish_icon.gif"><font size="5" color="blue"> Fish</font>')
INSERT INTO CATEGORY VALUES('REPTILES','Reptiles','<image src="../images/reptiles_icon.gif"><font size="5" color="blue"> Reptiles</font>')
INSERT INTO PRODUCT VALUES('AV-CB-01','BIRDS','Amazon Parrot','<image src="../images/bird4.gif">Great companion for up to 75 years')
INSERT INTO PRODUCT VALUES('AV-SB-02','BIRDS','Finch','<image src="../images/bird1.gif">Great stress reliever')
INSERT INTO PRODUCT VALUES('FI-FW-01','FISH','Koi','<image src="../images/fish3.gif">Fresh Water fish from Japan')
INSERT INTO PRODUCT VALUES('FI-FW-02','FISH','Goldfish','<image src="../images/fish2.gif">Fresh Water fish from China')
INSERT INTO PRODUCT VALUES('FI-SW-01','FISH','Angelfish','<image src="../images/fish1.jpg">Salt Water fish from Australia')
INSERT INTO PRODUCT VALUES('FI-SW-02','FISH','Tiger Shark','<image src="../images/fish4.gif">Salt Water fish from Australia')
INSERT INTO PRODUCT VALUES('FL-DLH-02','CATS','Persian','<image src="../images/cat1.gif">Friendly house cat, doubles as a princess')
INSERT INTO PRODUCT VALUES('FL-DSH-01','CATS','Manx','<image src="../images/cat3.gif">Great for reducing mouse populations')
INSERT INTO PRODUCT VALUES('K9-BD-01','DOGS','Bulldog','<image src="../images/dog2.gif">Friendly dog from England')
INSERT INTO PRODUCT VALUES('K9-CW-01','DOGS','Chihuahua','<image src="../images/dog4.gif">Great companion dog')
INSERT INTO PRODUCT VALUES('K9-DL-01','DOGS','Dalmation','<image src="../images/dog5.gif">Great dog for a Fire Station')
INSERT INTO PRODUCT VALUES('K9-PO-02','DOGS','Poodle','<image src="../images/dog6.gif">Cute dog from France')
INSERT INTO PRODUCT VALUES('K9-RT-01','DOGS','Golden Retriever','<image src="../images/dog1.gif">Great family dog')
INSERT INTO PRODUCT VALUES('K9-RT-02','DOGS','Labrador Retriever','<image src="../images/dog5.gif">Great hunting dog')
INSERT INTO PRODUCT VALUES('RP-LI-02','REPTILES','Iguana','<image src="../images/lizard2.gif">Friendly green friend')
INSERT INTO PRODUCT VALUES('RP-SN-01','REPTILES','Rattlesnake','<image src="../images/lizard3.gif">Doubles as a watch dog')
INSERT INTO ITEM VALUES('EST-1','FI-SW-01',16.50,10.00,1,'P','Large',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-10','K9-DL-01',18.50,12.00,1,'P','Spotted Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-11','RP-SN-01',18.50,12.00,1,'P','Venomless',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-12','RP-SN-01',18.50,12.00,1,'P','Rattleless',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-13','RP-LI-02',18.50,12.00,1,'P','Green Adult',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-14','FL-DSH-01',58.50,12.00,1,'P','Tailless',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-15','FL-DSH-01',23.50,12.00,1,'P','With tail',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-16','FL-DLH-02',93.50,12.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-17','FL-DLH-02',93.50,12.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-18','AV-CB-01',193.50,92.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-19','AV-SB-02',15.50,2.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-2','FI-SW-01',16.50,10.00,1,'P','Small',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-20','FI-FW-02',5.50,2.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-21','FI-FW-02',5.29,1.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-22','K9-RT-02',135.50,100.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-23','K9-RT-02',145.49,100.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-24','K9-RT-02',255.50,92.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-25','K9-RT-02',325.29,90.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-26','K9-CW-01',125.50,92.00,1,'P','Adult Male',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-27','K9-CW-01',155.29,90.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-28','K9-RT-01',155.29,90.00,1,'P','Adult Female',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-3','FI-SW-02',18.50,12.00,1,'P','Toothless',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-4','FI-FW-01',18.50,12.00,1,'P','Spotted',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-5','FI-FW-01',18.50,12.00,1,'P','Spotless',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-6','K9-BD-01',18.50,12.00,1,'P','Male Adult',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-7','K9-BD-01',18.50,12.00,1,'P','Female Puppy',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-8','K9-PO-02',18.50,12.00,1,'P','Male Puppy',NULL,NULL,NULL,NULL)
INSERT INTO ITEM VALUES('EST-9','K9-DL-01',18.50,12.00,1,'P','Spotless Male Puppy',NULL,NULL,NULL,NULL)
INSERT INTO INVENTORY VALUES('EST-1',10000)
INSERT INTO INVENTORY VALUES('EST-10',10000)
INSERT INTO INVENTORY VALUES('EST-11',10000)
INSERT INTO INVENTORY VALUES('EST-12',10000)
INSERT INTO INVENTORY VALUES('EST-13',10000)
INSERT INTO INVENTORY VALUES('EST-14',10000)
INSERT INTO INVENTORY VALUES('EST-15',10000)
INSERT INTO INVENTORY VALUES('EST-16',10000)
INSERT INTO INVENTORY VALUES('EST-17',10000)
INSERT INTO INVENTORY VALUES('EST-18',10000)
INSERT INTO INVENTORY VALUES('EST-19',10000)
INSERT INTO INVENTORY VALUES('EST-2',10000)
INSERT INTO INVENTORY VALUES('EST-20',10000)
INSERT INTO INVENTORY VALUES('EST-21',10000)
INSERT INTO INVENTORY VALUES('EST-22',10000)
INSERT INTO INVENTORY VALUES('EST-23',10000)
INSERT INTO INVENTORY VALUES('EST-24',10000)
INSERT INTO INVENTORY VALUES('EST-25',10000)
INSERT INTO INVENTORY VALUES('EST-26',10000)
INSERT INTO INVENTORY VALUES('EST-27',10000)
INSERT INTO INVENTORY VALUES('EST-28',10000)
INSERT INTO INVENTORY VALUES('EST-3',10000)
INSERT INTO INVENTORY VALUES('EST-4',10000)
INSERT INTO INVENTORY VALUES('EST-5',10000)
INSERT INTO INVENTORY VALUES('EST-6',10000)
INSERT INTO INVENTORY VALUES('EST-7',10000)
INSERT INTO INVENTORY VALUES('EST-8',10000)
INSERT INTO INVENTORY VALUES('EST-9',10000)
INSERT INTO SEQUENCE VALUES('linenum',1000)
INSERT INTO SEQUENCE VALUES('ordernum',1000)
/*C2*/CONNECT USER sa PASSWORD ""
CONNECT USER sa PASSWORD ""
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET READONLY TRUE
SET AUTOCOMMIT FALSE
COMMIT
SET AUTOCOMMIT TRUE
SET READONLY FALSE
SET AUTOCOMMIT TRUE
SET AUTOCOMMIT TRUE
SET READONLY FALSE