-- 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=111 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),(11,10001,3,'利尻岳','','りしりだけ','','','','','01','利尻岳','北海道','','','','1,721m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(12,10001,3,'羅臼岳','','らうすだけ','','','','','01','羅臼岳','北海道','','','','1,660m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(13,10001,3,'斜里岳','','しゃりだけ','','','','','01','斜里岳','北海道','','','','1,545m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(14,10001,3,'阿寒岳','','あかんだけ','','','','','01','阿寒岳','北海道','','','','1,499m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(15,10001,3,'大雪山','','だいせつざん','','','','','01','大雪山','北海道','','','','2,290m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(16,10001,3,'トムラウシ山','','とむらうしやま','','','','','01','トムラウシ山','北海道','','','','2,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(17,10001,3,'十勝岳','','とかちだけ','','','','','01','十勝岳','北海道','','','','2,077m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(18,10001,3,'幌尻岳','','ぽろしりだけ','','','','','01','幌尻岳','北海道','','','','2,052m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(19,10001,3,'羊蹄山','','ようていざん','','','','','01','羊蹄山','北海道','','','','1,898m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(20,10001,3,'岩木山','','いわきさん','','','','','02','岩木山','青森','','','','1,625m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(21,10001,3,'八甲田山','','はっこうださん','','','','','02','八甲田山','青森','','','','1,584m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(22,10001,3,'八幡平','','はちまんたい','','','','','03','八幡平','岩手・秋田','','','','1,613m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(23,10001,3,'岩手山','','いわてさん','','','','','03','岩手山','岩手','','','','2,038m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(24,10001,3,'早池峰山','','はやちねさん','','','','','03','早池峰山','岩手','','','','1,917m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(25,10001,3,'鳥海山','','ちょうかいさん','','','','','05','鳥海山','山形','','','','2,236m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(26,10001,3,'月山','','がっさん','','','','','05','月山','山形','','','','1,984m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(27,10001,3,'朝日岳','','あさひだけ','','','','','05','朝日岳','山形','','','','1,870m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(28,10001,3,'蔵王山','','ざおうさん','','','','','05','蔵王山','山形・宮城','','','','1,841m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(29,10001,3,'飯豊山','','いいでさん','','','','','07','飯豊山','福島','','','','2,128m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(30,10001,3,'吾妻山','','あづまやま','','','','','05','吾妻山','山形・福島','','','','2,035m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(31,10001,3,'安達太良山','','あだたらやま','','','','','07','安達太良山','福島','','','','1,709m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(32,10001,3,'磐梯山','','ばんだいさん','','','','','07','磐梯山','福島','','','','1,819m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(33,10001,3,'会津駒ヶ岳','','あいづこまがたけ','','','','','07','会津駒ヶ岳','福島','','','','2,133m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(34,10001,3,'那須岳','','なすだけ','','','','','07','那須岳','福島・栃木','','','','1,917m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(35,10001,3,'燧ヶ岳','','ひうちがたけ','','','','','21','燧ヶ岳','新潟','','','','2,356m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(36,10001,3,'至仏山','','しぶつさん','','','','','14','至仏山','群馬','','','','2,228m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(37,10001,3,'武尊山','','ほたかやま','','','','','14','武尊山','群馬','','','','2,158m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(38,10001,3,'男体山','','なんたいさん','','','','','13','男体山','栃木','','','','2,484m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(39,10001,3,'日光白根山','','おくしらねさん','','','','','13','日光白根山','栃木・群馬','','','','2,578m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(40,10001,3,'皇海山','','すかいさん','','','','','13','皇海山','栃木・群馬','','','','2,144m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(41,10001,3,'赤城山','','あかぎさん','','','','','14','赤城山','群馬','','','','1,828m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(42,10001,3,'筑波山','','つくばさん','','','','','12','筑波山','茨城','','','','0,877m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(43,10001,3,'両神山','','りょうかみさん','','','','','10','両神山','埼玉','','','','1,723m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(44,10001,3,'雲取山','','くもとりやま','','','','','08','雲取山','東京・埼玉','','','','2,017m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(45,10001,3,'甲武信ヶ岳','','こぶしだけ','','','','','10','甲武信ヶ岳','埼玉・山梨・長野','','','','2,475m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(46,10001,3,'金峰山','','きんぷさん','','','','','15','金峰山','山梨・長野','','','','2,599m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(47,10001,3,'瑞牆山','','みずがきやま','','','','','15','瑞牆山','山梨','','','','2,230m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(48,10001,3,'大菩薩嶺','','だいぼさつれい','','','','','15','大菩薩嶺','山梨','','','','2,057m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(49,10001,3,'丹沢山','','たんざわさん','','','','','09','丹沢山','神奈川','','','','1,673m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(50,10001,3,'富士山','','ふじさん','','','','','18','富士山','静岡・山梨','','','','3,776m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(51,10001,3,'天城山','','あまぎさん','','','','','18','天城山','静岡','','','','1,406m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(52,10001,3,'谷川岳','','たにがわだけ','','','','','14','谷川岳','群馬・新潟','','','','1,977m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(53,10001,3,'草津白根山','','くさつしらねさん','','','','','14','草津白根山','群馬','','','','2,578m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(54,10001,3,'四阿山','','あずまやさん','','','','','14','四阿山','群馬・長野','','','','2,354m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(55,10001,3,'浅間山','','あさまやま','','','','','14','浅間山','群馬・長野','','','','2,568m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(56,10001,3,'越後駒ヶ岳','','えちごこまがたけ','','','','','21','越後駒ヶ岳','新潟','','','','2,003m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(57,10001,3,'平ヶ岳','','ひらがたけ','','','','','21','平ヶ岳','新潟・群馬','','','','2,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(58,10001,3,'巻機山','','まきはたやま','','','','','21','巻機山','新潟・群馬','','','','1,967m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(59,10001,3,'雨飾山','','あまかざりやま','','','','','21','雨飾山','新潟・長野','','','','1,963m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(60,10001,3,'苗場山','','なえばさん','','','','','21','苗場山','新潟・長野','','','','2,145m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(61,10001,3,'妙高山','','みょうこうさん','','','','','21','妙高山','新潟','','','','2,454m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(62,10001,3,'火打山','','ひうちやま','','','','','21','火打山','新潟','','','','2,462m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(63,10001,3,'高妻山','','たかつまやま','','','','','21','高妻山','新潟・長野','','','','2,353m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(64,10001,3,'白馬岳','','しろうまだけ','','','','','19','白馬岳','長野・富山','','','','2,932m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(65,10001,3,'五竜岳','','ごりゅうだけ','','','','','24','五竜岳','富山','','','','2,814m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(66,10001,3,'鹿島槍ヶ岳','','かしまやりがたけ','','','','','19','鹿島槍ヶ岳','長野・富山','','','','2,889m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(67,10001,3,'剱岳','','つるぎだけ','','','','','24','剱岳','富山','','','','2,998m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(68,10001,3,'立山','','たてやま','','','','','24','立山','富山','','','','3,015m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(69,10001,3,'薬師岳','','やくしだけ','','','','','24','薬師岳','富山','','','','2,926m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(70,10001,3,'黒部五郎岳','','ぐろべごろうだけ','','','','','24','黒部五郎岳','富山・岐阜','','','','2,840m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(71,10001,3,'水晶岳','','すいしょうだけ','','','','','24','水晶岳','富山','','','','2,986m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(72,10001,3,'鷲羽岳','','わしばだけ','','','','','19','鷲羽岳','長野・富山','','','','2,924m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(73,10001,3,'槍ヶ岳','','やりがたけ','','','','','19','槍ヶ岳','長野','','','','3,180m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(74,10001,3,'穂高岳','','ほたかだけ','','','','','19','穂高岳','長野・岐阜','','','','3,190m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(75,10001,3,'常念岳','','じょうねんだけ','','','','','19','常念岳','長野','','','','2,857m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(76,10001,3,'笠ヶ岳','','かさがたけ','','','','','17','笠ヶ岳','岐阜','','','','2,897m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(77,10001,3,'焼岳','','やけだけ','','','','','19','焼岳','長野・岐阜','','','','2,455m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(78,10001,3,'乗鞍岳','','のりくらだけ','','','','','19','乗鞍岳','長野・岐阜','','','','3,026m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(79,10001,3,'御嶽山','','おんたけさん','','','','','19','御嶽山','長野','','','','3,067m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(80,10001,3,'美ヶ原','','うつくしがはら','','','','','19','美ヶ原','長野','','','','2,034m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(81,10001,3,'霧ヶ峰','','きりがみね','','','','','19','霧ヶ峰','長野','','','','1,925m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(82,10001,3,'蓼科山','','たてしなやま','','','','','19','蓼科山','長野','','','','2,530m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(83,10001,3,'赤岳','','あかだけ','','','','','19','赤岳','長野・山梨','','','','2,899m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(84,10001,3,'木曽駒ヶ岳','','きそこまがたけ','','','','','19','木曽駒ヶ岳','長野','','','','2,956m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(85,10001,3,'空木岳','','うつぎだけ','','','','','19','空木岳','長野','','','','2,864m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(86,10001,3,'恵那山','','えなさん','','','','','19','恵那山','長野・岐阜','','','','2,191m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(87,10001,3,'甲斐駒ヶ岳','','かいこまがたけ','','','','','15','甲斐駒ヶ岳','山梨・長野','','','','2,967m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(88,10001,3,'仙丈ヶ岳','','せんじょうがたけ','','','','','19','仙丈ヶ岳','長野・山梨','','','','3,033m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(89,10001,3,'鳳凰山','','ほうおうざん','','','','','15','鳳凰山','山梨','','','','2,840m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(90,10001,3,'北岳','','きただけ','','','','','15','北岳','山梨','','','','3,192m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(91,10001,3,'間ノ岳','','あいのだけ','','','','','18','間ノ岳','静岡・山梨','','','','3,189m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(92,10001,3,'塩見岳','','しおみだけ','','','','','18','塩見岳','静岡・長野','','','','3,052m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(93,10001,3,'悪沢岳','','わるさわだけ','','','','','18','悪沢岳','静岡','','','','3,141m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(94,10001,3,'赤石岳','','あかいしだけ','','','','','18','赤石岳','静岡・長野','','','','3,120m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(95,10001,3,'聖岳','','ひじりだけ','','','','','18','聖岳','静岡・長野','','','','3,013m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(96,10001,3,'光岳','','てかりだけ','','','','','18','光岳','静岡・長野','','','','2,591m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(97,10001,3,'白山','','はくさん','','','','','23','白山','石川・岐阜','','','','2,702m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(98,10001,3,'荒島岳','','あらしまだけ','','','','','22','荒島岳','福井','','','','1,523m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(99,10001,3,'伊吹山','','いぶきやま','','','','','28','伊吹山','滋賀','','','','1,377m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(100,10001,3,'大台ヶ原山','','おおだいがはらやま','','','','','29','大台ヶ原山','奈良・三重','','','','1,695m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(101,10001,3,'大峰山','','おおみねさん','','','','','29','大峰山','奈良','','','','1,915m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(102,10001,3,'大山','','だいせん','','','','','34','大山','鳥取','','','','1,729m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(103,10001,3,'剣山','','つるぎさん','','','','','36','剣山','徳島','','','','1,955m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(104,10001,3,'石鎚山','','いしづちさん','','','','','38','石鎚山','愛媛','','','','1,982m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(105,10001,3,'九重山','','くじゅうさん','','','','','44','九重山','大分','','','','1,791m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(106,10001,3,'祖母山','','そぼさん','','','','','44','祖母山','大分・宮崎','','','','1,756m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(107,10001,3,'阿蘇山','','あそさん','','','','','43','阿蘇山','熊本','','','','1,592m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(108,10001,3,'霧島山','','きりしまやま','','','','','45','霧島山','宮崎・鹿児島','','','','1,700m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(109,10001,3,'開聞岳','','かいもんだけ','','','','','46','開聞岳','鹿児島','','','','0,924m',0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0,0),(110,10001,3,'宮之浦岳','','みやのうらだけ','','','','','46','宮之浦岳','鹿児島','','','','1,936m',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-28 11:33:38
