WebSVN – MLAB – Rev 356 – Blame – /Web/Maintenance/phpMyAdmin/config.inc.php

250

kaklik

1

<?php

2

3

/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */

4

5

/* $Id: config.default.php,v 1.8 2005/12/16 14:07:10 lem9 Exp $ */

6

// vim: expandtab sw=4 ts=4 sts=4:

7

8

/**

9

* phpMyAdmin default configuration, you can copy values from here to your

10

* config.inc.php

11

*

12

* All directives are explained in Documentation.html

13

*/

14

15

16

/**

17

* Your phpMyAdmin URL.

18

*

19

* Complete the variable below with the full url ie

20

* http://www.your_web.net/path_to_your_phpMyAdmin_directory/

21

*

22

* It must contain characters that are valid for a URL, and the path is

23

* case sensitive on some Web servers, for example Unix-based servers.

24

*

25

* In most cases you can leave this variable empty, as the correct value

26

* will be detected automatically. However, we recommend that you do

27

* test to see that the auto-detection code works in your system. A good

28

* test is to browse a table, then edit a row and save it. There will be

29

* an error message if phpMyAdmin cannot auto-detect the correct value.

30

*/

31

$cfg['PmaAbsoluteUri'] = '';

32

33

/**

34

* Disable the default warning that is displayed on the DB Details Structure page if

35

* any of the required Tables for the relationfeatures could not be found

36

*/

37

$cfg['PmaNoRelation_DisableWarning'] = FALSE;

38

39

/**

40

* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If

41

* at least one server configuration uses 'cookie' auth_type, enter here a

42

* passphrase that will be used by blowfish. The maximum length seems to be 46

43

* characters.

44

*/

250

kaklik

46

47

/**

48

* Server(s) configuration

49

*/

50

$i = 0;

51

// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use

52

// $cfg['Servers'][0]. You can disable a server config entry by setting host

53

// to ''. If you want more than one server, just copy following section

54

// (including $i incrementation) serveral times. There is no need to define

55

// full server array, just define values you need to change.

56

$i++;

57

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address

58

$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port

59

$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket

60

$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')

61

$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')

62

$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection

63

// (requires PHP >= 4.3.0)

64

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings

65

// (this user must have read-only

66

$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user"

67

// and "mysql/db" tables).

68

// The controluser is also

69

// used for all relational

70

// features (pmadb)

250

kaklik

74

// with 'config' auth_type)

75

$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only

76

// this db is displayed in left frame

77

                                                    // It may also be an array of db-names, where sorting order is relevant.

78

$cfg['Servers'][$i]['hide_db'] = ''; // Database name to be hidden from listings

79

$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname

80

81

$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features

82

// (see scripts/create_tables.sql)

83

// - leave blank for no support

84

// DEFAULT: 'phpmyadmin'

85

$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table

86

// - leave blank for no bookmark support

87

// DEFAULT: 'pma_bookmark'

88

$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc)

89

// - leave blank for no relation-links support

90

// DEFAULT: 'pma_relation'

91

$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields

92

// - leave blank for no display fields support

93

// DEFAULT: 'pma_table_info'

94

$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema

95

// - leave blank for no PDF schema support

96

// DEFAULT: 'pma_table_coords'

97

$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf

98

// - leave blank if you don't want to use this

99

// DEFAULT: 'pma_pdf_pages'

100

$cfg['Servers'][$i]['column_info'] = ''; // table to store column information

101

// - leave blank for no column comments/mime types

102

// DEFAULT: 'pma_column_info'

103

$cfg['Servers'][$i]['history'] = ''; // table to store SQL history

104

// - leave blank for no SQL query history

105

// DEFAULT: 'pma_history'

106

$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables

107

// are up to date. This prevents compatibility

108

// checks and thereby increases performance.

109

$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login

110

$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use

111

= '';

112

$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults

113

= array();

114

115

// If you have more than one server configured, you can set $cfg['ServerDefault']

116

// to any one of them to autoconnect to that server when phpMyAdmin is started,

117

// or set it to 0 to be given a list of servers without logging in

