· 9 years ago · Dec 19, 2016, 07:02 PM
1CREATE TABLE IF NOT EXISTS `ci_sessions` (
2 `id` varchar(128) NOT NULL,
3 `ip_address` varchar(45) NOT NULL,
4 `timestamp` int(10) unsigned DEFAULT 0 NOT NULL,
5 `data` blob NOT NULL,
6 KEY `ci_sessions_timestamp` (`timestamp`)
7);
8-- -------------------------------------------------------------------
9CREATE TABLE `usuario`
10( `id` INT NOT NULL AUTO_INCREMENT ,
11 `nome` VARCHAR(150) NOT NULL ,
12 `login` VARCHAR(80) NOT NULL ,
13 `email` VARCHAR(150) NOT NULL ,
14 `senha` VARCHAR(80) NOT NULL ,
15 `creado_em` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
16 `alterado_em` DATETIME on update CURRENT_TIMESTAMP NULL ,
17 PRIMARY KEY (`id`)
18) ENGINE = InnoDB;
19
20-- -----------------------------------------------------------------------------------------------