postgres7.php

很棒的在线教学系统

          grade int4 NOT NULL default '0',
          custom int4 NOT NULL default '0',
          ongoing int4 NOT NULL default '0',
          usemaxgrade int4 NOT NULL default '0',
          maxanswers int4 NOT NULL default '4',
          maxattempts int4 NOT NULL default '5',
          review int4 NOT NULL default '0',
          nextpagedefault int4 NOT NULL default '0',
          minquestions int4 NOT NULL default '0',
          maxpages int4 NOT NULL default '0',
          timed int4 NOT NULL default '0',
          maxtime int8 NOT NULL default '0',
          retake int4 NOT NULL default '1',
          tree int4 NOT NULL default '0',
          slideshow int4 NOT NULL default '0',
          width int8 NOT NULL default '640',
          height int8 NOT NULL default '480',
          bgcolor varchar(7) default '#FFFFFF',
          displayleft int4 NOT NULL default '0',
          highscores int4 NOT NULL default '0',
          maxhighscores int8 NOT NULL default '0'
        )");
    }
    
    if ($oldversion < 2004100400) {
        //execute_sql(" ALTER TABLE `{$CFG->prefix}lesson_attempts` ADD `useranswer` text NOT NULL AFTER correct");
        table_column('lesson_attempts', '', 'useranswer', 'text', '', '', '', 'NOT NULL', 'correct');
    }
    
    if ($oldversion < 2004100700) {
        //execute_sql(" ALTER TABLE `{$CFG->prefix}lesson` ADD `modattempts` tinyint(3) unsigned NOT NULL default '0' AFTER practice");
        table_column('lesson', '', 'modattempts', 'INT', '4', 'unsigned', '0', 'NOT NULL', 'practice');
    }

    if ($oldversion < 2004102600) {
        //execute_sql(" ALTER TABLE `{$CFG->prefix}lesson_default` ADD `modattempts` tinyint(3) unsigned NOT NULL default '0' AFTER practice");
        table_column('lesson_default', '', 'modattempts', 'INT', '4', 'unsigned', '0', 'NOT NULL', 'practice');
    }

    if ($oldversion < 2004111200) {
        execute_sql("DROP INDEX {$CFG->prefix}lesson_course_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_answers_lessonid_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_answers_pageid_idx;",false); 
        execute_sql("DROP INDEX {$CFG->prefix}lesson_attempts_lessonid_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_attempts_pageid_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_attempts_userid_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_grades_lessonid_idx;",false);
        execute_sql("DROP INDEX {$CFG->prefix}lesson_grades_userid_idx;",false); 
        execute_sql("DROP INDEX {$CFG->prefix}lesson_pages_lessonid_idx;",false);

        modify_database('','CREATE INDEX prefix_lesson_course_idx ON prefix_lesson (course);');
        modify_database('','CREATE INDEX prefix_lesson_answers_lessonid_idx ON prefix_lesson_answers (lessonid);');
        modify_database('','CREATE INDEX prefix_lesson_answers_pageid_idx ON prefix_lesson_answers (pageid);');
        modify_database('','CREATE INDEX prefix_lesson_attempts_lessonid_idx ON prefix_lesson_attempts (lessonid);');
        modify_database('','CREATE INDEX prefix_lesson_attempts_pageid_idx ON prefix_lesson_attempts (pageid);');
        modify_database('','CREATE INDEX prefix_lesson_attempts_userid_idx ON prefix_lesson_attempts (userid);');
        modify_database('','CREATE INDEX prefix_lesson_grades_lessonid_idx ON prefix_lesson_grades (lessonid);');
        modify_database('','CREATE INDEX prefix_lesson_grades_userid_idx ON prefix_lesson_grades (userid);');
        modify_database('','CREATE INDEX prefix_lesson_pages_lessonid_idx ON prefix_lesson_pages (lessonid);');
   }
   
    if ($oldversion < 2005060900) {
        table_column('lesson_grades', 'grade', 'grade', 'real', '', 'unsigned', '0', 'not null');
    }
    
    if ($oldversion < 2005060901) { // Mass cleanup of bad postgres upgrade scripts
        modify_database('','ALTER TABLE prefix_lesson ALTER bgcolor SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER custom SET NOT NULL');
        table_column('lesson','height','height','integer','16','unsigned','480');
        modify_database('','ALTER TABLE prefix_lesson ALTER highscores SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER maxattempts SET DEFAULT 5');
        table_column('lesson','maxhighscores','maxhighscores','integer','16');
        modify_database('','ALTER TABLE prefix_lesson ALTER displayleft SET NOT NULL');
        table_column('lesson','','minquestions','integer','8');
        notify('The above error can be ignored if the column already exists, its possible that it was cleaned up already before running this upgrade');
        table_column('lesson','maxtime','maxtime','integer','16');
        modify_database('','ALTER TABLE prefix_lesson ALTER ongoing SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER password SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER practice SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER review SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER slideshow SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER timed SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER tree SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER usepassword SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson ALTER width SET NOT NULL');
        table_column('lesson','width','width','integer','16','unsigned','640');
        table_column('lesson_answers','flags','flags','integer','8');
        table_column('lesson_answers','grade','grade','integer','8');
        table_column('lesson_answers','score','score','integer','16');
        modify_database('','ALTER TABLE prefix_lesson_grades ALTER grade SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson_pages ALTER display SET NOT NULL');
        modify_database('','ALTER TABLE prefix_lesson_pages ALTER layout SET NOT NULL');
        table_column('lesson_pages','qoption','qoption','integer','8');
        table_column('lesson_pages','qtype','qtype','integer','8');
    }

    if ($oldversion < 2005061500) {
        table_column('lesson', '', 'mediafile', 'varchar', '255', '', '', 'not null', 'tree');
    }
    
    if ($oldversion < 2005063000) {
        table_column('lesson', '', 'dependency', 'INT', '8', 'unsigned', '0', 'not null', 'usepassword');
        table_column('lesson', '', 'conditions', 'text', '', '', '', 'not null', 'dependency');
    }
    
    if ($oldversion < 2005101900) {
        table_column('lesson', '', 'progressbar', 'INT', '3', 'unsigned', '0', 'not null', 'displayleft');
        table_column('lesson', '', 'displayleftif', 'INT', '3', 'unsigned', '0', 'not null', 'displayleft');
    }
    
    if ($oldversion < 2005102800) {
        table_column('lesson', '', 'mediaclose', 'INT', '3', 'unsigned', '0', 'not null', 'mediafile');
        table_column('lesson', '', 'mediaheight', 'INT', '10', 'unsigned', '100', 'not null', 'mediafile');
        table_column('lesson', '', 'mediawidth', 'INT', '10', 'unsigned', '650', 'not null', 'mediafile');
    }

    if ($oldversion < 2005110200) {
        table_column('lesson', '', 'activitylink', 'INT', '10', 'unsigned', '0', 'not null', 'tree');
    }
    
    if ($oldversion < 2006031900) {
        execute_sql('ALTER TABLE  '. $CFG->prefix . 'lesson DROP COLUMN tree');
        execute_sql('ALTER TABLE  '. $CFG->prefix . 'lesson_default DROP COLUMN tree');
    }
    
    if ($oldversion < 2006050100) {   
        table_column('lesson_default', '', 'conditions', 'text', '', '', '', 'not null', 'password');
        table_column('lesson_default', '', 'progressbar', 'tinyint', '3', 'unsigned', '0', 'not null', 'displayleft');
        table_column('lesson_default', '', 'displayleftif', 'int', '3', 'unsigned', '0', 'not null', 'displayleft'); 
        table_column('lesson_default', '', 'mediaclose', 'tinyint', '3', 'unsigned', '0', 'not null', 'retake');
        table_column('lesson_default', '', 'mediaheight', 'int', '10', 'unsigned', '100', 'not null', 'retake');
        table_column('lesson_default', '', 'mediawidth', 'int', '10', 'unsigned', '650', 'not null', 'retake');
    }

    if ($oldversion < 2006050101) {
        // drop the unused table
        execute_sql('DROP TABLE '.$CFG->prefix.'lesson_essay', false);

        // properly set the correct default values
        table_column('lesson', 'activitylink', 'activitylink', 'integer', '8', '', '0');
        table_column('lesson', 'dependency', 'dependency', 'integer', '8', '', '0');

        modify_database('', 'ALTER TABLE prefix_lesson_timer
            ALTER COLUMN lessontime SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_timer
            ALTER COLUMN lessonid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_timer
            ALTER COLUMN userid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_timer
            ALTER COLUMN starttime SET DEFAULT 0');

        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN lessonid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN timeseen SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN userid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN retry SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN pageid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_branch
            ALTER COLUMN flag SET DEFAULT 0');

        modify_database('', 'ALTER TABLE prefix_lesson_high_scores
            ALTER COLUMN nickname SET DEFAULT \'\'');
        modify_database('', 'ALTER TABLE prefix_lesson_high_scores
            ALTER COLUMN lessonid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_high_scores
            ALTER COLUMN gradeid SET DEFAULT 0');
        modify_database('', 'ALTER TABLE prefix_lesson_high_scores
            ALTER COLUMN userid SET DEFAULT 0');
    }
    
    if ($oldversion < 2006091202) {
        table_column('lesson', '', 'feedback', 'int', '3', 'unsigned', '1', 'not null', 'nextpagedefault'); 
        table_column('lesson_default', '', 'feedback', 'int', '3', 'unsigned', '1', 'not null', 'nextpagedefault'); 
    }

    //////  DO NOT ADD NEW THINGS HERE!!  USE upgrade.php and the lib/ddllib.php functions.

   return true;
}

?>