CREATE TABLE voucher_pricing (
id INTEGER PRIMARY KEY AUTOINCREMENT,
package_name TEXT NOT NULL,
customer_price DECIMAL(10,2) NOT NULL,
agent_price DECIMAL(10,2) NOT NULL,
commission_amount DECIMAL(10,2) NOT NULL,
duration INTEGER DEFAULT 0,
-- in hours
description TEXT,
is_active BOOLEAN DEFAULT 1,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
hotspot_profile TEXT,
duration_type TEXT DEFAULT 'hours',
account_type TEXT DEFAULT 'voucher',
voucher_digit_type TEXT DEFAULT 'mixed',
voucher_length INTEGER DEFAULT 8,
package_id INTEGER,
duration_hours INTEGER DEFAULT 24,
price DECIMAL(10,2),
commission DECIMAL(10,2)
)