Attachment 60755 Details for Bug 15707 – Bug 15707 - Update DB

[patch] Bug 15707 - Update DB

Bug-15707---Update-DB.patch (text/plain), 3.21 KB, created by Kyle M Hall (khall) on 2017-03-01 14:01:13 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2017-03-01 14:01:13 UTC

Size: 3.21 KB

patch

obsolete

>From 432e0a34d2bede37b66e00d1c85f75da672d1fb4 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Sun, 31 Jan 2016 11:21:00 +0000
>Subject: [PATCH] Bug 15707 - Update DB
>
>Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
>---
> installer/data/mysql/atomicupdate/library_groups.sql | 12 ++++++++++++
> installer/data/mysql/kohastructure.sql               | 17 +++++++++++++++++
> 2 files changed, 29 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/library_groups.sql
>
>diff --git a/installer/data/mysql/atomicupdate/library_groups.sql b/installer/data/mysql/atomicupdate/library_groups.sql
>new file mode 100644
>index 0000000..d6d3425
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/library_groups.sql
>@@ -0,0 +1,12 @@
>+CREATE TABLE library_groups (
>+    id INT(11) NOT NULL auto_increment,    -- unique id for each group
>+    parent_id INT(11) NULL DEFAULT NULL,   -- if this is a child group, the id of the parent group
>+    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
>+    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
>+    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
>+    created_on DATETIME NOT NULL,          -- Date and time of creation
>+    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
>+    PRIMARY KEY id ( id ),
>+    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
>+    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 985ee27..7fec14b 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3955,6 +3955,23 @@ CREATE TABLE deletedbiblio_metadata (
>     CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
> 
>+--
>+-- Table structure for table 'library_groups'
>+--
>+
>+CREATE TABLE library_groups (
>+    id INT(11) NOT NULL auto_increment,    -- unique id for each group
>+    parent_id INT(11) NULL DEFAULT NULL,   -- if this is a child group, the id of the parent group
>+    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
>+    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
>+    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
>+    created_on DATETIME NOT NULL,          -- Date and time of creation
>+    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
>+    PRIMARY KEY id ( id ),
>+    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
>+    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
>+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>+
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 15707: 47479 | 47480 | 47481 | 47482 | 47483 | 47484 | 47728 | 47729 | 47730 | 47731 | 47732 | 47733 | 47734 | 47849 | 47850 | 47851 | 47852 | 47853 | 47854 | 47855 | 47868 | 47869 | 47870 | 47871 | 47872 | 47873 | 47874 | 48072 | 50400 | 50401 | 50402 | 50403 | 50404 | 50405 | 50406 | 50407 | 50408 | 52267 | 52268 | 52269 | 52270 | 52271 | 52272 | 52273 | 52274 | 52275 | 52367 | 52370 | 52562 | 52563 | 52564 | 52565 | 52566 | 52567 | 52568 | 52569 | 52570 | 52571 | 52572 | 52573 | 52574 | 52575 | 57080 | 57081 | 57082 | 57083 | 57084 | 57085 | 57086 | 57087 | 57088 | 57089 | 57090 | 57091 | 57092 | 57093 | 58086 | 60504 | 60505 | 60506 | 60507 | 60508 | 60509 | 60510 | 60511 | 60512 | 60513 | 60514 | 60515 | 60516 | 60517 | 60518 | 60572 | 60573 | 60574 | 60575 | 60576 | 60577 | 60578 | 60579 | 60580 | 60581 | 60582 | 60583 | 60584 | 60585 | 60586 | 60587 | 60755 | 60756 | 60757 | 60758 | 60759 | 60760 | 60761 | 60762 | 60763 | 60764 | 60765 | 60766 | 60767 | 60768 | 60769 | 60770 | 60771 | 65666 | 65667 | 65668 | 65669 | 65670 | 65671 | 65672 | 65673 | 65674 | 65675 | 65676 | 65677 | 65678 | 65679 | 65680 | 65681 | 69514 | 69515 | 69516 | 69517 | 69518 | 69519 | 69520 | 69521 | 69522 | 69523 | 69524 | 69525 | 69526 | 69527 | 69528 | 69529 | 69573 | 69574 | 69575 | 69576 | 69577 | 69578 | 69579 | 69580 | 69581 | 69582 | 69583 | 69584 | 69585 | 69586 | 69587 | 69588 | 69589