· 8 years ago · Feb 22, 2018, 08:14 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 22, 2018 at 09:12
7-- Server version: 5.6.14
8-- PHP Version: 5.5.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `scring`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `Table_Master_Promo`
21--
22
23CREATE TABLE IF NOT EXISTS `Table_Master_Promo` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `name` varchar(100) DEFAULT NULL,
26 `description` text,
27 `start_date` datetime DEFAULT NULL,
28 `end_date` datetime DEFAULT NULL,
29 `discount_amount` int(15) DEFAULT NULL,
30 `idelete` int(11) DEFAULT '0',
31 PRIMARY KEY (`id`)
32) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
33
34--
35-- Dumping data for table `Table_Master_Promo`
36--
37
38INSERT INTO `Table_Master_Promo` (`id`, `name`, `description`, `start_date`, `end_date`, `discount_amount`, `idelete`) VALUES
39(1, 'Tester Januari', 'Test1', '2018-02-18 21:59:49', '2018-02-28 21:59:58', 50, 0),
40(2, 'Tester Feb', 'bayar 1000', '2018-02-13 11:08:00', '2018-03-07 16:50:00', 30, 1),
41(3, 'Tester kk', 'tester berhasil', '2018-02-22 22:33:00', '2018-02-24 22:34:00', NULL, 0),
42(4, 'Tester Maret', 'tester sdah bisa', '2018-03-09 00:00:00', '2018-03-10 23:56:00', 50, 1),
43(5, 'Promo Brian Birthday', 'Promo perayaan Ultah Brian', '2018-02-22 10:14:00', '2018-03-22 10:14:00', 25, 1),
44(6, 'promo meriah', 'Diskon Besar Besaran', '2018-02-23 23:59:00', '2018-02-25 20:50:00', 50, 0);