Lines 1120-1126
CREATE TABLE `marc_subfield_structure` (
Link Here
|
1120 |
`mandatory` tinyint(4) NOT NULL default 0, |
1120 |
`mandatory` tinyint(4) NOT NULL default 0, |
1121 |
`kohafield` varchar(40) default NULL, |
1121 |
`kohafield` varchar(40) default NULL, |
1122 |
`tab` tinyint(1) default NULL, |
1122 |
`tab` tinyint(1) default NULL, |
1123 |
`authorised_value` varchar(20) default NULL, |
1123 |
`authorised_value` varchar(32) default NULL, |
1124 |
`authtypecode` varchar(20) default NULL, |
1124 |
`authtypecode` varchar(20) default NULL, |
1125 |
`value_builder` varchar(80) default NULL, |
1125 |
`value_builder` varchar(80) default NULL, |
1126 |
`isurl` tinyint(1) default NULL, |
1126 |
`isurl` tinyint(1) default NULL, |
Lines 1133-1139
CREATE TABLE `marc_subfield_structure` (
Link Here
|
1133 |
PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), |
1133 |
PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`), |
1134 |
KEY `kohafield_2` (`kohafield`), |
1134 |
KEY `kohafield_2` (`kohafield`), |
1135 |
KEY `tab` (`frameworkcode`,`tab`), |
1135 |
KEY `tab` (`frameworkcode`,`tab`), |
1136 |
KEY `kohafield` (`frameworkcode`,`kohafield`) |
1136 |
KEY `kohafield` (`frameworkcode`,`kohafield`), |
|
|
1137 |
CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY (`authorised_value`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE |
1137 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1138 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1138 |
|
1139 |
|
1139 |
-- |
1140 |
-- |
1140 |
- |
|
|