Форум пользователей MySQL

CREATE TABLE news_portal
(id INT AUTO_INCREMENT,
title VARCHAR(100),
description TEXT,
date DATE,
author VARCHAR(30),
author_id INT,
PRIMARY KEY (id))
ENGINE InnoDB CHARACTER SET utf8;

CREATE TABLE screens
(id INT AUTO_INCREMENT,
serieID INT,
reliz_id INT,
full_image_location TEXT,
prev_location TEXT,
PRIMARY KEY(id))
ENGINE InnoDB CHARACTER SET utf8;

CREATE TABLE user_list
(id INT AUTO_INCREMENT,
login VARCHAR(15),
password VARCHAR(255),
ban BOOL,
avatar_image VARCHAR(255),
avatar_location VARCHAR(255),
total_news INT,
total_relizes INT,
total_coments INT,
user_class VARCHAR(20),
user_status VARCHAR(20),
sex VARCHAR(6),
PRIMARY KEY(id))
ENGINE InnoDB CHARACTER SET utf8;

CREATE TABLE series
(id INT AUTO_INCREMENT,
reliz_id INT,
serial_number INT,
serial_title VARCHAR(50),
original_title VARCHAR(50),
description TEXT,
technical_date TEXT,
PRIMARY KEY(id))
ENGINE InnoDB CHARACTER SET utf8;

ALTER TABLE screens
ADD FOREIGN KEY(reliz_id)
REFERENCES relizes(id)
ON DELETE CASCADE;