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

);