Subversion Repositories bacoAlunos

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2007 es 1 
 
2 
CREATE TABLE `user` (
3 
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
4 
   `nome` varchar(250) DEFAULT NULL,
5 
   `username` varchar(250),
6 
   `password` varchar(250),
7 
   `roles` varchar(250),
8 
   PRIMARY KEY  (`id`)
9 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10 
 
11 
 
12 
CREATE TABLE `pagina` (
13 
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
14 
   `nome` varchar(250) DEFAULT NULL,
15 
   PRIMARY KEY  (`id`)
16 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17 
 
18 
CREATE TABLE `seccao` (
19 
   `id` bigint(20) NOT NULL AUTO_INCREMENT,
20 
   `titulo` varchar(250) DEFAULT NULL,
21 
   `i` INTEGER,
22 
   `pagina_id` bigint(20) DEFAULT NULL,
23 
   PRIMARY KEY  (`id`),
24 
   KEY (pagina_id),
25 
   CONSTRAINT `fk1` FOREIGN KEY (`pagina_id`) REFERENCES `pagina` (`id`) ON DELETE CASCADE
26 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;