drop table rainmap_search;

CREATE TABLE `rainmap_search` (
  `muid` int(10) NOT NULL auto_increment,
  `latitude_e6` int(10) NOT NULL default '0',
  `longitude_e6` int(10) NOT NULL default '0',
  `icon` int(3) NOT NULL default '0',
  `color` int(3) NOT NULL default '0',
  `label` varchar(255) NOT NULL default '',
  `extra` varchar(255) NOT NULL default '',
  `extratype` varchar(10) NOT NULL default '',
  `zoom` int(2) default '0',
  `userip` varchar(16) default '',
  `regdate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`muid`),
  KEY `latlon` (`latitude_e6`,`longitude_e6`),
  KEY `regdate` (`regdate`)
) ENGINE=MyISAM COMMENT='·¹ÀÎ¸Ê °Ë»ö' 


drop table rainmap_weather;

CREATE TABLE `rainmap_weather` (
  `latitude_e6` int(10) NOT NULL default '0',
  `longitude_e6` int(10) NOT NULL default '0',
  `area_name` varchar(50) NOT NULL default '',
  `current_condition` varchar(30) NOT NULL default '',
  `current_temp_f` int(5) NOT NULL default '0',
  `current_temp_c` int(5) NOT NULL default '0',
  `current_humidity` varchar(20) NOT NULL default '',
  `current_icon` int(3) NOT NULL default '0',
  `current_wind` varchar(50) NOT NULL default '',
  `day0_week` varchar(4) NOT NULL default '',
  `day0_low` int(3) NOT NULL default '0',
  `day0_high` int(3) NOT NULL default '0',
  `day0_icon` int(3) NOT NULL default '0',
  `day0_condition` varchar(50) NOT NULL default '',
  `day1_week` varchar(4) NOT NULL default '',
  `day1_low` int(3) NOT NULL default '0',
  `day1_high` int(3) NOT NULL default '0',
  `day1_icon` int(3) NOT NULL default '0',
  `day1_condition` varchar(50) NOT NULL default '',
  `day2_week` varchar(4) NOT NULL default '',
  `day2_low` int(3) NOT NULL default '0',
  `day2_high` int(3) NOT NULL default '0',
  `day2_icon` int(3) NOT NULL default '0',
  `day2_condition` varchar(50) NOT NULL default '',
  `day3_week` varchar(4) NOT NULL default '',
  `day3_low` int(3) NOT NULL default '0',
  `day3_high` int(3) NOT NULL default '0',
  `day3_icon` int(3) NOT NULL default '0',
  `day3_condition` varchar(50) NOT NULL default '',
  `regdate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`latitude_e6`,`longitude_e6`),
  KEY `regdate` (`regdate`)
) ENGINE=MyISAM COMMENT='·¹ÀÎ¸Ê ³¯¾¾';


drop table rainmap_reverse;

CREATE TABLE `rainmap_reverse` (
  `latitude_e6` int(10) NOT NULL default '0',
  `longitude_e6` int(10) NOT NULL default '0',
  `area_name` varchar(100) NOT NULL default '',
  `keyword` varchar(100) NOT NULL default '',
  `country` varchar(50) NOT NULL default '',
  `state` varchar(50) NOT NULL default '',
  `county` varchar(50) NOT NULL default '',
  `town` varchar(50) NOT NULL default '',
  `regdate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`latitude_e6`,`longitude_e6`),
  KEY `regdate` (`regdate`)
) ENGINE=MyISAM COMMENT='·¹ÀÎ¸Ê RGC' ;

drop table rainmap_encyc;

drop table rainmap_rssdata;

CREATE TABLE `rainmap_rssdata` (
  `muid` int(10) NOT NULL auto_increment,
  `apitype` varchar(5) NOT NULL default '',
  `keyword` varchar(50) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '0',
  `link` varchar(100) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `thumbnail` varchar(100) NOT NULL default '',
  `regdate` int(11) NOT NULL default '0',
  `validdate` int(11) NOT NULL default '0',
  PRIMARY KEY  (`muid`),
  KEY `apitype` (`apitype`),
  KEY `keyword` (`keyword`)
) ENGINE=MyISAM  COMMENT='·¹ÀÎ¸Ê ¿ÜºÎ°Ë»öµ¥ÀÌŸ';

CREATE TABLE `rainmap_worldcity` (
  `latitude_e6` int(10) NOT NULL default '0',
  `longitude_e6` int(10) NOT NULL default '0',
  `country_eng` varchar(50) NOT NULL default '',
  `country_kor` varchar(50) NOT NULL default '',
  `country_code` char(2) NOT NULL default '',
  `city_eng` varchar(50) NOT NULL default '',
  `city_kor` varchar(50) NOT NULL default '',
  `is_capital` enum('Y','N') NOT NULL default 'N',
  `info_weather` text NOT NULL,
  `info_weather_icon` int(3) NOT NULL default '0',
  `info_weather_date` int(11) NOT NULL default '0',
  `info_dic` text NOT NULL,
  `info_dic_date` int(11) NOT NULL default '0',
  `info_image` text NOT NULL,
  `info_image_date` int(11) NOT NULL default '0',
  `info_news` text NOT NULL,
  `info_news_date` int(11) NOT NULL default '0',
  `info_movie` text NOT NULL,
  `info_movie_date` int(11) NOT NULL default '0',
  PRIMARY KEY  (`latitude_e6`,`longitude_e6`),
  KEY `country_eng` (`country_eng`),
  KEY `country_kor` (`country_kor`),
  KEY `city_eng` (`city_eng`),
  KEY `city_kor` (`city_kor`)
) ENGINE=MyISAM COMMENT='·¹ÀÎ¸Ê µµ½ÃÁ¤º¸';