1. -- --------------------------------------------------------
2. -- Host:                         80.72.41.210
3. -- Wersja serwera:               10.1.26-MariaDB-0+deb9u1 - Debian 9.1
4. -- Serwer OS:                    debian-linux-gnu
5. -- HeidiSQL Wersja:              9.5.0.5196
6. -- --------------------------------------------------------
7.  
8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9. /*!40101 SET NAMES utf8 */;
10. /*!50503 SET NAMES utf8mb4 */;
11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13.  
14. -- Zrzut struktury tabela srv35601.dr_shop_auras
15. CREATE TABLE IF NOT EXISTS `dr_shop_auras` (
16.   `buyid` int(11) NOT NULL AUTO_INCREMENT,
17.   `steamid` varchar(255) NOT NULL,
18.   `id` int(11) NOT NULL,
19.   `enddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
20.   PRIMARY KEY (`buyid`)
21. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
22.  
23. -- Data exporting was unselected.
24. -- Zrzut struktury tabela srv35601.dr_shop_models
25. CREATE TABLE IF NOT EXISTS `dr_shop_models` (
26.   `buyid` int(11) NOT NULL AUTO_INCREMENT,
27.   `steamid` varchar(255) NOT NULL,
28.   `id` int(11) NOT NULL,
29.   `enddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30.   PRIMARY KEY (`buyid`)
31. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
32.  
33. -- Data exporting was unselected.
34. -- Zrzut struktury tabela srv35601.dr_shop_pets
35. CREATE TABLE IF NOT EXISTS `dr_shop_pets` (
36.   `buyid` int(11) NOT NULL AUTO_INCREMENT,
37.   `steamid` varchar(255) NOT NULL,
38.   `id` int(11) NOT NULL,
39.   `enddate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
40.   PRIMARY KEY (`buyid`)
41. ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
42.  
43. -- Data exporting was unselected.
44. -- Zrzut struktury tabela srv35601.gsystems_time_players
45. CREATE TABLE IF NOT EXISTS `gsystems_time_players` (
46.   `playername` varchar(128) NOT NULL,
47.   `steamid` varchar(32) NOT NULL,
48.   `last_accountuse` int(64) NOT NULL,
49.   `timeCT` int(16) DEFAULT NULL,
50.   `timeTT` int(16) DEFAULT NULL,
51.   `timeSPE` int(16) DEFAULT NULL,
52.   `total` int(16) DEFAULT NULL,
53.   PRIMARY KEY (`steamid`)
54. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55.  
56. -- Data exporting was unselected.
57. -- Zrzut struktury tabela srv35601.j_credits
58. CREATE TABLE IF NOT EXISTS `j_credits` (
59.   `accountID` int(11) NOT NULL DEFAULT '0',
60.   `steamid` varchar(64) NOT NULL DEFAULT '',
61.   `name` varchar(64) NOT NULL DEFAULT '',
62.   `credits` int(11) NOT NULL DEFAULT '0',
63.   PRIMARY KEY (`accountID`)
64. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65.  
66. -- Data exporting was unselected.
67. -- Zrzut struktury tabela srv35601.mapzones
68. CREATE TABLE IF NOT EXISTS `mapzones` (
69.   `id` int(11) NOT NULL AUTO_INCREMENT,
70.   `map` varchar(128) DEFAULT NULL,
71.   `type` int(11) DEFAULT NULL,
72.   `corner1_x` float DEFAULT NULL,
73.   `corner1_y` float DEFAULT NULL,
74.   `corner1_z` float DEFAULT NULL,
75.   `corner2_x` float DEFAULT NULL,
76.   `corner2_y` float DEFAULT NULL,
77.   `corner2_z` float DEFAULT NULL,
78.   `rot_ang` float DEFAULT NULL,
79.   `fix1_x` float DEFAULT NULL,
80.   `fix1_y` float DEFAULT NULL,
81.   `fix2_x` float DEFAULT NULL,
82.   `fix2_y` float DEFAULT NULL,
83.   PRIMARY KEY (`id`)
84. ) ENGINE=MyISAM AUTO_INCREMENT=417 DEFAULT CHARSET=latin1;
85.  
86. -- Data exporting was unselected.
87. -- Zrzut struktury tabela srv35601.playertimes
88. CREATE TABLE IF NOT EXISTS `playertimes` (
89.   `id` int(11) NOT NULL AUTO_INCREMENT,
90.   `auth` varchar(32) DEFAULT NULL,
91.   `map` varchar(128) DEFAULT NULL,
92.   `time` float DEFAULT NULL,
93.   `jumps` varchar(32) DEFAULT NULL,
94.   `style` varchar(32) DEFAULT NULL,
95.   `date` date DEFAULT NULL,
96.   PRIMARY KEY (`id`)
97. ) ENGINE=InnoDB AUTO_INCREMENT=6519 DEFAULT CHARSET=latin1;
98.  
99. -- Data exporting was unselected.
100. -- Zrzut struktury tabela srv35601.stats
101. CREATE TABLE IF NOT EXISTS `stats` (
102.   `STEAMID64` bigint(128) NOT NULL,
103.   `nick` varchar(255) NOT NULL,
104.   `PierwszePolaczenie` int(11) NOT NULL,
105.   `Kills` int(11) NOT NULL,
106.   `Deaths` int(11) NOT NULL,
107.   `Pk` int(11) NOT NULL,
108.   `Czas` int(11) NOT NULL,
109.   `PrzejsciaMapy` int(11) NOT NULL,
110.   `RekordyMap` int(11) NOT NULL,
111.   PRIMARY KEY (`STEAMID64`)
112. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113.  
114. -- Data exporting was unselected.
115. -- Zrzut struktury tabela srv35601.users
116. CREATE TABLE IF NOT EXISTS `users` (
117.   `auth` varchar(32) NOT NULL,
118.   `name` varchar(32) DEFAULT NULL,
119.   `country` varchar(45) DEFAULT NULL,
120.   `ip` varchar(32) DEFAULT NULL,
121.   PRIMARY KEY (`auth`)
122. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
123.  
124. -- Data exporting was unselected.
125. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
126. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
127. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128.