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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +3 lines)
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
- 

Return to bug 26947