# 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 mtalk_category
#
DROP TABLE IF EXISTS `mtalk_category`;
CREATE TABLE `mtalk_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 mtalk_category
#
INSERT INTO `mtalk_category` VALUES (1,2,'คณิตศาสตร์ทั่วไป','คณิตศาสตร์ทั่วไป สำหรับทุกระดับชั้น ตั้งแต่ ประถม มัธยมต้น มัธยมปลาย และระดับสูงขึ้นไป ');
INSERT INTO `mtalk_category` VALUES (2,1,'เรื่องทั่วไป','เรื่องทั่วไป แลกเปลี่ยนความคิดเห็น และเปลี่ยนเรื่องราว ร่วมแบ่งปันและรับรู้เรื่องใหม่ๆ ที่เกิดขึ้นกับเราทุกคน คิดเห็นสิ่งใด บอกเล่ากันได้');
INSERT INTO `mtalk_category` VALUES (3,1,'ครู',NULL);
INSERT INTO `mtalk_category` VALUES (4,1,'นักเรียน',NULL);
INSERT INTO `mtalk_category` VALUES (5,3,'การศึกษาอื่นๆ',NULL);
INSERT INTO `mtalk_category` VALUES (6,2,'ถาม-ตอบ',NULL);
#
# Table structure for table mtalk_catused
#
DROP TABLE IF EXISTS `mtalk_catused`;
CREATE TABLE `mtalk_catused` (
`cat_id` tinyint(3) NOT NULL default '0',
`cat_count` int(10) NOT NULL default '0',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# Dumping data for table mtalk_catused
#
INSERT INTO `mtalk_catused` VALUES (1,13);
INSERT INTO `mtalk_catused` VALUES (2,6);
INSERT INTO `mtalk_catused` VALUES (3,1);
INSERT INTO `mtalk_catused` VALUES (4,8);
#
# Table structure for table mtalk_post
#
DROP TABLE IF EXISTS `mtalk_post`;
CREATE TABLE `mtalk_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=30 DEFAULT CHARSET=utf8;
#
# Dumping data for table mtalk_post
#
INSERT INTO `mtalk_post` VALUES (1,1,'ijook','2007-05-11 18:26','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (2,1,'sadfasdt','2007-05-11 18:28','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (3,1,'asdfsa','2007-05-12 15:52','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (4,2,'ครู','2007-05-13 10:27','sdfa@sadc.com','');
INSERT INTO `mtalk_post` VALUES (5,3,'ำดฟหกด','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `mtalk_post` VALUES (6,4,'AAA','2007-05-13 10:55','ijook@gmail.com','');
INSERT INTO `mtalk_post` VALUES (7,5,'ฆฤฏฆฤฏโ','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `mtalk_post` VALUES (8,6,'หกดฟหกด','2007-05-13 10:56','tsadfsa@adsc.com','');
INSERT INTO `mtalk_post` VALUES (9,4,'ijook','2007-05-14 08:04','tsadfsa@adsc.com','http://sadf');
INSERT INTO `mtalk_post` VALUES (10,4,'กดฟหด','2007-05-14 10:39','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (11,4,'ฟหดกฟหกด','2007-05-14 10:44','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (12,4,'ฟหกด','2007-05-14 13:02','sdfsad@tdc.com','http://www.jjjjjjjjj.com');
INSERT INTO `mtalk_post` VALUES (13,4,'dsfg','2007-05-14 13:03','sdfsad@tdc.com','http://www.thai.com');
INSERT INTO `mtalk_post` VALUES (14,4,'df','2007-05-14 15:11','sdfsad@tdc.com','http://www.jjjjjjjjj.com');
INSERT INTO `mtalk_post` VALUES (15,4,'ddd','2007-05-14 15:20','ddd@adf.com','');
INSERT INTO `mtalk_post` VALUES (16,4,'sdfg','2007-05-14 15:21','sdgfsdfg@asdf.com','');
INSERT INTO `mtalk_post` VALUES (18,0,'xxxxxxxxxx','2007-05-15 10:40','xxx-admin@gmail.com','');
INSERT INTO `mtalk_post` VALUES (19,8,'หมาโหล','2007-05-15 11:58','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (20,9,'ijook','2007-05-15 12:16','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (21,8,'sdfgsdfgsf','2007-05-15 13:04','test@tester.','');
INSERT INTO `mtalk_post` VALUES (22,8,'TESTER','2007-05-15 13:05','asfas@asdc.com','');
INSERT INTO `mtalk_post` VALUES (23,10,'TESTER','2007-05-15 13:08','asfasdf@asds.com','');
INSERT INTO `mtalk_post` VALUES (24,11,'ทดลอง','2007-05-15 13:10','sasd@asc.com','http://www.google.com');
INSERT INTO `mtalk_post` VALUES (25,11,'asdfasdf','2007-05-15 13:14','ddd@adf.com','http://www.google.com');
INSERT INTO `mtalk_post` VALUES (26,12,'TEST 3','2007-05-15 17:34','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (27,13,'TEST 4','2007-05-15 17:34','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (28,14,'fasdfasd','2007-05-15 17:35','test@tester.com','');
INSERT INTO `mtalk_post` VALUES (29,14,'testets','2007-05-16 09:17','skdfsa@sdc.om','');
#
# Table structure for table mtalk_postext
#
DROP TABLE IF EXISTS `mtalk_postext`;
CREATE TABLE `mtalk_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 mtalk_postext
#
INSERT INTO `mtalk_postext` VALUES (0,'asfdasfdasfdasdf\r
asdfË¿¡´¿èË\r
¿Ë¡´è¿ËÊ´¡\r
¿Ë¡´¿Ë衧´¿Ë¡´');
INSERT INTO `mtalk_postext` VALUES (1,'tasfasdfasdf');
INSERT INTO `mtalk_postext` VALUES (2,'sdfasfdasdf\r
asdfas\r
dfÀ¿¡´¿ÊÇ´¡\r
¿Ë´¿Ë¡\r
´¿Ë¡´');
INSERT INTO `mtalk_postext` VALUES (3,'http://www.krooon.com');
INSERT INTO `mtalk_postext` VALUES (4,'sadfs\r
sadfsahdfas\r
หกดหฟด่วสกหด\r
หกดาฟหดฟหวดฟ:oops: :o ');
INSERT INTO `mtalk_postext` VALUES (5,'asdfasdfsadfasdf\r
sdf\r
sdf\r
adsf8) ');
INSERT INTO `mtalk_postext` VALUES (6,'ทดลองการ POST ข้อความนี้ เป็นผู้เริ่มต้น หัวข้อ');
INSERT INTO `mtalk_postext` VALUES (7,'ฟหกดฟหก\r
หฟกด\r
ฟหก\r
ดฟหกดฟหกดหกด');
INSERT INTO `mtalk_postext` VALUES (8,'หฟกดฟหก\r
ดหฟกด\r
หฟกด');
INSERT INTO `mtalk_postext` VALUES (9,'sdfasdf\r
sadfjadfkajf asdfsad\r
fasdf:lol: :x :P ');
INSERT INTO `mtalk_postext` VALUES (10,'asdfasfasd\r
asdfasฟหกดฟ\r
ฟหกดฟห\r
ฟหด\r
ฟห:cry: :cry: ');
INSERT INTO `mtalk_postext` VALUES (11,'asfdasdf\r
ฟหกดฟหากดฟหกด\r
หฟกดฟหกดฟหงกด \r
ฟหก\r
:o ');
INSERT INTO `mtalk_postext` VALUES (12,'asdfasd\r
http://www.jingjo.com\r
\r
asfd\r
:oops: ');
INSERT INTO `mtalk_postext` VALUES (13,'ddd\r
:oops: \r
:oops: \r
http://www.krooon.com\r
');
INSERT INTO `mtalk_postext` VALUES (14,'http://www.krooon.com\r
:lol: ');
INSERT INTO `mtalk_postext` VALUES (15,'asfa asf http://www.krooon.com \r
');
INSERT INTO `mtalk_postext` VALUES (16,'dkiime\'ko\r
http://www.krooon.com\r
8) ');
INSERT INTO `mtalk_postext` VALUES (17,'ทดสอบการกรอหัวข้อสำหรับการลงคะแนะลงความเห็นว่าเป็นอย่างไรน่าเชื่อถือมากเพัยงใหน้๔ุกใจหรอืเปล่ามีอะไรให้ทำอีกบ้าง');
INSERT INTO `mtalk_postext` VALUES (18,'xxxxxxxxxxxx\r
xxxxxxxxxxxxxxx');
INSERT INTO `mtalk_postext` VALUES (19,'sadfasdfasd\r
asdfasdfadf\r
:x :oops: ');
INSERT INTO `mtalk_postext` VALUES (20,'sadfasdfasd\r
asdfasdfadf\r
:x :oops: ');
INSERT INTO `mtalk_postext` VALUES (21,'dfgsdgsdfg\r
dsfgsdgsdfg\r
sdgfsdgsdgsd\r
sdgsdgsdgsdfg');
INSERT INTO `mtalk_postext` VALUES (22,'TESTER\r
TESTER\r
TESTER');
INSERT INTO `mtalk_postext` VALUES (23,'sdfasdfasd:P :wink: ');
INSERT INTO `mtalk_postext` VALUES (24,'กดฟหกฟหกด\r
หดฟหกดฟหดฟหกด:cry: ');
INSERT INTO `mtalk_postext` VALUES (25,'askdlfas\r
asfdasfdas;fd\r
asfdasdfasd:P ');
INSERT INTO `mtalk_postext` VALUES (26,'asdf:oops: :lol: ');
INSERT INTO `mtalk_postext` VALUES (27,'asdfsadf\r
fasfsdf\r
:P :lol: ');
INSERT INTO `mtalk_postext` VALUES (28,'asdfasd');
INSERT INTO `mtalk_postext` VALUES (29,'ทดสอบการกรอกข้อความ:oops: :oops: \r
:) ');
#
# Table structure for table mtalk_smile
#
DROP TABLE IF EXISTS `mtalk_smile`;
CREATE TABLE `mtalk_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 mtalk_smile
#
INSERT INTO `mtalk_smile` VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO `mtalk_smile` VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO `mtalk_smile` VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO `mtalk_smile` VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO `mtalk_smile` VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO `mtalk_smile` VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO `mtalk_smile` VALUES (7,':(','icon_frown.gif','Sad');
INSERT INTO `mtalk_smile` VALUES (8,':-(','icon_frown.gif','Sad');
INSERT INTO `mtalk_smile` VALUES (9,':sad:','icon_frown.gif','Sad');
INSERT INTO `mtalk_smile` VALUES (10,':o','icon_eek.gif','Surprised');
INSERT INTO `mtalk_smile` VALUES (11,':-o','icon_eek.gif','Surprised');
INSERT INTO `mtalk_smile` VALUES (12,':eek:','icon_eek.gif','Suprised');
INSERT INTO `mtalk_smile` VALUES (13,':-?','icon_confused.gif','Confused');
INSERT INTO `mtalk_smile` VALUES (14,':???:','icon_confused.gif','Confused');
INSERT INTO `mtalk_smile` VALUES (15,'8)','icon_cool.gif','Cool');
INSERT INTO `mtalk_smile` VALUES (16,'8-)','icon_cool.gif','Cool');
INSERT INTO `mtalk_smile` VALUES (17,':cool:','icon_cool.gif','Cool');
INSERT INTO `mtalk_smile` VALUES (18,':lol:','icon_lol.gif','Laughing');
INSERT INTO `mtalk_smile` VALUES (19,':x','icon_mad.gif','Mad');
INSERT INTO `mtalk_smile` VALUES (20,':-x','icon_mad.gif','Mad');
INSERT INTO `mtalk_smile` VALUES (21,':mad:','icon_mad.gif','Mad');
INSERT INTO `mtalk_smile` VALUES (22,':P','icon_razz.gif','Razz');
INSERT INTO `mtalk_smile` VALUES (23,':-P','icon_razz.gif','Razz');
INSERT INTO `mtalk_smile` VALUES (24,':razz:','icon_razz.gif','Razz');
INSERT INTO `mtalk_smile` VALUES (25,':oops:','icon_redface.gif','Embaressed');
INSERT INTO `mtalk_smile` VALUES (26,':cry:','icon_cry.gif','Crying (very sad)');
INSERT INTO `mtalk_smile` VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO `mtalk_smile` VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO `mtalk_smile` VALUES (29,':wink:','icon_wink.gif','Wink');
INSERT INTO `mtalk_smile` VALUES (30,';)','icon_wink.gif','Wink');
INSERT INTO `mtalk_smile` VALUES (31,';-)','icon_wink.gif','Wink');
#
# Table structure for table mtalk_topic
#
DROP TABLE IF EXISTS `mtalk_topic`;
CREATE TABLE `mtalk_topic` (
`topic_id` int(10) NOT NULL auto_increment,
`topic_category` varchar(64) default NULL,
`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=15 DEFAULT CHARSET=utf8;
#
# Dumping data for table mtalk_topic
#
INSERT INTO `mtalk_topic` VALUES (1,NULL,'test','ijook','2007-05-12 18:26',10,4,3);
INSERT INTO `mtalk_topic` VALUES (2,NULL,'test 2 ทดสอบ ภาษษทไย','ครู','2007-05-13 10:27',2,0,4);
INSERT INTO `mtalk_topic` VALUES (3,NULL,'sadfasdf','ำดฟหกด','2007-05-13 10:55',1,0,5);
INSERT INTO `mtalk_topic` VALUES (4,NULL,'ASDas','adasdfasdfasd','2007-05-13 10:55',252,8,16);
INSERT INTO `mtalk_topic` VALUES (5,NULL,'หฟกดฟหกด','ฆฤฏฆฤฏโ','2007-05-13 10:55',3,0,7);
INSERT INTO `mtalk_topic` VALUES (6,NULL,'ฟหกดหฟกด','หกดฟหกด','2007-05-13 10:56',2,0,8);
INSERT INTO `mtalk_topic` VALUES (7,'/2/5/','xxxxxxxxxxx','xxxxxxxxxx','2007-05-15 10:40',0,0,0);
INSERT INTO `mtalk_topic` VALUES (8,'/1/6/','ทดสอบตั้งหัวข้อ','หมาโหล','2007-05-15 11:58',11,2,22);
INSERT INTO `mtalk_topic` VALUES (9,'/2/5/1/','ทดสอบตั้งหัวข้อหกดฟห','ijook','2007-05-15 12:16',21,0,20);
INSERT INTO `mtalk_topic` VALUES (10,'/2/1/','ทอลองอีกครั้ง ','TESTER','2007-05-15 13:08',1,0,23);
INSERT INTO `mtalk_topic` VALUES (11,'/1/6/','ทอลองอีกครั้ง 1','ทดลอง','2007-05-15 13:10',21,1,25);
INSERT INTO `mtalk_topic` VALUES (12,'/5/1/6/','asfd','TEST 3','2007-05-15 17:34',2,0,26);
INSERT INTO `mtalk_topic` VALUES (13,'/2/5/6/','TEST 4','TEST 4','2007-05-15 17:34',1,0,27);
INSERT INTO `mtalk_topic` VALUES (14,'/2/3/4/','asdfasdf','fasdfasd','2007-05-15 17:35',17,1,29);
/*!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 */;