Lines 1980-1989
DROP TABLE IF EXISTS `virtualshelves`;
Link Here
|
1980 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
1980 |
CREATE TABLE `virtualshelves` ( -- information about lists (or virtual shelves) |
1981 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
1981 |
`shelfnumber` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
1982 |
`shelfname` varchar(255) default NULL, -- name of the list |
1982 |
`shelfname` varchar(255) default NULL, -- name of the list |
1983 |
`owner` varchar(80) default NULL, -- foriegn key linking to the borrowers table (using borrowernumber) for the creator of this list |
1983 |
`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) |
1984 |
`category` varchar(1) default NULL, -- type of list (public [2], private [1] or open [3]) |
1984 |
`category` varchar(1) default NULL, -- type of list (private [1], public [2]) |
1985 |
`sortfield` varchar(16) default NULL, -- the field this list is sorted on |
1985 |
`sortfield` varchar(16) default NULL, -- the field this list is sorted on |
1986 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
1986 |
`lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- date and time the list was last modified |
|
|
1987 |
`allow_add` tinyint(1) default 0, -- permission for adding entries to list |
1988 |
`allow_delete_own` tinyint(1) default 1, -- permission for deleting entries frm list that you added yourself |
1989 |
`allow_delete_other` tinyint(1) default 0, -- permission for deleting entries from list that another person added |
1987 |
PRIMARY KEY (`shelfnumber`) |
1990 |
PRIMARY KEY (`shelfnumber`) |
1988 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1991 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1989 |
|
1992 |
|
Lines 1997-2002
CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list
Link Here
|
1997 |
`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 |
2000 |
`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 |
1998 |
`flags` int(11) default NULL, |
2001 |
`flags` int(11) default NULL, |
1999 |
`dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time this bib record was added to the list |
2002 |
`dateadded` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- date and time this bib record was added to the list |
|
|
2003 |
`borrowernumber` int, -- borrower number that created this list entry (only the first one is saved: no need for use in/as key) |
2000 |
KEY `shelfnumber` (`shelfnumber`), |
2004 |
KEY `shelfnumber` (`shelfnumber`), |
2001 |
KEY `biblionumber` (`biblionumber`), |
2005 |
KEY `biblionumber` (`biblionumber`), |
2002 |
CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2006 |
CONSTRAINT `virtualshelfcontents_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
Lines 2004-2009
CREATE TABLE `virtualshelfcontents` ( -- information about the titles in a list
Link Here
|
2004 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2008 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2005 |
|
2009 |
|
2006 |
-- |
2010 |
-- |
|
|
2011 |
-- Table structure for table `virtualshelfshares` |
2012 |
-- |
2013 |
|
2014 |
DROP TABLE IF EXISTS `virtualshelfshares`; |
2015 |
CREATE TABLE `virtualshelfshares` ( --shared private lists |
2016 |
`id` int AUTO_INCREMENT PRIMARY KEY, --unique key |
2017 |
`shelfnumber` int NOT NULL, -- foreign key for virtualshelves |
2018 |
`borrowernumber` int, -- borrower that accepted access to this list |
2019 |
`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 |
2020 |
`sharedate` datetime, -- date of invitation or acceptance of invitation |
2021 |
CONSTRAINT `virtualshelfshares_ibfk_1` FOREIGN KEY (`shelfnumber`) REFERENCES `virtualshelves` (`shelfnumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
2022 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
2023 |
|
2024 |
-- |
2007 |
-- Table structure for table `z3950servers` |
2025 |
-- Table structure for table `z3950servers` |
2008 |
-- |
2026 |
-- |
2009 |
|
2027 |
|
2010 |
- |
|
|