Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	upgrade_tables_mysql_4_1_2+.sql
Содержимое	-- ------------------------------------------------------------- -- 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 -- -- $Id$ -- -------------------------------------------------------- -- -- 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 ''; -- -------------------------------------------------------- -- -- Table structure for table `pma_designer_coords` -- CREATE TABLE IF NOT EXISTS `pma_designer_coords` ( `db_name` varchar(64) NOT NULL default '', `table_name` varchar(64) NOT NULL default '', `x` INT, `y` INT, `v` TINYINT, `h` TINYINT, PRIMARY KEY (`db_name`,`table_name`) ) ENGINE=MyISAM COMMENT='Table coordinates for Designer' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

/admin/myadmin2/scripts/

Имя	Дата	Размер
..	2013-06-28
check_lang.php	2013-06-28	2 кб.
convertcfg.pl	2013-06-28	352 байт
create_tables.sql	2013-06-28	5 кб.
create_tables_mysql_4_1_2+.sql	2013-06-28	6 кб.
decode_bug.php	2013-06-28	3 кб.
find_unused_messages.sh	2013-06-28	1 кб.
setup.php	2013-06-28	77 кб.
signon.php	2013-06-28	2 кб.
upgrade.pl	2013-06-28	5 кб.
upgrade_tables_mysql_4_1_2+.sql	2013-06-28	6 кб.

/admin/myadmin2/scripts