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

Компаний

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

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

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

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

Банкоматы

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

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

Курсы валют

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

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

сайты Орел

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

Статистика

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

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

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

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

Каталоги >

Новости >

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

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

Сервисы >

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

Имя файла	create_tables.sql
Содержимое	-- -------------------------------------------------------- -- SQL Commands to set up the pmadb as described in Documentation.html. -- -- DON'T RUN THIS SCRIPT ON MySQL 4.1.2 AND ABOVE! -- Instead, please run create_tables_mysql_4_1_2+.sql. -- -- This script expects the user pma to already be existing. If we would put a -- line here to create him too many users might just use this script and end -- up with having the same password for the controluser. -- -- This user "pma" must be defined in config.inc.php (controluser/controlpass) -- -- Please don't forget to set up the tablenames in config.inc.php -- -- $Id$ -- -------------------------------------------------------- -- -- Database : `phpmyadmin` -- DROP DATABASE IF EXISTS `phpmyadmin`; CREATE DATABASE `phpmyadmin`; USE phpmyadmin; -- -------------------------------------------------------- -- -- Privileges -- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@localhost; -- -------------------------------------------------------- -- -- Table structure for table `pma_bookmark` -- CREATE TABLE `pma_bookmark` ( `id` int(11) NOT NULL auto_increment, `dbase` varchar(255) NOT NULL default '', `user` varchar(255) NOT NULL default '', `label` varchar(255) NOT NULL default '', `query` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='Bookmarks'; -- -------------------------------------------------------- -- -- Table structure for table `pma_column_info` -- CREATE TABLE `pma_column_info` ( `id` int(5) unsigned NOT NULL auto_increment, `db_name` varchar(64) NOT NULL default '', `table_name` varchar(64) NOT NULL default '', `column_name` varchar(64) NOT NULL default '', `comment` varchar(255) NOT NULL default '', `mimetype` varchar(255) NOT NULL default '', `transformation` varchar(255) NOT NULL default '', `transformation_options` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`) ) TYPE=MyISAM COMMENT='Column information for phpMyAdmin'; -- -------------------------------------------------------- -- -- Table structure for table `pma_history` -- CREATE TABLE `pma_history` ( `id` bigint(20) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL default '', `db` varchar(64) NOT NULL default '', `table` varchar(64) NOT NULL default '', `timevalue` timestamp(14) NOT NULL, `sqlquery` text NOT NULL, PRIMARY KEY (`id`), KEY `username` (`username`,`db`,`table`,`timevalue`) ) TYPE=MyISAM COMMENT='SQL history for phpMyAdmin'; -- -------------------------------------------------------- -- -- Table structure for table `pma_pdf_pages` -- CREATE TABLE `pma_pdf_pages` ( `db_name` varchar(64) NOT NULL default '', `page_nr` int(10) unsigned NOT NULL auto_increment, `page_descr` varchar(50) NOT NULL default '', PRIMARY KEY (`page_nr`), KEY `db_name` (`db_name`) ) TYPE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'; -- -------------------------------------------------------- -- -- Table structure for table `pma_relation` -- CREATE TABLE `pma_relation` ( `master_db` varchar(64) NOT NULL default '', `master_table` varchar(64) NOT NULL default '', `master_field` varchar(64) NOT NULL default '', `foreign_db` varchar(64) NOT NULL default '', `foreign_table` varchar(64) NOT NULL default '', `foreign_field` varchar(64) NOT NULL default '', PRIMARY KEY (`master_db`,`master_table`,`master_field`), KEY `foreign_field` (`foreign_db`,`foreign_table`) ) TYPE=MyISAM COMMENT='Relation table'; -- -------------------------------------------------------- -- -- Table structure for table `pma_table_coords` -- CREATE TABLE `pma_table_coords` ( `db_name` varchar(64) NOT NULL default '', `table_name` varchar(64) NOT NULL default '', `pdf_page_number` int(11) NOT NULL default '0', `x` float unsigned NOT NULL default '0', `y` float unsigned NOT NULL default '0', PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`) ) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'; -- -------------------------------------------------------- -- -- Table structure for table `pma_table_info` -- CREATE TABLE `pma_table_info` ( `db_name` varchar(64) NOT NULL default '', `table_name` varchar(64) NOT NULL default '', `display_field` varchar(64) NOT NULL default '', PRIMARY KEY (`db_name`,`table_name`) ) TYPE=MyISAM COMMENT='Table information for phpMyAdmin'; -- -------------------------------------------------------- -- -- Table structure for table `pma_designer_coords` -- CREATE TABLE `pma_designer_coords` ( `db_name` varchar(64) NOT NULL default '', `table_name` varchar(64) NOT NULL default '', `x` INT(11) default NULL, `y` INT(11) default NULL, `v` TINYINT(4) default NULL, `h` TINYINT(4) default NULL, PRIMARY KEY (`db_name`,`table_name`) ) TYPE=MyISAM COMMENT='Table coordinates for Designer'

/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