# MySQL-Front 3.2 (Build 8.3)
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!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 */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40101 SET NAMES latin1 */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
# Host: localhost Database: krooon_db
# ------------------------------------------------------
# Server version 5.0.27-community-nt
USE `krooon_db`;
/*!40101 SET NAMES utf8 */;
#
# Table structure for table mcafe_category
#
DROP TABLE IF EXISTS `mcafe_category`;
CREATE TABLE `mcafe_category` (
`cat_id` int(11) NOT NULL auto_increment,
`cat_type` tinyint(3) NOT NULL default '1',
`cat_name` varchar(255) NOT NULL,
`cat_description` text,
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
#
# Dumping data for table mcafe_category
#
INSERT INTO `mcafe_category` VALUES (1,2,'คณิตศาสตร์ทั่วไป','เซต และควาหมาย');
INSERT INTO `mcafe_category` VALUES (2,1,'เรื่องทั่วไป',NULL);
INSERT INTO `mcafe_category` VALUES (3,1,'ครู',NULL);
INSERT INTO `mcafe_category` VALUES (4,1,'นักเรียน',NULL);
INSERT INTO `mcafe_category` VALUES (5,3,'การศึกษาอื่นๆ',NULL);
INSERT INTO `mcafe_category` VALUES (6,2,'ถาม-ตอบ',NULL);
#
# Table structure for table mcafe_post
#
DROP TABLE IF EXISTS `mcafe_post`;
CREATE TABLE `mcafe_post` (
`post_id` int(10) NOT NULL auto_increment,
`topic_id` int(10) NOT NULL default '0',
`poster` varchar(50) NOT NULL default '',
`post_time` varchar(20) default NULL,
`email` varchar(75) NOT NULL default '',
`web` varchar(75) NOT NULL default '',
PRIMARY KEY (`post_id`),
KEY `post_id` (`post_id`),
KEY `topic_id` (`topic_id`),
KEY `poster_id` (`poster`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
#
# Dumping data for table mcafe_post
#
INSERT INTO `mcafe_post` VALUES (1,1,'ijook','2007-05-11 18:26','test@tester.com','');
INSERT INTO `mcafe_post` VALUES (2,1,'sadfasdt','2007-05-11 18:28','test@tester.com','');
INSERT INTO `mcafe_post` VALUES (3,1,'asdfsa','2007-05-12 15:52','test@tester.com','');
INSERT INTO `mcafe_post` VALUES (4,2,'ครู','2007-05-13 10:27','sdfa@sadc.com','');
INSERT INTO `mcafe_post` VALUES (5,3,'ำดฟหกด','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `mcafe_post` VALUES (6,4,'AAA','2007-05-13 10:55','ijook@gmail.com','');
INSERT INTO `mcafe_post` VALUES (7,5,'ฆฤฏฆฤฏโ','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `mcafe_post` VALUES (8,6,'หกดฟหกด','2007-05-13 10:56','tsadfsa@adsc.com','');
INSERT INTO `mcafe_post` VALUES (9,4,'ijook','2007-05-14 08:04','tsadfsa@adsc.com','http://sadf');
INSERT INTO `mcafe_post` VALUES (10,4,'กดฟหด','2007-05-14 10:39','test@tester.com','');
INSERT INTO `mcafe_post` VALUES (11,4,'ฟหดกฟหกด','2007-05-14 10:44','test@tester.com','');
INSERT INTO `mcafe_post` VALUES (12,4,'ฟหกด','2007-05-14 13:02','sdfsad@tdc.com','http://www.jjjjjjjjj.com');
INSERT INTO `mcafe_post` VALUES (13,4,'dsfg','2007-05-14 13:03','sdfsad@tdc.com','http://www.thai.com');
INSERT INTO `mcafe_post` VALUES (14,4,'df','2007-05-14 15:11','sdfsad@tdc.com','http://www.jjjjjjjjj.com');
INSERT INTO `mcafe_post` VALUES (15,4,'ddd','2007-05-14 15:20','ddd@adf.com','');
INSERT INTO `mcafe_post` VALUES (16,4,'sdfg','2007-05-14 15:21','sdgfsdfg@asdf.com','');
#
# Table structure for table mcafe_postext
#
DROP TABLE IF EXISTS `mcafe_postext`;
CREATE TABLE `mcafe_postext` (
`post_id` int(10) NOT NULL default '0',
`post_text` text,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table mcafe_postext
#
INSERT INTO `mcafe_postext` VALUES (0,'asfdasfdasfdasdf\r
asdfË¿¡´¿èË\r
¿Ë¡´è¿ËÊ´¡\r
¿Ë¡´¿Ë衧´¿Ë¡´');
INSERT INTO `mcafe_postext` VALUES (1,'tasfasdfasdf');
INSERT INTO `mcafe_postext` VALUES (2,'sdfasfdasdf\r
asdfas\r
dfÀ¿¡´¿ÊÇ´¡\r
¿Ë´¿Ë¡\r
´¿Ë¡´');
INSERT INTO `mcafe_postext` VALUES (3,'http://www.krooon.com');
INSERT INTO `mcafe_postext` VALUES (4,'sadfs\r
sadfsahdfas\r
หกดหฟด่วสกหด\r
หกดาฟหดฟหวดฟ:oops: :o ');
INSERT INTO `mcafe_postext` VALUES (5,'asdfasdfsadfasdf\r
sdf\r
sdf\r
adsf8) ');
INSERT INTO `mcafe_postext` VALUES (6,'ทดลองการ POST ข้อความนี้ เป็นผู้เริ่มต้น หัวข้อ');
INSERT INTO `mcafe_postext` VALUES (7,'ฟหกดฟหก\r
หฟกด\r
ฟหก\r
ดฟหกดฟหกดหกด');
INSERT INTO `mcafe_postext` VALUES (8,'หฟกดฟหก\r
ดหฟกด\r
หฟกด');
INSERT INTO `mcafe_postext` VALUES (9,'sdfasdf\r
sadfjadfkajf asdfsad\r
fasdf:lol: :x :P ');
INSERT INTO `mcafe_postext` VALUES (10,'asdfasfasd\r
asdfasฟหกดฟ\r
ฟหกดฟห\r
ฟหด\r
ฟห:cry: :cry: ');
INSERT INTO `mcafe_postext` VALUES (11,'asfdasdf\r
ฟหกดฟหากดฟหกด\r
หฟกดฟหกดฟหงกด \r
ฟหก\r
:o ');
INSERT INTO `mcafe_postext` VALUES (12,'asdfasd\r
http://www.jingjo.com\r
\r
asfd\r
:oops: ');
INSERT INTO `mcafe_postext` VALUES (13,'ddd\r
:oops: \r
:oops: \r
http://www.krooon.com\r
');
INSERT INTO `mcafe_postext` VALUES (14,'http://www.krooon.com\r
:lol: ');
INSERT INTO `mcafe_postext` VALUES (15,'asfa asf http://www.krooon.com \r
');
INSERT INTO `mcafe_postext` VALUES (16,'dkiime\'ko\r
http://www.krooon.com\r
8) ');
#
# Table structure for table mcafe_smile
#
DROP TABLE IF EXISTS `mcafe_smile`;
CREATE TABLE `mcafe_smile` (
`id` int(10) NOT NULL auto_increment,
`code` varchar(50) default NULL,
`smile_url` varchar(100) default NULL,
`emotion` varchar(75) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
#
# Dumping data for table mcafe_smile
#
INSERT INTO `mcafe_smile` VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO `mcafe_smile` VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO `mcafe_smile` VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO `mcafe_smile` VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO `mcafe_smile` VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO `mcafe_smile` VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO `mcafe_smile` VALUES (7,':(','icon_frown.gif','Sad');
INSERT INTO `mcafe_smile` VALUES (8,':-(','icon_frown.gif','Sad');
INSERT INTO `mcafe_smile` VALUES (9,':sad:','icon_frown.gif','Sad');
INSERT INTO `mcafe_smile` VALUES (10,':o','icon_eek.gif','Surprised');
INSERT INTO `mcafe_smile` VALUES (11,':-o','icon_eek.gif','Surprised');
INSERT INTO `mcafe_smile` VALUES (12,':eek:','icon_eek.gif','Suprised');
INSERT INTO `mcafe_smile` VALUES (13,':-?','icon_confused.gif','Confused');
INSERT INTO `mcafe_smile` VALUES (14,':???:','icon_confused.gif','Confused');
INSERT INTO `mcafe_smile` VALUES (15,'8)','icon_cool.gif','Cool');
INSERT INTO `mcafe_smile` VALUES (16,'8-)','icon_cool.gif','Cool');
INSERT INTO `mcafe_smile` VALUES (17,':cool:','icon_cool.gif','Cool');
INSERT INTO `mcafe_smile` VALUES (18,':lol:','icon_lol.gif','Laughing');
INSERT INTO `mcafe_smile` VALUES (19,':x','icon_mad.gif','Mad');
INSERT INTO `mcafe_smile` VALUES (20,':-x','icon_mad.gif','Mad');
INSERT INTO `mcafe_smile` VALUES (21,':mad:','icon_mad.gif','Mad');
INSERT INTO `mcafe_smile` VALUES (22,':P','icon_razz.gif','Razz');
INSERT INTO `mcafe_smile` VALUES (23,':-P','icon_razz.gif','Razz');
INSERT INTO `mcafe_smile` VALUES (24,':razz:','icon_razz.gif','Razz');
INSERT INTO `mcafe_smile` VALUES (25,':oops:','icon_redface.gif','Embaressed');
INSERT INTO `mcafe_smile` VALUES (26,':cry:','icon_cry.gif','Crying (very sad)');
INSERT INTO `mcafe_smile` VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO `mcafe_smile` VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO `mcafe_smile` VALUES (29,':wink:','icon_wink.gif','Wink');
INSERT INTO `mcafe_smile` VALUES (30,';)','icon_wink.gif','Wink');
INSERT INTO `mcafe_smile` VALUES (31,';-)','icon_wink.gif','Wink');
#
# Table structure for table mcafe_topic
#
DROP TABLE IF EXISTS `mcafe_topic`;
CREATE TABLE `mcafe_topic` (
`topic_id` int(10) NOT NULL auto_increment,
`topic_title` varchar(100) default NULL,
`topic_poster` varchar(50) NOT NULL default '',
`topic_time` varchar(20) default NULL,
`topic_views` int(10) NOT NULL default '0',
`topic_replies` int(10) NOT NULL default '0',
`topic_last_post_id` int(10) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `topic_id` (`topic_id`),
KEY `topic_last_post_id` (`topic_last_post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
#
# Dumping data for table mcafe_topic
#
INSERT INTO `mcafe_topic` VALUES (1,'test','ijook','2007-05-12 18:26',9,4,3);
INSERT INTO `mcafe_topic` VALUES (2,'test 2 ทดสอบ ภาษษทไย','ครู','2007-05-13 10:27',2,0,4);
INSERT INTO `mcafe_topic` VALUES (3,'sadfasdf','ำดฟหกด','2007-05-13 10:55',1,0,5);
INSERT INTO `mcafe_topic` VALUES (4,'ASDas','adasdfasdfasd','2007-05-13 10:55',252,8,16);
INSERT INTO `mcafe_topic` VALUES (5,'หฟกดฟหกด','ฆฤฏฆฤฏโ','2007-05-13 10:55',3,0,7);
INSERT INTO `mcafe_topic` VALUES (6,'ฟหกดหฟกด','หกดฟหกด','2007-05-13 10:56',2,0,8);
/*!40101 SET NAMES latin1 */;
/*!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 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;