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