7310a: Improving list permissions: Changing Koha SQL structure
authorMarcel de Rooy <m.de.rooy@rijksmuseum.nl>
Thu, 8 Dec 2011 15:10:57 +0000 (16:10 +0100)
committerPaul Poulain <paul.poulain@biblibre.com>
Wed, 21 Mar 2012 15:46:29 +0000 (16:46 +0100)
commitd6f8fde92cde8f8daf940bf6aff058dab6a0b30f
treed890ae379384c0200628c21871c95dcbcc0258c0
parent8cff38fb24114850e2396451b3985a6572a01981
7310a: Improving list permissions: Changing Koha SQL structure

Modifying Koha structure for improving list permissions.
Adds new table virtualshelfshares for maintaining shared private lists.
Adds three columns to virtualshelves for permissions per list.
Adds column borrowernumber to virtualshelfcontents.

Signed-off-by: Jared Camins-Esakov <jcamins@cpbibliography.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Feb 28, 2012: Added three FK constraints for QA (for owner/borrowernumber in virtualshelves, shelfcontents and shelfshares). Resolved syntax error with a comment. Tested the install.
Signed-off-by: Ian Walls <koha.sekjal@gmail.com>
installer/data/mysql/kohastructure.sql