sql 스크립트가 입력이 안되네요 <br><div><span style="font-family:'굴림', gulim, '돋움', Dotum, Helvetica, AppleGothic, sans-serif;line-height:21.6000003814697px;font-size:9pt;">member_roles 생성할때 </span>ERROR 1005 가 뜨는데요</div> <div>다른 친구는 잘된다고 해서요</div> <div>잘넣어지는 테스트좀 부탁드립니다!</div> <div>-------------------------------------------------------------------------------</div> <div><br></div> <div><div><br></div> <div>CREATE SCHEMA test;</div> <div>USE test;</div> <div><br></div> <div>--</div> <div>-- Table structure for table `tendency`</div> <div>--</div> <div><br></div> <div>CREATE TABLE tendency (</div> <div> tendency_id varchar(10) NOT NULL,</div> <div> title varchar(45) DEFAULT NULL,</div> <div> PRIMARY KEY (tendency_id) USING BTREE</div> <div>) ENGINE=InnoDB DEFAULT CHARSET=utf8;</div> <div><br></div> <div><br></div> <div><br></div> <div>--</div> <div>-- Table structure for table `member`</div> <div>--</div> <div><br></div> <div>CREATE TABLE member (</div> <div> member_id varchar(45) NOT NULL,</div> <div> password varchar(45) DEFAULT NULL,</div> <div> nickname varchar(45) DEFAULT NULL,</div> <div> email varchar(45) DEFAULT NULL,</div> <div> reg_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,</div> <div> method varchar(10) DEFAULT NULL,</div> <div> task varchar(10) DEFAULT NULL,</div> <div> exam varchar(10) DEFAULT NULL,</div> <div> email_auth tinyint(4) unsigned DEFAULT '1',</div> <div> type varchar(45) DEFAULT '1',</div> <div> enabled tinyint(4) unsigned DEFAULT '1',</div> <div> PRIMARY KEY (member_id)</div> <div>) ENGINE=InnoDB DEFAULT CHARSET=utf8;</div> <div><br></div> <div><br></div> <div>--</div> <div>-- Table structure for table `member_roles`</div> <div>--</div> <div><br></div> <div>CREATE TABLE member_roles (</div> <div> member_role_id INT(11) NOT NULL AUTO_INCREMENT,</div> <div> member_id VARCHAR(45) NOT NULL,</div> <div> ROLE VARCHAR(45) NOT NULL,</div> <div> PRIMARY KEY (member_role_id),</div> <div> UNIQUE KEY uni_member_id_role (ROLE,member_id),</div> <div> KEY fk_username_idx (member_id),</div> <div> CONSTRAINT fk_member_id FOREIGN KEY (member_id) REFERENCES member (member_id));</div> <div><br></div> <div><br></div> <div>--</div> <div>-- Table structure for table `lecture`</div> <div>--</div> <div><br></div> <div>CREATE TABLE lecture (</div> <div> lecture_id int(10) unsigned NOT NULL AUTO_INCREMENT,</div> <div> lecture_name varchar(45) DEFAULT NULL,</div> <div> dept varchar(45) DEFAULT NULL,</div> <div> prof varchar(45) DEFAULT NULL,</div> <div> likes int(10) unsigned DEFAULT '1',</div> <div> PRIMARY KEY (lecture_id)</div> <div>) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;</div> <div><br></div> <div><br></div> <div><br></div> <div><br></div> <div>--</div> <div>-- Table structure for table `evaluation`</div> <div>--</div> <div><br></div> <div>CREATE TABLE evaluation (</div> <div> evaluation_id int(10) unsigned NOT NULL AUTO_INCREMENT,</div> <div> lecture_id int(10) unsigned DEFAULT NULL,</div> <div> member_id varchar(45) DEFAULT NULL,</div> <div> method varchar(45) DEFAULT NULL,</div> <div> task varchar(45) DEFAULT NULL,</div> <div> exam varchar(45) DEFAULT NULL,</div> <div> comment varchar(45) DEFAULT NULL,</div> <div> score int(10) unsigned DEFAULT NULL,</div> <div> write_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,</div> <div> is_delete tinyint(4) unsigned DEFAULT '1',</div> <div> is_reply tinyint(4) unsigned DEFAULT NULL,</div> <div> upper_id int(10) unsigned DEFAULT NULL,</div> <div> likes int(10) unsigned DEFAULT '0',</div> <div> dislike int(10) unsigned DEFAULT '0',</div> <div> report int(10) unsigned DEFAULT '0',</div> <div> PRIMARY KEY (evaluation_id),</div> <div> KEY FK_evaluation_lecture (lecture_id),</div> <div> KEY FK_evaluation_member (member_id),</div> <div> CONSTRAINT FK_evaluation_member FOREIGN KEY (member_id) REFERENCES member (member_id) ON DELETE CASCADE ON UPDATE CASCADE,</div> <div> CONSTRAINT FK_evaluation_lecture FOREIGN KEY (lecture_id) REFERENCES lecture (lecture_id) ON DELETE CASCADE ON UPDATE CASCADE</div> <div>) ENGINE=InnoDB DEFAULT CHARSET=utf8;</div></div> <div><br></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.