Bugzilla – Attachment 7820 Details for
Bug 7310
Improving permissions on lists (virtual shelves)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[PATCH 2][REVISED]Changing Koha SQL structure
patch.txt (text/plain), 3.91 KB, created by
Marcel de Rooy
on 2012-02-23 09:56:42 UTC
(
hide
)
Description:
[PATCH 2][REVISED]Changing Koha SQL structure
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2012-02-23 09:56:42 UTC
Size:
3.91 KB
patch
obsolete
>From e4067a37875c37109b4fe23fe8c0e6db405e3efc Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >Date: Thu, 8 Dec 2011 16:10:57 +0100 >Subject: [PATCH] 7310a: Improving list permissions: Changing Koha SQL structure >Content-Type: text/plain; charset="utf-8" > >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. >--- > installer/data/mysql/kohastructure.sql | 22 ++++++++++++++++++++-- > 1 files changed, 20 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 67149c9..0917449 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1980,10 +1980,13 @@ DROP TABLE IF EXISTS `virtualshelves`; > CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) > `shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha > `shelfname` varchar(255) default NULL, -- name of the list >- `owner` varchar(80) default NULL, -- foriegn key linking to the borrowers table (using borrowernumber) for the creator of this list >- `category` varchar(1) default NULL, -- type of list (public [2], private [1] or open [3]) >+ `owner` int default NULL, -- foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) >+ `category` varchar(1) default NULL, -- type of list (private [1], public [2]) > `sortfield` varchar(16) default NULL, -- the field this list is sorted on > `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified >+ `allow_add` tinyint(1) default 0, -- permission for adding entries to list >+ `allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself >+ `allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added > PRIMARY KEY (`shelfnumber`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > >@@ -1997,6 +2000,7 @@ CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list > `biblionumber` int(11) NOT NULL default 0, -- foreign key linking to the biblio table, defines the bib record that has been added to the list > `flags` int(11) default NULL, > `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time this bib record was added to the list >+ `borrowernumber` int, -- borrower number that created this list entry (only the first one is saved: no need for use in/as key) > KEY `shelfnumber` (`shelfnumber`), > KEY `biblionumber` (`biblionumber`), > CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >@@ -2004,6 +2008,20 @@ CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list > ) ENGINE=InnoDB DEFAULT CHARSET=utf8; > > -- >+-- Table structure for table `virtualshelfshares` >+-- >+ >+DROP TABLE IF EXISTS `virtualshelfshares`; >+CREATE TABLE `virtualshelfshares` ( --shared private lists >+ `id` int AUTO_INCREMENT PRIMARY KEY, --unique key >+ `shelfnumber` int NOT NULL, -- foreign key for virtualshelves >+ `borrowernumber` int, -- borrower that accepted access to this list >+ `invitekey` varchar(10), -- temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet >+ `sharedate` datetime, -- date of invitation or acceptance of invitation >+ CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, >+) ENGINE=InnoDB DEFAULT CHARSET=utf8; >+ >+-- > -- Table structure for table `z3950servers` > -- > >-- >1.6.0.6 >
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 7310
:
7092
|
7678
|
7679
|
7680
|
7681
|
7682
|
7769
|
7819
|
7820
|
7821
|
7823
|
7824
|
7825
|
7828
|
7873
|
7874
|
7875
|
7876
|
7877
|
7878
|
7879
|
7909
|
7910
|
7925
|
7926
|
7939
|
7940
|
7942
|
7953
|
8006
|
8007
|
8008
|
8009
|
8259
|
8260
|
8261
|
8262
|
8263
|
8264
|
8265
|
8266
|
8267
|
8410
|
8411
|
8412
|
8467
|
8519