DROP TABLE IF EXISTS authors;
CREATE TABLE authors(authorid BIGINT NOT NULL DEFAULT 0, fname VARCHAR(50) NULL, lname VARCHAR(50) NULL, yearborn VARCHAR(50) NULL,  KEY (authorid));


DROP TABLE IF EXISTS titles;
CREATE TABLE titles(isbn BIGINT NOT NULL DEFAULT 0, title VARCHAR(50) NULL, editionno BIGINT NOT NULL DEFAULT 0, year VARCHAR(50) NULL, descrip VARCHAR(50) NULL, pid BIGINT NOT NULL DEFAULT 0,  KEY (pid),  PRIMARY KEY (isbn));


DROP TABLE IF EXISTS authorisbn;
CREATE TABLE authorisbn(isbn BIGINT NOT NULL DEFAULT 0, authorid BIGINT NOT NULL DEFAULT 0,  KEY (authorid),  KEY (isbn));


DROP TABLE IF EXISTS publishers;
CREATE TABLE publishers(pid BIGINT NOT NULL DEFAULT 0, pubname VARCHAR(50) NULL,  KEY (pid));