Changeset 2693 for trunk/gui/tools/pma/scripts/create_tables.sql

Timestamp:

03/13/10 00:37:22 (2 years ago)

Author:

nuxwin

Message:

• [MERGE] Latest omega-1.0.5 changes - part I

Location:

trunk

Files:

• . (modified) (1 prop)
• gui/tools/pma/scripts/create_tables.sql (modified) (2 diffs)

trunk/gui/tools/pma/scripts/create_tables.sql

@@ -12 +12 @@
 -- Please don't forget to set up the tablenames in config.inc.php                                 
 -- 
--- $Id: create_tables.sql 10684 2007-09-30 12:15:08Z lem9 $
+-- $Id: create_tables.sql 12837 2009-08-20 13:39:02Z nijel $
 
 -- --------------------------------------------------------
@@ -173 +173 @@
   ENGINE=MyISAM COMMENT='Table coordinates for Designer'
   DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+
+--
+-- Table structure for table `pma_tracking`
+--
+
+CREATE TABLE IF NOT EXISTS `pma_tracking` (
+  `db_name` varchar(64) collate utf8_bin NOT NULL,
+  `table_name` varchar(64) collate utf8_bin NOT NULL,
+  `version` int(10) unsigned NOT NULL,
+  `date_created` datetime NOT NULL,
+  `date_updated` datetime NOT NULL,
+  `schema_snapshot` text collate utf8_bin NOT NULL,
+  `schema_sql` text collate utf8_bin,
+  `data_sql` text collate utf8_bin,
+  `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;