mirror of
https://github.com/kamailio/kamailio
synced 2026-08-07 16:32:08 -04:00
23 lines
924 B
SQL
23 lines
924 B
SQL
CREATE TABLE uacreg (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
l_uuid VARCHAR(64) DEFAULT '' NOT NULL,
|
|
l_username VARCHAR(64) DEFAULT '' NOT NULL,
|
|
l_domain VARCHAR(64) DEFAULT '' NOT NULL,
|
|
r_username VARCHAR(64) DEFAULT '' NOT NULL,
|
|
r_domain VARCHAR(64) DEFAULT '' NOT NULL,
|
|
realm VARCHAR(64) DEFAULT '' NOT NULL,
|
|
auth_username VARCHAR(64) DEFAULT '' NOT NULL,
|
|
auth_password VARCHAR(64) DEFAULT '' NOT NULL,
|
|
auth_ha1 VARCHAR(128) DEFAULT '' NOT NULL,
|
|
auth_proxy VARCHAR(255) DEFAULT '' NOT NULL,
|
|
expires INTEGER DEFAULT 0 NOT NULL,
|
|
flags INTEGER DEFAULT 0 NOT NULL,
|
|
reg_delay INTEGER DEFAULT 0 NOT NULL,
|
|
contact_addr VARCHAR(255) DEFAULT '' NOT NULL,
|
|
contact_user VARCHAR(255) DEFAULT '' NOT NULL,
|
|
socket VARCHAR(128) DEFAULT '' NOT NULL,
|
|
CONSTRAINT uacreg_l_uuid_idx UNIQUE (l_uuid)
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('uacreg','6');
|
|
|