<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * set of functions for tbl_create.php and tbl_addfield.php * * @package PhpMyAdmin */ use PMA\libraries\Table; /** * Transforms the radio button field_key into 4 arrays * * @return array An array of arrays which represents column keys for each index type */ function PMA_getIndexedColumns() { $field_cnt = count($_REQUEST['field_name']); $field_primary = json_decode($_REQUEST['primary_indexes'], true); $field_index = json_decode($_REQUEST['indexes'], true); $field_unique = json_decode($_REQUEST['unique_indexes'], true); $field_fulltext = json_decode($_REQUEST['fulltext_indexes'], true); $field_spatial = json_decode($_REQUEST['spatial_indexes'], true); return array( $field_cnt, $field_primary, $field_index, $field_unique, $field_fulltext, $field_spatial ); } /** * Initiate the column creation statement according to the table creation or * add columns to a existing table * * @param int $field_cnt number of columns * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return array $definitions An array of initial sql statements * according to the request */ function PMA_buildColumnCreationStatement( $field_cnt, $is_create_tbl = true ) { $definitions = array(); for ($i = 0; $i < $field_cnt; ++$i) { // '0' is also empty for php :-( if (empty($_REQUEST['field_name'][$i]) && $_REQUEST['field_name'][$i] != '0' ) { continue; } $definition = PMA_getStatementPrefix($is_create_tbl) . Table::generateFieldSpec( trim($_REQUEST['field_name'][$i]), $_REQUEST['field_type'][$i], $_REQUEST['field_length'][$i], $_REQUEST['field_attribute'][$i], isset($_REQUEST['field_collation'][$i]) ? $_REQUEST['field_collation'][$i] : '', isset($_REQUEST['field_null'][$i]) ? $_REQUEST['field_null'][$i] : 'NOT NULL', $_REQUEST['field_default_type'][$i], $_REQUEST['field_default_value'][$i], isset($_REQUEST['field_extra'][$i]) ? $_REQUEST['field_extra'][$i] : false, isset($_REQUEST['field_comments'][$i]) ? $_REQUEST['field_comments'][$i] : '', isset($_REQUEST['field_virtuality'][$i]) ? $_REQUEST['field_virtuality'][$i] : '', isset($_REQUEST['field_expression'][$i]) ? $_REQUEST['field_expression'][$i] : '' ); $definition .= PMA_setColumnCreationStatementSuffix($i, $is_create_tbl); $definitions[] = $definition; } // end for return $definitions; } /** * Set column creation suffix according to requested position of the new column * * @param int $current_field_num current column number * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string $sql_suffix suffix */ function PMA_setColumnCreationStatementSuffix($current_field_num, $is_create_tbl = true ) { // no suffix is needed if request is a table creation $sql_suffix = ' '; if ($is_create_tbl) { return $sql_suffix; } if ((string) $_REQUEST['field_where'] === 'last') { return $sql_suffix; } // Only the first field can be added somewhere other than at the end if ((int) $current_field_num === 0) { if ((string) $_REQUEST['field_where'] === 'first') { $sql_suffix .= ' FIRST'; } else { $sql_suffix .= ' AFTER ' . PMA\libraries\Util::backquote($_REQUEST['after_field']); } } else { $sql_suffix .= ' AFTER ' . PMA\libraries\Util::backquote( $_REQUEST['field_name'][$current_field_num - 1] ); } return $sql_suffix; } /** * Create relevant index statements * * @param array $index an array of index columns * @param string $index_choice index choice that which represents * the index type of $indexed_fields * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return array an array of sql statements for indexes */ function PMA_buildIndexStatements($index, $index_choice, $is_create_tbl = true ) { $statement = array(); if (!count($index)) { return $statement; } $sql_query = PMA_getStatementPrefix($is_create_tbl) . ' ' . $index_choice; if (! empty($index['Key_name']) && $index['Key_name'] != 'PRIMARY') { $sql_query .= ' ' . PMA\libraries\Util::backquote($index['Key_name']); } $index_fields = array(); foreach ($index['columns'] as $key => $column) { $index_fields[$key] = PMA\libraries\Util::backquote( $_REQUEST['field_name'][$column['col_index']] ); if ($column['size']) { $index_fields[$key] .= '(' . $column['size'] . ')'; } } // end while $sql_query .= ' (' . implode(', ', $index_fields) . ')'; $keyBlockSizes = $index['Key_block_size']; if (! empty($keyBlockSizes)) { $sql_query .= " KEY_BLOCK_SIZE = " . $GLOBALS['dbi']->escapeString($keyBlockSizes); } // specifying index type is allowed only for primary, unique and index only $type = $index['Index_type']; if ($index['Index_choice'] != 'SPATIAL' && $index['Index_choice'] != 'FULLTEXT' && in_array($type, PMA\libraries\Index::getIndexTypes()) ) { $sql_query .= ' USING ' . $type; } $parser = $index['Parser']; if ($index['Index_choice'] == 'FULLTEXT' && ! empty($parser)) { $sql_query .= " WITH PARSER " . $GLOBALS['dbi']->escapeString($parser); } $comment = $index['Index_comment']; if (! empty($comment)) { $sql_query .= " COMMENT '" . $GLOBALS['dbi']->escapeString($comment) . "'"; } $statement[] = $sql_query; return $statement; } /** * Statement prefix for the PMA_buildColumnCreationStatement() * * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string $sql_prefix prefix */ function PMA_getStatementPrefix($is_create_tbl = true) { $sql_prefix = " "; if (! $is_create_tbl) { $sql_prefix = ' ADD '; } return $sql_prefix; } /** * Merge index definitions for one type of index * * @param array $definitions the index definitions to merge to * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * @param array $indexed_columns the columns for one type of index * @param string $index_keyword the index keyword to use in the definition * * @return array $index_definitions */ function PMA_mergeIndexStatements( $definitions, $is_create_tbl, $indexed_columns, $index_keyword ) { foreach ($indexed_columns as $index) { $statements = PMA_buildIndexStatements( $index, " " . $index_keyword . " ", $is_create_tbl ); $definitions = array_merge($definitions, $statements); } return $definitions; } /** * Returns sql statement according to the column and index specifications as * requested * * @param boolean $is_create_tbl true if requirement is to get the statement * for table creation * * @return string sql statement */ function PMA_getColumnCreationStatements($is_create_tbl = true) { $sql_statement = ""; list($field_cnt, $field_primary, $field_index, $field_unique, $field_fulltext, $field_spatial ) = PMA_getIndexedColumns(); $definitions = PMA_buildColumnCreationStatement( $field_cnt, $is_create_tbl ); // Builds the PRIMARY KEY statements $primary_key_statements = PMA_buildIndexStatements( isset($field_primary[0]) ? $field_primary[0] : array(), " PRIMARY KEY ", $is_create_tbl ); $definitions = array_merge($definitions, $primary_key_statements); // Builds the INDEX statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_index, "INDEX" ); // Builds the UNIQUE statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_unique, "UNIQUE" ); // Builds the FULLTEXT statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_fulltext, "FULLTEXT" ); // Builds the SPATIAL statements $definitions = PMA_mergeIndexStatements( $definitions, $is_create_tbl, $field_spatial, "SPATIAL" ); if (count($definitions)) { $sql_statement = implode(', ', $definitions); } $sql_statement = preg_replace('@, $@', '', $sql_statement); return $sql_statement; } /** * Returns the partitioning clause * * @return string partitioning clause */ function PMA_getPartitionsDefinition() { $sql_query = ""; if (! empty($_REQUEST['partition_by']) && ! empty($_REQUEST['partition_expr']) && ! empty($_REQUEST['partition_count']) && $_REQUEST['partition_count'] > 1 ) { $sql_query .= " PARTITION BY " . $_REQUEST['partition_by'] . " (" . $_REQUEST['partition_expr'] . ")" . " PARTITIONS " . $_REQUEST['partition_count']; } if (! empty($_REQUEST['subpartition_by']) && ! empty($_REQUEST['subpartition_expr']) && ! empty($_REQUEST['subpartition_count']) && $_REQUEST['subpartition_count'] > 1 ) { $sql_query .= " SUBPARTITION BY " . $_REQUEST['subpartition_by'] . " (" . $_REQUEST['subpartition_expr'] . ")" . " SUBPARTITIONS " . $_REQUEST['subpartition_count']; } if (! empty($_REQUEST['partitions'])) { $i = 0; $partitions = array(); foreach ($_REQUEST['partitions'] as $partition) { $partitions[] = PMA_getPartitionDefinition($partition); $i++; } $sql_query .= " (" . implode(", ", $partitions) . ")"; } return $sql_query; } /** * Returns the definition of a partition/subpartition * * @param array $partition array of partition/subpartition detiails * @param boolean $isSubPartition whether a subpartition * * @return string partition/subpartition definition */ function PMA_getPartitionDefinition($partition, $isSubPartition = false) { $sql_query = " " . ($isSubPartition ? "SUB" : "") . "PARTITION "; $sql_query .= $partition['name']; if (! empty($partition['value_type'])) { $sql_query .= " VALUES " . $partition['value_type']; if ($partition['value_type'] != 'LESS THAN MAXVALUE') { $sql_query .= " (" . $partition['value'] . ")"; } } if (! empty($partition['engine'])) { $sql_query .= " ENGINE = " . $partition['engine']; } if (! empty($partition['comment'])) { $sql_query .= " COMMENT = '" . $partition['comment'] . "'"; } if (! empty($partition['data_directory'])) { $sql_query .= " DATA DIRECTORY = '" . $partition['data_directory'] . "'"; } if (! empty($partition['index_directory'])) { $sql_query .= " INDEX_DIRECTORY = '" . $partition['index_directory'] . "'"; } if (! empty($partition['max_rows'])) { $sql_query .= " MAX_ROWS = " . $partition['max_rows']; } if (! empty($partition['min_rows'])) { $sql_query .= " MIN_ROWS = " . $partition['min_rows']; } if (! empty($partition['tablespace'])) { $sql_query .= " TABLESPACE = " . $partition['tablespace']; } if (! empty($partition['node_group'])) { $sql_query .= " NODEGROUP = " . $partition['node_group']; } if (! empty($partition['subpartitions'])) { $j = 0; $subpartitions = array(); foreach ($partition['subpartitions'] as $subpartition) { $subpartitions[] = PMA_getPartitionDefinition( $subpartition, true ); $j++; } $sql_query .= " (" . implode(", ", $subpartitions) . ")"; } return $sql_query; } /** * Function to get table creation sql query * * @param string $db database name * @param string $table table name * * @return string */ function PMA_getTableCreationQuery($db, $table) { // get column addition statements $sql_statement = PMA_getColumnCreationStatements(true); // Builds the 'create table' statement $sql_query = 'CREATE TABLE ' . PMA\libraries\Util::backquote($db) . '.' . PMA\libraries\Util::backquote(trim($table)) . ' (' . $sql_statement . ')'; // Adds table type, character set, comments and partition definition if (!empty($_REQUEST['tbl_storage_engine']) && ($_REQUEST['tbl_storage_engine'] != 'Default') ) { $sql_query .= ' ENGINE = ' . $_REQUEST['tbl_storage_engine']; } if (!empty($_REQUEST['tbl_collation'])) { $sql_query .= PMA_generateCharsetQueryPart($_REQUEST['tbl_collation']); } if (! empty($_REQUEST['connection']) && ! empty($_REQUEST['tbl_storage_engine']) && $_REQUEST['tbl_storage_engine'] == 'FEDERATED' ) { $sql_query .= " CONNECTION = '" . $GLOBALS['dbi']->escapeString($_REQUEST['connection']) . "'"; } if (!empty($_REQUEST['comment'])) { $sql_query .= ' COMMENT = \'' . $GLOBALS['dbi']->escapeString($_REQUEST['comment']) . '\''; } $sql_query .= PMA_getPartitionsDefinition(); $sql_query .= ';'; return $sql_query; } /** * Function to get the number of fields for the table creation form * * @return int */ function PMA_getNumberOfFieldsFromRequest() { if (isset($_REQUEST['submit_num_fields'])) { // adding new fields $num_fields = min( 4096, intval($_REQUEST['orig_num_fields']) + intval($_REQUEST['added_fields']) ); } elseif (isset($_REQUEST['orig_num_fields'])) { // retaining existing fields $num_fields = min(4096, intval($_REQUEST['orig_num_fields'])); } elseif (isset($_REQUEST['num_fields']) && intval($_REQUEST['num_fields']) > 0 ) { // new table with specified number of fields $num_fields = min(4096, intval($_REQUEST['num_fields'])); } else { // new table with unspecified number of fields $num_fields = 4; } return $num_fields; } /** * Function to execute the column creation statement * * @param string $db current database * @param string $table current table * @param string $err_url error page url * * @return array */ function PMA_tryColumnCreationQuery($db, $table, $err_url) { // get column addition statements $sql_statement = PMA_getColumnCreationStatements(false); // To allow replication, we first select the db to use and then run queries // on this db. if (!($GLOBALS['dbi']->selectDb($db))) { PMA\libraries\Util::mysqlDie( $GLOBALS['dbi']->getError(), 'USE ' . PMA\libraries\Util::backquote($db), false, $err_url ); } $sql_query = 'ALTER TABLE ' . PMA\libraries\Util::backquote($table) . ' ' . $sql_statement . ';'; // If there is a request for SQL previewing. if (isset($_REQUEST['preview_sql'])) { PMA_previewSQL($sql_query); } return array($GLOBALS['dbi']->tryQuery($sql_query) , $sql_query); }
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
bfShapeFiles | Folder | 0755 |
|
|
config | Folder | 0755 |
|
|
controllers | Folder | 0755 |
|
|
dbi | Folder | 0755 |
|
|
di | Folder | 0755 |
|
|
engines | Folder | 0755 |
|
|
gis | Folder | 0755 |
|
|
navigation | Folder | 0755 |
|
|
plugins | Folder | 0755 |
|
|
properties | Folder | 0755 |
|
|
rte | Folder | 0755 |
|
|
sql-parser | Folder | 0755 |
|
|
Advisor.php | File | 15.13 KB | 0644 |
|
Config.php | File | 54.7 KB | 0644 |
|
Console.php | File | 14.82 KB | 0644 |
|
DatabaseInterface.php | File | 95.6 KB | 0644 |
|
DbList.php | File | 1.9 KB | 0644 |
|
DbQbe.php | File | 68.87 KB | 0644 |
|
DbSearch.php | File | 17.21 KB | 0644 |
|
DisplayResults.php | File | 206 KB | 0644 |
|
Error.php | File | 12.7 KB | 0644 |
|
ErrorHandler.php | File | 16.48 KB | 0644 |
|
File.php | File | 18.82 KB | 0644 |
|
Font.php | File | 4.24 KB | 0644 |
|
Footer.php | File | 10.52 KB | 0644 |
|
Header.php | File | 25.34 KB | 0644 |
|
Index.php | File | 23.79 KB | 0644 |
|
IndexColumn.php | File | 4.46 KB | 0644 |
|
Language.php | File | 4.27 KB | 0644 |
|
LanguageManager.php | File | 20.75 KB | 0644 |
|
Linter.php | File | 5.02 KB | 0644 |
|
ListAbstract.php | File | 3.15 KB | 0644 |
|
ListDatabase.php | File | 4.62 KB | 0644 |
|
Menu.php | File | 21.14 KB | 0644 |
|
Message.php | File | 18.67 KB | 0644 |
|
OutputBuffering.php | File | 3.59 KB | 0644 |
|
PDF.php | File | 3.94 KB | 0644 |
|
Partition.php | File | 7.26 KB | 0644 |
|
Psr4Autoloader.php | File | 4.85 KB | 0644 |
|
RecentFavoriteTable.php | File | 11.78 KB | 0644 |
|
Response.php | File | 12.61 KB | 0644 |
|
SavedSearches.php | File | 11.67 KB | 0644 |
|
Scripts.php | File | 7.38 KB | 0644 |
|
ServerStatusData.php | File | 15.72 KB | 0644 |
|
StorageEngine.php | File | 13.61 KB | 0644 |
|
SubPartition.php | File | 3.52 KB | 0644 |
|
SysInfo.php | File | 799 B | 0644 |
|
SysInfoLinux.php | File | 1.92 KB | 0644 |
|
SysInfoSunOS.php | File | 1.86 KB | 0644 |
|
SysInfoWINNT.php | File | 3.08 KB | 0644 |
|
SystemDatabase.php | File | 3.66 KB | 0644 |
|
Table.php | File | 88.12 KB | 0644 |
|
Template.php | File | 4.45 KB | 0644 |
|
Theme.php | File | 11.34 KB | 0644 |
|
ThemeManager.php | File | 12.91 KB | 0644 |
|
Tracker.php | File | 30.35 KB | 0644 |
|
Types.php | File | 6.08 KB | 0644 |
|
TypesMySQL.php | File | 17.26 KB | 0644 |
|
Util.php | File | 172.46 KB | 0644 |
|
VersionInformation.php | File | 7.87 KB | 0644 |
|
ZipFile.php | File | 6.63 KB | 0644 |
|
advisor.lib.php | File | 1.6 KB | 0644 |
|
advisory_rules.txt | File | 25.94 KB | 0644 |
|
autoloader.php | File | 450 B | 0644 |
|
bookmark.lib.php | File | 8.5 KB | 0644 |
|
browse_foreigners.lib.php | File | 9.83 KB | 0644 |
|
central_columns.lib.php | File | 49.38 KB | 0644 |
|
charset_conversion.lib.php | File | 3.54 KB | 0644 |
|
check_user_privileges.lib.php | File | 10.65 KB | 0644 |
|
cleanup.lib.php | File | 1.29 KB | 0644 |
|
common.inc.php | File | 34.38 KB | 0644 |
|
config.default.php | File | 66.5 KB | 0644 |
|
config.values.php | File | 10.17 KB | 0644 |
|
core.lib.php | File | 29.94 KB | 0644 |
|
create_addfield.lib.php | File | 15.68 KB | 0644 |
|
database_interface.inc.php | File | 2.63 KB | 0644 |
|
db_common.inc.php | File | 3.12 KB | 0644 |
|
db_designer.lib.php | File | 10.4 KB | 0644 |
|
db_table_exists.lib.php | File | 3.21 KB | 0644 |
|
display_change_password.lib.php | File | 5.45 KB | 0644 |
|
display_create_table.lib.php | File | 1.53 KB | 0644 |
|
display_export.lib.php | File | 38.11 KB | 0644 |
|
display_git_revision.lib.php | File | 3.04 KB | 0644 |
|
display_import.lib.php | File | 24.34 KB | 0644 |
|
display_import_ajax.lib.php | File | 3.13 KB | 0644 |
|
display_select_lang.lib.php | File | 2.36 KB | 0644 |
|
error.inc.php | File | 1.21 KB | 0644 |
|
error_report.lib.php | File | 10.25 KB | 0644 |
|
export.lib.php | File | 35.16 KB | 0644 |
|
file_listing.lib.php | File | 2.37 KB | 0644 |
|
iconv_wrapper.lib.php | File | 3.88 KB | 0644 |
|
import.lib.php | File | 50.64 KB | 0644 |
|
index.lib.php | File | 1.37 KB | 0644 |
|
information_schema_relations.lib.php | File | 10.95 KB | 0644 |
|
insert_edit.lib.php | File | 112.79 KB | 0644 |
|
ip_allow_deny.lib.php | File | 9.35 KB | 0644 |
|
js_escape.lib.php | File | 4.43 KB | 0644 |
|
kanji-encoding.lib.php | File | 4.46 KB | 0644 |
|
language_stats.inc.php | File | 1.45 KB | 0644 |
|
logging.lib.php | File | 521 B | 0644 |
|
mime.lib.php | File | 704 B | 0644 |
|
mult_submits.inc.php | File | 10.64 KB | 0644 |
|
mult_submits.lib.php | File | 20.44 KB | 0644 |
|
mysql_charsets.inc.php | File | 4.09 KB | 0644 |
|
mysql_charsets.lib.php | File | 10.47 KB | 0644 |
|
mysql_relations.lib.php | File | 5.12 KB | 0644 |
|
normalization.lib.php | File | 33.98 KB | 0644 |
|
opendocument.lib.php | File | 7.94 KB | 0644 |
|
operations.lib.php | File | 73.64 KB | 0644 |
|
parse_analyze.lib.php | File | 2.12 KB | 0644 |
|
plugin_interface.lib.php | File | 19.69 KB | 0644 |
|
plugin_interface.lib.php.bak | File | 19.69 KB | 0644 |
|
pmd_common.php | File | 24.2 KB | 0644 |
|
relation.lib.php | File | 68.41 KB | 0644 |
|
relation_cleanup.lib.php | File | 13.84 KB | 0644 |
|
replication.inc.php | File | 8.82 KB | 0644 |
|
replication_gui.lib.php | File | 37.45 KB | 0644 |
|
sanitizing.lib.php | File | 6.3 KB | 0644 |
|
select_server.lib.php | File | 3.4 KB | 0644 |
|
server_common.inc.php | File | 1.22 KB | 0644 |
|
server_common.lib.php | File | 1.92 KB | 0644 |
|
server_privileges.lib.php | File | 179.22 KB | 0644 |
|
server_status.lib.php | File | 9.92 KB | 0644 |
|
server_status_advisor.lib.php | File | 1.89 KB | 0644 |
|
server_status_monitor.lib.php | File | 26.22 KB | 0644 |
|
server_status_processes.lib.php | File | 9.57 KB | 0644 |
|
server_status_queries.lib.php | File | 4.86 KB | 0644 |
|
server_status_variables.lib.php | File | 28.95 KB | 0644 |
|
server_user_groups.lib.php | File | 12.8 KB | 0644 |
|
server_users.lib.php | File | 1.35 KB | 0644 |
|
session.inc.php | File | 5.22 KB | 0644 |
|
session.lib.php | File | 735 B | 0644 |
|
special_schema_links.lib.php | File | 17.51 KB | 0644 |
|
sql.lib.php | File | 77.51 KB | 0644 |
|
sql.lib.php.bak | File | 77.51 KB | 0644 |
|
sql_query_form.lib.php | File | 15.71 KB | 0644 |
|
string.lib.php | File | 800 B | 0644 |
|
stringMb.lib.php | File | 1.86 KB | 0644 |
|
stringNative.lib.php | File | 6.82 KB | 0644 |
|
sysinfo.lib.php | File | 1.34 KB | 0644 |
|
tbl_columns_definition_form.inc.php | File | 13.55 KB | 0644 |
|
tbl_common.inc.php | File | 1.3 KB | 0644 |
|
tbl_info.inc.php | File | 3.54 KB | 0644 |
|
tbl_partition_definition.inc.php | File | 5.55 KB | 0644 |
|
tracking.lib.php | File | 54.93 KB | 0644 |
|
transformations.lib.php | File | 14.63 KB | 0644 |
|
url_generating.lib.php | File | 6.77 KB | 0644 |
|
user_preferences.inc.php | File | 2.38 KB | 0644 |
|
user_preferences.lib.php | File | 8.17 KB | 0644 |
|
util.lib.php | File | 749 B | 0644 |
|
vendor_config.php | File | 2.49 KB | 0644 |
|
zip_extension.lib.php | File | 5.38 KB | 0644 |
|