http://www.mediawiki.org/wiki/Special:Code/MediaWiki/100682
Revision: 100682
Author: hashar
Date: 2011-10-25 08:06:57 +0000 (Tue, 25 Oct 2011)
Log Message:
-----------
add SQLite structure to abuse filter
Copy/pasted from the MySQL file and adapted for SQLite
Added Paths:
-----------
trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql
Added: trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql
===================================================================
--- trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql
(rev 0)
+++ trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql 2011-10-25
08:06:57 UTC (rev 100682)
@@ -0,0 +1,21 @@
+CREATE TABLE /*$wgDBprefix*/spoofuser (
+ -- Equivalent to user_name, but not guaranteed to be in sync.
+ -- Do a join against user_name to confirm that an account hasn't
+ -- been renamed or deleted away.
+ su_name VARCHAR(255),
+
+ -- Normalized form of name for similarity-spoofing checks
+ su_normalized VARCHAR(255),
+
+ -- ok/not-ok according to the looks-like-a-valid-name check
+ su_legal BOOL,
+
+ -- error message that came out of the unicode check, if any
+ su_error TEXT,
+
+ -- unique record per username
+ PRIMARY KEY (su_name)
+) /*$wgDBTableOptions*/;
+
+-- for checking matching possible spoofs
+CREATE INDEX su_normname_idx ON /*$wgDBprefix*/spoofuser (su_normalized,
su_name);
Property changes on: trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
