Attachment 30903 Details for Bug 6536 – [DO_NOT_PUSH] Bug 6536: Update DBIx schema of z3950servers for testing

[patch] [DO_NOT_PUSH] Bug 6536: Update DBIx schema of z3950servers for testing

Bug-6536-Update-DBIx-schema-of-z3950servers-for-te.patch (text/plain), 4.45 KB, created by Marcel de Rooy on 2014-08-18 08:10:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2014-08-18 08:10:45 UTC

Size: 4.45 KB

patch

obsolete

>From e70e4e2767b7b1a2bb6ff3367bd05a5a5a3e68bb Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Thu, 22 May 2014 10:08:42 +0200
>Subject: [PATCH] Bug 6536: Update DBIx schema of z3950servers for testing
>Content-Type: text/plain; charset=utf-8
>
>This patch adjusts the DBIx schema file for z3950servers table.
>This can be used for testing this set of patches.
>When the report is pushed, the RM should update the DBIx schema.
>
>Signed-off-by: Giuseppe Angilella <giuseppe.angilella@ct.infn.it>
>---
> Koha/Schema/Result/Z3950server.pm |   88 +++++++++++++++++--------------------
> 1 files changed, 41 insertions(+), 47 deletions(-)
>
>diff --git a/Koha/Schema/Result/Z3950server.pm b/Koha/Schema/Result/Z3950server.pm
>index 8dbf566..2b3a4d9 100644
>--- a/Koha/Schema/Result/Z3950server.pm
>+++ b/Koha/Schema/Result/Z3950server.pm
>@@ -23,6 +23,12 @@ __PACKAGE__->table("z3950servers");
> 
> =head1 ACCESSORS
> 
>+=head2 id
>+
>+  data_type: 'integer'
>+  is_auto_increment: 1
>+  is_nullable: 0
>+
> =head2 host
> 
>   data_type: 'varchar'
>@@ -52,15 +58,9 @@ __PACKAGE__->table("z3950servers");
>   is_nullable: 1
>   size: 255
> 
>-=head2 name
>+=head2 servername
> 
>   data_type: 'mediumtext'
>-  is_nullable: 1
>-
>-=head2 id
>-
>-  data_type: 'integer'
>-  is_auto_increment: 1
>   is_nullable: 0
> 
> =head2 checked
>@@ -85,23 +85,11 @@ __PACKAGE__->table("z3950servers");
>   default_value: 0
>   is_nullable: 0
> 
>-=head2 icon
>-
>-  data_type: 'text'
>-  is_nullable: 1
>-
>-=head2 position
>-
>-  data_type: 'enum'
>-  default_value: 'primary'
>-  extra: {list => ["primary","secondary",""]}
>-  is_nullable: 0
>-
>-=head2 type
>+=head2 servertype
> 
>   data_type: 'enum'
>   default_value: 'zed'
>-  extra: {list => ["zed","opensearch"]}
>+  extra: {list => ["zed","sru"]}
>   is_nullable: 0
> 
> =head2 encoding
>@@ -109,21 +97,34 @@ __PACKAGE__->table("z3950servers");
>   data_type: 'text'
>   is_nullable: 1
> 
>-=head2 description
>+=head2 recordtype
> 
>-  data_type: 'text'
>+  data_type: 'enum'
>+  default_value: 'biblio'
>+  extra: {list => ["authority","biblio"]}
>   is_nullable: 0
> 
>-=head2 recordtype
>+=head2 sru_options
> 
>   data_type: 'varchar'
>-  default_value: 'biblio'
>-  is_nullable: 0
>-  size: 45
>+  is_nullable: 1
>+  size: 255
>+
>+=head2 sru_fields
>+
>+  data_type: 'mediumtext'
>+  is_nullable: 1
>+
>+=head2 add_xslt
>+
>+  data_type: 'mediumtext'
>+  is_nullable: 1
> 
> =cut
> 
> __PACKAGE__->add_columns(
>+  "id",
>+  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>   "host",
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>   "port",
>@@ -134,10 +135,8 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>   "password",
>   { data_type => "varchar", is_nullable => 1, size => 255 },
>-  "name",
>-  { data_type => "mediumtext", is_nullable => 1 },
>-  "id",
>-  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
>+  "servername",
>+  { data_type => "mediumtext", is_nullable => 0 },
>   "checked",
>   { data_type => "smallint", is_nullable => 1 },
>   "rank",
>@@ -146,33 +145,28 @@ __PACKAGE__->add_columns(
>   { data_type => "varchar", is_nullable => 1, size => 80 },
>   "timeout",
>   { data_type => "integer", default_value => 0, is_nullable => 0 },
>-  "icon",
>-  { data_type => "text", is_nullable => 1 },
>-  "position",
>-  {
>-    data_type => "enum",
>-    default_value => "primary",
>-    extra => { list => ["primary", "secondary", ""] },
>-    is_nullable => 0,
>-  },
>-  "type",
>+  "servertype",
>   {
>     data_type => "enum",
>     default_value => "zed",
>-    extra => { list => ["zed", "opensearch"] },
>+    extra => { list => ["zed", "sru"] },
>     is_nullable => 0,
>   },
>   "encoding",
>   { data_type => "text", is_nullable => 1 },
>-  "description",
>-  { data_type => "text", is_nullable => 0 },
>   "recordtype",
>   {
>-    data_type => "varchar",
>+    data_type => "enum",
>     default_value => "biblio",
>+    extra => { list => ["authority", "biblio"] },
>     is_nullable => 0,
>-    size => 45,
>   },
>+  "sru_options",
>+  { data_type => "varchar", is_nullable => 1, size => 255 },
>+  "sru_fields",
>+  { data_type => "mediumtext", is_nullable => 1 },
>+  "add_xslt",
>+  { data_type => "mediumtext", is_nullable => 1 },
> );
> 
> =head1 PRIMARY KEY
>@@ -192,5 +186,5 @@ __PACKAGE__->set_primary_key("id");
> # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BA+II2AVWOTLfgbko1GAOA
> 
> 
>-# You can replace this text with custom content, and it will be preserved on regeneration
>+# You can replace this text with custom code or comments, and it will be preserved on regeneration
> 1;
>-- 
>1.7.7.6

Actions: View | Diff | Splinter Review

Attachments on bug 6536: 4540 | 4541 | 4959 | 6901 | 6919 | 6920 | 6924 | 13462 | 26169 | 26170 | 26171 | 26172 | 29754 | 29755 | 29756 | 29779 | 29780 | 29788 | 29790 | 29791 | 29812 | 29813 | 29814 | 29815 | 29816 | 29817 | 29818 | 29819 | 30189 | 30190 | 30191 | 30192 | 30193 | 30194 | 30900 | 30901 | 30902 | 30903 | 30904 | 30905 | 30906 | 30907 | 30929 | 30930 | 30931 | 30932 | 30933 | 30934 | 30935 | 30936 | 31046 | 31048 | 31137 | 31193 | 31194 | 31195 | 31227 | 31247 | 31248 | 37264