Lines 939-945
CREATE TABLE `itemtypes` ( -- defines the item types
Link Here
|
939 |
imageurl varchar(200) default NULL COMMENT "URL for the item type icon", |
939 |
imageurl varchar(200) default NULL COMMENT "URL for the item type icon", |
940 |
summary MEDIUMTEXT COMMENT "information from the summary field, may include HTML", |
940 |
summary MEDIUMTEXT COMMENT "information from the summary field, may include HTML", |
941 |
checkinmsg VARCHAR(255) COMMENT "message that is displayed when an item with the given item type is checked in", |
941 |
checkinmsg VARCHAR(255) COMMENT "message that is displayed when an item with the given item type is checked in", |
942 |
checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL COMMENT "type (CSS class) for the checkinmsg, can be "alert" or "message"", |
942 |
checkinmsgtype CHAR(16) DEFAULT 'message' NOT NULL COMMENT "type (CSS class) for the checkinmsg, can be 'alert' or 'message'", |
943 |
sip_media_type VARCHAR(3) DEFAULT NULL COMMENT "SIP2 protocol media type for this itemtype", |
943 |
sip_media_type VARCHAR(3) DEFAULT NULL COMMENT "SIP2 protocol media type for this itemtype", |
944 |
hideinopac tinyint(1) NOT NULL DEFAULT 0 COMMENT "Hide the item type from the search options in OPAC", |
944 |
hideinopac tinyint(1) NOT NULL DEFAULT 0 COMMENT "Hide the item type from the search options in OPAC", |
945 |
searchcategory varchar(80) default NULL COMMENT "Group this item type with others with the same value on OPAC search options", |
945 |
searchcategory varchar(80) default NULL COMMENT "Group this item type with others with the same value on OPAC search options", |
Lines 3904-3910
DROP TABLE IF EXISTS courses;
Link Here
|
3904 |
CREATE TABLE `courses` ( |
3904 |
CREATE TABLE `courses` ( |
3905 |
`course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT "unique id for the course", |
3905 |
`course_id` int(11) NOT NULL AUTO_INCREMENT COMMENT "unique id for the course", |
3906 |
`department` varchar(80) DEFAULT NULL COMMENT "the authorised value for the DEPARTMENT", |
3906 |
`department` varchar(80) DEFAULT NULL COMMENT "the authorised value for the DEPARTMENT", |
3907 |
`course_number` varchar(255) DEFAULT NULL COMMENT "the "course number" assigned to a course", |
3907 |
`course_number` varchar(255) DEFAULT NULL COMMENT "the 'course number' assigned to a course", |
3908 |
`section` varchar(255) DEFAULT NULL COMMENT "the 'section' of a course", |
3908 |
`section` varchar(255) DEFAULT NULL COMMENT "the 'section' of a course", |
3909 |
`course_name` varchar(255) DEFAULT NULL COMMENT "the name of the course", |
3909 |
`course_name` varchar(255) DEFAULT NULL COMMENT "the name of the course", |
3910 |
`term` varchar(80) DEFAULT NULL COMMENT "the authorised value for the TERM", |
3910 |
`term` varchar(80) DEFAULT NULL COMMENT "the authorised value for the TERM", |
Lines 4413-4419
CREATE TABLE library_groups (
Link Here
|
4413 |
branchcode VARCHAR(10) NULL DEFAULT NULL COMMENT "The branchcode of a branch belonging to the parent group", |
4413 |
branchcode VARCHAR(10) NULL DEFAULT NULL COMMENT "The branchcode of a branch belonging to the parent group", |
4414 |
title VARCHAR(100) NULL DEFAULT NULL COMMENT "Short description of the goup", |
4414 |
title VARCHAR(100) NULL DEFAULT NULL COMMENT "Short description of the goup", |
4415 |
description MEDIUMTEXT NULL DEFAULT NULL COMMENT "Longer explanation of the group, if necessary", |
4415 |
description MEDIUMTEXT NULL DEFAULT NULL COMMENT "Longer explanation of the group, if necessary", |
4416 |
ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0 COMMENT "Turn on the feature "Hide patron's info" for this group", |
4416 |
ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0 COMMENT "Turn on the feature 'Hide patron's info' for this group", |
4417 |
ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group for staff side search groups", |
4417 |
ft_search_groups_opac tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group for staff side search groups", |
4418 |
ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group for opac side search groups", |
4418 |
ft_search_groups_staff tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group for opac side search groups", |
4419 |
ft_local_hold_group tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group to identify libraries as pick up location for holds", |
4419 |
ft_local_hold_group tinyint(1) NOT NULL DEFAULT 0 COMMENT "Use this group to identify libraries as pick up location for holds", |
4420 |
- |
|
|