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

DROP TABLE IF EXISTS `m_bbs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_bbs` (
  `id_bbs` int(10) unsigned NOT NULL auto_increment,
  `id_category` int(10) unsigned NOT NULL,
  `c_subject` varchar(500) NOT NULL,
  `c_body` longtext NOT NULL,
  `id_account` int(10) unsigned NOT NULL,
  `c_attachFile1` varchar(255) NOT NULL,
  `c_attachFile2` varchar(255) NOT NULL,
  `c_attachFile3` varchar(255) NOT NULL,
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  `c_delete` int(10) unsigned NOT NULL default '0',
  `p_id_bbs` int(10) unsigned NOT NULL default '0' COMMENT 'parent id',
  `c_reply_cnt` int(10) unsigned NOT NULL default '0',
  `c_reply_lasttime` datetime NOT NULL,
  `c_read_count` int(10) unsigned NOT NULL default '0',
  `c_body_strip_tags` longtext NOT NULL,
  PRIMARY KEY  USING BTREE (`id_bbs`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_bbs`
--

LOCK TABLES `m_bbs` WRITE;
/*!40000 ALTER TABLE `m_bbs` DISABLE KEYS */;
INSERT INTO `m_bbs` VALUES (1,1,'掲示板テストです。','<P><STRONG><FONT style=\"BACKGROUND-COLOR: #ffff33\" color=#ff3333 size=4>掲示板のテストです。</FONT></STRONG></P>\r\n<P><FONT color=#3399ff size=4><STRONG>掲示板のテストです。</STRONG></FONT></P>\r\n<P>掲示板のテストです。<FONT color=#ffffff></P></FONT>',10001,'','','','2009-02-16 19:49:15','2009-02-17 19:09:22',0,0,0,'2009-02-16 19:49:15',0,'掲示板のテストです。\r\n掲示板のテストです。\r\n掲示板のテストです。'),(2,2,'この掲示板は全員共通の掲示板ですか？','',10003,'','','','2009-02-16 19:56:40','2009-02-16 19:56:40',0,0,4,'2009-02-16 20:21:07',0,''),(3,0,'Re: この掲示板は全員共通の掲示板ですか？','<P>はい。そうです。MyHome Portal全ユーザー共通の掲示板です。</P>\r\n<P><STRONG><FONT color=#6666cc size=3>WYSIWYGで<FONT color=#ff00cc size=5>HTML</FONT>タグも使えます。</FONT></STRONG></P>',10001,'','','','2009-02-16 19:57:46','2009-02-16 20:52:41',0,2,0,'0000-00-00 00:00:00',0,'はい。そうです。MyHome Portal全ユーザー共通の掲示板です。\r\nWYSIWYGでHTMLタグも使えます。'),(4,0,'Re: この掲示板は全員共通の掲示板ですか？','投稿した後、修正や削除はできますか？',10003,'','','','2009-02-16 19:59:10','2009-02-16 19:59:10',0,2,0,'0000-00-00 00:00:00',0,'投稿した後、修正や削除はできますか？'),(5,0,'Re: この掲示板は全員共通の掲示板ですか？','<P><STRONG><FONT size=3>はい、できます。</FONT></STRONG></P>\r\n<P>削除した投稿は、復活させることもできます。スレッドの最初の投稿者は、返信も含めてスレッド全体の削除もできます。</P>',10001,'','','','2009-02-16 20:01:33','2009-02-18 19:34:21',0,2,0,'0000-00-00 00:00:00',0,'はい、できます。\r\n削除した投稿は、復活させることもできます。スレッドの最初の投稿者は、返信も含めてスレッド全体の削除もできます。'),(6,1,'テストです。','',10003,'','','','2009-02-16 20:02:19','2009-02-16 20:02:54',444,0,1,'2009-02-18 19:36:25',0,''),(7,0,'Re: テストです。','返信です。',10001,'','','','2009-02-16 20:02:45','2009-02-16 20:02:45',0,6,0,'0000-00-00 00:00:00',0,'返信です。'),(8,1,'テストです。','',10003,'','','','2009-02-16 20:03:09','2009-02-16 20:03:31',888,0,1,'2009-02-16 20:03:25',0,''),(9,0,'Re: テストです。','返信。',10003,'','','','2009-02-16 20:03:25','2009-02-16 20:03:25',0,8,0,'0000-00-00 00:00:00',0,'返信。'),(10,0,'Re: この掲示板は全員共通の掲示板ですか？','<P>ファイルや写真も添付できます。</P>',10001,'00000010-000282.jpg','00000010-000652.jpg','','2009-02-16 20:21:07','2009-02-16 20:21:07',0,2,0,'0000-00-00 00:00:00',0,'ファイルや写真も添付できます。'),(11,0,'Re: テストです。','<P>&nbsp;</P>',10001,'','','','2009-02-18 19:36:25','2009-02-18 19:36:30',444,6,0,'0000-00-00 00:00:00',0,'&nbsp;'),(12,1,'FLV動画プレビューサンプル','<FONT color=#ff33ff>FLV動画プレビューのサンプルです。</FONT>',10001,'00000012-video.flv','','','2009-02-20 20:45:25','2009-02-23 19:31:05',0,0,0,'2009-02-20 20:45:25',0,'FLV動画プレビューのサンプルです。');
/*!40000 ALTER TABLE `m_bbs` 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_category` int(10) unsigned NOT NULL auto_increment,
  `c_categoryName` varchar(50) NOT NULL,
  `c_categoryDisplayOrder` int(10) unsigned NOT NULL,
  `c_delete` int(10) unsigned NOT NULL default '0',
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  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 (1,'伝達事項',10,0,'2009-02-16 19:46:17','2009-02-16 19:46:17'),(2,'質問',20,0,'2009-02-16 19:46:17','2009-02-16 19:46:17'),(3,'覚え書き',30,0,'2009-02-16 19:46:17','2009-02-16 19:46:17');
/*!40000 ALTER TABLE `m_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v_bbs`
--

DROP TABLE IF EXISTS `v_bbs`;
/*!50001 DROP VIEW IF EXISTS `v_bbs`*/;
/*!50001 CREATE TABLE `v_bbs` (
  `id_bbs` int(10) unsigned,
  `id_category` int(10) unsigned,
  `c_subject` varchar(500),
  `c_body` longtext,
  `id_account` int(10) unsigned,
  `c_attachFile1` varchar(255),
  `c_attachFile2` varchar(255),
  `c_attachFile3` varchar(255),
  `c_registtime` datetime,
  `c_updatetime` datetime,
  `c_delete` int(10) unsigned,
  `p_id_bbs` int(10) unsigned,
  `c_reply_cnt` int(10) unsigned,
  `c_reply_lasttime` datetime,
  `c_read_count` int(10) unsigned,
  `c_body_strip_tags` longtext,
  `c_categoryName` varchar(50),
  `c_categoryDisplayOrder` int(10) unsigned,
  `c_handle` varchar(100)
) */;

--
-- Final view structure for view `v_bbs`
--

/*!50001 DROP TABLE `v_bbs`*/;
/*!50001 DROP VIEW IF EXISTS `v_bbs`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `_db_bbs`.`v_bbs` AS select `_db_bbs`.`m_bbs`.`id_bbs` AS `id_bbs`,`_db_bbs`.`m_bbs`.`id_category` AS `id_category`,`_db_bbs`.`m_bbs`.`c_subject` AS `c_subject`,`_db_bbs`.`m_bbs`.`c_body` AS `c_body`,`_db_bbs`.`m_bbs`.`id_account` AS `id_account`,`_db_bbs`.`m_bbs`.`c_attachFile1` AS `c_attachFile1`,`_db_bbs`.`m_bbs`.`c_attachFile2` AS `c_attachFile2`,`_db_bbs`.`m_bbs`.`c_attachFile3` AS `c_attachFile3`,`_db_bbs`.`m_bbs`.`c_registtime` AS `c_registtime`,`_db_bbs`.`m_bbs`.`c_updatetime` AS `c_updatetime`,`_db_bbs`.`m_bbs`.`c_delete` AS `c_delete`,`_db_bbs`.`m_bbs`.`p_id_bbs` AS `p_id_bbs`,`_db_bbs`.`m_bbs`.`c_reply_cnt` AS `c_reply_cnt`,`_db_bbs`.`m_bbs`.`c_reply_lasttime` AS `c_reply_lasttime`,`_db_bbs`.`m_bbs`.`c_read_count` AS `c_read_count`,`_db_bbs`.`m_bbs`.`c_body_strip_tags` AS `c_body_strip_tags`,`_db_bbs`.`m_category`.`c_categoryName` AS `c_categoryName`,`_db_bbs`.`m_category`.`c_categoryDisplayOrder` AS `c_categoryDisplayOrder`,`_db_account`.`m_account`.`c_handle` AS `c_handle` from ((`_db_bbs`.`m_bbs` left join `_db_bbs`.`m_category` on((`_db_bbs`.`m_bbs`.`id_category` = `_db_bbs`.`m_category`.`id_category`))) left join `_db_account`.`m_account` on((`_db_bbs`.`m_bbs`.`id_account` = `_db_account`.`m_account`.`id_account`))) where (`_db_bbs`.`m_bbs`.`c_delete` <> 999) */;
/*!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-02-23 10:39:08
