· 9 years ago · Nov 05, 2016, 02:36 PM
1-- MySQL dump 10.13 Distrib 5.5.46, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: arividev
4-- ------------------------------------------------------
5-- Server version 5.5.46-0+deb8u1
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-- Current Database: `arividev`
20--
21
22
23--
24-- Table structure for table `data`
25--
26
27DROP TABLE IF EXISTS `data`;
28/*!40101 SET @saved_cs_client = @@character_set_client */;
29/*!40101 SET character_set_client = utf8 */;
30CREATE TABLE `data` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `key` tinytext,
33 `value` tinytext,
34 PRIMARY KEY (`id`),
35 UNIQUE KEY `data_key_uindex` (`key`(64))
36) ENGINE=InnoDB AUTO_INCREMENT=360 DEFAULT CHARSET=latin1;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `data`
41--
42
43LOCK TABLES `data` WRITE;
44/*!40000 ALTER TABLE `data` DISABLE KEYS */;
45INSERT INTO `data` VALUES (358,'title','Arivi.PL'),(359,'background','assets/img/banner.jpg');
46/*!40000 ALTER TABLE `data` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `sites`
51--
52
53DROP TABLE IF EXISTS `sites`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `sites` (
57 `id` int(11) NOT NULL AUTO_INCREMENT,
58 `name` varchar(64) DEFAULT NULL,
59 `title` varchar(64) DEFAULT NULL,
60 `module` varchar(64) DEFAULT NULL,
61 `renderable` varchar(64) DEFAULT NULL,
62 `redirect` text,
63 PRIMARY KEY (`id`),
64 UNIQUE KEY `sites_title_uindex` (`title`),
65 UNIQUE KEY `sites_name_uindex` (`name`)
66) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
67/*!40101 SET character_set_client = @saved_cs_client */;
68
69--
70-- Dumping data for table `sites`
71--
72
73LOCK TABLES `sites` WRITE;
74/*!40000 ALTER TABLE `sites` DISABLE KEYS */;
75INSERT INTO `sites` VALUES (8,'home','Strona Główna','facebookfeed','fbfeed',''),(9,'playerranking','Ranking Graczy','ranking','playerranking',''),(10,'guildsranking','Ranking Gildii','ranking','guildranking',''),(11,'store','Sklep','store','store','');
76/*!40000 ALTER TABLE `sites` ENABLE KEYS */;
77UNLOCK TABLES;
78
79--
80-- Table structure for table `store_services`
81--
82
83DROP TABLE IF EXISTS `store_services`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `store_services` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `name` varchar(32) DEFAULT NULL,
89 `desc` text,
90 `paypal` varchar(10) DEFAULT NULL,
91 `psc` varchar(10) DEFAULT NULL,
92 `sms_content` varchar(32) DEFAULT NULL,
93 `sms_price` varchar(10) DEFAULT NULL,
94 `sms_id` varchar(10) DEFAULT NULL,
95 `sms_number` varchar(10) DEFAULT NULL,
96 `commands` text,
97 `icon` text,
98 PRIMARY KEY (`id`),
99 UNIQUE KEY `name` (`name`)
100) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Dumping data for table `store_services`
105--
106
107LOCK TABLES `store_services` WRITE;
108/*!40000 ALTER TABLE `store_services` DISABLE KEYS */;
109/*!40000 ALTER TABLE `store_services` ENABLE KEYS */;
110UNLOCK TABLES;
111
112--
113-- Table structure for table `store_transactions`
114--
115
116DROP TABLE IF EXISTS `store_transactions`;
117/*!40101 SET @saved_cs_client = @@character_set_client */;
118/*!40101 SET character_set_client = utf8 */;
119CREATE TABLE `store_transactions` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `nick` varchar(32) DEFAULT NULL,
122 `serviceid` int(11) DEFAULT NULL,
123 `method` varchar(32) DEFAULT NULL,
124 `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
125 PRIMARY KEY (`id`)
126) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
127/*!40101 SET character_set_client = @saved_cs_client */;
128
129--
130-- Dumping data for table `store_transactions`
131--
132
133LOCK TABLES `store_transactions` WRITE;
134/*!40000 ALTER TABLE `store_transactions` DISABLE KEYS */;
135/*!40000 ALTER TABLE `store_transactions` ENABLE KEYS */;
136UNLOCK TABLES;
137
138--
139-- Table structure for table `users`
140--
141
142DROP TABLE IF EXISTS `users`;
143/*!40101 SET @saved_cs_client = @@character_set_client */;
144/*!40101 SET character_set_client = utf8 */;
145CREATE TABLE `users` (
146 `id` int(11) NOT NULL AUTO_INCREMENT,
147 `login` varchar(32) DEFAULT NULL,
148 `password` varchar(72) DEFAULT NULL,
149 `rank` int(11) DEFAULT NULL,
150 PRIMARY KEY (`id`),
151 UNIQUE KEY `login` (`login`)
152) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
153/*!40101 SET character_set_client = @saved_cs_client */;
154
155--
156-- Dumping data for table `users`
157--
158
159LOCK TABLES `users` WRITE;
160/*!40000 ALTER TABLE `users` DISABLE KEYS */;
161INSERT INTO `users` VALUES (1,'XopyIP','$2a$06$wZgT7CeLujI10l.x4V1h3e6wk0xmCV204AecDwGM6mGXg2uZloz2C',2),(8,'admin','$2y$10$zGNNlcz42XAdooBSFBxljuiutkVOoHEtMUzFGreSUqTzf5g9awLQe',2);
162/*!40000 ALTER TABLE `users` ENABLE KEYS */;
163UNLOCK TABLES;
164/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
165
166/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
167/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
168/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
169/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
170/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
171/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
172/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
173
174-- Dump completed on 2016-07-03 16:26:05