freenetis-github/db_upgrades/upgrade_1.2.0~alpha11.php @ 6f7e4d6a
8d0578dc | Filip Miskarik | <?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/
|
|||
*
|
|||
*/
|
|||
/**
|
|||
* Delete of voip and voip sips and all uses of these functions
|
|||
*
|
|||
* @author Filip Miskarik
|
|||
*/
|
|||
$upgrade_sql['1.2.0~alpha11'] = array
|
|||
(
|
|||
/* Drop VoIP tables */
|
|||
"DROP TABLE IF EXISTS voip_sips;",
|
|||
"DROP TABLE IF EXISTS voip_voicemail_users;",
|
|||
/* VoIP config fields */
|
|||
"DELETE FROM config WHERE name LIKE 'voip_%';",
|
|||
/* Drop member table VoIP columns */
|
|||
"ALTER TABLE members DROP voip_billing_limit, DROP voip_billing_type;",
|
|||
/* Delete AXO and all related access rights */
|
|||
"DELETE FROM axo WHERE section_value = 'VoIP_Controller';",
|
|||
"DELETE FROM axo_map WHERE section_value = 'VoIP_Controller';",
|
|||
"DELETE FROM axo_sections WHERE value = 'VoIP_Controller';",
|
|||
);
|