-- MySQL dump 10.11
--
-- Host: localhost    Database: _db_memo
-- ------------------------------------------------------
-- 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_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=29 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 (10003,25,'料理',0,0,'2008-09-15 00:00:00','2008-09-15 00:00:00'),(10001,26,'JavaScript',0,0,'2008-09-15 00:00:00','2008-09-15 00:00:00'),(10001,27,'PHP',0,0,'2008-09-15 00:00:00','2008-09-15 00:00:00'),(10001,28,'XML',0,0,'2008-09-15 00:00:00','2008-09-15 00:00:00');
/*!40000 ALTER TABLE `m_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `m_memo`
--

DROP TABLE IF EXISTS `m_memo`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `m_memo` (
  `id_memo` int(10) unsigned NOT NULL auto_increment,
  `id_category` int(10) unsigned NOT NULL,
  `c_subject` varchar(500) NOT NULL,
  `c_memo` 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_memo` int(10) unsigned NOT NULL,
  `c_privacy` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  USING BTREE (`id_memo`)
) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `m_memo`
--

LOCK TABLES `m_memo` WRITE;
/*!40000 ALTER TABLE `m_memo` DISABLE KEYS */;
INSERT INTO `m_memo` VALUES (150,25,'肉じゃが','http://www.bob-an.com/recipe/dailyjc/basic/jaga/jagaj.html\r\n\r\n材料：（４人分）\r\n牛肉（薄切り） 200g \r\nジャガイモ 300g \r\nニンジン 100g \r\n玉ネギ １コ \r\n糸コンニャク 100g \r\nだし汁（二番だし） ３カップ \r\n＜調味料＞   \r\n・砂糖 大さじ１ \r\n・みりん 大さじ３ \r\n・酒 大さじ１ \r\n・しょうゆ 大さじ５ \r\nグリンピース（冷凍または缶詰） 30g \r\n油 適量',10003,'00000150-15300.gif','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(151,26,'閉じるボタン','<input type=\"button\" value=\"閉じる\" onClick=\"self.close()\">',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(152,26,'JavaScriptでオブジェクト名に変数を使う方法','document.frm0.名前0.selectedIndex;\r\n↓↓↓\r\nvar selname = \"名前\" + ix;\r\nvar s1 = eval( \'document.frm0.\' + selname);\r\ns1.selectedIndex;',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(153,26,'オブジェクトを消す','<input type=\"button\" value=\"消える\" onClick=\"this.style.visibility=\'hidden\'\">',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(154,27,'PHPバージョン比較','if(version_compare(phpversion(),\"5.0\") > 0){ // +1が返るならtrue\r\n	// true : version 5.0 未満\r\n}else{\r\n	// false : :version 5.0 以上\r\n}',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(155,27,'セッション変数ダンプ','var_dump($_SESSION);',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(156,27,'checkboxの複数受け取り','foreach ($_POST[\"val\"] as $val) {\r\n	print \" \". $val .\"<br>\" ;\r\n}\r\nwhile($to[$i]){\r\nif($to[$i] == \"a\"){処理A}\r\nif($to[$i] == \"b\"){処理B}\r\nif($to[$i] == \"c\"){処理C}\r\n$i++;\r\ncontinue;\r\n}\r\n\r\nin_arrayを使う方法\r\nif( in_array( \"a\" , $to ) ){ 処理A }',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(157,27,'PHPソースの暗号化','http://www.doyouphp.jp/tips/tips_mmcache_encoder.shtml\r\nhttp://www.777777.net/php/encode/PE64GZ.php\r\nhttp://codelock.agtjapan.com/\r\nhttp://codelock.agtjapan.com/faqs.html\r\nhttp://lss.eternity.ne.jp/new/class.php?829',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(158,28,'UNICODE UTF8 XMLの頭につく16進で「EF,BB,BF」の3バイトの謎','BOM (Byte Order Mark)\r\nhttp://www.atmarkit.co.jp/aig/01xml/bom.html\r\nhttp://www5d.biglobe.ne.jp/~stssk/rfc/rfc3629j.html#35',10001,'','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(159,25,'麻婆豆腐','http://www.bob-an.com/recipe/OutputMain.asp?keyNo=15321&ST=47&RT=c\r\n\r\n材料4人分\r\n木綿豆腐 300g \r\n豚ひき肉 100g \r\nにんにく(みじん切り) 大さじ1/2 \r\nしょうが(みじん切り) 大さじ1/2 \r\n白ねぎ(みじん切り) 1/2本 \r\nゴマ油 大さじ1・1/2 \r\n豆板醤 大さじ1 \r\n甜面醤 大さじ1/2 \r\n鶏がらスープ 200ml \r\n酒 大さじ1 \r\n砂糖 小さじ1 \r\nしょうゆ 大さじ1・1/2 \r\nこしょう 少々 \r\n＜水溶き片栗粉＞   \r\n・片栗粉 大さじ1/2 \r\n・水 大さじ1',10003,'00000159-15321.gif','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(160,25,'ロールキャベツ','http://www.bob-an.com/recipe/OutputMain.asp?keyNo=01944&ST=47&RT=w\r\n\r\n材料2人分\r\nキャベツ 4～6枚 \r\nフィリング   \r\n・ミンチ(合挽き) 140g分 \r\n牛ミンチ 70g \r\n豚ミンチ 70g \r\nタマネギ 1/2コ \r\n・生パン粉 大さじ2 \r\n・牛乳 大さじ2 \r\n・卵 1/2コ \r\n・塩 少々 \r\n・コショウ 少々 \r\n・ナツメッグ 少々 \r\nトマト 1コ \r\n(A)   \r\n・ブイヨン 4カップ \r\n・白ワイン 大さじ2 \r\nローリエ 1枚 \r\n塩 少々 \r\nコショウ 少々 \r\nサラダ油 適量 \r\nイタリアンパセリ 適量',10003,'00000160-01944.gif','','','2008-09-15 00:00:00','2008-09-15 00:00:00',0,0,0),(161,26,'What is the Google AJAX Language API?','With the AJAX Language API, you can translate and detect the language of blocks of text within a webpage using only Javascript. In addition, you can enable transliteration on any textfield or textarea in your web page. For example, if you were transliterating to Hindi, this API will allow users to phonetically spell out Hindi words using English and have them appear in the Hindi script.\r\nThe language API is designed to be simple and easy to use to translate and detect languages on the fly when offline translations are not available. We plan on adding more exciting capabilities to the AJAX Language API in the future, so stay tuned.\r\nSo what is the difference between Translation and Transliteration? Transliteration is the process of phonetically converting a word written in one script into another. Transliteration should not be confused with translation, which involves a change in language while preserving meaning. With transliteration, it is the sound of the words that are converted from one alphabet to the other.',10001,'','','','2009-11-10 19:13:04','2009-11-10 19:13:04',0,0,0),(162,26,'Google AJAX Language API について','AJAX Language API を使用し、JavaScript のみを使用してウェブページ内のテキスト ブロックの言語を判別し、翻訳できます。さらにウェブページのテキスト フィールドやテキスト エリアで、文字変換を使用できます。たとえばこの API を使用してヒンディー語に文字変換する場合、ユーザーがヒンディー語を発音どおりに英語でつづって入力すると、それをヒンディー語の文字体系で表示できます。\r\nLanguage API は、オフライン翻訳が利用できない状況ですばやく言語を判別し翻訳するために、シンプルで容易に使えるように設計されています。AJAX Language API には、わくわくするような機能を今後さらに多く追加する予定ですので、楽しみにしていてください。\r\n翻訳と文字変換の違い文字変換は、ある文字体系で書かれた言葉を、その発音どおりに別の文字体系に変換する処理です。文字変換を翻訳と混同しないでください。翻訳では、意味が同じで、別の言語に変換します。文字変換では、言葉の発音をベースにして、ある文字体系から別の体系に変換します。',10001,'','','','2009-11-10 19:13:20','2009-11-10 19:13:20',0,0,0);
/*!40000 ALTER TABLE `m_memo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `v_memo`
--

DROP TABLE IF EXISTS `v_memo`;
/*!50001 DROP VIEW IF EXISTS `v_memo`*/;
/*!50001 CREATE TABLE `v_memo` (
  `id_memo` int(10) unsigned,
  `id_category` int(10) unsigned,
  `c_subject` varchar(500),
  `c_memo` 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_memo` int(10) unsigned,
  `c_privacy` int(10) unsigned,
  `c_categoryName` varchar(50),
  `c_categoryDisplayOrder` int(10) unsigned
) */;

--
-- Final view structure for view `v_memo`
--

/*!50001 DROP TABLE `v_memo`*/;
/*!50001 DROP VIEW IF EXISTS `v_memo`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_memo` AS select `m_memo`.`id_memo` AS `id_memo`,`m_memo`.`id_category` AS `id_category`,`m_memo`.`c_subject` AS `c_subject`,`m_memo`.`c_memo` AS `c_memo`,`m_memo`.`id_account` AS `id_account`,`m_memo`.`c_attachFile1` AS `c_attachFile1`,`m_memo`.`c_attachFile2` AS `c_attachFile2`,`m_memo`.`c_attachFile3` AS `c_attachFile3`,`m_memo`.`c_registtime` AS `c_registtime`,`m_memo`.`c_updatetime` AS `c_updatetime`,`m_memo`.`c_delete` AS `c_delete`,`m_memo`.`p_id_memo` AS `p_id_memo`,`m_memo`.`c_privacy` AS `c_privacy`,`m_category`.`c_categoryName` AS `c_categoryName`,`m_category`.`c_categoryDisplayOrder` AS `c_categoryDisplayOrder` from (`m_memo` left join `m_category` on((`m_memo`.`id_category` = `m_category`.`id_category`))) where (`m_memo`.`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-11-10 10:27:47
