Mercurial > hg > freeDiameter
annotate doc/app_sip_SL.sql @ 1502:515421a9ac5e
Add 3GPP TS 29.154 V15.3.0 (2019-09)
Add AVPs:
- Network-Area-Info-List, OctetString, code 4201, section 5.3.2
- Number-Of-UEs, Unsigned32, code 4209, section 5.3.10
- Reference-Id, OctetString, code 4202, section 5.3.3
- Transfer-Request-Type, Unsigned32, code 4203, section 5.3.4
- Time-Window, Grouped, code 4204, section 5.3.5
- Transfer-End-Time, Time, code 4205, section 5.3.6
- Transfer-Policy, Grouped, code 4207, section 5.3.8
- Transfer-Policy-Id, Unsigned32, code 4208, section 5.3.9
- Transfer-Start-Time, Time, code 4206, section 5.3.7
- Access-Network-Reports, Grouped, code 4210, section A.6.3.2
- Event-Configuration, Grouped, code 4211, section A.6.3.3
- Event-Configuration-State, Unsigned32, code 4212, section A.6.3.4
- Event-Configuration-Status, Grouped, code 4213, section A.6.3.5
- Event-Reporting-Results, Unsigned32, code 4214, section A.6.3.6
- Event-Reports, Grouped, code 4215, section A.6.3.7
- Extended-SCEF-Reference-ID, Unsigned64, code 4216, section A.6.3.8
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Fri, 03 Apr 2020 15:33:12 +1100 |
parents | 533188d2e6cc |
children |
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 |