
diff -r f907866f0e4b -r 6fceb66e1ad7 trunk/helpers/tbl_mysql6_tmpl.sql
--- a/trunk/helpers/tbl_mysql6_tmpl.sql	Tue Jan 20 10:21:03 2009 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,39 +0,0 @@
-CREATE DATABASE staroffice_news;
-
-CREATE TABLE groups 
-(
-  group_id      SERIAL,
-  name          VARCHAR(80) NOT NULL,
-  flags         INTEGER DEFAULT 0 NOT NULL
-);
-
-CREATE UNIQUE INDEX name_id_index ON groups (name);
-
-CREATE TABLE articles 
-(
-  article_id    SERIAL,
-  message_id    TEXT,
-  header        TEXT,
-  body          TEXT
-);
-
-CREATE UNIQUE INDEX article_message_index ON articles (message_id(255));
-
-CREATE TABLE postings 
-(
-  group_id      INTEGER,
-  article_id    INTEGER,
-  article_index INTEGER NOT NULL
-);
-
-CREATE UNIQUE INDEX posting_article_index ON postings (article_id);
-
-CREATE TABLE subscriptions 
-(
-  group_id    INTEGER
-);
-    
-CREATE TABLE overview 
-(
-  header      TEXT
-);




