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

(-)a/installer/data/mysql/kohastructure.sql (-15 / +18 lines)
Lines 61-67 CREATE TABLE `auth_subfield_structure` ( Link Here
61
  `repeatable` tinyint(4) NOT NULL default 0,
61
  `repeatable` tinyint(4) NOT NULL default 0,
62
  `mandatory` tinyint(4) NOT NULL default 0,
62
  `mandatory` tinyint(4) NOT NULL default 0,
63
  `tab` tinyint(1) default NULL,
63
  `tab` tinyint(1) default NULL,
64
  `authorised_value` varchar(10) default NULL,
64
  `authorised_value` varchar(32) default NULL,
65
  `value_builder` varchar(80) default NULL,
65
  `value_builder` varchar(80) default NULL,
66
  `seealso` varchar(255) default NULL,
66
  `seealso` varchar(255) default NULL,
67
  `isurl` tinyint(1) default NULL,
67
  `isurl` tinyint(1) default NULL,
Lines 72-78 CREATE TABLE `auth_subfield_structure` ( Link Here
72
  `defaultvalue` TEXT,
72
  `defaultvalue` TEXT,
73
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
73
  PRIMARY KEY  (`authtypecode`,`tagfield`,`tagsubfield`),
74
  KEY `tab` (`authtypecode`,`tab`),
74
  KEY `tab` (`authtypecode`,`tab`),
75
  CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
75
  CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE,
76
  CONSTRAINT `auth_subfield_structure_ibfk_2` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
76
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
77
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
77
78
78
--
79
--
Lines 87-95 CREATE TABLE `auth_tag_structure` ( Link Here
87
  `libopac` varchar(255) NOT NULL default '',
88
  `libopac` varchar(255) NOT NULL default '',
88
  `repeatable` tinyint(4) NOT NULL default 0,
89
  `repeatable` tinyint(4) NOT NULL default 0,
89
  `mandatory` tinyint(4) NOT NULL default 0,
90
  `mandatory` tinyint(4) NOT NULL default 0,
90
  `authorised_value` varchar(10) default NULL,
91
  `authorised_value` varchar(32) default NULL,
91
  PRIMARY KEY  (`authtypecode`,`tagfield`),
92
  PRIMARY KEY  (`authtypecode`,`tagfield`),
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
93
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE,
94
  CONSTRAINT `auth_tag_structure_ibfk_2` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
94
96
95
97
Lines 220-226 CREATE TABLE `borrower_attribute_types` ( -- definitions for custom patron field Link Here
220
  `category_code` VARCHAR(10) NULL DEFAULT NULL,-- defines a category for an attribute_type
222
  `category_code` VARCHAR(10) NULL DEFAULT NULL,-- defines a category for an attribute_type
221
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
223
  `class` VARCHAR(255) NOT NULL DEFAULT '',-- defines a class for an attribute_type
222
  PRIMARY KEY  (`code`),
224
  PRIMARY KEY  (`code`),
223
  KEY `auth_val_cat_idx` (`authorised_value_category`)
225
  CONSTRAINT `bat_ibfk_1` FOREIGN KEY (`authorised_value_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
224
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
226
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
225
227
226
--
228
--
Lines 676-682 CREATE TABLE `deleteditems` ( Link Here
676
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
678
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
677
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
679
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
678
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
680
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
679
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
681
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
680
  `materials` text default NULL, -- materials specified (MARC21 952$3)
682
  `materials` text default NULL, -- materials specified (MARC21 952$3)
681
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
683
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
682
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
684
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 933-939 CREATE TABLE `items` ( -- holdings/item information Link Here
933
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
935
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
934
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
936
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
935
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
937
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
936
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
938
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
937
  `materials` text default NULL, -- materials specified (MARC21 952$3)
939
  `materials` text default NULL, -- materials specified (MARC21 952$3)
938
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
940
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
939
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
941
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 1149-1157 CREATE TABLE `marc_tag_structure` ( Link Here
1149
  `libopac` varchar(255) NOT NULL default '',
1151
  `libopac` varchar(255) NOT NULL default '',
1150
  `repeatable` tinyint(4) NOT NULL default 0,
1152
  `repeatable` tinyint(4) NOT NULL default 0,
1151
  `mandatory` tinyint(4) NOT NULL default 0,
1153
  `mandatory` tinyint(4) NOT NULL default 0,
1152
  `authorised_value` varchar(10) default NULL,
1154
  `authorised_value` varchar(32) default NULL,
1153
  `frameworkcode` varchar(4) NOT NULL default '',
1155
  `frameworkcode` varchar(4) NOT NULL default '',
1154
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1156
  PRIMARY KEY  (`frameworkcode`,`tagfield`),
1157
  CONSTRAINT `marc_tag_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
1155
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1158
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1156
1159
1157
--
1160
--
Lines 1991-1997 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1991
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1994
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1992
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1995
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1993
  `associatedborrower` int(11) default NULL, -- unused in Koha
1996
  `associatedborrower` int(11) default NULL, -- unused in Koha
1994
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1997
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1995
  KEY `timeidx` (`datetime`),
1998
  KEY `timeidx` (`datetime`),
1996
  KEY `branch_idx` (`branch`),
1999
  KEY `branch_idx` (`branch`),
1997
  KEY `proccode_idx` (`proccode`),
2000
  KEY `proccode_idx` (`proccode`),
Lines 2644-2650 CREATE TABLE branch_transfer_limits ( Link Here
2644
    toBranch varchar(10) NOT NULL,
2647
    toBranch varchar(10) NOT NULL,
2645
    fromBranch varchar(10) NOT NULL,
2648
    fromBranch varchar(10) NOT NULL,
2646
    itemtype varchar(10) NULL,
2649
    itemtype varchar(10) NULL,
2647
    ccode varchar(10) NULL,
2650
    ccode varchar(80) NULL,
2648
    PRIMARY KEY  (limitId)
2651
    PRIMARY KEY  (limitId)
2649
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2652
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2650
2653
Lines 3635-3645 CREATE TABLE `additional_fields` ( Link Here
3635
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3638
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3636
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3639
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3637
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3640
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3638
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
3641
  `authorised_value_category` varchar(32) NOT NULL DEFAULT '', -- is an authorised value category
3639
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3642
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3640
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3643
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3641
  PRIMARY KEY (`id`),
3644
  PRIMARY KEY (`id`),
3642
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
3645
  UNIQUE KEY `fields_uniq` (`tablename`,`name`),
3646
  CONSTRAINT `additional_fields_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE
3643
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3647
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3644
3648
3645
--
3649
--
Lines 3760-3766 CREATE TABLE `course_items` ( Link Here
3760
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3764
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3761
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3765
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3762
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3766
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3763
  `ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3767
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3764
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3768
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3765
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3769
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3766
  `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
3770
  `enabled` enum('yes','no') NOT NULL DEFAULT 'no', -- if at least one enabled course has this item on reseve, this field will be 'yes', otherwise it will be 'no'
3767
- 

Return to bug 18097