جاهزية التشغيل والتحديث

CREATE TABLE IF NOT EXISTS dm_launch_versions(version VARCHAR(80) PRIMARY KEY,checksum CHAR(64) NOT NULL,applied_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_account_controls(user_id BIGINT UNSIGNED PRIMARY KEY,state VARCHAR(20) NOT NULL,auth_version INT UNSIGNED NOT NULL DEFAULT 0,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_verification_tokens(user_id BIGINT UNSIGNED PRIMARY KEY,token_hash CHAR(64) NOT NULL UNIQUE,expires_at DATETIME NOT NULL,used_at DATETIME NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_rate_limits(key_hash CHAR(64) NOT NULL,bucket BIGINT UNSIGNED NOT NULL,attempts INT UNSIGNED NOT NULL,expires_at DATETIME NOT NULL,PRIMARY KEY(key_hash,bucket),INDEX idx_rate_expiry(expires_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_contact_meta(contact_id BIGINT UNSIGNED PRIMARY KEY,request_key CHAR(64) NOT NULL UNIQUE,payload_hash CHAR(64) NOT NULL,phone VARCHAR(40) NOT NULL DEFAULT '',budget_currency CHAR(3) NOT NULL DEFAULT '',brief_json TEXT NULL,outcome VARCHAR(20) NOT NULL DEFAULT '',created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS directory_feedback(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,business_id BIGINT UNSIGNED NOT NULL,request_key CHAR(64) NOT NULL UNIQUE,request_type VARCHAR(20) NOT NULL,from_name VARCHAR(120) NOT NULL,from_email VARCHAR(255) NOT NULL,official_url VARCHAR(1024) NOT NULL DEFAULT '',message TEXT NOT NULL,status VARCHAR(20) NOT NULL DEFAULT 'new',admin_note TEXT NULL,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,INDEX idx_feedback_status(status,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_mail_outbox(id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,event_key CHAR(64) NOT NULL UNIQUE,recipient_hash CHAR(64) NOT NULL,payload_cipher MEDIUMTEXT NULL,status VARCHAR(20) NOT NULL DEFAULT 'pending',attempts TINYINT UNSIGNED NOT NULL DEFAULT 0,available_at DATETIME NOT NULL,locked_at DATETIME NULL,accepted_at DATETIME NULL,last_error VARCHAR(160) NULL,created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,INDEX idx_outbox_due(status,available_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS dm_operation_runs(task_name VARCHAR(80) PRIMARY KEY,started_at DATETIME NULL,finished_at DATETIME NULL,status VARCHAR(20) NOT NULL,processed INT UNSIGNED NOT NULL DEFAULT 0,error_code VARCHAR(100) NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;