CREATE TABLE customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT UNIQUE NOT NULL,
name TEXT NOT NULL,
phone TEXT UNIQUE NOT NULL,
pppoe_username TEXT,
email TEXT,
address TEXT,
latitude DECIMAL(10,8),
longitude DECIMAL(11,8),
package_id INTEGER,
pppoe_profile TEXT,
status TEXT DEFAULT 'active',
join_date DATETIME DEFAULT CURRENT_TIMESTAMP,
-- Cable connection fields
cable_type TEXT,
cable_length INTEGER,
port_number INTEGER,
cable_status TEXT DEFAULT 'connected',
cable_notes TEXT,
billing_day INTEGER DEFAULT 15,
auto_suspension BOOLEAN DEFAULT 1,
odp_id INTEGER,
static_ip TEXT,
mac_address TEXT,
assigned_ip TEXT,
whatsapp_lid TEXT,
password TEXT,
FOREIGN KEY (package_id) REFERENCES packages (id)
)