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

--
-- テーブルの構造 `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 ;
-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `corp_data` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `address1` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `address2` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `address3` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `address4` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `tel` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `fax` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `time` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `holiday` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `url` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `tex` longtext collate utf8_unicode_ci NOT NULL,
  `user_id` varchar(15) collate utf8_unicode_ci NOT NULL default '',
  `user_pass` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `disp_flag` int(1) NOT NULL default '0',
  `state` int(1) NOT NULL default '0',
  `state2` int(11) NOT NULL default '0',
  `state3` int(11) NOT NULL default '0',
  `state4` int(1) NOT NULL default '0',
  `top_bk_no` int(3) NOT NULL default '0',
  `top_tp_no` int(3) NOT NULL default '0',
  `top_op_no` int(3) NOT NULL default '0',
  `result_bk_no` int(3) NOT NULL default '0',
  `topics_admin` int(1) NOT NULL default '1',
  `customer_admin` int(1) NOT NULL default '0',
  `customer_id` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `customer_pass` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `reg_admin` int(1) NOT NULL default '1',
  `chu_admin` int(1) NOT NULL default '1',
  `land_admin` int(1) NOT NULL default '1',
  `man_admin` int(1) NOT NULL default '1',
  `jig_admin` int(1) NOT NULL default '1',
  `rent_kyo_admin` int(1) NOT NULL default '1',
  `rent_jig_admin` int(1) NOT NULL default '1',
  `rent_land_admin` int(1) NOT NULL default '1',
  `rent_car_admin` int(1) NOT NULL default '1',
  `cliant_viwe` int(1) NOT NULL default '1',
  `baibai` int(11) NOT NULL default '0',
  `chintai` int(11) NOT NULL default '0',
  `area_data` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `line_data` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `lat` float(10,7) NOT NULL default '0.0000000',
  `lng` float(10,7) NOT NULL default '0.0000000',
  `check_mode` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `check_selecter` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `main_title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sub_title` longtext collate utf8_unicode_ci NOT NULL,
  `kamei` longtext collate utf8_unicode_ci NOT NULL,
  `daitori` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `jigyo` longtext collate utf8_unicode_ci NOT NULL,
  `menkyo` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `Gazou1_Com` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1000045 ;

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

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

CREATE TABLE IF NOT EXISTS `es_list_new` (
  `id` int(255) NOT NULL default '0',
  `Genhan_Bikou` varchar(255) NOT NULL default '',
  `Top_Title` longtext NOT NULL,
  `Man_Name` varchar(255) NOT NULL default '',
  `Sub_Copy` longtext NOT NULL,
  `Yuubin1` int(3) NOT NULL default '0',
  `Yuubin2` int(4) NOT NULL default '0',
  `Rosen2_Todouhuken` varchar(10) NOT NULL default '',
  `Rosen2_Rosen` varchar(10) NOT NULL default '',
  `Rosen2_Eki` varchar(10) NOT NULL default '',
  `Rosen2_Toho` int(3) NOT NULL default '0',
  `Rosen2_Basu` int(3) NOT NULL default '0',
  `Rosen2_Basutei` varchar(10) NOT NULL default '',
  `Rosen2_Teiho` int(3) NOT NULL default '0',
  `Rosen2_Kyori` int(4) NOT NULL default '0',
  `Rosen3_Todouhuken` varchar(10) NOT NULL default '',
  `Rosen3_Rosen` varchar(10) NOT NULL default '',
  `Rosen3_Eki` varchar(10) NOT NULL default '',
  `Rosen3_Toho` int(3) NOT NULL default '0',
  `Rosen3_Basu` int(3) NOT NULL default '0',
  `Rosen3_Basutei` varchar(10) NOT NULL default '',
  `Rosen3_Teiho` int(3) NOT NULL default '0',
  `Rosen3_Kyori` int(4) NOT NULL default '0',
  `Tochi_Menseki_Kizyun` int(1) NOT NULL default '0',
  `Tochi_Menseki_Bikou` varchar(255) NOT NULL default '',
  `Senyu_Menseki_Kizyun` int(1) NOT NULL default '0',
  `Shidou1_Menseki` float(6,2) NOT NULL default '0.00',
  `Shidou2_Menseki` float(6,2) NOT NULL default '0.00',
  `Setback_Menseki` float(6,2) NOT NULL default '0.00',
  `Setback_Sentaku` float(6,2) NOT NULL default '0.00',
  `Tatemono_Menseki_Bikou` varchar(255) NOT NULL default '',
  `Valcony_Menseki_Bikou` varchar(255) NOT NULL default '',
  `Madori_Bikou` varchar(255) NOT NULL default '',
  `Madori_Syousai1_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai1_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai2_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai2_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai3_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai3_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai4_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai4_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai5_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai5_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai6_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai6_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai7_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai7_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai8_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai8_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai9_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai9_Zyousuu` varchar(5) NOT NULL default '',
  `Madori_Syousai10_Syurui` int(1) NOT NULL default '0',
  `Madori_Syousai10_Zyousuu` varchar(5) NOT NULL default '',
  `Kouzou_Chizyou` int(2) NOT NULL default '0',
  `Kouzou_Chika` int(2) NOT NULL default '0',
  `Soukosuu` int(2) NOT NULL default '0',
  `Hanbaikosuu` int(2) NOT NULL default '0',
  `Kenkaku` varchar(255) NOT NULL default '',
  `Setsudou1_Houkou` int(1) NOT NULL default '0',
  `Setsudou1_Hukuin` float(5,2) NOT NULL default '0.00',
  `Setsudou1_Maguchi` float(5,2) NOT NULL default '0.00',
  `Setsudou2_Houkou` int(1) NOT NULL default '0',
  `Setsudou2_Hukuin` float(5,2) NOT NULL default '0.00',
  `Setsudou2_Maguchi` float(5,2) NOT NULL default '0.00',
  `Kenri` int(2) NOT NULL default '0',
  `Kenri_Bikou` varchar(255) NOT NULL default '',
  `Toshikeikaku` int(2) NOT NULL default '0',
  `Sekou_Kaisya` text NOT NULL,
  `Youto2` int(2) NOT NULL default '0',
  `Chimoku` int(2) NOT NULL default '0',
  `Parking1` int(2) NOT NULL default '0',
  `Parking2` varchar(255) NOT NULL default '',
  `Parking_Ryoukin1` int(6) NOT NULL default '0',
  `Parking_Ryoukin2` int(6) NOT NULL default '0',
  `Kanrihi1` int(6) NOT NULL default '0',
  `Kanrihi2` int(6) NOT NULL default '0',
  `Kanrihi_Nashi` int(1) NOT NULL default '0',
  `Kanrihi_Bikou` varchar(255) NOT NULL default '',
  `Tumitatekin1` int(6) NOT NULL default '0',
  `Tumitatekin2` int(6) NOT NULL default '0',
  `Tumitatekin_Bikou` varchar(255) NOT NULL default '',
  `Kanri_Keitai` int(2) NOT NULL default '0',
  `Kanri_Kaisya` varchar(255) NOT NULL default '',
  `Kenpeiritu2` int(4) NOT NULL default '0',
  `Yousekiritsu2` int(4) NOT NULL default '0',
  `Syougakkou` varchar(255) NOT NULL default '',
  `Tyuugakkou` varchar(255) NOT NULL default '',
  `Torihikitaiyou` int(2) NOT NULL default '1',
  `Kokudohou` int(2) NOT NULL default '0',
  `Sonota_No` varchar(255) NOT NULL default '',
  `Hikiwatashi_Ziki` int(2) NOT NULL default '0',
  `Hikiwatashi_Zyouken` int(2) NOT NULL default '0',
  `Hikiwatashi_Zyouken2` varchar(255) NOT NULL default '',
  `Rimawari` varchar(6) NOT NULL default '',
  `Heya_Bangou` varchar(10) NOT NULL default '',
  `Kyouekihi` int(10) NOT NULL default '0',
  `Kyouekihi_Tani` int(2) NOT NULL default '1',
  `Kyouekihi_Bikou` varchar(255) NOT NULL default '',
  `Kyouekihi_Nashi` int(1) NOT NULL default '0',
  `Kenrikin` int(10) NOT NULL default '0',
  `Kenrikin_Tani` int(2) NOT NULL default '1',
  `Kenrikin_Nashi` int(1) NOT NULL default '0',
  `Koushinryou` int(10) NOT NULL default '0',
  `Koushinryou_Tani` int(2) NOT NULL default '1',
  `Koushinryou_Nashi` int(1) NOT NULL default '0',
  `Kasaihokenryou` int(10) NOT NULL default '0',
  `Sonota_Hiyou` varchar(100) NOT NULL default '',
  `Keiyakukikan_nen` int(2) NOT NULL default '0',
  `Keiyakukikan_Tsuki` int(2) NOT NULL default '0',
  `Keiyakukikan_Bikou` varchar(50) NOT NULL default '',
  `Syoukyakukinn` int(10) NOT NULL default '0',
  `Syoukyakukinn_Tani` int(2) NOT NULL default '1',
  `Syoukyakukinn_Nashi` int(1) NOT NULL default '0',
  `Syoukyakukinn_Ziki` varchar(255) NOT NULL default '',
  `Gazou1_Com` varchar(255) NOT NULL default '',
  `Gazou2_Com` varchar(255) NOT NULL default '',
  `Gazou3_Com` varchar(255) NOT NULL default '',
  `Gazou4_Com` varchar(255) NOT NULL default '',
  `Gazou5_Com` varchar(255) NOT NULL default '',
  `Gazou6_Com` varchar(255) NOT NULL default '',
  `Gazou7_Com` varchar(255) NOT NULL default '',
  `Gazou8_Com` varchar(255) NOT NULL default '',
  `Gazou9_Com` varchar(255) NOT NULL default '',
  `Gazou10_Com` varchar(255) NOT NULL default '',
  `Gazou11_Com` varchar(255) NOT NULL default '',
  `Gazou12_Com` varchar(255) NOT NULL default '',
  `Gazou13_Com` varchar(255) NOT NULL default '',
  `Gazou14_Com` varchar(255) NOT NULL default '',
  `Gazou15_Com` varchar(255) NOT NULL default '',
  `Setsubi` longtext NOT NULL,
  `Bikou` longtext NOT NULL,
  `Tokkizikou` longtext NOT NULL,
  `Motozuke_Name` varchar(255) NOT NULL default '',
  `Motozuke_Tel` varchar(255) NOT NULL default '',
  `Nyuuryoku_Tantou` varchar(255) NOT NULL default '',
  `youtube` varchar(255) NOT NULL default '',
  `Corp_Id` int(11) NOT NULL default '0',
  `Conv_Id` bigint(255) NOT NULL default '0',
  `Portal_Flug` int(1) NOT NULL default '0',
  `Portal_Top_Flug` int(1) NOT NULL default '0',
  `Kiriwake_Flug` int(1) NOT NULL default '0',
  `Kiriwake_Top_Flug` int(1) NOT NULL default '0',
  `Genhan_Flug` int(1) NOT NULL default '0',
  `Custom_Flug` int(1) NOT NULL default '0',
  `Syubetsu_Sel` int(1) NOT NULL default '0',
  `Syubetsu_bikou` char(255) NOT NULL default '',
  `Syubetsu_Syurui` int(1) NOT NULL default '0',
  `check_mode` char(2) NOT NULL default '',
  `Datetime_Add` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Datetime_Edit` timestamp NOT NULL default '0000-00-00 00:00:00',
  `Genhan1` datetime NOT NULL default '0000-00-00 00:00:00',
  `Genhan2` datetime NOT NULL default '0000-00-00 00:00:00',
  `Genhan_Lat` float(10,7) NOT NULL default '0.0000000',
  `Genhan_Lng` float(10,7) NOT NULL default '0.0000000',
  `Genhan_Open` varchar(6) NOT NULL default '',
  `Genhan_Close` varchar(6) NOT NULL default '',
  `Kakaku1` int(10) NOT NULL default '0',
  `Kakaku2` int(10) NOT NULL default '0',
  `Kakaku_zei` int(1) default NULL,
  `Tochi1_Menseki` float(6,2) NOT NULL default '0.00',
  `Tochi2_Menseki` float(6,2) NOT NULL default '0.00',
  `Senyu1_Menseki` float(6,2) NOT NULL default '0.00',
  `Senyu2_Menseki` float(6,2) NOT NULL default '0.00',
  `Tatemono1_Menseki` float(6,2) NOT NULL default '0.00',
  `Tatemono2_Menseki` float(6,2) NOT NULL default '0.00',
  `Valcony1_Menseki` float(6,2) NOT NULL default '0.00',
  `Valcony2_Menseki` float(6,2) NOT NULL default '0.00',
  `Madori1` int(1) NOT NULL default '0',
  `Madori1_Syurui` int(2) NOT NULL default '0',
  `Madori1_no` int(3) NOT NULL default '0',
  `Madori2` int(1) NOT NULL default '0',
  `Madori2_Syurui` int(2) NOT NULL default '0',
  `Kenpeiritu1` int(3) NOT NULL default '0',
  `Yousekiritsu1` int(3) NOT NULL default '0',
  `Chikunen_Nen` datetime NOT NULL default '0000-00-00 00:00:00',
  `Chikunen_Tsuki` int(2) NOT NULL default '0',
  `Chikunen_Bikou` int(2) NOT NULL default '0',
  `Genkyou` int(2) NOT NULL default '0',
  `Kouzou_Kibo` int(2) NOT NULL default '0',
  `Kouzou_Kaisuu` int(2) NOT NULL default '0',
  `Kouzou_Kaibubun` int(2) NOT NULL default '0',
  `Youto1` int(2) NOT NULL default '0',
  `Kenchiku_Zyouken` int(1) NOT NULL default '0',
  `Shikikin` int(10) NOT NULL default '0',
  `Shikikin_Tani` int(1) NOT NULL default '1',
  `Shikikin_Nashi` int(1) NOT NULL default '0',
  `Reikin` int(10) NOT NULL default '0',
  `Reikin_Tani` int(1) NOT NULL default '1',
  `Reikin_Nashi` int(1) NOT NULL default '0',
  `Hosyoukin` int(10) NOT NULL default '0',
  `Hosyoukin_Tani` int(1) NOT NULL default '1',
  `Hosyoukin_Nashi` int(1) NOT NULL default '0',
  `Chizu_Hyouzi` int(1) NOT NULL default '1',
  `Ido` float(10,7) NOT NULL default '0.0000000',
  `Keido` float(10,7) NOT NULL default '0.0000000',
  `lat` float(10,7) NOT NULL default '0.0000000',
  `lng` float(10,7) NOT NULL default '0.0000000',
  `Point_Hyouji` int(1) NOT NULL default '0',
  `Lat_Pin` float(10,7) NOT NULL default '0.0000000',
  `Lng_Pin` float(10,7) NOT NULL default '0.0000000',
  `Todouhuken` varchar(10) NOT NULL default '',
  `Shikutyouson` varchar(10) NOT NULL default '',
  `Choumei` varchar(255) NOT NULL default '',
  `Choume` int(2) NOT NULL default '0',
  `Banchi` varchar(255) NOT NULL default '',
  `Rosen1_Todouhuken` varchar(10) NOT NULL default '',
  `Rosen1_Rosen` varchar(20) NOT NULL default '',
  `Rosen1_Eki` varchar(20) NOT NULL default '',
  `Rosen1_Toho` int(3) NOT NULL default '0',
  `Rosen1_Basu` int(3) NOT NULL default '0',
  `Rosen1_Basutei` varchar(15) NOT NULL default '',
  `Rosen1_Teiho` int(3) NOT NULL default '0',
  `Rosen1_Kyori` int(5) NOT NULL default '0',
  `Kodawari_Koumoku` longtext NOT NULL,
  `update_time` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

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

