Bugzilla – Attachment 112530 Details for
Bug 18050
Missing constraint on aqbudgets.budget_period_id in aqbudgets
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
follow-up pushed to master. Thanks !
Bug-18050-move-aqbudgetperiods-table-before-aqbudg.patch (text/plain), 3.71 KB, created by
Tomás Cohen Arazi (tcohen)
on 2020-10-26 18:56:06 UTC
(
hide
)
Description:
follow-up pushed to master. Thanks !
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2020-10-26 18:56:06 UTC
Size:
3.71 KB
patch
obsolete
>From 3df7a02d8198e7a0a0af5459c4c3d2192177b27f Mon Sep 17 00:00:00 2001 >From: Mason James <mtj@kohaaloha.com> >Date: Tue, 27 Oct 2020 07:41:03 +1300 >Subject: [PATCH] Bug 18050: move aqbudgetperiods table before aqbudgets, to > fix sql error > >00:02:16.310 koha_1 | DBD::mysql::st execute failed: Can't create table `koha_kohadev`.`aqbudgets` (errno: 150 "Foreign key constraint is incorrectly formed") at /usr/share/perl5/DBIx/RunSQL.pm line 278, <$args{...}> line 1. >00:02:16.310 koha_1 | Something went wrong loading file /kohadevbox/koha/installer/data/mysql/kohastructure.sql ([SQL ERROR]: CREATE TABLE `aqbudgets` ( -- information related to Funds >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > installer/data/mysql/kohastructure.sql | 37 +++++++++++++------------- > 1 file changed, 18 insertions(+), 19 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 45d7b03af92..0ed6bc202e2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2899,6 +2899,24 @@ CREATE TABLE `aqbasketgroups` ( > CONSTRAINT `aqbasketgroups_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE ON DELETE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > >+-- >+-- Table structure for table `aqbudgetperiods` >+-- >+ >+DROP TABLE IF EXISTS `aqbudgetperiods`; >+CREATE TABLE `aqbudgetperiods` ( -- information related to Budgets >+ `budget_period_id` int(11) NOT NULL auto_increment, -- primary key and unique number assigned by Koha >+ `budget_period_startdate` date NOT NULL, -- date when the budget starts >+ `budget_period_enddate` date NOT NULL, -- date when the budget ends >+ `budget_period_active` tinyint(1) default '0', -- whether this budget is active or not (1 for yes, 0 for no) >+ `budget_period_description` LONGTEXT, -- description assigned to this budget >+ `budget_period_total` decimal(28,6), -- total amount available in this budget >+ `budget_period_locked` tinyint(1) default NULL, -- whether this budget is locked or not (1 for yes, 0 for no) >+ `sort1_authcat` varchar(10) default NULL, -- statistical category for this budget >+ `sort2_authcat` varchar(10) default NULL, -- second statistical category for this budget >+ PRIMARY KEY (`budget_period_id`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ > -- > -- Table structure for table `aqbudgets` > -- >@@ -2946,25 +2964,6 @@ CREATE TABLE aqbudgetborrowers ( > ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > >--- >--- Table structure for table `aqbudgetperiods` >--- >- >- >-DROP TABLE IF EXISTS `aqbudgetperiods`; >-CREATE TABLE `aqbudgetperiods` ( -- information related to Budgets >- `budget_period_id` int(11) NOT NULL auto_increment, -- primary key and unique number assigned by Koha >- `budget_period_startdate` date NOT NULL, -- date when the budget starts >- `budget_period_enddate` date NOT NULL, -- date when the budget ends >- `budget_period_active` tinyint(1) default '0', -- whether this budget is active or not (1 for yes, 0 for no) >- `budget_period_description` LONGTEXT, -- description assigned to this budget >- `budget_period_total` decimal(28,6), -- total amount available in this budget >- `budget_period_locked` tinyint(1) default NULL, -- whether this budget is locked or not (1 for yes, 0 for no) >- `sort1_authcat` varchar(10) default NULL, -- statistical category for this budget >- `sort2_authcat` varchar(10) default NULL, -- second statistical category for this budget >- PRIMARY KEY (`budget_period_id`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >- > -- > -- Table structure for table `aqbudgets_planning` > -- >-- >2.29.1
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 18050
:
110076
|
110078
|
110079
|
110080
|
110169
|
110170
|
110171
|
111429
|
111712
|
111713
|
111751
|
111752
|
111753
|
111754
|
111755
|
112529
| 112530