--
-- 테이블 구조 `bt_config`
--

CREATE TABLE IF NOT EXISTS `bt_config` (
  `bc_logo` varchar(100) NOT NULL,
  `bc_logo_width` int(11) NOT NULL,
  `bc_logo_height` int(11) NOT NULL,
  `bc_image_width` int(11) NOT NULL,
  `bc_skin_layout` varchar(40) NOT NULL,
  `bc_skin_mlayout` varchar(40) NOT NULL,
  `bc_skin_main` varchar(40) NOT NULL,
  `bc_skin_mmain` varchar(40) NOT NULL,
  `bc_alevel_useup` int(11) NOT NULL,
  `bc_alevel_usedown` int(11) NOT NULL,
  `bc_alevel_data` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- 테이블의 덤프 데이터 `bt_config`
--

INSERT INTO `bt_config` (`bc_logo`, `bc_logo_width`, `bc_logo_height`, `bc_image_width`, `bc_skin_layout`, `bc_skin_mlayout`, `bc_skin_main`, `bc_skin_mmain`, `bc_alevel_useup`, `bc_alevel_usedown`, `bc_alevel_data`) VALUES
('', 0, 0, 600, 'rightside', 'basic', 'basic', 'basic', 0, 0, '');


-- --------------------------------------------------------

--
-- 테이블 구조 `bt_menu`
--

CREATE TABLE IF NOT EXISTS `bt_menu` (
  `bm_idx` int(11) NOT NULL AUTO_INCREMENT,
  `bm_pidx` int(11) NOT NULL,
  `bm_code` varchar(7) NOT NULL,
  `bm_name` varchar(60) NOT NULL,
  `bm_type` varchar(10) NOT NULL,
  `bm_target` varchar(10) NOT NULL,
  `bm_step` int(11) NOT NULL,
  `bm_depth` int(11) NOT NULL,
  `bm_perm` int(11) NOT NULL,
  `bm_skin_layout` varchar(40) NOT NULL,
  `bm_skin_mlayout` varchar(40) NOT NULL,
  `bm_skin_group` varchar(20) NOT NULL,
  `bm_skin_mgroup` varchar(40) NOT NULL,
  `bm_mid` varchar(20) NOT NULL COMMENT '게시판아이디 또는 페이지아이디',
  `bm_device` varchar(10) NOT NULL,
  `bm_hide` int(11) NOT NULL,
  `bm_url` varchar(255) DEFAULT NULL,
  `bm_regdate` varchar(20) NOT NULL,
  PRIMARY KEY (`bm_idx`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='메뉴' AUTO_INCREMENT=54 ;


-- --------------------------------------------------------

--
-- 테이블 구조 `bt_page`
--

CREATE TABLE IF NOT EXISTS `bt_page` (
  `bp_id` varchar(20) NOT NULL,
  `bp_title` varchar(255) NOT NULL,
  `bp_content` text NOT NULL,
  `bp_regdate` varchar(20) NOT NULL,
  PRIMARY KEY (`bp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- --------------------------------------------------------

--
-- 테이블 구조 `bt_popup`
--

CREATE TABLE IF NOT EXISTS `bt_popup` (
  `bp_idx` int(11) NOT NULL AUTO_INCREMENT,
  `bp_subject` varchar(255) NOT NULL,
  `bp_type` varchar(10) NOT NULL,
  `bp_show_subject` int(11) NOT NULL,
  `bp_show_closeopt` int(11) NOT NULL,
  `bp_file` varchar(255) NOT NULL,
  `bp_width` int(11) NOT NULL,
  `bp_height` int(11) NOT NULL,
  `bp_url` varchar(255) NOT NULL,
  `bp_target` varchar(10) NOT NULL,
  `bp_sdate` varchar(20) NOT NULL,
  `bp_edate` varchar(20) NOT NULL,
  `bp_close_hour` varchar(2) NOT NULL,
  `bp_hide` int(11) NOT NULL,
  `bp_content` text NOT NULL,
  `bp_regdate` varchar(20) NOT NULL,
  PRIMARY KEY (`bp_idx`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='팝업' AUTO_INCREMENT=5 ;

