Attachment #60121 for bug #18097

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




  `repeatable` tinyint(4) NOT NULL default 0,
  `mandatory` tinyint(4) NOT NULL default 0,
  `tab` tinyint(1) default NULL,
  `authorised_value` varchar(80) default NULL,
  `value_builder` varchar(80) default NULL,
  `seealso` varchar(255) default NULL,
  `isurl` tinyint(1) default NULL,

  `libopac` varchar(255) NOT NULL default '',
  `repeatable` tinyint(4) NOT NULL default 0,
  `mandatory` tinyint(4) NOT NULL default 0,
  `authorised_value` varchar(80) default NULL,
  PRIMARY KEY  (`authtypecode`,`tagfield`),
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
  `cn_sort` varchar(255) default NULL, -- normalized form of the call number (MARC21 952$o) used for sorting
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
  `materials` text default NULL, -- materials specified (MARC21 952$3)
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

  `onloan` date default NULL, -- defines if item is checked out (NULL for not checked out, and checkout date for checked out)
  `cn_source` varchar(10) default NULL, -- classification source used on this item (MARC21 952$2)
  `cn_sort` varchar(255) default NULL,  -- normalized form of the call number (MARC21 952$o) used for sorting
  `ccode` varchar(80) default NULL, -- authorized value for the collection code associated with this item (MARC21 952$8)
  `materials` text default NULL, -- materials specified (MARC21 952$3)
  `uri` varchar(255) default NULL, -- URL for the item (MARC21 952$u)
  `itype` varchar(10) default NULL, -- foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

  `mandatory` tinyint(4) NOT NULL default 0,
  `kohafield` varchar(40) default NULL,
  `tab` tinyint(1) default NULL,
  `authorised_value` varchar(80) default NULL,
  `authtypecode` varchar(20) default NULL,
  `value_builder` varchar(80) default NULL,
  `isurl` tinyint(1) default NULL,

  `libopac` varchar(255) NOT NULL default '',
  `repeatable` tinyint(4) NOT NULL default 0,
  `mandatory` tinyint(4) NOT NULL default 0,
  `authorised_value` varchar(80) default NULL,
  `frameworkcode` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`frameworkcode`,`tagfield`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

  `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower
  `associatedborrower` int(11) default NULL, -- unused in Koha
  `ccode` varchar(80) default NULL, -- foreign key from the items table, links transaction to a specific collection code
  KEY `timeidx` (`datetime`),
  KEY `branch_idx` (`branch`),
  KEY `proccode_idx` (`proccode`),

    toBranch varchar(10) NOT NULL,
    fromBranch varchar(10) NOT NULL,
    itemtype varchar(10) NULL,
    ccode varchar(80) NULL,
    PRIMARY KEY  (limitId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
  `authorised_value_category` varchar(32) NOT NULL DEFAULT '', -- is an authorised value category
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
  PRIMARY KEY (`id`),

  `ci_id` int(11) NOT NULL AUTO_INCREMENT, -- course item id
  `itemnumber` int(11) NOT NULL, -- items.itemnumber for the item on reserve
  `itype` varchar(10) DEFAULT NULL, -- new itemtype for the item to have while on reserve (optional)
  `ccode` varchar(80) DEFAULT NULL, -- new category code for the item to have while on reserve (optional)
  `holdingbranch` varchar(10) DEFAULT NULL, -- new holding branch for the item to have while on reserve (optional)
  `location` varchar(80) DEFAULT NULL, -- new shelving location for the item to have while on reseve (optional)
  `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'
- 

Return to bug 18097

Lines 61-67 CREATE TABLE `auth_subfield_structure` ( Link Here

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