diff options
| author |   BT2983 <BT2983@att.com> | 2018-07-23 23:51:20 -0600 |
|---|---|---|
| committer | BT2983 <BT2983@att.com> | 2018-07-23 23:51:20 -0600 |
| commit | f5da5198e43addc77989dee8b500cb69e9885f93 (patch) | |
| tree | d68226f2b418787e012bd044f57dea60b1b2a331 /ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql | |
| parent | 3437d0aa56f7c0630cbd1b9074579f7e0f8a44ae (diff) | |
Adding naming micro-service code - more tests.
Integration tests and more unit tests.
Change-Id: Id3500085a43ff817d04d8f407e5cdbc4271dfb35
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/create_base_tables.sql')
| -rw-r--r-- | ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql index f79dd3fc..4cfe05c8 100644 --- a/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql +++ b/ms/neng/src/main/resources/db/changelog/scripts/rel_18_10/create_base_tables.sql @@ -10,14 +10,14 @@ NAME VARCHAR(500) COMMENT 'Generated name', PREFIX VARCHAR(100) COMMENT 'The prefix for the name. (The part of the name before the sequence number.)', SUFFIX VARCHAR(100) COMMENT 'The suffix for the name. (The part of the name after the sequence number.)', IS_RELEASED CHAR(1) COMMENT 'Indicating if the entry is released/unassigned', -CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP, +CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, CREATED_BY VARCHAR(50), LAST_UPDATED_TIME DATETIME, LAST_UPDATED_BY VARCHAR(50)) AUTO_INCREMENT=100; -- COMMENT 'TABLE TO STORE GENERATED NAMES'; CREATE TABLE SERVICE_PARAMETER (SERVICE_PARAMETER_ID INTEGER PRIMARY KEY AUTO_INCREMENT, -NAME VARCHAR(500) COMMENT 'Parameter name' NOT NULL UNIQUE, +NAME VARCHAR(500) NOT NULL COMMENT 'Parameter name', VALUE VARCHAR(500) COMMENT 'Parameter value', CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP, CREATED_BY VARCHAR(50), @@ -26,7 +26,7 @@ LAST_UPDATED_BY VARCHAR(50) ) AUTO_INCREMENT=100; CREATE TABLE IDENTIFIER_MAP (IDENTIFIER_MAP_ID INTEGER PRIMARY KEY AUTO_INCREMENT, -POLICY_FN_NAME VARCHAR(500) COMMENT 'Function name in policy manager' NOT NULL UNIQUE, +POLICY_FN_NAME VARCHAR(500) COMMENT 'Function name in policy manager' NOT NULL, JS_FN_NAME VARCHAR(500) COMMENT 'Equivalent name in Java or script', CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP, CREATED_BY VARCHAR(50), |