/usr/share/kamailio/mysql/registrar-create.sql is in kamailio-mysql-modules 4.0.4-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 16 17 18 19 20 21 22 23 24 25 | INSERT INTO version (table_name, table_version) values ('aliases','6');
CREATE TABLE aliases (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
ruid VARCHAR(64) DEFAULT '' NOT NULL,
username VARCHAR(64) DEFAULT '' NOT NULL,
domain VARCHAR(64) DEFAULT NULL,
contact VARCHAR(255) DEFAULT '' NOT NULL,
received VARCHAR(128) DEFAULT NULL,
path VARCHAR(128) DEFAULT NULL,
expires DATETIME DEFAULT '2030-05-28 21:32:15' NOT NULL,
q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INT(11) DEFAULT 1 NOT NULL,
last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
flags INT(11) DEFAULT 0 NOT NULL,
cflags INT(11) DEFAULT 0 NOT NULL,
user_agent VARCHAR(255) DEFAULT '' NOT NULL,
socket VARCHAR(64) DEFAULT NULL,
methods INT(11) DEFAULT NULL,
instance VARCHAR(255) DEFAULT NULL,
reg_id INT(11) DEFAULT 0 NOT NULL,
CONSTRAINT ruid_idx UNIQUE (ruid)
) ENGINE=MyISAM;
CREATE INDEX alias_idx ON aliases (username, domain, contact);
|