-- MySQL dump 10.11
--
-- Host: localhost    Database: _db_abook
-- ------------------------------------------------------
-- Server version	5.0.51a

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `m_abook`
--

DROP TABLE IF EXISTS `m_abook`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_abook` (
  `id_abook` int(10) unsigned NOT NULL auto_increment,
  `id_account` int(10) unsigned NOT NULL,
  `id_category` int(10) unsigned NOT NULL,
  `c_name1` varchar(100) NOT NULL,
  `c_name2` varchar(100) NOT NULL,
  `c_yomi1` varchar(100) NOT NULL,
  `c_yomi2` varchar(100) NOT NULL,
  `c_renmei` varchar(100) NOT NULL,
  `c_zip1` varchar(10) NOT NULL,
  `c_zip2` varchar(10) NOT NULL,
  `c_kenid` varchar(10) NOT NULL,
  `c_address1` varchar(255) NOT NULL,
  `c_address2` varchar(255) NOT NULL,
  `c_phone1` varchar(100) NOT NULL,
  `c_phone2` varchar(100) NOT NULL,
  `c_email` varchar(255) NOT NULL,
  `c_memo` varchar(255) NOT NULL,
  `c_check1` int(10) unsigned NOT NULL default '0',
  `c_check2` int(10) unsigned NOT NULL default '0',
  `c_check3` int(10) unsigned NOT NULL default '0',
  `c_check4` int(10) unsigned NOT NULL default '0',
  `c_check5` int(10) unsigned NOT NULL default '0',
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  `c_privacy` int(10) unsigned NOT NULL default '0',
  `c_delete` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`id_abook`)
) ENGINE=MyISAM AUTO_INCREMENT=311 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_abook`
--

