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;
}
|