[[商大占いサイト作成方法]] 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","","","社会情報学科タイプ","");