Subversion Repositories bacoAlunos

Rev

Rev 2005 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

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