Cut off ciggies - Blog Instead

CREATE TABLE DOCREF(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,TITLE VARCHAR,DESC VARCHAR,FDATE DATE,URL VARCHAR)
CREATE TABLE LINKREF(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,TITLE VARCHAR,DESC VARCHAR,URL VARCHAR)
CREATE TABLE EXREF(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,TITLE VARCHAR,DESC VARCHAR,FDATE DATE,URL VARCHAR)
CREATE USER JAVALAB PASSWORD "JAVA09"
INSERT INTO DOCREF VALUES(0,'Thinking in Java','Εισαγωγή στη Java','2008-10-26','TIJ2.pdf')
INSERT INTO DOCREF VALUES(1,'HSQLDB User guide','Οδηγίες για HQLDB','2008-10-26','guide.pdf')
INSERT INTO DOCREF VALUES(3,'Database Tools Manual','Οδηγίες για το plugin "Database tools"','2008-10-28','dbtools.howto.pdf')
INSERT INTO DOCREF VALUES(6,'Introduction to Servlets','Εισαγωγή Servlets','2009-01-12','Introduction_to_Servlets.pdf')
INSERT INTO LINKREF VALUES(0,'Ιστοχώρος της Java','http://java.sun.com')
INSERT INTO LINKREF VALUES(1,'Ιστoχώρος του eclipse','http://www.eclipse.org')
INSERT INTO LINKREF VALUES(2,'Παραδείγματα Java','http://www.idevelopment.info/data/Programming/java/PROGRAMMING_Java_Programming.shtml')
INSERT INTO LINKREF VALUES(3,'Java2SE reference API','http://java.sun.com/j2se/1.5.0/docs/api/')
INSERT INTO LINKREF VALUES(4,'Αναζήτηση','please go to google from here','http://www.google.com')
INSERT INTO EXREF VALUES(0,'Ασκηση 1, Java IO',' ex1.pdf')
INSERT INTO EXREF VALUES(1,'Ασκηση 2, servlets','ex2.pdf')