알지보드 

http://rgboard.com/main/index.php

 

• 무료공개 게시판 알지보드 4.3.0베타 utf-8 전환 (저작권표시없음,재배포가능)

http://rgboard.com/rg4_board/view.php?&bbs_code=rgboard_pds&page=1&bd_num=2160

 

-- --------------------------------------------------------
-- 호스트:                          127.0.0.1
-- 서버 버전:                        5.5.51 - MySQL Community Server (GPL)
-- 서버 OS:                        Win64
-- HeidiSQL 버전:                  9.5.0.5196
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- altibase 데이터베이스 구조 내보내기
CREATE DATABASE IF NOT EXISTS `altibase` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `altibase`;

-- 테이블 altibase.rg4_bbs_body 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_bbs_body` (
  `bd_num` int(11) NOT NULL AUTO_INCREMENT,
  `gr_num` int(11) NOT NULL DEFAULT '0',
  `bbs_db_num` int(11) NOT NULL DEFAULT '0',
  `mb_num` int(11) NOT NULL DEFAULT '0',
  `mb_id` varchar(255) NOT NULL DEFAULT '',
  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
  `cat_num` int(11) NOT NULL DEFAULT '0',
  `bd_top_num` int(11) NOT NULL DEFAULT '0',
  `bd_parent_num` int(11) NOT NULL DEFAULT '0',
  `bd_sequence` int(11) NOT NULL DEFAULT '0',
  `bd_depth` int(11) NOT NULL DEFAULT '0',
  `bd_next_num` int(11) NOT NULL DEFAULT '0',
  `bd_comment_count` int(11) NOT NULL DEFAULT '0',
  `bd_name` varchar(255) NOT NULL DEFAULT '',
  `bd_pass` varchar(255) NOT NULL DEFAULT '',
  `bd_email` varchar(255) NOT NULL DEFAULT '',
  `bd_home` varchar(255) NOT NULL DEFAULT '',
  `bd_subject` varchar(255) NOT NULL DEFAULT '',
  `bd_content` text,
  `bd_files` text,
  `bd_links` text,
  `bd_html` int(1) NOT NULL DEFAULT '0',
  `bd_secret` int(1) NOT NULL DEFAULT '0',
  `bd_notice` int(1) NOT NULL DEFAULT '0',
  `bd_reply_mail` int(1) NOT NULL DEFAULT '0',
  `bd_delete` int(1) NOT NULL DEFAULT '0',
  `bd_write_date` int(11) NOT NULL DEFAULT '0',
  `bd_write_ip` varchar(20) NOT NULL DEFAULT '',
  `bd_modify_date` int(11) NOT NULL DEFAULT '0',
  `bd_modify_ip` varchar(20) NOT NULL DEFAULT '',
  `bd_view_count` int(11) NOT NULL DEFAULT '0',
  `bd_vote_yes` int(11) NOT NULL DEFAULT '0',
  `bd_vote_no` int(11) NOT NULL DEFAULT '0',
  `bd_ext1` text,
  `bd_ext2` text,
  `bd_ext3` text,
  `bd_ext4` text,
  `bd_ext5` text,
  PRIMARY KEY (`bd_num`),
  KEY `bd_top_num` (`bd_top_num`),
  KEY `bd_next_num` (`bd_next_num`),
  KEY `bd_name` (`bd_name`),
  KEY `bd_subject` (`bd_subject`),
  KEY `bd_notice` (`bd_notice`),
  KEY `gr_num` (`gr_num`),
  KEY `bbs_db_num` (`bbs_db_num`),
  KEY `cat_num` (`cat_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_bbs_body:~0 rows (대략적) 내보내기
DELETE FROM `rg4_bbs_body`;
/*!40000 ALTER TABLE `rg4_bbs_body` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_bbs_body` ENABLE KEYS */;

