WRF4Gframework4g_conf: WRF4GDB

File WRF4GDB, 9.6 KB (added by carlos, 9 years ago)

WRF4GDB

Line 
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
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `WRF4GDB` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `WRF4GDB`;
25
26--
27-- Table structure for table `Chunk`
28--
29
30DROP TABLE IF EXISTS `Chunk`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE 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
51LOCK TABLES `Chunk` WRITE;
52/*!40000 ALTER TABLE `Chunk` DISABLE KEYS */;
53/*!40000 ALTER TABLE `Chunk` ENABLE KEYS */;
54UNLOCK TABLES;
55
56--
57-- Table structure for table `Events`
58--
59
60DROP TABLE IF EXISTS `Events`;
61/*!40101 SET @saved_cs_client     = @@character_set_client */;
62/*!40101 SET character_set_client = utf8 */;
63CREATE 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
80LOCK TABLES `Events` WRITE;
81/*!40000 ALTER TABLE `Events` DISABLE KEYS */;
82/*!40000 ALTER TABLE `Events` ENABLE KEYS */;
83UNLOCK TABLES;
84
85--
86-- Table structure for table `Experiment`
87--
88
89DROP TABLE IF EXISTS `Experiment`;
90/*!40101 SET @saved_cs_client     = @@character_set_client */;
91/*!40101 SET character_set_client = utf8 */;
92CREATE 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
114LOCK TABLES `Experiment` WRITE;
115/*!40000 ALTER TABLE `Experiment` DISABLE KEYS */;
116/*!40000 ALTER TABLE `Experiment` ENABLE KEYS */;
117UNLOCK TABLES;
118
119--
120-- Table structure for table `File`
121--
122
123DROP TABLE IF EXISTS `File`;
124/*!40101 SET @saved_cs_client     = @@character_set_client */;
125/*!40101 SET character_set_client = utf8 */;
126CREATE 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
145LOCK TABLES `File` WRITE;
146/*!40000 ALTER TABLE `File` DISABLE KEYS */;
147/*!40000 ALTER TABLE `File` ENABLE KEYS */;
148UNLOCK TABLES;
149
150--
151-- Table structure for table `Filetype`
152--
153
154DROP TABLE IF EXISTS `Filetype`;
155/*!40101 SET @saved_cs_client     = @@character_set_client */;
156/*!40101 SET character_set_client = utf8 */;
157CREATE 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
170LOCK TABLES `Filetype` WRITE;
171/*!40000 ALTER TABLE `Filetype` DISABLE KEYS */;
172/*!40000 ALTER TABLE `Filetype` ENABLE KEYS */;
173UNLOCK TABLES;
174
175--
176-- Table structure for table `Job`
177--
178
179DROP TABLE IF EXISTS `Job`;
180/*!40101 SET @saved_cs_client     = @@character_set_client */;
181/*!40101 SET character_set_client = utf8 */;
182CREATE 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
205LOCK TABLES `Job` WRITE;
206/*!40000 ALTER TABLE `Job` DISABLE KEYS */;
207/*!40000 ALTER TABLE `Job` ENABLE KEYS */;
208UNLOCK TABLES;
209
210--
211-- Table structure for table `Jobstatus`
212--
213
214DROP TABLE IF EXISTS `Jobstatus`;
215/*!40101 SET @saved_cs_client     = @@character_set_client */;
216/*!40101 SET character_set_client = utf8 */;
217CREATE 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
228LOCK TABLES `Jobstatus` WRITE;
229/*!40000 ALTER TABLE `Jobstatus` DISABLE KEYS */;
230INSERT 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 */;
232UNLOCK TABLES;
233
234--
235-- Table structure for table `Realization`
236--
237
238DROP TABLE IF EXISTS `Realization`;
239/*!40101 SET @saved_cs_client     = @@character_set_client */;
240/*!40101 SET character_set_client = utf8 */;
241CREATE 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
262LOCK TABLES `Realization` WRITE;
263/*!40000 ALTER TABLE `Realization` DISABLE KEYS */;
264/*!40000 ALTER TABLE `Realization` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `User`
269--
270
271DROP TABLE IF EXISTS `User`;
272/*!40101 SET @saved_cs_client     = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE 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
286LOCK TABLES `User` WRITE;
287/*!40000 ALTER TABLE `User` DISABLE KEYS */;
288/*!40000 ALTER TABLE `User` ENABLE KEYS */;
289UNLOCK 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