Mercurial > hg > freeDiameter
view doc/app_sip.sql @ 1532:64d0a145b041
Remove AVPs deprecated by 3GPP
Remove 3GPP AVPs that were in freeDiameter 1.4.0 and earlier,
marked with "Change-1.4.0:":
- ADC-Revalidation-Time (2801) Time removed in 3GPP TS 29.212 V12.1.0 (2013-06).
- PDG-Address (895) Address removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- PDG-Charging-Id (896) Unsigned32 removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WAG-Address (890) Address removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WAG-PLMN-Id (891) OctetString removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WLAN-Information (875) Grouped removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WLAN-Radio-Container (892) Grouped removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WLAN-Session-Id (1246) UTF8String removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WLAN-Technology (893) Unsigned32 removed in 3GPP TS 32.299 V12.6.0 (2014-09).
- WLAN-UE-Local-IPAddress (894) Address removed in 3GPP TS 32.299 V12.6.0 (2014-09).
Remove 3GPP AVPs only added recently (and not in a release):
- HeNB-BBF-FQDN (2803) UTF8String removed in 3GPP TS 29.212 V11.8.0 (2013-03).
- User-Data-Request-Type (627) removed in 3GPP TS 29.229 V6.5.0 (2005-06).
Remove WLAN-Information rule from Service-Information (873).
Consistency tweaks in "Change-1.4.0:" comments.
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Sat, 18 Apr 2020 17:31:05 +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 ;