Mercurial > hg > fD-testbed

annotate conf/backend.eap.testbed.aaa/freeDiameter/app_diameap.sql @ 7:45d7725a915c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prepared testbed configuration for app_diameap
author Sebastien Decugis <sdecugis@nict.go.jp>
date Wed, 28 Jul 2010 18:57:32 +0900
parents
children 6cc66ddc5ec8
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
7
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
1 # aptitude install mysql-server mysql-client libmysqlclient-dev
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
2 # mysql -u root -p
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
3 ## create user diameap@localhost identified by 'eapdiam';
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
4 ## create database diameap;
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
5 ## GRANT ALL PRIVILEGES ON diameap.* TO diameap@localhost;
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
6 ## Bye
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
7 # mysql -u diameap -p -D diameap < /root/conf/freeDiameter/app_diameap.sql
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
8
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
9 CREATE TABLE `auth` (
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
10 `id` int(11) NOT NULL AUTO_INCREMENT,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
11 `grp` int(11) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
12 `attrib` char(255) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
13 `operator` char(255) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
14 `value` char(255) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
15 PRIMARY KEY (`id`)
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
16 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
17
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
18 CREATE TABLE `authentication` (
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
19 `id` int(11) NOT NULL AUTO_INCREMENT,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
20 `grp` int(11) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
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',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
22 `operator` set('=','==') NOT NULL DEFAULT '=',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
23 `value` char(255) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
24 PRIMARY KEY (`id`)
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
25 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
26
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
27 CREATE TABLE `grp` (
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
28 `id` int(11) NOT NULL AUTO_INCREMENT,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
29 `grp_name` char(255) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
30 `active` set('Y','N') NOT NULL DEFAULT 'Y',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
31 PRIMARY KEY (`id`)
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
32 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
33
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
34 CREATE TABLE `user_grp` (
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
35 `id` int(11) NOT NULL AUTO_INCREMENT,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
36 `user` int(11) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
37 `grp` int(11) NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
38 PRIMARY KEY (`id`)
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
39 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
40
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
41 CREATE TABLE `users` (
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
42 `id` int(11) NOT NULL AUTO_INCREMENT,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
43 `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
44 `eapmethod` tinyint(3) unsigned NOT NULL DEFAULT '0',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
45 `vendor` int(11) NOT NULL DEFAULT '0',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
46 `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
47 `active` enum('Y','N') CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Y',
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
48 PRIMARY KEY (`id`)
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
49 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
50
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
51 INSERT INTO users (username, eapmethod) values ( 'client@eap.testbed.aaa', 13 );
45d7725a915c Prepared testbed configuration for app_diameap
Sebastien Decugis <sdecugis@nict.go.jp>
parents:
diff changeset
52
"Welcome to our mercurial repository"