[Bb-trac] [bbPress] #644: "column forum_slug can't have a default value" error with installation

[bbPress]

#644: "column forum_slug can't have a default value" error with installation
----------------------------------+-----------------------------------------
 Reporter:  sjons                 |       Owner:                         
     Type:  defect                |      Status:  new                    
 Priority:  normal                |   Milestone:  1.0                    
Component:  Installation/Upgrade  |     Version:                         
 Severity:  normal                |    Keywords:  svn install mysql error
----------------------------------+-----------------------------------------
 As posted [http://bbpress.org/forums/topic/1088?replies=2 here].

 Patch:
 {{{
 Index: upgrade-schema.php
 ===================================================================
 --- upgrade-schema.php  (revision 805)
 +++ upgrade-schema.php  (working copy)
 @@ -4,7 +4,7 @@
  $bb_queries = "CREATE TABLE $bbdb->forums (
    forum_id int(10) NOT NULL auto_increment,
    forum_name varchar(150)  NOT NULL default '',
 -  forum_slug text  NOT NULL default '',
 +  forum_slug text  NOT NULL,
    forum_desc text  NOT NULL,
    forum_parent int(10) NOT NULL default '0',
    forum_order int(10) NOT NULL default '0',
 @@ -31,7 +31,7 @@
  CREATE TABLE $bbdb->topics (
    topic_id bigint(20) NOT NULL auto_increment,
    topic_title varchar(100) NOT NULL default '',
 -  topic_slug text NOT NULL default '',
 +  topic_slug text NOT NULL,
    topic_poster bigint(20) NOT NULL default '0',
    topic_poster_name varchar(40) NOT NULL default 'Anonymous',
    topic_last_poster bigint(20) NOT NULL default '0',
 }}}

 And the version field lacks a ''svn'' type.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/644>
bbPress <http://bbpress.org/>
Innovative forum development