118

// If you have only one server configured, $cfg['ServerDefault'] *MUST* be

119

// set to that server.

120

$cfg['ServerDefault'] = 1; // Default server (0 = no default server)

121

122

/**

123

* Other core phpMyAdmin settings

124

*/

125

$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')

126

$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database

127

$cfg['ForceSSL'] = FALSE; // whether to force using https

128

$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)

129

$cfg['MemoryLimit'] = 0; // maximum allocated bytes (0 for no limit)

130

$cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show

131

// locked tables (since MySQL 3.23.30)

132

$cfg['ShowSQL'] = TRUE; // show SQL queries as run

133

$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users

134

$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'

135

$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not

136

$cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds)

137

$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature

138

// or not

139

$cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries

140

// even if one of the queries failed

141

$cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on

142

// multiple-statement queries. See the libraries/import.php file for

143

// hardcoded defaults on how many queries a statement may contain!

144

$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth

145

146

// Left frame setup

147

$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the

148

// current tables in the left frame.

149

$cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree

150

$cfg['LeftFrameDBSeparator'] = '_'; // the separator to sub-tree the select-based light menu tree

151

$cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes

152

// to split/nest tables into multiple categories

153

$cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting

154

// up tables by the above Separator

155

$cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame

156

$cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments

157

$cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of

158

// table/db names. Setting ShowTooltipAliasTB to 'nested' will only

159

// use the Aliases for nested descriptors, not the table itself.

160

161

$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame

162

$cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame

163

$cfg['DisplayServersList'] = FALSE; // server choice as links

164

165

// In the main frame, at startup...

166

$cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in

167

// the pages about database details and table

168

// properties

169

$cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for

170

$cfg['ShowChgPassword'] = FALSE; // simple users or not

171

$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)

172

173

// In browse mode...

174

$cfg['ShowBlob'] = FALSE; // display blob field contents

175

$cfg['NavigationBarIconic'] = 'both'; // Use icons instead of text for the navigation bar buttons

176

// and on right panel top menu (server db table) (TRUE|FALSE|'both')

177

$cfg['ShowAll'] = FALSE; // allows to display all the rows

178

$cfg['MaxRows'] = 30; // maximum number of rows to display

179

$cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid

180

// values are 'ASC', 'DESC' or 'SMART' -ie

181

// descending order for fields of type

182

// TIME, DATE, DATETIME & TIMESTAMP,

183

// ascending order else-)

184

185

// In edit mode...

186

$cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields

187

// valid values are:

188

// FALSE allow editing

189

// 'blob' allow editing except for BLOB fields

190

// 'all' disallow editing

191

$cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode

192

$cfg['CharEditing'] = 'input';

193

// Which editor should be used for CHAR/VARCHAR fields:

194

// input - allows limiting of input length

195

// textarea - allows newlines in fields

196

$cfg['InsertRows'] = 2; // How many rows can be inserted at one time

197

198

$cfg['ForeignKeyDropdownOrder'] = // Sort order for items in a foreign-key dropdown box.

199

array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.

200

$cfg['ForeignKeyMaxLimit'] = 100; // A dropdown will be used if fewer items are present

201

202

203

// For the export features...

204

$cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip

205

$cfg['GZipDump'] = TRUE; // compression for

206

$cfg['BZipDump'] = TRUE; // dump files

207

$cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on

208

// fly without need for much memory.

209

// If you encounter problems with

210

// created gzip/bzip2 files disable

211

// this feature.

212

213

// Tabs display settings

214

$cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs

215

$cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')

216

$cfg['PropertiesNumColumns'] = 1; // How many columns should be used for table display of a database?

217

// (a value larger than 1 results in some information being hidden)

218

219

$cfg['DefaultTabServer'] = 'main.php';

220

// Possible values:

221

// 'main.php' = the welcome page

222

// (recommended for multiuser setups)

223

// 'server_databases.php' = list of databases

224

// 'server_status.php' = runtime information

225

// 'server_variables.php' = MySQL server variables

226

// 'server_privileges.php' = user management

