/usr/share/kamailio/postgres/auth_db-create.sql is in kamailio-postgres-modules 5.1.2-1ubuntu2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | CREATE TABLE subscriber (
id SERIAL PRIMARY KEY NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
domain VARCHAR(64) DEFAULT '' NOT NULL,
password VARCHAR(64) DEFAULT '' NOT NULL,
ha1 VARCHAR(128) DEFAULT '' NOT NULL,
ha1b VARCHAR(128) DEFAULT '' NOT NULL,
email_address VARCHAR(128) DEFAULT NULL,
rpid VARCHAR(128) DEFAULT NULL,
CONSTRAINT subscriber_account_idx UNIQUE (username, domain)
);
CREATE INDEX subscriber_username_idx ON subscriber (username);
INSERT INTO version (table_name, table_version) values ('subscriber','7');
|