Tables Created / Verified
CREATE TABLE IF NOT EXISTS app_settings (
id INT AUTO_INCREMENT PRIMA…
CREATE TABLE IF NOT EXISTS app_installs (
id INT AUTO_I…
CREATE TABLE IF NOT EXISTS agents (
id INT AUTO_INCREMENT …
CREATE TABLE IF NOT EXISTS agent_sessions (
id INT AUTO_INCREMENT PR…
CREATE TABLE IF NOT EXISTS license_keys (
id INT AUTO_INCREMENT PRIM…
CREATE TABLE IF NOT EXISTS categories (
id INT AUTO_INCREMENT PRIMAR…
CREATE TABLE IF NOT EXISTS services (
id INT AUTO_INCREMENT PRIMARY…
CREATE TABLE IF NOT EXISTS agent_service_prices (
id INT AUTO_INCR…
CREATE TABLE IF NOT EXISTS agent_service_visibility (
id INT AUTO_IN…
CREATE TABLE IF NOT EXISTS orders (
id INT AUTO_INCREMENT …
CREATE TABLE IF NOT EXISTS deposits (
id INT AUTO_INCREMENT PRIM…
CREATE TABLE IF NOT EXISTS device_cache (
id INT AUTO_INCREMENT PR…
CREATE TABLE IF NOT EXISTS campaign_landing_pages (
id INT AUTO_…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN first_seen DATETIME DEFAULT CURRENT_TIMESTAM…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN last_seen DATETIME…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN note TEXT…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN screenshot_allowed TINYINT(1) DEFAULT 1…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN marketing_plan VARCHAR(50)…
[ALREADY OK] ALTER TABLE app_installs ADD COLUMN marketing_plan_expires DATETIME…
[ALREADY OK] ALTER TABLE agents ADD COLUMN balance DECIMAL(10,2) DEFAULT 0.00…
[ALREADY OK] ALTER TABLE agents ADD COLUMN min_deposit DECIMAL(10,2) DEFAULT 5.00…
[ALREADY OK] ALTER TABLE agents ADD COLUMN btc_address VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN eth_address VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN usdt_address VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN sol_address VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN processing_msg_title VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN processing_msg_body TEXT…
[ALREADY OK] ALTER TABLE agents ADD COLUMN contact_link VARCHAR(255)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN app_theme VARCHAR(50) DEFAULT 'dark'…
[ALREADY OK] ALTER TABLE agents ADD COLUMN marketing_plan_1mo DECIMAL(10,2)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN marketing_plan_3mo DECIMAL(10,2)…
[ALREADY OK] ALTER TABLE agents ADD COLUMN marketing_plan_6mo DECIMAL(10,2)…
[ALREADY OK] ALTER TABLE agent_sessions ADD COLUMN expires_at DATETIME…
[ALREADY OK] ALTER TABLE license_keys ADD COLUMN label VARCHAR(255)…
[ALREADY OK] ALTER TABLE license_keys ADD COLUMN max_uses INT DEFAULT 0…
[ALREADY OK] ALTER TABLE license_keys ADD COLUMN expires_at DATE…
[ALREADY OK] ALTER TABLE license_keys ADD COLUMN is_reseller TINYINT(1) DEFAULT 0…
[ALREADY OK] ALTER TABLE license_keys ADD COLUMN reseller_discount DECIMAL(5,2) DEFAULT 0.00…
[ALREADY OK] ALTER TABLE categories ADD COLUMN is_hidden TINYINT(1) DEFAULT 0…
[ALREADY OK] ALTER TABLE services ADD COLUMN description TEXT…
[ALREADY OK] ALTER TABLE services ADD COLUMN eta_days VARCHAR(255) DEFAULT '1-3 days'…
[ALREADY OK] ALTER TABLE services ADD COLUMN time_frame VARCHAR(255) DEFAULT '12-24 Hours'…
[ALREADY OK] ALTER TABLE services ADD COLUMN priority INT DEFAULT 10…
[ALREADY OK] ALTER TABLE orders ADD COLUMN device_info LONGTEXT…
[ALREADY OK] ALTER TABLE orders ADD COLUMN customer_name VARCHAR(255)…
[ALREADY OK] ALTER TABLE orders ADD COLUMN customer_phone VARCHAR(255)…
[ALREADY OK] ALTER TABLE orders ADD COLUMN customer_email VARCHAR(255)…
[ALREADY OK] ALTER TABLE orders ADD COLUMN service_id INT…
[ALREADY OK] ALTER TABLE orders ADD COLUMN notes TEXT…
[ALREADY OK] ALTER TABLE orders ADD COLUMN eta_override_hours INT…
[ALREADY OK] ALTER TABLE orders ADD COLUMN target_eta_hours INT…
[ALREADY OK] ALTER TABLE orders ADD COLUMN processing_started_at DATETIME…
[ALREADY OK] ALTER TABLE orders ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON U…
[ALREADY OK] ALTER TABLE deposits ADD COLUMN approved_by VARCHAR(50)…
[ALREADY OK] ALTER TABLE app_settings ADD COLUMN updated_at DATETIME DEFAULT CURRENT_TIMESTAM…
Default app_settings inserted/verified (11 rows)