LOCK TABLES `m_abook` WRITE;
/*!40000 ALTER TABLE `m_abook` DISABLE KEYS */;
INSERT INTO `m_abook` VALUES (1,10001,1,'山田','木蓮','やまだ','もくれん','','138','8001','08','東京都中央区日本橋室町1-4-1','マンション日本橋','03-1234-5678','080-1212-3434','xxxxxx.xxxx@xxxxx.co.jp','登山',0,1,0,0,0,'2009-09-17 20:20:59','2009-09-20 07:54:26',0,0),(2,10001,1,'鈴木','一郎','すずき','いちろう','花子','850','0853','42','長崎市浜町7番11号','長崎ハイツ','052-111-2222','090-1919-2828','xxxxxx.xxxxx@xxxx.xxx','',1,0,0,0,0,'2009-09-17 20:23:55','2009-09-20 09:23:45',0,0),(3,10001,2,'田中','未来','たなか','みらい','','810','8717','40','福岡市中央区天神1-4-1','天神ヒルズ','','','xxxx.xxxxx@xxxx.xxx','',0,1,0,0,0,'2009-09-17 20:26:02','2009-09-19 21:37:58',0,0),(4,10001,2,'松本','夏子','まつもと','なつこ','','060','0005','01','札幌市中央区北5条西4丁目7番地','','','','xxxx.xxxxx@xxxx.xxx','',1,0,0,0,0,'2009-09-17 20:26:02','2009-09-19 20:49:10',0,0),(5,10001,2,'高橋','春香','たかはし','はるか','','920','8583','23','金沢市武蔵町15-1','ハウス屋敷町','','','xxxx.xxxxx@xxxx.xxx','',1,1,0,0,0,'2009-09-17 20:27:59','2009-09-19 21:40:51',0,0),(6,10001,1,'山本','銀河','やまもと','ぎんが','いちご','730','8548','31','広島市中区胡町6-26','広島パーク','','','','高校',1,1,0,0,0,'2009-09-17 20:27:59','2009-09-20 08:03:13',0,0),(7,10001,1,'小林','香織','こばやし','かおり','','650','0037','27','神戸市中央区明石町40番地','','','','xxxxxx.xxxxxx@xxxx.jp','高校',1,1,0,0,0,'2009-09-17 20:27:59','2009-09-20 07:53:51',0,0),(8,10001,1,'加藤','穂高','かとう','ほだか','さくら','220','8601','09','横浜市西区南幸1丁目6番31号','','','','xxxxx.xxxxxxx@xxxxx.xxxx.ne.jp','大学',0,0,0,0,0,'2009-09-17 20:27:59','2009-09-20 07:53:51',0,0),(9,10001,1,'中村','白馬','なかむら','はくば','','980','8052','06','宮城県仙台市青葉区一番町3丁目2番17号','青葉シティ','','','xxxxxx.zzzzzzz@xxxx.jp','大学 登山',1,1,0,1,0,'2009-09-17 20:27:59','2009-09-20 08:03:13',0,0),(10,10001,1,'伊藤','岳人','いとう','がくと','桃子','780','8566','39','高知県高知市帯屋町1丁目6番1号','','03-1234-5678','','aaaaa.zzzzzzz@xxxx.com','登山',1,0,1,0,0,'2009-09-17 20:32:10','2009-09-20 07:58:47',0,0),(305,10001,3,'阿蘇山','','あそさん','','','','','43','32.884,131.104','熊本','','','','1,592m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(306,10001,3,'九重山','','くじゅうさん','','','','','44','33.086,131.249','大分','','','','1,791m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(304,10001,3,'石鎚山','','いしづちさん','','','','','38','33.768,133.115','愛媛','','','','1,982m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(302,10001,3,'大山','','だいせん','','','','','34','35.371,133.546','鳥取','','','','1,729m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(303,10001,3,'剣山','','つるぎさん','','','','','36','33.855,134.096','徳島','','','','1,955m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(301,10001,3,'大台ヶ原山','','おおだいがはらやま','','','','','29','34.185,136.109','奈良・三重','','','','1,695m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(300,10001,3,'大峰山','','おおみねさん','','','','','29','34.174,135.907','奈良','','','','1,915m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(299,10001,3,'伊吹山','','いぶきやま','','','','','28','35.418,136.406','滋賀','','','','1,377m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(298,10001,3,'黒部五郎岳','','ぐろべごろうだけ','','','','','24','36.393,137.540','富山・岐阜','','','','2,840m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(297,10001,3,'五竜岳','','ごりゅうだけ','','','','','24','36.658,137.753','富山','','','','2,814m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(296,10001,3,'剣岳','','つるぎだけ','','','','','24','36.623,137.617','富山','','','','2,998m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(295,10001,3,'立山','','たてやま','','','','','24','36.576,137.619','富山','','','','3,015m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(294,10001,3,'薬師岳','','やくしだけ','','','','','24','36.469,137.545','富山','','','','2,926m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(292,10001,3,'白山','','はくさん','','','','','23','36.155,136.771','石川・岐阜','','','','2,702m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(293,10001,3,'水晶岳','(黒岳)','すいしょうだけ','(くろだけ)','','','','24','36.426,137.603','富山','','','','2,986m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(291,10001,3,'荒島岳','','あらしまだけ','','','','','22','35.934,136.601','福井','','','','1,523m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(290,10001,3,'雨飾山','','あまかざりやま','','','','','21','36.902,137.963','新潟・長野','','','','1,963m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(288,10001,3,'高妻山','','たかつまやま','','','','','21','36.800,138.052','新潟・長野','','','','2,353m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(289,10001,3,'苗場山','','なえばさん','','','','','21','36.846,138.690','新潟・長野','','','','2,145m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(287,10001,3,'平ヶ岳','','ひらがたけ','','','','','21','37.003,139.172','新潟・群馬','','','','2,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(286,10001,3,'巻機山','','まきはたやま','','','','','21','36.978,138.964','新潟・群馬','','','','1,967m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(285,10001,3,'魚沼駒ヶ岳','(越後駒ヶ岳)','うおぬまこまがたけ','(えちごこまがたけ)','','','','21','37.126,139.075','新潟','','','','2,003m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(284,10001,3,'燧ヶ岳','','ひうちがたけ','','','','','21','36.955,139.285','新潟','','','','2,356m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(283,10001,3,'火打山','','ひうちやま','','','','','21','36.923,138.068','新潟','','','','2,462m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(282,10001,3,'妙高山','','みょうこうさん','','','','','21','36.893,138.113','新潟','','','','2,454m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(281,10001,3,'白馬岳','','しろうまだけ','','','','','19','36.758,137.760','長野・富山','','','','2,932m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(280,10001,3,'鹿島槍岳','','かしまやりがたけ','','','','','19','36.623,137.750','長野・富山','','','','2,889m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(279,10001,3,'鷲羽岳','','わしばだけ','','','','','19','36.403,137.605','長野・富山','','','','2,924m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(278,10001,3,'八ヶ岳','(赤岳)','やつがたけ','(あかだけ)','','','','19','35.971,138.370','長野・山梨','','','','2,899m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(277,10001,3,'仙丈岳','','せんじょうがたけ','','','','','19','35.717,138.183','長野・山梨','','','','3,033m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(276,10001,3,'穂高岳','(奥穂高岳)','ほたかだけ','','','','','19','36.288,137.644','長野・岐阜','','','','3,190m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(274,10001,3,'乗鞍岳','(剣ヶ峰)','のりくらだけ','','','','','19','36.106,137.554','長野・岐阜','','','','3,026m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(275,10001,3,'焼岳','','やけだけ','','','','','19','36.230,137.588','長野・岐阜','','','','2,455m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(273,10001,3,'恵那山','','えなさん','','','','','19','35.440,137.600','長野・岐阜','','','','2,191m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(272,10001,3,'槍ヶ岳','','やりがたけ','','','','','19','36.342,137.647','長野','','','','3,180m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(270,10001,3,'美ヶ原','(王ヶ頭)','うつくしがはら','','','','','19','36.226,138.107','長野','','','','2,034m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(271,10001,3,'常念岳','','じょうねんだけ','','','','','19','36.325,137.728','長野','','','','2,857m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(268,10001,3,'霧ヶ峰','(車山)','きりがみね','','','','','19','36.103,138.197','長野','','','','1,925m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(269,10001,3,'蓼科山','','たてしなやま','','','','','19','36.104,138.295','長野','','','','2,530m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(267,10001,3,'御岳','','おんたけさん','','','','','19','35.893,137.481','長野','','','','3,067m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(265,10001,3,'空木岳','','うつぎだけ','','','','','19','35.719,137.817','長野','','','','2,864m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(266,10001,3,'木曽駒ヶ岳','','きそこまがたけ','','','','','19','35.789,137.804','長野','','','','2,956m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(264,10001,3,'塩見岳','','しおみだけ','','','','','18','35.574,138.182','静岡・長野','','','','3,052m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(262,10001,3,'聖岳','','ひじりだけ','','','','','18','35.425,138.145','静岡・長野','','','','3,013m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(263,10001,3,'赤石岳','','あかいしだけ','','','','','18','35.461,138.157','静岡・長野','','','','3,120m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(260,10001,3,'間ノ岳','','あいのだけ','','','','','18','35.646,138.228','静岡・山梨','','','','3,189m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(261,10001,3,'光岳','','てかりだけ','','','','','18','35.338,138.084','静岡・長野','','','','2,591m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(258,10001,3,'悪沢岳','','わるさわだけ','','','','','18','35.501,138.182','静岡','','','','3,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(259,10001,3,'富士山','','ふじさん','','','','','18','35.361,138.729','静岡・山梨','','','','3,776m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(257,10001,3,'天城山','','あまぎさん','','','','','18','34.858,139.002','静岡','','','','1,406m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(255,10001,3,'金峰山','','きんぷさん','','','','','15','35.871,138.625','山梨・長野','','','','2,599m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(256,10001,3,'笠ヶ岳','','かさがたけ','','','','','17','36.315,137.550','岐阜','','','','2,897m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(254,10001,3,'甲斐駒ヶ岳','','かいこまがたけ','','','','','15','35.758,138.237','山梨・長野','','','','2,967m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(253,10001,3,'瑞牆山','','みずがきやま','','','','','15','35.894,138.592','山梨','','','','2,230m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(252,10001,3,'大菩薩岳','(大菩薩嶺)','だいぼさつだけ','(だいぼさつれい)','','','','15','35.749,138.845','山梨','','','','2,057m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(251,10001,3,'鳳凰山','(観音岳)','ほうおうざん','','','','','15','35.702,138.304','山梨','','','','2,840m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(249,10001,3,'四阿山','','あずまやさん','','','','','14','36.543,138.414','群馬・長野','','','','2,354m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(250,10001,3,'北岳','','きただけ','','','','','15','35.674,138.239','山梨','','','','3,192m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(248,10001,3,'浅間山','','あさまやま','','','','','14','36.406,138.523','群馬・長野','','','','2,568m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(247,10001,3,'谷川岳','','たにがわだけ','','','','','14','36.837,138.930','群馬・新潟','','','','1,977m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(246,10001,3,'至仏山','','しぶつさん','','','','','14','36.903,139.173','群馬','','','','2,228m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(245,10001,3,'武尊山','','ほたかやま','','','','','14','36.805,139.133','群馬','','','','2,158m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(243,10001,3,'赤城山','','あかぎさん','','','','','14','36.558,139.192','群馬','','','','1,828m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(244,10001,3,'草津白根山','','くさつしらねさん','','','','','14','36.618,138.528','群馬','','','','2,578m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(241,10001,3,'皇海山','','すかいさん','','','','','13','36.690,139.337','栃木・群馬','','','','2,144m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(242,10001,3,'日光白根山','(奥白根山)','にっこうしらねさん','(おくしらねさん)','','','','13','36.799,139.376','栃木・群馬','','','','2,578m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(240,10001,3,'男体山','','なんたいさん','','','','','13','36.765,139.491','栃木','','','','2,484m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(239,10001,3,'筑波山','','つくばさん','','','','','12','36.226,140.098','茨城','','','','0,877m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(238,10001,3,'甲武信岳','','こぶしだけ','','','','','10','35.909,138.729','埼玉・山梨・長野','','','','2,475m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(237,10001,3,'両神山','','りょうかみさん','','','','','10','36.023,138.841','埼玉','','','','1,723m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(236,10001,3,'丹沢山','','たんざわさん','','','','','09','35.486,139.139','神奈川','','','','1,673m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(234,10001,3,'那須岳','','なすだけ','','','','','07','37.125,139.964','福島・栃木','','','','1,917m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(235,10001,3,'雲取山','','くもとりやま','','','','','08','35.855,138.938','東京・埼玉','','','','2,017m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(233,10001,3,'飯豊山','','いいでさん','','','','','07','37.855,139.707','福島','','','','2,128m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(232,10001,3,'安達太良山','(乳首山)','あだたらやま','','','','','07','37.621,140.288','福島','','','','1,709m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(231,10001,3,'磐梯山','','ばんだいさん','','','','','07','37.601,140.072','福島','','','','1,819m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(230,10001,3,'会津駒ヶ岳','','あいづこまがたけ','','','','','07','37.048,139.354','福島','','','','2,133m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(229,10001,3,'吾妻山','','あづまやま','','','','','05','37.738,140.141','山形・福島','','','','2,035m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(228,10001,3,'蔵王山','','ざおうさん','','','','','05','38.144,140.439','山形・宮城','','','','1,841m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(227,10001,3,'鳥海山','','ちょうかいさん','','','','','05','39.099,140.051','山形','','','','2,236m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(226,10001,3,'月山','','がっさん','','','','','05','38.549,140.027','山形','','','','1,984m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(225,10001,3,'朝日岳','(朝日山)','あさひだけ','','','','','05','38.260,139.922','山形','','','','1,870m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(224,10001,3,'八幡平','','はちまんたい','','','','','03','39.958,140.854','岩手・秋田','','','','1,613m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(223,10001,3,'岩手山','','いわてさん','','','','','03','39.853,141.001','岩手','','','','2,038m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(222,10001,3,'早池峰山','','はやちねさん','','','','','03','39.558,141.489','岩手','','','','1,917m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(221,10001,3,'八甲田山','','はっこうださん','','','','','02','40.659,140.877','青森','','','','1,584m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(220,10001,3,'岩木山','(津軽富士)','いわきさん','','','','','02','40.656,140.303','青森','','','','1,625m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(219,10001,3,'利尻岳','','りしりだけ','','','','','01','45.180,141.241','北海道','','','','1,721m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(218,10001,3,'羅臼岳','','らうすだけ','','','','','01','44.076,145.122','北海道','','','','1,660m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(217,10001,3,'斜里岳','','しゃりだけ','','','','','01','43.766,144.718','北海道','','','','1,545m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(216,10001,3,'大雪山','','だいせつざん','','','','','01','43.663,142.854','北海道','','','','2,290m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(215,10001,3,'トムラウシ','','とむらうしやま','','','','','01','43.527,142.840','北海道','','','','2,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(214,10001,3,'十勝岳','','とかちだけ','','','','','01','43.418,142.686','北海道','','','','2,077m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(213,10001,3,'阿寒岳','','あかんだけ','','','','','01','43.386,144.009','北海道','','','','1,499m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(212,10001,3,'後方羊蹄山','(マッカリヌプリ)','ようていざん','','','','','01','42.828,140.811','北海道','','','','1,898m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(211,10001,3,'幌尻岳','','ぽろしりだけ','','','','','01','42.719,142.683','北海道','','','','2,052m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(307,10001,3,'祖母山','','そぼさん','','','','','44','32.828,131.347','大分・宮崎','','','','1,756m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(308,10001,3,'霧島山','(韓国岳)','きりしまやま','','','','','45','31.934,130.861','宮崎・鹿児島','','','','1,700m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(309,10001,3,'宮之浦岳','(屋久島)','みやのうらだけ','','','','','46','30.336,130.504','鹿児島','','','','1,936m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(310,10001,3,'開聞岳','(薩摩富士)','かいもんだけ','','','','','46','31.180,130.528','鹿児島','','','','0,924m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0);
/*!40000 ALTER TABLE `m_abook` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_category`
--

DROP TABLE IF EXISTS `m_category`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_category` (
  `id_account` int(10) unsigned NOT NULL,
  `id_category` int(10) unsigned NOT NULL auto_increment,
  `c_categoryName` varchar(50) NOT NULL,
  `c_categoryDisplayOrder` int(10) unsigned NOT NULL,
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  `c_delete` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`id_category`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_category`
--

LOCK TABLES `m_category` WRITE;
/*!40000 ALTER TABLE `m_category` DISABLE KEYS */;
INSERT INTO `m_category` VALUES (10001,1,'友人',0,'2009-09-17 20:16:52','2009-09-17 20:16:52',0),(10001,2,'会社',0,'2009-09-17 20:16:52','2009-09-17 20:16:52',0),(10001,3,'百名山',0,'2009-10-27 21:39:21','2009-10-27 21:39:21',0);
/*!40000 ALTER TABLE `m_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_check_caption`
--

DROP TABLE IF EXISTS `m_check_caption`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_check_caption` (
  `id_account` int(10) unsigned NOT NULL,
  `c_caption1` varchar(50) NOT NULL,
  `c_caption2` varchar(50) NOT NULL,
  `c_caption3` varchar(50) NOT NULL,
  `c_caption4` varchar(50) NOT NULL,
  `c_caption5` varchar(50) NOT NULL,
  PRIMARY KEY  USING BTREE (`id_account`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_check_caption`
--

LOCK TABLES `m_check_caption` WRITE;
/*!40000 ALTER TABLE `m_check_caption` DISABLE KEYS */;
INSERT INTO `m_check_caption` VALUES (10001,'09年賀受','09年賀出','','','');
/*!40000 ALTER TABLE `m_check_caption` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_kenmei`
--

DROP TABLE IF EXISTS `m_kenmei`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_kenmei` (
  `c_kenid` varchar(10) NOT NULL,
  `c_kenmei` varchar(20) NOT NULL,
  `c_area` varchar(20) NOT NULL,
  PRIMARY KEY  USING BTREE (`c_kenid`),
  KEY `c_kenmei` (`c_kenmei`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_kenmei`
--

LOCK TABLES `m_kenmei` WRITE;
/*!40000 ALTER TABLE `m_kenmei` DISABLE KEYS */;
INSERT INTO `m_kenmei` VALUES ('01','北海道','北海道'),('02','青森県','東北地方'),('03','岩手県','東北地方'),('04','秋田県','東北地方'),('05','山形県','東北地方'),('06','宮城県','東北地方'),('07','福島県','東北地方'),('08','東京都','関東地方'),('09','神奈川県','関東地方'),('10','埼玉県','関東地方'),('11','千葉県','関東地方'),('12','茨城県','関東地方'),('13','栃木県','関東地方'),('14','群馬県','関東地方'),('15','山梨県','関東地方'),('16','愛知県','中部地方'),('17','岐阜県','中部地方'),('18','静岡県','中部地方'),('19','長野県','中部地方'),('20','三重県','中部地方'),('21','新潟県','北陸地方'),('22','福井県','北陸地方'),('23','石川県','北陸地方'),('24','富山県','北陸地方'),('25','大阪府','近畿地方'),('26','京都府','近畿地方'),('27','兵庫県','近畿地方'),('28','滋賀県','近畿地方'),('29','奈良県','近畿地方'),('30','和歌山県','近畿地方'),('31','広島県','中国地方'),('32','岡山県','中国地方'),('33','山口県','中国地方'),('34','鳥取県','中国地方'),('35','島根県','中国地方'),('36','徳島県','四国地方'),('37','香川県','四国地方'),('38','愛媛県','四国地方'),('39','高知県','四国地方'),('40','福岡県','九州地方'),('41','佐賀県','九州地方'),('42','長崎県','九州地方'),('43','熊本県','九州地方'),('44','大分県','九州地方'),('45','宮崎県','九州地方'),('46','鹿児島県','九州地方'),('47','沖縄県','九州地方');
/*!40000 ALTER TABLE `m_kenmei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `r_kenmei`
--

DROP TABLE IF EXISTS `r_kenmei`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `r_kenmei` (
  `c_kenid` varchar(10) NOT NULL,
  `c_kenmei` varchar(20) NOT NULL,
  `c_area` varchar(20) NOT NULL,
  PRIMARY KEY  USING BTREE (`c_kenid`),
  KEY `c_kenmei` (`c_kenmei`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `r_kenmei`
--

LOCK TABLES `r_kenmei` WRITE;
/*!40000 ALTER TABLE `r_kenmei` DISABLE KEYS */;
INSERT INTO `r_kenmei` VALUES ('01','北海道','北海道'),('02','青森県','東北地方'),('03','岩手県','東北地方'),('04','秋田県','東北地方'),('05','山形県','東北地方'),('06','宮城県','東北地方'),('07','福島県','東北地方'),('08','東京都','関東地方'),('09','神奈川県','関東地方'),('10','埼玉県','関東地方'),('11','千葉県','関東地方'),('12','茨城県','関東地方'),('13','栃木県','関東地方'),('14','群馬県','関東地方'),('15','山梨県','関東地方'),('16','愛知県','中部地方'),('17','岐阜県','中部地方'),('18','静岡県','中部地方'),('19','長野県','中部地方'),('20','三重県','中部地方'),('21','新潟県','北陸地方'),('22','福井県','北陸地方'),('23','石川県','北陸地方'),('24','富山県','北陸地方'),('25','大阪府','近畿地方'),('26','京都府','近畿地方'),('27','兵庫県','近畿地方'),('28','滋賀県','近畿地方'),('29','奈良県','近畿地方'),('30','和歌山県','近畿地方'),('31','広島県','中国地方'),('32','岡山県','中国地方'),('33','山口県','中国地方'),('34','鳥取県','中国地方'),('35','島根県','中国地方'),('36','徳島県','四国地方'),('37','香川県','四国地方'),('38','愛媛県','四国地方'),('39','高知県','四国地方'),('40','福岡県','九州地方'),('41','佐賀県','九州地方'),('42','長崎県','九州地方'),('43','熊本県','九州地方'),('44','大分県','九州地方'),('45','宮崎県','九州地方'),('46','鹿児島県','九州地方'),('47','沖縄県','九州地方');
/*!40000 ALTER TABLE `r_kenmei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `r_zip100`
--

DROP TABLE IF EXISTS `r_zip100`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `r_zip100` (
  `c_zip100` varchar(10) NOT NULL,
  `c_kenmei` varchar(20) NOT NULL,
  PRIMARY KEY  USING BTREE (`c_zip100`),
  KEY `c_kenmei` (`c_kenmei`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `r_zip100`
--

LOCK TABLES `r_zip100` WRITE;
/*!40000 ALTER TABLE `r_zip100` DISABLE KEYS */;
INSERT INTO `r_zip100` VALUES ('00','北海道'),('01','秋田県'),('02','岩手県'),('03','青森県'),('04','北海道'),('05','北海道'),('06','北海道'),('07','北海道'),('08','北海道'),('09','北海道'),('10','東京都'),('11','東京都'),('12','東京都'),('13','東京都'),('14','東京都'),('15','東京都'),('16','東京都'),('17','東京都'),('18','東京都'),('19','東京都'),('20','東京都'),('21','神奈川県'),('22','神奈川県'),('23','神奈川県'),('24','神奈川県'),('25','神奈川県'),('26','千葉県'),('27','千葉県'),('28','千葉県'),('29','千葉県'),('30','茨城県'),('31','茨城県'),('32','栃木県'),('33','埼玉県'),('34','埼玉県'),('35','埼玉県'),('36','埼玉県'),('37','群馬県'),('38','長野県'),('39','長野県'),('40','山梨県'),('41','静岡県'),('42','静岡県'),('43','静岡県'),('44','愛知県'),('45','愛知県'),('46','愛知県'),('47','愛知県'),('48','愛知県'),('49','愛知県'),('50','岐阜県'),('51','三重県'),('52','滋賀県'),('53','大阪府'),('54','大阪府'),('55','大阪府'),('56','大阪府'),('57','大阪府'),('58','大阪府'),('59','大阪府'),('60','京都府'),('61','京都府'),('62','京都府'),('63','奈良県'),('64','和歌山県'),('65','兵庫県'),('66','兵庫県'),('67','兵庫県'),('68','鳥取県'),('69','島根県'),('70','岡山県'),('71','岡山県'),('72','広島県'),('73','広島県'),('74','山口県'),('75','山口県'),('76','香川県'),('77','徳島県'),('78','高知県'),('79','愛媛県'),('80','福岡県'),('81','福岡県'),('82','福岡県'),('83','福岡県'),('84','佐賀県'),('85','長崎県'),('86','熊本県'),('87','大分県'),('88','宮崎県'),('89','鹿児島県'),('90','沖縄県'),('91','福井県'),('92','石川県'),('93','富山県'),('94','新潟県'),('95','新潟県'),('96','福島県'),('97','福島県'),('98','宮城県'),('99','山形県');
/*!40000 ALTER TABLE `r_zip100` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v_abook`
--

DROP TABLE IF EXISTS `v_abook`;
/*!50001 DROP VIEW IF EXISTS `v_abook`*/;
/*!50001 CREATE TABLE `v_abook` (
  `id_abook` int(10) unsigned,
  `id_account` int(10) unsigned,
  `id_category` int(10) unsigned,
  `c_name1` varchar(100),
  `c_name2` varchar(100),
  `c_yomi1` varchar(100),
  `c_yomi2` varchar(100),
  `c_renmei` varchar(100),
  `c_zip1` varchar(10),
  `c_zip2` varchar(10),
  `c_kenid` varchar(10),
  `c_address1` varchar(255),
  `c_address2` varchar(255),
  `c_phone1` varchar(100),
  `c_phone2` varchar(100),
  `c_email` varchar(255),
  `c_memo` varchar(255),
  `c_check1` int(10) unsigned,
  `c_check2` int(10) unsigned,
  `c_check3` int(10) unsigned,
  `c_check4` int(10) unsigned,
  `c_check5` int(10) unsigned,
  `c_registtime` datetime,
  `c_updatetime` datetime,
  `c_privacy` int(10) unsigned,
  `c_delete` int(10) unsigned,
  `c_categoryName` varchar(50),
  `c_categoryDisplayOrder` int(10) unsigned,
  `c_kenmei` varchar(20)
) */;

--
-- Temporary table structure for view `v_abook_chk_ken`
--

DROP TABLE IF EXISTS `v_abook_chk_ken`;
/*!50001 DROP VIEW IF EXISTS `v_abook_chk_ken`*/;
/*!50001 CREATE TABLE `v_abook_chk_ken` (
  `id_account` int(10) unsigned,
  `id_abook` int(10) unsigned,
  `c_zip1` varchar(10),
  `c_kenid` varchar(10),
  `c_address1` varchar(255),
  `c_zip_zip100` varchar(10),
  `c_zip_kenid` varchar(10),
  `c_zip_kenmei` varchar(20)
) */;

--
-- Temporary table structure for view `v_zip100`
--

DROP TABLE IF EXISTS `v_zip100`;
/*!50001 DROP VIEW IF EXISTS `v_zip100`*/;
/*!50001 CREATE TABLE `v_zip100` (
  `c_zip100` varchar(10),
  `c_kenmei` varchar(20),
  `c_kenid` varchar(10)
) */;

--
-- Final view structure for view `v_abook`
--

/*!50001 DROP TABLE `v_abook`*/;
/*!50001 DROP VIEW IF EXISTS `v_abook`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_abook` AS select `m_abook`.`id_abook` AS `id_abook`,`m_abook`.`id_account` AS `id_account`,`m_abook`.`id_category` AS `id_category`,`m_abook`.`c_name1` AS `c_name1`,`m_abook`.`c_name2` AS `c_name2`,`m_abook`.`c_yomi1` AS `c_yomi1`,`m_abook`.`c_yomi2` AS `c_yomi2`,`m_abook`.`c_renmei` AS `c_renmei`,`m_abook`.`c_zip1` AS `c_zip1`,`m_abook`.`c_zip2` AS `c_zip2`,`m_abook`.`c_kenid` AS `c_kenid`,`m_abook`.`c_address1` AS `c_address1`,`m_abook`.`c_address2` AS `c_address2`,`m_abook`.`c_phone1` AS `c_phone1`,`m_abook`.`c_phone2` AS `c_phone2`,`m_abook`.`c_email` AS `c_email`,`m_abook`.`c_memo` AS `c_memo`,`m_abook`.`c_check1` AS `c_check1`,`m_abook`.`c_check2` AS `c_check2`,`m_abook`.`c_check3` AS `c_check3`,`m_abook`.`c_check4` AS `c_check4`,`m_abook`.`c_check5` AS `c_check5`,`m_abook`.`c_registtime` AS `c_registtime`,`m_abook`.`c_updatetime` AS `c_updatetime`,`m_abook`.`c_privacy` AS `c_privacy`,`m_abook`.`c_delete` AS `c_delete`,`m_category`.`c_categoryName` AS `c_categoryName`,`m_category`.`c_categoryDisplayOrder` AS `c_categoryDisplayOrder`,`r_kenmei`.`c_kenmei` AS `c_kenmei` from ((`m_abook` left join `m_category` on((`m_abook`.`id_category` = `m_category`.`id_category`))) left join `r_kenmei` on((`m_abook`.`c_kenid` = `r_kenmei`.`c_kenid`))) where (`m_abook`.`c_delete` = 0) */;

--
-- Final view structure for view `v_abook_chk_ken`
--

/*!50001 DROP TABLE `v_abook_chk_ken`*/;
/*!50001 DROP VIEW IF EXISTS `v_abook_chk_ken`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_abook_chk_ken` AS select `m_abook`.`id_account` AS `id_account`,`m_abook`.`id_abook` AS `id_abook`,`m_abook`.`c_zip1` AS `c_zip1`,`m_abook`.`c_kenid` AS `c_kenid`,`m_abook`.`c_address1` AS `c_address1`,`v_zip100`.`c_zip100` AS `c_zip_zip100`,`v_zip100`.`c_kenid` AS `c_zip_kenid`,`v_zip100`.`c_kenmei` AS `c_zip_kenmei` from (`m_abook` join `v_zip100` on((substr(`m_abook`.`c_zip1`,1,2) = convert(`v_zip100`.`c_zip100` using utf8)))) where ((`m_abook`.`c_kenid` = _utf8'') and (`m_abook`.`c_zip1` <> _utf8'')) */;

--
-- Final view structure for view `v_zip100`
--

/*!50001 DROP TABLE `v_zip100`*/;
/*!50001 DROP VIEW IF EXISTS `v_zip100`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_zip100` AS select `r_zip100`.`c_zip100` AS `c_zip100`,`r_zip100`.`c_kenmei` AS `c_kenmei`,`r_kenmei`.`c_kenid` AS `c_kenid` from (`r_zip100` left join `r_kenmei` on((`r_zip100`.`c_kenmei` = `r_kenmei`.`c_kenmei`))) */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-10-30 22:04:21
