sql 문제 ㅜㅜ 초보입니다 봐주세요 정보
sql 문제 ㅜㅜ 초보입니다 봐주세요본문
저의 지금 phpmyadmin 버전이 •Version information: 3.4.7.1, latest stable version: 3.5.6 이구요
MySQL 정보
•Server: Localhost via UNIX socket
•Server version: 5.5.17-rel22.1-log
•Protocol version: 10
•User: http://www.phpmyadmin.net
--
-- 호스트: localhost:3306
-- 처리한 시간: 10-12-02 02:13
-- 서버 버전: 5.1.48
-- PHP 버전: 5.2.13
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 데이터베이스: `nworld`
--
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_list`
--
DROP TABLE IF EXISTS `domain_list`;
CREATE TABLE IF NOT EXISTS `domain_list` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`user` char(50) NOT NULL,
`domain` char(50) NOT NULL,
`favicon` char(50) NOT NULL,
`popup` int(10) DEFAULT NULL,
`connect_url` char(100) NOT NULL,
`title` char(100) NOT NULL,
`field_1` char(50) DEFAULT NULL,
`field_2` char(50) DEFAULT NULL,
`field_3` char(50) DEFAULT NULL,
`field_4` char(50) DEFAULT NULL,
`field_5` char(50) DEFAULT NULL,
`field_6` char(50) DEFAULT NULL,
`popup2` varchar(50) DEFAULT NULL,
`texts` longtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_money_up`
--
DROP TABLE IF EXISTS `domain_money_up`;
CREATE TABLE IF NOT EXISTS `domain_money_up` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`bank` char(50) NOT NULL,
`name` char(50) NOT NULL,
`number` char(50) NOT NULL,
`point` int(10) NOT NULL,
`user` char(50) NOT NULL,
`result` int(2) NOT NULL,
`look` char(10) DEFAULT '0',
`date` char(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_user`
--
DROP TABLE IF EXISTS `domain_user`;
CREATE TABLE IF NOT EXISTS `domain_user` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`name` char(50) NOT NULL,
`password` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`point` int(10) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_1`
--
DROP TABLE IF EXISTS `domain_visit_1`;
CREATE TABLE IF NOT EXISTS `domain_visit_1` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`date1` char(50) NOT NULL,
`date2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`referer` char(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_2`
--
DROP TABLE IF EXISTS `domain_visit_2`;
CREATE TABLE IF NOT EXISTS `domain_visit_2` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`referer` char(200) NOT NULL,
`user` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_3`
--
DROP TABLE IF EXISTS `domain_visit_3`;
CREATE TABLE IF NOT EXISTS `domain_visit_3` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`date` char(200) NOT NULL,
`referer` char(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
MySQL 정보
•Server: Localhost via UNIX socket
•Server version: 5.5.17-rel22.1-log
•Protocol version: 10
•User: http://www.phpmyadmin.net
--
-- 호스트: localhost:3306
-- 처리한 시간: 10-12-02 02:13
-- 서버 버전: 5.1.48
-- PHP 버전: 5.2.13
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- 데이터베이스: `nworld`
--
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_list`
--
DROP TABLE IF EXISTS `domain_list`;
CREATE TABLE IF NOT EXISTS `domain_list` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`user` char(50) NOT NULL,
`domain` char(50) NOT NULL,
`favicon` char(50) NOT NULL,
`popup` int(10) DEFAULT NULL,
`connect_url` char(100) NOT NULL,
`title` char(100) NOT NULL,
`field_1` char(50) DEFAULT NULL,
`field_2` char(50) DEFAULT NULL,
`field_3` char(50) DEFAULT NULL,
`field_4` char(50) DEFAULT NULL,
`field_5` char(50) DEFAULT NULL,
`field_6` char(50) DEFAULT NULL,
`popup2` varchar(50) DEFAULT NULL,
`texts` longtext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_money_up`
--
DROP TABLE IF EXISTS `domain_money_up`;
CREATE TABLE IF NOT EXISTS `domain_money_up` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`bank` char(50) NOT NULL,
`name` char(50) NOT NULL,
`number` char(50) NOT NULL,
`point` int(10) NOT NULL,
`user` char(50) NOT NULL,
`result` int(2) NOT NULL,
`look` char(10) DEFAULT '0',
`date` char(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_user`
--
DROP TABLE IF EXISTS `domain_user`;
CREATE TABLE IF NOT EXISTS `domain_user` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`name` char(50) NOT NULL,
`password` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`point` int(10) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_1`
--
DROP TABLE IF EXISTS `domain_visit_1`;
CREATE TABLE IF NOT EXISTS `domain_visit_1` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`date1` char(50) NOT NULL,
`date2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`referer` char(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_2`
--
DROP TABLE IF EXISTS `domain_visit_2`;
CREATE TABLE IF NOT EXISTS `domain_visit_2` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`referer` char(200) NOT NULL,
`user` char(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
-- --------------------------------------------------------
--
-- 테이블 구조 `domain_visit_3`
--
DROP TABLE IF EXISTS `domain_visit_3`;
CREATE TABLE IF NOT EXISTS `domain_visit_3` (
`id` int(15) NOT NULL AUTO_INCREMENT,
`domain` char(50) NOT NULL,
`domain2` char(50) NOT NULL,
`ip` char(50) NOT NULL,
`date` char(200) NOT NULL,
`referer` char(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
댓글 전체
ENGINE=MyISAM 를 모두 삭제하고 임포트 해보세요.