text: --
  -- Copyright (c) 2012 - 2020 Arvato Systems GmbH
  --
  -- Licensed under the Apache License, Version 2.0 (the "License");
  -- you may not use this file except in compliance with the License.
  -- You may obtain a copy of the License at
  --
  --     http://www.apache.org/licenses/LICENSE-2.0
  --
  -- Unless required by applicable law or agreed to in writing, software
  -- distributed under the License is distributed on an "AS IS" BASIS,
  -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  -- See the License for the specific language governing permissions and
  -- limitations under the License.
  --
  
  -- set NOCACHE, as caching is done by the application
  DROP SEQUENCE cm_idgen_0000_seq;
  DROP SEQUENCE cm_idgen_0001_seq;
  DROP SEQUENCE cm_idgen_0002_seq;
  DROP SEQUENCE cm_idgen_0003_seq;
  DROP SEQUENCE cm_idgen_0004_seq;
  DROP SEQUENCE cm_idgen_0005_seq;
  DROP SEQUENCE cm_idgen_0006_seq;
  DROP SEQUENCE cm_idgen_0007_seq;
  DROP SEQUENCE cm_idgen_0008_seq;
  DROP SEQUENCE cm_idgen_0009_seq;
  DROP SEQUENCE cm_idgen_0010_seq;
  DROP SEQUENCE cm_idgen_0011_seq;
  DROP SEQUENCE cm_idgen_0012_seq;
  DROP SEQUENCE cm_idgen_0013_seq;
  DROP SEQUENCE cm_idgen_0014_seq;
  DROP SEQUENCE cm_idgen_0015_seq;
  DROP SEQUENCE cm_idgen_0016_seq;
  DROP SEQUENCE cm_idgen_0017_seq;
  DROP SEQUENCE cm_idgen_0018_seq;
  DROP SEQUENCE cm_idgen_0019_seq;
  DROP SEQUENCE cm_idgen_0020_seq;
  DROP SEQUENCE cm_idgen_0021_seq;
  DROP SEQUENCE cm_idgen_0022_seq;
  DROP SEQUENCE cm_idgen_0023_seq;
  DROP SEQUENCE cm_idgen_0024_seq;
  DROP SEQUENCE cm_idgen_0025_seq;
  DROP SEQUENCE cm_idgen_0026_seq;
  DROP SEQUENCE cm_idgen_0027_seq;
  DROP SEQUENCE cm_idgen_0028_seq;
  DROP SEQUENCE cm_idgen_0029_seq;
  DROP SEQUENCE cm_idgen_0030_seq;
  DROP SEQUENCE cm_idgen_0031_seq;
  DROP SEQUENCE cm_idgen_0032_seq;
  DROP SEQUENCE cm_idgen_0033_seq;
  DROP SEQUENCE cm_idgen_0034_seq;
  DROP SEQUENCE cm_idgen_0035_seq;
  DROP SEQUENCE cm_idgen_0036_seq;
  DROP SEQUENCE cm_idgen_0037_seq;
  DROP SEQUENCE cm_idgen_0038_seq;
  DROP SEQUENCE cm_idgen_0039_seq;
  DROP SEQUENCE cm_idgen_0040_seq;
  DROP SEQUENCE cm_idgen_0041_seq;
  DROP SEQUENCE cm_idgen_0042_seq;
  DROP SEQUENCE cm_idgen_0043_seq;
  DROP SEQUENCE cm_idgen_0044_seq;
  DROP SEQUENCE cm_idgen_0045_seq;
  DROP SEQUENCE cm_idgen_0046_seq;
  DROP SEQUENCE cm_idgen_0047_seq;
  DROP SEQUENCE cm_idgen_0048_seq;
  DROP SEQUENCE cm_idgen_0049_seq;
  DROP SEQUENCE cm_idgen_0050_seq;
  DROP SEQUENCE cm_idgen_0051_seq;
  DROP SEQUENCE cm_idgen_0052_seq;
  DROP SEQUENCE cm_idgen_0053_seq;
  DROP SEQUENCE cm_idgen_0054_seq;
  DROP SEQUENCE cm_idgen_0055_seq;
  DROP SEQUENCE cm_idgen_0056_seq;
  DROP SEQUENCE cm_idgen_0057_seq;
  DROP SEQUENCE cm_idgen_0058_seq;
  DROP SEQUENCE cm_idgen_0059_seq;
  DROP SEQUENCE cm_idgen_0060_seq;
  DROP SEQUENCE cm_idgen_0061_seq;
  DROP SEQUENCE cm_idgen_0062_seq;
  DROP SEQUENCE cm_idgen_0063_seq;
  DROP SEQUENCE cm_idgen_0064_seq;
  DROP SEQUENCE cm_idgen_0065_seq;
  DROP SEQUENCE cm_idgen_0066_seq;
  DROP SEQUENCE cm_idgen_0067_seq;
  DROP SEQUENCE cm_idgen_0068_seq;
  DROP SEQUENCE cm_idgen_0069_seq;
  DROP SEQUENCE cm_idgen_0070_seq;
  DROP SEQUENCE cm_idgen_0071_seq;
  DROP SEQUENCE cm_idgen_0072_seq;
  DROP SEQUENCE cm_idgen_0073_seq;
  DROP SEQUENCE cm_idgen_0074_seq;
  DROP SEQUENCE cm_idgen_0075_seq;
  DROP SEQUENCE cm_idgen_0076_seq;
  DROP SEQUENCE cm_idgen_0077_seq;
  DROP SEQUENCE cm_idgen_0078_seq;
  DROP SEQUENCE cm_idgen_0079_seq;
  DROP SEQUENCE cm_idgen_0080_seq;
  DROP SEQUENCE cm_idgen_0081_seq;
  DROP SEQUENCE cm_idgen_0082_seq;
  DROP SEQUENCE cm_idgen_0083_seq;
  DROP SEQUENCE cm_idgen_0084_seq;
  DROP SEQUENCE cm_idgen_0085_seq;
  DROP SEQUENCE cm_idgen_0086_seq;
  DROP SEQUENCE cm_idgen_0087_seq;
  DROP SEQUENCE cm_idgen_0088_seq;
  DROP SEQUENCE cm_idgen_0089_seq;
  DROP SEQUENCE cm_idgen_0090_seq;
  DROP SEQUENCE cm_idgen_0091_seq;
  DROP SEQUENCE cm_idgen_0092_seq;
  DROP SEQUENCE cm_idgen_0093_seq;
  DROP SEQUENCE cm_idgen_0094_seq;
  DROP SEQUENCE cm_idgen_0095_seq;
  DROP SEQUENCE cm_idgen_0096_seq;
  DROP SEQUENCE cm_idgen_0097_seq;
  DROP SEQUENCE cm_idgen_0098_seq;
  DROP SEQUENCE cm_idgen_0099_seq;
  CREATE SEQUENCE cm_idgen_0000_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0001_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0002_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0003_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0004_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0005_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0006_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0007_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0008_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0009_seq NOCACHE START WITH 200000;
  CREATE SEQUENCE cm_idgen_0010_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0011_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0012_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0013_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0014_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0015_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0016_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0017_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0018_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0019_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0020_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0021_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0022_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0023_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0024_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0025_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0026_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0027_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0028_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0029_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0030_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0031_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0032_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0033_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0034_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0035_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0036_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0037_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0038_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0039_seq NOCACHE START WITH 500000;
  CREATE SEQUENCE cm_idgen_0040_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0041_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0042_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0043_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0044_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0045_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0046_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0047_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0048_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0049_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0050_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0051_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0052_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0053_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0054_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0055_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0056_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0057_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0058_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0059_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0060_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0061_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0062_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0063_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0064_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0065_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0066_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0067_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0068_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0069_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0070_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0071_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0072_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0073_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0074_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0075_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0076_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0077_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0078_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0079_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0080_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0081_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0082_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0083_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0084_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0085_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0086_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0087_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0088_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0089_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0090_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0091_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0092_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0093_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0094_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0095_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0096_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0097_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0098_seq NOCACHE START WITH 1000000;
  CREATE SEQUENCE cm_idgen_0099_seq NOCACHE START WITH 1000000;
  