diff options
Diffstat (limited to 'h-source/Examples/Tables')
-rwxr-xr-x | h-source/Examples/Tables/mysql/admin_session.txt | 52 | ||||
-rwxr-xr-x | h-source/Examples/Tables/mysql/reg_session.txt | 63 |
2 files changed, 0 insertions, 115 deletions
diff --git a/h-source/Examples/Tables/mysql/admin_session.txt b/h-source/Examples/Tables/mysql/admin_session.txt deleted file mode 100755 index 8e5f604..0000000 --- a/h-source/Examples/Tables/mysql/admin_session.txt +++ /dev/null @@ -1,52 +0,0 @@ -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 deleted file mode 100755 index f5c4713..0000000 --- a/h-source/Examples/Tables/mysql/reg_session.txt +++ /dev/null @@ -1,63 +0,0 @@ -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 -); - - |