· 8 years ago · May 17, 2018, 06:34 PM
1-- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i686)
2--
3-- Host: localhost Database: test
4-- ------------------------------------------------------
5-- Server version 5.1.49-1ubuntu8.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `ADDRESSES`
20--
21
22DROP TABLE IF EXISTS `ADDRESSES`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `ADDRESSES` (
26 `address_id` int(11) NOT NULL AUTO_INCREMENT,
27 `address_postcode` varchar(5) COLLATE utf8_polish_ci NOT NULL,
28 `address_city` varchar(15) COLLATE utf8_polish_ci NOT NULL,
29 `address_street` varchar(32) COLLATE utf8_polish_ci NOT NULL,
30 `address_house` varchar(8) COLLATE utf8_polish_ci NOT NULL,
31 PRIMARY KEY (`address_id`)
32) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
33/*!40101 SET character_set_client = @saved_cs_client */;
34
35--
36-- Dumping data for table `ADDRESSES`
37--
38
39LOCK TABLES `ADDRESSES` WRITE;
40/*!40000 ALTER TABLE `ADDRESSES` DISABLE KEYS */;
41INSERT INTO `ADDRESSES` (`address_id`, `address_postcode`, `address_city`, `address_street`, `address_house`) VALUES (1,'40486','Katowice','kolista','moj');
42/*!40000 ALTER TABLE `ADDRESSES` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `EMPLOYEES`
47--
48
49DROP TABLE IF EXISTS `EMPLOYEES`;
50/*!40101 SET @saved_cs_client = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `EMPLOYEES` (
53 `employee_id` int(11) NOT NULL AUTO_INCREMENT,
54 `employee_position` enum('referent','inspektor','kierownik') COLLATE utf8_polish_ci DEFAULT NULL,
55 `personal_pesel` bigint(20) NOT NULL,
56 PRIMARY KEY (`employee_id`)
57) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
58/*!40101 SET character_set_client = @saved_cs_client */;
59
60--
61-- Dumping data for table `EMPLOYEES`
62--
63
64LOCK TABLES `EMPLOYEES` WRITE;
65/*!40000 ALTER TABLE `EMPLOYEES` DISABLE KEYS */;
66/*!40000 ALTER TABLE `EMPLOYEES` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `PERSONS`
71--
72
73DROP TABLE IF EXISTS `PERSONS`;
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `PERSONS` (
77 `person_pesel` bigint(11) NOT NULL,
78 `person_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
79 `person_secondname` varchar(32) NOT NULL,
80 `person_sex` enum('k','m') DEFAULT NULL,
81 `person_datebirth` varchar(6) NOT NULL,
82 `person_citybirth` varchar(24) NOT NULL,
83 `person_coutrybirth` varchar(24) NOT NULL,
84 `person_status` enum('maz','zona','brak') DEFAULT NULL,
85 `person_kindred` enum('brat','siostra','jedynak') DEFAULT NULL,
86 `address_id` int(11) NOT NULL,
87 PRIMARY KEY (`person_pesel`),
88 KEY `address_id` (`address_id`)
89) ENGINE=MyISAM DEFAULT CHARSET=latin1;
90/*!40101 SET character_set_client = @saved_cs_client */;
91
92--
93-- Dumping data for table `PERSONS`
94--
95
96LOCK TABLES `PERSONS` WRITE;
97/*!40000 ALTER TABLE `PERSONS` DISABLE KEYS */;
98/*!40000 ALTER TABLE `PERSONS` ENABLE KEYS */;
99UNLOCK TABLES;
100/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
101
102/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
103/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
104/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
105/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
106/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
107/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
108/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
109
110-- Dump completed on 2012-01-06 21:52:09
111Warning: The option '--all' is deprecated and will be removed in a future release. Please use --create-options instead.
112-- MySQL dump 10.13 Distrib 5.1.49, for debian-linux-gnu (i686)
113--
114-- Host: localhost Database: test
115-- ------------------------------------------------------
116-- Server version 5.1.49-1ubuntu8.1
117
118/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
119/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
120/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
121/*!40101 SET NAMES utf8 */;
122/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
123/*!40103 SET TIME_ZONE='+00:00' */;
124/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
125/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
126/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
127/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
128
129--
130-- Table structure for table `ADDRESSES`
131--
132
133DROP TABLE IF EXISTS `ADDRESSES`;
134/*!40101 SET @saved_cs_client = @@character_set_client */;
135/*!40101 SET character_set_client = utf8 */;
136CREATE TABLE `ADDRESSES` (
137 `address_id` int(11) NOT NULL AUTO_INCREMENT,
138 `address_postcode` varchar(5) COLLATE utf8_polish_ci NOT NULL,
139 `address_city` varchar(15) COLLATE utf8_polish_ci NOT NULL,
140 `address_street` varchar(32) COLLATE utf8_polish_ci NOT NULL,
141 `address_house` varchar(8) COLLATE utf8_polish_ci NOT NULL,
142 PRIMARY KEY (`address_id`)
143) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `ADDRESSES`
148--
149
150LOCK TABLES `ADDRESSES` WRITE;
151/*!40000 ALTER TABLE `ADDRESSES` DISABLE KEYS */;
152INSERT INTO `ADDRESSES` (`address_id`, `address_postcode`, `address_city`, `address_street`, `address_house`) VALUES (1,'40486','Katowice','kolista','moj');
153/*!40000 ALTER TABLE `ADDRESSES` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `EMPLOYEES`
158--
159
160DROP TABLE IF EXISTS `EMPLOYEES`;
161/*!40101 SET @saved_cs_client = @@character_set_client */;
162/*!40101 SET character_set_client = utf8 */;
163CREATE TABLE `EMPLOYEES` (
164 `employee_id` int(11) NOT NULL AUTO_INCREMENT,
165 `employee_position` enum('referent','inspektor','kierownik') COLLATE utf8_polish_ci DEFAULT NULL,
166 `personal_pesel` bigint(20) NOT NULL,
167 PRIMARY KEY (`employee_id`)
168) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `EMPLOYEES`
173--
174
175LOCK TABLES `EMPLOYEES` WRITE;
176/*!40000 ALTER TABLE `EMPLOYEES` DISABLE KEYS */;
177/*!40000 ALTER TABLE `EMPLOYEES` ENABLE KEYS */;
178UNLOCK TABLES;
179
180--
181-- Table structure for table `PERSONS`
182--
183
184DROP TABLE IF EXISTS `PERSONS`;
185/*!40101 SET @saved_cs_client = @@character_set_client */;
186/*!40101 SET character_set_client = utf8 */;
187CREATE TABLE `PERSONS` (
188 `person_pesel` bigint(11) NOT NULL,
189 `person_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
190 `person_secondname` varchar(32) NOT NULL,
191 `person_sex` enum('k','m') DEFAULT NULL,
192 `person_datebirth` varchar(6) NOT NULL,
193 `person_citybirth` varchar(24) NOT NULL,
194 `person_coutrybirth` varchar(24) NOT NULL,
195 `person_status` enum('maz','zona','brak') DEFAULT NULL,
196 `person_kindred` enum('brat','siostra','jedynak') DEFAULT NULL,
197 `address_id` int(11) NOT NULL,
198 PRIMARY KEY (`person_pesel`),
199 KEY `address_id` (`address_id`)
200) ENGINE=MyISAM DEFAULT CHARSET=latin1;
201/*!40101 SET character_set_client = @saved_cs_client */;
202
203--
204-- Dumping data for table `PERSONS`
205--
206
207LOCK TABLES `PERSONS` WRITE;
208/*!40000 ALTER TABLE `PERSONS` DISABLE KEYS */;
209/*!40000 ALTER TABLE `PERSONS` ENABLE KEYS */;
210UNLOCK TABLES;
211/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
212
213/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
214/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
215/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
216/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
217/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
218/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
219/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
220
221-- Dump completed on 2012-01-06 21:52:15