mirror of
https://github.com/kamailio/kamailio
synced 2026-08-07 16:32:08 -04:00
15 lines
601 B
SQL
15 lines
601 B
SQL
CREATE TABLE speed_dial (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
username VARCHAR(64) DEFAULT '' NOT NULL,
|
|
domain VARCHAR(64) DEFAULT '' NOT NULL,
|
|
sd_username VARCHAR(64) DEFAULT '' NOT NULL,
|
|
sd_domain VARCHAR(64) DEFAULT '' NOT NULL,
|
|
new_uri VARCHAR(255) DEFAULT '' NOT NULL,
|
|
fname VARCHAR(64) DEFAULT '' NOT NULL,
|
|
lname VARCHAR(64) DEFAULT '' NOT NULL,
|
|
description VARCHAR(64) DEFAULT '' NOT NULL,
|
|
CONSTRAINT speed_dial_speed_dial_idx UNIQUE (username, domain, sd_domain, sd_username)
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('speed_dial','2');
|
|
|