ignore this
On Wed, Sep 28, 2011 at 8:36 AM, Nicole C. Engard <[email protected]> wrote: > This patch documents the items table. Some fields were left > undocumented because I was unsure of what data was stored there: > > stack > paidfor > cn_sort > permanent_location > stocknumber > > http://bugs.koha-community.org/show_bug.cgi?id=6716 > --- > installer/data/mysql/kohastructure.sql | 70 > ++++++++++++++++---------------- > 1 files changed, 35 insertions(+), 35 deletions(-) > > diff --git a/installer/data/mysql/kohastructure.sql > b/installer/data/mysql/kohastructure.sql > index 3a51df5..337d555 100644 > --- a/installer/data/mysql/kohastructure.sql > +++ b/installer/data/mysql/kohastructure.sql > @@ -996,45 +996,45 @@ CREATE TABLE `issuingrules` ( > -- > > DROP TABLE IF EXISTS `items`; > -CREATE TABLE `items` ( > - `itemnumber` int(11) NOT NULL auto_increment, > - `biblionumber` int(11) NOT NULL default 0, > - `biblioitemnumber` int(11) NOT NULL default 0, > - `barcode` varchar(20) default NULL, > - `dateaccessioned` date default NULL, > - `booksellerid` mediumtext default NULL, > - `homebranch` varchar(10) default NULL, > - `price` decimal(8,2) default NULL, > - `replacementprice` decimal(8,2) default NULL, > - `replacementpricedate` date default NULL, > - `datelastborrowed` date default NULL, > - `datelastseen` date default NULL, > +CREATE TABLE `items` ( -- holdings/item information > + `itemnumber` int(11) NOT NULL auto_increment, -- primary key and unique > identifier added by Koha > + `biblionumber` int(11) NOT NULL default 0, -- foreign key from biblio > table used to link this item to the right bib record > + `biblioitemnumber` int(11) NOT NULL default 0, -- foreign key from the > biblioitems table to link to item to additional information > + `barcode` varchar(20) default NULL, -- item barcode (952$p) > + `dateaccessioned` date default NULL, -- date the item was acquired or > added to Koha (952$d) > + `booksellerid` mediumtext default NULL, -- where the item was purchased > (952$e) > + `homebranch` varchar(10) default NULL, -- foreign key from the branches > table for the library that owns this item (952$a) > + `price` decimal(8,2) default NULL, -- purchase price (952$g) > + `replacementprice` decimal(8,2) default NULL, -- cost the library charges > to replace the item if it has been marked lost (952$v) > + `replacementpricedate` date default NULL, -- the date the price is > effective from (952$w) > + `datelastborrowed` date default NULL, -- the date the item was last > checked out > + `datelastseen` date default NULL, -- the date the item was last see > (usually the last time the barcode was scanned or inventory was done) > `stack` tinyint(1) default NULL, > - `notforloan` tinyint(1) NOT NULL default 0, > - `damaged` tinyint(1) NOT NULL default 0, > - `itemlost` tinyint(1) NOT NULL default 0, > - `wthdrawn` tinyint(1) NOT NULL default 0, > - `itemcallnumber` varchar(255) default NULL, > - `issues` smallint(6) default NULL, > - `renewals` smallint(6) default NULL, > - `reserves` smallint(6) default NULL, > - `restricted` tinyint(1) default NULL, > - `itemnotes` mediumtext, > - `holdingbranch` varchar(10) default NULL, > + `notforloan` tinyint(1) NOT NULL default 0, -- authorized value defining > why this item is not for loan (952$7) > + `damaged` tinyint(1) NOT NULL default 0, -- authorized value defining this > item as damaged (952$4) > + `itemlost` tinyint(1) NOT NULL default 0, -- authorized value defining > this item as lost (952$1) > + `wthdrawn` tinyint(1) NOT NULL default 0, -- authorized value defining > this item as withdrawn (952$0) > + `itemcallnumber` varchar(255) default NULL, -- call number for this item > (952$o) > + `issues` smallint(6) default NULL, -- number of times this item has been > checked out > + `renewals` smallint(6) default NULL, -- number of times this item has been > renewed > + `reserves` smallint(6) default NULL, -- number of times this item has been > placed on hold/reserved > + `restricted` tinyint(1) default NULL, -- authorized value defining use > restrictions for this item (952$5) > + `itemnotes` mediumtext, -- public notes on this item (952$x) > + `holdingbranch` varchar(10) default NULL, -- foreign key from the branches > table for the library that is currently in possession item (952$b) > `paidfor` mediumtext, > - `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP, > - `location` varchar(80) default NULL, > + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP, -- date and time this item was last altered > + `location` varchar(80) default NULL, -- authorized value for the shelving > location for this item (952$c) > `permanent_location` varchar(80) default NULL, > - `onloan` date default NULL, > - `cn_source` varchar(10) default NULL, > + `onloan` date default NULL, -- defines if this item is currently checked > out (1 for yes, 0 for no) > + `cn_source` varchar(10) default NULL, -- classification source used on > this item (952$2) > `cn_sort` varchar(30) default NULL, > - `ccode` varchar(10) default NULL, > - `materials` varchar(10) default NULL, > - `uri` varchar(255) default NULL, > - `itype` varchar(10) default NULL, > - `more_subfields_xml` longtext default NULL, > - `enumchron` text default NULL, > - `copynumber` varchar(32) default NULL, > + `ccode` varchar(10) default NULL, -- authorized value for the collection > code associated with this item (952$8) > + `materials` varchar(10) default NULL, -- materials specified (952$3) > + `uri` varchar(255) default NULL, -- URL for the item (952$u) > + `itype` varchar(10) default NULL, -- foreign key from the itemtypes table > defining the type for this item (952$y) > + `more_subfields_xml` longtext default NULL, -- additional 952 subfields in > XML format > + `enumchron` text default NULL, -- serial enumeration/chronology for the > item (952$h) > + `copynumber` varchar(32) default NULL, -- copy number (952$t) > `stocknumber` varchar(32) default NULL, > PRIMARY KEY (`itemnumber`), > UNIQUE KEY `itembarcodeidx` (`barcode`), > -- > 1.7.2.3 > > _______________________________________________ > Koha-patches mailing list > [email protected] > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/ > _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
