scipro/resources/db_update_scripts/db_update_20130125.sql

4 lines
297 B
MySQL
Raw Permalink Normal View History

2013-01-25 12:41:34 +09:00
ALTER TABLE NotificationData ADD COLUMN `request_id` bigint(20) DEFAULT NULL;
ALTER TABLE NotificationData ADD KEY `FK2DCAC3558D40D1B9` (`request_id`);
ALTER TABLE NotificationData ADD CONSTRAINT `FK2DCAC3558D40D1B9` FOREIGN KEY (`request_id`) REFERENCES `peer_request` (`id`) ON DELETE SET NULL;