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

(-)a/installer/data/mysql/atomicupdate/bug_40841_z3950_library_limits.pl (+26 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "40841",
5
    description => "Add library limits support for Z39.50 servers",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        unless ( TableExists('z3950servers_branches') ) {
11
            $dbh->do(
12
                q{
13
                CREATE TABLE z3950servers_branches (
14
                  server_id int(11) NOT NULL COMMENT 'z3950server id',
15
                  branchcode varchar(10) NOT NULL COMMENT 'branch code',
16
                  PRIMARY KEY (server_id,branchcode),
17
                  KEY z3950servers_branches_ibfk_2 (branchcode),
18
                  CONSTRAINT z3950servers_branches_ibfk_1 FOREIGN KEY (server_id) REFERENCES z3950servers (id) ON DELETE CASCADE ON UPDATE CASCADE,
19
                  CONSTRAINT z3950servers_branches_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE CASCADE ON UPDATE CASCADE
20
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
21
            }
22
            );
23
            say $out "Added z3950servers_branches table for library limits";
24
        }
25
    },
26
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +17 lines)
Lines 6823-6828 CREATE TABLE `z3950servers` ( Link Here
6823
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6823
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6824
/*!40101 SET character_set_client = @saved_cs_client */;
6824
/*!40101 SET character_set_client = @saved_cs_client */;
6825
6825
6826
--
6827
-- Table structure for table `z3950servers_branches`
6828
--
6829
6830
DROP TABLE IF EXISTS `z3950servers_branches`;
6831
/*!40101 SET @saved_cs_client     = @@character_set_client */;
6832
/*!40101 SET character_set_client = utf8mb4 */;
6833
CREATE TABLE `z3950servers_branches` (
6834
  `server_id` int(11) NOT NULL COMMENT 'z3950server id',
6835
  `branchcode` varchar(10) NOT NULL COMMENT 'branch code',
6836
  PRIMARY KEY (`server_id`,`branchcode`),
6837
  KEY `z3950servers_branches_ibfk_2` (`branchcode`),
6838
  CONSTRAINT `z3950servers_branches_ibfk_1` FOREIGN KEY (`server_id`) REFERENCES `z3950servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
6839
  CONSTRAINT `z3950servers_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
6840
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6841
/*!40101 SET character_set_client = @saved_cs_client */;
6842
6826
--
6843
--
6827
-- Table structure for table `zebraqueue`
6844
-- Table structure for table `zebraqueue`
6828
--
6845
--
6829
- 

Return to bug 40481