linux:core.sql

-- core tables

CREATE TABLE alias (
  alias_id serial PRIMARY KEY,
  address text NOT NULL,
  goto text NOT NULL
);
CREATE TABLE account (
  account_id serial primary key,
  username text NOT NULL,
  password text NOT NULL,
  maildir text NOT NULL default '/mail/new'
);
INSERT INTO alias (address,goto) VALUES ('biuro','kurs@czarny06.aklin');
INSERT INTO alias (address,goto) VALUES ('biuro','kurs@czarny04.aklin');
INSERT INTO alias (address,goto) VALUES ('biuro','kurs@czarny02.aklin');

INSERT INTO account (username,password,maildir) VALUES ('kurs','kurs','/mail/kurs');
INSERT INTO account (username,password,maildir) VALUES ('test','test','/mail/test');
INSERT INTO account (username,password,maildir) VALUES ('test1','test1','/mail/test1');