Mercurial > hg > freeDiameter
view extensions/app_diameap/diameap.sql @ 1512:f98e2b6e8f42
Add 3GPP TS 29.368 V15.1.0 (2019-09)
Add AVPs:
- Device-Action, Grouped, code 3001, section 6. 4.2
- Device-Notification, Grouped, code 3002, section 6.4.3
- Trigger-Data, Grouped, code 3003, section 6.4.4
- Payload, OctetString, code 3004, section 6.4.5
- Action-Type, Enumerated, code 3005, section 6.4.6
- Priority-Indication, Enumerated, code 3006, section 6.4.7
- Reference-Number, Unsigned32, code 3007, section 6.4.8
- Request-Status, Enumerated, code 3008, section 6.4.9
- Delivery-Outcome, Enumerated, code 3009, section 6.4.10
- Application-Port-Identifier, Unsigned32, code 3010, section 6.4.11
- Old-Reference-Number, Unsigned32, code 3011, section 6.4.12
- Feature-Supported-In-Final-Target, Unsigned32, code 3012, section 6.4.13
author | Luke Mewburn <luke@mewburn.net> |
---|---|
date | Tue, 07 Apr 2020 16:04:36 +1000 |
parents | c5e37091553a |
children |
line wrap: on
line source
######################################################################### # diameap.sql # # DiamEAP extension # # Users Information Database schema # # # # # # # # MySQL command to load the script: # # mysql> mysql -u username -p password diameap_ui < diameap.sql # # # ######################################################################### -- -------------------------------------------------------- -- -- Table structure for table `authe` -- CREATE TABLE IF NOT EXISTS `authe` ( `id` int(11) NOT NULL AUTO_INCREMENT, `grp` int(11) NOT NULL, `attribute` set('Authorization-Lifetime','Auth-Grace-Period','Auth-Session-State','Re-Auth-Request-Type','Session-Timeout','Multi-Round-Time-Out','Acct-Interim-Interval') NOT NULL DEFAULT 'Authorization-Lifetime', `value` char(255) NOT NULL, PRIMARY KEY (`id`) ); -- -------------------------------------------------------- -- -- Table structure for table `authz` -- CREATE TABLE IF NOT EXISTS `authz` ( `id` int(11) NOT NULL AUTO_INCREMENT, `grp` int(11) NOT NULL, `attribute` set('NAS-IPv6-Address','NAS-Identifier','NAS-IP-Address','NAS-Port','NAS-Port-Id','NAS-Port-Type','Called-Station-Id','Calling-Station-Id','Connect-Info','Originating-Line-Info','Service-Type','Callback-Number','Callback-Id','Idle-Timeout','Port-Limit','NAS-Filter-Rule','Filter-Id','Configuration-Token','QoS-Filter-Rule','Framed-Protocol','Framed-Routing','Framed-MTU','Framed-Compression','Framed-IP-Address','Framed-IP-Netmask','Framed-Route','Framed-Pool','Framed-Interface-Id','Framed-IPv6-Prefix','Framed-IPv6-Pool','Framed-IPv6-Route','Framed-IPX-Network','Framed-Appletalk-Link','Framed-Appletalk-Network','Framed-Appletalk-Zone') NOT NULL DEFAULT 'Service-Type', `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', `value` char(255) NOT NULL, PRIMARY KEY (`id`) ); -- -------------------------------------------------------- -- -- Table structure for table `grp` -- CREATE TABLE IF NOT EXISTS `grp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `grp_name` char(255) NOT NULL, `active` set('Y','N') NOT NULL DEFAULT 'Y', PRIMARY KEY (`id`) ); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `eapmethod` tinyint(3) unsigned NOT NULL DEFAULT '0', `vendor` int(11) NOT NULL DEFAULT '0', `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, `active` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y', PRIMARY KEY (`id`) ); -- -------------------------------------------------------- -- -- Table structure for table `user_grp` -- CREATE TABLE IF NOT EXISTS `user_grp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user` int(11) NOT NULL, `grp` int(11) NOT NULL, PRIMARY KEY (`id`) );