AntiSpoof/sql/patch-antispoof.postgres.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

CREATE TABLE 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 character varying PRIMARY KEY,

  -- Normalized form of name for similarity-spoofing checks
  su_normalized character varying,

  -- ok/not-ok according to the looks-like-a-valid-name check
  su_legal boolean,

  -- error message that came out of the unicode check, if any
  su_error text
);

CREATE INDEX su_normname_idx ON spoofuser (su_normalized,su_name);