[xoops-svn] SF.net SVN: xoops-svn:[12374] XoopsModules/TDMCreate/branches/timgno/1.91/ TDMCreate/sql/mysql.sql

[<txm...@us...>]

Revision: 12374
          http://sourceforge.net/p/xoops/svn/12374
Author:   txmodxoops
Date:     2014-03-14 08:06:01 +0000 (Fri, 14 Mar 2014)
Log Message:
-----------
Unique key

Modified Paths:
--------------
    XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql

Modified: XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql
===================================================================
--- XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql	2014-03-13 21:55:43 UTC (rev 12373)
+++ XoopsModules/TDMCreate/branches/timgno/1.91/TDMCreate/sql/mysql.sql	2014-03-14 08:06:01 UTC (rev 12374)
@@ -36,7 +36,8 @@
   `mod_install` tinyint(1) unsigned NOT NULL default '0',
   `mod_donations` varchar(50) NOT NULL default '',
   `mod_subversion` varchar(10) NOT NULL default '',
-  PRIMARY KEY (`mod_id`)
+  PRIMARY KEY (`mod_id`),
+  KEY `mod_name` (`mod_name`)
 ) ENGINE=MyISAM;
 
 
@@ -60,5 +61,7 @@
   `table_comments` tinyint(1) unsigned NOT NULL default '0',
   `table_notifications` tinyint(1) unsigned NOT NULL default '0',
   `table_permissions` tinyint(1) unsigned NOT NULL default '0',
-  PRIMARY KEY (`table_id`)
+  PRIMARY KEY (`table_id`),
+  KEY `table_mid` (`table_mid`),
+  KEY `table_name` (`table_name`)
 ) ENGINE=MyISAM;
\ No newline at end of file