# aptitude install mysql-server mysql-client libmysqlclient-dev
# mysql -u root -p
## create user diameap@localhost identified by 'eapdiam';
## create database diameap;
## GRANT ALL PRIVILEGES ON diameap.* TO diameap@localhost;
## Bye
# 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 );