Bugzilla – Attachment 53805 Details for
Bug 15839
Move the reviews related code to Koha::Reviews
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15839: [QA Follow-up] Update existing rows in dbrev
Bug-15839-QA-Follow-up-Update-existing-rows-in-dbr.patch (text/plain), 1.01 KB, created by
Marcel de Rooy
on 2016-07-29 09:44:57 UTC
(
hide
)
Description:
Bug 15839: [QA Follow-up] Update existing rows in dbrev
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2016-07-29 09:44:57 UTC
Size:
1.01 KB
patch
obsolete
>From 1f9bddb71305e5e02eb6d077b1033b68050e5eaf Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Fri, 29 Jul 2016 08:16:47 +0200 >Subject: [PATCH] Bug 15839: [QA Follow-up] Update existing rows in dbrev >Content-Type: text/plain; charset=utf-8 > >Adding the default is fine for new records; we also should take care >of the pending existing ones. >Trivial addition to atomic update file. > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Tested the dbrev again with existing unapproved reviews. >--- > installer/data/mysql/atomicupdate/bug_review.sql | 1 + > 1 file changed, 1 insertion(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_review.sql b/installer/data/mysql/atomicupdate/bug_review.sql >index 076c3b5..ee882dd 100644 >--- a/installer/data/mysql/atomicupdate/bug_review.sql >+++ b/installer/data/mysql/atomicupdate/bug_review.sql >@@ -1 +1,2 @@ > ALTER TABLE reviews CHANGE COLUMN approved approved tinyint(4) DEFAULT 0; >+UPDATE reviews SET approved=0 WHERE approved IS NULL; >-- >1.7.10.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 15839
:
48166
|
48167
|
48168
|
48169
|
48170
|
48171
|
48172
|
48173
|
48174
|
48175
|
48176
|
48280
|
48281
|
48282
|
48283
|
48284
|
48285
|
48286
|
48287
|
48288
|
48289
|
48290
|
51197
|
51198
|
51199
|
51200
|
51201
|
51202
|
51203
|
51204
|
51205
|
51206
|
51207
|
53794
|
53795
|
53796
|
53797
|
53798
|
53799
|
53800
|
53801
|
53802
|
53803
|
53804
| 53805 |
53806
|
53807