227

// 'server_processlist.php' = process list

228

$cfg['DefaultTabDatabase'] = 'db_details_structure.php';

229

// Possible values:

230

// 'db_details_structure.php' = tables list

231

// 'db_details.php' = sql form

232

// 'db_search.php' = search query

233

// 'db_operations.php' = operations on database

234

$cfg['DefaultTabTable'] = 'tbl_properties_structure.php';

235

// Possible values:

236

// 'tbl_properties_structure.php' = fields list

237

// 'tbl_properties.php' = sql form

238

// 'tbl_select.php' = select page

239

// 'tbl_change.php' = insert row page

240

// 'sql.php' = browse page

241

242

/**

243

* Export defaults

244

*/

245

246

$cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword

247

$cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2

248

249

$cfg['Export']['asfile'] = FALSE;

250

$cfg['Export']['charset'] = '';

251

$cfg['Export']['onserver'] = FALSE;

252

$cfg['Export']['onserver_overwrite'] = FALSE;

253

$cfg['Export']['remember_file_template'] = TRUE;

254

$cfg['Export']['file_template_table'] = '__TABLE__';

255

$cfg['Export']['file_template_database'] = '__DB__';

256

$cfg['Export']['file_template_server'] = '__SERVER__';

257

258

$cfg['Export']['htmlexcel_columns'] = FALSE;

259

$cfg['Export']['htmlexcel_null'] = 'NULL';

260

261

$cfg['Export']['htmlword_structure'] = TRUE;

262

$cfg['Export']['htmlword_data'] = TRUE;

263

$cfg['Export']['htmlword_columns'] = FALSE;

264

$cfg['Export']['htmlword_null'] = 'NULL';

265

266

$cfg['Export']['xls_columns'] = FALSE;

267

$cfg['Export']['xls_null'] = 'NULL';

268

269

$cfg['Export']['csv_columns'] = FALSE;

270

$cfg['Export']['csv_null'] = 'NULL';

271

$cfg['Export']['csv_separator'] = ';';

272

$cfg['Export']['csv_enclosed'] = '"';

273

$cfg['Export']['csv_escaped'] = '\\';

274

$cfg['Export']['csv_terminated'] = 'AUTO';

275

$cfg['Export']['excel_columns'] = FALSE;

276

$cfg['Export']['excel_null'] = 'NULL';

277

$cfg['Export']['excel_edition'] = 'win'; // win/mac

278

279

$cfg['Export']['latex_structure'] = TRUE;

280

$cfg['Export']['latex_data'] = TRUE;

281

$cfg['Export']['latex_columns'] = TRUE;

282

$cfg['Export']['latex_relation'] = TRUE;

283

$cfg['Export']['latex_comments'] = TRUE;

284

$cfg['Export']['latex_mime'] = TRUE;

285

$cfg['Export']['latex_null'] = '\textit{NULL}';

286

$cfg['Export']['latex_caption'] = TRUE;

287

$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';

288

$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';

289

290

$cfg['Export']['sql_structure'] = TRUE;

291

$cfg['Export']['sql_data'] = TRUE;

292

$cfg['Export']['sql_compat'] = 'NONE';

293

$cfg['Export']['sql_disable_fk'] = FALSE;

294

$cfg['Export']['sql_use_transaction'] = FALSE;

295

$cfg['Export']['sql_drop_database'] = FALSE;

296

$cfg['Export']['sql_drop_table'] = FALSE;

297

$cfg['Export']['sql_if_not_exists'] = FALSE;

298

$cfg['Export']['sql_auto_increment'] = TRUE;

299

$cfg['Export']['sql_backquotes'] = TRUE;

300

$cfg['Export']['sql_dates'] = FALSE;

301

$cfg['Export']['sql_relation'] = FALSE;

302

$cfg['Export']['sql_columns'] = TRUE;

303

$cfg['Export']['sql_delayed'] = FALSE;

304

$cfg['Export']['sql_ignore'] = FALSE;

305

$cfg['Export']['sql_hex_for_binary'] = TRUE;

306