-- 테이블 altibase.rg4_bbs_category 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_bbs_category` (
  `cat_num` int(11) NOT NULL AUTO_INCREMENT,
  `bbs_db_num` int(11) NOT NULL DEFAULT '0',
  `cat_order` int(11) NOT NULL DEFAULT '0',
  `cat_name` varchar(255) NOT NULL DEFAULT '',
  `cat_count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_num`),
  KEY `cat_order` (`cat_order`),
  KEY `bbs_db_num` (`bbs_db_num`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_bbs_category:~6 rows (대략적) 내보내기
DELETE FROM `rg4_bbs_category`;
/*!40000 ALTER TABLE `rg4_bbs_category` DISABLE KEYS */;
INSERT INTO `rg4_bbs_category` (`cat_num`, `bbs_db_num`, `cat_order`, `cat_name`, `cat_count`) VALUES
	(1, 1, 1, '질문', 0),
	(2, 1, 2, '답변', 0),
	(3, 1, 3, '잡담', 0),
	(4, 2, 1, '질문', 0),
	(5, 2, 2, '답변', 0),
	(6, 2, 3, '잡담', 0);
/*!40000 ALTER TABLE `rg4_bbs_category` ENABLE KEYS */;

-- 테이블 altibase.rg4_bbs_cfg 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_bbs_cfg` (
  `bbs_num` int(11) NOT NULL AUTO_INCREMENT,
  `bbs_code` varchar(255) NOT NULL DEFAULT '',
  `bbs_db` varchar(255) NOT NULL DEFAULT '',
  `bbs_db_num` int(11) NOT NULL DEFAULT '0',
  `gr_num` int(11) NOT NULL DEFAULT '0',
  `bbs_name` varchar(255) NOT NULL DEFAULT '',
  `bbs_skin` varchar(255) NOT NULL DEFAULT '',
  `use_category` int(1) NOT NULL DEFAULT '0',
  `default_content` text,
  `auth_list` int(3) NOT NULL DEFAULT '0',
  `auth_view` int(3) NOT NULL DEFAULT '0',
  `auth_write` int(3) NOT NULL DEFAULT '0',
  `auth_reply` int(3) NOT NULL DEFAULT '0',
  `auth_modify` int(3) NOT NULL DEFAULT '0',
  `auth_delete` int(3) NOT NULL DEFAULT '0',
  `auth_comment` int(3) NOT NULL DEFAULT '0',
  `auth_secret` int(3) NOT NULL DEFAULT '0',
  `list_cfg` text,
  `write_cfg` text,
  `reply_cfg` text,
  `view_cfg` text,
  `mailing_mb_id` text,
  `admin_mb_id` text,
  `point_write` int(11) NOT NULL DEFAULT '0',
  `point_reply` int(11) NOT NULL DEFAULT '0',
  `point_comment` int(11) NOT NULL DEFAULT '0',
  `header_file` varchar(255) NOT NULL DEFAULT '',
  `header_tag` text,
  `footer_tag` text,
  `footer_file` varchar(255) NOT NULL DEFAULT '',
  `reg_date` int(11) NOT NULL DEFAULT '0',
  `bbs_ext1` text,
  `bbs_ext2` text,
  `bbs_ext3` text,
  `bbs_ext4` text,
  `bbs_ext5` text,
  `admin_memo` text NOT NULL,
  `deny_word` text NOT NULL,
  `deny_html` text NOT NULL,
  `deny_ip` text NOT NULL,
  PRIMARY KEY (`bbs_num`),
  KEY `bbs_code` (`bbs_code`),
  KEY `bbs_db` (`bbs_db`),
  KEY `bbs_db_num` (`bbs_db_num`),
  KEY `gr_num` (`gr_num`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_bbs_cfg:~2 rows (대략적) 내보내기
DELETE FROM `rg4_bbs_cfg`;
/*!40000 ALTER TABLE `rg4_bbs_cfg` DISABLE KEYS */;
INSERT INTO `rg4_bbs_cfg` (`bbs_num`, `bbs_code`, `bbs_db`, `bbs_db_num`, `gr_num`, `bbs_name`, `bbs_skin`, `use_category`, `default_content`, `auth_list`, `auth_view`, `auth_write`, `auth_reply`, `auth_modify`, `auth_delete`, `auth_comment`, `auth_secret`, `list_cfg`, `write_cfg`, `reply_cfg`, `view_cfg`, `mailing_mb_id`, `admin_mb_id`, `point_write`, `point_reply`, `point_comment`, `header_file`, `header_tag`, `footer_tag`, `footer_file`, `reg_date`, `bbs_ext1`, `bbs_ext2`, `bbs_ext3`, `bbs_ext4`, `bbs_ext5`, `admin_memo`, `deny_word`, `deny_html`, `deny_ip`) VALUES
	(1, 'notice', 'notice', 1, 1, '공지사항', 'default', 0, '', 0, 0, 90, 100, 90, 90, 100, 100, 'a:5:{s:10:"list_count";s:2:"20";s:8:"new_time";s:2:"24";s:13:"subject_limit";s:2:"60";s:10:"page_count";s:2:"10";s:11:"date_format";s:8:"%Y-%m-%d";}', 'a:14:{s:10:"use_notice";s:2:"90";s:8:"use_html";s:1:"0";s:10:"use_secret";s:3:"100";s:8:"use_home";s:1:"0";s:8:"use_link";s:3:"100";s:10:"link_count";s:1:"2";s:10:"use_upload";s:3:"100";s:12:"upload_count";s:1:"2";s:11:"writer_name";s:1:"3";s:13:"writer_modify";s:3:"100";s:8:"spam_chk";s:1:"0";s:15:"write_deny_time";s:1:"5";s:14:"use_reply_mail";s:1:"0";s:12:"reply_delete";s:1:"4";}', 'a:4:{s:14:"subject_prefix";s:8:"[답변]";s:9:"quote_use";s:1:"1";s:13:"quote_subject";s:27:"{NAME} 님의 글입니다.";s:10:"quote_mark";s:1:">";}', 'a:14:{s:12:"view_comment";s:1:"0";s:10:"view_image";s:1:"0";s:12:"use_download";s:1:"0";s:14:"view_signature";s:3:"100";s:9:"view_list";s:1:"0";s:8:"btn_list";s:1:"0";s:13:"btn_prev_next";s:1:"0";s:10:"btn_modify";s:1:"0";s:7:"btn_del";s:1:"0";s:9:"btn_reply";s:1:"0";s:8:"vote_yes";s:3:"100";s:7:"vote_no";s:3:"100";s:11:"date_format";s:17:"%Y-%m-%d %H:%M:%S";s:13:"c_date_format";s:17:"%Y-%m-%d %H:%M:%S";}', '', '', 0, 0, 0, '', '', '', '', 1183101402, '', '', '', '', '', '', '8억,새끼,개새끼,소새끼,병신,지랄,씨팔,십팔,니기미,찌랄,지랄,쌍년,쌍놈,빙신,좆까,니기미,좆같은게,잡놈,벼엉신,바보새끼,씹새끼,씨발,씨팔,시벌,씨벌,떠그랄,좆밥,추천인,추천id,추천아이디,추천id,추천아이디,추/천/인,쉐이,등신,싸가지,미친놈,미친넘,찌랄,죽습니다,님아,님들아,씨밸넘', 'script,xml', ''),
	(2, 'free', 'free', 2, 1, '자유게시판', 'default', 0, '', 0, 0, 0, 100, 0, 0, 0, 50, 'a:5:{s:10:"list_count";s:2:"20";s:8:"new_time";s:2:"24";s:13:"subject_limit";s:2:"60";s:10:"page_count";s:2:"10";s:11:"date_format";s:8:"%Y-%m-%d";}', 'a:14:{s:10:"use_notice";s:2:"90";s:8:"use_html";s:1:"0";s:10:"use_secret";s:3:"100";s:8:"use_home";s:1:"0";s:8:"use_link";s:3:"100";s:10:"link_count";s:1:"2";s:10:"use_upload";s:3:"100";s:12:"upload_count";s:1:"2";s:11:"writer_name";s:1:"3";s:13:"writer_modify";s:3:"100";s:8:"spam_chk";s:1:"0";s:15:"write_deny_time";s:1:"5";s:14:"use_reply_mail";s:1:"0";s:12:"reply_delete";s:1:"4";}', 'a:4:{s:14:"subject_prefix";s:8:"[답변]";s:9:"quote_use";s:1:"1";s:13:"quote_subject";s:27:"{NAME} 님의 글입니다.";s:10:"quote_mark";s:1:">";}', 'a:14:{s:12:"view_comment";s:1:"0";s:10:"view_image";s:1:"0";s:12:"use_download";s:1:"0";s:14:"view_signature";s:3:"100";s:9:"view_list";s:1:"0";s:8:"btn_list";s:1:"0";s:13:"btn_prev_next";s:1:"0";s:10:"btn_modify";s:1:"0";s:7:"btn_del";s:1:"0";s:9:"btn_reply";s:1:"0";s:8:"vote_yes";s:3:"100";s:7:"vote_no";s:3:"100";s:11:"date_format";s:17:"%Y-%m-%d %H:%M:%S";s:13:"c_date_format";s:17:"%Y-%m-%d %H:%M:%S";}', '', '', 1, 1, 1, '', '', '', '', 1185374597, '', '', '', '', '', '', '8억,새끼,개새끼,소새끼,병신,지랄,씨팔,십팔,니기미,찌랄,지랄,쌍년,쌍놈,빙신,좆까,니기미,좆같은게,잡놈,벼엉신,바보새끼,씹새끼,씨발,씨팔,시벌,씨벌,떠그랄,좆밥,추천인,추천id,추천아이디,추천id,추천아이디,추/천/인,쉐이,등신,싸가지,미친놈,미친넘,찌랄,죽습니다,님아,님들아,씨밸넘', 'script,xml', '');
/*!40000 ALTER TABLE `rg4_bbs_cfg` ENABLE KEYS */;

-- 테이블 altibase.rg4_bbs_comment 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_bbs_comment` (
  `bc_num` int(11) NOT NULL AUTO_INCREMENT,
  `gr_num` int(11) NOT NULL DEFAULT '0',
  `bbs_db_num` int(11) NOT NULL DEFAULT '0',
  `bd_num` int(11) NOT NULL DEFAULT '0',
  `mb_num` int(11) NOT NULL DEFAULT '0',
  `mb_id` varchar(255) NOT NULL DEFAULT '',
  `bc_name` varchar(255) NOT NULL DEFAULT '',
  `bc_pass` varchar(255) NOT NULL DEFAULT '',
  `bc_email` varchar(255) NOT NULL DEFAULT '',
  `bc_home` varchar(255) NOT NULL DEFAULT '',
  `bc_content` text,
  `bc_write_date` int(11) NOT NULL DEFAULT '0',
  `bc_write_ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`bc_num`),
  KEY `gr_num` (`gr_num`),
  KEY `bbs_db_num` (`bbs_db_num`),
  KEY `bd_num` (`bd_num`),
  KEY `mb_num` (`mb_num`),
  KEY `mb_id` (`mb_id`),
  KEY `bc_name` (`bc_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_bbs_comment:~0 rows (대략적) 내보내기
DELETE FROM `rg4_bbs_comment`;
/*!40000 ALTER TABLE `rg4_bbs_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_bbs_comment` ENABLE KEYS */;

-- 테이블 altibase.rg4_comm_code 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_comm_code` (
  `cd_num` int(11) NOT NULL AUTO_INCREMENT,
  `cd_type1` varchar(255) DEFAULT NULL,
  `cd_type2` varchar(255) DEFAULT NULL,
  `cd_code` varchar(255) DEFAULT NULL,
  `cd_name` varchar(255) DEFAULT NULL,
  `cd_ord` int(11) NOT NULL DEFAULT '0',
  `cd_data1` varchar(255) DEFAULT NULL,
  `cd_data2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cd_num`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_comm_code:~7 rows (대략적) 내보내기
DELETE FROM `rg4_comm_code`;
/*!40000 ALTER TABLE `rg4_comm_code` DISABLE KEYS */;
INSERT INTO `rg4_comm_code` (`cd_num`, `cd_type1`, `cd_type2`, `cd_code`, `cd_name`, `cd_ord`, `cd_data1`, `cd_data2`) VALUES
	(1, 'comm', 'yns', 'Y', '예', 1, '사용', ''),
	(2, 'comm', 'yns', 'N', '아니요', 2, '사용안함', ''),
	(3, 'popup', 'win_type', '01', '일반팝업', 0, '', ''),
	(4, 'popup', 'win_type', '02', '레이어팝업', 0, '', ''),
	(5, 'popup', 'cont_type', '01', '이미지업로드', 0, '', ''),
	(6, 'popup', 'cont_type', '02', 'html링크', 0, '', ''),
	(7, 'popup', 'cont_type', '03', 'html직접입력', 0, '', '');
/*!40000 ALTER TABLE `rg4_comm_code` ENABLE KEYS */;

-- 테이블 altibase.rg4_counter_day 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_counter_day` (
  `num` int(11) NOT NULL AUTO_INCREMENT,
  `reg_date` int(11) NOT NULL DEFAULT '0',
  `yy` int(4) NOT NULL DEFAULT '0',
  `mm` tinyint(2) NOT NULL DEFAULT '0',
  `dd` tinyint(2) NOT NULL DEFAULT '0',
  `ww` tinyint(1) NOT NULL DEFAULT '0',
  `hh0` int(11) NOT NULL DEFAULT '0',
  `hh1` int(11) NOT NULL DEFAULT '0',
  `hh2` int(11) NOT NULL DEFAULT '0',
  `hh3` int(11) NOT NULL DEFAULT '0',
  `hh4` int(11) NOT NULL DEFAULT '0',
  `hh5` int(11) NOT NULL DEFAULT '0',
  `hh6` int(11) NOT NULL DEFAULT '0',
  `hh7` int(11) NOT NULL DEFAULT '0',
  `hh8` int(11) NOT NULL DEFAULT '0',
  `hh9` int(11) NOT NULL DEFAULT '0',
  `hh10` int(11) NOT NULL DEFAULT '0',
  `hh11` int(11) NOT NULL DEFAULT '0',
  `hh12` int(11) NOT NULL DEFAULT '0',
  `hh13` int(11) NOT NULL DEFAULT '0',
  `hh14` int(11) NOT NULL DEFAULT '0',
  `hh15` int(11) NOT NULL DEFAULT '0',
  `hh16` int(11) NOT NULL DEFAULT '0',
  `hh17` int(11) NOT NULL DEFAULT '0',
  `hh18` int(11) NOT NULL DEFAULT '0',
  `hh19` int(11) NOT NULL DEFAULT '0',
  `hh20` int(11) NOT NULL DEFAULT '0',
  `hh21` int(11) NOT NULL DEFAULT '0',
  `hh22` int(11) NOT NULL DEFAULT '0',
  `hh23` int(11) NOT NULL DEFAULT '0',
  `uhh0` int(11) NOT NULL DEFAULT '0',
  `uhh1` int(11) NOT NULL DEFAULT '0',
  `uhh2` int(11) NOT NULL DEFAULT '0',
  `uhh3` int(11) NOT NULL DEFAULT '0',
  `uhh4` int(11) NOT NULL DEFAULT '0',
  `uhh5` int(11) NOT NULL DEFAULT '0',
  `uhh6` int(11) NOT NULL DEFAULT '0',
  `uhh7` int(11) NOT NULL DEFAULT '0',
  `uhh8` int(11) NOT NULL DEFAULT '0',
  `uhh9` int(11) NOT NULL DEFAULT '0',
  `uhh10` int(11) NOT NULL DEFAULT '0',
  `uhh11` int(11) NOT NULL DEFAULT '0',
  `uhh12` int(11) NOT NULL DEFAULT '0',
  `uhh13` int(11) NOT NULL DEFAULT '0',
  `uhh14` int(11) NOT NULL DEFAULT '0',
  `uhh15` int(11) NOT NULL DEFAULT '0',
  `uhh16` int(11) NOT NULL DEFAULT '0',
  `uhh17` int(11) NOT NULL DEFAULT '0',
  `uhh18` int(11) NOT NULL DEFAULT '0',
  `uhh19` int(11) NOT NULL DEFAULT '0',
  `uhh20` int(11) NOT NULL DEFAULT '0',
  `uhh21` int(11) NOT NULL DEFAULT '0',
  `uhh22` int(11) NOT NULL DEFAULT '0',
  `uhh23` int(11) NOT NULL DEFAULT '0',
  `hits` int(11) NOT NULL DEFAULT '0',
  `unique_hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num`),
  UNIQUE KEY `reg_date` (`reg_date`),
  KEY `ww` (`ww`),
  KEY `yy` (`yy`),
  KEY `mm` (`mm`),
  KEY `dd` (`dd`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_counter_day:~1 rows (대략적) 내보내기
DELETE FROM `rg4_counter_day`;
/*!40000 ALTER TABLE `rg4_counter_day` DISABLE KEYS */;
INSERT INTO `rg4_counter_day` (`num`, `reg_date`, `yy`, `mm`, `dd`, `ww`, `hh0`, `hh1`, `hh2`, `hh3`, `hh4`, `hh5`, `hh6`, `hh7`, `hh8`, `hh9`, `hh10`, `hh11`, `hh12`, `hh13`, `hh14`, `hh15`, `hh16`, `hh17`, `hh18`, `hh19`, `hh20`, `hh21`, `hh22`, `hh23`, `uhh0`, `uhh1`, `uhh2`, `uhh3`, `uhh4`, `uhh5`, `uhh6`, `uhh7`, `uhh8`, `uhh9`, `uhh10`, `uhh11`, `uhh12`, `uhh13`, `uhh14`, `uhh15`, `uhh16`, `uhh17`, `uhh18`, `uhh19`, `uhh20`, `uhh21`, `uhh22`, `uhh23`, `hits`, `unique_hits`) VALUES
	(1, 1516374000, 2018, 1, 20, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1);
/*!40000 ALTER TABLE `rg4_counter_day` ENABLE KEYS */;

-- 테이블 altibase.rg4_counter_etc 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_counter_etc` (
  `num` int(11) NOT NULL AUTO_INCREMENT,
  `type` char(3) NOT NULL DEFAULT '',
  `yy` int(4) NOT NULL DEFAULT '0',
  `mm` tinyint(2) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `unique_hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num`),
  KEY `yy` (`yy`),
  KEY `mm` (`mm`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_counter_etc:~3 rows (대략적) 내보내기
DELETE FROM `rg4_counter_etc`;
/*!40000 ALTER TABLE `rg4_counter_etc` DISABLE KEYS */;
INSERT INTO `rg4_counter_etc` (`num`, `type`, `yy`, `mm`, `name`, `hits`, `unique_hits`) VALUES
	(1, 'br', 2018, 1, 'safari 537.36', 1, 1),
	(2, 'os', 2018, 1, 'nt', 1, 1),
	(3, 'res', 2018, 1, '1366x768', 1, 1);
/*!40000 ALTER TABLE `rg4_counter_etc` ENABLE KEYS */;

-- 테이블 altibase.rg4_counter_host 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_counter_host` (
  `num` int(11) NOT NULL AUTO_INCREMENT,
  `yy` int(4) NOT NULL DEFAULT '0',
  `mm` tinyint(2) NOT NULL DEFAULT '0',
  `host` varchar(255) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `unique_hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num`),
  KEY `yy` (`yy`),
  KEY `mm` (`mm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_counter_host:~0 rows (대략적) 내보내기
DELETE FROM `rg4_counter_host`;
/*!40000 ALTER TABLE `rg4_counter_host` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_counter_host` ENABLE KEYS */;

-- 테이블 altibase.rg4_counter_log 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_counter_log` (
  `num` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT NULL DEFAULT '',
  `reg_date` int(11) NOT NULL DEFAULT '0',
  `host` varchar(255) NOT NULL DEFAULT '',
  `referrer` varchar(255) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `browser` varchar(255) NOT NULL DEFAULT '',
  `os` varchar(255) NOT NULL DEFAULT '',
  `res` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`num`),
  KEY `ip` (`ip`),
  KEY `reg_date` (`reg_date`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_counter_log:~1 rows (대략적) 내보내기
DELETE FROM `rg4_counter_log`;
/*!40000 ALTER TABLE `rg4_counter_log` DISABLE KEYS */;
INSERT INTO `rg4_counter_log` (`num`, `ip`, `reg_date`, `host`, `referrer`, `keyword`, `hits`, `browser`, `os`, `res`) VALUES
	(1, '127.0.0.1', 1516432993, '', '', '', 1, 'safari 537.36', 'nt', '1366x768');
/*!40000 ALTER TABLE `rg4_counter_log` ENABLE KEYS */;

-- 테이블 altibase.rg4_counter_search 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_counter_search` (
  `num` int(11) NOT NULL AUTO_INCREMENT,
  `yy` int(4) NOT NULL DEFAULT '0',
  `mm` tinyint(2) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `host` varchar(255) NOT NULL DEFAULT '',
  `keyword` varchar(255) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `unique_hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num`),
  KEY `yy` (`yy`),
  KEY `mm` (`mm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_counter_search:~0 rows (대략적) 내보내기
DELETE FROM `rg4_counter_search`;
/*!40000 ALTER TABLE `rg4_counter_search` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_counter_search` ENABLE KEYS */;

-- 테이블 altibase.rg4_gmember 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_gmember` (
  `gm_num` int(11) NOT NULL AUTO_INCREMENT,
  `gr_num` int(11) NOT NULL DEFAULT '0',
  `mb_num` int(11) NOT NULL DEFAULT '0',
  `gm_reg_date` int(11) NOT NULL DEFAULT '0',
  `gm_reg_ip` varchar(20) NOT NULL DEFAULT '',
  `gm_state` int(1) NOT NULL DEFAULT '0',
  `gm_level` int(2) NOT NULL DEFAULT '0',
  `gm_ext1` text,
  `gm_ext2` text,
  `gm_ext3` text,
  `gm_ext4` text,
  `gm_ext5` text,
  PRIMARY KEY (`gm_num`),
  KEY `gr_num` (`gr_num`),
  KEY `mb_num` (`mb_num`),
  KEY `gm_state` (`gm_state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_gmember:~0 rows (대략적) 내보내기
DELETE FROM `rg4_gmember`;
/*!40000 ALTER TABLE `rg4_gmember` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_gmember` ENABLE KEYS */;

-- 테이블 altibase.rg4_group 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_group` (
  `gr_num` int(11) NOT NULL AUTO_INCREMENT,
  `gr_id` varchar(255) NOT NULL DEFAULT '',
  `gr_name` varchar(255) NOT NULL DEFAULT '',
  `gr_desc` text,
  `gr_header_file` varchar(255) NOT NULL DEFAULT '',
  `gr_header_tag` text,
  `gr_footer_tag` text,
  `gr_footer_file` varchar(255) NOT NULL DEFAULT '',
  `gr_state` int(1) NOT NULL DEFAULT '0',
  `gr_default_state` int(1) NOT NULL DEFAULT '0',
  `gr_default_level` int(3) NOT NULL DEFAULT '0',
  `gr_level_type` int(1) NOT NULL DEFAULT '0',
  `gr_level_info` text NOT NULL,
  `gr_ext_cfg` text,
  `gr_admin_memo` text NOT NULL,
  `gr_reg_date` int(11) NOT NULL DEFAULT '0',
  `gr_reg_mb` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`gr_num`),
  KEY `gr_id` (`gr_id`),
  KEY `gr_name` (`gr_name`),
  KEY `gr_state` (`gr_state`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_group:~1 rows (대략적) 내보내기
DELETE FROM `rg4_group`;
/*!40000 ALTER TABLE `rg4_group` DISABLE KEYS */;
INSERT INTO `rg4_group` (`gr_num`, `gr_id`, `gr_name`, `gr_desc`, `gr_header_file`, `gr_header_tag`, `gr_footer_tag`, `gr_footer_file`, `gr_state`, `gr_default_state`, `gr_default_level`, `gr_level_type`, `gr_level_info`, `gr_ext_cfg`, `gr_admin_memo`, `gr_reg_date`, `gr_reg_mb`) VALUES
	(1, 'main', '메인그룹', '기본그룹', '', '', '', '', 1, 1, 1, 0, 'a:12:{i:0;s:6:"손님";i:1;s:7:"레벨1";i:2;s:7:"레벨2";i:3;s:7:"레벨3";i:4;s:7:"레벨4";i:5;s:7:"레벨5";i:6;s:7:"레벨6";i:7;s:7:"레벨7";i:8;s:7:"레벨8";i:9;s:7:"레벨9";i:50;s:15:"그룹관리자";i:90;s:9:"운영자";}', '', '기본그룹임', 1183101274, 1);
/*!40000 ALTER TABLE `rg4_group` ENABLE KEYS */;

-- 테이블 altibase.rg4_member 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_member` (
  `mb_num` int(11) NOT NULL AUTO_INCREMENT,
  `mb_id` varchar(255) NOT NULL DEFAULT '',
  `mb_pass` varchar(255) NOT NULL DEFAULT '',
  `mb_name` varchar(255) NOT NULL DEFAULT '',
  `mb_nick` varchar(255) NOT NULL DEFAULT '',
  `mb_level` int(3) NOT NULL DEFAULT '0',
  `mb_state` int(1) NOT NULL DEFAULT '0',
  `mb_jumin` varchar(255) NOT NULL DEFAULT '',
  `mb_sex` char(2) NOT NULL DEFAULT '',
  `mb_post` varchar(255) NOT NULL DEFAULT '',
  `mb_address1` varchar(255) NOT NULL DEFAULT '',
  `mb_address2` varchar(255) NOT NULL DEFAULT '',
  `mb_email` varchar(255) NOT NULL DEFAULT '',
  `mb_tel1` varchar(255) NOT NULL DEFAULT '',
  `mb_tel2` varchar(255) NOT NULL DEFAULT '',
  `mb_files` text,
  `mb_is_mailing` int(1) NOT NULL DEFAULT '0',
  `mb_is_opening` int(1) NOT NULL DEFAULT '0',
  `mb_open_field` text,
  `mb_signature` text,
  `mb_introduce` text,
  `mb_admin_memo` text,
  `mb_ext1` text,
  `mb_ext2` text,
  `mb_ext3` text,
  `mb_ext4` text,
  `mb_ext5` text,
  `mb_point` int(11) NOT NULL DEFAULT '0',
  `login_count` int(11) NOT NULL DEFAULT '0',
  `login_date` int(11) NOT NULL DEFAULT '0',
  `login_ip` varchar(20) NOT NULL DEFAULT '',
  `join_date` int(11) NOT NULL DEFAULT '0',
  `join_ip` varchar(20) NOT NULL DEFAULT '',
  `modify_date` int(11) NOT NULL DEFAULT '0',
  `modify_ip` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`mb_num`),
  KEY `mb_id` (`mb_id`),
  KEY `mb_name` (`mb_name`),
  KEY `mb_nick` (`mb_nick`),
  KEY `mb_jumin` (`mb_jumin`),
  KEY `mb_state` (`mb_state`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_member:~1 rows (대략적) 내보내기
DELETE FROM `rg4_member`;
/*!40000 ALTER TABLE `rg4_member` DISABLE KEYS */;
INSERT INTO `rg4_member` (`mb_num`, `mb_id`, `mb_pass`, `mb_name`, `mb_nick`, `mb_level`, `mb_state`, `mb_jumin`, `mb_sex`, `mb_post`, `mb_address1`, `mb_address2`, `mb_email`, `mb_tel1`, `mb_tel2`, `mb_files`, `mb_is_mailing`, `mb_is_opening`, `mb_open_field`, `mb_signature`, `mb_introduce`, `mb_admin_memo`, `mb_ext1`, `mb_ext2`, `mb_ext3`, `mb_ext4`, `mb_ext5`, `mb_point`, `login_count`, `login_date`, `login_ip`, `join_date`, `join_ip`, `modify_date`, `modify_ip`) VALUES
	(1, 'altibase', 'b59c67bf196a4758191e42f76670ceba', '최준호', '관리자', 90, 1, '', '', '', '', '', 'braverokmc79@gmail.com', '', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1516432655, '127.0.0.1', 1516432560, '127.0.0.1', 0, '');
/*!40000 ALTER TABLE `rg4_member` ENABLE KEYS */;

-- 테이블 altibase.rg4_note 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_note` (
  `nt_num` int(11) NOT NULL AUTO_INCREMENT,
  `mb_num` int(11) NOT NULL DEFAULT '0',
  `nt_type` int(1) NOT NULL DEFAULT '0',
  `nt_save` int(1) NOT NULL DEFAULT '0',
  `recv_mb_num` int(11) NOT NULL DEFAULT '0',
  `sent_mb_num` int(11) NOT NULL DEFAULT '0',
  `nt_sent_date` int(11) NOT NULL DEFAULT '0',
  `nt_recv_date` int(11) NOT NULL DEFAULT '0',
  `nt_sent_num` int(11) NOT NULL DEFAULT '0',
  `nt_link` varchar(255) NOT NULL DEFAULT '',
  `nt_content` text,
  PRIMARY KEY (`nt_num`),
  KEY `mb_num` (`mb_num`),
  KEY `nt_type` (`nt_type`),
  KEY `nt_save` (`nt_save`),
  KEY `recv_mb_num` (`recv_mb_num`),
  KEY `sent_mb_num` (`sent_mb_num`),
  KEY `nt_sent_num` (`nt_sent_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_note:~0 rows (대략적) 내보내기
DELETE FROM `rg4_note`;
/*!40000 ALTER TABLE `rg4_note` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_note` ENABLE KEYS */;

-- 테이블 altibase.rg4_point 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_point` (
  `po_num` int(11) NOT NULL AUTO_INCREMENT,
  `mb_num` int(11) NOT NULL DEFAULT '0',
  `po_type` int(2) NOT NULL DEFAULT '0',
  `po_part1` varchar(255) NOT NULL DEFAULT '',
  `po_part2` varchar(255) NOT NULL DEFAULT '',
  `po_point` int(11) NOT NULL DEFAULT '0',
  `po_current_point` int(11) NOT NULL DEFAULT '0',
  `po_date` int(11) NOT NULL DEFAULT '0',
  `po_data` text,
  PRIMARY KEY (`po_num`),
  KEY `mb_num` (`mb_num`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_point:~1 rows (대략적) 내보내기
DELETE FROM `rg4_point`;
/*!40000 ALTER TABLE `rg4_point` DISABLE KEYS */;
INSERT INTO `rg4_point` (`po_num`, `mb_num`, `po_type`, `po_part1`, `po_part2`, `po_point`, `po_current_point`, `po_date`, `po_data`) VALUES
	(1, 1, 0, '로그인', '로그인포인트', 1, 1, 1516432655, '');
/*!40000 ALTER TABLE `rg4_point` ENABLE KEYS */;

-- 테이블 altibase.rg4_popup 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_popup` (
  `pp_num` int(11) NOT NULL AUTO_INCREMENT,
  `pp_win_type_cd` char(2) DEFAULT NULL,
  `pp_title` varchar(255) DEFAULT NULL,
  `pp_use_yn` char(1) DEFAULT NULL,
  `pp_start_time` int(11) DEFAULT NULL,
  `pp_start_use_yn` char(1) DEFAULT NULL,
  `pp_end_time` int(11) DEFAULT NULL,
  `pp_end_use_yn` char(1) DEFAULT NULL,
  `pp_width` int(11) DEFAULT NULL,
  `pp_height` int(11) DEFAULT NULL,
  `pp_scrollbars_yn` char(1) DEFAULT NULL,
  `pp_left` int(11) DEFAULT NULL,
  `pp_top` int(11) DEFAULT NULL,
  `pp_cont_type_cd` char(2) DEFAULT NULL,
  `pp_images` text,
  `pp_link_url` varchar(255) DEFAULT NULL,
  `pp_content` text,
  `reg_date` int(11) DEFAULT NULL,
  `reg_mb_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pp_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_popup:~0 rows (대략적) 내보내기
DELETE FROM `rg4_popup`;
/*!40000 ALTER TABLE `rg4_popup` DISABLE KEYS */;
/*!40000 ALTER TABLE `rg4_popup` ENABLE KEYS */;

-- 테이블 altibase.rg4_setup 구조 내보내기
CREATE TABLE IF NOT EXISTS `rg4_setup` (
  `ss_num` int(11) NOT NULL AUTO_INCREMENT,
  `ss_name` varchar(255) NOT NULL DEFAULT '',
  `ss_content` text,
  PRIMARY KEY (`ss_num`),
  KEY `ss_name` (`ss_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- 테이블 데이터 altibase.rg4_setup:~3 rows (대략적) 내보내기
DELETE FROM `rg4_setup`;
/*!40000 ALTER TABLE `rg4_setup` DISABLE KEYS */;
INSERT INTO `rg4_setup` (`ss_num`, `ss_name`, `ss_content`) VALUES
	(1, 'site_info', 'a:12:{s:9:"site_name";s:15:"사이트이름";s:10:"admin_name";s:12:"운영자명";s:11:"admin_email";s:12:"master@aa.aa";s:9:"admin_tel";s:13:"000-0000-0000";s:9:"mail_from";s:15:"발송이메일";s:11:"mail_return";s:12:"master@aa.aa";s:10:"join_point";s:2:"10";s:11:"login_point";s:1:"1";s:10:"join_state";s:1:"1";s:10:"join_level";s:1:"1";s:11:"leave_state";s:1:"2";s:10:"join_login";s:1:"1";}'),
	(2, 'level_info', 'a:12:{i:0;s:6:"손님";i:1;s:7:"레벨1";i:2;s:7:"레벨2";i:3;s:7:"레벨3";i:4;s:7:"레벨4";i:5;s:7:"레벨5";i:6;s:7:"레벨6";i:7;s:7:"레벨7";i:8;s:7:"레벨8";i:9;s:7:"레벨9";i:50;s:15:"그룹관리자";i:90;s:9:"운영자";}'),
	(3, 'member_form', 'a:11:{s:7:"mb_name";s:1:"2";s:7:"mb_nick";s:1:"2";s:8:"mb_email";s:1:"2";s:8:"mb_jumin";s:1:"1";s:7:"mb_tel1";s:1:"2";s:7:"mb_tel2";s:1:"1";s:10:"mb_address";s:1:"1";s:12:"mb_signature";s:1:"1";s:12:"mb_introduce";s:1:"1";s:6:"photo1";s:1:"1";s:5:"icon1";s:1:"1";}');
/*!40000 ALTER TABLE `rg4_setup` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;