View | Details | Raw Unified | Return to bug 10604
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 478-488 CREATE TABLE collections_tracking ( Link Here
478
DROP TABLE IF EXISTS courses;
478
DROP TABLE IF EXISTS courses;
479
CREATE TABLE `courses` (
479
CREATE TABLE `courses` (
480
  `course_id` int(11) NOT NULL AUTO_INCREMENT,
480
  `course_id` int(11) NOT NULL AUTO_INCREMENT,
481
  `department` varchar(20) DEFAULT NULL, -- Stores the authorised value DEPT
481
  `department` varchar(80) DEFAULT NULL, -- Stores the authorised value DEPT
482
  `course_number` varchar(255) DEFAULT NULL, -- An arbitrary field meant to store the "course number" assigned to a course
482
  `course_number` varchar(255) DEFAULT NULL, -- An arbitrary field meant to store the "course number" assigned to a course
483
  `section` varchar(255) DEFAULT NULL, -- Also arbitrary, but for the 'section' of a course.
483
  `section` varchar(255) DEFAULT NULL, -- Also arbitrary, but for the 'section' of a course.
484
  `course_name` varchar(255) DEFAULT NULL,
484
  `course_name` varchar(255) DEFAULT NULL,
485
  `term` varchar(20) DEFAULT NULL, -- Stores the authorised value TERM
485
  `term` varchar(80) DEFAULT NULL, -- Stores the authorised value TERM
486
  `staff_note` mediumtext,
486
  `staff_note` mediumtext,
487
  `public_note` mediumtext,
487
  `public_note` mediumtext,
488
  `students_count` varchar(20) DEFAULT NULL, -- Meant to be just an estimate of how many students will be taking this course/section
488
  `students_count` varchar(20) DEFAULT NULL, -- Meant to be just an estimate of how many students will be taking this course/section
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7044-7049 if ( CheckVersion($DBversion) ) { Link Here
7044
    SetVersion($DBversion);
7044
    SetVersion($DBversion);
7045
}
7045
}
7046
7046
7047
$DBversion = "3.13.00.XXX";
7048
if ( CheckVersion($DBversion) ) {
7049
    $dbh->do("ALTER TABLE courses MODIFY COLUMN department varchar(80) DEFAULT NULL;");
7050
    $dbh->do("ALTER TABLE courses MODIFY COLUMN term       varchar(80) DEFAULT NULL;");
7051
    print "Upgrade to $DBversion done (Bug 10604: correct width of courses.department and courses.term)\n";
7052
    SetVersion($DBversion);
7053
}
7054
7047
=head1 FUNCTIONS
7055
=head1 FUNCTIONS
7048
7056
7049
=head2 TableExists($table)
7057
=head2 TableExists($table)
7050
- 

Return to bug 10604