· 8 years ago · Apr 21, 2018, 12:28 PM
1- kenshi
2- Targets: Instituto Nacional de Técnica Espacial, Consejo Superior de Investigaciones CientÃficas & Instituto de AstrofÃsica de AndalucÃa
3############################
4
5# HeidiSQL Dump
6#
7# --------------------------------------------------------
8# Host: 127.0.0.1
9# Database: dss63
10# Server version: 5.0.41-community-nt
11# Server OS: Win32
12# Target-Compatibility: MySQL 5.0
13# Extended INSERTs: Y
14# max_allowed_packet: 1048576
15# HeidiSQL version: 3.0 Revision: 572
16# --------------------------------------------------------
17
18/*!40100 SET CHARACTER SET latin1*/;
19
20
21#
22# Database structure for database 'dss63'
23#
24
25CREATE DATABASE /*!32312 IF NOT EXISTS*/ `dss63` /*!40100 DEFAULT CHARACTER SET latin1 */;
26
27USE `dss63`;
28
29
30#
31# Table structure for table 'antennaconfig'
32#
33
34CREATE TABLE /*!32312 IF NOT EXISTS*/ `antennaconfig` (
35 `id` int(11) NOT NULL auto_increment,
36 `Antennas_id` int(11) NOT NULL,
37 `Scans_id` int(11) default NULL,
38 `Subscans_id` int(11) default NULL,
39 `azimuth` double default NULL,
40 `elevation` double default NULL,
41 `Tsys` double default NULL,
42 `comments` longtext NOT NULL,
43 PRIMARY KEY (`id`),
44 KEY `AntennaConfig_Antennas_id` (`Antennas_id`),
45 KEY `AntennaConfig_Scans_id` (`Scans_id`),
46 KEY `AntennaConfig_Subscans_id` (`Subscans_id`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49
50
51#
52# Dumping data for table 'antennaconfig'
53#
54
55/*!40000 ALTER TABLE `antennaconfig` DISABLE KEYS*/;
56LOCK TABLES `antennaconfig` WRITE;
57UNLOCK TABLES;
58/*!40000 ALTER TABLE `antennaconfig` ENABLE KEYS*/;
59
60
61#
62# Table structure for table 'antennas'
63#
64
65CREATE TABLE /*!32312 IF NOT EXISTS*/ `antennas` (
66 `id` int(11) NOT NULL auto_increment,
67 `name` varchar(255) NOT NULL,
68 `longitude` double default NULL,
69 `latitude` double default NULL,
70 PRIMARY KEY (`id`)
71) ENGINE=InnoDB DEFAULT CHARSET=latin1;
72
73
74
75#
76# Dumping data for table 'antennas'
77#
78
79/*!40000 ALTER TABLE `antennas` DISABLE KEYS*/;
80LOCK TABLES `antennas` WRITE;
81REPLACE INTO `antennas` (`id`, `name`, `longitude`, `latitude`) VALUES (1,'DSS63',NULL,NULL);
82UNLOCK TABLES;
83/*!40000 ALTER TABLE `antennas` ENABLE KEYS*/;
84
85
86#
87# Table structure for table 'auth_group'
88#
89
90CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_group` (
91 `id` int(11) NOT NULL auto_increment,
92 `name` varchar(80) NOT NULL,
93 PRIMARY KEY (`id`),
94 UNIQUE KEY `name` (`name`)
95) ENGINE=InnoDB DEFAULT CHARSET=latin1;
96
97
98
99#
100# Dumping data for table 'auth_group'
101#
102
103/*!40000 ALTER TABLE `auth_group` DISABLE KEYS*/;
104LOCK TABLES `auth_group` WRITE;
105UNLOCK TABLES;
106/*!40000 ALTER TABLE `auth_group` ENABLE KEYS*/;
107
108
109#
110# Table structure for table 'auth_group_permissions'
111#
112
113CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_group_permissions` (
114 `id` int(11) NOT NULL auto_increment,
115 `group_id` int(11) NOT NULL,
116 `permission_id` int(11) NOT NULL,
117 PRIMARY KEY (`id`),
118 UNIQUE KEY `group_id` (`group_id`,`permission_id`),
119 KEY `permission_id_refs_id_5886d21f` (`permission_id`)
120) ENGINE=InnoDB DEFAULT CHARSET=latin1;
121
122
123
124#
125# Dumping data for table 'auth_group_permissions'
126#
127
128/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS*/;
129LOCK TABLES `auth_group_permissions` WRITE;
130UNLOCK TABLES;
131/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS*/;
132
133
134#
135# Table structure for table 'auth_message'
136#
137
138CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_message` (
139 `id` int(11) NOT NULL auto_increment,
140 `user_id` int(11) NOT NULL,
141 `message` longtext NOT NULL,
142 PRIMARY KEY (`id`),
143 KEY `auth_message_user_id` (`user_id`)
144) ENGINE=InnoDB DEFAULT CHARSET=latin1;
145
146
147
148#
149# Dumping data for table 'auth_message'
150#
151
152/*!40000 ALTER TABLE `auth_message` DISABLE KEYS*/;
153LOCK TABLES `auth_message` WRITE;
154UNLOCK TABLES;
155/*!40000 ALTER TABLE `auth_message` ENABLE KEYS*/;
156
157
158#
159# Table structure for table 'auth_permission'
160#
161
162CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_permission` (
163 `id` int(11) NOT NULL auto_increment,
164 `name` varchar(50) NOT NULL,
165 `content_type_id` int(11) NOT NULL,
166 `codename` varchar(100) NOT NULL,
167 PRIMARY KEY (`id`),
168 UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
169 KEY `auth_permission_content_type_id` (`content_type_id`)
170) ENGINE=InnoDB DEFAULT CHARSET=latin1;
171
172
173
174#
175# Dumping data for table 'auth_permission'
176#
177
178/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS*/;
179LOCK TABLES `auth_permission` WRITE;
180REPLACE INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (1,'Can add message',1,'add_message'),
181 (2,'Can change message',1,'change_message'),
182 (3,'Can delete message',1,'delete_message'),
183 (4,'Can add group',2,'add_group'),
184 (5,'Can change group',2,'change_group'),
185 (6,'Can delete group',2,'delete_group'),
186 (7,'Can add user',3,'add_user'),
187 (8,'Can change user',3,'change_user'),
188 (9,'Can delete user',3,'delete_user'),
189 (10,'Can add permission',4,'add_permission'),
190 (11,'Can change permission',4,'change_permission'),
191 (12,'Can delete permission',4,'delete_permission'),
192 (13,'Can add content type',5,'add_contenttype'),
193 (14,'Can change content type',5,'change_contenttype'),
194 (15,'Can delete content type',5,'delete_contenttype'),
195 (16,'Can add session',6,'add_session'),
196 (17,'Can change session',6,'change_session'),
197 (18,'Can delete session',6,'delete_session'),
198 (19,'Can add log entry',7,'add_logentry'),
199 (20,'Can change log entry',7,'change_logentry'),
200 (21,'Can delete log entry',7,'delete_logentry'),
201 (22,'Can add Software Version',8,'add_softwareversions'),
202 (23,'Can change Software Version',8,'change_softwareversions'),
203 (24,'Can delete Software Version',8,'delete_softwareversions'),
204 (25,'Can add Scans Quality',9,'add_scansquality'),
205 (26,'Can change Scans Quality',9,'change_scansquality'),
206 (27,'Can delete Scans Quality',9,'delete_scansquality'),
207 (28,'Can add Observing Mode',10,'add_observingmodes'),
208 (29,'Can change Observing Mode',10,'change_observingmodes'),
209 (30,'Can delete Observing Mode',10,'delete_observingmodes'),
210 (31,'Can add expFile',11,'add_expfiles'),
211 (32,'Can change expFile',11,'change_expfiles'),
212 (33,'Can delete expFile',11,'delete_expfiles'),
213 (34,'Can add rawFile',12,'add_rawfiles'),
214 (35,'Can change rawFile',12,'change_rawfiles'),
215 (36,'Can delete rawFile',12,'delete_rawfiles'),
216 (37,'Can add reducedFile',13,'add_reducedfiles'),
217 (38,'Can change reducedFile',13,'change_reducedfiles'),
218 (39,'Can delete reducedFile',13,'delete_reducedfiles'),
219 (40,'Can add logFile',14,'add_logfiles'),
220 (41,'Can change logFile',14,'change_logfiles'),
221 (42,'Can delete logFile',14,'delete_logfiles'),
222 (43,'Can add Project',15,'add_projects'),
223 (44,'Can change Project',15,'change_projects'),
224 (45,'Can delete Project',15,'delete_projects'),
225 (46,'Can add Source',16,'add_sources'),
226 (47,'Can change Source',16,'change_sources'),
227 (48,'Can delete Source',16,'delete_sources'),
228 (49,'Can add Scan',17,'add_scans'),
229 (50,'Can change Scan',17,'change_scans'),
230 (51,'Can delete Scan',17,'delete_scans'),
231 (52,'Can add OTFMap Setting',18,'add_otfmapsettings'),
232 (53,'Can change OTFMap Setting',18,'change_otfmapsettings'),
233 (54,'Can delete OTFMap Setting',18,'delete_otfmapsettings'),
234 (55,'Can add System Name',19,'add_systemnames'),
235 (56,'Can change System Name',19,'change_systemnames'),
236 (57,'Can delete System Name',19,'delete_systemnames'),
237 (58,'Can add OnOff Setting',20,'add_onoffsettings'),
238 (59,'Can change OnOff Setting',20,'change_onoffsettings'),
239 (60,'Can delete OnOff Setting',20,'delete_onoffsettings'),
240 (61,'Can add OTF Offset',21,'add_otfoffsets'),
241 (62,'Can change OTF Offset',21,'change_otfoffsets'),
242 (63,'Can delete OTF Offset',21,'delete_otfoffsets'),
243 (64,'Can add Subscan',22,'add_subscans'),
244 (65,'Can change Subscan',22,'change_subscans'),
245 (66,'Can delete Subscan',22,'delete_subscans'),
246 (67,'Can add Flux',23,'add_flux'),
247 (68,'Can change Flux',23,'change_flux'),
248 (69,'Can delete Flux',23,'delete_flux'),
249 (70,'Can add Flux Unit',24,'add_fluxunits'),
250 (71,'Can change Flux Unit',24,'change_fluxunits'),
251 (72,'Can delete Flux Unit',24,'delete_fluxunits'),
252 (73,'Can add Receivers Configuration',25,'add_receiverscfg'),
253 (74,'Can change Receivers Configuration',25,'change_receiverscfg'),
254 (75,'Can delete Receivers Configuration',25,'delete_receiverscfg'),
255 (76,'Can add Receiver Name',26,'add_receiversnames'),
256 (77,'Can change Receiver Name',26,'change_receiversnames'),
257 (78,'Can delete Receiver Name',26,'delete_receiversnames'),
258 (79,'Can add Receiver',27,'add_receivers'),
259 (80,'Can change Receiver',27,'change_receivers'),
260 (81,'Can delete Receiver',27,'delete_receivers'),
261 (82,'Can add Backend',28,'add_backends'),
262 (83,'Can change Backend',28,'change_backends'),
263 (84,'Can delete Backend',28,'delete_backends'),
264 (85,'Can add Backend Name',29,'add_backendsnames'),
265 (86,'Can change Backend Name',29,'change_backendsnames'),
266 (87,'Can delete Backend Name',29,'delete_backendsnames'),
267 (88,'Can add Switching Value',30,'add_switchingvalues'),
268 (89,'Can change Switching Value',30,'change_switchingvalues'),
269 (90,'Can delete Switching Value',30,'delete_switchingvalues'),
270 (91,'Can add Switching Mode',31,'add_switchingmodes'),
271 (92,'Can change Switching Mode',31,'change_switchingmodes'),
272 (93,'Can delete Switching Mode',31,'delete_switchingmodes'),
273 (94,'Can add Frequency Switching',32,'add_frequencyswitching'),
274 (95,'Can change Frequency Switching',32,'change_frequencyswitching'),
275 (96,'Can delete Frequency Switching',32,'delete_frequencyswitching'),
276 (97,'Can add Calibration Setting',33,'add_calibrationsettings'),
277 (98,'Can change Calibration Setting',33,'change_calibrationsettings'),
278 (99,'Can delete Calibration Setting',33,'delete_calibrationsettings'),
279 (100,'Can add Focus Setting',34,'add_focussettings'),
280 (101,'Can change Focus Setting',34,'change_focussettings'),
281 (102,'Can delete Focus Setting',34,'delete_focussettings'),
282 (103,'Can add Pointing Setting',35,'add_pointingsettings'),
283 (104,'Can change Pointing Setting',35,'change_pointingsettings'),
284 (105,'Can delete Pointing Setting',35,'delete_pointingsettings'),
285 (106,'Can add Antenna',36,'add_antennas'),
286 (107,'Can change Antenna',36,'change_antennas'),
287 (108,'Can delete Antenna',36,'delete_antennas'),
288 (109,'Can add Antenna Configuration',37,'add_antennaconfig'),
289 (110,'Can change Antenna Configuration',37,'change_antennaconfig'),
290 (111,'Can delete Antenna Configuration',37,'delete_antennaconfig'),
291 (112,'Can add Sources Log',38,'add_sourcelogs'),
292 (113,'Can change Sources Log',38,'change_sourcelogs'),
293 (114,'Can delete Sources Log',38,'delete_sourcelogs'),
294 (115,'Can add LogsT',39,'add_logst'),
295 (116,'Can change LogsT',39,'change_logst'),
296 (117,'Can delete LogsT',39,'delete_logst'),
297 (118,'Can add Weather Tau',40,'add_weathertau'),
298 (119,'Can change Weather Tau',40,'change_weathertau'),
299 (120,'Can delete Weather Tau',40,'delete_weathertau'),
300 (121,'Can add Log',41,'add_logs'),
301 (122,'Can change Log',41,'change_logs'),
302 (123,'Can delete Log',41,'delete_logs'),
303 (124,'Can add Weather Station',42,'add_weatherstation'),
304 (125,'Can change Weather Station',42,'change_weatherstation'),
305 (126,'Can delete Weather Station',42,'delete_weatherstation'),
306 (127,'Can add LogsExp',43,'add_logsexp'),
307 (128,'Can change LogsExp',43,'change_logsexp'),
308 (129,'Can delete LogsExp',43,'delete_logsexp');
309UNLOCK TABLES;
310/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS*/;
311
312
313#
314# Table structure for table 'auth_user'
315#
316
317CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_user` (
318 `id` int(11) NOT NULL auto_increment,
319 `username` varchar(30) NOT NULL,
320 `first_name` varchar(30) NOT NULL,
321 `last_name` varchar(30) NOT NULL,
322 `email` varchar(75) NOT NULL,
323 `password` varchar(128) NOT NULL,
324 `is_staff` tinyint(1) NOT NULL,
325 `is_active` tinyint(1) NOT NULL,
326 `is_superuser` tinyint(1) NOT NULL,
327 `last_login` datetime NOT NULL,
328 `date_joined` datetime NOT NULL,
329 PRIMARY KEY (`id`),
330 UNIQUE KEY `username` (`username`)
331) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332
333
334
335#
336# Dumping data for table 'auth_user'
337#
338
339/*!40000 ALTER TABLE `auth_user` DISABLE KEYS*/;
340LOCK TABLES `auth_user` WRITE;
341REPLACE INTO `auth_user` (`id`, `username`, `first_name`, `last_name`, `email`, `password`, `is_staff`, `is_active`, `is_superuser`, `last_login`, `date_joined`) VALUES (1,'laeffinta','','','jmalacid@laeff.inta.es','sha1$25255$10daffc92aad167240c0830cdac74cf158e68f74',1,1,1,'2008-08-04 10:52:17','2008-05-29 21:14:14');
342UNLOCK TABLES;
343/*!40000 ALTER TABLE `auth_user` ENABLE KEYS*/;
344
345
346#
347# Table structure for table 'auth_user_groups'
348#
349
350CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_user_groups` (
351 `id` int(11) NOT NULL auto_increment,
352 `user_id` int(11) NOT NULL,
353 `group_id` int(11) NOT NULL,
354 PRIMARY KEY (`id`),
355 UNIQUE KEY `user_id` (`user_id`,`group_id`),
356 KEY `group_id_refs_id_f116770` (`group_id`)
357) ENGINE=InnoDB DEFAULT CHARSET=latin1;
358
359
360
361#
362# Dumping data for table 'auth_user_groups'
363#
364
365/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS*/;
366LOCK TABLES `auth_user_groups` WRITE;
367UNLOCK TABLES;
368/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS*/;
369
370
371#
372# Table structure for table 'auth_user_user_permissions'
373#
374
375CREATE TABLE /*!32312 IF NOT EXISTS*/ `auth_user_user_permissions` (
376 `id` int(11) NOT NULL auto_increment,
377 `user_id` int(11) NOT NULL,
378 `permission_id` int(11) NOT NULL,
379 PRIMARY KEY (`id`),
380 UNIQUE KEY `user_id` (`user_id`,`permission_id`),
381 KEY `permission_id_refs_id_67e79cb` (`permission_id`)
382) ENGINE=InnoDB DEFAULT CHARSET=latin1;
383
384
385
386#
387# Dumping data for table 'auth_user_user_permissions'
388#
389
390/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS*/;
391LOCK TABLES `auth_user_user_permissions` WRITE;
392UNLOCK TABLES;
393/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS*/;
394
395
396#
397# Table structure for table 'backends'
398#
399
400CREATE TABLE /*!32312 IF NOT EXISTS*/ `backends` (
401 `id` int(11) NOT NULL auto_increment,
402 `BackendsNames_id` int(11) NOT NULL,
403 `Receivers_id` int(11) NOT NULL,
404 `resolution` double default NULL,
405 `bandwidth` double default NULL,
406 `spb_temp` double default NULL,
407 `spb_pwr` double default NULL,
408 PRIMARY KEY (`id`),
409 KEY `Backends_BackendsNames_id` (`BackendsNames_id`),
410 KEY `Backends_Receivers_id` (`Receivers_id`)
411) ENGINE=InnoDB DEFAULT CHARSET=latin1;
412
413
414
415#
416# Dumping data for table 'backends'
417#
418
419/*!40000 ALTER TABLE `backends` DISABLE KEYS*/;
420LOCK TABLES `backends` WRITE;
421UNLOCK TABLES;
422/*!40000 ALTER TABLE `backends` ENABLE KEYS*/;
423
424
425#
426# Table structure for table 'backendsnames'
427#
428
429CREATE TABLE /*!32312 IF NOT EXISTS*/ `backendsnames` (
430 `id` int(11) NOT NULL auto_increment,
431 `name` varchar(255) NOT NULL,
432 `description` longtext NOT NULL,
433 PRIMARY KEY (`id`)
434) ENGINE=InnoDB DEFAULT CHARSET=latin1;
435
436
437
438#
439# Dumping data for table 'backendsnames'
440#
441
442/*!40000 ALTER TABLE `backendsnames` DISABLE KEYS*/;
443LOCK TABLES `backendsnames` WRITE;
444REPLACE INTO `backendsnames` (`id`, `name`, `description`) VALUES (2,'spb500','');
445UNLOCK TABLES;
446/*!40000 ALTER TABLE `backendsnames` ENABLE KEYS*/;
447
448
449#
450# Table structure for table 'calibrationsettings'
451#
452
453CREATE TABLE /*!32312 IF NOT EXISTS*/ `calibrationsettings` (
454 `id` int(11) NOT NULL auto_increment,
455 `Scans_id` int(11) NOT NULL,
456 `Receivers_id` int(11) NOT NULL,
457 PRIMARY KEY (`id`),
458 KEY `CalibrationSettings_Scans_id` (`Scans_id`),
459 KEY `CalibrationSettings_Receivers_id` (`Receivers_id`)
460) ENGINE=InnoDB DEFAULT CHARSET=latin1;
461
462
463
464#
465# Dumping data for table 'calibrationsettings'
466#
467
468/*!40000 ALTER TABLE `calibrationsettings` DISABLE KEYS*/;
469LOCK TABLES `calibrationsettings` WRITE;
470UNLOCK TABLES;
471/*!40000 ALTER TABLE `calibrationsettings` ENABLE KEYS*/;
472
473
474#
475# Table structure for table 'django_admin_log'
476#
477
478CREATE TABLE /*!32312 IF NOT EXISTS*/ `django_admin_log` (
479 `id` int(11) NOT NULL auto_increment,
480 `action_time` datetime NOT NULL,
481 `user_id` int(11) NOT NULL,
482 `content_type_id` int(11) default NULL,
483 `object_id` longtext,
484 `object_repr` varchar(200) NOT NULL,
485 `action_flag` smallint(5) unsigned NOT NULL,
486 `change_message` longtext NOT NULL,
487 PRIMARY KEY (`id`),
488 KEY `django_admin_log_user_id` (`user_id`),
489 KEY `django_admin_log_content_type_id` (`content_type_id`)
490) ENGINE=InnoDB DEFAULT CHARSET=latin1;
491
492
493
494#
495# Dumping data for table 'django_admin_log'
496#
497
498/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS*/;
499LOCK TABLES `django_admin_log` WRITE;
500REPLACE INTO `django_admin_log` (`id`, `action_time`, `user_id`, `content_type_id`, `object_id`, `object_repr`, `action_flag`, `change_message`) VALUES (1,'2008-07-23 11:27:55',1,3,'1','laeffinta',2,'Changed e-mail address, staff status, active and superuser status.'),
501 (2,'2008-08-06 10:46:19',1,38,'1','SourceLogs object',3,''),
502 (3,'2008-08-06 10:46:27',1,38,'2','SourceLogs object',1,''),
503 (4,'2008-08-06 10:46:46',1,38,'3','SourceLogs object',1,''),
504 (5,'2008-08-06 10:46:54',1,38,'4','SourceLogs object',1,''),
505 (6,'2008-08-06 10:47:02',1,38,'5','SourceLogs object',1,''),
506 (7,'2008-08-06 10:47:13',1,38,'6','SourceLogs object',1,''),
507 (8,'2008-08-06 11:00:47',1,38,'7','SourceLogs object',1,''),
508 (9,'2008-08-06 11:02:14',1,38,'7','hg',3,''),
509 (10,'2008-08-06 11:12:14',1,36,'1','Antennas object',1,''),
510 (11,'2008-08-06 11:12:37',1,36,'1','Antennas object',3,''),
511 (12,'2008-08-08 10:46:21',1,9,'1','ScansQuality object',2,'Changed name.'),
512 (13,'2008-08-08 10:52:04',1,15,'1','Projects object',2,'Changed Principal Investigator and is public.'),
513 (14,'2008-08-08 12:42:53',1,24,'1','Jy',1,''),
514 (15,'2008-08-08 12:43:07',1,24,'2','Ta',1,''),
515 (16,'2008-08-08 12:43:18',1,24,'3','Tmb',1,''),
516 (17,'2008-08-08 12:44:50',1,26,'1','spb500 < MMS-1 < K 3ch HEMT',1,''),
517 (18,'2008-08-08 15:07:50',1,29,'1','test',3,'');
518UNLOCK TABLES;
519/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS*/;
520
521
522#
523# Table structure for table 'django_content_type'
524#
525
526CREATE TABLE /*!32312 IF NOT EXISTS*/ `django_content_type` (
527 `id` int(11) NOT NULL auto_increment,
528 `name` varchar(100) NOT NULL,
529 `app_label` varchar(100) NOT NULL,
530 `model` varchar(100) NOT NULL,
531 PRIMARY KEY (`id`),
532 UNIQUE KEY `app_label` (`app_label`,`model`)
533) ENGINE=InnoDB DEFAULT CHARSET=latin1;
534
535
536
537#
538# Dumping data for table 'django_content_type'
539#
540
541/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS*/;
542LOCK TABLES `django_content_type` WRITE;
543REPLACE INTO `django_content_type` (`id`, `name`, `app_label`, `model`) VALUES (1,'message','auth','message'),
544 (2,'group','auth','group'),
545 (3,'user','auth','user'),
546 (4,'permission','auth','permission'),
547 (5,'content type','contenttypes','contenttype'),
548 (6,'session','sessions','session'),
549 (7,'log entry','admin','logentry'),
550 (8,'Software Version','others','softwareversions'),
551 (9,'Scans Quality','others','scansquality'),
552 (10,'Observing Mode','others','observingmodes'),
553 (11,'expFile','datafiller','expfiles'),
554 (12,'rawFile','datafiller','rawfiles'),
555 (13,'reducedFile','datafiller','reducedfiles'),
556 (14,'logFile','datafiller','logfiles'),
557 (15,'Project','projects','projects'),
558 (16,'Source','sources','sources'),
559 (17,'Scan','scans','scans'),
560 (18,'OTFMap Setting','otfonoff','otfmapsettings'),
561 (19,'System Name','otfonoff','systemnames'),
562 (20,'OnOff Setting','otfonoff','onoffsettings'),
563 (21,'OTF Offset','otfonoff','otfoffsets'),
564 (22,'Subscan','subscans','subscans'),
565 (23,'Flux','flux','flux'),
566 (24,'Flux Unit','flux','fluxunits'),
567 (25,'Receivers Configuration','receivers','receiverscfg'),
568 (26,'Receiver Name','receivers','receiversnames'),
569 (27,'Receiver','receivers','receivers'),
570 (28,'Backend','backends','backends'),
571 (29,'Backend Name','backends','backendsnames'),
572 (30,'Switching Value','switching','switchingvalues'),
573 (31,'Switching Mode','switching','switchingmodes'),
574 (32,'Frequency Switching','switching','frequencyswitching'),
575 (33,'Calibration Setting','observation','calibrationsettings'),
576 (34,'Focus Setting','observation','focussettings'),
577 (35,'Pointing Setting','observation','pointingsettings'),
578 (36,'Antenna','antenna','antennas'),
579 (37,'Antenna Configuration','antenna','antennaconfig'),
580 (38,'Sources Log','logs','sourcelogs'),
581 (39,'LogsT','logs','logst'),
582 (40,'Weather Tau','logs','weathertau'),
583 (41,'Log','logs','logs'),
584 (42,'Weather Station','logs','weatherstation'),
585 (43,'LogsExp','logs','logsexp');
586UNLOCK TABLES;
587/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS*/;
588
589
590#
591# Table structure for table 'django_session'
592#
593
594CREATE TABLE /*!32312 IF NOT EXISTS*/ `django_session` (
595 `session_key` varchar(40) NOT NULL,
596 `session_data` longtext NOT NULL,
597 `expire_date` datetime NOT NULL,
598 PRIMARY KEY (`session_key`)
599) ENGINE=InnoDB DEFAULT CHARSET=latin1;
600
601
602
603#
604# Dumping data for table 'django_session'
605#
606
607/*!40000 ALTER TABLE `django_session` DISABLE KEYS*/;
608LOCK TABLES `django_session` WRITE;
609REPLACE INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('289a2df41125772ac200b60e6c8f0e33','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-29 18:58:12'),
610 ('30324b4e23d6f0c3bcef0ca8b2c15a20','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-06-15 10:07:59'),
611 ('30f17c76fb6cdd335b7452dada9df3ae','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-08-06 11:27:08'),
612 ('547d9fc9b9599b9836eb44c0c889ee2c','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-06-13 13:05:54'),
613 ('5d183d05710b832de67e15173354d998','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-08-11 09:29:18'),
614 ('5df3ef12c9b33c9ea2092121f9ab035e','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-08-18 10:52:17'),
615 ('60e3567f71cfcc2299daafdfcdc67510','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-08-11 09:23:52'),
616 ('666e75516db3b86e9931888aa1cbeaa3','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-06-13 09:49:43'),
617 ('6b2c40b7823b8d9d354b95621d7c05e3','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-07 23:22:41'),
618 ('84762cf35a37515b7fc4c1cce6f4bcb7','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-06-16 11:07:17'),
619 ('895f48cabcc4e1ad67c7726883a79f8a','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-08-09 17:37:52'),
620 ('9158218dc12740c0797955d24f3b77e2','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-18 03:38:23'),
621 ('9c14a814b236846ed11605acbbcb85cb','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-14 17:17:57'),
622 ('a8a636ace429785df37b57330ac5bdc2','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-08-01 17:31:07'),
623 ('bcbf7f48f9b43bc52a77922b1611500d','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-08-09 17:36:22'),
624 ('e82196fd03b0c9dea34a1fcc8ab84aeb','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-08-14 11:21:44'),
625 ('ef97daed32ab4bd11a92f56745d89360','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-20 21:10:23'),
626 ('f65e9c50e42409e525a66ddc289461d3','gAJ9cQEoVRJfYXV0aF91c2VyX2JhY2tlbmRxAlUpZGphbmdvLmNvbnRyaWIuYXV0aC5iYWNrZW5k\ncy5Nb2RlbEJhY2tlbmRxA1UNX2F1dGhfdXNlcl9pZHEEigEBdS41M2M0NDYwOWIxMzgyYTcwZjUy\nZTllMGU2ZGM3Y2JmMA==\n','2008-08-14 13:25:18'),
627 ('fda6c54f97484523230e6a5e21639d98','gAJ9cQFVCnRlc3Rjb29raWVxAlUGd29ya2VkcQNzLmVlZWI0MTU2NmQ4ZWZmMWMwN2FiOWNkYmQy\nMDMwNWUz\n','2008-07-29 20:04:38');
628UNLOCK TABLES;
629/*!40000 ALTER TABLE `django_session` ENABLE KEYS*/;
630
631
632#
633# Table structure for table 'expfiles'
634#
635
636CREATE TABLE /*!32312 IF NOT EXISTS*/ `expfiles` (
637 `id` int(11) NOT NULL auto_increment,
638 `logFiles_id` int(11) NOT NULL,
639 `filename` varchar(255) NOT NULL,
640 `year` smallint(6) NOT NULL,
641 PRIMARY KEY (`id`),
642 UNIQUE KEY `expFiles_Unique` (`filename`),
643 KEY `expFiles_logFiles_id` (`logFiles_id`)
644) ENGINE=InnoDB DEFAULT CHARSET=latin1;
645
646
647
648#
649# Dumping data for table 'expfiles'
650#
651
652/*!40000 ALTER TABLE `expfiles` DISABLE KEYS*/;
653LOCK TABLES `expfiles` WRITE;
654UNLOCK TABLES;
655/*!40000 ALTER TABLE `expfiles` ENABLE KEYS*/;
656
657
658#
659# Table structure for table 'flux'
660#
661
662CREATE TABLE /*!32312 IF NOT EXISTS*/ `flux` (
663 `id` int(11) NOT NULL auto_increment,
664 `Scans_id` int(11) NOT NULL,
665 `FluxUnits_id` int(11) NOT NULL,
666 `Flux_max` double default NULL,
667 `Flux_min` double default NULL,
668 `Flux_integrated` double default NULL,
669 PRIMARY KEY (`id`),
670 KEY `Flux_Scans_id` (`Scans_id`),
671 KEY `Flux_FluxUnits_id` (`FluxUnits_id`)
672) ENGINE=InnoDB DEFAULT CHARSET=latin1;
673
674
675
676#
677# Dumping data for table 'flux'
678#
679
680/*!40000 ALTER TABLE `flux` DISABLE KEYS*/;
681LOCK TABLES `flux` WRITE;
682UNLOCK TABLES;
683/*!40000 ALTER TABLE `flux` ENABLE KEYS*/;
684
685
686#
687# Table structure for table 'fluxunits'
688#
689
690CREATE TABLE /*!32312 IF NOT EXISTS*/ `fluxunits` (
691 `id` int(11) NOT NULL auto_increment,
692 `name` varchar(255) NOT NULL,
693 `description` longtext NOT NULL,
694 PRIMARY KEY (`id`)
695) ENGINE=InnoDB DEFAULT CHARSET=latin1;
696
697
698
699#
700# Dumping data for table 'fluxunits'
701#
702
703/*!40000 ALTER TABLE `fluxunits` DISABLE KEYS*/;
704LOCK TABLES `fluxunits` WRITE;
705REPLACE INTO `fluxunits` (`id`, `name`, `description`) VALUES (1,'Jy','Jansky'),
706 (2,'Ta','Antenna temperature'),
707 (3,'Tmb','');
708UNLOCK TABLES;
709/*!40000 ALTER TABLE `fluxunits` ENABLE KEYS*/;
710
711
712#
713# Table structure for table 'focussettings'
714#
715
716CREATE TABLE /*!32312 IF NOT EXISTS*/ `focussettings` (
717 `id` int(11) NOT NULL auto_increment,
718 `Scans_id` int(11) NOT NULL,
719 PRIMARY KEY (`id`),
720 KEY `FocusSettings_Scans_id` (`Scans_id`)
721) ENGINE=InnoDB DEFAULT CHARSET=latin1;
722
723
724
725#
726# Dumping data for table 'focussettings'
727#
728
729/*!40000 ALTER TABLE `focussettings` DISABLE KEYS*/;
730LOCK TABLES `focussettings` WRITE;
731UNLOCK TABLES;
732/*!40000 ALTER TABLE `focussettings` ENABLE KEYS*/;
733
734
735#
736# Table structure for table 'frequencyswitching'
737#
738
739CREATE TABLE /*!32312 IF NOT EXISTS*/ `frequencyswitching` (
740 `id` int(11) NOT NULL auto_increment,
741 `SwitchingValues_id` int(11) NOT NULL,
742 `Receivers_id` int(11) NOT NULL,
743 `frequencyThrow` double default NULL,
744 PRIMARY KEY (`id`),
745 KEY `FrequencySwitching_SwitchingValues_id` (`SwitchingValues_id`),
746 KEY `FrequencySwitching_Receivers_id` (`Receivers_id`)
747) ENGINE=InnoDB DEFAULT CHARSET=latin1;
748
749
750
751#
752# Dumping data for table 'frequencyswitching'
753#
754
755/*!40000 ALTER TABLE `frequencyswitching` DISABLE KEYS*/;
756LOCK TABLES `frequencyswitching` WRITE;
757UNLOCK TABLES;
758/*!40000 ALTER TABLE `frequencyswitching` ENABLE KEYS*/;
759
760
761#
762# Table structure for table 'logfiles'
763#
764
765CREATE TABLE /*!32312 IF NOT EXISTS*/ `logfiles` (
766 `id` int(11) NOT NULL auto_increment,
767 `filename` varchar(255) NOT NULL,
768 `year` smallint(6) NOT NULL,
769 PRIMARY KEY (`id`),
770 UNIQUE KEY `logFiles_Unique` (`filename`)
771) ENGINE=InnoDB DEFAULT CHARSET=latin1;
772
773
774
775#
776# Dumping data for table 'logfiles'
777#
778
779/*!40000 ALTER TABLE `logfiles` DISABLE KEYS*/;
780LOCK TABLES `logfiles` WRITE;
781UNLOCK TABLES;
782/*!40000 ALTER TABLE `logfiles` ENABLE KEYS*/;
783
784
785#
786# Table structure for table 'logs'
787#
788
789CREATE TABLE /*!32312 IF NOT EXISTS*/ `logs` (
790 `id` int(11) NOT NULL auto_increment,
791 `timeStamp` datetime NOT NULL,
792 `T_lna` double default NULL,
793 `T_fo_assumed` double default NULL,
794 `ND_coupling_correction` double default NULL,
795 `T_ambient_load` double default NULL,
796 `Azimuth` double default NULL,
797 `Elevation` double default NULL,
798 `Frequency` double default NULL,
799 PRIMARY KEY (`id`),
800 UNIQUE KEY `timeStamp` (`timeStamp`)
801) ENGINE=InnoDB DEFAULT CHARSET=latin1;
802
803
804
805#
806# Dumping data for table 'logs'
807#
808
809/*!40000 ALTER TABLE `logs` DISABLE KEYS*/;
810LOCK TABLES `logs` WRITE;
811UNLOCK TABLES;
812/*!40000 ALTER TABLE `logs` ENABLE KEYS*/;
813
814
815#
816# Table structure for table 'logsexp'
817#
818
819CREATE TABLE /*!32312 IF NOT EXISTS*/ `logsexp` (
820 `id` int(11) NOT NULL auto_increment,
821 `timeStamp` datetime NOT NULL,
822 `gain` double default NULL,
823 `linear_corr` double default NULL,
824 `quadratic_corr` double default NULL,
825 `T_noise_diode` double default NULL,
826 `non_linearity` double default NULL,
827 PRIMARY KEY (`id`),
828 UNIQUE KEY `timeStamp` (`timeStamp`)
829) ENGINE=InnoDB DEFAULT CHARSET=latin1;
830
831
832
833#
834# Dumping data for table 'logsexp'
835#
836
837/*!40000 ALTER TABLE `logsexp` DISABLE KEYS*/;
838LOCK TABLES `logsexp` WRITE;
839UNLOCK TABLES;
840/*!40000 ALTER TABLE `logsexp` ENABLE KEYS*/;
841
842
843#
844# Table structure for table 'logst'
845#
846
847CREATE TABLE /*!32312 IF NOT EXISTS*/ `logst` (
848 `id` int(11) NOT NULL auto_increment,
849 `SourceLogs_id` int(11) NOT NULL,
850 `LogsExp_id` int(11) NOT NULL,
851 `powermeter` double default NULL,
852 `T_linear` double default NULL,
853 `T_corrected` double default NULL,
854 PRIMARY KEY (`id`),
855 KEY `LogsT_SourceLogs_id` (`SourceLogs_id`),
856 KEY `LogsT_LogsExp_id` (`LogsExp_id`)
857) ENGINE=InnoDB DEFAULT CHARSET=latin1;
858
859
860
861#
862# Dumping data for table 'logst'
863#
864
865/*!40000 ALTER TABLE `logst` DISABLE KEYS*/;
866LOCK TABLES `logst` WRITE;
867UNLOCK TABLES;
868/*!40000 ALTER TABLE `logst` ENABLE KEYS*/;
869
870
871#
872# Table structure for table 'observingmodes'
873#
874
875CREATE TABLE /*!32312 IF NOT EXISTS*/ `observingmodes` (
876 `id` int(11) NOT NULL auto_increment,
877 `name` varchar(255) NOT NULL,
878 `description` longtext NOT NULL,
879 PRIMARY KEY (`id`)
880) ENGINE=InnoDB DEFAULT CHARSET=latin1;
881
882
883
884#
885# Dumping data for table 'observingmodes'
886#
887
888/*!40000 ALTER TABLE `observingmodes` DISABLE KEYS*/;
889LOCK TABLES `observingmodes` WRITE;
890REPLACE INTO `observingmodes` (`id`, `name`, `description`) VALUES (1,'LINEPSSW','');
891UNLOCK TABLES;
892/*!40000 ALTER TABLE `observingmodes` ENABLE KEYS*/;
893
894
895#
896# Table structure for table 'onoffsettings'
897#
898
899CREATE TABLE /*!32312 IF NOT EXISTS*/ `onoffsettings` (
900 `id` int(11) NOT NULL auto_increment,
901 `Scans_id` int(11) NOT NULL,
902 `SystemNames_id` int(11) NOT NULL,
903 `xOffset` double default NULL,
904 `yOffset` double default NULL,
905 PRIMARY KEY (`id`),
906 KEY `OnOffSettings_Scans_id` (`Scans_id`),
907 KEY `OnOffSettings_SystemNames_id` (`SystemNames_id`)
908) ENGINE=InnoDB DEFAULT CHARSET=latin1;
909
910
911
912#
913# Dumping data for table 'onoffsettings'
914#
915
916/*!40000 ALTER TABLE `onoffsettings` DISABLE KEYS*/;
917LOCK TABLES `onoffsettings` WRITE;
918UNLOCK TABLES;
919/*!40000 ALTER TABLE `onoffsettings` ENABLE KEYS*/;
920
921
922#
923# Table structure for table 'otfmapsettings'
924#
925
926CREATE TABLE /*!32312 IF NOT EXISTS*/ `otfmapsettings` (
927 `id` int(11) NOT NULL auto_increment,
928 `xStart` double default NULL,
929 `yStart` double default NULL,
930 `xEnd` double default NULL,
931 `yEnd` double default NULL,
932 `xStep` double default NULL,
933 `yStep` double default NULL,
934 `speedStart` double default NULL,
935 `speedEnd` double default NULL,
936 `timePerOtf` double default NULL,
937 PRIMARY KEY (`id`)
938) ENGINE=InnoDB DEFAULT CHARSET=latin1;
939
940
941
942#
943# Dumping data for table 'otfmapsettings'
944#
945
946/*!40000 ALTER TABLE `otfmapsettings` DISABLE KEYS*/;
947LOCK TABLES `otfmapsettings` WRITE;
948UNLOCK TABLES;
949/*!40000 ALTER TABLE `otfmapsettings` ENABLE KEYS*/;
950
951
952#
953# Table structure for table 'otfoffsets'
954#
955
956CREATE TABLE /*!32312 IF NOT EXISTS*/ `otfoffsets` (
957 `id` int(11) NOT NULL auto_increment,
958 `Scans_id` int(11) NOT NULL,
959 `OTFMapSettings_id` int(11) NOT NULL,
960 `SystemNames_id` int(11) NOT NULL,
961 `xOffset` double default NULL,
962 `yOffset` double default NULL,
963 PRIMARY KEY (`id`),
964 KEY `OTFOffsets_Scans_id` (`Scans_id`),
965 KEY `OTFOffsets_OTFMapSettings_id` (`OTFMapSettings_id`),
966 KEY `OTFOffsets_SystemNames_id` (`SystemNames_id`)
967) ENGINE=InnoDB DEFAULT CHARSET=latin1;
968
969
970
971#
972# Dumping data for table 'otfoffsets'
973#
974
975/*!40000 ALTER TABLE `otfoffsets` DISABLE KEYS*/;
976LOCK TABLES `otfoffsets` WRITE;
977UNLOCK TABLES;
978/*!40000 ALTER TABLE `otfoffsets` ENABLE KEYS*/;
979
980
981#
982# Table structure for table 'pointingsettings'
983#
984
985CREATE TABLE /*!32312 IF NOT EXISTS*/ `pointingsettings` (
986 `id` int(11) NOT NULL auto_increment,
987 `Scans_id` int(11) NOT NULL,
988 PRIMARY KEY (`id`),
989 KEY `PointingSettings_Scans_id` (`Scans_id`)
990) ENGINE=InnoDB DEFAULT CHARSET=latin1;
991
992
993
994#
995# Dumping data for table 'pointingsettings'
996#
997
998/*!40000 ALTER TABLE `pointingsettings` DISABLE KEYS*/;
999LOCK TABLES `pointingsettings` WRITE;
1000UNLOCK TABLES;
1001/*!40000 ALTER TABLE `pointingsettings` ENABLE KEYS*/;
1002
1003
1004#
1005# Table structure for table 'projects'
1006#
1007
1008CREATE TABLE /*!32312 IF NOT EXISTS*/ `projects` (
1009 `id` int(11) NOT NULL auto_increment,
1010 `PI_id` int(11) default NULL,
1011 `title` varchar(255) NOT NULL,
1012 `priority` smallint(6) default NULL,
1013 `allocatedTime` double default NULL,
1014 `usedTime` double default NULL,
1015 `comments` longtext NOT NULL,
1016 `description` longtext NOT NULL,
1017 `is_public` tinyint(1) NOT NULL,
1018 PRIMARY KEY (`id`),
1019 UNIQUE KEY `title` (`title`),
1020 KEY `Projects_PI_id` (`PI_id`)
1021) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1022
1023
1024
1025#
1026# Dumping data for table 'projects'
1027#
1028
1029/*!40000 ALTER TABLE `projects` DISABLE KEYS*/;
1030LOCK TABLES `projects` WRITE;
1031REPLACE INTO `projects` (`id`, `PI_id`, `title`, `priority`, `allocatedTime`, `usedTime`, `comments`, `description`, `is_public`) VALUES (1,1,'LAEFF-INTA',NULL,NULL,NULL,'','',1);
1032UNLOCK TABLES;
1033/*!40000 ALTER TABLE `projects` ENABLE KEYS*/;
1034
1035
1036#
1037# Table structure for table 'rawfiles'
1038#
1039
1040CREATE TABLE /*!32312 IF NOT EXISTS*/ `rawfiles` (
1041 `id` int(11) NOT NULL auto_increment,
1042 `logFiles_id` int(11) NOT NULL,
1043 `filename` varchar(255) NOT NULL,
1044 `year` smallint(6) NOT NULL,
1045 PRIMARY KEY (`id`),
1046 UNIQUE KEY `rawFiles_Unique` (`filename`),
1047 KEY `rawFiles_logFiles_id` (`logFiles_id`)
1048) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1049
1050
1051
1052#
1053# Dumping data for table 'rawfiles'
1054#
1055
1056/*!40000 ALTER TABLE `rawfiles` DISABLE KEYS*/;
1057LOCK TABLES `rawfiles` WRITE;
1058UNLOCK TABLES;
1059/*!40000 ALTER TABLE `rawfiles` ENABLE KEYS*/;
1060
1061
1062#
1063# Table structure for table 'receivers'
1064#
1065
1066CREATE TABLE /*!32312 IF NOT EXISTS*/ `receivers` (
1067 `id` int(11) NOT NULL auto_increment,
1068 `ReceiversNames_id` int(11) NOT NULL,
1069 `Scans_id` int(11) NOT NULL,
1070 PRIMARY KEY (`id`),
1071 KEY `Receivers_ReceiversNames_id` (`ReceiversNames_id`),
1072 KEY `Receivers_Scans_id` (`Scans_id`)
1073) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1074
1075
1076
1077#
1078# Dumping data for table 'receivers'
1079#
1080
1081/*!40000 ALTER TABLE `receivers` DISABLE KEYS*/;
1082LOCK TABLES `receivers` WRITE;
1083UNLOCK TABLES;
1084/*!40000 ALTER TABLE `receivers` ENABLE KEYS*/;
1085
1086
1087#
1088# Table structure for table 'receiverscfg'
1089#
1090
1091CREATE TABLE /*!32312 IF NOT EXISTS*/ `receiverscfg` (
1092 `id` int(11) NOT NULL auto_increment,
1093 `Receivers_id` int(11) NOT NULL,
1094 `linename` varchar(255) NOT NULL,
1095 `frequency` double default NULL,
1096 `polarization` varchar(255) NOT NULL,
1097 PRIMARY KEY (`id`),
1098 KEY `ReceiversCfg_Receivers_id` (`Receivers_id`)
1099) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1100
1101
1102
1103#
1104# Dumping data for table 'receiverscfg'
1105#
1106
1107/*!40000 ALTER TABLE `receiverscfg` DISABLE KEYS*/;
1108LOCK TABLES `receiverscfg` WRITE;
1109UNLOCK TABLES;
1110/*!40000 ALTER TABLE `receiverscfg` ENABLE KEYS*/;
1111
1112
1113#
1114# Table structure for table 'receiversnames'
1115#
1116
1117CREATE TABLE /*!32312 IF NOT EXISTS*/ `receiversnames` (
1118 `id` int(11) NOT NULL auto_increment,
1119 `name` varchar(255) NOT NULL,
1120 `description` longtext NOT NULL,
1121 PRIMARY KEY (`id`)
1122) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1123
1124
1125
1126#
1127# Dumping data for table 'receiversnames'
1128#
1129
1130/*!40000 ALTER TABLE `receiversnames` DISABLE KEYS*/;
1131LOCK TABLES `receiversnames` WRITE;
1132REPLACE INTO `receiversnames` (`id`, `name`, `description`) VALUES (1,'spb500 < MMS-1 < K 3ch HEMT','');
1133UNLOCK TABLES;
1134/*!40000 ALTER TABLE `receiversnames` ENABLE KEYS*/;
1135
1136
1137#
1138# Table structure for table 'reducedfiles'
1139#
1140
1141CREATE TABLE /*!32312 IF NOT EXISTS*/ `reducedfiles` (
1142 `id` int(11) NOT NULL auto_increment,
1143 `logFiles_id` int(11) NOT NULL,
1144 `filename` varchar(255) NOT NULL,
1145 `year` smallint(6) NOT NULL,
1146 PRIMARY KEY (`id`),
1147 UNIQUE KEY `reducedFiles_Unique` (`filename`),
1148 KEY `reducedFiles_logFiles_id` (`logFiles_id`)
1149) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1150
1151
1152
1153#
1154# Dumping data for table 'reducedfiles'
1155#
1156
1157/*!40000 ALTER TABLE `reducedfiles` DISABLE KEYS*/;
1158LOCK TABLES `reducedfiles` WRITE;
1159UNLOCK TABLES;
1160/*!40000 ALTER TABLE `reducedfiles` ENABLE KEYS*/;
1161
1162
1163#
1164# Table structure for table 'scans'
1165#
1166
1167CREATE TABLE /*!32312 IF NOT EXISTS*/ `scans` (
1168 `id` int(11) NOT NULL auto_increment,
1169 `scanID` varchar(255) NOT NULL,
1170 `Projects_id` int(11) NOT NULL,
1171 `Users_id` int(11) default NULL,
1172 `Sources_id` int(11) NOT NULL,
1173 `ObservingModes_id` int(11) default NULL,
1174 `ScansQuality_id` int(11) NOT NULL,
1175 `nSubscans` smallint(6) default NULL,
1176 `startTime` datetime default NULL,
1177 `endTime` datetime default NULL,
1178 `observedTime` smallint(6) default NULL,
1179 `dateObservation` date default NULL,
1180 `dateReduction` date default NULL,
1181 `LST` time default NULL,
1182 `UT` time default NULL,
1183 `comments` longtext NOT NULL,
1184 PRIMARY KEY (`id`),
1185 UNIQUE KEY `scanID` (`scanID`),
1186 KEY `Scans_Projects_id` (`Projects_id`),
1187 KEY `Scans_Users_id` (`Users_id`),
1188 KEY `Scans_Sources_id` (`Sources_id`),
1189 KEY `Scans_ObservingModes_id` (`ObservingModes_id`),
1190 KEY `Scans_ScansQuality_id` (`ScansQuality_id`)
1191) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1192
1193
1194
1195#
1196# Dumping data for table 'scans'
1197#
1198
1199/*!40000 ALTER TABLE `scans` DISABLE KEYS*/;
1200LOCK TABLES `scans` WRITE;
1201UNLOCK TABLES;
1202/*!40000 ALTER TABLE `scans` ENABLE KEYS*/;
1203
1204
1205#
1206# Table structure for table 'scansquality'
1207#
1208
1209CREATE TABLE /*!32312 IF NOT EXISTS*/ `scansquality` (
1210 `id` int(11) NOT NULL auto_increment,
1211 `name` varchar(255) NOT NULL,
1212 `description` longtext NOT NULL,
1213 PRIMARY KEY (`id`)
1214) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1215
1216
1217
1218#
1219# Dumping data for table 'scansquality'
1220#
1221
1222/*!40000 ALTER TABLE `scansquality` DISABLE KEYS*/;
1223LOCK TABLES `scansquality` WRITE;
1224REPLACE INTO `scansquality` (`id`, `name`, `description`) VALUES (1,'Not verified','');
1225UNLOCK TABLES;
1226/*!40000 ALTER TABLE `scansquality` ENABLE KEYS*/;
1227
1228
1229#
1230# Table structure for table 'softwareversions'
1231#
1232
1233CREATE TABLE /*!32312 IF NOT EXISTS*/ `softwareversions` (
1234 `id` int(11) NOT NULL auto_increment,
1235 `software` varchar(255) NOT NULL,
1236 `version` varchar(255) NOT NULL,
1237 `date` date default NULL,
1238 `description` longtext NOT NULL,
1239 PRIMARY KEY (`id`)
1240) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1241
1242
1243
1244#
1245# Dumping data for table 'softwareversions'
1246#
1247
1248/*!40000 ALTER TABLE `softwareversions` DISABLE KEYS*/;
1249LOCK TABLES `softwareversions` WRITE;
1250UNLOCK TABLES;
1251/*!40000 ALTER TABLE `softwareversions` ENABLE KEYS*/;
1252
1253
1254#
1255# Table structure for table 'softwareversions_used_in_scans'
1256#
1257
1258CREATE TABLE /*!32312 IF NOT EXISTS*/ `softwareversions_used_in_scans` (
1259 `id` int(11) NOT NULL auto_increment,
1260 `scans_id` int(11) NOT NULL,
1261 `softwareversions_id` int(11) NOT NULL,
1262 PRIMARY KEY (`id`),
1263 UNIQUE KEY `scans_id` (`scans_id`,`softwareversions_id`),
1264 KEY `softwareversions_id_refs_id_54a1d90c` (`softwareversions_id`)
1265) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1266
1267
1268
1269#
1270# Dumping data for table 'softwareversions_used_in_scans'
1271#
1272
1273/*!40000 ALTER TABLE `softwareversions_used_in_scans` DISABLE KEYS*/;
1274LOCK TABLES `softwareversions_used_in_scans` WRITE;
1275UNLOCK TABLES;
1276/*!40000 ALTER TABLE `softwareversions_used_in_scans` ENABLE KEYS*/;
1277
1278
1279#
1280# Table structure for table 'sourcelogs'
1281#
1282
1283CREATE TABLE /*!32312 IF NOT EXISTS*/ `sourcelogs` (
1284 `id` int(11) NOT NULL auto_increment,
1285 `name` varchar(255) NOT NULL,
1286 PRIMARY KEY (`id`)
1287) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1288
1289
1290
1291#
1292# Dumping data for table 'sourcelogs'
1293#
1294
1295/*!40000 ALTER TABLE `sourcelogs` DISABLE KEYS*/;
1296LOCK TABLES `sourcelogs` WRITE;
1297REPLACE INTO `sourcelogs` (`id`, `name`) VALUES (1,'Sky'),
1298 (2,'Sky+ND'),
1299 (3,'AmbLoad'),
1300 (4,'Amb+ND'),
1301 (5,'AmbLoad+20dB');
1302UNLOCK TABLES;
1303/*!40000 ALTER TABLE `sourcelogs` ENABLE KEYS*/;
1304
1305
1306#
1307# Table structure for table 'sources'
1308#
1309
1310CREATE TABLE /*!32312 IF NOT EXISTS*/ `sources` (
1311 `id` int(11) NOT NULL auto_increment,
1312 `object` varchar(255) NOT NULL,
1313 `name` varchar(255) NOT NULL,
1314 `ra` double default NULL,
1315 `dec` double default NULL,
1316 `epoch` varchar(20) NOT NULL,
1317 `deltav` double default NULL,
1318 `velo_lsr` double default NULL,
1319 `comments` longtext NOT NULL,
1320 PRIMARY KEY (`id`)
1321) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1322
1323
1324
1325#
1326# Dumping data for table 'sources'
1327#
1328
1329/*!40000 ALTER TABLE `sources` DISABLE KEYS*/;
1330LOCK TABLES `sources` WRITE;
1331UNLOCK TABLES;
1332/*!40000 ALTER TABLE `sources` ENABLE KEYS*/;
1333
1334
1335#
1336# Table structure for table 'subscans'
1337#
1338
1339CREATE TABLE /*!32312 IF NOT EXISTS*/ `subscans` (
1340 `id` int(11) NOT NULL auto_increment,
1341 `subscanID` varchar(255) NOT NULL,
1342 `Scans_id` int(11) NOT NULL,
1343 `dateObservation` date default NULL,
1344 `startTime` datetime default NULL,
1345 `endTime` datetime default NULL,
1346 `exposure` double default NULL,
1347 `is_source` tinyint(1) default NULL,
1348 `is_reference` tinyint(1) default NULL,
1349 PRIMARY KEY (`id`),
1350 UNIQUE KEY `subscanID` (`subscanID`),
1351 KEY `Subscans_Scans_id` (`Scans_id`)
1352) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1353
1354
1355
1356#
1357# Dumping data for table 'subscans'
1358#
1359
1360/*!40000 ALTER TABLE `subscans` DISABLE KEYS*/;
1361LOCK TABLES `subscans` WRITE;
1362UNLOCK TABLES;
1363/*!40000 ALTER TABLE `subscans` ENABLE KEYS*/;
1364
1365
1366#
1367# Table structure for table 'switchingmodes'
1368#
1369
1370CREATE TABLE /*!32312 IF NOT EXISTS*/ `switchingmodes` (
1371 `id` int(11) NOT NULL auto_increment,
1372 `name` varchar(255) NOT NULL,
1373 `description` longtext NOT NULL,
1374 PRIMARY KEY (`id`)
1375) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1376
1377
1378
1379#
1380# Dumping data for table 'switchingmodes'
1381#
1382
1383/*!40000 ALTER TABLE `switchingmodes` DISABLE KEYS*/;
1384LOCK TABLES `switchingmodes` WRITE;
1385UNLOCK TABLES;
1386/*!40000 ALTER TABLE `switchingmodes` ENABLE KEYS*/;
1387
1388
1389#
1390# Table structure for table 'switchingvalues'
1391#
1392
1393CREATE TABLE /*!32312 IF NOT EXISTS*/ `switchingvalues` (
1394 `id` int(11) NOT NULL auto_increment,
1395 `SwitchingModes_id` int(11) NOT NULL,
1396 `Scans_id` int(11) NOT NULL,
1397 PRIMARY KEY (`id`),
1398 KEY `SwitchingValues_SwitchingModes_id` (`SwitchingModes_id`),
1399 KEY `SwitchingValues_Scans_id` (`Scans_id`)
1400) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1401
1402
1403
1404#
1405# Dumping data for table 'switchingvalues'
1406#
1407
1408/*!40000 ALTER TABLE `switchingvalues` DISABLE KEYS*/;
1409LOCK TABLES `switchingvalues` WRITE;
1410UNLOCK TABLES;
1411/*!40000 ALTER TABLE `switchingvalues` ENABLE KEYS*/;
1412
1413
1414#
1415# Table structure for table 'systemnames'
1416#
1417
1418CREATE TABLE /*!32312 IF NOT EXISTS*/ `systemnames` (
1419 `id` int(11) NOT NULL auto_increment,
1420 `name` varchar(255) NOT NULL,
1421 `description` longtext NOT NULL,
1422 PRIMARY KEY (`id`)
1423) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1424
1425
1426
1427#
1428# Dumping data for table 'systemnames'
1429#
1430
1431/*!40000 ALTER TABLE `systemnames` DISABLE KEYS*/;
1432LOCK TABLES `systemnames` WRITE;
1433UNLOCK TABLES;
1434/*!40000 ALTER TABLE `systemnames` ENABLE KEYS*/;
1435
1436
1437#
1438# Table structure for table 'weatherstation'
1439#
1440
1441CREATE TABLE /*!32312 IF NOT EXISTS*/ `weatherstation` (
1442 `id` int(11) NOT NULL auto_increment,
1443 `timeStamp` datetime NOT NULL,
1444 `electricalField` double default NULL,
1445 `windVel` double default NULL,
1446 `windVelMax` double default NULL,
1447 `windDir` double default NULL,
1448 `humidity` double default NULL,
1449 `pressure` double default NULL,
1450 `temperature` double default NULL,
1451 PRIMARY KEY (`id`),
1452 UNIQUE KEY `timeStamp` (`timeStamp`)
1453) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1454
1455
1456
1457#
1458# Dumping data for table 'weatherstation'
1459#
1460
1461/*!40000 ALTER TABLE `weatherstation` DISABLE KEYS*/;
1462LOCK TABLES `weatherstation` WRITE;
1463UNLOCK TABLES;
1464/*!40000 ALTER TABLE `weatherstation` ENABLE KEYS*/;
1465
1466
1467#
1468# Table structure for table 'weathertau'
1469#
1470
1471CREATE TABLE /*!32312 IF NOT EXISTS*/ `weathertau` (
1472 `id` int(11) NOT NULL auto_increment,
1473 `timeStamp` datetime NOT NULL,
1474 `tau` double default NULL,
1475 `sigma` double default NULL,
1476 `fit` double default NULL,
1477 PRIMARY KEY (`id`),
1478 UNIQUE KEY `timeStamp` (`timeStamp`)
1479) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1480
1481
1482
1483#
1484# Dumping data for table 'weathertau'
1485#
1486
1487/*!40000 ALTER TABLE `weathertau` DISABLE KEYS*/;
1488LOCK TABLES `weathertau` WRITE;
1489UNLOCK TABLES;
1490/*!40000 ALTER TABLE `weathertau` ENABLE KEYS*/;