DROP TABLE IF EXISTS comicdb;

CREATE TABLE comic_publisher(
	publisher		VARCHAR(128),
	publisher_weblink	VARCHAR(192),
	publisher_id		INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_editor(
	editor		VARCHAR(128),
	editor_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_artist(
	artist		VARCHAR(128),
	artist_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_colorist(
	colorist	VARCHAR(128),
	colorist_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_writer(
	writer		VARCHAR(128),
	writer_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_cover_artist(
	cover_artist	VARCHAR(128),
	cover_artist_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_letterer(
	letterer	VARCHAR(128),
	letterer_is	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

CREATE TABLE comic_character(
	character_name	VARCHAR(128),
	character_id	INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

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	CHAR
	purchase_date	CHAR
	comic_image_thumb	CHAR,
	comic_image_Large	CHAR,
	ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT
);