[Koha-patches] [PATCH] Bug 6716 - Documents the virtual shelves tables
Nicole C. Engard
nengard at bywatersolutions.com
Sat Aug 27 06:16:27 CEST 2011
This patch documents the virtualshelfcontents and virtualshelves
tables. In the virtualshelfcontents table the 'flags' field has
been left undocumented since there is no data stored in this
field.
---
installer/data/mysql/kohastructure.sql | 22 +++++++++++-----------
1 files changed, 11 insertions(+), 11 deletions(-)
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 13fa53d..c833e0f 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1956,13 +1956,13 @@ CREATE TABLE `userflags` (
--
DROP TABLE IF EXISTS `virtualshelves`;
-CREATE TABLE `virtualshelves` (
- `shelfnumber` int(11) NOT NULL auto_increment,
- `shelfname` varchar(255) default NULL,
- `owner` varchar(80) default NULL,
- `category` varchar(1) default NULL,
- `sortfield` varchar(16) default NULL,
- `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+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])
+ `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
PRIMARY KEY (`shelfnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -1971,11 +1971,11 @@ CREATE TABLE `virtualshelves` (
--
DROP TABLE IF EXISTS `virtualshelfcontents`;
-CREATE TABLE `virtualshelfcontents` (
- `shelfnumber` int(11) NOT NULL default 0,
- `biblionumber` int(11) NOT NULL default 0,
+CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list (or virtual shelf)
+ `shelfnumber` int(11) NOT NULL default 0, -- foreign key linking to the virtualshelves table, defines the list that this record has been added to
+ `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,
+ `dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time this bib record was added to the list
KEY `shelfnumber` (`shelfnumber`),
KEY `biblionumber` (`biblionumber`),
CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE,
--
1.7.2.3
More information about the Koha-patches
mailing list