| Index: trunk/extensions/AntiSpoof/sql/patch-antispoof.sqlite.sql |
| — | — | @@ -0,0 +1,21 @@ |
| | 2 | +CREATE TABLE /*$wgDBprefix*/spoofuser ( |
| | 3 | + -- Equivalent to user_name, but not guaranteed to be in sync. |
| | 4 | + -- Do a join against user_name to confirm that an account hasn't |
| | 5 | + -- been renamed or deleted away. |
| | 6 | + su_name VARCHAR(255), |
| | 7 | + |
| | 8 | + -- Normalized form of name for similarity-spoofing checks |
| | 9 | + su_normalized VARCHAR(255), |
| | 10 | + |
| | 11 | + -- ok/not-ok according to the looks-like-a-valid-name check |
| | 12 | + su_legal BOOL, |
| | 13 | + |
| | 14 | + -- error message that came out of the unicode check, if any |
| | 15 | + su_error TEXT, |
| | 16 | + |
| | 17 | + -- unique record per username |
| | 18 | + PRIMARY KEY (su_name) |
| | 19 | +) /*$wgDBTableOptions*/; |
| | 20 | + |
| | 21 | +-- for checking matching possible spoofs |
| | 22 | +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 |
| 1 | 23 | + native |