· 8 years ago · Mar 02, 2018, 03:52 AM
1% mysqldump test
2-- MySQL dump 10.11
3--
4-- Host: localhost Database: test
5-- ------------------------------------------------------
6-- Server version 5.0.67
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
10/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
11/*!40101 SET NAMES utf8 */;
12/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
13/*!40103 SET TIME_ZONE='+00:00' */;
14/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
15/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
16/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
17/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
18
19--
20-- Table structure for table `book_in_dates`
21--
22
23DROP TABLE IF EXISTS `book_in_dates`;
24SET @saved_cs_client = @@character_set_client;
25SET character_set_client = utf8;
26CREATE TABLE `book_in_dates` (
27 `id` int(11) NOT NULL auto_increment,
28 `date` datetime default NULL,
29 `material_id` int(11) default NULL,
30 PRIMARY KEY (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32SET character_set_client = @saved_cs_client;
33
34--
35-- Dumping data for table `book_in_dates`
36--
37
38LOCK TABLES `book_in_dates` WRITE;
39/*!40000 ALTER TABLE `book_in_dates` DISABLE KEYS */;
40/*!40000 ALTER TABLE `book_in_dates` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `book_out_dates`
45--
46
47DROP TABLE IF EXISTS `book_out_dates`;
48SET @saved_cs_client = @@character_set_client;
49SET character_set_client = utf8;
50CREATE TABLE `book_out_dates` (
51 `id` int(11) NOT NULL auto_increment,
52 `date` datetime default NULL,
53 `material_id` int(11) default NULL,
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56SET character_set_client = @saved_cs_client;
57
58--
59-- Dumping data for table `book_out_dates`
60--
61
62LOCK TABLES `book_out_dates` WRITE;
63/*!40000 ALTER TABLE `book_out_dates` DISABLE KEYS */;
64/*!40000 ALTER TABLE `book_out_dates` ENABLE KEYS */;
65UNLOCK TABLES;
66
67--
68-- Table structure for table `materials`
69--
70
71DROP TABLE IF EXISTS `materials`;
72SET @saved_cs_client = @@character_set_client;
73SET character_set_client = utf8;
74CREATE TABLE `materials` (
75 `id` int(11) NOT NULL auto_increment,
76 `nazwa` varchar(50) default NULL,
77 `typ` int(11) default NULL,
78 PRIMARY KEY (`id`)
79) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80SET character_set_client = @saved_cs_client;
81
82--
83-- Dumping data for table `materials`
84--
85
86LOCK TABLES `materials` WRITE;
87/*!40000 ALTER TABLE `materials` DISABLE KEYS */;
88/*!40000 ALTER TABLE `materials` ENABLE KEYS */;
89UNLOCK TABLES;
90
91--
92-- Table structure for table `materials_printers`
93--
94
95DROP TABLE IF EXISTS `materials_printers`;
96SET @saved_cs_client = @@character_set_client;
97SET character_set_client = utf8;
98CREATE TABLE `materials_printers` (
99 `material_id` int(11) NOT NULL,
100 `printer_id` int(11) NOT NULL,
101 PRIMARY KEY (`material_id`,`printer_id`)
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103SET character_set_client = @saved_cs_client;
104
105--
106-- Dumping data for table `materials_printers`
107--
108
109LOCK TABLES `materials_printers` WRITE;
110/*!40000 ALTER TABLE `materials_printers` DISABLE KEYS */;
111/*!40000 ALTER TABLE `materials_printers` ENABLE KEYS */;
112UNLOCK TABLES;
113
114--
115-- Table structure for table `printers`
116--
117
118DROP TABLE IF EXISTS `printers`;
119SET @saved_cs_client = @@character_set_client;
120SET character_set_client = utf8;
121CREATE TABLE `printers` (
122 `id` int(11) NOT NULL auto_increment,
123 `nazwa` varchar(50) default NULL,
124 `producent` varchar(50) default NULL,
125 `flaga` int(11) default NULL,
126 PRIMARY KEY (`id`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128SET character_set_client = @saved_cs_client;
129
130--
131-- Dumping data for table `printers`
132--
133
134LOCK TABLES `printers` WRITE;
135/*!40000 ALTER TABLE `printers` DISABLE KEYS */;
136/*!40000 ALTER TABLE `printers` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `sessions`
141--
142
143DROP TABLE IF EXISTS `sessions`;
144SET @saved_cs_client = @@character_set_client;
145SET character_set_client = utf8;
146CREATE TABLE `sessions` (
147 `session_id` varchar(32) NOT NULL,
148 `data` text,
149 `created_at` datetime default NULL,
150 PRIMARY KEY (`session_id`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf8;
152SET character_set_client = @saved_cs_client;
153
154--
155-- Dumping data for table `sessions`
156--
157
158LOCK TABLES `sessions` WRITE;
159/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
160/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
161UNLOCK TABLES;
162
163--
164-- Table structure for table `users`
165--
166
167DROP TABLE IF EXISTS `users`;
168SET @saved_cs_client = @@character_set_client;
169SET character_set_client = utf8;
170CREATE TABLE `users` (
171 `id` int(11) NOT NULL auto_increment,
172 `login` varchar(50) default NULL,
173 `crypted_password` varchar(50) default NULL,
174 `salt` varchar(50) default NULL,
175 PRIMARY KEY (`id`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177SET character_set_client = @saved_cs_client;
178
179--
180-- Dumping data for table `users`
181--
182
183LOCK TABLES `users` WRITE;
184/*!40000 ALTER TABLE `users` DISABLE KEYS */;
185/*!40000 ALTER TABLE `users` ENABLE KEYS */;
186UNLOCK TABLES;
187/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
188
189/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
190/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
191/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
192/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
193/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
194/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
195/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
196
197-- Dump completed on 2009-02-28 22:36:06