site_for_text_like_pastebin

drop TABLE `user`;
drop TABLE `text`;


CREATE TABLE `user`
(
    id_user int PRIMARY KEY AUTO_INCREMENT,
    email VARCHAR(200) UNIQUE NOT NULL,
    status BOOLEAN DEFAULT FALSE,
    password VARCHAR(200) NOT NULL,
    legacy_password_hash VARCHAR(200) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE `text`
(
    id_text int PRIMARY KEY AUTO_INCREMENT,
    id_user int,
    title VARCHAR(200) NOT NULL,
    content text NOT NULL,
    sintax VARCHAR(20) DEFAULT 'text',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT fk_text_user,
        FOREIGN KEY(id_user) REFERENCES `user`(id_user)
            ON DELETE CASCADE
            ON UPDATE CASCADE
);



SELECT * from `user`;

SELECT * FROM `text`;