Subversion Repositories SmartDukaan

-- Flagship Credit: Schema Changes

-- Date: 2026-05-15

-- 1. Add flagship flag to catalog

ALTER TABLE catalog.catalog ADD COLUMN is_flagship TINYINT(1) NOT NULL DEFAULT 0;

-- 2. Add flagship fields + description to loan table

ALTER TABLE transaction.loan ADD COLUMN description VARCHAR(500) NULL;

ALTER TABLE transaction.loan ADD COLUMN is_flagship TINYINT(1) NOT NULL DEFAULT 0;

ALTER TABLE transaction.loan ADD COLUMN flagship_deadline DATETIME NULL;

-- 3. Add wallet flag to credit requirement

ALTER TABLE transaction.sd_credit_requirement ADD COLUMN flagship_wallet_first TINYINT(1) NOT NULL DEFAULT 1;

-- 4. Index for cron: find active flagship limit blocks past deadline

CREATE INDEX idx_loan_flagship_active ON transaction.loan (is_flagship, limit_block, settled_on, flagship_deadline);

-- 5. Index for cap validation: sum flagship amounts per partner

CREATE INDEX idx_loan_flagship_fofo ON transaction.loan (fofo_id, is_flagship, limit_block, settled_on, pending_amount);