Database Creation Suppressed, SQL Queries follow';
echo '';
echo '';
echo "Please note that executing the generated script below may not result in a fully functional "
. "database, particularly in upgrade scenarios. This is due to the fact that some upgrade "
. "steps require the execution of PHP code; these Upgrade Functions are defined in "
. ' install_helper_functions_api.php'
. " and cannot be translated to SQL statements. Use at your own risk.";
echo ' ';
echo "-- MantisBT " . MANTIS_VERSION . " Database creation script". PHP_EOL;
echo "-- " . date("c") . PHP_EOL . PHP_EOL;
}
# Make sure we do the upgrades using UTF-8 if needed
if( $f_db_type === 'mysqli' ) {
$g_db->execute( 'SET NAMES UTF8' );
}
/** @var ADODB_DataDict $t_dict */
$t_dict = NewDataDictionary( $g_db );
# Special processing for specific schema versions
# This allows execution of additional install steps, which are
# not a Mantis schema upgrade but nevertheless required due to
# changes in the code
if( $f_db_type == 'pgsql' && $t_last_update > 51 && $t_last_update < 189 ) {
# Since MantisBT 1.1.0 / ADOdb 4.96 (corresponding to schema 51)
# 'L' columns are BOOLEAN instead of SMALLINT
# Check for any DB discrepancies and update columns if needed
$t_bool_columns = check_pgsql_bool_columns();
if( $t_bool_columns !== true ) {
# Some columns need converting
$t_msg = "PostgreSQL: check Boolean columns' actual type";
if( is_array( $t_bool_columns ) ) {
$t_count = count( $t_bool_columns );
print_test(
$t_msg,
$t_count == 0,
false,
"$t_count columns must be converted to BOOLEAN"
);
# Convert the columns
foreach( $t_bool_columns as $t_row ) {
/**
* @var string $v_table_name
* @var string $v_column_name
* @var boolean $v_is_nullable
* @var boolean $v_column_default
*/
extract( $t_row, EXTR_PREFIX_ALL, 'v' );
$t_null = $v_is_nullable ? 'NULL' : 'NOT NULL';
$t_default = is_null( $v_column_default ) ? 'NULL' : $v_column_default;
$t_sqlarray = $t_dict->AlterColumnSQL(
$v_table_name,
$v_column_name . ' L ' . $t_null . ' DEFAULT ' . $t_default
);
print_test(
'Converting column ' . $v_table_name . '.' . $v_column_name . ' to BOOLEAN',
2 == $t_dict->ExecuteSQLArray( $t_sqlarray, false ),
true,
print_r( $t_sqlarray, true )
);
/** @noinspection PhpExpressionAlwaysConstantInspection Set by print_test() */
if( $g_failed ) {
# Error occurred, bail out
break;
}
}
} else {
# We did not get an array => error occurred
print_test( $t_msg, false, true, $t_bool_columns );
}
}
}
# Follow-up fix for user_pref.redirect_delay, which was incorrectly
# set to boolean in check_pgsql_bool_columns() before MantisBT 2.23.0,
# so we need to check its type and convert it back to integer if needed.
# See issue #26109.
elseif( $f_db_type == 'pgsql' && $t_last_update > 43
&& version_compare( MANTIS_VERSION, '2.23.0', '<=' )
) {
$t_table = db_get_table( 'user_pref' );
$t_column = 'redirect_delay';
try {
$t_is_integer = pgsql_get_column_type( $t_table, $t_column ) == 'integer';
$t_msg = "Column must be converted to INTEGER";
$t_exception_occured = false;
}
catch( Exception $e ) {
$t_exception_occured = true;
$t_msg = $e->getMessage();
}
/** @noinspection PhpUndefinedVariableInspection */
print_test(
"PostgreSQL: check column '$t_table.$t_column' data type",
!$t_exception_occured && $t_is_integer,
/* hard fail */ $t_exception_occured,
$t_msg
);
if( !$t_exception_occured && !$t_is_integer ) {
$t_sqlarray = $t_dict->AlterColumnSQL( $t_table,
'redirect_delay I NOTNULL DEFAULT 0'
);
print_test(
"Converting column '$t_table.$t_column'' to INTEGER",
2 == $t_dict->ExecuteSQLArray( $t_sqlarray, false ),
true,
print_r( $t_sqlarray, true )
);
}
}
# End of special processing for specific schema versions
while( ( $i <= $t_last_id ) && !$g_failed ) {
if( !$f_log_queries ) {
echo '| ';
}
# No-op upgrade step - required for oci8
if( $g_upgrade[$i] === null ) {
$t_sql = false;
$t_sqlarray = array();
$t_operation = 'No operation';
$t_target = null;
} else {
$t_sql = true;
$t_operation = $g_upgrade[$i][0];
$t_target = $g_upgrade[$i][1][0];
switch( $t_operation ) {
case 'InsertData':
$t_sqlarray = call_user_func_array( $t_operation, $g_upgrade[$i][1] );
break;
case 'UpdateSQL':
$t_sqlarray = array(
$g_upgrade[$i][1],
);
$t_target = $g_upgrade[$i][1];
break;
case 'UpdateFunction':
$t_sqlarray = array(
$g_upgrade[$i][1],
);
if( isset( $g_upgrade[$i][2] ) ) {
$t_sqlarray[] = $g_upgrade[$i][2];
}
$t_sql = false;
$t_target = $g_upgrade[$i][1];
break;
default:
$t_sqlarray = call_user_func_array( array( $t_dict, $t_operation ), $g_upgrade[$i][1] );
# 0: function to call, 1: function params, 2: function to evaluate before calling upgrade, if false, skip upgrade.
if( isset( $g_upgrade[$i][2] ) ) {
if( call_user_func_array( $g_upgrade[$i][2][0], $g_upgrade[$i][2][1] ) ) {
$t_sqlarray = call_user_func_array( array( $t_dict, $t_operation ), $g_upgrade[$i][1] );
} else {
$t_sql = false;
$t_sqlarray = array();
$t_operation = "No operation";
}
} else {
$t_sqlarray = call_user_func_array( array( $t_dict, $t_operation ), $g_upgrade[$i][1] );
}
break;
}
}
if( $f_log_queries ) {
echo "-- Schema step $i" . PHP_EOL;
if( $t_sql ) {
foreach( $t_sqlarray as $t_statement ) {
# "CREATE OR REPLACE TRIGGER" statements must end with "END;\n/" for Oracle sqlplus
if( $f_db_type == 'oci8' && stripos( $t_statement, 'CREATE OR REPLACE TRIGGER' ) === 0 ) {
$t_sql_end = PHP_EOL . '/';
} else {
$t_sql_end = ';';
}
echo htmlentities( $t_statement ) . $t_sql_end;
}
} elseif( $t_sqlarray ) {
echo "-- Execute PHP Update Function: install_" . htmlentities( $t_sqlarray[0] ) . "(";
# Convert the parameters array to a printable string
if( isset( $t_sqlarray[1] ) ) {
$t_params = array();
foreach( $t_sqlarray[1] as $t_param ) {
$t_value = var_export( $t_param, true );
if( is_array( $t_param ) ) {
# Remove unnecessary array keys, newlines and the trailing comma
$t_value = preg_replace( '/\s*[0-9]+ => /', ' ', $t_value );
$t_value = str_replace( ",\n", ' ', $t_value );
}
$t_params[] = $t_value;
}
echo htmlentities( implode( ', ', $t_params ) );
}
echo ")";
} else {
echo "-- $t_operation";
}
echo PHP_EOL . PHP_EOL;
} else {
echo 'Schema step ' . $i . ': ' . $t_operation;
if( $t_target === null ) {
$t_ret = 2;
} else {
echo ' ( ' . $t_target . ' )';
if( $t_sql ) {
$t_ret = $t_dict->ExecuteSQLArray( $t_sqlarray, false );
} else {
if( isset( $t_sqlarray[1] ) ) {
$t_ret = call_user_func( 'install_' . $t_sqlarray[0], $t_sqlarray[1] );
} else {
$t_ret = call_user_func( 'install_' . $t_sqlarray[0] );
}
}
}
echo ' | ';
if( $t_ret == 2 ) {
print_test_result( GOOD );
config_set( 'database_version', $i, ALL_USERS );
} else {
$t_all_sql = '';
if( $t_sql ) {
foreach( $t_sqlarray as $t_single_sql ) {
if( !empty( $t_single_sql ) ) {
$t_all_sql .= $t_single_sql . '
';
}
}
}
print_test_result( BAD, true, $t_all_sql . $g_db->ErrorMsg() );
}
echo ' ';
}
$i++;
}
if( $f_log_queries ) {
# add a query to set the database version
echo "-- Set database version" . PHP_EOL;
if( $t_last_update == -1 ) {
echo "INSERT INTO " . db_get_table( 'config' )
. " ( value, type, access_reqd, config_id, project_id, user_id )"
. " VALUES ($t_last_id, 1, 90, 'database_version', 0, 0 );"
. PHP_EOL;
} else {
echo "UPDATE " . db_get_table( 'config' )
. " SET value = $t_last_id"
. " WHERE config_id = 'database_version' AND project_id = 0 AND user_id = 0;"
. PHP_EOL;
}
echo '';
echo '';
echo '';
echo "Your database is not ready yet ! "
. "Please create it, then install the tables and data using the above script before proceeding.";
echo ' ';
echo ' |
';
}
}
if( !$g_failed ) {
$t_install_state++;
} else {
$t_install_state--;
}
?>