[geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.4.2.php, 1.23, 1.24

Oliver ospiess at qs1489.pair.com
Sun Sep 2 03:51:56 EDT 2007


Update of /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv1852/updates

Modified Files:
	mysql_1.4.1_to_1.4.2.php 
Log Message:
Primary key error

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.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** mysql_1.4.1_to_1.4.2.php	29 Aug 2007 04:28:08 -0000	1.23
--- mysql_1.4.1_to_1.4.2.php	2 Sep 2007 07:51:54 -0000	1.24
***************
*** 247,253 ****
          $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']} (
--- 247,251 ----
          $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 (pid, qid, aid);";
          $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