The branch, master has been updated
via a2f4717e0c4f0017fb0460984f8d1fa2ed2b0090 (commit)
from 0dbc9f4a3c7fa46baed1477f001e37dad14fc908 (commit)
- Log -----------------------------------------------------------------
commit a2f4717e0c4f0017fb0460984f8d1fa2ed2b0090
Author: Piotr Przybylski <[email protected]>
Date: Wed Jun 1 19:23:44 2011 +0200
SQL formatting in create_tables.sql
-----------------------------------------------------------------------
Summary of changes:
scripts/create_tables.sql | 11 ++++++++---
1 files changed, 8 insertions(+), 3 deletions(-)
diff --git a/scripts/create_tables.sql b/scripts/create_tables.sql
index a537462..6adc280 100644
--- a/scripts/create_tables.sql
+++ b/scripts/create_tables.sql
@@ -113,7 +113,9 @@ CREATE TABLE IF NOT EXISTS `pma_recent` (
`username` varchar(64) COLLATE utf8_bin NOT NULL,
`tables` blob NOT NULL,
PRIMARY KEY (`username`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+)
+ ENGINE=MyISAM COMMENT='Recently accessed tables'
+ DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
@@ -127,7 +129,8 @@ CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` (
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`prefs` blob NOT NULL,
PRIMARY KEY (`username`,`db_name`,`table_name`)
-) ENGINE=MyISAM COMMENT='tables'' UI preferences'
+)
+ ENGINE=MyISAM COMMENT='Tables'' UI preferences'
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
@@ -217,7 +220,9 @@ CREATE TABLE IF NOT EXISTS `pma_tracking` (
`tracking` set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE
DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME
TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER
VIEW','DROP VIEW') collate utf8_bin default NULL,
`tracking_active` int(1) unsigned NOT NULL default '1',
PRIMARY KEY (`db_name`,`table_name`,`version`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT;
+)
+ ENGINE=MyISAM ROW_FORMAT=COMPACT COMMENT='Database changes tracking for
phpMyAdmin'
+ DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
hooks/post-receive
--
phpMyAdmin
------------------------------------------------------------------------------
Simplify data backup and recovery for your virtual environment with vRanger.
Installation's a snap, and flexible recovery options mean your data is safe,
secure and there when you need it. Data protection magic?
Nope - It's vRanger. Get your free trial download today.
http://p.sf.net/sfu/quest-sfdev2dev
_______________________________________________
Phpmyadmin-git mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-git
