aboutsummaryrefslogtreecommitdiff
path: root/h-source/Examples/Tables/mysql
diff options
context:
space:
mode:
authorAntonio Gallo <tonicucoz@gmail.com>2011-05-08 15:23:09 +0000
committerAntonio Gallo <tonicucoz@gmail.com>2011-05-08 15:23:09 +0000
commit7fdac301801bc44f6fdb343187413bdfd2d5366c (patch)
tree5a18faacf0a20a781487a38cad1c305a49fe8951 /h-source/Examples/Tables/mysql
parent7b265a7d6c39266952538ce2a05a799dabc27151 (diff)
h-source:added the driver entry for 3g-cards
Diffstat (limited to 'h-source/Examples/Tables/mysql')
-rwxr-xr-xh-source/Examples/Tables/mysql/admin_session.txt52
-rwxr-xr-xh-source/Examples/Tables/mysql/reg_session.txt63
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
-);
-
-