-- MySQL dump 10.11
--
-- Host: localhost    Database: _db_rss
-- ------------------------------------------------------
-- 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_account` int(10) unsigned NOT NULL,
  `id_category` int(10) unsigned NOT NULL auto_increment,
  `c_categoryName` varchar(50) NOT NULL,
  `c_categoryDisplayColumn` int(10) unsigned NOT NULL,
  `c_categoryDisplayOrder` int(10) unsigned NOT NULL,
  `c_categoryDisplayColor` varchar(50) 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=9 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,'ニュース',1,1,'Cadetblue','2009-03-05 19:10:53','2009-03-05 19:26:40',0),(10001,2,'IT・コンピュータ',1,2,'Darkcyan','2009-03-05 19:10:53','2009-03-05 19:26:40',0),(10001,3,'エンタメ・音楽',0,3,'','2009-03-05 19:36:43','2009-03-07 07:56:05',0),(10001,4,'話題',0,5,'','2009-03-05 19:57:53','2009-03-10 20:20:11',0),(10001,5,'美術・映画',0,4,'','2009-03-05 19:57:53','2009-03-07 08:02:52',0),(10001,6,'旅行',0,6,'','2009-03-05 20:27:41','2009-03-10 20:35:19',0),(10003,7,'ファッション',0,0,'','2009-03-06 19:26:22','2009-03-06 19:26:22',0),(10003,8,'映画',0,0,'','2009-03-06 19:42:20','2009-03-06 19:42:20',0);
/*!40000 ALTER TABLE `m_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_rss`
--

DROP TABLE IF EXISTS `m_rss`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_rss` (
  `id_rss` int(10) unsigned NOT NULL auto_increment,
  `id_account` int(10) unsigned NOT NULL,
  `id_category` int(10) unsigned NOT NULL,
  `c_title` varchar(255) NOT NULL,
  `c_home_url` varchar(500) NOT NULL,
  `c_rss_url` varchar(500) NOT NULL,
  `c_displayOrder` int(10) unsigned NOT NULL,
  `c_displayColor` varchar(50) NOT NULL,
  `c_registtime` datetime NOT NULL,
  `c_updatetime` datetime NOT NULL,
  `c_delete` int(10) unsigned NOT NULL,
  `c_privacy` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id_rss`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_rss`
--

LOCK TABLES `m_rss` WRITE;
/*!40000 ALTER TABLE `m_rss` DISABLE KEYS */;
INSERT INTO `m_rss` VALUES (1,10001,1,'NHK','http://www.nhk.or.jp/','http://www3.nhk.or.jp/rss/news/cat0.xml',110,'Forestgreen','2009-03-05 19:25:08','2009-07-31 19:28:46',0,0),(2,10001,1,'アメーバ News','http://news.ameba.jp/','http://news.ameba.jp/index.xml',120,'Dodgerblue','2009-03-05 19:25:08','2009-07-31 19:28:46',0,0),(3,10001,2,'ITmedia','http://www.itmedia.co.jp/news/','http://rss.rssad.jp/rss/itmnews/2.0/news_bursts.xml',0,'Crimson','2009-03-05 21:12:08','2009-03-06 19:52:27',0,0),(4,10001,2,'MOONGIFT','http://www.moongift.jp/','http://feeds.feedburner.jp/moongift',0,'Slategray','2009-03-05 21:45:34','2009-03-06 19:52:27',0,0),(5,10003,7,'Yahoo! FASHION','http://fashion.yahoo.co.jp/','http://fashion.yahoo.co.jp/rss/whatsnew.xml',0,'Orangered','2009-03-06 19:27:22','2009-03-06 19:44:42',0,0),(6,10003,8,'goo 映画','http://movie.goo.ne.jp/','http://movie.goo.ne.jp/special/index.rdf',0,'Darkgreen','2009-03-06 19:29:12','2009-03-06 19:44:42',0,0),(7,10003,7,'magaseek','http://www.magaseek.com/','http://www.rsssuite.jp/magaseek/f4769/index.rdf',0,'Deeppink','2009-03-06 19:31:49','2010-03-25 19:04:49',999,0),(8,10001,2,'CREAMU','http://blog.creamu.com/mt/','http://blog.creamu.com/mt/atom.xml',0,'Royalblue','2009-03-06 19:58:16','2009-03-06 19:58:16',0,0),(9,10001,2,'IDEA*IDEA','http://www.ideaxidea.com/','http://www.ideaxidea.com/feed',0,'Deeppink','2009-03-06 19:59:32','2009-03-06 19:59:32',0,0),(10,10001,2,'コリス','http://coliss.com/','http://feeds.feedburner.jp/coliss',0,'Seagreen','2009-03-06 20:00:27','2009-03-06 20:00:27',0,0),(11,10001,2,'二十歳街道まっしぐら','http://tokuna.blog40.fc2.com/','http://tokuna.blog40.fc2.com/?xml',0,'Darkcyan','2009-03-06 20:01:40','2009-03-06 20:01:40',0,0),(12,10001,2,'百式','http://www.100shiki.com/','http://www.100shiki.com/feed',0,'DarkSlategray','2009-03-06 20:02:37','2009-03-06 20:02:37',0,0),(13,10001,1,'Yahoo! News','http://headlines.yahoo.co.jp/hl','http://dailynews.yahoo.co.jp/fc/rss.xml',20,'Red','2009-03-06 21:16:00','2009-07-31 19:27:40',0,0),(14,10001,1,'日刊スポーツ','http://www.nikkansports.com/','http://www.pheedo.jp/f/nikkansportscom_sports',140,'Royalblue','2009-03-06 21:22:51','2009-07-31 19:28:46',0,0),(15,10001,3,'マイコミ エンタテイメント','http://journal.mycom.co.jp/entertainment/index.html','http://feeds.journal.mycom.co.jp/haishin/rss/entertainment',0,'Deepskyblue','2009-03-06 21:30:16','2009-03-07 07:58:16',0,0),(16,10001,3,'Yahoo! MUSIC','http://magazine.music.yahoo.co.jp/','http://magazine.music.yahoo.co.jp/rss/ALL/rss.xml',0,'Darkorange','2009-03-07 07:54:39','2009-03-10 20:12:33',0,0),(17,10001,3,'Yahoo! エンタメ','http://dailynews.yahoo.co.jp/fc/entertainment/','http://dailynews.yahoo.co.jp/fc/entertainment/rss.xml',0,'Lightseagreen','2009-03-07 07:58:16','2009-03-07 07:58:16',0,0),(18,10001,5,'All About アート・美術展','http://allabout.co.jp/interest/art/library/mlibrary.htm','http://allabout.co.jp/interest/art/rss/index.xml',0,'Deeppink','2009-03-07 08:04:44','2009-07-26 16:16:52',999,0),(19,10001,5,'チケットぴあ','http://t.pia.jp/','http://t.pia.jp/common/pc/news/block/index.rdf',0,'Lightseagreen','2009-03-07 08:12:25','2009-03-07 08:12:25',0,0),(20,10001,1,'朝日新聞','http://www.asahi.com/','http://rss.asahi.com/f/asahi_newsheadlines',30,'FireBrick','2009-03-10 20:09:31','2009-07-31 19:27:40',0,0),(21,10001,4,'goo ランキング','http://ranking.goo.ne.jp/','http://ranking.goo.ne.jp/rss/index.rdf',0,'Orange','2009-03-10 20:20:57','2009-03-10 20:20:57',0,0),(22,10001,4,'雑誌 magabon','http://www.magabon.jp/','http://feed.magabon.jp/f2902/index.rdf',0,'Red','2009-03-10 20:23:08','2010-03-25 19:03:48',999,0),(23,10001,4,'ブログの話題ランキング','http://wadaino.jp/','http://wadaino.jp/rss/Item.rdf',0,'Chocolate','2009-03-10 20:26:39','2009-03-10 20:26:39',0,0),(24,10001,1,'イザ！','http://www.iza.ne.jp/news/natnews/','http://www.pheedo.jp/f/iza/natnews',130,'Darkturquoise','2009-03-10 20:28:56','2009-07-31 19:28:46',0,0),(25,10001,6,'JAL','http://www.jal.co.jp/','http://rss.jal.co.jp/f6513/index.rdf',0,'Red','2009-03-10 20:39:32','2009-03-10 20:39:32',0,0),(26,10001,6,'フォートラベル','http://4travel.jp/','http://4travel.jp/rdf/travelogue_all_new.xml',0,'Royalblue','2009-03-10 20:41:12','2009-03-10 20:41:12',0,0),(27,10001,2,'@IT','http://www.atmarkit.co.jp/','http://rss.rssad.jp/rss/itmatmarkit/rss2dc.xml',0,'Blueviolet','2009-03-11 19:37:26','2009-03-11 19:37:26',0,0),(28,10001,2,'PHPSPOT開発日誌','http://phpspot.org/blog/','http://feedproxy.google.com/phpspot/ccuf',0,'Mediumseagreen','2009-03-11 19:37:26','2009-03-11 19:37:26',0,0),(29,10001,2,'CodeZine','http://codezine.jp/','http://rss.rssad.jp/rss/codezine/new/20/index.xml',0,'Orangered','2009-03-11 19:40:16','2009-03-11 19:40:16',0,0),(30,10001,4,'話題！最新トピックス','http://wadai777.livedoor.biz/','http://wadai777.livedoor.biz/index.rdf',0,'Royalblue','2009-03-11 20:06:56','2010-03-25 19:03:48',999,0),(31,10001,1,'毎日新聞','http://mainichi.jp/','http://mainichi.pheedo.jp/f/mainichijp_flash',40,'Blue','2009-03-11 20:09:09','2009-07-31 19:27:40',0,0),(32,10001,1,'産経ニュース','http://sankei.jp.msn.com/','http://sankei.jp.msn.com/rss/news/points.xml',130,'Steelblue','2009-03-11 20:11:20','2009-07-31 19:28:12',999,0),(33,10001,3,'ORICON STYLE','http://www.oricon.co.jp/news/','http://rss.rssad.jp/rss/oricon/news/total',0,'Fuchsia','2009-03-14 17:09:14','2009-03-14 17:09:52',0,0),(34,10001,1,'Google','http://news.google.com/','http://news.google.com/news?hl=ja&ned=us&ie=UTF-8&oe=UTF-8&output=rss&topic=h',10,'Darkturquoise','2009-07-31 19:27:40','2009-07-31 19:27:40',0,0);
/*!40000 ALTER TABLE `m_rss` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v_rss`
--

DROP TABLE IF EXISTS `v_rss`;
/*!50001 DROP VIEW IF EXISTS `v_rss`*/;
/*!50001 CREATE TABLE `v_rss` (
  `id_rss` int(10) unsigned,
  `id_account` int(10) unsigned,
  `id_category` int(10) unsigned,
  `c_categoryName` varchar(50),
  `c_categoryDisplayOrder` int(10) unsigned,
  `c_title` varchar(255),
  `c_home_url` varchar(500),
  `c_rss_url` varchar(500),
  `c_displayOrder` int(10) unsigned,
  `c_displayColor` varchar(50),
  `c_delete` int(10) unsigned,
  `c_privacy` int(10) unsigned
) */;

--
-- Final view structure for view `v_rss`
--

/*!50001 DROP TABLE `v_rss`*/;
/*!50001 DROP VIEW IF EXISTS `v_rss`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_rss` AS select `m_rss`.`id_rss` AS `id_rss`,`m_rss`.`id_account` AS `id_account`,`m_rss`.`id_category` AS `id_category`,`m_category`.`c_categoryName` AS `c_categoryName`,`m_category`.`c_categoryDisplayOrder` AS `c_categoryDisplayOrder`,`m_rss`.`c_title` AS `c_title`,`m_rss`.`c_home_url` AS `c_home_url`,`m_rss`.`c_rss_url` AS `c_rss_url`,`m_rss`.`c_displayOrder` AS `c_displayOrder`,`m_rss`.`c_displayColor` AS `c_displayColor`,`m_rss`.`c_delete` AS `c_delete`,`m_rss`.`c_privacy` AS `c_privacy` from (`m_rss` left join `m_category` on((`m_rss`.`id_category` = `m_category`.`id_category`))) where (`m_rss`.`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 2010-03-25 10:05:59
