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
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
|
--
-- Daten für Tabelle `abschluss`
--
REPLACE INTO `abschluss` (`abschluss_id`, `name`, `name_kurz`, `beschreibung`, `author_id`, `editor_id`, `mkdate`, `chdate`) VALUES('228234544820cdf75db55b42d1ea3ecc', 'Bachelor', NULL, '', '', '', 1311416359, 1311416359);
REPLACE INTO `abschluss` (`abschluss_id`, `name`, `name_kurz`, `beschreibung`, `author_id`, `editor_id`, `mkdate`, `chdate`) VALUES('c7f569e815a35cf24a515a0e67928072', 'Master', NULL, '', '', '', 1311416385, 1311416385);
--
-- Daten für Tabelle `auth_user_md5`
--
REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('205f3efb7997a0fc9755da2b535038da', 'test_dozent', 0x24326124303824616a497667456a6431374d696944634672366d73632e786c646b6e482f745447616a555856684478444b4e4a565830483069763069, 'dozent', 'Testaccount', 'Dozent', 'dozent@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('6235c46eb9e962866ebdceece739ace5', 'test_admin', 0x24326124303824737676536d6132307649784952344a356763306a49753331677773315769626d69512f4844684354756b4641354771687363593147, 'admin', 'Testaccount', 'Admin', 'admin@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('76ed43ef286fb55cf9e41beadb484a9f', 'root@studip', 0x2432612430382453526f43597841685750465646385638434f3135544f797a722e50704c52665644396c565756726d6d42773462726b5254452f3247, 'root', 'Root', 'Studip', 'root@localhost', '', 'standard', 0, NULL, NULL, 'yes', NULL);
REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('7e81ec247c151c02ffd479511e24cc03', 'test_tutor', 0x243261243038246d4768426c3835545073694974756d5a34786a62674f6e5131767149684c414339676943665763467a706b45316a7165346c6d6279, 'tutor', 'Testaccount', 'Tutor', 'tutor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', NULL);
REPLACE INTO `auth_user_md5` (`user_id`, `username`, `password`, `perms`, `Vorname`, `Nachname`, `Email`, `validation_key`, `auth_plugin`, `locked`, `lock_comment`, `locked_by`, `visible`, `matriculation_number`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', 'test_autor', 0x24326124303824787662727650686b6373766b7a505a734e682e6b63654c7732494977694e4a2e316a474f7759332e482f645232663850473558334f, 'autor', 'Testaccount', 'Autor', 'autor@studip.de', '', 'standard', 0, NULL, NULL, 'unknown', '1234567');
--
-- Daten für Tabelle `config_values`
--
REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`, `comment`) VALUES('STUDYGROUPS_ENABLE', 'studip', '1', 1268739461, 1268739461, 'Studiengruppen');
REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`, `comment`) VALUES('STUDYGROUP_DEFAULT_INST', 'studip', 'ec2e364b28357106c0f8c282733dbe56', 1268739461, 1268739461, '');
REPLACE INTO `config_values` (`field`, `range_id`, `value`, `mkdate`, `chdate`, `comment`) VALUES('STUDYGROUP_TERMS', 'studip', 'Mir ist bekannt, dass ich die Gruppe nicht zu rechtswidrigen Zwecken nutzen darf. Dazu zählen u.a. Urheberrechtsverletzungen, Beleidigungen und andere Persönlichkeitsdelikte.\r\n\r\nIch erkläre mich damit einverstanden, dass Administratorinnen und Administratoren die Inhalte der Gruppe zu Kontrollzwecken einsehen dürfen.', 1268739461, 1268739461, '');
--
-- Dumping data for table `fach`
--
REPLACE INTO `fach` (`fach_id`, `name`, `name_kurz`, `beschreibung`, `schlagworte`, `author_id`, `editor_id`, `mkdate`, `chdate`) VALUES('6b9ac09535885ca55e29dd011e377c0a', 'Geschichte', NULL, '', NULL, '', '', 1311416418, 1311416418);
REPLACE INTO `fach` (`fach_id`, `name`, `name_kurz`, `beschreibung`, `schlagworte`, `author_id`, `editor_id`, `mkdate`, `chdate`) VALUES('f981c9b42ca72788a09da4a45794a737', 'Informatik', NULL, '', NULL, '', '', 1311416397, 1311416397);
--
-- Dumping data for table `files`
--
REPLACE INTO `files` (`id`, `user_id`, `mime_type`, `name`, `filetype`, `size`, `metadata`, `author_name`, `mkdate`, `chdate`) VALUES('b86665948274be968d78777830990eb5', '76ed43ef286fb55cf9e41beadb484a9f', '0', 'mappe_studip-el.pdf', 'URLFile', 314146, '{\"url\":\"https:\\/\\/www.studip.de\\/download\\/mappe_studip-el.pdf\",\"access_type\":\"redirect\"}', 'Root Studip', 1607705144, 1607705144);
--
-- Dumping data for table `file_refs`
--
REPLACE INTO `file_refs` (`id`, `file_id`, `folder_id`, `downloads`, `description`, `content_terms_of_use_id`, `user_id`, `name`, `mkdate`, `chdate`) VALUES('f62768f0cbd0bcdc4912ce5e4f84eb14', 'b86665948274be968d78777830990eb5', 'f7fc5ae64d2c453daa9619a820a6467e', 1, '', 'FREE_LICENSE', '76ed43ef286fb55cf9e41beadb484a9f', 'mappe_studip-el.pdf', 1607705144, 1607705144);
--
-- Dumping data for table `folders`
--
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('012cb91a42cf85e5fafdd84e54ed2ec3', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'CourseDateFolder', '15. Klausur am Sa., 15.02.2025, 11:00 - 12:30', '{\"termin_id\":\"86de155d92a8f2da7ed6cd8ed9c08d71\",\"permission\":5}', '', 1543859055, 1543859055);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('3cc9006789bceef5d3ea7bed680790b4', '76ed43ef286fb55cf9e41beadb484a9f', '', '110ce78ffefaf1e5f167cd7019b728bf', 'institute', 'RootFolder', 'externe Einrichtung B', '', '', 1510849315, 1510849315);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('694cdcef09c2b8e70a7313b028e36fb6', '', '3cc9006789bceef5d3ea7bed680790b4', '110ce78ffefaf1e5f167cd7019b728bf', 'institute', 'StandardFolder', 'Allgemeiner Dateiordner', '', 'Ablage für allgemeine Ordner und Dokumente der Einrichtung', 1156516698, 1156516698);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('76b822dcc7f1458ae6e144c3c0fb544e', '76ed43ef286fb55cf9e41beadb484a9f', '', 'ec2e364b28357106c0f8c282733dbe56', 'institute', 'RootFolder', 'externe Bildungseinrichtungen', '', '', 1510849315, 1510849315);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('9082368f7e01b24af15178d0d954f4dc', '76ed43ef286fb55cf9e41beadb484a9f', '', '7a4f19a0a2c321ab2b8f7b798881af7c', 'institute', 'RootFolder', 'externe Einrichtung A', '', '', 1510849315, 1510849315);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('ad8dc6a6162fb0fe022af4a62a15e309', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'HomeworkFolder', 'Hausaufgaben', '{\"permission\":\"3\"}', '', 1343924873, 1343924877);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('b58081c411c76814bc8f78425fb2ab81', '', '9082368f7e01b24af15178d0d954f4dc', '7a4f19a0a2c321ab2b8f7b798881af7c', 'institute', 'StandardFolder', 'Allgemeiner Dateiordner', '', 'Ablage für allgemeine Ordner und Dokumente der Einrichtung', 1156516698, 1156516698);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('bc63814f56ec1bbbba731e07d0074b45', '76ed43ef286fb55cf9e41beadb484a9f', '', '76ed43ef286fb55cf9e41beadb484a9f', 'user', 'RootFolder', '', '[]', '', 1543858972, 1543858972);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('ca002fbae136b07e4df29e0136e3bd32', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'StandardFolder', 'Allgemeiner Dateiordner', '', 'Ablage für allgemeine Ordner und Dokumente der Veranstaltung', 1343924407, 1343924894);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('da3c2c2b4ea4c9781dccbae6eade5721', '76ed43ef286fb55cf9e41beadb484a9f', '', '7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 'RootFolder', 'Test Studiengruppe', '', '', 1510849315, 1510849315);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('dad53cd0f0d9f36817c3c9c7c124bda3', '', '76b822dcc7f1458ae6e144c3c0fb544e', 'ec2e364b28357106c0f8c282733dbe56', 'institute', 'StandardFolder', 'Allgemeiner Dateiordner', '', 'Ablage für allgemeine Ordner und Dokumente der Einrichtung', 1156516698, 1156516698);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('df122112a21812ff4ffcf1965cb48fc3', '76ed43ef286fb55cf9e41beadb484a9f', 'f7fc5ae64d2c453daa9619a820a6467e', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'CourseGroupFolder', 'Dateiordner der Gruppe: Studierende', '{\"group\":\"2f597139a049a768dbf8345a0a0af3de\"}', 'Ablage für Ordner und Dokumente dieser Gruppe', 1343924860, 1343924860);
REPLACE INTO `folders` (`id`, `user_id`, `parent_id`, `range_id`, `range_type`, `folder_type`, `name`, `data_content`, `description`, `mkdate`, `chdate`) VALUES('f7fc5ae64d2c453daa9619a820a6467e', '76ed43ef286fb55cf9e41beadb484a9f', '', 'a07535cf2f8a72df33c12ddfa4b53dde', 'course', 'RootFolder', 'Test Lehrveranstaltung', '', '', 1510849315, 1510849315);
--
-- Daten für Tabelle `Institute`
--
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('110ce78ffefaf1e5f167cd7019b728bf', 'externe Einrichtung B', 'ec2e364b28357106c0f8c282733dbe56', '', '', '', '', '', '', 1, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('1535795b0d6ddecac6813f5f6ac47ef2', 'Test Fakultät', '1535795b0d6ddecac6813f5f6ac47ef2', 'Geismar Landstr. 17b', '37083 Göttingen', 'http://www.studip.de', '0551 / 381 985 0', 'testfakultaet@studip.de', '0551 / 381 985 3', 1, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('2560f7c7674942a7dce8eeb238e15d93', 'Test Einrichtung', '1535795b0d6ddecac6813f5f6ac47ef2', '', '', '', '', '', '', 1, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('536249daa596905f433e1f73578019db', 'Test Lehrstuhl', '1535795b0d6ddecac6813f5f6ac47ef2', '', '', '', '', '', '', 3, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('7a4f19a0a2c321ab2b8f7b798881af7c', 'externe Einrichtung A', 'ec2e364b28357106c0f8c282733dbe56', '', '', '', '', '', '', 1, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('ec2e364b28357106c0f8c282733dbe56', 'externe Bildungseinrichtungen', 'ec2e364b28357106c0f8c282733dbe56', '', '', '', '', '', '', 1, 1156516698, 1156516698, 'Studip', 0, '');
REPLACE INTO `Institute` (`Institut_id`, `Name`, `fakultaets_id`, `Strasse`, `Plz`, `url`, `telefon`, `email`, `fax`, `type`, `mkdate`, `chdate`, `lit_plugin_name`, `srienabled`, `lock_rule`) VALUES('f02e2b17bc0e99fc885da6ac4c2532dc', 'Test Abteilung', '1535795b0d6ddecac6813f5f6ac47ef2', '', '', '', '', '', '', 4, 1156516698, 1156516698, 'Studip', 0, '');
--
-- Daten für Tabelle `news_rss_range`
--
REPLACE INTO `news_rss_range` (`range_id`, `rss_id`, `range_type`) VALUES('studip', '70cefd1e80398bb20ff599636546cdff', 'global');
--
-- Daten für Tabelle `tools_activated`
--
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('110ce78ffefaf1e5f167cd7019b728bf', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('110ce78ffefaf1e5f167cd7019b728bf', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('110ce78ffefaf1e5f167cd7019b728bf', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('1535795b0d6ddecac6813f5f6ac47ef2', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('1535795b0d6ddecac6813f5f6ac47ef2', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('1535795b0d6ddecac6813f5f6ac47ef2', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('2560f7c7674942a7dce8eeb238e15d93', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('2560f7c7674942a7dce8eeb238e15d93', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('2560f7c7674942a7dce8eeb238e15d93', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('536249daa596905f433e1f73578019db', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('536249daa596905f433e1f73578019db', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('536249daa596905f433e1f73578019db', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7a4f19a0a2c321ab2b8f7b798881af7c', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7a4f19a0a2c321ab2b8f7b798881af7c', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7a4f19a0a2c321ab2b8f7b798881af7c', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 1, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 16, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 17, 3, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 19, 4, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'course', 22, 5, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 1, 3, '[]', 1640880515, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 2, 4, '[]', 1640880515, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 13, 10, '[]', 1640885044, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 17, 2, '[]', 1640880515, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 18, 7, '[]', 1640880515, 1640885063);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 20, 8, '[]', 1640880515, 1640885063);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 21, 9, '[]', 1640880515, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 22, 6, '[]', 1640880515, 1640885061);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'course', 26, 5, '[]', 1640885037, 1640885052);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('ec2e364b28357106c0f8c282733dbe56', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('ec2e364b28357106c0f8c282733dbe56', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('ec2e364b28357106c0f8c282733dbe56', 'institute', 25, 2, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('f02e2b17bc0e99fc885da6ac4c2532dc', 'institute', 14, 0, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('f02e2b17bc0e99fc885da6ac4c2532dc', 'institute', 15, 1, NULL, 1640880515, 1640880515);
REPLACE INTO `tools_activated` (`range_id`, `range_type`, `plugin_id`, `position`, `metadata`, `mkdate`, `chdate`) VALUES('f02e2b17bc0e99fc885da6ac4c2532dc', 'institute', 25, 2, NULL, 1640880515, 1640880515);
--
-- Daten für Tabelle `range_tree`
--
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('3f93863e3d37ba0df286a6e7e26974ef', 'root', 0, 0, 'Einrichtungen der Universität', '', '');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('1323254564871354786157481484621', '3f93863e3d37ba0df286a6e7e26974ef', 1, 0, '', 'inst', '1535795b0d6ddecac6813f5f6ac47ef2');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('ce6c87bbf759b4cfd6f92d0c5560da5c', '1323254564871354786157481484621', 0, 0, 'Test Einrichtung', 'inst', '2560f7c7674942a7dce8eeb238e15d93');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('2f4f90ac9d8d832cc8c8a95910fde4eb', '1323254564871354786157481484621', 0, 1, 'Test Lehrstuhl', 'inst', '536249daa596905f433e1f73578019db');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('5d032f70c255f3e57cf8aa85a429ad4e', '1323254564871354786157481484621', 0, 2, 'Test Abteilung', 'inst', 'f02e2b17bc0e99fc885da6ac4c2532dc');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('a3d977a66f0010fa8e15c27dd71aff63', 'root', 0, 1, 'externe Bildungseinrichtungen', 'fak', 'ec2e364b28357106c0f8c282733dbe56');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('e0ff0ead6a8c5191078ed787cd7c0c1f', 'a3d977a66f0010fa8e15c27dd71aff63', 0, 0, 'externe Einrichtung A', 'inst', '7a4f19a0a2c321ab2b8f7b798881af7c');
REPLACE INTO `range_tree` (`item_id`, `parent_id`, `level`, `priority`, `name`, `studip_object`, `studip_object_id`) VALUES('105b70b72dc1908ce2925e057c4a8daa', 'a3d977a66f0010fa8e15c27dd71aff63', 0, 1, 'externe Einrichtung B', 'inst', '110ce78ffefaf1e5f167cd7019b728bf');
--
-- Daten für Tabelle `scm`
--
REPLACE INTO `scm` (`scm_id`, `range_id`, `user_id`, `tab_name`, `content`, `mkdate`, `chdate`, `position`) VALUES('a07df31918cc8e5ca0597e959a4a5297', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', 'Informationen', '', 1343924407, 1343924407, 0);
--
-- Dumping data for table `semester_courses`
--
REPLACE INTO `semester_courses` (`semester_id`, `course_id`, `mkdate`, `chdate`) VALUES('4967f0a483e36554b77e3dc47aa58941', 'a07535cf2f8a72df33c12ddfa4b53dde', 1641490271, 1641490271);
--
-- Dumping data for table `seminare`
--
REPLACE INTO `seminare` (`Seminar_id`, `VeranstaltungsNummer`, `Institut_id`, `Name`, `Untertitel`, `status`, `Beschreibung`, `Ort`, `Sonstiges`, `Lesezugriff`, `Schreibzugriff`, `start_time`, `duration_time`, `art`, `teilnehmer`, `vorrausetzungen`, `lernorga`, `leistungsnachweis`, `mkdate`, `chdate`, `ects`, `admission_turnout`, `admission_binding`, `admission_prelim`, `admission_prelim_txt`, `admission_disable_waitlist`, `visible`, `showscore`, `aux_lock_rule`, `aux_lock_rule_forced`, `lock_rule`, `admission_waitlist_max`, `admission_disable_waitlist_move`, `completion`, `parent_course`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', '', 'ec2e364b28357106c0f8c282733dbe56', 'Test Studiengruppe', '', 99, 'Studiengruppen sind eine einfache Möglichkeit, mit KommilitonInnen, KollegInnen und anderen zusammenzuarbeiten.', '', '', 1, 1, 1680300000, -1, '', '', '', '', '', 1268739824, 1607705186, '', 0, 0, 0, '', 0, 1, 0, NULL, 0, NULL, 0, 0, 0, NULL);
REPLACE INTO `seminare` (`Seminar_id`, `VeranstaltungsNummer`, `Institut_id`, `Name`, `Untertitel`, `status`, `Beschreibung`, `Ort`, `Sonstiges`, `Lesezugriff`, `Schreibzugriff`, `start_time`, `duration_time`, `art`, `teilnehmer`, `vorrausetzungen`, `lernorga`, `leistungsnachweis`, `mkdate`, `chdate`, `ects`, `admission_turnout`, `admission_binding`, `admission_prelim`, `admission_prelim_txt`, `admission_disable_waitlist`, `visible`, `showscore`, `aux_lock_rule`, `aux_lock_rule_forced`, `lock_rule`, `admission_waitlist_max`, `admission_disable_waitlist_move`, `completion`, `parent_course`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '12345', '2560f7c7674942a7dce8eeb238e15d93', 'Test Lehrveranstaltung', 'eine normale Lehrveranstaltung', 1, '', '', '', 1, 1, 1727733600, 0, '', 'für alle Studierenden', 'abgeschlossenes Grundstudium', 'Referate in Gruppenarbeit', 'Klausur', 1343924407, 1716388347, '4', 0, 0, 0, '', 0, 1, 0, NULL, 0, NULL, 0, 0, 0, NULL);
--
-- Dumping data for table `seminar_cycle_dates`
--
REPLACE INTO `seminar_cycle_dates` (`metadate_id`, `seminar_id`, `start_time`, `end_time`, `weekday`, `description`, `sws`, `cycle`, `week_offset`, `end_offset`, `sorter`, `mkdate`, `chdate`) VALUES('fc3c44f257e448e3cd36a88406a8a9c1', 'a07535cf2f8a72df33c12ddfa4b53dde', '09:00:00', '11:00:00', 1, '', '0.0', 0, 0, 15, 0, 1530291739, 1698856934);
--
-- Daten für Tabelle `seminar_inst`
--
REPLACE INTO `seminar_inst` (`seminar_id`, `institut_id`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '2560f7c7674942a7dce8eeb238e15d93');
--
-- Daten für Tabelle `seminar_sem_tree`
--
REPLACE INTO `seminar_sem_tree` (`seminar_id`, `sem_tree_id`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '3d39528c1d560441fd4a8cb0b7717285');
REPLACE INTO `seminar_sem_tree` (`seminar_id`, `sem_tree_id`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '5c41d2b4a5a8338e069dda987a624b74');
REPLACE INTO `seminar_sem_tree` (`seminar_id`, `sem_tree_id`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'dd7fff9151e85e7130cdb684edf0c370');
--
-- Daten für Tabelle `seminar_user`
--
REPLACE INTO `seminar_user` (`Seminar_id`, `user_id`, `status`, `position`, `gruppe`, `mkdate`, `comment`, `visible`, `label`, `bind_calendar`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', 'e7a0a84b161f3e8c09b4a0a2e8a58147', 'autor', 0, 5, 1343924589, '', 'unknown', '', 1);
REPLACE INTO `seminar_user` (`Seminar_id`, `user_id`, `status`, `position`, `gruppe`, `mkdate`, `comment`, `visible`, `label`, `bind_calendar`) VALUES('7cb72dab1bf896a0b55c6aa7a70a3a86', 'e7a0a84b161f3e8c09b4a0a2e8a58147', 'dozent', 0, 8, 0, '', 'unknown', '', 1);
REPLACE INTO `seminar_user` (`Seminar_id`, `user_id`, `status`, `position`, `gruppe`, `mkdate`, `comment`, `visible`, `label`, `bind_calendar`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '205f3efb7997a0fc9755da2b535038da', 'dozent', 0, 5, 1343924407, '', 'yes', '', 1);
REPLACE INTO `seminar_user` (`Seminar_id`, `user_id`, `status`, `position`, `gruppe`, `mkdate`, `comment`, `visible`, `label`, `bind_calendar`) VALUES('a07535cf2f8a72df33c12ddfa4b53dde', '7e81ec247c151c02ffd479511e24cc03', 'tutor', 0, 5, 1343924407, '', 'yes', '', 1);
--
-- Daten für Tabelle `sem_tree`
--
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('5b73e28644a3e259a6e0bc1e1499773c', 'root', 1, '', 'Test Fakultät', NULL, 0);
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('439618ae57d8c10dcaabcf7e21bcc1d9', '5b73e28644a3e259a6e0bc1e1499773c', 0, '', 'Test Studienbereich A', NULL, 0);
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('5c41d2b4a5a8338e069dda987a624b74', '5b73e28644a3e259a6e0bc1e1499773c', 1, '', 'Test Studienbereich B', NULL, 0);
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('3d39528c1d560441fd4a8cb0b7717285', '439618ae57d8c10dcaabcf7e21bcc1d9', 0, '', 'Test Studienbereich A-1', NULL, 0);
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('dd7fff9151e85e7130cdb684edf0c370', '439618ae57d8c10dcaabcf7e21bcc1d9', 1, '', 'Test Studienbereich A-2', NULL, 0);
REPLACE INTO `sem_tree` (`sem_tree_id`, `parent_id`, `priority`, `info`, `name`, `studip_object_id`, `type`) VALUES('01c8b1d188be40c5ac64b54a01aae294', '5b73e28644a3e259a6e0bc1e1499773c', 2, '', 'Test Studienbereich C', NULL, 0);
--
-- Daten für Tabelle `statusgruppen`
--
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('86498c641ccf4f4d4e02f4961ccc3829', 'Lehrbeauftragte', '2560f7c7674942a7dce8eeb238e15d93', 3, 0, 0, 1156516698, 1156516698, 0);
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('600403561c21a50ae8b4d41655bd2191', 'Hochschullehrer/-in', '2560f7c7674942a7dce8eeb238e15d93', 4, 0, 0, 1156516698, 1156516698, 0);
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('efb56e092f33cb78a8766676042dc1c5', 'wiss. Mitarbeiter/-in', '2560f7c7674942a7dce8eeb238e15d93', 2, 0, 0, 1156516698, 1156516698, 0);
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('5d40b1fc0434e6589d7341a3ee742baf', 'Direktor/-in', '2560f7c7674942a7dce8eeb238e15d93', 1, 0, 0, 1156516698, 1156516698, 0);
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('2f597139a049a768dbf8345a0a0af3de', 'Studierende', 'a07535cf2f8a72df33c12ddfa4b53dde', 1, 0, 0, 1343924562, 1343924562, 0);
REPLACE INTO `statusgruppen` (`statusgruppe_id`, `name`, `range_id`, `position`, `size`, `selfassign`, `mkdate`, `chdate`, `calendar_group`) VALUES('f4319d9909e9f7cb4692c16771887f22', 'Lehrende', 'a07535cf2f8a72df33c12ddfa4b53dde', 0, 0, 0, 1343924551, 1343924551, 0);
--
-- Daten für Tabelle `statusgruppe_user`
--
REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `visible`, `inherit`) VALUES('efb56e092f33cb78a8766676042dc1c5', '7e81ec247c151c02ffd479511e24cc03', 1, 1, 1);
REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `visible`, `inherit`) VALUES('5d40b1fc0434e6589d7341a3ee742baf', '205f3efb7997a0fc9755da2b535038da', 1, 1, 1);
REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `visible`, `inherit`) VALUES('f4319d9909e9f7cb4692c16771887f22', '205f3efb7997a0fc9755da2b535038da', 1, 1, 1);
REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `visible`, `inherit`) VALUES('f4319d9909e9f7cb4692c16771887f22', '7e81ec247c151c02ffd479511e24cc03', 2, 1, 1);
REPLACE INTO `statusgruppe_user` (`statusgruppe_id`, `user_id`, `position`, `visible`, `inherit`) VALUES('2f597139a049a768dbf8345a0a0af3de', 'e7a0a84b161f3e8c09b4a0a2e8a58147', 1, 1, 1);
--
-- Dumping data for table `termine`
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('1199f2c43a6ddcd05fd61456e6ac1451', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1736755200, 1736762400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('132eec0a28623f5afde092a6960e45f4', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1736150400, 1736157600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('13bf7a5cd577bcba5bff88d46512baad', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1732521600, 1732528800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('221bb1927fcd93fab3ec7dde7c6b3cce', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1734336000, 1734343200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('4f47c3d25eca9ab8fb2a1644209074ae', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1733126400, 1733133600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('5f87ebde55d5527ceb27ccd6dcd9f66e', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1733731200, 1733738400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('60b4659f960ef05807cbaea6368158aa', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1730707200, 1730714400, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('749e52b43a4fe025442f355779489a9d', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1729494000, 1729501200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('7aaa9681da31192e49eaa63a4cef3dfb', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1737360000, 1737367200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('7ec82c654e1b41819cd476ec72e77a76', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1730102400, 1730109600, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('86de155d92a8f2da7ed6cd8ed9c08d71', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1739613600, 1739619000, 1698856983, 1716388379, 3, '', NULL);
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('a8f402ada308f68d5f24374923d25580', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1737964800, 1737972000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('be1ad3a4bc5c933d4bfbaa2b313d3ab5', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1738569600, 1738576800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('c729ae36a1503f471a407802e8f72cec', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1731916800, 1731924000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
REPLACE INTO `termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`) VALUES('e8212b6e58109ae94ad2a31796c4a520', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1731312000, 1731319200, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1');
--
-- Daten für Tabelle `ex_termine`
--
REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('1bd10ae335fd2c499ad701e49a2b52cb', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1734940800, 1734948000, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
REPLACE INTO `ex_termine` (`termin_id`, `range_id`, `autor_id`, `content`, `date`, `end_time`, `mkdate`, `chdate`, `date_typ`, `raum`, `metadate_id`, `resource_id`) VALUES('4b4657a993609ac0f7d4a0183507a5a2', 'a07535cf2f8a72df33c12ddfa4b53dde', '76ed43ef286fb55cf9e41beadb484a9f', '', 1735545600, 1735552800, 1716388347, 1716388347, 1, NULL, 'fc3c44f257e448e3cd36a88406a8a9c1', '');
--
-- Daten für Tabelle `user_info`
--
REPLACE INTO `user_info` (`user_id`, `hobby`, `lebenslauf`, `publi`, `schwerp`, `Home`, `privatnr`, `privatcell`, `privadr`, `score`, `geschlecht`, `mkdate`, `chdate`, `title_front`, `title_rear`, `preferred_language`, `smsforward_copy`, `smsforward_rec`, `email_forward`, `motto`, `lock_rule`, `oercampus_description`) VALUES('205f3efb7997a0fc9755da2b535038da', '', '', '', '', '', '', '', '', 0, 0, 0, 0, '', '', NULL, 1, '', 0, '', '', NULL);
REPLACE INTO `user_info` (`user_id`, `hobby`, `lebenslauf`, `publi`, `schwerp`, `Home`, `privatnr`, `privatcell`, `privadr`, `score`, `geschlecht`, `mkdate`, `chdate`, `title_front`, `title_rear`, `preferred_language`, `smsforward_copy`, `smsforward_rec`, `email_forward`, `motto`, `lock_rule`, `oercampus_description`) VALUES('6235c46eb9e962866ebdceece739ace5', '', '', '', '', '', '', '', '', 0, 0, 0, 0, '', '', NULL, 1, '', 0, '', '', NULL);
REPLACE INTO `user_info` (`user_id`, `hobby`, `lebenslauf`, `publi`, `schwerp`, `Home`, `privatnr`, `privatcell`, `privadr`, `score`, `geschlecht`, `mkdate`, `chdate`, `title_front`, `title_rear`, `preferred_language`, `smsforward_copy`, `smsforward_rec`, `email_forward`, `motto`, `lock_rule`, `oercampus_description`) VALUES('76ed43ef286fb55cf9e41beadb484a9f', '', '', '', '', '', '', '', '', 0, 0, 0, 1698855190, '', '', NULL, 1, '', 0, '', '', NULL);
REPLACE INTO `user_info` (`user_id`, `hobby`, `lebenslauf`, `publi`, `schwerp`, `Home`, `privatnr`, `privatcell`, `privadr`, `score`, `geschlecht`, `mkdate`, `chdate`, `title_front`, `title_rear`, `preferred_language`, `smsforward_copy`, `smsforward_rec`, `email_forward`, `motto`, `lock_rule`, `oercampus_description`) VALUES('7e81ec247c151c02ffd479511e24cc03', '', '', '', '', '', '', '', '', 0, 0, 0, 0, '', '', NULL, 1, '', 0, '', '', NULL);
REPLACE INTO `user_info` (`user_id`, `hobby`, `lebenslauf`, `publi`, `schwerp`, `Home`, `privatnr`, `privatcell`, `privadr`, `score`, `geschlecht`, `mkdate`, `chdate`, `title_front`, `title_rear`, `preferred_language`, `smsforward_copy`, `smsforward_rec`, `email_forward`, `motto`, `lock_rule`, `oercampus_description`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', '', '', '', '', '', '', '', '', 0, 0, 0, 0, '', '', NULL, 1, '', 0, '', '', NULL);
--
-- Daten für Tabelle `user_inst`
--
REPLACE INTO `user_inst` (`user_id`, `Institut_id`, `inst_perms`, `sprechzeiten`, `raum`, `Telefon`, `Fax`, `externdefault`, `priority`, `visible`) VALUES('205f3efb7997a0fc9755da2b535038da', '2560f7c7674942a7dce8eeb238e15d93', 'dozent', '', '', '', '', 0, 0, 1);
REPLACE INTO `user_inst` (`user_id`, `Institut_id`, `inst_perms`, `sprechzeiten`, `raum`, `Telefon`, `Fax`, `externdefault`, `priority`, `visible`) VALUES('6235c46eb9e962866ebdceece739ace5', '2560f7c7674942a7dce8eeb238e15d93', 'admin', '', '', '', '', 0, 0, 1);
REPLACE INTO `user_inst` (`user_id`, `Institut_id`, `inst_perms`, `sprechzeiten`, `raum`, `Telefon`, `Fax`, `externdefault`, `priority`, `visible`) VALUES('7e81ec247c151c02ffd479511e24cc03', '2560f7c7674942a7dce8eeb238e15d93', 'tutor', '', '', '', '', 0, 0, 1);
REPLACE INTO `user_inst` (`user_id`, `Institut_id`, `inst_perms`, `sprechzeiten`, `raum`, `Telefon`, `Fax`, `externdefault`, `priority`, `visible`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', '2560f7c7674942a7dce8eeb238e15d93', 'user', '', '', '', '', 1, 0, 1);
--
-- Daten für Tabelle `user_studiengang`
--
REPLACE INTO `user_studiengang` (`user_id`, `fach_id`, `semester`, `abschluss_id`) VALUES('e7a0a84b161f3e8c09b4a0a2e8a58147', '6b9ac09535885ca55e29dd011e377c0a', 2, '228234544820cdf75db55b42d1ea3ecc');
REPLACE INTO `user_studiengang` (`user_id`, `fach_id`, `semester`, `abschluss_id`) VALUES('7e81ec247c151c02ffd479511e24cc03', 'f981c9b42ca72788a09da4a45794a737', 1, '228234544820cdf75db55b42d1ea3ecc');
REPLACE INTO `news` (`news_id`, `topic`, `body`, `author`, `date`, `user_id`, `expire`, `allow_comments`, `chdate`, `chdate_uid`, `mkdate`) VALUES ('29f2932ce32be989022c6f43b866e744', 'Herzlich Willkommen!', '<!--HTML-->
Das Stud.IP-Team heisst sie herzlich willkommen.<br />
Bitte schauen Sie sich ruhig um!<br /><br />
Wenn Sie das System selbst installiert haben und diese News sehen, haben Sie die Demonstrationsdaten in die Datenbank eingefügt. Wenn Sie produktiv mit dem System arbeiten wollen, sollten Sie diese Daten später wieder löschen, <strong>da die Passwörter der Accounts öffentlich bekannt sind</strong>.<br />
<p>Wenn Sie mit der Stud.IP Open Source-Community in Kontakt treten wollen und Fragen oder Ideen haben, können Sie sich auf unserem eigenen Stud.IP-System mit uns austauschen: <a href="https://develop.studip.de/studip" class="link-extern" target="_blank" rel="noreferrer noopener">develop.studip.de</a></p>
<p>Falls Sie die Einführung an einer Bildungseinrichtung planen und Unterstützung bei der Einführung oder Beratung zum Einsatz von digitalen Tools für die Online Lehre haben, steht Ihnen die Firma data-quest als Dienstleister rund um Stud.IP zur Seite: <a href="https://www.data-quest.de" class="link-extern" target="_blank" rel="noreferrer noopener">https://www.data-quest.de</a></p>', 'Root Studip', UNIX_TIMESTAMP(), '76ed43ef286fb55cf9e41beadb484a9f', 14562502, 1, UNIX_TIMESTAMP(), '', UNIX_TIMESTAMP());
REPLACE INTO news_range (`news_id`, `range_id`) VALUES ('29f2932ce32be989022c6f43b866e744', '76ed43ef286fb55cf9e41beadb484a9f');
REPLACE INTO news_range (`news_id`, `range_id`) VALUES ('29f2932ce32be989022c6f43b866e744', 'studip');
|
