[geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.4.2.php, 1.17, 1.18
Oliver
ospiess at qs1489.pair.com
Mon Aug 20 04:53:45 EDT 2007
Update of /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv65423/updates
Modified Files:
mysql_1.4.1_to_1.4.2.php
Log Message:
fixing poll question table indexes
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.17
retrieving revision 1.18
diff -C2 -d -r1.17 -r1.18
*** mysql_1.4.1_to_1.4.2.php 9 Aug 2007 08:09:45 -0000 1.17
--- mysql_1.4.1_to_1.4.2.php 20 Aug 2007 08:53:43 -0000 1.18
***************
*** 44,51 ****
$P_SQL[] = "ALTER TABLE `{$_TABLES['pollvoters']}` CHANGE `qid` `pid` VARCHAR( 20 ) NOT NULL";
$P_SQL[] = "CREATE TABLE {$_TABLES['pollquestions']} (
! qid mediumint(9) NOT NULL auto_increment,
pid varchar(20) NOT NULL,
question varchar(255) NOT NULL,
! PRIMARY KEY (qid)
) TYPE=MyISAM
";
--- 44,51 ----
$P_SQL[] = "ALTER TABLE `{$_TABLES['pollvoters']}` CHANGE `qid` `pid` VARCHAR( 20 ) NOT NULL";
$P_SQL[] = "CREATE TABLE {$_TABLES['pollquestions']} (
! qid mediumint(9) NOT NULL DEFAULT '0',
pid varchar(20) NOT NULL,
question varchar(255) NOT NULL,
! KEY `qid` (`qid`)
) TYPE=MyISAM
";
***************
*** 82,86 ****
$P_SQL = array();
$P_SQL[] = "ALTER TABLE `{$_TABLES['staticpage']}` ADD commentcode tinyint(4) NOT NULL default '0' AFTER sp_label";
-
$P_SQL = INST_checkInnodbUpgrade($P_SQL);
for ($i = 0; $i < count ($P_SQL); $i++) {
--- 82,85 ----
More information about the geeklog-cvs
mailing list