From: <wis...@us...> - 2012-03-26 20:05:57
|
Revision: 9203 http://xoops.svn.sourceforge.net/xoops/?rev=9203&view=rev Author: wishcraft Date: 2012-03-26 20:05:51 +0000 (Mon, 26 Mar 2012) Log Message: ----------- Karioki Song List 1.09 - complete second release - final - DB Optimization, Bottlenecks Removed, Pagination Fixed, Templating Issues Fixed. Modified Paths: -------------- XoopsModules/songlist/releases/1.09/htdocs/modules/songlist/sql/mysql.sql XoopsModules/songlist/trunk/htdocs/modules/songlist/sql/mysql.sql Modified: XoopsModules/songlist/releases/1.09/htdocs/modules/songlist/sql/mysql.sql =================================================================== --- XoopsModules/songlist/releases/1.09/htdocs/modules/songlist/sql/mysql.sql 2012-03-26 19:44:00 UTC (rev 9202) +++ XoopsModules/songlist/releases/1.09/htdocs/modules/songlist/sql/mysql.sql 2012-03-26 20:05:51 UTC (rev 9203) @@ -77,7 +77,7 @@ `sid` INT(12) UNSIGNED DEFAULT '0', `created` INT(12) UNSIGNED DEFAULT '0', `updated` INT(12) UNSIGNED DEFAULT '0', - PRIMARY KEY (`rid`) + PRIMARY KEY (`rid`), KEY `SORT` (`songid`(10),`sid`,`created`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; Modified: XoopsModules/songlist/trunk/htdocs/modules/songlist/sql/mysql.sql =================================================================== --- XoopsModules/songlist/trunk/htdocs/modules/songlist/sql/mysql.sql 2012-03-26 19:44:00 UTC (rev 9202) +++ XoopsModules/songlist/trunk/htdocs/modules/songlist/sql/mysql.sql 2012-03-26 20:05:51 UTC (rev 9203) @@ -77,7 +77,7 @@ `sid` INT(12) UNSIGNED DEFAULT '0', `created` INT(12) UNSIGNED DEFAULT '0', `updated` INT(12) UNSIGNED DEFAULT '0', - PRIMARY KEY (`rid`) + PRIMARY KEY (`rid`), KEY `SORT` (`songid`(10),`sid`,`created`) ) ENGINE=INNODB DEFAULT CHARSET=utf8; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |