WARNING: option --ssl-verify-server-cert is disabled, because of an insecure passwordless login.
--------------
CREATE TABLE order_conversations (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    order_id INT UNSIGNED NOT NULL,
    user_id INT UNSIGNED NOT NULL,
    last_message_at DATETIME NULL,
    admin_read_at DATETIME NULL,
    user_read_at DATETIME NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    UNIQUE KEY uq_order (order_id),
    KEY idx_user (user_id),
    KEY idx_last_message (last_message_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
--------------

ERROR 1050 (42S01) at line 12: Table 'order_conversations' already exists
--------------
CREATE TABLE order_messages (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    conversation_id INT UNSIGNED NOT NULL,
    sender_type ENUM('user','admin') NOT NULL,
    sender_admin_id INT UNSIGNED NULL,
    body TEXT NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    KEY idx_conversation (conversation_id, created_at),
    CONSTRAINT fk_msg_conv FOREIGN KEY (conversation_id)
        REFERENCES order_conversations (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
--------------

ERROR 1050 (42S01) at line 26: Table 'order_messages' already exists