CREATE TABLE blc_scheduled_job (id VARCHAR(36) NOT NULL, author VARCHAR(255), cron VARCHAR(255), enabled CHAR(1) DEFAULT 'Y' NOT NULL, executed CHAR(1) DEFAULT 'N' NOT NULL, last_executed TIMESTAMP WITHOUT TIME ZONE, manage_in_admin CHAR(1) DEFAULT 'N' NOT NULL, name VARCHAR(255), target_date TIMESTAMP WITHOUT TIME ZONE, timing_type VARCHAR(60), trk_archived CHAR(1) DEFAULT 'N' NOT NULL, trk_change_details VARCHAR(10485760), trk_tenant_id VARCHAR(36), type VARCHAR(60), updated TIMESTAMP WITHOUT TIME ZONE, CONSTRAINT blc_scheduled_job_pkey PRIMARY KEY (id));
CREATE TABLE blc_notification_state (id VARCHAR(36) NOT NULL, acked CHAR(1) DEFAULT 'N' NOT NULL, attempts INTEGER, change_timestamp TIMESTAMP WITHOUT TIME ZONE, change_timestamp_ack TIMESTAMP WITHOUT TIME ZONE, container VARCHAR(36), entity_type VARCHAR(255) NOT NULL, message_type VARCHAR(255), message_value VARCHAR(10485760), notification_name VARCHAR(255), next_attempt TIMESTAMP WITHOUT TIME ZONE, stopped CHAR(1) DEFAULT 'N' NOT NULL, CONSTRAINT blc_notification_state_pkey PRIMARY KEY (id));
CREATE TABLE blc_resource_lock (id VARCHAR(36) NOT NULL, concept_key VARCHAR(255), context_id VARCHAR(36), lock_expiration_timestamp TIMESTAMP WITHOUT TIME ZONE, locked CHAR(1) DEFAULT 'N', sandbox_id VARCHAR(36), lock_timestamp TIMESTAMP WITHOUT TIME ZONE, token VARCHAR(255), type_alias VARCHAR(255), CONSTRAINT blc_resource_lock_pkey PRIMARY KEY (id));
CREATE TABLE blc_scheduled_job_detail (job_id VARCHAR(255) NOT NULL, name VARCHAR(60) NOT NULL, value_sha VARCHAR(255) NOT NULL, value VARCHAR(65535) NOT NULL, details_order INTEGER, CONSTRAINT blc_scheduled_job_detail_pkey PRIMARY KEY (job_id, name, value_sha));
ALTER TABLE blc_scheduled_job_detail ADD CONSTRAINT fkeyphrinaon47uv7ojkbvbkp14 FOREIGN KEY (job_id) REFERENCES blc_scheduled_job (id) ON UPDATE NO ACTION ON DELETE NO ACTION;
CREATE INDEX idx7i0i5vcl1dkkwuq5dyc88wem5 ON blc_notification_state(acked);
CREATE INDEX idxgfaqe3xmq5q4yh78mix1g04fy ON blc_notification_state(container);
CREATE INDEX idxkm4y3qj3jh2mpt0rt6l6vscl8 ON blc_resource_lock(token);
ALTER TABLE blc_resource_lock ADD CONSTRAINT uk7iegjt4gojv24q9bw8k0i4j0c UNIQUE (context_id, type_alias, sandbox_id, concept_key);
CREATE INDEX fkeyphrinaon47uv7ojkbvbkp14_idx ON blc_scheduled_job_detail(job_id);