-- Import ONLY into mokweenterprise_pressmokwe, NEVER into the existing news database.
CREATE TABLE IF NOT EXISTS press_admins (
 id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(100) NOT NULL UNIQUE,
 password_hash VARCHAR(255) NOT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS press_drafts (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 title VARCHAR(500) NOT NULL,
 slug VARCHAR(500) NOT NULL,
 summary TEXT NULL,
 content MEDIUMTEXT NOT NULL,
 keywords VARCHAR(500) NULL,
 category_id INT NOT NULL,
 author_id INT NOT NULL,
 lang_id INT NOT NULL DEFAULT 1,
 source_url VARCHAR(1000) NULL,
 state ENUM('draft','transferred') NOT NULL DEFAULT 'draft',
 target_post_id INT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
 updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 INDEX (state), INDEX (target_post_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS press_audit (
 id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
 draft_id BIGINT UNSIGNED NULL,
 event VARCHAR(60) NOT NULL,
 details TEXT NULL,
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
