· 10 years ago · Sep 15, 2016, 04:12 PM
1-- phpMyAdmin SQL Dump
2-- version 3.5.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Czas wygenerowania: 15 Wrz 2016, 18:11
7-- Wersja serwera: 5.5.21-log
8-- Wersja PHP: 5.3.20
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: `apteka`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Struktura tabeli dla tabeli `leki`
27--
28
29CREATE TABLE IF NOT EXISTS `leki` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `nazwa` text NOT NULL,
32 `cena` int(11) NOT NULL,
33 `typrefundacji` int(11) NOT NULL,
34 `czynarecepte` int(11) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
37
38--
39-- Zrzut danych tabeli `leki`
40--
41
42INSERT INTO `leki` (`id`, `nazwa`, `cena`, `typrefundacji`, `czynarecepte`) VALUES
43(1, 'ibuprom', 10, 0, 0),
44(2, 'ibupar', 22, 1, 1);
45
46-- --------------------------------------------------------
47
48--
49-- Struktura tabeli dla tabeli `szczegoly`
50--
51
52CREATE TABLE IF NOT EXISTS `szczegoly` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `id_transakcji` int(11) NOT NULL,
55 `id_leku` int(11) NOT NULL,
56 PRIMARY KEY (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;
58
59--
60-- Zrzut danych tabeli `szczegoly`
61--
62
63INSERT INTO `szczegoly` (`id`, `id_transakcji`, `id_leku`) VALUES
64(1, 3, 1),
65(2, 3, 1),
66(3, 3, 2),
67(4, 3, 2),
68(5, 4, 1),
69(6, 4, 2),
70(7, 5, 1),
71(8, 5, 2),
72(9, 5, 1),
73(10, 6, 1),
74(11, 6, 2),
75(12, 6, 1),
76(13, 7, 1),
77(14, 8, 1),
78(15, 9, 1),
79(16, 9, 2),
80(17, 10, 1),
81(18, 10, 2),
82(19, 11, 1),
83(20, 12, 1),
84(21, 13, 1),
85(22, 13, 1),
86(23, 13, 2),
87(24, 13, 2),
88(25, 13, 2),
89(26, 14, 1),
90(27, 14, 1),
91(28, 14, 2),
92(29, 14, 2),
93(30, 14, 2),
94(31, 15, 1),
95(32, 16, 1),
96(33, 17, 1),
97(34, 17, 2),
98(35, 18, 1),
99(36, 18, 2),
100(37, 19, 1),
101(38, 19, 1),
102(39, 19, 2),
103(40, 19, 2),
104(41, 20, 1),
105(42, 20, 1),
106(43, 20, 2),
107(44, 20, 2),
108(45, 21, 1),
109(46, 21, 2),
110(47, 22, 1),
111(48, 22, 2),
112(49, 23, 1),
113(50, 24, 1),
114(51, 25, 1),
115(52, 25, 2),
116(53, 26, 1),
117(54, 26, 2),
118(55, 27, 1),
119(56, 27, 1),
120(57, 27, 2),
121(58, 28, 1),
122(59, 28, 1),
123(60, 28, 2),
124(61, 29, 1),
125(62, 29, 2),
126(63, 30, 1),
127(64, 30, 2);
128
129-- --------------------------------------------------------
130
131--
132-- Struktura tabeli dla tabeli `transakcje`
133--
134
135CREATE TABLE IF NOT EXISTS `transakcje` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `kwota` int(11) NOT NULL,
138 `skonczona` int(11) NOT NULL,
139 `recepta` int(11) NOT NULL,
140 PRIMARY KEY (`id`)
141) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
142
143--
144-- Zrzut danych tabeli `transakcje`
145--
146
147INSERT INTO `transakcje` (`id`, `kwota`, `skonczona`, `recepta`) VALUES
148(1, 54, 0, 0),
149(2, 54, 0, 0),
150(3, 64, 0, 0),
151(4, 32, 0, 0),
152(5, 42, 0, 0),
153(6, 42, 0, 0),
154(7, 10, 0, 0),
155(8, 10, 0, 0),
156(9, 32, 0, 0),
157(10, 32, 0, 0),
158(11, 10, 0, 0),
159(12, 10, 0, 0),
160(13, 0, 0, 0),
161(14, 0, 0, 0),
162(15, 0, 0, 0),
163(16, 0, 0, 0),
164(17, 32, 0, 0),
165(18, 32, 0, 0),
166(19, 64, 0, 0),
167(20, 64, 0, 0),
168(21, 32, 0, 0),
169(22, 32, 0, 0),
170(23, 10, 0, 0),
171(24, 10, 0, 0),
172(25, 32, 0, 0),
173(26, 32, 1, 0),
174(27, 42, 0, 0),
175(28, 42, 1, 0),
176(29, 32, 0, 0),
177(30, 32, 0, 0);
178
179/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
180/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
181/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;