商大占いサイト作成方法

	DROP TABLE IF EXISTS `tree`;
	SET @saved_cs_client     = @@character_set_client;
	SET character_set_client = utf8;
	CREATE TABLE `tree` (
	  `id` int(8) unsigned NOT NULL,
	  `yes_id` int(4) unsigned default NULL,
	  `no_id` int(4) unsigned default NULL,
	  `type` varchar(1024) default NULL,
	  `question` varchar(1024) default NULL
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	SET character_set_client = @saved_cs_client;
	
	INSERT INTO `tree` VALUES("0","60","1","","質問 5 英語の勉強がしたくて商大に入った");
	INSERT INTO `tree` VALUES("1","37","2","","質問 8 あなたは商大君よりシャア大君の方が好きだ");
	INSERT INTO `tree` VALUES("2","34","3","","質問24 あなたは海外でホームステイしたことがある");
	INSERT INTO `tree` VALUES("3","19","4","","質問 18 自主休講は、月に一度以上欠かさない。");
	INSERT INTO `tree` VALUES("4","18","5","","質問 19 学食でひとりでもごはんを食べられる");
	INSERT INTO `tree` VALUES("5","13","6","","質問 4 講義のときは、たいてい前のほうに座る");
	INSERT INTO `tree` VALUES("6","12","7","","質問 3 好きなものは最後に食べる");
	INSERT INTO `tree` VALUES("7","9","8","","質問 10 早起きは苦ではない");
	INSERT INTO `tree` VALUES("8","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("9","11","10","","質問 12 地獄坂は歩いて登る。");
	INSERT INTO `tree` VALUES("10","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("11","","","企業法学科タイプ","");
	INSERT INTO `tree` VALUES("12","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("13","15","14","","質問 3 好きなものは最後に食べる");
	INSERT INTO `tree` VALUES("14","","","言語センタータイプ","");
	INSERT INTO `tree` VALUES("15","17","16","","質問 6 あなたはtwitterをしていますか?");
	INSERT INTO `tree` VALUES("16","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("17","","","企業法学科タイプ","");
	INSERT INTO `tree` VALUES("18","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("19","25","20","","質問 7 あなたはあだ名を持っていますか?");
	INSERT INTO `tree` VALUES("20","22","21","","質問2 どこでも寝られる");
	INSERT INTO `tree` VALUES("21","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("22","24","23","","質問 6 あなたはtwitterをしていますか?");
	INSERT INTO `tree` VALUES("23","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("24","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("25","33","26","","質問 25 サークル・部活を2つ以上掛け持ちしている");
	INSERT INTO `tree` VALUES("26","32","27","","質問 16 白黒ははっきりつけるものだと思う?");
	INSERT INTO `tree` VALUES("27","29","28","","質問 10 早起きは苦ではない");
	INSERT INTO `tree` VALUES("28","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("29","31","30","","質問1 授業をよくサボる");
	INSERT INTO `tree` VALUES("30","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("31","","","経済学科タイプ","");
	INSERT INTO `tree` VALUES("32","","","経済学科タイプ","");
	INSERT INTO `tree` VALUES("33","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("34","36","35","","質問 3 好きなものは最後に食べる");
	INSERT INTO `tree` VALUES("35","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("36","","","言語センタータイプ","");
	INSERT INTO `tree` VALUES("37","49","38","","質問 16 白黒ははっきりつけるものだと思う?");
	INSERT INTO `tree` VALUES("38","42","39","","質問 20 テストよりレポートの方が好きだ");
	INSERT INTO `tree` VALUES("39","41","40","","質問 15 英語より数学の方が好きだ");
	INSERT INTO `tree` VALUES("40","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("41","","","優等生タイプ","");
	INSERT INTO `tree` VALUES("42","44","43","","質問 7 あなたはあだ名を持っていますか?");
	INSERT INTO `tree` VALUES("43","","","企業法学科タイプ","");
	INSERT INTO `tree` VALUES("44","46","45","","質問 12 地獄坂は歩いて登る。");
	INSERT INTO `tree` VALUES("45","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("46","48","47","","質問 9 出席点のない授業には出席しない");
	INSERT INTO `tree` VALUES("47","","","企業法学科タイプ","");
	INSERT INTO `tree` VALUES("48","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("49","57","50","","質問1 授業をよくサボる");
	INSERT INTO `tree` VALUES("50","52","51","","質問 19 学食でひとりでもごはんを食べられる");
	INSERT INTO `tree` VALUES("51","","","商学科タイプ","");
	INSERT INTO `tree` VALUES("52","56","53","","質問 9 出席点のない授業には出席しない");
	INSERT INTO `tree` VALUES("53","55","54","","質問 13 空き講だからといって家に帰ってしまう");
	INSERT INTO `tree` VALUES("54","","","学務課タイプ","");
	INSERT INTO `tree` VALUES("55","","","優等生タイプ","");
	INSERT INTO `tree` VALUES("56","","","社会情報学科タイプ","");
	INSERT INTO `tree` VALUES("57","59","58","","質問 3 好きなものは最後に食べる");
	INSERT INTO `tree` VALUES("58","","","経済学科タイプ","");
	INSERT INTO `tree` VALUES("59","","","留年タイプ","");
	INSERT INTO `tree` VALUES("60","64","61","","質問 9 出席点のない授業には出席しない");
	INSERT INTO `tree` VALUES("61","63","62","","質問 15 英語より数学の方が好きだ");
	INSERT INTO `tree` VALUES("62","","","言語センタータイプ","");
	INSERT INTO `tree` VALUES("63","","","優等生タイプ","");
	INSERT INTO `tree` VALUES("64","","","社会情報学科タイプ","");