· 9 years ago · Nov 24, 2016, 08:08 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas generowania: 24 Lis 2016, 19:00
7-- Wersja serwera: 10.0.27-MariaDB-0+deb8u1
8-- Wersja PHP: 5.6.27-0+deb8u1
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: `Swiat`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `Sektor A`
27--
28
29CREATE TABLE IF NOT EXISTS `Sektor A` (
30`id` int(11) NOT NULL,
31 `x` varchar(11) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
32 `y` varchar(11) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
33 `value` int(11) NOT NULL,
34 `img` int(11) NOT NULL,
35 `color` varchar(11) NOT NULL
36) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
37
38--
39-- Zrzut danych tabeli `Sektor A`
40--
41
42INSERT INTO `Sektor A` (`id`, `x`, `y`, `value`, `img`, `color`) VALUES
43(1, '1', 'A', 0, 0, 0),
44(2, '2', 'A', 0, 0, 0),
45(3, '3', 'A', 0, 0, 0),
46(4, '4', 'A', 0, 0, 0),
47(5, '5', 'A', 0, 0, 0),
48(6, '6', 'A', 0, 0, 0),
49(7, '7', 'A', 0, 0, 0),
50(8, '8', 'A', 0, 0, 0),
51(9, '9', 'A', 0, 0, 0),
52(10, '10', 'A', 0, 0, 0),
53(11, '11', 'A', 0, 0, 0),
54(12, '12', 'A', 0, 0, 0),
55(13, '1', 'B', 0, 0, 0),
56(14, '2', 'B', 0, 0, 0),
57(15, '3', 'B', 0, 0, 0),
58(16, '4', 'B', 0, 0, 0),
59(17, '5', 'B', 0, 0, 0),
60(18, '6', 'B', 0, 0, 0),
61(19, '7', 'B', 0, 0, 0),
62(20, '8', 'B', 0, 0, 0),
63(21, '9', 'B', 0, 0, 0),
64(22, '10', 'B', 0, 0, 0),
65(23, '11', 'B', 0, 0, 0),
66(24, '12', 'B', 0, 0, 0),
67(25, '1', 'C', 0, 0, 0),
68(26, '2', 'C', 0, 0, 0),
69(27, '3', 'C', 0, 0, 0),
70(28, '4', 'C', 0, 0, 0),
71(29, '5', 'C', 0, 0, 0),
72(30, '6', 'C', 0, 0, 0),
73(31, '7', 'C', 0, 0, 0),
74(32, '8', 'C', 0, 0, 0),
75(33, '9', 'C', 0, 0, 0),
76(34, '10', 'C', 0, 0, 0),
77(35, '11', 'C', 0, 0, 0),
78(36, '12', 'C', 0, 0, 0),
79(37, '1', 'D', 0, 0, 0),
80(38, '2', 'D', 0, 0, 0),
81(39, '3', 'D', 0, 0, 0),
82(40, '4', 'D', 0, 0, 0),
83(41, '5', 'D', 0, 0, 0),
84(42, '6', 'D', 0, 0, 0),
85(43, '7', 'D', 0, 0, 0),
86(44, '8', 'D', 0, 0, 0),
87(45, '9', 'D', 0, 0, 0),
88(46, '10', 'D', 0, 0, 0),
89(47, '11', 'D', 0, 0, 0),
90(48, '12', 'D', 0, 0, 0),
91(49, '1', 'E', 0, 0, 0),
92(50, '2', 'E', 0, 0, 0),
93(51, '3', 'E', 0, 0, 0),
94(52, '4', 'E', 0, 0, 0),
95(53, '5', 'E', 0, 0, 0),
96(54, '6', 'E', 0, 0, 0),
97(55, '7', 'E', 0, 0, 0),
98(56, '8', 'E', 0, 0, 0),
99(57, '9', 'E', 0, 0, 0),
100(58, '10' 'E', 0, 0, 0),
101(59, '11', 'E', 0, 0, 0),
102(60, '12', 'E', 0, 0, 0),
103(61, '1', 'F', 0, 0, 0),
104(62, '2', 'F', 0, 0, 0),
105(63, '3', 'F', 0, 0, 0),
106(64, '4', 'F', 0, 0, 0),
107(65, '5', 'F', 0, 0, 0),
108(66, '6', 'F', 0, 0, 0),
109(67, '7', 'F', 0, 0, 0),
110(68, '8', 'F', 0, 0, 0),
111(69, '9', 'F', 0, 0, 0),
112(70, '10', 'F', 0, 0, 0),
113(71, '11', 'F', 0, 0, 0),
114(72, '12', 'F', 0, 0, 0),
115(73, '1', 'G', 0, 0, 0),
116(74, '2', 'G', 0, 0, 0),
117(75, '3', 'G', 0, 0, 0),
118(76, '4', 'G', 0, 0, 0),
119(77, '5', 'G', 0, 0, 0),
120(78, '6', 'G', 0, 0, 0),
121(79, '7', 'G', 0, 0, 0),
122(80, '8', 'G', 0, 0, 0),
123(81, '9', 'G', 0, 0, 0),
124(82, '10', 'G', 0, 0, 0),
125(83, '11', 'G', 0, 0, 0),
126(84, '12', 'G', 0, 0, 0),
127(85, '1', 'H', 0, 0, 0),
128(86, '2', 'H', 0, 0, 0),
129(87, '3', 'H', 0, 0, 0),
130(88, '4', 'H', 0, 0, 0),
131(89, '5', 'H', 0, 0, 0),
132(90, '6', 'H', 0, 0, 0),
133(91, '7', 'H', 0, 0, 0),
134(92, '8', 'H', 0, 0, 0),
135(93, '9', 'H', 0, 0, 0),
136(94, '10', 'H', 0, 0, 0),
137(95, '11', 'H', 0, 0, 0),
138(96, '12', 'H', 0, 0, 0),
139(97, '1', 'I', 0, 0, 0),
140(98, '2', 'I', 0, 0, 0),
141(99, '3', 'I', 0, 0, 0),
142(100, '4', 'I', 0, 0, 0),
143(101, '5', 'I', 0, 0, 0),
144(102, '6', 'I', 0, 0, 0),
145(103, '7', 'I', 0, 0, 0),
146(104, '8', 'I', 0, 0, 0),
147(105, '9', 'I', 0, 0, 0),
148(106, '10', 'I', 0, 0, 0),
149(107, '11', 'I', 0, 0, 0),
150(108, '12', 'I', 0, 0, 0),
151(109, '1', 'J', 0, 0, 0),
152(110, '2', 'J', 0, 0, 0),
153(111, '3', 'J', 0, 0, 0),
154(112, '4', 'J', 0, 0, 0),
155(113, '5', 'J', 0, 0, 0),
156(114, '6', 'J', 0, 0, 0),
157(115, '7', 'J', 0, 0, 0),
158(116, '8', 'J', 0, 0, 0),
159(117, '9', 'J', 0, 0, 0),
160(118, '10', 'J', 0, 0, 0),
161(119, '11', 'J', 0, 0, 0),
162(120, '12', 'J', 0, 0, 0),
163(121, '1', 'K', 0, 0, 0),
164(122, '2', 'K', 0, 0, 0),
165(123, '3', 'K', 0, 0, 0),
166(124, '4', 'K', 0, 0, 0),
167(125, '5', 'K', 0, 0, 0),
168(126, '6', 'K', 0, 0, 0),
169(127, '7', 'K', 0, 0, 0),
170(128, '8', 'K', 0, 0, 0),
171(129, '9', 'K', 0, 0, 0),
172(130, '10', 'K', 0, 0, 0),
173(131, '11', 'K', 0, 0, 0),
174(132, '12', 'K', 0, 0, 0),
175(133, '1', 'L', 0, 0, 0),
176(134, '2', 'L', 0, 0, 0),
177(135, '3', 'L', 0, 0, 0),
178(136, '4', 'L', 0, 0, 0),
179(137, '5', 'L', 0, 0, 0),
180(138, '6', 'L', 0, 0, 0),
181(139, '7', 'L', 0, 0, 0),
182(140, '8', 'L', 0, 0, 0),
183(141, '9', 'L', 0, 0, 0),
184(142, '10', 'L', 0, 0, 0),
185(143, '11', 'L', 0, 0, 0),
186(144, '12', 'L', 0, 0, 0)
187;
188
189
190
191
192--
193-- Indeksy dla zrzutów tabel
194--
195
196--
197-- Indexes for table `Sektor A`
198--
199ALTER TABLE `Sektor A`
200 ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`);
201
202--
203-- AUTO_INCREMENT for dumped tables
204--
205
206--
207-- AUTO_INCREMENT dla tabeli `Sektor A`
208--
209ALTER TABLE `Sektor A`
210MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
211/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
212/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
213/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;