Preliminary code to populate a PostgreSQL database with weblog entries.

1 files changed, 20 insertions, 0 deletions

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 ) ;