tCZn6Chm

1-- dump by formatme
2-- https://citizenhack.me/drama/
3
4-- --------------------------------------------------------
5-- Host:                         127.0.0.1
6-- Server version:               10.1.6-MariaDB - mariadb.org binary distribution
7-- Server OS:                    Win64
8-- HeidiSQL Version:             9.3.0.4984
9-- --------------------------------------------------------
10
11/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
12/*!40101 SET NAMES utf8mb4 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16-- Dumping database structure for rp_credits
17CREATE DATABASE IF NOT EXISTS `rp_credits` /*!40100 DEFAULT CHARACTER SET latin1 */;
18USE `rp_credits`;
19
20
21-- Dumping structure for table rp_credits.kshop_credits_transactions
22CREATE TABLE IF NOT EXISTS `kshop_credits_transactions` (
23  `Time` bigint(20) DEFAULT NULL,
24  `SteamID` varchar(40) DEFAULT NULL,
25  `Change` int(11) DEFAULT NULL,
26  `Note` text
27) ENGINE=MyISAM DEFAULT CHARSET=latin1;
28
29-- Dumping data for table rp_credits.kshop_credits_transactions: 0 rows
30/*!40000 ALTER TABLE `kshop_credits_transactions` DISABLE KEYS */;
31/*!40000 ALTER TABLE `kshop_credits_transactions` ENABLE KEYS */;
32
33
34-- Dumping structure for table rp_credits.kshop_currency_conversions
35CREATE TABLE IF NOT EXISTS `kshop_currency_conversions` (
36  `currency` char(3) NOT NULL DEFAULT '',
37  `rate` float NOT NULL DEFAULT '0',
38  PRIMARY KEY (`currency`)
39) ENGINE=MyISAM DEFAULT CHARSET=utf8;
40
41-- Dumping data for table rp_credits.kshop_currency_conversions: 0 rows
42/*!40000 ALTER TABLE `kshop_currency_conversions` DISABLE KEYS */;
43/*!40000 ALTER TABLE `kshop_currency_conversions` ENABLE KEYS */;
44
45
46-- Dumping structure for table rp_credits.kshop_ipn_transactions
47CREATE TABLE IF NOT EXISTS `kshop_ipn_transactions` (
48  `pay_status` varchar(32) NOT NULL,
49  `payer_email` varchar(128) NOT NULL,
50  `custom` varchar(20) NOT NULL,
51  `amount` float NOT NULL,
52  `currency` varchar(8) NOT NULL,
53  `txn_id` varchar(64) NOT NULL,
54  `txn_type` varchar(32) NOT NULL,
55  `first_name` varchar(64) DEFAULT NULL,
56  `last_name` varchar(64) DEFAULT NULL,
57  `parent_txn_id` varchar(64) DEFAULT NULL,
58  `timestamp` double DEFAULT '0',
59  `net` float DEFAULT '0',
60  `receiver_email` varchar(128) DEFAULT 'superiorgmodservers@gmail.com'
61) ENGINE=MyISAM DEFAULT CHARSET=latin1;
62
63-- Dumping data for table rp_credits.kshop_ipn_transactions: 0 rows
64/*!40000 ALTER TABLE `kshop_ipn_transactions` DISABLE KEYS */;
65/*!40000 ALTER TABLE `kshop_ipn_transactions` ENABLE KEYS */;
66
67
68-- Dumping structure for table rp_credits.kshop_purchases
69CREATE TABLE IF NOT EXISTS `kshop_purchases` (
70  `Time` bigint(20) DEFAULT NULL,
71  `SteamID` varchar(40) DEFAULT NULL,
72  `Upgrade` varchar(255) DEFAULT NULL
73) ENGINE=MyISAM DEFAULT CHARSET=latin1;
74
75-- Dumping data for table rp_credits.kshop_purchases: 0 rows
76/*!40000 ALTER TABLE `kshop_purchases` DISABLE KEYS */;
77/*!40000 ALTER TABLE `kshop_purchases` ENABLE KEYS */;
78
79
80-- Dumping structure for table rp_credits.kshop_servers
81CREATE TABLE IF NOT EXISTS `kshop_servers` (
82  `HostID` bigint(20) unsigned NOT NULL DEFAULT '0',
83  `Address` varchar(30) DEFAULT NULL,
84  `HostName` varchar(255) DEFAULT NULL,
85  PRIMARY KEY (`HostID`)
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- Dumping data for table rp_credits.kshop_servers: ~2 rows (approximately)
89/*!40000 ALTER TABLE `kshop_servers` DISABLE KEYS */;
90INSERT INTO `kshop_servers` (`HostID`, `Address`, `HostName`) VALUES
91	(429496729527015, '74.91.117.51:27015', '[SUP] SuperiorServers.co'),
92	(429496729527016, '74.91.117.146:27016', '[SUP] SuperiorServers.co | PurgeRP #2');
93/*!40000 ALTER TABLE `kshop_servers` ENABLE KEYS */;
94/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
95/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
96/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;