Blame |
Last modification |
View Log
| RSS feed
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nome` varchar(250) DEFAULT NULL,
`username` varchar(250) DEFAULT NULL,
`password` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `pagina` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`nome` varchar(250) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `seccao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`titulo` varchar(250) DEFAULT NULL,
`i` INTEGER,
`pagina_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY (pagina_id),
CONSTRAINT `fk1` FOREIGN KEY (`pagina_id`) REFERENCES `pagina` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;