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

(-)a/installer/data/mysql/kohastructure.sql (+31 lines)
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 */;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +32 lines)
Lines 9669-9674 if ( CheckVersion($DBversion) ) { Link Here
9669
    SetVersion ($DBversion);
9669
    SetVersion ($DBversion);
9670
}
9670
}
9671
9671
9672
9673
9674
9675
$DBversion = "3.19.00.XXX";
9676
if ( CheckVersion($DBversion) ) {
9677
    $dbh->do(q|
9678
        CREATE TABLE `additional_fields` (
9679
          `id` int(11) NOT NULL AUTO_INCREMENT,
9680
          `tablename` varchar(255) NOT NULL DEFAULT '',
9681
          `name` varchar(255) NOT NULL DEFAULT '',
9682
          `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
9683
          `marcfield` varchar(16) NOT NULL DEFAULT '',
9684
          `searchable` tinyint(1) NOT NULL DEFAULT '0',
9685
          PRIMARY KEY (`id`),
9686
          UNIQUE KEY `fields_uniq` (`tablename`,`name`)
9687
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9688
    |);
9689
    $dbh->do(q|
9690
        CREATE TABLE `additional_field_values` (
9691
          `id` int(11) NOT NULL AUTO_INCREMENT,
9692
          `field_id` int(11) NOT NULL,
9693
          `record_id` int(11) NOT NULL,
9694
          `value` varchar(255) NOT NULL DEFAULT '',
9695
          PRIMARY KEY (`id`),
9696
          UNIQUE KEY `field_record` (`field_id`,`record_id`),
9697
          CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
9698
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9699
    |);
9700
    print "Upgrade to $DBversion done (Bug 10855: Add tables additional_fields and additional_field_values)\n";
9701
    SetVersion($DBversion);
9702
}
9703
9672
=head1 FUNCTIONS
9704
=head1 FUNCTIONS
9673
9705
9674
=head2 TableExists($table)
9706
=head2 TableExists($table)
9675
- 

Return to bug 10855