/usr/share/kamailio/mysql/ims_dialog-create.sql is in kamailio-mysql-modules 5.1.2-1ubuntu2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | INSERT INTO version (table_name, table_version) values ('dialog_in', 7), ('dialog_out', 7), ('dialog_vars', 7);
CREATE TABLE `dialog_in` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hash_entry` int(10) unsigned NOT NULL,
`hash_id` int(10) unsigned NOT NULL,
`did` varchar(45) NOT NULL,
`callid` varchar(255) NOT NULL,
`from_uri` varchar(128) NOT NULL,
`from_tag` varchar(64) NOT NULL,
`caller_original_cseq` varchar(20) NOT NULL,
`req_uri` varchar(128) NOT NULL,
`caller_route_set` varchar(512) DEFAULT NULL,
`caller_contact` varchar(128) NOT NULL,
`caller_sock` varchar(64) NOT NULL,
`state` int(10) unsigned NOT NULL,
`start_time` int(10) unsigned NOT NULL,
`timeout` int(10) unsigned NOT NULL DEFAULT '0',
`sflags` int(10) unsigned NOT NULL DEFAULT '0',
`toroute_name` varchar(32) DEFAULT NULL,
`toroute_index` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `hash_idx` (`hash_entry`,`hash_id`)
);
CREATE TABLE `dialog_out` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hash_entry` int(11) NOT NULL,
`hash_id` int(11) NOT NULL,
`did` varchar(45) NOT NULL,
`to_uri` varchar(128) NOT NULL,
`to_tag` varchar(64) NOT NULL,
`caller_cseq` varchar(20) NOT NULL,
`callee_cseq` varchar(20) NOT NULL,
`callee_contact` varchar(128) NOT NULL,
`callee_route_set` varchar(512) DEFAULT NULL,
`callee_sock` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `dialog_vars` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hash_entry` int(10) unsigned NOT NULL,
`hash_id` int(10) unsigned NOT NULL,
`dialog_key` varchar(128) NOT NULL,
`dialog_value` varchar(512) NOT NULL,
PRIMARY KEY (`id`),
KEY `hash_idx` (`hash_entry`,`hash_id`)
);
|