· 8 years ago · Dec 06, 2017, 04:44 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.9
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 06, 2017 at 05:42 AM
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 `list_transaction`
21--
22
23CREATE TABLE IF NOT EXISTS `list_transaction` (
24 `id` int(120) NOT NULL AUTO_INCREMENT,
25 `user_id` varchar(120) DEFAULT NULL,
26 `photo` varchar(120) DEFAULT NULL,
27 `nameCustomer` varchar(120) DEFAULT NULL,
28 `dateTransaction` date DEFAULT NULL,
29 `viaTransaction` varchar(120) DEFAULT NULL,
30 `price` varchar(120) DEFAULT NULL,
31 PRIMARY KEY (`id`)
32) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
33
34--
35-- Dumping data for table `list_transaction`
36--
37
38INSERT INTO `list_transaction` (`id`, `user_id`, `photo`, `nameCustomer`, `dateTransaction`, `viaTransaction`, `price`) VALUES
39(1, '6d9a1f3ee8a67402144ab62f8f927063', 'https://i.pinimg.com/736x/1f/10/b5/1f10b51f5aab46c870d0e83bffce3844--art-atelier-atelier-series.jpg', 'Bembeng', '2017-11-17', 'Vie emoney', '10000'),
40(2, '6d9a1f3ee8a67402144ab62f8f927063', 'https://i.pinimg.com/736x/fb/46/2d/fb462d93244f0c7557c791bb60204bd0--bleach-characters-anime-characters.jpg', 'Tri', '2017-11-20', 'Cash', '20000'),
41(3, '6d9a1f3ee8a67402144ab62f8f927063', NULL, 'adit', '2017-11-15', 'paypal', '90190'),
42(4, '6d9a1f3ee8a67402144ab62f8f927063', NULL, 'bryn', '2017-11-21', 'bitcoin', '89123009');