DROP SEQUENCE PATS.BOILERPLATE_TEXT_SEQ;

CREATE SEQUENCE PATS.BOILERPLATE_TEXT_SEQ
  START WITH 722
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.COMPS_SEQ;

CREATE SEQUENCE PATS.COMPS_SEQ
  START WITH 919
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.CONGRESSIONAL_CONTACT_SEQ;

CREATE SEQUENCE PATS.CONGRESSIONAL_CONTACT_SEQ
  START WITH 4951
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.CONTACTING_ENTITY_SEQ;

CREATE SEQUENCE PATS.CONTACTING_ENTITY_SEQ
  START WITH 13
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.DMLOG_SEQ;

CREATE SEQUENCE PATS.DMLOG_SEQ
  START WITH 1009
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 5
  NOORDER;
DROP SEQUENCE PATS.FACILITY_SERV_OR_SECT_SEQ;

CREATE SEQUENCE PATS.FACILITY_SERV_OR_SECT_SEQ
  START WITH 8208
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.HOSPITAL_LOCATION_SEQ;

CREATE SEQUENCE PATS.HOSPITAL_LOCATION_SEQ
  START WITH 82406
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.METHOD_OF_CONTACT_SEQ;

CREATE SEQUENCE PATS.METHOD_OF_CONTACT_SEQ
  START WITH 11
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.NOTIFICATION_DETAIL_SEQ;

CREATE SEQUENCE PATS.NOTIFICATION_DETAIL_SEQ
  START WITH 1396417
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.NOTIFICATION_MASTER_SEQ;

CREATE SEQUENCE PATS.NOTIFICATION_MASTER_SEQ
  START WITH 832708
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.PATS_PATIENT_RACE_SEQ;

CREATE SEQUENCE PATS.PATS_PATIENT_RACE_SEQ
  START WITH 1891080
  MAXVALUE 999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.PATS_PATIENT_SEQ;

CREATE SEQUENCE PATS.PATS_PATIENT_SEQ
  START WITH 2610126
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.PATS_USER_SEQ;

CREATE SEQUENCE PATS.PATS_USER_SEQ
  START WITH 175655
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.ROC_CONTACTING_ENTITY_SEQ;

CREATE SEQUENCE PATS.ROC_CONTACTING_ENTITY_SEQ
  START WITH 18754530
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.ROC_ISSUE_SEQ;

CREATE SEQUENCE PATS.ROC_ISSUE_SEQ
  START WITH 9960489
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.ROC_METHOD_OF_CONTACT_SEQ;

CREATE SEQUENCE PATS.ROC_METHOD_OF_CONTACT_SEQ
  START WITH 14582102
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.ROC_PHONE_FAX_SEQ;

CREATE SEQUENCE PATS.ROC_PHONE_FAX_SEQ
  START WITH 5342430
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.TREATMENT_STATUS_SEQ;

CREATE SEQUENCE PATS.TREATMENT_STATUS_SEQ
  START WITH 14
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.PAD_LOCATION_SEQ;

CREATE SEQUENCE PATS.PAD_LOCATION_SEQ
  START WITH 222
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
DROP SEQUENCE PATS.PATS_ROLLUP_TO_NATL_SEQ;

CREATE SEQUENCE PATS.PATS_ROLLUP_TO_NATL_SEQ
  START WITH 55485
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
