Subversion Repositories bacoAlunos

CREATE TABLE `user` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
   `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;