db_null_date PHP代码示例

示例#1

0

显示文件

文件： schema.php 项目： lseyesl/mantisbt

# 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'));

示例#2

0

显示文件

文件： schema.php 项目： kaos/mantisbt

$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')));

示例#3

0

显示文件

文件： schema.php 项目： gtn/mantisbt

$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
#

PHP db_null_date示例