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