Stuff

CREATE TABLE PREFERENCE (FKEY VARCHAR(255) NOT NULL, FTYPE INTEGER, PRIMARY KEY (FKEY))
CREATE TABLE FEED (FID NUMERIC(19) NOT NULL, FGENERATOR VARCHAR(255), FLASTBUILDDATE TIMESTAMP, FVERSION NUMERIC(19), FWEBMASTER VARCHAR(255), FTITLE VARCHAR(510), FLASTMODIFIEDDATE TIMESTAMP, FDESCRIPTION LONGVARCHAR, FTTL INTEGER, FLANGUAGE VARCHAR(255), FFORMAT VARCHAR(255), FPROPERTIES BINARY, FPUBLISHDATE TIMESTAMP, FCOPYRIGHT VARCHAR(255), FDOCS VARCHAR(510), FIMAGE_TITLE VARCHAR(255), FWIDTH INTEGER, FIMAGE_DESCRIPTION VARCHAR(255), FHEIGHT INTEGER, FIMAGE_LINK VARCHAR(510), FURL VARCHAR(510), FHOMEPAGE VARCHAR(510), FLINK VARCHAR(510), FBASEURI VARCHAR(510), FAUTHOR_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE PERSON (FID NUMERIC(19) NOT NULL, FPROPERTIES BINARY, FNAME VARCHAR(255), FVERSION NUMERIC(19), FURI VARCHAR(510), FEMAIL VARCHAR(510), PRIMARY KEY (FID))
CREATE TABLE ATTACHMENT (FID NUMERIC(19) NOT NULL, FPROPERTIES BINARY, FTYPE VARCHAR(255), FVERSION NUMERIC(19), FLENGTH INTEGER, FURL VARCHAR(510), FNEWS_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE NEWS (FID NUMERIC(19) NOT NULL, FCOMMENTS VARCHAR(255), FISFLAGGED TINYINT, FPROPERTIES BINARY, FRATING INTEGER, FLINK VARCHAR(255), FSTATE INTEGER, FRECEIVEDATE TIMESTAMP, FVERSION NUMERIC(19), FMODIFIEDDATE TIMESTAMP, FTITLE VARCHAR(510), FDESCRIPTION LONGVARCHAR, FPUBLISHDATE TIMESTAMP, FVALUE VARCHAR(255), FISPERMALINK TINYINT, FBASEURI VARCHAR(510), FFEED_FID NUMERIC(19), FLABEL_FID NUMERIC(19), FNAME VARCHAR(255), FURL VARCHAR(510), FAUTHOR_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE LABEL (FID NUMERIC(19) NOT NULL, FPROPERTIES BINARY, FNAME VARCHAR(255), FVERSION NUMERIC(19), FCOLOR VARCHAR(255), PRIMARY KEY (FID))
CREATE TABLE PREFERENCEVALUE (ID NUMERIC(19) NOT NULL, FINDEX INTEGER, FVALUE VARCHAR(255), FPARENT_FKEY VARCHAR(255), PRIMARY KEY (ID))
CREATE TABLE SEARCHCONDITION (FID NUMERIC(19) NOT NULL, FSPECIFIER INTEGER, FVALUE VARCHAR(255), FVERSION NUMERIC(19), FPROPERTIES BINARY, FISANDSEARCH TINYINT, FFIELD INTEGER, FTYPE BINARY, FSEARCHMARK_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE MARK (FID NUMERIC(19) NOT NULL, DTYPE VARCHAR(31), FCREATIONDATE TIMESTAMP, FOPENONSTARTUP TINYINT, FVERSION NUMERIC(19), FLASTVISITDATE TIMESTAMP, FNAME VARCHAR(255), FPOPULARITY INTEGER, FPROPERTIES BINARY, FINDEX INTEGER, FFOLDER_FID NUMERIC(19), FUPDATEINTERVAL INTEGER, FFEEDID NUMERIC(19), FISERRORLOADING TINYINT, FISPROXYUSED TINYINT, FLOADONSTARTUP TINYINT, PRIMARY KEY (FID))
CREATE TABLE FOLDER (FID NUMERIC(19) NOT NULL, FPROPERTIES BINARY, FINDEX INTEGER, FNAME VARCHAR(255), FVERSION NUMERIC(19), FBLOGROLLURL VARCHAR(510), FPARENT_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE CATEGORY (FID NUMERIC(19) NOT NULL, FNAME VARCHAR(255), FDOMAIN VARCHAR(255), FPROPERTIES BINARY, FVERSION NUMERIC(19), FFEEDPARENT_FID NUMERIC(19), FNEWSPARENT_FID NUMERIC(19), PRIMARY KEY (FID))
CREATE TABLE DESCRIPTIONENTITY (FID NUMERIC(19) NOT NULL, FVALUE LONGVARCHAR, PRIMARY KEY (FID))
ALTER TABLE FEED ADD CONSTRAINT FK_FEED_FAUTHOR_FID FOREIGN KEY (FAUTHOR_FID) REFERENCES PERSON (FID)
ALTER TABLE ATTACHMENT ADD CONSTRAINT FK_ATTACHMENT_FNEWS_FID FOREIGN KEY (FNEWS_FID) REFERENCES NEWS (FID)
ALTER TABLE NEWS ADD CONSTRAINT FK_NEWS_FFEED_FID FOREIGN KEY (FFEED_FID) REFERENCES FEED (FID)
ALTER TABLE NEWS ADD CONSTRAINT FK_NEWS_FLABEL_FID FOREIGN KEY (FLABEL_FID) REFERENCES LABEL (FID)
ALTER TABLE NEWS ADD CONSTRAINT FK_NEWS_FAUTHOR_FID FOREIGN KEY (FAUTHOR_FID) REFERENCES PERSON (FID)
ALTER TABLE PREFERENCEVALUE ADD CONSTRAINT FK_PREFERENCEVALUE_FPARENT_FKEY FOREIGN KEY (FPARENT_FKEY) REFERENCES PREFERENCE (FKEY)
ALTER TABLE SEARCHCONDITION ADD CONSTRAINT FK_SEARCHCONDITION_FSEARCHMARK_FID FOREIGN KEY (FSEARCHMARK_FID) REFERENCES MARK (FID)
ALTER TABLE MARK ADD CONSTRAINT FK_MARK_FFOLDER_FID FOREIGN KEY (FFOLDER_FID) REFERENCES FOLDER (FID)
ALTER TABLE FOLDER ADD CONSTRAINT FK_FOLDER_FPARENT_FID FOREIGN KEY (FPARENT_FID) REFERENCES FOLDER (FID)
ALTER TABLE CATEGORY ADD CONSTRAINT FK_CATEGORY_FFEEDPARENT_FID FOREIGN KEY (FFEEDPARENT_FID) REFERENCES FEED (FID)
ALTER TABLE CATEGORY ADD CONSTRAINT FK_CATEGORY_FNEWSPARENT_FID FOREIGN KEY (FNEWSPARENT_FID) REFERENCES NEWS (FID)