CREATE TABLE IF NOT EXISTS notes (
                id INT AUTO_INCREMENT PRIMARY KEY,
                post_uid INT NOT NULL,
                note_submitted TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
                added_by INT NULL,
                note_text TEXT NOT NULL,
                
                CONSTRAINT fk_notes_post_uid FOREIGN KEY (post_uid) REFERENCES `posts`(post_uid) ON DELETE CASCADE,
                CONSTRAINT fk_notes_added_by FOREIGN KEY (added_by) REFERENCES `accounts`(id) ON DELETE SET NULL
            ) ENGINE=InnoDB;

ALTER TABLE `deleted_posts` DROP COLUMN `note`;