[geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.4.2.php, 1.18, 1.19
Oliver
ospiess at qs1489.pair.com
Mon Aug 20 05:25:39 EDT 2007
Update of /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv66436/updates
Modified Files:
mysql_1.4.1_to_1.4.2.php
Log Message:
fixing poll plugin answer tables index to prevent overwriting of other values
Index: mysql_1.4.1_to_1.4.2.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.4.1_to_1.4.2.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** mysql_1.4.1_to_1.4.2.php 20 Aug 2007 08:53:43 -0000 1.18
--- mysql_1.4.1_to_1.4.2.php 20 Aug 2007 09:25:37 -0000 1.19
***************
*** 42,45 ****
--- 42,49 ----
$P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` CHANGE `qid` `pid` VARCHAR( 20 ) NOT NULL";
$P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` ADD `qid` VARCHAR( 20 ) NOT NULL DEFAULT '0' AFTER `pid`;";
+ $P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` DROP PRIMARY KEY;";
+ $P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` ADD INDEX ( `qid` );";
+ $P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` ADD INDEX ( `aid` );";
+ $P_SQL[] = "ALTER TABLE `{$_TABLES['pollanswers']}` ADD INDEX ( `pid` );";
$P_SQL[] = "ALTER TABLE `{$_TABLES['pollvoters']}` CHANGE `qid` `pid` VARCHAR( 20 ) NOT NULL";
$P_SQL[] = "CREATE TABLE {$_TABLES['pollquestions']} (
More information about the geeklog-cvs
mailing list