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