1 | -- --------------------------------------------------------
|
---|
2 | -- Hostitel: 127.0.0.1
|
---|
3 | -- Verze serveru: 5.5.32-0ubuntu0.13.04.1 - (Ubuntu)
|
---|
4 | -- OS serveru: debian-linux-gnu
|
---|
5 | -- HeidiSQL Verze: 8.0.0.4396
|
---|
6 | -- --------------------------------------------------------
|
---|
7 |
|
---|
8 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
---|
9 | /*!40101 SET NAMES utf8 */;
|
---|
10 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
---|
11 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
---|
12 |
|
---|
13 | -- Exportování struktury pro tabulka wow_web.Article
|
---|
14 | CREATE TABLE IF NOT EXISTS `Article` (
|
---|
15 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
16 | `Title` text COLLATE utf8_czech_ci NOT NULL,
|
---|
17 | `Author` text COLLATE utf8_czech_ci NOT NULL,
|
---|
18 | `Category` int(11) NOT NULL DEFAULT '0',
|
---|
19 | `Content` text COLLATE utf8_czech_ci NOT NULL,
|
---|
20 | `Time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
---|
21 | PRIMARY KEY (`Id`),
|
---|
22 | KEY `Category` (`Category`),
|
---|
23 | KEY `Time` (`Time`),
|
---|
24 | CONSTRAINT `Article_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ArticleCategory` (`Id`)
|
---|
25 | ) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
---|
26 |
|
---|
27 | -- Exportování dat pro tabulku wow_web.Article: ~0 rows (přibližně)
|
---|
28 | /*!40000 ALTER TABLE `Article` DISABLE KEYS */;
|
---|
29 | /*!40000 ALTER TABLE `Article` ENABLE KEYS */;
|
---|
30 |
|
---|
31 |
|
---|
32 | -- Exportování struktury pro tabulka wow_web.ArticleCategory
|
---|
33 | CREATE TABLE IF NOT EXISTS `ArticleCategory` (
|
---|
34 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
35 | `Name` varchar(255) NOT NULL,
|
---|
36 | PRIMARY KEY (`Id`)
|
---|
37 | ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
|
---|
38 |
|
---|
39 | -- Exportování dat pro tabulku wow_web.ArticleCategory: ~4 rows (přibližně)
|
---|
40 | /*!40000 ALTER TABLE `ArticleCategory` DISABLE KEYS */;
|
---|
41 | INSERT INTO `ArticleCategory` (`Id`, `Name`) VALUES
|
---|
42 | (1, 'Server novinky'),
|
---|
43 | (2, 'GM novinky'),
|
---|
44 | (3, 'In-game novinky'),
|
---|
45 | (4, 'Články');
|
---|
46 | /*!40000 ALTER TABLE `ArticleCategory` ENABLE KEYS */;
|
---|
47 |
|
---|
48 |
|
---|
49 | -- Exportování struktury pro tabulka wow_web.characters
|
---|
50 | CREATE TABLE IF NOT EXISTS `characters` (
|
---|
51 | `guid` int(11) NOT NULL DEFAULT '0',
|
---|
52 | `warm` int(11) NOT NULL DEFAULT '0',
|
---|
53 | `weblevel` int(11) NOT NULL DEFAULT '0'
|
---|
54 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
55 |
|
---|
56 | -- Exportování dat pro tabulku wow_web.characters: ~0 rows (přibližně)
|
---|
57 | /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
|
---|
58 | /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
|
---|
59 |
|
---|
60 |
|
---|
61 | -- Exportování struktury pro tabulka wow_web.ClientRedirection
|
---|
62 | CREATE TABLE IF NOT EXISTS `ClientRedirection` (
|
---|
63 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
64 | `Original` varchar(255) NOT NULL,
|
---|
65 | `Local` varchar(255) NOT NULL,
|
---|
66 | PRIMARY KEY (`Id`)
|
---|
67 | ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
|
---|
68 |
|
---|
69 | -- Exportování dat pro tabulku wow_web.ClientRedirection: 26 rows
|
---|
70 | /*!40000 ALTER TABLE `ClientRedirection` DISABLE KEYS */;
|
---|
71 | INSERT INTO `ClientRedirection` (`Id`, `Original`, `Local`) VALUES
|
---|
72 | (1, 'http://signup.wow-europe.com/', 'http://www.heroesoffantasy.cz/registrace/'),
|
---|
73 | (2, 'http://www.wow-europe.com/en/support/', 'http://www.heroesoffantasy.cz/podpora/'),
|
---|
74 | (3, 'http://www.wow-europe.com/en/legal', 'http://www.heroesoffantasy.cz/pravni/'),
|
---|
75 | (4, 'http://www.wow-europe.com/en/serverstatus', 'http://www.heroesoffantasy.cz/stav-serveru/'),
|
---|
76 | (5, 'http://www.wow-europe.com/en/account/', 'http://www.heroesoffantasy.cz/ucet/'),
|
---|
77 | (6, 'http://www.wow-europe.com/en/burningcrusade/download', 'http://www.heroesoffantasy.cz/stahovani/'),
|
---|
78 | (7, 'http://eu.blizzard.com/support/article.xml?articleId=19654', 'http://www.heroesoffantasy.cz/platna-verze-hry/'),
|
---|
79 | (8, 'http://www.wow-europe.com/en/misc/banned.html', 'http://www.heroesoffantasy.cz/blokovani/'),
|
---|
80 | (9, 'https://www.wow-europe.com/login-support', 'http://www.heroesoffantasy.cz/podpora-prihlaseni/'),
|
---|
81 | (10, 'www.wow-europe.com/en/support', 'www.heroesoffantasy.cz/podpora/'),
|
---|
82 | (11, 'http://beta.wow-europe.com/en/alert', 'http://www.heroesoffantasy.cz/alert-beta/'),
|
---|
83 | (12, 'http://eu.scan.worldofwarcraft.com/update/Launcher.txt', 'http://www.heroesoffantasy.cz/launcher/'),
|
---|
84 | (13, 'http://eu.scan.worldofwarcraft.com/update/Scan.dll', 'http://www.heroesoffantasy.cz/'),
|
---|
85 | (14, 'http://eu.blizzard.com/support/article.xml?articleId=19644', 'http://www.heroesoffantasy.cz/trojan/'),
|
---|
86 | (15, 'http://eu.blizzard.com/support/article.xml?articleId=19633', 'http://www.heroesoffantasy.cz/hack/'),
|
---|
87 | (16, 'http://status.wow-europe.com/en/alert', 'http://www.heroesoffantasy.cz/alert/'),
|
---|
88 | (17, 'https://www.wow-europe.com/account/account-error.html', 'http://www.heroesoffantasy.cz/chyba-uctu/'),
|
---|
89 | (18, 'http://www.wow-europe.com', 'http://www.heroesoffantasy.cz/'),
|
---|
90 | (19, 'www.wow-europe.com', 'www.heroesoffantasy.cz'),
|
---|
91 | (20, 'http://launcher.wow-europe.com/en/eula.htm', 'http://www.heroesoffantasy.cz/eula/'),
|
---|
92 | (21, 'http://launcher.wow-europe.com/en/tos.htm', 'http://www.heroesoffantasy.cz/tos/'),
|
---|
93 | (22, 'www.wow-europe.com/en/lichking/download/', 'www.heroesoffantasy.cz/stahovani/'),
|
---|
94 | (23, 'http://us.blizzard.com/support/index.xml?gameId=11', 'http://www.heroesoffantasy.cz/podpora/'),
|
---|
95 | (25, 'http://www.worldofwarcraft.com/policy/pvp.shtml', 'http://www.heroesoffantasy.com/pvp/'),
|
---|
96 | (24, 'http://signup.worldofwarcraft.com', 'http://www.heroesoffantasy.cz/registrace/'),
|
---|
97 | (26, 'www.worldofwarcraft.com/support/trial', 'www.heroesoffantasyc.cz/stahovani');
|
---|
98 | /*!40000 ALTER TABLE `ClientRedirection` ENABLE KEYS */;
|
---|
99 |
|
---|
100 |
|
---|
101 | -- Exportování struktury pro tabulka wow_web.comments
|
---|
102 | CREATE TABLE IF NOT EXISTS `comments` (
|
---|
103 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
104 | `user` text COLLATE utf8_czech_ci NOT NULL,
|
---|
105 | `comment` text COLLATE utf8_czech_ci NOT NULL,
|
---|
106 | `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
---|
107 | PRIMARY KEY (`id`)
|
---|
108 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
---|
109 |
|
---|
110 | -- Exportování dat pro tabulku wow_web.comments: ~0 rows (přibližně)
|
---|
111 | /*!40000 ALTER TABLE `comments` DISABLE KEYS */;
|
---|
112 | /*!40000 ALTER TABLE `comments` ENABLE KEYS */;
|
---|
113 |
|
---|
114 |
|
---|
115 | -- Exportování struktury pro tabulka wow_web.DbVersion
|
---|
116 | CREATE TABLE IF NOT EXISTS `DbVersion` (
|
---|
117 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
118 | `Revision` int(11) NOT NULL,
|
---|
119 | PRIMARY KEY (`Id`)
|
---|
120 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
121 |
|
---|
122 | -- Exportování dat pro tabulku wow_web.DbVersion: ~0 rows (přibližně)
|
---|
123 | /*!40000 ALTER TABLE `DbVersion` DISABLE KEYS */;
|
---|
124 | INSERT INTO `DbVersion` (
|
---|
125 | `Id` ,
|
---|
126 | `Revision`
|
---|
127 | )
|
---|
128 | VALUES (
|
---|
129 | NULL , '710'
|
---|
130 | );
|
---|
131 | /*!40000 ALTER TABLE `DbVersion` ENABLE KEYS */;
|
---|
132 |
|
---|
133 |
|
---|
134 | -- Exportování struktury pro tabulka wow_web.File
|
---|
135 | CREATE TABLE IF NOT EXISTS `File` (
|
---|
136 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
137 | `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
|
---|
138 | `Location` varchar(255) COLLATE utf8_czech_ci NOT NULL,
|
---|
139 | `Time` datetime NOT NULL,
|
---|
140 | `Category` int(11) NOT NULL,
|
---|
141 | `Description` text COLLATE utf8_czech_ci NOT NULL,
|
---|
142 | PRIMARY KEY (`Id`),
|
---|
143 | KEY `Category` (`Category`),
|
---|
144 | CONSTRAINT `File_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `FileCategory` (`Id`)
|
---|
145 | ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
---|
146 |
|
---|
147 | -- Exportování dat pro tabulku wow_web.File: ~0 rows (přibližně)
|
---|
148 | /*!40000 ALTER TABLE `File` DISABLE KEYS */;
|
---|
149 | /*!40000 ALTER TABLE `File` ENABLE KEYS */;
|
---|
150 |
|
---|
151 |
|
---|
152 | -- Exportování struktury pro tabulka wow_web.FileCategory
|
---|
153 | CREATE TABLE IF NOT EXISTS `FileCategory` (
|
---|
154 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
155 | `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
|
---|
156 | PRIMARY KEY (`Id`)
|
---|
157 | ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
---|
158 |
|
---|
159 | -- Exportování dat pro tabulku wow_web.FileCategory: ~2 rows (přibližně)
|
---|
160 | /*!40000 ALTER TABLE `FileCategory` DISABLE KEYS */;
|
---|
161 | INSERT INTO `FileCategory` (`Id`, `Name`) VALUES
|
---|
162 | (1, 'Herní klient WoW'),
|
---|
163 | (2, 'Čeština pro klienta');
|
---|
164 | /*!40000 ALTER TABLE `FileCategory` ENABLE KEYS */;
|
---|
165 |
|
---|
166 |
|
---|
167 | -- Exportování struktury pro tabulka wow_web.Finance
|
---|
168 | CREATE TABLE IF NOT EXISTS `Finance` (
|
---|
169 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
170 | `Time` datetime DEFAULT NULL,
|
---|
171 | `Money` int(11) DEFAULT NULL,
|
---|
172 | `Operation` enum('contribution','consumption','buy','internet','sell','hosting') CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL DEFAULT 'contribution',
|
---|
173 | `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
|
---|
174 | `Reward` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
|
---|
175 | KEY `ID` (`Id`)
|
---|
176 | ) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
|
---|
177 |
|
---|
178 | -- Exportování dat pro tabulku wow_web.Finance: ~0 rows (přibližně)
|
---|
179 | /*!40000 ALTER TABLE `Finance` DISABLE KEYS */;
|
---|
180 | /*!40000 ALTER TABLE `Finance` ENABLE KEYS */;
|
---|
181 |
|
---|
182 |
|
---|
183 | -- Exportování struktury pro tabulka wow_web.FinanceReward
|
---|
184 | CREATE TABLE IF NOT EXISTS `FinanceReward` (
|
---|
185 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
186 | `Reward` varchar(255) NOT NULL,
|
---|
187 | `Price` varchar(255) NOT NULL,
|
---|
188 | PRIMARY KEY (`Id`)
|
---|
189 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
190 |
|
---|
191 | -- Exportování dat pro tabulku wow_web.FinanceReward: ~0 rows (přibližně)
|
---|
192 | /*!40000 ALTER TABLE `FinanceReward` DISABLE KEYS */;
|
---|
193 | /*!40000 ALTER TABLE `FinanceReward` ENABLE KEYS */;
|
---|
194 |
|
---|
195 |
|
---|
196 | -- Exportování struktury pro tabulka wow_web.GmTeam
|
---|
197 | CREATE TABLE IF NOT EXISTS `GmTeam` (
|
---|
198 | `Nick` varchar(255) NOT NULL,
|
---|
199 | `AccountId` int(11) NOT NULL,
|
---|
200 | `Delegation` varchar(255) NOT NULL,
|
---|
201 | `ForumId` int(11) NOT NULL,
|
---|
202 | `RealmId` int(11) NOT NULL,
|
---|
203 | `TimeFrom` date DEFAULT NULL,
|
---|
204 | `TimeTo` date DEFAULT NULL,
|
---|
205 | KEY `AccountId` (`AccountId`),
|
---|
206 | KEY `TimeFrom` (`TimeFrom`),
|
---|
207 | KEY `TimeTo` (`TimeTo`),
|
---|
208 | KEY `RealmId` (`RealmId`)
|
---|
209 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
210 |
|
---|
211 | -- Exportování dat pro tabulku wow_web.GmTeam: ~0 rows (přibližně)
|
---|
212 | /*!40000 ALTER TABLE `GmTeam` DISABLE KEYS */;
|
---|
213 | /*!40000 ALTER TABLE `GmTeam` ENABLE KEYS */;
|
---|
214 |
|
---|
215 |
|
---|
216 | -- Exportování struktury pro tabulka wow_web.GuildHouse
|
---|
217 | CREATE TABLE IF NOT EXISTS `GuildHouse` (
|
---|
218 | `Guild` int(255) DEFAULT NULL,
|
---|
219 | `Realm` int(11) NOT NULL,
|
---|
220 | `Type` int(255) NOT NULL,
|
---|
221 | `NextPayment` date DEFAULT NULL,
|
---|
222 | KEY `Id` (`Guild`),
|
---|
223 | KEY `Type` (`Type`),
|
---|
224 | CONSTRAINT `GuildHouse_ibfk_1` FOREIGN KEY (`Type`) REFERENCES `GuildHouseType` (`Id`)
|
---|
225 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
226 |
|
---|
227 | -- Exportování dat pro tabulku wow_web.GuildHouse: ~0 rows (přibližně)
|
---|
228 | /*!40000 ALTER TABLE `GuildHouse` DISABLE KEYS */;
|
---|
229 | /*!40000 ALTER TABLE `GuildHouse` ENABLE KEYS */;
|
---|
230 |
|
---|
231 |
|
---|
232 | -- Exportování struktury pro tabulka wow_web.GuildHouseType
|
---|
233 | CREATE TABLE IF NOT EXISTS `GuildHouseType` (
|
---|
234 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
235 | `Name` varchar(255) NOT NULL,
|
---|
236 | `Tax` int(11) NOT NULL,
|
---|
237 | PRIMARY KEY (`Id`)
|
---|
238 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
239 |
|
---|
240 | -- Exportování dat pro tabulku wow_web.GuildHouseType: ~0 rows (přibližně)
|
---|
241 | /*!40000 ALTER TABLE `GuildHouseType` DISABLE KEYS */;
|
---|
242 | /*!40000 ALTER TABLE `GuildHouseType` ENABLE KEYS */;
|
---|
243 |
|
---|
244 |
|
---|
245 | -- Exportování struktury pro tabulka wow_web.GuildInfo
|
---|
246 | CREATE TABLE IF NOT EXISTS `GuildInfo` (
|
---|
247 | `Id` int(11) NOT NULL DEFAULT '0',
|
---|
248 | `Guild` int(11) NOT NULL,
|
---|
249 | `Realm` int(11) NOT NULL,
|
---|
250 | `Homepage` varchar(255) NOT NULL,
|
---|
251 | PRIMARY KEY (`Id`),
|
---|
252 | KEY `Guild` (`Guild`),
|
---|
253 | KEY `Realm` (`Realm`)
|
---|
254 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
255 |
|
---|
256 | -- Exportování dat pro tabulku wow_web.GuildInfo: ~0 rows (přibližně)
|
---|
257 | /*!40000 ALTER TABLE `GuildInfo` DISABLE KEYS */;
|
---|
258 | /*!40000 ALTER TABLE `GuildInfo` ENABLE KEYS */;
|
---|
259 |
|
---|
260 |
|
---|
261 | -- Exportování struktury pro tabulka wow_web.guildy
|
---|
262 | CREATE TABLE IF NOT EXISTS `guildy` (
|
---|
263 | `id` varchar(255) DEFAULT NULL,
|
---|
264 | `jmeno` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci DEFAULT NULL,
|
---|
265 | `GuM` varchar(255) DEFAULT NULL,
|
---|
266 | `typgh` varchar(255) NOT NULL,
|
---|
267 | `dalsi_platba` date DEFAULT NULL
|
---|
268 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
---|
269 |
|
---|
270 | -- Exportování dat pro tabulku wow_web.guildy: ~0 rows (přibližně)
|
---|
271 | /*!40000 ALTER TABLE `guildy` DISABLE KEYS */;
|
---|
272 | /*!40000 ALTER TABLE `guildy` ENABLE KEYS */;
|
---|
273 |
|
---|
274 |
|
---|
275 | -- Exportování struktury pro tabulka wow_web.Host
|
---|
276 | CREATE TABLE IF NOT EXISTS `Host` (
|
---|
277 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
278 | `OS` varchar(255) NOT NULL,
|
---|
279 | `CPU` varchar(255) NOT NULL,
|
---|
280 | `Memory` varchar(255) NOT NULL,
|
---|
281 | `HDD` varchar(255) NOT NULL,
|
---|
282 | `Internet` varchar(255) NOT NULL,
|
---|
283 | `Address` varchar(255) NOT NULL,
|
---|
284 | `Statistic` varchar(255) NOT NULL,
|
---|
285 | `Enabled` int(11) NOT NULL DEFAULT '1',
|
---|
286 | PRIMARY KEY (`Id`)
|
---|
287 | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
---|
288 |
|
---|
289 | -- Exportování dat pro tabulku wow_web.Host: ~1 rows (přibližně)
|
---|
290 | /*!40000 ALTER TABLE `Host` DISABLE KEYS */;
|
---|
291 | INSERT INTO `Host` (`Id`, `OS`, `CPU`, `Memory`, `HDD`, `Internet`, `Address`, `Statistic`, `Enabled`) VALUES
|
---|
292 | (3, 'Linux', '', '', '', '', 'localhost', '', 1);
|
---|
293 | /*!40000 ALTER TABLE `Host` ENABLE KEYS */;
|
---|
294 |
|
---|
295 |
|
---|
296 | -- Exportování struktury pro tabulka wow_web.Logon
|
---|
297 | CREATE TABLE IF NOT EXISTS `Logon` (
|
---|
298 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
299 | `Host` int(11) NOT NULL,
|
---|
300 | `DatabaseUser` varchar(255) NOT NULL,
|
---|
301 | `DatabasePassword` varchar(255) NOT NULL,
|
---|
302 | `DatabaseHost` varchar(255) NOT NULL,
|
---|
303 | `DatabaseRealmd` varchar(255) NOT NULL,
|
---|
304 | `ClientVersion` varchar(255) NOT NULL,
|
---|
305 | `Port` int(11) NOT NULL,
|
---|
306 | `Online` int(11) NOT NULL,
|
---|
307 | `Name` varchar(255) NOT NULL,
|
---|
308 | `Enabled` int(11) NOT NULL DEFAULT '1',
|
---|
309 | PRIMARY KEY (`Id`),
|
---|
310 | KEY `Host` (`Host`),
|
---|
311 | CONSTRAINT `Logon_ibfk_1` FOREIGN KEY (`Host`) REFERENCES `Host` (`Id`)
|
---|
312 | ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
|
---|
313 |
|
---|
314 | -- Exportování dat pro tabulku wow_web.Logon: ~1 rows (přibližně)
|
---|
315 | /*!40000 ALTER TABLE `Logon` DISABLE KEYS */;
|
---|
316 | INSERT INTO `Logon` (`Id`, `Host`, `DatabaseUser`, `DatabasePassword`, `DatabaseHost`, `DatabaseRealmd`, `ClientVersion`, `Port`, `Online`, `Name`, `Enabled`) VALUES
|
---|
317 | (1, 3, 'wow', 'tenkyprut', 'localhost', 'wow_auth', '4.3.4', 3724, 0, 'Hlavní', 1);
|
---|
318 | /*!40000 ALTER TABLE `Logon` ENABLE KEYS */;
|
---|
319 |
|
---|
320 |
|
---|
321 | -- Exportování struktury pro tabulka wow_web.Realm
|
---|
322 | CREATE TABLE IF NOT EXISTS `Realm` (
|
---|
323 | `Id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
324 | `Host` int(11) NOT NULL,
|
---|
325 | `Logon` int(11) NOT NULL,
|
---|
326 | `DatabaseHost` varchar(255) NOT NULL,
|
---|
327 | `DatabaseUser` varchar(255) NOT NULL,
|
---|
328 | `DatabasePassword` varchar(255) NOT NULL,
|
---|
329 | `DatabaseCharacters` varchar(255) NOT NULL,
|
---|
330 | `DatabaseMangos` varchar(255) NOT NULL,
|
---|
331 | `DatabaseScriptDev2` varchar(255) NOT NULL,
|
---|
332 | `MaxOnlinePlayers` int(11) NOT NULL,
|
---|
333 | `Rate` varchar(255) NOT NULL,
|
---|
334 | `Type` varchar(255) NOT NULL,
|
---|
335 | `Name` varchar(255) NOT NULL,
|
---|
336 | `Description` text NOT NULL,
|
---|
337 | `Online` int(11) NOT NULL DEFAULT '0',
|
---|
338 | `Port` int(11) NOT NULL,
|
---|
339 | `Enabled` int(11) NOT NULL DEFAULT '1',
|
---|
340 | `Information` text NOT NULL,
|
---|
341 | `Locale` varchar(255) NOT NULL,
|
---|
342 | PRIMARY KEY (`Id`),
|
---|
343 | UNIQUE KEY `Port` (`Port`),
|
---|
344 | KEY `Host` (`Host`),
|
---|
345 | KEY `Logon` (`Logon`),
|
---|
346 | CONSTRAINT `Realm_ibfk_1` FOREIGN KEY (`Host`) REFERENCES `Host` (`Id`),
|
---|
347 | CONSTRAINT `Realm_ibfk_2` FOREIGN KEY (`Logon`) REFERENCES `Logon` (`Id`)
|
---|
348 | ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
|
---|
349 |
|
---|
350 | -- Exportování dat pro tabulku wow_web.Realm: ~1 rows (přibližně)
|
---|
351 | /*!40000 ALTER TABLE `Realm` DISABLE KEYS */;
|
---|
352 | INSERT INTO `Realm` (`Id`, `Host`, `Logon`, `DatabaseHost`, `DatabaseUser`, `DatabasePassword`, `DatabaseCharacters`, `DatabaseMangos`, `DatabaseScriptDev2`, `MaxOnlinePlayers`, `Rate`, `Type`, `Name`, `Description`, `Online`, `Port`, `Enabled`, `Information`, `Locale`) VALUES
|
---|
353 | (3, 3, 1, 'localhost', 'wow', 'tenkyprut', 'wow_characters', 'wow_world', '', 100, '1x', 'normal', 'Virtuál', 'ssdasdas asd as dsa dasd', 0, 8081, 1, '', 'csCZ');
|
---|
354 | /*!40000 ALTER TABLE `Realm` ENABLE KEYS */;
|
---|
355 |
|
---|
356 |
|
---|
357 | -- Exportování struktury pro tabulka wow_web.users
|
---|
358 | CREATE TABLE IF NOT EXISTS `users` (
|
---|
359 | `id` int(11) NOT NULL AUTO_INCREMENT,
|
---|
360 | `realmd_id` int(11) NOT NULL DEFAULT '0',
|
---|
361 | `name` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
|
---|
362 | PRIMARY KEY (`id`)
|
---|
363 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
---|
364 |
|
---|
365 | -- Exportování dat pro tabulku wow_web.users: ~0 rows (přibližně)
|
---|
366 | /*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
---|
367 | /*!40000 ALTER TABLE `users` ENABLE KEYS */;
|
---|
368 | /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
|
---|
369 | /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
|
---|
370 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
---|