Question: CREATE TABLE ` article ` ( ` id ` varchar ( 1 0 ) NOT NULL, ` volname ` varchar ( 1 0 0 )
CREATE TABLE article
id varchar NOT NULL,
volname varchar DEFAULT NULL,
volid varchar DEFAULT NULL,
title varchar NOT NULL,
bodyText text NOT NULL,
correspAut varchar DEFAULT NULL,
submissionDate date DEFAULT NULL,
result varchar DEFAULT NULL,
PRIMARY KEY id
KEY volnamevolnamevolid
KEY correspAutcorrespAut
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
CREATE TABLE articlekeywords
email varchar NOT NULL,
aid varchar NOT NULL,
PRIMARY KEY emailaid
KEY aidaid
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
CREATE TABLE person
email varchar NOT NULL,
name varchar DEFAULT NULL,
vname varchar NOT NULL,
vid varchar NOT NULL,
isAuthor tinyint DEFAULT NULL,
isEditor tinyint DEFAULT NULL,
isReviewer tinyint DEFAULT NULL,
PRIMARY KEY emailvnamevid
KEY vnamevnamevid
ENGINEInnoDB DEFAULT CHARSETutfmb COLLATEutfmbgeneralci;
ALTER TABLE articlekeywords
ADD CONSTRAINT articlekeywordsibfk FOREIGN KEY keywid REFERENCES keywordskeywid
ADD CONSTRAINT articlekeywordsibfk FOREIGN KEY aid REFERENCES articleid;
i got error message for alter table on mysql workbench how can i fix that
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
