| 4736 |
rajveer |
1 |
-- MySQL dump 10.13 Distrib 5.1.41, for debian-linux-gnu (i486)
|
|
|
2 |
--
|
|
|
3 |
-- Host: localhost Database: payment_test
|
|
|
4 |
-- ------------------------------------------------------
|
|
|
5 |
-- Server version 5.1.41-3ubuntu12.10
|
|
|
6 |
|
|
|
7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
|
8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
|
9 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
|
10 |
/*!40101 SET NAMES utf8 */;
|
|
|
11 |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
|
12 |
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
|
13 |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
|
14 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
|
15 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
|
16 |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
17 |
|
|
|
18 |
--
|
|
|
19 |
-- Table structure for table `gatewayattribute`
|
|
|
20 |
--
|
|
|
21 |
|
|
|
22 |
DROP TABLE IF EXISTS `gatewayattribute`;
|
|
|
23 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
24 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
25 |
CREATE TABLE `gatewayattribute` (
|
|
|
26 |
`payment_gateway_id` int(11) NOT NULL,
|
|
|
27 |
`name` varchar(50) NOT NULL,
|
|
|
28 |
`value` varchar(100) DEFAULT NULL,
|
|
|
29 |
PRIMARY KEY (`payment_gateway_id`,`name`),
|
|
|
30 |
KEY `ix_gatewayattribute_payment_gateway_id` (`payment_gateway_id`),
|
|
|
31 |
CONSTRAINT `gatewayattribute_payment_gateway_id_fk` FOREIGN KEY (`payment_gateway_id`) REFERENCES `paymentgateway` (`id`)
|
|
|
32 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
33 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
34 |
|
|
|
35 |
--
|
|
|
36 |
-- Dumping data for table `gatewayattribute`
|
|
|
37 |
--
|
|
|
38 |
|
|
|
39 |
LOCK TABLES `gatewayattribute` WRITE;
|
|
|
40 |
/*!40000 ALTER TABLE `gatewayattribute` DISABLE KEYS */;
|
|
|
41 |
/*!40000 ALTER TABLE `gatewayattribute` ENABLE KEYS */;
|
|
|
42 |
UNLOCK TABLES;
|
|
|
43 |
|
|
|
44 |
--
|
|
|
45 |
-- Table structure for table `payment`
|
|
|
46 |
--
|
|
|
47 |
|
|
|
48 |
DROP TABLE IF EXISTS `payment`;
|
|
|
49 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
50 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
51 |
CREATE TABLE `payment` (
|
|
|
52 |
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
53 |
`gatewayId` int(11) DEFAULT NULL,
|
|
|
54 |
`gatewayPaymentId` varchar(50) DEFAULT NULL,
|
|
|
55 |
`merchantTxnId` int(11) DEFAULT NULL,
|
|
|
56 |
`gatewayTxnId` varchar(50) DEFAULT NULL,
|
|
|
57 |
`amount` float DEFAULT NULL,
|
|
|
58 |
`gatewayTxnStatus` varchar(20) DEFAULT NULL,
|
|
|
59 |
`status` int(11) DEFAULT NULL,
|
|
|
60 |
`userId` int(11) DEFAULT NULL,
|
|
|
61 |
`errorCode` varchar(20) DEFAULT NULL,
|
|
|
62 |
`description` varchar(200) DEFAULT NULL,
|
|
|
63 |
`authCode` varchar(20) DEFAULT NULL,
|
|
|
64 |
`referenceCode` varchar(20) DEFAULT NULL,
|
|
|
65 |
`sessionId` varchar(50) DEFAULT NULL,
|
|
|
66 |
`gatewayTxnDate` varchar(50) DEFAULT NULL,
|
|
|
67 |
`initTimestamp` datetime DEFAULT NULL,
|
|
|
68 |
`successTimestamp` datetime DEFAULT NULL,
|
|
|
69 |
`errorTimestamp` datetime DEFAULT NULL,
|
|
|
70 |
PRIMARY KEY (`id`)
|
|
|
71 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
72 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
73 |
|
|
|
74 |
--
|
|
|
75 |
-- Dumping data for table `payment`
|
|
|
76 |
--
|
|
|
77 |
|
|
|
78 |
LOCK TABLES `payment` WRITE;
|
|
|
79 |
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
|
|
|
80 |
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
|
|
|
81 |
UNLOCK TABLES;
|
|
|
82 |
|
|
|
83 |
--
|
|
|
84 |
-- Table structure for table `paymentattribute`
|
|
|
85 |
--
|
|
|
86 |
|
|
|
87 |
DROP TABLE IF EXISTS `paymentattribute`;
|
|
|
88 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
89 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
90 |
CREATE TABLE `paymentattribute` (
|
|
|
91 |
`payment_id` int(11) NOT NULL,
|
|
|
92 |
`name` varchar(50) NOT NULL,
|
|
|
93 |
`value` varchar(250) DEFAULT NULL,
|
|
|
94 |
PRIMARY KEY (`payment_id`,`name`),
|
|
|
95 |
KEY `ix_paymentattribute_payment_id` (`payment_id`),
|
|
|
96 |
CONSTRAINT `paymentattribute_payment_id_fk` FOREIGN KEY (`payment_id`) REFERENCES `payment` (`id`)
|
|
|
97 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
98 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
99 |
|
|
|
100 |
--
|
|
|
101 |
-- Dumping data for table `paymentattribute`
|
|
|
102 |
--
|
|
|
103 |
|
|
|
104 |
LOCK TABLES `paymentattribute` WRITE;
|
|
|
105 |
/*!40000 ALTER TABLE `paymentattribute` DISABLE KEYS */;
|
|
|
106 |
/*!40000 ALTER TABLE `paymentattribute` ENABLE KEYS */;
|
|
|
107 |
UNLOCK TABLES;
|
|
|
108 |
|
|
|
109 |
--
|
|
|
110 |
-- Table structure for table `paymentgateway`
|
|
|
111 |
--
|
|
|
112 |
|
|
|
113 |
DROP TABLE IF EXISTS `paymentgateway`;
|
|
|
114 |
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
|
115 |
/*!40101 SET character_set_client = utf8 */;
|
|
|
116 |
CREATE TABLE `paymentgateway` (
|
|
|
117 |
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
118 |
`name` varchar(100) DEFAULT NULL,
|
|
|
119 |
`aliasName` varchar(100) DEFAULT NULL,
|
|
|
120 |
`url` varchar(500) DEFAULT NULL,
|
|
|
121 |
`responseUrl` varchar(500) DEFAULT NULL,
|
|
|
122 |
`errorUrl` varchar(500) DEFAULT NULL,
|
|
|
123 |
`status` int(11) DEFAULT NULL,
|
|
|
124 |
`addedOn` datetime DEFAULT NULL,
|
|
|
125 |
PRIMARY KEY (`id`)
|
|
|
126 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
127 |
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
128 |
|
|
|
129 |
--
|
|
|
130 |
-- Dumping data for table `paymentgateway`
|
|
|
131 |
--
|
|
|
132 |
|
|
|
133 |
LOCK TABLES `paymentgateway` WRITE;
|
|
|
134 |
/*!40000 ALTER TABLE `paymentgateway` DISABLE KEYS */;
|
|
|
135 |
/*!40000 ALTER TABLE `paymentgateway` ENABLE KEYS */;
|
|
|
136 |
UNLOCK TABLES;
|
|
|
137 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
138 |
|
|
|
139 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
|
140 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
|
141 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
|
142 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
143 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
|
144 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
|
145 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
146 |
|
|
|
147 |
-- Dump completed on 2011-08-10 17:17:15
|