fos_user table and indexes

CREATE TABLE fos_user
(
  id integer NOT NULL,
  updated_by_id integer,
  created_by_id integer,
  username character varying(255) NOT NULL,
  username_canonical character varying(255) NOT NULL,
  email character varying(255) NOT NULL,
  email_canonical character varying(255) NOT NULL,
  enabled boolean NOT NULL,
  salt character varying(255) NOT NULL,
  password character varying(255) NOT NULL,
  last_login timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  locked boolean NOT NULL,
  expired boolean NOT NULL,
  expires_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  confirmation_token character varying(255) DEFAULT NULL::character varying,
  password_requested_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  roles text NOT NULL, -- (DC2Type:array)
  credentials_expired boolean NOT NULL,
  credentials_expire_at timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  created_at timestamp(0) without time zone NOT NULL,
  updated_at timestamp(0) without time zone NOT NULL,
  date_of_birth timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  firstname character varying(64) DEFAULT NULL::character varying,
  lastname character varying(64) DEFAULT NULL::character varying,
  website character varying(64) DEFAULT NULL::character varying,
  biography character varying(255) DEFAULT NULL::character varying,
  gender character varying(1) DEFAULT NULL::character varying,
  locale character varying(8) DEFAULT NULL::character varying,
  timezone character varying(64) DEFAULT NULL::character varying,
  phone character varying(64) DEFAULT NULL::character varying,
  facebook_uid character varying(255) DEFAULT NULL::character varying,
  facebook_name character varying(255) DEFAULT NULL::character varying,
  facebook_data text, -- (DC2Type:json)
  twitter_uid character varying(255) DEFAULT NULL::character varying,
  twitter_name character varying(255) DEFAULT NULL::character varying,
  twitter_data text, -- (DC2Type:json)
  gplus_uid character varying(255) DEFAULT NULL::character varying,
  gplus_name character varying(255) DEFAULT NULL::character varying,
  gplus_data text, -- (DC2Type:json)
  token character varying(255) DEFAULT NULL::character varying,
  two_step_code character varying(255) DEFAULT NULL::character varying,
  updated timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  created timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  deleted timestamp(0) without time zone DEFAULT NULL::timestamp without time zone,
  department_id integer,
  CONSTRAINT fos_user_pkey PRIMARY KEY (id ),
  CONSTRAINT fk_957a6479896dbbde FOREIGN KEY (updated_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_957a6479ae80f5df FOREIGN KEY (department_id)
      REFERENCES department (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_957a6479b03a8386 FOREIGN KEY (created_by_id)
      REFERENCES fos_user (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE fos_user
  OWNER TO sd4;
COMMENT ON COLUMN fos_user.roles IS '(DC2Type:array)';
COMMENT ON COLUMN fos_user.facebook_data IS '(DC2Type:json)';
COMMENT ON COLUMN fos_user.twitter_data IS '(DC2Type:json)';
COMMENT ON COLUMN fos_user.gplus_data IS '(DC2Type:json)';


-- Index: idx_957a64793124b5b6

-- DROP INDEX idx_957a64793124b5b6;

CREATE INDEX idx_957a64793124b5b6
  ON fos_user
  USING btree
  (lastname COLLATE pg_catalog."default" );

-- Index: idx_957a647950f9bb84

-- DROP INDEX idx_957a647950f9bb84;

CREATE INDEX idx_957a647950f9bb84
  ON fos_user
  USING btree
  (enabled );

-- Index: idx_957a647983a00e68

-- DROP INDEX idx_957a647983a00e68;

CREATE INDEX idx_957a647983a00e68
  ON fos_user
  USING btree
  (firstname COLLATE pg_catalog."default" );

-- Index: idx_957a647983a00e683124b5b6

-- DROP INDEX idx_957a647983a00e683124b5b6;

CREATE INDEX idx_957a647983a00e683124b5b6
  ON fos_user
  USING btree
  (firstname COLLATE pg_catalog."default" , lastname COLLATE pg_catalog."default" );

-- Index: idx_957a6479896dbbde

-- DROP INDEX idx_957a6479896dbbde;

CREATE INDEX idx_957a6479896dbbde
  ON fos_user
  USING btree
  (updated_by_id );

-- Index: idx_957a6479ae80f5df

-- DROP INDEX idx_957a6479ae80f5df;

CREATE INDEX idx_957a6479ae80f5df
  ON fos_user
  USING btree
  (department_id );

-- Index: idx_957a6479b03a8386

-- DROP INDEX idx_957a6479b03a8386;

CREATE INDEX idx_957a6479b03a8386
  ON fos_user
  USING btree
  (created_by_id );

-- Index: idx_957a6479b23db7b8

-- DROP INDEX idx_957a6479b23db7b8;

CREATE INDEX idx_957a6479b23db7b8
  ON fos_user
  USING btree
  (created );

-- Index: idx_957a6479c69b96f7

-- DROP INDEX idx_957a6479c69b96f7;

CREATE INDEX idx_957a6479c69b96f7
  ON fos_user
  USING btree
  (updated );

-- Index: idx_957a6479eb3b4e33

-- DROP INDEX idx_957a6479eb3b4e33;

CREATE INDEX idx_957a6479eb3b4e33
  ON fos_user
  USING btree
  (deleted );

-- Index: uniq_957a647992fc23a8

-- DROP INDEX uniq_957a647992fc23a8;

CREATE UNIQUE INDEX uniq_957a647992fc23a8
  ON fos_user
  USING btree
  (username_canonical COLLATE pg_catalog."default" );

-- Index: uniq_957a6479a0d96fbf

-- DROP INDEX uniq_957a6479a0d96fbf;

CREATE UNIQUE INDEX uniq_957a6479a0d96fbf
  ON fos_user
  USING btree
  (email_canonical COLLATE pg_catalog."default" );