Navigation

Changeset 8:6cc66ddc5ec8 in VirtualTestbed


Ignore:
Timestamp:
Jul 29, 2010, 9:21:17 AM (14 years ago)
Author:
Sebastien Decugis <sdecugis@nict.go.jp>
Branch:
default
Phase:
public
Message:

Fix table definition for app_diameap

File:
1 edited

Legend:

Unmodified
Added
Removed

  • conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql

    r7 r8  
    55## GRANT ALL PRIVILEGES ON diameap.* TO diameap@localhost;
    66## Bye
     7# mysql -u diameap -p -D diameap < /home/aaa/src/freeDiameter/extensions/app_diameap/diameap.sql
    78# mysql -u diameap -p -D diameap < /root/conf/freeDiameter/app_diameap.sql
    8 
    9 CREATE TABLE `auth` (
    10   `id` int(11) NOT NULL AUTO_INCREMENT,
    11   `grp` int(11) NOT NULL,
    12   `attrib` char(255) NOT NULL,
    13   `operator` char(255) NOT NULL,
    14   `value` char(255) NOT NULL,
    15   PRIMARY KEY (`id`)
    16 );
    17 
    18 CREATE TABLE `authentication` (
    19   `id` int(11) NOT NULL AUTO_INCREMENT,
    20   `grp` int(11) NOT NULL,
    21   `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   `operator` set('=','==') NOT NULL DEFAULT '=',
    23   `value` char(255) NOT NULL,
    24   PRIMARY KEY (`id`)
    25 );
    26 
    27 CREATE TABLE `grp` (
    28   `id` int(11) NOT NULL AUTO_INCREMENT,
    29   `grp_name` char(255) NOT NULL,
    30   `active` set('Y','N') NOT NULL DEFAULT 'Y',
    31   PRIMARY KEY (`id`)
    32 );
    33 
    34 CREATE TABLE `user_grp` (
    35   `id` int(11) NOT NULL AUTO_INCREMENT,
    36   `user` int(11) NOT NULL,
    37   `grp` int(11) NOT NULL,
    38   PRIMARY KEY (`id`)
    39 );
    40 
    41 CREATE TABLE `users` (
    42   `id` int(11) NOT NULL AUTO_INCREMENT,
    43   `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
    44   `eapmethod` tinyint(3) unsigned NOT NULL DEFAULT '0',
    45   `vendor` int(11) NOT NULL DEFAULT '0',
    46   `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
    47   `active` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
    48   PRIMARY KEY (`id`)
    49 );
    509
    5110INSERT INTO users (username, eapmethod) values ( 'client@eap.testbed.aaa', 13 );
Note: See TracChangeset for help on using the changeset viewer.