Revize 1204
Přidáno uživatelem Michal Kliment před asi 13 roky(ů)
freenetis/branches/testing/application/upgrade_sql/upgrade_sql.php | ||
---|---|---|
(
|
||
/* Drops old tables */
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_accounts`;",
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_payments`;",
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_users`;",
|
||
"ALTER TABLE `devices` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL",
|
||
);
|
freenetis/branches/testing/application/upgrade_sql/upgrade_sql_1180.php | ||
---|---|---|
<?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/
|
||
*
|
||
*/
|
||
|
||
/**
|
||
* Array of sql queries that upgrade database.
|
||
* Adds VoIP views to database for synchronizing with SIP server.
|
||
*
|
||
* @author Ondřej Fibich
|
||
*/
|
||
$upgrade_sql[1180] = array
|
||
(
|
||
/* Drops old tables */
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_accounts`;",
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_payments`;",
|
||
|
||
"DROP TABLE IF EXISTS `voip_lbilling_users`;",
|
||
);
|
||
Také k dispozici: Unified diff
Jeste zmena db struktury.