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

--
-- テーブルの構造 `address`
--

CREATE TABLE IF NOT EXISTS `address` (
  `id` int(5) NOT NULL auto_increment,
  `code1` int(2) NOT NULL default '0',
  `code2` int(3) NOT NULL default '0',
  `code` int(5) NOT NULL default '0',
  `zip1` int(3) NOT NULL default '0',
  `zip2` int(4) NOT NULL default '0',
  `kana1` varchar(30) character set utf8 NOT NULL default '',
  `kana2` varchar(60) character set utf8 NOT NULL default '',
  `kana3` varchar(150) character set utf8 NOT NULL default '',
  `address1` varchar(15) character set utf8 NOT NULL default '',
  `address2` varchar(30) character set utf8 NOT NULL default '',
  `address3` varchar(100) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12410 ;

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

--
-- テーブルの構造 `line`
--

CREATE TABLE IF NOT EXISTS `line` (
  `id` int(5) NOT NULL auto_increment,
  `cord_1` int(2) NOT NULL default '0',
  `cord_2` int(5) NOT NULL default '0',
  `cord_3` int(7) NOT NULL default '0',
  `line_corp` varchar(50) character set utf8 NOT NULL default '',
  `line_name` varchar(60) character set utf8 NOT NULL default '',
  `st_name` varchar(50) character set utf8 NOT NULL default '',
  `area` int(2) NOT NULL default '0',
  `lng` float(10,7) NOT NULL default '0.0000000',
  `lat` float(10,7) NOT NULL default '0.0000000',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10726 ;

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

--
-- テーブルの構造 `ng_list`
--

CREATE TABLE IF NOT EXISTS `ng_list` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `add_date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  `check_mode` varchar(2) NOT NULL default '',
  `corp_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=123 ;

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

--
-- テーブルの構造 `topics`
--

CREATE TABLE IF NOT EXISTS `topics` (
  `Id` int(255) NOT NULL auto_increment,
  `Corp_Id` int(255) NOT NULL default '0',
  `State` int(2) NOT NULL default '0',
  `Title` varchar(255) NOT NULL default '',
  `Text` longtext NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `Date` datetime NOT NULL default '0000-00-00 00:00:00',
  `Check_Mode` varchar(3) NOT NULL default '',
  `datetime1` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=104 ;

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

--
-- テーブルの構造 `user_bk`
--

CREATE TABLE IF NOT EXISTS `user_bk` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `bk_id` int(11) NOT NULL default '0',
  `date_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=415 ;
