   "id" serial NOT NULL,
   "firstname" character varying(45),
   "surname" character varying(45),
-  "email" character varying(45),
-  "username" character varying(45),
+  "email" citext,
+  "username" citext,
   "title" integer,
   "organisation" integer,
   "telephone" character varying(128),

CREATE TABLE "enumval" (
  "id" serial NOT NULL,
  "enum_id" integer,
  "value" text,
  "layout_id" integer,
  "deleted" smallint DEFAULT 0 NOT NULL,
  "parent" integer,

  "lastlogin" timestamp,
  "lastrecord" integer,
  "lastview" integer,
  "value" citext,
  "account_request" smallint DEFAULT 0,
  "account_request_notes" text,
  "aup_accepted" timestamp,
