From a7189482e92556c33b5a320989faa97be98c82bc Mon Sep 17 00:00:00 2001 From: Philip Häusler Date: Sat, 15 Aug 2015 23:36:38 +0200 Subject: add shift creator and editor --- db/update.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'db') diff --git a/db/update.sql b/db/update.sql index 594969f9..3dbd613a 100644 --- a/db/update.sql +++ b/db/update.sql @@ -1,3 +1,16 @@ +/* more shift infos */ +ALTER TABLE `Shifts` ADD `created_by_user_id` INT NOT NULL , +ADD `created_at_timestamp` INT NOT NULL , +ADD `edited_by_user_id` INT NOT NULL , +ADD `edited_at_timestamp` INT NOT NULL; +ALTER TABLE `Shifts` ADD INDEX ( `created_by_user_id` ); +ALTER TABLE `Shifts` ADD INDEX ( `edited_by_user_id` ); +ALTER TABLE `Shifts` CHANGE `created_by_user_id` `created_by_user_id` INT( 11 ) NULL ; +ALTER TABLE `Shifts` CHANGE `edited_by_user_id` `edited_by_user_id` INT( 11 ) NULL ; +update Shifts set created_by_user_id=null, edited_by_user_id=null; +ALTER TABLE `Shifts` ADD FOREIGN KEY ( `created_by_user_id` ) REFERENCES `engelsystem`.`User` (`UID`) ON DELETE SET NULL ON UPDATE CASCADE ; +ALTER TABLE `Shifts` ADD FOREIGN KEY ( `edited_by_user_id` ) REFERENCES `engelsystem`.`User` (`UID`) ON DELETE SET NULL ON UPDATE CASCADE ; + /* Introduce planned departure date */ ALTER TABLE `User` ADD `planned_departure_date` INT NULL, ADD INDEX ( `planned_departure_date` ); -- cgit v1.2.3-54-g00ecf