--
-- テーブルの構造 `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 ;

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

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

CREATE TABLE IF NOT EXISTS `user_db` (
  `id` int(255) NOT NULL auto_increment,
  `user_id` varchar(30) NOT NULL default '',
  `user_pass` varchar(30) NOT NULL default '',
  `corp_id` int(11) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `name_kana` varchar(50) NOT NULL default '',
  `post_num1` varchar(3) NOT NULL default '',
  `post_num2` varchar(4) NOT NULL default '',
  `todouhuken` varchar(15) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `tel` varchar(20) NOT NULL default '',
  `fax` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `dm` int(1) NOT NULL default '0',
  `kibou_order` varchar(255) NOT NULL default '',
  `price_l` int(10) NOT NULL default '0',
  `price_h` int(10) NOT NULL default '0',
  `kibou_rosen` varchar(255) NOT NULL default '',
  `genzai_sumaia` varchar(255) NOT NULL default '',
  `sumikae_riyuu` varchar(255) NOT NULL default '',
  `ekikara_yuusen` varchar(255) NOT NULL default '',
  `ekikara` varchar(255) NOT NULL default '',
  `menseki_yuusen` varchar(255) NOT NULL default '',
  `menseki` varchar(255) NOT NULL default '',
  `madori_yuusen` varchar(255) NOT NULL default '',
  `madori` varchar(255) NOT NULL default '',
  `gakku_yuusen` varchar(255) NOT NULL default '',
  `gakku` varchar(255) NOT NULL default '',
  `sonota` longtext NOT NULL,
  `add_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1500 ;

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

