Untitled

DROP TABLE IF EXISTS comic_publisher;CREATE TABLE comic_publisher(	publisher		VARCHAR(128),	publisher_weblink	VARCHAR(192),	publisher_id		INT NOT NULL AUTO_INCREMENT,         PRIMARY KEY (publisher_id));DROP TABLE IF EXISTS comic_editor;CREATE TABLE comic_editor(	editor		VARCHAR(128),	editor_id	INT NOT NULL AUTO_INCREMENT,	 PRIMARY KEY(editor_id));DROP TABLE IF EXISTS comic_artist;CREATE TABLE comic_artist(	artist		VARCHAR(128),	artist_id	INT NOT NULL AUTO_INCREMENT,	PRIMARY KEY (artist_id));DROP TABLE IF EXISTS comic_colorist;CREATE TABLE comic_colorist(	colorist	VARCHAR(128),	colorist_id	INT NOT NULL AUTO_INCREMENT,	PRIMARY KEY (colorist_id));DROP TABLE IF EXISTS comic_writer;CREATE TABLE comic_writer(	writer		VARCHAR(128),	writer_id	INT NOT NULL AUTO_INCREMENT,	PRIMARY KEY (writer_id));DROP TABLE IF EXISTS comic_cover_artist;CREATE TABLE comic_cover_artist(	cover_artist	VARCHAR(128),	cover_artist_id	INT NOT NULL AUTO_INCREMENT,	PRIMARY KEY (cover_artist_id));DROP TABLE IF EXISTS comic_letterer;CREATE TABLE comic_letterer(	letterer	VARCHAR(128),	letterer_id	INT NOT NULL AUTO_INCREMENT,	PRIMARY KEY (letterer_id));DROP TABLE IF EXISTS comic_character;CREATE TABLE comic_character(	character_name	VARCHAR(128),	character_id	INT NOT NULL AUTO_INCREMENT,	 PRIMARY KEY (character_id));DROP TABLE IF EXISTS comics;CREATE TABLE comics(	series 		INT,	publisher_id	INT,	editor_id	INT,	writer_id	INT,	artist_id	INT,	cover_artist_id	INT,	letterer_id	INT,	character_id	INT,	title		VARCHAR(128),	coverprice	INT,	publication_date	DATE,	purchase_date	DATE,	comic_image_thumb	VARCHAR(120),	comic_image_Large	VARCHAR(120),	ID INT NOT NULL AUTO_INCREMENT,	 PRIMARY KEY (ID));