| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/comservices/db/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.5.1 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Dec 06, 2017 at 12:35 PM -- Server version: 10.1.16-MariaDB -- PHP Version: 5.5.38 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `helpdesk` -- CREATE DATABASE IF NOT EXISTS `helpdesk` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `helpdesk`; -- -------------------------------------------------------- -- -- Table structure for table `com_contact` -- CREATE TABLE `com_contact` ( `id` int(5) NOT NULL, `arkdetail` text CHARACTER SET utf8 NOT NULL, `ansdetail` text CHARACTER SET utf8, `membername` varchar(20) CHARACTER SET utf8 NOT NULL, `dateadd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `dateans` varchar(20) CHARACTER SET utf8 DEFAULT NULL, `email` varchar(30) CHARACTER SET utf8 DEFAULT NULL, `std_member` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `com_devices` -- CREATE TABLE `com_devices` ( `id` int(5) NOT NULL, `device_name` varchar(50) CHARACTER SET utf8 NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `com_devices` -- INSERT INTO `com_devices` (`id`, `device_name`) VALUES (1, 'Computer(PC)'), (2, 'Notebook'), (3, 'Printer'), (4, 'Projector'), (5, 'Keyboard'), (6, 'Mouse'), (7, 'Scanner'), (8, 'Other'), (9, '**'); -- -------------------------------------------------------- -- -- Table structure for table `com_devices_detail` -- CREATE TABLE `com_devices_detail` ( `id` int(5) NOT NULL, `item_id` varchar(20) CHARACTER SET utf8 NOT NULL, `device_name` varchar(100) CHARACTER SET utf8 NOT NULL, `device_status` varchar(20) CHARACTER SET utf8 NOT NULL, `count_unit` varchar(20) CHARACTER SET utf8 NOT NULL, `device_price` int(10) NOT NULL, `device_location` varchar(100) CHARACTER SET utf8 NOT NULL, `device_installation` varchar(20) CHARACTER SET utf8 NOT NULL, `where_price` varchar(50) CHARACTER SET utf8 NOT NULL, `remark` varchar(200) CHARACTER SET utf8 DEFAULT NULL, `admin_id` varchar(20) CHARACTER SET utf8 DEFAULT NULL, `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `com_devices_detail` -- INSERT INTO `com_devices_detail` (`id`, `item_id`, `device_name`, `device_status`, `count_unit`, `device_price`, `device_location`, `device_installation`, `where_price`, `remark`, `admin_id`, `date_add`) VALUES (1, '444444444444444', 'Other', 'กรุณาเลือก', 'กรุณาเลือก', 2147483647, '33333333333', '2017-12-15', '4333333333', '44444444444', NULL, '2017-12-06 10:46:02'); -- -------------------------------------------------------- -- -- Table structure for table `com_inform` -- CREATE TABLE `com_inform` ( `inform_id` int(5) NOT NULL, `inform_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `item_id` varchar(100) CHARACTER SET utf8 NOT NULL, `device_name` varchar(50) CHARACTER SET utf8 NOT NULL, `inform_location` varchar(100) CHARACTER SET utf8 NOT NULL, `job_type` text CHARACTER SET utf8 NOT NULL, `inform_detail` text CHARACTER SET utf8 NOT NULL, `inform_img` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `member_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL, `admin_id` varchar(20) CHARACTER SET utf8 NOT NULL, `inform_detailrepair` text CHARACTER SET utf8, `inform_status` varchar(20) CHARACTER SET utf8 DEFAULT NULL, `inform_remark` text CHARACTER SET utf8, `date_closeorder` varchar(20) CHARACTER SET utf8 DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `com_inform` -- INSERT INTO `com_inform` (`inform_id`, `inform_date`, `item_id`, `device_name`, `inform_location`, `job_type`, `inform_detail`, `inform_img`, `member_name`, `admin_id`, `inform_detailrepair`, `inform_status`, `inform_remark`, `date_closeorder`) VALUES (5, '2017-12-06 11:00:49', 'ssssssssssss', 'Computer(PC)', 'sssssssssssssssssssssssss', 'Software', 'ssssssssssssssssssssss', NULL, 'a', 'devbanban.com', NULL, 'waiting', NULL, NULL), (2, '2017-12-06 10:27:49', 'wrqwrqwre', 'Computer(PC)', 'rqwerqwr', 'Software', 'qwerqwe', NULL, 'a', 'พิศิษฐ์ บวรเลิศสุธี', 'ddddddddddd', 'close', 'dddddd', NULL), (3, '2017-12-06 10:28:28', 'wrqwrqwre', 'Computer(PC)', 'rqwerqwr', 'Software', 'qwerqwe', NULL, 'a', 'devbanban.com', NULL, 'waiting', NULL, NULL), (4, '2017-12-06 10:32:13', '33333333333333333333', 'Computer(PC)', '3333333333333333333333333333333333', 'Software', '33333333333333333333333', 'Chrysanthemum.jpg', 'a', 'devbanban.com', 'asdfasdfsaf', 'close', 'safsafsa', '2017-12-06'), (6, '2017-12-06 11:02:03', 'dddddddddddddddddddddd', 'Computer(PC)', 'dddddddddddddddddddddd', 'Software', 'dddddddddddddddd', NULL, 'a', 'devbanban.com', NULL, 'waiting', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `com_job_type` -- CREATE TABLE `com_job_type` ( `type_id` int(5) NOT NULL, `type_name` varchar(20) CHARACTER SET utf8 NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `com_job_type` -- INSERT INTO `com_job_type` (`type_id`, `type_name`) VALUES (1, 'Software'), (2, 'Hardware'), (3, 'Other'), (4, 'fff'); -- -------------------------------------------------------- -- -- Table structure for table `com_member` -- CREATE TABLE `com_member` ( `mid` int(11) NOT NULL, `mname` varchar(50) NOT NULL, `muser` varchar(50) NOT NULL, `mpass` varchar(20) NOT NULL, `mlevel` int(1) NOT NULL, `mlphone` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `com_member` -- INSERT INTO `com_member` (`mid`, `mname`, `muser`, `mpass`, `mlevel`, `mlphone`) VALUES (1, 'aa', 'a', 'a', 1, '0000000000'), (2, 'bb', 'b', 'b', 0, '00000000000'); -- -- Indexes for dumped tables -- -- -- Indexes for table `com_contact` -- ALTER TABLE `com_contact` ADD PRIMARY KEY (`id`); -- -- Indexes for table `com_devices` -- ALTER TABLE `com_devices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `com_devices_detail` -- ALTER TABLE `com_devices_detail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `com_inform` -- ALTER TABLE `com_inform` ADD PRIMARY KEY (`inform_id`); -- -- Indexes for table `com_job_type` -- ALTER TABLE `com_job_type` ADD PRIMARY KEY (`type_id`); -- -- Indexes for table `com_member` -- ALTER TABLE `com_member` ADD PRIMARY KEY (`mid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `com_contact` -- ALTER TABLE `com_contact` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `com_devices` -- ALTER TABLE `com_devices` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `com_devices_detail` -- ALTER TABLE `com_devices_detail` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `com_inform` -- ALTER TABLE `com_inform` MODIFY `inform_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `com_job_type` -- ALTER TABLE `com_job_type` MODIFY `type_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `com_member` -- ALTER TABLE `com_member` MODIFY `mid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; /*!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 */;