# remove unnecessary indexes $g_upgrade[75] = array('CreateIndexSQL', array('idx_project_id', db_get_table('project'), 'id', array('DROP')), array('db_index_exists', array(db_get_table('project'), 'idx_project_id'))); $g_upgrade[76] = array('CreateIndexSQL', array('idx_config', db_get_table('config'), 'config_id', array('DROP')), array('db_index_exists', array(db_get_table('config'), 'idx_config'))); $g_upgrade[77] = array('InsertData', array(db_get_table('plugin'), "\n\t( basename, enabled )\n\tVALUES\n\t( 'MantisCoreFormatting', '1' )")); $g_upgrade[78] = array('AddColumnSQL', array(db_get_table('project'), "\n\tinherit_global\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '0'")); $g_upgrade[79] = array('AddColumnSQL', array(db_get_table('project_hierarchy'), "\n\tinherit_parent\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '0'")); # ---------------------------------------------------------------------------- # Schema version: 80 # $g_upgrade[80] = array('AddColumnSQL', array(db_get_table('plugin'), "\n\tprotected\t\t\t\tL\t\tNOTNULL DEFAULT \" '0' \",\n\tpriority\t\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '3'\n\t")); $g_upgrade[81] = array('AddColumnSQL', array(db_get_table('project_version'), "\n\tobsolete\t\t\t\tL\t\tNOTNULL DEFAULT \" '0' \"")); $g_upgrade[82] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdue_date\t\t\t\tT\t\tNOTNULL DEFAULT '" . db_null_date() . "' ")); # Release marker: 1.2.0a1 $g_upgrade[83] = array('AddColumnSQL', array(db_get_table('custom_field'), "\n\tfilter_by\t\t\t\tL\t\tNOTNULL DEFAULT \" '1' \"")); # Release marker: 1.2.0a2 - 1.2.0a3 $g_upgrade[84] = array('CreateTableSQL', array(db_get_table('bug_revision'), "\n\tid\t\t\t\t\t\tI\t\tUNSIGNED NOTNULL PRIMARY AUTOINCREMENT,\n\tbug_id\t\t\t\t\tI\t\tUNSIGNED NOTNULL,\n\tbugnote_id\t\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '0',\n\tuser_id\t\t\t\t\tI\t\tUNSIGNED NOTNULL,\n\ttimestamp\t\t\t\tT\t\tNOTNULL DEFAULT '" . db_null_date() . "',\n\ttype\t\t\t\t\tI\t\tUNSIGNED NOTNULL,\n\tvalue\t\t\t\t\tXL\t\tNOTNULL", $t_table_options)); $g_upgrade[85] = array('CreateIndexSQL', array('idx_bug_rev_id_time', db_get_table('bug_revision'), 'bug_id, timestamp')); $g_upgrade[86] = array('CreateIndexSQL', array('idx_bug_rev_type', db_get_table('bug_revision'), 'type')); # Date conversion $g_upgrade[87] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdate_submitted_int\t\tI\t\tUNSIGNED NOTNULL DEFAULT '1' ")); $g_upgrade[88] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdue_date_int\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '1' ")); $g_upgrade[89] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tlast_updated_int\t\tI\t\tUNSIGNED NOTNULL DEFAULT '1' ")); # ---------------------------------------------------------------------------- # Schema version: 90 # $g_upgrade[90] = array('UpdateFunction', 'date_migrate', array(db_get_table('bug'), 'id', array('date_submitted', 'due_date', 'last_updated'), array('date_submitted_int', 'due_date_int', 'last_updated_int'))); $g_upgrade[91] = array('DropColumnSQL', array(db_get_table('bug'), 'date_submitted')); $g_upgrade[92] = array('RenameColumnSQL', array(db_get_table('bug'), 'date_submitted_int', 'date_submitted', "\n\tdate_submitted_int\t\tI\t\tUNSIGNED NOTNULL DEFAULT '1' ")); $g_upgrade[93] = array('DropColumnSQL', array(db_get_table('bug'), 'due_date')); $g_upgrade[94] = array('RenameColumnSQL', array(db_get_table('bug'), 'due_date_int', 'due_date', "\n\tdue_date_int\t\t\tI\t\tUNSIGNED NOTNULL DEFAULT '1' ")); $g_upgrade[95] = array('DropColumnSQL', array(db_get_table('bug'), 'last_updated'));
$upgrade[] = array('UpdateFunction', "category_migrate"); $upgrade[] = array('DropColumnSQL', array(db_get_table('bug'), "category")); $upgrade[] = array('DropTableSQL', array(db_get_table('project_category'))); $upgrade[] = array('AddColumnSQL', array(db_get_table('project'), "category_id I UNSIGNED NOTNULL DEFAULT '1'")); // remove unnecessary indexes $upgrade[] = array('CreateIndexSQL', array('idx_project_id', db_get_table('project'), 'id', array('DROP')), array('db_index_exists', array(db_get_table('project'), 'idx_project_id'))); $upgrade[] = array('CreateIndexSQL', array('idx_config', db_get_table('config'), 'config_id', array('DROP')), array('db_index_exists', array(db_get_table('config'), 'idx_config'))); $upgrade[] = array('InsertData', array(db_get_table('plugin'), "\n\t( basename, enabled ) VALUES\n\t( 'MantisCoreFormatting', '1' )")); $upgrade[] = array('AddColumnSQL', array(db_get_table('project'), "inherit_global I UNSIGNED NOTNULL DEFAULT '0'")); $upgrade[] = array('AddColumnSQL', array(db_get_table('project_hierarchy'), "inherit_parent I UNSIGNED NOTNULL DEFAULT '0'")); /* 80 */ $upgrade[] = array('AddColumnSQL', array(db_get_table('plugin'), "\n\tprotected\t\tL\t\tNOTNULL DEFAULT \" '0' \",\n\tpriority\t\tI\t\tUNSIGNED NOTNULL DEFAULT '3'\n\t")); $upgrade[] = array('AddColumnSQL', array(db_get_table('project_version'), "\n\tobsolete\t\tL\t\tNOTNULL DEFAULT \" '0' \"")); $upgrade[] = array('AddColumnSQL', array(db_get_table('bug'), "\n due_date T NOTNULL DEFAULT '" . db_null_date() . "' ")); $upgrade[] = array('AddColumnSQL', array(db_get_table('custom_field'), "\n filter_by \t\tL \t\tNOTNULL DEFAULT \" '1' \"")); $upgrade[] = array('CreateTableSQL', array(db_get_table('bug_revision'), "\n\tid\t\t\tI\t\tUNSIGNED NOTNULL PRIMARY AUTOINCREMENT,\n\tbug_id\t\tI\t\tUNSIGNED NOTNULL,\n\tbugnote_id\tI\t\tUNSIGNED NOTNULL DEFAULT '0',\n\tuser_id\t\tI\t\tUNSIGNED NOTNULL,\n\ttimestamp\tT\t\tNOTNULL DEFAULT '" . db_null_date() . "',\n\ttype\t\tI\t\tUNSIGNED NOTNULL,\n\tvalue\t\tXL\t\tNOTNULL\n\t", array('mysql' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8', 'pgsql' => 'WITHOUT OIDS'))); $upgrade[] = array('CreateIndexSQL', array('idx_bug_rev_id_time', db_get_table('bug_revision'), 'bug_id, timestamp')); $upgrade[] = array('CreateIndexSQL', array('idx_bug_rev_type', db_get_table('bug_revision'), 'type')); #date conversion $upgrade[] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdate_submitted_int\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); $upgrade[] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdue_date_int \t\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); $upgrade[] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tlast_updated_int\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); /* 90 */ $upgrade[] = array('UpdateFunction', "date_migrate", array(db_get_table('bug'), 'id', array('date_submitted', 'due_date', 'last_updated'), array('date_submitted_int', 'due_date_int', 'last_updated_int'))); $upgrade[] = array('DropColumnSQL', array(db_get_table('bug'), "date_submitted")); $upgrade[] = array('RenameColumnSQL', array(db_get_table('bug'), "date_submitted_int", "date_submitted", "date_submitted_int\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); $upgrade[] = array('DropColumnSQL', array(db_get_table('bug'), "due_date")); $upgrade[] = array('RenameColumnSQL', array(db_get_table('bug'), "due_date_int", "due_date", "due_date_int\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); $upgrade[] = array('DropColumnSQL', array(db_get_table('bug'), "last_updated")); $upgrade[] = array('RenameColumnSQL', array(db_get_table('bug'), "last_updated_int", "last_updated", "last_updated_int\t\tI UNSIGNED NOTNULL DEFAULT '1' ")); $upgrade[] = array('CreateIndexSQL', array('idx_last_mod', db_get_table('bugnote'), 'last_modified', array('DROP')), array('db_index_exists', array(db_get_table('bugnote'), 'idx_last_mod')));
$g_upgrade[79] = array('AddColumnSQL', array(db_get_table('project_hierarchy'), 'inherit_parent I UNSIGNED NOTNULL DEFAULT \'0\'')); # ---------------------------------------------------------------------------- # Schema version: 80 # $g_upgrade[80] = array('AddColumnSQL', array(db_get_table('plugin'), "\n\tprotected\t\tL\t\tNOTNULL DEFAULT \" '0' \",\n\tpriority\t\tI\t\tUNSIGNED NOTNULL DEFAULT '3'\n\t")); $g_upgrade[81] = array('AddColumnSQL', array(db_get_table('project_version'), "\n\tobsolete\t\tL\t\tNOTNULL DEFAULT \" '0' \"")); $g_upgrade[82] = array('AddColumnSQL', array(db_get_table('bug'), "\n\tdue_date T NOTNULL DEFAULT '" . db_null_date() . "' ")); # Release marker: 1.2.0a1 $g_upgrade[83] = array('AddColumnSQL', array(db_get_table('custom_field'), "\n filter_by \t\tL \t\tNOTNULL DEFAULT \" '1' \"")); # Release marker: 1.2.0a2 - 1.2.0a3 $g_upgrade[84] = array('CreateTableSQL', array(db_get_table('bug_revision'), ' id I UNSIGNED NOTNULL PRIMARY AUTOINCREMENT, bug_id I UNSIGNED NOTNULL, bugnote_id I UNSIGNED NOTNULL DEFAULT \'0\', user_id I UNSIGNED NOTNULL, timestamp T NOTNULL DEFAULT \'' . db_null_date() . '\', type I UNSIGNED NOTNULL, value XL NOTNULL ', array('mysql' => 'ENGINE=MyISAM DEFAULT CHARSET=utf8', 'pgsql' => 'WITHOUT OIDS'))); $g_upgrade[85] = array('CreateIndexSQL', array('idx_bug_rev_id_time', db_get_table('bug_revision'), 'bug_id, timestamp')); $g_upgrade[86] = array('CreateIndexSQL', array('idx_bug_rev_type', db_get_table('bug_revision'), 'type')); # Date conversion $g_upgrade[87] = array('AddColumnSQL', array(db_get_table('bug'), ' date_submitted_int I UNSIGNED NOTNULL DEFAULT \'1\' ')); $g_upgrade[88] = array('AddColumnSQL', array(db_get_table('bug'), ' due_date_int I UNSIGNED NOTNULL DEFAULT \'1\' ')); $g_upgrade[89] = array('AddColumnSQL', array(db_get_table('bug'), ' last_updated_int I UNSIGNED NOTNULL DEFAULT \'1\' ')); # ---------------------------------------------------------------------------- # Schema version: 90 #