-- 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 ('john','johns@example.com');
INSERT INTO alias (address,goto) VALUES ('john','johns@example2.com');
INSERT INTO alias (address,goto) VALUES ('john','johns@example3.com');

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