freenetis-github/db_upgrades/upgrade_1.2.0~alpha10.php @ eb7fd65e
| eb7fd65e | Ondřej Fibich | <?php defined('SYSPATH') or die('No direct script access.');
|
|
/*
|
|||
* This file is part of open source system FreenetIS
|
|||
* and it is released under GPLv3 licence.
|
|||
*
|
|||
* More info about licence can be found:
|
|||
* http://www.gnu.org/licenses/gpl-3.0.html
|
|||
*
|
|||
* More info about project can be found:
|
|||
* http://www.freenetis.org/
|
|||
*
|
|||
*/
|
|||
/**
|
|||
* Alters foreign keys in order to allow member delete. Names of foreign keys is
|
|||
* not fixed (auto-creation) thus for some deployments this can cause some
|
|||
* failures.
|
|||
*
|
|||
* @author Ondřej Fibich <ondrej.fibich@gmail.com>
|
|||
*/
|
|||
$upgrade_sql['1.1.22'] = array
|
|||
(
|
|||
"ALTER TABLE watchers DROP FOREIGN KEY watchers_ibfk_1;",
|
|||
"ALTER TABLE watchers ADD CONSTRAINT watchers_ibfk_1 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;",
|
|||
"ALTER TABLE jobs DROP FOREIGN KEY jobs_ibfk_2;",
|
|||
"ALTER TABLE jobs ADD CONSTRAINT jobs_ibfk_2 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;",
|
|||
"ALTER TABLE job_reports DROP FOREIGN KEY job_reports_ibfk_1;",
|
|||
"ALTER TABLE job_reports ADD CONSTRAINT job_reports_ibfk_1 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;",
|
|||
"ALTER TABLE requests DROP FOREIGN KEY requests_ibfk_1;",
|
|||
"ALTER TABLE requests ADD CONSTRAINT requests_ibfk_1 FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;",
|
|||
);
|