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

(-)a/installer/data/mysql/kohastructure.sql (+30 lines)
Lines 3387-3392 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
3391
-- This table add the ability to add new fields for a record
3392
--
3393
3394
CREATE TABLE `additional_fields` (
3395
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3396
  `tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field
3397
  `name` varchar(255) NOT NULL DEFAULT '', -- name of the field
3398
  `authorised_value_category` varchar(16) NOT NULL DEFAULT '', -- is an authorised value category
3399
  `marcfield` varchar(16) NOT NULL DEFAULT '', -- contains the marc field to copied into the record
3400
  `searchable` tinyint(1) NOT NULL DEFAULT '0', -- is the field searchable?
3401
  PRIMARY KEY (`id`),
3402
  UNIQUE KEY `fields_uniq` (`tablename`,`name`)
3403
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3404
3405
--
3406
-- Table structure for table addition_field_values
3407
-- This table store values for additional fields
3408
--
3409
3410
CREATE TABLE `additional_field_values` (
3411
  `id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier
3412
  `field_id` int(11) NOT NULL, -- foreign key references addition_fields(id)
3413
  `record_id` int(11) NOT NULL, -- record_id
3414
  `value` varchar(255) NOT NULL DEFAULT '', -- value for this field
3415
  PRIMARY KEY (`id`),
3416
  UNIQUE KEY `field_record` (`field_id`,`record_id`),
3417
  CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
3418
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3419
3390
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3420
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3391
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3421
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3392
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3422
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
(-)a/installer/data/mysql/updatedatabase.pl (-2 / +37 lines)
Lines 7130-7136 if ( CheckVersion($DBversion) ) { Link Here
7130
    SetVersion($DBversion);
7130
    SetVersion($DBversion);
7131
}
7131
}
7132
7132
7133
7134
$DBversion = "3.13.00.020";
7133
$DBversion = "3.13.00.020";
7135
if ( CheckVersion($DBversion) ) {
7134
if ( CheckVersion($DBversion) ) {
7136
    $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')");
7135
    $dbh->do("INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES('WhenLostForgiveFine','0',NULL,'If ON, Forgives the fines on an item when it is lost.','YesNo')");
Lines 7743-7748 if(CheckVersion($DBversion)) { Link Here
7743
    SetVersion($DBversion);
7742
    SetVersion($DBversion);
7744
}
7743
}
7745
7744
7745
7746
7747
7748
7749
7750
7751
7752
7753
$DBversion = "3.13.00.XXX";
7754
if ( CheckVersion($DBversion) ) {
7755
    $dbh->do(q|
7756
        CREATE TABLE `additional_fields` (
7757
          `id` int(11) NOT NULL AUTO_INCREMENT,
7758
          `tablename` varchar(255) NOT NULL DEFAULT '',
7759
          `name` varchar(255) NOT NULL DEFAULT '',
7760
          `authorised_value_category` varchar(16) NOT NULL DEFAULT '',
7761
          `marcfield` varchar(16) NOT NULL DEFAULT '',
7762
          `searchable` tinyint(1) NOT NULL DEFAULT '0',
7763
          PRIMARY KEY (`id`),
7764
          UNIQUE KEY `fields_uniq` (`tablename`,`name`)
7765
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
7766
    |);
7767
    $dbh->do(q|
7768
        CREATE TABLE `additional_field_values` (
7769
          `id` int(11) NOT NULL AUTO_INCREMENT,
7770
          `field_id` int(11) NOT NULL,
7771
          `record_id` int(11) NOT NULL,
7772
          `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
7773
          PRIMARY KEY (`id`),
7774
          UNIQUE KEY `field_record` (`field_id`,`record_id`),
7775
          CONSTRAINT `afv_fk` FOREIGN KEY (`field_id`) REFERENCES `additional_fields` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
7776
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8
7777
    |);
7778
    print "Upgrade to $DBversion done (Bug 10855: Add tables additional_fields and additional_field_values)\n";
7779
    SetVersion($DBversion);
7780
}
7781
7746
=head1 FUNCTIONS
7782
=head1 FUNCTIONS
7747
7783
7748
=head2 TableExists($table)
7784
=head2 TableExists($table)
7749
- 

Return to bug 10855