This is a bug that will have many patches. I have (as doc manager) agreed to document the mysql structure in Koha. To make it easy for others to submit patches and help me I'll submit a patch with what I've done in the day (or that time of day) so that others can submit patches as well without us doing the same work. It was voted that I will enter comments using the -- notation, for example: `frameworkcode` varchar(4) NOT NULL default '', --primary key, identifier for the framework table This report should not be closed until all fields have been documented. If you're adding new fields please document them using the above notation when adding them.
Created attachment 4987 [details] [review] Bug 6716 - Document Borrowers Table This is the first of many patches that will document the SQL structure in Koha. This patch adds comments to the borrowers table.
Created attachment 4988 [details] [review] Bug 6716 - Document Borrowers Table This is the first of many patches that will document the SQL structure in Koha. This patch adds comments to the borrowers table.
Created attachment 4989 [details] [review] Bug 6716 - Document Borrowers Table This is the first of many patches that will document the SQL structure in Koha. This patch adds comments to the borrowers table.
Created attachment 4992 [details] [SIGNED-OFF] Bug 6716 - Document Borrowers Table This is the first of many patches that will document the SQL structure in Koha. This patch adds comments to the borrowers table. Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> - dropped current database - recreated database using the webinstaller > borrowers table all ok
Created attachment 5003 [details] Bug 6716 - MySQL definition for authorised values table This is one of many patches that will document the MySQL table structure for Koha. This patch adds comments to the authorised_values table.
Created attachment 5004 [details] Bug 6716 - MySQL Table Documentation - Biblio Table This patch documents the biblio table, with the exception of the seriestitle field which I could not find an example of.
Created attachment 5005 [details] Bug 6716 - Deleted Borrowers MySQL Copied documentation from Borrowers to Deleted Borrowers table.
Created attachment 5006 [details] Bug 6716 - Deleted Biblio Table This patch documents the deletedbiblio table, with the exception of the seriestitle field which I could not find an example of.
Created attachment 5007 [details] Bug 6716 - Branch table documentation Documenting the branches table in Koha. Two unused fields noted, please update if they are in fact used.
Created attachment 5008 [details] Bug 6716 Documenting two Branch Group tables This patch documents the branchcategories table and the branchrelations table. Both tables are used in the library/ branch groups administration. Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com>
Created attachment 5009 [details] Bug6716 - File Cleanup The file was missing the starting comments before a few tables, this patch adds those in for consistencies sake. Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com>
Created attachment 5011 [details] Bug 6716 - Borrower Attributes Tables This patch defines the borrower attributes tables (borrower_attributes and borrower_attribute_types).
Created attachment 5012 [details] Bug 6716 - Cities Table Documentation Docmenting the cities table. Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com>
Created attachment 5013 [details] Bug 6716 - Issues Table Documentation This patch documents the issues and old_issues tables. Two fields in both tables are left undocumented - issuingbranch and return - because I was unable to determine what data should be stored in these fields, they are always NULL on my install. Feel free to edit with accurate information. Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com>
Created attachment 5014 [details] Bug 6716 - Statistics Table Documentation This patch documents the statistics table. A few fields were left undocumented. 'other' - unclear what this is used for 'proccode' - unclear what the number entered in this field stands for 'usercode' - always NULL on my system 'associatedborrower' - always NULL on my system Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com>
Created attachment 5139 [details] Bug 6716 - Definition of the branchcategories table This patch adds field definitions to the branchcategories table.
Created attachment 5140 [details] Bug 6716: DB Documentation for the branchrelations table Documents the branchrelations table.
Created attachment 5141 [details] Bug 6716: Documentation for the itemtypes table This patch defines the itemtypes table. The definiton for the summary field is a bit of guess based on the description in the staff client, and might need some clarification.
Created attachment 5142 [details] Bug 6716: Documentation for the letter table This patch documents the letter/notices table in Koha.
Created attachment 5174 [details] Bug 6716 - Document opac_news table Definiton for the opac_news table which stores date from the news tool in Koha.
Created attachment 5175 [details] Bug 6716 - Definition for the overduerules table This patch defines the overduerules table which includes information from the Overdue Notice Status Triggers Tool.
Created attachment 5176 [details] Bug 6716 - Document reviews table This patch adds documentation to the reviews (or comments) table.
Created attachment 5177 [details] Bug 6716 - Document roadtype table This patch adds documentation to the roadtype table.
Created attachment 5178 [details] Bug 6716 - Document the systempreferences table This patch defines the systempreferences table. Some of the fields aren't actually used anymore with the new system preference editor, but have been documented anyway.
Created attachment 5179 [details] Bug 6716 - Documentation for the fieldmapping table This patch documents the fieldmapping table which contains the data associated with the Keyword to Marc Mapping administration area.
Created attachment 5186 [details] Bug 6716 - Documentation for the messages table This documents the messages table which stores info about the circulation messages.
Created attachment 5187 [details] Bug 6716 - Document z3950servers table This patch documents the z3950servers table in Koha. There are two fields marked as unused (icon and description) and two fields that were left undocumented because they contain data, but I am unsure of where the data is coming from (position and type). A follow up patch will be necessary to document these fields.
Created attachment 5188 [details] Bug 6716 - Documents the virtual shelves tables 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.
Created attachment 5190 [details] Bug 6716 - Document subscriptionroutinglist table This table holds information related to serials routing lists.
Created attachment 5192 [details] Bug 6716 - Document holiday tables This patch documents the special_holidays and repeatable_holidays tables.
Created attachment 5193 [details] Bug 6716 - Define reports_dictionary table This patch documents the reports_dictionary table.
Created attachment 5355 [details] [review] Bug 6716: Document suggestions table This patch documents the suggestions database table. Several fields appear to be unused: * volumedesc * publicationyear * mailoverseeing They are left undocumented by this patch.
Created attachment 5356 [details] Bug 6716: Document suggestions DB table This patch documents the suggestions database table. Several fields appear to be unused: * volumedesc * publicationyear * mailoverseeing They are left undocumented by this patch.
All patches attached have been pushed, please test, then reset the status if you add more patches
Created attachment 5663 [details] [review] bug6716: documenting reserves and old_reserves tables This patch documents the reserves and the old_reserves table. Note that a few fields are marked unused: notificationdate and reminderdate. Also two fields are left undocumented: lowestPriority which never seems to be anything other than 0 and constrainttype which is either 'a' or 0, but there doesn't appear to be any explanation as to what each stands for.
Created attachment 5664 [details] [review] bug6716 - document the aqbooksellers table This documents the table that stores vendor info in Koha. There were 4 unused fields found: `accountnumber` `othersupplier` `currency` `booksellerurl`
Created attachment 5665 [details] [review] bug 6717 - document the items table 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
Created attachment 5666 [details] [review] Bug 6716 - document the items table This patch documents the items table. Some fields were left undocumented because I was unsure of what data was stored there: stack paidfor permanent_location stocknumber
Created attachment 5668 [details] [review] bug 6716 - document deleted items table This patch documents the deleted items table. Some fields were left undocumented because I was unsure of what data was stored there: stack paidfor permanent_location stocknumber
Created attachment 5669 [details] [review] bug 6716 - document items table This patch documents the items table. Some fields were left undocumented because I was unsure of what data was stored there: stack paidfor permanent_location stocknumber
Hi Nicole, Sure: stocknumber = inventory number, 952$i in MARC21, also mapped in UNIMARC cn_sort = sortable form of the callnumber generated using the classification source and filing rules Quite sure: permanend_location = linked to the CART and PROC temporary locations feature. Probably used to save the location while the item is in PROC or CART. Guessing a bit: stack = I think this is linked to the shelving number - not sure. paidfor = Was wrongly mapped to the internal note for a longer time. Probably something to be used when something gets lost and is paid for by the patron. Not sure this is still in use.
Thanks, I'll submit an updated patch with some of this info. Nicole
Created attachment 5686 [details] [review] Bug 6716 - Document Items Table This patch documents the items table. Some fields were left undocumented because I was unsure of what data was stored there: stack - might be linked to shelving number, but need confirmation paidfor - pretty sure this is unused, but don't want to document it that way
Created attachment 5687 [details] [review] Bug 6716 Document deleteditems table This patch documents the deleted items table. Some fields were left undocumented because I was unsure of what data was stored there: stack - might be linked to shelving number, but need confirmation paidfor - pretty sure this is unused, but don't want to document it that way
Created attachment 5706 [details] [review] Bug 6716: Document biblioitems and deletedbiblioitems This patch documents the biblioitems and the deletedbiblioitems tables. There are many fields left undocumented because I didn't see information in them, but this is enough of a start to be helpful to those writing reports.
Created attachment 5829 [details] [review] Bug 6716 : Categories table This patch documents the patron categories table in Koha. There are a couple fields marked unused and a couple that aren't documented because I wasn't sure: * dateofbirthrequired * bulk
Created attachment 6004 [details] [review] Documenting need_merge_authorities
Created attachment 6015 [details] [review] Bug 6716 Update biblio & deletedbiblio tables The comments on the biblio and deletedbiblio table didn't mention the MARC21 subfields. This patch adds that documentation in.
Updating Version : This ENH will be for Koha 3.8
Bug versionned for master. entries will be made against rel_3_8 once the patch has been applied (see thread about that on koha-devel yesterday)
The content of attachment 4992 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:08:39 NZDT.
The content of attachment 5003 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:09:01 NZDT.
The content of attachment 5004 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:09:32 NZDT.
The content of attachment 5005 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:09:50 NZDT.
The content of attachment 5006 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:10:51 NZDT.
The content of attachment 5007 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:12:08 NZDT.
The content of attachment 5008 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:12:24 NZDT.
The content of attachment 5009 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:12:45 NZDT.
The content of attachment 5011 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:13:14 NZDT.
The content of attachment 5012 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:13:55 NZDT.
The content of attachment 5013 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:14:28 NZDT.
The content of attachment 5014 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:14:45 NZDT.
The content of attachment 5139 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:15:18 NZDT.
The content of attachment 5140 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:15:46 NZDT.
The content of attachment 5141 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:16:04 NZDT.
The content of attachment 5142 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:16:21 NZDT.
The content of attachment 5174 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:16:40 NZDT.
The content of attachment 5175 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:17:01 NZDT.
The content of attachment 5176 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:17:22 NZDT.
The content of attachment 5177 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:17:47 NZDT.
The content of attachment 5178 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:18:40 NZDT.
The content of attachment 5179 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:19:12 NZDT.
The content of attachment 5186 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:19:44 NZDT.
The content of attachment 5187 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:20:02 NZDT.
The content of attachment 5188 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:20:46 NZDT.
The content of attachment 5190 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:21:02 NZDT.
The content of attachment 5192 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:21:20 NZDT.
The content of attachment 5193 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:21:37 NZDT.
The content of attachment 5356 [details] has been deleted by Chris Cormack <chris@bigballofwax.co.nz> without providing any reason. The token used to delete this attachment was generated at 2011-12-04 21:22:01 NZDT.
I have cleaned off the patches already pushed, the rest still need sign off
Created attachment 6591 [details] [review] bug6716: documenting reserves and old_reserves tables This patch documents the reserves and the old_reserves table. Note that a few fields are marked unused: notificationdate and reminderdate. Also two fields are left undocumented: lowestPriority which never seems to be anything other than 0 and constrainttype which is either 'a' or 0, but there doesn't appear to be any explanation as to what each stands for.
Created attachment 6592 [details] [review] [SIGNED-OFF] bug6716: documenting reserves and old_reserves tables This patch documents the reserves and the old_reserves table. Note that a few fields are marked unused: notificationdate and reminderdate. Also two fields are left undocumented: lowestPriority which never seems to be anything other than 0 and constrainttype which is either 'a' or 0, but there doesn't appear to be any explanation as to what each stands for. Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6593 [details] [review] [SIGNED-OFF] bug6716 - document the aqbooksellers table This documents the table that stores vendor info in Koha. There were 4 unused fields found: `accountnumber` `othersupplier` `currency` `booksellerurl` Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> Accountnumber is no longer unused and can be managed.
Created attachment 6594 [details] [review] [SIGNED-OFF] Bug 6716 - Document Items Table This patch documents the items table. Some fields were left undocumented because I was unsure of what data was stored there: stack - might be linked to shelving number, but need confirmation paidfor - pretty sure this is unused, but don't want to document it that way Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6595 [details] [review] [SIGNED-OFF] Bug 6716 Document deleteditems table This patch documents the deleted items table. Some fields were left undocumented because I was unsure of what data was stored there: stack - might be linked to shelving number, but need confirmation paidfor - pretty sure this is unused, but don't want to document it that way Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6596 [details] [review] [SIGNED-OFF] Bug 6716: Document biblioitems and deletedbiblioitems This patch documents the biblioitems and the deletedbiblioitems tables. There are many fields left undocumented because I didn't see information in them, but this is enough of a start to be helpful to those writing reports. Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6597 [details] [review] [SIGNED-OFF] Bug 6716 : Categories table This patch documents the patron categories table in Koha. There are a couple fields marked unused and a couple that aren't documented because I wasn't sure: * dateofbirthrequired * bulk Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6598 [details] [review] [SIGNED-OFF] 6717 Documenting need_merge_authorities table Documentation only. http://bugs.koha-community.org/show_bug.cgi?id=6716 Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Created attachment 6599 [details] [review] [SIGNED-OFF] Bug 6716 Update biblio & deletedbiblio tables The comments on the biblio and deletedbiblio table didn't mention the MARC21 subfields. This patch adds that documentation in. Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Applied patches and created a new database. No errors were reported and all documented tables were created.
QA comment: * aqorders.accountnumber is now used (i've pushed a patch to fix this recently). It stores & display the accountnumber of the library in the bookvendor system. * need_merge_authorities_table patch does not apply anymore Please provide new patches for those 2 tables
* need_merge_authorities_table patch does not apply anymore Hi Paul, it applies fine for me using "git am -is3...". I will add your suggested change to the patch for aqbooksellers.
QA comment : patches applying, tested it kohastructure.sql still valid after applying them. 6 patches pushed,
QA: Documentation changes only. OK
Comment on attachment 6593 [details] [review] [SIGNED-OFF] bug6716 - document the aqbooksellers table patch pushed
Comment on attachment 6598 [details] [review] [SIGNED-OFF] 6717 Documenting need_merge_authorities table patch pushed
Created attachment 10788 [details] [review] Bug 6716: Document the aqbasket table
Created attachment 10789 [details] [review] Bug 6716: Document aqbudgets and aqbudgetperiods tables
Created attachment 10790 [details] [review] Bug 6716: Document the aqorders table This table has a lot of fields that I never see any values in. All have been noted in the documentation and I welcome any additional info about how these fields might be used.
Created attachment 10791 [details] [review] Bug 6716: Document aqorders_items table
Created attachment 10792 [details] [review] Bug 6716: Document branchtransfers table
Created attachment 10793 [details] [review] Bug 6716: Update ratings table documentation This patch adds a comment to the table and updates the field descriptions with a bit more information.
Created attachment 10794 [details] [review] Bug 6716: Document action_logs table
Created attachment 10795 [details] [review] Bug 6716: Document aqbasket table
Created attachment 10822 [details] [review] Bug 6716: Document the biblio_framework table
Created attachment 10823 [details] [review] Bug 6716: Document branch_item_rules table
Created attachment 10824 [details] [review] Bug 6716: Document branch_borrower_circ_rules table
Created attachment 10832 [details] [review] Bug 6716: document issuingrules table
Created attachment 10833 [details] [review] Bug 6716: Document patronimage table
Created attachment 10942 [details] [review] Bug 6716: Document tags tables I did not document the 'tags' table in this patch because it looks like this table is unused, so I need confirmation of that before marking it as 'unused.'
Created attachment 10970 [details] [review] Bug 6716: Document import_batches table
Created attachment 10975 [details] [review] Bug 6716: document import_record_matches table
Created attachment 11011 [details] [review] Bug 6716: Update documentation for the letter table The letter table is now for slips and notices, and had other changes necessary.
Created attachment 11013 [details] [review] Bug 6716: Update reserves table This table had one field that I hadn't documented before and two new fields for hold suspensions. All of these are now updated.
Created attachment 11014 [details] [review] Bug 6716: Document saved_sql table
Created attachment 11016 [details] [review] Bug 6716: Document search_history table
Created attachment 11018 [details] [review] Bug 6716: Update z3950servers documentation The new timeout field was not documented.
Created attachment 11019 [details] [review] Bug 6716: Update documentation for the letter table The letter table is now for slips and notices, and had other changes necessary.
Created attachment 11020 [details] [review] Bug 6716: Update reserves table This table had one field that I hadn't documented before and two new fields for hold suspensions. All of these are now updated.
Created attachment 11021 [details] [review] Bug 6716: Document saved_sql table
Created attachment 11022 [details] [review] Bug 6716: Document search_history table
Created attachment 11023 [details] [review] Bug 6716: Update z3950servers documentation The new timeout field was not documented.
seems there's something wrong with -- comment at table level I applied all those patches, then tried to load kohastructure.sql, and got a nasty: ERROR 1064 (42000) at line 2737: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--information related to the basket line items `ordernumber` int(11) NOT NULL ' at line 1 which is: DROP TABLE IF EXISTS `aqorders`; CREATE TABLE `aqorders` ( --information related to the basket line items `ordernumber` int(11) NOT NULL auto_increment, -- primary key and unique identifier assigned by Koha to each li ne seems mySQL don't like the --SOMETHING without space: after adding a space: CREATE TABLE `aqorders` ( -- information related to the basket line items things are OK signed off, passed QA and pushed in master branch all in one go. Thx for your hard work Nicole !
Created attachment 11084 [details] [review] Bug 6716 tiny follow-up, mysql want a space after the --
Comment on attachment 11084 [details] [review] Bug 6716 tiny follow-up, mysql want a space after the -- this patch has been pushed, with many others, (on master branch directly)
Created attachment 11729 [details] [review] update 'onloan' in items and deleteditems This field said it was a 1 or 0 value, but it's a date field.
Created attachment 11823 [details] [review] [SIGNED-OFF] update 'onloan' in items and deleteditems This field said it was a 1 or 0 value, but it's a date field. http://bugs.koha-community.org/show_bug.cgi?id=6716 Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Last patch passes QA.
Comment on attachment 11823 [details] [review] [SIGNED-OFF] update 'onloan' in items and deleteditems This patch has been pushed on master
Created attachment 11987 [details] [review] Bug 6716: Update borrowers tables altaddress definiton The comment on the altcontactaddress3 said it was the 3rd address line but in reality it was the city. This fixes the documentation of that field
Created attachment 12024 [details] [review] Bug 6716 - Fix alt contact field documentation The borrowers table has the wrong documentation for the alternate address3 and city fields. This fixes that.
Created attachment 12561 [details] [review] Bug 6716: Update biblioitems tables This patch documents the cn_sort and agerestriction fields in the biblioitems and deletedbiblioitems tables.
Comment on attachment 12024 [details] [review] Bug 6716 - Fix alt contact field documentation this patch has been pushed
Comment on attachment 12561 [details] [review] Bug 6716: Update biblioitems tables This patch has been pushed
A new bug can be opened for further documentation updates.
Created attachment 26777 [details] [review] Bug 6716 - Document Items Table This patch documents the items table. Some fields were left undocumented because I was unsure of what data was stored there: stack - might be linked to shelving number, but need confirmation paidfor - pretty sure this is unused, but don't want to document it that way Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>