Add Column
Current Schema
CREATE TABLE collectors (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
phone TEXT UNIQUE NOT NULL,
email TEXT,
address TEXT,
status TEXT DEFAULT 'active' CHECK(status IN ('active', 'inactive', 'suspended')),
commission_rate DECIMAL(5,2) DEFAULT 5.00,
-- Commission percentage
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
password TEXT
)