Mercurial > hg > freeDiameter
view doc/app_sip.sql @ 1490:48a552fbb1aa
Add 3GPP TS 29.338 V15.1.0 (2018-12)
Add AVPs from 3GPP TS 29.338:
- SM-RP-MTI, Enumerated, code 3308, section 5.3.3.2
- SM-RP-SMEA, OctetString, code 3309, section 5.3.3.3
- SRR-Flags, Unsigned32, code 3310, section 5.3.3.4
- SM-Delivery-Not-Intended, Enumerated, code 3311, section 5.3.3.5
- MWD-Status, Unsigned32, code 3312, section 5.3.3.8
- MME-Absent-User-Diagnostic-SM, Unsigned32, code 3313, section 5.3.3.9
- MSC-Absent-User-Diagnostic-SM, Unsigned32, code 3314, section 5.3.3.10
- SGSN-Absent-User-Diagnostic-SM, Unsigned32, code 3315, section 5.3.3.11
- SM-Delivery-Outcome, Grouped, code 3316, section 5.3.3.14
- MME-SM-Delivery-Outcome, Grouped, code 3317, section 5.3.3.15
- MSC-SM-Delivery-Outcome, Grouped, code 3318, section 5.3.3.16
- SGSN-SM-Delivery-Outcome, Grouped, code 3319, section 5.3.3.17
- IP-SM-GW-SM-Delivery-Outcome, Grouped, code 3320, section 5.3.3.18
- SM-Delivery-Cause, Enumerated, code 3321, section 5.3.3.19
- Absent-User-Diagnostic-SM, Unsigned32, code 3322, section 5.3.3.20
- RDR-Flags, Unsigned32, code 3323, section 5.3.3.21
- Maximum-UE-Availability-Time, Time, code 3329, section 5.3.3.22
- SMS-GMSC-Alert-Event, Unsigned32, code 3333, section 5.3.3.23
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Mon, 30 Mar 2020 10:13:31 +1100 |
parents | 533188d2e6cc |
children |
line wrap: on
line source
--Can be used in phpMyAdmin SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- DIAMETER SERVER DATABASE -- -- -------------------------------------------------------- -- -- Table structure for table `ds_data_types` -- CREATE TABLE IF NOT EXISTS `ds_data_types` ( `id_data_type` int(11) NOT NULL AUTO_INCREMENT, `label_type` varchar(255) NOT NULL, PRIMARY KEY (`id_data_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_networks` -- CREATE TABLE IF NOT EXISTS `ds_networks` ( `id_network` int(11) NOT NULL AUTO_INCREMENT, `label_network` varchar(255) NOT NULL, PRIMARY KEY (`id_network`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_sip_aor` -- CREATE TABLE IF NOT EXISTS `ds_sip_aor` ( `id_sip_aor` int(11) NOT NULL AUTO_INCREMENT, `id_user` int(11) NOT NULL, `sip_aor` varchar(255) NOT NULL, `sip_server_uri` varchar(255) DEFAULT NULL, `registered` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_sip_aor`,`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_sip_services` -- CREATE TABLE IF NOT EXISTS `ds_sip_services` ( `id_service` int(11) NOT NULL AUTO_INCREMENT, `label_service` varchar(255) NOT NULL, PRIMARY KEY (`id_service`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_users` -- CREATE TABLE IF NOT EXISTS `ds_users` ( `id_user` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `SIP_Server_URI` varchar(255) DEFAULT NULL, `temp_SIP_Server_URI` varchar(255) DEFAULT NULL, `authentication_pending` tinyint(1) NOT NULL DEFAULT '0', `registrated` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_user`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_user_data` -- CREATE TABLE IF NOT EXISTS `ds_user_data` ( `id_user_data` int(11) NOT NULL AUTO_INCREMENT, `id_sip_aor` int(11) NOT NULL, `id_data_type` int(11) NOT NULL, `data` longblob NOT NULL, PRIMARY KEY (`id_user_data`,`id_sip_aor`,`id_data_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_user_networks` -- CREATE TABLE IF NOT EXISTS `ds_user_networks` ( `id_user_network` int(11) NOT NULL AUTO_INCREMENT, `id_user` int(11) NOT NULL, `id_network` int(11) NOT NULL, PRIMARY KEY (`id_user_network`,`id_user`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `ds_user_services` -- CREATE TABLE IF NOT EXISTS `ds_user_services` ( `id_user_service` int(11) NOT NULL AUTO_INCREMENT, `id_user` int(11) NOT NULL, `id_service` int(11) NOT NULL, `compulsory` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_user_service`,`id_user`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;