diff options
author | Sebastian Mendel <cybot_tm@users.sourceforge.net> | 2005-12-08 15:39:59 +0300 |
---|---|---|
committer | Sebastian Mendel <cybot_tm@users.sourceforge.net> | 2005-12-08 15:39:59 +0300 |
commit | 388e2364fb2433c14bfd9a8e6c85c09a0dd82a08 (patch) | |
tree | d008dbdf4e1cd86ee73e62a20f9d0d2e6ca4e11f /tbl_rename.php | |
parent | fe8553fa7b8423f428edeec5c01589e5f90f39d2 (diff) |
removed, deprecated by function PMA_table_rename()
Diffstat (limited to 'tbl_rename.php')
-rw-r--r-- | tbl_rename.php | 109 |
1 files changed, 0 insertions, 109 deletions
diff --git a/tbl_rename.php b/tbl_rename.php deleted file mode 100644 index 1e9d0006cf..0000000000 --- a/tbl_rename.php +++ /dev/null @@ -1,109 +0,0 @@ -<?php -/* $Id$ */ -// vim: expandtab sw=4 ts=4 sts=4: - - -/** - * Gets some core libraries - */ -require_once('./libraries/common.lib.php'); - -$js_to_run = 'functions.js'; -PMA_checkParameters(array('db','table')); - -/** - * Defines the url to return to in case of error in a sql statement - */ -$err_url = 'tbl_properties.php?' . PMA_generate_common_url($db, $table); - - -/** - * A new name has been submitted -> do the work - */ -if (isset($new_name) && trim($new_name) != '' && strpos($new_name,'.') === FALSE) { - $old_name = $table; - $table = $new_name; - - // Ensure the target is valid - if (count($dblist) > 0 && PMA_isInto($db, $dblist) == -1) { - exit(); - } - - require_once('./libraries/header.inc.php'); - PMA_DBI_select_db($db); - $sql_query = 'ALTER TABLE ' . PMA_backquote($old_name) . ' RENAME ' . PMA_backquote($new_name) . ';'; - $result = PMA_DBI_query($sql_query); - $message = sprintf($strRenameTableOK, htmlspecialchars($old_name), htmlspecialchars($table)); - $reload = 1; - - // garvin: Move old entries from comments to new table - require_once('./libraries/relation.lib.php'); - $cfgRelation = PMA_getRelationsParam(); - if ($cfgRelation['commwork']) { - $remove_query = 'UPDATE ' . PMA_backquote($cfgRelation['column_info']) - . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\'' - . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' - . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\''; - $rmv_rs = PMA_query_as_cu($remove_query); - unset($rmv_query); - } - - if ($cfgRelation['displaywork']) { - $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['table_info']) - . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\'' - . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' - . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\''; - $tb_rs = PMA_query_as_cu($table_query); - unset($table_query); - unset($tb_rs); - } - - if ($cfgRelation['relwork']) { - $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['relation']) - . ' SET foreign_table = \'' . PMA_sqlAddslashes($table) . '\'' - . ' WHERE foreign_db = \'' . PMA_sqlAddslashes($db) . '\'' - . ' AND foreign_table = \'' . PMA_sqlAddslashes($old_name) . '\''; - $tb_rs = PMA_query_as_cu($table_query); - unset($table_query); - unset($tb_rs); - - $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['relation']) - . ' SET master_table = \'' . PMA_sqlAddslashes($table) . '\'' - . ' WHERE master_db = \'' . PMA_sqlAddslashes($db) . '\'' - . ' AND master_table = \'' . PMA_sqlAddslashes($old_name) . '\''; - $tb_rs = PMA_query_as_cu($table_query); - unset($table_query); - unset($tb_rs); - } - - if ($cfgRelation['pdfwork']) { - $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['table_coords']) - . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\'' - . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' - . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\''; - $tb_rs = PMA_query_as_cu($table_query); - unset($table_query); - unset($tb_rs); - } - -} - - -/** - * No new name for the table! - */ -else { - require_once('./libraries/header.inc.php'); - if (strpos($new_name,'.') === FALSE) { - PMA_mysqlDie($strTableEmpty, '', '', $err_url); - } else { - PMA_mysqlDie($strError . ': ' . $new_name, '', '', $err_url); - } -} - - -/** - * Back to the calling script - */ -require('./tbl_properties_operations.php'); -?> |