Question

自动生成MySQL报错 1050 - Table 'sys_action' already exists

CREATE TABLE sys_action(
actionId VARCHAR(32) NOT NULL,
actionName VARCHAR(32) NOT NULL,
type TINYINT NOT NULL,
remark VARCHAR(1000),
PRIMARY KEY (actionId)
)ENGINE=INNODB
;

CREATE TABLE sys_menu(
menuId VARCHAR(32) NOT NULL,
menuName VARCHAR(32) NOT NULL,
actionId VARCHAR(32) NOT NULL,
remark VARCHAR(1000),
type TINYINT,
PRIMARY KEY (menuId)
)ENGINE=INNODB
;

CREATE TABLE sys_role(
roleId VARCHAR(32) NOT NULL,
rolename VARCHAR(32) NOT NULL,
remark VARCHAR(1000),
status TINYINT NOT NULL,
PRIMARY KEY (roleId)
)ENGINE=INNODB
;

CREATE TABLE sys_roleaction(
roleaction VARCHAR(10) NOT NULL,
actionId VARCHAR(32) NOT NULL,
roleId VARCHAR(32) NOT NULL,
PRIMARY KEY (roleaction)
)ENGINE=INNODB
;

CREATE TABLE sys_rolemenu(
rolemenu VARCHAR(32) NOT NULL,
menuId VARCHAR(32) NOT NULL,
roleId VARCHAR(32) NOT NULL,
PRIMARY KEY (rolemenu)
)ENGINE=INNODB
;

CREATE TABLE sys_userId(
userId VARCHAR(32) NOT NULL,
account VARCHAR(32) NOT NULL,
passwd VARCHAR(32) NOT NULL,
remark VARCHAR(1000),
creatTime DATETIME,
lastloginTime DATETIME,
PRIMARY KEY (userId)
)ENGINE=INNODB
;

CREATE TABLE sys_userrole(
roleuser VARCHAR(32) NOT NULL,
userId VARCHAR(32) NOT NULL,
roleId VARCHAR(32) NOT NULL,
PRIMARY KEY (roleuser)
)ENGINE=INNODB
;

ALTER TABLE sys_roleaction ADD CONSTRAINT Refsys_action5
FOREIGN KEY (actionId)
REFERENCES sys_action(actionId)
;

ALTER TABLE sys_roleaction ADD CONSTRAINT Refsys_role11
FOREIGN KEY (roleId)
REFERENCES sys_role(roleId)
;

ALTER TABLE sys_rolemenu ADD CONSTRAINT Refsys_menu9
FOREIGN KEY (menuId)
REFERENCES sys_menu(menuId)
;

ALTER TABLE sys_rolemenu ADD CONSTRAINT Refsys_role12
FOREIGN KEY (roleId)
REFERENCES sys_role(roleId)
;

ALTER TABLE sys_userrole ADD CONSTRAINT Refsys_userId1
FOREIGN KEY (userId)
REFERENCES sys_userId(userId)
;

ALTER TABLE sys_userrole ADD CONSTRAINT Refsys_role2
FOREIGN KEY (roleId)
REFERENCES sys_role(roleId)
;

Answer 1

在第一个创建语句后面改成 Create Table sys_action if not exists即可，这样可以防止出错