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; } } }