From 0003925549ea009bb0a99c225b5d1992ccd8e7af Mon Sep 17 00:00:00 2001 From: "David A. Madore" Date: Sun, 28 Aug 2011 01:14:40 +0200 Subject: Preliminary code to populate a PostgreSQL database with weblog entries. --- org/madore/damlengine/weblog-database.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 org/madore/damlengine/weblog-database.sql (limited to 'org/madore/damlengine/weblog-database.sql') diff --git a/org/madore/damlengine/weblog-database.sql b/org/madore/damlengine/weblog-database.sql new file mode 100644 index 0000000..ab4146d --- /dev/null +++ b/org/madore/damlengine/weblog-database.sql @@ -0,0 +1,20 @@ +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 +) ; +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 ) ; -- cgit v1.2.3