-- 작성날짜 : 2014년 01월 10일 금요일 오전 08시 02분, 날씨 무척 추움

-- 피리 > 피리 레벨 도우미 PLUS G5 > 레벨 CONFIG 화일

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

--
-- Table structure for table `g5__piree_770002_level_config`
--

DROP TABLE IF EXISTS `g5__piree_770002_level_config`;
CREATE TABLE IF NOT EXISTS `g5__piree_770002_level_config` (
  `num` int(11) NOT NULL auto_increment,
  `level_n` smallint UNSIGNED NOT NULL DEFAULT '0',
  `level_s` varchar(20) NOT NULL default '',
  `level_memo` varchar(600) NOT NULL default '',
  `use_auto_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `use_realtime_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `is_admin_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `assess_month_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `point_n` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `point_pay_n` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `arti_t` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `comm_t` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `attend_t` smallint UNSIGNED NOT NULL DEFAULT '0',
  `day_join_n` smallint UNSIGNED NOT NULL DEFAULT '0',
  `member_t` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `regi_time_n` int(11) UNSIGNED NOT NULL default '0',
  `relo_time_n` int(11) UNSIGNED NOT NULL default '0',
  PRIMARY KEY  (`num`),
  UNIQUE KEY `lv_n` (`level_n`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `g5__piree_770002_level_log`
--

DROP TABLE IF EXISTS `g5__piree_770002_level_log`;
CREATE TABLE IF NOT EXISTS `g5__piree_770002_level_log` (
  `num` int(11) NOT NULL auto_increment,
  `req_mem_mn` INT(13) NOT NULL default '0',
  `req_mb_id` varchar(20) NOT NULL default '',
  `req_mb_nick` varchar(255) NOT NULL default '',
  `admin_mem_mn` INT(13) NOT NULL default '0',
  `admin_mb_id` varchar(20) NOT NULL default '',
  `admin_mb_nick` varchar(255) NOT NULL default '',
  `level_now_n` smallint unsigned NOT NULL DEFAULT '0',
  `level_new_n` smallint unsigned NOT NULL DEFAULT '0',
  `point_n` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `arti_t` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `comm_t` int(11) UNSIGNED NOT NULL DEFAULT '0',
  `attend_t` smallint UNSIGNED NOT NULL DEFAULT '0',
  `is_auto_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `is_realtime_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `is_end_n` tinyint(4) UNSIGNED NOT NULL default '0',
  `active_s` varchar(20) NOT NULL default '',
  `active_m` varchar(600) NOT NULL default '',
  `requ_time_n` INT(13) NOT NULL default '0',
  `view_time_n` INT(13) NOT NULL default '0',
  `chng_time_n` INT(13) NOT NULL default '0',
  PRIMARY KEY  (`num`),
  KEY `mnlv` (`req_mem_mn`, `level_new_n`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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