[bbDev] [994] trunk/bb-admin/upgrade-schema.php: Return forcing of MyISAM to posts table.

[Michael D Adams]

Why was the collation assignment redundant?

On Dec 20, 2007, at 10:41 PM, m at wordpress.org wrote:

> Revision
> 994
> Author
> sambauers
> Date
> 2007-12-21 06:41:26 +0000 (Fri, 21 Dec 2007)
> Log Message
>
> Return forcing of MyISAM to posts table.
>
> Remove redundant collation assignment on user tables.
>
> Fixes #978
> Modified Paths
>
> trunk/bb-admin/upgrade-schema.php
> Diff
>
> Modified: trunk/bb-admin/upgrade-schema.php (993 => 994)
> --- trunk/bb-admin/upgrade-schema.php	2007-12-20 12:43:28 UTC (rev  
> 993)
> +++ trunk/bb-admin/upgrade-schema.php	2007-12-21 06:41:26 UTC (rev  
> 994)
> @@ -17,8 +17,6 @@
>  if ( $bbdb->has_cap( 'collation', $bbdb->users ) ) {
>  	if ( ! empty($bbdb->user_charset) )
>  		$user_charset_collate = "DEFAULT CHARACTER SET $bbdb- 
> >user_charset";
> -	if ( ! empty($bbdb->user_collate) )
> -		$user_charset_collate .= " COLLATE $bbdb->user_collate";
>  }
>
>  $bb_queries = "CREATE TABLE $bbdb->forums (
> @@ -47,7 +45,7 @@
>    KEY poster_time (poster_id,post_time),
>    KEY post_time (post_time),
>    FULLTEXT KEY post_text (post_text)
> -) $charset_collate;
> +) TYPE = MYISAM $charset_collate;
>  CREATE TABLE $bbdb->topics (
>    topic_id bigint(20) NOT NULL auto_increment,
>    topic_title varchar(100) NOT NULL default '',
> _______________________________________________
> bbDev mailing list
> bbDev at lists.bbpress.org
> http://lists.bbpress.org/mailman/listinfo/bbdev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://comox.textdrive.com/pipermail/bbdev/attachments/20080104/26557c96/attachment.htm