Mercurial > hg > freeDiameter

comparison extensions/app_diameap/diameap.sql @ 449:c5e37091553a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Updated app_diameap documentation and diameap.sql script
author Souheil Ben Ayed <souheil@tera.ics.keio.ac.jp>
date Thu, 29 Jul 2010 14:07:30 +0900
parents 0c6e50a5291d
children
comparison
equal deleted inserted replaced
448:9493b8d8a35f 449:c5e37091553a
3 # DiamEAP extension # 3 # DiamEAP extension #
4 # Users Information Database schema # 4 # Users Information Database schema #
5 # # 5 # #
6 # # 6 # #
7 # # 7 # #
8 # MySQL command to load the scrip: # 8 # MySQL command to load the script: #
9 # mysql> mysql -u username -p password diameap_ui < diameap.sql # 9 # mysql> mysql -u username -p password diameap_ui < diameap.sql #
10 # # 10 # #
11 ######################################################################### 11 #########################################################################
12 12
13 CREATE TABLE IF NOT EXISTS `authz` ( 13 -- --------------------------------------------------------
14 `id` int(11) NOT NULL AUTO_INCREMENT, 14
15 `grp` int(11) NOT NULL, 15 --
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', 16 -- Table structure for table `authe`
17 `op` set('==','>','>=','<','<=','!=','~=','=+','+==','+>','+>=','+<','+<=','+!=','+~=','==+','>+','>=+','<+','<=+','!=+') NOT NULL DEFAULT '==', 17 --
18 `value` char(255) NOT NULL,
19 PRIMARY KEY (`id`)
20 );
21 18
22 CREATE TABLE IF NOT EXISTS `authe` ( 19 CREATE TABLE IF NOT EXISTS `authe` (
23 `id` int(11) NOT NULL AUTO_INCREMENT, 20 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `grp` int(11) NOT NULL, 21 `grp` int(11) NOT NULL,
25 `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', 22 `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',
26 `value` char(255) NOT NULL, 23 `value` char(255) NOT NULL,
27 PRIMARY KEY (`id`) 24 PRIMARY KEY (`id`)
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 CREATE TABLE IF NOT EXISTS `grp` ( 48 CREATE TABLE IF NOT EXISTS `grp` (
31 `id` int(11) NOT NULL AUTO_INCREMENT, 49 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `grp_name` char(255) NOT NULL, 50 `grp_name` char(255) NOT NULL,
33 `active` set('Y','N') NOT NULL DEFAULT 'Y', 51 `active` set('Y','N') NOT NULL DEFAULT 'Y',
34 PRIMARY KEY (`id`) 52 PRIMARY KEY (`id`)
35 ); 53 );
54
55 -- --------------------------------------------------------
56
57 --
58 -- Table structure for table `users`
59 --
36 60
37 CREATE TABLE IF NOT EXISTS `users` ( 61 CREATE TABLE IF NOT EXISTS `users` (
38 `id` int(11) NOT NULL AUTO_INCREMENT, 62 `id` int(11) NOT NULL AUTO_INCREMENT,
39 `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, 63 `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
40 `eapmethod` tinyint(3) unsigned NOT NULL DEFAULT '0', 64 `eapmethod` tinyint(3) unsigned NOT NULL DEFAULT '0',
42 `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL, 66 `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
43 `active` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y', 67 `active` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
44 PRIMARY KEY (`id`) 68 PRIMARY KEY (`id`)
45 ); 69 );
46 70
71 -- --------------------------------------------------------
72
73 --
74 -- Table structure for table `user_grp`
75 --
76
47 CREATE TABLE IF NOT EXISTS `user_grp` ( 77 CREATE TABLE IF NOT EXISTS `user_grp` (
48 `id` int(11) NOT NULL AUTO_INCREMENT, 78 `id` int(11) NOT NULL AUTO_INCREMENT,
49 `user` int(11) NOT NULL, 79 `user` int(11) NOT NULL,
50 `grp` int(11) NOT NULL, 80 `grp` int(11) NOT NULL,
51 PRIMARY KEY (`id`) 81 PRIMARY KEY (`id`)
"Welcome to our mercurial repository"