-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdump.sql
203 lines (162 loc) · 46.9 KB
/
dump.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
-- MySQL dump 10.14 Distrib 5.5.36-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: priyom2
-- ------------------------------------------------------
-- Server version 5.5.36-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `alphabets`
--
LOCK TABLES `alphabets` WRITE;
/*!40000 ALTER TABLE `alphabets` DISABLE KEYS */;
INSERT INTO `alphabets` VALUES (1,'la','Latin'),(2,'ru','Cyrillic');
/*!40000 ALTER TABLE `alphabets` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `attachments`
--
LOCK TABLES `attachments` WRITE;
/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `capabilities`
--
LOCK TABLES `capabilities` WRITE;
/*!40000 ALTER TABLE `capabilities` DISABLE KEYS */;
/*!40000 ALTER TABLE `capabilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `event_attachments`
--
LOCK TABLES `event_attachments` WRITE;
/*!40000 ALTER TABLE `event_attachments` DISABLE KEYS */;
/*!40000 ALTER TABLE `event_attachments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `event_classes`
--
LOCK TABLES `event_classes` WRITE;
/*!40000 ALTER TABLE `event_classes` DISABLE KEYS */;
/*!40000 ALTER TABLE `event_classes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `event_frequencies`
--
LOCK TABLES `event_frequencies` WRITE;
/*!40000 ALTER TABLE `event_frequencies` DISABLE KEYS */;
/*!40000 ALTER TABLE `event_frequencies` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `events`
--
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `modes`
--
LOCK TABLES `modes` WRITE;
/*!40000 ALTER TABLE `modes` DISABLE KEYS */;
INSERT INTO `modes` VALUES (1,'USB');
/*!40000 ALTER TABLE `modes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `session_capabilities`
--
LOCK TABLES `session_capabilities` WRITE;
/*!40000 ALTER TABLE `session_capabilities` DISABLE KEYS */;
/*!40000 ALTER TABLE `session_capabilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `stations`
--
LOCK TABLES `stations` WRITE;
/*!40000 ALTER TABLE `stations` DISABLE KEYS */;
INSERT INTO `stations` VALUES ('2014-04-06 16:32:40','2014-04-06 16:32:40',1,'S28','M_Sr1','Buzzer',NULL,'Active','Unknown'),('2014-04-06 16:32:40','2014-04-06 16:32:40',2,'E06','I_E1','English man','A station that broadcasts (possibly to spies) numbers to be used with a one time pad.','Active','Russia'),('2014-04-06 16:32:40','2014-04-06 16:32:40',3,'E02','','Arabic man/The Babbler','Very little is known about this station.','Inactive','Unknown'),('2014-04-06 16:32:40','2014-04-06 16:32:40',4,'E03','','Lincolnshire Poacher','Plays the tune \"The Lincolnshire Poacher\" before each TX as a sort of callsign. Messages were always 200 groups long, and were always taking 45 minutes to transmit.','Inactive (last heard July 2008)','Cyprus (Akrotiri RAF base)'),('2014-04-06 16:32:40','2014-04-06 16:32:40',5,'E03a','','Cherry Ripe','Uses same format, only interval signal is different - this time the tune is \"Cherry Ripe\".','Inactive (last heard December 2009)','Guam, then possibly moved to northern Australia'),('2014-04-06 16:32:40','2014-04-06 16:32:40',6,'E04','','Cherry Ripe','Was deleted due to being matched up with E03, gaining the sub designater E03a','Deleted',NULL),('2014-04-06 16:32:41','2014-04-06 16:32:41',7,'E05','','Counting station \"Cynthia\"','CIA station. Sent messages as 3 figure/2 figure groups. Operated many years, heavily sticking to its schedules.','Inactive (last heard October 2003)','Warrenton, USA (with many other sites worldwide)'),('2014-04-06 16:32:41','2014-04-06 16:32:41',8,'E06a','','English Man','Variant of E06 sending 2-group message with 11111 and \"random\" number. Sometimes normal messages followed. Very rare.','Active','Russia'),('2014-04-06 16:32:41','2014-04-06 16:32:41',9,'E06b','','English Man','Varient of E06 with a 3 figure ID and a 5 figure group in the call. always sends 2 messages. This is a very rare station!','Active','Russia'),('2014-04-06 16:32:41','2014-04-06 16:32:41',10,'E01','','Ready Ready','Counterpart to S02. Main frequncies were 4740 and 6675 kHz. Broadcast started with woman repeating 5 figure identifier for 5 minutes. After callup group count was said (\"22, 22\") followed by \"Ready, Ready\" and goes into 5 figure groups.','Inactive','Bulgaria'),('2014-04-06 16:32:41','2014-04-06 16:32:41',11,'E07','','English Man',NULL,'Active','Russia'),('2014-04-06 16:32:41','2014-04-06 16:32:41',12,'E07a','','English Man','E07a uses USB where as E07 uses AM, also E07a has an extra 5 figure group in the call where E07 does not.','Active','Russia'),('2014-04-06 16:32:41','2014-04-06 16:32:41',13,'E09','','Magnetic Fields','Freqencies: 11290 ','Inactive','Unknown'),('2014-04-06 16:32:41','2014-04-06 16:32:41',14,'E10','','Mossad','E10 was believed to be operated by the israeli intelligence, Mossad. I was last heard at night on the 28th of febuary 2011.','Inactive','Israel'),('2014-04-06 16:32:41','2014-04-06 16:32:41',15,'E10a','',NULL,'Variant of E10 sending various strings. Mostly one letter (HNC B, HNC Z etc). Some of them were containing time information. The most famous one was sent on March 15, 2006 at 2200z on 3273//5339 kHz: KPA G1O2O3D4N5I6G7H8T9 (if you will remove numbers, you will get GOODNIGHT).','Inactive','Israel'),('2014-04-06 16:32:41','2014-04-06 16:32:41',16,'E11','','Oblique','E11 always sends a null message. Format is: nnn Oblique 00 (nnn/00). nnn is the ID. Transmissions always last 3 minutes. When it sends a message is becomes E11a','Active','Poland'),('2014-04-06 16:32:41','2014-04-06 16:32:41',17,'E11a','','Oblique','E11 message varient','Active','Poland'),('2014-04-06 16:32:41','2014-04-06 16:32:41',18,'E11b','','Oblique','E11b is another E11 varient that sends a message, but with stutter groups (77777 77777) at the begining and end of each message','Active','Poland'),('2014-04-06 16:32:41','2014-04-06 16:32:41',19,'E11c','','Oblique','E11c is E11 but with triplet element in ID (xxx/555/00), 755/555/00 only hear. Voice version of M03a not heard since May 2000.','Active','Poland'),('2014-04-06 16:32:41','2014-04-06 16:32:41',20,'E12','','NNN',NULL,'Inactive','Austria'),('2014-04-06 16:32:41','2014-04-06 16:32:41',21,'E13','','Five Dashes',NULL,'Inactive','Germany'),('2014-04-06 16:32:41','2014-04-06 16:32:41',22,'E14','','4F Control',NULL,'Inactive','USA'),('2014-04-06 16:32:41','2014-04-06 16:32:41',23,'E15','','Phonetic Alphabet - Pre-NATO','Noted for using an unidentified Pre-NATO phonetic alphabet. Last known broadcast was in 2006','Inactive','Egypt'),('2014-04-06 16:32:41','2014-04-06 16:32:41',24,'E16','','Two letter',NULL,'Inactive','Germany'),('2014-04-06 16:32:41','2014-04-06 16:32:41',25,'E17','','English Lady',NULL,'Inactive','Russia'),('2014-04-06 16:32:41','2014-04-06 16:32:42',26,'E17a','',NULL,'2 different voices in one transmission','Inactive','Russia'),('2014-04-06 16:32:42','2014-04-06 16:32:42',27,'E17y','',NULL,NULL,'Inactice','Cuba?'),('2014-04-06 16:32:42','2014-04-06 16:32:42',28,'E17z','','English Lady 0 0 0 0 0','This station is English variant of S06s. Messages are usually very short, new one comes every 2 weeks.','Active','Ukraine'),('2014-04-06 16:32:42','2014-04-06 16:32:42',29,'E18','','Fife Free/Edna Sednitzer',NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',30,'E19','','Irish Man',NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',31,'E20','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',32,'E21','','4F Counting',NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',33,'E21a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',34,'E22','','Indian man','Was withdrawn due to it being found to be a test transmission for All india radio','Withdrawn','India'),('2014-04-06 16:32:42','2014-04-06 16:32:42',35,'E23','','Swedish Rhapsody','Started in 1998 replacing G02, using voice of E05 Counting Station and \"without music intro\". Full transmission will always last 43 minutes and 30 seconds.','Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',36,'E24','','Allo Allo','There is much speculation about E24 ranging from it being an emergency broadcast station that only broadcasts extremely rarely to it being mistaken to be a number station at all.','Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',37,'E25','','No coined names yet','Believed to be of Egyption origin','Active','Egypt?'),('2014-04-06 16:32:42','2014-04-06 16:32:42',38,'E25a','',NULL,'This station calls in 785 77 788 71 72 73 74 75 76 78 style for some time, then shutdowns without message. Believed to be control ones.','Active','Egypt?'),('2014-04-06 16:32:42','2014-04-06 16:32:42',39,'E25b','',NULL,'E25b is actually just E25 in the arabic language. The reason it is still classified as an English language station is because the call up it still in English. Used ID\'s were 830 and 835. Not currently active since E25 uses automated female voice.','Inactive','Egypt?'),('2014-04-06 16:32:42','2014-04-06 16:32:42',40,'E26','',NULL,'E26 was actually wrongly classified by Enigma 2000. It was almost immediately Removed. This page is here purely for historical purposes. Its current designator is E25b.','Withdrawn',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',41,'E27','',NULL,'The carrier is generally up for about 5 minutes prior to broadcast. A long 1k tone for tuning which is then followed by 5 long morse like dashes which signal that the message is about to begin. Only 20 group messages were heard.','Active',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',42,'S01','','Aïda ','Female, computerised voice','Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',43,'S02','','Drums and Trumpets','Female, computerised voice','Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',44,'S02a','','Drums And Trumpets (A- With bugle)','Just as S02 but with a bugel','Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',45,'S02b','','Drums and Trumpets (B- bugle intro)','An intro for S02, no voice. Has now been deleted and replaced by X01','inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',46,'S02c','','- 3F Nomer, Then reversed',NULL,'Active',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',47,'S02d','','D- 5F Nomer',NULL,'Inactive',NULL),('2014-04-06 16:32:42','2014-04-06 16:32:42',48,'S03','','Czech Words',NULL,'Inactive',NULL),('2014-04-06 16:32:43','2014-04-06 16:32:43',49,'S04','','Edna Sednitzer','both male and female voices used','Inactive','Slovakia'),('2014-04-06 16:32:43','2014-04-06 16:32:43',50,'S05','','OLZ ','This is an early format null messages','Inactive',NULL),('2014-04-06 16:32:43','2014-04-06 16:32:43',51,'S05a','','OLX','same as S05 but with a different format','Inactive',NULL),('2014-04-06 16:32:43','2014-04-06 16:32:43',52,'S05b','','OLX','Same as S05 but with different format','Inactive',NULL),('2014-04-06 16:32:43','2014-04-06 16:32:43',53,'S06','','Russian Man','A very active Russian nuberstation that Transmits using USB with a carrier(H3E)','Active','Russia'),('2014-04-06 16:32:43','2014-04-06 16:32:44',54,'S06a','','Russian Man','A varient of S06 with a- 55555 00000 format)','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',55,'S06b','','Russian Man','Another varient of S06 with the format 11111 11111 before the message','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',56,'S06c','','Russian Man','Another varient of S06 with a single 5F group repeated. ','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',57,'S06d','','Russian Man','varient of s06 with ID+111','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',58,'S06e','','Russian Man','A varient of S06 but with 2 messages','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',59,'S06f','','Russian Man','a S06 varient with a call up of 00000-00000','Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',60,'S06s','','Russian lady',NULL,'Active','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',61,'S07','','Russian Man 000 000',NULL,'Inactive','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',62,'S07a','','A- Multiple two groups',NULL,'Inactive','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',63,'S07b','','B- multiple single group messages for same ID',NULL,'Inactive','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',64,'S07c','','4F non-random',NULL,'Inactive','Russia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',65,'S08','','YT',NULL,'Inactive','Yugoslavia'),('2014-04-06 16:32:44','2014-04-06 16:32:44',66,'S09','','Polish Counting','not actually a number station but polish military testing radio equipment','Active','Poland'),('2014-04-06 16:32:44','2014-04-06 16:32:44',67,'S10','','Czecj Lady(Later Five Notes)',NULL,'Inactive','Czech'),('2014-04-06 16:32:44','2014-04-06 16:32:44',68,'S10a','','Czech Lady','555 idler varient of S10','Inactive','Czech'),('2014-04-06 16:32:44','2014-04-06 16:32:44',69,'S10b','','Czech Lady','5 Note intro (3 versions) varient of S10','Inactive','Czech'),('2014-04-06 16:32:44','2014-04-06 16:32:44',70,'S10c','','Czech Lady','Re-Activation','Inactive','Czech'),('2014-04-06 16:32:44','2014-04-06 16:32:45',71,'S20d','','Czech Lady',NULL,'Inactive','Czech'),('2014-04-06 16:32:45','2014-04-06 16:32:45',72,'S10e','','Czech Lady',NULL,'Inactive','Czech'),('2014-04-06 16:32:45','2014-04-06 16:32:45',73,'S11','','Kreska',NULL,'Inactive',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',74,'S11a','','Cherta','Freqencies 4909, 5815, 8530, and 11581 kHz','Active',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',75,'S11b','','Cherta','This station is S11a but with 77777 77777 in beginnings and ends of transmissions. Group count is in 30\'s.','Active',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',76,'S12','','Cherta','Deleted and it now listed as S11a','Deleted',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',77,'S13','','Russian Counting and announcements','Not actually a number station. It is russian military testing radio equipment','Active','Russia'),('2014-04-06 16:32:45','2014-04-06 16:32:45',78,'s14','','Russian 1-10 announcement','Like S13, not actually a numberstation, just military testing equipment.','Active','Russia'),('2014-04-06 16:32:45','2014-04-06 16:32:45',79,'S15','','Rapid Dots','Changed to S05a','Deleted',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',80,'S16','','OLX','Changed to S05b','Deleted',NULL),('2014-04-06 16:32:45','2014-04-06 16:32:45',81,'S17','','Czech Lady','Frequencies chage every year. uses only 2 per year','Inactive','Czech'),('2014-04-06 16:32:45','2014-04-06 16:32:45',82,'S17a','','Czech Lady','A - no circuit number, positioning index or group count','Inactive','Czech'),('2014-04-06 16:32:45','2014-04-06 16:32:45',83,'S17b','','Czech Lady',NULL,'Inactive','Czech'),('2014-04-06 16:32:46','2014-04-06 16:32:46',84,'S17c','','Czech Lady',NULL,'Inactive','Czech'),('2014-04-06 16:32:46','2014-04-06 16:32:46',85,'S18','','Czech Man','This station has no known details as far as schedules or frequencies, it has only been caught rarely and by total chance. Uncertain of emission mode.','Active','Czech'),('2014-04-06 16:32:46','2014-04-06 16:32:46',86,'S19','','Czech Man control?',NULL,'Inactive','Czech'),('2014-04-06 16:32:46','2014-04-06 16:32:46',87,'S19a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',88,'S20','','Aifada','Very little is known about this station','Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',89,'S21','','Russian Lady',NULL,'Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',90,'S22','',NULL,'This is no currently a used ID. It is possible that emigma 2000 were about to designate a station to this ID and then decided not to','Deleted',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',91,'S23','','Barbara','Very little is known about this station','Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',92,'S24','',NULL,'This is not currently a used ID. Possibly because it was about to be classified so the ID was reserved, then it was for some reason dropped.','Deleted',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',93,'S25','','Russian Man Control?',NULL,'Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',94,'S25a','','A- 11111 22222','known frequency is 14720khz, though others have been used','Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',95,'S25b','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',96,'S25c','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',97,'S26','','Cyt Cyt','This station used Polish folk song Cyt, cyt by group Mazowsze as intro','Inactive','Poland?'),('2014-04-06 16:32:46','2014-04-06 16:32:46',98,'S27','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',99,'S27a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',100,'S29','',NULL,'Removed as it was found to be S18','Deleted',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',101,'S30','','The Pip','Frequencies: Day-time=5448, Night-time=3756','Active','Rostov-na-Donu, Russia'),('2014-04-06 16:32:46','2014-04-06 16:32:46',102,'S31','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',103,'S32','','The Squeaky Wheel','Frequencies: Day-time=5473, Night-time=3828','Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',104,'XP','','Polytones','XP was a data type (MFSK) used by russian intelligence. This was then replaced by XPA','Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',105,'XPA','','Polytone','XPA is a data type called MFSK-20 used by russian intelligence','Active','Russia'),('2014-04-06 16:32:46','2014-04-06 16:32:46',106,'XPA2','','Polytones','Similar to XPA but with a different format','Active','Around Moscow, Russia'),('2014-04-06 16:32:46','2014-04-06 16:32:46',107,'XPH','','High-Pitched Polytones','XPH is another russian polytone system','Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',108,'XPL','','Low-Pitched Polytone','A slow speed Russia Polytone. Active but rare!','Active',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',109,'XPM','','Middle-Pitched Polytone','Another MFSK with russia origin','Inactive',NULL),('2014-04-06 16:32:46','2014-04-06 16:32:46',110,'G01','','Tyrolean Music',NULL,'Inactive','Austria'),('2014-04-06 16:32:46','2014-04-06 16:32:46',111,'G01a','','A- Irregular tunes',NULL,'Inactive','Austria'),('2014-04-06 16:32:46','2014-04-06 16:32:46',112,'G01b','','B- Phrase messages in the first section and irregular tunes',NULL,'Inactive','Austria'),('2014-04-06 16:32:46','2014-04-06 16:32:47',113,'G02','','Swedish Rhapsody','Instead of sending one 100 groups long message it sent three of 100, 100 and 50 groups. After music tune (Swedish Rhapsody by Mantovani) three headers followed, repeated three times. Before each message, voice said Achtung! [here one of identifiers] Achtung!.','Inactive','Possibly Poland'),('2014-04-06 16:32:47','2014-04-06 16:32:47',114,'G02a','','Swedish Rhapsody(A- Counting variant)','Last heard on April 1, 1998. Replaced by E23.','Inactive','Possibly Poland'),('2014-04-06 16:32:47','2014-04-06 16:32:47',115,'G03','','Gongs or Chimes','Used by Stasi, not heard since 1990 (German unification).','Inactive','East germany'),('2014-04-06 16:32:47','2014-04-06 16:32:47',116,'G04','','Three Note Oddity','Possibly Hungarian, ceased early 2005. Used voice of G03.','Inactive','Hugary'),('2014-04-06 16:32:47','2014-04-06 16:32:47',117,'G05','','German Counting Station','German varient of CIA\'s E05. Format used was exactly the same','Inactive','USA?'),('2014-04-06 16:32:47','2014-04-06 16:32:47',118,'G05a','','A- \"Zwei\" Varient','This variant of G05 used word \"zwei\" instead of \"zwo\" and used voice of G13. Format otherwise the same.','Inactive','USA?'),('2014-04-06 16:32:47','2014-04-06 16:32:47',119,'G06','','German Lady',NULL,'Active','Russia'),('2014-04-06 16:32:47','2014-04-06 16:32:47',120,'G06a','',NULL,NULL,'Unknown','Russia'),('2014-04-06 16:32:47','2014-04-06 16:32:47',121,'G07','','German Lady 000 000','German varient of E07. Format used is almost same, but also used words Achtung and Ende in messages.','Inactive','Russia'),('2014-04-06 16:32:47','2014-04-06 16:32:47',122,'G07a','','A- 774 type varient',NULL,'Inactive','Russia'),('2014-04-06 16:32:47','2014-04-06 16:32:47',123,'G08','','Four note rising scale','Used by the stasi in east germany when berlin was not unified','Inactive','East germany'),('2014-04-06 16:32:47','2014-04-06 16:32:47',124,'G08a','','A- single repeated 5F group ','A letter repeated, then single 5 figure group repeated many times, long tone then repeat for 2 minutes.','Inactive','East germany'),('2014-04-06 16:32:47','2014-04-06 16:32:47',125,'G08b','','B- Rapid dots introduction','Send rapid dots tuning signal instead of 4-note rising scale','Inactive','East germany'),('2014-04-06 16:32:47','2014-04-06 16:32:47',126,'G09','','Saxaphone Piece','Very little is known about this station','Inactive',NULL),('2014-04-06 16:32:47','2014-04-06 16:32:47',127,'G10','','Bert Kaempfert','Very little is known about this station','Inactive',NULL),('2014-04-06 16:32:47','2014-04-06 16:32:47',128,'G11','','Strich','Often uses 3815, 5815 and 6986 kHz','Active',NULL),('2014-04-06 16:32:47','2014-04-06 16:32:48',129,'G12','','NNN',NULL,'Inactive',NULL),('2014-04-06 16:32:48','2014-04-06 16:32:48',130,'G13','','Five Dashes',NULL,'Inactive',NULL),('2014-04-06 16:32:48','2014-04-06 16:32:48',131,'G13a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:48','2014-04-06 16:32:48',132,'G14','','DFC37/DFD21 (rising ','This designator is for two stations - DFC37 and DFD21. They were operated by west German BND.','Inactive',NULL),('2014-04-06 16:32:48','2014-04-06 16:32:48',133,'G14a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:48','2014-04-06 16:32:48',134,'G15','','Papa November','This station is earliest of all 2-letter west German BND\'s network of stations. 4 frequencies were used: 2707, 5015, 7404 and 11108 kHz','Inactive','West Germany'),('2014-04-06 16:32:48','2014-04-06 16:32:48',135,'G15a','','A- PN read over notes','Varient of the \"Papa November\" station','Inactive','West Germany'),('2014-04-06 16:32:48','2014-04-06 16:32:48',136,'G16','','Two Letter',NULL,'Inactive','West Germany'),('2014-04-06 16:32:49','2014-04-06 16:32:49',137,'G17','','German Lady','Used the frequency 5420kHz','Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',138,'G18','','Eight note rising ','Operated by stasi','Inactive','East Germany'),('2014-04-06 16:32:49','2014-04-06 16:32:49',139,'G19','','German Man 000000',NULL,'Inactive','Russia'),('2014-04-06 16:32:49','2014-04-06 16:32:49',140,'G20','','Sprunch','Operated by West german intelligence','Inactive','West Germany'),('2014-04-06 16:32:49','2014-04-06 16:32:49',141,'G20a','','A- One 5F group','Operated by west German intelligence','Inactive','West Germany'),('2014-04-06 16:32:49','2014-04-06 16:32:49',142,'G21','','Random Pop (Music ',NULL,'Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',143,'G22','','Edna Sednitzer',NULL,'Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',144,'G23','','2M8, Hitler\'s Birthday','Very little is known about this station','Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',145,'V01','','Ciocîrlia The Skylark - Romanian',NULL,'Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',146,'V01a','','A- With additional tune',NULL,'Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',147,'V02','','Spanish Lady/Atencion',NULL,'Inactive',NULL),('2014-04-06 16:32:49','2014-04-06 16:32:49',148,'V02a','','Spanish Lady/Atencion','In each message broadcasts 3 messages of 150 groups each. Before them for 3 minutes is repeated word ¡Atención! followed by 3 5 figure headers, believed to contain actual group count and indications if it\'s real message or not.','Active','Cuba'),('2014-04-06 16:32:50','2014-04-06 16:32:50',149,'V02b','',NULL,NULL,'Unknown',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',150,'V02c','',NULL,NULL,'Unknown',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',151,'V03','',NULL,NULL,'Unknown',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',152,'V04','',NULL,NULL,'Unknown',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',153,'V05','','Counting- Spanish 3/2F',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',154,'V05a','','A- 4F',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',155,'V06','','Spanish Lady 00000',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',156,'V06a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',157,'V07','','Spanish Man 000 000','V07 has traditionally been reported most often by listeners in Europe, it has been in operation since at least as early as 1995. It is a station with a spotty reporting history and was not reported often between 2006 and 2011. Starting in early 2011 it was noted by listeners on the west coast of the USA.','Active',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',158,'V08','','Eastern Music Arabic',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',159,'V09','','Oriental Language','Chinese/Korean - uncertain, reluctant to classify.','Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',160,'V10','','Schlosst',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',161,'V10a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',162,'V11','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',163,'V12','','NNN',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',164,'V13','','New Star Broadcasting','Messages are broadcast daily at 0500, 0600, 1200 and 1300z on one of its two freqencies, 9505 and 9725.','Active','Taiwan'),('2014-04-06 16:32:50','2014-04-06 16:32:50',165,'V14','','Counting \'control\' - Spanish',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',166,'V15','','North Korean - Via Radio Pyongyang',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',167,'V16','','Chinese',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',168,'V17','','Romanian 3F + 000',NULL,'Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:50',169,'V18','','NNN (Hungarian)','The Hungarian language version of the NNN family. ','Inactive',NULL),('2014-04-06 16:32:50','2014-04-06 16:32:51',170,'V19','','WTR21 (\"Dont Cry For Me Argentina\")',NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',171,'V20','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',172,'V21','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',173,'V22','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',174,'V23','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',175,'V24','',NULL,'Despite this station being active, there is little information on it.','Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',176,'V25','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',177,'V26','','XSA/XSE23','Regular freq\'s: 4243, 4283, 7553, 9153. though has used others.','Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',178,'V27','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',179,'','VC01','VC01 - The Chinese Robot','Very fast female voice (3 numbers per second)','Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',180,'X01','','Bugle','A horn playing, possibly to signal the start of another Station','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',181,'X06','','Mazielka',NULL,'Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',182,'X06a','','Mazielka',NULL,'Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',183,'X06b','','Mazielka',NULL,'Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',184,'X06c','','Mazielka',NULL,'Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',185,'XB','','The Buzzer','XB was the old ID of S28 until it began sending messages. Now Deleted','Deleted','Russia'),('2014-04-06 16:32:51','2014-04-06 16:32:51',186,'XC','','Crackle','This transmission sounded like \"cans being dragged on the floor\". Like in the most of noise stations, no one knows what it actually was. Its home frequencies were 5500 and 5505 kHz interfering with Shannon VOLMET. Inactive as of 2009, may return','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',187,'XE','','Echo','last heard in 1999','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',188,'XF','','Faders','Not heard since 2001','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',189,'XM','','Backwards Music Station/Whales','XM style transmission caught by Scansweden 4840 2011-07-06 20:00-20:35 (start time unknown) posted up XM as closest station, but we are unsure.','Active',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',190,'XS','','Saw/Whine','The saw (buzzsaw, whine) is a jamming station, consisting of a long buzz-like sound.','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:51',191,'XW','','Workshop','The Workshop is believed to be a Russian jamming station. It is simply a live microphone (or recording) of clacking, banging, drilling, ect. Sometimes, a voice, in Russian, is heard in the background. It has not appeared for many years.','Inactive',NULL),('2014-04-06 16:32:51','2014-04-06 16:32:52',192,'XX','','The Pip','The origional ID S30 (The Pip) until a voice broadcast was heard.','Deleted',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',193,'XT','','The Pip','This designator replaced previously used XX and has been superseded by S30 in March 1999. ','Deleted',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',194,'M01','','Two Tone','Ends 000 and is Hand Keyed','Active',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',195,'M01a','',NULL,'A- End of month Varient','Active',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',196,'M01b','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',197,'M01c','',NULL,'C - other variants incl. 3 long dash ending ','Active',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',198,'M02','',NULL,'Ends AR, Long zero','Inactive',NULL),('2014-04-06 16:32:52','2014-04-06 16:32:52',199,'M03','',NULL,'This station is Morse counterpart to voice stations from family 3. Format is almost same, of course with changes due to Morse code. Uses short zero (T) and sends messages at approx 15 wpm. Mode is ICW.','Active','Poland'),('2014-04-06 16:32:52','2014-04-06 16:32:52',200,'M03a','','A- with Triplet element',NULL,'Active','Poland'),('2014-04-06 16:32:52','2014-04-06 16:32:52',201,'M03b','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',202,'M04','',NULL,'This station was Morse counterpart to G02 (E23). Operating mode was always MCW. Format: U (repeated for 10 minutes) LO LO LO LO LO LO/xxxxx [5f ID] = = [100x5f message] LO LO/xxxxx = = [repeat of message] AR SK AR SK.','Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',203,'M05','',NULL,'6fig 000000, Long Zero','Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',204,'M06','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',205,'M06a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',206,'M07','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',207,'M08','',NULL,'Superseded by M8a','Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',208,'M8a','',NULL,'Morse station counterpart to its voice equivalent V02a. Coming from Cuba.','Active',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',209,'M10','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',210,'M10a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',211,'M10b','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',212,'M10c','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',213,'M12','',NULL,'E07, G07, S07 and V07 are counterpart voice stations. XPA is counterpart digital station.','Active',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',214,'M13','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',215,'M13a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',216,'M14','',NULL,'frequency: 5464','Active',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',217,'M15','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',218,'M16','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',219,'M17','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',220,'M18','',NULL,'4fig pseudo time signal','Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',221,'M19','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',222,'M20','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',223,'M21','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:53','2014-04-06 16:32:53',224,'M22','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',225,'M23','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',226,'M24','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',227,'M24a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',228,'M25','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',229,'M26','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',230,'M27','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',231,'M28','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',232,'M29','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',233,'M29a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',234,'M31','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',235,'M32','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',236,'M33','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',237,'M34','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',238,'M39','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',239,'M40','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',240,'M41','',NULL,NULL,'Inactice',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:54',241,'M42','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:54','2014-04-06 16:32:55',242,'M43','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',243,'M44','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',244,'M45','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',245,'M46','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',246,'M47','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',247,'M48','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',248,'M49','',NULL,'G8a morse','Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',249,'M50','',NULL,'Hand keyed 5431khz + 4947khz MANY VARIANTS (related to M1?) ','Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',250,'M51','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',251,'M52','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',252,'M53','',NULL,'After being confired to be M40 was deleted.','Deleted',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',253,'M54','','V98T','Not much is known about this morse station. It has only ever been see to broadcast null messages. This may suggest that it is part of another station alerting the agent to there not being a message at the next scheduled time. The null message reads \"V98T\" hence the name.','Inactive',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',254,'M55','',NULL,'Very occasionally sends a null message containing 5x 3 figures then 000 000','Active',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',255,'M56','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:55','2014-04-06 16:32:55',256,'M62','','LNLL','Believed to be operated by the sloakian millitary','Active',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',257,'M63','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',258,'M64','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',259,'M65','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',260,'M67','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',261,'M67a','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',262,'M68','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',263,'M69','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',264,'M70','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',265,'M71','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:56','2014-04-06 16:32:56',266,'M72','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',267,'M73','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',268,'M74','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',269,'M75','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',270,'M76','',NULL,'complex msg structures, multiple messages, 25 wpm','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',271,'M77','',NULL,'P7X, around 11445kHz, 20.00/21.00/21.30z','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',272,'M78','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',273,'M79','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',274,'M80','',NULL,'Possibly M1a, with different call.','Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',275,'M81','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',276,'M82','',NULL,'\"BML\" North Korean Army ?','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',277,'M83','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',278,'M83a','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',279,'M83b','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',280,'M83c','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',281,'M86','',NULL,'Deleted now M*a','Deleted',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',282,'M87','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',283,'M88','',NULL,'Deleted, IDed as M03 null format','Deleted',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',284,'M89','',NULL,NULL,'Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',285,'M90','',NULL,'Czech Military, MCW, Hand Keyed','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',286,'M91','',NULL,'Czech military, MCW and Hand keyed','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',287,'M92','',NULL,'Czech military','Active',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',288,'M93','',NULL,NULL,'Inactive',NULL),('2014-04-06 16:32:57','2014-04-06 16:32:57',289,'M94','',NULL,'MCW station sistering voice station V24','Active','South Korea'),('2014-04-06 16:32:58','2014-04-06 16:32:58',290,'M95','',NULL,'CW Sister station to V26 Chinese voice station.','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',291,'MX','',NULL,'SLHFB\'s (Single Letter HF Beacons) Solitary','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',292,'MXI','',NULL,'SLHFB clusters ( group of beacons v.close in freq, c 0.1kHz apart)','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',293,'MXII','',NULL,'FSK mode TX','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',294,'MXIII','',NULL,'WITHDRAWN, MX covers','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',295,'MXIV','',NULL,'WITHDRAWN, MX covers','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',296,'MXP','',NULL,'With message, probably Russ. Naval','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',297,'MXV','',NULL,'Irregular \"V\"','Active',NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',298,'','I_Dm1',NULL,' ','heard once','Russia?'),('2014-04-06 16:32:58','2014-04-06 16:32:58',299,'','D_Dm1',NULL,' ',NULL,NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',300,'','D_Do1',NULL,'None yet',NULL,NULL),('2014-04-06 16:32:58','2014-04-06 16:32:58',301,'None','I_Df2','FSK 200Bd/1000Hz','FSK digital mode used by Russian intelligence.','Active','Russia'),('2014-04-06 16:32:58','2014-04-06 16:32:58',302,'None','I_Df3','FSK 200Bd/500Hz','FSK digital mode used by Russian intelligence.','Active','Russia'),('2014-04-06 16:32:58','2014-04-06 16:32:58',303,'None','None','Plavets-41','Russian military station linked with the Buzzer, The pip and the Squeaky Wheel','Active','Ekaterinburg');
/*!40000 ALTER TABLE `stations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_content_nodes`
--
LOCK TABLES `transmission_content_nodes` WRITE;
/*!40000 ALTER TABLE `transmission_content_nodes` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmission_content_nodes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_contents`
--
LOCK TABLES `transmission_contents` WRITE;
/*!40000 ALTER TABLE `transmission_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmission_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_format_nodes`
--
LOCK TABLES `transmission_format_nodes` WRITE;
/*!40000 ALTER TABLE `transmission_format_nodes` DISABLE KEYS */;
INSERT INTO `transmission_format_nodes` VALUES (1,NULL,NULL,'1',0,NULL,NULL,NULL,0,'S28 style message'),(2,1,0,'+',0,NULL,' ','callwrap',1,'Group callsigns separated with space'),(3,1,1,'1',0,NULL,' ',NULL,0,'Single space'),(4,1,2,'+',0,NULL,' ','messagewrap',1,'Join message parts'),(5,2,0,'1',1,NULL,'[0-9]{2}\\s+[0-9]{3}','call',0,'âCallsignâ'),(6,4,0,'1',0,NULL,NULL,NULL,0,'A single message'),(7,6,0,'1',1,NULL,'\\w+','codeword',0,'Single word'),(8,6,1,'1',0,NULL,' ',NULL,0,'Single space'),(9,6,2,'1',1,NULL,'([0-9]{2} ){3}[0-9]{2}','numbers',0,'Four two-digit numbers'),(10,NULL,NULL,'1',0,NULL,NULL,NULL,0,'3/4 digit ID + group count + 5 digit groups'),(11,10,0,'1',1,NULL,'[0-9?]{3,4}','id',0,'ID'),(12,10,1,'+',0,NULL,' ',NULL,0,'Space'),(13,10,2,'1',1,NULL,'[0-9?]{1,5}','group_count',0,'Group count'),(14,10,3,'+',0,NULL,' ',NULL,0,'Space'),(15,10,4,'1',0,NULL,' ','groupwrap',1,'Groups, joined with single space'),(16,15,0,'1',0,NULL,'[0-9?]{5}','group',0,'5 digit group'),(79,NULL,NULL,'1',0,NULL,NULL,NULL,0,'3/4 digit ID + group count + 5 digit groups'),(80,79,0,'1',1,NULL,'[0-9?]{3,4}','id',0,'ID'),(81,79,1,'+',0,NULL,' ',NULL,0,'Space'),(82,79,2,'1',1,NULL,'[0-9?]{1,5}','group_count',0,'Group count'),(83,79,3,'+',0,NULL,' ',NULL,0,'Space'),(84,79,4,'+',0,NULL,' ','groupwrap',1,'Groups, joined with single space'),(85,84,0,'1',0,NULL,'[0-9?]{5}','group',0,'5 digit group'),(90,NULL,NULL,'1',0,NULL,NULL,NULL,0,'3/4 digit ID + group count, without message'),(91,90,0,'1',1,NULL,'[0-9?]{3,4}','id',0,'ID'),(92,90,1,'+',0,NULL,' ',NULL,0,'Space'),(93,90,2,'1',1,NULL,'[0-9?]{1,5}','group_count',0,'Group count'),(104,NULL,NULL,'1',0,NULL,NULL,NULL,0,'4 figures'),(105,104,0,'*',0,NULL,' ','messagewrap',1,'messagewrap'),(106,105,0,'1',1,NULL,'[0-9?]{4}','group',0,'4 figure group'),(109,NULL,NULL,'+',0,NULL,' ',NULL,1,'5 figures'),(110,109,0,'+',0,NULL,' ','messagewrap',1,'messagewrap'),(111,110,0,'1',1,NULL,'[0-9?]{5}','group',0,'5 figure group'),(122,NULL,NULL,'1',0,NULL,NULL,NULL,0,'dlya groups of codeword + number'),(123,122,0,'+',0,NULL,' ','messagewrap',1,'messagewrap'),(124,123,0,'1',0,NULL,NULL,NULL,0,'dlya group of codeword + number'),(125,124,0,'1',1,NULL,'\\w+','codeword',0,'dlya codeword'),(126,124,1,'1',0,NULL,' ',NULL,0,'space'),(127,124,2,'1',1,NULL,'[0-9?]{2}','number',0,'dlya number');
/*!40000 ALTER TABLE `transmission_format_nodes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_formats`
--
LOCK TABLES `transmission_formats` WRITE;
/*!40000 ALTER TABLE `transmission_formats` DISABLE KEYS */;
INSERT INTO `transmission_formats` VALUES ('2014-04-06 16:34:37','2014-04-06 16:34:37',1,'MDZhB (UZB-76) standard format','',1),('2014-04-06 16:45:00','2014-04-06 18:03:14',2,'3/4 digit ID + group count + 5 digit groups','Example: 123 4 12345 12345 12345 12345',79),('2014-04-06 17:54:42','2014-04-06 18:07:57',3,'3/4 digit ID + group count, without message','Example: 123 4',90),('2014-04-06 17:57:23','2014-04-06 18:35:39',4,'4 figure groups','Example: 1234 1234 1234',104),('2014-04-06 17:58:20','2014-04-06 18:40:31',5,'5 figure groups','Example: 12345 12345 12345',109),('2014-04-06 18:02:05','2014-04-06 18:45:11',6,'dlya groups of codeword + number','Example: FOO 12 BAR 34',122);
/*!40000 ALTER TABLE `transmission_formats` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_raw_contents`
--
LOCK TABLES `transmission_raw_contents` WRITE;
/*!40000 ALTER TABLE `transmission_raw_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmission_raw_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `transmission_structured_contents`
--
LOCK TABLES `transmission_structured_contents` WRITE;
/*!40000 ALTER TABLE `transmission_structured_contents` DISABLE KEYS */;
/*!40000 ALTER TABLE `transmission_structured_contents` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `user_capabilities`
--
LOCK TABLES `user_capabilities` WRITE;
/*!40000 ALTER TABLE `user_capabilities` DISABLE KEYS */;
INSERT INTO `user_capabilities` VALUES (1,1),(1,2),(1,1),(1,2),(1,1),(1,2);
/*!40000 ALTER TABLE `user_capabilities` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `user_sessions`
--
LOCK TABLES `user_sessions` WRITE;
/*!40000 ALTER TABLE `user_sessions` DISABLE KEYS */;
INSERT INTO `user_sessions` VALUES (1,'tð»çÓô\'R\rJÁa&·i¢«iïR +-\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',1,'2014-04-13 16:33:09');
/*!40000 ALTER TABLE `user_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2014-04-06 20:51:06