$cfg['Export']['sql_type'] = 'insert'; // insert/update/replace

307

$cfg['Export']['sql_extended'] = TRUE;

308

$cfg['Export']['sql_max_query_size'] = 50000;

309

$cfg['Export']['sql_comments'] = FALSE;

310

$cfg['Export']['sql_mime'] = FALSE;

311

$cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line

312

313

$cfg['Export']['pdf_structure'] = FALSE;

314

$cfg['Export']['pdf_data'] = TRUE;

315

$cfg['Export']['pdf_report_title'] = '';

316

317

/**

318

* Import defaults

319

*/

320

$cfg['Import']['format'] = 'sql';

321

$cfg['Import']['allow_interrupt'] = TRUE;

322

$cfg['Import']['skip_queries'] = '0';

323

$cfg['Import']['csv_replace'] = FALSE;

324

$cfg['Import']['csv_terminated'] = ';';

325

$cfg['Import']['csv_enclosed'] = '"';

326

$cfg['Import']['csv_escaped'] = '\\';

327

$cfg['Import']['csv_new_line'] = 'auto';

328

$cfg['Import']['csv_columns'] = '';

329

$cfg['Import']['ldi_replace'] = FALSE;

330

$cfg['Import']['ldi_terminated'] = ';';

331

$cfg['Import']['ldi_enclosed'] = '"';

332

$cfg['Import']['ldi_escaped'] = '\\';

333

$cfg['Import']['ldi_new_line'] = 'auto';

334

$cfg['Import']['ldi_columns'] = '';

335

$cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing

336

337

338

/**

339

* Link to the official MySQL documentation.

340

* Be sure to include no trailing slash on the path.

341

* See http://dev.mysql.com/doc/ for more information

342

* about MySQL manuals and their types.

343

*/

344

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';

345

346

/**

347

* Type of MySQL documentation:

348

* viewable - "viewable online", current one used on MySQL website

349

* searchable - "Searchable, with user comments"

350

* chapters - "HTML, one page per chapter"

351

* chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release

352

* big - "HTML, all on one page"

353

* old - old style used in phpMyAdmin 2.3.0 and sooner

354

* none - do not show documentation links

355

*/

356

$cfg['MySQLManualType'] = 'viewable';

357

358

359

/**

360

* PDF options

361

*/

362

$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');

363

$cfg['PDFDefaultPageSize'] = 'A4';

364

365

366

/**

367

* Language and charset conversion settings

368

*/

369

// Default language to use, if not browser-defined or user-defined

370

$cfg['DefaultLang'] = 'en-iso-8859-1';

371

372

// Default connection collation (used for MySQL >= 4.1)

373

$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';

374

375

// Force: always use this language - must be defined in

376

// libraries/select_lang.lib.php

377

// $cfg['Lang'] = 'en-iso-8859-1';

378

379

// Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and

380

// English only

381

$cfg['FilterLanguages'] = '';

382

383

// Default charset to use for recoding of MySQL queries, does not take

384

// any effect when charsets recoding is switched off by

385

// $cfg['AllowAnywhereRecoding'] or in language file

386

// (see $cfg['AvailableCharsets'] to possible choices, you can add your own)

387

$cfg['DefaultCharset'] = 'iso-8859-1';

388

389

// Allow charset recoding of MySQL queries, must be also enabled in language

390

// file to make harder using other language files than unicode.

391

// Default value is FALSE to avoid problems on servers without the iconv

392

// extension and where dl() is not supported

393

$cfg['AllowAnywhereRecoding'] = FALSE;

394

395

// You can select here which functions will be used for charset conversion.

396

// Possible values are:

397

// auto - automatically use available one (first is tested iconv, then

398

// recode)

399

// iconv - use iconv or libiconv functions

400

// recode - use recode_string function

401

$cfg['RecodingEngine'] = 'auto';

402

403

// Specify some parameters for iconv used in charset conversion. See iconv

404

// documentation for details:

405

// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html

406

$cfg['IconvExtraParams'] = '//TRANSLIT';

407

408

// Available charsets for MySQL conversion. currently contains all which could

