-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Apr 29, 2019 at 06:36 PM
-- Server version: 10.0.38-MariaDB
-- PHP Version: 7.2.7

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: `mapa7924_data`
--

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

--
-- Table structure for table `trans`
--

CREATE TABLE `trans` (
  `noma` int(11) UNSIGNED NOT NULL,
  `tgl_pesan` date DEFAULT NULL,
  `tin1` varchar(255) DEFAULT NULL,
  `mobil` int(11) DEFAULT NULL,
  `jam1` varchar(5) DEFAULT '',
  `jam2` varchar(5) DEFAULT '',
  `tgl` datetime DEFAULT NULL,
  `tujuan` varchar(255) DEFAULT NULL,
  `sts` varchar(255) DEFAULT NULL,
  `selesai` datetime DEFAULT NULL,
  `oleh` varchar(55) NOT NULL DEFAULT '',
  `pic` varchar(55) NOT NULL DEFAULT '',
  `hppic` varchar(55) NOT NULL DEFAULT '',
  `ket` text NOT NULL,
  `tgl_respon` datetime DEFAULT NULL,
  `unit` varchar(55) NOT NULL DEFAULT '',
  `kebersihan` int(11) NOT NULL DEFAULT '0',
  `safety` int(11) NOT NULL DEFAULT '0',
  `jam_selesai` datetime DEFAULT NULL,
  `jam_selesai_driver` datetime DEFAULT NULL,
  `noorder` int(11) NOT NULL DEFAULT '100000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trans`
--

INSERT INTO `trans` (`noma`, `tgl_pesan`, `tin1`, `mobil`, `jam1`, `jam2`, `tgl`, `tujuan`, `sts`, `selesai`, `oleh`, `pic`, `hppic`, `ket`, `tgl_respon`, `unit`, `kebersihan`, `safety`, `jam_selesai`, `jam_selesai_driver`, `noorder`) VALUES
(25, '2019-04-27', 'Y', 102, '07:30', '10:00', '2019-04-26 15:44:59', 'Plaza mandiri', 'Closing', NULL, 'jaka', 'Dicky', '0811644452', '', '2019-04-26 23:09:22', 'Funding', 4, 5, '2019-04-27 00:03:26', '2019-04-27 00:03:17', 100000),
(34, '2019-04-30', 'Y', 107, '08:00', '12:00', '2019-04-29 09:11:07', 'Plaza Mandiri', 'Stand By', NULL, 'jaka', 'Teddy R', '0811644452', '', '2019-04-29 09:11:07', 'GA', 0, 0, NULL, NULL, 100008),
(29, '2019-04-29', 'N', 108, '07:30', '09:30', '2019-04-27 10:59:50', 'depok 2', 'Keep', NULL, 'apri', 'saya 2', '083636477474', '', '2019-04-29 09:19:24', 'Funding', 0, 0, NULL, '2019-04-29 09:19:24', 100003),
(33, '2019-04-28', 'N', 109, '14:00', '15:00', '2019-04-28 13:49:42', 'Garut', 'Stand By', NULL, 'jaka', 'Samsul', '083636477474', '', '2019-04-28 13:49:42', 'Funding', 0, 0, NULL, NULL, 100007),
(30, '2019-04-27', 'N', 102, '21:30', '22:00', '2019-04-27 21:55:32', 'aaaa', 'Closing', NULL, 'apri', 'aaa', '111', '111', '2019-04-29 13:39:06', 'HC', 5, 4, '2019-04-29 13:41:26', '2019-04-29 13:39:06', 100004),
(31, '2019-04-27', 'N', 107, '21:30', '22:00', '2019-04-27 21:56:27', '111', 'Closing', NULL, 'apri', '111', '11', '111', '2019-04-27 21:56:27', 'HC', 0, 0, NULL, '2019-04-27 23:54:54', 100005),
(32, '2019-04-27', 'N', 108, '21:30', '22:00', '2019-04-27 21:56:51', '111', 'Stand By', NULL, 'apri', '111', '11', '111', '2019-04-27 21:56:51', 'HC', 0, 0, NULL, NULL, 100006),
(35, '2019-04-29', 'Y', 102, '14:00', '16:00', '2019-04-29 13:36:27', 'depok 2', 'Closing', NULL, 'jaka', 'Rahmat', '081514345667', '', '2019-04-29 16:18:53', 'Funding', 5, 5, '2019-04-29 16:42:11', '2019-04-29 16:18:53', 100009),
(36, '2019-04-29', 'Y', 102, '17:00', '20:00', '2019-04-29 16:15:29', 'Plaza', 'Stand By', NULL, '', 'Iin', '08211111111', '', '2019-04-29 16:15:29', 'HC', 0, 0, NULL, NULL, 100010);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `trans`
--
ALTER TABLE `trans`
  ADD PRIMARY KEY (`noma`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `trans`
--
ALTER TABLE `trans`
  MODIFY `noma` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;
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 */;
