Bugzilla – Attachment 104191 Details for
Bug 24161
Add ability to track the claim dates of later orders
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24161: (follow-up) DB changes
Bug-24161-follow-up-DB-changes.patch (text/plain), 1.22 KB, created by
Jonathan Druart
on 2020-05-02 13:58:01 UTC
(
hide
)
Description:
Bug 24161: (follow-up) DB changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-05-02 13:58:01 UTC
Size:
1.22 KB
patch
obsolete
>From b7f0e46187fa0f502e867e135d9e175f5debe43a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Sat, 2 May 2020 15:28:23 +0200 >Subject: [PATCH] Bug 24161: (follow-up) DB changes > >--- > installer/data/mysql/kohastructure.sql | 6 +++--- > 1 file changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 7bf3657851..c7ce7be09d 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3273,9 +3273,9 @@ CREATE TABLE aqorders_transfers ( > > DROP TABLE IF EXISTS aqorders_claims; > CREATE TABLE aqorders_claims ( >- id int(11) AUTO_INCREMENT, >- ordernumber INT(11) NOT NULL, >- claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, >+ id int(11) AUTO_INCREMENT, -- ID of the claims >+ ordernumber INT(11) NOT NULL, -- order linked to this claim >+ claimed_on TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, -- Date of the claims > PRIMARY KEY (id), > CONSTRAINT aqorders_claims_ibfk_1 FOREIGN KEY (ordernumber) REFERENCES aqorders (ordernumber) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; >-- >2.20.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 24161
:
97114
|
97115
|
97116
|
97117
|
97118
|
97119
|
97470
|
97471
|
97472
|
98280
|
98522
|
98523
|
98524
|
98525
|
98526
|
98527
|
102111
|
102112
|
102113
|
102114
|
102115
|
102116
|
102220
|
102222
|
103567
|
103568
|
103569
|
103570
|
103571
|
103588
|
103589
|
103590
|
103591
|
103592
|
103593
|
103594
|
103595
|
104190
|
104191
|
104207
|
104208
|
104209
|
104210
|
104211
|
104212
|
104213
|
104214
|
104215
|
104216
|
104258
|
104259
|
104265
|
104826
|
104848