Attachment 43114 Details for Bug 10363 – Bug 10363: (follow-up) DB update - change in kohastructure.sql

[patch] Bug 10363: (follow-up) DB update - change in kohastructure.sql

Bug-10363-follow-up-DB-update---change-in-kohastru.patch (text/plain), 1.14 KB, created by Jonathan Druart on 2015-10-05 08:43:14 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-10-05 08:43:14 UTC

Size: 1.14 KB

patch

obsolete

>From d2d980cd75b54d06d867bf9ac03ab6fb74a59717 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Mon, 5 Oct 2015 09:42:36 +0100
>Subject: [PATCH] Bug 10363: (follow-up) DB update - change in
> kohastructure.sql
>
>---
> installer/data/mysql/kohastructure.sql | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index d6732a3..7d81d1f 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3249,8 +3249,8 @@ CREATE TABLE categories_branches( -- association table between categories and br
> 
> DROP TABLE IF EXISTS authorised_values_branches;
> CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches
>-    av_id INTEGER,
>-    branchcode VARCHAR(10),
>+    av_id INT(11) NOT NULL,
>+    branchcode VARCHAR(10) NOT NULL,
>     FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE,
>     FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
> ) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>-- 
>2.1.0

Actions: View | Diff | Splinter Review

Attachments on bug 10363: 18430 | 18431 | 18432 | 18751 | 18752 | 18753 | 20729 | 21833 | 21834 | 21835 | 21836 | 25284 | 25285 | 25286 | 25287 | 30583 | 30584 | 30585 | 30710 | 30711 | 30712 | 31565 | 32632 | 32633 | 32634 | 33416 | 33417 | 33422 | 33423 | 33860 | 33861 | 33862 | 33889 | 33949 | 35838 | 35839 | 35840 | 35841 | 41290 | 41291 | 41292 | 41293 | 41294 | 41302 | 41343 | 41344 | 41345 | 43112 | 43113 | 43114 | 43550 | 43551 | 43552 | 43553 | 43554 | 43555 | 43556 | 43557 | 43558 | 43559 | 43696 | 43827