Lines 3387-3393
CREATE TABLE IF NOT EXISTS marc_modification_template_actions (
Link Here
|
3387 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3387 |
CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE |
3388 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3388 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
3389 |
|
3389 |
|
3390 |
-- Table structure for table addition_fields |
3390 |
-- Table structure for table additional_fields |
3391 |
-- This table add the ability to add new fields for a record |
3391 |
-- This table add the ability to add new fields for a record |
3392 |
-- |
3392 |
-- |
3393 |
|
3393 |
|
Lines 3409-3415
CREATE TABLE `additional_fields` (
Link Here
|
3409 |
|
3409 |
|
3410 |
CREATE TABLE `additional_field_values` ( |
3410 |
CREATE TABLE `additional_field_values` ( |
3411 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3411 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3412 |
`field_id` int(11) NOT NULL, -- foreign key references addition_fields(id) |
3412 |
`field_id` int(11) NOT NULL, -- foreign key references additional_fields(id) |
3413 |
`record_id` int(11) NOT NULL, -- record_id |
3413 |
`record_id` int(11) NOT NULL, -- record_id |
3414 |
`value` varchar(255) NOT NULL DEFAULT '', -- value for this field |
3414 |
`value` varchar(255) NOT NULL DEFAULT '', -- value for this field |
3415 |
PRIMARY KEY (`id`), |
3415 |
PRIMARY KEY (`id`), |
3416 |
- |
|
|