1.1 --- a/trunk/helpers/tbl_mysql6_tmpl.sql	Tue Jan 20 10:21:03 2009 +0100
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,39 +0,0 @@
     1.4 -CREATE DATABASE staroffice_news;
     1.5 -
     1.6 -CREATE TABLE groups 
     1.7 -(
     1.8 -  group_id      SERIAL,
     1.9 -  name          VARCHAR(80) NOT NULL,
    1.10 -  flags         INTEGER DEFAULT 0 NOT NULL
    1.11 -);
    1.12 -
    1.13 -CREATE UNIQUE INDEX name_id_index ON groups (name);
    1.14 -
    1.15 -CREATE TABLE articles 
    1.16 -(
    1.17 -  article_id    SERIAL,
    1.18 -  message_id    TEXT,
    1.19 -  header        TEXT,
    1.20 -  body          TEXT
    1.21 -);
    1.22 -
    1.23 -CREATE UNIQUE INDEX article_message_index ON articles (message_id(255));
    1.24 -
    1.25 -CREATE TABLE postings 
    1.26 -(
    1.27 -  group_id      INTEGER,
    1.28 -  article_id    INTEGER,
    1.29 -  article_index INTEGER NOT NULL
    1.30 -);
    1.31 -
    1.32 -CREATE UNIQUE INDEX posting_article_index ON postings (article_id);
    1.33 -
    1.34 -CREATE TABLE subscriptions 
    1.35 -(
    1.36 -  group_id    INTEGER
    1.37 -);
    1.38 -    
    1.39 -CREATE TABLE overview 
    1.40 -(
    1.41 -  header      TEXT
    1.42 -);