Table_Master_Promo

-- phpMyAdmin SQL Dump
-- version 4.0.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 22, 2018 at 09:12
-- Server version: 5.6.14
-- PHP Version: 5.5.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `scring`
--

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

--
-- Table structure for table `Table_Master_Promo`
--

CREATE TABLE IF NOT EXISTS `Table_Master_Promo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `description` text,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `discount_amount` int(15) DEFAULT NULL,
  `idelete` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `Table_Master_Promo`
--

INSERT INTO `Table_Master_Promo` (`id`, `name`, `description`, `start_date`, `end_date`, `discount_amount`, `idelete`) VALUES
(1, 'Tester Januari', 'Test1', '2018-02-18 21:59:49', '2018-02-28 21:59:58', 50, 0),
(2, 'Tester Feb', 'bayar 1000', '2018-02-13 11:08:00', '2018-03-07 16:50:00', 30, 1),
(3, 'Tester kk', 'tester berhasil', '2018-02-22 22:33:00', '2018-02-24 22:34:00', NULL, 0),
(4, 'Tester Maret', 'tester sdah bisa', '2018-03-09 00:00:00', '2018-03-10 23:56:00', 50, 1),
(5, 'Promo Brian Birthday', 'Promo perayaan Ultah Brian', '2018-02-22 10:14:00', '2018-03-22 10:14:00', 25, 1),
(6, 'promo meriah', 'Diskon Besar Besaran', '2018-02-23 23:59:00', '2018-02-25 20:50:00', 50, 0);