1dLexQ6M

1--
2-- Table structure for table `blocked_period_rooms`
3--
4
5CREATE TABLE IF NOT EXISTS `blocked_period_rooms` (
6  `id` int(11) NOT NULL AUTO_INCREMENT,
7  `blocked_period_id` int(11) NOT NULL,
8  `room_type_id` int(11) NOT NULL,
9  `quantity` int(11) NOT NULL,
10  PRIMARY KEY (`id`),
11  KEY `blocked_period_id` (`blocked_period_id`)
12) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
13
14--
15-- Constraints for table `blocked_period_rooms`
16--
17
18ALTER TABLE `blocked_period_rooms`
19  ADD CONSTRAINT `blocked_period_rooms_ibfk_1` FOREIGN KEY (`blocked_period_id`) REFERENCES `blocked_periods` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
20	
21ALTER TABLE `guest_ip_addresses`
22  ADD UNIQUE KEY `guest_id` (`guest_id`,`ipaddress`),
23  ADD KEY `for_foreignkey_of_guest` (`guest_id`);
24
25ALTER TABLE `guest_ip_addresses`
26  ADD CONSTRAINT `foreignkey_guest` FOREIGN KEY (`guest_id`) REFERENCES `guests` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;