[Koha-bugs] [Bug 21946] Group circulation by item type

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21946

--- Comment #102 from Alex Arnaud <alex.arnaud at biblibre.com> ---
Comment on attachment 99419
  --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=99419
Bug 21946: Database updates

Review of attachment 99419:
 --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=21946&attachment=99419)
-----------------------------------------------------------------

::: installer/data/mysql/kohastructure.sql
@@ +892,4 @@
>    hideinopac tinyint(1) NOT NULL DEFAULT 0, -- Hide the item type from the search options in OPAC
>    searchcategory varchar(80) default NULL, -- Group this item type with others with the same value on OPAC search options
>    PRIMARY KEY  (`itemtype`),
> +  FOREIGN KEY (parent_type) REFERENCES itemtypes(itemtype) ON UPDATE CASCADE ON DELETE CASCADE,

Can you use CONSTRAINT as in the atomic update. So that we can have the
constraint name that is defined in.

-- 
You are receiving this mail because:
You are watching all bug changes.