CREATE DATABASE IF NOT EXISTS multiapp_panel;
USE multiapp_panel;

CREATE TABLE apps (
    id INT AUTO_INCREMENT PRIMARY KEY,
    app_name VARCHAR(150) NOT NULL,
    package_name VARCHAR(200) NOT NULL,
    website_url VARCHAR(255) NOT NULL,
    firebase_project_id VARCHAR(200) NOT NULL,
    fcm_topic VARCHAR(150) NOT NULL,
    service_account_file VARCHAR(255) NOT NULL,
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);