本文整理汇总了PHP中xmldb_table::addFieldInfo方法的典型用法代码示例。如果您正苦于以下问题:PHP xmldb_table::addFieldInfo方法的具体用法?PHP xmldb_table::addFieldInfo怎么用?PHP xmldb_table::addFieldInfo使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类xmldb_table
的用法示例。
在下文中一共展示了xmldb_table::addFieldInfo方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: xmldb_flashcard_upgrade
function xmldb_flashcard_upgrade($oldversion = 0)
{
/// This function does anything necessary to upgrade
/// older versions to match current functionality
/* @var $DB mysqli_native_moodle_database */
global $CFG, $DB;
/* @var $dbman database_manager */
$dbman = $DB->get_manager();
$result = true;
//===== 1.9.0 upgrade line ======//
if ($oldversion < 2008050400) {
/// Define field starttime to be added to flashcard
$table = new xmldb_table('flashcard');
/// Launch add field starttime
$field = new xmldb_field('starttime');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, null, null, null, null, null, 'timemodified');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field endtime
$field = new xmldb_field('endtime');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, null, null, null, null, null, 'starttime');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field autodowngrade
$field = new xmldb_field('autodowngrade');
$field->set_attributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 1, 'questionid');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck2_release
$field = new xmldb_field('deck2_release');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 96, 'autodowngrade');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck3_release
$field = new xmldb_field('deck3_release');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 96, 'deck2_release');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck1_delay
$field = new xmldb_field('deck1_delay');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 48, 'deck3_release');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck2_delay
$field = new xmldb_field('deck2_delay');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 96, 'deck1_delay');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck3_delay
$field = new xmldb_field('deck3_delay');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 168, 'deck2_delay');
$result = $result && $dbman->add_field($table, $field);
/// Define table flashcard_card to be created
$table = new xmldb_table('flashcard_card');
/// Adding fields to table flashcard_card
$table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null);
$table->addFieldInfo('flashcardid', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null);
$table->addFieldInfo('userid', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, null, null, null, null, null);
$table->addFieldInfo('entryid', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null);
$table->addFieldInfo('deck', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, null);
$table->addFieldInfo('lastaccessed', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, null, null, null, null, '0');
/// Adding keys to table flashcard_card
$table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id'));
/// Launch create table for flashcard_card
$result = $result && $dbman->create_table($table);
}
if ($oldversion < 2008050500) {
/// Define field starttime to be added to flashcard
$table = new xmldb_table('flashcard');
/// Launch add field deck4_release
$field = new xmldb_field('deck4_release');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 96, 'deck3_release');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field deck4_delay
$field = new xmldb_field('deck4_delay');
$field->set_attributes(XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, 336, 'deck3_delay');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field questionsasimages
$field = new xmldb_field('questionsasimages');
$field->set_attributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'deck4_delay');
$result = $result && $dbman->add_field($table, $field);
/// Launch add field answersasimages
$field = new xmldb_field('answersasimages');
$field->set_attributes(XMLDB_TYPE_INTEGER, '1', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'questionsasimages');
$result = $result && $dbman->add_field($table, $field);
}
if ($oldversion < 2008050501) {
/// Define field starttime to be added to flashcard
$table = new xmldb_table('flashcard');
/// Launch add field decks
$field = new xmldb_field('decks');
$field->set_attributes(XMLDB_TYPE_INTEGER, '3', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '3', 'autodowngrade');
$result = $result && $dbman->add_field($table, $field);
}
if ($result && $oldversion < 2008050800) {
/// Define table flashcard_deckdata to be created
$table = new xmldb_table('flashcard_deckdata');
/// Adding fields to table flashcard_deckdata
$table->addFieldInfo('id', XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, XMLDB_SEQUENCE, null, null, null);
$table->addFieldInfo('flashcardid', XMLDB_TYPE_INTEGER, '11', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0');
$table->addFieldInfo('questiontext', XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null);
$table->addFieldInfo('answertext', XMLDB_TYPE_TEXT, 'small', null, null, null, null, null, null);
/// Adding keys to table flashcard_deckdata
$table->addKeyInfo('primary', XMLDB_KEY_PRIMARY, array('id'));
/// Launch create table for flashcard_deckdata
$result = $result && $dbman->create_table($table);
}
//.........这里部分代码省略.........