Query
CREATE TABLE agents (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
name TEXT NOT NULL,
phone TEXT UNIQUE NOT NULL,
email TEXT,
password TEXT NOT NULL,
address TEXT,
status TEXT DEFAULT 'active' CHECK (status IN ('active', 'inactive', 'suspended')),
commission_rate DECIMAL(5,2) DEFAULT 5.00,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
)