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