-- DROP TABLE IF EXISTS video_galleries;
-- DROP TABLE IF EXISTS galleries;


CREATE TABLE galleries (
    id CHAR(36) PRIMARY KEY,
    image_url VARCHAR(500) NOT NULL,
    sorting INT NOT NULL DEFAULT 0,
    is_home_page BOOLEAN NOT NULL DEFAULT FALSE,
    is_popup_show BOOLEAN NOT NULL DEFAULT FALSE,
    is_deleted BOOLEAN NOT NULL DEFAULT FALSE,
    is_active BOOLEAN NOT NULL DEFAULT TRUE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);


CREATE TABLE video_galleries (
    id CHAR(36) PRIMARY KEY,
    filename VARCHAR(255) NOT NULL,
    video_url VARCHAR(500) NOT NULL,
    sorting INT NOT NULL DEFAULT 0,
    is_deleted BOOLEAN NOT NULL DEFAULT FALSE,
    is_active BOOLEAN NOT NULL DEFAULT TRUE,
    is_home_page BOOLEAN NOT NULL DEFAULT FALSE,
    is_popup_show BOOLEAN NOT NULL DEFAULT FALSE,
    is_top_slide BOOLEAN NOT NULL DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);