1 | -- MySQL dump 10.13 Distrib 5.5.24, for debian-linux-gnu (x86_64) |
---|
2 | -- |
---|
3 | -- Host: localhost Database: WRF4GDB |
---|
4 | -- ------------------------------------------------------ |
---|
5 | -- Server version 5.1.58 |
---|
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 | -- Current Database: `WRF4GDB` |
---|
20 | -- |
---|
21 | |
---|
22 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `WRF4GDB` /*!40100 DEFAULT CHARACTER SET latin1 */; |
---|
23 | |
---|
24 | USE `WRF4GDB`; |
---|
25 | |
---|
26 | -- |
---|
27 | -- Table structure for table `Chunk` |
---|
28 | -- |
---|
29 | |
---|
30 | DROP TABLE IF EXISTS `Chunk`; |
---|
31 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
32 | /*!40101 SET character_set_client = utf8 */; |
---|
33 | CREATE TABLE `Chunk` ( |
---|
34 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
35 | `id_rea` int(11) DEFAULT NULL, |
---|
36 | `sdate` datetime DEFAULT NULL, |
---|
37 | `edate` datetime DEFAULT NULL, |
---|
38 | `wps` tinyint(1) DEFAULT '0', |
---|
39 | `status` smallint(5) unsigned DEFAULT NULL, |
---|
40 | `id_chunk` int(11) DEFAULT NULL, |
---|
41 | PRIMARY KEY (`id`), |
---|
42 | KEY `chunk_id_rea` (`id_rea`), |
---|
43 | CONSTRAINT `chunk_id_rea` FOREIGN KEY (`id_rea`) REFERENCES `Realization` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION |
---|
44 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
45 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
46 | |
---|
47 | -- |
---|
48 | -- Dumping data for table `Chunk` |
---|
49 | -- |
---|
50 | |
---|
51 | LOCK TABLES `Chunk` WRITE; |
---|
52 | /*!40000 ALTER TABLE `Chunk` DISABLE KEYS */; |
---|
53 | /*!40000 ALTER TABLE `Chunk` ENABLE KEYS */; |
---|
54 | UNLOCK TABLES; |
---|
55 | |
---|
56 | -- |
---|
57 | -- Table structure for table `Events` |
---|
58 | -- |
---|
59 | |
---|
60 | DROP TABLE IF EXISTS `Events`; |
---|
61 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
62 | /*!40101 SET character_set_client = utf8 */; |
---|
63 | CREATE TABLE `Events` ( |
---|
64 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
65 | `id_job` int(11) DEFAULT NULL, |
---|
66 | `status` int(11) DEFAULT NULL, |
---|
67 | `timestamp` datetime DEFAULT NULL, |
---|
68 | PRIMARY KEY (`id`), |
---|
69 | KEY `chunkstatus_id_job` (`id_job`), |
---|
70 | KEY `jobstatus_id_job` (`status`), |
---|
71 | CONSTRAINT `chunkstatus_id_job` FOREIGN KEY (`id_job`) REFERENCES `Job` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, |
---|
72 | CONSTRAINT `jobstatus_id_job` FOREIGN KEY (`status`) REFERENCES `Jobstatus` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION |
---|
73 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
74 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
75 | |
---|
76 | -- |
---|
77 | -- Dumping data for table `Events` |
---|
78 | -- |
---|
79 | |
---|
80 | LOCK TABLES `Events` WRITE; |
---|
81 | /*!40000 ALTER TABLE `Events` DISABLE KEYS */; |
---|
82 | /*!40000 ALTER TABLE `Events` ENABLE KEYS */; |
---|
83 | UNLOCK TABLES; |
---|
84 | |
---|
85 | -- |
---|
86 | -- Table structure for table `Experiment` |
---|
87 | -- |
---|
88 | |
---|
89 | DROP TABLE IF EXISTS `Experiment`; |
---|
90 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
91 | /*!40101 SET character_set_client = utf8 */; |
---|
92 | CREATE TABLE `Experiment` ( |
---|
93 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
94 | `name` varchar(512) NOT NULL, |
---|
95 | `sdate` datetime DEFAULT NULL, |
---|
96 | `edate` datetime DEFAULT NULL, |
---|
97 | `multiple_parameters` tinyint(1) DEFAULT NULL, |
---|
98 | `multiple_dates` tinyint(1) DEFAULT NULL, |
---|
99 | `basepath` varchar(300) DEFAULT NULL, |
---|
100 | `multiparams_labels` varchar(1024) DEFAULT NULL, |
---|
101 | `experiment_description` varchar(1024) DEFAULT NULL, |
---|
102 | `id_user` int(11) DEFAULT NULL, |
---|
103 | PRIMARY KEY (`id`), |
---|
104 | UNIQUE KEY `name_UNIQUE` (`name`), |
---|
105 | KEY `exp_id_user` (`id_user`), |
---|
106 | CONSTRAINT `exp_id_user` FOREIGN KEY (`id_user`) REFERENCES `User` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION |
---|
107 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
108 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
109 | |
---|
110 | -- |
---|
111 | -- Dumping data for table `Experiment` |
---|
112 | -- |
---|
113 | |
---|
114 | LOCK TABLES `Experiment` WRITE; |
---|
115 | /*!40000 ALTER TABLE `Experiment` DISABLE KEYS */; |
---|
116 | /*!40000 ALTER TABLE `Experiment` ENABLE KEYS */; |
---|
117 | UNLOCK TABLES; |
---|
118 | |
---|
119 | -- |
---|
120 | -- Table structure for table `File` |
---|
121 | -- |
---|
122 | |
---|
123 | DROP TABLE IF EXISTS `File`; |
---|
124 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
125 | /*!40101 SET character_set_client = utf8 */; |
---|
126 | CREATE TABLE `File` ( |
---|
127 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
128 | `id_rea` int(11) DEFAULT NULL, |
---|
129 | `name` varchar(45) DEFAULT NULL, |
---|
130 | `type` int(11) DEFAULT NULL, |
---|
131 | `sdate` datetime DEFAULT NULL, |
---|
132 | `edate` datetime DEFAULT NULL, |
---|
133 | PRIMARY KEY (`id`), |
---|
134 | KEY `file_id_rea` (`id_rea`), |
---|
135 | KEY `file_type` (`type`), |
---|
136 | CONSTRAINT `file_id_rea` FOREIGN KEY (`id_rea`) REFERENCES `Realization` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, |
---|
137 | CONSTRAINT `file_type` FOREIGN KEY (`type`) REFERENCES `Filetype` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION |
---|
138 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
139 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
140 | |
---|
141 | -- |
---|
142 | -- Dumping data for table `File` |
---|
143 | -- |
---|
144 | |
---|
145 | LOCK TABLES `File` WRITE; |
---|
146 | /*!40000 ALTER TABLE `File` DISABLE KEYS */; |
---|
147 | /*!40000 ALTER TABLE `File` ENABLE KEYS */; |
---|
148 | UNLOCK TABLES; |
---|
149 | |
---|
150 | -- |
---|
151 | -- Table structure for table `Filetype` |
---|
152 | -- |
---|
153 | |
---|
154 | DROP TABLE IF EXISTS `Filetype`; |
---|
155 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
156 | /*!40101 SET character_set_client = utf8 */; |
---|
157 | CREATE TABLE `Filetype` ( |
---|
158 | `id` int(11) NOT NULL, |
---|
159 | `type` varchar(20) DEFAULT NULL, |
---|
160 | `descr` varchar(2000) DEFAULT NULL, |
---|
161 | `format` varchar(20) DEFAULT NULL, |
---|
162 | PRIMARY KEY (`id`) |
---|
163 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
164 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
165 | |
---|
166 | -- |
---|
167 | -- Dumping data for table `Filetype` |
---|
168 | -- |
---|
169 | |
---|
170 | LOCK TABLES `Filetype` WRITE; |
---|
171 | /*!40000 ALTER TABLE `Filetype` DISABLE KEYS */; |
---|
172 | /*!40000 ALTER TABLE `Filetype` ENABLE KEYS */; |
---|
173 | UNLOCK TABLES; |
---|
174 | |
---|
175 | -- |
---|
176 | -- Table structure for table `Job` |
---|
177 | -- |
---|
178 | |
---|
179 | DROP TABLE IF EXISTS `Job`; |
---|
180 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
181 | /*!40101 SET character_set_client = utf8 */; |
---|
182 | CREATE TABLE `Job` ( |
---|
183 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
184 | `gw_job` int(11) DEFAULT NULL, |
---|
185 | `gw_restarted` int(11) DEFAULT '0', |
---|
186 | `gw_array` int(11) DEFAULT NULL, |
---|
187 | `id_chunk` int(11) DEFAULT NULL, |
---|
188 | `resource` varchar(45) DEFAULT NULL, |
---|
189 | `status` int(11) DEFAULT '0', |
---|
190 | `hash` varchar(33) DEFAULT NULL, |
---|
191 | `wn` varchar(45) DEFAULT NULL, |
---|
192 | `exitcode` int(11) DEFAULT NULL, |
---|
193 | PRIMARY KEY (`id`), |
---|
194 | KEY `job_id_chunk` (`id_chunk`), |
---|
195 | KEY `job_id_jobstatus` (`status`), |
---|
196 | CONSTRAINT `job_id_chunk` FOREIGN KEY (`id_chunk`) REFERENCES `Chunk` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, |
---|
197 | CONSTRAINT `job_id_jobstatus` FOREIGN KEY (`status`) REFERENCES `Jobstatus` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION |
---|
198 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
199 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
200 | |
---|
201 | -- |
---|
202 | -- Dumping data for table `Job` |
---|
203 | -- |
---|
204 | |
---|
205 | LOCK TABLES `Job` WRITE; |
---|
206 | /*!40000 ALTER TABLE `Job` DISABLE KEYS */; |
---|
207 | /*!40000 ALTER TABLE `Job` ENABLE KEYS */; |
---|
208 | UNLOCK TABLES; |
---|
209 | |
---|
210 | -- |
---|
211 | -- Table structure for table `Jobstatus` |
---|
212 | -- |
---|
213 | |
---|
214 | DROP TABLE IF EXISTS `Jobstatus`; |
---|
215 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
216 | /*!40101 SET character_set_client = utf8 */; |
---|
217 | CREATE TABLE `Jobstatus` ( |
---|
218 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
219 | `description` varchar(45) DEFAULT NULL, |
---|
220 | PRIMARY KEY (`id`) |
---|
221 | ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1; |
---|
222 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
223 | |
---|
224 | -- |
---|
225 | -- Dumping data for table `Jobstatus` |
---|
226 | -- |
---|
227 | |
---|
228 | LOCK TABLES `Jobstatus` WRITE; |
---|
229 | /*!40000 ALTER TABLE `Jobstatus` DISABLE KEYS */; |
---|
230 | INSERT INTO `Jobstatus` VALUES (0,'Prepared'),(1,'Submitted'),(10,'Preparing WN'),(11,'Down. Bin.'),(12,'Down. Restart'),(20,'Down. WPS'),(21,'Down. Bound.'),(22,'ungrib'),(23,'metgrid'),(24,'real'),(25,'Upload. WPS'),(26,'icbcprocessor'),(29,'WRF'),(40,'Finished'),(41,'Failed'); |
---|
231 | /*!40000 ALTER TABLE `Jobstatus` ENABLE KEYS */; |
---|
232 | UNLOCK TABLES; |
---|
233 | |
---|
234 | -- |
---|
235 | -- Table structure for table `Realization` |
---|
236 | -- |
---|
237 | |
---|
238 | DROP TABLE IF EXISTS `Realization`; |
---|
239 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
240 | /*!40101 SET character_set_client = utf8 */; |
---|
241 | CREATE TABLE `Realization` ( |
---|
242 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
243 | `id_exp` int(11) DEFAULT NULL, |
---|
244 | `name` varchar(1024) NOT NULL, |
---|
245 | `sdate` datetime DEFAULT NULL, |
---|
246 | `edate` datetime DEFAULT NULL, |
---|
247 | `restart` datetime DEFAULT NULL, |
---|
248 | `status` smallint(5) unsigned DEFAULT NULL, |
---|
249 | `cdate` datetime DEFAULT NULL, |
---|
250 | `ctime` datetime DEFAULT NULL, |
---|
251 | `multiparams_label` varchar(100) DEFAULT NULL, |
---|
252 | PRIMARY KEY (`id`), |
---|
253 | KEY `rea_id_exp` (`id_exp`), |
---|
254 | CONSTRAINT `rea_id_exp` FOREIGN KEY (`id_exp`) REFERENCES `Experiment` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION |
---|
255 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
256 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
257 | |
---|
258 | -- |
---|
259 | -- Dumping data for table `Realization` |
---|
260 | -- |
---|
261 | |
---|
262 | LOCK TABLES `Realization` WRITE; |
---|
263 | /*!40000 ALTER TABLE `Realization` DISABLE KEYS */; |
---|
264 | /*!40000 ALTER TABLE `Realization` ENABLE KEYS */; |
---|
265 | UNLOCK TABLES; |
---|
266 | |
---|
267 | -- |
---|
268 | -- Table structure for table `User` |
---|
269 | -- |
---|
270 | |
---|
271 | DROP TABLE IF EXISTS `User`; |
---|
272 | /*!40101 SET @saved_cs_client = @@character_set_client */; |
---|
273 | /*!40101 SET character_set_client = utf8 */; |
---|
274 | CREATE TABLE `User` ( |
---|
275 | `id` int(11) NOT NULL AUTO_INCREMENT, |
---|
276 | `name` varchar(30) DEFAULT NULL, |
---|
277 | `CN` varchar(200) DEFAULT NULL, |
---|
278 | PRIMARY KEY (`id`) |
---|
279 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
---|
280 | /*!40101 SET character_set_client = @saved_cs_client */; |
---|
281 | |
---|
282 | -- |
---|
283 | -- Dumping data for table `User` |
---|
284 | -- |
---|
285 | |
---|
286 | LOCK TABLES `User` WRITE; |
---|
287 | /*!40000 ALTER TABLE `User` DISABLE KEYS */; |
---|
288 | /*!40000 ALTER TABLE `User` ENABLE KEYS */; |
---|
289 | UNLOCK TABLES; |
---|
290 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
291 | |
---|
292 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
293 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
294 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
295 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
296 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
297 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
298 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
299 | |
---|
300 | -- Dump completed on 2012-09-12 13:47:03 |
---|