freenetis-github/db_upgrades/upgrade_1.2.0~alpha7.php @ 3f5d6df7
| 18ac9009 | 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/
|
|||
*
|
|||
*/
|
|||
/**
|
|||
* Adds user_id column to members_whitelists tables
|
|||
* for loging who adds/edits members whitelist.
|
|||
*
|
|||
* @author David Raška <jeffraska@gmail.com>
|
|||
*/
|
|||
$upgrade_sql['1.2.0~alpha7'] = array
|
|||
(
|
|||
"ALTER TABLE `members_whitelists` ADD `user_id` INT NULL,
|
|||
ADD INDEX ( `user_id` );",
|
|||
"ALTER TABLE `members_whitelists` ADD FOREIGN KEY ( `user_id` ) REFERENCES `users` (
|
|||
`id`
|
|||
) ON DELETE SET NULL ;"
|
|||
); // end of $upgrade_sql['1.2.0~alpha7']
|