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
);