[Bug 6716] New: Database Documentation
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Bug #: 6716 Summary: Database Documentation Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: ASSIGNED Severity: enhancement Priority: P5 Component: Developer documentation AssignedTo: nengard@gmail.com ReportedBy: nengard@gmail.com QAContact: koha-bugs@lists.koha-community.org 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 |PATCH-Sent Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #1 from Nicole C. Engard <nengard@gmail.com> 2011-08-12 20:33:29 UTC --- Created attachment 4987 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=4987 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #4987|0 |1 is obsolete| | --- Comment #2 from Nicole C. Engard <nengard@gmail.com> 2011-08-12 20:42:24 UTC --- Created attachment 4988 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=4988 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Needs Signoff |Failed QA -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #4988|0 |1 is obsolete| | --- Comment #3 from Nicole C. Engard <nengard@gmail.com> 2011-08-12 21:27:39 UTC --- Created attachment 4989 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=4989 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Failed QA |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #4989|0 |1 is obsolete| | --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-08-14 13:19:46 UTC --- Created attachment 4992 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=4992 [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
-- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #5 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 20:10:54 UTC --- Created attachment 5003 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5003 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Signed Off |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #6 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 20:29:52 UTC --- Created attachment 5004 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5004 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #7 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 20:51:05 UTC --- Created attachment 5005 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5005 Bug 6716 - Deleted Borrowers MySQL Copied documentation from Borrowers to Deleted Borrowers table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #8 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 20:57:56 UTC --- Created attachment 5006 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5006 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #9 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 21:17:10 UTC --- Created attachment 5007 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5007 Bug 6716 - Branch table documentation Documenting the branches table in Koha. Two unused fields noted, please update if they are in fact used. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #10 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 21:37:55 UTC --- Created attachment 5008 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5008 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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #11 from Nicole C. Engard <nengard@gmail.com> 2011-08-14 21:56:47 UTC --- Created attachment 5009 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5009 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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #12 from Nicole C. Engard <nengard@gmail.com> 2011-08-15 00:31:03 UTC --- Created attachment 5011 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5011 Bug 6716 - Borrower Attributes Tables This patch defines the borrower attributes tables (borrower_attributes and borrower_attribute_types). -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #13 from Nicole C. Engard <nengard@gmail.com> 2011-08-15 00:43:21 UTC --- Created attachment 5012 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5012 Bug 6716 - Cities Table Documentation Docmenting the cities table. Signed-off-by: Nicole C. Engard <nengard@bywatersolutions.com> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #14 from Nicole C. Engard <nengard@gmail.com> 2011-08-15 00:52:04 UTC --- Created attachment 5013 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5013 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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #15 from Nicole C. Engard <nengard@gmail.com> 2011-08-15 01:45:07 UTC --- Created attachment 5014 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5014 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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #16 from Nicole C. Engard <nengard@gmail.com> 2011-08-25 03:00:05 UTC --- Created attachment 5139 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5139 Bug 6716 - Definition of the branchcategories table This patch adds field definitions to the branchcategories table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #17 from Nicole C. Engard <nengard@gmail.com> 2011-08-25 03:01:59 UTC --- Created attachment 5140 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5140 Bug 6716: DB Documentation for the branchrelations table Documents the branchrelations table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #18 from Nicole C. Engard <nengard@gmail.com> 2011-08-25 03:11:36 UTC --- Created attachment 5141 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5141 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #19 from Nicole C. Engard <nengard@gmail.com> 2011-08-25 03:15:59 UTC --- Created attachment 5142 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5142 Bug 6716: Documentation for the letter table This patch documents the letter/notices table in Koha. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #20 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:25:06 UTC --- Created attachment 5174 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5174 Bug 6716 - Document opac_news table Definiton for the opac_news table which stores date from the news tool in Koha. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #21 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:31:01 UTC --- Created attachment 5175 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5175 Bug 6716 - Definition for the overduerules table This patch defines the overduerules table which includes information from the Overdue Notice Status Triggers Tool. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #22 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:34:50 UTC --- Created attachment 5176 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5176 Bug 6716 - Document reviews table This patch adds documentation to the reviews (or comments) table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #23 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:37:46 UTC --- Created attachment 5177 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5177 Bug 6716 - Document roadtype table This patch adds documentation to the roadtype table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #24 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:43:34 UTC --- Created attachment 5178 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5178 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #25 from Nicole C. Engard <nengard@gmail.com> 2011-08-27 20:50:57 UTC --- Created attachment 5179 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5179 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #26 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 19:44:04 UTC --- Created attachment 5186 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5186 Bug 6716 - Documentation for the messages table This documents the messages table which stores info about the circulation messages. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #27 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 20:11:16 UTC --- Created attachment 5187 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5187 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #28 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 20:36:18 UTC --- Created attachment 5188 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5188 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #29 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 20:50:53 UTC --- Created attachment 5190 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5190 Bug 6716 - Document subscriptionroutinglist table This table holds information related to serials routing lists. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #30 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 21:29:13 UTC --- Created attachment 5192 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5192 Bug 6716 - Document holiday tables This patch documents the special_holidays and repeatable_holidays tables. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #31 from Nicole C. Engard <nengard@gmail.com> 2011-08-28 22:03:41 UTC --- Created attachment 5193 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5193 Bug 6716 - Define reports_dictionary table This patch documents the reports_dictionary table. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #32 from Nicole C. Engard <nengard@gmail.com> 2011-09-08 12:16:15 UTC --- Created attachment 5355 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5355 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5355|0 |1 is obsolete| | --- Comment #33 from Nicole C. Engard <nengard@gmail.com> 2011-09-08 12:45:03 UTC --- Created attachment 5356 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5356 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz Patch Status|Needs Signoff |Patch Pushed --- Comment #34 from Chris Cormack <chris@bigballofwax.co.nz> 2011-09-12 21:08:39 UTC --- All patches attached have been pushed, please test, then reset the status if you add more patches -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #35 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 15:35:02 UTC --- Created attachment 5663 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5663 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Patch Pushed |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #36 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 16:55:47 UTC --- Created attachment 5664 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5664 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` -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #37 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 17:25:00 UTC --- Created attachment 5665 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5665 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5665|0 |1 is obsolete| | --- Comment #38 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 17:51:27 UTC --- Created attachment 5666 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5666 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #39 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 18:29:54 UTC --- Created attachment 5668 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5668 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5666|0 |1 is obsolete| | --- Comment #40 from Nicole C. Engard <nengard@gmail.com> 2011-09-30 18:32:14 UTC --- Created attachment 5669 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5669 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #41 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-10-04 07:14:49 UTC --- 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #42 from Nicole C. Engard <nengard@gmail.com> 2011-10-04 11:56:27 UTC --- Thanks, I'll submit an updated patch with some of this info. Nicole -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5669|0 |1 is obsolete| | --- Comment #43 from Nicole C. Engard <nengard@gmail.com> 2011-10-04 12:06:04 UTC --- Created attachment 5686 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5686 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5668|0 |1 is obsolete| | --- Comment #44 from Nicole C. Engard <nengard@gmail.com> 2011-10-04 12:11:52 UTC --- Created attachment 5687 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5687 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #45 from Nicole C. Engard <nengard@gmail.com> 2011-10-04 19:59:53 UTC --- Created attachment 5706 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5706 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #46 from Nicole C. Engard <nengard@gmail.com> 2011-10-10 20:20:57 UTC --- Created attachment 5829 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=5829 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #47 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 2011-10-20 07:33:42 UTC --- Created attachment 6004 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6004 Documenting need_merge_authorities -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #48 from Nicole C. Engard <nengard@gmail.com> 2011-10-21 12:23:42 UTC --- Created attachment 6015 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6015 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|master |Rel_3_8 --- Comment #49 from Paul Poulain <paul.poulain@biblibre.com> 2011-10-24 11:38:21 UTC --- Updating Version : This ENH will be for Koha 3.8 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|Rel_3_8 |master --- Comment #50 from Paul Poulain <paul.poulain@biblibre.com> 2011-10-25 15:05:58 UTC --- 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) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #51 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:08:44 UTC --- The content of attachment 4992 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #52 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:09:05 UTC --- The content of attachment 5003 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #53 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:09:36 UTC --- The content of attachment 5004 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #54 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:09:54 UTC --- The content of attachment 5005 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #55 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:10:57 UTC --- The content of attachment 5006 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #56 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:12:11 UTC --- The content of attachment 5007 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #57 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:12:30 UTC --- The content of attachment 5008 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #58 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:12:48 UTC --- The content of attachment 5009 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #59 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:13:23 UTC --- The content of attachment 5011 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #60 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:13:58 UTC --- The content of attachment 5012 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #61 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:14:31 UTC --- The content of attachment 5013 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #62 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:14:49 UTC --- The content of attachment 5014 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #63 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:15:27 UTC --- The content of attachment 5139 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #64 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:15:49 UTC --- The content of attachment 5140 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #65 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:16:08 UTC --- The content of attachment 5141 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #66 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:16:25 UTC --- The content of attachment 5142 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #67 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:16:43 UTC --- The content of attachment 5174 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #68 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:17:05 UTC --- The content of attachment 5175 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #69 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:17:25 UTC --- The content of attachment 5176 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #70 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:18:06 UTC --- The content of attachment 5177 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #71 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:18:44 UTC --- The content of attachment 5178 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #72 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:19:16 UTC --- The content of attachment 5179 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #73 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:19:47 UTC --- The content of attachment 5186 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #74 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:20:06 UTC --- The content of attachment 5187 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #75 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:20:49 UTC --- The content of attachment 5188 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #76 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:21:06 UTC --- The content of attachment 5190 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #77 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:21:24 UTC --- The content of attachment 5192 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #78 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:21:40 UTC --- The content of attachment 5193 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #79 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:22:04 UTC --- The content of attachment 5356 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #80 from Chris Cormack <chris@bigballofwax.co.nz> 2011-12-04 08:22:33 UTC --- I have cleaned off the patches already pushed, the rest still need sign off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #5663|0 |1 is obsolete| | Attachment #5664|0 |1 is obsolete| | Attachment #5686|0 |1 is obsolete| | Attachment #5687|0 |1 is obsolete| | Attachment #5706|0 |1 is obsolete| | Attachment #5829|0 |1 is obsolete| | Attachment #6004|0 |1 is obsolete| | Attachment #6015|0 |1 is obsolete| | --- Comment #81 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:04:56 UTC --- Created attachment 6591 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6591 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #82 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:06:39 UTC --- Created attachment 6592 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6592 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #83 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:06:48 UTC --- Created attachment 6593 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6593 [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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #84 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:06:56 UTC --- Created attachment 6594 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6594 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #85 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:07:04 UTC --- Created attachment 6595 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6595 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #86 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:07:12 UTC --- Created attachment 6596 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6596 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #87 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:07:25 UTC --- Created attachment 6597 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6597 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #88 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:07:32 UTC --- Created attachment 6598 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6598 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #89 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:07:40 UTC --- Created attachment 6599 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6599 [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> -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6591|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|Needs Signoff |Signed Off --- Comment #90 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 07:08:32 UTC --- Applied patches and created a new database. No errors were reported and all documented tables were created. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |paul.poulain@biblibre.com --- Comment #91 from Paul Poulain <paul.poulain@biblibre.com> 2011-12-06 19:15:14 UTC --- 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 -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #92 from Katrin Fischer <katrin.fischer@bsz-bw.de> 2011-12-06 19:19:41 UTC --- * 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6592|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6594|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6595|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6596|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6597|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6599|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #93 from Paul Poulain <paul.poulain@biblibre.com> 2011-12-13 14:53:51 UTC --- QA comment : patches applying, tested it kohastructure.sql still valid after applying them. 6 patches pushed, -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |m.de.rooy@rijksmuseum.nl Patch Status|Signed Off |Passed QA QAContact|koha-bugs@lists.koha-commun |m.de.rooy@rijksmuseum.nl |ity.org | --- Comment #94 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 2012-01-10 15:08:42 UTC --- QA: Documentation changes only. OK -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6593|0 |1 is obsolete| | --- Comment #95 from Paul Poulain <paul.poulain@biblibre.com> 2012-01-13 10:46:22 UTC --- Comment on attachment 6593 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6593 [SIGNED-OFF] bug6716 - document the aqbooksellers table patch pushed -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #6598|0 |1 is obsolete| | --- Comment #96 from Paul Poulain <paul.poulain@biblibre.com> 2012-01-13 10:46:32 UTC --- Comment on attachment 6598 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=6598 [SIGNED-OFF] 6717 Documenting need_merge_authorities table patch pushed -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|PATCH-Sent |P3 Patch Status|Passed QA |--- -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #97 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10788 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10788&action=edit Bug 6716: Document the aqbasket table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #98 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10789 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10789&action=edit Bug 6716: Document aqbudgets and aqbudgetperiods tables -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #99 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10790 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10790&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #100 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10791 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10791&action=edit Bug 6716: Document aqorders_items table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #101 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10792 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10792&action=edit Bug 6716: Document branchtransfers table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #102 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10793 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10793&action=edit Bug 6716: Update ratings table documentation This patch adds a comment to the table and updates the field descriptions with a bit more information. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #103 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10794 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10794&action=edit Bug 6716: Document action_logs table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #10788|0 |1 is obsolete| | --- Comment #104 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10795 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10795&action=edit Bug 6716: Document aqbasket table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #105 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10822 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10822&action=edit Bug 6716: Document the biblio_framework table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #106 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10823 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10823&action=edit Bug 6716: Document branch_item_rules table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #107 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10824 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10824&action=edit Bug 6716: Document branch_borrower_circ_rules table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #108 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10832 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10832&action=edit Bug 6716: document issuingrules table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #109 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10833 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10833&action=edit Bug 6716: Document patronimage table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #110 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10942 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10942&action=edit 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.' -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #111 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10970 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10970&action=edit Bug 6716: Document import_batches table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #112 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 10975 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10975&action=edit Bug 6716: document import_record_matches table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #113 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11011 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11011&action=edit Bug 6716: Update documentation for the letter table The letter table is now for slips and notices, and had other changes necessary. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #114 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11013 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11013&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- CC|m.de.rooy@rijksmuseum.nl | -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #115 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11014 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11014&action=edit Bug 6716: Document saved_sql table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #116 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11016 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11016&action=edit Bug 6716: Document search_history table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #117 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11018 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11018&action=edit Bug 6716: Update z3950servers documentation The new timeout field was not documented. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11011|0 |1 is obsolete| | --- Comment #118 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11019 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11019&action=edit Bug 6716: Update documentation for the letter table The letter table is now for slips and notices, and had other changes necessary. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11013|0 |1 is obsolete| | --- Comment #119 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11020 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11020&action=edit 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11014|0 |1 is obsolete| | --- Comment #120 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11021 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11021&action=edit Bug 6716: Document saved_sql table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11016|0 |1 is obsolete| | --- Comment #121 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11022 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11022&action=edit Bug 6716: Document search_history table -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11018|0 |1 is obsolete| | --- Comment #122 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11023 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11023&action=edit Bug 6716: Update z3950servers documentation The new timeout field was not documented. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off --- Comment #123 from Paul Poulain <paul.poulain@biblibre.com> --- 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 ! -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #10789|0 |1 is obsolete| | Attachment #10790|0 |1 is obsolete| | Attachment #10791|0 |1 is obsolete| | Attachment #10792|0 |1 is obsolete| | Attachment #10793|0 |1 is obsolete| | Attachment #10794|0 |1 is obsolete| | Attachment #10795|0 |1 is obsolete| | Attachment #10822|0 |1 is obsolete| | Attachment #10823|0 |1 is obsolete| | Attachment #10824|0 |1 is obsolete| | Attachment #10832|0 |1 is obsolete| | Attachment #10833|0 |1 is obsolete| | Attachment #10942|0 |1 is obsolete| | Attachment #10970|0 |1 is obsolete| | Attachment #10975|0 |1 is obsolete| | Attachment #11019|0 |1 is obsolete| | Attachment #11020|0 |1 is obsolete| | Attachment #11021|0 |1 is obsolete| | Attachment #11022|0 |1 is obsolete| | Attachment #11023|0 |1 is obsolete| | --- Comment #124 from Paul Poulain <paul.poulain@biblibre.com> --- Created attachment 11084 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11084&action=edit Bug 6716 tiny follow-up, mysql want a space after the -- -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to Master -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11084|0 |1 is obsolete| | --- Comment #125 from Paul Poulain <paul.poulain@biblibre.com> --- Comment on attachment 11084 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11084 Bug 6716 tiny follow-up, mysql want a space after the -- this patch has been pushed, with many others, (on master branch directly) -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #126 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11729 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11729&action=edit update 'onloan' in items and deleteditems This field said it was a 1 or 0 value, but it's a date field. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to Master |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11729|0 |1 is obsolete| | --- Comment #127 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 11823 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11823&action=edit [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> -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA CC| |jonathan.druart@biblibre.co | |m --- Comment #128 from Jonathan Druart <jonathan.druart@biblibre.com> --- Last patch passes QA. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11823|0 |1 is obsolete| | --- Comment #129 from Paul Poulain <paul.poulain@biblibre.com> --- Comment on attachment 11823 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11823 [SIGNED-OFF] update 'onloan' in items and deleteditems This patch has been pushed on master -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #130 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 11987 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11987&action=edit 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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #11987|0 |1 is obsolete| | --- Comment #131 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 12024 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12024&action=edit Bug 6716 - Fix alt contact field documentation The borrowers table has the wrong documentation for the alternate address3 and city fields. This fixes that. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #132 from Nicole C. Engard <nengard@gmail.com> --- Created attachment 12561 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12561&action=edit Bug 6716: Update biblioitems tables This patch documents the cn_sort and agerestriction fields in the biblioitems and deletedbiblioitems tables. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #12024|0 |1 is obsolete| | --- Comment #133 from Paul Poulain <paul.poulain@biblibre.com> --- Comment on attachment 12024 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12024 Bug 6716 - Fix alt contact field documentation this patch has been pushed -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #12561|0 |1 is obsolete| | --- Comment #134 from Paul Poulain <paul.poulain@biblibre.com> --- Comment on attachment 12561 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12561 Bug 6716: Update biblioitems tables This patch has been pushed -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Paul Poulain <paul.poulain@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 Jared Camins-Esakov <jcamins@cpbibliography.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |FIXED --- Comment #135 from Jared Camins-Esakov <jcamins@cpbibliography.com> --- A new bug can be opened for further documentation updates. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6716 --- Comment #136 from Liz Rea <liz@catalyst.net.nz> --- Created attachment 26777 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=26777&action=edit 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> -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org