Lines 3214-3219
CREATE TABLE IF NOT EXISTS plugin_data (
Link Here
|
3214 |
PRIMARY KEY (plugin_class,plugin_key) |
3214 |
PRIMARY KEY (plugin_class,plugin_key) |
3215 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3215 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3216 |
|
3216 |
|
|
|
3217 |
-- |
3218 |
-- Table structure for table addition_fields |
3219 |
-- This table add the ability to add new fields for a record |
3220 |
-- |
3221 |
|
3222 |
CREATE TABLE `additional_fields` ( |
3223 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3224 |
`tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field |
3225 |
`name` varchar(255) NOT NULL DEFAULT '', -- name of the field |
3226 |
`authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category |
3227 |
`marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record |
3228 |
`searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable? |
3229 |
PRIMARY KEY (`id`), |
3230 |
UNIQUE KEY `fields_uniq` (`tablename`,`name`) |
3231 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 | |
3232 |
|
3233 |
-- |
3234 |
-- Table structure for table addition_field_values |
3235 |
-- This table store values for additional fields |
3236 |
-- |
3237 |
|
3238 |
CREATE TABLE `additional_field_values` ( |
3239 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3240 |
`field_id` int(11) NOT NULL, -- foreign key references addition_fields(id) |
3241 |
`record_id` int(11) NOT NULL, -- record_id |
3242 |
`value` varchar(255) NOT NULL DEFAULT '', -- value for this field |
3243 |
PRIMARY KEY (`id`), |
3244 |
UNIQUE KEY `field_record` (`field_id`,`record_id`), |
3245 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
3246 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 | |
3247 |
|
3217 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3248 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3218 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3249 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3219 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3250 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |