Mercurial > hg > freeDiameter
view doc/app_sip.sql @ 1514:8912a0645645
Add 3GPP TS 29.234 V11.2.0 (2013-06)
Add AVPs:
- 3GPP-WLAN-APN-Id, OctetString, code 100, section 10.1.15
- Authentication-Method, Enumerated, code 300, section 10.1.5
- Authentication-Information-SIM, OctetString, code 301, section 10.1.6
- Authorization-Information-SIM, OctetString, code 302, section 10.1.7
- WLAN-User-Data, Grouped, code 303, section 10.1.8
- Charging-Data, Grouped, code 304, section 10.1.10
- WLAN-Access, Enumerated, code 305, section 10.1.11
- WLAN-3GPP-IP-Access, Enumerated, code 306, section 10.1.12
- APN-Authorized, Grouped, code 307, section 10.1.14
- APN-Barring-Type, Enumerated, code 309, section 10.1.16
- WLAN-Direct-IP-Access, Enumerated, code 310, section 10.1.17
- Session-Request-Type, Enumerated, code 311, section 10.1.23
- Routing-Policy, IPFilterRule, code 312, section 10.1.24
- Max-Requested-Bandwidth, OctetString, code 313, section 10.1.26
- Charging-Characteristics, Integer32, code 314, section 10.1.27
- Charging-Nodes, Grouped, code 315, section 10.1.28
- Primary-OCS-Charging-Function-Name, DiameterIdentity, code 316, section 10.1.29
- Secondary-OCS-Charging-Function-Name, DiameterIdentity, code 317, section 10.1.30
- Maximum-Number-Accesses, Unsigned32, code 319, section 10.1.38
APN-Id (308) OctetString only present from
3GPP TS 29.234 V6.2.0 (2005-03) to 3GPP TS 29.234 V6.4.0 (2005-09)
before being deprecated in 3GPP TS 29.234 V6.5.0 (2005-12).
(Not provided here.)
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Wed, 08 Apr 2020 15:48:08 +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 ;