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)
);