config.default.php 61 KB

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