scipro/resources/db_update_scripts/db_update_20130125.sql
2013-01-25 12:41:34 +09:00

4 lines
297 B
SQL
Executable File

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;