INSERT INTO `corp_data` (`id`, `name`, `address1`, `address2`, `address3`, `address4`, `tel`, `fax`, `time`, `holiday`, `url`, `email`, `tex`, `user_id`, `user_pass`, `disp_flag`, `state`, `state2`, `state3`, `state4`, `top_bk_no`, `top_tp_no`, `top_op_no`, `result_bk_no`, `topics_admin`, `customer_admin`, `customer_id`, `customer_pass`, `reg_admin`, `chu_admin`, `land_admin`, `man_admin`, `jig_admin`, `rent_kyo_admin`, `rent_jig_admin`, `rent_land_admin`, `rent_car_admin`, `cliant_viwe`, `baibai`, `chintai`, `area_data`, `line_data`, `lat`, `lng`, `check_mode`, `check_selecter`, `main_title`, `sub_title`, `kamei`, `daitori`, `jigyo`, `menkyo`, `Gazou1_Com`) VALUES
(99999, 'WEBMASTER', '', '', '', '', '', '', '', '', '', '', '', 'demagic', 'demagic', 0, 1, 1, 1, 0, 10, 10, 10, 10, 1, 0, '', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 10000000, 10000000, '', '', 0.0000000, 0.0000000, 'OK', 'bk', '', '', '', '', '', '', '');
