/usr/share/opensips/mysql/usrloc-create.sql is in opensips-mysql-module 2.2.2-3.
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 | INSERT INTO version (table_name, table_version) values ('location','1011');
CREATE TABLE location (
contact_id BIGINT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
username CHAR(64) DEFAULT '' NOT NULL,
domain CHAR(64) DEFAULT NULL,
contact CHAR(255) DEFAULT '' NOT NULL,
received CHAR(128) DEFAULT NULL,
path CHAR(255) DEFAULT NULL,
expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL,
q FLOAT(10,2) DEFAULT 1.0 NOT NULL,
callid CHAR(255) DEFAULT 'Default-Call-ID' NOT NULL,
cseq INT(11) DEFAULT 13 NOT NULL,
last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL,
flags INT(11) DEFAULT 0 NOT NULL,
cflags CHAR(255) DEFAULT NULL,
user_agent CHAR(255) DEFAULT '' NOT NULL,
socket CHAR(64) DEFAULT NULL,
methods INT(11) DEFAULT NULL,
sip_instance CHAR(255) DEFAULT NULL,
attr CHAR(255) DEFAULT NULL,
CONSTRAINT account_contact_idx UNIQUE (username, domain, contact, callid)
) ENGINE=InnoDB;
|