nW87uKSz

1-- -----------------------------------------------------
2-- Table `mydb`.`tbl_user`
3-- -----------------------------------------------------
4CREATE  TABLE IF NOT EXISTS `mydb`.`tbl_user` (
5  `user_id` INT NOT NULL AUTO_INCREMENT ,
6  `username` VARCHAR(200) NULL ,
7  `password` VARCHAR(200) NULL ,
8  `salt` VARCHAR(200) NULL ,
9  `info` VARCHAR(200) NULL ,
10  `date_created` DATETIME NULL ,
11  PRIMARY KEY (`user_id`) ,
12  UNIQUE INDEX `username_UNIQUE` (`username` ASC) )
13ENGINE = InnoDB;
14
15-- -----------------------------------------------------
16-- Table `mydb`.`tbl_session`
17-- -----------------------------------------------------
18CREATE  TABLE IF NOT EXISTS `mydb`.`tbl_session` (
19  `session_id` INT NOT NULL AUTO_INCREMENT ,
20  `user_id` VARCHAR(200) NULL ,
21  `data` VARCHAR(200) NULL ,
22  `info` VARCHAR(200) NULL ,
23  `date_created` DATETIME NULL ,
24  `date_expired` DATETIME NULL ,
25  PRIMARY KEY (`session_id`) ,
26  UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC) )
27ENGINE = InnoDB;
28
29-- -----------------------------------------------------
30-- Table `mydb`.`tbl_user_block`
31-- -----------------------------------------------------
32CREATE  TABLE IF NOT EXISTS `mydb`.`tbl_user_block` (
33  `block_id` INT NOT NULL AUTO_INCREMENT ,
34  `user_id` VARCHAR(45) NULL ,
35  `block` TINYINT NULL DEFAULT 0 ,
36  `login_number` TINYINT NULL DEFAULT 1 ,
37  `info` VARCHAR(200) NULL ,
38  `date_blocked` DATETIME NULL ,
39  PRIMARY KEY (`block_id`) ,
40  UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC) )
41ENGINE = InnoDB;