mirror of
https://github.com/kamailio/kamailio
synced 2026-08-07 16:32:08 -04:00
43 lines
1.3 KiB
SQL
43 lines
1.3 KiB
SQL
CREATE TABLE dr_gateways (
|
|
gwid INTEGER PRIMARY KEY NOT NULL,
|
|
type INTEGER DEFAULT 0 NOT NULL,
|
|
address VARCHAR(128) NOT NULL,
|
|
strip INTEGER DEFAULT 0 NOT NULL,
|
|
pri_prefix VARCHAR(64) DEFAULT NULL,
|
|
attrs VARCHAR(255) DEFAULT NULL,
|
|
description VARCHAR(128) DEFAULT '' NOT NULL
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('dr_gateways','3');
|
|
|
|
CREATE TABLE dr_rules (
|
|
ruleid INTEGER PRIMARY KEY NOT NULL,
|
|
groupid VARCHAR(255) NOT NULL,
|
|
prefix VARCHAR(64) NOT NULL,
|
|
timerec VARCHAR(255) NOT NULL,
|
|
priority INTEGER DEFAULT 0 NOT NULL,
|
|
routeid VARCHAR(64) NOT NULL,
|
|
gwlist VARCHAR(255) NOT NULL,
|
|
description VARCHAR(128) DEFAULT '' NOT NULL
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('dr_rules','3');
|
|
|
|
CREATE TABLE dr_gw_lists (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
gwlist VARCHAR(255) NOT NULL,
|
|
description VARCHAR(128) DEFAULT '' NOT NULL
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('dr_gw_lists','1');
|
|
|
|
CREATE TABLE dr_groups (
|
|
id INTEGER PRIMARY KEY NOT NULL,
|
|
username VARCHAR(64) NOT NULL,
|
|
domain VARCHAR(128) DEFAULT '' NOT NULL,
|
|
groupid INTEGER DEFAULT 0 NOT NULL,
|
|
description VARCHAR(128) DEFAULT '' NOT NULL
|
|
);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('dr_groups','2');
|
|
|