409

// be found in lang/* files and few more.

410

// Charsets will be shown in same order as here listed, so if you frequently

411

// use some of these move them to the top.

412

$cfg['AvailableCharsets'] = array(

413

'iso-8859-1',

414

'iso-8859-2',

415

'iso-8859-3',

416

'iso-8859-4',

417

'iso-8859-5',

418

'iso-8859-6',

419

'iso-8859-7',

420

'iso-8859-8',

421

'iso-8859-9',

422

'iso-8859-10',

423

'iso-8859-11',

424

'iso-8859-12',

425

'iso-8859-13',

426

'iso-8859-14',

427

'iso-8859-15',

428

'windows-1250',

429

'windows-1251',

430

'windows-1252',

431

'windows-1256',

432

'windows-1257',

433

'koi8-r',

434

'big5',

435

'gb2312',

436

'utf-16',

437

'utf-8',

438

'utf-7',

439

'x-user-defined',

440

'euc-jp',

441

'ks_c_5601-1987',

442

'tis-620',

443

'SHIFT_JIS'

444

);

445

446

/**

447

* Customization & design

448

*

449

* The graphical settings are now located in themes/themename/layout.inc.php

450

*/

451

452

$cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer

453

// (used when LeftFrameLight is FALSE)

454

// see also LeftPointerColor

455

// in layout.inc.php

456

457

$cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer

458

// see also BrowsePointerColor

459

// in layout.inc.php

460

461

$cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker

462

// see also BrowseMarkerColor

463

// in layout.inc.php

464

465

$cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode

466

// (this value will be emphasized (*2) for sql

467

// query textareas and (*1.25) for query window)

468

$cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode

469

$cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields

470

$cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox

471

$cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR

472

$cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR

473

$cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing?

474

$cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields

475

$cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse

476

// (or at the top with vertical browse)

477

$cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse

478

// (or at the bottom with vertical browse)

479

$cfg['DefaultDisplay'] = 'horizontal'; // default display direction

480

// (horizontal|vertical|horizontalflipped)

481

$cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/

482

// creating columns (tbl_properties)

483

// (horizontal|vertical)

484

485

$cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake)

486

// NOTE: CSS only works in IE browsers!

487

$cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.

488

$cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.

489

$cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)

490

491

$cfg['EditInWindow']        = TRUE;         // Set to TRUE if Edit link should open the query to edit in the query window (assuming Javascript is enabled), and to FALSE if we should edit in the right panel

492

$cfg['QueryWindowWidth'] = 550; // Width of Query window

493

$cfg['QueryWindowHeight'] = 310; // Height of Query window

494

$cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history.

495

// If FALSE, this utilizes JS-routines to display

496

// query history (lost by window close)

497

$cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup

498

// (sql|files|history|full)

499

$cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries

500

// should be kept?

501

$cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for

502

$cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for

503

// table rows.

504

$cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of

505

// the PDF page editor. Requires an IE6/Mozilla based browser.

506

507

$cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order

508

509

510

//-----------------------------------------------------------------------------

511

// custom-setup by mkkeck: 2004-05-04

512

// some specials for new icons and scrollings

513

// FIXME:

514

// 2004-05-08 rabus: We need to rearrange these variables.

515

516

$cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)?

517

$cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server)

518

// or an other string, wich should be shown in browsers window title.

519

// If not set (or empty), the PMA will get your real Host-Adress.

520

521

$cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)?

522

$cfg['MainPageIconic'] = TRUE; // show icons in list on main page and on menu tabs (true|false)?

523

$cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocu (true|false)?

524

525

// theme manager

526

$cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes'

527

// else leave empty

528

$cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty

529

// set it to true, else set it to false (default is false);

530

$cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty

531

// you can set up here an valid path to themes or 'original' for

532

// the original pma-theme

533

$cfg['ThemePerServer'] = FALSE; // allow diferent theme for each configured server

534

535

//-----------------------------------------------------------------------------

536

537

538

