[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_4_1RC1-2855-ga2f4717

[Piotr Przybylski]

The branch, master has been updated
       via  a2f4717e0c4f0017fb0460984f8d1fa2ed2b0090 (commit)
      from  0dbc9f4a3c7fa46baed1477f001e37dad14fc908 (commit)


- Log -----------------------------------------------------------------
commit a2f4717e0c4f0017fb0460984f8d1fa2ed2b0090
Author: Piotr Przybylski <piotrprz at gmail.com>
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