CREATE TABLE FEED(ID INTEGER IDENTITY PRIMARY KEY,LOCATION VARCHAR_IGNORECASE,CONTENT_TYPE VARCHAR_IGNORECASE,DATE_FOUND BIGINT,LAST_UPDATED BIGINT,COPYRIGHT VARCHAR_IGNORECASE,UNIQUE(ID))
CREATE INDEX INDX_FEED_LOCATION ON FEED(LOCATION)
CREATE INDEX INDX_FEED_ID ON FEED(ID)
CREATE TABLE CHANNEL(ID INTEGER IDENTITY PRIMARY KEY,LOCATION VARCHAR_IGNORECASE,SITE VARCHAR_IGNORECASE,CONTENT_TYPE VARCHAR_IGNORECASE,TITLE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,IMAGE_FK INTEGER,SOURCE VARCHAR_IGNORECASE,DATE_FOUND BIGINT,LAST_UPDATED BIGINT,COPYRIGHT VARCHAR_IGNORECASE,CATEGORY_FK INTEGER,SUBSCRIBED INTEGER,INITIALIZED INTEGER,UNIQUE(ID),UNIQUE(LOCATION))
CREATE INDEX INDX_CHANNEL_LOCATION ON CHANNEL(LOCATION)
CREATE INDEX INDX_CHANNEL_ID ON CHANNEL(ID)
CREATE TABLE IMAGE(ID INTEGER IDENTITY PRIMARY KEY,CHANNEL VARCHAR_IGNORECASE,LOCATION VARCHAR_IGNORECASE,WIDTH INTEGER,HEIGHT INTEGER,TITLE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,UNIQUE(ID),UNIQUE(CHANNEL))
CREATE INDEX INDX_IMAGE_ID ON IMAGE(ID)
CREATE INDEX INDX_IMAGE_CHANNEL ON IMAGE(CHANNEL)
CREATE TABLE ARTICLE(ID INTEGER IDENTITY PRIMARY KEY,LOCATION VARCHAR_IGNORECASE,CHANNEL VARCHAR_IGNORECASE,TITLE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,COPYRIGHT VARCHAR_IGNORECASE,DC_CREATOR VARCHAR_IGNORECASE,DC_SUBJECT VARCHAR_IGNORECASE,DATE_FOUND BIGINT,LAST_UPDATED BIGINT,MARKED_READ INTEGER,UNIQUE(ID),UNIQUE(LOCATION))
CREATE INDEX INDX_ARTICLE_LOCATION ON ARTICLE(LOCATION)
CREATE INDEX INDX_ARTICLE_CHANNEL ON ARTICLE(CHANNEL)
CREATE INDEX INDX_ARTICLE_CHANNEL_MARKED_READ ON ARTICLE(CHANNEL,MARKED_READ)
CREATE INDEX INDX_ARTICLE_ID ON ARTICLE(ID)
CREATE TABLE FAVICON(ID INTEGER IDENTITY PRIMARY KEY,SITE VARCHAR_IGNORECASE,LOCATION VARCHAR_IGNORECASE,STATUS INTEGER,UNIQUE(ID),UNIQUE(LOCATION),UNIQUE(SITE))
CREATE INDEX INDX_FAVICON_LOCATION ON FAVICON(LOCATION)
CREATE INDEX INDX_FAVICON_SITE ON FAVICON(SITE)
CREATE TABLE MONITOR(ID INTEGER IDENTITY PRIMARY KEY,CHANNEL_FK INTEGER,UNIQUE(ID,CHANNEL_FK))
CREATE TABLE CATEGORY(ID INTEGER IDENTITY PRIMARY KEY,NAME VARCHAR_IGNORECASE,UNIQUE(ID),UNIQUE(NAME))
CREATE INDEX INDX_CATEGORY_ID ON CATEGORY(ID)
CREATE TABLE WEBLOG(ID INTEGER IDENTITY PRIMARY KEY,LOCATION VARCHAR_IGNORECASE,TITLE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,COMMENTS VARCHAR_IGNORECASE,DC_SUBJECT VARCHAR_IGNORECASE,DATE_FOUND BIGINT,LAST_UPDATED BIGINT,UNIQUE(ID))
CREATE INDEX INDX_CHANNEL_LOCATION ON WEBLOG(LOCATION)
CREATE INDEX INDX_WEBLOG_ID ON WEBLOG(ID)
CREATE TABLE TEXTINPUT(ID INTEGER IDENTITY PRIMARY KEY,SITE VARCHAR_IGNORECASE,CHANNEL VARCHAR_IGNORECASE,LINK VARCHAR_IGNORECASE,TITLE VARCHAR_IGNORECASE,DESCRIPTION VARCHAR_IGNORECASE,NAME VARCHAR_IGNORECASE,UNIQUE(ID))
CREATE INDEX INDX_TEXTINPUT_ID ON TEXTINPUT(ID)
CREATE TABLE SETTING(ID INTEGER IDENTITY PRIMARY KEY,NAME VARCHAR_IGNORECASE,VALUE VARCHAR_IGNORECASE,UNIQUE(ID))
CREATE INDEX INDX_CONFIG_ID ON SETTING(ID)
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
SET IGNORECASE TRUE
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 SQRT FOR "java.lang.Math.sqrt"
CREATE ALIAS ABS FOR "java.lang.Math.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 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.hsql.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 CHANNEL VALUES(0,'http://www.slashdot.org/slashdot.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Slashdot','Slashdot',NULL,NULL,NULL,NULL,NULL,11,1,NULL)
INSERT INTO CHANNEL VALUES(1,'http://reptile.openprivacy.org/xml/reptile-news.rss',NULL,'http://purl.org/rss/1.0/','Reptile news','Reptile news',NULL,NULL,NULL,NULL,NULL,4,1,NULL)
INSERT INTO CHANNEL VALUES(2,'http://relativity.yi.org/rss/index.rss',NULL,'http://purl.org/rss/1.0/','Weblog for Kevin Burton','Kevin Burton',NULL,NULL,NULL,NULL,NULL,9,1,NULL)
INSERT INTO CHANNEL VALUES(3,'http://www.cnn.com/cnn.rss',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','CNN','CNN',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(4,'http://www.xmlhack.com/rsscat.php',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','XMLHack','XMLHack',NULL,NULL,NULL,NULL,NULL,16,1,NULL)
INSERT INTO CHANNEL VALUES(5,'http://www.wired.com/news_drop/netcenter/netcenter.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Wired','Wired',NULL,NULL,NULL,NULL,NULL,11,1,NULL)
INSERT INTO CHANNEL VALUES(6,'http://linuxtoday.com/backend/my-netscape.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','LinuxToday','LinuxToday',NULL,NULL,NULL,NULL,NULL,11,1,NULL)
INSERT INTO CHANNEL VALUES(7,'http://www.linuxplanet.com/rss',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','LinuxPlanet','LinuxPlanet',NULL,NULL,NULL,NULL,NULL,11,1,NULL)
INSERT INTO CHANNEL VALUES(8,'http://freshmeat.net/backend/fm.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Freshmeat','Freshmeat',NULL,NULL,NULL,NULL,NULL,11,1,NULL)
INSERT INTO CHANNEL VALUES(9,'http://p.moreover.com/cgi-local/page?o=rss&c=Java%20news',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Moreover: Java','Moreover: Java',NULL,NULL,NULL,NULL,NULL,5,1,NULL)
INSERT INTO CHANNEL VALUES(10,'http://www.jsurfer.org/backend.php',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Moreover: Java','Moreover: Java',NULL,NULL,NULL,NULL,NULL,5,1,NULL)
INSERT INTO CHANNEL VALUES(11,'http://www.linux.com/mrn/front_page.rss',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Linux.com','Linux.com',NULL,NULL,NULL,NULL,NULL,7,1,NULL)
INSERT INTO CHANNEL VALUES(12,'http://javaboutique.internet.com/articles.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','JavaBoutique','JavaBoutique',NULL,NULL,NULL,NULL,NULL,5,1,NULL)
INSERT INTO CHANNEL VALUES(13,'http://www.xml.com/cs/xml/query/q/19',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','XML.com','XML.com',NULL,NULL,NULL,NULL,NULL,16,1,NULL)
INSERT INTO CHANNEL VALUES(14,'http://www.apacheweek.com/issues/apacheweek-headlines.xml',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','ApacheWeek','ApacheWeek',NULL,NULL,NULL,NULL,NULL,1,1,NULL)
INSERT INTO CHANNEL VALUES(15,'http://www.oreillynet.com/meerkat/?_fl=rss&t=30DAY&c=2386',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Meerkat: python','Meerkat: python',NULL,NULL,NULL,NULL,NULL,14,1,NULL)
INSERT INTO CHANNEL VALUES(16,'http://www.python.org/channews.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','python.org','python.org',NULL,NULL,NULL,NULL,NULL,14,1,NULL)
INSERT INTO CHANNEL VALUES(17,'http://www.netbsd.org/Changes/rss-netbsd.xml',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','NetBSD','NetBSD',NULL,NULL,NULL,NULL,NULL,2,1,NULL)
INSERT INTO CHANNEL VALUES(18,'http://www.theregister.co.uk/tonys/slashdot.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','The Register','The Register',NULL,NULL,NULL,NULL,NULL,3,1,NULL)
INSERT INTO CHANNEL VALUES(19,'http://www.plastic.com/plastic.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Plastic','Plastic',NULL,NULL,NULL,NULL,NULL,4,1,NULL)
INSERT INTO CHANNEL VALUES(20,'http://www.kuro5hin.org/backend.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','kuro5hin','kuro5hin',NULL,NULL,NULL,NULL,NULL,4,1,NULL)
INSERT INTO CHANNEL VALUES(21,'http://www.oreillynet.com/meerkat/?_fl=rss&t=30DAY&c=4880',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Meerkat: P2P','Meerkat: P2P',NULL,NULL,NULL,NULL,NULL,12,1,NULL)
INSERT INTO CHANNEL VALUES(22,'http://dot.kdenews.org/rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','KDE','KDE',NULL,NULL,NULL,NULL,NULL,6,1,NULL)
INSERT INTO CHANNEL VALUES(23,'http://www.mosfet.org/mosfetnews.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.9.dtd','KDE: Mosfet','KDE: Mosfet',NULL,NULL,NULL,NULL,NULL,6,1,NULL)
INSERT INTO CHANNEL VALUES(24,'http://export.cnet.com/export/feeds/news/rss/1,11176,,00.xml',NULL,'http://my.netscape.com/publish/formats/rss-0.9.dtd','CNET','CNET',NULL,NULL,NULL,NULL,NULL,3,1,NULL)
INSERT INTO CHANNEL VALUES(25,'http://p.moreover.com/cgi-local/page?o=rss&c=XML%20and%20metadata%20news',NULL,'http://my.netscape.com/publish/formats/rss-0.9.dtd','Moreover: XML','Moreover: XML',NULL,NULL,NULL,NULL,NULL,16,1,NULL)
INSERT INTO CHANNEL VALUES(26,'http://www.blogspace.com/rss/rss10',NULL,'http://my.netscape.com/rdf/simple/0.9/','Blogspace: RSS','Blogspace: RSS',NULL,NULL,NULL,NULL,NULL,16,1,NULL)
INSERT INTO CHANNEL VALUES(27,'http://www.infoanarchy.org/backend.rdf',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','InfoAnarchy','InfoAnarchy',NULL,NULL,NULL,NULL,NULL,12,1,NULL)
INSERT INTO CHANNEL VALUES(28,'http://www.peertal.com/backend.php',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Peertal','Peertal',NULL,NULL,NULL,NULL,NULL,12,1,NULL)
INSERT INTO CHANNEL VALUES(29,'http://www.peerintelligence.com/pi-rss.xml',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','peerintelligence','peerintelligence',NULL,NULL,NULL,NULL,NULL,12,1,NULL)
INSERT INTO CHANNEL VALUES(30,'http://slashdot.org/apache.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Slashdot: Apache','Slashdot: Apache',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(31,'http://slashdot.org/features.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Slashdot: Features','Slashdot: Features',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(32,'http://slashdot.org/yro.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Slashdot: YRO','Slashdot: YRO',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(33,'http://slashdot.org/science.rdf',NULL,'http://my.netscape.com/rdf/simple/0.9/','Slashdot: Science','Slashdot: Science',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(34,'http://www.ilrt.bris.ac.uk/discovery/rdf/resources/rss.rdf',NULL,'http://purl.org/rss/1.0/','RDF','RDF',NULL,NULL,NULL,NULL,NULL,16,1,NULL)
INSERT INTO CHANNEL VALUES(35,'http://www.newsisfree.com/HPE/xml/feeds/07/2407.xml',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','NewsIsFree','NewsIsFree',NULL,NULL,NULL,NULL,NULL,10,1,NULL)
INSERT INTO CHANNEL VALUES(36,'http://p.moreover.com/cgi-local/page?o=rss&c=Microsoft%20news',NULL,'http://my.netscape.com/publish/formats/rss-0.91.dtd','Moreover: Microsoft','Moreover: Microsoft',NULL,NULL,NULL,NULL,NULL,8,1,NULL)
INSERT INTO CHANNEL VALUES(37,'http://www.privacydigest.com/newsToRss',NULL,'http://my.netscape.com/rdf/simple/0.9/','PrivacyDigest','PrivacyDigest',NULL,NULL,NULL,NULL,NULL,13,1,NULL)
INSERT INTO CATEGORY VALUES(0,'uncategorized')
INSERT INTO CATEGORY VALUES(1,'Apache')
INSERT INTO CATEGORY VALUES(2,'BSD')
INSERT INTO CATEGORY VALUES(3,'Computer Industry')
INSERT INTO CATEGORY VALUES(4,'Cool Stuff')
INSERT INTO CATEGORY VALUES(5,'Java')
INSERT INTO CATEGORY VALUES(6,'KDE')
INSERT INTO CATEGORY VALUES(7,'Linux')
INSERT INTO CATEGORY VALUES(8,'Microsoft')
INSERT INTO CATEGORY VALUES(9,'Misc')
INSERT INTO CATEGORY VALUES(10,'NEWS')
INSERT INTO CATEGORY VALUES(11,'Open Source')
INSERT INTO CATEGORY VALUES(12,'P2P')
INSERT INTO CATEGORY VALUES(13,'Privacy')
INSERT INTO CATEGORY VALUES(14,'Python')
INSERT INTO CATEGORY VALUES(15,'WAR')
INSERT INTO CATEGORY VALUES(16,'XML')
INSERT INTO SETTING VALUES(0,'reptile.setting.href-target','_new')
INSERT INTO SETTING VALUES(1,'reptile.setting.jxta.peer.title','no title')
INSERT INTO SETTING VALUES(2,'reptile.setting.jxta.peer.description','no description')
INSERT INTO SETTING VALUES(3,'reptile.setting.weblog.title','no weblog title')
INSERT INTO SETTING VALUES(4,'reptile.setting.weblog.description','no weblog description')
INSERT INTO SETTING VALUES(5,'reptile.setting.weblog.image.title','my image title')
INSERT INTO SETTING VALUES(6,'reptile.setting.weblog.image.link','http://reptile.openprivacy.org')
INSERT INTO SETTING VALUES(7,'reptile.setting.weblog.image.URL','http://reptile.openprivacy.org/images/logo.png')
INSERT INTO SETTING VALUES(8,'reptile.setting.channel.handle-read-links','normal-face')
INSERT INTO SETTING VALUES(9,'reptile.setting.rss.channel.size','10')