diff options
Diffstat (limited to 'srcs/phpmyadmin/sql/upgrade_tables_mysql_4_1_2+.sql')
| -rw-r--r-- | srcs/phpmyadmin/sql/upgrade_tables_mysql_4_1_2+.sql | 144 |
1 files changed, 0 insertions, 144 deletions
diff --git a/srcs/phpmyadmin/sql/upgrade_tables_mysql_4_1_2+.sql b/srcs/phpmyadmin/sql/upgrade_tables_mysql_4_1_2+.sql deleted file mode 100644 index df4046a..0000000 --- a/srcs/phpmyadmin/sql/upgrade_tables_mysql_4_1_2+.sql +++ /dev/null @@ -1,144 +0,0 @@ --- ------------------------------------------------------------- --- SQL Commands to upgrade pmadb for normal phpMyAdmin operation --- with MySQL 4.1.2 and above. --- --- This file is meant for use with MySQL 4.1.2 and above! --- For older MySQL releases, please use create_tables.sql --- --- If you are running one MySQL 4.1.0 or 4.1.1, please create the tables using --- create_tables.sql, then use this script. --- --- Please don't forget to set up the tablenames in config.inc.php --- - --- -------------------------------------------------------- - --- --- Database : `phpmyadmin` --- -ALTER DATABASE `phpmyadmin` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; -USE phpmyadmin; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__bookmark` --- -ALTER TABLE `pma__bookmark` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__bookmark` - CHANGE `dbase` `dbase` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__bookmark` - CHANGE `user` `user` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__bookmark` - CHANGE `label` `label` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; -ALTER TABLE `pma__bookmark` - CHANGE `query` `query` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__column_info` --- - -ALTER TABLE `pma__column_info` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__column_info` - CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `column_name` `column_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `comment` `comment` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `mimetype` `mimetype` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `transformation` `transformation` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__column_info` - CHANGE `transformation_options` `transformation_options` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__history` --- -ALTER TABLE `pma__history` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__history` - CHANGE `username` `username` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__history` - CHANGE `db` `db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__history` - CHANGE `table` `table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__history` - CHANGE `sqlquery` `sqlquery` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__pdf_pages` --- - -ALTER TABLE `pma__pdf_pages` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__pdf_pages` - CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__pdf_pages` - CHANGE `page_descr` `page_descr` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__relation` --- -ALTER TABLE `pma__relation` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__relation` - CHANGE `master_db` `master_db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__relation` - CHANGE `master_table` `master_table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__relation` - CHANGE `master_field` `master_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__relation` - CHANGE `foreign_db` `foreign_db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__relation` - CHANGE `foreign_table` `foreign_table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__relation` - CHANGE `foreign_field` `foreign_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__table_coords` --- - -ALTER TABLE `pma__table_coords` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__table_coords` - CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__table_coords` - CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; - --- -------------------------------------------------------- - --- --- Table structure for table `pma__table_info` --- - -ALTER TABLE `pma__table_info` - DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; - -ALTER TABLE `pma__table_info` - CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__table_info` - CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; -ALTER TABLE `pma__table_info` - CHANGE `display_field` `display_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ''; |