function data_restore_mods($mod, $restore) { global $CFG; $status = true; $data = backup_getid($restore->backup_unique_code, $mod->modtype, $mod->id); if ($data) { //Now get completed xmlized object $info = $data->info; // if necessary, write to restorelog and adjust date/time fields if ($restore->course_startdateoffset) { restore_log_date_changes('Database', $restore, $info['MOD']['#'], array('TIMEAVAILABLEFROM', 'TIMEAVAILABLETO', 'TIMEVIEWFROM', 'TIMEVIEWTO')); } //traverse_xmlize($info); //Debug //print_object ($GLOBALS['traverse_array']); //Debug //$GLOBALS['traverse_array']=""; //Debug $database->course = $restore->course_id; $database->name = backup_todb($info['MOD']['#']['NAME']['0']['#']); $database->intro = backup_todb($info['MOD']['#']['INTRO']['0']['#']); // Only relevant for restoring backups from 1.6 in a 1.7 install. if (isset($info['MOD']['#']['RATINGS']['0']['#'])) { $database->ratings = backup_todb($info['MOD']['#']['RATINGS']['0']['#']); } $database->comments = backup_todb($info['MOD']['#']['COMMENTS']['0']['#']); $database->timeavailablefrom = backup_todb($info['MOD']['#']['TIMEAVAILABLEFROM']['0']['#']); $database->timeavailableto = backup_todb($info['MOD']['#']['TIMEAVAILABLETO']['0']['#']); $database->timeviewfrom = backup_todb($info['MOD']['#']['TIMEVIEWFROM']['0']['#']); $database->timeviewto = backup_todb($info['MOD']['#']['TIMEVIEWTO']['0']['#']); // Only relevant for restoring backups from 1.6 in a 1.7 install. if (isset($info['MOD']['#']['PARTICIPANTS']['0']['#'])) { $database->participants = backup_todb($info['MOD']['#']['PARTICIPANTS']['0']['#']); } $database->requiredentries = backup_todb($info['MOD']['#']['REQUIREDENTRIES']['0']['#']); $database->requiredentriestoview = backup_todb($info['MOD']['#']['REQUIREDENTRIESTOVIEW']['0']['#']); $database->maxentries = backup_todb($info['MOD']['#']['MAXENTRIES']['0']['#']); $database->rssarticles = backup_todb($info['MOD']['#']['RSSARTICLES']['0']['#']); $database->singletemplate = backup_todb($info['MOD']['#']['SINGLETEMPLATE']['0']['#']); $database->listtemplate = backup_todb($info['MOD']['#']['LISTTEMPLATE']['0']['#']); $database->listtemplateheader = backup_todb($info['MOD']['#']['LISTTEMPLATEHEADER']['0']['#']); $database->listtemplatefooter = backup_todb($info['MOD']['#']['LISTTEMPLATEFOOTER']['0']['#']); $database->addtemplate = backup_todb($info['MOD']['#']['ADDTEMPLATE']['0']['#']); $database->rsstemplate = backup_todb($info['MOD']['#']['RSSTEMPLATE']['0']['#']); $database->rsstitletemplate = backup_todb($info['MOD']['#']['RSSTITLETEMPLATE']['0']['#']); $database->csstemplate = backup_todb($info['MOD']['#']['CSSTEMPLATE']['0']['#']); $database->jstemplate = backup_todb($info['MOD']['#']['JSTEMPLATE']['0']['#']); $database->asearchtemplate = backup_todb($info['MOD']['#']['ASEARCHTEMPLATE']['0']['#']); $database->approval = backup_todb($info['MOD']['#']['APPROVAL']['0']['#']); $database->scale = backup_todb($info['MOD']['#']['SCALE']['0']['#']); $database->assessed = backup_todb($info['MOD']['#']['ASSESSED']['0']['#']); // Only relevant for restoring backups from 1.6 in a 1.7 install. if (isset($info['MOD']['#']['ASSESSPUBLIC']['0']['#'])) { $database->assesspublic = backup_todb($info['MOD']['#']['ASSESSPUBLIC']['0']['#']); } $database->defaultsort = backup_todb($info['MOD']['#']['DEFAULTSORT']['0']['#']); $database->defaultsortdir = backup_todb($info['MOD']['#']['DEFAULTSORTDIR']['0']['#']); $database->editany = backup_todb($info['MOD']['#']['EDITANY']['0']['#']); $database->notification = backup_todb($info['MOD']['#']['NOTIFICATION']['0']['#']); // We have to recode the scale field if it's <0 (positive is a grade, not a scale) if ($database->scale < 0) { $scale = backup_getid($restore->backup_unique_code, 'scale', abs($database->scale)); if ($scale) { $database->scale = -$scale->new_id; } } $newid = insert_record('data', $database); //Do some output if (!defined('RESTORE_SILENTLY')) { echo "<li>" . get_string("modulename", "data") . " \"" . format_string(stripslashes($database->name), true) . "\"</li>"; } if ($newid) { //We have the newid, update backup_ids backup_putid($restore->backup_unique_code, $mod->modtype, $mod->id, $newid); //Now check if want to restore user data and do it. if (function_exists('restore_userdata_selected')) { // Moodle 1.6 $restore_userdata_selected = restore_userdata_selected($restore, 'data', $mod->id); } else { // Moodle 1.5 $restore_userdata_selected = $restore->mods['data']->userinfo; } global $fieldids; //Restore data_fields first!!! need to hold an array of [oldid]=>newid due to double dependencies $status = $status and data_fields_restore_mods($mod->id, $newid, $info, $restore); // now use the new field in the defaultsort $newdefaultsort = empty($fieldids[$database->defaultsort]) ? 0 : $fieldids[$database->defaultsort]; set_field('data', 'defaultsort', $newdefaultsort, 'id', $newid); if ($restore_userdata_selected) { $status = $status and data_records_restore_mods($mod->id, $newid, $info, $restore); } // If the backup contained $data->participants, $data->assesspublic // and $data->groupmode, we need to convert the data to use Roles. // It means the backup was made pre Moodle 1.7. We check the // backup_version to make sure. if (isset($database->participants) && isset($database->assesspublic)) { if (!($teacherroles = get_roles_with_capability('moodle/legacy:teacher', CAP_ALLOW))) { notice('Default teacher role was not found. Roles and permissions ' . 'for your database modules will have to be manually set.'); } if (!($studentroles = get_roles_with_capability('moodle/legacy:student', CAP_ALLOW))) { notice('Default student role was not found. Roles and permissions ' . 'for all your database modules will have to be manually set.'); } if (!($guestroles = get_roles_with_capability('moodle/legacy:guest', CAP_ALLOW))) { notice('Default guest role was not found. Roles and permissions ' . 'for all your database modules will have to be manually set.'); } require_once $CFG->dirroot . '/mod/data/lib.php'; data_convert_to_roles($database, $teacherroles, $studentroles, $restore->mods['data']->instances[$mod->id]->restored_as_course_module); } } else { $status = false; } } else { $status = false; } return $status; }
function data_upgrade($oldversion) { /// This function does anything necessary to upgrade /// older versions to match current functionality global $CFG; if ($oldversion < 2006011900) { table_column("data_content", "", "content1", "longtext", "", "", "", "not null"); table_column("data_content", "", "content2", "longtext", "", "", "", "not null"); table_column("data_content", "", "content3", "longtext", "", "", "", "not null"); table_column("data_content", "", "content4", "longtext", "", "", "", "not null"); } if ($oldversion < 2006011901) { table_column("data", "", "approval", "tinyint", "4"); table_column("data_records", "", "approved", "tinyint", "4"); } if ($oldversion < 2006020801) { table_column("data", "", "scale", "integer", "10", "signed"); table_column("data", "", "assessed", "integer", "10"); table_column("data", "", "assesspublic", "integer", "4"); } if ($oldversion < 2006022700) { table_column("data_comments", "", "created", "integer", "10"); table_column("data_comments", "", "modified", "integer", "10"); } if ($oldversion < 2006030700) { modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates def', 'data', 'name')"); } if ($oldversion < 2006032700) { table_column('data', '', 'defaultsort', 'integer', '10', 'unsigned', '0'); table_column('data', '', 'defaultsortdir', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsort'); table_column('data', '', 'editany', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsortdir'); } if ($oldversion < 2006032900) { table_column('data', '', 'csstemplate', 'text', '', '', '', 'not null', 'rsstemplate'); } if ($oldversion < 2006050500) { // 2 fields have got no default null values table_column('data_comments', 'content', 'content', 'text', '', '', '', 'not null'); table_column('data_fields', 'description', 'description', 'text', '', '', '', 'not null'); table_column('data_fields', 'param1', 'param1', 'text', '', '', '', 'not null'); table_column('data_fields', 'param2', 'param2', 'text', '', '', '', 'not null'); table_column('data_fields', 'param3', 'param3', 'text', '', '', '', 'not null'); table_column('data_fields', 'param4', 'param4', 'text', '', '', '', 'not null'); table_column('data_fields', 'param5', 'param5', 'text', '', '', '', 'not null'); table_column('data_fields', 'param6', 'param6', 'text', '', '', '', 'not null'); table_column('data_fields', 'param7', 'param7', 'text', '', '', '', 'not null'); table_column('data_fields', 'param8', 'param8', 'text', '', '', '', 'not null'); table_column('data_fields', 'param9', 'param9', 'text', '', '', '', 'not null'); table_column('data_fields', 'param10', 'param10', 'text', '', '', '', 'not null'); } if ($oldversion < 2006052400) { table_column('data', '', 'rsstitletemplate', 'text', '', '', '', 'not null', 'rsstemplate'); } if ($oldversion < 2006081700) { table_column('data', '', 'jstemplate', 'text', '', '', '', 'not null', 'csstemplate'); } if ($oldversion < 2006092000) { // Upgrades for new roles and capabilities support. require_once $CFG->dirroot . '/mod/data/lib.php'; $datamod = get_record('modules', 'name', 'data'); if ($data = get_records('data')) { if (!($teacherroles = get_roles_with_capability('moodle/legacy:teacher', CAP_ALLOW))) { notify('Default teacher role was not found. Roles and permissions ' . 'for all your forums will have to be manually set after ' . 'this upgrade.'); } if (!($studentroles = get_roles_with_capability('moodle/legacy:student', CAP_ALLOW))) { notify('Default student role was not found. Roles and permissions ' . 'for all your forums will have to be manually set after ' . 'this upgrade.'); } foreach ($data as $d) { if (!data_convert_to_roles($d, $teacherroles, $studentroles)) { notify('Data with id ' . $d->id . ' was not upgraded'); } } // We need to rebuild all the course caches to refresh the state of // the forum modules. include_once "{$CFG->dirroot}/course/lib.php"; rebuild_course_cache(); } // End if. modify_database('', 'ALTER TABLE prefix_data DROP COLUMN participants;'); modify_database('', 'ALTER TABLE prefix_data DROP COLUMN assesspublic;'); modify_database('', 'ALTER TABLE prefix_data DROP COLUMN ratings;'); } if ($oldversion < 2006092302) { // Changing some TEXT fields to NULLable and no default execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE singletemplate singletemplate text NULL AFTER rssarticles"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE listtemplate listtemplate text NULL AFTER singletemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE listtemplateheader listtemplateheader text NULL AFTER listtemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE listtemplatefooter listtemplatefooter text NULL AFTER listtemplateheader"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE addtemplate addtemplate text NULL AFTER listtemplatefooter"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE rsstemplate rsstemplate text NULL AFTER addtemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE rsstitletemplate rsstitletemplate text NULL AFTER rsstemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE csstemplate csstemplate text NULL AFTER rsstitletemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data CHANGE jstemplate jstemplate text NULL AFTER csstemplate"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param1 param1 text NULL AFTER description"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param2 param2 text NULL AFTER param1"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param3 param3 text NULL AFTER param2"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param4 param4 text NULL AFTER param3"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param5 param5 text NULL AFTER param4"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param6 param6 text NULL AFTER param5"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param7 param7 text NULL AFTER param6"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param8 param8 text NULL AFTER param7"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param9 param9 text NULL AFTER param8"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields CHANGE param10 param10 text NULL AFTER param9"); execute_sql("ALTER TABLE {$CFG->prefix}data_content CHANGE content content longtext NULL AFTER recordid"); execute_sql("ALTER TABLE {$CFG->prefix}data_content CHANGE content1 content1 longtext NULL AFTER content"); execute_sql("ALTER TABLE {$CFG->prefix}data_content CHANGE content2 content2 longtext NULL AFTER content1"); execute_sql("ALTER TABLE {$CFG->prefix}data_content CHANGE content3 content3 longtext NULL AFTER content2"); execute_sql("ALTER TABLE {$CFG->prefix}data_content CHANGE content4 content4 longtext NULL AFTER content3"); } ////// DO NOT ADD NEW THINGS HERE!! USE upgrade.php and the lib/ddllib.php functions. return true; }
function data_upgrade($oldversion) { /// This function does anything necessary to upgrade /// older versions to match current functionality global $CFG; if ($oldversion < 2006011900) { table_column("data_content", "", "content1", "text", "", "", "", "not null"); table_column("data_content", "", "content2", "text", "", "", "", "not null"); table_column("data_content", "", "content3", "text", "", "", "", "not null"); table_column("data_content", "", "content4", "text", "", "", "", "not null"); } if ($oldversion < 2006011901) { table_column("data", "", "approval", "integer", "4", "unsigned", "0", "not null"); table_column("data_records", "", "approved", "integer", "4", "unsigned", "0", "not null"); } if ($oldversion < 2006020801) { table_column("data", "", "scale", "integer"); table_column("data", "", "assessed", "integer"); table_column("data", "", "assesspublic", "integer"); } if ($oldversion < 2006022700) { table_column("data_comments", "", "created", "integer"); table_column("data_comments", "", "modified", "integer"); } if ($oldversion < 2006030700) { modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'view', 'data', 'name');"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')"); modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates defaults', 'data', 'name')"); } if ($oldversion < 2006032700) { table_column('data', '', 'defaultsort', 'integer', '10', 'unsigned', '0'); table_column('data', '', 'defaultsortdir', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsort'); table_column('data', '', 'editany', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsortdir'); } if ($oldversion < 2006032900) { table_column('data', '', 'csstemplate', 'text', '', '', '', 'not null', 'rsstemplate'); } if ($oldversion < 2006050500) { // drop all tables, and create from scratch execute_sql("DROP TABLE {$CFG->prefix}data", false); execute_sql("DROP TABLE {$CFG->prefix}data_content", false); execute_sql("DROP TABLE {$CFG->prefix}data_fields", false); execute_sql("DROP TABLE {$CFG->prefix}data_records", false); execute_sql("DROP TABLE {$CFG->prefix}data_comments", false); execute_sql("DROP TABLE {$CFG->prefix}data_ratings", false); modify_database('', "CREATE TABLE prefix_data (\n id SERIAL PRIMARY KEY,\n course integer NOT NULL default '0',\n name varchar(255) NOT NULL default '',\n intro text NOT NULL default '',\n ratings integer NOT NULL default '0',\n comments integer NOT NULL default '0',\n timeavailablefrom integer NOT NULL default '0',\n timeavailableto integer NOT NULL default '0',\n timeviewfrom integer NOT NULL default '0',\n timeviewto integer NOT NULL default '0',\n participants integer NOT NULL default '0',\n requiredentries integer NOT NULL default '0',\n requiredentriestoview integer NOT NULL default '0',\n maxentries integer NOT NULL default '0',\n rssarticles integer NOT NULL default '0',\n singletemplate text NOT NULL default '',\n listtemplate text NOT NULL default '',\n listtemplateheader text NOT NULL default '',\n listtemplatefooter text NOT NULL default '',\n addtemplate text NOT NULL default '',\n rsstemplate text NOT NULL default '',\n csstemplate text NOT NULL default '',\n approval integer NOT NULL default '0',\n scale integer NOT NULL default '0',\n assessed integer NOT NULL default '0',\n assesspublic integer NOT NULL default '0',\n defaultsort integer NOT NULL default '0',\n defaultsortdir integer NOT NULL default '0',\n editany integer NOT NULL default '0'\n );\n\n CREATE TABLE prefix_data_content (\n id SERIAL PRIMARY KEY,\n fieldid integer NOT NULL default '0',\n recordid integer NOT NULL default '0',\n content text NOT NULL default '',\n content1 text NOT NULL default '',\n content2 text NOT NULL default '',\n content3 text NOT NULL default '',\n content4 text NOT NULL default ''\n );\n\n CREATE TABLE prefix_data_fields (\n id SERIAL PRIMARY KEY,\n dataid integer NOT NULL default '0',\n type varchar(255) NOT NULL default '',\n name varchar(255) NOT NULL default '',\n description text NOT NULL default '',\n param1 text NOT NULL default '',\n param2 text NOT NULL default '',\n param3 text NOT NULL default '',\n param4 text NOT NULL default '',\n param5 text NOT NULL default '',\n param6 text NOT NULL default '',\n param7 text NOT NULL default '',\n param8 text NOT NULL default '',\n param9 text NOT NULL default '',\n param10 text NOT NULL default ''\n );\n\n CREATE TABLE prefix_data_records (\n id SERIAL PRIMARY KEY,\n userid integer NOT NULL default '0',\n groupid integer NOT NULL default '0',\n dataid integer NOT NULL default '0',\n timecreated integer NOT NULL default '0',\n timemodified integer NOT NULL default '0',\n approved integer NOT NULL default '0'\n );\n\n CREATE TABLE prefix_data_comments (\n id SERIAL PRIMARY KEY,\n userid integer NOT NULL default '0',\n recordid integer NOT NULL default '0',\n content text NOT NULL default '',\n created integer NOT NULL default '0',\n modified integer NOT NULL default '0'\n );\n\n CREATE TABLE prefix_data_ratings (\n id SERIAL PRIMARY KEY,\n userid integer NOT NULL default '0',\n recordid integer NOT NULL default '0',\n rating integer NOT NULL default '0'\n );"); } if ($oldversion < 2006052400) { table_column('data', '', 'rsstitletemplate', 'text', '', '', '', 'not null', 'rsstemplate'); } if ($oldversion < 2006081700) { table_column('data', '', 'jstemplate', 'text', '', '', '', 'not null', 'csstemplate'); } if ($oldversion < 2006092000) { // Upgrades for new roles and capabilities support. require_once $CFG->dirroot . '/mod/data/lib.php'; $datamod = get_record('modules', 'name', 'data'); if ($data = get_records('data')) { if (!($teacherroles = get_roles_with_capability('moodle/legacy:teacher', CAP_ALLOW))) { notify('Default teacher role was not found. Roles and permissions ' . 'for all your forums will have to be manually set after ' . 'this upgrade.'); } if (!($studentroles = get_roles_with_capability('moodle/legacy:student', CAP_ALLOW))) { notify('Default student role was not found. Roles and permissions ' . 'for all your forums will have to be manually set after ' . 'this upgrade.'); } foreach ($data as $d) { if (!data_convert_to_roles($d, $teacherroles, $studentroles)) { notify('Data with id ' . $d->id . ' was not upgraded'); } } // We need to rebuild all the course caches to refresh the state of // the forum modules. include_once "{$CFG->dirroot}/course/lib.php"; rebuild_course_cache(); } // End if. modify_database('', 'ALTER TABLE prefix_data DROP COLUMN participants;'); modify_database('', 'ALTER TABLE prefix_data DROP COLUMN assesspublic;'); modify_database('', 'ALTER TABLE prefix_data DROP COLUMN ratings;'); } if ($oldversion < 2006092302) { // Changing some TEXT fields to NULLable and no default execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN singletemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN singletemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplateheader DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplateheader DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplatefooter DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplatefooter DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN addtemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN addtemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstitletemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstitletemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN csstemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN csstemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN jstemplate DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN jstemplate DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param1 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param1 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param2 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param2 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param3 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param3 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param4 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param4 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param5 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param5 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param6 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param6 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param7 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param7 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param8 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param8 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param9 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param9 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param10 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param10 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content1 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content1 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content2 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content2 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content3 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content3 DROP DEFAULT"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content4 DROP NOT NULL"); execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content4 DROP DEFAULT"); } ////// DO NOT ADD NEW THINGS HERE!! USE upgrade.php and the lib/ddllib.php functions. return true; }