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 |