DROP SEQUENCE EESRV.SERVICE_USER_S;

CREATE SEQUENCE EESRV.SERVICE_USER_S
  START WITH 1654
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_USER_S FOR EESRV.SERVICE_USER_S;


GRANT SELECT ON EESRV.SERVICE_USER_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_USER_H_S;

CREATE SEQUENCE EESRV.SERVICE_USER_H_S
  START WITH 3157
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_USER_H_S FOR EESRV.SERVICE_USER_H_S;


GRANT SELECT ON EESRV.SERVICE_USER_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_REQUEST_S;

CREATE SEQUENCE EESRV.SERVICE_REQUEST_S
  START WITH 1054
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_REQUEST_S FOR EESRV.SERVICE_REQUEST_S;


GRANT SELECT ON EESRV.SERVICE_REQUEST_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_REQUEST_H_S;

CREATE SEQUENCE EESRV.SERVICE_REQUEST_H_S
  START WITH 2455
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_REQUEST_H_S FOR EESRV.SERVICE_REQUEST_H_S;


GRANT SELECT ON EESRV.SERVICE_REQUEST_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_REQUEST_ASSIGNMENT_S;

CREATE SEQUENCE EESRV.SERVICE_REQUEST_ASSIGNMENT_S
  START WITH 2255
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_REQUEST_ASSIGNMENT_S FOR EESRV.SERVICE_REQUEST_ASSIGNMENT_S;


GRANT SELECT ON EESRV.SERVICE_REQUEST_ASSIGNMENT_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_REQUEST_ASSIGNMENT_H_S;

CREATE SEQUENCE EESRV.SERVICE_REQUEST_ASSIGNMENT_H_S
  START WITH 2959
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_REQUEST_ASSIGNMENT_H_S FOR EESRV.SERVICE_REQUEST_ASSIGNMENT_H_S;


GRANT SELECT ON EESRV.SERVICE_REQUEST_ASSIGNMENT_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.SERVICE_LOG_S;

CREATE SEQUENCE EESRV.SERVICE_LOG_S
  START WITH 29516360
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM SERVICE_LOG_S FOR EESRV.SERVICE_LOG_S;


GRANT SELECT ON EESRV.SERVICE_LOG_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.REQUEST_GROUP_S;

CREATE SEQUENCE EESRV.REQUEST_GROUP_S
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM REQUEST_GROUP_S FOR EESRV.REQUEST_GROUP_S;


GRANT SELECT ON EESRV.REQUEST_GROUP_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.REQUEST_GROUP_H_S;

CREATE SEQUENCE EESRV.REQUEST_GROUP_H_S
  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM REQUEST_GROUP_H_S FOR EESRV.REQUEST_GROUP_H_S;


GRANT SELECT ON EESRV.REQUEST_GROUP_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.REQUEST_FIELD_S;

CREATE SEQUENCE EESRV.REQUEST_FIELD_S
  START WITH 7163
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM REQUEST_FIELD_S FOR EESRV.REQUEST_FIELD_S;


GRANT SELECT ON EESRV.REQUEST_FIELD_S TO EESRV_SEQ_R;
DROP SEQUENCE EESRV.REQUEST_FIELD_H_S;

CREATE SEQUENCE EESRV.REQUEST_FIELD_H_S
  START WITH 15590
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM REQUEST_FIELD_H_S FOR EESRV.REQUEST_FIELD_H_S;


GRANT SELECT ON EESRV.REQUEST_FIELD_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.FIELD_H_S;

CREATE SEQUENCE EESRV.FIELD_H_S
  START WITH 1269
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM FIELD_H_S FOR EESRV.FIELD_H_S;


GRANT SELECT ON EESRV.FIELD_H_S TO EESRV_H_SEQ_R;
DROP SEQUENCE EESRV.FIELD_GROUP_H_S;

CREATE SEQUENCE EESRV.FIELD_GROUP_H_S
  START WITH 355
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM FIELD_GROUP_H_S FOR EESRV.FIELD_GROUP_H_S;


GRANT SELECT ON EESRV.FIELD_GROUP_H_S TO EESRV_H_SEQ_R;
