PHP ModifyTableField 예제들

예제 #1

파일: upgrade.php 프로젝트: rpshaw/CDash

    // Set the database version
    setVersion();
    // Put that the upgrade is done in the log
    add_log("Upgrade done.", "upgrade-2-2");
    return;
}
// 2.4 Upgrade
if (isset($_GET['upgrade-2-4'])) {
    // Support for subproject groups
    AddTableField('subproject', 'groupid', 'int(11)', 'bigint', '0');
    AddTableIndex('subproject', 'groupid');
    RemoveTableField("subproject", "core");
    RemoveTableField('project', 'coveragethreshold2');
    // Support for larger types
    ModifyTableField("buildfailure", "workingdirectory", "VARCHAR( 512)", "VARCHAR( 512 )", "", true, false);
    ModifyTableField("buildfailure", "outputfile", "VARCHAR( 512)", "VARCHAR( 512 )", "", true, false);
    // Support for parent builds
    AddTableField('build', 'parentid', 'int(11)', 'int', '0');
    AddTableIndex('build', 'parentid');
    // Cache configure results similar to build & test
    AddTableField('build', 'configureerrors', 'smallint(6)', 'smallint', '-1');
    AddTableField('build', 'configurewarnings', 'smallint(6)', 'smallint', '-1');
    // Add new multi-column index to build table.
    // This improves the rendering speed of overview.php.
    $multi_index = array("projectid", "parentid", "starttime");
    AddTableIndex("build", $multi_index);
    // Support for dynamic BuildGroups.
    AddTableField('buildgroup', 'type', 'varchar(20)', 'character varying(20)', 'Daily');
    AddTableField('build2grouprule', 'parentgroupid', 'int(11)', 'bigint', '0');
    // Support for pull request notifications.
    AddTableField('build', 'notified', 'tinyint(1)', 'smallint', '0');

예제 #2

파일: upgrade.php 프로젝트: kitware/cdash

    // Put that the upgrade is done in the log
    add_log('Upgrade done.', 'upgrade-2-2');
    return;
}
// 2.4 Upgrade
if (isset($_GET['upgrade-2-4'])) {
    // Support for subproject groups
    AddTableField('subproject', 'groupid', 'int(11)', 'bigint', '0');
    AddTableIndex('subproject', 'groupid');
    AddTableField('subprojectgroup', 'position', 'int(11)', 'bigint', '0');
    AddTableIndex('subprojectgroup', 'position');
    RemoveTableField('subproject', 'core');
    RemoveTableField('project', 'coveragethreshold2');
    // Support for larger types
    ModifyTableField('buildfailure', 'workingdirectory', 'VARCHAR( 512)', 'VARCHAR( 512 )', '', true, false);
    ModifyTableField('buildfailure', 'outputfile', 'VARCHAR( 512)', 'VARCHAR( 512 )', '', true, false);
    // Support for parent builds
    AddTableField('build', 'parentid', 'int(11)', 'int', '0');
    AddTableIndex('build', 'parentid');
    // Cache configure results similar to build & test
    AddTableField('build', 'configureerrors', 'smallint(6)', 'smallint', '-1');
    AddTableField('build', 'configurewarnings', 'smallint(6)', 'smallint', '-1');
    // Add new multi-column index to build table.
    // This improves the rendering speed of overview.php.
    $multi_index = array('projectid', 'parentid', 'starttime');
    AddTableIndex('build', $multi_index);
    // Support for dynamic BuildGroups.
    AddTableField('buildgroup', 'type', 'varchar(20)', 'character varying(20)', 'Daily');
    AddTableField('build2grouprule', 'parentgroupid', 'int(11)', 'bigint', '0');
    // Support for pull request notifications.
    AddTableField('build', 'notified', 'tinyint(1)', 'smallint', '0');