sequences.sql

--Sewer--------------------------------------------------------------------------------
---------------------------------------------------------------------------------------

DROP SEQUENCE ssSystemValve_seq;

CREATE SEQUENCE ssSystemValve_seq
 START WITH     11102
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssCleanout_seq;

CREATE SEQUENCE ssCleanout_seq
 START WITH     174021
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssManhole_seq;

CREATE SEQUENCE ssManhole_seq
 START WITH     189680
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssNetworkStructure_seq;

CREATE SEQUENCE ssNetworkStructure_seq
 START WITH     1384
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssGreaseTrap_seq;

CREATE SEQUENCE ssGreaseTrap_seq
 START WITH     14839
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssLateralLine_seq;

CREATE SEQUENCE ssLateralLine_seq
 START WITH     181287
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssGravityMain_seq;

CREATE SEQUENCE ssGravityMain_seq
 START WITH     192816
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssForceMain_seq;

CREATE SEQUENCE ssForceMain_seq
 START WITH     14537
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssFitting_seq;

CREATE SEQUENCE ssFitting_seq
 START WITH     159000
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssControlValve_seq;

CREATE SEQUENCE ssControlValve_seq
 START WITH     11010
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssCasing_seq;

CREATE SEQUENCE ssCasing_seq
 START WITH     14245
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE ssAerial_seq;

CREATE SEQUENCE ssAerial_seq
 START WITH     11930
 INCREMENT BY   1;

---------------------------------------------------------------------------------------
--Water--------------------------------------------------------------------------------
---------------------------------------------------------------------------------------

DROP SEQUENCE wSystemValve_seq;

CREATE SEQUENCE wSystemValve_seq
 START WITH     227324
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wControlValve_seq;

CREATE SEQUENCE wControlValve_seq
 START WITH     264930
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wPressureMain_seq;

CREATE SEQUENCE wPressureMain_seq
 START WITH     264175
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wHydrant_seq;

CREATE SEQUENCE wHydrant_seq
 START WITH     171716
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wSampleStation_seq;

CREATE SEQUENCE wSampleStation_seq
 START WITH     10300
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wServiceConnection_seq;

CREATE SEQUENCE wServiceConnection_seq
 START WITH     442874
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wFitting_seq;

CREATE SEQUENCE wFitting_seq
 START WITH     286479
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wGravityMain_seq;

CREATE SEQUENCE wGravityMain_seq
 START WITH     100423
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wNetworkStructure_seq;

CREATE SEQUENCE wNetworkStructure_seq
 START WITH     10078
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wLateralLine_seq;

CREATE SEQUENCE wLateralLine_seq
 START WITH     268023
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE wCasing_seq;

CREATE SEQUENCE wCasing_seq
 START WITH     15132
 INCREMENT BY   1;

---------------------------------------------------------------------------------------
--Reuse--------------------------------------------------------------------------------
---------------------------------------------------------------------------------------

DROP SEQUENCE rCasing_seq;

CREATE SEQUENCE rCasing_seq
 START WITH     10048
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rPressureMain_seq;

CREATE SEQUENCE rPressureMain_seq
 START WITH     100666
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rNetworkStructure_seq;

CREATE SEQUENCE rNetworkStructure_seq
 START WITH     1006
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rFitting_seq;

CREATE SEQUENCE rFitting_seq
 START WITH     101790
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rServiceConnection_seq;

CREATE SEQUENCE rServiceConnection_seq
 START WITH     100032
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rHydrant_seq;

CREATE SEQUENCE rHydrant_seq
 START WITH     10017
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rSampleStation_seq;

CREATE SEQUENCE rSampleStation_seq
 START WITH     100007
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rControlValve_seq;

CREATE SEQUENCE rControlValve_seq
 START WITH     10137
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rLateralLine_seq;

CREATE SEQUENCE rLateralLine_seq
 START WITH     101247
 INCREMENT BY   1;

---------------------------------------------------------------------------------------

DROP SEQUENCE rSystemValve_seq;

CREATE SEQUENCE rSystemValve_seq
 START WITH     100272
 INCREMENT BY   1;

---------------------------------------------------------------------------------------