Mercurial > hg > freeDiameter
view doc/app_sip.sql @ 1515:8430dabbc637
Add 3GPP TS 29.109 V15.0.0 (2017-06)
Add AVPs:
- GBA-UserSecSettings, OctetString, code 400, section 6.3.1.1
- Transaction-Identifier, OctetString, code 401, section 6.3.1.2
- NAF-Id, OctetString, code 402, section 6.3.1.3
- GAA-Service-Identifier, OctetString, code 403, section 6.3.1.4
- Key-ExpiryTime, Time, code 404, section 6.3.1.5
- ME-Key-Material, OctetString, code 405, section 6.3.1.6
- UICC-Key-Material, OctetString, code 406, section 6.3.1.7
- GBA-U-Awareness-Indicator, Enumerated, code 407, section 6.3.1.8
- BootstrapInfoCreationTime, Time, code 408, section 6.3.1.9
- GUSS-Timestamp, Time, code 409, section 6.3.1.10
- GBA-Type, Enumerated, code 410, section 6.3.1.11
- UE-Id, OctetString, code 411, section 6.3.1.12
- UE-Id-Type, Enumerated, code 412, section 6.3.1.13
- UICC-App-Label, OctetString, code 413, section 6.3.1.14
- UICC-ME, Enumerated, code 414, section 6.3.1.15
- Requested-Key-Lifetime, Time, code 415, section 6.3.1.16
- Private-Identity-Request, Enumerated, code 416, section 6.3.1.17
- GBA-Push-Info, OctetString, code 417, section 6.3.1.18
- NAF-SA-Identifier, OctetString, code 418, section 6.3.1.19
- Security-Feature-Request, OctetString, code 419, section 6.3.1.20
- Security-Feature-Response, OctetString, code 420, section 6.3.1.21
Note: 3GPP TS 29.109 table 6.1 row GBA_U-Awareness-Indicator (407)
has an underscore in the name (contrary to RFC 6733 section 4.1).
Fix: GBA_U-Awareness-Indicator (407) renamed to GBA-U-Awareness-Indicator (407).
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Thu, 09 Apr 2020 00:34:15 +1000 |
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 ;