DROP SEQUENCE ADRMGT.RELEASE_S;

CREATE SEQUENCE ADRMGT.RELEASE_S
  START WITH 7171
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.RELEASE_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.RELEASE_H_S;

CREATE SEQUENCE ADRMGT.RELEASE_H_S
  START WITH 7072
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.RELEASE_H_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.JOB_PROCESS_LOGS_ID_S;

CREATE SEQUENCE ADRMGT.JOB_PROCESS_LOGS_ID_S
  START WITH 715402
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM JOB_PROCESS_LOGS_ID_S FOR ADRMGT.JOB_PROCESS_LOGS_ID_S;


GRANT SELECT ON ADRMGT.JOB_PROCESS_LOGS_ID_S TO ADR;

GRANT SELECT ON ADRMGT.JOB_PROCESS_LOGS_ID_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.JOB_PROCESS_ERRS_ID_S;

CREATE SEQUENCE ADRMGT.JOB_PROCESS_ERRS_ID_S
  START WITH 3755
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM JOB_PROCESS_ERRS_ID_S FOR ADRMGT.JOB_PROCESS_ERRS_ID_S;


GRANT SELECT ON ADRMGT.JOB_PROCESS_ERRS_ID_S TO ADR;

GRANT SELECT ON ADRMGT.JOB_PROCESS_ERRS_ID_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.DEPLOYMENT_S;

CREATE SEQUENCE ADRMGT.DEPLOYMENT_S
  START WITH 10483
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.DEPLOYMENT_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.DEPLOYMENT_H_S;

CREATE SEQUENCE ADRMGT.DEPLOYMENT_H_S
  START WITH 14540
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.DEPLOYMENT_H_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.CCR_S;

CREATE SEQUENCE ADRMGT.CCR_S
  START WITH 10784
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.CCR_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.CCR_H_S;

CREATE SEQUENCE ADRMGT.CCR_H_S
  START WITH 13265
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.CCR_H_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.ADR_USER_CONTACT_S;

CREATE SEQUENCE ADRMGT.ADR_USER_CONTACT_S
  START WITH 4212
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.ADR_USER_CONTACT_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.ADR_USER_CONTACT_H_S;

CREATE SEQUENCE ADRMGT.ADR_USER_CONTACT_H_S
  START WITH 9992
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


GRANT SELECT ON ADRMGT.ADR_USER_CONTACT_H_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.ADR_PARAMETER_ID_S;

CREATE SEQUENCE ADRMGT.ADR_PARAMETER_ID_S
  START WITH 55
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;


GRANT SELECT ON ADRMGT.ADR_PARAMETER_ID_S TO ADRMGT_SEQ_R;
DROP SEQUENCE ADRMGT.ADR_PARAMETER_H_ID_S;

CREATE SEQUENCE ADRMGT.ADR_PARAMETER_H_ID_S
  START WITH 3944
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;


GRANT SELECT ON ADRMGT.ADR_PARAMETER_H_ID_S TO ADRMGT_SEQ_R;
