From 0003925549ea009bb0a99c225b5d1992ccd8e7af Mon Sep 17 00:00:00 2001
From: "David A. Madore" <david+git@madore.org>
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

