mod/data/db/postgres7.php

   1 <?php
   2
   3 // THIS FILE IS DEPRECATED!  PLEASE DO NOT MAKE CHANGES TO IT!
   4 //
   5 // IT IS USED ONLY FOR UPGRADES FROM BEFORE MOODLE 1.7, ALL
   6 // LATER CHANGES SHOULD USE upgrade.php IN THIS DIRECTORY.
   7
   8 function data_upgrade($oldversion) {
   9 /// This function does anything necessary to upgrade
  10 /// older versions to match current functionality
  11
  12     global $CFG;
  13
  14     if ($oldversion < 2006011900) {
  15         table_column("data_content", "", "content1", "text", "", "", "", "not null");
  16         table_column("data_content", "", "content2", "text", "", "", "", "not null");
  17         table_column("data_content", "", "content3", "text", "", "", "", "not null");
  18         table_column("data_content", "", "content4", "text", "", "", "", "not null");
  19     }
  20
  21     if ($oldversion < 2006011901) {
  22         table_column("data", "", "approval", "integer", "4", "unsigned", "0", "not null");
  23         table_column("data_records", "", "approved", "integer", "4", "unsigned", "0", "not null");
  24     }
  25
  26     if ($oldversion < 2006020801) {
  27         table_column("data", "", "scale", "integer");
  28         table_column("data", "", "assessed", "integer");
  29         table_column("data", "", "assesspublic", "integer");
  30     }
  31
  32     if ($oldversion < 2006022700) {
  33         table_column("data_comments", "", "created", "integer");
  34         table_column("data_comments", "", "modified", "integer");
  35     }
  36
  37     if ($oldversion < 2006030700) {
  38         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'view', 'data', 'name');");
  39         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'add', 'data', 'name')");
  40         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'update', 'data', 'name')");
  41         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'record delete', 'data', 'name')");
  42         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields add', 'data_fields', 'name')");
  43         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'fields update', 'data_fields', 'name')");
  44         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates saved', 'data', 'name')");
  45         modify_database('', "INSERT INTO prefix_log_display (module, action, mtable, field) VALUES ('data', 'templates defaults', 'data', 'name')");
  46     }
  47
  48     if ($oldversion < 2006032700) {
  49         table_column('data', '', 'defaultsort', 'integer', '10', 'unsigned', '0');
  50         table_column('data', '', 'defaultsortdir', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsort');
  51         table_column('data', '', 'editany', 'tinyint', '4', 'unsigned', '0', 'not null', 'defaultsortdir');
  52     }
  53
  54     if ($oldversion < 2006032900) {
  55         table_column('data', '', 'csstemplate', 'text', '', '', '', 'not null', 'rsstemplate');
  56     }
  57
  58     if ($oldversion < 2006050500) { // drop all tables, and create from scratch
  59
  60         execute_sql("DROP TABLE {$CFG->prefix}data", false);
  61         execute_sql("DROP TABLE {$CFG->prefix}data_content", false);
  62         execute_sql("DROP TABLE {$CFG->prefix}data_fields", false);
  63         execute_sql("DROP TABLE {$CFG->prefix}data_records", false);
  64         execute_sql("DROP TABLE {$CFG->prefix}data_comments", false);
  65         execute_sql("DROP TABLE {$CFG->prefix}data_ratings", false);
  66
  67         modify_database('',"CREATE TABLE prefix_data (
  68                               id SERIAL PRIMARY KEY,
  69                               course integer NOT NULL default '0',
  70                               name varchar(255) NOT NULL default '',
  71                               intro text NOT NULL default '',
  72                               ratings integer NOT NULL default '0',
  73                               comments integer NOT NULL default '0',
  74                               timeavailablefrom integer NOT NULL default '0',
  75                               timeavailableto integer NOT NULL default '0',
  76                               timeviewfrom integer NOT NULL default '0',
  77                               timeviewto integer NOT NULL default '0',
  78                               participants integer NOT NULL default '0',
  79                               requiredentries integer NOT NULL default '0',
  80                               requiredentriestoview integer NOT NULL default '0',
  81                               maxentries integer NOT NULL default '0',
  82                               rssarticles integer NOT NULL default '0',
  83                               singletemplate text NOT NULL default '',
  84                               listtemplate text NOT NULL default '',
  85                               listtemplateheader text NOT NULL default '',
  86                               listtemplatefooter text NOT NULL default '',
  87                               addtemplate text NOT NULL default '',
  88                               rsstemplate text NOT NULL default '',
  89                               csstemplate text NOT NULL default '',
  90                               approval integer NOT NULL default '0',
  91                               scale integer NOT NULL default '0',
  92                               assessed integer NOT NULL default '0',
  93                               assesspublic integer NOT NULL default '0',
  94                               defaultsort integer NOT NULL default '0',
  95                               defaultsortdir integer NOT NULL default '0',
  96                               editany integer NOT NULL default '0'
  97                             );
  98
  99                             CREATE TABLE prefix_data_content (
 100                               id SERIAL PRIMARY KEY,
 101                               fieldid integer NOT NULL default '0',
 102                               recordid integer NOT NULL default '0',
 103                               content text NOT NULL default '',
 104                               content1 text NOT NULL default '',
 105                               content2 text NOT NULL default '',
 106                               content3 text NOT NULL default '',
 107                               content4 text NOT NULL default ''
 108                             );
 109
 110                             CREATE TABLE prefix_data_fields (
 111                               id SERIAL PRIMARY KEY,
 112                               dataid integer NOT NULL default '0',
 113                               type varchar(255) NOT NULL default '',
 114                               name varchar(255) NOT NULL default '',
 115                               description text NOT NULL default '',
 116                               param1  text NOT NULL default '',
 117                               param2  text NOT NULL default '',
 118                               param3  text NOT NULL default '',
 119                               param4  text NOT NULL default '',
 120                               param5  text NOT NULL default '',
 121                               param6  text NOT NULL default '',
 122                               param7  text NOT NULL default '',
 123                               param8  text NOT NULL default '',
 124                               param9  text NOT NULL default '',
 125                               param10 text NOT NULL default ''
 126                             );
 127
 128                             CREATE TABLE prefix_data_records (
 129                               id SERIAL PRIMARY KEY,
 130                               userid integer NOT NULL default '0',
 131                               groupid integer NOT NULL default '0',
 132                               dataid integer NOT NULL default '0',
 133                               timecreated integer NOT NULL default '0',
 134                               timemodified integer NOT NULL default '0',
 135                               approved integer NOT NULL default '0'
 136                             );
 137
 138                             CREATE TABLE prefix_data_comments (
 139                               id SERIAL PRIMARY KEY,
 140                               userid integer NOT NULL default '0',
 141                               recordid integer NOT NULL default '0',
 142                               content text NOT NULL default '',
 143                               created integer NOT NULL default '0',
 144                               modified integer NOT NULL default '0'
 145                             );
 146
 147                             CREATE TABLE prefix_data_ratings (
 148                               id SERIAL PRIMARY KEY,
 149                               userid integer NOT NULL default '0',
 150                               recordid integer NOT NULL default '0',
 151                               rating integer NOT NULL default '0'
 152                             );");
 153
 154     }
 155
 156     if ($oldversion < 2006052400) {
 157         table_column('data','','rsstitletemplate','text','','','','not null','rsstemplate');
 158     }
 159
 160     if ($oldversion < 2006081700) {
 161         table_column('data', '', 'jstemplate', 'text', '', '', '', 'not null', 'csstemplate');
 162     }
 163
 164     if ($oldversion < 2006092000) {
 165         // Upgrades for new roles and capabilities support.
 166         require_once($CFG->dirroot.'/mod/data/lib.php');
 167
 168         $datamod = get_record('modules', 'name', 'data');
 169
 170         if ($data = get_records('data')) {
 171
 172             if (!$teacherroles = get_roles_with_capability('moodle/legacy:teacher', CAP_ALLOW)) {
 173                 notify('Default teacher role was not found. Roles and permissions '.
 174                        'for all your forums will have to be manually set after '.
 175                        'this upgrade.');
 176             }
 177             if (!$studentroles = get_roles_with_capability('moodle/legacy:student', CAP_ALLOW)) {
 178                 notify('Default student role was not found. Roles and permissions '.
 179                        'for all your forums will have to be manually set after '.
 180                        'this upgrade.');
 181             }
 182             foreach ($data as $d) {
 183                 if (!data_convert_to_roles($d, $teacherroles, $studentroles)) {
 184                     notify('Data with id '.$d->id.' was not upgraded');
 185                 }
 186             }
 187             // We need to rebuild all the course caches to refresh the state of
 188             // the forum modules.
 189             include_once( "$CFG->dirroot/course/lib.php" );
 190             rebuild_course_cache();
 191
 192         } // End if.
 193
 194         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN participants;');
 195         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN assesspublic;');
 196         modify_database('', 'ALTER TABLE prefix_data DROP COLUMN ratings;');
 197
 198     }
 199
 200     if ($oldversion < 2006092302) { // Changing some TEXT fields to NULLable and no default
 201         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN singletemplate DROP NOT NULL");
 202         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN singletemplate DROP DEFAULT");
 203
 204         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplate DROP NOT NULL");
 205         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplate DROP DEFAULT");
 206
 207         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplateheader DROP NOT NULL");
 208         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplateheader DROP DEFAULT");
 209
 210         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplatefooter DROP NOT NULL");
 211         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN listtemplatefooter DROP DEFAULT");
 212
 213         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN addtemplate DROP NOT NULL");
 214         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN addtemplate DROP DEFAULT");
 215
 216         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstemplate DROP NOT NULL");
 217         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstemplate DROP DEFAULT");
 218
 219         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstitletemplate DROP NOT NULL");
 220         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN rsstitletemplate DROP DEFAULT");
 221
 222         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN csstemplate DROP NOT NULL");
 223         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN csstemplate DROP DEFAULT");
 224
 225         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN jstemplate DROP NOT NULL");
 226         execute_sql("ALTER TABLE {$CFG->prefix}data ALTER COLUMN jstemplate DROP DEFAULT");
 227
 228         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param1 DROP NOT NULL");
 229         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param1 DROP DEFAULT");
 230
 231         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param2 DROP NOT NULL");
 232         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param2 DROP DEFAULT");
 233
 234         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param3 DROP NOT NULL");
 235         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param3 DROP DEFAULT");
 236
 237         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param4 DROP NOT NULL");
 238         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param4 DROP DEFAULT");
 239
 240         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param5 DROP NOT NULL");
 241         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param5 DROP DEFAULT");
 242
 243         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param6 DROP NOT NULL");
 244         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param6 DROP DEFAULT");
 245
 246         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param7 DROP NOT NULL");
 247         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param7 DROP DEFAULT");
 248
 249         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param8 DROP NOT NULL");
 250         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param8 DROP DEFAULT");
 251
 252         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param9 DROP NOT NULL");
 253         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param9 DROP DEFAULT");
 254
 255         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param10 DROP NOT NULL");
 256         execute_sql("ALTER TABLE {$CFG->prefix}data_fields ALTER COLUMN param10 DROP DEFAULT");
 257
 258         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content DROP NOT NULL");
 259         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content DROP DEFAULT");
 260
 261         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content1 DROP NOT NULL");
 262         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content1 DROP DEFAULT");
 263
 264         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content2 DROP NOT NULL");
 265         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content2 DROP DEFAULT");
 266
 267         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content3 DROP NOT NULL");
 268         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content3 DROP DEFAULT");
 269
 270         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content4 DROP NOT NULL");
 271         execute_sql("ALTER TABLE {$CFG->prefix}data_content ALTER COLUMN content4 DROP DEFAULT");
 272     }
 273
 274     //////  DO NOT ADD NEW THINGS HERE!!  USE upgrade.php and the lib/ddllib.php functions.
 275
 276     return true;
 277 }
 278
 279 ?>