View | Details | Raw Unified | Return to bug 10855
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_10855.sql (+20 lines)
Line 0 Link Here
1
CREATE TABLE `additional_fields` (
2
  `id` int(11) NOT NULL AUTO_INCREMENT,
3
  `tablename` varchar(255) NOT NULL DEFAULT '',
4
  `name` varchar(255) NOT NULL DEFAULT '',
5
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
6
  `marcfield` varchar(16) NOT NULL DEFAULT '',
7
  `searchable` tinyint(1) NOT NULL DEFAULT '0',
8
  PRIMARY KEY (`id`),
9
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
10
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
11
12
CREATE TABLE `additional_field_values` (
13
  `id` int(11) NOT NULL AUTO_INCREMENT,
14
  `field_id` int(11) NOT NULL,
15
  `record_id` int(11) NOT NULL,
16
  `value` varchar(255) NOT NULL DEFAULT '',
17
  PRIMARY KEY (`id`),
18
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
19
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
20
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +31 lines)
Lines 3534-3539 CREATE TABLE discharges ( Link Here
3534
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3534
  CONSTRAINT borrower_discharges_ibfk1 FOREIGN KEY (borrower) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE
3535
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3535
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3536
3536
3537
--
3538
-- Table structure for table additional_fields
3539
-- This table add the ability to add new fields for a record
3540
--
3541
3542
CREATE TABLE `additional_fields` (
3543
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3544
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3545
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3546
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
3547
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3548
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3549
  PRIMARY KEY (`id`),
3550
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
3551
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3552
3553
--
3554
-- Table structure for table additional_field_values
3555
-- This table store values for additional fields
3556
--
3557
3558
CREATE TABLE `additional_field_values` (
3559
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3560
  `field_id` int(11) NOT NULL, -- foreign key references additional_fields(id)
3561
  `record_id` int(11) NOT NULL, -- record_id
3562
  `value` varchar(255) NOT NULL DEFAULT '', -- value for this field
3563
  PRIMARY KEY (`id`),
3564
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
3565
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3566
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3567
3537
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3568
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3538
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3569
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3539
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3570
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3540
- 

Return to bug 10855