update_version_db();
$db_release = '1.3';
if ($code_release == $db_release) {
return;
}
// end script db is same level as code
}
// Release 1.3 to 1.3.1
if ($db_release == '1.3') {
// go to Release 1.3.1
if (!mysql_num_rows(mysql_query("SHOW TABLES LIKE '" . TABLE_ACCOUNTS_NOTES . "'"))) {
$db->Execute("CREATE TABLE " . TABLE_ACCOUNTS_NOTES . " (\r\n\t id int(11) NOT NULL auto_increment,\r\n\t notes text,\r\n\t PRIMARY KEY (id)\r\n\t ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Holds account custom notes for accounts' ;");
}
$db->Execute("ALTER TABLE " . TABLE_CURRENT_STATUS . " \r\n\t\tCHANGE next_po_num next_po_num VARCHAR( 16 ) NOT NULL DEFAULT '1',\r\n\t\tCHANGE next_inv_num next_inv_num VARCHAR( 16 ) NOT NULL DEFAULT '1',\r\n\t\tCHANGE next_check_num next_check_num VARCHAR( 16 ) NOT NULL DEFAULT '1'");
// update the database version information
update_version_db();
$db_release = '1.3.1';
if ($code_release == $db_release) {
return;
}
// end script db is same level as code
}
// The rest of this script is the last beta release updates ******************************
if (!defined('ENABLE_MULTI_CURRENCY')) {
$db->Execute("INSERT INTO " . TABLE_CONFIGURATION . " \r\n ( `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) \r\n VALUES ( 'Enable Multi-Currency Displays', 'ENABLE_MULTI_CURRENCY', '0', 'Enable multiple currencies in user entry screens.<br />If No is selected, only the default currency wil be used.', '1', '19', NULL , '2008-01-21 00:00:00', NULL , 'cfg_keyed_select_option(array(0 =>\\'No\\', 1=>\\'Yes\\'),' ),\r\n ( 'Enable Multi-Branch Displays', 'ENABLE_MULTI_BRANCH', '0', 'Enable multiple branch functionality.<br />If No is selected, only one company location will be assumed.', '1', '18', NULL , '2008-01-21 00:00:00', NULL , 'cfg_keyed_select_option(array(0 =>\\'No\\', 1=>\\'Yes\\'),' );");
}
$fields = mysql_list_fields(DB_DATABASE, TABLE_JOURNAL_MAIN);
$columns = mysql_num_fields($fields);
$field_array[] = array();
for ($i = 0; $i < $columns; $i++) {
$field_array[] = mysql_field_name($fields, $i);
function execute_upgrade($db_release)
{
global $db, $messageStack;
$code_release = MODULE_PHREEBOOKS_VERSION;
// $db_release = PROJECT_DB_VERSION_MAJOR . '.' . PROJECT_DB_VERSION_MINOR;
if ($db_release <= '1.3.1') {
// upgrade db to Release 1.4
include DIR_FS_MODULES . 'phreebooks/updates/R131toR14.php';
update_version_db('1', '4');
$db_release = '1.4';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.4') {
// upgrade db to Release 1.5
include DIR_FS_MODULES . 'phreebooks/updates/R14toR15.php';
update_version_db('1', '5');
$db_release = '1.5';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.5') {
// upgrade db to Release 1.6
include DIR_FS_MODULES . 'phreebooks/updates/R15toR16.php';
update_version_db('1', '6');
$db_release = '1.6';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.6') {
// upgrade db to Release 1.7
include DIR_FS_MODULES . 'phreebooks/updates/R16toR17.php';
update_version_db('1', '7');
$db_release = '1.7';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.7') {
// upgrade db to Release 1.8
include DIR_FS_MODULES . 'phreebooks/updates/R17toR18.php';
update_version_db('1', '8');
$db_release = '1.8';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.8') {
// upgrade db to Release 1.9
include DIR_FS_MODULES . 'phreebooks/updates/R18toR19.php';
update_version_db('1', '9');
$db_release = '1.9';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '1.9' || $db_release <= '1.9p') {
// upgrade db to Release 2.0
include DIR_FS_MODULES . 'phreebooks/updates/R19toR20.php';
update_version_db('2', '0');
$db_release = '2.0';
if ($code_release == $db_release) {
return false;
}
}
if ($db_release <= '2.0') {
// upgrade db to Release 2.1
include DIR_FS_MODULES . 'phreebooks/updates/R20toR21.php';
update_version_db('2', '1');
$db_release = '2.1';
if ($code_release == $db_release) {
return false;
}
}
return true;
// error
}
function execute_upgrade()
{
global $db, $messageStack;
$code_release = PROJECT_VERSION_MAJOR . '.' . PROJECT_VERSION_MINOR;
$db_release = PROJECT_DB_VERSION_MAJOR . '.' . PROJECT_DB_VERSION_MINOR;
if ($db_release <= '1.3.1') {
// upgrade db to Release 1.4
include 'updates/R131toR14.php';
update_version_db('1', '4');
$db_release = '1.4';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.4') {
// upgrade db to Release 1.5
include 'updates/R14toR15.php';
update_version_db('1', '5');
$db_release = '1.5';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.5') {
// upgrade db to Release 1.6
include 'updates/R15toR16.php';
update_version_db('1', '6');
$db_release = '1.6';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.6') {
// upgrade db to Release 1.7
include 'updates/R16toR17.php';
update_version_db('1', '7');
$db_release = '1.7';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.7') {
// upgrade db to Release 1.8
include 'updates/R17toR18.php';
update_version_db('1', '8');
$db_release = '1.8';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.8') {
// upgrade db to Release 1.9
include 'updates/R18toR19.php';
update_version_db('1', '9');
$db_release = '1.9';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '1.9' || $db_release <= '1.9p') {
// upgrade db to Release 2.0
include 'updates/R19toR20.php';
update_version_db('2', '0');
$db_release = '2.0';
if ($code_release == $db_release) {
return;
}
}
if ($db_release <= '2.0') {
// upgrade db to Release 2.1
include 'updates/R20toR21.php';
update_version_db('2', '1');
$db_release = '2.1';
if ($code_release == $db_release) {
return;
}
}
}
