music.script

This is source run loader with java

CREATE TABLE PRODUCT(PRODUCT_ID VARCHAR(32) NOT NULL,PRODUCT_NAME VARCHAR(32),PRODUCT_SIZE VARCHAR(8),PRODUCT_URL VARCHAR(64))
CREATE TABLE CAMPAIGN(CAMPAIGN_ID VARCHAR(16) NOT NULL,CAMPAIGN_NAME VARCHAR(32),DISCRIPTION VARCHAR(64))
CREATE TABLE USER(USER_ID VARCHAR(16) NOT NULL,USER_NAME VARCHAR(32),YOB SMALLINT,KNOWLEDGE VARCHAR(16),BIRTH_PLACE VARCHAR(16),SEX VARCHAR(8),PASSWORD VARCHAR(32))
CREATE TABLE RESULT(CAMPAIGN_ID VARCHAR(16) NOT NULL,USER_ID VARCHAR(16) NOT NULL,PRODUCT_ID VARCHAR(32) NOT NULL,RESULT TINYINT)
CREATE TABLE ADMIN(USER_ID VARCHAR NOT NULL PRIMARY KEY)
CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\Eclipse-.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\Eclipse-.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\eclipse.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\eclipse.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\hotel\sasRadissonOswaldDusk.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\hotel\sasRadissonOswaldDusk.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\hotel\sasRobertsonDusk_may03.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\hotel\sasRobertsonDusk_may03.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\Sample.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\Sample.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('C:\Documents and Settings\khanhtq\My Documents\My Pictures\turtle.jpg','C:\Documents and Settings\khanhtq\My Documents\My Pictures\turtle.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\Eclipse-.jpg','\Eclipse-.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\eclipse.jpg','\eclipse.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\sasRadissonOswaldDusk.jpg','\sasRadissonOswaldDusk.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\sasRobertsonDusk_may03.jpg','\sasRobertsonDusk_may03.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\Sample.jpg','\Sample.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('\turtle.jpg','\turtle.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('Eclipse-.jpg','Eclipse-.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('eclipse.jpg','eclipse.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('sasRadissonOswaldDusk.jpg','sasRadissonOswaldDusk.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('sasRobertsonDusk_may03.jpg','sasRobertsonDusk_may03.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('Sample.jpg','Sample.jpg','20x20',NULL)
INSERT INTO PRODUCT VALUES('turtle.jpg','turtle.jpg','20x20',NULL)
INSERT INTO USER VALUES('khanh','khanh',NULL,NULL,NULL,NULL,'khanh')
INSERT INTO USER VALUES('Khanh Tran','Khanh Tran',0,'Trung h\u1ecdc tr\u1edf xu\u1ed1ng',NULL,'N\u1eef','Nha Uyen')
INSERT INTO USER VALUES('k','k',0,'C\u00e1c t\u1ec9nh',NULL,'Nam','k')
INSERT INTO USER VALUES('u','Nha\u0303 Uy\u00ean',0,'Cao \u0111\u1eb3ng tr\u1edf l\u00ean',NULL,NULL,'u')
INSERT INTO USER VALUES('khanh','adfasdfasdf',1,'3','5','2','khanh')
INSERT INTO USER VALUES('hai','Nguy\u00ea\u0303n Minh Ha\u0309i',1,'3','5','2','hai')
INSERT INTO RESULT VALUES('1','u','eclipse.jpg',1)
INSERT INTO RESULT VALUES('1','u','sasRobertsonDusk_may03.jpg',1)
INSERT INTO RESULT VALUES('1','u','Sample.jpg',1)
INSERT INTO RESULT VALUES('1','u','turtle.jpg',1)
INSERT INTO RESULT VALUES('1','u','sasRadissonOswaldDusk.jpg',1)
INSERT INTO RESULT VALUES('1','k','eclipse.jpg',3)
INSERT INTO RESULT VALUES('1','k','sasRobertsonDusk_may03.jpg',3)
INSERT INTO RESULT VALUES('1','k','Eclipse-.jpg',3)
INSERT INTO RESULT VALUES('1','k','Sample.jpg',3)
INSERT INTO RESULT VALUES('1','k','turtle.jpg',1)
INSERT INTO RESULT VALUES('1','k','sasRadissonOswaldDusk.jpg',3)
INSERT INTO RESULT VALUES('1','khanh','womenp2843n21.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a07.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','Sample.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a06.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a05.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a04.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','sasRadissonOswaldDusk.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a03.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a02.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','sasRobertsonDusk_may03.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','turtle.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','womenp2843n12.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a001.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','Eclipse-.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a08.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','eclipse.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','a011.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','RUS02.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','REC06.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','DC01.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','GC05.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','GC04.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','REC03.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','GC03.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','GC02.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','REC44.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','GC01.jpg',1)
INSERT INTO RESULT VALUES('1','khanh','RUS03.jpg',1)
INSERT INTO RESULT VALUES('1','u','RUS02.jpg',3)
INSERT INTO RESULT VALUES('1','u','GC03.jpg',3)
INSERT INTO RESULT VALUES('1','u','GC05.jpg',3)
INSERT INTO RESULT VALUES('1','u','DC01.jpg',3)
INSERT INTO RESULT VALUES('1','u','GC02.jpg',3)
INSERT INTO RESULT VALUES('1','u','RUS03.jpg',4)
INSERT INTO RESULT VALUES('1','u','GC04.jpg',3)
INSERT INTO RESULT VALUES('1','u','GC01.jpg',3)
INSERT INTO RESULT VALUES('1','hai','RUS02.jpg',1)
INSERT INTO RESULT VALUES('1','hai','GC03.jpg',1)
INSERT INTO RESULT VALUES('1','hai','GC05.jpg',1)
INSERT INTO RESULT VALUES('1','hai','GC02.jpg',1)
INSERT INTO RESULT VALUES('1','hai','RUS03.jpg',1)
INSERT INTO RESULT VALUES('1','hai','GC01.jpg',1)
INSERT INTO ADMIN VALUES('u')