RLtdHdRg

1-- phpMyAdmin SQL Dump
2-- version home.pl
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 22 Gru 2016, 13:36
7-- Wersja serwera: 5.5.51-38.1-log
8-- Wersja PHP: 5.2.17
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 utf8 */;
18
19--
20-- Baza danych: `17757354_rpg`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `Atut`
27--
28
29CREATE TABLE IF NOT EXISTS `Atut` (
30  `IdAtutu` int(11) NOT NULL AUTO_INCREMENT,
31  `IdKlasyAtutu` int(11) NOT NULL,
32  `NazwaAtutu` char(255) NOT NULL,
33  `OpisAtutu` text NOT NULL,
34  PRIMARY KEY (`IdAtutu`),
35  KEY `FK_CechujeSie` (`IdKlasyAtutu`)
36) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=137 ;
37
38--
39-- Zrzut danych tabeli `Atut`
40--
41
42INSERT INTO `Atut` (`IdAtutu`, `IdKlasyAtutu`, `NazwaAtutu`, `OpisAtutu`) VALUES
43(128, 65, 'Animal Affinity', 'You get a +2 bonus on all Handle Animal checks and Ride checks.'),
44(129, 68, 'Armor Proficiency (light)', 'You are proficient with light armor (see Table 7-6: Armor and Shields, page 123).'),
45(130, 65, 'Armor Proficiency (medium)', 'You are proficient with medium armor (see Table 7-6: Armor and Shields, page 123).'),
46(131, 67, 'Brew Potion', 'You can create potions, which carry spells within themselves. See the Dungeon Masters Guide for rules on potions.'),
47(132, 68, 'Athletic', 'You get a +2 bonus on all Climb checks and Swim checks.'),
48(133, 68, 'Armor Proficiency (heavy)', 'You are proficient with heavy armor (see Table 7-6: Armor and Shields, page 123).'),
49(134, 66, 'Augment Summoning', 'Each creature you conjure with any summon spell gains a +4 enhancement bonus to Strength and Constitution for the duration of the spell that summoned it.'),
50(135, 68, 'Combat Casting', 'You are adept at casting spells in combat.'),
51(136, 68, 'Acrobatic', 'You get a +2 bonus on all Jump checks and Tumble checks.');
52
53-- --------------------------------------------------------
54
55--
56-- Struktura tabeli dla tabeli `AtutZaPoziom`
57--
58
59CREATE TABLE IF NOT EXISTS `AtutZaPoziom` (
60  `IdAtutu` int(11) NOT NULL,
61  `IdPoziomu` int(11) NOT NULL,
62  PRIMARY KEY (`IdAtutu`,`IdPoziomu`),
63  KEY `FK_DajeAtut` (`IdPoziomu`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin2;
65
66--
67-- Zrzut danych tabeli `AtutZaPoziom`
68--
69
70INSERT INTO `AtutZaPoziom` (`IdAtutu`, `IdPoziomu`) VALUES
71(128, 1),
72(132, 1);
73
74-- --------------------------------------------------------
75
76--
77-- Struktura tabeli dla tabeli `Bostwo`
78--
79
80CREATE TABLE IF NOT EXISTS `Bostwo` (
81  `IdBostwa` int(11) NOT NULL AUTO_INCREMENT,
82  `NazwaBostwa` char(255) NOT NULL,
83  `OpisBostwa` text NOT NULL,
84  PRIMARY KEY (`IdBostwa`)
85) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=98 ;
86
87--
88-- Zrzut danych tabeli `Bostwo`
89--
90
91INSERT INTO `Bostwo` (`IdBostwa`, `NazwaBostwa`, `OpisBostwa`) VALUES
92(90, 'Giraffe Lonesome', '-'),
93(91, 'Hungry Cougar', '-'),
94(92, 'Stony Goldfish', '-'),
95(93, 'Black Horse', '-'),
96(94, 'Helpless Tapir', '-'),
97(95, 'The Cockroach', '-'),
98(96, 'Bear Drunken', '-'),
99(97, 'Black Giraffe', '-');
100
101-- --------------------------------------------------------
102
103--
104-- Struktura tabeli dla tabeli `Gracz`
105--
106
107CREATE TABLE IF NOT EXISTS `Gracz` (
108  `IdGracza` int(11) NOT NULL AUTO_INCREMENT,
109  `NazwaGracza` char(255) NOT NULL,
110  PRIMARY KEY (`IdGracza`)
111) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=176 ;
112
113--
114-- Zrzut danych tabeli `Gracz`
115--
116
117INSERT INTO `Gracz` (`IdGracza`, `NazwaGracza`) VALUES
118(161, 'Game Master'),
119(162, 'Crazy Solid Frog'),
120(163, 'Baby Doctor'),
121(164, 'Green Devil'),
122(165, 'Lovebird Ruthless'),
123(166, 'The Finch'),
124(167, 'Hog Bad'),
125(168, 'Drunken Coyote'),
126(169, 'Indigo Pilot'),
127(170, 'Needless Pig'),
128(171, 'The Beam'),
129(172, 'Major Opossum'),
130(173, 'Brave Eaglet'),
131(174, 'Pup Willy'),
132(175, 'Moose Rusty');
133
134-- --------------------------------------------------------
135
136--
137-- Struktura tabeli dla tabeli `Klasa`
138--
139
140CREATE TABLE IF NOT EXISTS `Klasa` (
141  `IdKlasy` int(11) NOT NULL AUTO_INCREMENT,
142  `NazwaKlasy` char(255) NOT NULL,
143  `KostkaZdrowia` char(255) NOT NULL,
144  `OpisKlasy` text NOT NULL,
145  PRIMARY KEY (`IdKlasy`)
146) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=121 ;
147
148--
149-- Zrzut danych tabeli `Klasa`
150--
151
152INSERT INTO `Klasa` (`IdKlasy`, `NazwaKlasy`, `KostkaZdrowia`, `OpisKlasy`) VALUES
153(113, 'Monk', 'd8', 'Weapon and Armor Proficiency: Monks are proficient with certain basic peasant weapons and some special weapons that are part of monk training. The weapons with which a monk is proficient are club, crossbow (light or heavy), dagger, handaxe, javelin, kama, nunchaku, quarterstaff, sai, shuriken, siangham, and sling. (See Chapter 7: Equipment for descriptions of these weapons.) Monks are not proficient with any armor or shields—in fact, many of the monks special powers require unfettered movement. When wearing armor, using a shield, or carrying a medium or heavy load, a monk loses her AC bonus, as well as her fast movement and flurry of blows abilities.'),
154(114, 'Sorcerer', 'd4', 'Weapon and Armor Proficiency: Sorcerers are proficient with all simple weapons. They are not proficient with any type of armor or shield. Armor of any type interferes with a sorcerers arcane gestures, which can cause his spells with somatic components to fail.'),
155(115, 'Rogue', 'd6', 'Weapon and Armor Proficiency: Rogues are proficient with all simple weapons, plus the hand crossbow, rapier, sap, shortbow, and short sword. Rogues are proficient with light armor, but not with shields.'),
156(116, 'Ranger', 'd8', 'Weapon and Armor Proficiency: A ranger is proficient with all simple and martial weapons, and with light armor and shields (except tower shields).'),
157(117, 'Paladin', 'd10', 'Weapon and Armor Proficiency: Paladins are proficient with all simple and martial weapons, with all types of armor (heavy, medium, and light), and with shields (except tower shields).'),
158(118, 'Bard', 'd6', 'Weapon and Armor Proficiency: A bard is proficient with all simple weapons, plus the longsword, rapier, sap, short sword, shortbow, and whip. Bards are proficient with light armor and shields (except tower shields).'),
159(119, 'Druid', 'd8', 'Weapon and Armor Proficiency: Druids are proficient with the following weapons: club, dagger, dart, quarterstaff, scimitar, sickle, shortspear, sling, and spear. They are also proficient with all natural attacks (claw, bite, and so forth) of any form they assume with wild shape (see below).'),
160(120, 'Cleric', 'd8', 'Weapon and Armor Proficiency: Clerics are proficient with all simple weapons, with all types of armor (light, medium, and heavy), and with shields (except tower shields).');
161
162-- --------------------------------------------------------
163
164--
165-- Struktura tabeli dla tabeli `KlasaAtutu`
166--
167
168CREATE TABLE IF NOT EXISTS `KlasaAtutu` (
169  `IdKlasyAtutu` int(11) NOT NULL AUTO_INCREMENT,
170  `NazwaKlasyAtutu` char(255) NOT NULL,
171  PRIMARY KEY (`IdKlasyAtutu`)
172) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=69 ;
173
174--
175-- Zrzut danych tabeli `KlasaAtutu`
176--
177
178INSERT INTO `KlasaAtutu` (`IdKlasyAtutu`, `NazwaKlasyAtutu`) VALUES
179(65, 'General'),
180(66, 'Martial'),
181(67, 'Magic'),
182(68, 'Expert');
183
184-- --------------------------------------------------------
185
186--
187-- Struktura tabeli dla tabeli `Lokacja`
188--
189
190CREATE TABLE IF NOT EXISTS `Lokacja` (
191  `IdLokacji` int(11) NOT NULL AUTO_INCREMENT,
192  `NazwaLokacji` char(255) NOT NULL,
193  `OpisLokacji` text,
194  PRIMARY KEY (`IdLokacji`)
195) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=3300 ;
196
197--
198-- Zrzut danych tabeli `Lokacja`
199--
200
201INSERT INTO `Lokacja` (`IdLokacji`, `NazwaLokacji`, `OpisLokacji`) VALUES
202(3105, 'Unpleasant Abyss of Destiny', '-'),
203(3106, 'Dark Meadow of Death', '-'),
204(3107, 'Evil Dungeon of Darkness', '-'),
205(3108, 'Spooky Pit of Doom', '-'),
206(3109, 'Astral Dungeon of Endlessness', '-'),
207(3110, 'Spooky Cavern of Annihilation', '-'),
208(3111, 'Unpleasant Meadow of Destiny', '-'),
209(3112, 'Astral Meadow of Death', '-'),
210(3113, 'Dark Abyss of Destiny', '-'),
211(3114, 'Evil Meadow of Doom', '-'),
212(3115, 'Utterdark Meadow of Darkness', '-'),
213(3116, 'Unpleasant Pit of Destiny', '-'),
214(3117, 'Spooky Pit of Darkness', '-'),
215(3118, 'Astral Abyss of Endlessness', '-'),
216(3119, 'Unpleasant Dungeon of Darkness', '-'),
217(3120, 'Unpleasant Dungeon of Doom', '-'),
218(3121, 'Utterdark Abyss of Endlessness', '-'),
219(3122, 'Astral Pit of Darkness', '-'),
220(3123, 'Unpleasant Cavern of Death', '-'),
221(3124, 'Astral Dungeon of Annihilation', '-'),
222(3125, 'Unpleasant Meadow of Doom', '-'),
223(3126, 'Utterdark Pit of Annihilation', '-'),
224(3127, 'Astral Dungeon of Destiny', '-'),
225(3128, 'Spooky Tomb of Destiny', '-'),
226(3129, 'Spooky Dungeon of Death', '-'),
227(3130, 'Spooky Tomb of Death', '-'),
228(3131, 'Astral Tomb of Annihilation', '-'),
229(3132, 'Utterdark Tomb of Death', '-'),
230(3133, 'Spooky Meadow of Death', '-'),
231(3134, 'Unpleasant Tomb of Doom', '-'),
232(3135, 'Evil Pit of Darkness', '-'),
233(3136, 'Evil Cavern of Destiny', '-'),
234(3137, 'Evil Meadow of Darkness', '-'),
235(3138, 'Dark Meadow of Darkness', '-'),
236(3139, 'Astral Cavern of Annihilation', '-'),
237(3140, 'Evil Abyss of Destiny', '-'),
238(3141, 'Spooky Tomb of Endlessness', '-'),
239(3142, 'Astral Dungeon of Endlessness', '-'),
240(3143, 'Dark Pit of Darkness', '-'),
241(3144, 'Utterdark Pit of Annihilation', '-'),
242(3145, 'Spooky Abyss of Destiny', '-'),
243(3146, 'Unpleasant Pit of Darkness', '-'),
244(3147, 'Spooky Tomb of Annihilation', '-'),
245(3148, 'Dark Cavern of Death', '-'),
246(3149, 'Utterdark Meadow of Death', '-'),
247(3150, 'Astral Cavern of Endlessness', '-'),
248(3151, 'Unpleasant Meadow of Annihilation', '-'),
249(3152, 'Utterdark Pit of Death', '-'),
250(3153, 'Utterdark Pit of Annihilation', '-'),
251(3154, 'Utterdark Pit of Doom', '-'),
252(3155, 'Spooky Cavern of Destiny', '-'),
253(3156, 'Dark Dungeon of Annihilation', '-'),
254(3157, 'Unpleasant Abyss of Darkness', '-'),
255(3158, 'Dark Cavern of Death', '-'),
256(3159, 'Evil Dungeon of Annihilation', '-'),
257(3160, 'Evil Abyss of Doom', '-'),
258(3161, 'Unpleasant Pit of Darkness', '-'),
259(3162, 'Spooky Meadow of Death', '-'),
260(3163, 'Unpleasant Abyss of Endlessness', '-'),
261(3164, 'Utterdark Pit of Doom', '-'),
262(3165, 'Utterdark Dungeon of Doom', '-'),
263(3166, 'Evil Pit of Annihilation', '-'),
264(3167, 'Utterdark Abyss of Destiny', '-'),
265(3168, 'Astral Abyss of Destiny', '-'),
266(3169, 'Dark Dungeon of Death', '-'),
267(3170, 'Dark Cavern of Annihilation', '-'),
268(3171, 'Dark Cavern of Destiny', '-'),
269(3172, 'Spooky Tomb of Destiny', '-'),
270(3173, 'Astral Tomb of Doom', '-'),
271(3174, 'Evil Pit of Endlessness', '-'),
272(3175, 'Dark Pit of Endlessness', '-'),
273(3176, 'Evil Tomb of Darkness', '-'),
274(3177, 'Evil Meadow of Destiny', '-'),
275(3178, 'Dark Pit of Death', '-'),
276(3179, 'Astral Cavern of Darkness', '-'),
277(3180, 'Dark Tomb of Doom', '-'),
278(3181, 'Dark Abyss of Destiny', '-'),
279(3182, 'Utterdark Abyss of Annihilation', '-'),
280(3183, 'Spooky Meadow of Death', '-'),
281(3184, 'Evil Abyss of Darkness', '-'),
282(3185, 'Dark Abyss of Endlessness', '-'),
283(3186, 'Astral Meadow of Annihilation', '-'),
284(3187, 'Evil Tomb of Endlessness', '-'),
285(3188, 'Unpleasant Dungeon of Doom', '-'),
286(3189, 'Spooky Dungeon of Destiny', '-'),
287(3190, 'Unpleasant Dungeon of Destiny', '-'),
288(3191, 'Astral Tomb of Darkness', '-'),
289(3192, 'Spooky Dungeon of Annihilation', '-'),
290(3193, 'Utterdark Cavern of Doom', '-'),
291(3194, 'Astral Meadow of Destiny', '-'),
292(3195, 'Dark Abyss of Doom', '-'),
293(3196, 'Astral Tomb of Darkness', '-'),
294(3197, 'Evil Abyss of Death', '-'),
295(3198, 'Astral Meadow of Doom', '-'),
296(3199, 'Unpleasant Abyss of Death', '-'),
297(3200, 'Utterdark Abyss of Doom', '-'),
298(3201, 'Evil Pit of Doom', '-'),
299(3202, 'Spooky Abyss of Endlessness', '-'),
300(3203, 'Utterdark Tomb of Doom', '-'),
301(3204, 'Utterdark Abyss of Doom', '-'),
302(3205, 'Evil Pit of Endlessness', '-'),
303(3206, 'Unpleasant Cavern of Doom', '-'),
304(3207, 'Astral Abyss of Destiny', '-'),
305(3208, 'Astral Abyss of Darkness', '-'),
306(3209, 'Unpleasant Pit of Death', '-'),
307(3210, 'Utterdark Dungeon of Darkness', '-'),
308(3211, 'Evil Abyss of Darkness', '-'),
309(3212, 'Astral Meadow of Death', '-'),
310(3213, 'Evil Cavern of Doom', '-'),
311(3214, 'Evil Pit of Doom', '-'),
312(3215, 'Dark Abyss of Death', '-'),
313(3216, 'Spooky Abyss of Darkness', '-'),
314(3217, 'Unpleasant Abyss of Destiny', '-'),
315(3218, 'Dark Tomb of Death', '-'),
316(3219, 'Astral Cavern of Death', '-'),
317(3220, 'Astral Abyss of Endlessness', '-'),
318(3221, 'Evil Meadow of Endlessness', '-'),
319(3222, 'Utterdark Meadow of Destiny', '-'),
320(3223, 'Dark Dungeon of Destiny', '-'),
321(3224, 'Dark Dungeon of Darkness', '-'),
322(3225, 'Dark Cavern of Death', '-'),
323(3226, 'Utterdark Pit of Darkness', '-'),
324(3227, 'Spooky Dungeon of Endlessness', '-'),
325(3228, 'Unpleasant Meadow of Annihilation', '-'),
326(3229, 'Unpleasant Tomb of Doom', '-'),
327(3230, 'Spooky Meadow of Annihilation', '-'),
328(3231, 'Spooky Abyss of Death', '-'),
329(3232, 'Spooky Meadow of Destiny', '-'),
330(3233, 'Evil Cavern of Destiny', '-'),
331(3234, 'Utterdark Cavern of Death', '-'),
332(3235, 'Spooky Cavern of Endlessness', '-'),
333(3236, 'Evil Cavern of Destiny', '-'),
334(3237, 'Utterdark Pit of Annihilation', '-'),
335(3238, 'Astral Meadow of Death', '-'),
336(3239, 'Astral Tomb of Endlessness', '-'),
337(3240, 'Unpleasant Abyss of Annihilation', '-'),
338(3241, 'Dark Tomb of Doom', '-'),
339(3242, 'Utterdark Meadow of Destiny', '-'),
340(3243, 'Dark Abyss of Annihilation', '-'),
341(3244, 'Spooky Abyss of Darkness', '-'),
342(3245, 'Spooky Meadow of Darkness', '-'),
343(3246, 'Evil Cavern of Doom', '-'),
344(3247, 'Utterdark Pit of Death', '-'),
345(3248, 'Astral Meadow of Darkness', '-'),
346(3249, 'Utterdark Tomb of Death', '-'),
347(3250, 'Evil Dungeon of Endlessness', '-'),
348(3251, 'Utterdark Abyss of Destiny', '-'),
349(3252, 'Evil Dungeon of Destiny', '-'),
350(3253, 'Astral Pit of Darkness', '-'),
351(3254, 'Utterdark Meadow of Endlessness', '-'),
352(3255, 'Utterdark Cavern of Endlessness', '-'),
353(3256, 'Astral Abyss of Destiny', '-'),
354(3257, 'Dark Pit of Endlessness', '-'),
355(3258, 'Dark Pit of Darkness', '-'),
356(3259, 'Unpleasant Pit of Annihilation', '-'),
357(3260, 'Evil Dungeon of Destiny', '-'),
358(3261, 'Spooky Abyss of Endlessness', '-'),
359(3262, 'Unpleasant Dungeon of Doom', '-'),
360(3263, 'Utterdark Cavern of Death', '-'),
361(3264, 'Evil Cavern of Destiny', '-'),
362(3265, 'Spooky Tomb of Endlessness', '-'),
363(3266, 'Evil Cavern of Destiny', '-'),
364(3267, 'Spooky Abyss of Destiny', '-'),
365(3268, 'Spooky Pit of Endlessness', '-'),
366(3269, 'Dark Abyss of Death', '-'),
367(3270, 'Spooky Meadow of Darkness', '-'),
368(3271, 'Utterdark Cavern of Destiny', '-'),
369(3272, 'Utterdark Tomb of Destiny', '-'),
370(3273, 'Utterdark Cavern of Death', '-'),
371(3274, 'Utterdark Dungeon of Destiny', '-'),
372(3275, 'Unpleasant Cavern of Annihilation', '-'),
373(3276, 'Spooky Tomb of Darkness', '-'),
374(3277, 'Evil Tomb of Doom', '-'),
375(3278, 'Utterdark Dungeon of Destiny', '-'),
376(3279, 'Astral Abyss of Doom', '-'),
377(3280, 'Evil Cavern of Endlessness', '-'),
378(3281, 'Evil Pit of Darkness', '-'),
379(3282, 'Dark Cavern of Death', '-'),
380(3283, 'Spooky Pit of Endlessness', '-'),
381(3284, 'Unpleasant Pit of Endlessness', '-'),
382(3285, 'Dark Abyss of Destiny', '-'),
383(3286, 'Evil Pit of Darkness', '-'),
384(3287, 'Spooky Abyss of Annihilation', '-'),
385(3288, 'Evil Tomb of Darkness', '-'),
386(3289, 'Unpleasant Meadow of Darkness', '-'),
387(3290, 'Evil Dungeon of Doom', '-'),
388(3291, 'Utterdark Tomb of Endlessness', '-'),
389(3292, 'Evil Abyss of Destiny', '-'),
390(3293, 'Dark Pit of Destiny', '-'),
391(3294, 'Astral Abyss of Annihilation', '-'),
392(3295, 'Unpleasant Pit of Darkness', '-'),
393(3296, 'Unpleasant Pit of Destiny', '-'),
394(3297, 'Dark Meadow of Endlessness', '-'),
395(3298, 'Unpleasant Tomb of Death', '-'),
396(3299, 'Test', 'test');
397
398-- --------------------------------------------------------
399
400--
401-- Struktura tabeli dla tabeli `Pochodzenie`
402--
403
404CREATE TABLE IF NOT EXISTS `Pochodzenie` (
405  `IdPochodzenia` int(11) NOT NULL AUTO_INCREMENT,
406  `NazwaPochodzenia` char(255) NOT NULL,
407  `OpisPochodzenia` text NOT NULL,
408  PRIMARY KEY (`IdPochodzenia`)
409) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=2329 ;
410
411--
412-- Zrzut danych tabeli `Pochodzenie`
413--
414
415INSERT INTO `Pochodzenie` (`IdPochodzenia`, `NazwaPochodzenia`, `OpisPochodzenia`) VALUES
416(2135, 'Unpleasant Pit of Darkness', '-'),
417(2136, 'Evil Dungeon of Doom', '-'),
418(2137, 'Evil Tomb of Death', '-'),
419(2138, 'Spooky Cavern of Doom', '-'),
420(2139, 'Dark Cavern of Destiny', '-'),
421(2140, 'Utterdark Meadow of Destiny', '-'),
422(2141, 'Dark Pit of Annihilation', '-'),
423(2142, 'Dark Cavern of Darkness', '-'),
424(2143, 'Evil Cavern of Darkness', '-'),
425(2144, 'Evil Tomb of Death', '-'),
426(2145, 'Spooky Tomb of Darkness', '-'),
427(2146, 'Spooky Dungeon of Endlessness', '-'),
428(2147, 'Dark Pit of Annihilation', '-'),
429(2148, 'Evil Pit of Doom', '-'),
430(2149, 'Spooky Pit of Destiny', '-'),
431(2150, 'Astral Dungeon of Death', '-'),
432(2151, 'Spooky Abyss of Destiny', '-'),
433(2152, 'Spooky Cavern of Darkness', '-'),
434(2153, 'Unpleasant Meadow of Annihilation', '-'),
435(2154, 'Astral Abyss of Doom', '-'),
436(2155, 'Unpleasant Cavern of Darkness', '-'),
437(2156, 'Spooky Abyss of Annihilation', '-'),
438(2157, 'Unpleasant Pit of Death', '-'),
439(2158, 'Unpleasant Abyss of Darkness', '-'),
440(2159, 'Evil Pit of Annihilation', '-'),
441(2160, 'Spooky Dungeon of Death', '-'),
442(2161, 'Utterdark Pit of Darkness', '-'),
443(2162, 'Dark Meadow of Death', '-'),
444(2163, 'Utterdark Pit of Endlessness', '-'),
445(2164, 'Utterdark Dungeon of Death', '-'),
446(2165, 'Unpleasant Pit of Endlessness', '-'),
447(2166, 'Dark Abyss of Destiny', '-'),
448(2167, 'Evil Abyss of Destiny', '-'),
449(2168, 'Evil Pit of Death', '-'),
450(2169, 'Spooky Pit of Destiny', '-'),
451(2170, 'Evil Cavern of Endlessness', '-'),
452(2171, 'Spooky Meadow of Doom', '-'),
453(2172, 'Spooky Tomb of Darkness', '-'),
454(2173, 'Astral Dungeon of Endlessness', '-'),
455(2174, 'Spooky Dungeon of Endlessness', '-'),
456(2175, 'Evil Meadow of Death', '-'),
457(2176, 'Dark Tomb of Death', '-'),
458(2177, 'Dark Meadow of Doom', '-'),
459(2178, 'Evil Abyss of Destiny', '-'),
460(2179, 'Unpleasant Cavern of Doom', '-'),
461(2180, 'Evil Abyss of Darkness', '-'),
462(2181, 'Astral Abyss of Doom', '-'),
463(2182, 'Dark Cavern of Annihilation', '-'),
464(2183, 'Spooky Dungeon of Destiny', '-'),
465(2184, 'Spooky Abyss of Destiny', '-'),
466(2185, 'Spooky Dungeon of Destiny', '-'),
467(2186, 'Astral Pit of Endlessness', '-'),
468(2187, 'Spooky Tomb of Endlessness', '-'),
469(2188, 'Utterdark Dungeon of Doom', '-'),
470(2189, 'Utterdark Dungeon of Darkness', '-'),
471(2190, 'Dark Abyss of Death', '-'),
472(2191, 'Unpleasant Pit of Endlessness', '-'),
473(2192, 'Utterdark Pit of Destiny', '-'),
474(2193, 'Astral Meadow of Death', '-'),
475(2194, 'Dark Pit of Destiny', '-'),
476(2195, 'Unpleasant Tomb of Darkness', '-'),
477(2196, 'Utterdark Cavern of Doom', '-'),
478(2197, 'Spooky Pit of Death', '-'),
479(2198, 'Evil Cavern of Endlessness', '-'),
480(2199, 'Evil Dungeon of Death', '-'),
481(2200, 'Dark Meadow of Annihilation', '-'),
482(2201, 'Dark Abyss of Death', '-'),
483(2202, 'Spooky Meadow of Destiny', '-'),
484(2203, 'Utterdark Tomb of Destiny', '-'),
485(2204, 'Dark Meadow of Endlessness', '-'),
486(2205, 'Astral Abyss of Annihilation', '-'),
487(2206, 'Unpleasant Abyss of Doom', '-'),
488(2207, 'Astral Pit of Darkness', '-'),
489(2208, 'Utterdark Abyss of Death', '-'),
490(2209, 'Evil Cavern of Destiny', '-'),
491(2210, 'Evil Cavern of Destiny', '-'),
492(2211, 'Unpleasant Meadow of Doom', '-'),
493(2212, 'Utterdark Dungeon of Darkness', '-'),
494(2213, 'Astral Pit of Endlessness', '-'),
495(2214, 'Spooky Meadow of Darkness', '-'),
496(2215, 'Unpleasant Tomb of Destiny', '-'),
497(2216, 'Evil Dungeon of Destiny', '-'),
498(2217, 'Astral Pit of Destiny', '-'),
499(2218, 'Utterdark Dungeon of Endlessness', '-'),
500(2219, 'Spooky Abyss of Darkness', '-'),
501(2220, 'Utterdark Cavern of Annihilation', '-'),
502(2221, 'Unpleasant Abyss of Annihilation', '-'),
503(2222, 'Evil Tomb of Endlessness', '-'),
504(2223, 'Utterdark Cavern of Endlessness', '-'),
505(2224, 'Unpleasant Meadow of Destiny', '-'),
506(2225, 'Astral Abyss of Darkness', '-'),
507(2226, 'Unpleasant Abyss of Endlessness', '-'),
508(2227, 'Unpleasant Tomb of Doom', '-'),
509(2228, 'Astral Pit of Death', '-'),
510(2229, 'Utterdark Meadow of Destiny', '-'),
511(2230, 'Dark Dungeon of Destiny', '-'),
512(2231, 'Unpleasant Pit of Annihilation', '-'),
513(2232, 'Spooky Dungeon of Annihilation', '-'),
514(2233, 'Astral Pit of Destiny', '-'),
515(2234, 'Spooky Meadow of Darkness', '-'),
516(2235, 'Utterdark Tomb of Annihilation', '-'),
517(2236, 'Unpleasant Abyss of Death', '-'),
518(2237, 'Evil Meadow of Doom', '-'),
519(2238, 'Unpleasant Dungeon of Endlessness', '-'),
520(2239, 'Astral Dungeon of Annihilation', '-'),
521(2240, 'Dark Tomb of Endlessness', '-'),
522(2241, 'Dark Pit of Endlessness', '-'),
523(2242, 'Evil Pit of Doom', '-'),
524(2243, 'Evil Meadow of Endlessness', '-'),
525(2244, 'Unpleasant Abyss of Endlessness', '-'),
526(2245, 'Utterdark Abyss of Annihilation', '-'),
527(2246, 'Dark Pit of Endlessness', '-'),
528(2247, 'Spooky Cavern of Death', '-'),
529(2248, 'Utterdark Cavern of Death', '-'),
530(2249, 'Utterdark Cavern of Darkness', '-'),
531(2250, 'Spooky Meadow of Doom', '-'),
532(2251, 'Utterdark Cavern of Doom', '-'),
533(2252, 'Spooky Tomb of Death', '-'),
534(2253, 'Spooky Cavern of Darkness', '-'),
535(2254, 'Utterdark Tomb of Annihilation', '-'),
536(2255, 'Astral Pit of Endlessness', '-'),
537(2256, 'Dark Abyss of Doom', '-'),
538(2257, 'Evil Cavern of Destiny', '-'),
539(2258, 'Dark Tomb of Annihilation', '-'),
540(2259, 'Utterdark Tomb of Death', '-'),
541(2260, 'Unpleasant Abyss of Death', '-'),
542(2261, 'Spooky Abyss of Death', '-'),
543(2262, 'Spooky Pit of Endlessness', '-'),
544(2263, 'Spooky Abyss of Annihilation', '-'),
545(2264, 'Spooky Dungeon of Endlessness', '-'),
546(2265, 'Utterdark Meadow of Endlessness', '-'),
547(2266, 'Unpleasant Cavern of Darkness', '-'),
548(2267, 'Astral Meadow of Doom', '-'),
549(2268, 'Astral Meadow of Darkness', '-'),
550(2269, 'Astral Abyss of Doom', '-'),
551(2270, 'Utterdark Tomb of Annihilation', '-'),
552(2271, 'Utterdark Meadow of Endlessness', '-'),
553(2272, 'Dark Tomb of Doom', '-'),
554(2273, 'Astral Cavern of Annihilation', '-'),
555(2274, 'Dark Dungeon of Annihilation', '-'),
556(2275, 'Utterdark Abyss of Darkness', '-'),
557(2276, 'Utterdark Tomb of Endlessness', '-'),
558(2277, 'Dark Dungeon of Annihilation', '-'),
559(2278, 'Spooky Dungeon of Endlessness', '-'),
560(2279, 'Utterdark Dungeon of Death', '-'),
561(2280, 'Evil Cavern of Annihilation', '-'),
562(2281, 'Evil Abyss of Endlessness', '-'),
563(2282, 'Dark Dungeon of Annihilation', '-'),
564(2283, 'Evil Abyss of Annihilation', '-'),
565(2284, 'Spooky Meadow of Doom', '-'),
566(2285, 'Unpleasant Pit of Destiny', '-'),
567(2286, 'Dark Abyss of Annihilation', '-'),
568(2287, 'Utterdark Abyss of Annihilation', '-'),
569(2288, 'Astral Pit of Endlessness', '-'),
570(2289, 'Dark Cavern of Death', '-'),
571(2290, 'Utterdark Tomb of Annihilation', '-'),
572(2291, 'Evil Meadow of Doom', '-'),
573(2292, 'Evil Tomb of Death', '-'),
574(2293, 'Astral Tomb of Darkness', '-'),
575(2294, 'Utterdark Tomb of Death', '-'),
576(2295, 'Utterdark Tomb of Annihilation', '-'),
577(2296, 'Unpleasant Abyss of Darkness', '-'),
578(2297, 'Evil Meadow of Destiny', '-'),
579(2298, 'Unpleasant Pit of Annihilation', '-'),
580(2299, 'Spooky Abyss of Annihilation', '-'),
581(2300, 'Astral Pit of Annihilation', '-'),
582(2301, 'Spooky Meadow of Darkness', '-'),
583(2302, 'Unpleasant Abyss of Destiny', '-'),
584(2303, 'Unpleasant Tomb of Death', '-'),
585(2304, 'Utterdark Dungeon of Darkness', '-'),
586(2305, 'Spooky Pit of Endlessness', '-'),
587(2306, 'Spooky Tomb of Destiny', '-'),
588(2307, 'Evil Dungeon of Endlessness', '-'),
589(2308, 'Astral Dungeon of Death', '-'),
590(2309, 'Dark Dungeon of Destiny', '-'),
591(2310, 'Unpleasant Meadow of Darkness', '-'),
592(2311, 'Evil Meadow of Destiny', '-'),
593(2312, 'Evil Meadow of Annihilation', '-'),
594(2313, 'Spooky Abyss of Doom', '-'),
595(2314, 'Evil Pit of Destiny', '-'),
596(2315, 'Unpleasant Abyss of Annihilation', '-'),
597(2316, 'Evil Pit of Darkness', '-'),
598(2317, 'Evil Meadow of Destiny', '-'),
599(2318, 'Astral Cavern of Darkness', '-'),
600(2319, 'Dark Abyss of Doom', '-'),
601(2320, 'Utterdark Abyss of Annihilation', '-'),
602(2321, 'Spooky Abyss of Annihilation', '-'),
603(2322, 'Utterdark Cavern of Endlessness', '-'),
604(2323, 'Evil Meadow of Doom', '-'),
605(2324, 'Evil Pit of Annihilation', '-'),
606(2325, 'Evil Cavern of Destiny', '-'),
607(2326, 'Utterdark Cavern of Destiny', '-'),
608(2327, 'Unpleasant Meadow of Doom', '-'),
609(2328, 'Astral Cavern of Doom', '-');
610
611-- --------------------------------------------------------
612
613--
614-- Struktura tabeli dla tabeli `Postac`
615--
616
617CREATE TABLE IF NOT EXISTS `Postac` (
618  `IdPostaci` int(11) NOT NULL AUTO_INCREMENT,
619  `Sila` int(11) NOT NULL,
620  `Zrecznosc` int(11) NOT NULL,
621  `Budowa` int(11) NOT NULL,
622  `Inteligencja` int(11) NOT NULL,
623  `Wiedza` int(11) NOT NULL,
624  `Charyzma` int(11) NOT NULL,
625  `AktualneZdrowie` int(11) NOT NULL,
626  `ModyfikatorPancerza` int(11) DEFAULT NULL,
627  `ModyfikatorInicjatywy` int(11) DEFAULT NULL,
628  `RedukcjaObrazen` text,
629  `ModyfikatorWytrwalosci` int(11) DEFAULT NULL,
630  `ModyfikatorRefleksu` int(11) DEFAULT NULL,
631  `ModyfikatorWoli` int(11) DEFAULT NULL,
632  `BazowaPremiaAtaku` int(11) NOT NULL,
633  `OdpornoscNaZaklecia` int(11) DEFAULT NULL,
634  `ModyfikatorZwarcia` int(11) DEFAULT NULL,
635  `Doswiadczenie` int(11) NOT NULL,
636  `Zloto` int(11) NOT NULL,
637  `Poziom` int(11) NOT NULL,
638  `CharakterPostaci` int(11) NOT NULL,
639  `MaksymalneZdrowie` int(11) NOT NULL,
640  `IdSzablonuPostaci` int(11) NOT NULL,
641  `IdLokacji` int(11) NOT NULL,
642  `IdBostwa` int(11) NOT NULL,
643  `IdGracza` int(11) DEFAULT NULL,
644  PRIMARY KEY (`IdPostaci`),
645  KEY `FK_DziedziczySzablon` (`IdSzablonuPostaci`),
646  KEY `FK_Posiada` (`IdGracza`),
647  KEY `FK_Wyznaje` (`IdBostwa`),
648  KEY `FK_ZnajdujeSie` (`IdLokacji`)
649) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=1216 ;
650
651--
652-- Zrzut danych tabeli `Postac`
653--
654
655INSERT INTO `Postac` (`IdPostaci`, `Sila`, `Zrecznosc`, `Budowa`, `Inteligencja`, `Wiedza`, `Charyzma`, `AktualneZdrowie`, `ModyfikatorPancerza`, `ModyfikatorInicjatywy`, `RedukcjaObrazen`, `ModyfikatorWytrwalosci`, `ModyfikatorRefleksu`, `ModyfikatorWoli`, `BazowaPremiaAtaku`, `OdpornoscNaZaklecia`, `ModyfikatorZwarcia`, `Doswiadczenie`, `Zloto`, `Poziom`, `CharakterPostaci`, `MaksymalneZdrowie`, `IdSzablonuPostaci`, `IdLokacji`, `IdBostwa`, `IdGracza`) VALUES
656(1115, 14, 14, 17, 5, 1, 15, 388, 1, 13, '', 13, 21, 3, 5, -1, -1, 32167, 3300, 13, 1, 175, 259, 3109, 94, 172),
657(1116, 8, 12, 5, 14, 19, 6, 567, 2, 16, '', 30, 22, 6, 16, -1, -1, 3968, 32041, 9, 1, 567, 268, 3109, 90, 163),
658(1117, 1, 8, 12, 12, 6, 16, 221, 7, 21, '', 9, 4, 29, 17, -1, -1, 11794, 1504, 30, 1, 506, 270, 3169, 92, 170),
659(1118, 4, 3, 3, 17, 20, 4, 639, 20, 30, '', 30, 3, 2, 16, -1, -1, 1970, 27539, 13, 8, 639, 265, 3141, 95, 173),
660(1119, 10, 1, 14, 14, 9, 17, 379, 20, 28, '', 14, 15, 20, 5, -1, -1, 23198, 26206, 19, 7, 379, 261, 3162, 95, 170),
661(1120, 12, 3, 15, 9, 1, 12, 29, 11, 20, '', 22, 23, 10, 1, -1, -1, 19282, 3816, 11, 5, 939, 268, 3187, 96, 161),
662(1121, 12, 12, 12, 17, 15, 18, 861, 12, 13, '', 7, 2, 5, 17, -1, -1, 21210, 31977, 7, 5, 861, 274, 3143, 91, 172),
663(1122, 4, 12, 10, 11, 4, 10, 76, 19, 14, '', 19, 25, 7, 20, -1, -1, 24673, 6492, 26, 2, 703, 276, 3282, 95, 164),
664(1123, 12, 13, 18, 4, 10, 4, 382, 5, 11, '', 4, 20, 2, 5, -1, -1, 14989, 23302, 26, 6, 670, 268, 3271, 97, 169),
665(1124, 7, 2, 11, 10, 8, 1, 821, 25, 16, '', 11, 30, 14, 19, -1, -1, 6456, 23002, 9, 4, 821, 266, 3277, 91, 165),
666(1125, 14, 15, 4, 2, 9, 13, 15, 1, 11, '', 10, 14, 13, 1, -1, -1, 202, 26532, 13, 4, 408, 261, 3109, 97, 161),
667(1126, 8, 3, 17, 9, 7, 9, 96, 7, 26, '', 19, 21, 29, 11, -1, -1, 14866, 14130, 16, 1, 869, 281, 3287, 95, 174),
668(1127, 9, 19, 17, 12, 15, 12, 864, 21, 13, '', 24, 14, 19, 3, -1, -1, 23324, 8952, 28, 3, 864, 279, 3248, 96, 161),
669(1128, 2, 2, 16, 17, 11, 18, 860, 26, 15, '', 28, 27, 29, 9, -1, -1, 27099, 1934, 14, 1, 860, 262, 3293, 96, 173),
670(1129, 5, 15, 14, 13, 12, 10, 607, 5, 29, '', 15, 1, 17, 10, -1, -1, 9384, 21757, 22, 8, 607, 281, 3109, 92, 163),
671(1130, 5, 11, 3, 20, 1, 8, 556, 29, 9, '', 3, 28, 1, 17, -1, -1, 19803, 28283, 21, 5, 967, 265, 3154, 91, 165),
672(1131, 9, 19, 10, 20, 16, 20, 541, 8, 9, '', 14, 23, 19, 14, -1, -1, 11690, 24520, 22, 5, 599, 268, 3153, 90, 172),
673(1132, 3, 12, 5, 3, 11, 17, 104, 29, 1, '', 10, 2, 1, 14, -1, -1, 17238, 11075, 25, 6, 104, 277, 3217, 95, 175),
674(1133, 6, 13, 8, 9, 2, 9, 112, 29, 24, '', 26, 1, 2, 3, -1, -1, 5791, 12488, 8, 5, 112, 278, 3181, 90, 167),
675(1134, 6, 13, 9, 11, 2, 9, 398, 27, 26, '', 8, 8, 29, 18, -1, -1, 28519, 19031, 15, 7, 398, 277, 3190, 91, 166),
676(1135, 5, 10, 20, 18, 12, 2, 90, 14, 1, '', 11, 10, 29, 13, -1, -1, 27876, 25660, 2, 9, 247, 265, 3176, 95, 163),
677(1136, 19, 8, 1, 20, 14, 7, 614, 13, 20, '', 18, 2, 6, 19, -1, -1, 7933, 4382, 23, 4, 614, 260, 3190, 90, 168),
678(1137, 11, 11, 10, 17, 19, 10, 901, 5, 7, '', 30, 11, 18, 5, -1, -1, 1029, 5523, 0, 5, 901, 265, 3148, 95, 173),
679(1138, 11, 9, 6, 7, 5, 8, 883, 9, 10, '', 13, 6, 13, 6, -1, -1, 30306, 2973, 20, 4, 883, 275, 3146, 91, 173),
680(1139, 2, 20, 4, 3, 19, 11, 744, 14, 8, '', 27, 29, 13, 18, -1, -1, 8474, 2014, 18, 3, 744, 261, 3196, 97, 173),
681(1140, 8, 16, 11, 1, 8, 8, 281, 16, 10, '', 22, 14, 6, 13, -1, -1, 22178, 22789, 2, 8, 641, 263, 3163, 95, 172),
682(1141, 2, 12, 8, 7, 18, 18, 786, 8, 26, '', 9, 15, 27, 7, -1, -1, 9875, 24987, 23, 7, 786, 274, 3290, 97, 162),
683(1142, 6, 5, 9, 7, 6, 13, 227, 24, 12, '', 21, 25, 13, 19, -1, -1, 10525, 13455, 1, 9, 227, 268, 3239, 94, 165),
684(1143, 5, 18, 12, 15, 18, 19, 250, 6, 5, '', 13, 13, 26, 7, -1, -1, 3717, 15678, 9, 9, 90, 266, 3284, 94, 173),
685(1144, 13, 5, 7, 6, 8, 16, 752, 7, 6, '', 22, 7, 13, 4, -1, -1, 3355, 22290, 17, 5, 5, 281, 3230, 93, 169),
686(1145, 2, 3, 12, 4, 13, 1, 580, 25, 9, '', 13, 19, 1, 18, -1, -1, 4759, 29206, 22, 5, 580, 279, 3150, 93, 174),
687(1146, 20, 15, 15, 19, 15, 20, 398, 9, 27, '', 11, 23, 9, 1, -1, -1, 27292, 5256, 19, 7, 398, 276, 3134, 94, 164),
688(1147, 4, 6, 3, 20, 12, 2, 815, 12, 25, '', 22, 17, 29, 9, -1, -1, 31785, 17780, 16, 5, 815, 270, 3262, 90, 172),
689(1148, 20, 19, 6, 15, 4, 6, 455, 16, 12, '', 9, 14, 2, 2, -1, -1, 26991, 31771, 25, 6, 757, 274, 3264, 93, 161),
690(1149, 10, 5, 14, 17, 2, 13, 960, 2, 20, '', 16, 20, 20, 3, -1, -1, 31504, 5538, 28, 2, 960, 273, 3144, 96, 170),
691(1150, 14, 2, 18, 7, 9, 9, -5, 20, 24, '', 14, 12, 6, 18, -1, -1, 19296, 9176, 14, 1, 91, 276, 3135, 95, 171),
692(1151, 16, 20, 8, 15, 6, 18, 898, 23, 13, '', 7, 19, 14, 3, -1, -1, 2076, 4804, 17, 7, 898, 270, 3116, 94, 166),
693(1152, 18, 12, 20, 13, 16, 3, 849, 2, 1, '', 26, 8, 6, 2, -1, -1, 22975, 16580, 16, 1, 849, 269, 3149, 91, 169),
694(1153, 1, 2, 15, 6, 13, 9, 90, 21, 4, '', 17, 2, 30, 19, -1, -1, 23710, 22770, 22, 9, 660, 261, 3280, 91, 175),
695(1154, 18, 16, 20, 4, 5, 1, 942, 5, 15, '', 25, 16, 2, 19, -1, -1, 14533, 25196, 11, 1, 942, 262, 3288, 94, 170),
696(1155, 14, 11, 1, 6, 10, 19, 905, 18, 6, '', 7, 26, 6, 9, -1, -1, 24491, 6367, 6, 5, 905, 264, 3158, 90, 170),
697(1156, 17, 7, 20, 18, 13, 20, 891, 2, 17, '', 24, 24, 11, 3, -1, -1, 22129, 404, 6, 1, 891, 268, 3233, 93, 166),
698(1157, 9, 18, 4, 3, 15, 1, 488, 7, 11, '', 25, 25, 22, 8, -1, -1, 24542, 2611, 14, 9, 563, 273, 3157, 91, 170),
699(1158, 15, 12, 6, 1, 7, 5, 769, 26, 1, '', 28, 4, 19, 9, -1, -1, 27055, 24932, 9, 7, 769, 261, 3181, 94, 169),
700(1159, 7, 6, 2, 14, 18, 8, 478, 21, 10, '', 13, 14, 16, 17, -1, -1, 20282, 26209, 2, 2, 369, 264, 3247, 95, 165),
701(1160, 18, 11, 19, 16, 4, 6, 997, 30, 22, '', 29, 27, 1, 18, -1, -1, 5236, 3000, 18, 9, 997, 277, 3121, 95, 170),
702(1161, 12, 19, 7, 10, 4, 16, 891, 23, 5, '', 22, 7, 5, 17, -1, -1, 24323, 19306, 13, 6, 38, 276, 3287, 95, 165),
703(1162, 15, 8, 18, 18, 19, 12, 698, 16, 3, '', 2, 5, 20, 5, -1, -1, 31090, 29040, 29, 5, 698, 275, 3289, 94, 170),
704(1163, 4, 17, 6, 3, 12, 20, 614, 10, 29, '', 17, 15, 14, 9, -1, -1, 20673, 20859, 14, 8, 70, 262, 3220, 92, 168),
705(1164, 13, 11, 16, 3, 17, 10, 957, 19, 17, '', 14, 26, 21, 8, -1, -1, 22974, 26551, 2, 7, 957, 278, 3185, 97, 162),
706(1165, 13, 11, 11, 9, 11, 10, 762, 23, 24, '', 14, 29, 9, 9, -1, -1, 17997, 20767, 1, 1, 919, 276, 3176, 96, 165),
707(1166, 12, 20, 6, 15, 17, 15, 302, 12, 22, '', 27, 18, 25, 10, -1, -1, 20811, 5554, 24, 3, 688, 270, 3237, 90, 171),
708(1167, 1, 8, 14, 17, 15, 9, 283, 14, 8, '', 29, 24, 16, 20, -1, -1, 12046, 19674, 13, 4, 283, 267, 3257, 97, 167),
709(1168, 1, 19, 13, 3, 12, 4, 999, 25, 3, '', 19, 10, 25, 12, -1, -1, 27563, 15756, 29, 6, 999, 260, 3195, 97, 165),
710(1169, 7, 13, 14, 17, 17, 15, 15, 18, 17, '', 12, 18, 8, 19, -1, -1, 10936, 22964, 10, 9, 515, 263, 3114, 92, 172),
711(1170, 13, 5, 4, 11, 8, 16, 272, 4, 18, '', 26, 30, 15, 19, -1, -1, 19753, 23303, 26, 8, 617, 261, 3155, 96, 169),
712(1171, 16, 14, 10, 16, 10, 7, 802, 10, 2, '', 15, 8, 30, 11, -1, -1, 7801, 3314, 23, 8, 802, 279, 3262, 92, 161),
713(1172, 12, 19, 4, 8, 18, 15, 766, 10, 28, '', 15, 17, 18, 17, -1, -1, 30464, 30962, 30, 6, 766, 266, 3201, 92, 175),
714(1173, 12, 8, 4, 1, 20, 16, 824, 29, 10, '', 24, 29, 18, 15, -1, -1, 6587, 18922, 11, 4, 575, 268, 3105, 95, 162),
715(1174, 18, 17, 1, 12, 12, 18, 801, 14, 18, '', 23, 14, 29, 4, -1, -1, 29080, 20265, 0, 4, 801, 262, 3240, 93, 163),
716(1175, 13, 10, 5, 1, 20, 6, 149, 2, 22, '', 25, 2, 24, 14, -1, -1, 32147, 27998, 14, 3, 447, 278, 3161, 92, 162),
717(1176, 18, 10, 3, 8, 8, 5, 412, 18, 24, '', 21, 17, 8, 16, -1, -1, 5359, 1774, 23, 9, 412, 275, 3126, 91, 162),
718(1177, 11, 10, 6, 20, 5, 11, 246, 25, 16, '', 14, 14, 2, 9, -1, -1, 7150, 24605, 23, 3, 627, 273, 3200, 95, 173),
719(1178, 7, 20, 20, 7, 5, 3, 388, 8, 6, '', 15, 1, 4, 14, -1, -1, 15112, 30206, 7, 5, 423, 270, 3168, 95, 166),
720(1179, 4, 8, 6, 16, 14, 11, 985, 8, 6, '', 5, 19, 29, 4, -1, -1, 1644, 31090, 18, 7, 985, 264, 3111, 94, 169),
721(1180, 14, 19, 2, 12, 20, 11, 167, 21, 16, '', 8, 1, 25, 16, -1, -1, 28045, 31521, 16, 7, 555, 265, 3158, 95, 173),
722(1181, 13, 5, 7, 18, 7, 6, 73, 11, 8, '', 3, 24, 12, 13, -1, -1, 9689, 18820, 9, 3, 655, 263, 3278, 95, 166),
723(1182, 14, 5, 6, 9, 9, 17, 446, 25, 23, '', 17, 29, 14, 13, -1, -1, 3484, 25119, 17, 9, 446, 277, 3259, 94, 173),
724(1183, 11, 3, 17, 13, 11, 13, 717, 6, 26, '', 3, 30, 17, 18, -1, -1, 13815, 6320, 24, 5, 717, 270, 3283, 90, 171),
725(1184, 12, 14, 18, 3, 8, 8, 984, 2, 17, '', 13, 13, 13, 19, -1, -1, 2435, 16910, 0, 2, 984, 275, 3267, 90, 173),
726(1185, 4, 14, 14, 19, 8, 16, -9, 22, 13, '', 6, 7, 14, 17, -1, -1, 3364, 21617, 16, 4, 699, 275, 3172, 97, 166),
727(1186, 10, 3, 18, 18, 2, 13, 586, 28, 26, '', 17, 25, 11, 3, -1, -1, 8825, 21511, 3, 5, 272, 270, 3208, 94, 166),
728(1187, 17, 4, 7, 8, 20, 2, 922, 30, 3, '', 30, 28, 6, 13, -1, -1, 14500, 6260, 1, 1, 922, 281, 3263, 96, 168),
729(1188, 9, 9, 17, 2, 12, 4, 223, 17, 9, '', 3, 16, 12, 15, -1, -1, 4531, 20037, 4, 4, 622, 263, 3111, 91, 173),
730(1189, 20, 18, 11, 15, 14, 12, 1, 27, 26, '', 26, 25, 15, 7, -1, -1, 4043, 28475, 7, 8, 203, 276, 3191, 92, 170),
731(1190, 13, 19, 4, 5, 16, 1, 773, 1, 2, '', 1, 21, 25, 7, -1, -1, 17930, 20392, 4, 3, 773, 278, 3252, 95, 174),
732(1191, 16, 18, 8, 20, 20, 2, 857, 14, 9, '', 28, 4, 4, 1, -1, -1, 24410, 17844, 30, 9, 857, 270, 3110, 93, 172),
733(1192, 19, 17, 15, 3, 3, 18, 48, 24, 15, '', 29, 22, 6, 12, -1, -1, 7982, 25656, 23, 1, 571, 261, 3274, 92, 161),
734(1193, 14, 6, 7, 6, 15, 4, 376, 27, 20, '', 23, 7, 18, 3, -1, -1, 9686, 27818, 25, 4, 552, 275, 3135, 97, 166),
735(1194, 2, 4, 3, 13, 1, 15, 354, 8, 19, '', 18, 14, 3, 13, -1, -1, 7977, 6396, 12, 5, 354, 280, 3265, 93, 169),
736(1195, 2, 5, 17, 6, 14, 8, 288, 21, 25, '', 23, 25, 29, 8, -1, -1, 28499, 26122, 8, 3, 240, 266, 3164, 94, 170),
737(1196, 16, 4, 10, 8, 19, 3, 427, 15, 1, '', 28, 20, 9, 19, -1, -1, 28791, 17249, 16, 5, 521, 281, 3254, 95, 173),
738(1197, 14, 10, 19, 6, 17, 6, 460, 19, 3, '', 10, 29, 8, 6, -1, -1, 28628, 21457, 16, 9, 297, 263, 3126, 90, 164),
739(1198, 1, 20, 19, 18, 17, 13, 927, 4, 15, '', 20, 26, 22, 17, -1, -1, 3722, 19321, 9, 8, 927, 270, 3220, 97, 164),
740(1199, 9, 12, 7, 18, 15, 6, 842, 22, 6, '', 9, 24, 17, 9, -1, -1, 23074, 24289, 7, 5, 842, 265, 3117, 97, 163),
741(1200, 16, 4, 13, 6, 18, 1, 354, 14, 30, '', 28, 3, 17, 20, -1, -1, 502, 30317, 16, 8, 283, 279, 3272, 97, 168),
742(1201, 11, 8, 8, 8, 11, 16, 446, 18, 16, '', 16, 9, 23, 7, -1, -1, 10318, 29329, 17, 8, 741, 269, 3295, 97, 175),
743(1202, 15, 7, 19, 7, 12, 20, 763, 2, 3, '', 29, 17, 14, 1, -1, -1, 15484, 11729, 13, 2, 169, 267, 3297, 97, 172),
744(1203, 2, 4, 7, 15, 3, 13, -7, 12, 2, '', 28, 26, 16, 7, -1, -1, 10102, 19956, 3, 1, 834, 273, 3241, 95, 169),
745(1204, 3, 19, 14, 17, 9, 5, 256, 30, 11, '', 24, 12, 5, 10, -1, -1, 19155, 28194, 1, 7, 35, 271, 3209, 91, 168),
746(1205, 13, 7, 12, 18, 19, 3, 730, 11, 29, '', 6, 30, 21, 5, -1, -1, 12655, 28153, 30, 5, 730, 272, 3149, 92, 173),
747(1206, 13, 16, 2, 1, 6, 17, 664, 27, 16, '', 2, 19, 13, 9, -1, -1, 9390, 7330, 14, 9, 664, 278, 3105, 96, 168),
748(1207, 13, 12, 18, 16, 13, 17, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 0, 0, 1, 0, 8, 282, 3272, 94, 165),
749(1208, 13, 13, 18, 15, 13, 13, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 0, 0, 3, 0, 14, 283, 3152, 97, 175),
750(1209, 12, 14, 17, 12, 10, 17, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 0, 0, 2, 0, 15, 284, 3153, 90, 172),
751(1210, 16, 15, 14, 14, 16, 12, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 0, 0, 2, 0, 9, 285, 3126, 96, 167),
752(1211, 17, 18, 11, 14, 14, 12, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 0, 0, 2, 0, 9, 286, 3144, 97, 175),
753(1212, 9, 14, 17, 18, 17, 15, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 103998, 0, 3, 0, 16, 287, 3299, 95, NULL),
754(1213, 11, 18, 14, 14, 10, 17, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 1000, 0, 3, 0, 18, 288, 3226, 97, 165),
755(1214, 13, 14, 14, 16, 12, 17, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 10000, 0, 3, 0, 18, 289, 3249, 93, NULL),
756(1215, 15, 9, 11, 12, 17, 15, 8, -1, -1, '', -1, -1, -1, 0, -1, -1, 100, 0, 2, 0, 15, 290, 3126, 91, 172);
757
758-- --------------------------------------------------------
759
760--
761-- Struktura tabeli dla tabeli `Poziom`
762--
763
764CREATE TABLE IF NOT EXISTS `Poziom` (
765  `IdPoziomu` int(11) NOT NULL AUTO_INCREMENT,
766  `IdKlasy` int(11) NOT NULL,
767  `Poziom` int(11) NOT NULL,
768  `DoswiadczenieDoAwansu` int(11) NOT NULL,
769  `Punkty` int(11) NOT NULL,
770  PRIMARY KEY (`IdPoziomu`),
771  KEY `FK_DotyczyKlasy` (`IdKlasy`)
772) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=3 ;
773
774--
775-- Zrzut danych tabeli `Poziom`
776--
777
778INSERT INTO `Poziom` (`IdPoziomu`, `IdKlasy`, `Poziom`, `DoswiadczenieDoAwansu`, `Punkty`) VALUES
779(1, 113, 1, 100, 0),
780(2, 113, 2, 300, 1);
781
782-- --------------------------------------------------------
783
784--
785-- Struktura tabeli dla tabeli `Przedmiot`
786--
787
788CREATE TABLE IF NOT EXISTS `Przedmiot` (
789  `IdPrzedmiotu` int(11) NOT NULL AUTO_INCREMENT,
790  `IdSzablonuPrzedmiotu` int(11) NOT NULL,
791  `IdPostaci` int(11) NOT NULL,
792  `StanPrzedmiotu` char(255) DEFAULT NULL,
793  PRIMARY KEY (`IdPrzedmiotu`),
794  KEY `FK_JestPosiadany` (`IdPostaci`),
795  KEY `FK_ReprezentujeSzablon` (`IdSzablonuPrzedmiotu`)
796) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=1892 ;
797
798--
799-- Zrzut danych tabeli `Przedmiot`
800--
801
802INSERT INTO `Przedmiot` (`IdPrzedmiotu`, `IdSzablonuPrzedmiotu`, `IdPostaci`, `StanPrzedmiotu`) VALUES
803(1628, 88, 1148, '28'),
804(1629, 105, 1201, '46'),
805(1630, 89, 1166, '1'),
806(1631, 102, 1130, '70'),
807(1632, 99, 1173, '31'),
808(1633, 107, 1164, '62'),
809(1634, 98, 1150, '32'),
810(1635, 104, 1138, '7'),
811(1636, 108, 1181, '79'),
812(1637, 113, 1148, '55'),
813(1638, 107, 1165, '99'),
814(1639, 113, 1119, '11'),
815(1640, 92, 1185, '11'),
816(1641, 89, 1126, '13'),
817(1642, 114, 1185, '63'),
818(1643, 103, 1174, '17'),
819(1644, 112, 1198, '95'),
820(1645, 100, 1156, '63'),
821(1646, 110, 1130, '6'),
822(1647, 100, 1120, '39'),
823(1648, 89, 1166, '7'),
824(1649, 97, 1167, '51'),
825(1650, 94, 1124, '92'),
826(1651, 93, 1131, '29'),
827(1652, 88, 1118, '77'),
828(1653, 94, 1142, '18'),
829(1654, 92, 1192, '12'),
830(1655, 88, 1118, '30'),
831(1656, 88, 1195, '31'),
832(1657, 102, 1144, '50'),
833(1658, 100, 1141, '32'),
834(1659, 89, 1177, '91'),
835(1660, 102, 1165, '29'),
836(1661, 108, 1127, '32'),
837(1662, 97, 1128, '49'),
838(1663, 98, 1148, '29'),
839(1664, 109, 1199, '4'),
840(1665, 89, 1141, '90'),
841(1666, 89, 1190, '5'),
842(1667, 93, 1144, '60'),
843(1668, 99, 1150, '61'),
844(1669, 101, 1200, '64'),
845(1670, 101, 1126, '5'),
846(1671, 105, 1129, '47'),
847(1672, 98, 1143, '32'),
848(1673, 100, 1184, '9'),
849(1674, 92, 1191, '82'),
850(1675, 101, 1198, '98'),
851(1676, 98, 1116, '24'),
852(1677, 90, 1136, '9'),
853(1678, 109, 1176, '19'),
854(1679, 104, 1147, '98'),
855(1680, 102, 1202, '61'),
856(1681, 96, 1174, '77'),
857(1682, 110, 1145, '86'),
858(1683, 89, 1162, '92'),
859(1684, 114, 1190, '99'),
860(1685, 104, 1203, '3'),
861(1686, 111, 1115, '14'),
862(1687, 99, 1161, '21'),
863(1688, 100, 1190, '16'),
864(1689, 92, 1187, '55'),
865(1690, 103, 1175, '15'),
866(1691, 104, 1157, '9'),
867(1692, 106, 1173, '95'),
868(1693, 90, 1144, '37'),
869(1694, 93, 1119, '96'),
870(1695, 94, 1154, '82'),
871(1696, 96, 1167, '40'),
872(1697, 99, 1200, '68'),
873(1698, 94, 1199, '73'),
874(1699, 101, 1174, '66'),
875(1700, 105, 1146, '65'),
876(1701, 90, 1188, '54'),
877(1702, 93, 1178, '2'),
878(1703, 106, 1187, '8'),
879(1704, 91, 1133, '98'),
880(1705, 95, 1183, '29'),
881(1706, 87, 1128, '86'),
882(1707, 111, 1149, '82'),
883(1708, 114, 1131, '87'),
884(1709, 108, 1152, '58'),
885(1710, 88, 1134, '60'),
886(1711, 113, 1147, '19'),
887(1712, 96, 1190, '68'),
888(1713, 99, 1171, '93'),
889(1714, 102, 1187, '90'),
890(1715, 87, 1129, '80'),
891(1716, 107, 1174, '14'),
892(1717, 92, 1126, '32'),
893(1718, 97, 1170, '95'),
894(1719, 108, 1162, '65'),
895(1720, 92, 1167, '40'),
896(1721, 112, 1187, '79'),
897(1722, 107, 1196, '7'),
898(1723, 111, 1148, '18'),
899(1724, 88, 1206, '9'),
900(1725, 114, 1144, '40'),
901(1726, 109, 1164, '52'),
902(1727, 89, 1185, '69'),
903(1728, 91, 1123, '68'),
904(1729, 105, 1190, '47'),
905(1730, 113, 1188, '56'),
906(1731, 87, 1191, '90'),
907(1732, 95, 1155, '17'),
908(1733, 110, 1162, '5'),
909(1734, 90, 1150, '57'),
910(1735, 105, 1130, '56'),
911(1736, 110, 1125, '54'),
912(1737, 104, 1182, '77'),
913(1738, 114, 1183, '20'),
914(1739, 87, 1161, '10'),
915(1740, 92, 1205, '69'),
916(1741, 110, 1171, '66'),
917(1742, 91, 1199, '25'),
918(1743, 114, 1175, '99'),
919(1744, 112, 1160, '100'),
920(1745, 93, 1139, '6'),
921(1746, 111, 1133, '85'),
922(1747, 96, 1163, '50'),
923(1748, 112, 1201, '33'),
924(1749, 106, 1161, '14'),
925(1750, 112, 1160, '90'),
926(1751, 96, 1142, '93'),
927(1752, 98, 1120, '76'),
928(1753, 88, 1190, '36'),
929(1754, 91, 1151, '32'),
930(1755, 88, 1167, '2'),
931(1756, 92, 1165, '17'),
932(1757, 101, 1199, '82'),
933(1758, 100, 1178, '69'),
934(1759, 89, 1176, '3'),
935(1760, 100, 1140, '99'),
936(1761, 93, 1173, '88'),
937(1762, 111, 1177, '30'),
938(1763, 93, 1116, '47'),
939(1764, 93, 1163, '45'),
940(1765, 93, 1177, '28'),
941(1766, 109, 1157, '42'),
942(1767, 94, 1192, '61'),
943(1768, 101, 1192, '63'),
944(1769, 107, 1184, '72'),
945(1770, 93, 1168, '54'),
946(1771, 99, 1202, '9'),
947(1772, 100, 1192, '81'),
948(1773, 97, 1200, '88'),
949(1774, 101, 1192, '86'),
950(1775, 98, 1139, '64'),
951(1776, 104, 1151, '74'),
952(1777, 106, 1196, '33'),
953(1778, 108, 1183, '44'),
954(1779, 88, 1200, '12'),
955(1780, 106, 1176, '32'),
956(1781, 114, 1129, '93'),
957(1782, 105, 1118, '75'),
958(1783, 93, 1144, '73'),
959(1784, 111, 1156, '7'),
960(1785, 114, 1126, '16'),
961(1786, 88, 1160, '74'),
962(1787, 89, 1176, '66'),
963(1788, 103, 1122, '99'),
964(1789, 113, 1133, '63'),
965(1790, 107, 1153, '33'),
966(1791, 88, 1164, '99'),
967(1792, 94, 1194, '90'),
968(1793, 89, 1131, '63'),
969(1794, 88, 1190, '63'),
970(1795, 109, 1128, '9'),
971(1796, 100, 1175, '74'),
972(1797, 113, 1136, '92'),
973(1798, 94, 1131, '36'),
974(1799, 97, 1137, '90'),
975(1800, 91, 1158, '99'),
976(1801, 94, 1199, '75'),
977(1802, 97, 1131, '18'),
978(1803, 107, 1133, '24'),
979(1804, 90, 1181, '36'),
980(1805, 100, 1141, '41'),
981(1806, 106, 1151, '19'),
982(1807, 98, 1204, '16'),
983(1808, 89, 1166, '94'),
984(1809, 111, 1180, '2'),
985(1810, 111, 1174, '97'),
986(1811, 95, 1162, '96'),
987(1812, 99, 1159, '53'),
988(1813, 113, 1166, '1'),
989(1814, 107, 1135, '66'),
990(1815, 95, 1189, '9'),
991(1816, 108, 1118, '2'),
992(1817, 101, 1174, '52'),
993(1818, 113, 1183, '37'),
994(1819, 100, 1183, '97'),
995(1820, 87, 1197, '37'),
996(1821, 105, 1150, '79'),
997(1822, 101, 1125, '45'),
998(1823, 91, 1116, '73'),
999(1824, 97, 1117, '88'),
1000(1825, 101, 1166, '24'),
1001(1826, 107, 1184, '47'),
1002(1827, 101, 1180, '1'),
1003(1828, 94, 1199, '27'),
1004(1829, 112, 1121, '66'),
1005(1830, 104, 1157, '61'),
1006(1831, 94, 1196, '84'),
1007(1832, 112, 1130, '54'),
1008(1833, 111, 1162, '30'),
1009(1834, 94, 1172, '62'),
1010(1835, 105, 1122, '54'),
1011(1836, 111, 1123, '13'),
1012(1837, 95, 1133, '34'),
1013(1838, 91, 1127, '8'),
1014(1839, 102, 1142, '91'),
1015(1840, 112, 1126, '7'),
1016(1841, 99, 1173, '84'),
1017(1842, 108, 1193, '30'),
1018(1843, 113, 1166, '86'),
1019(1844, 93, 1166, '69'),
1020(1845, 114, 1192, '2'),
1021(1846, 95, 1179, '87'),
1022(1847, 96, 1201, '78'),
1023(1848, 103, 1151, '44'),
1024(1849, 106, 1118, '28'),
1025(1850, 107, 1125, '53'),
1026(1851, 95, 1132, '4'),
1027(1852, 105, 1174, '4'),
1028(1853, 93, 1191, '89'),
1029(1854, 99, 1175, '9'),
1030(1855, 110, 1177, '13'),
1031(1856, 113, 1164, '15'),
1032(1857, 99, 1160, '98'),
1033(1858, 113, 1134, '62'),
1034(1859, 95, 1191, '30'),
1035(1860, 109, 1183, '98'),
1036(1861, 105, 1135, '40'),
1037(1862, 91, 1161, '76'),
1038(1863, 113, 1166, '18'),
1039(1864, 108, 1122, '37'),
1040(1865, 97, 1181, '21'),
1041(1866, 87, 1184, '28'),
1042(1867, 104, 1152, '19'),
1043(1868, 105, 1128, '89'),
1044(1869, 107, 1176, '4'),
1045(1870, 108, 1152, '82'),
1046(1871, 102, 1116, '27'),
1047(1872, 99, 1163, '46'),
1048(1873, 106, 1189, '33'),
1049(1874, 92, 1120, '54'),
1050(1875, 97, 1151, '52'),
1051(1876, 110, 1185, '87'),
1052(1877, 97, 1140, '19'),
1053(1878, 112, 1155, '70'),
1054(1879, 87, 1139, '87'),
1055(1880, 94, 1195, '30'),
1056(1881, 100, 1146, '32'),
1057(1882, 101, 1201, '42'),
1058(1883, 103, 1122, '17'),
1059(1884, 101, 1192, '15'),
1060(1885, 98, 1190, '10'),
1061(1886, 97, 1182, '37'),
1062(1887, 97, 1163, '12'),
1063(1888, 98, 1189, '43'),
1064(1889, 101, 1164, '27'),
1065(1890, 93, 1177, '84'),
1066(1891, 87, 1115, '28');
1067
1068-- --------------------------------------------------------
1069
1070--
1071-- Struktura tabeli dla tabeli `PrzydzialyAtutow`
1072--
1073
1074CREATE TABLE IF NOT EXISTS `PrzydzialyAtutow` (
1075  `IdPrzydzialuA` int(11) NOT NULL AUTO_INCREMENT,
1076  `IdPostaci` int(11) NOT NULL,
1077  `IdAtutu` int(11) NOT NULL,
1078  PRIMARY KEY (`IdPrzydzialuA`),
1079  KEY `FK_PosiadaAtut` (`IdAtutu`),
1080  KEY `FK_PrzydzielaAtut` (`IdPostaci`)
1081) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=4918 ;
1082
1083--
1084-- Zrzut danych tabeli `PrzydzialyAtutow`
1085--
1086
1087INSERT INTO `PrzydzialyAtutow` (`IdPrzydzialuA`, `IdPostaci`, `IdAtutu`) VALUES
1088(4514, 1115, 128),
1089(4515, 1115, 133),
1090(4516, 1115, 129),
1091(4517, 1115, 135),
1092(4518, 1115, 134),
1093(4519, 1115, 129),
1094(4520, 1115, 128),
1095(4521, 1116, 133),
1096(4522, 1116, 136),
1097(4523, 1116, 129),
1098(4524, 1117, 136),
1099(4525, 1117, 130),
1100(4526, 1117, 129),
1101(4527, 1117, 132),
1102(4528, 1117, 136),
1103(4529, 1117, 132),
1104(4530, 1118, 134),
1105(4531, 1118, 130),
1106(4532, 1118, 129),
1107(4533, 1118, 128),
1108(4534, 1118, 135),
1109(4535, 1121, 132),
1110(4536, 1121, 130),
1111(4537, 1121, 129),
1112(4538, 1121, 130),
1113(4539, 1122, 132),
1114(4540, 1122, 134),
1115(4541, 1122, 132),
1116(4542, 1122, 129),
1117(4543, 1122, 136),
1118(4544, 1122, 134),
1119(4545, 1123, 129),
1120(4546, 1123, 131),
1121(4547, 1123, 133),
1122(4548, 1123, 131),
1123(4549, 1123, 133),
1124(4550, 1124, 135),
1125(4551, 1124, 136),
1126(4552, 1124, 135),
1127(4553, 1124, 134),
1128(4554, 1124, 130),
1129(4555, 1124, 131),
1130(4556, 1124, 128),
1131(4557, 1124, 136),
1132(4558, 1125, 130),
1133(4559, 1125, 134),
1134(4560, 1125, 131),
1135(4561, 1125, 133),
1136(4562, 1125, 135),
1137(4563, 1125, 130),
1138(4564, 1126, 128),
1139(4565, 1126, 129),
1140(4566, 1127, 128),
1141(4567, 1127, 136),
1142(4568, 1127, 135),
1143(4569, 1127, 129),
1144(4570, 1127, 132),
1145(4571, 1128, 128),
1146(4572, 1128, 134),
1147(4573, 1128, 136),
1148(4574, 1128, 130),
1149(4575, 1128, 132),
1150(4576, 1129, 131),
1151(4577, 1129, 131),
1152(4578, 1129, 134),
1153(4579, 1129, 133),
1154(4580, 1129, 133),
1155(4581, 1131, 131),
1156(4582, 1131, 133),
1157(4583, 1131, 136),
1158(4584, 1131, 135),
1159(4585, 1131, 135),
1160(4586, 1132, 135),
1161(4587, 1132, 136),
1162(4588, 1132, 136),
1163(4589, 1134, 129),
1164(4590, 1134, 128),
1165(4591, 1134, 131),
1166(4592, 1134, 130),
1167(4593, 1134, 130),
1168(4594, 1134, 136),
1169(4595, 1136, 128),
1170(4596, 1136, 136),
1171(4597, 1136, 128),
1172(4598, 1136, 129),
1173(4599, 1136, 131),
1174(4600, 1136, 129),
1175(4601, 1137, 136),
1176(4602, 1137, 131),
1177(4603, 1137, 134),
1178(4604, 1137, 135),
1179(4605, 1138, 129),
1180(4606, 1138, 131),
1181(4607, 1138, 131),
1182(4608, 1138, 135),
1183(4609, 1138, 132),
1184(4610, 1139, 130),
1185(4611, 1139, 132),
1186(4612, 1139, 135),
1187(4613, 1139, 135),
1188(4614, 1139, 130),
1189(4615, 1139, 129),
1190(4616, 1140, 134),
1191(4617, 1140, 136),
1192(4618, 1140, 128),
1193(4619, 1140, 132),
1194(4620, 1140, 135),
1195(4621, 1140, 136),
1196(4622, 1140, 131),
1197(4623, 1141, 136),
1198(4624, 1141, 133),
1199(4625, 1141, 129),
1200(4626, 1141, 132),
1201(4627, 1141, 136),
1202(4628, 1141, 136),
1203(4629, 1141, 133),
1204(4630, 1141, 131),
1205(4631, 1142, 133),
1206(4632, 1142, 136),
1207(4633, 1142, 135),
1208(4634, 1142, 133),
1209(4635, 1142, 135),
1210(4636, 1142, 130),
1211(4637, 1142, 134),
1212(4638, 1142, 135),
1213(4639, 1143, 131),
1214(4640, 1143, 130),
1215(4641, 1143, 135),
1216(4642, 1143, 133),
1217(4643, 1143, 128),
1218(4644, 1143, 128),
1219(4645, 1144, 129),
1220(4646, 1144, 128),
1221(4647, 1144, 128),
1222(4648, 1144, 132),
1223(4649, 1144, 135),
1224(4650, 1144, 130),
1225(4651, 1144, 130),
1226(4652, 1144, 130),
1227(4653, 1145, 128),
1228(4654, 1145, 134),
1229(4655, 1146, 128),
1230(4656, 1146, 134),
1231(4657, 1146, 128),
1232(4658, 1146, 131),
1233(4659, 1146, 134),
1234(4660, 1146, 134),
1235(4661, 1146, 134),
1236(4662, 1147, 129),
1237(4663, 1147, 130),
1238(4664, 1147, 134),
1239(4665, 1148, 134),
1240(4666, 1148, 134),
1241(4667, 1149, 128),
1242(4668, 1149, 134),
1243(4669, 1149, 130),
1244(4670, 1149, 132),
1245(4671, 1149, 134),
1246(4672, 1152, 133),
1247(4673, 1152, 132),
1248(4674, 1152, 130),
1249(4675, 1152, 133),
1250(4676, 1152, 134),
1251(4677, 1153, 130),
1252(4678, 1153, 133),
1253(4679, 1153, 129),
1254(4680, 1153, 130),
1255(4681, 1153, 135),
1256(4682, 1156, 131),
1257(4683, 1156, 129),
1258(4684, 1156, 133),
1259(4685, 1156, 134),
1260(4686, 1156, 129),
1261(4687, 1156, 129),
1262(4688, 1157, 132),
1263(4689, 1157, 135),
1264(4690, 1157, 128),
1265(4691, 1157, 130),
1266(4692, 1157, 132),
1267(4693, 1158, 136),
1268(4694, 1158, 135),
1269(4695, 1158, 135),
1270(4696, 1158, 130),
1271(4697, 1158, 130),
1272(4698, 1159, 136),
1273(4699, 1159, 132),
1274(4700, 1159, 135),
1275(4701, 1159, 131),
1276(4702, 1159, 130),
1277(4703, 1159, 130),
1278(4704, 1160, 134),
1279(4705, 1160, 129),
1280(4706, 1160, 135),
1281(4707, 1160, 132),
1282(4708, 1160, 130),
1283(4709, 1160, 131),
1284(4710, 1161, 132),
1285(4711, 1161, 130),
1286(4712, 1163, 129),
1287(4713, 1163, 130),
1288(4714, 1163, 132),
1289(4715, 1164, 130),
1290(4716, 1164, 135),
1291(4717, 1164, 135),
1292(4718, 1164, 131),
1293(4719, 1164, 131),
1294(4720, 1165, 131),
1295(4721, 1165, 129),
1296(4722, 1165, 132),
1297(4723, 1165, 131),
1298(4724, 1166, 132),
1299(4725, 1166, 133),
1300(4726, 1166, 136),
1301(4727, 1166, 134),
1302(4728, 1166, 132),
1303(4729, 1166, 135),
1304(4730, 1166, 135),
1305(4731, 1168, 130),
1306(4732, 1168, 131),
1307(4733, 1168, 128),
1308(4734, 1169, 133),
1309(4735, 1169, 133),
1310(4736, 1169, 132),
1311(4737, 1169, 128),
1312(4738, 1169, 128),
1313(4739, 1169, 133),
1314(4740, 1169, 134),
1315(4741, 1169, 136),
1316(4742, 1170, 129),
1317(4743, 1170, 130),
1318(4744, 1170, 133),
1319(4745, 1170, 136),
1320(4746, 1170, 130),
1321(4747, 1171, 133),
1322(4748, 1171, 128),
1323(4749, 1171, 128),
1324(4750, 1171, 131),
1325(4751, 1171, 132),
1326(4752, 1172, 132),
1327(4753, 1172, 135),
1328(4754, 1173, 129),
1329(4755, 1173, 135),
1330(4756, 1173, 130),
1331(4757, 1173, 128),
1332(4758, 1174, 132),
1333(4759, 1174, 128),
1334(4760, 1174, 133),
1335(4761, 1174, 128),
1336(4762, 1174, 133),
1337(4763, 1174, 131),
1338(4764, 1175, 130),
1339(4765, 1175, 135),
1340(4766, 1175, 131),
1341(4767, 1176, 131),
1342(4768, 1177, 133),
1343(4769, 1178, 128),
1344(4770, 1178, 132),
1345(4771, 1178, 128),
1346(4772, 1178, 132),
1347(4773, 1178, 133),
1348(4774, 1178, 132),
1349(4775, 1178, 135),
1350(4776, 1181, 131),
1351(4777, 1181, 135),
1352(4778, 1181, 136),
1353(4779, 1181, 129),
1354(4780, 1181, 129),
1355(4781, 1181, 133),
1356(4782, 1181, 136),
1357(4783, 1181, 128),
1358(4784, 1182, 136),
1359(4785, 1182, 129),
1360(4786, 1182, 134),
1361(4787, 1182, 130),
1362(4788, 1182, 135),
1363(4789, 1182, 134),
1364(4790, 1183, 129),
1365(4791, 1183, 130),
1366(4792, 1183, 135),
1367(4793, 1183, 136),
1368(4794, 1183, 133),
1369(4795, 1183, 134),
1370(4796, 1184, 135),
1371(4797, 1184, 131),
1372(4798, 1184, 132),
1373(4799, 1185, 130),
1374(4800, 1185, 132),
1375(4801, 1185, 130),
1376(4802, 1185, 129),
1377(4803, 1185, 133),
1378(4804, 1186, 131),
1379(4805, 1186, 129),
1380(4806, 1187, 134),
1381(4807, 1187, 134),
1382(4808, 1187, 132),
1383(4809, 1187, 135),
1384(4810, 1188, 135),
1385(4811, 1188, 130),
1386(4812, 1188, 134),
1387(4813, 1188, 134),
1388(4814, 1188, 131),
1389(4815, 1188, 135),
1390(4816, 1188, 133),
1391(4817, 1188, 134),
1392(4818, 1189, 130),
1393(4819, 1189, 130),
1394(4820, 1189, 132),
1395(4821, 1189, 131),
1396(4822, 1189, 133),
1397(4823, 1189, 128),
1398(4824, 1189, 134),
1399(4825, 1190, 131),
1400(4826, 1190, 130),
1401(4827, 1190, 134),
1402(4828, 1191, 132),
1403(4829, 1192, 136),
1404(4830, 1193, 133),
1405(4831, 1193, 136),
1406(4832, 1193, 129),
1407(4833, 1193, 136),
1408(4834, 1193, 128),
1409(4835, 1193, 129),
1410(4836, 1194, 128),
1411(4837, 1194, 133),
1412(4838, 1194, 132),
1413(4839, 1195, 131),
1414(4840, 1195, 135),
1415(4841, 1195, 132),
1416(4842, 1195, 132),
1417(4843, 1195, 130),
1418(4844, 1195, 128),
1419(4845, 1195, 136),
1420(4846, 1195, 133),
1421(4847, 1196, 135),
1422(4848, 1196, 135),
1423(4849, 1196, 136),
1424(4850, 1198, 130),
1425(4851, 1198, 135),
1426(4852, 1198, 132),
1427(4853, 1198, 132),
1428(4854, 1198, 136),
1429(4855, 1198, 131),
1430(4856, 1198, 131),
1431(4857, 1198, 134),
1432(4858, 1199, 135),
1433(4859, 1199, 129),
1434(4860, 1199, 135),
1435(4861, 1199, 134),
1436(4862, 1199, 130),
1437(4863, 1199, 136),
1438(4864, 1199, 134),
1439(4865, 1201, 132),
1440(4866, 1201, 134),
1441(4867, 1201, 134),
1442(4868, 1201, 128),
1443(4869, 1201, 130),
1444(4870, 1201, 128),
1445(4871, 1202, 131),
1446(4872, 1202, 134),
1447(4873, 1202, 129),
1448(4874, 1202, 129),
1449(4875, 1203, 134),
1450(4876, 1203, 134),
1451(4877, 1204, 128),
1452(4878, 1205, 132),
1453(4879, 1205, 132),
1454(4880, 1205, 135),
1455(4881, 1205, 135),
1456(4882, 1205, 132),
1457(4883, 1205, 129),
1458(4884, 1205, 129),
1459(4885, 1205, 133),
1460(4886, 1206, 133),
1461(4887, 1206, 129),
1462(4888, 1208, 128),
1463(4889, 1208, 132),
1464(4890, 1208, 128),
1465(4891, 1208, 132),
1466(4892, 1208, 128),
1467(4893, 1208, 132),
1468(4894, 1208, 128),
1469(4895, 1208, 132),
1470(4896, 1208, 128),
1471(4897, 1208, 132),
1472(4898, 1208, 128),
1473(4899, 1208, 132),
1474(4900, 1208, 128),
1475(4901, 1208, 132),
1476(4902, 1208, 128),
1477(4903, 1208, 132),
1478(4904, 1209, 128),
1479(4905, 1209, 132),
1480(4906, 1210, 128),
1481(4907, 1210, 132),
1482(4908, 1211, 128),
1483(4909, 1211, 132),
1484(4910, 1212, 128),
1485(4911, 1212, 132),
1486(4912, 1213, 128),
1487(4913, 1213, 132),
1488(4914, 1214, 128),
1489(4915, 1214, 132),
1490(4916, 1215, 128),
1491(4917, 1215, 132);
1492
1493-- --------------------------------------------------------
1494
1495--
1496-- Struktura tabeli dla tabeli `PrzydzialyUmiejetnosciSpecjalnych`
1497--
1498
1499CREATE TABLE IF NOT EXISTS `PrzydzialyUmiejetnosciSpecjalnych` (
1500  `IdPrzydzialuUS` int(11) NOT NULL AUTO_INCREMENT,
1501  `IdPostaci` int(11) NOT NULL,
1502  `IdUmiejetnosciSpecjalnej` int(11) NOT NULL,
1503  PRIMARY KEY (`IdPrzydzialuUS`),
1504  KEY `FK_PosiadaUmiejetnosc` (`IdUmiejetnosciSpecjalnej`),
1505  KEY `FK_PrzydzielaUmiejetnosc` (`IdPostaci`)
1506) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=159 ;
1507
1508--
1509-- Zrzut danych tabeli `PrzydzialyUmiejetnosciSpecjalnych`
1510--
1511
1512INSERT INTO `PrzydzialyUmiejetnosciSpecjalnych` (`IdPrzydzialuUS`, `IdPostaci`, `IdUmiejetnosciSpecjalnej`) VALUES
1513(113, 1139, 113),
1514(114, 1183, 114),
1515(115, 1140, 115),
1516(116, 1131, 116),
1517(117, 1132, 117),
1518(118, 1195, 118),
1519(119, 1194, 119),
1520(120, 1158, 120),
1521(121, 1142, 121),
1522(122, 1123, 122),
1523(123, 1142, 123),
1524(124, 1138, 124),
1525(125, 1116, 125),
1526(126, 1162, 126),
1527(127, 1192, 127),
1528(128, 1154, 128),
1529(129, 1208, 113),
1530(130, 1208, 114),
1531(131, 1208, 113),
1532(132, 1208, 114),
1533(133, 1208, 113),
1534(134, 1208, 114),
1535(135, 1208, 113),
1536(136, 1208, 114),
1537(137, 1208, 113),
1538(138, 1208, 114),
1539(139, 1208, 113),
1540(140, 1208, 114),
1541(141, 1208, 113),
1542(142, 1208, 114),
1543(143, 1208, 113),
1544(144, 1208, 114),
1545(145, 1209, 113),
1546(146, 1209, 114),
1547(147, 1210, 113),
1548(148, 1210, 114),
1549(149, 1211, 113),
1550(150, 1211, 114),
1551(151, 1212, 113),
1552(152, 1212, 114),
1553(153, 1213, 113),
1554(154, 1213, 114),
1555(155, 1214, 113),
1556(156, 1214, 114),
1557(157, 1215, 113),
1558(158, 1215, 114);
1559
1560-- --------------------------------------------------------
1561
1562--
1563-- Struktura tabeli dla tabeli `Rasa`
1564--
1565
1566CREATE TABLE IF NOT EXISTS `Rasa` (
1567  `IdRasy` int(11) NOT NULL AUTO_INCREMENT,
1568  `NazwaRasy` char(255) NOT NULL,
1569  `OpisRasy` text NOT NULL,
1570  PRIMARY KEY (`IdRasy`)
1571) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=134 ;
1572
1573--
1574-- Zrzut danych tabeli `Rasa`
1575--
1576
1577INSERT INTO `Rasa` (`IdRasy`, `NazwaRasy`, `OpisRasy`) VALUES
1578(127, 'Half - elf', 'To humans, half - elves look like elves.To elves, they look like humans – indeed, elves call them half - humans.Half - elf height ranges from under 5 feet to about 6 feet tall, and weight usually ranges from 100 to 180 pounds.Half - elf men are taller and heavier than half - elf women, but the difference is less pronounced than that found among humans.Half - elves are paler, fairer, and smoother - skinned than their human parents, but their actual skin tone, hair color, and other details vary just as human features do.Half - elves eyes are green, just as are those of their elf parents. A half-elf reaches adulthood at age 20 and can live to be over 180 years old.'),
1579(128, 'Gnome', 'Gnomes are welcome everywhere as technicians, alchemists, and inventors.Despite the demand for their skills, most gnomes prefer to remain among their own kind, living in comfortable burrows beneath rolling, wooded hills where animals abound.'),
1580(129, 'Diopsid', 'Diopsids are Underdark creatures that resemble a cross between a humanoid and a beetle.They occupy large, sprawling caverns deep beneath the earth where they carve settlements into the walls and floors of their domains.Diopsids have a deep love of metal weapons and other objects, but they lack the technical ability to manufacture such goods.Thus, they work as mercenaries, laborers, hunters, and scouts for other races.To the folk of the Underdark, diopsids are simple but dangerous barbarians best dealt with via a mercenary contract rather than open engagement.Tough, strong, and skilled with a variety of weapons, diopsids make terrifying opponents and valued allies.'),
1581(130, 'Dwarf', 'Dwarves stand only 4 to 4 - 1 / 2 feet tall, but they are so broad and compact that they are, on average, almost as heavy as humans.Dwarf men are slightly taller and noticeably heavier than dwarf women.Dwarves skin is typically deep tan or light brown, and their eyes are dark. Their hair is usually black, gray, or brown, and worn long. Dwarf men value their beards highly and groom them very carefully. Dwarves favor simple styles for their hair, beards, and clothes. Dwarves are considered adults at about age 40, and they can live to be more than 400 years old.'),
1582(131, 'Dvati', 'Dvati are a strange race of humanoid creatures found in small enclaves scattered throughout the world and across the planes.All dvati are born identical twins, with the pair sharing a single soul between them.Dvati lore holds that their souls are so powerful that a single, mortal vessel is too weak to contain them.Thus, their minds occupy two bodies.'),
1583(132, 'Elf', 'Elves are short and slim, standing about 4 - 1 / 2 to 5 - 1 / 2 feet tall and typically weighing 95 to 135 pounds, with elf men the same height as and only marginally heavier than elf women.They are graceful but frail.They tend to be pale - skinned and dark - haired, with deep green eyes.Elves have no facial or body hair.They prefer simple, comfortable clothes, especially in pastel blues and greens, and they enjoy simple yet elegant jewelry.Elves possess unearthly grace and fine features. Many humans and members of other races find them hauntingly beautiful.An elf reaches adulthood at about 110 years of age and can live to be more than 700 years old.'),
1584(133, 'Diabolus', 'Originating on a distant plane, the diaboli appear to many humanoid cultures as nightmares incarnate.They have dispersed across the infinite planes as much to spread their creed of benevolent chaos as to escape the rampant horrors of an invading reality.');
1585
1586-- --------------------------------------------------------
1587
1588--
1589-- Struktura tabeli dla tabeli `SzablonPostaci`
1590--
1591
1592CREATE TABLE IF NOT EXISTS `SzablonPostaci` (
1593  `IdSzablonuPostaci` int(11) NOT NULL AUTO_INCREMENT,
1594  `IdRasy` int(11) NOT NULL,
1595  `IdKlasy` int(11) NOT NULL,
1596  `IdPochodzenia` int(11) NOT NULL,
1597  `NazwaSzablonuPostaci` text NOT NULL,
1598  `BazowaSila` int(11) NOT NULL,
1599  `BazowaZrecznosc` int(11) NOT NULL,
1600  `BazowaBudowa` int(11) NOT NULL,
1601  `BazowaInteligencja` int(11) NOT NULL,
1602  `BazowaWiedza` int(11) NOT NULL,
1603  `BazowaCharyzma` int(11) NOT NULL,
1604  PRIMARY KEY (`IdSzablonuPostaci`),
1605  KEY `FK_JestKlasy` (`IdKlasy`),
1606  KEY `FK_JestRasy` (`IdRasy`),
1607  KEY `FK_PochodziZ` (`IdPochodzenia`)
1608) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=291 ;
1609
1610--
1611-- Zrzut danych tabeli `SzablonPostaci`
1612--
1613
1614INSERT INTO `SzablonPostaci` (`IdSzablonuPostaci`, `IdRasy`, `IdKlasy`, `IdPochodzenia`, `NazwaSzablonuPostaci`, `BazowaSila`, `BazowaZrecznosc`, `BazowaBudowa`, `BazowaInteligencja`, `BazowaWiedza`, `BazowaCharyzma`) VALUES
1615(259, 128, 117, 2286, 'Venan', 8, 4, 5, 12, 11, 1),
1616(260, 133, 117, 2254, 'Muelric', 14, 8, 14, 12, 18, 10),
1617(261, 131, 116, 2318, 'Guthed', 5, 13, 10, 4, 14, 3),
1618(262, 132, 115, 2316, 'Ansam', 15, 7, 15, 1, 19, 16),
1619(263, 130, 118, 2189, 'Chrismax', 19, 5, 14, 8, 6, 10),
1620(264, 131, 115, 2184, 'Nan', 15, 4, 12, 19, 4, 6),
1621(265, 133, 114, 2182, 'Rahfred', 1, 4, 17, 2, 8, 10),
1622(266, 130, 119, 2197, 'Thorjoan', 20, 1, 18, 1, 5, 8),
1623(267, 132, 116, 2174, 'Jogrim', 8, 13, 7, 14, 15, 4),
1624(268, 130, 114, 2325, 'Bermas', 3, 9, 5, 13, 11, 6),
1625(269, 127, 120, 2187, 'Halsere', 20, 10, 12, 3, 9, 8),
1626(270, 130, 120, 2315, 'Ing', 2, 11, 16, 3, 3, 16),
1627(271, 129, 113, 2206, 'Johnard', 10, 16, 19, 2, 2, 19),
1628(272, 132, 117, 2188, 'Nielfrea', 20, 9, 17, 13, 13, 14),
1629(273, 129, 115, 2322, 'Salett', 16, 14, 1, 13, 17, 2),
1630(274, 133, 114, 2300, 'Berven', 9, 20, 7, 11, 2, 10),
1631(275, 128, 117, 2233, 'Chellgrimred', 1, 17, 5, 4, 1, 6),
1632(276, 133, 117, 2275, 'Iro', 14, 2, 10, 1, 19, 7),
1633(277, 133, 115, 2235, 'Anord', 6, 15, 14, 1, 4, 20),
1634(278, 131, 120, 2155, 'Nielda', 14, 4, 15, 14, 7, 3),
1635(279, 127, 114, 2313, 'Cyric', 13, 3, 16, 5, 9, 12),
1636(280, 128, 116, 2201, 'Isenchelan', 18, 10, 18, 4, 1, 12),
1637(281, 131, 116, 2317, 'Winean', 16, 9, 3, 2, 16, 17),
1638(282, 129, 113, 2203, 'test', 13, 12, 18, 16, 13, 17),
1639(283, 132, 113, 2270, 'LevelTest', 13, 13, 18, 15, 13, 13),
1640(284, 132, 113, 2295, 'LevelTest', 12, 14, 17, 12, 10, 17),
1641(285, 132, 113, 2192, 'Leveltest2', 16, 15, 14, 14, 16, 12),
1642(286, 132, 113, 2192, 'LevelTest3', 17, 18, 11, 14, 14, 12),
1643(287, 128, 113, 2235, 'Monk of the Darkness', 9, 14, 17, 18, 17, 15),
1644(288, 132, 113, 2203, 'LevelTest4', 11, 18, 14, 14, 10, 17),
1645(289, 132, 113, 2294, 'Chinaguy', 13, 14, 14, 16, 12, 17),
1646(290, 132, 113, 2294, 'test', 15, 9, 11, 12, 17, 15);
1647
1648-- --------------------------------------------------------
1649
1650--
1651-- Struktura tabeli dla tabeli `SzablonPrzedmiotu`
1652--
1653
1654CREATE TABLE IF NOT EXISTS `SzablonPrzedmiotu` (
1655  `IdSzablonuPrzedmiotu` int(11) NOT NULL AUTO_INCREMENT,
1656  `NazwaSzablonuPrzedmiotu` text NOT NULL,
1657  `WagaPrzedmiotu` int(11) NOT NULL,
1658  `TypPrzedmiotu` char(255) NOT NULL,
1659  `KlasaPancerza` int(11) DEFAULT NULL,
1660  `SpecjalneWlasciwosci` text,
1661  `KaraZaPancerz` int(11) DEFAULT NULL,
1662  `SzansaNaPorazkeZaklecia` int(11) DEFAULT NULL,
1663  `WspolczynnikAtaku` int(11) DEFAULT NULL,
1664  `ObrazeniaBroni` text,
1665  `SzansaNaObrazeniaKrytyczneBroni` text,
1666  `ZasiegBroni` int(11) DEFAULT NULL,
1667  PRIMARY KEY (`IdSzablonuPrzedmiotu`)
1668) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=115 ;
1669
1670--
1671-- Zrzut danych tabeli `SzablonPrzedmiotu`
1672--
1673
1674INSERT INTO `SzablonPrzedmiotu` (`IdSzablonuPrzedmiotu`, `NazwaSzablonuPrzedmiotu`, `WagaPrzedmiotu`, `TypPrzedmiotu`, `KlasaPancerza`, `SpecjalneWlasciwosci`, `KaraZaPancerz`, `SzansaNaPorazkeZaklecia`, `WspolczynnikAtaku`, `ObrazeniaBroni`, `SzansaNaObrazeniaKrytyczneBroni`, `ZasiegBroni`) VALUES
1675(87, 'Immovable Banded Mail of Lordly Mana Arrow', 27, 'Armor', 7, '', 26, 67, 5, '3d20 + 14', 'x5', 0),
1676(88, 'Diadem of the Invocation of Accuracy and Agility', 21, 'Arrow', 6, '', 22, 90, 5, '6d20 + 20', 'x4', 0),
1677(89, 'Ring Mail of the Rune of Control Everburning', 56, 'Arrow', 3, '', 90, 70, 0, '7d20 + 18', 'x2', 0),
1678(90, 'Fine Krakens Blowgun of Control Thinker', 68, 'White Weapon', 0, '', 65, 38, 1, '16d20 + 19', 'x3', 0),
1679(91, 'Glorified Crossbow', 38, 'Orb', 6, '', 58, 65, 3, '1d20 + 1', 'x4', 0),
1680(92, 'Just Priestesss Dagger', 93, 'Magic Weapon', 7, '', 8, 75, 4, '6d20 + 9', 'x3', 0),
1681(93, 'Envenomed Draught', 66, 'Mail', 4, '', 66, 70, 3, '3d20 + 19', 'x3', 0),
1682(94, 'Blasphemous Wizards Apparatus', 71, 'Diadem', 5, '', 62, 66, 5, '14d20 + 11', 'x2', 0),
1683(95, 'Living Drink', 2, 'Diadem', 5, '', 77, 18, 5, '10d20 + 11', 'x2', 0),
1684(96, 'Black Utensil of the Working of Closing and Honor', 27, 'Arrow', 7, '', 99, 11, 8, '8d20 + 15', 'x5', 0),
1685(97, 'White Bar', 52, 'Arrow', 4, '', 1, 87, 2, '12d20 + 5', 'x2', 0),
1686(98, 'Holy Orb', 4, 'Magic Weapon', 7, '', 62, 59, 5, '20d20 + 2', 'x4', 0),
1687(99, 'Holy Breast Plate of Flame and Barbs', 9, 'Diadem', 7, '', 39, 65, 2, '11d20 + 20', 'x4', 0),
1688(100, 'Spiritual Blue Ointment of Health Control', 70, 'Armor', 0, '', 18, 71, 7, '9d20 + 3', 'x3', 0),
1689(101, 'Orb of Eternal Finders', 79, 'Arrow', 0, '', 84, 22, 1, '8d20 + 14', 'x2', 0),
1690(102, 'Dire Returners Automaton', 74, 'Arrow', 5, '', 93, 79, 4, '14d20 + 9', 'x2', 0),
1691(103, 'Throwing Axe of Good Venom Zone', 28, 'Armor', 3, '', 49, 67, 4, '20d20 + 8', 'x5', 0),
1692(104, 'Villainous Spear', 93, 'Armor', 2, '', 20, 63, 3, '8d20 + 6', 'x5', 0),
1693(105, 'Great Buckler', 19, 'Magic Weapon', 0, '', 69, 21, 8, '14d20 + 6', 'x2', 0),
1694(106, 'Infernal Axe', 92, 'White Weapon', 7, '', 10, 97, 2, '12d20 + 2', 'x2', 0),
1695(107, 'Lizards Cone of the Divination of Deflect Victory', 48, 'Diadem', 3, '', 57, 34, 10, '5d20 + 7', 'x4', 0),
1696(108, 'Knife of the Marvelous Witchery of Control Finder', 46, 'Diadem', 2, '', 83, 52, 4, '1d20 + 17', 'x2', 0),
1697(109, 'Claymore of Stone Hail', 55, 'Arrow', 1, '', 36, 8, 10, '8d20 + 20', 'x5', 0),
1698(110, 'Harpsichord of the Perfect Rite of the Gothic Crowns', 19, 'Magic Weapon', 3, '', 52, 72, 2, '9d20 + 8', 'x5', 0),
1699(111, 'Caring Questers Voluge', 41, 'Arrow', 6, '', 34, 95, 3, '20d20 + 13', 'x4', 0),
1700(112, 'Illuminated Mechanism of Muck Disk', 49, 'Mail', 6, '', 29, 19, 6, '4d20 + 14', 'x5', 0),
1701(113, 'Balm of the Eater', 59, 'Armor', 4, '', 90, 99, 2, '13d20 + 5', 'x5', 0),
1702(114, 'Savage Seers Cube', 16, 'Mail', 4, '', 86, 58, 4, '16d20 + 3', 'x5', 0);
1703
1704-- --------------------------------------------------------
1705
1706--
1707-- Struktura tabeli dla tabeli `SzablonUmiejetnosci`
1708--
1709
1710CREATE TABLE IF NOT EXISTS `SzablonUmiejetnosci` (
1711  `IdSzablonuUmiejetnosci` int(11) NOT NULL AUTO_INCREMENT,
1712  `NazwaSzablonuUmiejetnosci` char(255) NOT NULL,
1713  `OpisUmiejetnosci` text NOT NULL,
1714  `WymagaNauczenia` tinyint(1) NOT NULL,
1715  PRIMARY KEY (`IdSzablonuUmiejetnosci`)
1716) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=131 ;
1717
1718--
1719-- Zrzut danych tabeli `SzablonUmiejetnosci`
1720--
1721
1722INSERT INTO `SzablonUmiejetnosci` (`IdSzablonuUmiejetnosci`, `NazwaSzablonuUmiejetnosci`, `OpisUmiejetnosci`, `WymagaNauczenia`) VALUES
1723(115, 'Flower arranging', '-', 0),
1724(116, 'Stage magic', '-', 0),
1725(117, 'Martial Arts', '-', 0),
1726(118, 'Tracking', '-', 1),
1727(119, 'Hunting', '-', 1),
1728(120, 'Wrapping presents', '-', 0),
1729(121, 'Mathematics', '-', 0),
1730(122, 'Glassblowing', '-', 0),
1731(123, 'Poledancing', '-', 1),
1732(124, 'Pyrotechniques', '-', 1),
1733(125, 'Lying', '-', 0),
1734(126, 'Sorcery', '-', 1),
1735(127, 'Forging', '-', 0),
1736(128, 'Knitting', '-', 1),
1737(129, 'Smooth-talking', '-', 1),
1738(130, 'Sculpting', '-', 0);
1739
1740-- --------------------------------------------------------
1741
1742--
1743-- Struktura tabeli dla tabeli `SzablonZaklecia`
1744--
1745
1746CREATE TABLE IF NOT EXISTS `SzablonZaklecia` (
1747  `IdSzablonuZaklecia` int(11) NOT NULL AUTO_INCREMENT,
1748  `NazwaSzablonuZaklecia` char(255) NOT NULL,
1749  `OpisZaklecia` text NOT NULL,
1750  `PoziomZaklecia` int(11) NOT NULL,
1751  `ZasiegZaklecia` int(11) NOT NULL,
1752  PRIMARY KEY (`IdSzablonuZaklecia`)
1753) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=77 ;
1754
1755--
1756-- Zrzut danych tabeli `SzablonZaklecia`
1757--
1758
1759INSERT INTO `SzablonZaklecia` (`IdSzablonuZaklecia`, `NazwaSzablonuZaklecia`, `OpisZaklecia`, `PoziomZaklecia`, `ZasiegZaklecia`) VALUES
1760(69, 'Aberrate', 'The caster transforms one creature into an aberration.', 1, 2),
1761(70, 'Ability Rip', 'You rip a supernatural ability of your choice away from one creature and transfer it to another.', 7, 2),
1762(71, 'Aboleth Curse', 'You bestow a dreadful affliction on the creature you touch, similar to the effect of an aboleths foul contact.', 4, 2),
1763(72, 'Abolish Shadows', 'A burst of dark energy leaps forth from your body and disrupts all shadows in the area of effect.', 3, 9),
1764(73, 'Absolute Steel', 'The absolute steel stance allows you to enhance your mobility and speed.You move quickly, keep a sharp eye on your enemies, and are ready to instantly sidestep any incoming attacks.', 3, 1),
1765(74, 'Absorb Mind', 'The caster eats at least a portion of the brain of another creatures corpse.', 3, 1),
1766(75, 'Absorb Strength', 'The caster eats at least a portion of the flesh of another creatures corpse, thereby gaining one-quarter of the creatures Strength score as an enhancement bonus to the casters Strength score, and one-quarter of the creatures Constitution score as an enhancement bonus to the casters Constitution.', 4, 1),
1767(76, 'Absorb Weapon', 'You can harmlessly absorb a weapon you are touching(even a poisoned one) into your arm, so long as it is not in another creatures possession.', 3, 1);
1768
1769-- --------------------------------------------------------
1770
1771--
1772-- Struktura tabeli dla tabeli `Umiejetnosc`
1773--
1774
1775CREATE TABLE IF NOT EXISTS `Umiejetnosc` (
1776  `IdUmiejetnosci` int(11) NOT NULL AUTO_INCREMENT,
1777  `IdPostaci` int(11) NOT NULL,
1778  `IdSzablonuUmiejetnosci` int(11) NOT NULL,
1779  `PoziomUmiejetnosci` int(11) NOT NULL,
1780  `ModyfikatorPoziomuUmiejetnosci` int(11) NOT NULL,
1781  PRIMARY KEY (`IdUmiejetnosci`),
1782  KEY `FK_KorzystaZSzablonu` (`IdSzablonuUmiejetnosci`),
1783  KEY `FK_Uzywa` (`IdPostaci`)
1784) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=960 ;
1785
1786--
1787-- Zrzut danych tabeli `Umiejetnosc`
1788--
1789
1790INSERT INTO `Umiejetnosc` (`IdUmiejetnosci`, `IdPostaci`, `IdSzablonuUmiejetnosci`, `PoziomUmiejetnosci`, `ModyfikatorPoziomuUmiejetnosci`) VALUES
1791(888, 1131, 116, 5, 31),
1792(889, 1180, 121, 1, 40),
1793(890, 1167, 124, 2, 77),
1794(891, 1174, 126, 4, 96),
1795(892, 1195, 115, 5, 10),
1796(893, 1163, 129, 2, 61),
1797(894, 1172, 122, 5, 42),
1798(895, 1117, 123, 5, 57),
1799(896, 1196, 116, 2, 6),
1800(897, 1161, 120, 4, 72),
1801(898, 1141, 119, 5, 20),
1802(899, 1146, 123, 3, 34),
1803(900, 1141, 127, 1, 61),
1804(901, 1167, 119, 1, 62),
1805(902, 1140, 123, 4, 13),
1806(903, 1117, 118, 3, 14),
1807(904, 1137, 127, 4, 1),
1808(905, 1171, 117, 4, 25),
1809(906, 1166, 128, 3, 22),
1810(907, 1144, 118, 3, 16),
1811(908, 1175, 123, 3, 60),
1812(909, 1169, 125, 4, 9),
1813(910, 1139, 127, 5, 83),
1814(911, 1176, 115, 2, 24),
1815(912, 1167, 126, 4, 32),
1816(913, 1130, 118, 3, 50),
1817(914, 1160, 127, 5, 99),
1818(915, 1206, 119, 1, 31),
1819(916, 1125, 127, 2, 95),
1820(917, 1139, 123, 3, 8),
1821(918, 1123, 124, 3, 90),
1822(919, 1158, 124, 1, 74),
1823(920, 1144, 120, 4, 61),
1824(921, 1182, 117, 5, 4),
1825(922, 1197, 124, 5, 16),
1826(923, 1206, 120, 2, 70),
1827(924, 1144, 115, 1, 4),
1828(925, 1119, 123, 5, 59),
1829(926, 1130, 122, 1, 21),
1830(927, 1151, 119, 4, 55),
1831(928, 1129, 119, 3, 98),
1832(929, 1143, 120, 3, 33),
1833(930, 1119, 127, 1, 75),
1834(931, 1122, 128, 1, 21),
1835(932, 1198, 126, 5, 66),
1836(933, 1204, 116, 2, 60),
1837(934, 1146, 115, 3, 7),
1838(935, 1188, 125, 3, 52),
1839(936, 1167, 129, 2, 1),
1840(937, 1141, 120, 2, 86),
1841(938, 1200, 128, 3, 37),
1842(939, 1121, 118, 4, 64),
1843(940, 1148, 121, 3, 13),
1844(941, 1173, 125, 5, 7),
1845(942, 1117, 126, 4, 25),
1846(943, 1127, 117, 1, 44),
1847(944, 1148, 127, 4, 68),
1848(945, 1117, 124, 1, 5),
1849(946, 1115, 118, 1, 1),
1850(947, 1119, 115, 3, 81),
1851(948, 1179, 124, 4, 21),
1852(949, 1124, 127, 4, 89),
1853(950, 1170, 130, 5, 4),
1854(951, 1201, 121, 1, 11),
1855(952, 1166, 121, 5, 53),
1856(953, 1153, 126, 1, 31),
1857(954, 1184, 122, 1, 18),
1858(955, 1191, 127, 4, 49),
1859(956, 1121, 127, 5, 12),
1860(957, 1160, 130, 5, 97),
1861(958, 1173, 120, 3, 13),
1862(959, 1179, 127, 2, 29);
1863
1864-- --------------------------------------------------------
1865
1866--
1867-- Struktura tabeli dla tabeli `UmiejetnoscSpecjalna`
1868--
1869
1870CREATE TABLE IF NOT EXISTS `UmiejetnoscSpecjalna` (
1871  `IdUmiejetnosciSpecjalnej` int(11) NOT NULL AUTO_INCREMENT,
1872  `NazwaUmiejetnosciSpecjalnej` char(255) NOT NULL,
1873  `OpisUmiejetnosciSpecjalnej` text NOT NULL,
1874  PRIMARY KEY (`IdUmiejetnosciSpecjalnej`)
1875) ENGINE=InnoDB  DEFAULT CHARSET=latin2 AUTO_INCREMENT=129 ;
1876
1877--
1878-- Zrzut danych tabeli `UmiejetnoscSpecjalna`
1879--
1880
1881INSERT INTO `UmiejetnoscSpecjalna` (`IdUmiejetnosciSpecjalnej`, `NazwaUmiejetnosciSpecjalnej`, `OpisUmiejetnosciSpecjalnej`) VALUES
1882(113, 'Hunting', '-'),
1883(114, 'Glassblowing', '-'),
1884(115, 'Poledancing', '-'),
1885(116, 'Map-making', '-'),
1886(117, 'Stage magic', '-'),
1887(118, 'Socializing', '-'),
1888(119, 'Sorcery', '-'),
1889(120, 'Sewing', '-'),
1890(121, 'Pyrotechniques', '-'),
1891(122, 'Martial Arts', '-'),
1892(123, 'Juggling', '-'),
1893(124, 'Sculpting', '-'),
1894(125, 'Marksmanship', '-'),
1895(126, 'Tracking', '-'),
1896(127, 'Wrapping presents', '-'),
1897(128, 'Knitting', '-');
1898
1899-- --------------------------------------------------------
1900
1901--
1902-- Struktura tabeli dla tabeli `UmiejetnoscZaPoziom`
1903--
1904
1905CREATE TABLE IF NOT EXISTS `UmiejetnoscZaPoziom` (
1906  `IdUmiejetnosciSpecjalnej` int(11) NOT NULL,
1907  `IdPoziomu` int(11) NOT NULL,
1908  PRIMARY KEY (`IdUmiejetnosciSpecjalnej`,`IdPoziomu`),
1909  KEY `FK_DajeUmiejetnoscSpecjalna` (`IdPoziomu`)
1910) ENGINE=InnoDB DEFAULT CHARSET=latin2;
1911
1912--
1913-- Zrzut danych tabeli `UmiejetnoscZaPoziom`
1914--
1915
1916INSERT INTO `UmiejetnoscZaPoziom` (`IdUmiejetnosciSpecjalnej`, `IdPoziomu`) VALUES
1917(113, 1),
1918(114, 1);
1919
1920-- --------------------------------------------------------
1921
1922--
1923-- Struktura tabeli dla tabeli `Zaklecie`
1924--
1925
1926CREATE TABLE IF NOT EXISTS `Zaklecie` (
1927  `IdSzablonuZaklecia` int(11) NOT NULL,
1928  `IdPostaci` int(11) NOT NULL,
1929  `IloscPozostalychUzyc` int(11) NOT NULL,
1930  PRIMARY KEY (`IdSzablonuZaklecia`,`IdPostaci`),
1931  KEY `FK_Zna` (`IdPostaci`)
1932) ENGINE=InnoDB DEFAULT CHARSET=latin2;
1933
1934--
1935-- Zrzut danych tabeli `Zaklecie`
1936--
1937
1938INSERT INTO `Zaklecie` (`IdSzablonuZaklecia`, `IdPostaci`, `IloscPozostalychUzyc`) VALUES
1939(69, 1118, 10),
1940(69, 1128, 3),
1941(69, 1133, 9),
1942(69, 1134, 2),
1943(69, 1139, 8),
1944(69, 1140, 8),
1945(69, 1143, 8),
1946(69, 1152, 3),
1947(69, 1154, 2),
1948(69, 1155, 10),
1949(69, 1156, 3),
1950(69, 1157, 5),
1951(69, 1160, 6),
1952(69, 1172, 6),
1953(69, 1173, 10),
1954(69, 1174, 7),
1955(69, 1178, 6),
1956(69, 1179, 6),
1957(69, 1181, 8),
1958(69, 1182, 2),
1959(69, 1185, 4),
1960(69, 1195, 9),
1961(69, 1201, 7),
1962(70, 1115, 4),
1963(70, 1116, 4),
1964(70, 1120, 2),
1965(70, 1121, 8),
1966(70, 1123, 10),
1967(70, 1124, 3),
1968(70, 1128, 9),
1969(70, 1136, 2),
1970(70, 1145, 7),
1971(70, 1146, 2),
1972(70, 1147, 1),
1973(70, 1164, 2),
1974(70, 1166, 3),
1975(70, 1174, 7),
1976(70, 1175, 6),
1977(70, 1178, 4),
1978(70, 1187, 4),
1979(70, 1188, 2),
1980(70, 1204, 6),
1981(71, 1118, 2),
1982(71, 1130, 8),
1983(71, 1134, 4),
1984(71, 1135, 6),
1985(71, 1136, 8),
1986(71, 1140, 5),
1987(71, 1141, 9),
1988(71, 1142, 7),
1989(71, 1146, 4),
1990(71, 1147, 4),
1991(71, 1157, 2),
1992(71, 1163, 9),
1993(71, 1171, 9),
1994(71, 1172, 5),
1995(71, 1175, 10),
1996(71, 1176, 3),
1997(71, 1177, 5),
1998(71, 1186, 1),
1999(71, 1188, 8),
2000(71, 1189, 2),
2001(71, 1197, 8),
2002(71, 1199, 4),
2003(72, 1117, 6),
2004(72, 1119, 6),
2005(72, 1124, 10),
2006(72, 1132, 4),
2007(72, 1134, 1),
2008(72, 1135, 6),
2009(72, 1137, 5),
2010(72, 1141, 3),
2011(72, 1142, 9),
2012(72, 1143, 1),
2013(72, 1146, 2),
2014(72, 1149, 2),
2015(72, 1155, 6),
2016(72, 1166, 2),
2017(72, 1167, 8),
2018(72, 1168, 9),
2019(72, 1182, 9),
2020(72, 1183, 3),
2021(72, 1187, 6),
2022(72, 1191, 3),
2023(72, 1196, 7),
2024(72, 1197, 3),
2025(72, 1198, 7),
2026(72, 1199, 1),
2027(72, 1204, 2),
2028(72, 1205, 8),
2029(73, 1118, 10),
2030(73, 1127, 6),
2031(73, 1129, 2),
2032(73, 1140, 6),
2033(73, 1141, 8),
2034(73, 1145, 1),
2035(73, 1146, 6),
2036(73, 1150, 9),
2037(73, 1152, 3),
2038(73, 1154, 10),
2039(73, 1160, 2),
2040(73, 1162, 6),
2041(73, 1163, 2),
2042(73, 1168, 2),
2043(73, 1178, 9),
2044(73, 1182, 3),
2045(73, 1186, 3),
2046(73, 1195, 4),
2047(73, 1199, 3),
2048(73, 1204, 2),
2049(74, 1119, 1),
2050(74, 1123, 4),
2051(74, 1127, 7),
2052(74, 1129, 3),
2053(74, 1130, 2),
2054(74, 1135, 3),
2055(74, 1136, 5),
2056(74, 1139, 4),
2057(74, 1143, 6),
2058(74, 1149, 4),
2059(74, 1155, 1),
2060(74, 1162, 3),
2061(74, 1165, 9),
2062(74, 1167, 4),
2063(74, 1173, 7),
2064(74, 1176, 6),
2065(74, 1177, 3),
2066(74, 1185, 7),
2067(74, 1199, 9),
2068(75, 1127, 6),
2069(75, 1132, 7),
2070(75, 1154, 10),
2071(75, 1156, 6),
2072(75, 1157, 1),
2073(75, 1159, 7),
2074(75, 1166, 6),
2075(75, 1167, 1),
2076(75, 1168, 9),
2077(75, 1170, 2),
2078(75, 1171, 8),
2079(75, 1173, 6),
2080(75, 1174, 2),
2081(75, 1178, 4),
2082(75, 1191, 8),
2083(75, 1196, 10),
2084(75, 1197, 5),
2085(76, 1117, 8),
2086(76, 1119, 9),
2087(76, 1120, 2),
2088(76, 1130, 6),
2089(76, 1131, 7),
2090(76, 1132, 3),
2091(76, 1137, 6),
2092(76, 1142, 10),
2093(76, 1149, 1),
2094(76, 1157, 8),
2095(76, 1160, 9),
2096(76, 1168, 1),
2097(76, 1170, 4),
2098(76, 1177, 5),
2099(76, 1179, 4),
2100(76, 1182, 5),
2101(76, 1187, 8),
2102(76, 1191, 5),
2103(76, 1193, 2),
2104(76, 1195, 5),
2105(76, 1196, 10),
2106(76, 1197, 3),
2107(76, 1204, 8);
2108
2109--
2110-- Ograniczenia dla zrzutów tabel
2111--
2112
2113--
2114-- Ograniczenia dla tabeli `Atut`
2115--
2116ALTER TABLE `Atut`
2117  ADD CONSTRAINT `FK_CechujeSie` FOREIGN KEY (`IdKlasyAtutu`) REFERENCES `KlasaAtutu` (`IdKlasyAtutu`);
2118
2119--
2120-- Ograniczenia dla tabeli `AtutZaPoziom`
2121--
2122ALTER TABLE `AtutZaPoziom`
2123  ADD CONSTRAINT `FK_DotyczyAtutu` FOREIGN KEY (`IdAtutu`) REFERENCES `Atut` (`IdAtutu`),
2124  ADD CONSTRAINT `FK_DajeAtut` FOREIGN KEY (`IdPoziomu`) REFERENCES `Poziom` (`IdPoziomu`);
2125
2126--
2127-- Ograniczenia dla tabeli `Postac`
2128--
2129ALTER TABLE `Postac`
2130  ADD CONSTRAINT `FK_DziedziczySzablon` FOREIGN KEY (`IdSzablonuPostaci`) REFERENCES `SzablonPostaci` (`IdSzablonuPostaci`),
2131  ADD CONSTRAINT `FK_Posiada` FOREIGN KEY (`IdGracza`) REFERENCES `Gracz` (`IdGracza`),
2132  ADD CONSTRAINT `FK_Wyznaje` FOREIGN KEY (`IdBostwa`) REFERENCES `Bostwo` (`IdBostwa`),
2133  ADD CONSTRAINT `FK_ZnajdujeSie` FOREIGN KEY (`IdLokacji`) REFERENCES `Lokacja` (`IdLokacji`);
2134
2135--
2136-- Ograniczenia dla tabeli `Poziom`
2137--
2138ALTER TABLE `Poziom`
2139  ADD CONSTRAINT `FK_DotyczyKlasy` FOREIGN KEY (`IdKlasy`) REFERENCES `Klasa` (`IdKlasy`);
2140
2141--
2142-- Ograniczenia dla tabeli `Przedmiot`
2143--
2144ALTER TABLE `Przedmiot`
2145  ADD CONSTRAINT `FK_JestPosiadany` FOREIGN KEY (`IdPostaci`) REFERENCES `Postac` (`IdPostaci`),
2146  ADD CONSTRAINT `FK_ReprezentujeSzablon` FOREIGN KEY (`IdSzablonuPrzedmiotu`) REFERENCES `SzablonPrzedmiotu` (`IdSzablonuPrzedmiotu`);
2147
2148--
2149-- Ograniczenia dla tabeli `PrzydzialyAtutow`
2150--
2151ALTER TABLE `PrzydzialyAtutow`
2152  ADD CONSTRAINT `FK_PosiadaAtut` FOREIGN KEY (`IdAtutu`) REFERENCES `Atut` (`IdAtutu`),
2153  ADD CONSTRAINT `FK_PrzydzielaAtut` FOREIGN KEY (`IdPostaci`) REFERENCES `Postac` (`IdPostaci`);
2154
2155--
2156-- Ograniczenia dla tabeli `PrzydzialyUmiejetnosciSpecjalnych`
2157--
2158ALTER TABLE `PrzydzialyUmiejetnosciSpecjalnych`
2159  ADD CONSTRAINT `FK_PosiadaUmiejetnosc` FOREIGN KEY (`IdUmiejetnosciSpecjalnej`) REFERENCES `UmiejetnoscSpecjalna` (`IdUmiejetnosciSpecjalnej`),
2160  ADD CONSTRAINT `FK_PrzydzielaUmiejetnosc` FOREIGN KEY (`IdPostaci`) REFERENCES `Postac` (`IdPostaci`);
2161
2162--
2163-- Ograniczenia dla tabeli `SzablonPostaci`
2164--
2165ALTER TABLE `SzablonPostaci`
2166  ADD CONSTRAINT `FK_JestKlasy` FOREIGN KEY (`IdKlasy`) REFERENCES `Klasa` (`IdKlasy`),
2167  ADD CONSTRAINT `FK_JestRasy` FOREIGN KEY (`IdRasy`) REFERENCES `Rasa` (`IdRasy`),
2168  ADD CONSTRAINT `FK_PochodziZ` FOREIGN KEY (`IdPochodzenia`) REFERENCES `Pochodzenie` (`IdPochodzenia`);
2169
2170--
2171-- Ograniczenia dla tabeli `Umiejetnosc`
2172--
2173ALTER TABLE `Umiejetnosc`
2174  ADD CONSTRAINT `FK_KorzystaZSzablonu` FOREIGN KEY (`IdSzablonuUmiejetnosci`) REFERENCES `SzablonUmiejetnosci` (`IdSzablonuUmiejetnosci`),
2175  ADD CONSTRAINT `FK_Uzywa` FOREIGN KEY (`IdPostaci`) REFERENCES `Postac` (`IdPostaci`);
2176
2177--
2178-- Ograniczenia dla tabeli `UmiejetnoscZaPoziom`
2179--
2180ALTER TABLE `UmiejetnoscZaPoziom`
2181  ADD CONSTRAINT `FK_DajeUmiejetnoscSpecjalna` FOREIGN KEY (`IdPoziomu`) REFERENCES `Poziom` (`IdPoziomu`);
2182
2183--
2184-- Ograniczenia dla tabeli `Zaklecie`
2185--
2186ALTER TABLE `Zaklecie`
2187  ADD CONSTRAINT `FK_DotyczySzablonu` FOREIGN KEY (`IdSzablonuZaklecia`) REFERENCES `SzablonZaklecia` (`IdSzablonuZaklecia`),
2188  ADD CONSTRAINT `FK_Zna` FOREIGN KEY (`IdPostaci`) REFERENCES `Postac` (`IdPostaci`);
2189
2190/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2191/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2192/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;