Bugzilla – Attachment 103884 Details for
Bug 22335
Comment on column suggestions.STATUS is not complete
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22335: Fix comment on suggestions.STATUS in kohastructure.sql
Bug-22335-Fix-comment-on-suggestionsSTATUS-in-koha.patch (text/plain), 1.64 KB, created by
David Nind
on 2020-04-28 20:11:17 UTC
(
hide
)
Description:
Bug 22335: Fix comment on suggestions.STATUS in kohastructure.sql
Filename:
MIME Type:
Creator:
David Nind
Created:
2020-04-28 20:11:17 UTC
Size:
1.64 KB
patch
obsolete
>From d6f9f2b51e2b7ea4876be251d6ad1441e70ff0d6 Mon Sep 17 00:00:00 2001 >From: Katrin Fischer <katrin.fischer.83@web.de> >Date: Mon, 13 Apr 2020 04:42:37 +0200 >Subject: [PATCH] Bug 22335: Fix comment on suggestions.STATUS in > kohastructure.sql > >The description on STATUS was incomplete, missing 2 status and >the SUGGEST_STATUS category. > >To test: >- Later this will show up in schema.koha-community.org, but > for now it can only be verified reading the patch. > >Signed-off-by: David Nind <david@davidnind.com> >--- > installer/data/mysql/kohastructure.sql | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 1cb3165eee..c456c89c89 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -3016,7 +3016,7 @@ CREATE TABLE `suggestions` ( -- purchase suggestions > rejecteddate date default NULL, -- date the suggestion was marked as rejected > lastmodificationby INT(11) default NULL, -- borrowernumber for the librarian who edit the suggestion for the last time > lastmodificationdate date default NULL, -- date of the last modification >- `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, or REJECTED) >+ `STATUS` varchar(10) NOT NULL default '', -- suggestion status (ASKED, CHECKED, ACCEPTED, REJECTED, ORDERED, AVAILABLE or a value from the SUGGEST_STATUS authorised value category) > `archived` TINYINT(1) NOT NULL DEFAULT 0, -- is the suggestion archived? > `note` LONGTEXT, -- note entered on the suggestion > `author` varchar(80) default NULL, -- author of the suggested item >-- >2.11.0
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 22335
:
102795
|
103883
|
103884
|
104295