SET TIME ZONE 0; CREATE TABLE entries ( id integer PRIMARY KEY , edate text NOT NULL , cdate timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP , mdate timestamp with time zone NOT NULL DEFAULT CURRENT_TIMESTAMP , lang text , title text , title_xml xml , content xml NOT NULL , sha1 text NOT NULL , do_single_page text ) ; CREATE INDEX entries_edate_key ON entries ( edate ) ; CREATE TABLE incat ( id integer NOT NULL , code text NOT NULL , FOREIGN KEY ( id ) REFERENCES entries ( id ) ON DELETE CASCADE ) ; CREATE INDEX incat_id_key ON incat ( id ) ; CREATE INDEX incat_code_key ON incat ( code ) ;