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 7050-7055 if ( CheckVersion($DBversion) ) { Link Here
7050
    SetVersion($DBversion);
7050
    SetVersion($DBversion);
7051
}
7051
}
7052
7052
7053
$DBversion = "3.13.00.XXX";
7054
if ( CheckVersion($DBversion) ) {
7055
    $dbh->do("ALTER TABLE courses MODIFY COLUMN department varchar(80) DEFAULT NULL;");
7056
    $dbh->do("ALTER TABLE courses MODIFY COLUMN term       varchar(80) DEFAULT NULL;");
7057
    print "Upgrade to $DBversion done (Bug 10604: correct width of courses.department and courses.term)\n";
7058
    SetVersion($DBversion);
7059
}
7060
7053
=head1 FUNCTIONS
7061
=head1 FUNCTIONS
7054
7062
7055
=head2 TableExists($table)
7063
=head2 TableExists($table)
7056
- 

Return to bug 10604