ALTER TABLE feedbacks
ADD COLUMN isCustomFeedback BOOLEAN,
ADD COLUMN isSmileyFeedback BOOLEAN,
ADD COLUMN isFeedbackNegative BOOLEAN,
ADD COLUMN table_label VARCHAR(255),
ADD COLUMN phone VARCHAR(255),
ADD COLUMN created_on DATETIME,
ADD COLUMN email VARCHAR(255),
ADD COLUMN name VARCHAR(255),
ADD COLUMN room_number VARCHAR(255),
ADD COLUMN negative_color VARCHAR(255),
ADD COLUMN positive_color VARCHAR(255),
ADD COLUMN neutral_color VARCHAR(255),
ADD COLUMN feedback_id VARCHAR(255);

ALTER TABLE feedbacks MODIFY rating DECIMAL(10,2);

CREATE TABLE fb_stars (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    feedback_id BIGINT NOT NULL,
    label VARCHAR(255),
    rating FLOAT,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE fb_smileys (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    feedback_id BIGINT NOT NULL,
    label VARCHAR(255),
    rating FLOAT,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE fb_actions (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    fb_smiley_id BIGINT NOT NULL,
    label VARCHAR(255),
    state VARCHAR(255),
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);