Lines 3502-3507
CREATE TABLE items_search_fields (
Link Here
|
3502 |
ON DELETE SET NULL ON UPDATE CASCADE |
3502 |
ON DELETE SET NULL ON UPDATE CASCADE |
3503 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3503 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3504 |
|
3504 |
|
|
|
3505 |
-- |
3506 |
-- Table structure for table additional_fields |
3507 |
-- This table add the ability to add new fields for a record |
3508 |
-- |
3509 |
|
3510 |
CREATE TABLE `additional_fields` ( |
3511 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3512 |
`tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field |
3513 |
`name` varchar(255) NOT NULL DEFAULT '', -- name of the field |
3514 |
`authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category |
3515 |
`marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record |
3516 |
`searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable? |
3517 |
PRIMARY KEY (`id`), |
3518 |
UNIQUE KEY `fields_uniq` (`tablename`,`name`) |
3519 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3520 |
|
3521 |
-- |
3522 |
-- Table structure for table additional_field_values |
3523 |
-- This table store values for additional fields |
3524 |
-- |
3525 |
|
3526 |
CREATE TABLE `additional_field_values` ( |
3527 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3528 |
`field_id` int(11) NOT NULL, -- foreign key references additional_fields(id) |
3529 |
`record_id` int(11) NOT NULL, -- record_id |
3530 |
`value` varchar(255) NOT NULL DEFAULT '', -- value for this field |
3531 |
PRIMARY KEY (`id`), |
3532 |
UNIQUE KEY `field_record` (`field_id`,`record_id`), |
3533 |
CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
3534 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3535 |
|
3505 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3536 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3506 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3537 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3507 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
3538 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |