annotate doc/app_sip_SL.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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
432
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
1
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
2
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
4
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
5 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
6 -- SUBSCRIBER LOCATOR DATABASE
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
7 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
8
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
9 -- --------------------------------------------------------
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
10
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
11 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
12 -- Table structure for table `ds_sip_aor_map`
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
13 --
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
14
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
15 CREATE TABLE IF NOT EXISTS `ds_sip_aor_map` (
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
16 `id_map` int(11) NOT NULL AUTO_INCREMENT,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
17 `sip_aor` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
18 `diameter_uri` varchar(255) NOT NULL,
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
19 PRIMARY KEY (`id_map`)
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
20 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
533188d2e6cc Corrected bugs on SAR/SAA; added SQL files
Alexandre Westfahl <awestfahl@freediameter.net>
parents:
diff changeset
21
"Welcome to our mercurial repository"