# HG changeset patch
# User Sebastien Decugis <sdecugis@nict.go.jp>
# Date 1280362877 -32400
# Node ID 6cc66ddc5ec87c7a1a845f65ec55378177f2fb96
# Parent  45d7725a915c2f0e8d1f3ee06515a4d674eb4159
Fix table definition for app_diameap

diff -r 45d7725a915c -r 6cc66ddc5ec8 conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql
--- a/conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql	Wed Jul 28 18:57:32 2010 +0900
+++ b/conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql	Thu Jul 29 09:21:17 2010 +0900
@@ -4,49 +4,8 @@
 ## create database diameap;
 ## GRANT ALL PRIVILEGES ON diameap.* TO diameap@localhost;
 ## Bye
+# mysql -u diameap -p -D diameap < /home/aaa/src/freeDiameter/extensions/app_diameap/diameap.sql
 # mysql -u diameap -p -D diameap < /root/conf/freeDiameter/app_diameap.sql
 
-CREATE TABLE `auth` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `grp` int(11) NOT NULL,
-  `attrib` char(255) NOT NULL,
-  `operator` char(255) NOT NULL,
-  `value` char(255) NOT NULL,
-  PRIMARY KEY (`id`)
-);
-
-CREATE TABLE `authentication` (
-  `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',
-  `operator` set('=','==') NOT NULL DEFAULT '=',
-  `value` char(255) NOT NULL,
-  PRIMARY KEY (`id`)
-);
-
-CREATE TABLE `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`)
-);
-
-CREATE TABLE `user_grp` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `user` int(11) NOT NULL,
-  `grp` int(11) NOT NULL,
-  PRIMARY KEY (`id`)
-);
-
-CREATE TABLE `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`)
-);
-
 INSERT INTO users (username, eapmethod) values ( 'client@eap.testbed.aaa', 13 );