iruz8Bya

1CREATE TABLE sections ( 
2section_id INT NOT NULL AUTO_INCREMENT, 
3PRIMARY KEY(section_id), 
4title VARCHAR(30), 
5created_at int(10) NOT NULL, 
6updated_at int(10) NOT NULL) 
7ENGINE=InnoDB; 
8
9CREATE TABLE pages ( 
10page_id INT NOT NULL AUTO_INCREMENT, 
11PRIMARY KEY(page_id), 
12section_idfk INT NOT NULL, 
13FOREIGN KEY(section_idfk) REFERENCES sections(section_id) 
14ON DELETE CASCADE 
15ON UPDATE CASCADE) 
16ENGINE=InnoDB;
17	
18DROP TABLE IF EXISTS `test`.`sections`;
19CREATE TABLE  `test`.`sections` (
20  `section_id` int(10) unsigned NOT NULL auto_increment,
21  `title` varchar(30) NOT NULL,
22  `created_at` int(10) unsigned NOT NULL,
23  `updated_at` int(10) unsigned NOT NULL,
24  PRIMARY KEY  (`section_id`)
25) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
26
27DROP TABLE IF EXISTS `test`.`pages`;
28CREATE TABLE  `test`.`pages` (
29  `page_id` int(10) unsigned NOT NULL auto_increment,
30  `section_idfk` int(10) unsigned NOT NULL,
31  PRIMARY KEY  (`page_id`),
32  KEY `section_idfk` (`section_idfk`),
33  CONSTRAINT `section_idfk` FOREIGN KEY (`section_idfk`) REFERENCES `sections` (`section_id`) ON DELETE CASCADE ON UPDATE CASCADE
34) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;