/usr/share/opensips/postgres/registrar-create.sql is in opensips-postgres-module 2.2.2-3build4.
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 16 17 18 19 20 21 22 23 24 | INSERT INTO version (table_name, table_version) values ('aliases','1009');
CREATE TABLE aliases (
id SERIAL PRIMARY KEY NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
domain VARCHAR(64) DEFAULT '' NOT NULL,
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(255) DEFAULT NULL,
expires TIMESTAMP WITHOUT TIME ZONE DEFAULT '2020-05-28 21:32:15' NOT NULL,
q REAL DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INTEGER DEFAULT 13 NOT NULL,
last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '1900-01-01 00:00:01' NOT NULL,
flags INTEGER DEFAULT 0 NOT NULL,
cflags VARCHAR(255) DEFAULT NULL,
user_agent VARCHAR(255) DEFAULT '' NOT NULL,
socket VARCHAR(64) DEFAULT NULL,
methods INTEGER DEFAULT NULL,
sip_instance VARCHAR(255) DEFAULT NULL,
attr VARCHAR(255) DEFAULT NULL,
CONSTRAINT aliases_alias_idx UNIQUE (username, domain, contact, callid)
);
ALTER SEQUENCE aliases_id_seq MAXVALUE 2147483647 CYCLE;
|