Lines 1-66
Link Here
|
1 |
ALTER TABLE systempreferences ADD version varchar(12) DEFAULT NULL; |
1 |
ALTER TABLE systempreferences ADD version varchar(12) DEFAULT NULL; |
|
|
2 |
ALTER TABLE systempreferences ADD display_choices mediumtext DEFAULT NULL; |
2 |
UPDATE systempreferences SET version="16.06.00.003" WHERE variable ="MaxItemsToProcessForBatchMod"; |
3 |
UPDATE systempreferences SET version="16.06.00.003" WHERE variable ="MaxItemsToProcessForBatchMod"; |
3 |
UPDATE systempreferences SET version="16.06.00.003" WHERE variable ="MaxItemsToDisplayForBatchDel"; |
4 |
UPDATE systempreferences SET version="16.06.00.003" WHERE variable ="MaxItemsToDisplayForBatchDel"; |
4 |
UPDATE systempreferences SET version="16.06.00.004" WHERE variable ="OPACXSLTListsDisplay"; |
5 |
UPDATE systempreferences SET version="16.06.00.004" WHERE variable ="OPACXSLTListsDisplay"; |
5 |
UPDATE systempreferences SET version="16.06.00.004" WHERE variable ="XSLTListsDisplay"; |
6 |
UPDATE systempreferences SET version="16.06.00.004" WHERE variable ="XSLTListsDisplay"; |
6 |
UPDATE systempreferences SET version="16.06.00.005" WHERE variable ="XSLTListsDisplay"; |
7 |
UPDATE systempreferences SET version="16.06.00.005" WHERE variable ="XSLTListsDisplay"; |
7 |
UPDATE systempreferences SET version="16.06.00.006" WHERE variable="RefundLostOnReturnControl"; |
8 |
UPDATE systempreferences SET version="16.06.00.006", display_choices="check-in library.|item home branch.|item holding branch." WHERE variable="RefundLostOnReturnControl"; |
8 |
UPDATE systempreferences SET version="16.06.00.007" WHERE variable="PatronQuickAddFields"; |
9 |
UPDATE systempreferences SET version="16.06.00.007" WHERE variable="PatronQuickAddFields"; |
9 |
UPDATE systempreferences SET version="16.06.00.008" WHERE variable="CheckPrevCheckout"; |
10 |
UPDATE systempreferences SET version="16.06.00.008", display_choices="Do|Unless overridden, do|Unless overridden, do not|Do not" WHERE variable="CheckPrevCheckout"; |
10 |
UPDATE systempreferences SET version="16.06.00.009" WHERE variable="IntranetCatalogSearchPulldown"; |
11 |
UPDATE systempreferences SET version="16.06.00.009", display_choices="Don't show|Show" WHERE variable="IntranetCatalogSearchPulldown"; |
11 |
UPDATE systempreferences SET version="16.06.00.010" WHERE variable="MaxOpenSuggestions"; |
12 |
UPDATE systempreferences SET version="16.06.00.010" WHERE variable="MaxOpenSuggestions"; |
12 |
UPDATE systempreferences SET version="16.06.00.011" WHERE variable="NovelistSelectStaffEnabled"; |
13 |
UPDATE systempreferences SET version="16.06.00.011", display_choices="Don't add|add" WHERE variable="NovelistSelectStaffEnabled"; |
13 |
UPDATE systempreferences SET version="16.06.00.011" WHERE variable="NovelistSelectStaffView"; |
14 |
UPDATE systempreferences SET version="16.06.00.011", display_choices="in a tab|above the holdings table|below the holdings table" WHERE variable="NovelistSelectStaffView"; |
14 |
UPDATE systempreferences SET version="16.06.00.013" WHERE variable="OPACResultsLibrary"; |
15 |
UPDATE systempreferences SET version="16.06.00.013", display_choices="home library|current location" WHERE variable="OPACResultsLibrary"; |
15 |
UPDATE systempreferences SET version="16.06.00.015" WHERE variable="HoldsLog"; |
16 |
UPDATE systempreferences SET version="16.06.00.015", display_choices="Don't log|Log" WHERE variable="HoldsLog"; |
16 |
UPDATE systempreferences SET version="16.06.00.020" WHERE variable="SwitchOnSiteCheckouts"; |
17 |
UPDATE systempreferences SET version="16.06.00.020", display_choices="Don't switch|Switch" WHERE variable="SwitchOnSiteCheckouts"; |
17 |
UPDATE systempreferences SET version="16.06.00.027" WHERE variable="TrackLastPatronActivity"; |
18 |
UPDATE systempreferences SET version="16.06.00.027", display_choices="Don't|Do" WHERE variable="TrackLastPatronActivity"; |
18 |
UPDATE systempreferences SET version="16.06.00.021" WHERE variable="PatronSelfRegistrationEmailMustBeUnique"; |
19 |
UPDATE systempreferences SET version="16.06.00.021", display_choices="Do not consider|Consider" WHERE variable="PatronSelfRegistrationEmailMustBeUnique"; |
19 |
UPDATE systempreferences SET version="16.06.00.023" WHERE variable="timeout"; |
20 |
UPDATE systempreferences SET version="16.06.00.023" WHERE variable="timeout"; |
20 |
UPDATE systempreferences SET version="16.06.00.025" WHERE variable="makePreviousSerialAvailable"; |
21 |
UPDATE systempreferences SET version="16.06.00.025", display_choices="Do not make|Make" WHERE variable="makePreviousSerialAvailable"; |
21 |
UPDATE systempreferences SET version="16.06.00.026" WHERE variable="PatronSelfRegistrationLibraryList"; |
22 |
UPDATE systempreferences SET version="16.06.00.026" WHERE variable="PatronSelfRegistrationLibraryList"; |
22 |
UPDATE systempreferences SET version="16.06.00.027" WHERE variable="TrackLastPatronActivity"; |
23 |
UPDATE systempreferences SET version="16.06.00.027", display_choices="Don't|Do" WHERE variable="TrackLastPatronActivity"; |
23 |
UPDATE systempreferences SET version="16.06.00.029" WHERE variable="UsageStatsLibraryType"; |
24 |
UPDATE systempreferences SET version="16.06.00.029", display_choices="public|school|academic|research|private|society or association|corporate|government|religious organization|subscription" WHERE variable="UsageStatsLibraryType"; |
24 |
UPDATE systempreferences SET version="16.06.00.029" WHERE variable="UsageStatsCountry"; |
25 |
UPDATE systempreferences SET version="16.06.00.029", options="Afghanistan|Albania|Algeria|Andorra|Angola|Angitua & Deps|Argentina|Armenia|Australia|Austria|Azerbaijan|Bahamas|Bahrain|Bangladesh|Barbados|Belarus|Barbados|Belgium|Beliza|Benin|Bhutan|Bolizia|Bosnia Herz.|Botswana|Brazil|Brunei|Bulgaria|Burkina|Burundi|Cambodia|Cameroon|Canada|Capre Verde|Centr. Afr. Rep|Chad|Chile|China|Colombia|Comoros|Congo|Costa Rica|Croatia|Cuba|Cyprus|Czeck Rpublic|Denmark|Djibouti|Dominica|Dominican Rep.|East Timor|Ecuador|Egypt|El Salvador|Equator. Guinea|Eritrea|Estonia|Ethiopia|Fiji|Finland|France|Gabon|Gambia|Georgia|Germany|Ghana|Greece|Grenada|Guatemala|Guinea|Guinea-Bissau|Guyana|Haiti|Honduras|Hungary|Iceland|India|Indonesia|Iran|Iraq|Ireland|Isreal|Italy|Ivory Coast|Jamaica|Japan|Jordan|Kazakhstan|Kenya|Kiribati|Korea North|Korea South|Kosovo|Kuwait|Kyrgyzstan|Laos|Latvia|Lebanon|Lesotho|Liberia|Libya|Liechtenstein|Lithuania|Luxembourg|Macedonia|Madagascar|Malawi|Malyasia|Maldives|Mali|Malta|Marshall Isl.|Mauritania|Mauritius|Mexico|Micronesia|Moldova|Monaco|Mongolia|Montenegro|Morocco|Mozambique|Myanmar|Namibia|Nauru|Nepal|Netherlands|New Zealand|Nicaragua|Niger|Nigeria|Norway|Oman|Pakistan|Palau|Papua N. Guinea|Paraguay|Peru|Philippines|Poland|Portugal|Qatar|Romania|Russian Fed.|Rwanada|St Kitts & Nev.|St Lucia|St Vincent|Samoa|San Marino|Sao Tome|Saudi Arabia|Senegal|Serbia|Seychelles|Sierra Leone|Singapore|Slovakia|Slovenia|Solomon Islands|Somalia|South Africa|Spain|Sri Lanka|Sudan|Suriname|Swaziland|Sweden|Switzerland|Syria|Taiwan|Tajikistan|Tanzania|Thailand|Togo|Tonga|Trinidad & Tob.|Tunisia|Turkey|Turkmenistan|Tuvalu|Uganda|Ukraine|UAE|United Kingdom|USA|Uruguay|Uzbekistan|Vanuatu|Vatican City|Venezuela|Vietnam|Yemen|Zambia|Zimbabwe", display_choices="Afghanistan|Albania|Algeria|Andorra|Angola|Angitua & Deps|Argentina|Armenia|Australia|Austria|Azerbaijan|Bahamas|Bahrain|Bangladesh|Barbados|Belarus|Barbados|Belgium|Beliza|Benin|Bhutan|Bolizia|Bosnia Herz.|Botswana|Brazil|Brunei|Bulgaria|Burkina|Burundi|Cambodia|Cameroon|Canada|Capre Verde|Centr. Afr. Rep|Chad|Chile|China|Colombia|Comoros|Congo|Costa Rica|Croatia|Cuba|Cyprus|Czeck Rpublic|Denmark|Djibouti|Dominica|Dominican Rep.|East Timor|Ecuador|Egypt|El Salvador|Equator. Guinea|Eritrea|Estonia|Ethiopia|Fiji|Finland|France|Gabon|Gambia|Georgia|Germany|Ghana|Greece|Grenada|Guatemala|Guinea|Guinea-Bissau|Guyana|Haiti|Honduras|Hungary|Iceland|India|Indonesia|Iran|Iraq|Ireland|Isreal|Italy|Ivory Coast|Jamaica|Japan|Jordan|Kazakhstan|Kenya|Kiribati|Korea North|Korea South|Kosovo|Kuwait|Kyrgyzstan|Laos|Latvia|Lebanon|Lesotho|Liberia|Libya|Liechtenstein|Lithuania|Luxembourg|Macedonia|Madagascar|Malawi|Malyasia|Maldives|Mali|Malta|Marshall Isl.|Mauritania|Mauritius|Mexico|Micronesia|Moldova|Monaco|Mongolia|Montenegro|Morocco|Mozambique|Myanmar|Namibia|Nauru|Nepal|Netherlands|New Zealand|Nicaragua|Niger|Nigeria|Norway|Oman|Pakistan|Palau|Papua N. Guinea|Paraguay|Peru|Philippines|Poland|Portugal|Qatar|Romania|Russian Fed.|Rwanada|St Kitts & Nev.|St Lucia|Saint Vincent|Samoa|San Marino|Sao Tome|Saudi Arabia|Senegal|Serbia|Seychelles|Sierra Leone|Singapore|Slovakia|Slovenia|Solomon Islands|Somalia|South Africa|Spain|Sri Lanka|Sudan|Suriname|Swaziland|Sweden|Switzerland|Syria|Taiwan|Tajikistan|Tanzania|Thailand|Togo|Tonga|Trinidad & Tob.|Tunisia|Turkey|Turkmenistan|Tuvalu|Uganda|Ukraine|UAE|United Kingdom|USA|Uruguay|Uzbekistan|Vanuatu|Vatican City|Venezuela|Vietnam|Yemen|Zambia|Zimbabwe" WHERE variable="UsageStatsCountry"; |
25 |
UPDATE systempreferences SET version="16.06.00.030" WHERE variable="OPACHoldingsDefaultSortField"; |
26 |
UPDATE systempreferences SET version="16.06.00.030", display_choices="First column of the table|Home library|Holding library" WHERE variable="OPACHoldingsDefaultSortField"; |
26 |
UPDATE systempreferences SET version="16.06.00.031" WHERE variable="PatronSelfRegistrationPrefillForm"; |
27 |
UPDATE systempreferences SET version="16.06.00.031", display_choices="Do not display and prefill|Display and prefill" WHERE variable="PatronSelfRegistrationPrefillForm"; |
27 |
UPDATE systempreferences SET version="16.06.00.035" WHERE variable="AllowItemsOnHoldCheckoutSCO"; |
28 |
UPDATE systempreferences SET version="16.06.00.035", display_choices="Don't allow|Allow" WHERE variable="AllowItemsOnHoldCheckoutSCO"; |
28 |
UPDATE systempreferences SET version="16.06.00.036" WHERE variable="HouseboundModule"; |
29 |
UPDATE systempreferences SET version="16.06.00.036", display_choices="Disable|Enable" WHERE variable="HouseboundModule"; |
29 |
UPDATE systempreferences SET version="16.06.00.037" WHERE variable="ArticleRequests"; |
30 |
UPDATE systempreferences SET version="16.06.00.037", display_choices="Don't enable|Enable" WHERE variable="ArticleRequests"; |
30 |
UPDATE systempreferences SET version="16.06.00.037" WHERE variable="ArticleRequestsMandatoryFields"; |
31 |
UPDATE systempreferences SET version="16.06.00.037", display_choices="Title|Author|Volume|Issue|Date|Pages|Chapters" WHERE variable="ArticleRequestsMandatoryFields"; |
31 |
UPDATE systempreferences SET version="16.06.00.037" WHERE variable="ArticleRequestsMandatoryFieldsItemsOnly"; |
32 |
UPDATE systempreferences SET version="16.06.00.037", display_choices="Title|Author|Volume|Issue|Date|Pages|Chapters" WHERE variable="ArticleRequestsMandatoryFieldsItemsOnly"; |
32 |
UPDATE systempreferences SET version="16.06.00.037" WHERE variable="ArticleRequestsMandatoryFieldsRecordOnly"; |
33 |
UPDATE systempreferences SET version="16.06.00.037", display_choices="Title|Author|Volume|Issue|Date|Pages|Chapters" WHERE variable="ArticleRequestsMandatoryFieldsRecordOnly"; |
33 |
UPDATE systempreferences SET version="16.06.00.038" WHERE variable="DefaultPatronSearchFields"; |
34 |
UPDATE systempreferences SET version="16.06.00.038", display_choices="surname,firstname,othernames,cardnumber,userid" WHERE variable="DefaultPatronSearchFields"; |
34 |
UPDATE systempreferences SET version="16.06.00.041" WHERE variable="AggressiveMatchOnISSN"; |
35 |
UPDATE systempreferences SET version="16.06.00.041", display_choices="don't|do" WHERE variable="AggressiveMatchOnISSN"; |
35 |
UPDATE systempreferences SET version="16.06.00.045" WHERE variable="BorrowerRenewalPeriodBase"; |
36 |
UPDATE systempreferences SET version="16.06.00.045", display_choices="current membership expiry date.|current date.|the latter of the current and expiry date." WHERE variable="BorrowerRenewalPeriodBase"; |
36 |
UPDATE systempreferences SET version="16.06.00.049" WHERE variable="ReplytoDefault"; |
37 |
UPDATE systempreferences SET version="16.06.00.049" WHERE variable="ReplytoDefault"; |
37 |
UPDATE systempreferences SET version="16.06.00.049" WHERE variable="ReturnpathDefault"; |
38 |
UPDATE systempreferences SET version="16.06.00.049" WHERE variable="ReturnpathDefault"; |
38 |
UPDATE systempreferences SET version="16.12.00.005" WHERE variable="AuthorityMergeMode"; |
39 |
UPDATE systempreferences SET version="16.12.00.005", display_choices="loose|strict" WHERE variable="AuthorityMergeMode"; |
39 |
UPDATE systempreferences SET version="16.12.00.008" WHERE variable="MarcItemFieldsToOrder"; |
40 |
UPDATE systempreferences SET version="16.12.00.008" WHERE variable="MarcItemFieldsToOrder"; |
40 |
UPDATE systempreferences SET version="16.12.00.009" WHERE variable="OPACHoldsIfAvailableAtPickup"; |
41 |
UPDATE systempreferences SET version="16.12.00.009", display_choices="Don't allow|Allow" WHERE variable="OPACHoldsIfAvailableAtPickup"; |
41 |
UPDATE systempreferences SET version="16.12.00.009" WHERE variable="OPACHoldsIfAvailableAtPickupExceptions"; |
42 |
UPDATE systempreferences SET version="16.12.00.009" WHERE variable="OPACHoldsIfAvailableAtPickupExceptions"; |
42 |
UPDATE systempreferences SET version="16.12.00.010" WHERE variable="OverDriveCirculation"; |
43 |
UPDATE systempreferences SET version="16.12.00.010", display_choices="Don't enable|Enable" WHERE variable="OverDriveCirculation"; |
43 |
UPDATE systempreferences SET version="16.12.00.012" WHERE variable="OpacNewsLibrarySelect"; |
44 |
UPDATE systempreferences SET version="16.12.00.012", display_choices="Don't display|Display" WHERE variable="OpacNewsLibrarySelect"; |
44 |
UPDATE systempreferences SET version="16.12.00.013" WHERE variable="CircSidebar"; |
45 |
UPDATE systempreferences SET version="16.12.00.013", display_choices="Deactivate|Activate" WHERE variable="CircSidebar"; |
45 |
UPDATE systempreferences SET version="16.12.00.014" WHERE variable="LoadSearchHistoryToTheFirstLoggedUser"; |
46 |
UPDATE systempreferences SET version="16.12.00.014", display_choices="Don't load|Load" WHERE variable="LoadSearchHistoryToTheFirstLoggedUser"; |
46 |
UPDATE systempreferences SET version="16.12.00.015" WHERE variable="UsageStatsGeolocation"; |
47 |
UPDATE systempreferences SET version="16.12.00.015" WHERE variable="UsageStatsGeolocation"; |
47 |
UPDATE systempreferences SET version="16.12.00.015" WHERE variable="UsageStatsLibrariesInfo"; |
48 |
UPDATE systempreferences SET version="16.12.00.015", display_choices="Do not Share|Share" WHERE variable="UsageStatsLibrariesInfo"; |
48 |
UPDATE systempreferences SET version="16.12.00.015" WHERE variable="UsageStatsPublicID"; |
49 |
UPDATE systempreferences SET version="16.12.00.015" WHERE variable="UsageStatsPublicID"; |
49 |
UPDATE systempreferences SET version="16.12.00.017" WHERE variable="CumulativeRestrictionPeriods"; |
50 |
UPDATE systempreferences SET version="16.12.00.017", display_choices="Don't cumulate|Cumulate" WHERE variable="CumulativeRestrictionPeriods"; |
50 |
UPDATE systempreferences SET version="16.12.00.020" WHERE variable="HoldFeeMode"; |
51 |
UPDATE systempreferences SET version="16.12.00.020", display_choices="any time a hold is placed.|only if all items are checked out and the record has at least one hold already.|any time a hold is collected." WHERE variable="HoldFeeMode"; |
51 |
UPDATE systempreferences SET version="16.12.00.021" WHERE variable="RenewalLog"; |
52 |
UPDATE systempreferences SET version="16.12.00.021", display_choices="Don't log|Log" WHERE variable="RenewalLog"; |
52 |
UPDATE systempreferences SET version="16.12.00.023" WHERE variable="AuthorityMergeLimit"; |
53 |
UPDATE systempreferences SET version="16.12.00.023" WHERE variable="AuthorityMergeLimit"; |
53 |
UPDATE systempreferences SET version="16.12.00.024" WHERE variable="OverdueNoticeBcc"; |
54 |
UPDATE systempreferences SET version="16.12.00.024" WHERE variable="OverdueNoticeBcc"; |
|
|
55 |
UPDATE systempreferences SET version="16.12.00.024" WHERE variable="NoticeBcc"; |
54 |
UPDATE systempreferences SET version="16.12.00.025" WHERE variable="UploadPurgeTemporaryFilesDays"; |
56 |
UPDATE systempreferences SET version="16.12.00.025" WHERE variable="UploadPurgeTemporaryFilesDays"; |
55 |
UPDATE systempreferences SET version="16.12.00.028" WHERE variable="AddressFormat"; |
57 |
UPDATE systempreferences SET version="16.12.00.028", display_choices="Germany style ([Address][Street number] - [ZIP/Postal Code] - [Country])|French style ([Street number][Address] - [ZIP/Postal COde][City] - [Country])|US style ([Street number], [Address] - [City], [ ZIP/Postal Code], [Country})" WHERE variable="AddressFormat"; |
56 |
UPDATE systempreferences SET version="16.12.00.029" WHERE variable="AllowCheckoutNotes"; |
58 |
UPDATE systempreferences SET version="16.12.00.029", display_choices="Don't allow|Allow" WHERE variable="AllowCheckoutNotes"; |
57 |
UPDATE systempreferences SET version="16.12.00.032" WHERE variable="ExcludeHolidaysFromMaxPickUpDelay"; |
59 |
UPDATE systempreferences SET version="16.12.00.032", display_choices="Don't allow|Allow" WHERE variable="ExcludeHolidaysFromMaxPickUpDelay"; |
58 |
UPDATE systempreferences SET version="16.12.00.033" WHERE variable="TranslateNotices"; |
60 |
UPDATE systempreferences SET version="16.12.00.033", display_choices="Don't allow|Allow" WHERE variable="TranslateNotices"; |
59 |
UPDATE systempreferences SET version="16.12.00.034" WHERE variable="OPACFineNoRenewalsBlockAutoRenew"; |
61 |
UPDATE systempreferences SET version="16.12.00.034", display_choices="Block|Allow" WHERE variable="OPACFineNoRenewalsBlockAutoRenew"; |
60 |
UPDATE systempreferences SET version="16.12.00.036" WHERE variable="NumSavedReports"; |
62 |
UPDATE systempreferences SET version="16.12.00.036" WHERE variable="NumSavedReports"; |
61 |
UPDATE systempreferences SET version="16.12.00.037" WHERE variable="FailedLoginAttempts"; |
63 |
UPDATE systempreferences SET version="16.12.00.037" WHERE variable="FailedLoginAttempts"; |
62 |
UPDATE systempreferences SET version="16.12.00.038" WHERE variable="ExportRemoveFields"; |
64 |
UPDATE systempreferences SET version="16.12.00.038" WHERE variable="ExportRemoveFields"; |
63 |
UPDATE systempreferences SET version="16.12.00.039" WHERE variable="TalkingTechItivaPhoneNotification"; |
65 |
UPDATE systempreferences SET version="16.12.00.039", display_choices="Disable|Enable" WHERE variable="TalkingTechItivaPhoneNotification"; |
64 |
|
66 |
|
65 |
|
67 |
|
66 |
|
68 |
|