Please note that this is only a proposal.
When you have changes that need to happen on the database, add a row to the table below with the next available version number, your username, the date and a short description (including a buglink if applicable). If you need to describe or discuss the patch more, create a page like 'en:development:dbrevs:v3.00.00.106' (where 3.00.00.106 is the relevant version), and link the version number in the table to it.
| Version | name | date | status | description |
|---|---|---|---|---|
| v3.00.00.105 | amoore | July 30, 2008 | pushed | Adding the SMSSendDriver system preference for bug 2355 |
| v3.00.00.106 | paul | Aug 2nd, 2008 | pushed | cleaning DB of subscriptionhistory.enddate of 0000-00-00 value bug 2452 |
| v3.00.00.107 | amoore | Aug 6, 2008 | pushed | adding warnings on system preferences that cause poor system performance bug 2084 |
| v3.01.00.001 | galen | Aug 14, 2008 | pushed | add table to implement targeting hold requests as part of holds queue batch job; see RFC and bug 2522 and bug 2331 |
| v3.01.00.002 | galen | September 4, 2008 | pushed | fix NULL issues.issuedate |
| v3.01.00.003 | pianohacker | Aug 15, 2008 | pushed | Adding the AllowRenewalLimitOverride system preference |
| v3.01.00.004 | Allen | Oct 29, 2008 | pushed | Add OPACDisplayRequestPriority to systempreferences |
| v3.01.00.005 | pianohacker | Oct 04, 2008 | pushed | Add letters for holds notifications |
| v3.01.00.006 | galen | December 11, 2008 | pushed | add index on biblioitems.issn |
| v3.01.00.007 | pianohacker | Aug 22, 2008 | pushed | fixing display of many sysprefs |
| v3.01.00.008 | kylemhall | Nov 14, 2008 | submitted | Adding branch transfer limits table |
| v3.01.00.009 | beppu | Nov 14, 2008 | pushed | Overriding Blocked Renewals: adding more user_permissions |
| v3.01.00.010 | danny | Nov 19, 2008 | pushed | Increase length of borrower attribute fields bug 2687 |
| v3.01.00.011 | amoore | Dec 18, 2008 | submitted | removed bogus intranetuserjs syspref for bug 2578 |
| v3.01.00.013 | kylemhall | Jan 2, 2009 | submitted | Table updates for Branch Transfer Limits |
| v3.01.00.014 | kylemhall | Jan 5, 2009 | submited | System Preference for FinesOnReturn |
| v3.01.00.015 | nahuel | Jan 8, 2009 | submited | Add a syspref called 'AllowNotForLoanOverride' need for the bugfix #2893 |
| v3.01.00.016 | kylemhall | Dec 5, 2008 | submitted | Additional fields for the reserves table |
| v3.01.00.017 | kylemhall | Jan 20, 2009 | submitted | Clubs & Services tables for port from dev_week |
| v3.01.00.018 | kylemhall | Dec 9, 2008 | submitted | Tables for the Rotating Collections ported from dev_week |
| v3.01.00.019 | nahuel | Jan 28, 2009 | pending | column in issuingrules for fine days |
| v3.01.00.020 | atz | Feb 4, 2009 | pending | Enlarge labels_conf.formatstring |
| v3.01.00.021 | kylemhall | Feb 9, 2009 | submitted | Messages table for new messaging system |
| v3.01.00.022 | mdhafen | Feb. 24 2009 | submitted | Add system preference for maxItemsinSearchResult |
| v3.01.00.023 | mdhafen | Feb. 25 2009 | submitted | New feature and system preference Due Date Ceiling |
| v3.01.00.024 | mdhafen | Feb. 25 2009 | submitted | New feature and system preference Number of Returned Items To Show |
| v3.01.00.025 | nahuel | March 9 2009 | pending | column for subscriptions grace period |
| v3.01.00.026 | fdemians | March 20 2009 | pending | A syspref enabling a new OPAC enhanced content |
| v3.01.00.027 | kivutar | Jun 9 2009 | pending | A syspref to enable ILS-DI services |
| v3.01.00.038 | nahuel | Jun 10, 2009 | pending | Allowed renewals column in issuingrules table, and dropping contraints |
| v3.01.00.039 | kivutar | Jun 22, 2009 | pending | 3 sysprefs for antispam in anonymous suggestions |
| v3.01.00.041 | kivutar | Jul 6, 2009 | pending | Permissions for batch modification and deletion of items |
| v3.01.00.042 | colinsc | Jul 26, 2009 | pushed | syspref to limit OPAC renewals by fine amount |
| v3.01.00.043 | colinsc | Jul 26, 2009 | pushed | New item column and sysprefs for Shelving and In Processing status |
| v3.01.00.044 | colinsc | Jul 26, 2009 | pushed | Add syspref for clear screen in circulation |
| v3.01.00.045 | chris | August 19 2009 | pushed | Add syspref to hide borrowers name |
| v3.01.00.046 | Sébastien Hinderer | August 2, 2009 | pushed | Add country and B_country to borrowers bug 3464 |
| v3.01.00.047 | nengard | Aug 16, 2009 | pushed | Changed length of itemcallnumber to 255 bug 2761 |
| v3.01.00.048 | nengard | Aug 16, 2009 | pushed | Changed catalogue to catalog and fixed capitalization in Patron Permissions bug 2611 |
| v3.01.00.049 | nengard | Aug 19, 2009 | pushed | Changed catalogue to catalog on the expanded permissions bug 2611 |
| v3.01.00.050 | nengard | Aug 23, 2009 | pushed | New system preference OPACSearchForTitleIn to allow for editing of 'More Search Options' bug 1934 |
| v3.01.00.051 | nengard | August 23, 2009 | pushed | fixed typos in new system preferences |
| v3.01.00.052 | gmcharlt | August 23, 2009 | pushed | add permanent_location to deleted items |
| v3.01.00.053 | chris_n2 | Sep 5, 2009 | pushed | labels changes |
| v3.01.00.054 | kfischer | Sep 04, 2009 | pushed | Bug 1600: Added B_address2 and altcontactcountry to borrowers and deletedborrowers |
| v3.01.00.055 | nengard | Aug 24, 2009 | pushed | changed OPACSearchForTitleIn per requests in bug 1934 |
| v3.01.00.056 | nengard | Aug 25, 2009 | pushed | Added OPACPatronDetails system preference bug 1172 |
| v3.01.00.057 | nengard | Aug 25, 2009 | pushed | Added OPACFinesTab Syspref bug 2572 |
| v3.01.00.058 | nengard | Aug 25, 2009 | pushed | Added primary keys to tables per comments bug 2559 |
| v3.01.00.059 | jwagner | Aug 23, 2009 | pushed | Added DisplayOPACiconsXSLT syspref bug 3545 |
| v3.01.00.060 | colinsc | Jul 25, 2009 | pushed | new patron note/message table and AllowAllMessageDeletion syspref |
| v3.01.00.061 | gmcharlt | Jul 22, 2009 | pushed | ShowPatronImageInWebBasedSelfCheck system preference bug 3436 |
| no # yet | ryan | Oct 20, 2008 | pending | Add barcode prefixes (See RFC) |
| no # yet | allen | Dec 14, 2008 | pending | fines cleanup adding accounttypes table and foreign keys for accountlines |
| no # yet | amoore | Dec 18, 2008 | pending | Implementing summary records |
| no # yet | beppu | Dec 24, 2008 | pending | Email Checkout Slips |
| no # yet | sbrinker | Dec 24, 2008 | pending | Alter suggestion title length from 80 to 255 to fix Bug 2046 |
| no # yet | gmcharlt | Jan 8, 2009 | pending | Add 'loc' to list of values for AdvancedSearchType syspref |
| no # yet | beppu | Mar 26, 2009 | pending | New system preferences and user_permissions for deletions project |
| no # yet | nengard | Sep 22, 2009 | pending | Add new authorized values categories for manual invoice and borrower notes & Add new locations to authorized values for shelf to cart processing |
| no # yet | nengard | Nov 30, 2009 | pending | Add tag moderation permissions bug 3817 |