· 7 years ago · Feb 20, 2019, 05:00 PM
1-- MySQL dump 10.17 Distrib 10.3.12-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: tupex6
4-- ------------------------------------------------------
5-- Server version 10.3.12-MariaDB-log
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 utf8mb4 */;
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: `tupex6`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tupex6` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
23
24USE `tupex6`;
25
26--
27-- Table structure for table `gui_Param2Trendgroup`
28--
29
30DROP TABLE IF EXISTS `gui_Param2Trendgroup`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `gui_Param2Trendgroup` (
34 `keyParam2Trendgroup` int(10) unsigned NOT NULL AUTO_INCREMENT,
35 `keyTrendgroup` int(10) unsigned NOT NULL,
36 `keyTMParam` int(10) unsigned NOT NULL,
37 `keyNode` int(10) unsigned NOT NULL,
38 PRIMARY KEY (`keyParam2Trendgroup`),
39 KEY `TrendgroupParam_Trendgroup` (`keyTrendgroup`),
40 KEY `TrendgroupParam_TMParam` (`keyTMParam`),
41 KEY `Param2Trendgroup_Node` (`keyNode`),
42 CONSTRAINT `Param2Trendgroup_Node` FOREIGN KEY (`keyNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON DELETE CASCADE ON UPDATE CASCADE,
43 CONSTRAINT `Param2Trendgroup_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE,
44 CONSTRAINT `Param2Trendgroup_Trendgroup` FOREIGN KEY (`keyTrendgroup`) REFERENCES `gui_Trendgroup` (`keyTrendgroup`) ON DELETE CASCADE ON UPDATE CASCADE
45) ENGINE=InnoDB DEFAULT CHARSET=latin1;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Dumping data for table `gui_Param2Trendgroup`
50--
51
52LOCK TABLES `gui_Param2Trendgroup` WRITE;
53/*!40000 ALTER TABLE `gui_Param2Trendgroup` DISABLE KEYS */;
54/*!40000 ALTER TABLE `gui_Param2Trendgroup` ENABLE KEYS */;
55UNLOCK TABLES;
56
57--
58-- Table structure for table `gui_Profile`
59--
60
61DROP TABLE IF EXISTS `gui_Profile`;
62/*!40101 SET @saved_cs_client = @@character_set_client */;
63/*!40101 SET character_set_client = utf8 */;
64CREATE TABLE `gui_Profile` (
65 `keyProfile` int(10) unsigned NOT NULL AUTO_INCREMENT,
66 `ProfileName` varchar(50) NOT NULL,
67 `ColorBgdNormal` varchar(10) NOT NULL COMMENT '''#RRGGBB'' or ''#AARRGGBB''',
68 `ColorBgdTolerable` varchar(10) NOT NULL,
69 `ColorBgdCritical` varchar(10) NOT NULL,
70 `ColorValueNormal` varchar(10) NOT NULL,
71 `ColorValueTolerable` varchar(10) NOT NULL,
72 `ColorValueCritical` varchar(10) NOT NULL,
73 `ColorOldValueNormal` varchar(10) NOT NULL,
74 `ColorOldValueTolerable` varchar(10) NOT NULL,
75 `ColorOldValueCritical` varchar(10) NOT NULL,
76 `ColorName` varchar(10) NOT NULL,
77 `ColorDescription` varchar(10) NOT NULL,
78 `ColorUnit` varchar(10) NOT NULL,
79 `Font` varchar(150) NOT NULL,
80 PRIMARY KEY (`keyProfile`)
81) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
82/*!40101 SET character_set_client = @saved_cs_client */;
83
84--
85-- Dumping data for table `gui_Profile`
86--
87
88LOCK TABLES `gui_Profile` WRITE;
89/*!40000 ALTER TABLE `gui_Profile` DISABLE KEYS */;
90INSERT INTO `gui_Profile` VALUES
91 (1,'default','#000000','#ffff00','#ff0000','#ffffff','#000000','#000000','#a0a0a4','#a0a0a4','#a0a0a4','#ffff00','#00ff00','#00ff00','DejaVu Sans Mono,12,-1,5,75,0,0,0,0,0'),
92 (2,'pFDAs','#000000','#ffff00','#ff0000','#ffffff','#000000','#000000','#a0a0a4','#a0a0a4','#a0a0a4','#ffff00','#00ff00','#00ff00','DejaVu Sans Mono,12,-1,5,75,0,0,0,0,0');
93/*!40000 ALTER TABLE `gui_Profile` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `gui_ProfileWindow`
98--
99
100DROP TABLE IF EXISTS `gui_ProfileWindow`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `gui_ProfileWindow` (
104 `keyProfileWindow` int(10) unsigned NOT NULL AUTO_INCREMENT,
105 `keyProfile` int(10) unsigned NOT NULL,
106 `WindowTitle` varchar(50) NOT NULL,
107 `WindowIcon` varchar(100) DEFAULT NULL,
108 PRIMARY KEY (`keyProfileWindow`),
109 KEY `ProfileWindow_Profile` (`keyProfile`),
110 CONSTRAINT `ProfileWindow_Profile` FOREIGN KEY (`keyProfile`) REFERENCES `gui_Profile` (`keyProfile`) ON DELETE CASCADE ON UPDATE CASCADE
111) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
112/*!40101 SET character_set_client = @saved_cs_client */;
113
114--
115-- Dumping data for table `gui_ProfileWindow`
116--
117
118LOCK TABLES `gui_ProfileWindow` WRITE;
119/*!40000 ALTER TABLE `gui_ProfileWindow` DISABLE KEYS */;
120INSERT INTO `gui_ProfileWindow` VALUES
121 (1,1,'OBC',NULL),
122 (2,1,'RBE',NULL),
123 (3,1,'EPS',NULL),
124 (4,1,'pFDAs',NULL),
125 (5,2,'pFDA1',NULL),
126 (6,2,'pFDA2',NULL),
127 (7,2,'pFDA3',NULL),
128 (8,2,'pFDA4',NULL),
129 (9,1,'Read SD Block',NULL);
130/*!40000 ALTER TABLE `gui_ProfileWindow` ENABLE KEYS */;
131UNLOCK TABLES;
132
133--
134-- Table structure for table `gui_ProfileWindowParam`
135--
136
137DROP TABLE IF EXISTS `gui_ProfileWindowParam`;
138/*!40101 SET @saved_cs_client = @@character_set_client */;
139/*!40101 SET character_set_client = utf8 */;
140CREATE TABLE `gui_ProfileWindowParam` (
141 `keyProfileWindowParam` int(10) unsigned NOT NULL AUTO_INCREMENT,
142 `keyProfileWindow` int(10) unsigned NOT NULL,
143 `keyParam` int(10) unsigned NOT NULL,
144 `keyNode` int(10) unsigned NOT NULL,
145 `ProfileRow` int(10) unsigned NOT NULL,
146 `ProfileColumn` int(10) unsigned NOT NULL,
147 PRIMARY KEY (`keyProfileWindowParam`),
148 KEY `ProfileWindowParam_ProfileWindow` (`keyProfileWindow`),
149 KEY `ProfileWindowParam_TMParam` (`keyParam`),
150 KEY `ProfileWindowParam_Node` (`keyNode`),
151 CONSTRAINT `ProfileWindowParam_Node` FOREIGN KEY (`keyNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON DELETE CASCADE ON UPDATE CASCADE,
152 CONSTRAINT `ProfileWindowParam_ProfileWindow` FOREIGN KEY (`keyProfileWindow`) REFERENCES `gui_ProfileWindow` (`keyProfileWindow`) ON DELETE CASCADE ON UPDATE CASCADE,
153 CONSTRAINT `ProfileWindowParam_TMParam` FOREIGN KEY (`keyParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE
154) ENGINE=InnoDB AUTO_INCREMENT=701 DEFAULT CHARSET=latin1;
155/*!40101 SET character_set_client = @saved_cs_client */;
156
157--
158-- Dumping data for table `gui_ProfileWindowParam`
159--
160
161LOCK TABLES `gui_ProfileWindowParam` WRITE;
162/*!40000 ALTER TABLE `gui_ProfileWindowParam` DISABLE KEYS */;
163INSERT INTO `gui_ProfileWindowParam` VALUES
164 (271,4,130002,5,0,0),
165 (272,4,130012,5,0,1),
166 (273,4,130001,5,1,0),
167 (274,4,130013,5,1,1),
168 (275,4,130004,5,2,0),
169 (276,4,130014,5,2,1),
170 (277,4,130003,5,3,0),
171 (278,4,130005,5,5,0),
172 (279,4,130006,5,6,0),
173 (280,4,130007,5,7,0),
174 (281,4,130008,5,9,0),
175 (282,4,130009,5,10,0),
176 (283,4,130010,5,11,0),
177 (284,4,130011,5,13,0),
178 (285,2,800001,3,0,0),
179 (286,2,800002,3,1,0),
180 (287,2,800003,3,2,0),
181 (288,2,800006,3,4,0),
182 (289,2,800007,3,5,0),
183 (290,2,800004,3,6,0),
184 (291,2,800005,3,7,0),
185 (292,2,800008,3,8,0),
186 (293,2,800009,3,9,0),
187 (350,9,105001,2,0,0),
188 (351,9,105002,2,1,0),
189 (352,9,105003,2,2,0),
190 (353,9,105004,2,3,0),
191 (519,5,130001,5,0,0),
192 (520,5,130012,5,0,1),
193 (521,5,130002,5,1,0),
194 (522,5,130013,5,1,1),
195 (523,5,130014,5,2,1),
196 (524,5,130003,5,3,0),
197 (525,5,130018,5,3,1),
198 (526,5,130004,5,4,0),
199 (527,5,130015,5,5,1),
200 (528,5,130008,5,6,0),
201 (529,5,130016,5,6,1),
202 (530,5,130009,5,7,0),
203 (531,5,130017,5,7,1),
204 (532,5,130010,5,8,0),
205 (533,5,130005,5,10,0),
206 (534,5,130006,5,11,0),
207 (535,5,130007,5,12,0),
208 (536,5,130011,5,14,0),
209 (537,5,130019,5,16,0),
210 (538,6,130001,6,0,0),
211 (539,6,130012,6,0,1),
212 (540,6,130002,6,1,0),
213 (541,6,130013,6,1,1),
214 (542,6,130003,6,2,0),
215 (543,6,130014,6,2,1),
216 (544,6,130004,6,3,0),
217 (545,6,130018,6,3,1),
218 (546,6,130008,6,5,0),
219 (547,6,130015,6,5,1),
220 (548,6,130009,6,6,0),
221 (549,6,130016,6,6,1),
222 (550,6,130010,6,7,0),
223 (551,6,130017,6,7,1),
224 (552,6,130005,6,9,0),
225 (553,6,130006,6,10,0),
226 (554,6,130007,6,11,0),
227 (555,6,130011,6,13,0),
228 (556,6,130019,6,15,0),
229 (557,7,130001,7,0,0),
230 (558,7,130012,7,0,1),
231 (559,7,130002,7,1,0),
232 (560,7,130013,7,1,1),
233 (561,7,130003,7,2,0),
234 (562,7,130014,7,2,1),
235 (563,7,130004,7,3,0),
236 (564,7,130018,7,3,1),
237 (565,7,130008,7,5,0),
238 (566,7,130015,7,5,1),
239 (567,7,130009,7,6,0),
240 (568,7,130016,7,6,1),
241 (569,7,130010,7,7,0),
242 (570,7,130017,7,7,1),
243 (571,7,130005,7,9,0),
244 (572,7,130006,7,10,0),
245 (573,7,130007,7,11,0),
246 (574,7,130011,7,13,0),
247 (575,7,130019,7,15,0),
248 (576,8,130001,8,0,0),
249 (577,8,130012,8,0,1),
250 (578,8,130002,8,1,0),
251 (579,8,130013,8,1,1),
252 (580,8,130003,8,2,0),
253 (581,8,130014,8,2,1),
254 (582,8,130004,8,3,0),
255 (583,8,130018,8,3,1),
256 (584,8,130008,8,5,0),
257 (585,8,130015,8,5,1),
258 (586,8,130009,8,6,0),
259 (587,8,130016,8,6,1),
260 (588,8,130010,8,7,0),
261 (589,8,130017,8,7,1),
262 (590,8,130005,8,9,0),
263 (591,8,130006,8,10,0),
264 (592,8,130007,8,11,0),
265 (593,8,130011,8,13,0),
266 (594,8,130019,8,15,0),
267 (595,3,120001,4,0,0),
268 (596,3,120003,4,0,1),
269 (597,3,120002,4,1,0),
270 (598,3,120004,4,1,1),
271 (599,3,120046,4,3,0),
272 (600,3,120009,4,3,1),
273 (601,3,120007,4,4,0),
274 (602,3,120018,4,4,1),
275 (603,3,120008,4,5,0),
276 (604,3,120027,4,5,1),
277 (605,3,120036,4,6,1),
278 (606,3,120017,4,7,0),
279 (607,3,120026,4,8,0),
280 (608,3,120010,4,8,1),
281 (609,3,120035,4,9,0),
282 (610,3,120019,4,9,1),
283 (611,3,120044,4,10,0),
284 (612,3,120028,4,10,1),
285 (613,3,120037,4,11,1),
286 (614,3,120013,4,12,0),
287 (615,3,120045,4,12,1),
288 (616,3,120022,4,13,0),
289 (617,3,120005,4,13,1),
290 (618,3,120031,4,14,0),
291 (619,3,120006,4,14,1),
292 (620,3,120040,4,15,0),
293 (621,3,120011,4,16,1),
294 (622,3,120014,4,17,0),
295 (623,3,120020,4,17,1),
296 (624,3,120023,4,18,0),
297 (625,3,120029,4,18,1),
298 (626,3,120032,4,19,0),
299 (627,3,120038,4,19,1),
300 (628,3,120041,4,20,0),
301 (629,3,120012,4,21,1),
302 (630,3,120015,4,22,0),
303 (631,3,120021,4,22,1),
304 (632,3,120024,4,23,0),
305 (633,3,120030,4,23,1),
306 (634,3,120033,4,24,0),
307 (635,3,120039,4,24,1),
308 (636,3,120042,4,25,0),
309 (637,3,120047,4,26,1),
310 (638,3,120016,4,27,0),
311 (639,3,120048,4,27,1),
312 (640,3,120025,4,28,0),
313 (641,3,120034,4,29,0),
314 (642,3,120043,4,30,0),
315 (670,1,200001,2,0,0),
316 (671,1,100003,2,0,1),
317 (672,1,200003,2,1,0),
318 (673,1,100009,2,1,1),
319 (674,1,200007,2,2,0),
320 (675,1,100011,2,2,1),
321 (676,1,200005,2,3,0),
322 (677,1,200009,2,4,0),
323 (678,1,100004,2,4,1),
324 (679,1,200011,2,5,0),
325 (680,1,100010,2,5,1),
326 (681,1,200013,2,6,0),
327 (682,1,100012,2,6,1),
328 (683,1,200002,2,8,0),
329 (684,1,100014,2,8,1),
330 (685,1,200004,2,9,0),
331 (686,1,100013,2,9,1),
332 (687,1,200008,2,10,0),
333 (688,1,200006,2,11,0),
334 (689,1,200016,2,11,1),
335 (690,1,200010,2,12,0),
336 (691,1,200017,2,12,1),
337 (692,1,200012,2,13,0),
338 (693,1,200014,2,14,0),
339 (694,1,100001,2,14,1),
340 (695,1,100033,2,15,1),
341 (696,1,11001,2,16,0),
342 (697,1,17001,2,17,0),
343 (698,1,100002,2,17,1),
344 (699,1,200015,2,18,0),
345 (700,1,100034,2,18,1);
346/*!40000 ALTER TABLE `gui_ProfileWindowParam` ENABLE KEYS */;
347UNLOCK TABLES;
348
349--
350-- Table structure for table `gui_Trendgroup`
351--
352
353DROP TABLE IF EXISTS `gui_Trendgroup`;
354/*!40101 SET @saved_cs_client = @@character_set_client */;
355/*!40101 SET character_set_client = utf8 */;
356CREATE TABLE `gui_Trendgroup` (
357 `keyTrendgroup` int(10) unsigned NOT NULL AUTO_INCREMENT,
358 `NameTrendgroup` varchar(100) NOT NULL,
359 PRIMARY KEY (`keyTrendgroup`)
360) ENGINE=InnoDB DEFAULT CHARSET=latin1;
361/*!40101 SET character_set_client = @saved_cs_client */;
362
363--
364-- Dumping data for table `gui_Trendgroup`
365--
366
367LOCK TABLES `gui_Trendgroup` WRITE;
368/*!40000 ALTER TABLE `gui_Trendgroup` DISABLE KEYS */;
369/*!40000 ALTER TABLE `gui_Trendgroup` ENABLE KEYS */;
370UNLOCK TABLES;
371
372--
373-- Table structure for table `rdt_CommandLog`
374--
375
376DROP TABLE IF EXISTS `rdt_CommandLog`;
377/*!40101 SET @saved_cs_client = @@character_set_client */;
378/*!40101 SET character_set_client = utf8 */;
379CREATE TABLE `rdt_CommandLog` (
380 `keyCommandLog` int(10) unsigned NOT NULL AUTO_INCREMENT,
381 `keySatelliteModel` int(10) unsigned NOT NULL,
382 `keyGroundStation` int(10) unsigned NOT NULL,
383 `TransmissionTime` datetime DEFAULT NULL,
384 `CommandString` mediumtext DEFAULT NULL,
385 `SendState` enum('UNHANDLED','TTS OK','TTS NOK','TNC OK','TNC NOK','SAT OK','SAT NOK','SAT UNDEF') DEFAULT 'UNHANDLED',
386 PRIMARY KEY (`keyCommandLog`),
387 KEY `CommandLog_GroundStation` (`keyGroundStation`),
388 KEY `CommandLog_SatelliteModel` (`keySatelliteModel`),
389 CONSTRAINT `CommandLog_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE,
390 CONSTRAINT `CommandLog_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE
391) ENGINE=InnoDB DEFAULT CHARSET=latin1;
392/*!40101 SET character_set_client = @saved_cs_client */;
393
394--
395-- Dumping data for table `rdt_CommandLog`
396--
397
398LOCK TABLES `rdt_CommandLog` WRITE;
399/*!40000 ALTER TABLE `rdt_CommandLog` DISABLE KEYS */;
400/*!40000 ALTER TABLE `rdt_CommandLog` ENABLE KEYS */;
401UNLOCK TABLES;
402
403--
404-- Table structure for table `rdt_DecodedData`
405--
406
407DROP TABLE IF EXISTS `rdt_DecodedData`;
408/*!40101 SET @saved_cs_client = @@character_set_client */;
409/*!40101 SET character_set_client = utf8 */;
410CREATE TABLE `rdt_DecodedData` (
411 `keyDecodedData` int(10) unsigned NOT NULL AUTO_INCREMENT,
412 `keyDecodedSourcePacket` int(10) unsigned NOT NULL,
413 `keyTMParam` int(10) unsigned NOT NULL,
414 `ValueDouble` double DEFAULT NULL,
415 `ValueHex` text DEFAULT NULL,
416 `ValueError` tinyint(1) unsigned NOT NULL DEFAULT 0,
417 PRIMARY KEY (`keyDecodedData`),
418 KEY `DecodedData_DecodedSourcePacket` (`keyDecodedSourcePacket`),
419 KEY `DecodedData_TMParam` (`keyTMParam`),
420 CONSTRAINT `DecodedData_DecodedSourcePacket` FOREIGN KEY (`keyDecodedSourcePacket`) REFERENCES `rdt_DecodedSourcePacket` (`keyDecodedSourcePacket`) ON DELETE CASCADE ON UPDATE CASCADE,
421 CONSTRAINT `DecodedData_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`)
422) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded TELEMETRY VALUES';
423/*!40101 SET character_set_client = @saved_cs_client */;
424
425--
426-- Dumping data for table `rdt_DecodedData`
427--
428
429LOCK TABLES `rdt_DecodedData` WRITE;
430/*!40000 ALTER TABLE `rdt_DecodedData` DISABLE KEYS */;
431/*!40000 ALTER TABLE `rdt_DecodedData` ENABLE KEYS */;
432UNLOCK TABLES;
433
434--
435-- Table structure for table `rdt_DecodedSourcePacket`
436--
437
438DROP TABLE IF EXISTS `rdt_DecodedSourcePacket`;
439/*!40101 SET @saved_cs_client = @@character_set_client */;
440/*!40101 SET character_set_client = utf8 */;
441CREATE TABLE `rdt_DecodedSourcePacket` (
442 `keyDecodedSourcePacket` int(10) unsigned NOT NULL AUTO_INCREMENT,
443 `keyDecodedTransferFrame` int(10) unsigned NOT NULL,
444 `keyLogicNode` int(10) unsigned NOT NULL,
445 `physicalNode` tinyint(1) unsigned NOT NULL,
446 `keyTMSourcePacket` int(10) unsigned NOT NULL,
447 `keyTMVirtualChannel` int(10) unsigned NOT NULL,
448 `RecordingTime` datetime NOT NULL,
449 `RecordingTimeFrac` tinyint(1) unsigned NOT NULL,
450 `HeaderError` tinyint(1) unsigned NOT NULL,
451 `ParamErrorCount` smallint(4) unsigned NOT NULL,
452 PRIMARY KEY (`keyDecodedSourcePacket`),
453 KEY `DecodedSourcePacket_DecodedTransferFrame` (`keyDecodedTransferFrame`),
454 KEY `DecodedSourcePacket_LogicNode` (`keyLogicNode`),
455 KEY `DecodedSourcePacket_TMSourcePacket` (`keyTMSourcePacket`),
456 KEY `DecodedSourcePacket_TMVirtualChannel` (`keyTMVirtualChannel`),
457 CONSTRAINT `DecodedSourcePacket_DecodedTransferFrame` FOREIGN KEY (`keyDecodedTransferFrame`) REFERENCES `rdt_DecodedTransferFrame` (`keyDecodedTransferFrame`) ON DELETE CASCADE ON UPDATE CASCADE,
458 CONSTRAINT `DecodedSourcePacket_LogicNode` FOREIGN KEY (`keyLogicNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON UPDATE CASCADE,
459 CONSTRAINT `DecodedSourcePacket_TMSourcePacket` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON UPDATE CASCADE,
460 CONSTRAINT `DecodedSourcePacket_TMVirtualChannel` FOREIGN KEY (`keyTMVirtualChannel`) REFERENCES `stm_tm_virtualchannel` (`keyTMVirtualChannel`) ON UPDATE CASCADE
461) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded SOURCE PACKETS';
462/*!40101 SET character_set_client = @saved_cs_client */;
463
464--
465-- Dumping data for table `rdt_DecodedSourcePacket`
466--
467
468LOCK TABLES `rdt_DecodedSourcePacket` WRITE;
469/*!40000 ALTER TABLE `rdt_DecodedSourcePacket` DISABLE KEYS */;
470/*!40000 ALTER TABLE `rdt_DecodedSourcePacket` ENABLE KEYS */;
471UNLOCK TABLES;
472
473--
474-- Table structure for table `rdt_DecodedTransferFrame`
475--
476
477DROP TABLE IF EXISTS `rdt_DecodedTransferFrame`;
478/*!40101 SET @saved_cs_client = @@character_set_client */;
479/*!40101 SET character_set_client = utf8 */;
480CREATE TABLE `rdt_DecodedTransferFrame` (
481 `keyDecodedTransferFrame` int(10) unsigned NOT NULL AUTO_INCREMENT,
482 `keyRawData` int(10) unsigned NOT NULL,
483 `SpaceCraftID` int(10) unsigned NOT NULL,
484 `Version` tinyint(10) unsigned NOT NULL,
485 `Counter` int(10) unsigned NOT NULL,
486 `HeaderError` tinyint(1) unsigned NOT NULL,
487 `BlockErrorCount` tinyint(2) unsigned NOT NULL,
488 PRIMARY KEY (`keyDecodedTransferFrame`),
489 KEY `DecodedTransferFrame_RawData` (`keyRawData`),
490 CONSTRAINT `DecodedTransferFrame_RawData` FOREIGN KEY (`keyRawData`) REFERENCES `rdt_RawData` (`keyRawdata`) ON UPDATE CASCADE
491) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded TRANSFER FRAMES';
492/*!40101 SET character_set_client = @saved_cs_client */;
493
494--
495-- Dumping data for table `rdt_DecodedTransferFrame`
496--
497
498LOCK TABLES `rdt_DecodedTransferFrame` WRITE;
499/*!40000 ALTER TABLE `rdt_DecodedTransferFrame` DISABLE KEYS */;
500/*!40000 ALTER TABLE `rdt_DecodedTransferFrame` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `rdt_LogInfo`
505--
506
507DROP TABLE IF EXISTS `rdt_LogInfo`;
508/*!40101 SET @saved_cs_client = @@character_set_client */;
509/*!40101 SET character_set_client = utf8 */;
510CREATE TABLE `rdt_LogInfo` (
511 `keyLogInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
512 `keySatelliteModel` int(10) unsigned DEFAULT NULL,
513 `Time` datetime NOT NULL,
514 `ActionType` varchar(50) NOT NULL,
515 `Message` text DEFAULT NULL,
516 `ModuleType` varchar(50) DEFAULT NULL,
517 `MessageType` varchar(50) DEFAULT NULL,
518 PRIMARY KEY (`keyLogInfo`),
519 KEY `LogInfo_SatelliteModel` (`keySatelliteModel`),
520 CONSTRAINT `LogInfo_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE SET NULL ON UPDATE CASCADE
521) ENGINE=InnoDB DEFAULT CHARSET=latin1;
522/*!40101 SET character_set_client = @saved_cs_client */;
523
524--
525-- Dumping data for table `rdt_LogInfo`
526--
527
528LOCK TABLES `rdt_LogInfo` WRITE;
529/*!40000 ALTER TABLE `rdt_LogInfo` DISABLE KEYS */;
530/*!40000 ALTER TABLE `rdt_LogInfo` ENABLE KEYS */;
531UNLOCK TABLES;
532
533--
534-- Table structure for table `rdt_RawData`
535--
536
537DROP TABLE IF EXISTS `rdt_RawData`;
538/*!40101 SET @saved_cs_client = @@character_set_client */;
539/*!40101 SET character_set_client = utf8 */;
540CREATE TABLE `rdt_RawData` (
541 `keyRawdata` int(10) unsigned NOT NULL AUTO_INCREMENT,
542 `keySatelliteModel` int(10) unsigned NOT NULL,
543 `keyGroundStation` int(10) unsigned NOT NULL,
544 `keyTNC` int(10) unsigned NOT NULL,
545 `GroundStationTimeUTC` datetime NOT NULL,
546 `OrbitNumber` mediumint(8) unsigned NOT NULL DEFAULT 0,
547 `RawData` text NOT NULL,
548 `Comment` varchar(50) DEFAULT NULL,
549 `DecodeState` tinyint(2) NOT NULL DEFAULT 0,
550 `Azimuth` float DEFAULT NULL,
551 `Elevation` float DEFAULT NULL,
552 `SMeter` float DEFAULT NULL,
553 PRIMARY KEY (`keyRawdata`),
554 KEY `RawData_TNC` (`keyTNC`),
555 KEY `RawData_GroundStation` (`keyGroundStation`),
556 KEY `RawData_SatelliteModel` (`keySatelliteModel`),
557 CONSTRAINT `RawData_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE NO ACTION ON UPDATE CASCADE,
558 CONSTRAINT `RawData_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE,
559 CONSTRAINT `RawData_TNC` FOREIGN KEY (`keyTNC`) REFERENCES `stm_TNC` (`keyTNC`) ON DELETE NO ACTION ON UPDATE CASCADE
560) ENGINE=InnoDB DEFAULT CHARSET=latin1;
561/*!40101 SET character_set_client = @saved_cs_client */;
562
563--
564-- Dumping data for table `rdt_RawData`
565--
566
567LOCK TABLES `rdt_RawData` WRITE;
568/*!40000 ALTER TABLE `rdt_RawData` DISABLE KEYS */;
569/*!40000 ALTER TABLE `rdt_RawData` ENABLE KEYS */;
570UNLOCK TABLES;
571
572--
573-- Table structure for table `rdt_TC_AutomatedList`
574--
575
576DROP TABLE IF EXISTS `rdt_TC_AutomatedList`;
577/*!40101 SET @saved_cs_client = @@character_set_client */;
578/*!40101 SET character_set_client = utf8 */;
579CREATE TABLE `rdt_TC_AutomatedList` (
580 `keyTCAutomatedList` int(10) unsigned NOT NULL AUTO_INCREMENT,
581 `keySatelliteModel` int(10) unsigned NOT NULL,
582 `ListName` varchar(100) NOT NULL,
583 `DefaultList` tinyint(1) unsigned NOT NULL,
584 `ActiveList` tinyint(1) unsigned NOT NULL,
585 `ListState` enum('Incomplete','Complete','InProgress') NOT NULL DEFAULT 'Incomplete',
586 `ValidFrom` datetime DEFAULT NULL COMMENT 'Datetime from when list is allowed for transmission',
587 `ValidTo` datetime DEFAULT NULL COMMENT 'Datetime until list is allowed for transmission',
588 PRIMARY KEY (`keyTCAutomatedList`),
589 KEY `AutomatedList_SatelliteModel` (`keySatelliteModel`),
590 CONSTRAINT `AutomatedList_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE
591) ENGINE=InnoDB DEFAULT CHARSET=latin1;
592/*!40101 SET character_set_client = @saved_cs_client */;
593
594--
595-- Dumping data for table `rdt_TC_AutomatedList`
596--
597
598LOCK TABLES `rdt_TC_AutomatedList` WRITE;
599/*!40000 ALTER TABLE `rdt_TC_AutomatedList` DISABLE KEYS */;
600/*!40000 ALTER TABLE `rdt_TC_AutomatedList` ENABLE KEYS */;
601UNLOCK TABLES;
602
603--
604-- Table structure for table `rdt_TC_AutomatedListCommand`
605--
606
607DROP TABLE IF EXISTS `rdt_TC_AutomatedListCommand`;
608/*!40101 SET @saved_cs_client = @@character_set_client */;
609/*!40101 SET character_set_client = utf8 */;
610CREATE TABLE `rdt_TC_AutomatedListCommand` (
611 `keyTCAutomatedListCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
612 `keyTCAutomatedList` int(10) unsigned NOT NULL,
613 `CommandID` int(10) unsigned NOT NULL,
614 `CommandString` mediumtext NOT NULL,
615 `ForceTransmission` tinyint(1) unsigned NOT NULL,
616 `SendState` enum('UNHANDLED','TTS OK','TTS NOK','TNC OK','TNC NOK','SAT OK','SAT NOK','SAT UNDEF') NOT NULL DEFAULT 'UNHANDLED',
617 `TransmissionTime` datetime DEFAULT NULL,
618 PRIMARY KEY (`keyTCAutomatedListCommand`),
619 UNIQUE KEY `keyTCAutomatedList_CommandID` (`keyTCAutomatedList`,`CommandID`),
620 CONSTRAINT `AutomatedListCommand_AutomatedList` FOREIGN KEY (`keyTCAutomatedList`) REFERENCES `rdt_TC_AutomatedList` (`keyTCAutomatedList`) ON DELETE CASCADE ON UPDATE CASCADE
621) ENGINE=InnoDB DEFAULT CHARSET=latin1;
622/*!40101 SET character_set_client = @saved_cs_client */;
623
624--
625-- Dumping data for table `rdt_TC_AutomatedListCommand`
626--
627
628LOCK TABLES `rdt_TC_AutomatedListCommand` WRITE;
629/*!40000 ALTER TABLE `rdt_TC_AutomatedListCommand` DISABLE KEYS */;
630/*!40000 ALTER TABLE `rdt_TC_AutomatedListCommand` ENABLE KEYS */;
631UNLOCK TABLES;
632
633--
634-- Table structure for table `rdt_TLE`
635--
636
637DROP TABLE IF EXISTS `rdt_TLE`;
638/*!40101 SET @saved_cs_client = @@character_set_client */;
639/*!40101 SET character_set_client = utf8 */;
640CREATE TABLE `rdt_TLE` (
641 `keyTLE` int(10) unsigned NOT NULL AUTO_INCREMENT,
642 `keySatelliteModel` int(10) unsigned NOT NULL,
643 `Time` datetime NOT NULL,
644 `TLE` text NOT NULL,
645 PRIMARY KEY (`keyTLE`),
646 KEY `TLE_SatelliteModel` (`keySatelliteModel`),
647 CONSTRAINT `TLE_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE
648) ENGINE=InnoDB DEFAULT CHARSET=latin1;
649/*!40101 SET character_set_client = @saved_cs_client */;
650
651--
652-- Dumping data for table `rdt_TLE`
653--
654
655LOCK TABLES `rdt_TLE` WRITE;
656/*!40000 ALTER TABLE `rdt_TLE` DISABLE KEYS */;
657/*!40000 ALTER TABLE `rdt_TLE` ENABLE KEYS */;
658UNLOCK TABLES;
659
660--
661-- Table structure for table `stm_GroundStation`
662--
663
664DROP TABLE IF EXISTS `stm_GroundStation`;
665/*!40101 SET @saved_cs_client = @@character_set_client */;
666/*!40101 SET character_set_client = utf8 */;
667CREATE TABLE `stm_GroundStation` (
668 `keyGroundStation` int(10) unsigned NOT NULL AUTO_INCREMENT,
669 `Name` varchar(50) NOT NULL DEFAULT '-----',
670 `NSCoordinate` double NOT NULL DEFAULT 0,
671 `EWCoordinate` double NOT NULL DEFAULT 0,
672 `HeightNN` double NOT NULL DEFAULT 0,
673 `TimeZone` double NOT NULL DEFAULT 0,
674 `TTSAdress` varchar(255) DEFAULT NULL,
675 `TTSPort` smallint(5) unsigned NOT NULL DEFAULT 0,
676 `Country` varchar(20) DEFAULT NULL,
677 `LocalAuthority` varchar(50) DEFAULT NULL,
678 `ContactPerson` varchar(50) DEFAULT NULL,
679 `ContactPhone` varchar(50) DEFAULT NULL,
680 `ContactEmail` varchar(50) DEFAULT NULL,
681 PRIMARY KEY (`keyGroundStation`),
682 UNIQUE KEY `Name` (`Name`)
683) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Only Copy of working table stm_GroundStation in globaldb!';
684/*!40101 SET character_set_client = @saved_cs_client */;
685
686--
687-- Dumping data for table `stm_GroundStation`
688--
689
690LOCK TABLES `stm_GroundStation` WRITE;
691/*!40000 ALTER TABLE `stm_GroundStation` DISABLE KEYS */;
692INSERT INTO `stm_GroundStation` VALUES
693 (1,'localhost',0,0,0,0,'localhost',7000,NULL,NULL,NULL,NULL,NULL);
694/*!40000 ALTER TABLE `stm_GroundStation` ENABLE KEYS */;
695UNLOCK TABLES;
696
697--
698-- Table structure for table `stm_SatelliteModel`
699--
700
701DROP TABLE IF EXISTS `stm_SatelliteModel`;
702/*!40101 SET @saved_cs_client = @@character_set_client */;
703/*!40101 SET character_set_client = utf8 */;
704CREATE TABLE `stm_SatelliteModel` (
705 `keySatelliteModel` int(10) unsigned NOT NULL AUTO_INCREMENT,
706 `NORADKatalogNr` int(10) unsigned NOT NULL DEFAULT 0,
707 `SpacecraftID` int(10) unsigned NOT NULL DEFAULT 0,
708 `ModelName` varchar(20) NOT NULL,
709 `Comment` varchar(50) DEFAULT NULL,
710 `UpFrequency` int(11) NOT NULL DEFAULT 0 COMMENT '[Hz]',
711 `DownFrequency` int(11) NOT NULL DEFAULT 0 COMMENT '[Hz]',
712 `isLaboratoryModel` tinyint(1) unsigned NOT NULL DEFAULT 0,
713 `TransferFrameLength` smallint(6) NOT NULL DEFAULT 0 COMMENT '[Byte]',
714 `TimeCalculationBase` datetime DEFAULT NULL,
715 PRIMARY KEY (`keySatelliteModel`),
716 UNIQUE KEY `NORADKatalogNr` (`NORADKatalogNr`)
717) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
718/*!40101 SET character_set_client = @saved_cs_client */;
719
720--
721-- Dumping data for table `stm_SatelliteModel`
722--
723
724LOCK TABLES `stm_SatelliteModel` WRITE;
725/*!40000 ALTER TABLE `stm_SatelliteModel` DISABLE KEYS */;
726INSERT INTO `stm_SatelliteModel` VALUES
727 (1,80,0,'Test','The main test model',0,0,1,0,'2000-01-01 00:00:00'),
728 (2,81,0,'Linux','Versions of the software compiled for Linux',0,0,1,0,'2000-01-01 00:00:00');
729/*!40000 ALTER TABLE `stm_SatelliteModel` ENABLE KEYS */;
730UNLOCK TABLES;
731
732--
733-- Table structure for table `stm_TC_Command`
734--
735
736DROP TABLE IF EXISTS `stm_TC_Command`;
737/*!40101 SET @saved_cs_client = @@character_set_client */;
738/*!40101 SET character_set_client = utf8 */;
739CREATE TABLE `stm_TC_Command` (
740 `keyTCCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
741 `keyApp` int(10) unsigned NOT NULL,
742 `Pre_Command` varchar(30) DEFAULT NULL,
743 `Post_Command` varchar(30) DEFAULT NULL,
744 `Name` varchar(45) NOT NULL,
745 `TC_Code` tinyint(8) unsigned NOT NULL,
746 `NumberOfParameters` smallint(5) unsigned NOT NULL,
747 `Editable` tinyint(1) unsigned NOT NULL DEFAULT 1,
748 `Function` varchar(100) NOT NULL,
749 `Comment` varchar(200) DEFAULT NULL,
750 `GuiParamWindow` enum('value','switch','sourcepacket') DEFAULT NULL,
751 PRIMARY KEY (`keyTCCommand`),
752 UNIQUE KEY `UNIQUE_cmd2app_combination` (`keyApp`,`TC_Code`),
753 KEY `TC_Command_keyApp` (`keyApp`),
754 CONSTRAINT `keyApp` FOREIGN KEY (`keyApp`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE
755) ENGINE=InnoDB AUTO_INCREMENT=170006 DEFAULT CHARSET=latin1 COMMENT='List of TELECOMMANDS';
756/*!40101 SET character_set_client = @saved_cs_client */;
757
758--
759-- Dumping data for table `stm_TC_Command`
760--
761
762LOCK TABLES `stm_TC_Command` WRITE;
763/*!40000 ALTER TABLE `stm_TC_Command` DISABLE KEYS */;
764INSERT INTO `stm_TC_Command` VALUES
765 (1001,1,NULL,NULL,'NOP',1,0,0,'GLB - no operation','does nothing while being a valid command',''),
766 (1002,1,NULL,NULL,'SEND_EXTENDEDHKD',2,8,1,'GLB - extended housekeeping request','request transmission of 1 to 8 extended Real-Time telemetry source packages with the given <b>ID</b>\'s','sourcepacket'),
767 (1003,1,NULL,NULL,'SET_DEFAULT_HR',3,0,0,'GLB - set default housekeeping rate','set housekeeping rate for all source packages to their respective default values',NULL),
768 (2001,2,NULL,NULL,'NOP',1,0,0,'NOI - no operation','does nothing while being a valid command',NULL),
769 (2003,2,NULL,NULL,'SEND_NODEINFOS',3,0,0,'NOI - request node infos SP','request transmission of the ExtendedTmNodeInfos SP',NULL),
770 (2004,2,NULL,NULL,'SET_INT_TEMP_OFFSET',4,1,1,'NOI - set internal temperatur sensor offset','set the linear offset value for each nodes internal temperatur sensor','value'),
771 (2005,2,NULL,NULL,'SET_HISTORY_RATE',5,1,1,'NOI - set history rate of the NodeInfos telemetry','set the history sample rate for the NodeInfos source packet','value'),
772 (2006,2,NULL,NULL,'STORE_FLASH_PARAMS',6,0,0,'NOI - store flash parameter (bootCount, intTempOffset)','store the current flash parameter permanently<br>- Boot-Counter<br>- Internal Temperature Sensor Offset',NULL),
773 (3001,3,NULL,NULL,'NOP',1,0,0,'WAT - no operation','does nothing while being a valid command',NULL),
774 (3002,3,NULL,NULL,'RESET_NODE',2,0,0,'WAT - reset node','set node software in a while(1)-loop and wait for ext watchdog to reset the node',NULL),
775 (3003,3,NULL,NULL,'NOT_ALLOW_RESET',3,0,0,'WAT - not allow reset by watchdog application','do not allow the watchdog application to reset the node in case of detected software problems',NULL),
776 (3004,3,NULL,NULL,'ALLOW_RESET',4,0,0,'WAT - allow reset by watchdog application','allow the watchdog application to reset the node in case of detected software problems',NULL),
777 (3005,3,NULL,NULL,'STORE_FLASH_PARAMS',5,0,0,'WAT - store flash parameter (isResetEnabled)','store the current flash parameter permanently<br>- enable flag for watchdog-resets',NULL),
778 (4001,4,NULL,NULL,'NOP',1,0,0,'TIM - no operation','does nothing while being a valid command',NULL),
779 (4003,4,NULL,NULL,'SET_UTC',3,1,1,'TIM - set utc time','set current UTC time to <b>Seconds</b>','value'),
780 (4004,4,NULL,NULL,'ADJUST_UTC',4,1,1,'TIM - adjust utc time in milliseconds','adjust current UTC time by <b>Milliseconds</b>','value'),
781 (4005,4,NULL,NULL,'DISTRIBUTE_UTC_ENABLE',5,0,0,'TIM - enable time distribution','enable node to distribute time',NULL),
782 (4006,4,NULL,NULL,'DISTRIBUTE_UTC_DISABLE',6,0,0,'TIM - disable time distribution','disable node to distribute time',NULL),
783 (4007,4,NULL,NULL,'PPS_SYNC_ENABLE',7,0,0,'TIM - enable pps synchronisation','enable node to synchronize time with PPS signal',NULL),
784 (4008,4,NULL,NULL,'PPS_SYNC_DISABLE',8,0,0,'TIM - disable pps synchronisation','disable node to synchronize time with PPS signal',NULL),
785 (5001,5,NULL,NULL,'STD_TM_ENABLE',1,0,0,'HKE - enable standard telemetry','enable node to collect and distribute standard telemetry',NULL),
786 (5002,5,NULL,NULL,'STD_TM_DISABLE',2,0,0,'HKE - disable standard telemetry','disable node to collect and distribute standard telemetry',NULL),
787 (5003,5,NULL,NULL,'SET_HISTORY_RATE',3,1,1,'HKE - set standard telemetry update rate','set new <b>Update Rate</b> for historical standard telemetry','value'),
788 (5005,5,NULL,NULL,'SET_EXTENDEDHKD',4,8,1,'HKE - set list of SourcePackets to be requested each time telemetry is collected','set a list of extened telemetry SourcePackets that are requested each time telemetry is requested','sourcepacket'),
789 (5006,5,NULL,NULL,'CLEAR_EXTENDEDHKD',5,0,0,'HKE - clear list of SourcePackets to be requested eacht time a telemetry is collected','clear list of extened telemetry SourcePackets that are requested each time telemetry is requested',NULL),
790 (6001,6,NULL,NULL,'NOP',1,0,0,'CMD - no operation','does nothing while being a valid command',NULL),
791 (100001,10,NULL,NULL,'SEND_INFO',1,0,0,'TMM - request Telemetry Manager Info telemetry','request a SourcePacket with info on the current state of the history buffers and the transfer frame composer',NULL),
792 (100003,10,NULL,NULL,'CLEAR_HISTORY',3,1,1,'TMM - clear History TM','clear all history telemetry in a single or all history telemetry buffer','value'),
793 (100004,10,NULL,NULL,'CLEAR_HISTORY_COUNTER',4,1,1,'TMM - clear History TM Counter','clear all counters (lost SourcePackets, bad CRC...) in a single or all history telemetry channel','value'),
794 (100005,10,NULL,NULL,'CLEAR_LIVE_COUNTER',5,1,1,'TMM - clear Live TM Counter','clear all counters (lost SourcePackets) in a single or all live telemetry channel','value'),
795 (100006,10,NULL,NULL,'SET_WRITE_PROTECTION',6,1,1,'TMM - set write protection','sets the TMM write protection so that experiment data does not get overwritten when the PCDH is rebooted','value'),
796 (100007,10,NULL,NULL,'SEND_SDBLOCK',7,2,1,'TMM- send SD Block','read a 512 byte block from one SD card and send it back as telemetry for debugging purposes','value'),
797 (110001,11,NULL,NULL,'NOP',1,0,0,'OBC - no operation','does nothing',NULL),
798 (110002,11,NULL,NULL,'TIMER_SYNC',2,1,1,'OBC - Syncronizes time with eps','get\'s time from eps and obc starts his tasks depending on the time','value'),
799 (110003,11,NULL,NULL,'ABORT',3,1,1,'OBC - abort flight schedule application','aborts a running flight shedule',NULL),
800 (110004,11,NULL,NULL,'MAGNETS',4,1,1,'OBC - set magnet mode','arms or disarms the magnets. If the magnets are armed, supplying power to the 12V magnet line will cause the ejection of the paracute.','value'),
801 (120001,12,NULL,NULL,'NOP',1,0,0,'RBE - no operation','does nothing',NULL),
802 (120002,12,NULL,NULL,'SET_20V_EN',2,1,1,'RBE - set 20V swtich enable','enables or disables the 20V switch used for charging the FFU batteries','value'),
803 (130001,13,NULL,NULL,'NOP',1,0,0,'EPS - no operation','does nothing',NULL),
804 (130002,13,NULL,NULL,'SET_MODE',2,1,1,'EPS - set power mode','sets the power mode','value'),
805 (130003,13,NULL,NULL,'(DEV)SET_POWER_RAW',3,1,1,'EPS - override power mode','allows finer control over the state of the power switches. Each bit defines the state of one power switch starting from the LSB for pFDA Common','value'),
806 (130004,13,NULL,NULL,'SET_ACTIVE_CAN',4,1,1,'EPS - set active can','sets the status of the switches that drive the can select lines to either activate can 0 or can 1','value'),
807 (140001,14,NULL,NULL,'NOP',1,0,0,'FDA - NOP','does nothing',NULL),
808 (140002,14,NULL,NULL,'SET_ENABLED',2,1,1,'FDA - set enabled','enables or disables the pFDA pump','value'),
809 (140003,14,NULL,NULL,'SET_FREQUENCY',3,1,1,'FDA - set pump frequency','sets the frequency that the pump operates at','value'),
810 (140004,14,NULL,NULL,'SET_SPEED',4,1,1,'FDA - set pump speed','sets the speed that the pump operates at','value'),
811 (150001,15,NULL,NULL,'NOP',1,0,0,'RSG - NOP','does nothing',NULL),
812 (150002,15,NULL,NULL,'SET_SAFE_MODE',2,1,1,'RSG - set safe mode','sets the RSG app into safe mode in which rocket signal reception is logged but no other actions are taken','value'),
813 (160001,16,NULL,NULL,'NOP',1,0,0,'LED - no operation','does nothing',NULL),
814 (160002,16,NULL,NULL,'TOGGLE',2,1,1,'LED - set toggle period','sets a period in seconds in after which the LED will toggle on or off automatically continuously until disabled. Set to 0 to disable.','value'),
815 (160003,16,NULL,NULL,'SET',3,1,1,'LED - set LED state','sets the LED pin to the specified value','value'),
816 (170001,17,NULL,NULL,'NOP',1,0,0,'PFM - no operation','does nothing',NULL),
817 (170002,17,NULL,NULL,'TELEMETRY',2,1,1,'PFM - enable telemetry trigger system','Enables or disables the automatic telemetry trigger system that requests telemetry from the 4 pFDAs at 30Hz','value'),
818 (170003,17,NULL,NULL,'SET_ENABLED',3,4,1,'PFM - enable pFDAs','Causes OBC to send commands to all four pFDA nodes to enable or disable them individually. ','value'),
819 (170004,17,NULL,NULL,'SET_FREQUENCY',4,4,1,'PFM - set pFDA frequency','Causes OBC to send commands to all four pFDA nodes to change their pump frequency simultaneously. ','value'),
820 (170005,17,NULL,NULL,'SET_SPEED',5,4,1,'PFM - set pFDA speed','Causes OBC to send commands to all four pFDA nodes to change their speed simultaneously. ','value');
821/*!40000 ALTER TABLE `stm_TC_Command` ENABLE KEYS */;
822UNLOCK TABLES;
823
824--
825-- Table structure for table `stm_TC_Controlbytes`
826--
827
828DROP TABLE IF EXISTS `stm_TC_Controlbytes`;
829/*!40101 SET @saved_cs_client = @@character_set_client */;
830/*!40101 SET character_set_client = utf8 */;
831CREATE TABLE `stm_TC_Controlbytes` (
832 `keyTCControlBytes` int(10) unsigned NOT NULL AUTO_INCREMENT,
833 `Name` varchar(20) NOT NULL,
834 `Value` varchar(8) NOT NULL,
835 `Comment` varchar(200) DEFAULT NULL,
836 PRIMARY KEY (`keyTCControlBytes`)
837) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Table of base CONTROL BYTES for UHF communication protocols';
838/*!40101 SET character_set_client = @saved_cs_client */;
839
840--
841-- Dumping data for table `stm_TC_Controlbytes`
842--
843
844LOCK TABLES `stm_TC_Controlbytes` WRITE;
845/*!40000 ALTER TABLE `stm_TC_Controlbytes` DISABLE KEYS */;
846INSERT INTO `stm_TC_Controlbytes` VALUES
847 (1,'Regular','2050','Telecommand Message');
848/*!40000 ALTER TABLE `stm_TC_Controlbytes` ENABLE KEYS */;
849UNLOCK TABLES;
850
851--
852-- Table structure for table `stm_TC_Parameter`
853--
854
855DROP TABLE IF EXISTS `stm_TC_Parameter`;
856/*!40101 SET @saved_cs_client = @@character_set_client */;
857/*!40101 SET character_set_client = utf8 */;
858CREATE TABLE `stm_TC_Parameter` (
859 `keyTCParameter` int(10) unsigned NOT NULL AUTO_INCREMENT,
860 `keyTCCommand` int(10) unsigned NOT NULL,
861 `ParamNo` smallint(6) NOT NULL,
862 `ParamName` varchar(20) NOT NULL,
863 `BitLenght` smallint(16) unsigned NOT NULL,
864 `ParamType` enum('TC_BYTE','TC_BYTE_UN','TC_HEX_ARRAY','TC_SHORT','TC_SHORT_UN','TC_SHORT_UN_LE','TC_INT','TC_INT_UN','TC_INT_UN_LE','TC_LONG','TC_LONG_UN','TC_LONG_UN_LE','TC_FLOAT','TC_DOUBLE','TC_INT_UN_TIME') NOT NULL DEFAULT 'TC_BYTE',
865 `DefaultValue` double DEFAULT NULL,
866 `MinValue` double DEFAULT NULL,
867 `MaxValue` double DEFAULT NULL,
868 `Unit` varchar(15) DEFAULT NULL,
869 `Comment` varchar(1000) DEFAULT NULL,
870 `Interpretation` varchar(3000) DEFAULT NULL,
871 PRIMARY KEY (`keyTCParameter`),
872 UNIQUE KEY `UNIQUE_paramNo2cmd_combination` (`keyTCCommand`,`ParamNo`),
873 KEY `keyTCCommand` (`keyTCCommand`),
874 CONSTRAINT `TCParameter_TCCommand` FOREIGN KEY (`keyTCCommand`) REFERENCES `stm_TC_Command` (`keyTCCommand`) ON DELETE CASCADE ON UPDATE CASCADE
875) ENGINE=InnoDB AUTO_INCREMENT=24000302 DEFAULT CHARSET=latin1 COMMENT='List of TELECOMMAND PARAMETERS';
876/*!40101 SET character_set_client = @saved_cs_client */;
877
878--
879-- Dumping data for table `stm_TC_Parameter`
880--
881
882LOCK TABLES `stm_TC_Parameter` WRITE;
883/*!40000 ALTER TABLE `stm_TC_Parameter` DISABLE KEYS */;
884INSERT INTO `stm_TC_Parameter` VALUES
885 (100201,1002,1,'ID 1',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
886 (100202,1002,2,'ID 2',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
887 (100203,1002,3,'ID 3',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
888 (100204,1002,4,'ID 4',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
889 (100205,1002,5,'ID 5',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
890 (100206,1002,6,'ID 6',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
891 (100207,1002,7,'ID 7',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
892 (100208,1002,8,'ID 8',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
893 (200401,2004,1,'Offset',8,'TC_BYTE',0,-128,127,'°C','internal temperature sensor offset in degrees Celsius',NULL),
894 (200501,2005,1,'New Rate',16,'TC_SHORT_UN',0,0,65535,'s','new history rate',NULL),
895 (400201,4003,1,'UTC',32,'TC_INT_UN_TIME',0,0,2147483647,'s','seconds since 1.1.2000 to current time in UTC',NULL),
896 (400401,4004,1,'Milliseconds',32,'TC_INT',0,-2147483648,2147483647,'ms','milliseconds to adjust current UTC time by',NULL),
897 (500301,5003,1,'Update Rate',32,'TC_INT',0,0,2147483647,'s','update rate in seconds',NULL),
898 (500501,5005,1,'ID 1',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
899 (500502,5005,2,'ID 2',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
900 (500503,5005,3,'ID 3',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
901 (500504,5005,4,'ID 4',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
902 (500505,5005,5,'ID 5',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
903 (500506,5005,6,'ID 6',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
904 (500507,5005,7,'ID 7',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
905 (500508,5005,8,'ID 8',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
906 (10000301,100003,1,'History Channel',8,'TC_BYTE_UN',255,0,255,NULL,'History Channel to clear','0=Bus History;1=Payload History;2=Diagnosis History;255=All'),
907 (10000401,100004,1,'History Channel',8,'TC_BYTE_UN',255,0,255,NULL,'History Channel to clear all counters in','0=Bus History;1=Payload History;2=Diagnosis History;255=All'),
908 (10000501,100005,1,'Live Channel',8,'TC_BYTE_UN',255,0,255,NULL,'Live Channel to clear all counters in','0=Standard Tm;1=RealTime Tm;255=All'),
909 (10000601,100006,1,'Status',8,'TC_BYTE_UN',0,0,1,NULL,'The new status of the write protection','0=Disabled;1=Enabled'),
910 (10000701,100007,1,'Card',8,'TC_BYTE_UN',0,0,1,NULL,'SD Card to read from',NULL),
911 (10000702,100007,2,'Block',32,'TC_INT_UN',0,0,4294967295,NULL,'Block to read',NULL),
912 (11000301,110002,1,'Timer',32,'TC_INT',-600,-600,67,'s','timer to syncronize nodes','-600=SODS;67=SOE'),
913 (11000401,110004,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to arm or disarm the magnets','0=Disarmed;1=Armed'),
914 (12000201,120002,1,'En',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to disable or to enable the 20V switch','0=Disabled;1=Enabled'),
915 (13000201,130002,1,'Mode',8,'TC_BYTE_UN',0,0,255,NULL,'The power mode which should be switched to','0=Standby;1=Pre launch;2=Ejection;3=Experiment Phase 1;4=Experiment Phase 2;5=Post Experiment;6=Magnets;7=Descent;8=Recovery;'),
916 (13000401,130004,1,'CAN',8,'TC_BYTE_UN',0,0,1,NULL,'the can line to switch to','0=CAN0;1=CAN1'),
917 (14000201,140002,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'Wheter to disable or enable the pump','0=Disabled;1=Enabled'),
918 (14000301,140003,1,'Frequency',16,'TC_SHORT_UN',1000,1000,20000,'Hz','The frequency at which the pump shall run at',NULL),
919 (14000401,140004,1,'Speed',16,'TC_SHORT',0,-100,100,'%','The speed at which the pump shall run at',NULL),
920 (15000201,150002,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'The state to which the safe mode should be set','0=Disabled;1=Enabled'),
921 (16000201,160002,1,'Period',8,'TC_BYTE_UN',0,0,255,'s','The period after which the LED shall toggle automatically. 0 disables automatic toggling.',NULL),
922 (16000301,160003,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'The state to which the LED pin shall be set.',NULL),
923 (17000201,170002,1,'Enable',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to enable or disable synchronous pFDA telemetry capturing','0=Disabled;1=Enabled'),
924 (17000301,170003,1,'Enable pFDA 1',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to enable or disable pFDA 1','0=Disabled;1=Enabled'),
925 (17000302,170003,2,'Enable pFDA 2',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to enable or disable pFDA 2','0=Disabled;1=Enabled'),
926 (17000303,170003,3,'Enable pFDA 3',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to enable or disable pFDA 3','0=Disabled;1=Enabled'),
927 (17000304,170003,4,'Enable pFDA 4',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to enable or disable pFDA 4','0=Disabled;1=Enabled'),
928 (17000401,170004,1,'pFDA 1 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 1 frequency',''),
929 (17000402,170004,2,'pFDA 2 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 2 frequency',''),
930 (17000403,170004,3,'pFDA 3 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 3 frequency',''),
931 (17000404,170004,4,'pFDA 4 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 4 frequency',''),
932 (17000501,170005,1,'pFDA 1 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 1 speed',''),
933 (17000502,170005,2,'pFDA 2 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 2 speed',''),
934 (17000503,170005,3,'pFDA 3 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 3 speed',''),
935 (17000504,170005,4,'pFDA 4 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 4 speed',''),
936 (24000301,130003,1,'Mode',16,'TC_SHORT_UN',0,0,2047,NULL,'The bit mask according to which to enable or disable power switches 0 -> off 1 -> on',NULL);
937/*!40000 ALTER TABLE `stm_TC_Parameter` ENABLE KEYS */;
938UNLOCK TABLES;
939
940--
941-- Table structure for table `stm_TC_Procedure`
942--
943
944DROP TABLE IF EXISTS `stm_TC_Procedure`;
945/*!40101 SET @saved_cs_client = @@character_set_client */;
946/*!40101 SET character_set_client = utf8 */;
947CREATE TABLE `stm_TC_Procedure` (
948 `keyTCProcedure` int(10) unsigned NOT NULL AUTO_INCREMENT,
949 `ProcedureName` varchar(100) NOT NULL,
950 `ListLocked` tinyint(1) NOT NULL DEFAULT 0,
951 PRIMARY KEY (`keyTCProcedure`)
952) ENGINE=InnoDB DEFAULT CHARSET=latin1;
953/*!40101 SET character_set_client = @saved_cs_client */;
954
955--
956-- Dumping data for table `stm_TC_Procedure`
957--
958
959LOCK TABLES `stm_TC_Procedure` WRITE;
960/*!40000 ALTER TABLE `stm_TC_Procedure` DISABLE KEYS */;
961/*!40000 ALTER TABLE `stm_TC_Procedure` ENABLE KEYS */;
962UNLOCK TABLES;
963
964--
965-- Table structure for table `stm_TC_ProcedureCommand`
966--
967
968DROP TABLE IF EXISTS `stm_TC_ProcedureCommand`;
969/*!40101 SET @saved_cs_client = @@character_set_client */;
970/*!40101 SET character_set_client = utf8 */;
971CREATE TABLE `stm_TC_ProcedureCommand` (
972 `keyTCProcedureCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
973 `keyTCProcedure` int(10) unsigned NOT NULL,
974 `CommandID` int(10) unsigned NOT NULL,
975 `CommandString` mediumtext NOT NULL,
976 `ForceTransmission` tinyint(1) unsigned NOT NULL DEFAULT 0,
977 PRIMARY KEY (`keyTCProcedureCommand`),
978 KEY `TCProcedureCommand_TCProcedure` (`keyTCProcedure`),
979 CONSTRAINT `ProcedureCommand_Procedure` FOREIGN KEY (`keyTCProcedure`) REFERENCES `stm_TC_Procedure` (`keyTCProcedure`) ON DELETE CASCADE ON UPDATE CASCADE
980) ENGINE=InnoDB DEFAULT CHARSET=latin1;
981/*!40101 SET character_set_client = @saved_cs_client */;
982
983--
984-- Dumping data for table `stm_TC_ProcedureCommand`
985--
986
987LOCK TABLES `stm_TC_ProcedureCommand` WRITE;
988/*!40000 ALTER TABLE `stm_TC_ProcedureCommand` DISABLE KEYS */;
989/*!40000 ALTER TABLE `stm_TC_ProcedureCommand` ENABLE KEYS */;
990UNLOCK TABLES;
991
992--
993-- Table structure for table `stm_TNC`
994--
995
996DROP TABLE IF EXISTS `stm_TNC`;
997/*!40101 SET @saved_cs_client = @@character_set_client */;
998/*!40101 SET character_set_client = utf8 */;
999CREATE TABLE `stm_TNC` (
1000 `keyTNC` int(10) unsigned NOT NULL AUTO_INCREMENT,
1001 `Name` varchar(50) NOT NULL,
1002 `ErrorDetectionRoutine` enum('','MobiTex') DEFAULT '',
1003 PRIMARY KEY (`keyTNC`)
1004) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1005/*!40101 SET character_set_client = @saved_cs_client */;
1006
1007--
1008-- Dumping data for table `stm_TNC`
1009--
1010
1011LOCK TABLES `stm_TNC` WRITE;
1012/*!40000 ALTER TABLE `stm_TNC` DISABLE KEYS */;
1013INSERT INTO `stm_TNC` VALUES
1014 (7,'Tbx20Egse','MobiTex');
1015/*!40000 ALTER TABLE `stm_TNC` ENABLE KEYS */;
1016UNLOCK TABLES;
1017
1018--
1019-- Table structure for table `stm_anomalies`
1020--
1021
1022DROP TABLE IF EXISTS `stm_anomalies`;
1023/*!40101 SET @saved_cs_client = @@character_set_client */;
1024/*!40101 SET character_set_client = utf8 */;
1025CREATE TABLE `stm_anomalies` (
1026 `keyAnomalies` int(10) unsigned NOT NULL AUTO_INCREMENT,
1027 `Name` varchar(50) NOT NULL,
1028 `AnomalyId` int(11) NOT NULL,
1029 `Critical` tinyint(1) NOT NULL DEFAULT 0,
1030 `Comment` varchar(200) NOT NULL,
1031 PRIMARY KEY (`keyAnomalies`),
1032 UNIQUE KEY `UNIQUE_AnomalyId` (`AnomalyId`)
1033) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1 COMMENT='lists all the anomalies that exist';
1034/*!40101 SET character_set_client = @saved_cs_client */;
1035
1036--
1037-- Dumping data for table `stm_anomalies`
1038--
1039
1040LOCK TABLES `stm_anomalies` WRITE;
1041/*!40000 ALTER TABLE `stm_anomalies` DISABLE KEYS */;
1042INSERT INTO `stm_anomalies` VALUES
1043 (0,'NO_ANOMALY',0,0,'no anomaly - all is well'),
1044 (1,'GLB_BAD_PARAM',1,0,''),
1045 (2,'GLB_BAD_TCC',2,0,''),
1046 (7,'WAT_TIMINGERR',7,0,''),
1047 (8,'WAT_WOULD_RESET_NODE',8,0,''),
1048 (9,'WAT_TABLE_OVERFLOW',9,0,''),
1049 (14,'TMM_BUS_HIST_FIFO_FULL',14,0,''),
1050 (15,'TMM_PLD_HIST_FIFO_FULL',15,0,''),
1051 (16,'TMM_STD_TM_FIFO_FULL',16,0,''),
1052 (17,'TMM_RT_TM_FIFO_FULL',17,0,''),
1053 (18,'TMM_BUS_HIST_FLASH_FULL',18,0,''),
1054 (19,'TMM_PLD_HIST_FLASH_FULL',19,0,''),
1055 (22,'GLB_FIFO_FULL',22,0,''),
1056 (23,'GLB_SYNC_FIFO_FULL',23,0,''),
1057 (25,'TMM_DIA_HIST_FIFO_FULL',25,0,''),
1058 (26,'TMM_DIA_HIST_FLASH_FULL',26,0,''),
1059 (35,'TMM_BUS_HIST_RESET',35,0,''),
1060 (36,'TMM_PLD_HIST_RESET',36,0,''),
1061 (37,'TMM_DIA_HIST_RESET',37,0,''),
1062 (48,'RBE_PCDHCONFIG_BUSY',48,0,''),
1063 (67,'UNEXPECTED_BOOT_OBC',67,0,''),
1064 (80,'TMM_SD1_INIT_FAILED',49,0,''),
1065 (81,'TMM_SD2_INIT_FAILED',50,0,''),
1066 (99,'ANM_BAD_ANOMALY_INDEX',99,0,'');
1067/*!40000 ALTER TABLE `stm_anomalies` ENABLE KEYS */;
1068UNLOCK TABLES;
1069
1070--
1071-- Table structure for table `stm_applications`
1072--
1073
1074DROP TABLE IF EXISTS `stm_applications`;
1075/*!40101 SET @saved_cs_client = @@character_set_client */;
1076/*!40101 SET character_set_client = utf8 */;
1077CREATE TABLE `stm_applications` (
1078 `keyApplications` int(10) unsigned NOT NULL AUTO_INCREMENT,
1079 `Name` varchar(45) NOT NULL,
1080 `ShortName` varchar(3) NOT NULL,
1081 `ID` int(10) unsigned NOT NULL,
1082 `comment` varchar(200) DEFAULT NULL,
1083 `description` varchar(200) DEFAULT NULL,
1084 PRIMARY KEY (`keyApplications`),
1085 UNIQUE KEY `UNIQUE_ShortName` (`ShortName`),
1086 UNIQUE KEY `UNIQUE_ID` (`ID`)
1087) ENGINE=InnoDB AUTO_INCREMENT=905 DEFAULT CHARSET=latin1 COMMENT='List of APPLICATIONS';
1088/*!40101 SET character_set_client = @saved_cs_client */;
1089
1090--
1091-- Dumping data for table `stm_applications`
1092--
1093
1094LOCK TABLES `stm_applications` WRITE;
1095/*!40000 ALTER TABLE `stm_applications` DISABLE KEYS */;
1096INSERT INTO `stm_applications` VALUES
1097 (1,'GLOBAL','GLB',1,'GLB - Every application','common commands implemented in every application'),
1098 (2,'NODEINFOS','NOI',2,'GLB - Node Infos','supplies node specific information'),
1099 (3,'WATCHDOG','WAT',3,'GLB - Watchdog','supervises node applications and handles \"I am alive\" messages'),
1100 (4,'TIMEMANAGER','TIM',4,'GLB - Time Manager','handles time and synchronisation'),
1101 (5,'HOUSEKEEPER','HKE',5,'GLB - Housekeeper','manages standard telemetry on the four main nodes (OBC, EPS, COM, AOCS)'),
1102 (6,'COMMANDER','CMD',6,'GLB - Commander','handles incoming telecommands'),
1103 (10,'TMMANAGER','TMM',10,'OBC - Telemetry Manager','manages onbord telemetry and downlink data'),
1104 (11,'OBC','OBC',11,'OBC - Control various things','Mainly just turn an LED on or off'),
1105 (12,'RBE','RBE',12,'RBE - Control various things','Mainly just LED things'),
1106 (13,'EPS','EPS',13,'EPS - Electronic Power Subsystem','manages FFU power modes'),
1107 (14,'PFDAPUMP','FDA',14,'FAP - Fluid Dynamic Actuator Pump control','Controls pFDA pump parameters'),
1108 (15,'ROCKETSIGNALS','RSG',15,'RSG - Rocketsignal interface','Application that polls the signal lines from the RXSM and configures the FFU when they are received'),
1109 (16,'LED','LED',16,'LED - Control the LED','controls the debug led on each board'),
1110 (17,'PFDAMANAGER','PFM',17,'PFM - pFDA manager','Application to synchronously send commands and requests for telemetry to all four pFDAs'),
1111 (901,'STDTM OBC','STO',901,'OBC - Standard TM','\"virtual\" application to manage standard Telemetry of OBC'),
1112 (902,'STDTM_RBE','STR',902,'RBE - Standard TM','\"virtual\" application to manage standard Telemetry of RBE'),
1113 (903,'STDTM_EPS','STE',903,'EPS - Standard TM','\"virtual\" application to manage standard Telemetry of EPS'),
1114 (904,'STDTM_PFDA','STP',904,'FDA - Standard TM','\"virtual\" application to manage standard Telemetry of pFDAs');
1115/*!40000 ALTER TABLE `stm_applications` ENABLE KEYS */;
1116UNLOCK TABLES;
1117
1118--
1119-- Table structure for table `stm_apps2nodes`
1120--
1121
1122DROP TABLE IF EXISTS `stm_apps2nodes`;
1123/*!40101 SET @saved_cs_client = @@character_set_client */;
1124/*!40101 SET character_set_client = utf8 */;
1125CREATE TABLE `stm_apps2nodes` (
1126 `keyApps2Nodes` int(10) unsigned NOT NULL AUTO_INCREMENT,
1127 `keyNode` int(10) unsigned NOT NULL,
1128 `keyApp` int(10) unsigned NOT NULL,
1129 PRIMARY KEY (`keyApps2Nodes`),
1130 UNIQUE KEY `UNIQUE_app2node_combination` (`keyNode`,`keyApp`),
1131 KEY `keyNode` (`keyNode`),
1132 KEY `keyApp` (`keyApp`),
1133 CONSTRAINT `Apps2Nodes_keyApp` FOREIGN KEY (`keyApp`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE,
1134 CONSTRAINT `Apps2Nodes_keyNode` FOREIGN KEY (`keyNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON DELETE NO ACTION ON UPDATE CASCADE
1135) ENGINE=InnoDB AUTO_INCREMENT=8905 DEFAULT CHARSET=latin1 COMMENT='Map APPLICATIONS to NODES';
1136/*!40101 SET character_set_client = @saved_cs_client */;
1137
1138--
1139-- Dumping data for table `stm_apps2nodes`
1140--
1141
1142LOCK TABLES `stm_apps2nodes` WRITE;
1143/*!40000 ALTER TABLE `stm_apps2nodes` DISABLE KEYS */;
1144INSERT INTO `stm_apps2nodes` VALUES
1145 (1001,1,1),
1146 (1002,1,2),
1147 (1003,1,3),
1148 (1004,1,4),
1149 (1005,1,5),
1150 (1006,1,6),
1151 (2001,2,1),
1152 (2002,2,2),
1153 (2003,2,3),
1154 (2004,2,4),
1155 (2005,2,5),
1156 (2006,2,6),
1157 (2010,2,10),
1158 (2011,2,11),
1159 (2016,2,16),
1160 (2017,2,17),
1161 (2901,2,901),
1162 (3001,3,1),
1163 (3002,3,2),
1164 (3003,3,3),
1165 (3004,3,4),
1166 (3005,3,5),
1167 (3006,3,6),
1168 (3010,3,10),
1169 (3012,3,12),
1170 (3015,3,15),
1171 (3016,3,16),
1172 (3902,3,902),
1173 (4001,4,1),
1174 (4002,4,2),
1175 (4003,4,3),
1176 (4004,4,4),
1177 (4005,4,5),
1178 (4006,4,6),
1179 (4013,4,13),
1180 (4016,4,16),
1181 (4903,4,903),
1182 (5001,5,1),
1183 (5002,5,2),
1184 (5003,5,3),
1185 (5004,5,4),
1186 (5005,5,5),
1187 (5006,5,6),
1188 (5014,5,14),
1189 (5904,5,904),
1190 (6001,6,1),
1191 (6002,6,2),
1192 (6003,6,3),
1193 (6004,6,4),
1194 (6005,6,5),
1195 (6006,6,6),
1196 (6014,6,14),
1197 (6904,6,904),
1198 (7001,7,1),
1199 (7002,7,2),
1200 (7003,7,3),
1201 (7004,7,4),
1202 (7005,7,5),
1203 (7006,7,6),
1204 (7014,7,14),
1205 (7904,7,904),
1206 (8001,8,1),
1207 (8002,8,2),
1208 (8003,8,3),
1209 (8004,8,4),
1210 (8005,8,5),
1211 (8006,8,6),
1212 (8014,8,14),
1213 (8904,8,904);
1214/*!40000 ALTER TABLE `stm_apps2nodes` ENABLE KEYS */;
1215UNLOCK TABLES;
1216
1217--
1218-- Table structure for table `stm_logic_nodes`
1219--
1220
1221DROP TABLE IF EXISTS `stm_logic_nodes`;
1222/*!40101 SET @saved_cs_client = @@character_set_client */;
1223/*!40101 SET character_set_client = utf8 */;
1224CREATE TABLE `stm_logic_nodes` (
1225 `keyLogicNode` int(10) unsigned NOT NULL,
1226 `Name` varchar(16) NOT NULL,
1227 `ShortName` varchar(3) NOT NULL,
1228 `Node_Id` smallint(5) unsigned NOT NULL,
1229 `is_redundant` tinyint(1) DEFAULT 0,
1230 `comment` varchar(200) DEFAULT NULL,
1231 PRIMARY KEY (`keyLogicNode`),
1232 UNIQUE KEY `UNIQUE_Node_Id` (`Node_Id`)
1233) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of LOGIC NODES';
1234/*!40101 SET character_set_client = @saved_cs_client */;
1235
1236--
1237-- Dumping data for table `stm_logic_nodes`
1238--
1239
1240LOCK TABLES `stm_logic_nodes` WRITE;
1241/*!40000 ALTER TABLE `stm_logic_nodes` DISABLE KEYS */;
1242INSERT INTO `stm_logic_nodes` VALUES
1243 (1,'GLOBAL','GLB',128,1,'All active Nodes'),
1244 (2,'OBC','OBC',4,0,'On-Bord Computer Node'),
1245 (3,'RBE','RBE',2,0,'Rocket Bourne Equipment'),
1246 (4,'EPS','EPS',0,0,'Electronic Power Subsystem'),
1247 (5,'PFDA1','FA1',6,0,'pFDA on side 1 of FFU'),
1248 (6,'PFDA2','FA2',8,0,'pFDA on side 2 of FFU'),
1249 (7,'PFDA3','FA3',10,0,'pFDA on side 3 of FFU'),
1250 (8,'PFDA4','FA4',12,0,'pFDA on side 4 of FFU');
1251/*!40000 ALTER TABLE `stm_logic_nodes` ENABLE KEYS */;
1252UNLOCK TABLES;
1253
1254--
1255-- Table structure for table `stm_tc_ht_providers`
1256--
1257
1258DROP TABLE IF EXISTS `stm_tc_ht_providers`;
1259/*!40101 SET @saved_cs_client = @@character_set_client */;
1260/*!40101 SET character_set_client = utf8 */;
1261CREATE TABLE `stm_tc_ht_providers` (
1262 `keyHTProvider` int(10) unsigned NOT NULL AUTO_INCREMENT,
1263 `Name` varchar(45) NOT NULL,
1264 `ID` int(10) unsigned NOT NULL,
1265 `comment` varchar(200) DEFAULT NULL,
1266 PRIMARY KEY (`keyHTProvider`),
1267 UNIQUE KEY `UNIQUE_Bit_Num` (`ID`),
1268 UNIQUE KEY `UNIQUE_Name` (`Name`)
1269) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Bitmap of EPS Switches';
1270/*!40101 SET character_set_client = @saved_cs_client */;
1271
1272--
1273-- Dumping data for table `stm_tc_ht_providers`
1274--
1275
1276LOCK TABLES `stm_tc_ht_providers` WRITE;
1277/*!40000 ALTER TABLE `stm_tc_ht_providers` DISABLE KEYS */;
1278INSERT INTO `stm_tc_ht_providers` VALUES
1279 (1,'I2CMasterDriverRODOSAdapter',0,'An adapter driver for RODOS based I2C masters'),
1280 (2,'I2CSwitchDriverPCA9543',1,'Driver for the I2C switch series PCA9543A/B/C from NXP'),
1281 (3,'I2CSwitchDriverParallel',2,'Driver which allows to use I2C switches connected in parallel as a single large switch'),
1282 (4,'I2CMasterDriverSwitchChannel',3,'Driver which makes an I2C switch downstream bus available as an I2C bus master'),
1283 (5,'A3G4250DDriver',4,'Driver for the A3G4250D ST microelectronics MEMS Gyro with internal temperature sensor'),
1284 (6,'MAX21000Driver',5,'Driver for the MAX21000 Maxim Integrated MEMS Gyro with internal temperature sensor'),
1285 (7,'HMC5983Driver',6,'Driver for the HMC5983 Honeywell Magnetometer IC with internal temperature sensor'),
1286 (8,'LIS3MDLDriver',7,'Driver for the LIS3MDL ST microelectronics Magnetometer IC with internal temperature sensor'),
1287 (9,'TUBSSUDriver',8,'Driver for the TUBSSU TU Berlin Sun sensor with internal temperature sensor'),
1288 (10,'INA219Driver',9,'Driver for the INA219 Texas Instruments current/voltage sensor'),
1289 (11,'TMP175Driver',10,'Driver for the TMP175 Texas Instruments temperature sensor'),
1290 (12,'DRV8830Driver',11,'Driver for the DRV8830 Texas Instruments motor driver'),
1291 (13,'BufferLastSampleSink',12,'A Sink which bufferes the last sample'),
1292 (14,'SpiMasterDriverStm32',13,'Driver for the on-chip SPI peripheral of the STM32F4 series MCU'),
1293 (15,'DifferentialTriggerStm32',14,'A trigger with differential signals for the STM32F4 controller'),
1294 (16,'TriggerChannel',15,'A channel for a trigger'),
1295 (17,'MUFORS6UCDriver',16,'Driver for the MuFors-6UC LITEF fiber optic rate sensor'),
1296 (18,'AngularRateSinkKalman',17,'AngularRateSink with Kalman filter'),
1297 (19,'AngularRate1Dto3D',18,'An adapter which forms one AngularRateInterface from three AngularRate1DInterface'),
1298 (20,'AngularRate1DSinkKalman',19,'AngularRate1DSink with Kalman filter'),
1299 (21,'VectorVoterAverage',20,'A generic provider which calculates the average of several vector inputs'),
1300 (22,'BiasScaleCorrection',21,'A generic provider which corrects bias and scale factor errors'),
1301 (23,'BiasScaleMisalignmentCorrection',22,'A generic provider which corrects bias, scale factor and misalignment errors'),
1302 (24,'InterruptDriverStm32Ext',23,'Driver for external GPIO interrupts of the STM32F4 series MCU'),
1303 (25,'RodosCommBufferProvider',24,'A state quantity provider with internal RODOS::CommBuffer'),
1304 (26,'ControlCycleStart',25,'A time provider for the beginning of the AOCS control cylce'),
1305 (27,'ControlCycleEnd',26,'A time provider for the end of the AOCS control cylce'),
1306 (28,'Sgp4',27,'SGP4 orbit propagation'),
1307 (29,'Igrf',28,'International Geomagnetic Reference Field (IGRF)'),
1308 (30,'Slpc',29,'Sun low-precision coordinates (SLPC)'),
1309 (31,'EclipseBasic',30,'A basic eclipse model'),
1310 (32,'AppliedTorque',31,'Calculate the applied torque from applied magnetic dipole and reaction wheel angular momentum derivative'),
1311 (33,'Quest',32,'Quaternion estimator: attitude estimation algorithm'),
1312 (34,'AttitudePrediction',33,'Predict the attitude for the end of the control cycle'),
1313 (35,'VectorPrediction',34,'Predict a body-fixed vector for the end of the control cycle'),
1314 (36,'AngularRatePrediction',35,'Predict the body-fixed angular rate for the end of the control cycle'),
1315 (37,'StateDeterminationBasic',36,'State provider to provide a set of all state quantities and perform FDIR checks'),
1316 (38,'StateDeterminationMemory',37,'State provider which stores a set of add state quantities for the next control cycle'),
1317 (39,'StateDeterminationVoter',38,'State provider which votes between different state provider instances'),
1318 (40,'ControlDampingBDot',39,'Damping Mode (DPM) with B-dot control law'),
1319 (41,'ControlDampingCrossProduct',40,'Damping Mode (DPM) with cross-product control law'),
1320 (42,'ControlErrorNadirPointing',41,'Provider to calculate the control error in state space for nadir pointing'),
1321 (43,'ControlErrorTargetPointing',42,'Provider to calculate the control error in state space for target pointing'),
1322 (44,'ControlTorqueDeterminationStateSpace',43,'Provider to calculate the control torque with state space control law'),
1323 (45,'ControlTorqueDeterminationPD',44,'Provider to calculate the control torque with quaternion feedback control law'),
1324 (46,'ControlTorqueDistributionMts',45,'Provider to distribute the control torque on 3 magnetic torquers'),
1325 (47,'ControlTorqueDistributionRws4D',46,'Provider to distribute the control torque on 4 reaction wheels'),
1326 (48,'DesaturationRws4DMts',47,'Provider to desaturate 4 reaction wheels with magnetic torquers');
1327/*!40000 ALTER TABLE `stm_tc_ht_providers` ENABLE KEYS */;
1328UNLOCK TABLES;
1329
1330--
1331-- Table structure for table `stm_tc_switchconfig`
1332--
1333
1334DROP TABLE IF EXISTS `stm_tc_switchconfig`;
1335/*!40101 SET @saved_cs_client = @@character_set_client */;
1336/*!40101 SET character_set_client = utf8 */;
1337CREATE TABLE `stm_tc_switchconfig` (
1338 `keyTCSwitchConfig` int(10) unsigned NOT NULL AUTO_INCREMENT,
1339 `Name` varchar(45) NOT NULL,
1340 `Bit_Num` int(10) unsigned NOT NULL,
1341 `comment` varchar(200) DEFAULT NULL,
1342 PRIMARY KEY (`keyTCSwitchConfig`),
1343 UNIQUE KEY `UNIQUE_Bit_Num` (`Bit_Num`),
1344 UNIQUE KEY `UNIQUE_Name` (`Name`)
1345) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Bitmap of EPS Switches';
1346/*!40101 SET character_set_client = @saved_cs_client */;
1347
1348--
1349-- Dumping data for table `stm_tc_switchconfig`
1350--
1351
1352LOCK TABLES `stm_tc_switchconfig` WRITE;
1353/*!40000 ALTER TABLE `stm_tc_switchconfig` DISABLE KEYS */;
1354/*!40000 ALTER TABLE `stm_tc_switchconfig` ENABLE KEYS */;
1355UNLOCK TABLES;
1356
1357--
1358-- Table structure for table `stm_tm_combination`
1359--
1360
1361DROP TABLE IF EXISTS `stm_tm_combination`;
1362/*!40101 SET @saved_cs_client = @@character_set_client */;
1363/*!40101 SET character_set_client = utf8 */;
1364CREATE TABLE `stm_tm_combination` (
1365 `keyTMCombination` int(10) unsigned NOT NULL AUTO_INCREMENT,
1366 `keyTMSourcePacket` int(10) unsigned NOT NULL,
1367 `keyTMParam` int(10) unsigned NOT NULL,
1368 `keyTMCombinationFormula` int(10) unsigned NOT NULL,
1369 PRIMARY KEY (`keyTMCombination`),
1370 KEY `keyTMParam` (`keyTMParam`),
1371 KEY `keyTMCombinationFormula` (`keyTMCombinationFormula`),
1372 KEY `keyTMSourcePacket` (`keyTMSourcePacket`),
1373 CONSTRAINT `TMCombination_TMCombinationFormula` FOREIGN KEY (`keyTMCombinationFormula`) REFERENCES `stm_tm_combinationformula` (`keyTMCombinationFormula`) ON UPDATE CASCADE,
1374 CONSTRAINT `TMCombination_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE,
1375 CONSTRAINT `TMCombination_TMSourcePacket` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON UPDATE CASCADE
1376) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1377/*!40101 SET character_set_client = @saved_cs_client */;
1378
1379--
1380-- Dumping data for table `stm_tm_combination`
1381--
1382
1383LOCK TABLES `stm_tm_combination` WRITE;
1384/*!40000 ALTER TABLE `stm_tm_combination` DISABLE KEYS */;
1385/*!40000 ALTER TABLE `stm_tm_combination` ENABLE KEYS */;
1386UNLOCK TABLES;
1387
1388--
1389-- Table structure for table `stm_tm_combinationformula`
1390--
1391
1392DROP TABLE IF EXISTS `stm_tm_combinationformula`;
1393/*!40101 SET @saved_cs_client = @@character_set_client */;
1394/*!40101 SET character_set_client = utf8 */;
1395CREATE TABLE `stm_tm_combinationformula` (
1396 `keyTMCombinationFormula` int(10) unsigned NOT NULL AUTO_INCREMENT,
1397 `Formula` varchar(1000) NOT NULL,
1398 PRIMARY KEY (`keyTMCombinationFormula`)
1399) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1400/*!40101 SET character_set_client = @saved_cs_client */;
1401
1402--
1403-- Dumping data for table `stm_tm_combinationformula`
1404--
1405
1406LOCK TABLES `stm_tm_combinationformula` WRITE;
1407/*!40000 ALTER TABLE `stm_tm_combinationformula` DISABLE KEYS */;
1408/*!40000 ALTER TABLE `stm_tm_combinationformula` ENABLE KEYS */;
1409UNLOCK TABLES;
1410
1411--
1412-- Table structure for table `stm_tm_combinationparameter`
1413--
1414
1415DROP TABLE IF EXISTS `stm_tm_combinationparameter`;
1416/*!40101 SET @saved_cs_client = @@character_set_client */;
1417/*!40101 SET character_set_client = utf8 */;
1418CREATE TABLE `stm_tm_combinationparameter` (
1419 `keyTMCombinationFormula` int(10) unsigned NOT NULL,
1420 `keyTMParam` int(10) unsigned NOT NULL,
1421 `ParamOrder` int(10) unsigned NOT NULL,
1422 UNIQUE KEY `UNIQUE` (`keyTMCombinationFormula`,`keyTMParam`,`ParamOrder`),
1423 KEY `keyTMParam` (`keyTMParam`),
1424 KEY `keyTMCombinationFormula` (`keyTMCombinationFormula`),
1425 CONSTRAINT `TMCombinationParameter_TMCombinationFormula` FOREIGN KEY (`keyTMCombinationFormula`) REFERENCES `stm_tm_combinationformula` (`keyTMCombinationFormula`) ON UPDATE CASCADE,
1426 CONSTRAINT `TMCombinationParameter_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON UPDATE CASCADE
1427) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1428/*!40101 SET character_set_client = @saved_cs_client */;
1429
1430--
1431-- Dumping data for table `stm_tm_combinationparameter`
1432--
1433
1434LOCK TABLES `stm_tm_combinationparameter` WRITE;
1435/*!40000 ALTER TABLE `stm_tm_combinationparameter` DISABLE KEYS */;
1436/*!40000 ALTER TABLE `stm_tm_combinationparameter` ENABLE KEYS */;
1437UNLOCK TABLES;
1438
1439--
1440-- Table structure for table `stm_tm_param`
1441--
1442
1443DROP TABLE IF EXISTS `stm_tm_param`;
1444/*!40101 SET @saved_cs_client = @@character_set_client */;
1445/*!40101 SET character_set_client = utf8 */;
1446CREATE TABLE `stm_tm_param` (
1447 `keyTMParam` int(10) unsigned NOT NULL AUTO_INCREMENT,
1448 `keySubSystem` int(10) unsigned NOT NULL,
1449 `keyTMParamConversion` int(10) unsigned NOT NULL,
1450 `Name` varchar(15) NOT NULL,
1451 `Description` varchar(60) NOT NULL,
1452 `ToolTip` varchar(255) DEFAULT NULL,
1453 `Unit` varchar(10) DEFAULT NULL,
1454 `ParamType` enum('Unsigned Int','Signed Int','Float','Boolean','String','Double','Unsigned Int LE','Signed Int LE','Float LE','Double LE') NOT NULL DEFAULT 'Unsigned Int',
1455 `ParamFormat` enum('Parameter','Placeholder','Combination','VcID','ApID','OnBoardTime','ObcUpTime','Image','ErrorMarker') NOT NULL DEFAULT 'Parameter',
1456 `SoftMin` float NOT NULL DEFAULT 0,
1457 `SoftMax` float NOT NULL DEFAULT 0,
1458 `HardMin` float NOT NULL DEFAULT 0,
1459 `HardMax` float NOT NULL DEFAULT 0,
1460 `Interpretation` varchar(3000) DEFAULT NULL,
1461 `DecimalCnt` tinyint(3) unsigned NOT NULL DEFAULT 0,
1462 `BitLength` int(10) unsigned NOT NULL,
1463 `ParamDependency` varchar(20) DEFAULT NULL,
1464 `Resolution` varchar(50) DEFAULT NULL COMMENT '[optional] a value describing the resolution of a TM-Parameter',
1465 PRIMARY KEY (`keyTMParam`),
1466 KEY `keySubSystem` (`keySubSystem`),
1467 KEY `keyTMParamType` (`keyTMParamConversion`),
1468 CONSTRAINT `TMParam_SubSystem` FOREIGN KEY (`keySubSystem`) REFERENCES `stm_tm_subsystem` (`keySubSystem`) ON DELETE NO ACTION ON UPDATE CASCADE,
1469 CONSTRAINT `TMParam_TMParamConversion` FOREIGN KEY (`keyTMParamConversion`) REFERENCES `stm_tm_paramconversion` (`keyTMParamConversion`) ON DELETE NO ACTION ON UPDATE CASCADE
1470) ENGINE=InnoDB AUTO_INCREMENT=800010 DEFAULT CHARSET=latin1 COMMENT='List of TELEMETRY PARAMETER\r\n\r\n[INFO]\r\nLittle Endian Parameter Types\r\n- All "ParameterType" Datatypes marked with "LE" allow TM-Parameter in little endian format. \r\n- Please make shure that ".. Int LE" TM-Parameter have a bitsize with a multiple of 8!\r\n- Please make shure that "Float LE" Parameter have a bitsize of 32 (4 byte)\r\n- Please make shure that "Double LE" Parameter have a bitsize of 64 (8 byte)';
1471/*!40101 SET character_set_client = @saved_cs_client */;
1472
1473--
1474-- Dumping data for table `stm_tm_param`
1475--
1476
1477LOCK TABLES `stm_tm_param` WRITE;
1478/*!40000 ALTER TABLE `stm_tm_param` DISABLE KEYS */;
1479INSERT INTO `stm_tm_param` VALUES
1480 (1,1,1,'res_1_bit','reserved 1 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,1,NULL,NULL),
1481 (2,1,1,'res_2_bit','reserved 2 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,2,NULL,NULL),
1482 (3,1,1,'res_3_bit','reserved 3 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,3,NULL,NULL),
1483 (4,1,1,'res_4_bit','reserved 4 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,4,NULL,NULL),
1484 (5,1,1,'res_5_bit','reserved 5 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,5,NULL,NULL),
1485 (6,1,1,'res_6_bit','reserved 6 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,6,NULL,NULL),
1486 (7,1,1,'res_7_bit','reserved 7 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,7,NULL,NULL),
1487 (8,1,1,'res_1_byte','reserved 1 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,8,NULL,NULL),
1488 (9,1,1,'res_2_byte','reserved 2 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,16,NULL,NULL),
1489 (10,1,1,'res_3_byte','reserved 3 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,24,NULL,NULL),
1490 (11,1,1,'res_4_byte','reserved 4 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,32,NULL,NULL),
1491 (11001,1,1,'MAGSTATE','Magnet status','Indicates whether the magnets are armed or disarmed. If the magnets are armed, supplying 12V to the magnet power domain controlled by the PCDU will trigger the ejection of the paracute.',NULL,'Unsigned Int','Parameter',1,1,1,2,'0=Uninitialized;1=Armed;2=Disarmed',0,8,NULL,NULL),
1492 (17001,1,1,'PFDATM','pFDA telemetry trigger status','Indicates whether automatic synchronous triggering of pFDA telemetry is enabled',NULL,'Unsigned Int','Parameter',0,0,1,1,NULL,0,1,NULL,NULL),
1493 (20001,1,1,'BOTSLT','Boot Slot','currently running internal software slot',NULL,'Unsigned Int','Parameter',0,3,0,7,'0=#0;1=#1;2=#2;3=#3;7=BOOT',0,3,NULL,NULL),
1494 (20003,1,1,'BOTCNT','Boot Count','counts all soft- and hardware triggered reboots and power-ups',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1495 (20004,1,1,'TMPINT','MCU Temperature','internal temperature of node-MCU','°C','Signed Int','Parameter',-10,40,-20,60,NULL,0,8,NULL,NULL),
1496 (20005,1,1,'CNTIMM','Cmd Count: immediate','counts all immediate telecommands for this node',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1497 (20006,1,1,'CNTTTC','Cmd Count: time tagged','counts all timed telecommands for this node',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1498 (20007,1,1,'CNTINT','Cmd Count: internal','counts all internal commands for this node',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1499 (20008,1,1,'CNTEXE','Cmd Count: executed','counts all commands executed by applications on this node',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1500 (20009,1,1,'CNTREJ','Cmd Count: rejected','counts all commands rejected (bad TCC or Parameter) by applications on this node',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1501 (20010,1,1,'LSTCID','last Command Id','ID of the last immediate/timetagged/internal command that was received by applications on this node (executed and rejected)',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1502 (20011,1,81,'MCUCUR','MCU Current','supply current of the node\'s microcontroller','mA','Unsigned Int','Parameter',0,100,0,200,NULL,1,16,NULL,NULL),
1503 (20012,1,1,'RSTSTS','Reset Status','the reset status register contents',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1504 (20013,1,1,'NODENO','Node No.','redundant node number',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,1,NULL,NULL),
1505 (30002,1,1,'RST_EN','WTD Reset Enabled','the watchdog application is enabled to reset the node',NULL,'Boolean','Parameter',0,0,0,0,'0=False;1=True',0,1,NULL,NULL),
1506 (40001,1,1,'TIMLOC','Uptime [local]','current uptime since last reboot','s','Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1507 (40003,1,1,'SYNPPS','PPS Synchronisation','shall the node synchronize with the PPS signal',NULL,'Boolean','Parameter',0,0,0,0,NULL,0,1,NULL,NULL),
1508 (40004,1,1,'DISUTC','UTC Distribution','shall the node distribute the UTC time at the next PPS signal',NULL,'Boolean','Parameter',0,0,0,0,NULL,0,1,NULL,NULL),
1509 (99001,1,1,'CONSUMED_PARTS','Number of parts consumed by the linkinterface','Number of parts consumed by the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1510 (99002,1,1,'IGNORED_PARTS','Number of parts ignored by the linkinterface','Number of parts ignored by the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1511 (99003,1,1,'COMPLETED_FRAME','Number of frames completed by the linkinterface','Number of frames completed by the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1512 (99004,1,1,'TIMEDOUT_FRAMES','Number of frames timed out in the linkinterface','Number of frames timed out in the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1513 (99005,1,1,'DROPPED_FRAMES','Number of frames dropped by the linkinterface','Number of frames dropped by the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1514 (99006,1,1,'USED_ASSEMBLERS','Number of assemblers used by the linkinterface','Number of assemblers used by the linkinterface',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1515 (100001,2,1,'TMMBUSUSD','TMM BUS Used Pages','Used flash pages for bus history tm',NULL,'Unsigned Int','Parameter',0,2000,0,2000,NULL,0,16,NULL,NULL),
1516 (100002,2,1,'TMMPLDUSD','TMM PLD Used Pages','Used flash pages for payload history tm',NULL,'Unsigned Int','Parameter',0,2000,0,2000,NULL,0,16,NULL,NULL),
1517 (100003,2,1,'TMMBUSCNT','TMM BUS SP Count','Current count of bus history sourcepackets in memory',NULL,'Unsigned Int','Parameter',0,32000,0,32000,NULL,0,16,NULL,NULL),
1518 (100004,2,1,'TMMPLDCNT','TMM PLD SP Count','Current count of payload history sourcepackets in memory',NULL,'Unsigned Int','Parameter',0,32000,0,32000,NULL,0,16,NULL,NULL),
1519 (100009,2,1,'TMMBUSFLP','TMM BUS Fill Level','Fill level of the bus history buffer','%','Unsigned Int','Parameter',0,80,0,100,NULL,0,8,NULL,NULL),
1520 (100010,2,1,'TMMPLDFLP','TMM PLD Fill Level','Fill level of the payload history buffer','%','Unsigned Int','Parameter',0,80,0,100,NULL,0,8,NULL,NULL),
1521 (100011,2,1,'TMMBUSLSP','TMM BUS Lost SP','Current Count of bus history sourcepackets lost due to full fifo',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1522 (100012,2,1,'TMMPLDLSP','TMM PLD Lost SP','Current Count of payload history sourcepackets lost due to full fifo',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1523 (100013,2,1,'TMMSTDLSP','TMM StdTM Lost SP','Current Count of standard TM sourcepackets lost due to full fifo',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1524 (100014,2,1,'TMMRTTLSP','TMM RealTime Lost SP','Current Count of real time TM sourcepackets lost due to full fifo',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1525 (100015,2,1,'TMMDIAUSD','TMM DIA Used Pages','Used flash pages for diagnosis history tm',NULL,'Unsigned Int','Parameter',0,2000,0,2000,NULL,0,16,NULL,NULL),
1526 (100016,2,1,'TMMDIACNT','TMM DIA SP Count','Current count of bus history sourcepackets in memory',NULL,'Unsigned Int','Parameter',0,32000,0,32000,NULL,0,16,NULL,NULL),
1527 (100019,2,1,'TMMDIAFLP','TMM DIA Fill Level','Fill level of the diagnosis history buffer','%','Unsigned Int','Parameter',0,80,0,100,NULL,0,8,NULL,NULL),
1528 (100020,2,1,'TMMDIALSP','TMM DIA Lost SP','Current Count of diagnosis history sourcepackets lost due to full fifo',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1529 (100033,2,1,'TMMBUSVOL','TMM BUS DataVolume','total bus history data stored in kByte','kiB','Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1530 (100034,2,1,'TMMPLDVOL','TMM PLD DataVolume','total payload history data stored in kByte','kiB','Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1531 (100035,2,1,'TMMDIAVOL','TMM DIA DataVolume','total diagnosis history data stored in kByte','kiB','Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1532 (102020,1,1,'STRING','a string message',NULL,NULL,'String','Parameter',0,0,0,0,NULL,0,640,NULL,NULL),
1533 (105001,2,1,'SDREADSUCC','SD card read success','Indicates the result of the SD card read command that resulted in the sending of this source packet',NULL,'Boolean','Parameter',1,1,0,1,'0=Faiulre;1=Success',0,1,NULL,NULL),
1534 (105002,2,1,'SDREADCARD','SD card read card id','Indicates the card that was read from',NULL,'Unsigned Int','Parameter',0,1,0,1,NULL,0,1,NULL,NULL),
1535 (105003,2,1,'SDREADBLOCK','SD card read block nr','Indicates the address of the read block',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1536 (105004,2,1,'SDREADDATA','SD card read data','Contains the data that was just read from the SD card','[hex]','String','Parameter',0,0,0,0,NULL,0,4096,NULL,NULL),
1537 (112001,1,1,'SAT_MODE','SAT MODE','the current mode of the satellite',NULL,'Unsigned Int','Parameter',0,3,0,3,'0=SAFE;1=LEOP;2=NOMINAL;',0,2,NULL,NULL),
1538 (115001,8,1,'ANOMLYCNT','ANOMALY COUNT','total count of anomalies registered',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1539 (115002,8,1,'LSTALYID','LAST ANMLY ID','id of the last anomaly registered',NULL,'Signed Int','Parameter',0,33000,0,33000,'0=NO_ANOMALY;1=GLB_BAD_PARAM;2=GLB_BAD_TCC;3=EPS_MAIN_REGULATED_HSC_POWER_BAD;4=EPS_MAIN_UNREGULATED_HSC_POWER_BAD;5=EPS_REGULATED_HSC_POWER_BAD;6=EPS_UNREGULATED_HSC_POWER_BAD;7=WAT_TIMINGERR;8=WAT_WOULD_RESET_NODE;9=WAT_TABLE_OVERFLOW;10=TCM_FREELIST_UNDERFLOW;11=EPS_REMAINING_BATTERY_CAPACITY_LOW;12=TCM_TIME_IN_PAST;13=TCM_TOO_MANY_PARAMS_FOR_TTC;14=TMM_BUS_HIST_FIFO_FULL;15=TMM_PLD_HIST_FIFO_FULL;16=TMM_STD_TM_FIFO_FULL;17=TMM_RT_TM_FIFO_FULL;18=TMM_BUS_HIST_FLASH_FULL;19=TMM_PLD_HIST_FLASH_FULL;20=EPS_PAYLOAD_TIMEOUT;-21=MOD_SAFEMODE_COMMANDED;22=GLB_FIFO_FULL;23=GLB_SYNC_FIFO_FULL;24=DUL_WRONG_CRC;25=TMM_DIA_HIST_FIFO_FULL;26=TMM_DIA_HIST_FLASH_FULL;-27=EPS_REMAINING_BATTERY_CAPACITY_CRITICAL;28=I2C_OVERCURRENT_I2C_SWITCH;29=I2C_OVERCURRENT_I2C_MEASURED;30=CAM_PICTURE_TIMEOUT;31=COM_TMP_ERROR;32=COM_TMP_PERSISTENT_ERROR;33=BOM_BAD_HEADER;34=BOM_BAD_BANK;35=TMM_BUS_HIST_RESET;36=TMM_PLD_HIST_RESET;37=TMM_DIA_HIST_RESET;38=COM_TF_BUSY;39=COM_BEACON_BUSY;40=COM_UNSPECIFIED;41=ACS_MTS_MT_FAULT;42=ACS_MTS_NOT_OPERATIONAL;43=ACS_ISB_SIDE_NOT_OPERATIONAL;44=ACS_ISB_NOT_OPERATIONAL;45=FOR_MUFORS_FAILURE;46=ACS_CORE_INVALID_MODE_TRANSITION;47=ACS_CORE_MODE_DEADLINE_REACHED;48=ACS_CORE_ANGULAR_RATE_LIMIT_EXCEEDED;-49=ACS_RWS_SAFE_MODE;50=ACS_RWS_MTR_OVER_CURR;51=ACS_RWS_MV_LIMIT;52=ACS_RWS_INV_TC_AN;53=ACS_RWS_TIMEOUT_AN;54=ACS_RWS_RESET_AN;55=ACS_RWS_POWER_ANOMALY;56=ACS_RWS_ENVIR_ANOMALY;57=ACS_RWS_NO_RESPONSE;-58=ACS_RWS_FAILURE;59=PDH_CAM_PAYLOAD_TIMEOUT;60=PDH_HSP_PAYLOAD_TIMEOUT;61=EPS_NCTRL_MISSED_IAMALIVE_ONCE;-62=EPS_NCTRL_MISSED_IAMALIVE_TWICE;63=UNEXPECTED_BOOT_AOCS;64=UNEXPECTED_BOOT_FOR;65=DIA_NO_SUCH_SCENARIO;66=DIA_NO_SUCH_TEST;67=UNEXPECTED_BOOT_OBC;68=UNEXPECTED_BOOT_PDH;69=UNEXPECTED_BOOT_SOLID;70=UNEXPECTED_BOOT_COM;71=COM_TRX0_LOST;72=COM_TRX1_LOST;-73=COM_ALL_TRX_LOST;-74=COM_AUTOMATON_LOST;75=ACS_RWS_MAX_MOMENTUM_EXCEEDED;76=COM_TC_ENCODING_ERROR;77=COM_TF_DROPPED;78=EPS_COM_NO_TC_TIMEOUT;79=RES_48;80=RES_49;81=RES_50;82=RES_51;83=EPS_RCTRL_DUAL_WORKER;84=EPS_I2C_POW_OC;85=EPS_I2C_POW_BAD_REINIT;86=EPS_SW_DCDC_OC;87=EPS_SW_DCDC_BAD_REINIT;-88=EPS_MAIN_HSC_OC;-89=EPS_NODE_RWS_HSC_OC;90=DUL_NO_SUDO;91=DUL_SUDO_MODE_ENTERED;92=ACS_RWS_NO_SUDO;93=ACS_RWS_SUDO_MODE_ENTERED;94=RES_54;95=RES_55;96=DUL_FLASH_ERROR;97=DUL_FLASH_CONTROLLER_BUSY;98=CAM_PICTURE_TOO_BIG;99=ANM_BAD_ANOMALY_INDEX',0,16,NULL,NULL),
1540 (115003,8,8,'LSTALYTIM','LAST ANMLY TIME','time of occurence of the last registered anomaly',NULL,'Unsigned Int','OnBoardTime',0,0,0,0,NULL,0,32,NULL,NULL),
1541 (115004,8,1,'LSTALYNOD','LAST ANMLY NODE','node throwing the last anomaly registered',NULL,'Unsigned Int','Parameter',0,0,0,0,'0=EPS #0;1=EPS #1;2=COM #0;3=COM #1;4=OBC #0;5=OBC #1;6=AOCS #0;7=AOCS #1;8=FOR #0;9=FOR #1;10=PDH #0;11=PDH #1;12=SOLID #0;13=SOLID #1;14=FDA #0;15=FDA #1;16=RW #0;18=RW #1; 20=RW #2;22=RW#3;30=SIM #0;31=SIM #1; 32=TESTBED #0;33=TESTBED #1;255=/',0,8,NULL,NULL),
1542 (120001,1,1,'EPS20VVOL','EPS 20V Bus Voltage','Indicates the voltage read from the main ~20V Supply from the batteries','mV','Signed Int','Parameter',19750,20250,18000,22000,NULL,1,16,NULL,NULL),
1543 (120002,1,81,'EPS20VCUR','EPS 20V Current draw','Indicates the current drawn from the main ~20V Supply from the batteries','mA','Signed Int','Parameter',0,50,0,75,NULL,1,16,NULL,NULL),
1544 (120003,1,1,'EPS3V3VOL','EPS 3.3V Bus Voltage','Indicates teh voltage read from the 3.3V Supply','mV','Signed Int','Parameter',3150,3450,3000,3600,NULL,1,16,NULL,NULL),
1545 (120004,1,81,'EPS3V3CUR','EPS 3.3V Current draw','Indiates the current drawn from the 3.3V Supply','mA','Signed Int','Parameter',0,300,0,600,NULL,1,16,NULL,NULL),
1546 (120005,1,1,'EPS05VVOL','EPS 5V Bus Voltage','Indiate the voltage read from the 5V Supply','mV','Signed Int','Parameter',4750,5250,4500,5500,NULL,1,16,NULL,NULL),
1547 (120006,1,81,'EPS05VCUR','EPS 5V Current draw','Indicates the current drawn from the 5V Supply','mA','Signed Int','Parameter',0,40,0,60,NULL,1,16,NULL,NULL),
1548 (120007,1,1,'EPS12VVOL','EPS 12V Bus Voltage','EPS 12V Bus Voltage','mV','Signed Int','Parameter',11750,12250,11000,12000,NULL,1,16,NULL,NULL),
1549 (120008,1,81,'EPS12VCUR','EPS 12V Current draw','EPS 12V Current draw','mA','Signed Int','Parameter',0,100,0,200,NULL,1,16,NULL,''),
1550 (120009,1,1,'EPSPFDAEN','EPS PFDA Power switch enable','Indicates whether the pFDA 3.3V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1551 (120010,1,1,'EPSPCDHEN','EPS PCDH Power switch enable','Indicates whether the PCDH 3.3V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1552 (120011,1,1,'EPSAPRSEN','EPS APRS Power switch enable','Indicates whether the APRS 3.3/5V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1553 (120012,1,1,'EPSSTINGREN','EPS STINGR Power switch enable','Indicates whether the STINGR 5V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1554 (120013,1,1,'EPSPFDA1EN','EPS PFDA1 Power switch enable','Indicates whether the pFDA1 12V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1555 (120014,1,1,'EPSPFDA2EN','EPS PFDA2 Power switch enable','Indicates whether the pFDA2 12V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1556 (120015,1,1,'EPSPFDA3EN','EPS PFDA3 Power switch enable','Indicates whether the pFDA3 12V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1557 (120016,1,1,'EPSPFDA4EN','EPS PFDA4 Power switch enable','Indicates whether the pFDA4 12V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1558 (120017,1,1,'EPSMAGNETEN','EPS Magnet Power switch enable','Indicates whether the Magnet 12V power switch is active',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1559 (120018,1,1,'EPSPFDAFLAG','EPS PFDA Power switch fault status','Indicates whether the pFDA 3.3V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1560 (120019,1,1,'EPSPCDHFLAG','EPS PCDH Power switch fault status','Indicates whether the PCDH 3.3V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1561 (120020,1,1,'EPSAPRSFLAG','EPS APRS Power switch fault status','Indicates whether the APRS 3.3/5V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1562 (120021,1,1,'EPSSTINGRFLAG','EPS STINGR Power switch fault status','Indicates whether the STINGR 5V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1563 (120022,1,1,'EPSPFDA1FLAG','EPS PFDA1 Power switch fault status','Indicates whether the pFDA1 12V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1564 (120023,1,1,'EPSPFDA2FLAG','EPS PFDA2 Power switch fault status','Indicates whether the pFDA2 12V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1565 (120024,1,1,'EPSPFDA3FLAG','EPS PFDA3 Power switch fault statu','Indicates whether the pFDA3 12V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1566 (120025,1,1,'EPSPFDA4FLAG','EPS PFDA4 Power switch fault status','Indicates whether the pFDA4 12V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1567 (120026,1,1,'EPSMAGNETFLAG','EPS Magnet Power switch fault status','Indicates whether the Magnet 12V power switch currently signals an error',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1568 (120027,1,1,'EPSPFDAFCNT','EPS PFDA Power switch fault count','Indicates how often the pFDA 3.3V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1569 (120028,1,1,'EPSPCDHFCNT','EPS PCDH Power switch fault count','Indicates how often the PCDH 3.3V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1570 (120029,1,1,'EPSAPRSFCNT','EPS APRS Power switch fault count','Indicates how often the APRS 3.3/5V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1571 (120030,1,1,'EPSSTINGRFCNT','EPS STINGR Power switch fault count','Indicates how often the STINGR 5V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1572 (120031,1,1,'EPSPFDA1FCNT','EPS PFDA1 Power switch fault count','Indicates how often the pFDA1 12V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1573 (120032,1,1,'EPSPFDA2FCNT','EPS PFDA2 Power switch fault count','Indicates how often the pFDA2 12V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1574 (120033,1,1,'EPSPFDA3FCNT','EPS PFDA3 Power switch fault statu','Indicates how often the pFDA3 12V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1575 (120034,1,1,'EPSPFDA4FCNT','EPS PFDA4 Power switch fault count','Indicates how often the pFDA4 12V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1576 (120035,1,1,'EPSMAGNETFCNT','EPS Magnet Power switch fault count','Indicates how often the Magnet 12V power switch reported an error',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1577 (120036,1,1,'EPSPFDAFTIME','EPS PFDA Power switch last fault time','Indicates the last time the pFDA 3.3V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1578 (120037,1,1,'EPSPCDHFTIME','EPS PCDH Power switch last fault time','Indicates the last time the PCDH 3.3V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1579 (120038,1,1,'EPSAPRSFTIME','EPS APRS Power switch last fault time','Indicates the last time the APRS 3.3/5V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1580 (120039,1,1,'EPSSTINGRFTIME','EPS STINGR Power switch last fault time','Indicates the last time the STINGR 5V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1581 (120040,1,1,'EPSPFDA1FTIME','EPS PFDA1 Power switch last fault time','Indicates the last time the pFDA1 12V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1582 (120041,1,1,'EPSPFDA2FTIME','EPS PFDA2 Power switch last fault time','Indicates the last time the pFDA2 12V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1583 (120042,1,1,'EPSPFDA3FTIME','EPS PFDA3 Power switch fault statu','Indicates the last time the pFDA3 12V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1584 (120043,1,1,'EPSPFDA4FTIME','EPS PFDA4 Power switch last fault time','Indicates the last time the pFDA4 12V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1585 (120044,1,1,'EPSMAGNETFTIME','EPS Magnet Power switch last fault time','Indicates the last time the Magnet 12V power switch reported an error',NULL,'Signed Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1586 (120045,1,1,'EPS5VEN','EPS 5V enable','Indicates whether the 5V DCDC converter is enabled',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1587 (120046,1,1,'EPS12VEN','EPS 12V enable','Indicates whether 12V DCDC converter is enabled',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1588 (120047,1,82,'BAT1TEMP','Battery 1 temperature','Indicates the temperature determined from battery thermistor 1','°C','Signed Int','Parameter',10,30,0,50,NULL,2,16,NULL,NULL),
1589 (120048,1,82,'BAT2TEMP','Battery 2 temperature','Indicates the temperature determined from battery thermistor 2','°C','Signed Int','Parameter',10,30,0,50,NULL,2,16,NULL,NULL),
1590 (130001,1,1,'VDDVOL','Logic input voltage','The voltage read across the pFDAs 3.3V input','mV','Signed Int','Parameter',3200,3400,3000,3600,NULL,0,16,NULL,NULL),
1591 (130002,1,81,'VDDCUR','Logic input current','The current drawn from the pFDAs 3.3V input','mA','Signed Int','Parameter',20,100,10,150,NULL,1,16,NULL,NULL),
1592 (130003,1,1,'VPVOL','VP Voltage','The Voltage that is read by the VP sensor (whatever that means)','mV','Signed Int','Parameter',0,24000,0,24000,NULL,0,16,NULL,NULL),
1593 (130004,1,81,'VPCUR','VP Current','The Current that is read by the VP sensor (whatever that means)','mA','Signed Int','Parameter',0,2000,0,2000,NULL,1,16,NULL,NULL),
1594 (130005,1,1,'IMUGYROX','IMU X Rotation rate','The rate of rotation around the X axis read from the IMU','rad/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1595 (130006,1,1,'IMUGYROY','IMU Y Rotation rate','The rate of rotation around the Y axis read from the IMU','rad/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1596 (130007,1,1,'IMUGYROZ','IMU Z Rotation rate','The rate of rotation around the Z axis read from the IMU','rad/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1597 (130008,1,1,'IMUACCX','IMU X acceleration','The acceleration in the X axis read from the IMU','m/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1598 (130009,1,1,'IMUACCY','IMU Y acceleration','The acceleration in the Y axis read from the IMU','m/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1599 (130010,1,1,'IMUACCZ','IMU Z acceleration','The acceleration in the Z axis read from the IMU','m/s','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,16,NULL,NULL),
1600 (130011,1,1,'IMUTEMP','IMU Temperature','The temperature read from the IMUs temperature sensor','°C','Signed Int','Parameter',-0.3,0.3,-1,1,NULL,0,8,NULL,NULL),
1601 (130012,1,1,'PUMPEN','Pump enabled','Indicates whether the pFDA pump is currently active','','Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1602 (130013,1,1,'PUMPFREQ','Pump frequency','The frequency at which the pFDA pump runs at','Hz','Unsigned Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1603 (130014,1,1,'PUMPSPD','Pump speed','The speed at which the pFDA pump runs at','%','Signed Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1604 (130015,1,1,'ICGGYROX','ICG X Rotation rate','The rotation rate around the X axis read from the ICG gyroscope','deg/s','Signed Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1605 (130016,1,1,'ICGGYROY','ICG Y Rotation rate','The rotation rate around the Y axis read from the ICG gyroscope','deg/s','Signed Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1606 (130017,1,1,'ICGGYROZ','ICG Z Rotation rate','The rotation rate around the Z axis read from the ICG gyroscope','deg/s','Signed Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1607 (130018,1,1,'LMR64010SHDN','Pump voltage regulator shutdown','Whether the LMR64010 that regulates the pump voltage is currentl shut down',NULL,'Boolean','Parameter',0,0,0,0,'1=Shutdown;0=Enabled',0,1,NULL,NULL),
1608 (130019,1,1,'SNDPMPVOL','Secondary pump voltage','The voltage over the pump that was read from the ADS1115','mV','Signed Int','Parameter',0,0,0,0,NULL,0,16,NULL,NULL),
1609 (190001,1,1,'PARTID','Part ID','Part ID the HealthTree is created from',NULL,'Unsigned Int','Parameter',0,0,0,0,'',0,16,'',NULL),
1610 (190002,1,1,'HEALTHTREE','Raw HealthTree','Raw HealthTree','[hex]','String','Parameter',0,0,0,0,'',0,2040,'',NULL),
1611 (200001,2,1,'SD1CURFAIL','SD card 1 current failure count','The current number of recorded write failures since the last reset for sd card 1',NULL,'Unsigned Int','Parameter',0,0,0,3,NULL,0,32,NULL,NULL),
1612 (200002,2,1,'SD2CURFAIL','SD card 2 current failure count','The current number of recorded write failures since the last reset for sd card 2',NULL,'Unsigned Int','Parameter',0,0,0,3,NULL,0,32,NULL,NULL),
1613 (200003,2,1,'SD1TOTFAIL','SD card 1 total failure count','The total number of recorded write failures since boot for sd card 1',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1614 (200004,2,1,'SD2TOTFAIL','SD card 2 total failure count','The total number of recorded write failures since boot for sd card 2',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1615 (200005,2,1,'SD1SUCRESET','SD card 1 successful reset count','The number of successful resets of sd card 1',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1616 (200006,2,1,'SD2SUCRESET','SD card 2 successful reset count','The number of successful resets of sd card 2',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1617 (200007,2,1,'SD1FAILRESET','SD card 1 failed reset count','The number of failed resets of sd card 1',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1618 (200008,2,1,'SD2FAILRESET','SD card 2 failed reset count','The number of failed resets of sd card 2',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1619 (200009,2,1,'SD1LASTFAIL','SD card 1 last recorded failure time','The last time at which a write to sd card 1 failed',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1620 (200010,2,1,'SD2LASTFAIL','SD card 2 last recorded failure time','The last time at which a write to sd card 2 failed',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1621 (200011,2,1,'SD1LASTRESET','SD card 1 last reset attempt time','The last time at which a reset of sd card 1 was attempted',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1622 (200012,2,1,'SD2LASTRESET','SD card 2 last reset attempt time','The last time at which a reset of sd card 2 was attempted',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL),
1623 (200013,2,1,'SD1STATE','SD card 1 status','The current reset status of sd card 1',NULL,'Unsigned Int','Parameter',0,0,0,0,'0=Off;1=Initializing;2=WaitForRetry;3=Operational',0,8,NULL,NULL),
1624 (200014,2,1,'SD2STATE','SD card 2 status','The current reset status of sd card 2',NULL,'Unsigned Int','Parameter',0,0,0,0,'0=Off;1=Initializing;2=WaitForRetry;3=Operational',0,8,NULL,NULL),
1625 (200015,2,1,'WRITEPROT','SD card write protection','Indicates if writing telemetry to the sd cards is currently enabled',NULL,'Boolean','Parameter',0,0,0,0,'0=Writing enabled;1=Writing disabled',0,1,NULL,NULL),
1626 (200016,1,1,'NEXTTCID','ID of next TC','ID of next TC',NULL,'Signed Int','Parameter',0,0,0,0,'-1=N/A',0,8,NULL,NULL),
1627 (200017,1,81,'TIMENEXTTC','Time until next tc is send','Time until next tc is send','s','Signed Int','Parameter',0,0,0,0,'-0.1=N/A',1,16,NULL,NULL),
1628 (700003,1,1,'DULBSY','DUL Flash Busy','Indicates the state of the UploadManagers Flash Controller','','Boolean','Parameter',0,0,0,0,'0=Idle;1=Busy',0,1,'',''),
1629 (800001,1,1,'SODS','Start of Data Storage','Start of Data Storage',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=NotActive',0,1,NULL,NULL),
1630 (800002,1,1,'SOE','Start of experiment','Start of experiment',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=NotActive',0,1,NULL,NULL),
1631 (800003,1,1,'SAFE_MODE','Rocketsignals safe mode','Indicates whether the rocketsignal polling application is in safe mode wherein rocket signals are logged but not passed to the rest of the system',NULL,'Boolean','Parameter',0,1,0,1,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1632 (800004,1,1,'RBE20VVOL','RBE 20V Bus voltage','Indicates the voltage read on the 20V supply to the FFU','mV','Signed Int','Parameter',19000,21000,18000,22000,NULL,0,16,NULL,NULL),
1633 (800005,1,81,'RBE20VCUR','RBE 20V Current draw','Indicates the current drawn by the FFU on the 20V supply line','mA','Signed Int','Parameter',0,300,0,1000,NULL,1,16,NULL,NULL),
1634 (800006,1,1,'RBE20VEN','RBE 20V Switch enable','Indicates whether or not the 20V switch on the RBE can provide current to the FFU',NULL,'Boolean','Parameter',0,0,0,0,'0=Disabled;1=Enabled',0,1,NULL,NULL),
1635 (800007,1,1,'RBE20VFLAG','RBE 20V fault status','Indicates if the 20V switch shut off due to an overcurrent condition',NULL,'Boolean','Parameter',0,0,0,0,'0=Active;1=Inactive',0,1,NULL,NULL),
1636 (800008,1,1,'RBE20VFCNT','RBE 20V fault count','Indicates the number of times the 20V switch shut off due to an overcurrent condition',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,8,NULL,NULL),
1637 (800009,1,1,'RBE20VFTIME','RBE 20V last fault time','Indicates the last time the 20V switch shut down due to an overcurrent condition',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,64,NULL,NULL);
1638/*!40000 ALTER TABLE `stm_tm_param` ENABLE KEYS */;
1639UNLOCK TABLES;
1640
1641--
1642-- Table structure for table `stm_tm_param2sourcepacket`
1643--
1644
1645DROP TABLE IF EXISTS `stm_tm_param2sourcepacket`;
1646/*!40101 SET @saved_cs_client = @@character_set_client */;
1647/*!40101 SET character_set_client = utf8 */;
1648CREATE TABLE `stm_tm_param2sourcepacket` (
1649 `keyTMParam2SourcePacket` int(10) unsigned NOT NULL COMMENT 'rule for keys [xxx yyy zzz]: xxx = AppID; yyy = SourcePacketID; zzz = counter',
1650 `keyTMSourcePacket` int(10) unsigned NOT NULL,
1651 `keyTMParam` int(10) unsigned NOT NULL,
1652 `ParamOrder` int(10) unsigned NOT NULL,
1653 PRIMARY KEY (`keyTMParam2SourcePacket`),
1654 UNIQUE KEY `UNIQUE_sourcepacket2paramorder_combination` (`keyTMSourcePacket`,`ParamOrder`),
1655 KEY `TMSourcePacket_TMApid` (`keyTMSourcePacket`),
1656 KEY `TMSourcePacket_TMParam` (`keyTMParam`),
1657 CONSTRAINT `TMSourcePacket_TMApid` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON DELETE CASCADE ON UPDATE CASCADE,
1658 CONSTRAINT `TMSourcePacket_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE
1659) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Map TELEMETRY PARAMETER to SOURCE PACKETS';
1660/*!40101 SET character_set_client = @saved_cs_client */;
1661
1662--
1663-- Dumping data for table `stm_tm_param2sourcepacket`
1664--
1665
1666LOCK TABLES `stm_tm_param2sourcepacket` WRITE;
1667/*!40000 ALTER TABLE `stm_tm_param2sourcepacket` DISABLE KEYS */;
1668INSERT INTO `stm_tm_param2sourcepacket` VALUES
1669 (100001,10,20013,1),
1670 (100002,10,30002,2),
1671 (100003,10,20001,3),
1672 (100004,10,40003,4),
1673 (100005,10,40004,5),
1674 (100006,10,700003,6),
1675 (100010,10,800001,10),
1676 (100011,10,800002,11),
1677 (100012,10,800003,12),
1678 (100013,10,800006,13),
1679 (100014,10,800007,14),
1680 (100015,10,3,15),
1681 (100016,10,800004,16),
1682 (100017,10,800005,17),
1683 (100018,10,800008,18),
1684 (100019,10,800009,19),
1685 (105001,105,105001,1),
1686 (105002,105,105002,2),
1687 (105003,105,6,3),
1688 (105009,105,105003,9),
1689 (105010,105,105004,10),
1690 (110001,11,20013,1),
1691 (110002,11,30002,2),
1692 (110003,11,20001,3),
1693 (110004,11,40003,4),
1694 (110005,11,40004,5),
1695 (110006,11,700003,6),
1696 (110010,11,200001,10),
1697 (110011,11,200002,11),
1698 (110012,11,200003,12),
1699 (110013,11,200004,13),
1700 (110014,11,200005,14),
1701 (110015,11,200006,15),
1702 (110016,11,200007,16),
1703 (110017,11,200008,17),
1704 (110018,11,200009,18),
1705 (110019,11,200010,19),
1706 (110020,11,200011,20),
1707 (110021,11,200012,21),
1708 (110022,11,200013,22),
1709 (110023,11,200014,23),
1710 (110024,11,11001,24),
1711 (110025,11,200016,25),
1712 (110026,11,200017,26),
1713 (110027,11,17001,27),
1714 (110028,11,200015,28),
1715 (110029,11,6,29),
1716 (110035,11,100001,35),
1717 (110036,11,100002,36),
1718 (110037,11,100015,37),
1719 (110038,11,100003,38),
1720 (110039,11,100004,39),
1721 (110040,11,100016,40),
1722 (110041,11,100009,41),
1723 (110042,11,100010,42),
1724 (110043,11,100019,43),
1725 (110044,11,100011,44),
1726 (110045,11,100012,45),
1727 (110046,11,100020,46),
1728 (110047,11,100013,47),
1729 (110048,11,100014,48),
1730 (110049,11,100033,49),
1731 (110050,11,100034,50),
1732 (110051,11,100035,51),
1733 (120001,12,20013,1),
1734 (120002,12,30002,2),
1735 (120003,12,20001,3),
1736 (120004,12,40003,4),
1737 (120005,12,40004,5),
1738 (120006,12,700003,6),
1739 (120010,12,120001,10),
1740 (120011,12,120002,11),
1741 (120012,12,120003,12),
1742 (120013,12,120004,13),
1743 (120014,12,120005,14),
1744 (120015,12,120006,15),
1745 (120016,12,120007,16),
1746 (120017,12,120008,17),
1747 (120018,12,120009,18),
1748 (120019,12,120010,19),
1749 (120020,12,120011,20),
1750 (120021,12,120012,21),
1751 (120022,12,120013,22),
1752 (120023,12,120014,23),
1753 (120024,12,120015,24),
1754 (120025,12,120016,25),
1755 (120026,12,120017,26),
1756 (120027,12,120018,27),
1757 (120028,12,120019,28),
1758 (120029,12,120020,29),
1759 (120030,12,120021,30),
1760 (120031,12,120022,31),
1761 (120032,12,120023,32),
1762 (120033,12,120024,33),
1763 (120034,12,120025,34),
1764 (120035,12,120026,35),
1765 (120036,12,120045,36),
1766 (120037,12,120046,37),
1767 (120038,12,4,38),
1768 (120042,12,120027,42),
1769 (120043,12,120028,43),
1770 (120044,12,120029,44),
1771 (120045,12,120030,45),
1772 (120046,12,120031,46),
1773 (120047,12,120032,47),
1774 (120048,12,120033,48),
1775 (120049,12,120034,49),
1776 (120050,12,120035,50),
1777 (120051,12,120036,51),
1778 (120052,12,120037,52),
1779 (120053,12,120038,53),
1780 (120054,12,120039,54),
1781 (120055,12,120040,55),
1782 (120056,12,120041,56),
1783 (120057,12,120042,57),
1784 (120058,12,120043,58),
1785 (120059,12,120044,59),
1786 (120060,12,120047,60),
1787 (120061,12,120048,61),
1788 (130001,13,20013,1),
1789 (130002,13,30002,2),
1790 (130003,13,20001,3),
1791 (130004,13,40003,4),
1792 (130005,13,40004,5),
1793 (130006,13,700003,6),
1794 (130010,13,130001,10),
1795 (130011,13,130002,11),
1796 (130012,13,130003,12),
1797 (130013,13,130004,13),
1798 (130014,13,130005,14),
1799 (130015,13,130006,15),
1800 (130016,13,130007,16),
1801 (130017,13,130008,17),
1802 (130018,13,130009,18),
1803 (130019,13,130010,19),
1804 (130020,13,130011,20),
1805 (130021,13,130012,21),
1806 (130022,13,130018,22),
1807 (130023,13,6,23),
1808 (130029,13,130013,29),
1809 (130030,13,130014,30),
1810 (130031,13,130015,31),
1811 (130032,13,130016,32),
1812 (130033,13,130017,33),
1813 (130034,13,130019,34),
1814 (990001,99,99001,1),
1815 (990002,99,99002,2),
1816 (990003,99,99003,3),
1817 (990004,99,99004,4),
1818 (990005,99,99005,5),
1819 (990006,99,99006,6),
1820 (1180001,118,20005,1),
1821 (1180002,118,20006,2),
1822 (1180003,118,20007,3),
1823 (1180004,118,20008,4),
1824 (1180005,118,20009,5),
1825 (1180006,118,20010,6),
1826 (1180007,118,20011,7),
1827 (1180008,118,20012,8),
1828 (1180009,118,20003,9),
1829 (1180010,118,40001,10),
1830 (1180011,118,20004,11),
1831 (1900001,190,190001,1),
1832 (1900002,190,190002,2),
1833 (102114001,114,102020,1);
1834/*!40000 ALTER TABLE `stm_tm_param2sourcepacket` ENABLE KEYS */;
1835UNLOCK TABLES;
1836
1837--
1838-- Table structure for table `stm_tm_paramconversion`
1839--
1840
1841DROP TABLE IF EXISTS `stm_tm_paramconversion`;
1842/*!40101 SET @saved_cs_client = @@character_set_client */;
1843/*!40101 SET character_set_client = utf8 */;
1844CREATE TABLE `stm_tm_paramconversion` (
1845 `keyTMParamConversion` int(10) unsigned NOT NULL AUTO_INCREMENT,
1846 `TypeName` varchar(20) NOT NULL,
1847 `PhysicalConversion` text DEFAULT NULL,
1848 `Numerator` text DEFAULT NULL,
1849 `Denominator` text DEFAULT NULL,
1850 PRIMARY KEY (`keyTMParamConversion`)
1851) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 COMMENT='Table of CONVERSION FORMULAE for TELEMETRY PARAMETER';
1852/*!40101 SET character_set_client = @saved_cs_client */;
1853
1854--
1855-- Dumping data for table `stm_tm_paramconversion`
1856--
1857
1858LOCK TABLES `stm_tm_paramconversion` WRITE;
1859/*!40000 ALTER TABLE `stm_tm_paramconversion` DISABLE KEYS */;
1860INSERT INTO `stm_tm_paramconversion` VALUES
1861 (1,'none','1',NULL,NULL),
1862 (8,'TimeStampToDate','function pad(a) {\r\n if (a < 10)\r\n return \"0\" + a;\r\n else\r\n return a;\r\n}\r\n\r\nvar d = new Date(946684800000 + V * 1000); \r\nd.getUTCFullYear() + \"-\" + pad(d.getUTCMonth() + 1) + \"-\" + pad(d.getUTCDate()) + \" \" + pad(d.getUTCHours()) + \":\" + pad(d.getUTCMinutes()) + \":\" + pad(d.getUTCSeconds());',NULL,NULL),
1863 (81,'Div by 10','0.1',NULL,NULL),
1864 (82,'Div by 100','0.01',NULL,NULL);
1865/*!40000 ALTER TABLE `stm_tm_paramconversion` ENABLE KEYS */;
1866UNLOCK TABLES;
1867
1868--
1869-- Table structure for table `stm_tm_sourcepackets`
1870--
1871
1872DROP TABLE IF EXISTS `stm_tm_sourcepackets`;
1873/*!40101 SET @saved_cs_client = @@character_set_client */;
1874/*!40101 SET character_set_client = utf8 */;
1875CREATE TABLE `stm_tm_sourcepackets` (
1876 `keyTMSourcePacket` int(10) unsigned NOT NULL AUTO_INCREMENT,
1877 `keyApplication` int(10) unsigned NOT NULL,
1878 `Number` int(10) unsigned NOT NULL,
1879 `HeaderNumber` int(10) unsigned DEFAULT NULL,
1880 `Name` varchar(40) NOT NULL,
1881 `SaveApidHead` tinyint(1) unsigned NOT NULL DEFAULT 0,
1882 `ExtHkEnabled` tinyint(1) unsigned NOT NULL DEFAULT 0,
1883 PRIMARY KEY (`keyTMSourcePacket`),
1884 UNIQUE KEY `SPNumber` (`Number`),
1885 KEY `TMAPID_keyApp_idx` (`keyApplication`),
1886 CONSTRAINT `TMAPID_keyApp` FOREIGN KEY (`keyApplication`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE
1887) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=latin1 COMMENT='List of SOURCE PACKETS';
1888/*!40101 SET character_set_client = @saved_cs_client */;
1889
1890--
1891-- Dumping data for table `stm_tm_sourcepackets`
1892--
1893
1894LOCK TABLES `stm_tm_sourcepackets` WRITE;
1895/*!40000 ALTER TABLE `stm_tm_sourcepackets` DISABLE KEYS */;
1896INSERT INTO `stm_tm_sourcepackets` VALUES
1897 (10,902,10,NULL,'StdTmRBE',0,1),
1898 (11,901,11,NULL,'StdTmOBC',0,1),
1899 (12,903,12,NULL,'StdTmEPS',0,1),
1900 (13,904,13,NULL,'StdTmPFDA',0,1),
1901 (99,1,99,NULL,'TMGateway',0,1),
1902 (105,10,105,NULL,'SDBlock',0,0),
1903 (114,1,114,NULL,'ExTmString',0,0),
1904 (118,2,118,NULL,'NodeInfos',0,1),
1905 (190,1,190,NULL,'TmHealthTree',0,0);
1906/*!40000 ALTER TABLE `stm_tm_sourcepackets` ENABLE KEYS */;
1907UNLOCK TABLES;
1908
1909--
1910-- Table structure for table `stm_tm_subsystem`
1911--
1912
1913DROP TABLE IF EXISTS `stm_tm_subsystem`;
1914/*!40101 SET @saved_cs_client = @@character_set_client */;
1915/*!40101 SET character_set_client = utf8 */;
1916CREATE TABLE `stm_tm_subsystem` (
1917 `keySubSystem` int(10) unsigned NOT NULL AUTO_INCREMENT,
1918 `Name` varchar(10) NOT NULL,
1919 `Description` varchar(60) NOT NULL,
1920 PRIMARY KEY (`keySubSystem`)
1921) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COMMENT='List of Sub-System categories';
1922/*!40101 SET character_set_client = @saved_cs_client */;
1923
1924--
1925-- Dumping data for table `stm_tm_subsystem`
1926--
1927
1928LOCK TABLES `stm_tm_subsystem` WRITE;
1929/*!40000 ALTER TABLE `stm_tm_subsystem` DISABLE KEYS */;
1930INSERT INTO `stm_tm_subsystem` VALUES
1931 (1,'other','no specific sub system'),
1932 (2,'OBDH','On Board Data Handling'),
1933 (8,'ALY','Anomaly Reporting System');
1934/*!40000 ALTER TABLE `stm_tm_subsystem` ENABLE KEYS */;
1935UNLOCK TABLES;
1936
1937--
1938-- Table structure for table `stm_tm_virtualchannel`
1939--
1940
1941DROP TABLE IF EXISTS `stm_tm_virtualchannel`;
1942/*!40101 SET @saved_cs_client = @@character_set_client */;
1943/*!40101 SET character_set_client = utf8 */;
1944CREATE TABLE `stm_tm_virtualchannel` (
1945 `keyTMVirtualChannel` int(10) unsigned NOT NULL AUTO_INCREMENT,
1946 `Number` int(10) unsigned NOT NULL,
1947 `Name` varchar(20) NOT NULL,
1948 `isRealTime` tinyint(1) unsigned NOT NULL DEFAULT 0,
1949 `isPadding` tinyint(1) unsigned NOT NULL DEFAULT 0,
1950 PRIMARY KEY (`keyTMVirtualChannel`),
1951 UNIQUE KEY `TMVCNumber` (`Number`)
1952) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1 COMMENT='List of VIRTUAL CHANNELS';
1953/*!40101 SET character_set_client = @saved_cs_client */;
1954
1955--
1956-- Dumping data for table `stm_tm_virtualchannel`
1957--
1958
1959LOCK TABLES `stm_tm_virtualchannel` WRITE;
1960/*!40000 ALTER TABLE `stm_tm_virtualchannel` DISABLE KEYS */;
1961INSERT INTO `stm_tm_virtualchannel` VALUES
1962 (1,0,'REAL_TIME',1,0),
1963 (2,1,'BUS_HISTORY',0,0),
1964 (3,2,'PAYLOAD_HISTORY',0,0),
1965 (4,3,'DIAGNOSIS_HISTORY',1,0),
1966 (5,4,'PICTURE_DATA',1,0),
1967 (6,15,'PADDING',0,1),
1968 (999,999,'UNDEFINED',0,0);
1969/*!40000 ALTER TABLE `stm_tm_virtualchannel` ENABLE KEYS */;
1970UNLOCK TABLES;
1971
1972--
1973-- Table structure for table `stm_topics`
1974--
1975
1976DROP TABLE IF EXISTS `stm_topics`;
1977/*!40101 SET @saved_cs_client = @@character_set_client */;
1978/*!40101 SET character_set_client = utf8 */;
1979CREATE TABLE `stm_topics` (
1980 `keyTopics` int(11) unsigned NOT NULL,
1981 `Name` varchar(50) NOT NULL,
1982 `ID` smallint(5) unsigned NOT NULL,
1983 `Comment` varchar(100) NOT NULL,
1984 PRIMARY KEY (`keyTopics`),
1985 UNIQUE KEY `UNIQUE_ID` (`ID`)
1986) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of TOPICS';
1987/*!40101 SET character_set_client = @saved_cs_client */;
1988
1989--
1990-- Dumping data for table `stm_topics`
1991--
1992
1993LOCK TABLES `stm_topics` WRITE;
1994/*!40000 ALTER TABLE `stm_topics` DISABLE KEYS */;
1995INSERT INTO `stm_topics` VALUES
1996 (1,'Commands',1012,'Topic to deliver commands to applications'),
1997 (2,'InternalCommands',1013,'Topic for Telecommands published inside the Bus'),
1998 (3,'IAmAlive',1014,'Node-internal alive Topic'),
1999 (4,'AnomalyReport',1003,'Topic for Anomaly reporting'),
2000 (5,'TMBusHist',1008,'Topic for historical Bus Telemetry reporting'),
2001 (6,'TMPayloadHist',1009,'Topic for historical Payload Telemetry reporting'),
2002 (7,'TMRealTime',1007,'Topic for Real Time Telemetry reporting'),
2003 (8,'TMStandard',1015,'Topic for Standard Telemetry reporting'),
2004 (9,'StandardHKRequest',1016,'Topic to request delivery of Standard Telemetry'),
2005 (10,'RequestTransferFrame',1017,'Topic to request delivery of a Transfer Frame for Downlink'),
2006 (11,'IAmAlivePCU',1000,'System-wide alive Topic'),
2007 (12,'PpsInterrupt',1011,'Local Topic to handle PPS interrupts'),
2008 (13,'TimeSyncForNextPPS',1004,'Topic to deliver new Time to be set upon next PPS-Signal'),
2009 (14,'BootMsgToEgse',1010,'EGSE-Topic to deliver info message upon boot'),
2010 (15,'DownLinkChannel',1005,'Topic to deliver Transfer Frames for radio transmission'),
2011 (18,'GroundTelecommands',1001,'Topic for incoming Telecommands on radio link'),
2012 (19,'TimedCommands',1002,'Topic for incoming / published TimeTagged Telecommands (???)'),
2013 (89,'StackoverflowReport',1024,'A thread\'s info on stackoverflow'),
2014 (91,'TimingLog',1019,'Timing information of an application\'s thread'),
2015 (92,'FaultReport',1020,'Processor last resort fault information'),
2016 (93,'PpsSoftwareFallback',1021,'Topic to handle PPS software fallback'),
2017 (94,'pfdaTriggerTelemetry',5001,'Topic to synchronously trigger telemetry sending on all pFDAs'),
2018 (95,'pfdaSetEnable',5002,'Topic to synchronously enable or disable individual pFDAs'),
2019 (96,'pfdaSetFrequency',5003,'Topic to syncrhonously set the frequency of all pFDAs'),
2020 (97,'pfdaSetSpeed',5004,'Topic to synchronously set the spee of all pFDAs');
2021/*!40000 ALTER TABLE `stm_topics` ENABLE KEYS */;
2022UNLOCK TABLES;
2023
2024--
2025-- Current Database: `global`
2026--
2027
2028CREATE DATABASE /*!32312 IF NOT EXISTS*/ `global` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
2029
2030USE `global`;
2031
2032--
2033-- Table structure for table `rdt_LogInfo`
2034--
2035
2036DROP TABLE IF EXISTS `rdt_LogInfo`;
2037/*!40101 SET @saved_cs_client = @@character_set_client */;
2038/*!40101 SET character_set_client = utf8 */;
2039CREATE TABLE `rdt_LogInfo` (
2040 `keyLogInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
2041 `keyGroundStation` int(10) unsigned DEFAULT NULL,
2042 `keySatellite` int(10) unsigned DEFAULT NULL,
2043 `keySatelliteModel` int(10) unsigned DEFAULT NULL,
2044 `Time` datetime NOT NULL,
2045 `ActionType` varchar(50) NOT NULL,
2046 `Message` text DEFAULT NULL,
2047 `ModuleType` varchar(50) DEFAULT NULL,
2048 `MessageType` varchar(50) DEFAULT NULL,
2049 PRIMARY KEY (`keyLogInfo`),
2050 KEY `LogInfo_GroundStation` (`keyGroundStation`),
2051 KEY `LogInfo_Satellite` (`keySatellite`),
2052 CONSTRAINT `LogInfo_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE SET NULL ON UPDATE CASCADE,
2053 CONSTRAINT `LogInfo_Satellite` FOREIGN KEY (`keySatellite`) REFERENCES `stm_Satellite` (`keySatellite`) ON DELETE SET NULL ON UPDATE CASCADE
2054) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2055/*!40101 SET character_set_client = @saved_cs_client */;
2056
2057--
2058-- Dumping data for table `rdt_LogInfo`
2059--
2060
2061LOCK TABLES `rdt_LogInfo` WRITE;
2062/*!40000 ALTER TABLE `rdt_LogInfo` DISABLE KEYS */;
2063/*!40000 ALTER TABLE `rdt_LogInfo` ENABLE KEYS */;
2064UNLOCK TABLES;
2065
2066--
2067-- Table structure for table `stm_Configuration`
2068--
2069
2070DROP TABLE IF EXISTS `stm_Configuration`;
2071/*!40101 SET @saved_cs_client = @@character_set_client */;
2072/*!40101 SET character_set_client = utf8 */;
2073CREATE TABLE `stm_Configuration` (
2074 `keyConfiguration` int(10) unsigned NOT NULL AUTO_INCREMENT,
2075 `keyGroundStation` int(10) unsigned NOT NULL,
2076 `keyConfigurationParameter` int(10) unsigned NOT NULL,
2077 `ParameterValue` varchar(100) DEFAULT NULL,
2078 PRIMARY KEY (`keyConfiguration`),
2079 KEY `Configuration_ConfiguationParameter` (`keyConfigurationParameter`),
2080 KEY `Configuration_GroundStation` (`keyGroundStation`),
2081 CONSTRAINT `Configuration_ConfiguationParameter` FOREIGN KEY (`keyConfigurationParameter`) REFERENCES `stm_ConfigurationParameter` (`keyConfigurationParameter`) ON DELETE CASCADE ON UPDATE CASCADE,
2082 CONSTRAINT `Configuration_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE
2083) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2084/*!40101 SET character_set_client = @saved_cs_client */;
2085
2086--
2087-- Dumping data for table `stm_Configuration`
2088--
2089
2090LOCK TABLES `stm_Configuration` WRITE;
2091/*!40000 ALTER TABLE `stm_Configuration` DISABLE KEYS */;
2092/*!40000 ALTER TABLE `stm_Configuration` ENABLE KEYS */;
2093UNLOCK TABLES;
2094
2095--
2096-- Table structure for table `stm_ConfigurationParameter`
2097--
2098
2099DROP TABLE IF EXISTS `stm_ConfigurationParameter`;
2100/*!40101 SET @saved_cs_client = @@character_set_client */;
2101/*!40101 SET character_set_client = utf8 */;
2102CREATE TABLE `stm_ConfigurationParameter` (
2103 `keyConfigurationParameter` int(10) unsigned NOT NULL AUTO_INCREMENT,
2104 `ParameterName` varchar(100) NOT NULL,
2105 `ParameterType` varchar(20) NOT NULL,
2106 `Required` tinyint(4) NOT NULL DEFAULT 1,
2107 `Description` varchar(150) NOT NULL,
2108 PRIMARY KEY (`keyConfigurationParameter`),
2109 UNIQUE KEY `ParameterName` (`ParameterName`)
2110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2111/*!40101 SET character_set_client = @saved_cs_client */;
2112
2113--
2114-- Dumping data for table `stm_ConfigurationParameter`
2115--
2116
2117LOCK TABLES `stm_ConfigurationParameter` WRITE;
2118/*!40000 ALTER TABLE `stm_ConfigurationParameter` DISABLE KEYS */;
2119/*!40000 ALTER TABLE `stm_ConfigurationParameter` ENABLE KEYS */;
2120UNLOCK TABLES;
2121
2122--
2123-- Table structure for table `stm_GroundStation`
2124--
2125
2126DROP TABLE IF EXISTS `stm_GroundStation`;
2127/*!40101 SET @saved_cs_client = @@character_set_client */;
2128/*!40101 SET character_set_client = utf8 */;
2129CREATE TABLE `stm_GroundStation` (
2130 `keyGroundStation` int(10) unsigned NOT NULL AUTO_INCREMENT,
2131 `Name` varchar(50) NOT NULL DEFAULT '-----',
2132 `NSCoordinate` double NOT NULL DEFAULT 0,
2133 `EWCoordinate` double NOT NULL DEFAULT 0,
2134 `HeightNN` double NOT NULL DEFAULT 0,
2135 `TimeZone` double NOT NULL DEFAULT 0,
2136 `TTSAdress` varchar(255) DEFAULT NULL,
2137 `TTSPort` smallint(5) unsigned NOT NULL DEFAULT 0,
2138 `Country` varchar(20) DEFAULT NULL,
2139 `LocalAuthority` varchar(50) DEFAULT NULL,
2140 `ContactPerson` varchar(50) DEFAULT NULL,
2141 `ContactPhone` varchar(50) DEFAULT NULL,
2142 `ContactEmail` varchar(50) DEFAULT NULL,
2143 PRIMARY KEY (`keyGroundStation`),
2144 UNIQUE KEY `Name` (`Name`)
2145) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2146/*!40101 SET character_set_client = @saved_cs_client */;
2147
2148--
2149-- Dumping data for table `stm_GroundStation`
2150--
2151
2152LOCK TABLES `stm_GroundStation` WRITE;
2153/*!40000 ALTER TABLE `stm_GroundStation` DISABLE KEYS */;
2154INSERT INTO `stm_GroundStation` VALUES
2155 (0,'-----',0,0,0,0,NULL,0,NULL,NULL,NULL,NULL,NULL),
2156 (1,'localhost',0,0,0,0,'localhost',7000,'none','none','none','none','none');
2157/*!40000 ALTER TABLE `stm_GroundStation` ENABLE KEYS */;
2158UNLOCK TABLES;
2159
2160--
2161-- Table structure for table `stm_MCCProgram`
2162--
2163
2164DROP TABLE IF EXISTS `stm_MCCProgram`;
2165/*!40101 SET @saved_cs_client = @@character_set_client */;
2166/*!40101 SET character_set_client = utf8 */;
2167CREATE TABLE `stm_MCCProgram` (
2168 `keyMCCProgram` int(10) unsigned NOT NULL AUTO_INCREMENT,
2169 `ProgramType` enum('TTS','TCControl','TMViewer','TMAnalyzer','Installer') NOT NULL,
2170 `linux32` longblob DEFAULT NULL,
2171 `linux64` longblob DEFAULT NULL,
2172 `win32` longblob DEFAULT NULL,
2173 `win64` longblob DEFAULT NULL,
2174 `java` longblob DEFAULT NULL,
2175 `TimeStamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
2176 `Version` varchar(50) DEFAULT NULL,
2177 PRIMARY KEY (`keyMCCProgram`),
2178 UNIQUE KEY `ProgramType_Platform` (`ProgramType`)
2179) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2180/*!40101 SET character_set_client = @saved_cs_client */;
2181
2182--
2183-- Dumping data for table `stm_MCCProgram`
2184--
2185
2186LOCK TABLES `stm_MCCProgram` WRITE;
2187/*!40000 ALTER TABLE `stm_MCCProgram` DISABLE KEYS */;
2188/*!40000 ALTER TABLE `stm_MCCProgram` ENABLE KEYS */;
2189UNLOCK TABLES;
2190
2191--
2192-- Table structure for table `stm_Plugin`
2193--
2194
2195DROP TABLE IF EXISTS `stm_Plugin`;
2196/*!40101 SET @saved_cs_client = @@character_set_client */;
2197/*!40101 SET character_set_client = utf8 */;
2198CREATE TABLE `stm_Plugin` (
2199 `keyPlugin` int(10) unsigned NOT NULL AUTO_INCREMENT,
2200 `PluginType` enum('HamLibModule','Library','OwnLibrary','QtLibrary','QPlatformLib','OSModule','TNC','Telemetry','Command') NOT NULL,
2201 `PluginName` varchar(50) NOT NULL,
2202 `linux32` longblob DEFAULT NULL,
2203 `linux64` longblob DEFAULT NULL,
2204 `win32` longblob DEFAULT NULL,
2205 `win64` longblob DEFAULT NULL,
2206 `java` longblob DEFAULT NULL,
2207 `TimeStamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
2208 `Version` varchar(50) DEFAULT NULL,
2209 PRIMARY KEY (`keyPlugin`)
2210) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2211/*!40101 SET character_set_client = @saved_cs_client */;
2212
2213--
2214-- Dumping data for table `stm_Plugin`
2215--
2216
2217LOCK TABLES `stm_Plugin` WRITE;
2218/*!40000 ALTER TABLE `stm_Plugin` DISABLE KEYS */;
2219INSERT INTO `stm_Plugin` VALUES
2220 (1,'Command','command_tubix20',NULL,NULL,NULL,NULL,NULL,'2018-05-25 08:15:15',NULL),
2221 (2,'Telemetry','tubix20plugin',NULL,NULL,NULL,NULL,NULL,'2018-05-25 09:34:09','0.0.1');
2222/*!40000 ALTER TABLE `stm_Plugin` ENABLE KEYS */;
2223UNLOCK TABLES;
2224
2225--
2226-- Table structure for table `stm_Satellite`
2227--
2228
2229DROP TABLE IF EXISTS `stm_Satellite`;
2230/*!40101 SET @saved_cs_client = @@character_set_client */;
2231/*!40101 SET character_set_client = utf8 */;
2232CREATE TABLE `stm_Satellite` (
2233 `keySatellite` int(10) unsigned NOT NULL AUTO_INCREMENT,
2234 `SatelliteName` varchar(50) NOT NULL DEFAULT '-----',
2235 `DBSheme` varchar(30) DEFAULT NULL,
2236 `DBLogin` varchar(100) DEFAULT NULL COMMENT '[encrypted]',
2237 `DBPassword` varchar(100) DEFAULT NULL COMMENT '[encrypted]',
2238 `DBServer` varchar(100) DEFAULT NULL,
2239 `DBPort` smallint(30) unsigned NOT NULL DEFAULT 3306,
2240 `IsBeeSat1` tinyint(1) unsigned NOT NULL DEFAULT 0,
2241 `TrackIntervall` smallint(5) unsigned NOT NULL DEFAULT 1000 COMMENT '[MSec]',
2242 `keyTMPlugin` int(10) unsigned DEFAULT NULL,
2243 `keyTNCPlugin` int(10) unsigned DEFAULT NULL,
2244 `keyTCPlugin` int(10) unsigned DEFAULT NULL,
2245 `OperationMode` enum('beesat1','beesatx','tubix20','beesat5to8') NOT NULL DEFAULT 'beesatx' COMMENT 'Mode of Com-Operations',
2246 PRIMARY KEY (`keySatellite`),
2247 UNIQUE KEY `Name` (`SatelliteName`),
2248 KEY `Satellite_TMPlugin` (`keyTMPlugin`),
2249 KEY `Satellite_TNCPlugin` (`keyTNCPlugin`),
2250 KEY `Satellite_TCPlugin` (`keyTCPlugin`),
2251 CONSTRAINT `Satellite_TCPlugin` FOREIGN KEY (`keyTCPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL,
2252 CONSTRAINT `Satellite_TMPlugin` FOREIGN KEY (`keyTMPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL ON UPDATE CASCADE,
2253 CONSTRAINT `Satellite_TNCPlugin` FOREIGN KEY (`keyTNCPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL ON UPDATE CASCADE
2254) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2255/*!40101 SET character_set_client = @saved_cs_client */;
2256
2257--
2258-- Dumping data for table `stm_Satellite`
2259--
2260
2261LOCK TABLES `stm_Satellite` WRITE;
2262/*!40000 ALTER TABLE `stm_Satellite` DISABLE KEYS */;
2263INSERT INTO `stm_Satellite` VALUES
2264 (0,'-----',NULL,NULL,NULL,NULL,3306,0,1000,NULL,NULL,NULL,'beesatx'),
2265 (1,'TUPEX-6 Sat','tupex6','root','root','localhost',3306,0,1000,2,NULL,1,'tubix20');
2266/*!40000 ALTER TABLE `stm_Satellite` ENABLE KEYS */;
2267UNLOCK TABLES;
2268
2269--
2270-- Table structure for table `stm_SatellitesToTrack`
2271--
2272
2273DROP TABLE IF EXISTS `stm_SatellitesToTrack`;
2274/*!40101 SET @saved_cs_client = @@character_set_client */;
2275/*!40101 SET character_set_client = utf8 */;
2276CREATE TABLE `stm_SatellitesToTrack` (
2277 `keySatellitesToTrack` int(10) unsigned NOT NULL AUTO_INCREMENT,
2278 `keyGroundStation` int(10) unsigned NOT NULL,
2279 `keySatellite` int(10) unsigned NOT NULL,
2280 `keySatelliteModel` int(10) unsigned NOT NULL COMMENT 'Attention: No Foreign Key Constraint, handle with care!',
2281 `autoTrack` tinyint(1) unsigned NOT NULL DEFAULT 0,
2282 PRIMARY KEY (`keySatellitesToTrack`),
2283 KEY `SatellitesToTrack_Groundstation` (`keyGroundStation`),
2284 KEY `SatellitesToTrack_Satellite` (`keySatellite`),
2285 CONSTRAINT `SatellitesToTrack_Groundstation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE,
2286 CONSTRAINT `SatellitesToTrack_Satellite` FOREIGN KEY (`keySatellite`) REFERENCES `stm_Satellite` (`keySatellite`) ON DELETE CASCADE ON UPDATE CASCADE
2287) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2288/*!40101 SET character_set_client = @saved_cs_client */;
2289
2290--
2291-- Dumping data for table `stm_SatellitesToTrack`
2292--
2293
2294LOCK TABLES `stm_SatellitesToTrack` WRITE;
2295/*!40000 ALTER TABLE `stm_SatellitesToTrack` DISABLE KEYS */;
2296/*!40000 ALTER TABLE `stm_SatellitesToTrack` ENABLE KEYS */;
2297UNLOCK TABLES;
2298
2299--
2300-- Table structure for table `stm_TNC`
2301--
2302
2303DROP TABLE IF EXISTS `stm_TNC`;
2304/*!40101 SET @saved_cs_client = @@character_set_client */;
2305/*!40101 SET character_set_client = utf8 */;
2306CREATE TABLE `stm_TNC` (
2307 `keyTNC` int(10) unsigned NOT NULL AUTO_INCREMENT,
2308 `Name` varchar(50) NOT NULL,
2309 `ErrorDetectionRoutine` enum('','MobiTex') DEFAULT '',
2310 PRIMARY KEY (`keyTNC`)
2311) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
2312/*!40101 SET character_set_client = @saved_cs_client */;
2313
2314--
2315-- Dumping data for table `stm_TNC`
2316--
2317
2318LOCK TABLES `stm_TNC` WRITE;
2319/*!40000 ALTER TABLE `stm_TNC` DISABLE KEYS */;
2320INSERT INTO `stm_TNC` VALUES
2321 (7,'Tbx20Egse','MobiTex');
2322/*!40000 ALTER TABLE `stm_TNC` ENABLE KEYS */;
2323UNLOCK TABLES;
2324/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2325
2326/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2327/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2328/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2329/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2330/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2331/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2332/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2333
2334-- Dump completed on 2019-02-20 17:56:24