mirror of
https://github.com/kamailio/kamailio
synced 2026-08-07 16:32:08 -04:00
28 lines
905 B
SQL
28 lines
905 B
SQL
CREATE TABLE uid_uri (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
uid VARCHAR(64) NOT NULL,
|
|
did VARCHAR(64) NOT NULL,
|
|
username VARCHAR(64) NOT NULL,
|
|
flags INTEGER DEFAULT 0 NOT NULL,
|
|
scheme VARCHAR(8) DEFAULT 'sip' NOT NULL
|
|
);
|
|
|
|
CREATE INDEX uid_uri_uri_idx1 ON uid_uri (username, did, scheme);
|
|
CREATE INDEX uid_uri_uri_uid ON uid_uri (uid);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('uid_uri','3');
|
|
|
|
CREATE TABLE uid_uri_attrs (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
username VARCHAR(64) NOT NULL,
|
|
did VARCHAR(64) NOT NULL,
|
|
name VARCHAR(32) NOT NULL,
|
|
value VARCHAR(128),
|
|
type INTEGER DEFAULT 0 NOT NULL,
|
|
flags INTEGER DEFAULT 0 NOT NULL,
|
|
scheme VARCHAR(8) DEFAULT 'sip' NOT NULL,
|
|
CONSTRAINT uid_uri_attrs_uriattrs_idx UNIQUE (username, did, name, value, scheme)
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('uid_uri_attrs','2');
|
|
|