From 666004bf0a5ca2fabccf31a1c4fa4a7bd8138e5c Mon Sep 17 00:00:00 2001 From: rych Date: Fri, 9 Mar 2007 22:03:13 +0000 Subject: [PATCH] per row inserts --- misc/sql-datas/en/mandatory/05_sysprefs.sql | 199 +++++++++---------- misc/sql-datas/en/mandatory/06_userflags.sql | 33 ++- 2 files changed, 115 insertions(+), 117 deletions(-) diff --git a/misc/sql-datas/en/mandatory/05_sysprefs.sql b/misc/sql-datas/en/mandatory/05_sysprefs.sql index a2d3819c57..db9a320ca1 100644 --- a/misc/sql-datas/en/mandatory/05_sysprefs.sql +++ b/misc/sql-datas/en/mandatory/05_sysprefs.sql @@ -1,100 +1,99 @@ -INSERT INTO `systempreferences` VALUES - ('acquisitions','normal','Normal, budget-based acquisitions, or Simple bibliographic-data acquisitions','simple|normal','Choice'), - ('advancedMARCeditor','0','If set, the MARC editor won\'t show you tag/subfields description','','YesNo'), - ('AmazonAssocTag','','see: associates.amazon.com/gp/flex/associates/apply-login.html','','free'), - ('AmazonContent','0','Turn On Amazon Content - You MUST set AmazonDevKey and AmazonAssocTag if enabled','','YesNo'), - ('AmazonDevKey','','see: aws-portal.amazon.com/gp/aws/developer/registration/index.html','','free'), - ('AnonSuggestions','0','Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free'), - ('authoritysep','--','the separator used in authority/thesaurus. Usually --','10','free'), - ('autoBarcode','1','Barcode is auto-calculated','','YesNo'), - ('AutoLocation','0','switch to activate or not Autolocation, if Yes, the Librarian can\'t change his location, it\'s defined by branchip',NULL,'YesNo'), - ('AutomaticItemReturn','1','This Variable allow or not to return automaticly to his homebranch',NULL,'YesNo'), - ('autoMemberNum','1','Member number is auto-calculated','','YesNo'), - ('BiblioDefaultView','normal','Define the default view of a biblio. Can be either normal, marc or isbd','normal|marc|isbd','Choice'), - ('BorrowerMandatoryField','zipcode|surname','List all mandatory fields for borrowers',NULL,'free'), - ('borrowerRelationship','father|mother','The relationships between a guarantor & a guarantee (separated by | or ,)','','free'), - ('BorrowersLog','0','Active this if you want to log borrowers edition/creation/deletion...',NULL,'YesNo'), - ('BorrowersTitles','Mr|Mrs|Miss|Ms','List all Titles for borrowers',NULL,'free'), - ('CataloguingLog','0','Active this if you want to log cataloguing action.',NULL,'YesNo'), - ('checkdigit','none','Validity checks on membership number: none or \"Katipo\" style checks','none|katipo','Choice'), - ('dateformat','us','date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy/mm/dd)','metric|us|iso','Choice'), - ('delimiter',';','Define the default separator character for report exportations into files',';|tabulation|,|/|\\|#','Choice'), - ('Disable_Dictionary','1','Disables Dictionary buttons if set to yes','','YesNo'), - ('expandedSearchOption','0','search among marc field',NULL,'YesNo'), - ('FinesLog','0','Active this if you want to log fines',NULL,'YesNo'), - ('gist','0','the gist rate. NOT in %, but in numeric form (0.12 for 12%)','','free'), - ('hidelostitems','0','show or hide \"lost\" items in OPAC.','','YesNo'), - ('hide_marc','0','hide marc specific datas like subfield code & indicators to library',NULL,'YesNo'), - ('IndependantBranches','0','Turn Branch independancy management On an Off',NULL,'YesNo'), - ('insecure','NO','If YES, no auth at all is needed. Be careful if you set this to yes!',NULL,'YesNo'), - ('IntranetBiblioDefaultView','normal','IntranetBiblioDefaultView','',''), - ('intranetcolorstylesheet','intranet.css','Enter the name of the color stylesheet to use in Intranet','','free'), - ('IntranetmainUserblock','','A user-defined block of HTML on the intranet home page','50|20','Textarea'), - ('IntranetNav','','Use HTML tabs to add navigational links to the left-hand navigational bar in Int','70|10','Textarea'), - ('intranetreadinghistory','0','Turn on or off the Reading History option in the intranet','','YesNo'), - ('intranetstylesheet','','Enter a complete URL to use an alternate layout stylesheet in Intranet',NULL,'free'), - ('intranetuserjs','function prepareEmailPopup(){\r\n if (!document.getElementById) return false;\r\n if (!document.getElementById(\'reserveemail\')) return false;\r\n rsvlink = document.getElementById(\'reserveemail\');\r\n rsvlink.onclick = function() {\r\n doReservePopup();\r\n return false;\r\n }\r\n}\r\n\r\nfunction doReservePopup(){\r\n}\r\n\r\nfunction prepareReserveList(){\r\n}\r\n\r\naddLoadEvent(prepareEmailPopup);\r\naddLoadEvent(prepareReserveList);','Custom javascript for inclusion in Intranet','50|10','Textarea'), - ('intranet_includes','includes','The includes directory you want for specific look of Koha (includes or includes_npl for example)',NULL,'Free'), - ('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|

\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|

|{ 5003 }{ 500a }|\r\n#501|

|{ 501a }|\r\n#502|

|{ 502a }|\r\n#504|

|{ 504a }|\r\n#505|

|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|

|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|

|{ 507a }{ 507b }|\r\n#508|

|{ 508a }{ 508a }|\r\n#510|

|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|

|{ 511a }|\r\n#513|

|{ 513a }{513b }|\r\n#514|

|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|

|{ 515a }|\r\n#516|

|{ 516a }|\r\n#518|

|{ 5183 }{ 518a }|\r\n#520|

|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|

|{ 5213 }{ 521a }{ 521b }|\r\n#522|

|{ 522a }|\r\n#524|

|{ 524a }|\r\n#525|

|{ 525a }|\r\n#526|

|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|

|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|

|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|

|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|

|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|

|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|

|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|

|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|

|{\\n545a }{ 545b }{\\n545u }|\r\n#546|

|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|

|{\\n547a }|\r\n#550|

|{ 550a }|\r\n#552|

|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|

|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|

|{ 556a }{ 506z }|\r\n#563|

|{ 5633 }{ 563a }{ 563u }|\r\n#565|

|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|

|{ 567a }|\r\n#580|

|{ 580a }|\r\n#581|

|{ 5633 }{ 581a }{ 581z }|\r\n#584|

|{ 5843 }{ 584a }{ 584b }|\r\n#585|

|{ 5853 }{ 585a }|\r\n#586|

|{ 5863 }{ 586a }|\r\n#020|

|{ 020a }{ 020c }|\r\n#022|

|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|

|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|

|{ 027a }|\r\n#028|

|{ 028a }{ 028b }|\r\n#013|

|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|

|{ 030a }|\r\n#037|

|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|

|{ 010a }|\r\n#015|

|{ 015a }{ 0152 }|\r\n#016|

|{ 016a }{ 0162 }|\r\n#600|

|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|

|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|

|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|

|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|

|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|

|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|

|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|

|{ 653a }|\r\n#654|

|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|

|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|

|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|

|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|

|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|

|{ 050a }{ / 050b }|\r\n#082|

|{ 082a }{ / 082b }|\r\n#080|

|{ 080a }{ 080x }{ / 080b }|\r\n#070|

|{ 070a }{ / 070b }|\r\n#060|

|{ 060a }{ / 060b }|\r\n#074|

|{ 074a }|\r\n#086|

|{ 086a }|\r\n#088|

|{ 088a }|','ISBD','80|20','Textarea'), - ('IssueLog','0','Active this if you want to log issue.',NULL,'YesNo'), - ('IssuingInProcess','0','Allow no debt alert if the patron is issuing item that accumulate debt',NULL,'YesNo'), - ('item-level_itypes','1','Item-level Itemtype / issuing rules','','YesNo'), - ('itemcallnumber','676a','The MARC field/subfield that is used to calculate the itemcallnumber (in UNIMARC',NULL,'free'), - ('KohaAdminEmailAddress','root@localhost','the email address where borrowers modifs are sent','','free'), - ('kohaspsuggest','1','Keep track of queries and suggestions in a database','',''), - ('LabelMARCView','standard','Define how a MARC record will display','standard|economical','Choice'), - ('LetterLog','0','Active this if you want to log all the letter sent',NULL,'YesNo'), - ('LibraryName','','Library name as shown on main opac page','',''), - ('marc','ON','Turn on MARC support',NULL,'YesNo'), - ('marcflavour','MARC21','your MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice'), - ('MARCOrgCode','OSt','Your MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.htm','','free'), - ('maxoutstanding','5','maximum amount withstanding to be able make reserves','','Integer'), - ('maxreserves','50','maximum number of reserves a member can make','','Integer'), - ('memberofinstitution','0','Are your patrons members of institutions',NULL,'YesNo'), - ('MIME','EXCEL','Define the default application for report exportations into files','EXCEL|OPENOFFICE.ORG','Choice'), - ('noissuescharge','5','maximum amount withstanding to be able to check out an item','','Integer'), - ('NotifyBorrowerDeparture','0','Delay before expiry where a notice is sent when issuing',NULL,'Integer'), - ('OpacAuthorities','1','Enable / Disable the search authority link on OPAC',NULL,'YesNo'), - ('opacbookbag','1','Enable or disable display of biblio basket (book bag)','','YesNo'), - ('OpacBrowser','1','Enable/Disable browser link on OPAC (needs to set misc/cronjob/build_browser.pl)',NULL,'YesNo'), - ('OpacCloud','1','Enable / Disable cloud link on OPAC',NULL,'YesNo'), - ('opaccolorstylesheet','colors.css','Enter the name of the color stylesheet to use in the OPAC','','free'), - ('opaccredits','','Put any HTML Credits at the bottom of the OPAC page','70|10','Textarea'), - ('opacheader','','Enter HTML to be included as a custom header in the OPAC','30|10','Textarea'), - ('opaclanguages','en','Set the preferred order for translations. The top language will be tried first.',NULL,'Languages'), - ('opaclanguagesdisplay','0','Turn on/off display of Change Language feature on OPAC','','YesNo'), - ('opaclargeimage','','Enter a complete URL to an image, will be on the main page, instead of the Koha',NULL,'free'), - ('opaclayoutstylesheet','opac.css','Enter the name of the layout stylesheet to use in the OPAC','','free'), - ('OpacMaintenance','0','This will give the users a nice maintenance warning if enabled','','YesNo'), - ('OpacMainUserBlock','Welcome to Koha...\r\n
','A user-defined block of HTML in the main content area of the opac main page','50|20','Textarea'), - ('OpacNav','Important links here.','Use HTML tabs to add navigational links to the left-hand navigational bar in OPA','70|10','Textarea'), - ('OpacPasswordChange','1','Enable/Disable password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo'), - ('opacreadinghistory','1','Turn on/off display of Patron Reading History in OPAC','','YesNo'), - ('opacsmallimage','','Enter a complete URL to an image, will be on top/left instead of the Koha logo','','free'), - ('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free'), - ('opacthemes','prog','Set the preferred order for themes. The top theme will be tried first.','','Themes'), - ('OpacTopissue','1','Enable / Disable the top issue link on OPAC',NULL,'YesNo'), - ('opacuserjs','','Custom javascript for inclusion in OPAC','50|20','Textarea'), - ('opacuserlogin','1','Enable or disable display of user login features',NULL,'YesNo'), - ('patronimages','0','Turn on/off display of patron images in Intranet and specify a file extension fo','','YesNo'), - ('printcirculationslips','1','if set to 1, print circulation slips. If set to 0, don\'t','','free'), - ('ReadingHistory','1','Allow reading record info retrievable from issues and oldissues tables','','YesNo'), - ('RequestOnOpac','1','option to allow reserves on opac',NULL,'YesNo'), - ('ReservesMaxPickUpDelay','7','Maximum delay to pick up a reserved document','','free'), - ('ReturnBeforeExpiry','0','If Yes, Returndate on issuing can\'t be after borrower card expiry',NULL,'YesNo'), - ('ReturnLog','0','Active this if you want to log the circulation return',NULL,'YesNo'), - ('reviewson','1','Allows patrons to submit reviews from the opac','','YesNo'), - ('serialsadditems','0','If set, a new item will be automatically added when receiving an issue',NULL,'YesNo'), - ('sortbynonfiling','no','Sort search results by MARC nonfiling characters',NULL,'YesNo'), - ('SpecifyDueDate','1','Choose whether to display \"Specify Due Date\" form in Circulation','','YesNo'), - ('SubscriptionHistory',';','Define the information level for serials history in OPAC','simplified|full','Choice'), - ('SubscriptionLog','0','Active this if you want to log Subscription action',NULL,'YesNo'), - ('suggestion','1','if set to 1, suggestions are activated in OPAC','','free'), - ('template','prog','Preference order for intranet interface templates','','Themes'), - ('TemplateEncoding','utf-8','Specify the encoding to use in Templates','iso-8859-1|utf-8','Choice'), - ('timeout','12000000','Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer'), - ('TransfersMaxDaysWarning','3','Max delay before considering the transfer has potentialy a problem',NULL,'free'), - ('useDaysMode','Calendar','How to calculate return dates : Calendar means holidays will be controled, Days means the return date don\'t depend on holidays','Calendar|Days','Choice'), - ('virtualshelves','1','Set virtual shelves management ON or OFF','','YesNo'), - ('z3950AuthorAuthFields','701,702,700','contains the MARC biblio tags of person authorities to fill biblio.author with w',NULL,'free'), - ('z3950NormalizeAuthor','0','If set, Personal Name Authorities will replace authors in biblio.author','','YesNo'); +INSERT INTO `systempreferences` VALUES('acquisitions','normal','Normal, budget-based acquisitions, or Simple bibliographic-data acquisitions','simple|normal','Choice'); +INSERT INTO `systempreferences` VALUES('advancedMARCeditor','0','If set, the MARC editor won\'t show you tag/subfields description','','YesNo'); +INSERT INTO `systempreferences` VALUES('AmazonAssocTag','','see: associates.amazon.com/gp/flex/associates/apply-login.html','','free'); +INSERT INTO `systempreferences` VALUES('AmazonContent','0','Turn On Amazon Content - You MUST set AmazonDevKey and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` VALUES('AmazonDevKey','','see: aws-portal.amazon.com/gp/aws/developer/registration/index.html','','free'); +INSERT INTO `systempreferences` VALUES('AnonSuggestions','0','Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free'); +INSERT INTO `systempreferences` VALUES('authoritysep','--','the separator used in authority/thesaurus. Usually --','10','free'); +INSERT INTO `systempreferences` VALUES('autoBarcode','1','Barcode is auto-calculated','','YesNo'); +INSERT INTO `systempreferences` VALUES('AutoLocation','0','switch to activate or not Autolocation, if Yes, the Librarian can\'t change his location, it\'s defined by branchip',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('AutomaticItemReturn','1','This Variable allow or not to return automaticly to his homebranch',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('autoMemberNum','1','Member number is auto-calculated','','YesNo'); +INSERT INTO `systempreferences` VALUES('BiblioDefaultView','normal','Define the default view of a biblio. Can be either normal, marc or isbd','normal|marc|isbd','Choice'); +INSERT INTO `systempreferences` VALUES('BorrowerMandatoryField','zipcode|surname','List all mandatory fields for borrowers',NULL,'free'); +INSERT INTO `systempreferences` VALUES('borrowerRelationship','father|mother','The relationships between a guarantor & a guarantee (separated by | or ,)','','free'); +INSERT INTO `systempreferences` VALUES('BorrowersLog','0','Active this if you want to log borrowers edition/creation/deletion...',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('BorrowersTitles','Mr|Mrs|Miss|Ms','List all Titles for borrowers',NULL,'free'); +INSERT INTO `systempreferences` VALUES('CataloguingLog','0','Active this if you want to log cataloguing action.',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('checkdigit','none','Validity checks on membership number: none or \"Katipo\" style checks','none|katipo','Choice'); +INSERT INTO `systempreferences` VALUES('dateformat','us','date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy/mm/dd)','metric|us|iso','Choice'); +INSERT INTO `systempreferences` VALUES('delimiter',';','Define the default separator character for report exportations into files',';|tabulation|,|/|\\|#','Choice'); +INSERT INTO `systempreferences` VALUES('Disable_Dictionary','1','Disables Dictionary buttons if set to yes','','YesNo'); +INSERT INTO `systempreferences` VALUES('expandedSearchOption','0','search among marc field',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('FinesLog','0','Active this if you want to log fines',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('gist','0','the gist rate. NOT in %, but in numeric form (0.12 for 12%)','','free'); +INSERT INTO `systempreferences` VALUES('hidelostitems','0','show or hide \"lost\" items in OPAC.','','YesNo'); +INSERT INTO `systempreferences` VALUES('hide_marc','0','hide marc specific datas like subfield code & indicators to library',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('IndependantBranches','0','Turn Branch independancy management On an Off',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('insecure','NO','If YES, no auth at all is needed. Be careful if you set this to yes!',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('IntranetBiblioDefaultView','normal','IntranetBiblioDefaultView','',''); +INSERT INTO `systempreferences` VALUES('intranetcolorstylesheet','intranet.css','Enter the name of the color stylesheet to use in Intranet','','free'); +INSERT INTO `systempreferences` VALUES('IntranetmainUserblock','','A user-defined block of HTML on the intranet home page','50|20','Textarea'); +INSERT INTO `systempreferences` VALUES('IntranetNav','','Use HTML tabs to add navigational links to the left-hand navigational bar in Int','70|10','Textarea'); +INSERT INTO `systempreferences` VALUES('intranetreadinghistory','0','Turn on or off the Reading History option in the intranet','','YesNo'); +INSERT INTO `systempreferences` VALUES('intranetstylesheet','','Enter a complete URL to use an alternate layout stylesheet in Intranet',NULL,'free'); +INSERT INTO `systempreferences` VALUES('intranetuserjs','function prepareEmailPopup(){\r\n if (!document.getElementById) return false;\r\n if (!document.getElementById(\'reserveemail\')) return false;\r\n rsvlink = document.getElementById(\'reserveemail\');\r\n rsvlink.onclick = function() {\r\n doReservePopup();\r\n return false;\r\n }\r\n}\r\n\r\nfunction doReservePopup(){\r\n}\r\n\r\nfunction prepareReserveList(){\r\n}\r\n\r\naddLoadEvent(prepareEmailPopup);\r\naddLoadEvent(prepareReserveList);','Custom javascript for inclusion in Intranet','50|10','Textarea'); +INSERT INTO `systempreferences` VALUES('intranet_includes','includes','The includes directory you want for specific look of Koha (includes or includes_npl for example)',NULL,'Free'); +INSERT INTO `systempreferences` VALUES('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|

\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|

|{ 5003 }{ 500a }|\r\n#501|

|{ 501a }|\r\n#502|

|{ 502a }|\r\n#504|

|{ 504a }|\r\n#505|

|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|

|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|

|{ 507a }{ 507b }|\r\n#508|

|{ 508a }{ 508a }|\r\n#510|

|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|

|{ 511a }|\r\n#513|

|{ 513a }{513b }|\r\n#514|

|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|

|{ 515a }|\r\n#516|

|{ 516a }|\r\n#518|

|{ 5183 }{ 518a }|\r\n#520|

|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|

|{ 5213 }{ 521a }{ 521b }|\r\n#522|

|{ 522a }|\r\n#524|

|{ 524a }|\r\n#525|

|{ 525a }|\r\n#526|

|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|

|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|

|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|

|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|

|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|

|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|

|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|

|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|

|{\\n545a }{ 545b }{\\n545u }|\r\n#546|

|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|

|{\\n547a }|\r\n#550|

|{ 550a }|\r\n#552|

|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|

|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|

|{ 556a }{ 506z }|\r\n#563|

|{ 5633 }{ 563a }{ 563u }|\r\n#565|

|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|

|{ 567a }|\r\n#580|

|{ 580a }|\r\n#581|

|{ 5633 }{ 581a }{ 581z }|\r\n#584|

|{ 5843 }{ 584a }{ 584b }|\r\n#585|

|{ 5853 }{ 585a }|\r\n#586|

|{ 5863 }{ 586a }|\r\n#020|

|{ 020a }{ 020c }|\r\n#022|

|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|

|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|

|{ 027a }|\r\n#028|

|{ 028a }{ 028b }|\r\n#013|

|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|

|{ 030a }|\r\n#037|

|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|

|{ 010a }|\r\n#015|

|{ 015a }{ 0152 }|\r\n#016|

|{ 016a }{ 0162 }|\r\n#600|

|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|

|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|

|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|

|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|

|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|

|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|

|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|

|{ 653a }|\r\n#654|

|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|

|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|

|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|

|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|

|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|

|{ 050a }{ / 050b }|\r\n#082|

|{ 082a }{ / 082b }|\r\n#080|

|{ 080a }{ 080x }{ / 080b }|\r\n#070|

|{ 070a }{ / 070b }|\r\n#060|

|{ 060a }{ / 060b }|\r\n#074|

|{ 074a }|\r\n#086|

|{ 086a }|\r\n#088|

|{ 088a }|','ISBD','80|20','Textarea'); +INSERT INTO `systempreferences` VALUES('IssueLog','0','Active this if you want to log issue.',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('IssuingInProcess','0','Allow no debt alert if the patron is issuing item that accumulate debt',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('item-level_itypes','1','Item-level Itemtype / issuing rules','','YesNo'); +INSERT INTO `systempreferences` VALUES('itemcallnumber','676a','The MARC field/subfield that is used to calculate the itemcallnumber (in UNIMARC',NULL,'free'); +INSERT INTO `systempreferences` VALUES('KohaAdminEmailAddress','root@localhost','the email address where borrowers modifs are sent','','free'); +INSERT INTO `systempreferences` VALUES('kohaspsuggest','1','Keep track of queries and suggestions in a database','',''); +INSERT INTO `systempreferences` VALUES('LabelMARCView','standard','Define how a MARC record will display','standard|economical','Choice'); +INSERT INTO `systempreferences` VALUES('LetterLog','0','Active this if you want to log all the letter sent',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('LibraryName','','Library name as shown on main opac page','',''); +INSERT INTO `systempreferences` VALUES('marc','ON','Turn on MARC support',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('marcflavour','MARC21','your MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice'); +INSERT INTO `systempreferences` VALUES('MARCOrgCode','OSt','Your MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.htm','','free'); +INSERT INTO `systempreferences` VALUES('maxoutstanding','5','maximum amount withstanding to be able make reserves','','Integer'); +INSERT INTO `systempreferences` VALUES('maxreserves','50','maximum number of reserves a member can make','','Integer'); +INSERT INTO `systempreferences` VALUES('memberofinstitution','0','Are your patrons members of institutions',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('MIME','EXCEL','Define the default application for report exportations into files','EXCEL|OPENOFFICE.ORG','Choice'); +INSERT INTO `systempreferences` VALUES('noissuescharge','5','maximum amount withstanding to be able to check out an item','','Integer'); +INSERT INTO `systempreferences` VALUES('NotifyBorrowerDeparture','0','Delay before expiry where a notice is sent when issuing',NULL,'Integer'); +INSERT INTO `systempreferences` VALUES('OpacAuthorities','1','Enable / Disable the search authority link on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('opacbookbag','1','Enable or disable display of biblio basket (book bag)','','YesNo'); +INSERT INTO `systempreferences` VALUES('OpacBrowser','1','Enable/Disable browser link on OPAC (needs to set misc/cronjob/build_browser.pl)',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('OpacCloud','1','Enable / Disable cloud link on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('opaccolorstylesheet','colors.css','Enter the name of the color stylesheet to use in the OPAC','','free'); +INSERT INTO `systempreferences` VALUES('opaccredits','','Put any HTML Credits at the bottom of the OPAC page','70|10','Textarea'); +INSERT INTO `systempreferences` VALUES('opacheader','','Enter HTML to be included as a custom header in the OPAC','30|10','Textarea'); +INSERT INTO `systempreferences` VALUES('opaclanguages','en','Set the preferred order for translations. The top language will be tried first.',NULL,'Languages'); +INSERT INTO `systempreferences` VALUES('opaclanguagesdisplay','0','Turn on/off display of Change Language feature on OPAC','','YesNo'); +INSERT INTO `systempreferences` VALUES('opaclargeimage','','Enter a complete URL to an image, will be on the main page, instead of the Koha',NULL,'free'); +INSERT INTO `systempreferences` VALUES('opaclayoutstylesheet','opac.css','Enter the name of the layout stylesheet to use in the OPAC','','free'); +INSERT INTO `systempreferences` VALUES('OpacMaintenance','0','This will give the users a nice maintenance warning if enabled','','YesNo'); +INSERT INTO `systempreferences` VALUES('OpacMainUserBlock','Welcome to Koha...\r\n
','A user-defined block of HTML in the main content area of the opac main page','50|20','Textarea'); +INSERT INTO `systempreferences` VALUES('OpacNav','Important links here.','Use HTML tabs to add navigational links to the left-hand navigational bar in OPA','70|10','Textarea'); +INSERT INTO `systempreferences` VALUES('OpacPasswordChange','1','Enable/Disable password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('opacreadinghistory','1','Turn on/off display of Patron Reading History in OPAC','','YesNo'); +INSERT INTO `systempreferences` VALUES('opacsmallimage','','Enter a complete URL to an image, will be on top/left instead of the Koha logo','','free'); +INSERT INTO `systempreferences` VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free'); +INSERT INTO `systempreferences` VALUES('opacthemes','prog','Set the preferred order for themes. The top theme will be tried first.','','Themes'); +INSERT INTO `systempreferences` VALUES('OpacTopissue','1','Enable / Disable the top issue link on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('opacuserjs','','Custom javascript for inclusion in OPAC','50|20','Textarea'); +INSERT INTO `systempreferences` VALUES('opacuserlogin','1','Enable or disable display of user login features',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('patronimages','0','Turn on/off display of patron images in Intranet and specify a file extension fo','','YesNo'); +INSERT INTO `systempreferences` VALUES('printcirculationslips','1','if set to 1, print circulation slips. If set to 0, don\'t','','free'); +INSERT INTO `systempreferences` VALUES('ReadingHistory','1','Allow reading record info retrievable from issues and oldissues tables','','YesNo'); +INSERT INTO `systempreferences` VALUES('RequestOnOpac','1','option to allow reserves on opac',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('ReservesMaxPickUpDelay','7','Maximum delay to pick up a reserved document','','free'); +INSERT INTO `systempreferences` VALUES('ReturnBeforeExpiry','0','If Yes, Returndate on issuing can\'t be after borrower card expiry',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('ReturnLog','0','Active this if you want to log the circulation return',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('reviewson','1','Allows patrons to submit reviews from the opac','','YesNo'); +INSERT INTO `systempreferences` VALUES('serialsadditems','0','If set, a new item will be automatically added when receiving an issue',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('sortbynonfiling','no','Sort search results by MARC nonfiling characters',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('SpecifyDueDate','1','Choose whether to display \"Specify Due Date\" form in Circulation','','YesNo'); +INSERT INTO `systempreferences` VALUES('SubscriptionHistory',';','Define the information level for serials history in OPAC','simplified|full','Choice'); +INSERT INTO `systempreferences` VALUES('SubscriptionLog','0','Active this if you want to log Subscription action',NULL,'YesNo'); +INSERT INTO `systempreferences` VALUES('suggestion','1','if set to 1, suggestions are activated in OPAC','','free'); +INSERT INTO `systempreferences` VALUES('template','prog','Preference order for intranet interface templates','','Themes'); +INSERT INTO `systempreferences` VALUES('TemplateEncoding','utf-8','Specify the encoding to use in Templates','iso-8859-1|utf-8','Choice'); +INSERT INTO `systempreferences` VALUES('timeout','12000000','Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer'); +INSERT INTO `systempreferences` VALUES('TransfersMaxDaysWarning','3','Max delay before considering the transfer has potentialy a problem',NULL,'free'); +INSERT INTO `systempreferences` VALUES('useDaysMode','Calendar','How to calculate return dates : Calendar means holidays will be controled, Days means the return date don\'t depend on holidays','Calendar|Days','Choice'); +INSERT INTO `systempreferences` VALUES('virtualshelves','1','Set virtual shelves management ON or OFF','','YesNo'); +INSERT INTO `systempreferences` VALUES('z3950AuthorAuthFields','701,702,700','contains the MARC biblio tags of person authorities to fill biblio.author with w',NULL,'free'); +INSERT INTO `systempreferences` VALUES('z3950NormalizeAuthor','0','If set, Personal Name Authorities will replace authors in biblio.author','','YesNo'); diff --git a/misc/sql-datas/en/mandatory/06_userflags.sql b/misc/sql-datas/en/mandatory/06_userflags.sql index 275eae89f3..2cbcd11c89 100644 --- a/misc/sql-datas/en/mandatory/06_userflags.sql +++ b/misc/sql-datas/en/mandatory/06_userflags.sql @@ -1,17 +1,16 @@ -INSERT INTO `userflags` VALUES - (0,'superlibrarian','Access to all librarian functions',0), - (1,'circulate','Circulate books',0), - (2,'catalogue','View Catalogue (Librarian Interface)',0), - (3,'parameters','Set Koha system paramters',0), - (4,'borrowers','Add or modify borrowers',0), - (5,'permissions','Set user permissions',0), - (6,'reserveforothers','Reserve books for patrons',0), - (7,'borrow','Borrow books',1), - (9,'editcatalogue','Edit Catalogue (Modify bibliographic/holdings data)',0), - (10,'updatecharges','Update borrower charges',0), - (11,'acquisition','Acquisition and/or suggestion management',0), - (12,'management','Set library management parameters',0), - (13,'tools','Use tools (export, import, barcodes)',0), - (14,'editauthorities','allow to edit authorities',0), - (15,'serials','allow to manage serials subscriptions',0), - (16,'reports','allow to access to the reports module',0); +INSERT INTO `systempreferences` VALUES(0,'superlibrarian','Access to all librarian functions',0); +INSERT INTO `systempreferences` VALUES(1,'circulate','Circulate books',0); +INSERT INTO `systempreferences` VALUES(2,'catalogue','View Catalogue (Librarian Interface)',0); +INSERT INTO `systempreferences` VALUES(3,'parameters','Set Koha system paramters',0); +INSERT INTO `systempreferences` VALUES(4,'borrowers','Add or modify borrowers',0); +INSERT INTO `systempreferences` VALUES(5,'permissions','Set user permissions',0); +INSERT INTO `systempreferences` VALUES(6,'reserveforothers','Reserve books for patrons',0); +INSERT INTO `systempreferences` VALUES(7,'borrow','Borrow books',1); +INSERT INTO `systempreferences` VALUES(9,'editcatalogue','Edit Catalogue (Modify bibliographic/holdings data)',0); +INSERT INTO `systempreferences` VALUES(10,'updatecharges','Update borrower charges',0); +INSERT INTO `systempreferences` VALUES(11,'acquisition','Acquisition and/or suggestion management',0); +INSERT INTO `systempreferences` VALUES(12,'management','Set library management parameters',0); +INSERT INTO `systempreferences` VALUES(13,'tools','Use tools (export, import, barcodes)',0); +INSERT INTO `systempreferences` VALUES(14,'editauthorities','allow to edit authorities',0); +INSERT INTO `systempreferences` VALUES(15,'serials','allow to manage serials subscriptions',0); +INSERT INTO `systempreferences` VALUES(16,'reports','allow to access to the reports module',0); -- 2.20.1