CREATE TABLE `brand_chat_sessions` (
  `id` varchar(36) NOT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `messages` longtext DEFAULT NULL,
  `question_session` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE `chat_id_mapping` (
  `id` varchar(36) NOT NULL,
  `chat_id` longtext NOT NULL,
  `first_question` varchar(5000) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `update_time` DATETIME NULL,
  `people_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE chatbot (
    id INT AUTO_INCREMENT PRIMARY KEY,
    agent_image VARCHAR(2048) NULL,
    company_name VARCHAR(255) NULL,
    nickname VARCHAR(255) NULL,
    role VARCHAR(255) NULL,
    response_length VARCHAR(255) NULL,
    embedding_model VARCHAR(255) NULL,
    system_prompt TEXT NULL,
    website_urls longtext NULL,
    update_time DATETIME NULL,
    created_at DATETIME NULL
);


CREATE TABLE chatbot_session (
    id VARCHAR(36) PRIMARY KEY, 
    chatbot_id INT NOT NULL,
    first_question VARCHAR(5000) NULL,
    messages longtext DEFAULT NULL,
    user_id VARCHAR(255) NULL,
    update_time DATETIME NULL
);

CREATE TABLE chatbot_files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    url VARCHAR(2048) NULL,
    chatbot_id INT NOT NULL,
    file_name VARCHAR(255) NULL,
    uploaded_at DATETIME NULL,
    file_use VARCHAR(255) NULL
);

CREATE TABLE chatbot_url (
    id VARCHAR(36) NOT NULL PRIMARY KEY,
    chatbot_id INT NOT NULL,
    url VARCHAR(2048) NOT NULL,
    embed_model VARCHAR(10) NULL
);