diff options
author | BT2983 <BT2983@att.com> | 2018-07-23 13:11:35 -0600 |
---|---|---|
committer | BT2983 <BT2983@att.com> | 2018-07-23 13:11:35 -0600 |
commit | 5a398289dee4b666528aa77f4e38f9c68d35b254 (patch) | |
tree | 6e6f7215778424beacdd3637ddffa289fc35c39f /ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql | |
parent | 84b6500a6c3a95b927df2fa90cdf8453ed2a028b (diff) |
Adding naming micro-service code - scripts.
Docker and DB scripts.
Change-Id: I2e9e153f6c72e5f5d6ee86cc9dfc275ec77b4642
Issue-ID: CCSDK-342
Signed-off-by: BT2983 <BT2983@att.com>
Diffstat (limited to 'ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql')
-rw-r--r-- | ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql new file mode 100644 index 00000000..65562424 --- /dev/null +++ b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/02_create_indexes_ddl.sql @@ -0,0 +1,8 @@ +--liquibase formatted sql +--changeset index_creation:18_10.create_indexes_01.sql + +-- Add indexes on GENERATED_NAME + +create index gen_name_ext_id_idx on GENERATED_NAME(EXTERNAL_ID); +create index gen_name_name_idx on GENERATED_NAME(NAME); +create index gen_name_pre_suf_idx on GENERATED_NAME(PREFIX, SUFFIX); |