Subversion Repositories SmartDukaan

CREATE TABLE IF NOT EXISTS transaction.cron_batch (
    id INT AUTO_INCREMENT PRIMARY KEY,
    job_name VARCHAR(100) NOT NULL,
    status VARCHAR(20) NOT NULL DEFAULT 'RUNNING',
    total_count INT NOT NULL DEFAULT 0,
    success_count INT NOT NULL DEFAULT 0,
    failure_count INT NOT NULL DEFAULT 0,
    started_at DATETIME NOT NULL,
    completed_at DATETIME,
    INDEX idx_cron_batch_job_status (job_name, status),
    INDEX idx_cron_batch_started (started_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS transaction.cron_batch_item (
    id INT AUTO_INCREMENT PRIMARY KEY,
    batch_id INT NOT NULL,
    fofo_id INT NOT NULL,
    partner_name VARCHAR(200),
    status VARCHAR(20) NOT NULL DEFAULT 'PENDING',
    error_message VARCHAR(500),
    started_at DATETIME,
    completed_at DATETIME,
    INDEX idx_cron_batch_item_batch_status (batch_id, status),
    INDEX idx_cron_batch_item_fofo (fofo_id),
    CONSTRAINT fk_cron_batch_item_batch FOREIGN KEY (batch_id) REFERENCES cron_batch(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;