source: trunk/sql/structure.sql

Last change on this file was 712, checked in by chronos, 11 years ago
  • Upraveno: Aktualizace inicializačního skriptu pro sql databázi na revizi 710.
  • Upraveno: Aktualizována třída Database na novější využívající třídu PDO a generující výjímky při chybě, které je pak nutno očetřit.
  • Property svn:executable set to *
File size: 15.6 KB
Line 
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
14CREATE 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
33CREATE 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 */;
41INSERT 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
50CREATE 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
62CREATE 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 */;
71INSERT 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
102CREATE 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
116CREATE 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 */;
124INSERT INTO `DbVersion` (
125`Id` ,
126`Revision`
127)
128VALUES (
129NULL , '710'
130);
131/*!40000 ALTER TABLE `DbVersion` ENABLE KEYS */;
132
133
134-- Exportování struktury pro tabulka wow_web.File
135CREATE 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
153CREATE 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 */;
161INSERT 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
168CREATE 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
184CREATE 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
197CREATE 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
217CREATE 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
233CREATE 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
246CREATE 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
262CREATE 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
276CREATE 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 */;
291INSERT 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
297CREATE 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 */;
316INSERT 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
322CREATE 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 */;
352INSERT 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
358CREATE 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 */;
Note: See TracBrowser for help on using the repository browser.