|
<?php
|
|
/**
|
|
* Changes work report table, adds column added_by_id and it's forein key.
|
|
*
|
|
* @author Ondřej Fibich
|
|
*/
|
|
$upgrade_sql[1234] = array
|
|
(
|
|
"ALTER TABLE `job_reports` ADD `added_by_id` INT( 11 ) AFTER `user_id`;",
|
|
|
|
"ALTER TABLE `job_reports` ADD INDEX ( `added_by_id` );",
|
|
|
|
"ALTER TABLE `job_reports` ADD FOREIGN KEY ( `added_by_id` ) REFERENCES `users` ( `id` ) ON DELETE SET NULL;"
|
|
);
|
|
?>
|