-- MySQL dump 10.11
--
-- Host: localhost    Database: _db_zid_mgr_a
-- ------------------------------------------------------
-- 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_category`
--

DROP TABLE IF EXISTS `m_category`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_category` (
  `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',
  `id_account` int(10) unsigned NOT NULL,
  PRIMARY KEY  USING BTREE (`id_category`)
) ENGINE=MyISAM AUTO_INCREMENT=65 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 (62,'電子メール',0,'2008-09-15 00:00:00','2008-09-15 00:00:00',0,10001),(63,'ブログ',0,'2008-09-15 00:00:00','2008-09-15 00:00:00',0,10001),(64,'ネットショップ',0,'2008-09-15 00:00:00','2009-06-17 19:11:31',0,10001);
/*!40000 ALTER TABLE `m_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_pass`
--

DROP TABLE IF EXISTS `m_pass`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_pass` (
  `id_pass` int(10) unsigned NOT NULL auto_increment,
  `id_account` int(10) unsigned NOT NULL,
  `c_subject` varchar(255) NOT NULL,
  `c_body` varchar(500) NOT NULL,
  `c_homepageUrl` varchar(500) NOT NULL,
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  `c_delete` int(10) unsigned NOT NULL default '0',
  `c_item1` varchar(45) NOT NULL,
  `c_item2` varchar(45) NOT NULL,
  `c_item3` varchar(45) NOT NULL,
  `c_item4` varchar(45) NOT NULL,
  `id_category` int(10) unsigned NOT NULL,
  `c_item5` varchar(45) NOT NULL,
  `c_item6` varchar(45) NOT NULL,
  `c_privacy` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`id_pass`)
) ENGINE=MyISAM AUTO_INCREMENT=120 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_pass`
--

LOCK TABLES `m_pass` WRITE;
/*!40000 ALTER TABLE `m_pass` DISABLE KEYS */;
INSERT INTO `m_pass` VALUES (117,10001,'Gmail','','http://mail.google.com/mail/','2008-09-15 00:00:00','2009-06-25 19:25:00',0,'ID','PW','メールアドレス','氏名',62,'','',0),(118,10001,'FC2 BLOG','http://blog.fc2.com/','http://id.fc2.com/','2008-09-15 00:00:00','2008-09-15 00:00:00',0,'メールアドレス','ニックネーム','PW','ブログID',63,'','',0),(119,10001,'楽天','','http://www.rakuten.co.jp/','2008-09-15 00:00:00','2009-06-17 19:12:00',0,'ID','PW','クレジットカード','',64,'','',0);
/*!40000 ALTER TABLE `m_pass` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v_pass`
--

DROP TABLE IF EXISTS `v_pass`;
/*!50001 DROP VIEW IF EXISTS `v_pass`*/;
/*!50001 CREATE TABLE `v_pass` (
  `id_pass` int(10) unsigned,
  `id_account` int(10) unsigned,
  `c_subject` varchar(255),
  `c_body` varchar(500),
  `c_homepageUrl` varchar(500),
  `c_registtime` datetime,
  `c_updatetime` datetime,
  `c_delete` int(10) unsigned,
  `c_item1` varchar(45),
  `c_item2` varchar(45),
  `c_item3` varchar(45),
  `c_item4` varchar(45),
  `id_category` int(10) unsigned,
  `c_item5` varchar(45),
  `c_item6` varchar(45),
  `c_privacy` int(10) unsigned,
  `c_categoryName` varchar(50),
  `c_categoryDisplayOrder` int(10) unsigned,
  `c_val1` varchar(700),
  `c_val2` varchar(700),
  `c_val3` varchar(700),
  `c_val4` varchar(700),
  `c_val5` varchar(700),
  `c_val6` varchar(700)
) */;

--
-- Final view structure for view `v_pass`
--

/*!50001 DROP TABLE `v_pass`*/;
/*!50001 DROP VIEW IF EXISTS `v_pass`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `_db_zid_mgr_a`.`v_pass` AS select `_db_zid_mgr_a`.`m_pass`.`id_pass` AS `id_pass`,`_db_zid_mgr_a`.`m_pass`.`id_account` AS `id_account`,`_db_zid_mgr_a`.`m_pass`.`c_subject` AS `c_subject`,`_db_zid_mgr_a`.`m_pass`.`c_body` AS `c_body`,`_db_zid_mgr_a`.`m_pass`.`c_homepageUrl` AS `c_homepageUrl`,`_db_zid_mgr_a`.`m_pass`.`c_registtime` AS `c_registtime`,`_db_zid_mgr_a`.`m_pass`.`c_updatetime` AS `c_updatetime`,`_db_zid_mgr_a`.`m_pass`.`c_delete` AS `c_delete`,`_db_zid_mgr_a`.`m_pass`.`c_item1` AS `c_item1`,`_db_zid_mgr_a`.`m_pass`.`c_item2` AS `c_item2`,`_db_zid_mgr_a`.`m_pass`.`c_item3` AS `c_item3`,`_db_zid_mgr_a`.`m_pass`.`c_item4` AS `c_item4`,`_db_zid_mgr_a`.`m_pass`.`id_category` AS `id_category`,`_db_zid_mgr_a`.`m_pass`.`c_item5` AS `c_item5`,`_db_zid_mgr_a`.`m_pass`.`c_item6` AS `c_item6`,`_db_zid_mgr_a`.`m_pass`.`c_privacy` AS `c_privacy`,`_db_zid_mgr_a`.`m_category`.`c_categoryName` AS `c_categoryName`,`_db_zid_mgr_a`.`m_category`.`c_categoryDisplayOrder` AS `c_categoryDisplayOrder`,`_db_zid_mgr_b`.`m_pass2`.`c_val1` AS `c_val1`,`_db_zid_mgr_b`.`m_pass2`.`c_val2` AS `c_val2`,`_db_zid_mgr_b`.`m_pass2`.`c_val3` AS `c_val3`,`_db_zid_mgr_b`.`m_pass2`.`c_val4` AS `c_val4`,`_db_zid_mgr_b`.`m_pass2`.`c_val5` AS `c_val5`,`_db_zid_mgr_b`.`m_pass2`.`c_val6` AS `c_val6` from ((`_db_zid_mgr_a`.`m_pass` left join `_db_zid_mgr_a`.`m_category` on((`_db_zid_mgr_a`.`m_pass`.`id_category` = `_db_zid_mgr_a`.`m_category`.`id_category`))) left join `_db_zid_mgr_b`.`m_pass2` on((`_db_zid_mgr_a`.`m_pass`.`id_pass` = `_db_zid_mgr_b`.`m_pass2`.`id_pass`))) where (`_db_zid_mgr_a`.`m_pass`.`c_delete` = 0) */;
/*!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-08-04 12:06:01
