| 1 |
<?php |
1 |
<?php |
| 2 |
|
2 |
|
| 3 |
/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */ |
3 |
/* !!! DO NOT EDIT THIS FILE, EDIT config.inc.php INSTEAD !!! */ |
| 4 |
|
4 |
|
| 5 |
/* $Id: config.default.php,v 1.8 2005/12/16 14:07:10 lem9 Exp $ */ |
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: |
6 |
// vim: expandtab sw=4 ts=4 sts=4: |
| 7 |
|
7 |
|
| 8 |
/** |
8 |
/** |
| 9 |
* phpMyAdmin default configuration, you can copy values from here to your |
9 |
* phpMyAdmin default configuration, you can copy values from here to your |
| 10 |
* config.inc.php |
10 |
* config.inc.php |
| 11 |
* |
11 |
* |
| 12 |
* All directives are explained in Documentation.html |
12 |
* All directives are explained in Documentation.html |
| 13 |
*/ |
13 |
*/ |
| 14 |
|
14 |
|
| 15 |
|
15 |
|
| 16 |
/** |
16 |
/** |
| 17 |
* Your phpMyAdmin URL. |
17 |
* Your phpMyAdmin URL. |
| 18 |
* |
18 |
* |
| 19 |
* Complete the variable below with the full url ie |
19 |
* Complete the variable below with the full url ie |
| 20 |
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/ |
20 |
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/ |
| 21 |
* |
21 |
* |
| 22 |
* It must contain characters that are valid for a URL, and the path is |
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. |
23 |
* case sensitive on some Web servers, for example Unix-based servers. |
| 24 |
* |
24 |
* |
| 25 |
* In most cases you can leave this variable empty, as the correct value |
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 |
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 |
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 |
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. |
29 |
* an error message if phpMyAdmin cannot auto-detect the correct value. |
| 30 |
*/ |
30 |
*/ |
| 31 |
$cfg['PmaAbsoluteUri'] = ''; |
31 |
$cfg['PmaAbsoluteUri'] = ''; |
| 32 |
|
32 |
|
| 33 |
/** |
33 |
/** |
| 34 |
* Disable the default warning that is displayed on the DB Details Structure page if |
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 |
35 |
* any of the required Tables for the relationfeatures could not be found |
| 36 |
*/ |
36 |
*/ |
| 37 |
$cfg['PmaNoRelation_DisableWarning'] = FALSE; |
37 |
$cfg['PmaNoRelation_DisableWarning'] = FALSE; |
| 38 |
|
38 |
|
| 39 |
/** |
39 |
/** |
| 40 |
* The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If |
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 |
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 |
42 |
* passphrase that will be used by blowfish. The maximum length seems to be 46 |
| 43 |
* characters. |
43 |
* characters. |
| 44 |
*/ |
44 |
*/ |
| 45 |
$cfg['blowfish_secret'] = ''; |
45 |
$cfg['blowfish_secret'] = 'cookie'; |
| 46 |
|
46 |
|
| 47 |
/** |
47 |
/** |
| 48 |
* Server(s) configuration |
48 |
* Server(s) configuration |
| 49 |
*/ |
49 |
*/ |
| 50 |
$i = 0; |
50 |
$i = 0; |
| 51 |
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use |
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 |
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 |
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 |
54 |
// (including $i incrementation) serveral times. There is no need to define |
| 55 |
// full server array, just define values you need to change. |
55 |
// full server array, just define values you need to change. |
| 56 |
$i++; |
56 |
$i++; |
| 57 |
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address |
57 |
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address |
| 58 |
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port |
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 |
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') |
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') |
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 |
62 |
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection |
| 63 |
// (requires PHP >= 4.3.0) |
63 |
// (requires PHP >= 4.3.0) |
| 64 |
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings |
64 |
$cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings |
| 65 |
// (this user must have read-only |
65 |
// (this user must have read-only |
| 66 |
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" |
66 |
$cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" |
| 67 |
// and "mysql/db" tables). |
67 |
// and "mysql/db" tables). |
| 68 |
// The controluser is also |
68 |
// The controluser is also |
| 69 |
// used for all relational |
69 |
// used for all relational |
| 70 |
// features (pmadb) |
70 |
// features (pmadb) |
| 71 |
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? |
71 |
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)? |
| 72 |
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user |
72 |
$cfg['Servers'][$i]['user'] = ''; // MySQL user |
| 73 |
$cfg['Servers'][$i]['password'] = '321hehe'; // MySQL password (only needed |
73 |
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed |
| 74 |
// with 'config' auth_type) |
74 |
// with 'config' auth_type) |
| 75 |
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only |
75 |
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only |
| 76 |
// this db is displayed in left frame |
76 |
// this db is displayed in left frame |
| 77 |
// It may also be an array of db-names, where sorting order is relevant. |
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 |
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 |
79 |
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname |
| 80 |
|
80 |
|
| 81 |
$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features |
81 |
$cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features |
| 82 |
// (see scripts/create_tables.sql) |
82 |
// (see scripts/create_tables.sql) |
| 83 |
// - leave blank for no support |
83 |
// - leave blank for no support |
| 84 |
// DEFAULT: 'phpmyadmin' |
84 |
// DEFAULT: 'phpmyadmin' |
| 85 |
$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table |
85 |
$cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table |
| 86 |
// - leave blank for no bookmark support |
86 |
// - leave blank for no bookmark support |
| 87 |
// DEFAULT: 'pma_bookmark' |
87 |
// DEFAULT: 'pma_bookmark' |
| 88 |
$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) |
88 |
$cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) |
| 89 |
// - leave blank for no relation-links support |
89 |
// - leave blank for no relation-links support |
| 90 |
// DEFAULT: 'pma_relation' |
90 |
// DEFAULT: 'pma_relation' |
| 91 |
$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields |
91 |
$cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields |
| 92 |
// - leave blank for no display fields support |
92 |
// - leave blank for no display fields support |
| 93 |
// DEFAULT: 'pma_table_info' |
93 |
// DEFAULT: 'pma_table_info' |
| 94 |
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema |
94 |
$cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema |
| 95 |
// - leave blank for no PDF schema support |
95 |
// - leave blank for no PDF schema support |
| 96 |
// DEFAULT: 'pma_table_coords' |
96 |
// DEFAULT: 'pma_table_coords' |
| 97 |
$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf |
97 |
$cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf |
| 98 |
// - leave blank if you don't want to use this |
98 |
// - leave blank if you don't want to use this |
| 99 |
// DEFAULT: 'pma_pdf_pages' |
99 |
// DEFAULT: 'pma_pdf_pages' |
| 100 |
$cfg['Servers'][$i]['column_info'] = ''; // table to store column information |
100 |
$cfg['Servers'][$i]['column_info'] = ''; // table to store column information |
| 101 |
// - leave blank for no column comments/mime types |
101 |
// - leave blank for no column comments/mime types |
| 102 |
// DEFAULT: 'pma_column_info' |
102 |
// DEFAULT: 'pma_column_info' |
| 103 |
$cfg['Servers'][$i]['history'] = ''; // table to store SQL history |
103 |
$cfg['Servers'][$i]['history'] = ''; // table to store SQL history |
| 104 |
// - leave blank for no SQL query history |
104 |
// - leave blank for no SQL query history |
| 105 |
// DEFAULT: 'pma_history' |
105 |
// DEFAULT: 'pma_history' |
| 106 |
$cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables |
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 |
107 |
// are up to date. This prevents compatibility |
| 108 |
// checks and thereby increases performance. |
108 |
// checks and thereby increases performance. |
| 109 |
$cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login |
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 |
110 |
$cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use |
| 111 |
= ''; |
111 |
= ''; |
| 112 |
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults |
112 |
$cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults |
| 113 |
= array(); |
113 |
= array(); |
| 114 |
|
114 |
|
| 115 |
// If you have more than one server configured, you can set $cfg['ServerDefault'] |
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, |
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 |
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 |
118 |
// If you have only one server configured, $cfg['ServerDefault'] *MUST* be |
| 119 |
// set to that server. |
119 |
// set to that server. |
| 120 |
$cfg['ServerDefault'] = 1; // Default server (0 = no default server) |
120 |
$cfg['ServerDefault'] = 1; // Default server (0 = no default server) |
| 121 |
|
121 |
|
| 122 |
/** |
122 |
/** |
| 123 |
* Other core phpMyAdmin settings |
123 |
* Other core phpMyAdmin settings |
| 124 |
*/ |
124 |
*/ |
| 125 |
$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto') |
125 |
$cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto') |
| 126 |
$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database |
126 |
$cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database |
| 127 |
$cfg['ForceSSL'] = FALSE; // whether to force using https |
127 |
$cfg['ForceSSL'] = FALSE; // whether to force using https |
| 128 |
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit) |
128 |
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit) |
| 129 |
$cfg['MemoryLimit'] = 0; // maximum allocated bytes (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 |
130 |
$cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show |
| 131 |
// locked tables (since MySQL 3.23.30) |
131 |
// locked tables (since MySQL 3.23.30) |
| 132 |
$cfg['ShowSQL'] = TRUE; // show SQL queries as run |
132 |
$cfg['ShowSQL'] = TRUE; // show SQL queries as run |
| 133 |
$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users |
133 |
$cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users |
| 134 |
$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE' |
134 |
$cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE' |
| 135 |
$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not |
135 |
$cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not |
| 136 |
$cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds) |
136 |
$cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds) |
| 137 |
$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature |
137 |
$cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature |
| 138 |
// or not |
138 |
// or not |
| 139 |
$cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries |
139 |
$cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries |
| 140 |
// even if one of the queries failed |
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 |
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 |
142 |
// multiple-statement queries. See the libraries/import.php file for |
| 143 |
// hardcoded defaults on how many queries a statement may contain! |
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 |
144 |
$cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth |
| 145 |
|
145 |
|
| 146 |
// Left frame setup |
146 |
// Left frame setup |
| 147 |
$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the |
147 |
$cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the |
| 148 |
// current tables in the left frame. |
148 |
// current tables in the left frame. |
| 149 |
$cfg['LeftFrameDBTree'] = TRUE; // turn the select-based light menu into a tree |
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 |
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 |
151 |
$cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes |
| 152 |
// to split/nest tables into multiple categories |
152 |
// to split/nest tables into multiple categories |
| 153 |
$cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting |
153 |
$cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting |
| 154 |
// up tables by the above Separator |
154 |
// up tables by the above Separator |
| 155 |
$cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame |
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 |
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 |
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 |
158 |
// table/db names. Setting ShowTooltipAliasTB to 'nested' will only |
| 159 |
// use the Aliases for nested descriptors, not the table itself. |
159 |
// use the Aliases for nested descriptors, not the table itself. |
| 160 |
|
160 |
|
| 161 |
$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame |
161 |
$cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame |
| 162 |
$cfg['LeftDisplayServers'] = FALSE; // display server choice 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 |
163 |
$cfg['DisplayServersList'] = FALSE; // server choice as links |
| 164 |
|
164 |
|
| 165 |
// In the main frame, at startup... |
165 |
// In the main frame, at startup... |
| 166 |
$cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in |
166 |
$cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in |
| 167 |
// the pages about database details and table |
167 |
// the pages about database details and table |
| 168 |
// properties |
168 |
// properties |
| 169 |
$cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for |
169 |
$cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for |
| 170 |
$cfg['ShowChgPassword'] = FALSE; // simple users or not |
170 |
$cfg['ShowChgPassword'] = FALSE; // simple users or not |
| 171 |
$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty) |
171 |
$cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty) |
| 172 |
|
172 |
|
| 173 |
// In browse mode... |
173 |
// In browse mode... |
| 174 |
$cfg['ShowBlob'] = FALSE; // display blob field contents |
174 |
$cfg['ShowBlob'] = FALSE; // display blob field contents |
| 175 |
$cfg['NavigationBarIconic'] = 'both'; // Use icons instead of text for the navigation bar buttons |
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') |
176 |
// and on right panel top menu (server db table) (TRUE|FALSE|'both') |
| 177 |
$cfg['ShowAll'] = FALSE; // allows to display all the rows |
177 |
$cfg['ShowAll'] = FALSE; // allows to display all the rows |
| 178 |
$cfg['MaxRows'] = 30; // maximum number of rows to display |
178 |
$cfg['MaxRows'] = 30; // maximum number of rows to display |
| 179 |
$cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid |
179 |
$cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid |
| 180 |
// values are 'ASC', 'DESC' or 'SMART' -ie |
180 |
// values are 'ASC', 'DESC' or 'SMART' -ie |
| 181 |
// descending order for fields of type |
181 |
// descending order for fields of type |
| 182 |
// TIME, DATE, DATETIME & TIMESTAMP, |
182 |
// TIME, DATE, DATETIME & TIMESTAMP, |
| 183 |
// ascending order else-) |
183 |
// ascending order else-) |
| 184 |
|
184 |
|
| 185 |
// In edit mode... |
185 |
// In edit mode... |
| 186 |
$cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields |
186 |
$cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields |
| 187 |
// valid values are: |
187 |
// valid values are: |
| 188 |
// FALSE allow editing |
188 |
// FALSE allow editing |
| 189 |
// 'blob' allow editing except for BLOB fields |
189 |
// 'blob' allow editing except for BLOB fields |
| 190 |
// 'all' disallow editing |
190 |
// 'all' disallow editing |
| 191 |
$cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode |
191 |
$cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode |
| 192 |
$cfg['CharEditing'] = 'input'; |
192 |
$cfg['CharEditing'] = 'input'; |
| 193 |
// Which editor should be used for CHAR/VARCHAR fields: |
193 |
// Which editor should be used for CHAR/VARCHAR fields: |
| 194 |
// input - allows limiting of input length |
194 |
// input - allows limiting of input length |
| 195 |
// textarea - allows newlines in fields |
195 |
// textarea - allows newlines in fields |
| 196 |
$cfg['InsertRows'] = 2; // How many rows can be inserted at one time |
196 |
$cfg['InsertRows'] = 2; // How many rows can be inserted at one time |
| 197 |
|
197 |
|
| 198 |
$cfg['ForeignKeyDropdownOrder'] = // Sort order for items in a foreign-key dropdown box. |
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. |
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 |
200 |
$cfg['ForeignKeyMaxLimit'] = 100; // A dropdown will be used if fewer items are present |
| 201 |
|
201 |
|
| 202 |
|
202 |
|
| 203 |
// For the export features... |
203 |
// For the export features... |
| 204 |
$cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip |
204 |
$cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip |
| 205 |
$cfg['GZipDump'] = TRUE; // compression for |
205 |
$cfg['GZipDump'] = TRUE; // compression for |
| 206 |
$cfg['BZipDump'] = TRUE; // dump files |
206 |
$cfg['BZipDump'] = TRUE; // dump files |
| 207 |
$cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on |
207 |
$cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on |
| 208 |
// fly without need for much memory. |
208 |
// fly without need for much memory. |
| 209 |
// If you encounter problems with |
209 |
// If you encounter problems with |
| 210 |
// created gzip/bzip2 files disable |
210 |
// created gzip/bzip2 files disable |
| 211 |
// this feature. |
211 |
// this feature. |
| 212 |
|
212 |
|
| 213 |
// Tabs display settings |
213 |
// Tabs display settings |
| 214 |
$cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs |
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') |
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? |
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) |
217 |
// (a value larger than 1 results in some information being hidden) |
| 218 |
|
218 |
|
| 219 |
$cfg['DefaultTabServer'] = 'main.php'; |
219 |
$cfg['DefaultTabServer'] = 'main.php'; |
| 220 |
// Possible values: |
220 |
// Possible values: |
| 221 |
// 'main.php' = the welcome page |
221 |
// 'main.php' = the welcome page |
| 222 |
// (recommended for multiuser setups) |
222 |
// (recommended for multiuser setups) |
| 223 |
// 'server_databases.php' = list of databases |
223 |
// 'server_databases.php' = list of databases |
| 224 |
// 'server_status.php' = runtime information |
224 |
// 'server_status.php' = runtime information |
| 225 |
// 'server_variables.php' = MySQL server variables |
225 |
// 'server_variables.php' = MySQL server variables |
| 226 |
// 'server_privileges.php' = user management |
226 |
// 'server_privileges.php' = user management |
| 227 |
// 'server_processlist.php' = process list |
227 |
// 'server_processlist.php' = process list |
| 228 |
$cfg['DefaultTabDatabase'] = 'db_details_structure.php'; |
228 |
$cfg['DefaultTabDatabase'] = 'db_details_structure.php'; |
| 229 |
// Possible values: |
229 |
// Possible values: |
| 230 |
// 'db_details_structure.php' = tables list |
230 |
// 'db_details_structure.php' = tables list |
| 231 |
// 'db_details.php' = sql form |
231 |
// 'db_details.php' = sql form |
| 232 |
// 'db_search.php' = search query |
232 |
// 'db_search.php' = search query |
| 233 |
// 'db_operations.php' = operations on database |
233 |
// 'db_operations.php' = operations on database |
| 234 |
$cfg['DefaultTabTable'] = 'tbl_properties_structure.php'; |
234 |
$cfg['DefaultTabTable'] = 'tbl_properties_structure.php'; |
| 235 |
// Possible values: |
235 |
// Possible values: |
| 236 |
// 'tbl_properties_structure.php' = fields list |
236 |
// 'tbl_properties_structure.php' = fields list |
| 237 |
// 'tbl_properties.php' = sql form |
237 |
// 'tbl_properties.php' = sql form |
| 238 |
// 'tbl_select.php' = select page |
238 |
// 'tbl_select.php' = select page |
| 239 |
// 'tbl_change.php' = insert row page |
239 |
// 'tbl_change.php' = insert row page |
| 240 |
// 'sql.php' = browse page |
240 |
// 'sql.php' = browse page |
| 241 |
|
241 |
|
| 242 |
/** |
242 |
/** |
| 243 |
* Export defaults |
243 |
* Export defaults |
| 244 |
*/ |
244 |
*/ |
| 245 |
|
245 |
|
| 246 |
$cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword |
246 |
$cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword |
| 247 |
$cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2 |
247 |
$cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2 |
| 248 |
|
248 |
|
| 249 |
$cfg['Export']['asfile'] = FALSE; |
249 |
$cfg['Export']['asfile'] = FALSE; |
| 250 |
$cfg['Export']['charset'] = ''; |
250 |
$cfg['Export']['charset'] = ''; |
| 251 |
$cfg['Export']['onserver'] = FALSE; |
251 |
$cfg['Export']['onserver'] = FALSE; |
| 252 |
$cfg['Export']['onserver_overwrite'] = FALSE; |
252 |
$cfg['Export']['onserver_overwrite'] = FALSE; |
| 253 |
$cfg['Export']['remember_file_template'] = TRUE; |
253 |
$cfg['Export']['remember_file_template'] = TRUE; |
| 254 |
$cfg['Export']['file_template_table'] = '__TABLE__'; |
254 |
$cfg['Export']['file_template_table'] = '__TABLE__'; |
| 255 |
$cfg['Export']['file_template_database'] = '__DB__'; |
255 |
$cfg['Export']['file_template_database'] = '__DB__'; |
| 256 |
$cfg['Export']['file_template_server'] = '__SERVER__'; |
256 |
$cfg['Export']['file_template_server'] = '__SERVER__'; |
| 257 |
|
257 |
|
| 258 |
$cfg['Export']['htmlexcel_columns'] = FALSE; |
258 |
$cfg['Export']['htmlexcel_columns'] = FALSE; |
| 259 |
$cfg['Export']['htmlexcel_null'] = 'NULL'; |
259 |
$cfg['Export']['htmlexcel_null'] = 'NULL'; |
| 260 |
|
260 |
|
| 261 |
$cfg['Export']['htmlword_structure'] = TRUE; |
261 |
$cfg['Export']['htmlword_structure'] = TRUE; |
| 262 |
$cfg['Export']['htmlword_data'] = TRUE; |
262 |
$cfg['Export']['htmlword_data'] = TRUE; |
| 263 |
$cfg['Export']['htmlword_columns'] = FALSE; |
263 |
$cfg['Export']['htmlword_columns'] = FALSE; |
| 264 |
$cfg['Export']['htmlword_null'] = 'NULL'; |
264 |
$cfg['Export']['htmlword_null'] = 'NULL'; |
| 265 |
|
265 |
|
| 266 |
$cfg['Export']['xls_columns'] = FALSE; |
266 |
$cfg['Export']['xls_columns'] = FALSE; |
| 267 |
$cfg['Export']['xls_null'] = 'NULL'; |
267 |
$cfg['Export']['xls_null'] = 'NULL'; |
| 268 |
|
268 |
|
| 269 |
$cfg['Export']['csv_columns'] = FALSE; |
269 |
$cfg['Export']['csv_columns'] = FALSE; |
| 270 |
$cfg['Export']['csv_null'] = 'NULL'; |
270 |
$cfg['Export']['csv_null'] = 'NULL'; |
| 271 |
$cfg['Export']['csv_separator'] = ';'; |
271 |
$cfg['Export']['csv_separator'] = ';'; |
| 272 |
$cfg['Export']['csv_enclosed'] = '"'; |
272 |
$cfg['Export']['csv_enclosed'] = '"'; |
| 273 |
$cfg['Export']['csv_escaped'] = '\\'; |
273 |
$cfg['Export']['csv_escaped'] = '\\'; |
| 274 |
$cfg['Export']['csv_terminated'] = 'AUTO'; |
274 |
$cfg['Export']['csv_terminated'] = 'AUTO'; |
| 275 |
$cfg['Export']['excel_columns'] = FALSE; |
275 |
$cfg['Export']['excel_columns'] = FALSE; |
| 276 |
$cfg['Export']['excel_null'] = 'NULL'; |
276 |
$cfg['Export']['excel_null'] = 'NULL'; |
| 277 |
$cfg['Export']['excel_edition'] = 'win'; // win/mac |
277 |
$cfg['Export']['excel_edition'] = 'win'; // win/mac |
| 278 |
|
278 |
|
| 279 |
$cfg['Export']['latex_structure'] = TRUE; |
279 |
$cfg['Export']['latex_structure'] = TRUE; |
| 280 |
$cfg['Export']['latex_data'] = TRUE; |
280 |
$cfg['Export']['latex_data'] = TRUE; |
| 281 |
$cfg['Export']['latex_columns'] = TRUE; |
281 |
$cfg['Export']['latex_columns'] = TRUE; |
| 282 |
$cfg['Export']['latex_relation'] = TRUE; |
282 |
$cfg['Export']['latex_relation'] = TRUE; |
| 283 |
$cfg['Export']['latex_comments'] = TRUE; |
283 |
$cfg['Export']['latex_comments'] = TRUE; |
| 284 |
$cfg['Export']['latex_mime'] = TRUE; |
284 |
$cfg['Export']['latex_mime'] = TRUE; |
| 285 |
$cfg['Export']['latex_null'] = '\textit{NULL}'; |
285 |
$cfg['Export']['latex_null'] = '\textit{NULL}'; |
| 286 |
$cfg['Export']['latex_caption'] = TRUE; |
286 |
$cfg['Export']['latex_caption'] = TRUE; |
| 287 |
$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data'; |
287 |
$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data'; |
| 288 |
$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure'; |
288 |
$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure'; |
| 289 |
|
289 |
|
| 290 |
$cfg['Export']['sql_structure'] = TRUE; |
290 |
$cfg['Export']['sql_structure'] = TRUE; |
| 291 |
$cfg['Export']['sql_data'] = TRUE; |
291 |
$cfg['Export']['sql_data'] = TRUE; |
| 292 |
$cfg['Export']['sql_compat'] = 'NONE'; |
292 |
$cfg['Export']['sql_compat'] = 'NONE'; |
| 293 |
$cfg['Export']['sql_disable_fk'] = FALSE; |
293 |
$cfg['Export']['sql_disable_fk'] = FALSE; |
| 294 |
$cfg['Export']['sql_use_transaction'] = FALSE; |
294 |
$cfg['Export']['sql_use_transaction'] = FALSE; |
| 295 |
$cfg['Export']['sql_drop_database'] = FALSE; |
295 |
$cfg['Export']['sql_drop_database'] = FALSE; |
| 296 |
$cfg['Export']['sql_drop_table'] = FALSE; |
296 |
$cfg['Export']['sql_drop_table'] = FALSE; |
| 297 |
$cfg['Export']['sql_if_not_exists'] = FALSE; |
297 |
$cfg['Export']['sql_if_not_exists'] = FALSE; |
| 298 |
$cfg['Export']['sql_auto_increment'] = TRUE; |
298 |
$cfg['Export']['sql_auto_increment'] = TRUE; |
| 299 |
$cfg['Export']['sql_backquotes'] = TRUE; |
299 |
$cfg['Export']['sql_backquotes'] = TRUE; |
| 300 |
$cfg['Export']['sql_dates'] = FALSE; |
300 |
$cfg['Export']['sql_dates'] = FALSE; |
| 301 |
$cfg['Export']['sql_relation'] = FALSE; |
301 |
$cfg['Export']['sql_relation'] = FALSE; |
| 302 |
$cfg['Export']['sql_columns'] = TRUE; |
302 |
$cfg['Export']['sql_columns'] = TRUE; |
| 303 |
$cfg['Export']['sql_delayed'] = FALSE; |
303 |
$cfg['Export']['sql_delayed'] = FALSE; |
| 304 |
$cfg['Export']['sql_ignore'] = FALSE; |
304 |
$cfg['Export']['sql_ignore'] = FALSE; |
| 305 |
$cfg['Export']['sql_hex_for_binary'] = TRUE; |
305 |
$cfg['Export']['sql_hex_for_binary'] = TRUE; |
| 306 |
$cfg['Export']['sql_type'] = 'insert'; // insert/update/replace |
306 |
$cfg['Export']['sql_type'] = 'insert'; // insert/update/replace |
| 307 |
$cfg['Export']['sql_extended'] = TRUE; |
307 |
$cfg['Export']['sql_extended'] = TRUE; |
| 308 |
$cfg['Export']['sql_max_query_size'] = 50000; |
308 |
$cfg['Export']['sql_max_query_size'] = 50000; |
| 309 |
$cfg['Export']['sql_comments'] = FALSE; |
309 |
$cfg['Export']['sql_comments'] = FALSE; |
| 310 |
$cfg['Export']['sql_mime'] = FALSE; |
310 |
$cfg['Export']['sql_mime'] = FALSE; |
| 311 |
$cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line |
311 |
$cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line |
| 312 |
|
312 |
|
| 313 |
$cfg['Export']['pdf_structure'] = FALSE; |
313 |
$cfg['Export']['pdf_structure'] = FALSE; |
| 314 |
$cfg['Export']['pdf_data'] = TRUE; |
314 |
$cfg['Export']['pdf_data'] = TRUE; |
| 315 |
$cfg['Export']['pdf_report_title'] = ''; |
315 |
$cfg['Export']['pdf_report_title'] = ''; |
| 316 |
|
316 |
|
| 317 |
/** |
317 |
/** |
| 318 |
* Import defaults |
318 |
* Import defaults |
| 319 |
*/ |
319 |
*/ |
| 320 |
$cfg['Import']['format'] = 'sql'; |
320 |
$cfg['Import']['format'] = 'sql'; |
| 321 |
$cfg['Import']['allow_interrupt'] = TRUE; |
321 |
$cfg['Import']['allow_interrupt'] = TRUE; |
| 322 |
$cfg['Import']['skip_queries'] = '0'; |
322 |
$cfg['Import']['skip_queries'] = '0'; |
| 323 |
$cfg['Import']['csv_replace'] = FALSE; |
323 |
$cfg['Import']['csv_replace'] = FALSE; |
| 324 |
$cfg['Import']['csv_terminated'] = ';'; |
324 |
$cfg['Import']['csv_terminated'] = ';'; |
| 325 |
$cfg['Import']['csv_enclosed'] = '"'; |
325 |
$cfg['Import']['csv_enclosed'] = '"'; |
| 326 |
$cfg['Import']['csv_escaped'] = '\\'; |
326 |
$cfg['Import']['csv_escaped'] = '\\'; |
| 327 |
$cfg['Import']['csv_new_line'] = 'auto'; |
327 |
$cfg['Import']['csv_new_line'] = 'auto'; |
| 328 |
$cfg['Import']['csv_columns'] = ''; |
328 |
$cfg['Import']['csv_columns'] = ''; |
| 329 |
$cfg['Import']['ldi_replace'] = FALSE; |
329 |
$cfg['Import']['ldi_replace'] = FALSE; |
| 330 |
$cfg['Import']['ldi_terminated'] = ';'; |
330 |
$cfg['Import']['ldi_terminated'] = ';'; |
| 331 |
$cfg['Import']['ldi_enclosed'] = '"'; |
331 |
$cfg['Import']['ldi_enclosed'] = '"'; |
| 332 |
$cfg['Import']['ldi_escaped'] = '\\'; |
332 |
$cfg['Import']['ldi_escaped'] = '\\'; |
| 333 |
$cfg['Import']['ldi_new_line'] = 'auto'; |
333 |
$cfg['Import']['ldi_new_line'] = 'auto'; |
| 334 |
$cfg['Import']['ldi_columns'] = ''; |
334 |
$cfg['Import']['ldi_columns'] = ''; |
| 335 |
$cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing |
335 |
$cfg['Import']['ldi_local_option'] = 'auto'; // 'auto' for autodetection, TRUE or FALSE for forcing |
| 336 |
|
336 |
|
| 337 |
|
337 |
|
| 338 |
/** |
338 |
/** |
| 339 |
* Link to the official MySQL documentation. |
339 |
* Link to the official MySQL documentation. |
| 340 |
* Be sure to include no trailing slash on the path. |
340 |
* Be sure to include no trailing slash on the path. |
| 341 |
* See http://dev.mysql.com/doc/ for more information |
341 |
* See http://dev.mysql.com/doc/ for more information |
| 342 |
* about MySQL manuals and their types. |
342 |
* about MySQL manuals and their types. |
| 343 |
*/ |
343 |
*/ |
| 344 |
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman'; |
344 |
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman'; |
| 345 |
|
345 |
|
| 346 |
/** |
346 |
/** |
| 347 |
* Type of MySQL documentation: |
347 |
* Type of MySQL documentation: |
| 348 |
* viewable - "viewable online", current one used on MySQL website |
348 |
* viewable - "viewable online", current one used on MySQL website |
| 349 |
* searchable - "Searchable, with user comments" |
349 |
* searchable - "Searchable, with user comments" |
| 350 |
* chapters - "HTML, one page per chapter" |
350 |
* chapters - "HTML, one page per chapter" |
| 351 |
* chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release |
351 |
* chapters_old - "HTML, one page per chapter", format used prior to MySQL 5.0 release |
| 352 |
* big - "HTML, all on one page" |
352 |
* big - "HTML, all on one page" |
| 353 |
* old - old style used in phpMyAdmin 2.3.0 and sooner |
353 |
* old - old style used in phpMyAdmin 2.3.0 and sooner |
| 354 |
* none - do not show documentation links |
354 |
* none - do not show documentation links |
| 355 |
*/ |
355 |
*/ |
| 356 |
$cfg['MySQLManualType'] = 'viewable'; |
356 |
$cfg['MySQLManualType'] = 'viewable'; |
| 357 |
|
357 |
|
| 358 |
|
358 |
|
| 359 |
/** |
359 |
/** |
| 360 |
* PDF options |
360 |
* PDF options |
| 361 |
*/ |
361 |
*/ |
| 362 |
$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal'); |
362 |
$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal'); |
| 363 |
$cfg['PDFDefaultPageSize'] = 'A4'; |
363 |
$cfg['PDFDefaultPageSize'] = 'A4'; |
| 364 |
|
364 |
|
| 365 |
|
365 |
|
| 366 |
/** |
366 |
/** |
| 367 |
* Language and charset conversion settings |
367 |
* Language and charset conversion settings |
| 368 |
*/ |
368 |
*/ |
| 369 |
// Default language to use, if not browser-defined or user-defined |
369 |
// Default language to use, if not browser-defined or user-defined |
| 370 |
$cfg['DefaultLang'] = 'en-iso-8859-1'; |
370 |
$cfg['DefaultLang'] = 'en-iso-8859-1'; |
| 371 |
|
371 |
|
| 372 |
// Default connection collation (used for MySQL >= 4.1) |
372 |
// Default connection collation (used for MySQL >= 4.1) |
| 373 |
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci'; |
373 |
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci'; |
| 374 |
|
374 |
|
| 375 |
// Force: always use this language - must be defined in |
375 |
// Force: always use this language - must be defined in |
| 376 |
// libraries/select_lang.lib.php |
376 |
// libraries/select_lang.lib.php |
| 377 |
// $cfg['Lang'] = 'en-iso-8859-1'; |
377 |
// $cfg['Lang'] = 'en-iso-8859-1'; |
| 378 |
|
378 |
|
| 379 |
// Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and |
379 |
// Regullar expression to limit listed languages, eg. '^(cs|en)' for Czech and |
| 380 |
// English only |
380 |
// English only |
| 381 |
$cfg['FilterLanguages'] = ''; |
381 |
$cfg['FilterLanguages'] = ''; |
| 382 |
|
382 |
|
| 383 |
// Default charset to use for recoding of MySQL queries, does not take |
383 |
// Default charset to use for recoding of MySQL queries, does not take |
| 384 |
// any effect when charsets recoding is switched off by |
384 |
// any effect when charsets recoding is switched off by |
| 385 |
// $cfg['AllowAnywhereRecoding'] or in language file |
385 |
// $cfg['AllowAnywhereRecoding'] or in language file |
| 386 |
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own) |
386 |
// (see $cfg['AvailableCharsets'] to possible choices, you can add your own) |
| 387 |
$cfg['DefaultCharset'] = 'iso-8859-1'; |
387 |
$cfg['DefaultCharset'] = 'iso-8859-1'; |
| 388 |
|
388 |
|
| 389 |
// Allow charset recoding of MySQL queries, must be also enabled in language |
389 |
// Allow charset recoding of MySQL queries, must be also enabled in language |
| 390 |
// file to make harder using other language files than unicode. |
390 |
// file to make harder using other language files than unicode. |
| 391 |
// Default value is FALSE to avoid problems on servers without the iconv |
391 |
// Default value is FALSE to avoid problems on servers without the iconv |
| 392 |
// extension and where dl() is not supported |
392 |
// extension and where dl() is not supported |
| 393 |
$cfg['AllowAnywhereRecoding'] = FALSE; |
393 |
$cfg['AllowAnywhereRecoding'] = FALSE; |
| 394 |
|
394 |
|
| 395 |
// You can select here which functions will be used for charset conversion. |
395 |
// You can select here which functions will be used for charset conversion. |
| 396 |
// Possible values are: |
396 |
// Possible values are: |
| 397 |
// auto - automatically use available one (first is tested iconv, then |
397 |
// auto - automatically use available one (first is tested iconv, then |
| 398 |
// recode) |
398 |
// recode) |
| 399 |
// iconv - use iconv or libiconv functions |
399 |
// iconv - use iconv or libiconv functions |
| 400 |
// recode - use recode_string function |
400 |
// recode - use recode_string function |
| 401 |
$cfg['RecodingEngine'] = 'auto'; |
401 |
$cfg['RecodingEngine'] = 'auto'; |
| 402 |
|
402 |
|
| 403 |
// Specify some parameters for iconv used in charset conversion. See iconv |
403 |
// Specify some parameters for iconv used in charset conversion. See iconv |
| 404 |
// documentation for details: |
404 |
// documentation for details: |
| 405 |
// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html |
405 |
// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html |
| 406 |
$cfg['IconvExtraParams'] = '//TRANSLIT'; |
406 |
$cfg['IconvExtraParams'] = '//TRANSLIT'; |
| 407 |
|
407 |
|
| 408 |
// Available charsets for MySQL conversion. currently contains all which could |
408 |
// Available charsets for MySQL conversion. currently contains all which could |
| 409 |
// be found in lang/* files and few more. |
409 |
// be found in lang/* files and few more. |
| 410 |
// Charsets will be shown in same order as here listed, so if you frequently |
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. |
411 |
// use some of these move them to the top. |
| 412 |
$cfg['AvailableCharsets'] = array( |
412 |
$cfg['AvailableCharsets'] = array( |
| 413 |
'iso-8859-1', |
413 |
'iso-8859-1', |
| 414 |
'iso-8859-2', |
414 |
'iso-8859-2', |
| 415 |
'iso-8859-3', |
415 |
'iso-8859-3', |
| 416 |
'iso-8859-4', |
416 |
'iso-8859-4', |
| 417 |
'iso-8859-5', |
417 |
'iso-8859-5', |
| 418 |
'iso-8859-6', |
418 |
'iso-8859-6', |
| 419 |
'iso-8859-7', |
419 |
'iso-8859-7', |
| 420 |
'iso-8859-8', |
420 |
'iso-8859-8', |
| 421 |
'iso-8859-9', |
421 |
'iso-8859-9', |
| 422 |
'iso-8859-10', |
422 |
'iso-8859-10', |
| 423 |
'iso-8859-11', |
423 |
'iso-8859-11', |
| 424 |
'iso-8859-12', |
424 |
'iso-8859-12', |
| 425 |
'iso-8859-13', |
425 |
'iso-8859-13', |
| 426 |
'iso-8859-14', |
426 |
'iso-8859-14', |
| 427 |
'iso-8859-15', |
427 |
'iso-8859-15', |
| 428 |
'windows-1250', |
428 |
'windows-1250', |
| 429 |
'windows-1251', |
429 |
'windows-1251', |
| 430 |
'windows-1252', |
430 |
'windows-1252', |
| 431 |
'windows-1256', |
431 |
'windows-1256', |
| 432 |
'windows-1257', |
432 |
'windows-1257', |
| 433 |
'koi8-r', |
433 |
'koi8-r', |
| 434 |
'big5', |
434 |
'big5', |
| 435 |
'gb2312', |
435 |
'gb2312', |
| 436 |
'utf-16', |
436 |
'utf-16', |
| 437 |
'utf-8', |
437 |
'utf-8', |
| 438 |
'utf-7', |
438 |
'utf-7', |
| 439 |
'x-user-defined', |
439 |
'x-user-defined', |
| 440 |
'euc-jp', |
440 |
'euc-jp', |
| 441 |
'ks_c_5601-1987', |
441 |
'ks_c_5601-1987', |
| 442 |
'tis-620', |
442 |
'tis-620', |
| 443 |
'SHIFT_JIS' |
443 |
'SHIFT_JIS' |
| 444 |
); |
444 |
); |
| 445 |
|
445 |
|
| 446 |
/** |
446 |
/** |
| 447 |
* Customization & design |
447 |
* Customization & design |
| 448 |
* |
448 |
* |
| 449 |
* The graphical settings are now located in themes/themename/layout.inc.php |
449 |
* The graphical settings are now located in themes/themename/layout.inc.php |
| 450 |
*/ |
450 |
*/ |
| 451 |
|
451 |
|
| 452 |
$cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer |
452 |
$cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer |
| 453 |
// (used when LeftFrameLight is FALSE) |
453 |
// (used when LeftFrameLight is FALSE) |
| 454 |
// see also LeftPointerColor |
454 |
// see also LeftPointerColor |
| 455 |
// in layout.inc.php |
455 |
// in layout.inc.php |
| 456 |
|
456 |
|
| 457 |
$cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer |
457 |
$cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer |
| 458 |
// see also BrowsePointerColor |
458 |
// see also BrowsePointerColor |
| 459 |
// in layout.inc.php |
459 |
// in layout.inc.php |
| 460 |
|
460 |
|
| 461 |
$cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker |
461 |
$cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker |
| 462 |
// see also BrowseMarkerColor |
462 |
// see also BrowseMarkerColor |
| 463 |
// in layout.inc.php |
463 |
// in layout.inc.php |
| 464 |
|
464 |
|
| 465 |
$cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode |
465 |
$cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode |
| 466 |
// (this value will be emphasized (*2) for sql |
466 |
// (this value will be emphasized (*2) for sql |
| 467 |
// query textareas and (*1.25) for query window) |
467 |
// query textareas and (*1.25) for query window) |
| 468 |
$cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode |
468 |
$cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode |
| 469 |
$cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields |
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 |
470 |
$cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox |
| 471 |
$cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR |
471 |
$cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR |
| 472 |
$cfg['CharTextareaRows'] = 2; // textarea size (rows) 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? |
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 |
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 |
475 |
$cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse |
| 476 |
// (or at the top with vertical browse) |
476 |
// (or at the top with vertical browse) |
| 477 |
$cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse |
477 |
$cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse |
| 478 |
// (or at the bottom with vertical browse) |
478 |
// (or at the bottom with vertical browse) |
| 479 |
$cfg['DefaultDisplay'] = 'horizontal'; // default display direction |
479 |
$cfg['DefaultDisplay'] = 'horizontal'; // default display direction |
| 480 |
// (horizontal|vertical|horizontalflipped) |
480 |
// (horizontal|vertical|horizontalflipped) |
| 481 |
$cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/ |
481 |
$cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/ |
| 482 |
// creating columns (tbl_properties) |
482 |
// creating columns (tbl_properties) |
| 483 |
// (horizontal|vertical) |
483 |
// (horizontal|vertical) |
| 484 |
|
484 |
|
| 485 |
$cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake) |
485 |
$cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake) |
| 486 |
// NOTE: CSS only works in IE browsers! |
486 |
// NOTE: CSS only works in IE browsers! |
| 487 |
$cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode. |
487 |
$cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode. |
| 488 |
$cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' 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) |
489 |
$cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate) |
| 490 |
|
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 |
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 |
492 |
$cfg['QueryWindowWidth'] = 550; // Width of Query window |
| 493 |
$cfg['QueryWindowHeight'] = 310; // Height 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. |
494 |
$cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history. |
| 495 |
// If FALSE, this utilizes JS-routines to display |
495 |
// If FALSE, this utilizes JS-routines to display |
| 496 |
// query history (lost by window close) |
496 |
// query history (lost by window close) |
| 497 |
$cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup |
497 |
$cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup |
| 498 |
// (sql|files|history|full) |
498 |
// (sql|files|history|full) |
| 499 |
$cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries |
499 |
$cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries |
| 500 |
// should be kept? |
500 |
// should be kept? |
| 501 |
$cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for |
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 |
502 |
$cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for |
| 503 |
// table rows. |
503 |
// table rows. |
| 504 |
$cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of |
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. |
505 |
// the PDF page editor. Requires an IE6/Mozilla based browser. |
| 506 |
|
506 |
|
| 507 |
$cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order |
507 |
$cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order |
| 508 |
|
508 |
|
| 509 |
|
509 |
|
| 510 |
//----------------------------------------------------------------------------- |
510 |
//----------------------------------------------------------------------------- |
| 511 |
// custom-setup by mkkeck: 2004-05-04 |
511 |
// custom-setup by mkkeck: 2004-05-04 |
| 512 |
// some specials for new icons and scrollings |
512 |
// some specials for new icons and scrollings |
| 513 |
// FIXME: |
513 |
// FIXME: |
| 514 |
// 2004-05-08 rabus: We need to rearrange these variables. |
514 |
// 2004-05-08 rabus: We need to rearrange these variables. |
| 515 |
|
515 |
|
| 516 |
$cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)? |
516 |
$cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)? |
| 517 |
$cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server) |
517 |
$cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server) |
| 518 |
// or an other string, wich should be shown in browsers window title. |
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. |
519 |
// If not set (or empty), the PMA will get your real Host-Adress. |
| 520 |
|
520 |
|
| 521 |
$cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)? |
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)? |
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)? |
523 |
$cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocu (true|false)? |
| 524 |
|
524 |
|
| 525 |
// theme manager |
525 |
// theme manager |
| 526 |
$cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes' |
526 |
$cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes' |
| 527 |
// else leave empty |
527 |
// else leave empty |
| 528 |
$cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not 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); |
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 |
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 |
531 |
// you can set up here an valid path to themes or 'original' for |
| 532 |
// the original pma-theme |
532 |
// the original pma-theme |
| 533 |
$cfg['ThemePerServer'] = FALSE; // allow diferent theme for each configured server |
533 |
$cfg['ThemePerServer'] = FALSE; // allow diferent theme for each configured server |
| 534 |
|
534 |
|
| 535 |
//----------------------------------------------------------------------------- |
535 |
//----------------------------------------------------------------------------- |
| 536 |
|
536 |
|
| 537 |
|
537 |
|
| 538 |
/** |
538 |
/** |
| 539 |
* Default queries |
539 |
* Default queries |
| 540 |
* %d will be replaced by the database name. |
540 |
* %d will be replaced by the database name. |
| 541 |
* %t will be replaced by the table name. |
541 |
* %t will be replaced by the table name. |
| 542 |
* %f will be replaced by a list of field names. |
542 |
* %f will be replaced by a list of field names. |
| 543 |
* (%t and %f only applies to DefaultQueryTable) |
543 |
* (%t and %f only applies to DefaultQueryTable) |
| 544 |
*/ |
544 |
*/ |
| 545 |
$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1'; |
545 |
$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1'; |
| 546 |
$cfg['DefaultQueryDatabase'] = ''; |
546 |
$cfg['DefaultQueryDatabase'] = ''; |
| 547 |
|
547 |
|
| 548 |
/** |
548 |
/** |
| 549 |
* SQL Query box settings |
549 |
* SQL Query box settings |
| 550 |
* These are the links display in all of the SQL Query boxes |
550 |
* These are the links display in all of the SQL Query boxes |
| 551 |
*/ |
551 |
*/ |
| 552 |
$cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query |
552 |
$cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query |
| 553 |
$cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries |
553 |
$cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries |
| 554 |
$cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP |
554 |
$cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP |
| 555 |
$cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well) |
555 |
$cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well) |
| 556 |
$cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page |
556 |
$cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page |
| 557 |
|
557 |
|
| 558 |
|
558 |
|
| 559 |
/** |
559 |
/** |
| 560 |
* Webserver upload/save/import directories |
560 |
* Webserver upload/save/import directories |
| 561 |
*/ |
561 |
*/ |
| 562 |
$cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by |
562 |
$cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by |
| 563 |
// phpMyAdmin. For example './upload'. Leave empty for |
563 |
// phpMyAdmin. For example './upload'. Leave empty for |
| 564 |
// no upload directory support. Use %u for username |
564 |
// no upload directory support. Use %u for username |
| 565 |
// inclusion. |
565 |
// inclusion. |
| 566 |
$cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on |
566 |
$cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on |
| 567 |
// server. For example './save'. Leave empty for no save |
567 |
// server. For example './save'. Leave empty for no save |
| 568 |
// directory support. Use %u for username inclusion. |
568 |
// directory support. Use %u for username inclusion. |
| 569 |
$cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import |
569 |
$cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import |
| 570 |
// docSQL files from that directory. For example |
570 |
// docSQL files from that directory. For example |
| 571 |
// './docSQL'. Leave empty for no docSQL import support. |
571 |
// './docSQL'. Leave empty for no docSQL import support. |
| 572 |
$cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files. |
572 |
$cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files. |
| 573 |
// This is needed for MS Excel export, see documentation |
573 |
// This is needed for MS Excel export, see documentation |
| 574 |
// how to enable that. |
574 |
// how to enable that. |
| 575 |
|
575 |
|
| 576 |
|
576 |
|
| 577 |
/** |
577 |
/** |
| 578 |
* Misc. settings |
578 |
* Misc. settings |
| 579 |
*/ |
579 |
*/ |
| 580 |
$cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto' |
580 |
$cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto' |
| 581 |
// does autodetection, which is a bit expensive for |
581 |
// does autodetection, which is a bit expensive for |
| 582 |
// php < 4.3.0, but it is the only safe vay how to |
582 |
// php < 4.3.0, but it is the only safe vay how to |
| 583 |
// determine GD version. |
583 |
// determine GD version. |
| 584 |
/** |
584 |
/** |
| 585 |
* SQL Parser Settings |
585 |
* SQL Parser Settings |
| 586 |
*/ |
586 |
*/ |
| 587 |
$cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none) |
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) |
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}) |
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 |
590 |
// The graphical settings are now located in themes/themename/layout.inc.php |
| 591 |
|
591 |
|
| 592 |
/** |
592 |
/** |
| 593 |
* If you wish to use the SQL Validator service, you should be |
593 |
* If you wish to use the SQL Validator service, you should be |
| 594 |
* aware of the following: |
594 |
* aware of the following: |
| 595 |
* All SQL statements are stored anonymously for statistical purposes. |
595 |
* All SQL statements are stored anonymously for statistical purposes. |
| 596 |
* Mimer SQL Validator, Copyright 2002 Upright Database Technology. |
596 |
* Mimer SQL Validator, Copyright 2002 Upright Database Technology. |
| 597 |
* All rights reserved. |
597 |
* All rights reserved. |
| 598 |
*/ |
598 |
*/ |
| 599 |
$cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available |
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) |
600 |
$cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous) |
| 601 |
$cfg['SQLValidator']['password'] = ''; // Password for username |
601 |
$cfg['SQLValidator']['password'] = ''; // Password for username |
| 602 |
|
602 |
|
| 603 |
/** |
603 |
/** |
| 604 |
* Developers ONLY! |
604 |
* Developers ONLY! |
| 605 |
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ |
605 |
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ |
| 606 |
*/ |
606 |
*/ |
| 607 |
$cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available |
607 |
$cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available |
| 608 |
$cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP |
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 |
609 |
$cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display |
| 610 |
// Anything below the threshold is not displayed |
610 |
// Anything below the threshold is not displayed |
| 611 |
|
611 |
|
| 612 |
|
612 |
|
| 613 |
/** |
613 |
/** |
| 614 |
* MySQL settings |
614 |
* MySQL settings |
| 615 |
*/ |
615 |
*/ |
| 616 |
// Column types; |
616 |
// Column types; |
| 617 |
// varchar, tinyint, text and date are listed first, based on estimated popularity |
617 |
// varchar, tinyint, text and date are listed first, based on estimated popularity |
| 618 |
$cfg['ColumnTypes'] = array( |
618 |
$cfg['ColumnTypes'] = array( |
| 619 |
'VARCHAR', |
619 |
'VARCHAR', |
| 620 |
'TINYINT', |
620 |
'TINYINT', |
| 621 |
'TEXT', |
621 |
'TEXT', |
| 622 |
'DATE', |
622 |
'DATE', |
| 623 |
'SMALLINT', |
623 |
'SMALLINT', |
| 624 |
'MEDIUMINT', |
624 |
'MEDIUMINT', |
| 625 |
'INT', |
625 |
'INT', |
| 626 |
'BIGINT', |
626 |
'BIGINT', |
| 627 |
'FLOAT', |
627 |
'FLOAT', |
| 628 |
'DOUBLE', |
628 |
'DOUBLE', |
| 629 |
'DECIMAL', |
629 |
'DECIMAL', |
| 630 |
'DATETIME', |
630 |
'DATETIME', |
| 631 |
'TIMESTAMP', |
631 |
'TIMESTAMP', |
| 632 |
'TIME', |
632 |
'TIME', |
| 633 |
'YEAR', |
633 |
'YEAR', |
| 634 |
'CHAR', |
634 |
'CHAR', |
| 635 |
'TINYBLOB', |
635 |
'TINYBLOB', |
| 636 |
'TINYTEXT', |
636 |
'TINYTEXT', |
| 637 |
'BLOB', |
637 |
'BLOB', |
| 638 |
'MEDIUMBLOB', |
638 |
'MEDIUMBLOB', |
| 639 |
'MEDIUMTEXT', |
639 |
'MEDIUMTEXT', |
| 640 |
'LONGBLOB', |
640 |
'LONGBLOB', |
| 641 |
'LONGTEXT', |
641 |
'LONGTEXT', |
| 642 |
'ENUM', |
642 |
'ENUM', |
| 643 |
'SET', |
643 |
'SET', |
| 644 |
'BOOL' |
644 |
'BOOL' |
| 645 |
); |
645 |
); |
| 646 |
|
646 |
|
| 647 |
// Attributes |
647 |
// Attributes |
| 648 |
// Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically |
648 |
// Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically |
| 649 |
// for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php |
649 |
// for MySQL >= 4.1.2, in libraries/tbl_properties.inc.php |
| 650 |
|
650 |
|
| 651 |
$cfg['AttributeTypes'] = array( |
651 |
$cfg['AttributeTypes'] = array( |
| 652 |
'', |
652 |
'', |
| 653 |
'BINARY', |
653 |
'BINARY', |
| 654 |
'UNSIGNED', |
654 |
'UNSIGNED', |
| 655 |
'UNSIGNED ZEROFILL' |
655 |
'UNSIGNED ZEROFILL' |
| 656 |
); |
656 |
); |
| 657 |
|
657 |
|
| 658 |
// Available functions |
658 |
// Available functions |
| 659 |
if ($cfg['ShowFunctionFields']) { |
659 |
if ($cfg['ShowFunctionFields']) { |
| 660 |
$cfg['Functions'] = array( |
660 |
$cfg['Functions'] = array( |
| 661 |
'ASCII', |
661 |
'ASCII', |
| 662 |
'CHAR', |
662 |
'CHAR', |
| 663 |
'SOUNDEX', |
663 |
'SOUNDEX', |
| 664 |
'LCASE', |
664 |
'LCASE', |
| 665 |
'UCASE', |
665 |
'UCASE', |
| 666 |
'NOW', |
666 |
'NOW', |
| 667 |
'PASSWORD', |
667 |
'PASSWORD', |
| 668 |
'OLD_PASSWORD', |
668 |
'OLD_PASSWORD', |
| 669 |
'MD5', |
669 |
'MD5', |
| 670 |
'SHA1', |
670 |
'SHA1', |
| 671 |
'ENCRYPT', |
671 |
'ENCRYPT', |
| 672 |
'COMPRESS', |
672 |
'COMPRESS', |
| 673 |
'UNCOMPRESS', |
673 |
'UNCOMPRESS', |
| 674 |
'RAND', |
674 |
'RAND', |
| 675 |
'LAST_INSERT_ID', |
675 |
'LAST_INSERT_ID', |
| 676 |
'COUNT', |
676 |
'COUNT', |
| 677 |
'AVG', |
677 |
'AVG', |
| 678 |
'SUM', |
678 |
'SUM', |
| 679 |
'CURDATE', |
679 |
'CURDATE', |
| 680 |
'CURTIME', |
680 |
'CURTIME', |
| 681 |
'FROM_DAYS', |
681 |
'FROM_DAYS', |
| 682 |
'FROM_UNIXTIME', |
682 |
'FROM_UNIXTIME', |
| 683 |
'PERIOD_ADD', |
683 |
'PERIOD_ADD', |
| 684 |
'PERIOD_DIFF', |
684 |
'PERIOD_DIFF', |
| 685 |
'TO_DAYS', |
685 |
'TO_DAYS', |
| 686 |
'UNIX_TIMESTAMP', |
686 |
'UNIX_TIMESTAMP', |
| 687 |
'USER', |
687 |
'USER', |
| 688 |
'WEEKDAY', |
688 |
'WEEKDAY', |
| 689 |
'CONCAT' |
689 |
'CONCAT' |
| 690 |
); |
690 |
); |
| 691 |
|
691 |
|
| 692 |
// Which column types will be mapped to which Group? |
692 |
// Which column types will be mapped to which Group? |
| 693 |
$cfg['RestrictColumnTypes'] = array( |
693 |
$cfg['RestrictColumnTypes'] = array( |
| 694 |
'VARCHAR' => 'FUNC_CHAR', |
694 |
'VARCHAR' => 'FUNC_CHAR', |
| 695 |
'TINYINT' => 'FUNC_NUMBER', |
695 |
'TINYINT' => 'FUNC_NUMBER', |
| 696 |
'TEXT' => 'FUNC_CHAR', |
696 |
'TEXT' => 'FUNC_CHAR', |
| 697 |
'DATE' => 'FUNC_DATE', |
697 |
'DATE' => 'FUNC_DATE', |
| 698 |
'SMALLINT' => 'FUNC_NUMBER', |
698 |
'SMALLINT' => 'FUNC_NUMBER', |
| 699 |
'MEDIUMINT' => 'FUNC_NUMBER', |
699 |
'MEDIUMINT' => 'FUNC_NUMBER', |
| 700 |
'INT' => 'FUNC_NUMBER', |
700 |
'INT' => 'FUNC_NUMBER', |
| 701 |
'BIGINT' => 'FUNC_NUMBER', |
701 |
'BIGINT' => 'FUNC_NUMBER', |
| 702 |
'FLOAT' => 'FUNC_NUMBER', |
702 |
'FLOAT' => 'FUNC_NUMBER', |
| 703 |
'DOUBLE' => 'FUNC_NUMBER', |
703 |
'DOUBLE' => 'FUNC_NUMBER', |
| 704 |
'DECIMAL' => 'FUNC_NUMBER', |
704 |
'DECIMAL' => 'FUNC_NUMBER', |
| 705 |
'DATETIME' => 'FUNC_DATE', |
705 |
'DATETIME' => 'FUNC_DATE', |
| 706 |
'TIMESTAMP' => 'FUNC_DATE', |
706 |
'TIMESTAMP' => 'FUNC_DATE', |
| 707 |
'TIME' => 'FUNC_DATE', |
707 |
'TIME' => 'FUNC_DATE', |
| 708 |
'YEAR' => 'FUNC_DATE', |
708 |
'YEAR' => 'FUNC_DATE', |
| 709 |
'CHAR' => 'FUNC_CHAR', |
709 |
'CHAR' => 'FUNC_CHAR', |
| 710 |
'TINYBLOB' => 'FUNC_CHAR', |
710 |
'TINYBLOB' => 'FUNC_CHAR', |
| 711 |
'TINYTEXT' => 'FUNC_CHAR', |
711 |
'TINYTEXT' => 'FUNC_CHAR', |
| 712 |
'BLOB' => 'FUNC_CHAR', |
712 |
'BLOB' => 'FUNC_CHAR', |
| 713 |
'MEDIUMBLOB' => 'FUNC_CHAR', |
713 |
'MEDIUMBLOB' => 'FUNC_CHAR', |
| 714 |
'MEDIUMTEXT' => 'FUNC_CHAR', |
714 |
'MEDIUMTEXT' => 'FUNC_CHAR', |
| 715 |
'LONGBLOB' => 'FUNC_CHAR', |
715 |
'LONGBLOB' => 'FUNC_CHAR', |
| 716 |
'LONGTEXT' => 'FUNC_CHAR', |
716 |
'LONGTEXT' => 'FUNC_CHAR', |
| 717 |
'ENUM' => '', |
717 |
'ENUM' => '', |
| 718 |
'SET' => '' |
718 |
'SET' => '' |
| 719 |
); |
719 |
); |
| 720 |
|
720 |
|
| 721 |
// Map above defined groups to any function |
721 |
// Map above defined groups to any function |
| 722 |
$cfg['RestrictFunctions'] = array( |
722 |
$cfg['RestrictFunctions'] = array( |
| 723 |
'FUNC_CHAR' => array( |
723 |
'FUNC_CHAR' => array( |
| 724 |
'ASCII', |
724 |
'ASCII', |
| 725 |
'CHAR', |
725 |
'CHAR', |
| 726 |
'SOUNDEX', |
726 |
'SOUNDEX', |
| 727 |
'LCASE', |
727 |
'LCASE', |
| 728 |
'UCASE', |
728 |
'UCASE', |
| 729 |
'PASSWORD', |
729 |
'PASSWORD', |
| 730 |
'OLD_PASSWORD', |
730 |
'OLD_PASSWORD', |
| 731 |
'MD5', |
731 |
'MD5', |
| 732 |
'SHA1', |
732 |
'SHA1', |
| 733 |
'ENCRYPT', |
733 |
'ENCRYPT', |
| 734 |
'COMPRESS', |
734 |
'COMPRESS', |
| 735 |
'UNCOMPRESS', |
735 |
'UNCOMPRESS', |
| 736 |
'LAST_INSERT_ID', |
736 |
'LAST_INSERT_ID', |
| 737 |
'USER', |
737 |
'USER', |
| 738 |
'CONCAT' |
738 |
'CONCAT' |
| 739 |
), |
739 |
), |
| 740 |
|
740 |
|
| 741 |
'FUNC_DATE' => array( |
741 |
'FUNC_DATE' => array( |
| 742 |
'NOW', |
742 |
'NOW', |
| 743 |
'CURDATE', |
743 |
'CURDATE', |
| 744 |
'CURTIME', |
744 |
'CURTIME', |
| 745 |
'FROM_DAYS', |
745 |
'FROM_DAYS', |
| 746 |
'FROM_UNIXTIME', |
746 |
'FROM_UNIXTIME', |
| 747 |
'PERIOD_ADD', |
747 |
'PERIOD_ADD', |
| 748 |
'PERIOD_DIFF', |
748 |
'PERIOD_DIFF', |
| 749 |
'TO_DAYS', |
749 |
'TO_DAYS', |
| 750 |
'UNIX_TIMESTAMP', |
750 |
'UNIX_TIMESTAMP', |
| 751 |
'WEEKDAY' |
751 |
'WEEKDAY' |
| 752 |
), |
752 |
), |
| 753 |
|
753 |
|
| 754 |
'FUNC_NUMBER' => array( |
754 |
'FUNC_NUMBER' => array( |
| 755 |
'ASCII', |
755 |
'ASCII', |
| 756 |
'CHAR', |
756 |
'CHAR', |
| 757 |
'MD5', |
757 |
'MD5', |
| 758 |
'SHA1', |
758 |
'SHA1', |
| 759 |
'ENCRYPT', |
759 |
'ENCRYPT', |
| 760 |
'RAND', |
760 |
'RAND', |
| 761 |
'LAST_INSERT_ID', |
761 |
'LAST_INSERT_ID', |
| 762 |
'UNIX_TIMESTAMP', |
762 |
'UNIX_TIMESTAMP', |
| 763 |
'COUNT', |
763 |
'COUNT', |
| 764 |
'AVG', |
764 |
'AVG', |
| 765 |
'SUM' |
765 |
'SUM' |
| 766 |
) |
766 |
) |
| 767 |
); |
767 |
); |
| 768 |
|
768 |
|
| 769 |
// Default functions for above defined groups |
769 |
// Default functions for above defined groups |
| 770 |
$cfg['DefaultFunctions'] = array( |
770 |
$cfg['DefaultFunctions'] = array( |
| 771 |
'FUNC_CHAR' => '', |
771 |
'FUNC_CHAR' => '', |
| 772 |
'FUNC_DATE' => '', |
772 |
'FUNC_DATE' => '', |
| 773 |
'FUNC_NUMBER' => '', |
773 |
'FUNC_NUMBER' => '', |
| 774 |
'first_timestamp' => 'NOW' |
774 |
'first_timestamp' => 'NOW' |
| 775 |
); |
775 |
); |
| 776 |
|
776 |
|
| 777 |
|
777 |
|
| 778 |
} // end if |
778 |
} // end if |
| 779 |
|
779 |
|
| 780 |
// Search operators |
780 |
// Search operators |
| 781 |
$cfg['NumOperators'] = array( |
781 |
$cfg['NumOperators'] = array( |
| 782 |
'=', |
782 |
'=', |
| 783 |
'>', |
783 |
'>', |
| 784 |
'>=', |
784 |
'>=', |
| 785 |
'<', |
785 |
'<', |
| 786 |
'<=', |
786 |
'<=', |
| 787 |
'!=', |
787 |
'!=', |
| 788 |
'LIKE', |
788 |
'LIKE', |
| 789 |
'NOT LIKE' |
789 |
'NOT LIKE' |
| 790 |
); |
790 |
); |
| 791 |
|
791 |
|
| 792 |
$cfg['TextOperators'] = array( |
792 |
$cfg['TextOperators'] = array( |
| 793 |
'LIKE', |
793 |
'LIKE', |
| 794 |
'LIKE %...%', |
794 |
'LIKE %...%', |
| 795 |
'NOT LIKE', |
795 |
'NOT LIKE', |
| 796 |
'=', |
796 |
'=', |
| 797 |
'!=', |
797 |
'!=', |
| 798 |
'REGEXP', |
798 |
'REGEXP', |
| 799 |
'NOT REGEXP' |
799 |
'NOT REGEXP' |
| 800 |
); |
800 |
); |
| 801 |
|
801 |
|
| 802 |
$cfg['EnumOperators'] = array( |
802 |
$cfg['EnumOperators'] = array( |
| 803 |
'=', |
803 |
'=', |
| 804 |
'!=' |
804 |
'!=' |
| 805 |
); |
805 |
); |
| 806 |
|
806 |
|
| 807 |
$cfg['SetOperators'] = array( |
807 |
$cfg['SetOperators'] = array( |
| 808 |
'IN', |
808 |
'IN', |
| 809 |
'NOT IN' |
809 |
'NOT IN' |
| 810 |
); |
810 |
); |
| 811 |
|
811 |
|
| 812 |
$cfg['NullOperators'] = array( |
812 |
$cfg['NullOperators'] = array( |
| 813 |
'IS NULL', |
813 |
'IS NULL', |
| 814 |
'IS NOT NULL' |
814 |
'IS NOT NULL' |
| 815 |
); |
815 |
); |
| 816 |
|
816 |
|
| 817 |
$cfg['UnaryOperators'] = array( |
817 |
$cfg['UnaryOperators'] = array( |
| 818 |
'IS NULL' => 1, |
818 |
'IS NULL' => 1, |
| 819 |
'IS NOT NULL' => 1 |
819 |
'IS NOT NULL' => 1 |
| 820 |
); |
820 |
); |
| 821 |
|
821 |
|
| 822 |
?> |
822 |
?> |