Changeset 449:c5e37091553a in freeDiameter for extensions/app_diameap/diameap.sql
- Timestamp:
- Jul 29, 2010, 2:07:30 PM (14 years ago)
- Branch:
- default
- Phase:
- public
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/app_diameap/diameap.sql
r425 r449 6 6 # # 7 7 # # 8 # MySQL command to load the scrip : #8 # MySQL command to load the script: # 9 9 # mysql> mysql -u username -p password diameap_ui < diameap.sql # 10 10 # # 11 11 ######################################################################### 12 12 13 CREATE TABLE IF NOT EXISTS `authz` ( 14 `id` int(11) NOT NULL AUTO_INCREMENT, 15 `grp` int(11) NOT NULL, 16 `attribute` set('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', 17 `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', 18 `value` char(255) NOT NULL, 19 PRIMARY KEY (`id`) 20 ); 13 -- -------------------------------------------------------- 14 15 -- 16 -- Table structure for table `authe` 17 -- 21 18 22 19 CREATE TABLE IF NOT EXISTS `authe` ( … … 28 25 ); 29 26 27 -- -------------------------------------------------------- 28 29 -- 30 -- Table structure for table `authz` 31 -- 32 33 CREATE TABLE IF NOT EXISTS `authz` ( 34 `id` int(11) NOT NULL AUTO_INCREMENT, 35 `grp` int(11) NOT NULL, 36 `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', 37 `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', 38 `value` char(255) NOT NULL, 39 PRIMARY KEY (`id`) 40 ); 41 42 -- -------------------------------------------------------- 43 44 -- 45 -- Table structure for table `grp` 46 -- 47 30 48 CREATE TABLE IF NOT EXISTS `grp` ( 31 49 `id` int(11) NOT NULL AUTO_INCREMENT, … … 34 52 PRIMARY KEY (`id`) 35 53 ); 54 55 -- -------------------------------------------------------- 56 57 -- 58 -- Table structure for table `users` 59 -- 36 60 37 61 CREATE TABLE IF NOT EXISTS `users` ( … … 45 69 ); 46 70 71 -- -------------------------------------------------------- 72 73 -- 74 -- Table structure for table `user_grp` 75 -- 76 47 77 CREATE TABLE IF NOT EXISTS `user_grp` ( 48 78 `id` int(11) NOT NULL AUTO_INCREMENT,
Note: See TracChangeset
for help on using the changeset viewer.