config.default.php 61 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865
  1. <?php
  2. /* vim: set expandtab sw=4 ts=4 sts=4: */
  3. /**
  4. * <code>
  5. * N N OOO !! DDDD OOO N N OOO TTTTT EEEE DDDD I TTTTT !!
  6. * NN N O O !! D D O O NN N O O T E D D I T !!
  7. * N N N O O !! D D O O N N N O O T EEEE D D I T !!
  8. * N NN O O D D O O N NN O O T E D D I T
  9. * N N OOO !! DDDD OOO N N OOO T EEEE DDDD I T !!
  10. * </code>
  11. *
  12. * DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!!
  13. *
  14. * phpMyAdmin default configuration, you can copy values from here to your
  15. * config.inc.php
  16. *
  17. * All directives are explained in the documentation
  18. *
  19. * @package PhpMyAdmin
  20. */
  21. /**
  22. * Your phpMyAdmin URL.
  23. *
  24. * Complete the variable below with the full URL ie
  25. * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  26. *
  27. * It must contain characters that are valid for a URL, and the path is
  28. * case sensitive on some Web servers, for example Unix-based servers.
  29. *
  30. * In most cases you can leave this variable empty, as the correct value
  31. * will be detected automatically. However, we recommend that you do
  32. * test to see that the auto-detection code works in your system. A good
  33. * test is to browse a table, then edit a row and save it. There will be
  34. * an error message if phpMyAdmin cannot auto-detect the correct value.
  35. *
  36. * @global string $cfg['PmaAbsoluteUri']
  37. */
  38. $cfg['PmaAbsoluteUri'] = '';
  39. /**
  40. * Disable the default warning that is displayed on the DB Details Structure page if
  41. * any of the required Tables for the configuration storage could not be found
  42. *
  43. * @global boolean $cfg['PmaNoRelation_DisableWarning']
  44. */
  45. $cfg['PmaNoRelation_DisableWarning'] = false;
  46. /**
  47. * Disable the default warning that is displayed if Suhosin is detected
  48. *
  49. * @global boolean $cfg['SuhosinDisableWarning']
  50. */
  51. $cfg['SuhosinDisableWarning'] = false;
  52. /**
  53. * Disable the default warning that is displayed if a diffrence between
  54. * the MySQL library and server is detected.
  55. *
  56. * @global boolean $cfg['['ServerLibraryDifference_DisableWarning']']
  57. */
  58. $cfg['ServerLibraryDifference_DisableWarning'] = false;
  59. /**
  60. * Disable the default warning about MySQL reserved words in column names
  61. *
  62. * @global boolean $cfg['ReservedWordDisableWarning']
  63. */
  64. $cfg['ReservedWordDisableWarning'] = false;
  65. /**
  66. * Show warning about incomplete translations on certain threshold.
  67. *
  68. * @global boolean $cfg['TranslationWarningThreshold']
  69. */
  70. $cfg['TranslationWarningThreshold'] = 80;
  71. /**
  72. * Allows phpMyAdmin to be included from a other document in a frame;
  73. * setting this to true is a potential security hole
  74. *
  75. * @global boolean $cfg['AllowThirdPartyFraming']
  76. */
  77. $cfg['AllowThirdPartyFraming'] = false;
  78. /**
  79. * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If
  80. * at least one server configuration uses 'cookie' auth_type, enter here a
  81. * pass phrase that will be used by blowfish. The maximum length seems to be 46
  82. * characters.
  83. *
  84. * @global string $cfg['blowfish_secret']
  85. */
  86. $cfg['blowfish_secret'] = '';
  87. /*******************************************************************************
  88. * Server(s) configuration
  89. *
  90. * The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use
  91. * $cfg['Servers'][0]. You can disable a server configuration entry by setting host
  92. * to ''. If you want more than one server, just copy following section
  93. * (including $i incrementation) several times. There is no need to define
  94. * full server array, just define values you need to change.
  95. *
  96. * @global array $cfg['Servers']
  97. */
  98. $cfg['Servers'] = array();
  99. $i = 1;
  100. /**
  101. * MySQL hostname or IP address
  102. *
  103. * @global string $cfg['Servers'][$i]['host']
  104. */
  105. $cfg['Servers'][$i]['host'] = 'localhost';
  106. /**
  107. * MySQL port - leave blank for default port
  108. *
  109. * @global string $cfg['Servers'][$i]['port']
  110. */
  111. $cfg['Servers'][$i]['port'] = '';
  112. /**
  113. * Path to the socket - leave blank for default socket
  114. *
  115. * @global string $cfg['Servers'][$i]['socket']
  116. */
  117. $cfg['Servers'][$i]['socket'] = '';
  118. /**
  119. * Use SSL for connecting to MySQL server?
  120. *
  121. * @global boolean $cfg['Servers'][$i]['ssl']
  122. */
  123. $cfg['Servers'][$i]['ssl'] = false;
  124. /**
  125. * Path to the key file when using SSL for connecting to the MySQL server
  126. *
  127. * @global string $cfg['Servers'][$i]['ssl_key']
  128. */
  129. $cfg['Servers'][$i]['ssl_key'] = null;
  130. /**
  131. * Path to the cert file when using SSL for connecting to the MySQL server
  132. *
  133. * @global string $cfg['Servers'][$i]['ssl_cert']
  134. */
  135. $cfg['Servers'][$i]['ssl_cert'] = null;
  136. /**
  137. * Path to the CA file when using SSL for connecting to the MySQL server
  138. *
  139. * @global string $cfg['Servers'][$i]['ssl_ca']
  140. */
  141. $cfg['Servers'][$i]['ssl_ca'] = null;
  142. /**
  143. * Directory containing trusted SSL CA certificates in PEM format
  144. *
  145. * @global string $cfg['Servers'][$i]['ssl_ca_path']
  146. */
  147. $cfg['Servers'][$i]['ssl_ca_path'] = null;
  148. /**
  149. * List of allowable ciphers for SSL connections to the MySQL server
  150. *
  151. * @global string $cfg['Servers'][$i]['ssl_ciphers']
  152. */
  153. $cfg['Servers'][$i]['ssl_ciphers'] = null;
  154. /**
  155. * How to connect to MySQL server ('tcp' or 'socket')
  156. *
  157. * @global string $cfg['Servers'][$i]['connect_type']
  158. */
  159. $cfg['Servers'][$i]['connect_type'] = 'tcp';
  160. /**
  161. * Use compressed protocol for the MySQL connection
  162. *
  163. * @global boolean $cfg['Servers'][$i]['compress']
  164. */
  165. $cfg['Servers'][$i]['compress'] = false;
  166. /**
  167. * MySQL control host. This permits to use a host different than the
  168. * main host, for the phpMyAdmin configuration storage. If left empty,
  169. * $cfg['Servers'][$i]['host'] is used instead.
  170. *
  171. * @global string $cfg['Servers'][$i]['controlhost']
  172. */
  173. $cfg['Servers'][$i]['controlhost'] = '';
  174. /**
  175. * MySQL control port. This permits to use a port different than the
  176. * main port, for the phpMyAdmin configuration storage. If left empty,
  177. * $cfg['Servers'][$i]['port'] is used instead.
  178. *
  179. * @global string $cfg['Servers'][$i]['controlport']
  180. */
  181. $cfg['Servers'][$i]['controlport'] = '';
  182. /**
  183. * MySQL control user settings (this user must have read-only
  184. * access to the "mysql/user" and "mysql/db" tables). The controluser is also
  185. * used for all relational features (pmadb)
  186. *
  187. * @global string $cfg['Servers'][$i]['controluser']
  188. */
  189. $cfg['Servers'][$i]['controluser'] = '';
  190. /**
  191. * MySQL control user settings (this user must have read-only
  192. * access to the "mysql/user" and "mysql/db" tables). The controluser is also
  193. * used for all relational features (pmadb)
  194. *
  195. * @global string $cfg['Servers'][$i]['controlpass']
  196. */
  197. $cfg['Servers'][$i]['controlpass'] = '';
  198. /**
  199. * Authentication method (valid choices: config, http, signon or cookie)
  200. *
  201. * @global string $cfg['Servers'][$i]['auth_type']
  202. */
  203. $cfg['Servers'][$i]['auth_type'] = 'cookie';
  204. /**
  205. * HTTP Basic Auth Realm name to display (only used with 'HTTP' auth_type)
  206. *
  207. * @global string $cfg['Servers'][$i]['auth_http_realm']
  208. */
  209. $cfg['Servers'][$i]['auth_http_realm'] = '';
  210. /**
  211. * File containing Swekey ids and login names (see /contrib);
  212. * leave empty to deactivate Swekey hardware authentication
  213. *
  214. * @global string $cfg['Servers'][$i]['auth_swekey_config']
  215. */
  216. $cfg['Servers'][$i]['auth_swekey_config'] = '';
  217. /**
  218. * MySQL user
  219. *
  220. * @global string $cfg['Servers'][$i]['user']
  221. */
  222. $cfg['Servers'][$i]['user'] = 'root';
  223. /**
  224. * MySQL password (only needed with 'config' auth_type)
  225. *
  226. * @global string $cfg['Servers'][$i]['password']
  227. */
  228. $cfg['Servers'][$i]['password'] = '';
  229. /**
  230. * Session to use for 'signon' authentication method
  231. *
  232. * @global string $cfg['Servers'][$i]['SignonSession']
  233. */
  234. $cfg['Servers'][$i]['SignonSession'] = '';
  235. /**
  236. * PHP script to use for 'signon' authentication method
  237. *
  238. * @global string $cfg['Servers'][$i]['SignonScript']
  239. */
  240. $cfg['Servers'][$i]['SignonScript'] = '';
  241. /**
  242. * URL where to redirect user to login for 'signon' authentication method
  243. *
  244. * @global string $cfg['Servers'][$i]['SignonURL']
  245. */
  246. $cfg['Servers'][$i]['SignonURL'] = '';
  247. /**
  248. * URL where to redirect user after logout
  249. *
  250. * @global string $cfg['Servers'][$i]['LogoutURL']
  251. */
  252. $cfg['Servers'][$i]['LogoutURL'] = '';
  253. /**
  254. * Whether to try to connect without password
  255. *
  256. * @global boolean $cfg['Servers'][$i]['nopassword']
  257. */
  258. $cfg['Servers'][$i]['nopassword'] = false;
  259. /**
  260. * If set to a db-name, only this db is displayed in navigation panel
  261. * It may also be an array of db-names
  262. *
  263. * @global string $cfg['Servers'][$i]['only_db']
  264. */
  265. $cfg['Servers'][$i]['only_db'] = '';
  266. /**
  267. * Database name to be hidden from listings
  268. *
  269. * @global string $cfg['Servers'][$i]['hide_db']
  270. */
  271. $cfg['Servers'][$i]['hide_db'] = '';
  272. /**
  273. * Verbose name for this host - leave blank to show the hostname
  274. * (for HTTP authentication, all non-US-ASCII characters will be stripped)
  275. *
  276. * @global string $cfg['Servers'][$i]['verbose']
  277. */
  278. $cfg['Servers'][$i]['verbose'] = '';
  279. /**
  280. * Database used for Relation, Bookmark and PDF Features
  281. * (see examples/create_tables.sql)
  282. * - leave blank for no support
  283. * SUGGESTED: 'phpmyadmin'
  284. *
  285. * @global string $cfg['Servers'][$i]['pmadb']
  286. */
  287. $cfg['Servers'][$i]['pmadb'] = '';
  288. /**
  289. * Bookmark table
  290. * - leave blank for no bookmark support
  291. * SUGGESTED: 'pma__bookmark'
  292. *
  293. * @global string $cfg['Servers'][$i]['bookmarktable']
  294. */
  295. $cfg['Servers'][$i]['bookmarktable'] = '';
  296. /**
  297. * table to describe the relation between links (see doc)
  298. * - leave blank for no relation-links support
  299. * SUGGESTED: 'pma__relation'
  300. *
  301. * @global string $cfg['Servers'][$i]['relation']
  302. */
  303. $cfg['Servers'][$i]['relation'] = '';
  304. /**
  305. * table to describe the display fields
  306. * - leave blank for no display fields support
  307. * SUGGESTED: 'pma__table_info'
  308. *
  309. * @global string $cfg['Servers'][$i]['table_info']
  310. */
  311. $cfg['Servers'][$i]['table_info'] = '';
  312. /**
  313. * table to describe the tables position for the PDF schema
  314. * - leave blank for no PDF schema support
  315. * SUGGESTED: 'pma__table_coords'
  316. *
  317. * @global string $cfg['Servers'][$i]['table_coords']
  318. */
  319. $cfg['Servers'][$i]['table_coords'] = '';
  320. /**
  321. * table to describe pages of relationpdf
  322. * - leave blank if you don't want to use this
  323. * SUGGESTED: 'pma__pdf_pages'
  324. *
  325. * @global string $cfg['Servers'][$i]['pdf_pages']
  326. */
  327. $cfg['Servers'][$i]['pdf_pages'] = '';
  328. /**
  329. * table to store column information
  330. * - leave blank for no column comments/mime types
  331. * SUGGESTED: 'pma__column_info'
  332. *
  333. * @global string $cfg['Servers'][$i]['column_info']
  334. */
  335. $cfg['Servers'][$i]['column_info'] = '';
  336. /**
  337. * table to store SQL history
  338. * - leave blank for no SQL query history
  339. * SUGGESTED: 'pma__history'
  340. *
  341. * @global string $cfg['Servers'][$i]['history']
  342. */
  343. $cfg['Servers'][$i]['history'] = '';
  344. /**
  345. * table to store the coordinates for Designer
  346. * - leave blank for no Designer feature
  347. * SUGGESTED: 'pma__designer_coords'
  348. *
  349. * @global string $cfg['Servers'][$i]['designer_coords']
  350. */
  351. $cfg['Servers'][$i]['designer_coords'] = '';
  352. /**
  353. * table to store recently used tables
  354. * - leave blank for no "persistent" recently used tables
  355. * SUGGESTED: 'pma__recent'
  356. */
  357. $cfg['Servers'][$i]['recent'] = '';
  358. /**
  359. * table to store favorite tables
  360. * - leave blank for no favorite tables
  361. * SUGGESTED: 'pma__favorite'
  362. */
  363. $cfg['Servers'][$i]['favorite'] = '';
  364. /**
  365. * table to store UI preferences for tables
  366. * - leave blank for no "persistent" UI preferences
  367. * SUGGESTED: 'pma__table_uiprefs'
  368. */
  369. $cfg['Servers'][$i]['table_uiprefs'] = '';
  370. /**
  371. * table to store SQL tracking
  372. * - leave blank for no SQL tracking
  373. * SUGGESTED: 'pma__tracking'
  374. *
  375. * @global string $cfg['Servers'][$i]['tracking']
  376. */
  377. $cfg['Servers'][$i]['tracking'] = '';
  378. /**
  379. * table to store user preferences
  380. * - leave blank to disable server storage
  381. * SUGGESTED: 'pma__userconfig'
  382. *
  383. * @global string $cfg['Servers'][$i]['userconfig']
  384. */
  385. $cfg['Servers'][$i]['userconfig'] = '';
  386. /**
  387. * table to store users and their assignment to user groups
  388. * - leave blank to disable configurable menus feature
  389. * SUGGESTED: 'pma__users'
  390. *
  391. * @global string $cfg['Servers'][$i]['users']
  392. */
  393. $cfg['Servers'][$i]['users'] = '';
  394. /**
  395. * table to store allowed menu items for each user group
  396. * - leave blank to disable configurable menus feature
  397. * SUGGESTED: 'pma__usergroups'
  398. *
  399. * @global string $cfg['Servers'][$i]['usergroups']
  400. */
  401. $cfg['Servers'][$i]['usergroups'] = '';
  402. /**
  403. * table to store information about item hidden from navigation tree
  404. * - leave blank to disable hide/show navigation items feature
  405. * SUGGESTED: 'pma__navigationhiding'
  406. *
  407. * @global string $cfg['Servers'][$i]['navigationhiding']
  408. */
  409. $cfg['Servers'][$i]['navigationhiding'] = '';
  410. /**
  411. * table to store information about saved searches from query-by-example on a db
  412. * - leave blank to disable saved searches feature
  413. * SUGGESTED: 'pma__savedsearches'
  414. *
  415. * @global string $cfg['Servers'][$i]['savedsearches']
  416. */
  417. $cfg['Servers'][$i]['savedsearches'] = '';
  418. /**
  419. * Maximum number of records saved in $cfg['Servers'][$i]['table_uiprefs'] table.
  420. *
  421. * In case where tables in databases is modified (e.g. dropped or renamed),
  422. * table_uiprefs may contains invalid data (referring to tables which are not
  423. * exist anymore).
  424. * This configuration make sure that we only keep N (N = MaxTableUiprefs)
  425. * newest record in table_uiprefs and automatically delete older records.
  426. *
  427. * @global integer $cfg['Servers'][$i]['userconfig'] = '';
  428. */
  429. $cfg['Servers'][$i]['MaxTableUiprefs'] = 100;
  430. /**
  431. * whether to allow root login
  432. *
  433. * @global boolean $cfg['Servers'][$i]['AllowRoot']
  434. */
  435. $cfg['Servers'][$i]['AllowRoot'] = true;
  436. /**
  437. * whether to allow login of any user without a password
  438. *
  439. * @global boolean $cfg['Servers'][$i]['AllowNoPassword']
  440. */
  441. $cfg['Servers'][$i]['AllowNoPassword'] = false;
  442. /**
  443. * Host authentication order, leave blank to not use
  444. *
  445. * @global string $cfg['Servers'][$i]['AllowDeny']['order']
  446. */
  447. $cfg['Servers'][$i]['AllowDeny']['order'] = '';
  448. /**
  449. * Host authentication rules, leave blank for defaults
  450. *
  451. * @global array $cfg['Servers'][$i]['AllowDeny']['rules']
  452. */
  453. $cfg['Servers'][$i]['AllowDeny']['rules'] = array();
  454. /**
  455. * Whether the tracking mechanism creates
  456. * versions for tables and views automatically.
  457. *
  458. * @global bool $cfg['Servers'][$i]['tracking_version_auto_create']
  459. */
  460. $cfg['Servers'][$i]['tracking_version_auto_create'] = false;
  461. /**
  462. * Defines the list of statements
  463. * the auto-creation uses for new versions.
  464. *
  465. * @global string $cfg['Servers'][$i]['tracking_default_statements']
  466. */
  467. $cfg['Servers'][$i]['tracking_default_statements']
  468. = 'CREATE TABLE,ALTER TABLE,DROP TABLE,RENAME TABLE,CREATE INDEX,' .
  469. 'DROP INDEX,INSERT,UPDATE,DELETE,TRUNCATE,REPLACE,CREATE VIEW,' .
  470. 'ALTER VIEW,DROP VIEW,CREATE DATABASE,ALTER DATABASE,DROP DATABASE';
  471. /**
  472. * Whether a DROP VIEW IF EXISTS statement will be added
  473. * as first line to the log when creating a view.
  474. *
  475. * @global bool $cfg['Servers'][$i]['tracking_add_drop_view']
  476. */
  477. $cfg['Servers'][$i]['tracking_add_drop_view'] = true;
  478. /**
  479. * Whether a DROP TABLE IF EXISTS statement will be added
  480. * as first line to the log when creating a table.
  481. *
  482. * @global bool $cfg['Servers'][$i]['tracking_add_drop_table']
  483. */
  484. $cfg['Servers'][$i]['tracking_add_drop_table'] = true;
  485. /**
  486. * Whether a DROP DATABASE IF EXISTS statement will be added
  487. * as first line to the log when creating a database.
  488. *
  489. * @global bool $cfg['Servers'][$i]['tracking_add_drop_database']
  490. */
  491. $cfg['Servers'][$i]['tracking_add_drop_database'] = true;
  492. /**
  493. * Enables caching of TABLE STATUS outputs for specific databases on this server
  494. * (in some cases TABLE STATUS can be very slow, so you may want to cache it).
  495. * APC is used (if the PHP extension is available, if not, this setting is ignored
  496. * silently). You have to provide StatusCacheLifetime.
  497. *
  498. * @global array $cfg['Servers'][$i]['StatusCacheDatabases']
  499. */
  500. $cfg['Servers'][$i]['StatusCacheDatabases'] = array();
  501. /**
  502. * Lifetime in seconds of the TABLE STATUS cache if StatusCacheDatabases is used
  503. *
  504. * @global integer $cfg['Servers'][$i]['StatusCacheLifetime']
  505. */
  506. $cfg['Servers'][$i]['StatusCacheLifetime'] = 0;
  507. /**
  508. * Default server (0 = no default server)
  509. *
  510. * If you have more than one server configured, you can set $cfg['ServerDefault']
  511. * to any one of them to auto-connect to that server when phpMyAdmin is started,
  512. * or set it to 0 to be given a list of servers without logging in
  513. * If you have only one server configured, $cfg['ServerDefault'] *MUST* be
  514. * set to that server.
  515. *
  516. * @global integer $cfg['ServerDefault']
  517. */
  518. $cfg['ServerDefault'] = 1;
  519. /*
  520. * Other core phpMyAdmin settings
  521. */
  522. /**
  523. * whether version check is active
  524. *
  525. * @global boolean $cfg['VersionCheck']
  526. */
  527. if (defined('VERSION_CHECK_DEFAULT')) {
  528. $cfg['VersionCheck'] = VERSION_CHECK_DEFAULT;
  529. } else {
  530. $cfg['VersionCheck'] = true;
  531. }
  532. /**
  533. * The url of the proxy to be used when retrieving the information about
  534. * the latest version of phpMyAdmin or error reporting. You need this if
  535. * the server where phpMyAdmin is installed does not have direct access to
  536. * the internet.
  537. * The format is: "hostname:portnumber"
  538. *
  539. * @global string $cfg['ProxyUrl']
  540. */
  541. $cfg['ProxyUrl'] = "";
  542. /**
  543. * The username for authenticating with the proxy. By default, no
  544. * authentication is performed. If a username is supplied, Basic
  545. * Authentication will be performed. No other types of authentication
  546. * are currently supported.
  547. *
  548. * @global string $cfg['ProxyUser']
  549. */
  550. $cfg['ProxyUser'] = "";
  551. /**
  552. * The password for authenticating with the proxy.
  553. *
  554. * @global string $cfg['ProxyPass']
  555. */
  556. $cfg['ProxyPass'] = "";
  557. /**
  558. * maximum number of db's displayed in database list
  559. *
  560. * @global integer $cfg['MaxDbList']
  561. */
  562. $cfg['MaxDbList'] = 100;
  563. /**
  564. * maximum number of tables displayed in table list
  565. *
  566. * @global integer $cfg['MaxTableList']
  567. */
  568. $cfg['MaxTableList'] = 250;
  569. /**
  570. * whether to show hint or not
  571. *
  572. * @global boolean $cfg['ShowHint']
  573. */
  574. $cfg['ShowHint'] = true;
  575. /**
  576. * maximum number of characters when a SQL query is displayed
  577. *
  578. * @global integer $cfg['MaxCharactersInDisplayedSQL']
  579. */
  580. $cfg['MaxCharactersInDisplayedSQL'] = 1000;
  581. /**
  582. * use GZIP output buffering if possible (true|false|'auto')
  583. *
  584. * @global string $cfg['OBGzip']
  585. */
  586. $cfg['OBGzip'] = 'auto';
  587. /**
  588. * use persistent connections to MySQL database
  589. *
  590. * @global boolean $cfg['PersistentConnections']
  591. */
  592. $cfg['PersistentConnections'] = false;
  593. /**
  594. * whether to force using HTTPS
  595. *
  596. * @global boolean $cfg['ForceSSL']
  597. */
  598. $cfg['ForceSSL'] = false;
  599. /**
  600. * maximum execution time in seconds (0 for no limit)
  601. *
  602. * @global integer $cfg['ExecTimeLimit']
  603. */
  604. $cfg['ExecTimeLimit'] = 300;
  605. /**
  606. * Path for storing session data (session_save_path PHP parameter).
  607. *
  608. * @global integer $cfg['SessionSavePath']
  609. */
  610. $cfg['SessionSavePath'] = '';
  611. /**
  612. * maximum allocated bytes ('-1' for no limit)
  613. * this is a string because '16M' is a valid value; we must put here
  614. * a string as the default value so that /setup accepts strings
  615. *
  616. * @global string $cfg['MemoryLimit']
  617. */
  618. $cfg['MemoryLimit'] = '-1';
  619. /**
  620. * mark used tables, make possible to show locked tables (since MySQL 3.23.30)
  621. * Is ignored for Drizzle.
  622. *
  623. * @global boolean $cfg['SkipLockedTables']
  624. */
  625. $cfg['SkipLockedTables'] = false;
  626. /**
  627. * show SQL queries as run
  628. *
  629. * @global boolean $cfg['ShowSQL']
  630. */
  631. $cfg['ShowSQL'] = true;
  632. /**
  633. * retain SQL input on Ajax execute
  634. *
  635. * @global boolean $cfg['RetainQueryEditor']
  636. */
  637. $cfg['RetainQueryBox'] = false;
  638. /**
  639. * use CodeMirror syntax highlighting for editing SQL
  640. *
  641. * @global boolean $cfg['CodemirrorEnable']
  642. */
  643. $cfg['CodemirrorEnable'] = true;
  644. /**
  645. * show a 'Drop database' link to normal users
  646. *
  647. * @global boolean $cfg['AllowUserDropDatabase']
  648. */
  649. $cfg['AllowUserDropDatabase'] = false;
  650. /**
  651. * confirm some commands that can result in loss of data
  652. *
  653. * @global boolean $cfg['Confirm']
  654. */
  655. $cfg['Confirm'] = true;
  656. /**
  657. * recall previous login in cookie authentication mode or not
  658. *
  659. * @global boolean $cfg['LoginCookieRecall']
  660. */
  661. $cfg['LoginCookieRecall'] = true;
  662. /**
  663. * validity of cookie login (in seconds; 1440 matches php.ini's
  664. * session.gc_maxlifetime)
  665. *
  666. * @global integer $cfg['LoginCookieValidity']
  667. */
  668. $cfg['LoginCookieValidity'] = 1440;
  669. /**
  670. * how long login cookie should be stored (in seconds)
  671. *
  672. * @global integer $cfg['LoginCookieStore']
  673. */
  674. $cfg['LoginCookieStore'] = 0;
  675. /**
  676. * whether to delete all login cookies on logout
  677. *
  678. * @global boolean $cfg['LoginCookieDeleteAll']
  679. */
  680. $cfg['LoginCookieDeleteAll'] = true;
  681. /**
  682. * whether to enable the "database search" feature or not
  683. *
  684. * @global boolean $cfg['UseDbSearch']
  685. */
  686. $cfg['UseDbSearch'] = true;
  687. /**
  688. * if set to true, PMA continues computing multiple-statement queries
  689. * even if one of the queries failed
  690. *
  691. * @global boolean $cfg['IgnoreMultiSubmitErrors']
  692. */
  693. $cfg['IgnoreMultiSubmitErrors'] = false;
  694. /**
  695. * allow login to any user entered server in cookie based authentication
  696. *
  697. * @global boolean $cfg['AllowArbitraryServer']
  698. */
  699. $cfg['AllowArbitraryServer'] = false;
  700. /**
  701. * if reCaptcha is enabled it needs public key to connect with the service
  702. *
  703. * @global string $cfg['CaptchaLoginPublicKey']
  704. */
  705. $cfg['CaptchaLoginPublicKey'] = '';
  706. /**
  707. * if reCaptcha is enabled it needs private key to connect with the service
  708. *
  709. * @global string $cfg['CaptchaLoginPrivateKey']
  710. */
  711. $cfg['CaptchaLoginPrivateKey'] = '';
  712. /*******************************************************************************
  713. * Error handler configuration
  714. *
  715. * this configures phpMyAdmin's own error handler, it is used to avoid information
  716. * disclosure, gather errors for logging, reporting and displaying
  717. *
  718. * @global array $cfg['Error_Handler']
  719. */
  720. $cfg['Error_Handler'] = array();
  721. /**
  722. * whether to display errors or not
  723. *
  724. * this does not affect errors of type E_USER_*
  725. *
  726. * @global boolean $cfg['Error_Handler']['display']
  727. */
  728. $cfg['Error_Handler']['display'] = false;
  729. /*******************************************************************************
  730. * Navigation panel setup
  731. */
  732. /**
  733. * maximum number of first level databases displayed in navigation panel
  734. *
  735. * @global integer $cfg['FirstLevelNavigationItems']
  736. */
  737. $cfg['FirstLevelNavigationItems'] = 250;
  738. /**
  739. * maximum number of items displayed in navigation panel
  740. *
  741. * @global integer $cfg['MaxNavigationItems']
  742. */
  743. $cfg['MaxNavigationItems'] = 50;
  744. /**
  745. * turn the select-based light menu into a tree
  746. *
  747. * @global boolean $cfg['NavigationTreeEnableGrouping']
  748. */
  749. $cfg['NavigationTreeEnableGrouping'] = true;
  750. /**
  751. * the separator to sub-tree the select-based light menu tree
  752. *
  753. * @global string $cfg['NavigationTreeDbSeparator']
  754. */
  755. $cfg['NavigationTreeDbSeparator'] = '_';
  756. /**
  757. * Which string will be used to generate table prefixes
  758. * to split/nest tables into multiple categories
  759. *
  760. * @global string $cfg['NavigationTreeTableSeparator']
  761. */
  762. $cfg['NavigationTreeTableSeparator'] = '__';
  763. /**
  764. * How many sublevels should be displayed when splitting up tables
  765. * by the above Separator
  766. *
  767. * @global integer $cfg['NavigationTreeTableLevel']
  768. */
  769. $cfg['NavigationTreeTableLevel'] = 1;
  770. /**
  771. * display logo at top of navigation panel
  772. *
  773. * @global boolean $cfg['NavigationDisplayLogo']
  774. */
  775. $cfg['NavigationDisplayLogo'] = true;
  776. /**
  777. * where should logo link point to (can also contain an external URL)
  778. *
  779. * @global string $cfg['NavigationLogoLink']
  780. */
  781. $cfg['NavigationLogoLink'] = 'index.php';
  782. /**
  783. * whether to open the linked page in the main window ('main') or
  784. * in a new window ('new')
  785. *
  786. * @global string $cfg['NavigationLogoLinkWindow']
  787. */
  788. $cfg['NavigationLogoLinkWindow'] = 'main';
  789. /**
  790. * number of recently used tables displayed in the navigation panel
  791. *
  792. * @global integer $cfg['NumRecentTables']
  793. */
  794. $cfg['NumRecentTables'] = 10;
  795. /**
  796. * number of favorite tables displayed in the navigation panel
  797. *
  798. * @global integer $cfg['NumFavoriteTables']
  799. */
  800. $cfg['NumFavoriteTables'] = 10;
  801. /**
  802. * display a JavaScript table filter in the navigation panel
  803. * when more then x tables are present
  804. *
  805. * @global boolean $cfg['NavigationTreeDisplayItemFilterMinimum']
  806. */
  807. $cfg['NavigationTreeDisplayItemFilterMinimum'] = 30;
  808. /**
  809. * display server choice at top of navigation panel
  810. *
  811. * @global boolean $cfg['NavigationDisplayServers']
  812. */
  813. $cfg['NavigationDisplayServers'] = true;
  814. /**
  815. * server choice as links
  816. *
  817. * @global boolean $cfg['DisplayServersList']
  818. */
  819. $cfg['DisplayServersList'] = false;
  820. /**
  821. * display a JavaScript database filter in the navigation panel
  822. * when more then x databases are present
  823. *
  824. * @global boolean $cfg['NavigationTreeDisplayDbFilterMinimum']
  825. */
  826. $cfg['NavigationTreeDisplayDbFilterMinimum'] = 30;
  827. /**
  828. * target of the navigation panel quick access icon
  829. *
  830. * Possible values:
  831. * 'tbl_structure.php' = fields list
  832. * 'tbl_sql.php' = SQL form
  833. * 'tbl_select.php' = search page
  834. * 'tbl_change.php' = insert row page
  835. * 'sql.php' = browse page
  836. *
  837. * @global string $cfg['NavigationTreeDefaultTabTable']
  838. */
  839. $cfg['NavigationTreeDefaultTabTable'] = 'tbl_structure.php';
  840. /**
  841. * Disables the possibility of database expansion
  842. *
  843. * @global boolean $cfg['DisableDatabaseExpansion']
  844. */
  845. $cfg['NavigationTreeDisableDatabaseExpansion'] = false;
  846. /*******************************************************************************
  847. * In the main panel, at startup...
  848. */
  849. /**
  850. * allow to display statistics and space usage in the pages about database
  851. * details and table properties
  852. *
  853. * @global boolean $cfg['ShowStats']
  854. */
  855. $cfg['ShowStats'] = true;
  856. /**
  857. * show PHP info link
  858. *
  859. * @global boolean $cfg['ShowPhpInfo']
  860. */
  861. $cfg['ShowPhpInfo'] = false;
  862. /**
  863. * show MySQL server and web server information
  864. *
  865. * @global boolean $cfg['ShowServerInfo']
  866. */
  867. $cfg['ShowServerInfo'] = true;
  868. /**
  869. * show change password link
  870. *
  871. * @global boolean $cfg['ShowChgPassword']
  872. */
  873. $cfg['ShowChgPassword'] = true;
  874. /**
  875. * show create database form
  876. *
  877. * @global boolean $cfg['ShowCreateDb']
  878. */
  879. $cfg['ShowCreateDb'] = true;
  880. /*******************************************************************************
  881. * Database structure
  882. */
  883. /**
  884. * show creation timestamp column in database structure (true|false)?
  885. *
  886. * @global boolean $cfg['ShowDbStructureCreation']
  887. */
  888. $cfg['ShowDbStructureCreation'] = false;
  889. /**
  890. * show last update timestamp column in database structure (true|false)?
  891. *
  892. * @global boolean $cfg['ShowDbStructureLastUpdate']
  893. */
  894. $cfg['ShowDbStructureLastUpdate'] = false;
  895. /**
  896. * show last check timestamp column in database structure (true|false)?
  897. *
  898. * @global boolean $cfg['ShowDbStructureLastCheck']
  899. */
  900. $cfg['ShowDbStructureLastCheck'] = false;
  901. /**
  902. * allow hide action columns to drop down menu in database structure (true|false)?
  903. *
  904. * @global boolean $cfg['HideStructureActions']
  905. */
  906. $cfg['HideStructureActions'] = true;
  907. /*******************************************************************************
  908. * In browse mode...
  909. */
  910. /**
  911. * Use icons instead of text for the navigation bar buttons (table browse)
  912. * ('text'|'icons'|'both')
  913. *
  914. * @global string $cfg['TableNavigationLinksMode']
  915. */
  916. $cfg['TableNavigationLinksMode'] = 'icons';
  917. /**
  918. * Defines whether a user should be displayed a "show all (records)"
  919. * button in browse mode or not.
  920. *
  921. * @global boolean $cfg['ShowAll']
  922. */
  923. $cfg['ShowAll'] = false;
  924. /**
  925. * Number of rows displayed when browsing a result set. If the result
  926. * set contains more rows, "Previous" and "Next".
  927. * Possible values: 25,50,100,250,500
  928. *
  929. * @global integer $cfg['MaxRows']
  930. */
  931. $cfg['MaxRows'] = 25;
  932. /**
  933. * default for 'ORDER BY' clause (valid values are 'ASC', 'DESC' or 'SMART' -ie
  934. * descending order for fields of type TIME, DATE, DATETIME & TIMESTAMP,
  935. * ascending order else-)
  936. *
  937. * @global string $cfg['Order']
  938. */
  939. $cfg['Order'] = 'SMART';
  940. /**
  941. * default for 'Show binary contents as HEX'
  942. *
  943. * @global string $cfg['DisplayBinaryAsHex']
  944. */
  945. $cfg['DisplayBinaryAsHex'] = true;
  946. /**
  947. * grid editing: save edited cell(s) in browse-mode at once
  948. *
  949. * @global boolean $cfg['SaveCellsAtOnce']
  950. */
  951. $cfg['SaveCellsAtOnce'] = false;
  952. /**
  953. * grid editing: which action triggers it, or completely disable the feature
  954. *
  955. * Possible values:
  956. * 'click'
  957. * 'double-click'
  958. * 'disabled'
  959. *
  960. * @global string $cfg['GridEditing']
  961. */
  962. $cfg['GridEditing'] ='double-click';
  963. /*******************************************************************************
  964. * In edit mode...
  965. */
  966. /**
  967. * disallow editing of binary fields
  968. * valid values are:
  969. * false allow editing
  970. * 'blob' allow editing except for BLOB fields
  971. * 'noblob' disallow editing except for BLOB fields
  972. * 'all' disallow editing
  973. *
  974. * @global string $cfg['ProtectBinary']
  975. */
  976. $cfg['ProtectBinary'] = 'blob';
  977. /**
  978. * Display the function fields in edit/insert mode
  979. *
  980. * @global boolean $cfg['ShowFunctionFields']
  981. */
  982. $cfg['ShowFunctionFields'] = true;
  983. /**
  984. * Display the type fields in edit/insert mode
  985. *
  986. * @global boolean $cfg['ShowFieldTypesInDataEditView']
  987. */
  988. $cfg['ShowFieldTypesInDataEditView'] = true;
  989. /**
  990. * Which editor should be used for CHAR/VARCHAR fields:
  991. * input - allows limiting of input length
  992. * textarea - allows newlines in fields
  993. *
  994. * @global string $cfg['CharEditing']
  995. */
  996. $cfg['CharEditing'] = 'input';
  997. /**
  998. * The minimum size for character input fields
  999. *
  1000. * @global integer $cfg['MinSizeForInputField']
  1001. */
  1002. $cfg['MinSizeForInputField'] = 4;
  1003. /**
  1004. * The maximum size for character input fields
  1005. *
  1006. * @global integer $cfg['MinSizeForInputField']
  1007. */
  1008. $cfg['MaxSizeForInputField'] = 60;
  1009. /**
  1010. * How many rows can be inserted at one time
  1011. *
  1012. * @global integer $cfg['InsertRows']
  1013. */
  1014. $cfg['InsertRows'] = 2;
  1015. /**
  1016. * Sort order for items in a foreign-key drop-down list.
  1017. * 'content' is the referenced data, 'id' is the key value.
  1018. *
  1019. * @global array $cfg['ForeignKeyDropdownOrder']
  1020. */
  1021. $cfg['ForeignKeyDropdownOrder'] = array('content-id', 'id-content');
  1022. /**
  1023. * A drop-down list will be used if fewer items are present
  1024. *
  1025. * @global integer $cfg['ForeignKeyMaxLimit']
  1026. */
  1027. $cfg['ForeignKeyMaxLimit'] = 100;
  1028. /*******************************************************************************
  1029. * For the export features...
  1030. */
  1031. /**
  1032. * Allow for the use of zip compression (requires zip support to be enabled)
  1033. *
  1034. * @global boolean $cfg['ZipDump']
  1035. */
  1036. $cfg['ZipDump'] = true;
  1037. /**
  1038. * Allow for the use of gzip compression (requires zlib)
  1039. *
  1040. * @global boolean $cfg['GZipDump']
  1041. */
  1042. $cfg['GZipDump'] = true;
  1043. /**
  1044. * Allow for the use of bzip2 decompression (requires bz2 extension)
  1045. *
  1046. * @global boolean $cfg['BZipDump']
  1047. */
  1048. $cfg['BZipDump'] = true;
  1049. /**
  1050. * Will compress gzip exports on the fly without the need for much memory.
  1051. * If you encounter problems with created gzip files disable this feature.
  1052. *
  1053. * @global boolean $cfg['CompressOnFly']
  1054. */
  1055. $cfg['CompressOnFly'] = true;
  1056. /*******************************************************************************
  1057. * Tabs display settings
  1058. */
  1059. /**
  1060. * How to display the menu tabs ('icons'|'text'|'both')
  1061. *
  1062. * @global boolean $cfg['TabsMode']
  1063. */
  1064. $cfg['TabsMode'] = 'both';
  1065. /**
  1066. * How to display various action links ('icons'|'text'|'both')
  1067. *
  1068. * @global boolean $cfg['ActionLinksMode']
  1069. */
  1070. $cfg['ActionLinksMode'] = 'both';
  1071. /**
  1072. * How many columns should be used for table display of a database?
  1073. * (a value larger than 1 results in some information being hidden)
  1074. *
  1075. * @global integer $cfg['PropertiesNumColumns']
  1076. */
  1077. $cfg['PropertiesNumColumns'] = 1;
  1078. /**
  1079. * Possible values:
  1080. * 'index.php' = the welcome page
  1081. * (recommended for multiuser setups)
  1082. * 'server_databases.php' = list of databases
  1083. * 'server_status.php' = runtime information
  1084. * 'server_variables.php' = MySQL server variables
  1085. * 'server_privileges.php' = user management
  1086. *
  1087. * @global string $cfg['DefaultTabServer']
  1088. */
  1089. $cfg['DefaultTabServer'] = 'index.php';
  1090. /**
  1091. * Possible values:
  1092. * 'db_structure.php' = tables list
  1093. * 'db_sql.php' = SQL form
  1094. * 'db_search.php' = search query
  1095. * 'db_operations.php' = operations on database
  1096. *
  1097. * @global string $cfg['DefaultTabDatabase']
  1098. */
  1099. $cfg['DefaultTabDatabase'] = 'db_structure.php';
  1100. /**
  1101. * Possible values:
  1102. * 'tbl_structure.php' = fields list
  1103. * 'tbl_sql.php' = SQL form
  1104. * 'tbl_select.php' = search page
  1105. * 'tbl_change.php' = insert row page
  1106. * 'sql.php' = browse page
  1107. *
  1108. * @global string $cfg['DefaultTabTable']
  1109. */
  1110. $cfg['DefaultTabTable'] = 'sql.php';
  1111. /**
  1112. * Whether to display image or text or both image and text in table row
  1113. * action segment. Value can be either of ``image``, ``text`` or ``both``.
  1114. */
  1115. $cfg['RowActionType'] = 'both';
  1116. /*******************************************************************************
  1117. * Export defaults
  1118. */
  1119. $cfg['Export'] = array();
  1120. /**
  1121. * codegen/csv/excel/htmlexcel/htmlword/latex/ods/odt/pdf/sql/texytext/xls/xml/yaml
  1122. *
  1123. * @global string $cfg['Export']['format']
  1124. */
  1125. $cfg['Export']['format'] = 'sql';
  1126. /**
  1127. * quick/custom/custom-no-form
  1128. *
  1129. * @global string $cfg['Export']['format']
  1130. */
  1131. $cfg['Export']['method'] = 'quick';
  1132. /**
  1133. * none/zip/gzip
  1134. *
  1135. * @global string $cfg['Export']['compression']
  1136. */
  1137. $cfg['Export']['compression'] = 'none';
  1138. /**
  1139. *
  1140. *
  1141. * @global boolean $cfg['Export']['asfile']
  1142. */
  1143. $cfg['Export']['asfile'] = true;
  1144. /**
  1145. *
  1146. *
  1147. * @global string $cfg['Export']['charset']
  1148. */
  1149. $cfg['Export']['charset'] = '';
  1150. /**
  1151. *
  1152. *
  1153. * @global boolean $cfg['Export']['onserver']
  1154. */
  1155. $cfg['Export']['onserver'] = false;
  1156. /**
  1157. *
  1158. *
  1159. * @global boolean $cfg['Export']['onserver_overwrite']
  1160. */
  1161. $cfg['Export']['onserver_overwrite'] = false;
  1162. /**
  1163. *
  1164. *
  1165. * @global boolean $cfg['Export']['quick_export_onserver']
  1166. */
  1167. $cfg['Export']['quick_export_onserver'] = false;
  1168. /**
  1169. *
  1170. *
  1171. * @global boolean $cfg['Export']['quick_export_onserver_overwrite']
  1172. */
  1173. $cfg['Export']['quick_export_onserver_overwrite'] = false;
  1174. /**
  1175. *
  1176. *
  1177. * @global boolean $cfg['Export']['remember_file_template']
  1178. */
  1179. $cfg['Export']['remember_file_template'] = true;
  1180. /**
  1181. *
  1182. *
  1183. * @global string $cfg['Export']['file_template_table']
  1184. */
  1185. $cfg['Export']['file_template_table'] = '@TABLE@';
  1186. /**
  1187. *
  1188. *
  1189. * @global string $cfg['Export']['file_template_database']
  1190. */
  1191. $cfg['Export']['file_template_database'] = '@DATABASE@';
  1192. /**
  1193. *
  1194. *
  1195. * @global string $cfg['Export']['file_template_server']
  1196. */
  1197. $cfg['Export']['file_template_server'] = '@SERVER@';
  1198. /**
  1199. *
  1200. *
  1201. * @global string $cfg['Export']['codegen_structure_or_data']
  1202. */
  1203. $cfg['Export']['codegen_structure_or_data'] = 'data';
  1204. /**
  1205. *
  1206. *
  1207. * @global $cfg['Export']['codegen_format']
  1208. */
  1209. $cfg['Export']['codegen_format'] = 0;
  1210. /**
  1211. *
  1212. *
  1213. * @global boolean $cfg['Export']['ods_columns']
  1214. */
  1215. $cfg['Export']['ods_columns'] = false;
  1216. /**
  1217. *
  1218. *
  1219. * @global string $cfg['Export']['ods_null']
  1220. */
  1221. $cfg['Export']['ods_null'] = 'NULL';
  1222. /**
  1223. *
  1224. *
  1225. * @global string $cfg['Export']['odt_structure_or_data']
  1226. */
  1227. $cfg['Export']['odt_structure_or_data'] = 'structure_and_data';
  1228. /**
  1229. *
  1230. *
  1231. * @global boolean $cfg['Export']['odt_columns']
  1232. */
  1233. $cfg['Export']['odt_columns'] = true;
  1234. /**
  1235. *
  1236. *
  1237. * @global boolean $cfg['Export']['odt_relation']
  1238. */
  1239. $cfg['Export']['odt_relation'] = true;
  1240. /**
  1241. *
  1242. *
  1243. * @global boolean $cfg['Export']['odt_comments']
  1244. */
  1245. $cfg['Export']['odt_comments'] = true;
  1246. /**
  1247. *
  1248. *
  1249. * @global boolean $cfg['Export']['odt_mime']
  1250. */
  1251. $cfg['Export']['odt_mime'] = true;
  1252. /**
  1253. *
  1254. *
  1255. * @global string $cfg['Export']['odt_null']
  1256. */
  1257. $cfg['Export']['odt_null'] = 'NULL';
  1258. /**
  1259. *
  1260. *
  1261. * @global boolean $cfg['Export']['htmlword_structure_or_data']
  1262. */
  1263. $cfg['Export']['htmlword_structure_or_data'] = 'structure_and_data';
  1264. /**
  1265. *
  1266. *
  1267. * @global boolean $cfg['Export']['htmlword_columns']
  1268. */
  1269. $cfg['Export']['htmlword_columns'] = false;
  1270. /**
  1271. *
  1272. *
  1273. * @global string $cfg['Export']['htmlword_null']
  1274. */
  1275. $cfg['Export']['htmlword_null'] = 'NULL';
  1276. /**
  1277. *
  1278. *
  1279. * @global string $cfg['Export']['texytext_structure_or_data']
  1280. */
  1281. $cfg['Export']['texytext_structure_or_data'] = 'structure_and_data';
  1282. /**
  1283. *
  1284. *
  1285. * @global boolean $cfg['Export']['texytext_columns']
  1286. */
  1287. $cfg['Export']['texytext_columns'] = false;
  1288. /**
  1289. *
  1290. *
  1291. * @global string $cfg['Export']['texytext_null']
  1292. */
  1293. $cfg['Export']['texytext_null'] = 'NULL';
  1294. /**
  1295. *
  1296. *
  1297. * @global boolean $cfg['Export']['xls_columns']
  1298. */
  1299. $cfg['Export']['xls_columns'] = false;
  1300. /**
  1301. *
  1302. *
  1303. * @global string $cfg['Export']['xls_structure_or_data']
  1304. */
  1305. $cfg['Export']['xls_structure_or_data'] = 'data';
  1306. /**
  1307. *
  1308. *
  1309. * @global string $cfg['Export']['xls_null']
  1310. */
  1311. $cfg['Export']['xls_null'] = 'NULL';
  1312. /**
  1313. *
  1314. *
  1315. * @global boolean $cfg['Export']['xlsx_columns']
  1316. */
  1317. $cfg['Export']['xlsx_columns'] = false;
  1318. /**
  1319. *
  1320. *
  1321. * @global string $cfg['Export']['xlsx_structure_or_data']
  1322. */
  1323. $cfg['Export']['xlsx_structure_or_data'] = 'data';
  1324. /**
  1325. *
  1326. *
  1327. * @global string $cfg['Export']['xlsx_null']
  1328. */
  1329. $cfg['Export']['xlsx_null'] = 'NULL';
  1330. /**
  1331. *
  1332. *
  1333. * @global boolean $cfg['Export']['csv_columns']
  1334. */
  1335. $cfg['Export']['csv_columns'] = false;
  1336. /**
  1337. *
  1338. *
  1339. * @global string $cfg['Export']['csv_structure_or_data']
  1340. */
  1341. $cfg['Export']['csv_structure_or_data'] = 'data';
  1342. /**
  1343. *
  1344. *
  1345. * @global string $cfg['Export']['csv_null']
  1346. */
  1347. $cfg['Export']['csv_null'] = 'NULL';
  1348. /**
  1349. *
  1350. *
  1351. * @global string $cfg['Export']['csv_separator']
  1352. */
  1353. $cfg['Export']['csv_separator'] = ',';
  1354. /**
  1355. *
  1356. *
  1357. * @global string $cfg['Export']['csv_enclosed']
  1358. */
  1359. $cfg['Export']['csv_enclosed'] = '"';
  1360. /**
  1361. *
  1362. *
  1363. * @global string $cfg['Export']['csv_escaped']
  1364. */
  1365. $cfg['Export']['csv_escaped'] = '"';
  1366. /**
  1367. *
  1368. *
  1369. * @global string $cfg['Export']['csv_terminated']
  1370. */
  1371. $cfg['Export']['csv_terminated'] = 'AUTO';
  1372. /**
  1373. *
  1374. *
  1375. * @global string $cfg['Export']['csv_removeCRLF']
  1376. */
  1377. $cfg['Export']['csv_removeCRLF'] = false;
  1378. /**
  1379. *
  1380. *
  1381. * @global boolean $cfg['Export']['excel_columns']
  1382. */
  1383. $cfg['Export']['excel_columns'] = false;
  1384. /**
  1385. *
  1386. *
  1387. * @global string $cfg['Export']['excel_null']
  1388. */
  1389. $cfg['Export']['excel_null'] = 'NULL';
  1390. /**
  1391. * win/mac
  1392. *
  1393. * @global string $cfg['Export']['excel_edition']
  1394. */
  1395. $cfg['Export']['excel_edition'] = 'win';
  1396. /**
  1397. *
  1398. *
  1399. * @global string $cfg['Export']['excel_removeCRLF']
  1400. */
  1401. $cfg['Export']['excel_removeCRLF'] = false;
  1402. /**
  1403. *
  1404. *
  1405. * @global string $cfg['Export']['excel_structure_or_data']
  1406. */
  1407. $cfg['Export']['excel_structure_or_data'] = 'data';
  1408. /**
  1409. *
  1410. *
  1411. * @global string $cfg['Export']['latex_structure_or_data']
  1412. */
  1413. $cfg['Export']['latex_structure_or_data'] = 'structure_and_data';
  1414. /**
  1415. *
  1416. *
  1417. * @global boolean $cfg['Export']['latex_columns']
  1418. */
  1419. $cfg['Export']['latex_columns'] = true;
  1420. /**
  1421. *
  1422. *
  1423. * @global boolean $cfg['Export']['latex_relation']
  1424. */
  1425. $cfg['Export']['latex_relation'] = true;
  1426. /**
  1427. *
  1428. *
  1429. * @global boolean $cfg['Export']['latex_comments']
  1430. */
  1431. $cfg['Export']['latex_comments'] = true;
  1432. /**
  1433. *
  1434. *
  1435. * @global boolean $cfg['Export']['latex_mime']
  1436. */
  1437. $cfg['Export']['latex_mime'] = true;
  1438. /**
  1439. *
  1440. *
  1441. * @global string $cfg['Export']['latex_null']
  1442. */
  1443. $cfg['Export']['latex_null'] = '\textit{NULL}';
  1444. /**
  1445. *
  1446. *
  1447. * @global boolean $cfg['Export']['latex_caption']
  1448. */
  1449. $cfg['Export']['latex_caption'] = true;
  1450. /**
  1451. *
  1452. *
  1453. * @global string $cfg['Export']['latex_structure_caption']
  1454. */
  1455. $cfg['Export']['latex_structure_caption'] = 'strLatexStructure';
  1456. /**
  1457. *
  1458. *
  1459. * @global string $cfg['Export']['latex_structure_continued_caption']
  1460. */
  1461. $cfg['Export']['latex_structure_continued_caption']
  1462. = 'strLatexStructure strLatexContinued';
  1463. /**
  1464. *
  1465. *
  1466. * @global string $cfg['Export']['latex_data_caption']
  1467. */
  1468. $cfg['Export']['latex_data_caption'] = 'strLatexContent';
  1469. /**
  1470. *
  1471. *
  1472. * @global string $cfg['Export']['latex_data_continued_caption']
  1473. */
  1474. $cfg['Export']['latex_data_continued_caption'] = 'strLatexContent strLatexContinued';
  1475. /**
  1476. *
  1477. *
  1478. * @global string $cfg['Export']['latex_data_label']
  1479. */
  1480. $cfg['Export']['latex_data_label'] = 'tab:@TABLE@-data';
  1481. /**
  1482. *
  1483. *
  1484. * @global string $cfg['Export']['latex_structure_label']
  1485. */
  1486. $cfg['Export']['latex_structure_label'] = 'tab:@TABLE@-structure';
  1487. /**
  1488. *
  1489. *
  1490. * @global string $cfg['Export']['mediawiki_structure_or_data']
  1491. */
  1492. $cfg['Export']['mediawiki_structure_or_data'] = 'data';
  1493. /**
  1494. *
  1495. *
  1496. * @global boolean $cfg['Export']['mediawiki_caption']
  1497. */
  1498. $cfg['Export']['mediawiki_caption'] = true;
  1499. /**
  1500. *
  1501. *
  1502. * @global boolean $cfg['Export']['mediawiki_headers']
  1503. */
  1504. $cfg['Export']['mediawiki_headers'] = true;
  1505. /**
  1506. *
  1507. *
  1508. * @global string $cfg['Export']['ods_structure_or_data']
  1509. */
  1510. $cfg['Export']['ods_structure_or_data'] = 'data';
  1511. /**
  1512. *
  1513. *
  1514. * @global string $cfg['Export']['pdf_structure_or_data']
  1515. */
  1516. $cfg['Export']['pdf_structure_or_data'] = 'data';
  1517. /**
  1518. *
  1519. *
  1520. * @global string $cfg['Export']['phparray_structure_or_data']
  1521. */
  1522. $cfg['Export']['phparray_structure_or_data'] = 'data';
  1523. /**
  1524. *
  1525. *
  1526. * @global string $cfg['Export']['json_structure_or_data']
  1527. */
  1528. $cfg['Export']['json_structure_or_data'] = 'data';
  1529. /**
  1530. *
  1531. *
  1532. * @global string $cfg['Export']['sql_structure_or_data']
  1533. */
  1534. $cfg['Export']['sql_structure_or_data'] = 'structure_and_data';
  1535. /**
  1536. *
  1537. *
  1538. * @global string $cfg['Export']['sql_compatibility']
  1539. */
  1540. $cfg['Export']['sql_compatibility'] = 'NONE';
  1541. /**
  1542. * Whether to include comments in SQL export.
  1543. *
  1544. * @global string $cfg['Export']['sql_include_comments']
  1545. */
  1546. $cfg['Export']['sql_include_comments'] = true;
  1547. /**
  1548. *
  1549. *
  1550. * @global boolean $cfg['Export']['sql_disable_fk']
  1551. */
  1552. $cfg['Export']['sql_disable_fk'] = false;
  1553. /**
  1554. *
  1555. *
  1556. * @global boolean $cfg['Export']['sql_views_as_tables']
  1557. */
  1558. $cfg['Export']['sql_views_as_tables'] = false;
  1559. /**
  1560. *
  1561. *
  1562. * @global boolean $cfg['Export']['sql_use_transaction']
  1563. */
  1564. $cfg['Export']['sql_use_transaction'] = false;
  1565. /**
  1566. *
  1567. *
  1568. * @global boolean $cfg['Export']['sql_create_database']
  1569. */
  1570. $cfg['Export']['sql_create_database'] = false;
  1571. /**
  1572. *
  1573. *
  1574. * @global boolean $cfg['Export']['sql_drop_database']
  1575. */
  1576. $cfg['Export']['sql_drop_database'] = false;
  1577. /**
  1578. *
  1579. *
  1580. * @global boolean $cfg['Export']['sql_drop_table']
  1581. */
  1582. $cfg['Export']['sql_drop_table'] = false;
  1583. /**
  1584. *
  1585. *
  1586. * true by default for correct behavior when dealing with exporting
  1587. * of VIEWs and the stand-in table
  1588. * @global boolean $cfg['Export']['sql_if_not_exists']
  1589. */
  1590. $cfg['Export']['sql_if_not_exists'] = true;
  1591. /**
  1592. *
  1593. *
  1594. * @global boolean $cfg['Export']['sql_procedure_function']
  1595. */
  1596. $cfg['Export']['sql_procedure_function'] = true;
  1597. /**
  1598. *
  1599. *
  1600. * @global boolean $cfg['Export']['sql_create_table']
  1601. */
  1602. $cfg['Export']['sql_create_table'] = true;
  1603. /**
  1604. *
  1605. *
  1606. * @global boolean $cfg['Export']['sql_create_view']
  1607. */
  1608. $cfg['Export']['sql_create_view'] = true;
  1609. /**
  1610. *
  1611. *
  1612. * @global boolean $cfg['Export']['sql_create_trigger']
  1613. */
  1614. $cfg['Export']['sql_create_trigger'] = true;
  1615. /**
  1616. *
  1617. *
  1618. * @global boolean $cfg['Export']['sql_auto_increment']
  1619. */
  1620. $cfg['Export']['sql_auto_increment'] = true;
  1621. /**
  1622. *
  1623. *
  1624. * @global boolean $cfg['Export']['sql_backquotes']
  1625. */
  1626. $cfg['Export']['sql_backquotes'] = true;
  1627. /**
  1628. *
  1629. *
  1630. * @global boolean $cfg['Export']['sql_dates']
  1631. */
  1632. $cfg['Export']['sql_dates'] = false;
  1633. /**
  1634. *
  1635. *
  1636. * @global boolean $cfg['Export']['sql_relation']
  1637. */
  1638. $cfg['Export']['sql_relation'] = false;
  1639. /**
  1640. *
  1641. *
  1642. * @global boolean $cfg['Export']['sql_truncate']
  1643. */
  1644. $cfg['Export']['sql_truncate'] = false;
  1645. /**
  1646. *
  1647. *
  1648. * @global boolean $cfg['Export']['sql_delayed']
  1649. */
  1650. $cfg['Export']['sql_delayed'] = false;
  1651. /**
  1652. *
  1653. *
  1654. * @global boolean $cfg['Export']['sql_ignore']
  1655. */
  1656. $cfg['Export']['sql_ignore'] = false;
  1657. /**
  1658. * Export time in UTC.
  1659. *
  1660. * @global boolean $cfg['Export']['sql_utc_time']
  1661. */
  1662. $cfg['Export']['sql_utc_time'] = true;
  1663. /**
  1664. *
  1665. *
  1666. * @global boolean $cfg['Export']['sql_hex_for_binary']
  1667. */
  1668. $cfg['Export']['sql_hex_for_binary'] = true;
  1669. /**
  1670. * insert/update/replace
  1671. *
  1672. * @global string $cfg['Export']['sql_type']
  1673. */
  1674. $cfg['Export']['sql_type'] = 'INSERT';
  1675. /**
  1676. *
  1677. *
  1678. * @global integer $cfg['Export']['sql_max_query_size']
  1679. */
  1680. $cfg['Export']['sql_max_query_size'] = 50000;
  1681. /**
  1682. *
  1683. *
  1684. * @global boolean $cfg['Export']['sql_mime']
  1685. */
  1686. $cfg['Export']['sql_mime'] = false;
  1687. /**
  1688. * \n is replaced by new line
  1689. *
  1690. * @global string $cfg['Export']['sql_header_comment']
  1691. */
  1692. $cfg['Export']['sql_header_comment'] = '';
  1693. /**
  1694. *
  1695. *
  1696. * @global boolean $cfg['Export']['sql_create_table_statements']
  1697. */
  1698. $cfg['Export']['sql_create_table_statements'] = true;
  1699. /**
  1700. * Whether to use complete inserts, extended inserts, both, or neither
  1701. *
  1702. * @global string $cfg['Export']['sql_insert_syntax']
  1703. */
  1704. $cfg['Export']['sql_insert_syntax'] = 'both';
  1705. /**
  1706. *
  1707. *
  1708. * @global string $cfg['Export']['pdf_report_title']
  1709. */
  1710. $cfg['Export']['pdf_report_title'] = '';
  1711. /**
  1712. *
  1713. *
  1714. *@global string $cfg['Export']['xml_structure_or_data']
  1715. */
  1716. $cfg['Export']['xml_structure_or_data'] = 'data';
  1717. /**
  1718. * Export schema for each structure
  1719. *
  1720. * @global string $cfg['Export']['xml_export_struc']
  1721. */
  1722. $cfg['Export']['xml_export_struc'] = true;
  1723. /**
  1724. * Export functions
  1725. *
  1726. * @global string $cfg['Export']['xml_export_functions']
  1727. */
  1728. $cfg['Export']['xml_export_functions'] = true;
  1729. /**
  1730. * Export procedures
  1731. *
  1732. * @global string $cfg['Export']['xml_export_procedures']
  1733. */
  1734. $cfg['Export']['xml_export_procedures'] = true;
  1735. /**
  1736. * Export schema for each table
  1737. *
  1738. * @global string $cfg['Export']['xml_export_tables']
  1739. */
  1740. $cfg['Export']['xml_export_tables'] = true;
  1741. /**
  1742. * Export triggers
  1743. *
  1744. * @global string $cfg['Export']['xml_export_triggers']
  1745. */
  1746. $cfg['Export']['xml_export_triggers'] = true;
  1747. /**
  1748. * Export views
  1749. *
  1750. * @global string $cfg['Export']['xml_export_views']
  1751. */
  1752. $cfg['Export']['xml_export_views'] = true;
  1753. /**
  1754. * Export contents data
  1755. *
  1756. * @global string $cfg['Export']['xml_export_contents']
  1757. */
  1758. $cfg['Export']['xml_export_contents'] = true;
  1759. /**
  1760. *
  1761. *
  1762. * @global string $cfg['Export']['yaml_structure_or_data']
  1763. */
  1764. $cfg['Export']['yaml_structure_or_data'] = 'data';
  1765. /*******************************************************************************
  1766. * Import defaults
  1767. */
  1768. $cfg['Import'] = array();
  1769. /**
  1770. *
  1771. *
  1772. * @global string $cfg['Import']['format']
  1773. */
  1774. $cfg['Import']['format'] = 'sql';
  1775. /**
  1776. * Default charset for import.
  1777. *
  1778. * @global string $cfg['Import']['charset']
  1779. */
  1780. $cfg['Import']['charset'] = '';
  1781. /**
  1782. *
  1783. *
  1784. * @global boolean $cfg['Import']['allow_interrupt']
  1785. */
  1786. $cfg['Import']['allow_interrupt'] = true;
  1787. /**
  1788. *
  1789. *
  1790. * @global integer $cfg['Import']['skip_queries']
  1791. */
  1792. $cfg['Import']['skip_queries'] = 0;
  1793. /**
  1794. *
  1795. *
  1796. * @global string $cfg['Import']['sql_compatibility']
  1797. */
  1798. $cfg['Import']['sql_compatibility'] = 'NONE';
  1799. /**
  1800. *
  1801. *
  1802. * @global string $cfg['Import']['sql_no_auto_value_on_zero']
  1803. */
  1804. $cfg['Import']['sql_no_auto_value_on_zero'] = true;
  1805. /**
  1806. *
  1807. *
  1808. * @global boolean $cfg['Import']['csv_replace']
  1809. */
  1810. $cfg['Import']['csv_replace'] = false;
  1811. /**
  1812. *
  1813. *
  1814. * @global boolean $cfg['Import']['csv_ignore']
  1815. */
  1816. $cfg['Import']['csv_ignore'] = false;
  1817. /**
  1818. *
  1819. *
  1820. * @global string $cfg['Import']['csv_terminated']
  1821. */
  1822. $cfg['Import']['csv_terminated'] = ',';
  1823. /**
  1824. *
  1825. *
  1826. * @global string $cfg['Import']['csv_enclosed']
  1827. */
  1828. $cfg['Import']['csv_enclosed'] = '"';
  1829. /**
  1830. *
  1831. *
  1832. * @global string $cfg['Import']['csv_escaped']
  1833. */
  1834. $cfg['Import']['csv_escaped'] = '"';
  1835. /**
  1836. *
  1837. *
  1838. * @global string $cfg['Import']['csv_new_line']
  1839. */
  1840. $cfg['Import']['csv_new_line'] = 'auto';
  1841. /**
  1842. *
  1843. *
  1844. * @global string $cfg['Import']['csv_columns']
  1845. */
  1846. $cfg['Import']['csv_columns'] = '';
  1847. /**
  1848. *
  1849. *
  1850. * @global string $cfg['Import']['csv_col_names']
  1851. */
  1852. $cfg['Import']['csv_col_names'] = false;
  1853. /**
  1854. *
  1855. *
  1856. * @global boolean $cfg['Import']['ldi_replace']
  1857. */
  1858. $cfg['Import']['ldi_replace'] = false;
  1859. /**
  1860. *
  1861. *
  1862. * @global boolean $cfg['Import']['ldi_ignore']
  1863. */
  1864. $cfg['Import']['ldi_ignore'] = false;
  1865. /**
  1866. *
  1867. *
  1868. * @global string $cfg['Import']['ldi_terminated']
  1869. */
  1870. $cfg['Import']['ldi_terminated'] = ';';
  1871. /**
  1872. *
  1873. *
  1874. * @global string $cfg['Import']['ldi_enclosed']
  1875. */
  1876. $cfg['Import']['ldi_enclosed'] = '"';
  1877. /**
  1878. *
  1879. *
  1880. * @global string $cfg['Import']['ldi_escaped']
  1881. */
  1882. $cfg['Import']['ldi_escaped'] = '\\';
  1883. /**
  1884. *
  1885. *
  1886. * @global string $cfg['Import']['ldi_new_line']
  1887. */
  1888. $cfg['Import']['ldi_new_line'] = 'auto';
  1889. /**
  1890. *
  1891. *
  1892. * @global string $cfg['Import']['ldi_columns']
  1893. */
  1894. $cfg['Import']['ldi_columns'] = '';
  1895. /**
  1896. * 'auto' for auto-detection, true or false for forcing
  1897. *
  1898. * @global string $cfg['Import']['ldi_local_option']
  1899. */
  1900. $cfg['Import']['ldi_local_option'] = 'auto';
  1901. /**
  1902. *
  1903. *
  1904. * @global string $cfg['Import']['ods_col_names']
  1905. */
  1906. $cfg['Import']['ods_col_names'] = false;
  1907. /**
  1908. *
  1909. *
  1910. * @global string $cfg['Import']['ods_empty_rows']
  1911. */
  1912. $cfg['Import']['ods_empty_rows'] = true;
  1913. /**
  1914. *
  1915. *
  1916. * @global string $cfg['Import']['ods_recognize_percentages']
  1917. */
  1918. $cfg['Import']['ods_recognize_percentages'] = true;
  1919. /**
  1920. *
  1921. *
  1922. * @global string $cfg['Import']['ods_recognize_currency']
  1923. */
  1924. $cfg['Import']['ods_recognize_currency'] = true;
  1925. /**
  1926. *
  1927. *
  1928. * @global string $cfg['Import']['xml_col_names']
  1929. */
  1930. $cfg['Import']['xls_col_names'] = false;
  1931. /**
  1932. *
  1933. *
  1934. * @global string $cfg['Import']['xml_empty_rows']
  1935. */
  1936. $cfg['Import']['xls_empty_rows'] = true;
  1937. /**
  1938. *
  1939. *
  1940. * @global string $cfg['Import']['xlsx_col_names']
  1941. */
  1942. $cfg['Import']['xlsx_col_names'] = false;
  1943. /*******************************************************************************
  1944. * PDF options
  1945. */
  1946. /**
  1947. *
  1948. *
  1949. * @global array $cfg['PDFPageSizes']
  1950. */
  1951. $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
  1952. /**
  1953. *
  1954. *
  1955. * @global string $cfg['PDFDefaultPageSize']
  1956. */
  1957. $cfg['PDFDefaultPageSize'] = 'A4';
  1958. /*******************************************************************************
  1959. * Language and character set conversion settings
  1960. */
  1961. /**
  1962. * Default language to use, if not browser-defined or user-defined
  1963. *
  1964. * @global string $cfg['DefaultLang']
  1965. */
  1966. $cfg['DefaultLang'] = 'en';
  1967. /**
  1968. * Default connection collation
  1969. *
  1970. * @global string $cfg['DefaultConnectionCollation']
  1971. */
  1972. $cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
  1973. /**
  1974. * Force: always use this language
  1975. * $cfg['Lang'] = 'en';
  1976. *
  1977. * Regular expression to limit listed languages, e.g. '^(cs|en)' for Czech and
  1978. * English only
  1979. *
  1980. * @global string $cfg['FilterLanguages']
  1981. */
  1982. $cfg['FilterLanguages'] = '';
  1983. /**
  1984. * You can select here which functions will be used for character set conversion.
  1985. * Possible values are:
  1986. * auto - automatically use available one (first is tested iconv, then
  1987. * recode)
  1988. * iconv - use iconv or libiconv functions
  1989. * recode - use recode_string function
  1990. * mb - use mbstring extension
  1991. * none - disable encoding conversion
  1992. *
  1993. * @global string $cfg['RecodingEngine']
  1994. */
  1995. $cfg['RecodingEngine'] = 'auto';
  1996. /**
  1997. * Specify some parameters for iconv used in character set conversion. See iconv
  1998. * documentation for details:
  1999. * http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
  2000. *
  2001. * @global string $cfg['IconvExtraParams']
  2002. */
  2003. $cfg['IconvExtraParams'] = '//TRANSLIT';
  2004. /**
  2005. * Available character sets for MySQL conversion. currently contains all which could
  2006. * be found in lang/* files and few more.
  2007. * Character sets will be shown in same order as here listed, so if you frequently
  2008. * use some of these move them to the top.
  2009. *
  2010. * @global array $cfg['AvailableCharsets']
  2011. */
  2012. $cfg['AvailableCharsets'] = array(
  2013. 'iso-8859-1',
  2014. 'iso-8859-2',
  2015. 'iso-8859-3',
  2016. 'iso-8859-4',
  2017. 'iso-8859-5',
  2018. 'iso-8859-6',
  2019. 'iso-8859-7',
  2020. 'iso-8859-8',
  2021. 'iso-8859-9',
  2022. 'iso-8859-10',
  2023. 'iso-8859-11',
  2024. 'iso-8859-12',
  2025. 'iso-8859-13',
  2026. 'iso-8859-14',
  2027. 'iso-8859-15',
  2028. 'windows-1250',
  2029. 'windows-1251',
  2030. 'windows-1252',
  2031. 'windows-1256',
  2032. 'windows-1257',
  2033. 'koi8-r',
  2034. 'big5',
  2035. 'gb2312',
  2036. 'utf-16',
  2037. 'utf-8',
  2038. 'utf-7',
  2039. 'x-user-defined',
  2040. 'euc-jp',
  2041. 'ks_c_5601-1987',
  2042. 'tis-620',
  2043. 'SHIFT_JIS'
  2044. );
  2045. /*******************************************************************************
  2046. * Customization & design
  2047. *
  2048. * The graphical settings are now located in themes/theme-name/layout.inc.php
  2049. */
  2050. /**
  2051. * enable the left panel pointer
  2052. * see also LeftPointerColor
  2053. * in layout.inc.php
  2054. *
  2055. * @global boolean $cfg['NavigationTreePointerEnable']
  2056. */
  2057. $cfg['NavigationTreePointerEnable'] = true;
  2058. /**
  2059. * enable the browse pointer
  2060. * see also BrowsePointerColor
  2061. * in layout.inc.php
  2062. *
  2063. * @global boolean $cfg['BrowsePointerEnable']
  2064. */
  2065. $cfg['BrowsePointerEnable'] = true;
  2066. /**
  2067. * enable the browse marker
  2068. * see also BrowseMarkerColor
  2069. * in layout.inc.php
  2070. *
  2071. * @global boolean $cfg['BrowseMarkerEnable']
  2072. */
  2073. $cfg['BrowseMarkerEnable'] = true;
  2074. /**
  2075. * textarea size (columns) in edit mode
  2076. * (this value will be emphasized (*2) for SQL
  2077. * query textareas and (*1.25) for query window)
  2078. *
  2079. * @global integer $cfg['TextareaCols']
  2080. */
  2081. $cfg['TextareaCols'] = 40;
  2082. /**
  2083. * textarea size (rows) in edit mode
  2084. *
  2085. * @global integer $cfg['TextareaRows']
  2086. */
  2087. $cfg['TextareaRows'] = 15;
  2088. /**
  2089. * double size of textarea size for LONGTEXT columns
  2090. *
  2091. * @global boolean $cfg['LongtextDoubleTextarea']
  2092. */
  2093. $cfg['LongtextDoubleTextarea'] = true;
  2094. /**
  2095. * auto-select when clicking in the textarea of the query-box
  2096. *
  2097. * @global boolean $cfg['TextareaAutoSelect']
  2098. */
  2099. $cfg['TextareaAutoSelect'] = false;
  2100. /**
  2101. * textarea size (columns) for CHAR/VARCHAR
  2102. *
  2103. * @global integer $cfg['CharTextareaCols']
  2104. */
  2105. $cfg['CharTextareaCols'] = 40;
  2106. /**
  2107. * textarea size (rows) for CHAR/VARCHAR
  2108. *
  2109. * @global integer $cfg['CharTextareaRows']
  2110. */
  2111. $cfg['CharTextareaRows'] = 2;
  2112. /**
  2113. * Max field data length in browse mode for all non-numeric fields
  2114. *
  2115. * @global integer $cfg['LimitChars']
  2116. */
  2117. $cfg['LimitChars'] = 50;
  2118. /**
  2119. * Where to show the edit/copy/delete links in browse mode
  2120. * Possible values are 'left', 'right', 'both' and 'none';
  2121. * which will be interpreted as 'top', 'bottom', 'both' and 'none'
  2122. * respectively for vertical display mode
  2123. *
  2124. * @global string $cfg['RowActionLinks']
  2125. */
  2126. $cfg['RowActionLinks'] = 'left';
  2127. /**
  2128. * default display direction (horizontal|vertical|horizontalflipped)
  2129. *
  2130. * @global string $cfg['DefaultDisplay']
  2131. */
  2132. $cfg['DefaultDisplay'] = 'horizontal';
  2133. /**
  2134. * remember the last way a table sorted
  2135. *
  2136. * @global string $cfg['RememberSorting']
  2137. */
  2138. $cfg['RememberSorting'] = true;
  2139. /**
  2140. * table-header rotation via faking or CSS? (css|fake|auto)
  2141. * NOTE: CSS only works in IE browsers!
  2142. *
  2143. * @global string $cfg['HeaderFlipType']
  2144. */
  2145. $cfg['HeaderFlipType'] = 'auto';
  2146. /**
  2147. * shows stored relation-comments in 'browse' mode.
  2148. *
  2149. * @global boolean $cfg['ShowBrowseComments']
  2150. */
  2151. $cfg['ShowBrowseComments'] = true;
  2152. /**
  2153. * shows stored relation-comments in 'table property' mode.
  2154. *
  2155. * @global boolean $cfg['ShowPropertyComments']
  2156. */
  2157. $cfg['ShowPropertyComments']= true;
  2158. /**
  2159. * shows table display direction.
  2160. */
  2161. $cfg['ShowDisplayDirection'] = false;
  2162. /**
  2163. * repeat header names every X cells? (0 = deactivate)
  2164. *
  2165. * @global integer $cfg['RepeatCells']
  2166. */
  2167. $cfg['RepeatCells'] = 100;
  2168. /**
  2169. * Set to true if Edit link should open the query to edit in the query window
  2170. * and to false if we should edit in the right panel
  2171. *
  2172. * @global boolean $cfg['EditInWindow']
  2173. */
  2174. $cfg['EditInWindow'] = true;
  2175. /**
  2176. * Width of Query window
  2177. *
  2178. * @global integer $cfg['QueryWindowWidth']
  2179. */
  2180. $cfg['QueryWindowWidth'] = 550;
  2181. /**
  2182. * Height of Query window
  2183. *
  2184. * @global integer $cfg['QueryWindowHeight']
  2185. */
  2186. $cfg['QueryWindowHeight'] = 310;
  2187. /**
  2188. * Set to true if you want DB-based query history.If false, this utilizes
  2189. * JS-routines to display query history (lost by window close)
  2190. *
  2191. * @global boolean $cfg['QueryHistoryDB']
  2192. */
  2193. $cfg['QueryHistoryDB'] = false;
  2194. /**
  2195. * which tab to display in the querywindow on startup
  2196. * (sql|files|history|full)
  2197. *
  2198. * @global string $cfg['QueryWindowDefTab']
  2199. */
  2200. $cfg['QueryWindowDefTab'] = 'sql';
  2201. /**
  2202. * When using DB-based query history, how many entries should be kept?
  2203. *
  2204. * @global integer $cfg['QueryHistoryMax']
  2205. */
  2206. $cfg['QueryHistoryMax'] = 25;
  2207. /**
  2208. * Use MIME-Types (stored in column comments table) for
  2209. *
  2210. * @global boolean $cfg['BrowseMIME']
  2211. */
  2212. $cfg['BrowseMIME'] = true;
  2213. /**
  2214. * When approximate count < this, PMA will get exact count for table rows.
  2215. *
  2216. * @global integer $cfg['MaxExactCount']
  2217. */
  2218. $cfg['MaxExactCount'] = 500000;
  2219. /**
  2220. * Zero means that no row count is done for views; see the doc
  2221. *
  2222. * @global integer $cfg['MaxExactCountViews']
  2223. */
  2224. $cfg['MaxExactCountViews'] = 0;
  2225. /**
  2226. * Sort table and database in natural order
  2227. *
  2228. * @global boolean $cfg['NaturalOrder']
  2229. */
  2230. $cfg['NaturalOrder'] = true;
  2231. /**
  2232. * Initial state for sliders
  2233. * (open | closed | disabled)
  2234. *
  2235. * @global string $cfg['InitialSlidersState']
  2236. */
  2237. $cfg['InitialSlidersState'] = 'closed';
  2238. /**
  2239. * User preferences: disallow these settings
  2240. * For possible setting names look in libraries/config/user_preferences.forms.php
  2241. *
  2242. * @global array $cfg['UserprefsDisallow']
  2243. */
  2244. $cfg['UserprefsDisallow'] = array();
  2245. /**
  2246. * User preferences: enable the Developer tab
  2247. */
  2248. $cfg['UserprefsDeveloperTab'] = false;
  2249. /*******************************************************************************
  2250. * Window title settings
  2251. */
  2252. /**
  2253. * title of browser window when a table is selected
  2254. *
  2255. * @global string $cfg['TitleTable']
  2256. */
  2257. $cfg['TitleTable'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@';
  2258. /**
  2259. * title of browser window when a database is selected
  2260. *
  2261. * @global string $cfg['TitleDatabase']
  2262. */
  2263. $cfg['TitleDatabase'] = '@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@';
  2264. /**
  2265. * title of browser window when a server is selected
  2266. *
  2267. * @global string $cfg['TitleServer']
  2268. */
  2269. $cfg['TitleServer'] = '@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@';
  2270. /**
  2271. * title of browser window when nothing is selected
  2272. * @global string $cfg['TitleDefault']
  2273. */
  2274. $cfg['TitleDefault'] = '@HTTP_HOST@ | @PHPMYADMIN@';
  2275. /*******************************************************************************
  2276. * theme manager
  2277. */
  2278. /**
  2279. * using themes manager please set up here the path to 'themes' else leave empty
  2280. *
  2281. * @global string $cfg['ThemePath']
  2282. */
  2283. $cfg['ThemePath'] = './themes';
  2284. /**
  2285. * if you want to use selectable themes and if ThemesPath not empty
  2286. * set it to true, else set it to false (default is false);
  2287. *
  2288. * @global boolean $cfg['ThemeManager']
  2289. */
  2290. $cfg['ThemeManager'] = true;
  2291. /**
  2292. * set up default theme, if ThemePath not empty you can set up here an valid
  2293. * path to themes or 'original' for the original pma-theme
  2294. *
  2295. * @global string $cfg['ThemeDefault']
  2296. */
  2297. $cfg['ThemeDefault'] = 'pmahomme';
  2298. /**
  2299. * allow different theme for each configured server
  2300. *
  2301. * @global boolean $cfg['ThemePerServer']
  2302. */
  2303. $cfg['ThemePerServer'] = false;
  2304. /*******************************************************************************
  2305. *
  2306. */
  2307. /**
  2308. * Default query for table
  2309. *
  2310. * @global string $cfg['DefaultQueryTable']
  2311. */
  2312. $cfg['DefaultQueryTable'] = 'SELECT * FROM @TABLE@ WHERE 1';
  2313. /**
  2314. * Default query for database
  2315. *
  2316. * @global string $cfg['DefaultQueryDatabase']
  2317. */
  2318. $cfg['DefaultQueryDatabase'] = '';
  2319. /*******************************************************************************
  2320. * SQL Query box settings
  2321. * These are the links display in all of the SQL Query boxes
  2322. *
  2323. * @global array $cfg['SQLQuery']
  2324. */
  2325. $cfg['SQLQuery'] = array();
  2326. /**
  2327. * Edit link to change a query
  2328. *
  2329. * @global boolean $cfg['SQLQuery']['Edit']
  2330. */
  2331. $cfg['SQLQuery']['Edit'] = true;
  2332. /**
  2333. * EXPLAIN on SELECT queries
  2334. *
  2335. * @global boolean $cfg['SQLQuery']['Explain']
  2336. */
  2337. $cfg['SQLQuery']['Explain'] = true;
  2338. /**
  2339. * Wrap a query in PHP
  2340. *
  2341. * @global boolean $cfg['SQLQuery']['ShowAsPHP']
  2342. */
  2343. $cfg['SQLQuery']['ShowAsPHP'] = true;
  2344. /**
  2345. * Refresh the results page
  2346. *
  2347. * @global boolean $cfg['SQLQuery']['Refresh']
  2348. */
  2349. $cfg['SQLQuery']['Refresh'] = true;
  2350. /*******************************************************************************
  2351. * Web server upload/save/import directories
  2352. */
  2353. /**
  2354. * Directory for uploaded files that can be executed by phpMyAdmin.
  2355. * For example './upload'. Leave empty for no upload directory support.
  2356. * Use %u for username inclusion.
  2357. *
  2358. * @global string $cfg['UploadDir']
  2359. */
  2360. $cfg['UploadDir'] = '';
  2361. /**
  2362. * Directory where phpMyAdmin can save exported data on server.
  2363. * For example './save'. Leave empty for no save directory support.
  2364. * Use %u for username inclusion.
  2365. *
  2366. * @global string $cfg['SaveDir']
  2367. */
  2368. $cfg['SaveDir'] = '';
  2369. /**
  2370. * Directory where phpMyAdmin can save temporary files.
  2371. *
  2372. * @global string $cfg['TempDir']
  2373. */
  2374. $cfg['TempDir'] = '';
  2375. /**
  2376. * Misc. settings
  2377. */
  2378. /**
  2379. * Is GD >= 2 available? Set to yes/no/auto. 'auto' does auto-detection,
  2380. * which is the only safe way to determine GD version.
  2381. *
  2382. * @global string $cfg['GD2Available']
  2383. */
  2384. $cfg['GD2Available'] = 'auto';
  2385. /**
  2386. * Lists proxy IP and HTTP header combinations which are trusted for IP allow/deny
  2387. *
  2388. * @global array $cfg['TrustedProxies']
  2389. */
  2390. $cfg['TrustedProxies'] = array();
  2391. /**
  2392. * We normally check the permissions on the configuration file to ensure
  2393. * it's not world writable. However, phpMyAdmin could be installed on
  2394. * a NTFS filesystem mounted on a non-Windows server, in which case the
  2395. * permissions seems wrong but in fact cannot be detected. In this case
  2396. * a sysadmin would set the following to false.
  2397. */
  2398. $cfg['CheckConfigurationPermissions'] = true;
  2399. /**
  2400. * Limit for length of URL in links. When length would be above this limit, it
  2401. * is replaced by form with button.
  2402. * This is required as some web servers (IIS) have problems with long URLs.
  2403. * The recommended limit is 2000
  2404. * (see http://www.boutell.com/newfaq/misc/urllength.html) but we put
  2405. * 1000 to accommodate Suhosin, see bug #3358750.
  2406. */
  2407. $cfg['LinkLengthLimit'] = 1000;
  2408. /**
  2409. * Additional string to allow in CSP headers.
  2410. */
  2411. $cfg['CSPAllow'] = '';
  2412. /**
  2413. * Disable the table maintenance mass operations, like optimizing or
  2414. * repairing the selected tables of a database. An accidental execution
  2415. * of such a maintenance task can enormously slow down a bigger database.
  2416. */
  2417. $cfg['DisableMultiTableMaintenance'] = false;
  2418. /**
  2419. * Whether or not to query the user before sending the error report to
  2420. * the phpMyAdmin team when a JavaScript error occurs
  2421. *
  2422. * Available options
  2423. * (ask | always | never)
  2424. *
  2425. * @global string $cfg['SendErrorReports']
  2426. */
  2427. $cfg['SendErrorReports'] = 'ask';
  2428. /*******************************************************************************
  2429. * Developers ONLY!
  2430. *
  2431. * @global array $cfg['DBG']
  2432. */
  2433. $cfg['DBG'] = array();
  2434. /**
  2435. * Output executed queries and their execution times
  2436. *
  2437. * @global boolean $cfg['DBG']['sql']
  2438. */
  2439. $cfg['DBG']['sql'] = false;
  2440. /**
  2441. * Enable to let server present itself as demo server.
  2442. *
  2443. * @global boolean $cfg['DBG']['demo']
  2444. */
  2445. $cfg['DBG']['demo'] = false;
  2446. /*******************************************************************************
  2447. * MySQL settings
  2448. */
  2449. /**
  2450. * Default functions for above defined groups
  2451. *
  2452. * @global array $cfg['DefaultFunctions']
  2453. */
  2454. $cfg['DefaultFunctions'] = array(
  2455. 'FUNC_CHAR' => '',
  2456. 'FUNC_DATE' => '',
  2457. 'FUNC_NUMBER' => '',
  2458. 'FUNC_SPATIAL' => 'GeomFromText',
  2459. 'FUNC_UUID' => 'UUID',
  2460. 'first_timestamp' => 'NOW',
  2461. );
  2462. /**
  2463. * Max rows retreived for zoom search
  2464. */
  2465. $cfg['maxRowPlotLimit'] = 500;
  2466. ?>