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

(-)a/installer/data/mysql/kohastructure.sql (+31 lines)
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 */;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +31 lines)
Lines 9835-9840 if(CheckVersion($DBversion)) { Link Here
9835
    });
9835
    });
9836
9836
9837
    print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
9837
    print "Upgrade to $DBversion done (Bug 13523 - Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES)\n";
9838
    SetVersion ($DBversion);
9839
}
9840
9841
9842
9843
$DBversion = "3.19.00.XXX";
9844
if ( CheckVersion($DBversion) ) {
9845
    $dbh->do(q|
9846
        CREATE TABLE `additional_fields` (
9847
          `id` int(11) NOT NULL AUTO_INCREMENT,
9848
          `tablename` varchar(255) NOT NULL DEFAULT '',
9849
          `name` varchar(255) NOT NULL DEFAULT '',
9850
          `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
9851
          `marcfield` varchar(16) NOT NULL DEFAULT '',
9852
          `searchable` tinyint(1) NOT NULL DEFAULT '0',
9853
          PRIMARY KEY (`id`),
9854
          UNIQUE KEY `fields_uniq` (`tablename`,`name`)
9855
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9856
    |);
9857
    $dbh->do(q|
9858
        CREATE TABLE `additional_field_values` (
9859
          `id` int(11) NOT NULL AUTO_INCREMENT,
9860
          `field_id` int(11) NOT NULL,
9861
          `record_id` int(11) NOT NULL,
9862
          `value` varchar(255) NOT NULL DEFAULT '',
9863
          PRIMARY KEY (`id`),
9864
          UNIQUE KEY `field_record` (`field_id`,`record_id`),
9865
          CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
9866
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
9867
    |);
9868
    print "Upgrade to $DBversion done (Bug 10855: Add tables additional_fields and additional_field_values)\n";
9838
    SetVersion($DBversion);
9869
    SetVersion($DBversion);
9839
}
9870
}
9840
9871
9841
- 

Return to bug 10855