Bugzilla – Attachment 112529 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]
Bug 18050: move aqbudgetperiods table before aqbudgets, to fix sql error
Bug-18050-move-aqbudgetperiods-table-before-aqbudg.patch (text/plain), 3.52 KB, created by
Mason James
on 2020-10-26 18:45:14 UTC
(
hide
)
Description:
Bug 18050: move aqbudgetperiods table before aqbudgets, to fix sql error
Filename:
MIME Type:
Creator:
Mason James
Created:
2020-10-26 18:45:14 UTC
Size:
3.52 KB
patch
obsolete
>From 51d014086864e190c4745871b221ba5babb7ce25 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 >Content-Type: text/plain; charset="utf-8" > >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 >--- > 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 45d7b03..0ed6bc2 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2900,6 +2900,24 @@ CREATE TABLE `aqbasketgroups` ( > ) 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` > -- > >@@ -2947,25 +2965,6 @@ CREATE TABLE aqbudgetborrowers ( > ) 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.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 18050
:
110076
|
110078
|
110079
|
110080
|
110169
|
110170
|
110171
|
111429
|
111712
|
111713
|
111751
|
111752
|
111753
|
111754
|
111755
|
112529
|
112530