mirror of https://github.com/sipwise/kamailio.git
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
54 lines
2.1 KiB
54 lines
2.1 KiB
CREATE TABLE `pcscf_location` (
|
|
`id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
|
|
`domain` VARCHAR(64) NOT NULL,
|
|
`aor` VARCHAR(255) NOT NULL,
|
|
`host` VARCHAR(100) NOT NULL,
|
|
`port` INT(10) NOT NULL,
|
|
`received` VARCHAR(128) DEFAULT NULL,
|
|
`received_port` INT(10) UNSIGNED DEFAULT NULL,
|
|
`received_proto` INT(10) UNSIGNED DEFAULT NULL,
|
|
`path` VARCHAR(512) DEFAULT NULL,
|
|
`rinstance` VARCHAR(255) DEFAULT NULL,
|
|
`rx_session_id` VARCHAR(256) DEFAULT NULL,
|
|
`reg_state` TINYINT(4) DEFAULT NULL,
|
|
`expires` DATETIME DEFAULT '2030-05-28 21:32:15',
|
|
`service_routes` VARCHAR(2048) DEFAULT NULL,
|
|
`socket` VARCHAR(64) DEFAULT NULL,
|
|
`public_ids` VARCHAR(2048) DEFAULT NULL,
|
|
`security_type` INT(11) DEFAULT NULL,
|
|
`protocol` VARCHAR(5) DEFAULT NULL,
|
|
`mode` VARCHAR(10) DEFAULT NULL,
|
|
`ck` VARCHAR(100) DEFAULT NULL,
|
|
`ik` VARCHAR(100) DEFAULT NULL,
|
|
`ealg` VARCHAR(20) DEFAULT NULL,
|
|
`ialg` VARCHAR(20) DEFAULT NULL,
|
|
`port_pc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`port_ps` INT(11) UNSIGNED DEFAULT NULL,
|
|
`port_uc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`port_us` INT(11) UNSIGNED DEFAULT NULL,
|
|
`spi_pc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`spi_ps` INT(11) UNSIGNED DEFAULT NULL,
|
|
`spi_uc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`spi_us` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_security_type` INT(11) DEFAULT NULL,
|
|
`t_protocol` VARCHAR(5) DEFAULT NULL,
|
|
`t_mode` VARCHAR(10) DEFAULT NULL,
|
|
`t_ck` VARCHAR(100) DEFAULT NULL,
|
|
`t_ik` VARCHAR(100) DEFAULT NULL,
|
|
`t_ealg` VARCHAR(20) DEFAULT NULL,
|
|
`t_ialg` VARCHAR(20) DEFAULT NULL,
|
|
`t_port_pc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_port_ps` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_port_uc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_port_us` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_spi_pc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_spi_ps` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_spi_uc` INT(11) UNSIGNED DEFAULT NULL,
|
|
`t_spi_us` INT(11) UNSIGNED DEFAULT NULL
|
|
);
|
|
|
|
CREATE INDEX aor_idx ON pcscf_location (`aor`);
|
|
|
|
INSERT INTO version (table_name, table_version) values ('pcscf_location','7');
|
|
|