[phpmix-cvs] drupal/modules/akismet akismet.install,1.2,1.3

[<php...@li...>]

Update of /cvsroot/phpmix/drupal/modules/akismet
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv14944

Modified Files:
	akismet.install 
Log Message:
Ahem, the new table is for moderator options so better change the name.

Index: akismet.install
===================================================================
RCS file: /cvsroot/phpmix/drupal/modules/akismet/akismet.install,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** akismet.install	10 Jun 2006 17:50:00 -0000	1.2
--- akismet.install	10 Jun 2006 17:57:35 -0000	1.3
***************
*** 18,22 ****
            INDEX spam_created (spam_created)
          ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
!       db_query("CREATE TABLE {akismet_user} (
            uid int(10) unsigned NOT NULL default 0,
            email_for varchar(20) NOT NULL default '',
--- 18,22 ----
            INDEX spam_created (spam_created)
          ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
!       db_query("CREATE TABLE {akismet_moderator} (
            uid int(10) unsigned NOT NULL default 0,
            email_for varchar(20) NOT NULL default '',
***************
*** 34,43 ****
        db_query("CREATE UNIQUE INDEX {akismet_spam_marks_content} ON {akismet_spam_marks} (content_type, content_id)");
        db_query("CREATE INDEX {akismet_spam_marks_spamcreated} ON {akismet_spam_marks} (spam_created)");
!       db_query("CREATE TABLE {akismet_user} (
            uid INTEGER NOT NULL DEFAULT 0 CHECK (uid >= 0),
            email_for VARCHAR(20) NOT NULL DEFAULT '',
            PRIMARY KEY (uid)
          )");
!       db_query("CREATE INDEX {akismet_user_email_for} ON {akismet_user} (email_for)");
        break;
    }
--- 34,43 ----
        db_query("CREATE UNIQUE INDEX {akismet_spam_marks_content} ON {akismet_spam_marks} (content_type, content_id)");
        db_query("CREATE INDEX {akismet_spam_marks_spamcreated} ON {akismet_spam_marks} (spam_created)");
!       db_query("CREATE TABLE {akismet_moderator} (
            uid INTEGER NOT NULL DEFAULT 0 CHECK (uid >= 0),
            email_for VARCHAR(20) NOT NULL DEFAULT '',
            PRIMARY KEY (uid)
          )");
!       db_query("CREATE INDEX {akismet_moderator_email_for} ON {akismet_moderator} (email_for)");
        break;
    }
***************
*** 55,59 ****
      case 'mysql':
      case 'mysqli':
!       $ret[] = update_sql("CREATE TABLE {akismet_user} (
            uid int(10) unsigned NOT NULL default 0,
            email_for varchar(20) NOT NULL default '',
--- 55,59 ----
      case 'mysql':
      case 'mysqli':
!       $ret[] = update_sql("CREATE TABLE {akismet_moderator} (
            uid int(10) unsigned NOT NULL default 0,
            email_for varchar(20) NOT NULL default '',
***************
*** 64,73 ****
  
      case 'pgsql':
!       $ret[] = update_sql("CREATE TABLE {akismet_user} (
            uid INTEGER NOT NULL DEFAULT 0 CHECK (uid >= 0),
            email_for VARCHAR(20) NOT NULL DEFAULT '',
            PRIMARY KEY (uid)
          )");
!       $ret[] = update_sql("CREATE INDEX {akismet_user_email_for} ON {akismet_user} (email_for)");
        break;
    }
--- 64,73 ----
  
      case 'pgsql':
!       $ret[] = update_sql("CREATE TABLE {akismet_moderator} (
            uid INTEGER NOT NULL DEFAULT 0 CHECK (uid >= 0),
            email_for VARCHAR(20) NOT NULL DEFAULT '',
            PRIMARY KEY (uid)
          )");
!       $ret[] = update_sql("CREATE INDEX {akismet_moderator_email_for} ON {akismet_moderator} (email_for)");
        break;
    }