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

(-)a/installer/data/mysql/kohastructure.sql (-11 / +10 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(80) 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 87-93 CREATE TABLE `auth_tag_structure` ( Link Here
87
  `libopac` varchar(255) NOT NULL default '',
87
  `libopac` varchar(255) NOT NULL default '',
88
  `repeatable` tinyint(4) NOT NULL default 0,
88
  `repeatable` tinyint(4) NOT NULL default 0,
89
  `mandatory` tinyint(4) NOT NULL default 0,
89
  `mandatory` tinyint(4) NOT NULL default 0,
90
  `authorised_value` varchar(10) default NULL,
90
  `authorised_value` varchar(80) default NULL,
91
  PRIMARY KEY  (`authtypecode`,`tagfield`),
91
  PRIMARY KEY  (`authtypecode`,`tagfield`),
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 647-653 CREATE TABLE `deleteditems` ( Link Here
647
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
647
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
648
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
648
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
649
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
649
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
650
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
650
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
651
  `materials` text default NULL, -- materials specified (MARC21 952$3)
651
  `materials` text default NULL, -- materials specified (MARC21 952$3)
652
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
652
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
653
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
653
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 888-894 CREATE TABLE `items` ( -- holdings/item information Link Here
888
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
888
  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
889
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
889
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
890
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
890
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
891
  `ccode` varchar(10) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
891
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
892
  `materials` text default NULL, -- materials specified (MARC21 952$3)
892
  `materials` text default NULL, -- materials specified (MARC21 952$3)
893
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
893
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
894
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
894
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
Lines 1071-1077 CREATE TABLE `marc_subfield_structure` ( Link Here
1071
  `mandatory` tinyint(4) NOT NULL default 0,
1071
  `mandatory` tinyint(4) NOT NULL default 0,
1072
  `kohafield` varchar(40) default NULL,
1072
  `kohafield` varchar(40) default NULL,
1073
  `tab` tinyint(1) default NULL,
1073
  `tab` tinyint(1) default NULL,
1074
  `authorised_value` varchar(20) default NULL,
1074
  `authorised_value` varchar(80) default NULL,
1075
  `authtypecode` varchar(20) default NULL,
1075
  `authtypecode` varchar(20) default NULL,
1076
  `value_builder` varchar(80) default NULL,
1076
  `value_builder` varchar(80) default NULL,
1077
  `isurl` tinyint(1) default NULL,
1077
  `isurl` tinyint(1) default NULL,
Lines 1098-1104 CREATE TABLE `marc_tag_structure` ( Link Here
1098
  `libopac` varchar(255) NOT NULL default '',
1098
  `libopac` varchar(255) NOT NULL default '',
1099
  `repeatable` tinyint(4) NOT NULL default 0,
1099
  `repeatable` tinyint(4) NOT NULL default 0,
1100
  `mandatory` tinyint(4) NOT NULL default 0,
1100
  `mandatory` tinyint(4) NOT NULL default 0,
1101
  `authorised_value` varchar(10) default NULL,
1101
  `authorised_value` varchar(80) default NULL,
1102
  `frameworkcode` varchar(4) NOT NULL default '',
1102
  `frameworkcode` varchar(4) NOT NULL default '',
1103
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1103
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
1104
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1104
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 1847-1853 CREATE TABLE `statistics` ( -- information related to transactions (circulation Link Here
1847
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1847
  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
1848
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1848
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
1849
  `associatedborrower` int(11) default NULL, -- unused in Koha
1849
  `associatedborrower` int(11) default NULL, -- unused in Koha
1850
  `ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1850
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
1851
  KEY `timeidx` (`datetime`),
1851
  KEY `timeidx` (`datetime`),
1852
  KEY `branch_idx` (`branch`),
1852
  KEY `branch_idx` (`branch`),
1853
  KEY `proccode_idx` (`proccode`),
1853
  KEY `proccode_idx` (`proccode`),
Lines 2508-2514 CREATE TABLE branch_transfer_limits ( Link Here
2508
    toBranch varchar(10) NOT NULL,
2508
    toBranch varchar(10) NOT NULL,
2509
    fromBranch varchar(10) NOT NULL,
2509
    fromBranch varchar(10) NOT NULL,
2510
    itemtype varchar(10) NULL,
2510
    itemtype varchar(10) NULL,
2511
    ccode varchar(10) NULL,
2511
    ccode varchar(80) NULL,
2512
    PRIMARY KEY  (limitId)
2512
    PRIMARY KEY  (limitId)
2513
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2513
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2514
2514
Lines 3417-3423 CREATE TABLE `additional_fields` ( Link Here
3417
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3417
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3418
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3418
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3419
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3419
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3420
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
3420
  `authorised_value_category` varchar(32) NOT NULL DEFAULT '', -- is an authorised value category
3421
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3421
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3422
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3422
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3423
  PRIMARY KEY (`id`),
3423
  PRIMARY KEY (`id`),
Lines 3528-3534 CREATE TABLE `course_items` ( Link Here
3528
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3528
  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
3529
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3529
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
3530
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3530
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
3531
  `ccode` varchar(10) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3531
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
3532
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3532
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
3533
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3533
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
3534
  `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'
3534
  `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'
3535
- 

Return to bug 18097