SQL 실행방법. 채택완료
CREATE TABLE `card_bet` ( `cb_idx` int(11) NOT NULL, `cb_mb_id` varchar(20) NOT NULL, `cb_time` varchar(10) NOT NULL, `cb_date` varchar(25) NOT NULL, `cb_episode` int(11) NOT NULL DEFAULT '0', `cb_batting_date` varchar(255) NOT NULL, `cb_character_no` int(11) NOT NULL DEFAULT '0', `cb_rate` float NOT NULL DEFAULT '0', `cb_batting_point` int(11) NOT NULL DEFAULT '0', `cb_gain_point` int(11) NOT NULL DEFAULT '0', `cb_result` int(11) NOT NULL DEFAULT '0', `cb_win` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `card_bet` ADD PRIMARY KEY (`cb_idx`), ADD KEY `cb_result` (`cb_result`), ADD KEY `cb_episode` (`cb_episode`), ADD KEY `cb_date` (`cb_date`), ADD KEY `cb_character_no` (`cb_character_no`), ADD KEY `cb_mb_id` (`cb_mb_id`), ADD KEY `cb_time` (`cb_time`);
ALTER TABLE `card_bet` MODIFY `cb_idx` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT;
----------------------------------------------------------------------------------------------------------------------------
-- -- Table structure for table `g5_result_poker` --
CREATE TABLE `g5_result_poker` ( `poker_idx` int(11) NOT NULL, `poker_timeId` int(11) NOT NULL, `poker_datetime` varchar(25) NOT NULL, `poker_episode_date` varchar(10) NOT NULL, `poker_episode` int(11) NOT NULL, `poker_card` varchar(255) NOT NULL, `poker_player_card` varchar(255) NOT NULL, `poker_result_id` varchar(255) NOT NULL, `poker_result_card` varchar(255) NOT NULL, `poker_result_rank` varchar(255) NOT NULL, `poker_status` int(11) NOT NULL DEFAULT '1', `poker_oddx1` decimal(3,2) NOT NULL, `poker_oddx2` decimal(3,2) NOT NULL, `poker_oddx3` decimal(3,2) NOT NULL, `poker_oddx4` decimal(3,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- -- Dumping data for table `g5_result_poker` --
-- -- Indexes for dumped tables --
-- -- Indexes for table `g5_result_poker` -- ALTER TABLE `g5_result_poker` ADD PRIMARY KEY (`poker_idx`), ADD KEY `poker_episode_date` (`poker_episode_date`), ADD KEY `poker_episode` (`poker_episode`), ADD KEY `poker_status` (`poker_status`), ADD KEY `poker_timeId` (`poker_timeId`);
-- -- AUTO_INCREMENT for dumped tables --
-- -- AUTO_INCREMENT for table `g5_result_poker` -- ALTER TABLE `g5_result_poker` MODIFY `poker_idx` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT;
플러그인의 게임을 다운받았는데요.
이걸 실행시켜야된다고 해서 PHPMYADMIN -> SQL에 이 소스를 넣고 실행시키니 오류가 나더라구요.
파일로 불러와도 반응이 없구요...
이 SQL을 실행시키려면 어떻게 하면 되나요?
답변 3개
CREATE TABLE card_bet ( cb_idx int(11) NOT NULL, cb_mb_id varchar(20) NOT NULL, cb_time varchar(10) NOT NULL, cb_date varchar(25) NOT NULL, cb_episode int(11) NOT NULL DEFAULT '0', cb_batting_date varchar(255) NOT NULL, cb_character_no int(11) NOT NULL DEFAULT '0', cb_rate float NOT NULL DEFAULT '0', cb_batting_point int(11) NOT NULL DEFAULT '0', cb_gain_point int(11) NOT NULL DEFAULT '0', cb_result int(11) NOT NULL DEFAULT '0', cb_win int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE card_bet ADD PRIMARY KEY (cb_idx), ADD KEY cb_result (cb_result), ADD KEY cb_episode (cb_episode), ADD KEY cb_date (cb_date), ADD KEY cb_character_no (cb_character_no), ADD KEY cb_mb_id (cb_mb_id), ADD KEY cb_time (cb_time);
ALTER TABLE card_bet MODIFY cb_idx int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT;
CREATE TABLE g5_result_poker ( poker_idx int(11) NOT NULL, poker_timeId int(11) NOT NULL, poker_datetime varchar(25) NOT NULL, poker_episode_date varchar(10) NOT NULL, poker_episode int(11) NOT NULL, poker_card varchar(255) NOT NULL, poker_player_card varchar(255) NOT NULL, poker_result_id varchar(255) NOT NULL, poker_result_card varchar(255) NOT NULL, poker_result_rank varchar(255) NOT NULL, poker_status int(11) NOT NULL DEFAULT '1', poker_oddx1 decimal(3,2) NOT NULL, poker_oddx2 decimal(3,2) NOT NULL, poker_oddx3 decimal(3,2) NOT NULL, poker_oddx4 decimal(3,2) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE g5_result_poker ADD PRIMARY KEY (poker_idx), ADD KEY poker_episode_date (poker_episode_date), ADD KEY poker_episode (poker_episode), ADD KEY poker_status (poker_status), ADD KEY poker_timeId (poker_timeId);
ALTER TABLE g5_result_poker MODIFY poker_idx int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT;
이것으로 SQL에 넣고 실행해보세요.
댓글을 작성하려면 로그인이 필요합니다.
sql 문에서 두군데 혹은
CHARSET=latin1;
=>
CHARSET=utf8;
로 바꾸시고
;
단위로만 실행해보시면
좀 낫지 않을까 싶습니다.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인