|
<?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/
|
|
*
|
|
*/
|
|
|
|
/**
|
|
* Gets number of current SVN revision ID
|
|
*
|
|
* @return integer
|
|
*/
|
|
function get_SVN_rev()
|
|
{
|
|
$svnid = '$Rev: 1252 $';
|
|
$svnid = substr($svnid , 6);
|
|
$svnid = substr($svnid , 0, -2);
|
|
return $svnid;
|
|
}
|
|
|
|
|
|
/**
|
|
* Column for transfer key in phone invoice users
|
|
*
|
|
* @author Ondřej Fibich
|
|
*/
|
|
$upgrade_sql[get_SVN_rev()] = array
|
|
(
|
|
"ALTER TABLE `phone_invoice_users` ADD `transfer_id` INT( 11 ) NULL AFTER `phone_invoice_id`;",
|
|
|
|
"ALTER TABLE `phone_invoice_users` ADD INDEX ( `transfer_id` );",
|
|
|
|
"ALTER TABLE `phone_invoice_users` ADD FOREIGN KEY ( `transfer_id` ) REFERENCES `transfers` ( `id` ) ON DELETE SET NULL;",
|
|
);
|