Mercurial > hg > fD-testbed
changeset 8:6cc66ddc5ec8
Fix table definition for app_diameap
author | Sebastien Decugis <sdecugis@nict.go.jp> |
---|---|
date | Thu, 29 Jul 2010 09:21:17 +0900 |
parents | 45d7725a915c |
children | 6400e3613888 |
files | conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql |
diffstat | 1 files changed, 1 insertions(+), 42 deletions(-) [+] |
line wrap: on
line diff
--- 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 );