Bugzilla – Attachment 47729 Details for
Bug 15707
Add ability to define hierarchical groups of libraries
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15707 - Update DB
Bug-15707---Update-DB.patch (text/plain), 3.00 KB, created by
Kyle M Hall (khall)
on 2016-02-06 11:30:24 UTC
(
hide
)
Description:
Bug 15707 - Update DB
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2016-02-06 11:30:24 UTC
Size:
3.00 KB
patch
obsolete
>From 6a6685dd635fb7f62c105155a6e84f06e8ff77fb 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 > >--- > 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 0828565..19b313a 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3621,6 +3621,23 @@ CREATE TABLE audio_alerts ( > KEY precedence (precedence) > ) 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), >+ 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
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 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