izZ1jXX6

1-- phpMyAdmin SQL Dump
2-- version 4.2.11
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 05, 2018 at 08:21 AM
7-- Server version: 5.6.21
8-- PHP Version: 5.6.3
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `cuselight`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `tbl_payments`
27--
28
29CREATE TABLE IF NOT EXISTS `tbl_payments` (
30`fld_ID` int(11) NOT NULL,
31  `fld_userid` int(11) NOT NULL,
32  `fld_relatedTo` int(11) NOT NULL,
33  `fld_type` varchar(255) NOT NULL,
34  `fld_customerProfileID` varchar(255) NOT NULL,
35  `fld_paymentProfileID` varchar(255) NOT NULL,
36  `fld_transactionID` varchar(255) NOT NULL,
37  `fld_status` enum('success','failed') NOT NULL,
38  `addedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
39) ENGINE=InnoDB DEFAULT CHARSET=latin1;
40
41-- --------------------------------------------------------
42
43--
44-- Table structure for table `tbl_payment_profiles`
45--
46
47CREATE TABLE IF NOT EXISTS `tbl_payment_profiles` (
48`fld_ID` int(11) NOT NULL,
49  `fld_userid` int(11) NOT NULL,
50  `fld_customerProfileID` varchar(255) NOT NULL,
51  `fld_paymentProfileID` varchar(255) NOT NULL,
52  `addedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
53) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
54
55--
56-- Table structure for table `tbl_transactions`
57--
58
59CREATE TABLE IF NOT EXISTS `tbl_transactions` (
60`fld_ID` int(11) NOT NULL,
61  `fld_request` text NOT NULL,
62  `fld_response` text NOT NULL,
63  `addedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66--
67-- Indexes for dumped tables
68--
69
70--
71-- Indexes for table `tbl_payments`
72--
73ALTER TABLE `tbl_payments`
74 ADD PRIMARY KEY (`fld_ID`);
75
76--
77-- Indexes for table `tbl_payment_profiles`
78--
79ALTER TABLE `tbl_payment_profiles`
80 ADD PRIMARY KEY (`fld_ID`);
81
82--
83-- Indexes for table `tbl_transactions`
84--
85ALTER TABLE `tbl_transactions`
86 ADD PRIMARY KEY (`fld_ID`);
87
88--
89-- AUTO_INCREMENT for dumped tables
90--
91
92--
93-- AUTO_INCREMENT for table `tbl_payments`
94--
95ALTER TABLE `tbl_payments`
96MODIFY `fld_ID` int(11) NOT NULL AUTO_INCREMENT;
97--
98-- AUTO_INCREMENT for table `tbl_payment_profiles`
99--
100ALTER TABLE `tbl_payment_profiles`
101MODIFY `fld_ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
102--
103-- AUTO_INCREMENT for table `tbl_transactions`
104--
105ALTER TABLE `tbl_transactions`
106MODIFY `fld_ID` int(11) NOT NULL AUTO_INCREMENT;
107/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
108/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
109/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;