Thanks for the reply.
I will use the Ion Auth for the project. Thanks a lot!
I will use postgreSQL database, here is the model for test purposes.
CREATE TABLE "users" (
"id" SERIAL NOT NULL,
"group_id" int4 NOT NULL,
"ip_address" char(16) NOT NULL,
"username" varchar(15) NOT NULL,
"password" varchar(40) NOT NULL,
"email" varchar(40) NOT NULL,
"activation_code" varchar(40),
"forgotten_password_code" varchar(40),
"active" int4,
PRIMARY KEY("id"),
CONSTRAINT "check_id" CHECK(id >= 0),
CONSTRAINT "check_group_id" CHECK(group_id >= 0),
CONSTRAINT "check_active" CHECK(active >= 0)
);
CREATE TABLE "meta" (
"id" SERIAL NOT NULL,
"user_id" int4,
"first_name" varchar(50),
"last_name" varchar(50),
"company" varchar(100),
"phone" varchar(20),
PRIMARY KEY("id"),
CONSTRAINT "check_id" CHECK(id >= 0),
CONSTRAINT "check_user_id" CHECK(user_id >= 0)
);
CREATE TABLE "groups" (
"id" SERIAL NOT NULL,
"name" varchar(20) NOT NULL,
"description" varchar(100) NOT NULL,
PRIMARY KEY("id"),
CONSTRAINT "check_id" CHECK(id >= 0)
);
INSERT INTO groups (id, name, description) VALUES
(1,'admin','Administrator'),
(2,'members','General User');
INSERT INTO meta (id, user_id, first_name, last_name, company, phone) VALUES
('1','1','Admin','istrator','ADMIN','0');
INSERT INTO users (id, group_id, ip_address, username, password, email, activation_code, forgotten_password_code, active) VALUES
('1','1','127.0.0.1','administrator','59beecdf7fc966e2f17fd8f65a4a9aeb09d4a3d4','admin@admin.com','',NULL,'1');
In the project I will not use postgreSQL sequences(same as auto increment of MySQL). I will use triggers instead.
Here to share.
Best Regards,
