-# the other hash contains other actions that can't be done elsewhere. they are done
-# either BEFORE of AFTER everything else, depending on "when" entry (default => AFTER)
-
-# The tabledata hash contains data that should be in the tables.
-# The uniquefieldrequired hash entry is used to determine which (if any) fields
-# must not exist in the table for this row to be inserted. If the
-# uniquefieldrequired entry is already in the table, the existing data is not
-# modified, unless the forceupdate hash entry is also set. Fields in the
-# anonymous "forceupdate" hash will be forced to be updated to the default
-# values given in the %tabledata hash.
-
-my %tabledata = (
-# tablename => [
-# { uniquefielrequired => 'fieldname', # the primary key in the table
-# fieldname => fieldvalue,
-# fieldname2 => fieldvalue2,
-# },
-# ],
- systempreferences => [
- {
- uniquefieldrequired => 'variable',
- variable => 'useDaysMode',
- value => 'Calendar',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'How to calculate return dates : Calendar means holidays will be controled, Days means the return date don\'t depend on holidays',
- type => 'Choice',
- options => 'Calendar|Days'
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'BorrowersTitles',
- value => 'Mr|Mrs|Miss|Ms',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'List all Titles for borrowers',
- type => 'free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'BorrowerMandatoryField',
- value => 'cardnumber|surname|address',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'List all mandatory fields for borrowers',
- type => 'free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'borrowerRelationship',
- value => 'father|mother,grand-mother',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'The relationships between a guarantor & a guarantee (separated by | or ,)',
- type => 'free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'ReservesMaxPickUpDelay',
- value => '10',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Maximum delay to pick up a reserved document',
- type => 'free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'TransfersMaxDaysWarning',
- value => '3',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Max delay before considering the transfer has potentialy a problem',
- type => 'free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'memberofinstitution',
- value => '0',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Are your patrons members of institutions',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'ReadingHistory',
- value => '0',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Allow reading record info retrievable from issues and oldissues tables',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'IssuingInProcess',
- value => '0',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Allow no debt alert if the patron is issuing item that accumulate debt',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'AutomaticItemReturn',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'This Variable allow or not to return automaticly to his homebranch',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'reviewson',
- value => '0',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Allows patrons to submit reviews from the opac',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'intranet_includes',
- value => 'includes',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'The includes directory you want for specific look of Koha (includes or includes_npl for example)',
- type => 'Free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'AutoLocation',
- value => '0',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'switch to activate or not Autolocation, if Yes, the Librarian can\'t change his location, it\'s defined by branchip',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'serialsadditems',
- value => '0',
- forceupdate => {
- 'explanation' => 1,
- 'type' => 1
- },
- explanation => 'If set, a new item will be automatically added when receiving an issue',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'expandedSearchOption',
- value => '0',
- forceupdate => {
- 'explanation' => 1,
- 'type' => 1
- },
- explanation => 'search among marc field',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'RequestOnOpac',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'option to allow reserves on opac',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'OpacCloud',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Enable / Disable cloud link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl on the server)',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'OpacBrowser',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Enable/Disable browser link on OPAC (Require to run misc/cronjobs/build_browser_and_cloud.pl on the server)',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'OpacTopissue',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Enable / Disable the top issue link on OPAC',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'OpacAuthorities',
- value => '1',
- forceupdate => { 'explanation' => 1,
- 'type' => 1},
- explanation => 'Enable / Disable the search authority link on OPAC',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'CataloguingLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log cataloguing action.',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'BorrowersLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log borrowers edition/creation/deletion...',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'SubscriptionLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log Subscription action',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'IssueLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log issue.',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'ReturnLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log the circulation return',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'Version',
- value => '3.0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Koha Version',
- type => 'Free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'LetterLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log all the letter sent',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'FinesLog',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want to log fines',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'NoZebra',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => 'Active this if you want NOT to use zebra (large libraries should avoid this parameters)',
- type => 'YesNo',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'NoZebraIndexes',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => "Enter a specific hash for NoZebra indexes. Enter : 'indexname' => '100a,245a,500*','index2' => '...'",
- type => 'Free',
- },
- {
- uniquefieldrequired => 'variable',
- variable => 'uppercasesurnames',
- value => '0',
- forceupdate => {'explanation' => 1, 'type' => 1},
- explanation => "Force Surnames to be uppercase",
- type => 'YesNo',
- },
- ],
- userflags => [
- {
- uniquefieldrequired => 'bit',
- bit => '14',
- flag => 'editauthorities',
- flagdesc => 'allow to edit authorities',
- defaulton => '0',
- },
- {
- uniquefieldrequired => 'bit',
- bit => '15',
- flag => 'serials',
- flagdesc => 'allow to manage serials subscriptions',
- defaulton => '0',
- },
- {
- uniquefieldrequired => 'bit',
- bit => '16',
- flag => 'reports',
- flagdesc => 'allow to access to the reports module',
- defaulton => '0',
- },
- ],
- authorised_values => [
- {
- uniquefieldrequired => 'id',
- category => 'SUGGEST',
- authorised_value => 'Not enough budget',
- lib => 'This book it too much expensive',
- }
- ],
-);
-
-my %fielddefinitions = (
-# fieldname => [
-# { field => 'fieldname',
-# type => 'fieldtype',
-# null => '',
-# key => '',
-# default => ''
-# },
-# ],
- aqbasket => [
- {
- field => 'booksellerid',
- type => 'int(11)',
- null => 'NOT NULL',
- key => '',
- default => '1',
- extra => '',
- },
- ],
- aqbooksellers => [
- {
- field => 'id',
- type => 'int(11)',
- null => 'NOT NULL',
- key => 'PRI',
- default => '',
- extra => 'auto_increment',
- },
- {
- field => 'listprice',
- type => 'varchar(10)',
- null => 'NULL',
- key => '',
- default => '',
- extra => '',
- },
- {
- field => 'invoiceprice',
- type => 'varchar(10)',
- null => 'NULL',
- key => '',
- default => '',
- extra => '',
- },
- ],