tables.sql

-- Active: 1663606336975@@35.226.146.116@3306@lovelace-2147431-israel-cordeiro
CREATE TABLE IF NOT EXISTS labook_users(
            id VARCHAR(255) PRIMARY KEY,
            name VARCHAR(255) NOT NULL,
            email VARCHAR(255) UNIQUE NOT NULL,
            password VARCHAR(255) NOT NULL
         );
   
         CREATE TABLE IF NOT EXISTS labook_posts(
            id VARCHAR(255) PRIMARY KEY,
            photo VARCHAR(255) NOT NULL,
            description VARCHAR(255) NOT NULL,
            type ENUM("normal","event") DEFAULT "normal",
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            author_id VARCHAR(255),
            FOREIGN KEY (author_id) REFERENCES labook_users (id)
         );

         CREATE TABLE IF NOT EXISTS labook_friendship(
            id VARCHAR(255) PRIMARY KEY,
            user VARCHAR(255) NOT NULL,
            friendship VARCHAR(255) NOT NULL,
            FOREIGN KEY (user) REFERENCES labook_users (id),
            FOREIGN KEY (friendship) REFERENCES labook_users (id)
         )