Bugzilla – Attachment 27439 Details for
Bug 10486
Allow external Z39.50 targets to be searched from the OPAC
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10486 followup - add tables to kohastructure.sql
Bug-10486-followup---add-tables-to-kohastructuresq.patch (text/plain), 2.00 KB, created by
Jesse Weaver
on 2014-04-22 22:15:20 UTC
(
hide
)
Description:
Bug 10486 followup - add tables to kohastructure.sql
Filename:
MIME Type:
Creator:
Jesse Weaver
Created:
2014-04-22 22:15:20 UTC
Size:
2.00 KB
patch
obsolete
>From e9eda0b578cb198a8d2860967d2c1aa3a283c999 Mon Sep 17 00:00:00 2001 >From: Jesse Weaver <pianohacker@gmail.com> >Date: Thu, 10 Apr 2014 18:38:33 -0600 >Subject: [PATCH] Bug 10486 followup - add tables to kohastructure.sql > >--- > installer/data/mysql/kohastructure.sql | 30 ++++++++++++++++++++++++++++++ > 1 file changed, 30 insertions(+) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index ea4f944..74abc9a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3379,6 +3379,36 @@ CREATE TABLE IF NOT EXISTS marc_modification_template_actions ( > CONSTRAINT `mmta_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `marc_modification_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > >+-- >+-- Table structure for table 'external_targets' >+-- >+ >+CREATE TABLE `external_targets` ( >+ `target_id` int(11) NOT NULL AUTO_INCREMENT, >+ `host` varchar(128) NOT NULL, >+ `port` int(11) NOT NULL, >+ `db` varchar(64) NOT NULL, >+ `userid` varchar(64) DEFAULT '', >+ `password` varchar(64) DEFAULT '', >+ `name` varchar(64) NOT NULL, >+ `syntax` varchar(64) NOT NULL, >+ `encoding` varchar(16) DEFAULT 'MARC-8', >+ PRIMARY KEY (`target_id`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ >+-- >+-- Table structure for table 'external_target_restrictions' >+-- >+ >+CREATE TABLE `external_target_restrictions` ( >+ `branchcode` varchar(10) NOT NULL, >+ `target_id` int(11) NOT NULL, >+ KEY `branchcode` (`branchcode`), >+ KEY `target_id` (`target_id`), >+ CONSTRAINT `external_target_restrictions_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE, >+ CONSTRAINT `external_target_restrictions_ibfk_2` FOREIGN KEY (`target_id`) REFERENCES `external_targets` (`target_id`) ON DELETE CASCADE >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ > /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; > /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; > /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; >-- >1.9.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10486
:
19142
|
19143
|
19226
|
19227
|
19680
|
21687
|
21734
|
22084
|
22540
|
23109
|
23112
|
23113
|
24036
|
24206
|
24207
|
24208
|
25235
|
25236
|
25979
|
26002
|
26017
|
26129
|
26804
|
26988
|
27275
|
27276
|
27438
|
27439
|
27440
|
27559
|
27756
|
27781
|
27783
|
27785
|
27786
|
27787
|
27788
|
27789
|
27790