· 7 years ago · Feb 20, 2019, 04:54 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=670 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 (643,1,200001,2,0,0),
316 (644,1,100003,2,0,1),
317 (645,1,200003,2,1,0),
318 (646,1,100009,2,1,1),
319 (647,1,200007,2,2,0),
320 (648,1,100011,2,2,1),
321 (649,1,200005,2,3,0),
322 (650,1,200009,2,4,0),
323 (651,1,100004,2,4,1),
324 (652,1,200011,2,5,0),
325 (653,1,100010,2,5,1),
326 (654,1,200013,2,6,0),
327 (655,1,100012,2,6,1),
328 (656,1,200002,2,8,0),
329 (657,1,100014,2,8,1),
330 (658,1,200004,2,9,0),
331 (659,1,100013,2,9,1),
332 (660,1,200008,2,10,0),
333 (661,1,200006,2,11,0),
334 (662,1,200016,2,11,1),
335 (663,1,200010,2,12,0),
336 (664,1,200017,2,12,1),
337 (665,1,200012,2,13,0),
338 (666,1,200014,2,14,0),
339 (667,1,11001,2,16,0),
340 (668,1,17001,2,17,0),
341 (669,1,200015,2,18,0);
342/*!40000 ALTER TABLE `gui_ProfileWindowParam` ENABLE KEYS */;
343UNLOCK TABLES;
344
345--
346-- Table structure for table `gui_Trendgroup`
347--
348
349DROP TABLE IF EXISTS `gui_Trendgroup`;
350/*!40101 SET @saved_cs_client = @@character_set_client */;
351/*!40101 SET character_set_client = utf8 */;
352CREATE TABLE `gui_Trendgroup` (
353 `keyTrendgroup` int(10) unsigned NOT NULL AUTO_INCREMENT,
354 `NameTrendgroup` varchar(100) NOT NULL,
355 PRIMARY KEY (`keyTrendgroup`)
356) ENGINE=InnoDB DEFAULT CHARSET=latin1;
357/*!40101 SET character_set_client = @saved_cs_client */;
358
359--
360-- Dumping data for table `gui_Trendgroup`
361--
362
363LOCK TABLES `gui_Trendgroup` WRITE;
364/*!40000 ALTER TABLE `gui_Trendgroup` DISABLE KEYS */;
365/*!40000 ALTER TABLE `gui_Trendgroup` ENABLE KEYS */;
366UNLOCK TABLES;
367
368--
369-- Table structure for table `rdt_CommandLog`
370--
371
372DROP TABLE IF EXISTS `rdt_CommandLog`;
373/*!40101 SET @saved_cs_client = @@character_set_client */;
374/*!40101 SET character_set_client = utf8 */;
375CREATE TABLE `rdt_CommandLog` (
376 `keyCommandLog` int(10) unsigned NOT NULL AUTO_INCREMENT,
377 `keySatelliteModel` int(10) unsigned NOT NULL,
378 `keyGroundStation` int(10) unsigned NOT NULL,
379 `TransmissionTime` datetime DEFAULT NULL,
380 `CommandString` mediumtext DEFAULT NULL,
381 `SendState` enum('UNHANDLED','TTS OK','TTS NOK','TNC OK','TNC NOK','SAT OK','SAT NOK','SAT UNDEF') DEFAULT 'UNHANDLED',
382 PRIMARY KEY (`keyCommandLog`),
383 KEY `CommandLog_GroundStation` (`keyGroundStation`),
384 KEY `CommandLog_SatelliteModel` (`keySatelliteModel`),
385 CONSTRAINT `CommandLog_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE,
386 CONSTRAINT `CommandLog_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE
387) ENGINE=InnoDB DEFAULT CHARSET=latin1;
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Dumping data for table `rdt_CommandLog`
392--
393
394LOCK TABLES `rdt_CommandLog` WRITE;
395/*!40000 ALTER TABLE `rdt_CommandLog` DISABLE KEYS */;
396/*!40000 ALTER TABLE `rdt_CommandLog` ENABLE KEYS */;
397UNLOCK TABLES;
398
399--
400-- Table structure for table `rdt_DecodedData`
401--
402
403DROP TABLE IF EXISTS `rdt_DecodedData`;
404/*!40101 SET @saved_cs_client = @@character_set_client */;
405/*!40101 SET character_set_client = utf8 */;
406CREATE TABLE `rdt_DecodedData` (
407 `keyDecodedData` int(10) unsigned NOT NULL AUTO_INCREMENT,
408 `keyDecodedSourcePacket` int(10) unsigned NOT NULL,
409 `keyTMParam` int(10) unsigned NOT NULL,
410 `ValueDouble` double DEFAULT NULL,
411 `ValueHex` text DEFAULT NULL,
412 `ValueError` tinyint(1) unsigned NOT NULL DEFAULT 0,
413 PRIMARY KEY (`keyDecodedData`),
414 KEY `DecodedData_DecodedSourcePacket` (`keyDecodedSourcePacket`),
415 KEY `DecodedData_TMParam` (`keyTMParam`),
416 CONSTRAINT `DecodedData_DecodedSourcePacket` FOREIGN KEY (`keyDecodedSourcePacket`) REFERENCES `rdt_DecodedSourcePacket` (`keyDecodedSourcePacket`) ON DELETE CASCADE ON UPDATE CASCADE,
417 CONSTRAINT `DecodedData_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`)
418) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded TELEMETRY VALUES';
419/*!40101 SET character_set_client = @saved_cs_client */;
420
421--
422-- Dumping data for table `rdt_DecodedData`
423--
424
425LOCK TABLES `rdt_DecodedData` WRITE;
426/*!40000 ALTER TABLE `rdt_DecodedData` DISABLE KEYS */;
427/*!40000 ALTER TABLE `rdt_DecodedData` ENABLE KEYS */;
428UNLOCK TABLES;
429
430--
431-- Table structure for table `rdt_DecodedSourcePacket`
432--
433
434DROP TABLE IF EXISTS `rdt_DecodedSourcePacket`;
435/*!40101 SET @saved_cs_client = @@character_set_client */;
436/*!40101 SET character_set_client = utf8 */;
437CREATE TABLE `rdt_DecodedSourcePacket` (
438 `keyDecodedSourcePacket` int(10) unsigned NOT NULL AUTO_INCREMENT,
439 `keyDecodedTransferFrame` int(10) unsigned NOT NULL,
440 `keyLogicNode` int(10) unsigned NOT NULL,
441 `physicalNode` tinyint(1) unsigned NOT NULL,
442 `keyTMSourcePacket` int(10) unsigned NOT NULL,
443 `keyTMVirtualChannel` int(10) unsigned NOT NULL,
444 `RecordingTime` datetime NOT NULL,
445 `RecordingTimeFrac` tinyint(1) unsigned NOT NULL,
446 `HeaderError` tinyint(1) unsigned NOT NULL,
447 `ParamErrorCount` smallint(4) unsigned NOT NULL,
448 PRIMARY KEY (`keyDecodedSourcePacket`),
449 KEY `DecodedSourcePacket_DecodedTransferFrame` (`keyDecodedTransferFrame`),
450 KEY `DecodedSourcePacket_LogicNode` (`keyLogicNode`),
451 KEY `DecodedSourcePacket_TMSourcePacket` (`keyTMSourcePacket`),
452 KEY `DecodedSourcePacket_TMVirtualChannel` (`keyTMVirtualChannel`),
453 CONSTRAINT `DecodedSourcePacket_DecodedTransferFrame` FOREIGN KEY (`keyDecodedTransferFrame`) REFERENCES `rdt_DecodedTransferFrame` (`keyDecodedTransferFrame`) ON DELETE CASCADE ON UPDATE CASCADE,
454 CONSTRAINT `DecodedSourcePacket_LogicNode` FOREIGN KEY (`keyLogicNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON UPDATE CASCADE,
455 CONSTRAINT `DecodedSourcePacket_TMSourcePacket` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON UPDATE CASCADE,
456 CONSTRAINT `DecodedSourcePacket_TMVirtualChannel` FOREIGN KEY (`keyTMVirtualChannel`) REFERENCES `stm_tm_virtualchannel` (`keyTMVirtualChannel`) ON UPDATE CASCADE
457) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded SOURCE PACKETS';
458/*!40101 SET character_set_client = @saved_cs_client */;
459
460--
461-- Dumping data for table `rdt_DecodedSourcePacket`
462--
463
464LOCK TABLES `rdt_DecodedSourcePacket` WRITE;
465/*!40000 ALTER TABLE `rdt_DecodedSourcePacket` DISABLE KEYS */;
466/*!40000 ALTER TABLE `rdt_DecodedSourcePacket` ENABLE KEYS */;
467UNLOCK TABLES;
468
469--
470-- Table structure for table `rdt_DecodedTransferFrame`
471--
472
473DROP TABLE IF EXISTS `rdt_DecodedTransferFrame`;
474/*!40101 SET @saved_cs_client = @@character_set_client */;
475/*!40101 SET character_set_client = utf8 */;
476CREATE TABLE `rdt_DecodedTransferFrame` (
477 `keyDecodedTransferFrame` int(10) unsigned NOT NULL AUTO_INCREMENT,
478 `keyRawData` int(10) unsigned NOT NULL,
479 `SpaceCraftID` int(10) unsigned NOT NULL,
480 `Version` tinyint(10) unsigned NOT NULL,
481 `Counter` int(10) unsigned NOT NULL,
482 `HeaderError` tinyint(1) unsigned NOT NULL,
483 `BlockErrorCount` tinyint(2) unsigned NOT NULL,
484 PRIMARY KEY (`keyDecodedTransferFrame`),
485 KEY `DecodedTransferFrame_RawData` (`keyRawData`),
486 CONSTRAINT `DecodedTransferFrame_RawData` FOREIGN KEY (`keyRawData`) REFERENCES `rdt_RawData` (`keyRawdata`) ON UPDATE CASCADE
487) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of decoded TRANSFER FRAMES';
488/*!40101 SET character_set_client = @saved_cs_client */;
489
490--
491-- Dumping data for table `rdt_DecodedTransferFrame`
492--
493
494LOCK TABLES `rdt_DecodedTransferFrame` WRITE;
495/*!40000 ALTER TABLE `rdt_DecodedTransferFrame` DISABLE KEYS */;
496/*!40000 ALTER TABLE `rdt_DecodedTransferFrame` ENABLE KEYS */;
497UNLOCK TABLES;
498
499--
500-- Table structure for table `rdt_LogInfo`
501--
502
503DROP TABLE IF EXISTS `rdt_LogInfo`;
504/*!40101 SET @saved_cs_client = @@character_set_client */;
505/*!40101 SET character_set_client = utf8 */;
506CREATE TABLE `rdt_LogInfo` (
507 `keyLogInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
508 `keySatelliteModel` int(10) unsigned DEFAULT NULL,
509 `Time` datetime NOT NULL,
510 `ActionType` varchar(50) NOT NULL,
511 `Message` text DEFAULT NULL,
512 `ModuleType` varchar(50) DEFAULT NULL,
513 `MessageType` varchar(50) DEFAULT NULL,
514 PRIMARY KEY (`keyLogInfo`),
515 KEY `LogInfo_SatelliteModel` (`keySatelliteModel`),
516 CONSTRAINT `LogInfo_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE SET NULL ON UPDATE CASCADE
517) ENGINE=InnoDB DEFAULT CHARSET=latin1;
518/*!40101 SET character_set_client = @saved_cs_client */;
519
520--
521-- Dumping data for table `rdt_LogInfo`
522--
523
524LOCK TABLES `rdt_LogInfo` WRITE;
525/*!40000 ALTER TABLE `rdt_LogInfo` DISABLE KEYS */;
526/*!40000 ALTER TABLE `rdt_LogInfo` ENABLE KEYS */;
527UNLOCK TABLES;
528
529--
530-- Table structure for table `rdt_RawData`
531--
532
533DROP TABLE IF EXISTS `rdt_RawData`;
534/*!40101 SET @saved_cs_client = @@character_set_client */;
535/*!40101 SET character_set_client = utf8 */;
536CREATE TABLE `rdt_RawData` (
537 `keyRawdata` int(10) unsigned NOT NULL AUTO_INCREMENT,
538 `keySatelliteModel` int(10) unsigned NOT NULL,
539 `keyGroundStation` int(10) unsigned NOT NULL,
540 `keyTNC` int(10) unsigned NOT NULL,
541 `GroundStationTimeUTC` datetime NOT NULL,
542 `OrbitNumber` mediumint(8) unsigned NOT NULL DEFAULT 0,
543 `RawData` text NOT NULL,
544 `Comment` varchar(50) DEFAULT NULL,
545 `DecodeState` tinyint(2) NOT NULL DEFAULT 0,
546 `Azimuth` float DEFAULT NULL,
547 `Elevation` float DEFAULT NULL,
548 `SMeter` float DEFAULT NULL,
549 PRIMARY KEY (`keyRawdata`),
550 KEY `RawData_TNC` (`keyTNC`),
551 KEY `RawData_GroundStation` (`keyGroundStation`),
552 KEY `RawData_SatelliteModel` (`keySatelliteModel`),
553 CONSTRAINT `RawData_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE NO ACTION ON UPDATE CASCADE,
554 CONSTRAINT `RawData_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE,
555 CONSTRAINT `RawData_TNC` FOREIGN KEY (`keyTNC`) REFERENCES `stm_TNC` (`keyTNC`) ON DELETE NO ACTION ON UPDATE CASCADE
556) ENGINE=InnoDB DEFAULT CHARSET=latin1;
557/*!40101 SET character_set_client = @saved_cs_client */;
558
559--
560-- Dumping data for table `rdt_RawData`
561--
562
563LOCK TABLES `rdt_RawData` WRITE;
564/*!40000 ALTER TABLE `rdt_RawData` DISABLE KEYS */;
565/*!40000 ALTER TABLE `rdt_RawData` ENABLE KEYS */;
566UNLOCK TABLES;
567
568--
569-- Table structure for table `rdt_TC_AutomatedList`
570--
571
572DROP TABLE IF EXISTS `rdt_TC_AutomatedList`;
573/*!40101 SET @saved_cs_client = @@character_set_client */;
574/*!40101 SET character_set_client = utf8 */;
575CREATE TABLE `rdt_TC_AutomatedList` (
576 `keyTCAutomatedList` int(10) unsigned NOT NULL AUTO_INCREMENT,
577 `keySatelliteModel` int(10) unsigned NOT NULL,
578 `ListName` varchar(100) NOT NULL,
579 `DefaultList` tinyint(1) unsigned NOT NULL,
580 `ActiveList` tinyint(1) unsigned NOT NULL,
581 `ListState` enum('Incomplete','Complete','InProgress') NOT NULL DEFAULT 'Incomplete',
582 `ValidFrom` datetime DEFAULT NULL COMMENT 'Datetime from when list is allowed for transmission',
583 `ValidTo` datetime DEFAULT NULL COMMENT 'Datetime until list is allowed for transmission',
584 PRIMARY KEY (`keyTCAutomatedList`),
585 KEY `AutomatedList_SatelliteModel` (`keySatelliteModel`),
586 CONSTRAINT `AutomatedList_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE ON UPDATE CASCADE
587) ENGINE=InnoDB DEFAULT CHARSET=latin1;
588/*!40101 SET character_set_client = @saved_cs_client */;
589
590--
591-- Dumping data for table `rdt_TC_AutomatedList`
592--
593
594LOCK TABLES `rdt_TC_AutomatedList` WRITE;
595/*!40000 ALTER TABLE `rdt_TC_AutomatedList` DISABLE KEYS */;
596/*!40000 ALTER TABLE `rdt_TC_AutomatedList` ENABLE KEYS */;
597UNLOCK TABLES;
598
599--
600-- Table structure for table `rdt_TC_AutomatedListCommand`
601--
602
603DROP TABLE IF EXISTS `rdt_TC_AutomatedListCommand`;
604/*!40101 SET @saved_cs_client = @@character_set_client */;
605/*!40101 SET character_set_client = utf8 */;
606CREATE TABLE `rdt_TC_AutomatedListCommand` (
607 `keyTCAutomatedListCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
608 `keyTCAutomatedList` int(10) unsigned NOT NULL,
609 `CommandID` int(10) unsigned NOT NULL,
610 `CommandString` mediumtext NOT NULL,
611 `ForceTransmission` tinyint(1) unsigned NOT NULL,
612 `SendState` enum('UNHANDLED','TTS OK','TTS NOK','TNC OK','TNC NOK','SAT OK','SAT NOK','SAT UNDEF') NOT NULL DEFAULT 'UNHANDLED',
613 `TransmissionTime` datetime DEFAULT NULL,
614 PRIMARY KEY (`keyTCAutomatedListCommand`),
615 UNIQUE KEY `keyTCAutomatedList_CommandID` (`keyTCAutomatedList`,`CommandID`),
616 CONSTRAINT `AutomatedListCommand_AutomatedList` FOREIGN KEY (`keyTCAutomatedList`) REFERENCES `rdt_TC_AutomatedList` (`keyTCAutomatedList`) ON DELETE CASCADE ON UPDATE CASCADE
617) ENGINE=InnoDB DEFAULT CHARSET=latin1;
618/*!40101 SET character_set_client = @saved_cs_client */;
619
620--
621-- Dumping data for table `rdt_TC_AutomatedListCommand`
622--
623
624LOCK TABLES `rdt_TC_AutomatedListCommand` WRITE;
625/*!40000 ALTER TABLE `rdt_TC_AutomatedListCommand` DISABLE KEYS */;
626/*!40000 ALTER TABLE `rdt_TC_AutomatedListCommand` ENABLE KEYS */;
627UNLOCK TABLES;
628
629--
630-- Table structure for table `rdt_TLE`
631--
632
633DROP TABLE IF EXISTS `rdt_TLE`;
634/*!40101 SET @saved_cs_client = @@character_set_client */;
635/*!40101 SET character_set_client = utf8 */;
636CREATE TABLE `rdt_TLE` (
637 `keyTLE` int(10) unsigned NOT NULL AUTO_INCREMENT,
638 `keySatelliteModel` int(10) unsigned NOT NULL,
639 `Time` datetime NOT NULL,
640 `TLE` text NOT NULL,
641 PRIMARY KEY (`keyTLE`),
642 KEY `TLE_SatelliteModel` (`keySatelliteModel`),
643 CONSTRAINT `TLE_SatelliteModel` FOREIGN KEY (`keySatelliteModel`) REFERENCES `stm_SatelliteModel` (`keySatelliteModel`) ON DELETE CASCADE
644) ENGINE=InnoDB DEFAULT CHARSET=latin1;
645/*!40101 SET character_set_client = @saved_cs_client */;
646
647--
648-- Dumping data for table `rdt_TLE`
649--
650
651LOCK TABLES `rdt_TLE` WRITE;
652/*!40000 ALTER TABLE `rdt_TLE` DISABLE KEYS */;
653/*!40000 ALTER TABLE `rdt_TLE` ENABLE KEYS */;
654UNLOCK TABLES;
655
656--
657-- Table structure for table `stm_GroundStation`
658--
659
660DROP TABLE IF EXISTS `stm_GroundStation`;
661/*!40101 SET @saved_cs_client = @@character_set_client */;
662/*!40101 SET character_set_client = utf8 */;
663CREATE TABLE `stm_GroundStation` (
664 `keyGroundStation` int(10) unsigned NOT NULL AUTO_INCREMENT,
665 `Name` varchar(50) NOT NULL DEFAULT '-----',
666 `NSCoordinate` double NOT NULL DEFAULT 0,
667 `EWCoordinate` double NOT NULL DEFAULT 0,
668 `HeightNN` double NOT NULL DEFAULT 0,
669 `TimeZone` double NOT NULL DEFAULT 0,
670 `TTSAdress` varchar(255) DEFAULT NULL,
671 `TTSPort` smallint(5) unsigned NOT NULL DEFAULT 0,
672 `Country` varchar(20) DEFAULT NULL,
673 `LocalAuthority` varchar(50) DEFAULT NULL,
674 `ContactPerson` varchar(50) DEFAULT NULL,
675 `ContactPhone` varchar(50) DEFAULT NULL,
676 `ContactEmail` varchar(50) DEFAULT NULL,
677 PRIMARY KEY (`keyGroundStation`),
678 UNIQUE KEY `Name` (`Name`)
679) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Only Copy of working table stm_GroundStation in globaldb!';
680/*!40101 SET character_set_client = @saved_cs_client */;
681
682--
683-- Dumping data for table `stm_GroundStation`
684--
685
686LOCK TABLES `stm_GroundStation` WRITE;
687/*!40000 ALTER TABLE `stm_GroundStation` DISABLE KEYS */;
688INSERT INTO `stm_GroundStation` VALUES
689 (1,'localhost',0,0,0,0,'localhost',7000,NULL,NULL,NULL,NULL,NULL);
690/*!40000 ALTER TABLE `stm_GroundStation` ENABLE KEYS */;
691UNLOCK TABLES;
692
693--
694-- Table structure for table `stm_SatelliteModel`
695--
696
697DROP TABLE IF EXISTS `stm_SatelliteModel`;
698/*!40101 SET @saved_cs_client = @@character_set_client */;
699/*!40101 SET character_set_client = utf8 */;
700CREATE TABLE `stm_SatelliteModel` (
701 `keySatelliteModel` int(10) unsigned NOT NULL AUTO_INCREMENT,
702 `NORADKatalogNr` int(10) unsigned NOT NULL DEFAULT 0,
703 `SpacecraftID` int(10) unsigned NOT NULL DEFAULT 0,
704 `ModelName` varchar(20) NOT NULL,
705 `Comment` varchar(50) DEFAULT NULL,
706 `UpFrequency` int(11) NOT NULL DEFAULT 0 COMMENT '[Hz]',
707 `DownFrequency` int(11) NOT NULL DEFAULT 0 COMMENT '[Hz]',
708 `isLaboratoryModel` tinyint(1) unsigned NOT NULL DEFAULT 0,
709 `TransferFrameLength` smallint(6) NOT NULL DEFAULT 0 COMMENT '[Byte]',
710 `TimeCalculationBase` datetime DEFAULT NULL,
711 PRIMARY KEY (`keySatelliteModel`),
712 UNIQUE KEY `NORADKatalogNr` (`NORADKatalogNr`)
713) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
714/*!40101 SET character_set_client = @saved_cs_client */;
715
716--
717-- Dumping data for table `stm_SatelliteModel`
718--
719
720LOCK TABLES `stm_SatelliteModel` WRITE;
721/*!40000 ALTER TABLE `stm_SatelliteModel` DISABLE KEYS */;
722INSERT INTO `stm_SatelliteModel` VALUES
723 (1,80,0,'Test','The main test model',0,0,1,0,'2000-01-01 00:00:00'),
724 (2,81,0,'Linux','Versions of the software compiled for Linux',0,0,1,0,'2000-01-01 00:00:00');
725/*!40000 ALTER TABLE `stm_SatelliteModel` ENABLE KEYS */;
726UNLOCK TABLES;
727
728--
729-- Table structure for table `stm_TC_Command`
730--
731
732DROP TABLE IF EXISTS `stm_TC_Command`;
733/*!40101 SET @saved_cs_client = @@character_set_client */;
734/*!40101 SET character_set_client = utf8 */;
735CREATE TABLE `stm_TC_Command` (
736 `keyTCCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
737 `keyApp` int(10) unsigned NOT NULL,
738 `Pre_Command` varchar(30) DEFAULT NULL,
739 `Post_Command` varchar(30) DEFAULT NULL,
740 `Name` varchar(45) NOT NULL,
741 `TC_Code` tinyint(8) unsigned NOT NULL,
742 `NumberOfParameters` smallint(5) unsigned NOT NULL,
743 `Editable` tinyint(1) unsigned NOT NULL DEFAULT 1,
744 `Function` varchar(100) NOT NULL,
745 `Comment` varchar(200) DEFAULT NULL,
746 `GuiParamWindow` enum('value','switch','sourcepacket') DEFAULT NULL,
747 PRIMARY KEY (`keyTCCommand`),
748 UNIQUE KEY `UNIQUE_cmd2app_combination` (`keyApp`,`TC_Code`),
749 KEY `TC_Command_keyApp` (`keyApp`),
750 CONSTRAINT `keyApp` FOREIGN KEY (`keyApp`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE
751) ENGINE=InnoDB AUTO_INCREMENT=170006 DEFAULT CHARSET=latin1 COMMENT='List of TELECOMMANDS';
752/*!40101 SET character_set_client = @saved_cs_client */;
753
754--
755-- Dumping data for table `stm_TC_Command`
756--
757
758LOCK TABLES `stm_TC_Command` WRITE;
759/*!40000 ALTER TABLE `stm_TC_Command` DISABLE KEYS */;
760INSERT INTO `stm_TC_Command` VALUES
761 (1001,1,NULL,NULL,'NOP',1,0,0,'GLB - no operation','does nothing while being a valid command',''),
762 (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'),
763 (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),
764 (2001,2,NULL,NULL,'NOP',1,0,0,'NOI - no operation','does nothing while being a valid command',NULL),
765 (2003,2,NULL,NULL,'SEND_NODEINFOS',3,0,0,'NOI - request node infos SP','request transmission of the ExtendedTmNodeInfos SP',NULL),
766 (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'),
767 (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'),
768 (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),
769 (3001,3,NULL,NULL,'NOP',1,0,0,'WAT - no operation','does nothing while being a valid command',NULL),
770 (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),
771 (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),
772 (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),
773 (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),
774 (4001,4,NULL,NULL,'NOP',1,0,0,'TIM - no operation','does nothing while being a valid command',NULL),
775 (4003,4,NULL,NULL,'SET_UTC',3,1,1,'TIM - set utc time','set current UTC time to <b>Seconds</b>','value'),
776 (4004,4,NULL,NULL,'ADJUST_UTC',4,1,1,'TIM - adjust utc time in milliseconds','adjust current UTC time by <b>Milliseconds</b>','value'),
777 (4005,4,NULL,NULL,'DISTRIBUTE_UTC_ENABLE',5,0,0,'TIM - enable time distribution','enable node to distribute time',NULL),
778 (4006,4,NULL,NULL,'DISTRIBUTE_UTC_DISABLE',6,0,0,'TIM - disable time distribution','disable node to distribute time',NULL),
779 (4007,4,NULL,NULL,'PPS_SYNC_ENABLE',7,0,0,'TIM - enable pps synchronisation','enable node to synchronize time with PPS signal',NULL),
780 (4008,4,NULL,NULL,'PPS_SYNC_DISABLE',8,0,0,'TIM - disable pps synchronisation','disable node to synchronize time with PPS signal',NULL),
781 (5001,5,NULL,NULL,'STD_TM_ENABLE',1,0,0,'HKE - enable standard telemetry','enable node to collect and distribute standard telemetry',NULL),
782 (5002,5,NULL,NULL,'STD_TM_DISABLE',2,0,0,'HKE - disable standard telemetry','disable node to collect and distribute standard telemetry',NULL),
783 (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'),
784 (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'),
785 (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),
786 (6001,6,NULL,NULL,'NOP',1,0,0,'CMD - no operation','does nothing while being a valid command',NULL),
787 (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),
788 (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'),
789 (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'),
790 (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'),
791 (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'),
792 (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'),
793 (110001,11,NULL,NULL,'NOP',1,0,0,'OBC - no operation','does nothing',NULL),
794 (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'),
795 (110003,11,NULL,NULL,'ABORT',3,1,1,'OBC - abort flight schedule application','aborts a running flight shedule',NULL),
796 (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'),
797 (120001,12,NULL,NULL,'NOP',1,0,0,'RBE - no operation','does nothing',NULL),
798 (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'),
799 (130001,13,NULL,NULL,'NOP',1,0,0,'EPS - no operation','does nothing',NULL),
800 (130002,13,NULL,NULL,'SET_MODE',2,1,1,'EPS - set power mode','sets the power mode','value'),
801 (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'),
802 (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'),
803 (140001,14,NULL,NULL,'NOP',1,0,0,'FDA - NOP','does nothing',NULL),
804 (140002,14,NULL,NULL,'SET_ENABLED',2,1,1,'FDA - set enabled','enables or disables the pFDA pump','value'),
805 (140003,14,NULL,NULL,'SET_FREQUENCY',3,1,1,'FDA - set pump frequency','sets the frequency that the pump operates at','value'),
806 (140004,14,NULL,NULL,'SET_SPEED',4,1,1,'FDA - set pump speed','sets the speed that the pump operates at','value'),
807 (150001,15,NULL,NULL,'NOP',1,0,0,'RSG - NOP','does nothing',NULL),
808 (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'),
809 (160001,16,NULL,NULL,'NOP',1,0,0,'LED - no operation','does nothing',NULL),
810 (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'),
811 (160003,16,NULL,NULL,'SET',3,1,1,'LED - set LED state','sets the LED pin to the specified value','value'),
812 (170001,17,NULL,NULL,'NOP',1,0,0,'PFM - no operation','does nothing',NULL),
813 (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'),
814 (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'),
815 (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'),
816 (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');
817/*!40000 ALTER TABLE `stm_TC_Command` ENABLE KEYS */;
818UNLOCK TABLES;
819
820--
821-- Table structure for table `stm_TC_Controlbytes`
822--
823
824DROP TABLE IF EXISTS `stm_TC_Controlbytes`;
825/*!40101 SET @saved_cs_client = @@character_set_client */;
826/*!40101 SET character_set_client = utf8 */;
827CREATE TABLE `stm_TC_Controlbytes` (
828 `keyTCControlBytes` int(10) unsigned NOT NULL AUTO_INCREMENT,
829 `Name` varchar(20) NOT NULL,
830 `Value` varchar(8) NOT NULL,
831 `Comment` varchar(200) DEFAULT NULL,
832 PRIMARY KEY (`keyTCControlBytes`)
833) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Table of base CONTROL BYTES for UHF communication protocols';
834/*!40101 SET character_set_client = @saved_cs_client */;
835
836--
837-- Dumping data for table `stm_TC_Controlbytes`
838--
839
840LOCK TABLES `stm_TC_Controlbytes` WRITE;
841/*!40000 ALTER TABLE `stm_TC_Controlbytes` DISABLE KEYS */;
842INSERT INTO `stm_TC_Controlbytes` VALUES
843 (1,'Regular','2050','Telecommand Message');
844/*!40000 ALTER TABLE `stm_TC_Controlbytes` ENABLE KEYS */;
845UNLOCK TABLES;
846
847--
848-- Table structure for table `stm_TC_Parameter`
849--
850
851DROP TABLE IF EXISTS `stm_TC_Parameter`;
852/*!40101 SET @saved_cs_client = @@character_set_client */;
853/*!40101 SET character_set_client = utf8 */;
854CREATE TABLE `stm_TC_Parameter` (
855 `keyTCParameter` int(10) unsigned NOT NULL AUTO_INCREMENT,
856 `keyTCCommand` int(10) unsigned NOT NULL,
857 `ParamNo` smallint(6) NOT NULL,
858 `ParamName` varchar(20) NOT NULL,
859 `BitLenght` smallint(16) unsigned NOT NULL,
860 `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',
861 `DefaultValue` double DEFAULT NULL,
862 `MinValue` double DEFAULT NULL,
863 `MaxValue` double DEFAULT NULL,
864 `Unit` varchar(15) DEFAULT NULL,
865 `Comment` varchar(1000) DEFAULT NULL,
866 `Interpretation` varchar(3000) DEFAULT NULL,
867 PRIMARY KEY (`keyTCParameter`),
868 UNIQUE KEY `UNIQUE_paramNo2cmd_combination` (`keyTCCommand`,`ParamNo`),
869 KEY `keyTCCommand` (`keyTCCommand`),
870 CONSTRAINT `TCParameter_TCCommand` FOREIGN KEY (`keyTCCommand`) REFERENCES `stm_TC_Command` (`keyTCCommand`) ON DELETE CASCADE ON UPDATE CASCADE
871) ENGINE=InnoDB AUTO_INCREMENT=24000302 DEFAULT CHARSET=latin1 COMMENT='List of TELECOMMAND PARAMETERS';
872/*!40101 SET character_set_client = @saved_cs_client */;
873
874--
875-- Dumping data for table `stm_TC_Parameter`
876--
877
878LOCK TABLES `stm_TC_Parameter` WRITE;
879/*!40000 ALTER TABLE `stm_TC_Parameter` DISABLE KEYS */;
880INSERT INTO `stm_TC_Parameter` VALUES
881 (100201,1002,1,'ID 1',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
882 (100202,1002,2,'ID 2',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
883 (100203,1002,3,'ID 3',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
884 (100204,1002,4,'ID 4',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
885 (100205,1002,5,'ID 5',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
886 (100206,1002,6,'ID 6',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
887 (100207,1002,7,'ID 7',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
888 (100208,1002,8,'ID 8',8,'TC_BYTE_UN',0,0,255,'(NULL)','source packet id',NULL),
889 (200401,2004,1,'Offset',8,'TC_BYTE',0,-128,127,'°C','internal temperature sensor offset in degrees Celsius',NULL),
890 (200501,2005,1,'New Rate',16,'TC_SHORT_UN',0,0,65535,'s','new history rate',NULL),
891 (400201,4003,1,'UTC',32,'TC_INT_UN_TIME',0,0,2147483647,'s','seconds since 1.1.2000 to current time in UTC',NULL),
892 (400401,4004,1,'Milliseconds',32,'TC_INT',0,-2147483648,2147483647,'ms','milliseconds to adjust current UTC time by',NULL),
893 (500301,5003,1,'Update Rate',32,'TC_INT',0,0,2147483647,'s','update rate in seconds',NULL),
894 (500501,5005,1,'ID 1',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
895 (500502,5005,2,'ID 2',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
896 (500503,5005,3,'ID 3',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
897 (500504,5005,4,'ID 4',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
898 (500505,5005,5,'ID 5',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
899 (500506,5005,6,'ID 6',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
900 (500507,5005,7,'ID 7',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
901 (500508,5005,8,'ID 8',8,'TC_BYTE_UN',0,0,255,NULL,'source packet id',NULL),
902 (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'),
903 (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'),
904 (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'),
905 (10000601,100006,1,'Status',8,'TC_BYTE_UN',0,0,1,NULL,'The new status of the write protection','0=Disabled;1=Enabled'),
906 (10000701,100007,1,'Card',8,'TC_BYTE_UN',0,0,1,NULL,'SD Card to read from',NULL),
907 (10000702,100007,2,'Block',32,'TC_INT_UN',0,0,4294967295,NULL,'Block to read',NULL),
908 (11000301,110002,1,'Timer',32,'TC_INT',-600,-600,67,'s','timer to syncronize nodes','-600=SODS;67=SOE'),
909 (11000401,110004,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'Whether to arm or disarm the magnets','0=Disarmed;1=Armed'),
910 (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'),
911 (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;'),
912 (13000401,130004,1,'CAN',8,'TC_BYTE_UN',0,0,1,NULL,'the can line to switch to','0=CAN0;1=CAN1'),
913 (14000201,140002,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'Wheter to disable or enable the pump','0=Disabled;1=Enabled'),
914 (14000301,140003,1,'Frequency',16,'TC_SHORT_UN',1000,1000,20000,'Hz','The frequency at which the pump shall run at',NULL),
915 (14000401,140004,1,'Speed',16,'TC_SHORT',0,-100,100,'%','The speed at which the pump shall run at',NULL),
916 (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'),
917 (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),
918 (16000301,160003,1,'State',8,'TC_BYTE_UN',0,0,1,NULL,'The state to which the LED pin shall be set.',NULL),
919 (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'),
920 (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'),
921 (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'),
922 (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'),
923 (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'),
924 (17000401,170004,1,'pFDA 1 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 1 frequency',''),
925 (17000402,170004,2,'pFDA 2 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 2 frequency',''),
926 (17000403,170004,3,'pFDA 3 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 3 frequency',''),
927 (17000404,170004,4,'pFDA 4 Frequency',16,'TC_SHORT_UN',0,0,65536,NULL,'Desired pFDA 4 frequency',''),
928 (17000501,170005,1,'pFDA 1 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 1 speed',''),
929 (17000502,170005,2,'pFDA 2 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 2 speed',''),
930 (17000503,170005,3,'pFDA 3 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 3 speed',''),
931 (17000504,170005,4,'pFDA 4 Speed',16,'TC_SHORT',0,-32768,32768,NULL,'Desired pFDA 4 speed',''),
932 (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);
933/*!40000 ALTER TABLE `stm_TC_Parameter` ENABLE KEYS */;
934UNLOCK TABLES;
935
936--
937-- Table structure for table `stm_TC_Procedure`
938--
939
940DROP TABLE IF EXISTS `stm_TC_Procedure`;
941/*!40101 SET @saved_cs_client = @@character_set_client */;
942/*!40101 SET character_set_client = utf8 */;
943CREATE TABLE `stm_TC_Procedure` (
944 `keyTCProcedure` int(10) unsigned NOT NULL AUTO_INCREMENT,
945 `ProcedureName` varchar(100) NOT NULL,
946 `ListLocked` tinyint(1) NOT NULL DEFAULT 0,
947 PRIMARY KEY (`keyTCProcedure`)
948) ENGINE=InnoDB DEFAULT CHARSET=latin1;
949/*!40101 SET character_set_client = @saved_cs_client */;
950
951--
952-- Dumping data for table `stm_TC_Procedure`
953--
954
955LOCK TABLES `stm_TC_Procedure` WRITE;
956/*!40000 ALTER TABLE `stm_TC_Procedure` DISABLE KEYS */;
957/*!40000 ALTER TABLE `stm_TC_Procedure` ENABLE KEYS */;
958UNLOCK TABLES;
959
960--
961-- Table structure for table `stm_TC_ProcedureCommand`
962--
963
964DROP TABLE IF EXISTS `stm_TC_ProcedureCommand`;
965/*!40101 SET @saved_cs_client = @@character_set_client */;
966/*!40101 SET character_set_client = utf8 */;
967CREATE TABLE `stm_TC_ProcedureCommand` (
968 `keyTCProcedureCommand` int(10) unsigned NOT NULL AUTO_INCREMENT,
969 `keyTCProcedure` int(10) unsigned NOT NULL,
970 `CommandID` int(10) unsigned NOT NULL,
971 `CommandString` mediumtext NOT NULL,
972 `ForceTransmission` tinyint(1) unsigned NOT NULL DEFAULT 0,
973 PRIMARY KEY (`keyTCProcedureCommand`),
974 KEY `TCProcedureCommand_TCProcedure` (`keyTCProcedure`),
975 CONSTRAINT `ProcedureCommand_Procedure` FOREIGN KEY (`keyTCProcedure`) REFERENCES `stm_TC_Procedure` (`keyTCProcedure`) ON DELETE CASCADE ON UPDATE CASCADE
976) ENGINE=InnoDB DEFAULT CHARSET=latin1;
977/*!40101 SET character_set_client = @saved_cs_client */;
978
979--
980-- Dumping data for table `stm_TC_ProcedureCommand`
981--
982
983LOCK TABLES `stm_TC_ProcedureCommand` WRITE;
984/*!40000 ALTER TABLE `stm_TC_ProcedureCommand` DISABLE KEYS */;
985/*!40000 ALTER TABLE `stm_TC_ProcedureCommand` ENABLE KEYS */;
986UNLOCK TABLES;
987
988--
989-- Table structure for table `stm_TNC`
990--
991
992DROP TABLE IF EXISTS `stm_TNC`;
993/*!40101 SET @saved_cs_client = @@character_set_client */;
994/*!40101 SET character_set_client = utf8 */;
995CREATE TABLE `stm_TNC` (
996 `keyTNC` int(10) unsigned NOT NULL AUTO_INCREMENT,
997 `Name` varchar(50) NOT NULL,
998 `ErrorDetectionRoutine` enum('','MobiTex') DEFAULT '',
999 PRIMARY KEY (`keyTNC`)
1000) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
1001/*!40101 SET character_set_client = @saved_cs_client */;
1002
1003--
1004-- Dumping data for table `stm_TNC`
1005--
1006
1007LOCK TABLES `stm_TNC` WRITE;
1008/*!40000 ALTER TABLE `stm_TNC` DISABLE KEYS */;
1009INSERT INTO `stm_TNC` VALUES
1010 (7,'Tbx20Egse','MobiTex');
1011/*!40000 ALTER TABLE `stm_TNC` ENABLE KEYS */;
1012UNLOCK TABLES;
1013
1014--
1015-- Table structure for table `stm_anomalies`
1016--
1017
1018DROP TABLE IF EXISTS `stm_anomalies`;
1019/*!40101 SET @saved_cs_client = @@character_set_client */;
1020/*!40101 SET character_set_client = utf8 */;
1021CREATE TABLE `stm_anomalies` (
1022 `keyAnomalies` int(10) unsigned NOT NULL AUTO_INCREMENT,
1023 `Name` varchar(50) NOT NULL,
1024 `AnomalyId` int(11) NOT NULL,
1025 `Critical` tinyint(1) NOT NULL DEFAULT 0,
1026 `Comment` varchar(200) NOT NULL,
1027 PRIMARY KEY (`keyAnomalies`),
1028 UNIQUE KEY `UNIQUE_AnomalyId` (`AnomalyId`)
1029) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1 COMMENT='lists all the anomalies that exist';
1030/*!40101 SET character_set_client = @saved_cs_client */;
1031
1032--
1033-- Dumping data for table `stm_anomalies`
1034--
1035
1036LOCK TABLES `stm_anomalies` WRITE;
1037/*!40000 ALTER TABLE `stm_anomalies` DISABLE KEYS */;
1038INSERT INTO `stm_anomalies` VALUES
1039 (0,'NO_ANOMALY',0,0,'no anomaly - all is well'),
1040 (1,'GLB_BAD_PARAM',1,0,''),
1041 (2,'GLB_BAD_TCC',2,0,''),
1042 (7,'WAT_TIMINGERR',7,0,''),
1043 (8,'WAT_WOULD_RESET_NODE',8,0,''),
1044 (9,'WAT_TABLE_OVERFLOW',9,0,''),
1045 (14,'TMM_BUS_HIST_FIFO_FULL',14,0,''),
1046 (15,'TMM_PLD_HIST_FIFO_FULL',15,0,''),
1047 (16,'TMM_STD_TM_FIFO_FULL',16,0,''),
1048 (17,'TMM_RT_TM_FIFO_FULL',17,0,''),
1049 (18,'TMM_BUS_HIST_FLASH_FULL',18,0,''),
1050 (19,'TMM_PLD_HIST_FLASH_FULL',19,0,''),
1051 (22,'GLB_FIFO_FULL',22,0,''),
1052 (23,'GLB_SYNC_FIFO_FULL',23,0,''),
1053 (25,'TMM_DIA_HIST_FIFO_FULL',25,0,''),
1054 (26,'TMM_DIA_HIST_FLASH_FULL',26,0,''),
1055 (35,'TMM_BUS_HIST_RESET',35,0,''),
1056 (36,'TMM_PLD_HIST_RESET',36,0,''),
1057 (37,'TMM_DIA_HIST_RESET',37,0,''),
1058 (48,'RBE_PCDHCONFIG_BUSY',48,0,''),
1059 (67,'UNEXPECTED_BOOT_OBC',67,0,''),
1060 (80,'TMM_SD1_INIT_FAILED',49,0,''),
1061 (81,'TMM_SD2_INIT_FAILED',50,0,''),
1062 (99,'ANM_BAD_ANOMALY_INDEX',99,0,'');
1063/*!40000 ALTER TABLE `stm_anomalies` ENABLE KEYS */;
1064UNLOCK TABLES;
1065
1066--
1067-- Table structure for table `stm_applications`
1068--
1069
1070DROP TABLE IF EXISTS `stm_applications`;
1071/*!40101 SET @saved_cs_client = @@character_set_client */;
1072/*!40101 SET character_set_client = utf8 */;
1073CREATE TABLE `stm_applications` (
1074 `keyApplications` int(10) unsigned NOT NULL AUTO_INCREMENT,
1075 `Name` varchar(45) NOT NULL,
1076 `ShortName` varchar(3) NOT NULL,
1077 `ID` int(10) unsigned NOT NULL,
1078 `comment` varchar(200) DEFAULT NULL,
1079 `description` varchar(200) DEFAULT NULL,
1080 PRIMARY KEY (`keyApplications`),
1081 UNIQUE KEY `UNIQUE_ShortName` (`ShortName`),
1082 UNIQUE KEY `UNIQUE_ID` (`ID`)
1083) ENGINE=InnoDB AUTO_INCREMENT=905 DEFAULT CHARSET=latin1 COMMENT='List of APPLICATIONS';
1084/*!40101 SET character_set_client = @saved_cs_client */;
1085
1086--
1087-- Dumping data for table `stm_applications`
1088--
1089
1090LOCK TABLES `stm_applications` WRITE;
1091/*!40000 ALTER TABLE `stm_applications` DISABLE KEYS */;
1092INSERT INTO `stm_applications` VALUES
1093 (1,'GLOBAL','GLB',1,'GLB - Every application','common commands implemented in every application'),
1094 (2,'NODEINFOS','NOI',2,'GLB - Node Infos','supplies node specific information'),
1095 (3,'WATCHDOG','WAT',3,'GLB - Watchdog','supervises node applications and handles \"I am alive\" messages'),
1096 (4,'TIMEMANAGER','TIM',4,'GLB - Time Manager','handles time and synchronisation'),
1097 (5,'HOUSEKEEPER','HKE',5,'GLB - Housekeeper','manages standard telemetry on the four main nodes (OBC, EPS, COM, AOCS)'),
1098 (6,'COMMANDER','CMD',6,'GLB - Commander','handles incoming telecommands'),
1099 (10,'TMMANAGER','TMM',10,'OBC - Telemetry Manager','manages onbord telemetry and downlink data'),
1100 (11,'OBC','OBC',11,'OBC - Control various things','Mainly just turn an LED on or off'),
1101 (12,'RBE','RBE',12,'RBE - Control various things','Mainly just LED things'),
1102 (13,'EPS','EPS',13,'EPS - Electronic Power Subsystem','manages FFU power modes'),
1103 (14,'PFDAPUMP','FDA',14,'FAP - Fluid Dynamic Actuator Pump control','Controls pFDA pump parameters'),
1104 (15,'ROCKETSIGNALS','RSG',15,'RSG - Rocketsignal interface','Application that polls the signal lines from the RXSM and configures the FFU when they are received'),
1105 (16,'LED','LED',16,'LED - Control the LED','controls the debug led on each board'),
1106 (17,'PFDAMANAGER','PFM',17,'PFM - pFDA manager','Application to synchronously send commands and requests for telemetry to all four pFDAs'),
1107 (901,'STDTM OBC','STO',901,'OBC - Standard TM','\"virtual\" application to manage standard Telemetry of OBC'),
1108 (902,'STDTM_RBE','STR',902,'RBE - Standard TM','\"virtual\" application to manage standard Telemetry of RBE'),
1109 (903,'STDTM_EPS','STE',903,'EPS - Standard TM','\"virtual\" application to manage standard Telemetry of EPS'),
1110 (904,'STDTM_PFDA','STP',904,'FDA - Standard TM','\"virtual\" application to manage standard Telemetry of pFDAs');
1111/*!40000 ALTER TABLE `stm_applications` ENABLE KEYS */;
1112UNLOCK TABLES;
1113
1114--
1115-- Table structure for table `stm_apps2nodes`
1116--
1117
1118DROP TABLE IF EXISTS `stm_apps2nodes`;
1119/*!40101 SET @saved_cs_client = @@character_set_client */;
1120/*!40101 SET character_set_client = utf8 */;
1121CREATE TABLE `stm_apps2nodes` (
1122 `keyApps2Nodes` int(10) unsigned NOT NULL AUTO_INCREMENT,
1123 `keyNode` int(10) unsigned NOT NULL,
1124 `keyApp` int(10) unsigned NOT NULL,
1125 PRIMARY KEY (`keyApps2Nodes`),
1126 UNIQUE KEY `UNIQUE_app2node_combination` (`keyNode`,`keyApp`),
1127 KEY `keyNode` (`keyNode`),
1128 KEY `keyApp` (`keyApp`),
1129 CONSTRAINT `Apps2Nodes_keyApp` FOREIGN KEY (`keyApp`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE,
1130 CONSTRAINT `Apps2Nodes_keyNode` FOREIGN KEY (`keyNode`) REFERENCES `stm_logic_nodes` (`keyLogicNode`) ON DELETE NO ACTION ON UPDATE CASCADE
1131) ENGINE=InnoDB AUTO_INCREMENT=8905 DEFAULT CHARSET=latin1 COMMENT='Map APPLICATIONS to NODES';
1132/*!40101 SET character_set_client = @saved_cs_client */;
1133
1134--
1135-- Dumping data for table `stm_apps2nodes`
1136--
1137
1138LOCK TABLES `stm_apps2nodes` WRITE;
1139/*!40000 ALTER TABLE `stm_apps2nodes` DISABLE KEYS */;
1140INSERT INTO `stm_apps2nodes` VALUES
1141 (1001,1,1),
1142 (1002,1,2),
1143 (1003,1,3),
1144 (1004,1,4),
1145 (1005,1,5),
1146 (1006,1,6),
1147 (2001,2,1),
1148 (2002,2,2),
1149 (2003,2,3),
1150 (2004,2,4),
1151 (2005,2,5),
1152 (2006,2,6),
1153 (2010,2,10),
1154 (2011,2,11),
1155 (2016,2,16),
1156 (2017,2,17),
1157 (2901,2,901),
1158 (3001,3,1),
1159 (3002,3,2),
1160 (3003,3,3),
1161 (3004,3,4),
1162 (3005,3,5),
1163 (3006,3,6),
1164 (3010,3,10),
1165 (3012,3,12),
1166 (3015,3,15),
1167 (3016,3,16),
1168 (3902,3,902),
1169 (4001,4,1),
1170 (4002,4,2),
1171 (4003,4,3),
1172 (4004,4,4),
1173 (4005,4,5),
1174 (4006,4,6),
1175 (4013,4,13),
1176 (4016,4,16),
1177 (4903,4,903),
1178 (5001,5,1),
1179 (5002,5,2),
1180 (5003,5,3),
1181 (5004,5,4),
1182 (5005,5,5),
1183 (5006,5,6),
1184 (5014,5,14),
1185 (5904,5,904),
1186 (6001,6,1),
1187 (6002,6,2),
1188 (6003,6,3),
1189 (6004,6,4),
1190 (6005,6,5),
1191 (6006,6,6),
1192 (6014,6,14),
1193 (6904,6,904),
1194 (7001,7,1),
1195 (7002,7,2),
1196 (7003,7,3),
1197 (7004,7,4),
1198 (7005,7,5),
1199 (7006,7,6),
1200 (7014,7,14),
1201 (7904,7,904),
1202 (8001,8,1),
1203 (8002,8,2),
1204 (8003,8,3),
1205 (8004,8,4),
1206 (8005,8,5),
1207 (8006,8,6),
1208 (8014,8,14),
1209 (8904,8,904);
1210/*!40000 ALTER TABLE `stm_apps2nodes` ENABLE KEYS */;
1211UNLOCK TABLES;
1212
1213--
1214-- Table structure for table `stm_logic_nodes`
1215--
1216
1217DROP TABLE IF EXISTS `stm_logic_nodes`;
1218/*!40101 SET @saved_cs_client = @@character_set_client */;
1219/*!40101 SET character_set_client = utf8 */;
1220CREATE TABLE `stm_logic_nodes` (
1221 `keyLogicNode` int(10) unsigned NOT NULL,
1222 `Name` varchar(16) NOT NULL,
1223 `ShortName` varchar(3) NOT NULL,
1224 `Node_Id` smallint(5) unsigned NOT NULL,
1225 `is_redundant` tinyint(1) DEFAULT 0,
1226 `comment` varchar(200) DEFAULT NULL,
1227 PRIMARY KEY (`keyLogicNode`),
1228 UNIQUE KEY `UNIQUE_Node_Id` (`Node_Id`)
1229) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of LOGIC NODES';
1230/*!40101 SET character_set_client = @saved_cs_client */;
1231
1232--
1233-- Dumping data for table `stm_logic_nodes`
1234--
1235
1236LOCK TABLES `stm_logic_nodes` WRITE;
1237/*!40000 ALTER TABLE `stm_logic_nodes` DISABLE KEYS */;
1238INSERT INTO `stm_logic_nodes` VALUES
1239 (1,'GLOBAL','GLB',128,1,'All active Nodes'),
1240 (2,'OBC','OBC',4,0,'On-Bord Computer Node'),
1241 (3,'RBE','RBE',2,0,'Rocket Bourne Equipment'),
1242 (4,'EPS','EPS',0,0,'Electronic Power Subsystem'),
1243 (5,'PFDA1','FA1',6,0,'pFDA on side 1 of FFU'),
1244 (6,'PFDA2','FA2',8,0,'pFDA on side 2 of FFU'),
1245 (7,'PFDA3','FA3',10,0,'pFDA on side 3 of FFU'),
1246 (8,'PFDA4','FA4',12,0,'pFDA on side 4 of FFU');
1247/*!40000 ALTER TABLE `stm_logic_nodes` ENABLE KEYS */;
1248UNLOCK TABLES;
1249
1250--
1251-- Table structure for table `stm_tc_ht_providers`
1252--
1253
1254DROP TABLE IF EXISTS `stm_tc_ht_providers`;
1255/*!40101 SET @saved_cs_client = @@character_set_client */;
1256/*!40101 SET character_set_client = utf8 */;
1257CREATE TABLE `stm_tc_ht_providers` (
1258 `keyHTProvider` int(10) unsigned NOT NULL AUTO_INCREMENT,
1259 `Name` varchar(45) NOT NULL,
1260 `ID` int(10) unsigned NOT NULL,
1261 `comment` varchar(200) DEFAULT NULL,
1262 PRIMARY KEY (`keyHTProvider`),
1263 UNIQUE KEY `UNIQUE_Bit_Num` (`ID`),
1264 UNIQUE KEY `UNIQUE_Name` (`Name`)
1265) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT COMMENT='Bitmap of EPS Switches';
1266/*!40101 SET character_set_client = @saved_cs_client */;
1267
1268--
1269-- Dumping data for table `stm_tc_ht_providers`
1270--
1271
1272LOCK TABLES `stm_tc_ht_providers` WRITE;
1273/*!40000 ALTER TABLE `stm_tc_ht_providers` DISABLE KEYS */;
1274INSERT INTO `stm_tc_ht_providers` VALUES
1275 (1,'I2CMasterDriverRODOSAdapter',0,'An adapter driver for RODOS based I2C masters'),
1276 (2,'I2CSwitchDriverPCA9543',1,'Driver for the I2C switch series PCA9543A/B/C from NXP'),
1277 (3,'I2CSwitchDriverParallel',2,'Driver which allows to use I2C switches connected in parallel as a single large switch'),
1278 (4,'I2CMasterDriverSwitchChannel',3,'Driver which makes an I2C switch downstream bus available as an I2C bus master'),
1279 (5,'A3G4250DDriver',4,'Driver for the A3G4250D ST microelectronics MEMS Gyro with internal temperature sensor'),
1280 (6,'MAX21000Driver',5,'Driver for the MAX21000 Maxim Integrated MEMS Gyro with internal temperature sensor'),
1281 (7,'HMC5983Driver',6,'Driver for the HMC5983 Honeywell Magnetometer IC with internal temperature sensor'),
1282 (8,'LIS3MDLDriver',7,'Driver for the LIS3MDL ST microelectronics Magnetometer IC with internal temperature sensor'),
1283 (9,'TUBSSUDriver',8,'Driver for the TUBSSU TU Berlin Sun sensor with internal temperature sensor'),
1284 (10,'INA219Driver',9,'Driver for the INA219 Texas Instruments current/voltage sensor'),
1285 (11,'TMP175Driver',10,'Driver for the TMP175 Texas Instruments temperature sensor'),
1286 (12,'DRV8830Driver',11,'Driver for the DRV8830 Texas Instruments motor driver'),
1287 (13,'BufferLastSampleSink',12,'A Sink which bufferes the last sample'),
1288 (14,'SpiMasterDriverStm32',13,'Driver for the on-chip SPI peripheral of the STM32F4 series MCU'),
1289 (15,'DifferentialTriggerStm32',14,'A trigger with differential signals for the STM32F4 controller'),
1290 (16,'TriggerChannel',15,'A channel for a trigger'),
1291 (17,'MUFORS6UCDriver',16,'Driver for the MuFors-6UC LITEF fiber optic rate sensor'),
1292 (18,'AngularRateSinkKalman',17,'AngularRateSink with Kalman filter'),
1293 (19,'AngularRate1Dto3D',18,'An adapter which forms one AngularRateInterface from three AngularRate1DInterface'),
1294 (20,'AngularRate1DSinkKalman',19,'AngularRate1DSink with Kalman filter'),
1295 (21,'VectorVoterAverage',20,'A generic provider which calculates the average of several vector inputs'),
1296 (22,'BiasScaleCorrection',21,'A generic provider which corrects bias and scale factor errors'),
1297 (23,'BiasScaleMisalignmentCorrection',22,'A generic provider which corrects bias, scale factor and misalignment errors'),
1298 (24,'InterruptDriverStm32Ext',23,'Driver for external GPIO interrupts of the STM32F4 series MCU'),
1299 (25,'RodosCommBufferProvider',24,'A state quantity provider with internal RODOS::CommBuffer'),
1300 (26,'ControlCycleStart',25,'A time provider for the beginning of the AOCS control cylce'),
1301 (27,'ControlCycleEnd',26,'A time provider for the end of the AOCS control cylce'),
1302 (28,'Sgp4',27,'SGP4 orbit propagation'),
1303 (29,'Igrf',28,'International Geomagnetic Reference Field (IGRF)'),
1304 (30,'Slpc',29,'Sun low-precision coordinates (SLPC)'),
1305 (31,'EclipseBasic',30,'A basic eclipse model'),
1306 (32,'AppliedTorque',31,'Calculate the applied torque from applied magnetic dipole and reaction wheel angular momentum derivative'),
1307 (33,'Quest',32,'Quaternion estimator: attitude estimation algorithm'),
1308 (34,'AttitudePrediction',33,'Predict the attitude for the end of the control cycle'),
1309 (35,'VectorPrediction',34,'Predict a body-fixed vector for the end of the control cycle'),
1310 (36,'AngularRatePrediction',35,'Predict the body-fixed angular rate for the end of the control cycle'),
1311 (37,'StateDeterminationBasic',36,'State provider to provide a set of all state quantities and perform FDIR checks'),
1312 (38,'StateDeterminationMemory',37,'State provider which stores a set of add state quantities for the next control cycle'),
1313 (39,'StateDeterminationVoter',38,'State provider which votes between different state provider instances'),
1314 (40,'ControlDampingBDot',39,'Damping Mode (DPM) with B-dot control law'),
1315 (41,'ControlDampingCrossProduct',40,'Damping Mode (DPM) with cross-product control law'),
1316 (42,'ControlErrorNadirPointing',41,'Provider to calculate the control error in state space for nadir pointing'),
1317 (43,'ControlErrorTargetPointing',42,'Provider to calculate the control error in state space for target pointing'),
1318 (44,'ControlTorqueDeterminationStateSpace',43,'Provider to calculate the control torque with state space control law'),
1319 (45,'ControlTorqueDeterminationPD',44,'Provider to calculate the control torque with quaternion feedback control law'),
1320 (46,'ControlTorqueDistributionMts',45,'Provider to distribute the control torque on 3 magnetic torquers'),
1321 (47,'ControlTorqueDistributionRws4D',46,'Provider to distribute the control torque on 4 reaction wheels'),
1322 (48,'DesaturationRws4DMts',47,'Provider to desaturate 4 reaction wheels with magnetic torquers');
1323/*!40000 ALTER TABLE `stm_tc_ht_providers` ENABLE KEYS */;
1324UNLOCK TABLES;
1325
1326--
1327-- Table structure for table `stm_tc_switchconfig`
1328--
1329
1330DROP TABLE IF EXISTS `stm_tc_switchconfig`;
1331/*!40101 SET @saved_cs_client = @@character_set_client */;
1332/*!40101 SET character_set_client = utf8 */;
1333CREATE TABLE `stm_tc_switchconfig` (
1334 `keyTCSwitchConfig` int(10) unsigned NOT NULL AUTO_INCREMENT,
1335 `Name` varchar(45) NOT NULL,
1336 `Bit_Num` int(10) unsigned NOT NULL,
1337 `comment` varchar(200) DEFAULT NULL,
1338 PRIMARY KEY (`keyTCSwitchConfig`),
1339 UNIQUE KEY `UNIQUE_Bit_Num` (`Bit_Num`),
1340 UNIQUE KEY `UNIQUE_Name` (`Name`)
1341) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Bitmap of EPS Switches';
1342/*!40101 SET character_set_client = @saved_cs_client */;
1343
1344--
1345-- Dumping data for table `stm_tc_switchconfig`
1346--
1347
1348LOCK TABLES `stm_tc_switchconfig` WRITE;
1349/*!40000 ALTER TABLE `stm_tc_switchconfig` DISABLE KEYS */;
1350/*!40000 ALTER TABLE `stm_tc_switchconfig` ENABLE KEYS */;
1351UNLOCK TABLES;
1352
1353--
1354-- Table structure for table `stm_tm_combination`
1355--
1356
1357DROP TABLE IF EXISTS `stm_tm_combination`;
1358/*!40101 SET @saved_cs_client = @@character_set_client */;
1359/*!40101 SET character_set_client = utf8 */;
1360CREATE TABLE `stm_tm_combination` (
1361 `keyTMCombination` int(10) unsigned NOT NULL AUTO_INCREMENT,
1362 `keyTMSourcePacket` int(10) unsigned NOT NULL,
1363 `keyTMParam` int(10) unsigned NOT NULL,
1364 `keyTMCombinationFormula` int(10) unsigned NOT NULL,
1365 PRIMARY KEY (`keyTMCombination`),
1366 KEY `keyTMParam` (`keyTMParam`),
1367 KEY `keyTMCombinationFormula` (`keyTMCombinationFormula`),
1368 KEY `keyTMSourcePacket` (`keyTMSourcePacket`),
1369 CONSTRAINT `TMCombination_TMCombinationFormula` FOREIGN KEY (`keyTMCombinationFormula`) REFERENCES `stm_tm_combinationformula` (`keyTMCombinationFormula`) ON UPDATE CASCADE,
1370 CONSTRAINT `TMCombination_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE,
1371 CONSTRAINT `TMCombination_TMSourcePacket` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON UPDATE CASCADE
1372) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1373/*!40101 SET character_set_client = @saved_cs_client */;
1374
1375--
1376-- Dumping data for table `stm_tm_combination`
1377--
1378
1379LOCK TABLES `stm_tm_combination` WRITE;
1380/*!40000 ALTER TABLE `stm_tm_combination` DISABLE KEYS */;
1381/*!40000 ALTER TABLE `stm_tm_combination` ENABLE KEYS */;
1382UNLOCK TABLES;
1383
1384--
1385-- Table structure for table `stm_tm_combinationformula`
1386--
1387
1388DROP TABLE IF EXISTS `stm_tm_combinationformula`;
1389/*!40101 SET @saved_cs_client = @@character_set_client */;
1390/*!40101 SET character_set_client = utf8 */;
1391CREATE TABLE `stm_tm_combinationformula` (
1392 `keyTMCombinationFormula` int(10) unsigned NOT NULL AUTO_INCREMENT,
1393 `Formula` varchar(1000) NOT NULL,
1394 PRIMARY KEY (`keyTMCombinationFormula`)
1395) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1396/*!40101 SET character_set_client = @saved_cs_client */;
1397
1398--
1399-- Dumping data for table `stm_tm_combinationformula`
1400--
1401
1402LOCK TABLES `stm_tm_combinationformula` WRITE;
1403/*!40000 ALTER TABLE `stm_tm_combinationformula` DISABLE KEYS */;
1404/*!40000 ALTER TABLE `stm_tm_combinationformula` ENABLE KEYS */;
1405UNLOCK TABLES;
1406
1407--
1408-- Table structure for table `stm_tm_combinationparameter`
1409--
1410
1411DROP TABLE IF EXISTS `stm_tm_combinationparameter`;
1412/*!40101 SET @saved_cs_client = @@character_set_client */;
1413/*!40101 SET character_set_client = utf8 */;
1414CREATE TABLE `stm_tm_combinationparameter` (
1415 `keyTMCombinationFormula` int(10) unsigned NOT NULL,
1416 `keyTMParam` int(10) unsigned NOT NULL,
1417 `ParamOrder` int(10) unsigned NOT NULL,
1418 UNIQUE KEY `UNIQUE` (`keyTMCombinationFormula`,`keyTMParam`,`ParamOrder`),
1419 KEY `keyTMParam` (`keyTMParam`),
1420 KEY `keyTMCombinationFormula` (`keyTMCombinationFormula`),
1421 CONSTRAINT `TMCombinationParameter_TMCombinationFormula` FOREIGN KEY (`keyTMCombinationFormula`) REFERENCES `stm_tm_combinationformula` (`keyTMCombinationFormula`) ON UPDATE CASCADE,
1422 CONSTRAINT `TMCombinationParameter_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON UPDATE CASCADE
1423) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1424/*!40101 SET character_set_client = @saved_cs_client */;
1425
1426--
1427-- Dumping data for table `stm_tm_combinationparameter`
1428--
1429
1430LOCK TABLES `stm_tm_combinationparameter` WRITE;
1431/*!40000 ALTER TABLE `stm_tm_combinationparameter` DISABLE KEYS */;
1432/*!40000 ALTER TABLE `stm_tm_combinationparameter` ENABLE KEYS */;
1433UNLOCK TABLES;
1434
1435--
1436-- Table structure for table `stm_tm_param`
1437--
1438
1439DROP TABLE IF EXISTS `stm_tm_param`;
1440/*!40101 SET @saved_cs_client = @@character_set_client */;
1441/*!40101 SET character_set_client = utf8 */;
1442CREATE TABLE `stm_tm_param` (
1443 `keyTMParam` int(10) unsigned NOT NULL AUTO_INCREMENT,
1444 `keySubSystem` int(10) unsigned NOT NULL,
1445 `keyTMParamConversion` int(10) unsigned NOT NULL,
1446 `Name` varchar(15) NOT NULL,
1447 `Description` varchar(60) NOT NULL,
1448 `ToolTip` varchar(255) DEFAULT NULL,
1449 `Unit` varchar(10) DEFAULT NULL,
1450 `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',
1451 `ParamFormat` enum('Parameter','Placeholder','Combination','VcID','ApID','OnBoardTime','ObcUpTime','Image','ErrorMarker') NOT NULL DEFAULT 'Parameter',
1452 `SoftMin` float NOT NULL DEFAULT 0,
1453 `SoftMax` float NOT NULL DEFAULT 0,
1454 `HardMin` float NOT NULL DEFAULT 0,
1455 `HardMax` float NOT NULL DEFAULT 0,
1456 `Interpretation` varchar(3000) DEFAULT NULL,
1457 `DecimalCnt` tinyint(3) unsigned NOT NULL DEFAULT 0,
1458 `BitLength` int(10) unsigned NOT NULL,
1459 `ParamDependency` varchar(20) DEFAULT NULL,
1460 `Resolution` varchar(50) DEFAULT NULL COMMENT '[optional] a value describing the resolution of a TM-Parameter',
1461 PRIMARY KEY (`keyTMParam`),
1462 KEY `keySubSystem` (`keySubSystem`),
1463 KEY `keyTMParamType` (`keyTMParamConversion`),
1464 CONSTRAINT `TMParam_SubSystem` FOREIGN KEY (`keySubSystem`) REFERENCES `stm_tm_subsystem` (`keySubSystem`) ON DELETE NO ACTION ON UPDATE CASCADE,
1465 CONSTRAINT `TMParam_TMParamConversion` FOREIGN KEY (`keyTMParamConversion`) REFERENCES `stm_tm_paramconversion` (`keyTMParamConversion`) ON DELETE NO ACTION ON UPDATE CASCADE
1466) 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)';
1467/*!40101 SET character_set_client = @saved_cs_client */;
1468
1469--
1470-- Dumping data for table `stm_tm_param`
1471--
1472
1473LOCK TABLES `stm_tm_param` WRITE;
1474/*!40000 ALTER TABLE `stm_tm_param` DISABLE KEYS */;
1475INSERT INTO `stm_tm_param` VALUES
1476 (1,1,1,'res_1_bit','reserved 1 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,1,NULL,NULL),
1477 (2,1,1,'res_2_bit','reserved 2 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,2,NULL,NULL),
1478 (3,1,1,'res_3_bit','reserved 3 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,3,NULL,NULL),
1479 (4,1,1,'res_4_bit','reserved 4 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,4,NULL,NULL),
1480 (5,1,1,'res_5_bit','reserved 5 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,5,NULL,NULL),
1481 (6,1,1,'res_6_bit','reserved 6 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,6,NULL,NULL),
1482 (7,1,1,'res_7_bit','reserved 7 bit',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,7,NULL,NULL),
1483 (8,1,1,'res_1_byte','reserved 1 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,8,NULL,NULL),
1484 (9,1,1,'res_2_byte','reserved 2 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,16,NULL,NULL),
1485 (10,1,1,'res_3_byte','reserved 3 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,24,NULL,NULL),
1486 (11,1,1,'res_4_byte','reserved 4 byte',NULL,NULL,'Unsigned Int','Placeholder',0,0,0,0,NULL,0,32,NULL,NULL),
1487 (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),
1488 (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),
1489 (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),
1490 (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),
1491 (20004,1,1,'TMPINT','MCU Temperature','internal temperature of node-MCU','°C','Signed Int','Parameter',-10,40,-20,60,NULL,0,8,NULL,NULL),
1492 (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),
1493 (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),
1494 (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),
1495 (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),
1496 (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),
1497 (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),
1498 (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),
1499 (20012,1,1,'RSTSTS','Reset Status','the reset status register contents',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1500 (20013,1,1,'NODENO','Node No.','redundant node number',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,1,NULL,NULL),
1501 (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),
1502 (40001,1,1,'TIMLOC','Uptime [local]','current uptime since last reboot','s','Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1503 (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),
1504 (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),
1505 (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),
1506 (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),
1507 (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),
1508 (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),
1509 (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),
1510 (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),
1511 (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),
1512 (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),
1513 (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),
1514 (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),
1515 (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),
1516 (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),
1517 (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),
1518 (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),
1519 (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),
1520 (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),
1521 (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),
1522 (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),
1523 (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),
1524 (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),
1525 (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),
1526 (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),
1527 (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),
1528 (102020,1,1,'STRING','a string message',NULL,NULL,'String','Parameter',0,0,0,0,NULL,0,640,NULL,NULL),
1529 (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),
1530 (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),
1531 (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),
1532 (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),
1533 (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),
1534 (115001,8,1,'ANOMLYCNT','ANOMALY COUNT','total count of anomalies registered',NULL,'Unsigned Int','Parameter',0,0,0,0,NULL,0,32,NULL,NULL),
1535 (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),
1536 (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),
1537 (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),
1538 (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),
1539 (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),
1540 (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),
1541 (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),
1542 (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),
1543 (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),
1544 (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),
1545 (120008,1,81,'EPS12VCUR','EPS 12V Current draw','EPS 12V Current draw','mA','Signed Int','Parameter',0,100,0,200,NULL,1,16,NULL,''),
1546 (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),
1547 (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),
1548 (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),
1549 (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),
1550 (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),
1551 (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),
1552 (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),
1553 (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),
1554 (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),
1555 (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),
1556 (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),
1557 (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),
1558 (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),
1559 (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),
1560 (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),
1561 (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),
1562 (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),
1563 (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),
1564 (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),
1565 (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),
1566 (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),
1567 (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),
1568 (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),
1569 (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),
1570 (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),
1571 (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),
1572 (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),
1573 (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),
1574 (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),
1575 (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),
1576 (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),
1577 (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),
1578 (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),
1579 (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),
1580 (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),
1581 (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),
1582 (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),
1583 (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),
1584 (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),
1585 (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),
1586 (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),
1587 (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),
1588 (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),
1589 (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),
1590 (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),
1591 (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),
1592 (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),
1593 (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),
1594 (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),
1595 (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),
1596 (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),
1597 (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),
1598 (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),
1599 (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),
1600 (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),
1601 (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),
1602 (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),
1603 (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),
1604 (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),
1605 (190001,1,1,'PARTID','Part ID','Part ID the HealthTree is created from',NULL,'Unsigned Int','Parameter',0,0,0,0,'',0,16,'',NULL),
1606 (190002,1,1,'HEALTHTREE','Raw HealthTree','Raw HealthTree','[hex]','String','Parameter',0,0,0,0,'',0,2040,'',NULL),
1607 (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),
1608 (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),
1609 (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),
1610 (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),
1611 (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),
1612 (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),
1613 (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),
1614 (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),
1615 (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),
1616 (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),
1617 (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),
1618 (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),
1619 (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),
1620 (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),
1621 (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),
1622 (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),
1623 (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),
1624 (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,'',''),
1625 (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),
1626 (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),
1627 (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),
1628 (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),
1629 (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),
1630 (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),
1631 (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),
1632 (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),
1633 (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);
1634/*!40000 ALTER TABLE `stm_tm_param` ENABLE KEYS */;
1635UNLOCK TABLES;
1636
1637--
1638-- Table structure for table `stm_tm_param2sourcepacket`
1639--
1640
1641DROP TABLE IF EXISTS `stm_tm_param2sourcepacket`;
1642/*!40101 SET @saved_cs_client = @@character_set_client */;
1643/*!40101 SET character_set_client = utf8 */;
1644CREATE TABLE `stm_tm_param2sourcepacket` (
1645 `keyTMParam2SourcePacket` int(10) unsigned NOT NULL COMMENT 'rule for keys [xxx yyy zzz]: xxx = AppID; yyy = SourcePacketID; zzz = counter',
1646 `keyTMSourcePacket` int(10) unsigned NOT NULL,
1647 `keyTMParam` int(10) unsigned NOT NULL,
1648 `ParamOrder` int(10) unsigned NOT NULL,
1649 PRIMARY KEY (`keyTMParam2SourcePacket`),
1650 UNIQUE KEY `UNIQUE_sourcepacket2paramorder_combination` (`keyTMSourcePacket`,`ParamOrder`),
1651 KEY `TMSourcePacket_TMApid` (`keyTMSourcePacket`),
1652 KEY `TMSourcePacket_TMParam` (`keyTMParam`),
1653 CONSTRAINT `TMSourcePacket_TMApid` FOREIGN KEY (`keyTMSourcePacket`) REFERENCES `stm_tm_sourcepackets` (`keyTMSourcePacket`) ON DELETE CASCADE ON UPDATE CASCADE,
1654 CONSTRAINT `TMSourcePacket_TMParam` FOREIGN KEY (`keyTMParam`) REFERENCES `stm_tm_param` (`keyTMParam`) ON DELETE CASCADE ON UPDATE CASCADE
1655) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Map TELEMETRY PARAMETER to SOURCE PACKETS';
1656/*!40101 SET character_set_client = @saved_cs_client */;
1657
1658--
1659-- Dumping data for table `stm_tm_param2sourcepacket`
1660--
1661
1662LOCK TABLES `stm_tm_param2sourcepacket` WRITE;
1663/*!40000 ALTER TABLE `stm_tm_param2sourcepacket` DISABLE KEYS */;
1664INSERT INTO `stm_tm_param2sourcepacket` VALUES
1665 (100001,10,20013,1),
1666 (100002,10,30002,2),
1667 (100003,10,20001,3),
1668 (100004,10,40003,4),
1669 (100005,10,40004,5),
1670 (100006,10,700003,6),
1671 (100010,10,800001,10),
1672 (100011,10,800002,11),
1673 (100012,10,800003,12),
1674 (100013,10,800006,13),
1675 (100014,10,800007,14),
1676 (100015,10,3,15),
1677 (100016,10,800004,16),
1678 (100017,10,800005,17),
1679 (100018,10,800008,18),
1680 (100019,10,800009,19),
1681 (105001,105,105001,1),
1682 (105002,105,105002,2),
1683 (105003,105,6,3),
1684 (105009,105,105003,9),
1685 (105010,105,105004,10),
1686 (110001,11,20013,1),
1687 (110002,11,30002,2),
1688 (110003,11,20001,3),
1689 (110004,11,40003,4),
1690 (110005,11,40004,5),
1691 (110006,11,700003,6),
1692 (110010,11,200001,10),
1693 (110011,11,200002,11),
1694 (110012,11,200003,12),
1695 (110013,11,200004,13),
1696 (110014,11,200005,14),
1697 (110015,11,200006,15),
1698 (110016,11,200007,16),
1699 (110017,11,200008,17),
1700 (110018,11,200009,18),
1701 (110019,11,200010,19),
1702 (110020,11,200011,20),
1703 (110021,11,200012,21),
1704 (110022,11,200013,22),
1705 (110023,11,200014,23),
1706 (110024,11,11001,24),
1707 (110025,11,200016,25),
1708 (110026,11,200017,26),
1709 (110027,11,17001,27),
1710 (110028,11,200015,28),
1711 (110029,11,6,29),
1712 (110035,11,100001,35),
1713 (110036,11,100002,36),
1714 (110037,11,100015,37),
1715 (110038,11,100003,38),
1716 (110039,11,100004,39),
1717 (110040,11,100016,40),
1718 (110041,11,100009,41),
1719 (110042,11,100010,42),
1720 (110043,11,100019,43),
1721 (110044,11,100011,44),
1722 (110045,11,100012,45),
1723 (110046,11,100020,46),
1724 (110047,11,100013,47),
1725 (110048,11,100014,48),
1726 (110049,11,100033,49),
1727 (110050,11,100034,50),
1728 (110051,11,100035,51),
1729 (120001,12,20013,1),
1730 (120002,12,30002,2),
1731 (120003,12,20001,3),
1732 (120004,12,40003,4),
1733 (120005,12,40004,5),
1734 (120006,12,700003,6),
1735 (120010,12,120001,10),
1736 (120011,12,120002,11),
1737 (120012,12,120003,12),
1738 (120013,12,120004,13),
1739 (120014,12,120005,14),
1740 (120015,12,120006,15),
1741 (120016,12,120007,16),
1742 (120017,12,120008,17),
1743 (120018,12,120009,18),
1744 (120019,12,120010,19),
1745 (120020,12,120011,20),
1746 (120021,12,120012,21),
1747 (120022,12,120013,22),
1748 (120023,12,120014,23),
1749 (120024,12,120015,24),
1750 (120025,12,120016,25),
1751 (120026,12,120017,26),
1752 (120027,12,120018,27),
1753 (120028,12,120019,28),
1754 (120029,12,120020,29),
1755 (120030,12,120021,30),
1756 (120031,12,120022,31),
1757 (120032,12,120023,32),
1758 (120033,12,120024,33),
1759 (120034,12,120025,34),
1760 (120035,12,120026,35),
1761 (120036,12,120045,36),
1762 (120037,12,120046,37),
1763 (120038,12,4,38),
1764 (120042,12,120027,42),
1765 (120043,12,120028,43),
1766 (120044,12,120029,44),
1767 (120045,12,120030,45),
1768 (120046,12,120031,46),
1769 (120047,12,120032,47),
1770 (120048,12,120033,48),
1771 (120049,12,120034,49),
1772 (120050,12,120035,50),
1773 (120051,12,120036,51),
1774 (120052,12,120037,52),
1775 (120053,12,120038,53),
1776 (120054,12,120039,54),
1777 (120055,12,120040,55),
1778 (120056,12,120041,56),
1779 (120057,12,120042,57),
1780 (120058,12,120043,58),
1781 (120059,12,120044,59),
1782 (120060,12,120047,60),
1783 (120061,12,120048,61),
1784 (130001,13,20013,1),
1785 (130002,13,30002,2),
1786 (130003,13,20001,3),
1787 (130004,13,40003,4),
1788 (130005,13,40004,5),
1789 (130006,13,700003,6),
1790 (130010,13,130001,10),
1791 (130011,13,130002,11),
1792 (130012,13,130003,12),
1793 (130013,13,130004,13),
1794 (130014,13,130005,14),
1795 (130015,13,130006,15),
1796 (130016,13,130007,16),
1797 (130017,13,130008,17),
1798 (130018,13,130009,18),
1799 (130019,13,130010,19),
1800 (130020,13,130011,20),
1801 (130021,13,130012,21),
1802 (130022,13,130018,22),
1803 (130023,13,6,23),
1804 (130029,13,130013,29),
1805 (130030,13,130014,30),
1806 (130031,13,130015,31),
1807 (130032,13,130016,32),
1808 (130033,13,130017,33),
1809 (130034,13,130019,34),
1810 (990001,99,99001,1),
1811 (990002,99,99002,2),
1812 (990003,99,99003,3),
1813 (990004,99,99004,4),
1814 (990005,99,99005,5),
1815 (990006,99,99006,6),
1816 (1180001,118,20005,1),
1817 (1180002,118,20006,2),
1818 (1180003,118,20007,3),
1819 (1180004,118,20008,4),
1820 (1180005,118,20009,5),
1821 (1180006,118,20010,6),
1822 (1180007,118,20011,7),
1823 (1180008,118,20012,8),
1824 (1180009,118,20003,9),
1825 (1180010,118,40001,10),
1826 (1180011,118,20004,11),
1827 (1900001,190,190001,1),
1828 (1900002,190,190002,2),
1829 (102114001,114,102020,1);
1830/*!40000 ALTER TABLE `stm_tm_param2sourcepacket` ENABLE KEYS */;
1831UNLOCK TABLES;
1832
1833--
1834-- Table structure for table `stm_tm_paramconversion`
1835--
1836
1837DROP TABLE IF EXISTS `stm_tm_paramconversion`;
1838/*!40101 SET @saved_cs_client = @@character_set_client */;
1839/*!40101 SET character_set_client = utf8 */;
1840CREATE TABLE `stm_tm_paramconversion` (
1841 `keyTMParamConversion` int(10) unsigned NOT NULL AUTO_INCREMENT,
1842 `TypeName` varchar(20) NOT NULL,
1843 `PhysicalConversion` text DEFAULT NULL,
1844 `Numerator` text DEFAULT NULL,
1845 `Denominator` text DEFAULT NULL,
1846 PRIMARY KEY (`keyTMParamConversion`)
1847) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1 COMMENT='Table of CONVERSION FORMULAE for TELEMETRY PARAMETER';
1848/*!40101 SET character_set_client = @saved_cs_client */;
1849
1850--
1851-- Dumping data for table `stm_tm_paramconversion`
1852--
1853
1854LOCK TABLES `stm_tm_paramconversion` WRITE;
1855/*!40000 ALTER TABLE `stm_tm_paramconversion` DISABLE KEYS */;
1856INSERT INTO `stm_tm_paramconversion` VALUES
1857 (1,'none','1',NULL,NULL),
1858 (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),
1859 (81,'Div by 10','0.1',NULL,NULL),
1860 (82,'Div by 100','0.01',NULL,NULL);
1861/*!40000 ALTER TABLE `stm_tm_paramconversion` ENABLE KEYS */;
1862UNLOCK TABLES;
1863
1864--
1865-- Table structure for table `stm_tm_sourcepackets`
1866--
1867
1868DROP TABLE IF EXISTS `stm_tm_sourcepackets`;
1869/*!40101 SET @saved_cs_client = @@character_set_client */;
1870/*!40101 SET character_set_client = utf8 */;
1871CREATE TABLE `stm_tm_sourcepackets` (
1872 `keyTMSourcePacket` int(10) unsigned NOT NULL AUTO_INCREMENT,
1873 `keyApplication` int(10) unsigned NOT NULL,
1874 `Number` int(10) unsigned NOT NULL,
1875 `HeaderNumber` int(10) unsigned DEFAULT NULL,
1876 `Name` varchar(40) NOT NULL,
1877 `SaveApidHead` tinyint(1) unsigned NOT NULL DEFAULT 0,
1878 `ExtHkEnabled` tinyint(1) unsigned NOT NULL DEFAULT 0,
1879 PRIMARY KEY (`keyTMSourcePacket`),
1880 UNIQUE KEY `SPNumber` (`Number`),
1881 KEY `TMAPID_keyApp_idx` (`keyApplication`),
1882 CONSTRAINT `TMAPID_keyApp` FOREIGN KEY (`keyApplication`) REFERENCES `stm_applications` (`keyApplications`) ON DELETE NO ACTION ON UPDATE CASCADE
1883) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=latin1 COMMENT='List of SOURCE PACKETS';
1884/*!40101 SET character_set_client = @saved_cs_client */;
1885
1886--
1887-- Dumping data for table `stm_tm_sourcepackets`
1888--
1889
1890LOCK TABLES `stm_tm_sourcepackets` WRITE;
1891/*!40000 ALTER TABLE `stm_tm_sourcepackets` DISABLE KEYS */;
1892INSERT INTO `stm_tm_sourcepackets` VALUES
1893 (10,902,10,NULL,'StdTmRBE',0,1),
1894 (11,901,11,NULL,'StdTmOBC',0,1),
1895 (12,903,12,NULL,'StdTmEPS',0,1),
1896 (13,904,13,NULL,'StdTmPFDA',0,1),
1897 (99,1,99,NULL,'TMGateway',0,1),
1898 (105,10,105,NULL,'SDBlock',0,0),
1899 (114,1,114,NULL,'ExTmString',0,0),
1900 (118,2,118,NULL,'NodeInfos',0,1),
1901 (190,1,190,NULL,'TmHealthTree',0,0);
1902/*!40000 ALTER TABLE `stm_tm_sourcepackets` ENABLE KEYS */;
1903UNLOCK TABLES;
1904
1905--
1906-- Table structure for table `stm_tm_subsystem`
1907--
1908
1909DROP TABLE IF EXISTS `stm_tm_subsystem`;
1910/*!40101 SET @saved_cs_client = @@character_set_client */;
1911/*!40101 SET character_set_client = utf8 */;
1912CREATE TABLE `stm_tm_subsystem` (
1913 `keySubSystem` int(10) unsigned NOT NULL AUTO_INCREMENT,
1914 `Name` varchar(10) NOT NULL,
1915 `Description` varchar(60) NOT NULL,
1916 PRIMARY KEY (`keySubSystem`)
1917) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COMMENT='List of Sub-System categories';
1918/*!40101 SET character_set_client = @saved_cs_client */;
1919
1920--
1921-- Dumping data for table `stm_tm_subsystem`
1922--
1923
1924LOCK TABLES `stm_tm_subsystem` WRITE;
1925/*!40000 ALTER TABLE `stm_tm_subsystem` DISABLE KEYS */;
1926INSERT INTO `stm_tm_subsystem` VALUES
1927 (1,'other','no specific sub system'),
1928 (2,'OBDH','On Board Data Handling'),
1929 (8,'ALY','Anomaly Reporting System');
1930/*!40000 ALTER TABLE `stm_tm_subsystem` ENABLE KEYS */;
1931UNLOCK TABLES;
1932
1933--
1934-- Table structure for table `stm_tm_virtualchannel`
1935--
1936
1937DROP TABLE IF EXISTS `stm_tm_virtualchannel`;
1938/*!40101 SET @saved_cs_client = @@character_set_client */;
1939/*!40101 SET character_set_client = utf8 */;
1940CREATE TABLE `stm_tm_virtualchannel` (
1941 `keyTMVirtualChannel` int(10) unsigned NOT NULL AUTO_INCREMENT,
1942 `Number` int(10) unsigned NOT NULL,
1943 `Name` varchar(20) NOT NULL,
1944 `isRealTime` tinyint(1) unsigned NOT NULL DEFAULT 0,
1945 `isPadding` tinyint(1) unsigned NOT NULL DEFAULT 0,
1946 PRIMARY KEY (`keyTMVirtualChannel`),
1947 UNIQUE KEY `TMVCNumber` (`Number`)
1948) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1 COMMENT='List of VIRTUAL CHANNELS';
1949/*!40101 SET character_set_client = @saved_cs_client */;
1950
1951--
1952-- Dumping data for table `stm_tm_virtualchannel`
1953--
1954
1955LOCK TABLES `stm_tm_virtualchannel` WRITE;
1956/*!40000 ALTER TABLE `stm_tm_virtualchannel` DISABLE KEYS */;
1957INSERT INTO `stm_tm_virtualchannel` VALUES
1958 (1,0,'REAL_TIME',1,0),
1959 (2,1,'BUS_HISTORY',0,0),
1960 (3,2,'PAYLOAD_HISTORY',0,0),
1961 (4,3,'DIAGNOSIS_HISTORY',1,0),
1962 (5,4,'PICTURE_DATA',1,0),
1963 (6,15,'PADDING',0,1),
1964 (999,999,'UNDEFINED',0,0);
1965/*!40000 ALTER TABLE `stm_tm_virtualchannel` ENABLE KEYS */;
1966UNLOCK TABLES;
1967
1968--
1969-- Table structure for table `stm_topics`
1970--
1971
1972DROP TABLE IF EXISTS `stm_topics`;
1973/*!40101 SET @saved_cs_client = @@character_set_client */;
1974/*!40101 SET character_set_client = utf8 */;
1975CREATE TABLE `stm_topics` (
1976 `keyTopics` int(11) unsigned NOT NULL,
1977 `Name` varchar(50) NOT NULL,
1978 `ID` smallint(5) unsigned NOT NULL,
1979 `Comment` varchar(100) NOT NULL,
1980 PRIMARY KEY (`keyTopics`),
1981 UNIQUE KEY `UNIQUE_ID` (`ID`)
1982) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of TOPICS';
1983/*!40101 SET character_set_client = @saved_cs_client */;
1984
1985--
1986-- Dumping data for table `stm_topics`
1987--
1988
1989LOCK TABLES `stm_topics` WRITE;
1990/*!40000 ALTER TABLE `stm_topics` DISABLE KEYS */;
1991INSERT INTO `stm_topics` VALUES
1992 (1,'Commands',1012,'Topic to deliver commands to applications'),
1993 (2,'InternalCommands',1013,'Topic for Telecommands published inside the Bus'),
1994 (3,'IAmAlive',1014,'Node-internal alive Topic'),
1995 (4,'AnomalyReport',1003,'Topic for Anomaly reporting'),
1996 (5,'TMBusHist',1008,'Topic for historical Bus Telemetry reporting'),
1997 (6,'TMPayloadHist',1009,'Topic for historical Payload Telemetry reporting'),
1998 (7,'TMRealTime',1007,'Topic for Real Time Telemetry reporting'),
1999 (8,'TMStandard',1015,'Topic for Standard Telemetry reporting'),
2000 (9,'StandardHKRequest',1016,'Topic to request delivery of Standard Telemetry'),
2001 (10,'RequestTransferFrame',1017,'Topic to request delivery of a Transfer Frame for Downlink'),
2002 (11,'IAmAlivePCU',1000,'System-wide alive Topic'),
2003 (12,'PpsInterrupt',1011,'Local Topic to handle PPS interrupts'),
2004 (13,'TimeSyncForNextPPS',1004,'Topic to deliver new Time to be set upon next PPS-Signal'),
2005 (14,'BootMsgToEgse',1010,'EGSE-Topic to deliver info message upon boot'),
2006 (15,'DownLinkChannel',1005,'Topic to deliver Transfer Frames for radio transmission'),
2007 (18,'GroundTelecommands',1001,'Topic for incoming Telecommands on radio link'),
2008 (19,'TimedCommands',1002,'Topic for incoming / published TimeTagged Telecommands (???)'),
2009 (89,'StackoverflowReport',1024,'A thread\'s info on stackoverflow'),
2010 (91,'TimingLog',1019,'Timing information of an application\'s thread'),
2011 (92,'FaultReport',1020,'Processor last resort fault information'),
2012 (93,'PpsSoftwareFallback',1021,'Topic to handle PPS software fallback'),
2013 (94,'pfdaTriggerTelemetry',5001,'Topic to synchronously trigger telemetry sending on all pFDAs'),
2014 (95,'pfdaSetEnable',5002,'Topic to synchronously enable or disable individual pFDAs'),
2015 (96,'pfdaSetFrequency',5003,'Topic to syncrhonously set the frequency of all pFDAs'),
2016 (97,'pfdaSetSpeed',5004,'Topic to synchronously set the spee of all pFDAs');
2017/*!40000 ALTER TABLE `stm_topics` ENABLE KEYS */;
2018UNLOCK TABLES;
2019
2020--
2021-- Current Database: `global`
2022--
2023
2024CREATE DATABASE /*!32312 IF NOT EXISTS*/ `global` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin */;
2025
2026USE `global`;
2027
2028--
2029-- Table structure for table `rdt_LogInfo`
2030--
2031
2032DROP TABLE IF EXISTS `rdt_LogInfo`;
2033/*!40101 SET @saved_cs_client = @@character_set_client */;
2034/*!40101 SET character_set_client = utf8 */;
2035CREATE TABLE `rdt_LogInfo` (
2036 `keyLogInfo` int(10) unsigned NOT NULL AUTO_INCREMENT,
2037 `keyGroundStation` int(10) unsigned DEFAULT NULL,
2038 `keySatellite` int(10) unsigned DEFAULT NULL,
2039 `keySatelliteModel` int(10) unsigned DEFAULT NULL,
2040 `Time` datetime NOT NULL,
2041 `ActionType` varchar(50) NOT NULL,
2042 `Message` text DEFAULT NULL,
2043 `ModuleType` varchar(50) DEFAULT NULL,
2044 `MessageType` varchar(50) DEFAULT NULL,
2045 PRIMARY KEY (`keyLogInfo`),
2046 KEY `LogInfo_GroundStation` (`keyGroundStation`),
2047 KEY `LogInfo_Satellite` (`keySatellite`),
2048 CONSTRAINT `LogInfo_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE SET NULL ON UPDATE CASCADE,
2049 CONSTRAINT `LogInfo_Satellite` FOREIGN KEY (`keySatellite`) REFERENCES `stm_Satellite` (`keySatellite`) ON DELETE SET NULL ON UPDATE CASCADE
2050) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2051/*!40101 SET character_set_client = @saved_cs_client */;
2052
2053--
2054-- Dumping data for table `rdt_LogInfo`
2055--
2056
2057LOCK TABLES `rdt_LogInfo` WRITE;
2058/*!40000 ALTER TABLE `rdt_LogInfo` DISABLE KEYS */;
2059/*!40000 ALTER TABLE `rdt_LogInfo` ENABLE KEYS */;
2060UNLOCK TABLES;
2061
2062--
2063-- Table structure for table `stm_Configuration`
2064--
2065
2066DROP TABLE IF EXISTS `stm_Configuration`;
2067/*!40101 SET @saved_cs_client = @@character_set_client */;
2068/*!40101 SET character_set_client = utf8 */;
2069CREATE TABLE `stm_Configuration` (
2070 `keyConfiguration` int(10) unsigned NOT NULL AUTO_INCREMENT,
2071 `keyGroundStation` int(10) unsigned NOT NULL,
2072 `keyConfigurationParameter` int(10) unsigned NOT NULL,
2073 `ParameterValue` varchar(100) DEFAULT NULL,
2074 PRIMARY KEY (`keyConfiguration`),
2075 KEY `Configuration_ConfiguationParameter` (`keyConfigurationParameter`),
2076 KEY `Configuration_GroundStation` (`keyGroundStation`),
2077 CONSTRAINT `Configuration_ConfiguationParameter` FOREIGN KEY (`keyConfigurationParameter`) REFERENCES `stm_ConfigurationParameter` (`keyConfigurationParameter`) ON DELETE CASCADE ON UPDATE CASCADE,
2078 CONSTRAINT `Configuration_GroundStation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE
2079) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2080/*!40101 SET character_set_client = @saved_cs_client */;
2081
2082--
2083-- Dumping data for table `stm_Configuration`
2084--
2085
2086LOCK TABLES `stm_Configuration` WRITE;
2087/*!40000 ALTER TABLE `stm_Configuration` DISABLE KEYS */;
2088/*!40000 ALTER TABLE `stm_Configuration` ENABLE KEYS */;
2089UNLOCK TABLES;
2090
2091--
2092-- Table structure for table `stm_ConfigurationParameter`
2093--
2094
2095DROP TABLE IF EXISTS `stm_ConfigurationParameter`;
2096/*!40101 SET @saved_cs_client = @@character_set_client */;
2097/*!40101 SET character_set_client = utf8 */;
2098CREATE TABLE `stm_ConfigurationParameter` (
2099 `keyConfigurationParameter` int(10) unsigned NOT NULL AUTO_INCREMENT,
2100 `ParameterName` varchar(100) NOT NULL,
2101 `ParameterType` varchar(20) NOT NULL,
2102 `Required` tinyint(4) NOT NULL DEFAULT 1,
2103 `Description` varchar(150) NOT NULL,
2104 PRIMARY KEY (`keyConfigurationParameter`),
2105 UNIQUE KEY `ParameterName` (`ParameterName`)
2106) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2107/*!40101 SET character_set_client = @saved_cs_client */;
2108
2109--
2110-- Dumping data for table `stm_ConfigurationParameter`
2111--
2112
2113LOCK TABLES `stm_ConfigurationParameter` WRITE;
2114/*!40000 ALTER TABLE `stm_ConfigurationParameter` DISABLE KEYS */;
2115/*!40000 ALTER TABLE `stm_ConfigurationParameter` ENABLE KEYS */;
2116UNLOCK TABLES;
2117
2118--
2119-- Table structure for table `stm_GroundStation`
2120--
2121
2122DROP TABLE IF EXISTS `stm_GroundStation`;
2123/*!40101 SET @saved_cs_client = @@character_set_client */;
2124/*!40101 SET character_set_client = utf8 */;
2125CREATE TABLE `stm_GroundStation` (
2126 `keyGroundStation` int(10) unsigned NOT NULL AUTO_INCREMENT,
2127 `Name` varchar(50) NOT NULL DEFAULT '-----',
2128 `NSCoordinate` double NOT NULL DEFAULT 0,
2129 `EWCoordinate` double NOT NULL DEFAULT 0,
2130 `HeightNN` double NOT NULL DEFAULT 0,
2131 `TimeZone` double NOT NULL DEFAULT 0,
2132 `TTSAdress` varchar(255) DEFAULT NULL,
2133 `TTSPort` smallint(5) unsigned NOT NULL DEFAULT 0,
2134 `Country` varchar(20) DEFAULT NULL,
2135 `LocalAuthority` varchar(50) DEFAULT NULL,
2136 `ContactPerson` varchar(50) DEFAULT NULL,
2137 `ContactPhone` varchar(50) DEFAULT NULL,
2138 `ContactEmail` varchar(50) DEFAULT NULL,
2139 PRIMARY KEY (`keyGroundStation`),
2140 UNIQUE KEY `Name` (`Name`)
2141) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2142/*!40101 SET character_set_client = @saved_cs_client */;
2143
2144--
2145-- Dumping data for table `stm_GroundStation`
2146--
2147
2148LOCK TABLES `stm_GroundStation` WRITE;
2149/*!40000 ALTER TABLE `stm_GroundStation` DISABLE KEYS */;
2150INSERT INTO `stm_GroundStation` VALUES
2151 (0,'-----',0,0,0,0,NULL,0,NULL,NULL,NULL,NULL,NULL),
2152 (1,'localhost',0,0,0,0,'localhost',7000,'none','none','none','none','none');
2153/*!40000 ALTER TABLE `stm_GroundStation` ENABLE KEYS */;
2154UNLOCK TABLES;
2155
2156--
2157-- Table structure for table `stm_MCCProgram`
2158--
2159
2160DROP TABLE IF EXISTS `stm_MCCProgram`;
2161/*!40101 SET @saved_cs_client = @@character_set_client */;
2162/*!40101 SET character_set_client = utf8 */;
2163CREATE TABLE `stm_MCCProgram` (
2164 `keyMCCProgram` int(10) unsigned NOT NULL AUTO_INCREMENT,
2165 `ProgramType` enum('TTS','TCControl','TMViewer','TMAnalyzer','Installer') NOT NULL,
2166 `linux32` longblob DEFAULT NULL,
2167 `linux64` longblob DEFAULT NULL,
2168 `win32` longblob DEFAULT NULL,
2169 `win64` longblob DEFAULT NULL,
2170 `java` longblob DEFAULT NULL,
2171 `TimeStamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
2172 `Version` varchar(50) DEFAULT NULL,
2173 PRIMARY KEY (`keyMCCProgram`),
2174 UNIQUE KEY `ProgramType_Platform` (`ProgramType`)
2175) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2176/*!40101 SET character_set_client = @saved_cs_client */;
2177
2178--
2179-- Dumping data for table `stm_MCCProgram`
2180--
2181
2182LOCK TABLES `stm_MCCProgram` WRITE;
2183/*!40000 ALTER TABLE `stm_MCCProgram` DISABLE KEYS */;
2184/*!40000 ALTER TABLE `stm_MCCProgram` ENABLE KEYS */;
2185UNLOCK TABLES;
2186
2187--
2188-- Table structure for table `stm_Plugin`
2189--
2190
2191DROP TABLE IF EXISTS `stm_Plugin`;
2192/*!40101 SET @saved_cs_client = @@character_set_client */;
2193/*!40101 SET character_set_client = utf8 */;
2194CREATE TABLE `stm_Plugin` (
2195 `keyPlugin` int(10) unsigned NOT NULL AUTO_INCREMENT,
2196 `PluginType` enum('HamLibModule','Library','OwnLibrary','QtLibrary','QPlatformLib','OSModule','TNC','Telemetry','Command') NOT NULL,
2197 `PluginName` varchar(50) NOT NULL,
2198 `linux32` longblob DEFAULT NULL,
2199 `linux64` longblob DEFAULT NULL,
2200 `win32` longblob DEFAULT NULL,
2201 `win64` longblob DEFAULT NULL,
2202 `java` longblob DEFAULT NULL,
2203 `TimeStamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
2204 `Version` varchar(50) DEFAULT NULL,
2205 PRIMARY KEY (`keyPlugin`)
2206) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2207/*!40101 SET character_set_client = @saved_cs_client */;
2208
2209--
2210-- Dumping data for table `stm_Plugin`
2211--
2212
2213LOCK TABLES `stm_Plugin` WRITE;
2214/*!40000 ALTER TABLE `stm_Plugin` DISABLE KEYS */;
2215INSERT INTO `stm_Plugin` VALUES
2216 (1,'Command','command_tubix20',NULL,NULL,NULL,NULL,NULL,'2018-05-25 08:15:15',NULL),
2217 (2,'Telemetry','tubix20plugin',NULL,NULL,NULL,NULL,NULL,'2018-05-25 09:34:09','0.0.1');
2218/*!40000 ALTER TABLE `stm_Plugin` ENABLE KEYS */;
2219UNLOCK TABLES;
2220
2221--
2222-- Table structure for table `stm_Satellite`
2223--
2224
2225DROP TABLE IF EXISTS `stm_Satellite`;
2226/*!40101 SET @saved_cs_client = @@character_set_client */;
2227/*!40101 SET character_set_client = utf8 */;
2228CREATE TABLE `stm_Satellite` (
2229 `keySatellite` int(10) unsigned NOT NULL AUTO_INCREMENT,
2230 `SatelliteName` varchar(50) NOT NULL DEFAULT '-----',
2231 `DBSheme` varchar(30) DEFAULT NULL,
2232 `DBLogin` varchar(100) DEFAULT NULL COMMENT '[encrypted]',
2233 `DBPassword` varchar(100) DEFAULT NULL COMMENT '[encrypted]',
2234 `DBServer` varchar(100) DEFAULT NULL,
2235 `DBPort` smallint(30) unsigned NOT NULL DEFAULT 3306,
2236 `IsBeeSat1` tinyint(1) unsigned NOT NULL DEFAULT 0,
2237 `TrackIntervall` smallint(5) unsigned NOT NULL DEFAULT 1000 COMMENT '[MSec]',
2238 `keyTMPlugin` int(10) unsigned DEFAULT NULL,
2239 `keyTNCPlugin` int(10) unsigned DEFAULT NULL,
2240 `keyTCPlugin` int(10) unsigned DEFAULT NULL,
2241 `OperationMode` enum('beesat1','beesatx','tubix20','beesat5to8') NOT NULL DEFAULT 'beesatx' COMMENT 'Mode of Com-Operations',
2242 PRIMARY KEY (`keySatellite`),
2243 UNIQUE KEY `Name` (`SatelliteName`),
2244 KEY `Satellite_TMPlugin` (`keyTMPlugin`),
2245 KEY `Satellite_TNCPlugin` (`keyTNCPlugin`),
2246 KEY `Satellite_TCPlugin` (`keyTCPlugin`),
2247 CONSTRAINT `Satellite_TCPlugin` FOREIGN KEY (`keyTCPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL,
2248 CONSTRAINT `Satellite_TMPlugin` FOREIGN KEY (`keyTMPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL ON UPDATE CASCADE,
2249 CONSTRAINT `Satellite_TNCPlugin` FOREIGN KEY (`keyTNCPlugin`) REFERENCES `stm_Plugin` (`keyPlugin`) ON DELETE SET NULL ON UPDATE CASCADE
2250) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2251/*!40101 SET character_set_client = @saved_cs_client */;
2252
2253--
2254-- Dumping data for table `stm_Satellite`
2255--
2256
2257LOCK TABLES `stm_Satellite` WRITE;
2258/*!40000 ALTER TABLE `stm_Satellite` DISABLE KEYS */;
2259INSERT INTO `stm_Satellite` VALUES
2260 (0,'-----',NULL,NULL,NULL,NULL,3306,0,1000,NULL,NULL,NULL,'beesatx'),
2261 (1,'TUPEX-6 Sat','tupex6','root','root','localhost',3306,0,1000,2,NULL,1,'tubix20');
2262/*!40000 ALTER TABLE `stm_Satellite` ENABLE KEYS */;
2263UNLOCK TABLES;
2264
2265--
2266-- Table structure for table `stm_SatellitesToTrack`
2267--
2268
2269DROP TABLE IF EXISTS `stm_SatellitesToTrack`;
2270/*!40101 SET @saved_cs_client = @@character_set_client */;
2271/*!40101 SET character_set_client = utf8 */;
2272CREATE TABLE `stm_SatellitesToTrack` (
2273 `keySatellitesToTrack` int(10) unsigned NOT NULL AUTO_INCREMENT,
2274 `keyGroundStation` int(10) unsigned NOT NULL,
2275 `keySatellite` int(10) unsigned NOT NULL,
2276 `keySatelliteModel` int(10) unsigned NOT NULL COMMENT 'Attention: No Foreign Key Constraint, handle with care!',
2277 `autoTrack` tinyint(1) unsigned NOT NULL DEFAULT 0,
2278 PRIMARY KEY (`keySatellitesToTrack`),
2279 KEY `SatellitesToTrack_Groundstation` (`keyGroundStation`),
2280 KEY `SatellitesToTrack_Satellite` (`keySatellite`),
2281 CONSTRAINT `SatellitesToTrack_Groundstation` FOREIGN KEY (`keyGroundStation`) REFERENCES `stm_GroundStation` (`keyGroundStation`) ON DELETE CASCADE ON UPDATE CASCADE,
2282 CONSTRAINT `SatellitesToTrack_Satellite` FOREIGN KEY (`keySatellite`) REFERENCES `stm_Satellite` (`keySatellite`) ON DELETE CASCADE ON UPDATE CASCADE
2283) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2284/*!40101 SET character_set_client = @saved_cs_client */;
2285
2286--
2287-- Dumping data for table `stm_SatellitesToTrack`
2288--
2289
2290LOCK TABLES `stm_SatellitesToTrack` WRITE;
2291/*!40000 ALTER TABLE `stm_SatellitesToTrack` DISABLE KEYS */;
2292/*!40000 ALTER TABLE `stm_SatellitesToTrack` ENABLE KEYS */;
2293UNLOCK TABLES;
2294
2295--
2296-- Table structure for table `stm_TNC`
2297--
2298
2299DROP TABLE IF EXISTS `stm_TNC`;
2300/*!40101 SET @saved_cs_client = @@character_set_client */;
2301/*!40101 SET character_set_client = utf8 */;
2302CREATE TABLE `stm_TNC` (
2303 `keyTNC` int(10) unsigned NOT NULL AUTO_INCREMENT,
2304 `Name` varchar(50) NOT NULL,
2305 `ErrorDetectionRoutine` enum('','MobiTex') DEFAULT '',
2306 PRIMARY KEY (`keyTNC`)
2307) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
2308/*!40101 SET character_set_client = @saved_cs_client */;
2309
2310--
2311-- Dumping data for table `stm_TNC`
2312--
2313
2314LOCK TABLES `stm_TNC` WRITE;
2315/*!40000 ALTER TABLE `stm_TNC` DISABLE KEYS */;
2316INSERT INTO `stm_TNC` VALUES
2317 (7,'Tbx20Egse','MobiTex');
2318/*!40000 ALTER TABLE `stm_TNC` ENABLE KEYS */;
2319UNLOCK TABLES;
2320/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2321
2322/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2323/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2324/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2325/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2326/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2327/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2328/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2329
2330-- Dump completed on 2019-02-13 14:31:35