/**

539

* Default queries

540

* %d will be replaced by the database name.

541

* %t will be replaced by the table name.

542

* %f will be replaced by a list of field names.

543

* (%t and %f only applies to DefaultQueryTable)

544

*/

545

$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';

546

$cfg['DefaultQueryDatabase'] = '';

547

548

/**

549

* SQL Query box settings

550

* These are the links display in all of the SQL Query boxes

551

*/

552

$cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query

553

$cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries

554

$cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP

555

$cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well)

556

$cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page

557

558

559

/**

560

* Webserver upload/save/import directories

561

*/

562

$cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by

563

// phpMyAdmin. For example './upload'. Leave empty for

564

// no upload directory support. Use %u for username

565

// inclusion.

566

$cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on

567

// server. For example './save'. Leave empty for no save

568

// directory support. Use %u for username inclusion.

569

$cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import

570

// docSQL files from that directory. For example

571

// './docSQL'. Leave empty for no docSQL import support.

572

$cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files.

573

// This is needed for MS Excel export, see documentation

574

// how to enable that.

575

576

577

/**

578

* Misc. settings

579

*/

580

$cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto'

581

// does autodetection, which is a bit expensive for

582

// php < 4.3.0, but it is the only safe vay how to

583

// determine GD version.

584

/**

585

* SQL Parser Settings

586

*/

587

$cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)

588

$cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok)

589

$cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})

590

// The graphical settings are now located in themes/themename/layout.inc.php

591

592

/**

593

* If you wish to use the SQL Validator service, you should be

594

* aware of the following:

595

* All SQL statements are stored anonymously for statistical purposes.

596

597

598

*/

599

$cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available

600

$cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)

601

$cfg['SQLValidator']['password'] = ''; // Password for username

602

603

/**

604

* Developers ONLY!

605

* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/

606

*/

607

$cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available

608

$cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP

609

$cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display

610

// Anything below the threshold is not displayed

611

612

613

/**

614

* MySQL settings

615

*/

616

// Column types;

617

// varchar, tinyint, text and date are listed first, based on estimated popularity

618

$cfg['ColumnTypes'] = array(

619

'VARCHAR',

620

'TINYINT',

621

'TEXT',

622

'DATE',

623

'SMALLINT',

624

'MEDIUMINT',

625

'INT',

626

'BIGINT',

627

'FLOAT',

628

'DOUBLE',

629

'DECIMAL',

630

'DATETIME',

631

'TIMESTAMP',

632

'TIME',

633

'YEAR',

634

'CHAR',

635

'TINYBLOB',

636

'TINYTEXT',

637

'BLOB',

638

'MEDIUMBLOB',

639

'MEDIUMTEXT',

640

'LONGBLOB',

641

'LONGTEXT',

642

'ENUM',

643

'SET',

644

'BOOL'

645

);

646

647

// Attributes

648

// Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically

649

// for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php

650

651

$cfg['AttributeTypes'] = array(

652

'',

653

'BINARY',

654

'UNSIGNED',

655

'UNSIGNED ZEROFILL'

656

);

657

658

// Available functions

659

