04jAJRhq

1-- phpMyAdmin SQL Dump
2-- version 4.4.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 03, 2016 at 08:01 AM
7-- Server version: 5.6.26-log
8-- PHP Version: 5.6.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+04: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 utf8mb4 */;
18
19--
20-- Database: `arcilium_donate`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `categories`
27--
28
29CREATE TABLE IF NOT EXISTS `categories` (
30  `cid` int(11) NOT NULL,
31  `cat_title` varchar(20) NOT NULL,
32  `zindex` int(11) NOT NULL DEFAULT '0'
33) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
34
35--
36-- Dumping data for table `categories`
37--
38
39INSERT INTO `categories` (`cid`, `cat_title`, `zindex`) VALUES
40(7, 'Rares', 0),
41(8, 'Weapons', 0),
42(9, 'Armor', 0),
43(10, 'Holiday', 0),
44(11, 'Accessories', 0);
45
46-- --------------------------------------------------------
47
48--
49-- Table structure for table `payments`
50--
51
52CREATE TABLE IF NOT EXISTS `payments` (
53  `id` int(11) NOT NULL,
54  `item_name` varchar(255) NOT NULL,
55  `item_number` int(11) NOT NULL,
56  `status` varchar(255) NOT NULL,
57  `amount` double NOT NULL,
58  `quantity` int(11) NOT NULL DEFAULT '0',
59  `currency` varchar(255) NOT NULL,
60  `buyer` varchar(255) NOT NULL,
61  `receiver` varchar(255) NOT NULL,
62  `dateline` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
63  `player_name` varchar(255) NOT NULL,
64  `claimed` tinyint(1) NOT NULL DEFAULT '0'
65) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
66
67--
68-- Dumping data for table `payments`
69--
70
71INSERT INTO `payments` (`id`, `item_name`, `item_number`, `status`, `amount`, `quantity`, `currency`, `buyer`, `receiver`, `dateline`, `player_name`, `claimed`) VALUES
72(1, 'Test Item', 1, 'Completed', 25, 1, 'USD', 'mails.mail.mm@gmail.com', 'mails.mail.mm@gmail.com', '2015-12-04 21:31:05', 'oly', 1);
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `products`
78--
79
80CREATE TABLE IF NOT EXISTS `products` (
81  `item_id` int(11) NOT NULL,
82  `item_name` varchar(255) NOT NULL,
83  `category` int(11) NOT NULL DEFAULT '0',
84  `item_price` double NOT NULL,
85  `item_discount` double NOT NULL DEFAULT '0',
86  `image_url` varchar(255) NOT NULL,
87  `description` varchar(255) DEFAULT NULL
88) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
89
90--
91-- Dumping data for table `products`
92--
93
94INSERT INTO `products` (`item_id`, `item_name`, `category`, `item_price`, `item_discount`, `image_url`, `description`) VALUES
95(10, 'Yellow Partyhat', 7, 35, 5, 'assets/img/donate/phat.png', NULL),
96(11, 'Eagle Kite', 9, 40, 0, 'assets/img/donate/eagle.png', NULL),
97(17, 'Chaotic Crossbow', 8, 35, 0, 'assets/img/donate/ccb.png', NULL);
98
99-- --------------------------------------------------------
100
101--
102-- Table structure for table `used_hashes`
103--
104
105CREATE TABLE IF NOT EXISTS `used_hashes` (
106  `hash` varchar(255) NOT NULL
107) ENGINE=InnoDB DEFAULT CHARSET=utf8;
108
109--
110-- Dumping data for table `used_hashes`
111--
112
113INSERT INTO `used_hashes` (`hash`) VALUES
114('0c3cb8cb2a08cc0b79d0772da3e6a9b8'),
115('08008e1e2b681361a7da67499cb682e4');
116
117--
118-- Indexes for dumped tables
119--
120
121--
122-- Indexes for table `categories`
123--
124ALTER TABLE `categories`
125  ADD PRIMARY KEY (`cid`);
126
127--
128-- Indexes for table `payments`
129--
130ALTER TABLE `payments`
131  ADD PRIMARY KEY (`id`);
132
133--
134-- Indexes for table `products`
135--
136ALTER TABLE `products`
137  ADD PRIMARY KEY (`item_id`);
138
139--
140-- AUTO_INCREMENT for dumped tables
141--
142
143--
144-- AUTO_INCREMENT for table `categories`
145--
146ALTER TABLE `categories`
147  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14;
148--
149-- AUTO_INCREMENT for table `payments`
150--
151ALTER TABLE `payments`
152  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
153--
154-- AUTO_INCREMENT for table `products`
155--
156ALTER TABLE `products`
157  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
158/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
159/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
160/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;