CREATE TABLE voucher_online_settings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
package_id TEXT NOT NULL UNIQUE,
profile TEXT NOT NULL,
enabled INTEGER NOT NULL DEFAULT 1,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
agent_price DECIMAL(10,2) DEFAULT 0.00,
commission_amount DECIMAL(10,2) DEFAULT 0.00,
is_active BOOLEAN DEFAULT 1,
price INTEGER DEFAULT 0,
name TEXT,
digits INTEGER DEFAULT 5,
duration INTEGER DEFAULT 24,
duration_type TEXT DEFAULT 'hours'
)