[Koha-cvs] koha/misc/sql-datas/en/mandatory 05_sysprefs.sq... [rel_3_0]

[Ryan Higgins]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_3_0
Changes by:     Ryan Higgins <rych>     07/03/06 15:50:14

Added files:
        misc/sql-datas/en/mandatory: 05_sysprefs.sql 05_sysprefs.txt 
                                     06_userflags.sql 06_userflags.txt 

Log message:
        

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/05_sysprefs.sql?cvsroot=koha&only_with_tag=rel_3_0&rev=1.1.2.1
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/05_sysprefs.txt?cvsroot=koha&only_with_tag=rel_3_0&rev=1.1.2.1
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/06_userflags.sql?cvsroot=koha&only_with_tag=rel_3_0&rev=1.1.2.1
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/06_userflags.txt?cvsroot=koha&only_with_tag=rel_3_0&rev=1.1.2.1

Patches:
Index: 05_sysprefs.sql
===================================================================
RCS file: 05_sysprefs.sql
diff -N 05_sysprefs.sql
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ 05_sysprefs.sql     6 Mar 2007 15:50:14 -0000       1.1.2.1
@@ -0,0 +1,100 @@
+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 
}|<br/><br/>\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|<br/><br/>|{ 5003 }{ 500a }|\r\n#501|<br/><br/>|{ 501a 
}|\r\n#502|<br/><br/>|{ 502a }|\r\n#504|<br/><br/>|{ 504a 
}|\r\n#505|<br/><br/>|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u 
}|\r\n#506|<br/><br/>|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u 
}|\r\n#507|<br/><br/>|{ 507a }{ 507b }|\r\n#508|<br/><br/>|{ 508a }{ 508a 
}|\r\n#510|<br/><br/>|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b 
}|\r\n#511|<br/><br/>|{ 511a }|\r\n#513|<br/><br/>|{ 513a }{513b 
}|\r\n#514|<br/><br/>|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 
514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|<br/><br/>|{ 
515a }|\r\n#516|<br/><br/>|{ 516a }|\r\n#518|<br/><br/>|{ 5183 }{ 518a 
}|\r\n#520|<br/><br/>|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|<br/><br/>|{ 
5213 }{ 521a }{ 521b }|\r\n#522|<br/><br/>|{ 522a }|\r\n#524|<br/><br/>|{ 524a 
}|\r\n#525|<br/><br/>|{ 525a }|\r\n#526|<br/><br/>|{\\n510i }{\\n510a }{ 510b 
}{ 510c }{ 510d }{\\n510x }|\r\n#530|<br/><br/>|{\\n5063 }{\\n506a }{ 506b }{ 
506c }{ 506d }{\\n506u }|\r\n#533|<br/><br/>|{\\n5333 }{\\n533a }{\\n533b 
}{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n 
}|\r\n#534|<br/><br/>|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d 
}{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z 
}|\r\n#535|<br/><br/>|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d 
}|\r\n#538|<br/><br/>|{\\n5383 }{\\n538a }{\\n538i }{\\n538u 
}|\r\n#540|<br/><br/>|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u 
}|\r\n#544|<br/><br/>|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d 
}{\\n544e }{\\n544n }|\r\n#545|<br/><br/>|{\\n545a }{ 545b }{\\n545u 
}|\r\n#546|<br/><br/>|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|<br/><br/>|{\\n547a 
}|\r\n#550|<br/><br/>|{ 550a }|\r\n#552|<br/><br/>|{ 552z }{ 552a }{ 552b }{ 
552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 
552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|<br/><br/>|{ 5553 }{ 555a }{ 
555b }{ 555c }{ 555d }{ 555u }|\r\n#556|<br/><br/>|{ 556a }{ 506z 
}|\r\n#563|<br/><br/>|{ 5633 }{ 563a }{ 563u }|\r\n#565|<br/><br/>|{ 5653 }{ 
565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|<br/><br/>|{ 567a 
}|\r\n#580|<br/><br/>|{ 580a }|\r\n#581|<br/><br/>|{ 5633 }{ 581a }{ 581z 
}|\r\n#584|<br/><br/>|{ 5843 }{ 584a }{ 584b }|\r\n#585|<br/><br/>|{ 5853 }{ 
585a }|\r\n#586|<br/><br/>|{ 5863 }{ 586a }|\r\n#020|<br/><br/><label>ISBN: 
</label>|{ 020a }{ 020c }|\r\n#022|<br/><br/><label>ISSN: </label>|{ 022a 
}|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b 
}|\r\n#024|<br/><br/><label>Standard No.: </label>|{ 024a }{ 024c }{ 024d }{ 
0242 }|\r\n#027|<br/><br/><label>Standard Tech. Report. No.: </label>|{ 027a 
}|\r\n#028|<br/><br/><label>Publisher. No.: </label>|{ 028a }{ 028b 
}|\r\n#013|<br/><br/><label>Patent No.: </label>|{ 013a }{ 013b }{ 013c }{ 013d 
}{ 013e }{ 013f }|\r\n#030|<br/><br/><label>CODEN: </label>|{ 030a 
}|\r\n#037|<br/><br/><label>Source: </label>|{ 037a }{ 037b }{ 037c }{ 037f }{ 
037g }{ 037n }|\r\n#010|<br/><br/><label>LCCN: </label>|{ 010a 
}|\r\n#015|<br/><br/><label>Nat. Bib. No.: </label>|{ 015a }{ 0152 
}|\r\n#016|<br/><br/><label>Nat. Bib. Agency Control No.: </label>|{ 016a }{ 
0162 }|\r\n#600|<br/><br/><label>Subjects--Personal Names: </label>|{\\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|<br/><br/><label>Subjects--Corporate 
Names: </label>|{\\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|<br/><br/><label>Subjects--Meeting 
Names: </label>|{\\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|<br/><br/><label>Subjects--Uniform 
Titles: </label>|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 
630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t 
}{--630x}{--630z}{--630y}{--630v}|\r\n#648|<br/><br/><label>Subjects--Chronological
 Terms: </label>|{\\n6483 }{\\n648a 
}{--648x}{--648z}{--648y}{--648v}|\r\n#650|<br/><br/><label>Subjects--Topical 
Terms: </label>|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e 
}{--650x}{--650z}{--650y}{--650v}|\r\n#651|<br/><br/><label>Subjects--Geographic
 Terms: </label>|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e 
}{--651x}{--651z}{--651y}{--651v}|\r\n#653|<br/><br/><label>Subjects--Index 
Terms: </label>|{ 653a }|\r\n#654|<br/><br/><label>Subjects--Facted Index 
Terms: </label>|{\\n6543 
}{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|<br/><br/><label>Index
 Terms--Genre/Form: </label>|{\\n6553 }{\\n655a}{--655b}{--655x 
}{--655z}{--655y}{--655v}|\r\n#656|<br/><br/><label>Index Terms--Occupation: 
</label>|{\\n6563 
}{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|<br/><br/><label>Index
 Terms--Function: </label>|{\\n6573 
}{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|<br/><br/><label>Index 
Terms--Curriculum Objective: 
</label>|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|<br/><br/><label>LC 
Class. No.: </label>|{ 050a }{ / 050b }|\r\n#082|<br/><br/><label>Dewey Class. 
No.: </label>|{ 082a }{ / 082b }|\r\n#080|<br/><br/><label>Universal Decimal 
Class. No.: </label>|{ 080a }{ 080x }{ / 080b 
}|\r\n#070|<br/><br/><label>National Agricultural Library Call No.: </label>|{ 
070a }{ / 070b }|\r\n#060|<br/><br/><label>National Library of Medicine Call 
No.: </label>|{ 060a }{ / 060b }|\r\n#074|<br/><br/><label>GPO Item No.: 
</label>|{ 074a }|\r\n#086|<br/><br/><label>Gov. Doc. Class. No.: </label>|{ 
086a }|\r\n#088|<br/><br/><label>Report. No.: </label>|{ 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','address@hidden','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<hr>','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');

Index: 05_sysprefs.txt
===================================================================
RCS file: 05_sysprefs.txt
diff -N 05_sysprefs.txt
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ 05_sysprefs.txt     6 Mar 2007 15:50:14 -0000       1.1.2.1
@@ -0,0 +1 @@
+Default Koha system preferences 

Index: 06_userflags.sql
===================================================================
RCS file: 06_userflags.sql
diff -N 06_userflags.sql
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ 06_userflags.sql    6 Mar 2007 15:50:14 -0000       1.1.2.1
@@ -0,0 +1,17 @@
+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);

Index: 06_userflags.txt
===================================================================
RCS file: 06_userflags.txt
diff -N 06_userflags.txt
--- /dev/null   1 Jan 1970 00:00:00 -0000
+++ 06_userflags.txt    6 Mar 2007 15:50:14 -0000       1.1.2.1
@@ -0,0 +1 @@
+Default user permissions flags