1CREATE TABLE subscriber (
2    id SERIAL PRIMARY KEY NOT NULL,
3    username VARCHAR(64) DEFAULT '' NOT NULL,
4    domain VARCHAR(64) DEFAULT '' NOT NULL,
5    password VARCHAR(64) DEFAULT '' NOT NULL,
6    ha1 VARCHAR(128) DEFAULT '' NOT NULL,
7    ha1b VARCHAR(128) DEFAULT '' NOT NULL,
8    CONSTRAINT subscriber_account_idx UNIQUE (username, domain)
9);
10
11CREATE INDEX subscriber_username_idx ON subscriber (username);
12
13INSERT INTO version (table_name, table_version) values ('subscriber','7');
14
15