CREATE TABLE USM_COUNT_QUEUE
(
ID BIGSERIAL,
PRODUCT BIGINT NOT NULL,
DATE_ADDED DATETIME YEAR TO FRACTION(3),
ADDED_COUNTS BIGINT NOT NULL,
PARTITION_NAME LVARCHAR(600),
FEATURE_NAME NVARCHAR(255),
AUDITED INT DEFAULT 0
) extent size 32 next size 32 lock mode row;
CREATE INDEX IX_USM_COUNT_QUEUE ON USM_COUNT_QUEUE (ID);
drop table USM_COUNT_AUDIT;
CREATE TABLE USM_COUNT_AUDIT
(
ID BIGSERIAL,
DATE_ADDED DATETIME YEAR TO FRACTION(3),
INTERACT BIGINT NOT NULL,
MKT_OPR BIGINT NOT NULL,
MKT_OPR_ENTR BIGINT NOT NULL,
CAMPAIGN BIGINT NOT NULL,
CNT_OPT BIGINT NOT NULL,
PLATFORM BIGINT NOT NULL,
DELIVER BIGINT NOT NULL,
JOURNEY BIGINT NOT NULL,
LINK_CONNECTOR BIGINT NOT NULL,
ENT_DETAILS CLOB
) extent size 32 next size 32 lock mode row;
CREATE INDEX IX_USM_COUNT_AUDIT ON USM_COUNT_AUDIT (ID);
drop table USM_CAMPAIGN_PART_COUNT;
CREATE TABLE USM_CAMPAIGN_PART_COUNT
(
ID BIGINT NOT NULL,
PRODUCT BIGINT NOT NULL,
PARTITION_NAME BIGINT NOT NULL,
UPDATED_ON DATETIME YEAR TO FRACTION(3) NOT NULL,
LAST_COUNT BIGINT NOT NULL,
PRIMARY KEY (ID)
) extent size 32 next size 32 lock mode row;
CREATE SEQUENCE USM_CAMPAIGN_PART_COUNT_SEQ START WITH 1 INCREMENT BY 1;
DROP TABLE USM_NOTIFICATION_RULE;
drop TABLE USM_CLIENT_DETAILS;
CREATE TABLE USM_CLIENT_DETAILS
(
APPL_NAME LVARCHAR(256) NOT NULL,
CLIENT_ID INT NOT NULL,
CLIENT_SECRET LVARCHAR(256) NOT NULL
) extent size 32 next size 32 lock mode row;
CREATE UNIQUE INDEX IX_USM_CLIENT_DETAILS_APP ON USM_CLIENT_DETAILS (APPL_NAME asc);
CREATE TABLE USM_NOTIFICATION_RULE
(
ID BIGSERIAL,
NAME NVARCHAR(120) NOT NULL,
TYPE INT NOT NULL,
data LVARCHAR(1035)
) extent size 32 next size 32 lock mode row;
CREATE SEQUENCE USM_NOTIFICATION_RULE_SEQ START WITH 1 INCREMENT BY 1;
CREATE UNIQUE INDEX IX_USM_NOTIFICATION_RULE ON USM_NOTIFICATION_RULE (NAME asc);
alter table USM_CAMPAIGN_PART_COUNT modify partition_name LVARCHAR(1024) not null;
alter table USM_CAMPAIGN_PART_COUNT modify id BIGSERIAL;