From 232aa1924c8c0f10d87b210b46c9f061af5c844c Mon Sep 17 00:00:00 2001
From: Antonio Gallo <tonicucoz@gmail.com>
Date: Sun, 17 Oct 2010 13:29:57 +0000
Subject: added files

---
 h-source/Examples/Tables/mysql/admin_session.txt | 52 +++++++++++++++++++
 h-source/Examples/Tables/mysql/reg_session.txt   | 63 ++++++++++++++++++++++++
 2 files changed, 115 insertions(+)
 create mode 100755 h-source/Examples/Tables/mysql/admin_session.txt
 create mode 100755 h-source/Examples/Tables/mysql/reg_session.txt

(limited to 'h-source/Examples/Tables/mysql')

diff --git a/h-source/Examples/Tables/mysql/admin_session.txt b/h-source/Examples/Tables/mysql/admin_session.txt
new file mode 100755
index 0000000..8e5f604
--- /dev/null
+++ b/h-source/Examples/Tables/mysql/admin_session.txt
@@ -0,0 +1,52 @@
+tables:
+
+#default admin session tables
+
+create table adminusers (
+   id_user INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+   username VARCHAR(80) binary NOT NULL,
+   password CHAR(40) binary NOT NULL,
+   last_failure INT UNSIGNED NOT NULL,
+   has_confirmed INT UNSIGNED NOT NULL,
+   unique(username),
+   index(username, password)
+)engine=innodb;
+
+create table admingroups (
+	id_group INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(30) binary NOT NULL,
+	unique(name)
+)engine=innodb;
+
+create table adminusers_groups (
+	id_user int(11) UNSIGNED not null,
+	id_group int(11) UNSIGNED not null,
+	index group_indx(id_group),
+	index user_indx(id_user),
+	foreign key group_fky(id_group) references admingroups (id_group),
+	foreign key user_fky(id_user) references adminusers (id_user),
+	unique (id_group,id_user)
+)engine=innodb;
+
+
+insert into adminusers (username,password) values ('admin',sha1('admin'));
+
+
+CREATE TABLE adminsessions (
+   uid CHAR(32) NOT NULL,
+   token CHAR(32) NOT NULL,
+   id_user INT UNSIGNED NOT NULL,
+   creation_date INT UNSIGNED NOT NULL,
+   user_agent CHAR(32) NOT NULL,
+   INDEX(uid)
+)engine=innodb;
+
+
+create table accesses (
+	id int(12) not null auto_increment primary key,
+	ip char(20) not null,data char(10) not null,
+	ora char(8) not null,
+	username varchar(30) not null
+);
+
+
diff --git a/h-source/Examples/Tables/mysql/reg_session.txt b/h-source/Examples/Tables/mysql/reg_session.txt
new file mode 100755
index 0000000..f5c4713
--- /dev/null
+++ b/h-source/Examples/Tables/mysql/reg_session.txt
@@ -0,0 +1,63 @@
+tables:
+
+#default registered session tables
+
+create table regusers (
+	id_user INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	username VARCHAR(80) binary NOT NULL,
+	password CHAR(40) binary NOT NULL,
+	last_failure INT UNSIGNED NOT NULL,
+	has_confirmed INT UNSIGNED NOT NULL,
+	
+	e_mail VARCHAR(60) binary NOT NULL,
+	confirmation_token CHAR(32) NOT NULL,
+	creation_date timestamp default CURRENT_TIMESTAMP,
+	creation_time INT UNSIGNED NOT NULL,
+	temp_field CHAR(32) NOT NULL,
+	deleted CHAR(4) NOT NULL default 'no',
+	
+	forgot_token CHAR(32) NOT NULL,
+	forgot_time INT UNSIGNED NOT NULL,  
+					   
+	unique(username),
+	index(username, password)
+)engine=innodb;
+
+create table reggroups (
+	id_group INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+	name VARCHAR(30) binary NOT NULL,
+	unique(name)
+)engine=innodb;
+
+create table regusers_groups (
+	id_user int(11) UNSIGNED not null,
+	id_group int(11) UNSIGNED not null,
+	index group_indx(id_group),
+	index user_indx(id_user),
+	foreign key group_fky(id_group) references reggroups (id_group),
+	foreign key user_fky(id_user) references regusers (id_user),
+	unique (id_group,id_user)
+)engine=innodb;
+
+
+insert into regusers (username,password) values ('user',sha1('user'));
+
+
+CREATE TABLE regsessions (
+   uid CHAR(32) NOT NULL,
+   token CHAR(32) NOT NULL,
+   id_user INT UNSIGNED NOT NULL,
+   creation_date INT UNSIGNED NOT NULL,
+   user_agent CHAR(32) NOT NULL,
+   INDEX(uid)
+)engine=innodb;
+
+
+create table regaccesses (
+	id int(12) not null auto_increment primary key,
+	ip char(20) not null,data char(10) not null,
+	ora char(8) not null,
+	username varchar(30) not null
+);
+
+
-- 
cgit v1.2.3