-- phpMyAdmin SQL Dump -- version 5.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 13, 2021 at 08:11 AM -- Server version: 10.4.11-MariaDB -- PHP Version: 7.4.1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `webboard` -- -- -------------------------------------------------------- -- -- Table structure for table `mtalk_category` -- CREATE TABLE `mtalk_category` ( `cat_id` int(11) NOT NULL, `cat_type` tinyint(3) NOT NULL DEFAULT 1, `cat_name` varchar(255) NOT NULL, `cat_description` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_category` -- INSERT INTO `mtalk_category` (`cat_id`, `cat_type`, `cat_name`, `cat_description`) VALUES (1, 2, 'คณิตศาสตร์ทั่วไป', 'คณิตศาสตร์ทั่วไป สำหรับทุกระดับชั้น ตั้งแต่ ประถม มัธยมต้น มัธยมปลาย และระดับสูงขึ้นไป '), (2, 1, 'เรื่องทั่วไป', 'เรื่องทั่วไป แลกเปลี่ยนความคิดเห็น และเปลี่ยนเรื่องราว ร่วมแบ่งปันและรับรู้เรื่องใหม่ๆ ที่เกิดขึ้นกับเราทุกคน คิดเห็นสิ่งใด บอกเล่ากันได้'), (3, 1, 'ครู', NULL), (4, 1, 'นักเรียน', NULL), (5, 3, 'การศึกษาอื่นๆ', NULL), (6, 2, 'ถาม-ตอบ', NULL); -- -------------------------------------------------------- -- -- Table structure for table `mtalk_catused` -- CREATE TABLE `mtalk_catused` ( `cat_id` tinyint(3) NOT NULL DEFAULT 0, `cat_count` int(10) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_catused` -- INSERT INTO `mtalk_catused` (`cat_id`, `cat_count`) VALUES (1, 14), (2, 20), (3, 1), (4, 9); -- -------------------------------------------------------- -- -- Table structure for table `mtalk_post` -- CREATE TABLE `mtalk_post` ( `post_id` int(10) NOT NULL, `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) DEFAULT '' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_post` -- INSERT INTO `mtalk_post` (`post_id`, `topic_id`, `poster`, `post_time`, `email`, `web`) VALUES (1, 1, 'ijook', '2007-05-11 18:26', 'test@tester.com', ''), (2, 1, 'sadfasdt', '2007-05-11 18:28', 'test@tester.com', ''), (3, 1, 'asdfsa', '2007-05-12 15:52', 'test@tester.com', ''), (4, 2, 'ครู', '2007-05-13 10:27', 'sdfa@sadc.com', ''), (5, 3, 'ำดฟหกด', '2007-05-13 10:55', 'tsadfsa@adsc.com', ''), (6, 4, 'AAA', '2007-05-13 10:55', 'ijook@gmail.com', ''), (7, 5, 'ฆฤฏฆฤฏโ', '2007-05-13 10:55', 'tsadfsa@adsc.com', ''), (8, 6, 'หกดฟหกด', '2007-05-13 10:56', 'tsadfsa@adsc.com', ''), (9, 4, 'ijook', '2007-05-14 08:04', 'tsadfsa@adsc.com', 'http://sadf'), (10, 4, 'กดฟหด', '2007-05-14 10:39', 'test@tester.com', ''), (11, 4, 'ฟหดกฟหกด', '2007-05-14 10:44', 'test@tester.com', ''), (12, 4, 'ฟหกด', '2007-05-14 13:02', 'sdfsad@tdc.com', 'http://www.jjjjjjjjj.com'), (13, 4, 'dsfg', '2007-05-14 13:03', 'sdfsad@tdc.com', 'http://www.thai.com'), (14, 4, 'df', '2007-05-14 15:11', 'sdfsad@tdc.com', 'http://www.jjjjjjjjj.com'), (15, 4, 'ddd', '2007-05-14 15:20', 'ddd@adf.com', ''), (16, 4, 'sdfg', '2007-05-14 15:21', 'sdgfsdfg@asdf.com', ''), (18, 0, 'xxxxxxxxxx', '2007-05-15 10:40', 'xxx-admin@gmail.com', ''), (19, 8, 'หมาโหล', '2007-05-15 11:58', 'test@tester.com', ''), (20, 9, 'ijook', '2007-05-15 12:16', 'test@tester.com', ''), (21, 8, 'sdfgsdfgsf', '2007-05-15 13:04', 'test@tester.', ''), (22, 8, 'TESTER', '2007-05-15 13:05', 'asfas@asdc.com', ''), (23, 10, 'TESTER', '2007-05-15 13:08', 'asfasdf@asds.com', ''), (24, 11, 'ทดลอง', '2007-05-15 13:10', 'sasd@asc.com', 'http://www.google.com'), (25, 11, 'asdfasdf', '2007-05-15 13:14', 'ddd@adf.com', 'http://www.google.com'), (26, 12, 'TEST 3', '2007-05-15 17:34', 'test@tester.com', ''), (27, 13, 'TEST 4', '2007-05-15 17:34', 'test@tester.com', ''), (28, 14, 'fasdfasd', '2007-05-15 17:35', 'test@tester.com', ''), (29, 14, 'testets', '2007-05-16 09:17', 'skdfsa@sdc.om', ''); -- -------------------------------------------------------- -- -- Table structure for table `mtalk_postext` -- CREATE TABLE `mtalk_postext` ( `post_id` int(10) NOT NULL DEFAULT 0, `post_text` text DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_postext` -- INSERT INTO `mtalk_postext` (`post_id`, `post_text`) VALUES (0, 'asfdasfdasfdasdf\r
asdfË¿¡´¿èË\r
¿Ë¡´è¿ËÊ´¡\r
¿Ë¡´¿Ë衧´¿Ë¡´'), (1, 'tasfasdfasdf'), (2, 'sdfasfdasdf\r
asdfas\r
dfÀ¿¡´¿ÊÇ´¡\r
¿Ë´¿Ë¡\r
´¿Ë¡´'), (3, 'http://www.krooon.com'), (4, 'sadfs\r
sadfsahdfas\r
หกดหฟด่วสกหด\r
หกดาฟหดฟหวดฟ:oops: :o '), (5, 'asdfasdfsadfasdf\r
sdf\r
sdf\r
adsf8) '), (6, 'ทดลองการ POST ข้อความนี้ เป็นผู้เริ่มต้น หัวข้อ'), (7, 'ฟหกดฟหก\r
หฟกด\r
ฟหก\r
ดฟหกดฟหกดหกด'), (8, 'หฟกดฟหก\r
ดหฟกด\r
หฟกด'), (9, 'sdfasdf\r
sadfjadfkajf asdfsad\r
fasdf:lol: :x :P '), (10, 'asdfasfasd\r
asdfasฟหกดฟ\r
ฟหกดฟห\r
ฟหด\r
ฟห:cry: :cry: '), (11, 'asfdasdf\r
ฟหกดฟหากดฟหกด\r
หฟกดฟหกดฟหงกด \r
ฟหก\r
:o '), (12, 'asdfasd\r
http://www.jingjo.com\r
\r
asfd\r
:oops: '), (13, 'ddd\r
:oops: \r
:oops: \r
http://www.krooon.com\r
'), (14, 'http://www.krooon.com\r
:lol: '), (15, 'asfa asf http://www.krooon.com \r
'), (16, 'dkiime\'ko\r
http://www.krooon.com\r
8) '), (17, 'ทดสอบการกรอหัวข้อสำหรับการลงคะแนะลงความเห็นว่าเป็นอย่างไรน่าเชื่อถือมากเพัยงใหน้๔ุกใจหรอืเปล่ามีอะไรให้ทำอีกบ้าง'), (18, 'xxxxxxxxxxxx\r
xxxxxxxxxxxxxxx'), (19, 'sadfasdfasd\r
asdfasdfadf\r
:x :oops: '), (20, 'sadfasdfasd\r
asdfasdfadf\r
:x :oops: '), (21, 'dfgsdgsdfg\r
dsfgsdgsdfg\r
sdgfsdgsdgsd\r
sdgsdgsdgsdfg'), (22, 'TESTER\r
TESTER\r
TESTER'), (23, 'sdfasdfasd:P :wink: '), (24, 'กดฟหกฟหกด\r
หดฟหกดฟหดฟหกด:cry: '), (25, 'askdlfas\r
asfdasfdas;fd\r
asfdasdfasd:P '), (26, 'asdf:oops: :lol: '), (27, 'asdfsadf\r
fasfsdf\r
:P :lol: '), (28, 'asdfasd'), (29, 'ทดสอบการกรอกข้อความ:oops: :oops: \r
:) '); -- -------------------------------------------------------- -- -- Table structure for table `mtalk_smile` -- CREATE TABLE `mtalk_smile` ( `id` int(10) NOT NULL, `code` varchar(50) DEFAULT NULL, `smile_url` varchar(100) DEFAULT NULL, `emotion` varchar(75) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_smile` -- INSERT INTO `mtalk_smile` (`id`, `code`, `smile_url`, `emotion`) VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy'), (2, ':-D', 'icon_biggrin.gif', 'Very Happy'), (3, ':grin:', 'icon_biggrin.gif', 'Very Happy'), (4, ':)', 'icon_smile.gif', 'Smile'), (5, ':-)', 'icon_smile.gif', 'Smile'), (6, ':smile:', 'icon_smile.gif', 'Smile'), (7, ':(', 'icon_frown.gif', 'Sad'), (8, ':-(', 'icon_frown.gif', 'Sad'), (9, ':sad:', 'icon_frown.gif', 'Sad'), (10, ':o', 'icon_eek.gif', 'Surprised'), (11, ':-o', 'icon_eek.gif', 'Surprised'), (12, ':eek:', 'icon_eek.gif', 'Suprised'), (13, ':-?', 'icon_confused.gif', 'Confused'), (14, ':???:', 'icon_confused.gif', 'Confused'), (15, '8)', 'icon_cool.gif', 'Cool'), (16, '8-)', 'icon_cool.gif', 'Cool'), (17, ':cool:', 'icon_cool.gif', 'Cool'), (18, ':lol:', 'icon_lol.gif', 'Laughing'), (19, ':x', 'icon_mad.gif', 'Mad'), (20, ':-x', 'icon_mad.gif', 'Mad'), (21, ':mad:', 'icon_mad.gif', 'Mad'), (22, ':P', 'icon_razz.gif', 'Razz'), (23, ':-P', 'icon_razz.gif', 'Razz'), (24, ':razz:', 'icon_razz.gif', 'Razz'), (25, ':oops:', 'icon_redface.gif', 'Embaressed'), (26, ':cry:', 'icon_cry.gif', 'Crying (very sad)'), (27, ':evil:', 'icon_evil.gif', 'Evil or Very Mad'), (28, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes'), (29, ':wink:', 'icon_wink.gif', 'Wink'), (30, ';)', 'icon_wink.gif', 'Wink'), (31, ';-)', 'icon_wink.gif', 'Wink'); -- -------------------------------------------------------- -- -- Table structure for table `mtalk_topic` -- CREATE TABLE `mtalk_topic` ( `topic_id` int(10) NOT NULL, `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 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `mtalk_topic` -- INSERT INTO `mtalk_topic` (`topic_id`, `topic_category`, `topic_title`, `topic_poster`, `topic_time`, `topic_views`, `topic_replies`, `topic_last_post_id`) VALUES (1, NULL, 'test', 'ijook', '2007-05-12 18:26', 10, 4, 3), (2, NULL, 'test 2 ทดสอบ ภาษาไทย555555', 'ครู', '2007-05-13 10:27', 3, 0, 4), (3, NULL, 'sadfasdf', 'ำดฟหกด', '2007-05-13 10:55', 1, 0, 5), (4, NULL, 'ASDas', 'adasdfasdfasd', '2007-05-13 10:55', 252, 8, 16), (5, NULL, 'หฟกดฟหกด', 'ฆฤฏฆฤฏโ', '2007-05-13 10:55', 3, 0, 7), (6, NULL, 'ฟหกดหฟกด', 'หกดฟหกด', '2007-05-13 10:56', 2, 0, 8), (8, '/1/6/', 'ทดสอบตั้งหัวข้อ', 'หมาโหล', '2007-05-15 11:58', 11, 2, 22), (9, '/2/5/1/', 'ทดสอบตั้งหัวข้อหกดฟห', 'ijook', '2007-05-15 12:16', 22, 0, 20), (10, '/2/1/', 'ทอลองอีกครั้ง ', 'TESTER', '2007-05-15 13:08', 2, 0, 23), (11, '/1/6/', 'ทอลองอีกครั้ง 1', 'ทดลอง', '2007-05-15 13:10', 26, 2, 0), (12, '/5/1/6/', 'asfd', 'TEST 3', '2007-05-15 17:34', 2, 0, 26), (13, '/2/5/6/', 'TEST 4', 'TEST 4', '2007-05-15 17:34', 8, 3, 0), (14, '/2/3/4/', 'asdfasdf', 'fasdfasd', '2007-05-15 17:35', 23, 3, 0); -- -- Indexes for dumped tables -- -- -- Indexes for table `mtalk_category` -- ALTER TABLE `mtalk_category` ADD PRIMARY KEY (`cat_id`); -- -- Indexes for table `mtalk_catused` -- ALTER TABLE `mtalk_catused` ADD PRIMARY KEY (`cat_id`); -- -- Indexes for table `mtalk_post` -- ALTER TABLE `mtalk_post` ADD PRIMARY KEY (`post_id`), ADD KEY `post_id` (`post_id`), ADD KEY `topic_id` (`topic_id`), ADD KEY `poster_id` (`poster`); -- -- Indexes for table `mtalk_postext` -- ALTER TABLE `mtalk_postext` ADD PRIMARY KEY (`post_id`); -- -- Indexes for table `mtalk_smile` -- ALTER TABLE `mtalk_smile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `mtalk_topic` -- ALTER TABLE `mtalk_topic` ADD PRIMARY KEY (`topic_id`), ADD KEY `topic_id` (`topic_id`), ADD KEY `topic_last_post_id` (`topic_last_post_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `mtalk_category` -- ALTER TABLE `mtalk_category` MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `mtalk_post` -- ALTER TABLE `mtalk_post` MODIFY `post_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `mtalk_smile` -- ALTER TABLE `mtalk_smile` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; -- -- AUTO_INCREMENT for table `mtalk_topic` -- ALTER TABLE `mtalk_topic` MODIFY `topic_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; COMMIT; /*!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 */;