1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
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
);
|