if ($cfg['ShowFunctionFields']) {

660

$cfg['Functions'] = array(

661

'ASCII',

662

'CHAR',

663

'SOUNDEX',

664

'LCASE',

665

'UCASE',

666

'NOW',

667

'PASSWORD',

668

'OLD_PASSWORD',

669

'MD5',

670

'SHA1',

671

'ENCRYPT',

672

'COMPRESS',

673

'UNCOMPRESS',

674

'RAND',

675

'LAST_INSERT_ID',

676

'COUNT',

677

'AVG',

678

'SUM',

679

'CURDATE',

680

'CURTIME',

681

'FROM_DAYS',

682

'FROM_UNIXTIME',

683

'PERIOD_ADD',

684

'PERIOD_DIFF',

685

'TO_DAYS',

686

'UNIX_TIMESTAMP',

687

'USER',

688

'WEEKDAY',

689

'CONCAT'

690

);

691

692

// Which column types will be mapped to which Group?

693

$cfg['RestrictColumnTypes'] = array(

694

'VARCHAR' => 'FUNC_CHAR',

695

'TINYINT' => 'FUNC_NUMBER',

696

'TEXT' => 'FUNC_CHAR',

697

'DATE' => 'FUNC_DATE',

698

'SMALLINT' => 'FUNC_NUMBER',

699

'MEDIUMINT' => 'FUNC_NUMBER',

700

'INT' => 'FUNC_NUMBER',

701

'BIGINT' => 'FUNC_NUMBER',

702

'FLOAT' => 'FUNC_NUMBER',

703

'DOUBLE' => 'FUNC_NUMBER',

704

'DECIMAL' => 'FUNC_NUMBER',

705

'DATETIME' => 'FUNC_DATE',

706

'TIMESTAMP' => 'FUNC_DATE',

707

'TIME' => 'FUNC_DATE',

708

'YEAR' => 'FUNC_DATE',

709

'CHAR' => 'FUNC_CHAR',

710

'TINYBLOB' => 'FUNC_CHAR',

711

'TINYTEXT' => 'FUNC_CHAR',

712

'BLOB' => 'FUNC_CHAR',

713

'MEDIUMBLOB' => 'FUNC_CHAR',

714

'MEDIUMTEXT' => 'FUNC_CHAR',

715

'LONGBLOB' => 'FUNC_CHAR',

716

'LONGTEXT' => 'FUNC_CHAR',

717

'ENUM' => '',

718

'SET' => ''

719

);

720

721

// Map above defined groups to any function

722

$cfg['RestrictFunctions'] = array(

723

'FUNC_CHAR' => array(

724

'ASCII',

725

'CHAR',

726

'SOUNDEX',

727

'LCASE',

728

'UCASE',

729

'PASSWORD',

730

'OLD_PASSWORD',

731

'MD5',

732

'SHA1',

733

'ENCRYPT',

734

'COMPRESS',

735

'UNCOMPRESS',

736

'LAST_INSERT_ID',

737

'USER',

738

'CONCAT'

739

),

740

741

'FUNC_DATE' => array(

742

'NOW',

743

'CURDATE',

744

'CURTIME',

745

'FROM_DAYS',

746

'FROM_UNIXTIME',

747

'PERIOD_ADD',

748

'PERIOD_DIFF',

749

'TO_DAYS',

750

'UNIX_TIMESTAMP',

751

'WEEKDAY'

752

),

753

754

'FUNC_NUMBER' => array(

755

'ASCII',

756

'CHAR',

757

'MD5',

758

'SHA1',

759

'ENCRYPT',

760

'RAND',

761

'LAST_INSERT_ID',

762

'UNIX_TIMESTAMP',

763

'COUNT',

764

'AVG',

765

'SUM'

766

)

767

);

768

769

// Default functions for above defined groups

770

$cfg['DefaultFunctions'] = array(

771

'FUNC_CHAR' => '',

772

'FUNC_DATE' => '',

773

'FUNC_NUMBER' => '',

774

'first_timestamp' => 'NOW'

775

);

776

777

778

} // end if

779

780

// Search operators

781

$cfg['NumOperators'] = array(

782

'=',

783

'>',

784

'>=',

785

'<',

786

'<=',

787

'!=',

788

'LIKE',

789

'NOT LIKE'

790

);

791

792

$cfg['TextOperators'] = array(

793

'LIKE',

794

'LIKE %...%',

795

'NOT LIKE',

796

'=',

797

'!=',

798

'REGEXP',

799

'NOT REGEXP'

800

);

801

802

$cfg['EnumOperators'] = array(

803

'=',

804

'!='

805

);

806

807

$cfg['SetOperators'] = array(

808

'IN',

809

'NOT IN'

810

);

811

812

$cfg['NullOperators'] = array(

813

'IS NULL',

814

'IS NOT NULL'

815

);

816

817

$cfg['UnaryOperators'] = array(

818

'IS NULL' => 1,

819

'IS NOT NULL' => 1

820

);

821

822

?>

Subversion Repositories – MLAB

(root)/Web/Maintenance/phpMyAdmin/config.inc.php

Rev 356