[Tͪ#n$;<:a4sX [kň%{t@BH_9F5eM{t0;M|*cd*ٿ#djZƧ>3ڋ:|<9C$^n-X"Xnx߼TG 2,O4%{!sŝo/74?Ssɳ.YĐN =ﰇJtPuό 7t|9%!< DENJPl8j6ͧNeC7emg%h =3Nᾣ1#Ɏz0AZ+&#`we3jp(wY1f gbޠ;k=`Ikaǀ4(xCaW8'[$eHU׏Ky&273Nᾣ1#Ɏzb'/n֫JkuN9Mزn\'>—u)t#OC7c&\0Ѹ zP⌛ǫRh u/Frhsp#ڦ,J#j80h]RJ*(y[P^\.07ɵ"PjpZvu5 ǏڟDPsk-aDe<=39]03bcC GDk/Y“튜Y"oaJoB#qsFa:YRÉHhZbUȓT!cˣqYGݙ̑r/Fa Q2X&((Qo4ʄܟofT>L[ʖ'. r e%vU4%XW3Nᾣ1#Ɏz? Sn @˅5eO?N29pᨹ~h׃Jf_9t%X NE%E03Nᾣ1#Ɏz=qڡTN[DhIJO~Jŝd<(\Z'wƭ )*ؠt?KZ?b஀?V1bv64Ĝ*s+/5y;3=Woj٤itܐ*/(S{Z=u[|XW!M%[ÞFۃqe=M~NqQ@8{KS2N|!kQ`|;O/^_Rh4'%1]JNCK'k\cu=P.zR#jHGз;e Mn_5Y T'DoÕPnaƷ-Bcxi%ϼ6K%x /"}m3Nᾣ1#Ɏz<,(BjTcT?NYG&n2oƂ3X~rՄtz Ѿ䪄>n 13Nᾣ1#Ɏz,>Il~v*%<#ѽ([KggT9Lw 2krU4,K2}Ut2^C-Lh w_ăpᨹ~h׃Jf_9t%X NE%E03Nᾣ1#Ɏz=q:-fL B$yjȲIgO) p!&7B|6 ]d%$,mz1>jص6l}Z1ɦ#R@Ä҅|?g2Qm,v^@PwGwu\?HhG"V浍 `;Z2oc؛ * 盦Gea"x{)y95 "4[ս"Bj啾̵Pf!v[ /m̅`HX n+y3'g{8&SkM=td"զtp&ӊwQp&,XSRg Vfn@xP|xQ&LSJ1G71pFSz،NTឰ+Vèl,O"aQqaLu)!BOa=Q#rΟQXqvv@ 5И% 3Nᾣ1#Ɏz$"3ieL#HF٩0[qyyRl.YX ?8[`&sAm.Uv-ڽ}TV,`ϏY~yXy20v((&[<8ഌP=<8q?rl 8`L]7:&w%t>Vu}Zk̹¸^d~Hr!ΡVZo$Y4 iӫ{w~akVH%U+PORtXseT@#㬽dv' #' 9J $x7?-T%fXY]Jt$]f+V&$?oըy9〹Dt@Iposo_-z@_8 js=R:Tfr^c<@о#ن7i"H;BTƼ0ujC<]&Ĺ!|/k\A3O!$ϐ}N&#q0SUE*cW]QIjyOI2f8^'SHz+:"5v+~' ջT"MHQ|}s=s㽾>`>wK>NɅf̑3Nᾣ1#ɎziRTV R7Tн~4}a89i.d̞X3هuter_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); }