config.default.php 69 KB

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