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