neo4j-indexes-enterprise.cypher

CREATE CONSTRAINT user_id_constraint IF NOT EXISTS
ON (u:User) ASSERT u.id IS UNIQUE;

CREATE INDEX user_id_index IF NOT EXISTS
FOR (u:User) ON (u.id);

CREATE INDEX user_email_index IF NOT EXISTS
FOR (u:User) ON (u.email);

CREATE CONSTRAINT session_session_token_constraint IF NOT EXISTS
ON (s:Session) ASSERT s.sessionToken IS UNIQUE;

CREATE INDEX session_session_token_index IF NOT EXISTS
FOR (s:Session) ON (s.sessionToken);

CREATE CONSTRAINT account_provider_composite_constraint IF NOT EXISTS
ON (a:Account) ASSERT (a.provider, a.providerAccountId) IS NODE KEY;

CREATE INDEX account_provider_composite_index IF NOT EXISTS
FOR (a:Account) ON (a.provider, a.providerAccountId);

CREATE CONSTRAINT verification_token_composite_constraint IF NOT EXISTS
ON (v:VerificationToken) ASSERT (v.identifier, v.token) IS NODE KEY;

CREATE INDEX verification_token_composite_index IF NOT EXISTS
FOR (v:VerificationToken) ON (v.identifier, v.token);

CREATE INDEX rep_orgid_index IF NOT EXISTS
FOR (r:Rep) ON (r.orgId);

CREATE INDEX rep_id_index IF NOT EXISTS
FOR (r:Rep) ON (r.id);

CREATE INDEX role_orgid_index IF NOT EXISTS
FOR (r:Role) ON (r.orgId);

CREATE INDEX role_id_index IF NOT EXISTS
FOR (r:Role) ON (r.id);

CREATE INDEX ramp_orgid_index IF NOT EXISTS
FOR (r:Ramp) ON (r.orgId);

CREATE INDEX ramp_id_index IF NOT EXISTS
FOR (r:Ramp) ON (r.id);