| 36305 |
amit |
1 |
CREATE TABLE IF NOT EXISTS transaction.cron_batch (
|
|
|
2 |
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
|
3 |
job_name VARCHAR(100) NOT NULL,
|
|
|
4 |
status VARCHAR(20) NOT NULL DEFAULT 'RUNNING',
|
|
|
5 |
total_count INT NOT NULL DEFAULT 0,
|
|
|
6 |
success_count INT NOT NULL DEFAULT 0,
|
|
|
7 |
failure_count INT NOT NULL DEFAULT 0,
|
|
|
8 |
started_at DATETIME NOT NULL,
|
|
|
9 |
completed_at DATETIME,
|
|
|
10 |
INDEX idx_cron_batch_job_status (job_name, status),
|
|
|
11 |
INDEX idx_cron_batch_started (started_at)
|
|
|
12 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
13 |
|
|
|
14 |
CREATE TABLE IF NOT EXISTS transaction.cron_batch_item (
|
|
|
15 |
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
|
16 |
batch_id INT NOT NULL,
|
|
|
17 |
fofo_id INT NOT NULL,
|
|
|
18 |
partner_name VARCHAR(200),
|
|
|
19 |
status VARCHAR(20) NOT NULL DEFAULT 'PENDING',
|
|
|
20 |
error_message VARCHAR(500),
|
|
|
21 |
started_at DATETIME,
|
|
|
22 |
completed_at DATETIME,
|
|
|
23 |
INDEX idx_cron_batch_item_batch_status (batch_id, status),
|
|
|
24 |
INDEX idx_cron_batch_item_fofo (fofo_id),
|
|
|
25 |
CONSTRAINT fk_cron_batch_item_batch FOREIGN KEY (batch_id) REFERENCES cron_batch(id)
|
|
|
26 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|