| 4 |
andreas |
1 |
--
|
|
|
2 |
-- Selected TOC Entries:
|
|
|
3 |
--
|
|
|
4 |
\connect - andreas
|
|
|
5 |
|
|
|
6 |
--
|
|
|
7 |
-- TOC Entry ID 1 (OID 0)
|
|
|
8 |
--
|
|
|
9 |
-- Name: pm Type: DATABASE Owner: andreas
|
|
|
10 |
--
|
|
|
11 |
|
|
|
12 |
CREATE DATABASE "pm" WITH TEMPLATE = template0 ENCODING = 0;
|
|
|
13 |
|
|
|
14 |
\connect pm andreas
|
|
|
15 |
|
|
|
16 |
\connect - wwwrun
|
|
|
17 |
|
|
|
18 |
--
|
|
|
19 |
-- TOC Entry ID 2 (OID 157123)
|
|
|
20 |
--
|
|
|
21 |
-- Name: key_role Type: TABLE Owner: wwwrun
|
|
|
22 |
--
|
|
|
23 |
|
|
|
24 |
CREATE TABLE "key_role" (
|
|
|
25 |
"kr_num" integer NOT NULL,
|
|
|
26 |
"kr_role" character varying(50),
|
|
|
27 |
Constraint "key_role_pkey" Primary Key ("kr_num")
|
|
|
28 |
);
|
|
|
29 |
|
|
|
30 |
--
|
|
|
31 |
-- TOC Entry ID 3 (OID 157123)
|
|
|
32 |
--
|
|
|
33 |
-- Name: key_role Type: ACL Owner:
|
|
|
34 |
--
|
|
|
35 |
|
|
|
36 |
REVOKE ALL on "key_role" from PUBLIC;
|
|
|
37 |
GRANT ALL on "key_role" to "andreas";
|
|
|
38 |
GRANT ALL on "key_role" to "wwwrun";
|
|
|
39 |
|
|
|
40 |
--
|
|
|
41 |
-- TOC Entry ID 4 (OID 157126)
|
|
|
42 |
--
|
|
|
43 |
-- Name: key_land Type: TABLE Owner: wwwrun
|
|
|
44 |
--
|
|
|
45 |
|
|
|
46 |
CREATE TABLE "key_land" (
|
|
|
47 |
"kl_num" integer NOT NULL,
|
|
|
48 |
"kl_land" character varying(50),
|
|
|
49 |
Constraint "key_land_pkey" Primary Key ("kl_num")
|
|
|
50 |
);
|
|
|
51 |
|
|
|
52 |
--
|
|
|
53 |
-- TOC Entry ID 5 (OID 157126)
|
|
|
54 |
--
|
|
|
55 |
-- Name: key_land Type: ACL Owner:
|
|
|
56 |
--
|
|
|
57 |
|
|
|
58 |
REVOKE ALL on "key_land" from PUBLIC;
|
|
|
59 |
GRANT ALL on "key_land" to "andreas";
|
|
|
60 |
GRANT ALL on "key_land" to "wwwrun";
|
|
|
61 |
|
|
|
62 |
--
|
|
|
63 |
-- TOC Entry ID 6 (OID 157129)
|
|
|
64 |
--
|
|
|
65 |
-- Name: key_abt Type: TABLE Owner: wwwrun
|
|
|
66 |
--
|
|
|
67 |
|
|
|
68 |
CREATE TABLE "key_abt" (
|
|
|
69 |
"ka_num" integer NOT NULL,
|
|
|
70 |
"ka_abt" character varying(50),
|
|
|
71 |
Constraint "key_abt_pkey" Primary Key ("ka_num")
|
|
|
72 |
);
|
|
|
73 |
|
|
|
74 |
--
|
|
|
75 |
-- TOC Entry ID 7 (OID 157129)
|
|
|
76 |
--
|
|
|
77 |
-- Name: key_abt Type: ACL Owner:
|
|
|
78 |
--
|
|
|
79 |
|
|
|
80 |
REVOKE ALL on "key_abt" from PUBLIC;
|
|
|
81 |
GRANT ALL on "key_abt" to "andreas";
|
|
|
82 |
GRANT ALL on "key_abt" to "wwwrun";
|
|
|
83 |
|
|
|
84 |
--
|
|
|
85 |
-- TOC Entry ID 8 (OID 157132)
|
|
|
86 |
--
|
|
|
87 |
-- Name: key_sgf Type: TABLE Owner: wwwrun
|
|
|
88 |
--
|
|
|
89 |
|
|
|
90 |
CREATE TABLE "key_sgf" (
|
|
|
91 |
"ks_num" integer NOT NULL,
|
|
|
92 |
"ks_sgf" character varying(20),
|
|
|
93 |
Constraint "key_sgf_pkey" Primary Key ("ks_num")
|
|
|
94 |
);
|
|
|
95 |
|
|
|
96 |
--
|
|
|
97 |
-- TOC Entry ID 9 (OID 157132)
|
|
|
98 |
--
|
|
|
99 |
-- Name: key_sgf Type: ACL Owner:
|
|
|
100 |
--
|
|
|
101 |
|
|
|
102 |
REVOKE ALL on "key_sgf" from PUBLIC;
|
|
|
103 |
GRANT ALL on "key_sgf" to "andreas";
|
|
|
104 |
GRANT ALL on "key_sgf" to "wwwrun";
|
|
|
105 |
|
|
|
106 |
--
|
|
|
107 |
-- TOC Entry ID 10 (OID 157135)
|
|
|
108 |
--
|
|
|
109 |
-- Name: key_tmgroup Type: TABLE Owner: wwwrun
|
|
|
110 |
--
|
|
|
111 |
|
|
|
112 |
CREATE TABLE "key_tmgroup" (
|
|
|
113 |
"kt_num" integer NOT NULL,
|
|
|
114 |
"kt_tm" character varying(50),
|
|
|
115 |
Constraint "key_tmgroup_pkey" Primary Key ("kt_num")
|
|
|
116 |
);
|
|
|
117 |
|
|
|
118 |
--
|
|
|
119 |
-- TOC Entry ID 11 (OID 157135)
|
|
|
120 |
--
|
|
|
121 |
-- Name: key_tmgroup Type: ACL Owner:
|
|
|
122 |
--
|
|
|
123 |
|
|
|
124 |
REVOKE ALL on "key_tmgroup" from PUBLIC;
|
|
|
125 |
GRANT ALL on "key_tmgroup" to "andreas";
|
|
|
126 |
GRANT ALL on "key_tmgroup" to "wwwrun";
|
|
|
127 |
|
|
|
128 |
--
|
|
|
129 |
-- TOC Entry ID 12 (OID 157138)
|
|
|
130 |
--
|
|
|
131 |
-- Name: counter Type: TABLE Owner: wwwrun
|
|
|
132 |
--
|
|
|
133 |
|
|
|
134 |
CREATE TABLE "counter" (
|
|
|
135 |
"co_mitarbeiter" integer,
|
|
|
136 |
"co_plan" integer,
|
|
|
137 |
"co_task" integer,
|
|
|
138 |
"co_wdone" integer,
|
|
|
139 |
"co_allocation" integer
|
|
|
140 |
);
|
|
|
141 |
|
|
|
142 |
--
|
|
|
143 |
-- TOC Entry ID 13 (OID 157138)
|
|
|
144 |
--
|
|
|
145 |
-- Name: counter Type: ACL Owner:
|
|
|
146 |
--
|
|
|
147 |
|
|
|
148 |
REVOKE ALL on "counter" from PUBLIC;
|
|
|
149 |
GRANT ALL on "counter" to "andreas";
|
|
|
150 |
GRANT ALL on "counter" to "wwwrun";
|
|
|
151 |
|
|
|
152 |
--
|
|
|
153 |
-- TOC Entry ID 14 (OID 157140)
|
|
|
154 |
--
|
|
|
155 |
-- Name: mitarbeiter Type: TABLE Owner: wwwrun
|
|
|
156 |
--
|
|
|
157 |
|
|
|
158 |
CREATE TABLE "mitarbeiter" (
|
|
|
159 |
"mi_num" integer NOT NULL,
|
|
|
160 |
"mi_vname" character varying(50) NOT NULL,
|
|
|
161 |
"mi_nname" character varying(50) NOT NULL,
|
|
|
162 |
"mi_land" integer,
|
|
|
163 |
"mi_abt" integer,
|
|
|
164 |
"mi_tel" character varying(50),
|
|
|
165 |
"mi_mail" character varying(80),
|
|
|
166 |
"mi_userid" character varying(16),
|
|
|
167 |
"mi_passwd" character varying(50),
|
|
|
168 |
"mi_rstufe" smallint,
|
|
|
169 |
"mi_hacker" smallint,
|
|
|
170 |
Constraint "mitarbeiter_pkey" Primary Key ("mi_num")
|
|
|
171 |
);
|
|
|
172 |
|
|
|
173 |
--
|
|
|
174 |
-- TOC Entry ID 15 (OID 157140)
|
|
|
175 |
--
|
|
|
176 |
-- Name: mitarbeiter Type: ACL Owner:
|
|
|
177 |
--
|
|
|
178 |
|
|
|
179 |
REVOKE ALL on "mitarbeiter" from PUBLIC;
|
|
|
180 |
GRANT ALL on "mitarbeiter" to "andreas";
|
|
|
181 |
GRANT ALL on "mitarbeiter" to "wwwrun";
|
|
|
182 |
|
|
|
183 |
--
|
|
|
184 |
-- TOC Entry ID 16 (OID 157157)
|
|
|
185 |
--
|
|
|
186 |
-- Name: project Type: TABLE Owner: wwwrun
|
|
|
187 |
--
|
|
|
188 |
|
|
|
189 |
CREATE TABLE "project" (
|
|
|
190 |
"pr_num" integer NOT NULL,
|
|
|
191 |
"pr_name" character varying(100) NOT NULL,
|
|
|
192 |
"pr_pl" integer NOT NULL,
|
|
|
193 |
"pr_plav" integer,
|
|
|
194 |
"pr_sgf" integer,
|
|
|
195 |
"pr_tmgroup" integer,
|
|
|
196 |
"pr_status" integer,
|
|
|
197 |
Constraint "project_pkey" Primary Key ("pr_num")
|
|
|
198 |
);
|
|
|
199 |
|
|
|
200 |
--
|
|
|
201 |
-- TOC Entry ID 17 (OID 157157)
|
|
|
202 |
--
|
|
|
203 |
-- Name: project Type: ACL Owner:
|
|
|
204 |
--
|
|
|
205 |
|
|
|
206 |
REVOKE ALL on "project" from PUBLIC;
|
|
|
207 |
GRANT ALL on "project" to "andreas";
|
|
|
208 |
GRANT ALL on "project" to "wwwrun";
|
|
|
209 |
|
|
|
210 |
--
|
|
|
211 |
-- TOC Entry ID 18 (OID 157179)
|
|
|
212 |
--
|
|
|
213 |
-- Name: plan Type: TABLE Owner: wwwrun
|
|
|
214 |
--
|
|
|
215 |
|
|
|
216 |
CREATE TABLE "plan" (
|
|
|
217 |
"pl_num" integer NOT NULL,
|
|
|
218 |
"pl_lfd" integer NOT NULL,
|
|
|
219 |
"pl_prnum" integer,
|
|
|
220 |
"pl_status" smallint,
|
|
|
221 |
Constraint "plan_pkey" Primary Key ("pl_num")
|
|
|
222 |
);
|
|
|
223 |
|
|
|
224 |
--
|
|
|
225 |
-- TOC Entry ID 19 (OID 157179)
|
|
|
226 |
--
|
|
|
227 |
-- Name: plan Type: ACL Owner:
|
|
|
228 |
--
|
|
|
229 |
|
|
|
230 |
REVOKE ALL on "plan" from PUBLIC;
|
|
|
231 |
GRANT ALL on "plan" to "andreas";
|
|
|
232 |
GRANT ALL on "plan" to "wwwrun";
|
|
|
233 |
|
|
|
234 |
--
|
|
|
235 |
-- TOC Entry ID 20 (OID 157188)
|
|
|
236 |
--
|
|
|
237 |
-- Name: task Type: TABLE Owner: wwwrun
|
|
|
238 |
--
|
|
|
239 |
|
|
|
240 |
CREATE TABLE "task" (
|
|
|
241 |
"ta_num" integer NOT NULL,
|
|
|
242 |
"ta_plnum" integer NOT NULL,
|
|
|
243 |
"ta_id" smallint NOT NULL,
|
|
|
244 |
"ta_depend" smallint,
|
|
|
245 |
"ta_deptype" smallint,
|
|
|
246 |
"ta_name" character varying(50) NOT NULL,
|
|
|
247 |
"ta_color" integer,
|
|
|
248 |
"ta_shape" character varying(40),
|
|
|
249 |
"ta_meeting" smallint,
|
|
|
250 |
"ta_start" integer,
|
|
|
251 |
"ta_duration" smallint,
|
|
|
252 |
"ta_complete" smallint,
|
|
|
253 |
"ta_fixed_start" smallint,
|
|
|
254 |
"ta_priority" smallint,
|
|
|
255 |
"ta_level" smallint,
|
|
|
256 |
"ta_notiz" character varying(4096),
|
|
|
257 |
"ta_phase" integer,
|
|
|
258 |
Constraint "task_pkey" Primary Key ("ta_num")
|
|
|
259 |
);
|
|
|
260 |
|
|
|
261 |
--
|
|
|
262 |
-- TOC Entry ID 21 (OID 157188)
|
|
|
263 |
--
|
|
|
264 |
-- Name: task Type: ACL Owner:
|
|
|
265 |
--
|
|
|
266 |
|
|
|
267 |
REVOKE ALL on "task" from PUBLIC;
|
|
|
268 |
GRANT ALL on "task" to "andreas";
|
|
|
269 |
GRANT ALL on "task" to "wwwrun";
|
|
|
270 |
|
|
|
271 |
--
|
|
|
272 |
-- TOC Entry ID 22 (OID 157201)
|
|
|
273 |
--
|
|
|
274 |
-- Name: allocation Type: TABLE Owner: wwwrun
|
|
|
275 |
--
|
|
|
276 |
|
|
|
277 |
CREATE TABLE "allocation" (
|
|
|
278 |
"al_num" integer NOT NULL,
|
|
|
279 |
"al_task" integer,
|
|
|
280 |
"al_ressource" integer,
|
|
|
281 |
"al_hours" double precision,
|
|
|
282 |
"al_role" integer,
|
|
|
283 |
"al_phase" smallint,
|
|
|
284 |
"al_pstart" integer,
|
|
|
285 |
"al_pduration" smallint,
|
|
|
286 |
Constraint "allocation_pkey" Primary Key ("al_num")
|
|
|
287 |
);
|
|
|
288 |
|
|
|
289 |
--
|
|
|
290 |
-- TOC Entry ID 23 (OID 157201)
|
|
|
291 |
--
|
|
|
292 |
-- Name: allocation Type: ACL Owner:
|
|
|
293 |
--
|
|
|
294 |
|
|
|
295 |
REVOKE ALL on "allocation" from PUBLIC;
|
|
|
296 |
GRANT ALL on "allocation" to "andreas";
|
|
|
297 |
GRANT ALL on "allocation" to "wwwrun";
|
|
|
298 |
|
|
|
299 |
--
|
|
|
300 |
-- TOC Entry ID 24 (OID 157223)
|
|
|
301 |
--
|
|
|
302 |
-- Name: wdone Type: TABLE Owner: wwwrun
|
|
|
303 |
--
|
|
|
304 |
|
|
|
305 |
CREATE TABLE "wdone" (
|
|
|
306 |
"wd_num" integer NOT NULL,
|
|
|
307 |
"wd_prnum" integer,
|
|
|
308 |
"wd_minum" integer,
|
|
|
309 |
"wd_datum" integer,
|
|
|
310 |
"wd_hours" double precision,
|
|
|
311 |
"wd_task" integer,
|
|
|
312 |
"wd_rk" smallint,
|
|
|
313 |
"wd_phase" smallint,
|
|
|
314 |
"wd_edit" boolean,
|
|
|
315 |
"wd_periode" integer,
|
|
|
316 |
Constraint "wdone_pkey" Primary Key ("wd_num")
|
|
|
317 |
);
|
|
|
318 |
|
|
|
319 |
--
|
|
|
320 |
-- TOC Entry ID 25 (OID 157223)
|
|
|
321 |
--
|
|
|
322 |
-- Name: wdone Type: ACL Owner:
|
|
|
323 |
--
|
|
|
324 |
|
|
|
325 |
REVOKE ALL on "wdone" from PUBLIC;
|
|
|
326 |
GRANT ALL on "wdone" to "andreas";
|
|
|
327 |
GRANT ALL on "wdone" to "wwwrun";
|
|
|
328 |
|
|
|
329 |
\connect - andreas
|
|
|
330 |
|
|
|
331 |
--
|
|
|
332 |
-- TOC Entry ID 26 (OID 157245)
|
|
|
333 |
--
|
|
|
334 |
-- Name: pga_graphs Type: TABLE Owner: andreas
|
|
|
335 |
--
|
|
|
336 |
|
|
|
337 |
CREATE TABLE "pga_graphs" (
|
|
|
338 |
"graphname" character varying(64) NOT NULL,
|
|
|
339 |
"graphsource" text,
|
|
|
340 |
"graphcode" text,
|
|
|
341 |
Constraint "pga_graphs_pkey" Primary Key ("graphname")
|
|
|
342 |
);
|
|
|
343 |
|
|
|
344 |
--
|
|
|
345 |
-- TOC Entry ID 27 (OID 157245)
|
|
|
346 |
--
|
|
|
347 |
-- Name: pga_graphs Type: ACL Owner:
|
|
|
348 |
--
|
|
|
349 |
|
|
|
350 |
REVOKE ALL on "pga_graphs" from PUBLIC;
|
|
|
351 |
GRANT ALL on "pga_graphs" to "andreas";
|
|
|
352 |
GRANT ALL on "pga_graphs" to "wwwrun";
|
|
|
353 |
|
|
|
354 |
--
|
|
|
355 |
-- TOC Entry ID 28 (OID 157251)
|
|
|
356 |
--
|
|
|
357 |
-- Name: pga_layout Type: TABLE Owner: andreas
|
|
|
358 |
--
|
|
|
359 |
|
|
|
360 |
CREATE TABLE "pga_layout" (
|
|
|
361 |
"tablename" character varying(64) NOT NULL,
|
|
|
362 |
"nrcols" smallint,
|
|
|
363 |
"colnames" text,
|
|
|
364 |
"colwidth" text,
|
|
|
365 |
Constraint "pga_layout_pkey" Primary Key ("tablename")
|
|
|
366 |
);
|
|
|
367 |
|
|
|
368 |
--
|
|
|
369 |
-- TOC Entry ID 29 (OID 157251)
|
|
|
370 |
--
|
|
|
371 |
-- Name: pga_layout Type: ACL Owner:
|
|
|
372 |
--
|
|
|
373 |
|
|
|
374 |
REVOKE ALL on "pga_layout" from PUBLIC;
|
|
|
375 |
GRANT ALL on "pga_layout" to "andreas";
|
|
|
376 |
GRANT ALL on "pga_layout" to "wwwrun";
|
|
|
377 |
|
|
|
378 |
--
|
|
|
379 |
-- TOC Entry ID 30 (OID 157257)
|
|
|
380 |
--
|
|
|
381 |
-- Name: pga_images Type: TABLE Owner: andreas
|
|
|
382 |
--
|
|
|
383 |
|
|
|
384 |
CREATE TABLE "pga_images" (
|
|
|
385 |
"imagename" character varying(64) NOT NULL,
|
|
|
386 |
"imagesource" text,
|
|
|
387 |
Constraint "pga_images_pkey" Primary Key ("imagename")
|
|
|
388 |
);
|
|
|
389 |
|
|
|
390 |
--
|
|
|
391 |
-- TOC Entry ID 31 (OID 157257)
|
|
|
392 |
--
|
|
|
393 |
-- Name: pga_images Type: ACL Owner:
|
|
|
394 |
--
|
|
|
395 |
|
|
|
396 |
REVOKE ALL on "pga_images" from PUBLIC;
|
|
|
397 |
GRANT ALL on "pga_images" to "andreas";
|
|
|
398 |
GRANT ALL on "pga_images" to "wwwrun";
|
|
|
399 |
|
|
|
400 |
--
|
|
|
401 |
-- TOC Entry ID 32 (OID 157263)
|
|
|
402 |
--
|
|
|
403 |
-- Name: pga_queries Type: TABLE Owner: andreas
|
|
|
404 |
--
|
|
|
405 |
|
|
|
406 |
CREATE TABLE "pga_queries" (
|
|
|
407 |
"queryname" character varying(64) NOT NULL,
|
|
|
408 |
"querytype" character(1),
|
|
|
409 |
"querycommand" text,
|
|
|
410 |
"querytables" text,
|
|
|
411 |
"querylinks" text,
|
|
|
412 |
"queryresults" text,
|
|
|
413 |
"querycomments" text,
|
|
|
414 |
Constraint "pga_queries_pkey" Primary Key ("queryname")
|
|
|
415 |
);
|
|
|
416 |
|
|
|
417 |
--
|
|
|
418 |
-- TOC Entry ID 33 (OID 157263)
|
|
|
419 |
--
|
|
|
420 |
-- Name: pga_queries Type: ACL Owner:
|
|
|
421 |
--
|
|
|
422 |
|
|
|
423 |
REVOKE ALL on "pga_queries" from PUBLIC;
|
|
|
424 |
GRANT ALL on "pga_queries" to "andreas";
|
|
|
425 |
GRANT ALL on "pga_queries" to "wwwrun";
|
|
|
426 |
|
|
|
427 |
--
|
|
|
428 |
-- TOC Entry ID 34 (OID 157269)
|
|
|
429 |
--
|
|
|
430 |
-- Name: pga_reports Type: TABLE Owner: andreas
|
|
|
431 |
--
|
|
|
432 |
|
|
|
433 |
CREATE TABLE "pga_reports" (
|
|
|
434 |
"reportname" character varying(64) NOT NULL,
|
|
|
435 |
"reportsource" text,
|
|
|
436 |
"reportbody" text,
|
|
|
437 |
"reportprocs" text,
|
|
|
438 |
"reportoptions" text,
|
|
|
439 |
Constraint "pga_reports_pkey" Primary Key ("reportname")
|
|
|
440 |
);
|
|
|
441 |
|
|
|
442 |
--
|
|
|
443 |
-- TOC Entry ID 35 (OID 157269)
|
|
|
444 |
--
|
|
|
445 |
-- Name: pga_reports Type: ACL Owner:
|
|
|
446 |
--
|
|
|
447 |
|
|
|
448 |
REVOKE ALL on "pga_reports" from PUBLIC;
|
|
|
449 |
GRANT ALL on "pga_reports" to "andreas";
|
|
|
450 |
GRANT ALL on "pga_reports" to "wwwrun";
|
|
|
451 |
|
|
|
452 |
--
|
|
|
453 |
-- TOC Entry ID 36 (OID 157275)
|
|
|
454 |
--
|
|
|
455 |
-- Name: pga_forms Type: TABLE Owner: andreas
|
|
|
456 |
--
|
|
|
457 |
|
|
|
458 |
CREATE TABLE "pga_forms" (
|
|
|
459 |
"formname" character varying(64) NOT NULL,
|
|
|
460 |
"formsource" text,
|
|
|
461 |
Constraint "pga_forms_pkey" Primary Key ("formname")
|
|
|
462 |
);
|
|
|
463 |
|
|
|
464 |
--
|
|
|
465 |
-- TOC Entry ID 37 (OID 157275)
|
|
|
466 |
--
|
|
|
467 |
-- Name: pga_forms Type: ACL Owner:
|
|
|
468 |
--
|
|
|
469 |
|
|
|
470 |
REVOKE ALL on "pga_forms" from PUBLIC;
|
|
|
471 |
GRANT ALL on "pga_forms" to "andreas";
|
|
|
472 |
GRANT ALL on "pga_forms" to "wwwrun";
|
|
|
473 |
|
|
|
474 |
--
|
|
|
475 |
-- TOC Entry ID 38 (OID 157281)
|
|
|
476 |
--
|
|
|
477 |
-- Name: pga_diagrams Type: TABLE Owner: andreas
|
|
|
478 |
--
|
|
|
479 |
|
|
|
480 |
CREATE TABLE "pga_diagrams" (
|
|
|
481 |
"diagramname" character varying(64) NOT NULL,
|
|
|
482 |
"diagramtables" text,
|
|
|
483 |
"diagramlinks" text,
|
|
|
484 |
Constraint "pga_diagrams_pkey" Primary Key ("diagramname")
|
|
|
485 |
);
|
|
|
486 |
|
|
|
487 |
--
|
|
|
488 |
-- TOC Entry ID 39 (OID 157281)
|
|
|
489 |
--
|
|
|
490 |
-- Name: pga_diagrams Type: ACL Owner:
|
|
|
491 |
--
|
|
|
492 |
|
|
|
493 |
REVOKE ALL on "pga_diagrams" from PUBLIC;
|
|
|
494 |
GRANT ALL on "pga_diagrams" to "andreas";
|
|
|
495 |
GRANT ALL on "pga_diagrams" to "wwwrun";
|
|
|
496 |
|
|
|
497 |
--
|
|
|
498 |
-- TOC Entry ID 40 (OID 157287)
|
|
|
499 |
--
|
|
|
500 |
-- Name: pga_scripts Type: TABLE Owner: andreas
|
|
|
501 |
--
|
|
|
502 |
|
|
|
503 |
CREATE TABLE "pga_scripts" (
|
|
|
504 |
"scriptname" character varying(64) NOT NULL,
|
|
|
505 |
"scriptsource" text,
|
|
|
506 |
Constraint "pga_scripts_pkey" Primary Key ("scriptname")
|
|
|
507 |
);
|
|
|
508 |
|
|
|
509 |
--
|
|
|
510 |
-- TOC Entry ID 41 (OID 157287)
|
|
|
511 |
--
|
|
|
512 |
-- Name: pga_scripts Type: ACL Owner:
|
|
|
513 |
--
|
|
|
514 |
|
|
|
515 |
REVOKE ALL on "pga_scripts" from PUBLIC;
|
|
|
516 |
GRANT ALL on "pga_scripts" to "andreas";
|
|
|
517 |
GRANT ALL on "pga_scripts" to "wwwrun";
|
|
|
518 |
|
|
|
519 |
\connect - wwwrun
|
|
|
520 |
|
|
|
521 |
--
|
|
|
522 |
-- TOC Entry ID 42 (OID 157338)
|
|
|
523 |
--
|
|
|
524 |
-- Name: key_status Type: TABLE Owner: wwwrun
|
|
|
525 |
--
|
|
|
526 |
|
|
|
527 |
CREATE TABLE "key_status" (
|
|
|
528 |
"ks_num" integer NOT NULL,
|
|
|
529 |
"ks_status" character varying(10) NOT NULL,
|
|
|
530 |
Constraint "key_status_pkey" Primary Key ("ks_num")
|
|
|
531 |
);
|
|
|
532 |
|
|
|
533 |
--
|
|
|
534 |
-- TOC Entry ID 43 (OID 157338)
|
|
|
535 |
--
|
|
|
536 |
-- Name: key_status Type: ACL Owner:
|
|
|
537 |
--
|
|
|
538 |
|
|
|
539 |
REVOKE ALL on "key_status" from PUBLIC;
|
|
|
540 |
GRANT ALL on "key_status" to "andreas";
|
|
|
541 |
GRANT ALL on "key_status" to "wwwrun";
|
|
|
542 |
|
|
|
543 |
--
|
|
|
544 |
-- TOC Entry ID 44 (OID 157341)
|
|
|
545 |
--
|
|
|
546 |
-- Name: ptemp Type: TABLE Owner: wwwrun
|
|
|
547 |
--
|
|
|
548 |
|
|
|
549 |
CREATE TABLE "ptemp" (
|
|
|
550 |
"pt_num" integer NOT NULL,
|
|
|
551 |
"pt_tnum" smallint NOT NULL,
|
|
|
552 |
"pt_lfd" smallint NOT NULL,
|
|
|
553 |
"pt_level" smallint,
|
|
|
554 |
"pt_name" character varying(50),
|
|
|
555 |
"pt_color" integer,
|
|
|
556 |
"pt_meeting" boolean,
|
|
|
557 |
"pt_phase" integer,
|
|
|
558 |
Constraint "ptemp_pkey" Primary Key ("pt_num")
|
|
|
559 |
);
|
|
|
560 |
|
|
|
561 |
--
|
|
|
562 |
-- TOC Entry ID 45 (OID 157341)
|
|
|
563 |
--
|
|
|
564 |
-- Name: ptemp Type: ACL Owner:
|
|
|
565 |
--
|
|
|
566 |
|
|
|
567 |
REVOKE ALL on "ptemp" from PUBLIC;
|
|
|
568 |
GRANT ALL on "ptemp" to "andreas";
|
|
|
569 |
GRANT ALL on "ptemp" to "wwwrun";
|
|
|
570 |
|
|
|
571 |
--
|
|
|
572 |
-- TOC Entry ID 46 (OID 165403)
|
|
|
573 |
--
|
|
|
574 |
-- Name: key_phase Type: TABLE Owner: wwwrun
|
|
|
575 |
--
|
|
|
576 |
|
|
|
577 |
CREATE TABLE "key_phase" (
|
|
|
578 |
"kp_num" integer NOT NULL,
|
|
|
579 |
"kp_phase" character varying(60) NOT NULL,
|
|
|
580 |
Constraint "key_phase_pkey" Primary Key ("kp_num")
|
|
|
581 |
);
|
|
|
582 |
|
|
|
583 |
--
|
|
|
584 |
-- TOC Entry ID 47 (OID 173690)
|
|
|
585 |
--
|
|
|
586 |
-- Name: allocmi Type: VIEW Owner: wwwrun
|
|
|
587 |
--
|
|
|
588 |
|
|
|
589 |
CREATE VIEW "allocmi" as SELECT allocation.al_num AS am_num, allocation.al_task AS am_task, allocation.al_ressource AS am_ressource, allocation.al_hours AS am_hours, allocation.al_phase AS am_phase, key_role.kr_role AS am_role, key_role.kr_num AS am_krnum, mitarbeiter.mi_vname AS am_vname, mitarbeiter.mi_nname AS am_nname, allocation.al_pstart AS am_pstart, allocation.al_pduration AS am_pduration FROM allocation, mitarbeiter, key_role WHERE ((mitarbeiter.mi_num = allocation.al_ressource) AND (key_role.kr_num = allocation.al_role));
|
|
|
590 |
|
|
|
591 |
--
|
|
|
592 |
-- TOC Entry ID 48 (OID 190526)
|
|
|
593 |
--
|
|
|
594 |
-- Name: tempidx Type: TABLE Owner: wwwrun
|
|
|
595 |
--
|
|
|
596 |
|
|
|
597 |
CREATE TABLE "tempidx" (
|
|
|
598 |
"te_num" integer NOT NULL,
|
|
|
599 |
"te_name" character varying(60) NOT NULL,
|
|
|
600 |
"te_zweck" character varying(2048),
|
|
|
601 |
Constraint "tempidx_pkey" Primary Key ("te_num")
|
|
|
602 |
);
|
|
|
603 |
|
|
|
604 |
--
|
|
|
605 |
-- Data for TOC Entry ID 57 (OID 157123)
|
|
|
606 |
--
|
|
|
607 |
-- Name: key_role Type: TABLE DATA Owner: wwwrun
|
|
|
608 |
--
|
|
|
609 |
|
|
|
610 |
|
|
|
611 |
COPY "key_role" FROM stdin;
|
|
|
612 |
1 Projektleiter
|
|
|
613 |
3 Mitarbeiter
|
|
|
614 |
4 Programmierer
|
|
|
615 |
5 Themenmanager
|
|
|
616 |
6 Ressourcenmanager
|
|
|
617 |
7 Geschäftsführung
|
|
|
618 |
2 PLA-V
|
|
|
619 |
\.
|
|
|
620 |
--
|
|
|
621 |
-- Data for TOC Entry ID 58 (OID 157126)
|
|
|
622 |
--
|
|
|
623 |
-- Name: key_land Type: TABLE DATA Owner: wwwrun
|
|
|
624 |
--
|
|
|
625 |
|
|
|
626 |
|
|
|
627 |
COPY "key_land" FROM stdin;
|
|
|
628 |
2 RLB
|
|
|
629 |
3 RZB
|
|
|
630 |
4 RI
|
|
|
631 |
5 Extern
|
|
|
632 |
6 RI-Fachlich
|
|
|
633 |
1 RO+<big>e</big>
|
|
|
634 |
\.
|
|
|
635 |
--
|
|
|
636 |
-- Data for TOC Entry ID 59 (OID 157129)
|
|
|
637 |
--
|
|
|
638 |
-- Name: key_abt Type: TABLE DATA Owner: wwwrun
|
|
|
639 |
--
|
|
|
640 |
|
|
|
641 |
|
|
|
642 |
COPY "key_abt" FROM stdin;
|
|
|
643 |
2 Meldewesen
|
|
|
644 |
1 Finanzierung
|
|
|
645 |
3 Vertrieb
|
|
|
646 |
4 Programmierung
|
|
|
647 |
\.
|
|
|
648 |
--
|
|
|
649 |
-- Data for TOC Entry ID 60 (OID 157132)
|
|
|
650 |
--
|
|
|
651 |
-- Name: key_sgf Type: TABLE DATA Owner: wwwrun
|
|
|
652 |
--
|
|
|
653 |
|
|
|
654 |
|
|
|
655 |
COPY "key_sgf" FROM stdin;
|
|
|
656 |
1 PK
|
|
|
657 |
2 PK+
|
|
|
658 |
3 FK
|
|
|
659 |
4 FB
|
|
|
660 |
\.
|
|
|
661 |
--
|
|
|
662 |
-- Data for TOC Entry ID 61 (OID 157135)
|
|
|
663 |
--
|
|
|
664 |
-- Name: key_tmgroup Type: TABLE DATA Owner: wwwrun
|
|
|
665 |
--
|
|
|
666 |
|
|
|
667 |
|
|
|
668 |
COPY "key_tmgroup" FROM stdin;
|
|
|
669 |
1 Finanzierung
|
|
|
670 |
3 Vertrieb
|
|
|
671 |
2 BW Controlling
|
|
|
672 |
4 Büroorganisation
|
|
|
673 |
5 Veranlagung
|
|
|
674 |
6 Zahlungsverkehr
|
|
|
675 |
7 Kernbanken
|
|
|
676 |
\.
|
|
|
677 |
--
|
|
|
678 |
-- Data for TOC Entry ID 62 (OID 157138)
|
|
|
679 |
--
|
|
|
680 |
-- Name: counter Type: TABLE DATA Owner: wwwrun
|
|
|
681 |
--
|
|
|
682 |
|
|
|
683 |
|
|
|
684 |
COPY "counter" FROM stdin;
|
|
|
685 |
35 29 336 171 843
|
|
|
686 |
\.
|
|
|
687 |
--
|
|
|
688 |
-- Data for TOC Entry ID 63 (OID 157140)
|
|
|
689 |
--
|
|
|
690 |
-- Name: mitarbeiter Type: TABLE DATA Owner: wwwrun
|
|
|
691 |
--
|
|
|
692 |
|
|
|
693 |
|
|
|
694 |
COPY "mitarbeiter" FROM stdin;
|
|
|
695 |
1 Andreas Theofilu 1 1 5387 andreas.theofilu@roe.raiffeisen.at wrothe 6fab60e33f7e264df872a70fc89572d5 1 0
|
|
|
696 |
9 Linda Windisch 1 1 5916 linda.windisch@roe.raiffeisen.at wrowil be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
697 |
13 Günther Glassl 1 1 5917 wrogla be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
698 |
14 Markus Strobl 1 1 5302 wrostr be2332e4f2e07062832164eb5bc7a78f 4 0
|
|
|
699 |
8 Josef Stern 6 2 wrnstj ea110dfdeb4b966c81f7d786df7b1192 5 0
|
|
|
700 |
15 Robert Kollmann 1 1 5382 robert.kollmann@roe.raiffeisen.at wrokol 2 0
|
|
|
701 |
6 Christian Gerl 1 1 5346 christian.gerl@roe.raiffeisen.at wrogch 2 0
|
|
|
702 |
5 Klaus Schilhan 1 1 5375 klaus.schilhan@roe.raiffeisen.at wrosck 2 0
|
|
|
703 |
16 N N 1 2 nn 5 0
|
|
|
704 |
2 Herbert Papai 1 2 5382 herbert.papai@roe.raiffeisen.at wropah be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
705 |
10 Franz Heneis 2 1 franz be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
706 |
4 Manfred Krankenedl 2 2 manfred be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
707 |
11 Wolfgang Wieshofer 3 2 wolfgang be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
708 |
12 Heinz Gromes 2 2 heinz be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
709 |
17 Alexander Dorfmann 5 2 wroa20 be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
710 |
18 Gerald Vukovich 1 1 wrovuk be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
711 |
19 Josef Spiess 3 1 josef 5 0
|
|
|
712 |
22 Christine Hagen 2 1 nn2 5 0
|
|
|
713 |
24 Herbert Strallhofer 2 1 nn4 5 0
|
|
|
714 |
25 Sabine Benigni 3 1 nn5 5 0
|
|
|
715 |
26 Johannes Schuster 3 1 nn6 5 0
|
|
|
716 |
28 ? Sailer 2 1 nn8 5 0
|
|
|
717 |
29 Martin Zöch 2 1 nn9 5 0
|
|
|
718 |
30 Fachlich RACON 6 1 nn10 5 0
|
|
|
719 |
31 Entwicklung RACON 4 1 nn11 5 0
|
|
|
720 |
23 Heinz Donat 2 1 nn3 5 0
|
|
|
721 |
21 Gert Fenkart 2 1 nn1 5 0
|
|
|
722 |
20 Gerhard Grünwald 2 1 unknown 5 0
|
|
|
723 |
27 Daniela Marvan 2 1 nn7 5 0
|
|
|
724 |
3 Thomas Kainz 1 1 thomas.kainz@roe.raiffeisen.at wrokth be2332e4f2e07062832164eb5bc7a78f 3 0
|
|
|
725 |
32 Viktor Kotal 1 3 viktor.kotal@roe.raiffeisen.at wrokot be2332e4f2e07062832164eb5bc7a78f 6 0
|
|
|
726 |
7 Christian Urich 5 1 5316 christian.urich@roe.raiffeisen.at wroa10 be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
727 |
33 Franz Zdichynec 3 2 nn20 5 0
|
|
|
728 |
34 Manfred Holzer 2 2 nn21 5 0
|
|
|
729 |
35 Tanja Stöcker 1 1 5317 tanja.stoecker@roe.raiffeisen.at wrosto be2332e4f2e07062832164eb5bc7a78f 2 0
|
|
|
730 |
\.
|
|
|
731 |
--
|
|
|
732 |
-- Data for TOC Entry ID 64 (OID 157157)
|
|
|
733 |
--
|
|
|
734 |
-- Name: project Type: TABLE DATA Owner: wwwrun
|
|
|
735 |
--
|
|
|
736 |
|
|
|
737 |
|
|
|
738 |
COPY "project" FROM stdin;
|
|
|
739 |
11230 Sicherheitenbewertung 7 5 1 1 3
|
|
|
740 |
10388 Kreditrisikomanagement 6 5 3 2 3
|
|
|
741 |
13130 Meldewesen Neu 2 5 3 2 5
|
|
|
742 |
13510 Beteiligungen & Anteilsrechte 1 5 3 2 3
|
|
|
743 |
90757 TM BW Controlling 5 5 4 2 6
|
|
|
744 |
13200 Zahlungsbilanz Neu 17 5 3 2 1
|
|
|
745 |
999999 Testprojekt 1 5 4 2 1
|
|
|
746 |
13860 Teil B1 Restlaufzeiten und Risikostatistik 17 5 4 2 2
|
|
|
747 |
12661 GKE Globalrahmen 17 5 3 2 3
|
|
|
748 |
13980 Kompensandokonten 17 5 3 2 6
|
|
|
749 |
13870 Auslistung Kontrolldatei GI 0536 17 5 4 2 6
|
|
|
750 |
13880 Elektronische Rückmeldung GKE 17 5 4 2 1
|
|
|
751 |
13890 Großveranlagungen § 27 BWG 17 5 4 2 6
|
|
|
752 |
13900 Automatische Bewertungsbuchungen 17 5 4 2 6
|
|
|
753 |
13910 Testumgebung Meldewesen und Bilanz 17 5 4 2 6
|
|
|
754 |
13920 Stammdaten - NEU 17 5 4 2 6
|
|
|
755 |
11750 Design der Kreditprozesse 35 5 4 1 3
|
|
|
756 |
14060 GA-Statistikblatt RK0049 1 5 4 2 2
|
|
|
757 |
\.
|
|
|
758 |
--
|
|
|
759 |
-- Data for TOC Entry ID 65 (OID 157179)
|
|
|
760 |
--
|
|
|
761 |
-- Name: plan Type: TABLE DATA Owner: wwwrun
|
|
|
762 |
--
|
|
|
763 |
|
|
|
764 |
|
|
|
765 |
COPY "plan" FROM stdin;
|
|
|
766 |
6 1 12661 1
|
|
|
767 |
10 1 10388 1
|
|
|
768 |
2 1 13510 2
|
|
|
769 |
13 1 90757 2
|
|
|
770 |
11 1 13200 5
|
|
|
771 |
12 2 13200 2
|
|
|
772 |
15 1 999999 1
|
|
|
773 |
17 1 11230 1
|
|
|
774 |
14 1 13860 2
|
|
|
775 |
29 2 11750 1
|
|
|
776 |
26 1 14060 2
|
|
|
777 |
\.
|
|
|
778 |
--
|
|
|
779 |
-- Data for TOC Entry ID 66 (OID 157188)
|
|
|
780 |
--
|
|
|
781 |
-- Name: task Type: TABLE DATA Owner: wwwrun
|
|
|
782 |
--
|
|
|
783 |
|
|
|
784 |
|
|
|
785 |
COPY "task" FROM stdin;
|
|
|
786 |
9 2 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 40 100 0 1 2 1 1
|
|
|
787 |
88 2 3 0 2 Grunddaten fixieren Mai 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 30 100 0 1 3 1
|
|
|
788 |
89 2 4 0 2 Grunddaten fixieren Juni 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 15 100 0 1 3 1
|
|
|
789 |
10 2 5 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 13 100 0 1 2 1
|
|
|
790 |
12 2 6 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087250400 1 0 0 1 2 1
|
|
|
791 |
24 2 7 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 1 0 0 1 1 2
|
|
|
792 |
25 2 8 0 2 Prozesse Modellieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 30 0 0 1 2 2
|
|
|
793 |
26 2 9 0 2 Sollkonzept freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1091138400 1 0 0 1 2 2
|
|
|
794 |
27 2 10 0 2 Organisatorische Maßnahmen definieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 30 0 0 1 2 2
|
|
|
795 |
28 2 11 0 2 Organisationskonzept freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1091138400 1 0 0 1 2 2
|
|
|
796 |
29 2 12 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 1 0 0 1 1 3
|
|
|
797 |
30 2 13 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 90 0 0 1 2 3
|
|
|
798 |
31 2 14 0 2 Erstellen Interimslösung Excel 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 30 100 0 2 2 Durch Hr. Krankenedl erstellt.\r\nEr bekommt dafür 6 PT extra (Projektänderung!)\r\nÄnderung durch PLA am 20.08.2004 beschlossen. 3
|
|
|
799 |
32 2 15 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 14 0 0 1 2 3
|
|
|
800 |
33 2 16 0 2 IT-Lösung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1088546400 1 0 0 1 2 3
|
|
|
801 |
90 2 17 0 2 IT-Lösung abnehmen (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088546400 1 100 0 1 2 3
|
|
|
802 |
91 2 18 0 2 IT-Lösung Abnehmen Juli (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 5 100 0 1 2 3
|
|
|
803 |
92 2 19 0 2 IT-Lösung Abnehmen August (Excel) 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 10 100 0 1 2 3
|
|
|
804 |
100 12 4 0 2 Rahmenangebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 1 0 0 1 1 1
|
|
|
805 |
101 12 5 0 2 Definition Inhalte Rahmenangebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087336800 93 0 0 1 2 1
|
|
|
806 |
102 12 6 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097877600 1 0 0 1 2 1
|
|
|
807 |
103 12 7 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091224800 1 0 0 1 1 3
|
|
|
808 |
104 12 8 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091224800 92 0 0 1 2 3
|
|
|
809 |
105 12 9 0 2 Fachkonzept RI/RACON übergeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099000800 1 0 0 1 2 3
|
|
|
810 |
106 12 10 0 2 Softwarerealisierung gesamt 8421631 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 211 0 0 1 2 3
|
|
|
811 |
107 12 11 0 2 Testumgebung fertiggestellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1112306400 1 0 0 1 2 3
|
|
|
812 |
108 12 12 0 2 Abnahmetest MONSTAT 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1112306400 84 0 0 1 2 3
|
|
|
813 |
109 12 13 0 2 Abnahmetest MONSTAT freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1119823200 1 0 0 1 2 3
|
|
|
814 |
110 12 14 0 2 Abnahmetest 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 183 0 0 1 2 3
|
|
|
815 |
111 12 15 0 2 Abnahmetest freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1135983600 1 0 0 1 2 3
|
|
|
816 |
112 12 16 0 2 Testdaten an ÖNB / nach Freigabe Teilthema 32960 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1120168800 153 0 0 1 2 3
|
|
|
817 |
113 12 17 0 2 Projektende 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1135983600 1 0 0 1 2 3
|
|
|
818 |
127 13 1 0 2 Themenmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 0
|
|
|
819 |
97 12 1 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 1 0 0 1 1 0
|
|
|
820 |
99 12 3 0 2 Analyse beendet 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087250400 1 0 0 1 2 0
|
|
|
821 |
98 12 2 0 2 Analyse 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 48 0 0 1 2 0
|
|
|
822 |
132 15 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 1
|
|
|
823 |
133 15 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 19 0 0 1 2 1
|
|
|
824 |
134 15 3 2 2 Angebot erstellt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1095717600 1 0 0 1 2 1
|
|
|
825 |
135 15 4 0 2 Organisatorissche Massnahmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095631200 1 0 0 1 1 2
|
|
|
826 |
136 15 5 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095631200 72 0 0 1 2 2
|
|
|
827 |
137 15 6 5 2 Organisationskonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1101855600 1 0 0 1 2 2
|
|
|
828 |
138 15 7 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 1 0 0 1 1 3
|
|
|
829 |
139 15 8 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 71 0 0 1 2 3
|
|
|
830 |
140 15 9 0 2 Fachkonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1102978800 1 0 0 1 2 3
|
|
|
831 |
141 15 10 0 2 Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 1 0 0 1 1 4
|
|
|
832 |
142 15 11 0 2 Rolloutplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 70 0 0 1 2 4
|
|
|
833 |
143 15 12 0 2 Rolloutkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102892400 28 0 0 1 2 4
|
|
|
834 |
144 15 13 0 2 Rolloutkonzept fertig 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105398000 1 0 0 1 2 4
|
|
|
835 |
145 15 14 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1 0 0 1 1 6
|
|
|
836 |
146 15 15 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 181 0 0 1 2 6
|
|
|
837 |
148 6 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 1 0 0 1 1 1
|
|
|
838 |
149 6 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 4 0 0 1 2 1
|
|
|
839 |
150 6 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 1 0 0 1 2 1
|
|
|
840 |
151 6 4 0 2 Angebot freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1086213600 1 0 0 1 2 1
|
|
|
841 |
152 6 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086559200 1 0 0 1 1 3
|
|
|
842 |
153 6 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086559200 2 0 0 1 2 3
|
|
|
843 |
154 6 7 0 2 Entwicklung beauftragt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1086904800 1 0 0 1 2 3
|
|
|
844 |
155 6 8 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091397600 18 0 0 1 2 3
|
|
|
845 |
156 6 9 0 2 Software abgenommen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1092952800 1 0 0 1 2 3
|
|
|
846 |
157 6 10 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087768800 67 0 0 1 1 4
|
|
|
847 |
158 6 11 0 2 Rolloutkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1087768800 4 0 0 1 2 4
|
|
|
848 |
159 6 12 0 2 Einsatzrelevante Dokumente erstellt 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1088114400 1 0 0 1 2 4
|
|
|
849 |
160 6 13 0 2 Feldeinsatz freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1093557600 1 0 0 1 2 4
|
|
|
850 |
161 6 14 0 2 Dezentraler Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1095372000 1 0 0 1 1 5
|
|
|
851 |
162 6 15 0 2 Rollout abgeschlossen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1095372000 1 0 0 1 2 5
|
|
|
852 |
163 6 16 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 125 0 0 1 1 6
|
|
|
853 |
164 6 17 0 2 Laufende Tätigkeiten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 112 0 0 1 2 6
|
|
|
854 |
165 6 18 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1085695200 112 0 0 1 2 6
|
|
|
855 |
166 6 19 0 2 Software Entwicklung / Lizenz 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 60 0 0 1 2 6
|
|
|
856 |
167 6 20 0 2 RACON-Entwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 60 0 0 1 3 6
|
|
|
857 |
168 6 21 0 2 Projekt abgeschlossen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096495200 1 0 0 1 2 6
|
|
|
858 |
61 11 9 0 2 Rahmenangebot 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1087164000 1 0 0 1 2 0
|
|
|
859 |
59 11 8 0 2 Grenzüb. Finanztr 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 3 0
|
|
|
860 |
58 11 7 0 2 Grenzüb. Liegensch.- u. Vermögensübertr. 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 3 0
|
|
|
861 |
57 11 6 0 2 Sonstige Investitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
|
|
|
862 |
56 11 5 0 2 Direktinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
|
|
|
863 |
55 11 4 0 2 Portfolioinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 18 0 0 1 3 0
|
|
|
864 |
54 11 3 0 2 Analyse Teilthemen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 60 0 0 1 2 0
|
|
|
865 |
60 11 2 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1081807200 476 0 0 1 1 0
|
|
|
866 |
64 11 12 0 2 Angebot fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1090792800 1 0 0 1 2 1
|
|
|
867 |
63 11 11 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088978400 19 0 0 1 2 1
|
|
|
868 |
62 11 10 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088978400 21 0 0 1 1 1
|
|
|
869 |
67 11 15 0 2 Qualitätssicherung Sollprozess 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096236000 12 0 0 1 2 2
|
|
|
870 |
66 11 14 0 2 Organisatorische Massnahmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 26 0 0 1 2 2
|
|
|
871 |
68 11 13 0 2 Orgkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094767200 35 0 0 1 1 2
|
|
|
872 |
69 11 16 0 2 Orgkonzept freigeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097445600 1 0 0 1 2 2
|
|
|
873 |
70 11 17 0 2 Fachkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083535200 281 0 0 1 1 3
|
|
|
874 |
71 11 18 0 2 Portfolioinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 127 0 0 1 2 3
|
|
|
875 |
74 11 19 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096840800 78 0 0 1 2 Wertpapiere und Depotmeldungen\r\nRepo- und Wertpapierleihegeschäfte\r\nStammdaten interner Wertpapierkennummern\r\nFinanzderivate\r\nRepos 3
|
|
|
876 |
75 11 20 0 2 Fachkonzept freigeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105311600 1 0 0 1 3 3
|
|
|
877 |
76 11 21 0 2 Testplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 22 0 0 1 3 3
|
|
|
878 |
78 11 23 0 2 Testkonzept fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1107730800 1 0 0 1 4 3
|
|
|
879 |
77 11 22 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 19 0 0 1 4 3
|
|
|
880 |
79 11 24 0 2 Direktinvestitionen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 57 0 0 1 2 3
|
|
|
881 |
80 11 25 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1125957600 26 0 0 1 3 Unterjährige und Jährliche Meldungen 3
|
|
|
882 |
81 11 26 0 2 Fachkonzept freigeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096840800 1 0 0 1 3 3
|
|
|
883 |
82 11 27 0 2 Testplan erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 22 0 0 1 3 3
|
|
|
884 |
83 11 28 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 19 0 0 1 4 3
|
|
|
885 |
84 11 29 0 2 Testkonzept fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099263600 1 0 0 1 4 3
|
|
|
886 |
147 15 17 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 181 0 0 1 2 6
|
|
|
887 |
169 15 19 0 2 RACON Softwareentwicklung 16744448 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 74 0 0 1 3 6
|
|
|
888 |
171 15 18 0 2 Softwareentwicklung 16744448 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 1 0 0 1 2 6
|
|
|
889 |
172 15 20 0 2 Software fertig 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1105916400 1 0 0 1 3 6
|
|
|
890 |
115 10 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 183 100 0 1 2 1
|
|
|
891 |
114 10 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 183 100 0 1 1 1
|
|
|
892 |
173 10 4 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 303 0 0 1 1 2
|
|
|
893 |
174 10 5 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 303 0 0 1 2 0
|
|
|
894 |
176 10 19 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 454 0 0 1 2 6
|
|
|
895 |
175 10 18 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 454 0 0 1 1 6
|
|
|
896 |
124 10 15 0 2 Rolloutkonzept 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1080770400 363 0 0 1 2 4
|
|
|
897 |
131 10 14 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 30 0 0 1 1 4
|
|
|
898 |
123 10 13 0 2 Testkonzept erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1096581600 1 0 0 1 3 3
|
|
|
899 |
122 10 12 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 26 0 0 1 3 3
|
|
|
900 |
121 10 11 0 2 Fachliche Geschäftsfälle 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 26 0 0 1 3 3
|
|
|
901 |
126 10 17 0 2 Rolloutkonzept erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1112047200 1 0 0 1 2 4
|
|
|
902 |
118 10 7 0 2 Fachkonzeption 0 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 2 3
|
|
|
903 |
117 10 6 0 2 Systementwicklung 0 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 1 3
|
|
|
904 |
128 13 2 0 2 Themenaufbereitung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1093989600 1582 0 0 1 2 0
|
|
|
905 |
181 17 2 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 30 0 0 1 2 1
|
|
|
906 |
180 17 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 30 0 0 1 1 1
|
|
|
907 |
182 17 3 0 2 Organisationsentwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 40 0 0 1 1 2
|
|
|
908 |
183 17 4 0 2 Organisationskonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1075590000 40 0 0 1 2 2
|
|
|
909 |
185 17 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1078095600 120 0 0 1 2 3
|
|
|
910 |
186 17 7 0 2 Testkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1086040800 150 0 0 1 2 3
|
|
|
911 |
184 17 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1078095600 242 0 0 1 1 3
|
|
|
912 |
49 2 39 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
|
|
|
913 |
48 2 38 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
|
|
|
914 |
47 2 37 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
|
|
|
915 |
46 2 36 0 2 Themenmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 364 0 0 1 2 6
|
|
|
916 |
45 2 35 0 2 Projekt gestartet 65280 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1083362400 1 0 0 1 2 6
|
|
|
917 |
44 2 34 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 1 0 0 1 1 6
|
|
|
918 |
43 2 33 0 2 Rollout abgeschlossen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1110495600 1 0 0 1 2 5
|
|
|
919 |
42 2 32 0 2 Rollout durchführen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1096581600 162 0 0 1 2 5
|
|
|
920 |
41 2 31 0 2 Dezentralen Rollout planen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 184 0 0 1 2 5
|
|
|
921 |
40 2 30 0 2 Dezentraler Rollout 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 1 0 0 1 1 5
|
|
|
922 |
39 2 29 0 2 Einsatzrelevante Dokumente erstellt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1108508400 1 0 0 1 2 4
|
|
|
923 |
38 2 25 0 2 Rolloutkonzepte erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 184 0 0 1 2 4
|
|
|
924 |
36 2 24 0 2 Zentrale Rolloutplanung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1092607200 1 0 0 1 1 4
|
|
|
925 |
35 2 23 0 2 IT-Lösung abgenommen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1108335600 1 0 0 1 2 3
|
|
|
926 |
34 2 21 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1105916400 25 0 0 1 2 3
|
|
|
927 |
1 2 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1083362400 1 0 0 1 1 1
|
|
|
928 |
187 2 20 0 2 IT-Lösung programmieren 4227200 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1088632800 226 0 0 1 2 3
|
|
|
929 |
94 2 26 0 2 Rolloutkonzept 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1091311200 195 0 0 1 3 4
|
|
|
930 |
129 14 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 35 100 0 1 1 1
|
|
|
931 |
188 14 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 35 0 0 1 2 1
|
|
|
932 |
189 14 4 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097445600 1 0 0 1 2 1
|
|
|
933 |
190 14 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 20 0 0 1 1 3
|
|
|
934 |
191 14 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097445600 19 0 0 1 2 3
|
|
|
935 |
192 14 7 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098309600 10 0 0 1 2 3
|
|
|
936 |
197 14 13 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
|
|
|
937 |
196 14 12 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
|
|
|
938 |
194 14 10 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 1 6
|
|
|
939 |
193 14 9 0 2 Entwicklung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099173600 1 0 0 1 2 3
|
|
|
940 |
198 14 8 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098050400 11 0 0 1 2 3
|
|
|
941 |
199 14 14 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 55 0 0 1 2 6
|
|
|
942 |
130 14 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1094421600 24 0 0 1 2 1
|
|
|
943 |
177 10 10 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1072911600 424 0 0 1 3 Theofilu: Monat 9 (September):\r\nErstellen des Schulungskonzepts einschließlich der Folien und einiger Beispielreports.\r\n\r\nSicherstellen das in Vlbg. die Systeme für den Test vorbereitet sind und am Testtag auch einsatzbereit.\r\n\r\nRückmeldung von Gerl abwarten.\r\n\r\nTestkonzept nach Anmerkungen von Hagen überarbeiten.\r\n 3
|
|
|
944 |
297 26 1 0 2 Angebot 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 23 0 0 1 1 1
|
|
|
945 |
299 26 3 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099263600 4 0 0 1 2 1
|
|
|
946 |
300 26 4 0 2 Angebot freigegeben 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1099868400 1 0 0 1 2 1
|
|
|
947 |
301 26 5 0 2 Systementwicklung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099868400 32 0 0 1 1 3
|
|
|
948 |
302 26 6 0 2 Fachkonzept erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1101078000 11 0 0 1 2 3
|
|
|
949 |
303 26 7 0 2 IT-Lösung beauftragen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102287600 4 0 0 1 2 3
|
|
|
950 |
304 26 8 0 2 Entwicklung beauftragt 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1102633200 1 0 0 1 2 3
|
|
|
951 |
305 26 10 0 2 IT-Lösung abnehmen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1108940400 4 0 0 1 2 3
|
|
|
952 |
306 26 9 7 2 Entwicklung durchführen 4227200 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1102892400 74 0 0 1 2 3
|
|
|
953 |
307 26 11 10 2 Software abgenommen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1109545200 1 0 0 1 2 3
|
|
|
954 |
308 26 12 0 2 Phasenübergreifende Projektaktivitäten 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 1 6
|
|
|
955 |
309 26 13 0 2 Laufende Aktivitäten des Projektleiters 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
|
|
|
956 |
310 26 14 0 2 Berichterstattung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
|
|
|
957 |
311 26 15 0 2 Sitzungsmanagement 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 197 0 0 1 2 6
|
|
|
958 |
298 26 2 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097704800 1 100 0 1 2 1
|
|
|
959 |
312 26 16 0 2 Projekt abgeschlossen 16711680 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1114725600 1 0 0 1 2 6
|
|
|
960 |
318 29 1 0 2 Projektinitialisierung 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097791200 1 0 0 1 1 0
|
|
|
961 |
330 29 5 0 2 Grunddaten fixieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1097791200 1 0 0 1 1 1
|
|
|
962 |
335 29 19 0 2 Organisationskonzept freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098655200 1 0 0 1 1 2
|
|
|
963 |
323 29 18 0 2 Organisatorische Maßnahmen definieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1101769200 1 0 0 1 1 2
|
|
|
964 |
334 29 17 0 2 Sollkonzept freigegeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098396000 1 0 0 1 1 2
|
|
|
965 |
322 29 16 0 2 Prozesse modellieren 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1100473200 1 0 0 1 1 2
|
|
|
966 |
333 29 15 0 2 Projekt Kick-Off durchführen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1098223200 1 0 0 1 1 1
|
|
|
967 |
321 29 14 0 2 Projektvertrag abschließen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1099173600 1 0 0 1 1 1
|
|
|
968 |
332 29 13 0 2 Angebot freigeben 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 1 1097964000 1 0 0 1 1 1
|
|
|
969 |
320 29 9 0 2 Angebot erstellen 9221838 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 0 1098655200 1 0 0 1 1 1
|
|
|
970 |
\.
|
|
|
971 |
--
|
|
|
972 |
-- Data for TOC Entry ID 67 (OID 157201)
|
|
|
973 |
--
|
|
|
974 |
-- Name: allocation Type: TABLE DATA Owner: wwwrun
|
|
|
975 |
--
|
|
|
976 |
|
|
|
977 |
|
|
|
978 |
COPY "allocation" FROM stdin;
|
|
|
979 |
116 55 2 5 1 0 1080770400 30
|
|
|
980 |
117 55 2 5 1 0 1083362400 30
|
|
|
981 |
119 56 1 5 3 0 1080770400 30
|
|
|
982 |
120 56 1 10 3 0 1083362400 30
|
|
|
983 |
122 25 2 1 1 2 1088632800 30
|
|
|
984 |
123 25 1 3 3 2 1088632800 30
|
|
|
985 |
124 10 2 1 1 1 1086040800 30
|
|
|
986 |
125 89 12 2 3 1 1086040800 30
|
|
|
987 |
126 89 10 2 3 1 1086040800 30
|
|
|
988 |
127 89 4 2 3 1 1086040800 30
|
|
|
989 |
128 89 2 2 1 1 1086040800 30
|
|
|
990 |
129 89 8 2 3 1 1086040800 30
|
|
|
991 |
130 89 1 7 3 1 1086040800 30
|
|
|
992 |
131 89 11 2 3 1 1086040800 30
|
|
|
993 |
132 88 10 1 3 1 1083362400 30
|
|
|
994 |
133 88 4 1 3 1 1083362400 30
|
|
|
995 |
134 88 2 1 1 1 1083362400 30
|
|
|
996 |
135 88 8 1 3 1 1083362400 30
|
|
|
997 |
136 88 11 1 3 1 1083362400 30
|
|
|
998 |
137 27 12 0.5 3 2 1088632800 30
|
|
|
999 |
138 27 10 0.5 3 2 1088632800 30
|
|
|
1000 |
139 27 4 0.5 3 2 1088632800 30
|
|
|
1001 |
140 27 2 1 1 2 1088632800 30
|
|
|
1002 |
141 27 1 3 3 2 1088632800 30
|
|
|
1003 |
142 27 11 0.5 3 2 1088632800 30
|
|
|
1004 |
143 30 12 0.5 3 3 1086040800 30
|
|
|
1005 |
144 30 10 0.5 3 3 1086040800 30
|
|
|
1006 |
145 30 4 0.5 3 3 1086040800 30
|
|
|
1007 |
148 31 4 6 3 3 1091311200 30
|
|
|
1008 |
151 90 8 1 3 3 1088546400 30
|
|
|
1009 |
152 91 8 2 3 3 1088632800 30
|
|
|
1010 |
153 92 12 1.5 3 3 1091311200 30
|
|
|
1011 |
154 92 2 0.5 1 3 1091311200 30
|
|
|
1012 |
155 92 1 0.5 3 3 1091311200 30
|
|
|
1013 |
162 94 12 2 3 4 1091311200 30
|
|
|
1014 |
179 58 5 0.5 2 0 1080770400 30
|
|
|
1015 |
180 58 5 0.5 2 0 1083362400 30
|
|
|
1016 |
181 58 5 0.5 2 0 1086040800 30
|
|
|
1017 |
183 133 1 5 1 1 1093989600 30
|
|
|
1018 |
187 136 1 3 1 2 1095631200 30
|
|
|
1019 |
188 136 1 3 1 2 1096581600 30
|
|
|
1020 |
189 136 1 4 1 2 1099263600 30
|
|
|
1021 |
191 139 10 2 3 3 1096840800 30
|
|
|
1022 |
192 139 10 2 3 3 1099263600 30
|
|
|
1023 |
193 139 10 4 3 3 1101855600 30
|
|
|
1024 |
194 139 4 2 3 3 1096840800 30
|
|
|
1025 |
195 139 4 2 3 3 1099263600 30
|
|
|
1026 |
196 139 4 4 3 3 1101855600 30
|
|
|
1027 |
197 139 3 4 3 3 1096840800 30
|
|
|
1028 |
198 139 3 4 3 3 1099263600 30
|
|
|
1029 |
199 139 3 4 3 3 1101855600 30
|
|
|
1030 |
200 139 8 1 3 3 1096840800 30
|
|
|
1031 |
201 139 8 1 3 3 1099263600 30
|
|
|
1032 |
202 139 8 1 3 3 1101855600 30
|
|
|
1033 |
203 139 1 1 1 3 1096840800 30
|
|
|
1034 |
204 139 1 1 1 3 1099263600 30
|
|
|
1035 |
205 139 1 1 1 3 1101855600 30
|
|
|
1036 |
206 139 11 1.5 3 3 1096840800 30
|
|
|
1037 |
207 139 11 1.5 3 3 1099263600 30
|
|
|
1038 |
208 139 11 2 3 3 1101855600 30
|
|
|
1039 |
209 63 1 20 3 1 1088632800 30
|
|
|
1040 |
214 122 1 1 3 3 1093989600 30
|
|
|
1041 |
215 121 1 6 3 3 1093989600 30
|
|
|
1042 |
218 136 5 0.5 2 2 1093989600 30
|
|
|
1043 |
219 136 5 0.5 2 2 1096581600 30
|
|
|
1044 |
220 136 5 0.5 2 2 1099263600 30
|
|
|
1045 |
222 142 1 1 1 4 1104534000 30
|
|
|
1046 |
228 143 3 2 3 4 1101855600 30
|
|
|
1047 |
229 143 3 4 3 4 1104534000 30
|
|
|
1048 |
231 146 1 0.5 1 6 1093989600 30
|
|
|
1049 |
232 146 1 0.5 1 6 1096581600 30
|
|
|
1050 |
233 146 1 0.5 1 6 1099263600 30
|
|
|
1051 |
234 146 1 0.5 1 6 1101855600 30
|
|
|
1052 |
235 146 1 0.5 1 6 1104534000 30
|
|
|
1053 |
236 146 1 0.5 1 6 1107212400 30
|
|
|
1054 |
238 147 1 0.5 1 6 1093989600 30
|
|
|
1055 |
239 147 1 0.5 1 6 1096581600 30
|
|
|
1056 |
240 147 1 0.5 1 6 1099263600 30
|
|
|
1057 |
241 147 1 0.5 1 6 1101855600 30
|
|
|
1058 |
242 147 1 0.5 1 6 1104534000 30
|
|
|
1059 |
243 147 1 0.5 1 6 1107212400 30
|
|
|
1060 |
245 147 5 0.5 2 6 1093989600 30
|
|
|
1061 |
246 147 5 0.5 2 6 1096581600 30
|
|
|
1062 |
247 147 5 0.5 2 6 1099263600 30
|
|
|
1063 |
248 147 5 0.5 2 6 1101855600 30
|
|
|
1064 |
249 147 5 0.5 2 6 1104534000 30
|
|
|
1065 |
250 147 5 0.5 2 6 1107212400 30
|
|
|
1066 |
252 169 16 15 4 6 1099263600 30
|
|
|
1067 |
253 169 16 15 4 6 1101855600 30
|
|
|
1068 |
254 169 16 15 4 6 1104534000 30
|
|
|
1069 |
262 142 8 2 3 4 1101855600 30
|
|
|
1070 |
263 142 8 1 3 4 1104534000 30
|
|
|
1071 |
265 142 4 2 3 4 1099263600 30
|
|
|
1072 |
266 142 4 4 3 4 1101855600 30
|
|
|
1073 |
276 174 6 4 1 0 1078095600 30
|
|
|
1074 |
277 174 6 1.5 1 0 1080770400 30
|
|
|
1075 |
278 174 6 5.75 1 0 1083362400 30
|
|
|
1076 |
279 174 6 6 1 0 1086040800 30
|
|
|
1077 |
280 174 6 10.75 1 0 1088632800 30
|
|
|
1078 |
281 174 6 3.5 1 0 1091311200 30
|
|
|
1079 |
282 174 6 6 1 0 1096581600 30
|
|
|
1080 |
283 174 6 7 1 0 1099263600 30
|
|
|
1081 |
286 174 18 2 3 0 1075590000 30
|
|
|
1082 |
287 174 18 2 3 0 1080770400 30
|
|
|
1083 |
288 174 18 0.5 3 0 1083362400 30
|
|
|
1084 |
289 174 18 1.75 3 0 1086040800 30
|
|
|
1085 |
291 174 16 26 3 0 1099263600 30
|
|
|
1086 |
293 174 19 1.5 3 0 1083362400 30
|
|
|
1087 |
294 174 19 2 3 0 1091311200 30
|
|
|
1088 |
295 174 19 2 3 0 1099263600 30
|
|
|
1089 |
297 174 7 8 3 0 1075590000 30
|
|
|
1090 |
298 174 7 8 3 0 1083362400 30
|
|
|
1091 |
299 174 7 2.5 3 0 1088632800 30
|
|
|
1092 |
300 174 7 2.5 3 0 1091311200 30
|
|
|
1093 |
301 174 7 3 3 0 1093989600 30
|
|
|
1094 |
303 174 5 1 2 0 1075590000 30
|
|
|
1095 |
304 174 5 1 2 0 1083362400 30
|
|
|
1096 |
305 174 5 1 2 0 1086040800 30
|
|
|
1097 |
306 174 5 1 2 0 1088632800 30
|
|
|
1098 |
307 174 5 3 2 0 1091311200 30
|
|
|
1099 |
308 174 5 3 2 0 1093989600 30
|
|
|
1100 |
310 174 20 0.5 3 0 1086040800 30
|
|
|
1101 |
311 174 20 2 3 0 1093989600 30
|
|
|
1102 |
312 174 20 2 3 0 1099263600 30
|
|
|
1103 |
314 174 21 2 3 0 1093989600 30
|
|
|
1104 |
315 174 21 2 3 0 1099263600 30
|
|
|
1105 |
317 174 22 1 3 0 1088632800 30
|
|
|
1106 |
319 174 23 2 3 0 1093989600 30
|
|
|
1107 |
320 174 23 2 3 0 1099263600 30
|
|
|
1108 |
322 174 24 2 3 0 1093989600 30
|
|
|
1109 |
323 174 24 2 3 0 1099263600 30
|
|
|
1110 |
325 174 25 1 3 0 1075590000 30
|
|
|
1111 |
326 174 25 1.5 3 0 1083362400 30
|
|
|
1112 |
327 174 25 3 3 0 1093989600 30
|
|
|
1113 |
328 174 25 2 3 0 1099263600 30
|
|
|
1114 |
331 177 6 10.5 1 3 1072911600 30
|
|
|
1115 |
332 177 6 9 1 3 1075590000 30
|
|
|
1116 |
333 177 6 12.375 1 3 1078095600 30
|
|
|
1117 |
334 177 6 4.5 1 3 1080770400 30
|
|
|
1118 |
335 177 6 2.75 1 3 1083362400 30
|
|
|
1119 |
336 177 6 6.625 1 3 1086040800 30
|
|
|
1120 |
337 177 6 2.375 1 3 1088632800 30
|
|
|
1121 |
338 177 6 7.875 1 3 1091311200 30
|
|
|
1122 |
339 177 6 2 1 3 1093989600 30
|
|
|
1123 |
340 177 6 6 1 3 1096581600 30
|
|
|
1124 |
341 177 6 3 1 3 1099263600 30
|
|
|
1125 |
342 177 6 1 1 3 1104534000 30
|
|
|
1126 |
343 177 6 2 1 3 1107212400 30
|
|
|
1127 |
357 177 16 26 4 3 1099263600 30
|
|
|
1128 |
363 177 19 6 3 3 1072911600 30
|
|
|
1129 |
364 177 19 5 3 3 1078095600 30
|
|
|
1130 |
365 177 19 2 3 3 1080770400 30
|
|
|
1131 |
367 177 7 10 3 3 1072911600 30
|
|
|
1132 |
368 177 7 8 3 3 1078095600 30
|
|
|
1133 |
369 177 7 8 3 3 1080770400 30
|
|
|
1134 |
370 177 7 2 3 3 1086040800 30
|
|
|
1135 |
371 177 7 1 3 3 1088632800 30
|
|
|
1136 |
372 177 7 4 3 3 1091311200 30
|
|
|
1137 |
373 177 7 5 3 3 1093989600 30
|
|
|
1138 |
374 177 7 5 3 3 1096581600 30
|
|
|
1139 |
375 177 7 3 3 3 1099263600 30
|
|
|
1140 |
377 177 5 1 2 3 1078095600 30
|
|
|
1141 |
378 177 5 2 2 3 1080770400 30
|
|
|
1142 |
379 177 5 0.5 2 3 1091311200 30
|
|
|
1143 |
380 177 5 2 2 3 1093989600 30
|
|
|
1144 |
381 177 5 2 2 3 1096581600 30
|
|
|
1145 |
382 177 5 2 2 3 1099263600 30
|
|
|
1146 |
384 177 20 2 3 3 1078095600 30
|
|
|
1147 |
385 177 20 1 3 3 1080770400 30
|
|
|
1148 |
387 177 21 1 3 3 1072911600 30
|
|
|
1149 |
388 177 21 3 3 3 1078095600 30
|
|
|
1150 |
389 177 21 1 3 3 1080770400 30
|
|
|
1151 |
390 177 21 1 3 3 1091311200 30
|
|
|
1152 |
392 177 22 1 3 3 1078095600 30
|
|
|
1153 |
394 177 23 1 3 3 1072911600 30
|
|
|
1154 |
395 177 23 3 3 3 1078095600 30
|
|
|
1155 |
396 177 23 1 3 3 1080770400 30
|
|
|
1156 |
397 177 23 1 3 3 1091311200 30
|
|
|
1157 |
399 177 27 1.5 3 3 1078095600 30
|
|
|
1158 |
401 177 28 9 3 3 1078095600 30
|
|
|
1159 |
403 177 24 1 3 3 1072911600 30
|
|
|
1160 |
404 177 24 3 3 3 1078095600 30
|
|
|
1161 |
405 177 24 1 3 3 1080770400 30
|
|
|
1162 |
406 177 24 1 3 3 1093989600 30
|
|
|
1163 |
407 177 24 1 3 3 1096581600 30
|
|
|
1164 |
408 177 24 1 3 3 1099263600 30
|
|
|
1165 |
410 177 29 1 3 3 1078095600 30
|
|
|
1166 |
411 177 29 1 3 3 1080770400 30
|
|
|
1167 |
413 177 25 1 3 3 1072911600 30
|
|
|
1168 |
414 177 25 3 3 3 1078095600 30
|
|
|
1169 |
415 177 25 1 3 3 1080770400 30
|
|
|
1170 |
416 177 25 3 3 3 1091311200 30
|
|
|
1171 |
417 177 25 6 3 3 1093989600 30
|
|
|
1172 |
418 177 25 1 3 3 1096581600 30
|
|
|
1173 |
419 177 25 1 3 3 1099263600 30
|
|
|
1174 |
421 177 30 3 3 3 1093989600 30
|
|
|
1175 |
422 177 30 3 3 3 1096581600 30
|
|
|
1176 |
423 177 30 3 3 3 1099263600 30
|
|
|
1177 |
425 177 31 38 4 3 1072911600 30
|
|
|
1178 |
426 177 31 38 4 3 1075590000 30
|
|
|
1179 |
427 177 31 38 4 3 1078095600 30
|
|
|
1180 |
428 177 31 38 4 3 1080770400 30
|
|
|
1181 |
429 177 31 38 4 3 1083362400 30
|
|
|
1182 |
430 177 31 38 4 3 1086040800 30
|
|
|
1183 |
431 177 31 38 4 3 1088632800 30
|
|
|
1184 |
432 177 31 38 4 3 1091311200 30
|
|
|
1185 |
433 177 31 38 4 3 1093989600 30
|
|
|
1186 |
434 177 31 38 4 3 1096581600 30
|
|
|
1187 |
435 177 31 40 4 3 1099263600 30
|
|
|
1188 |
437 177 13 0.375 3 3 1072911600 30
|
|
|
1189 |
439 124 6 2 3 4 1091311200 30
|
|
|
1190 |
440 124 6 4 3 4 1093989600 30
|
|
|
1191 |
441 124 6 6 3 4 1096581600 30
|
|
|
1192 |
442 124 6 2 3 4 1099263600 30
|
|
|
1193 |
443 124 6 5 3 4 1101855600 30
|
|
|
1194 |
444 124 6 8 3 4 1104534000 30
|
|
|
1195 |
445 124 6 6 3 4 1107212400 30
|
|
|
1196 |
446 124 6 2 3 4 1109631600 30
|
|
|
1197 |
450 124 16 24.5 3 4 1099263600 30
|
|
|
1198 |
452 124 7 2 3 4 1096581600 30
|
|
|
1199 |
454 176 6 1 1 6 1075590000 30
|
|
|
1200 |
455 176 6 1 1 6 1078095600 30
|
|
|
1201 |
456 176 6 1 1 6 1080770400 30
|
|
|
1202 |
457 176 6 1 1 6 1083362400 30
|
|
|
1203 |
458 176 6 3 1 6 1086040800 30
|
|
|
1204 |
459 176 6 2.5 1 6 1088632800 30
|
|
|
1205 |
460 176 6 3 1 6 1091311200 30
|
|
|
1206 |
461 176 6 3 1 6 1093989600 30
|
|
|
1207 |
462 176 6 2 1 6 1096581600 30
|
|
|
1208 |
463 176 6 3 1 6 1099263600 30
|
|
|
1209 |
464 176 6 2 1 6 1101855600 30
|
|
|
1210 |
465 176 6 2 1 6 1104534000 30
|
|
|
1211 |
466 176 6 2 1 6 1107212400 30
|
|
|
1212 |
467 176 6 3 1 6 1109631600 30
|
|
|
1213 |
483 176 5 2 2 6 1072911600 30
|
|
|
1214 |
484 176 5 1 2 6 1075590000 30
|
|
|
1215 |
485 176 5 1 2 6 1078095600 30
|
|
|
1216 |
486 176 5 1 2 6 1083362400 30
|
|
|
1217 |
487 176 5 1 2 6 1086040800 30
|
|
|
1218 |
488 176 5 1 2 6 1088632800 30
|
|
|
1219 |
489 176 5 1 2 6 1091311200 30
|
|
|
1220 |
490 176 5 1 2 6 1093989600 30
|
|
|
1221 |
491 176 5 1 2 6 1096581600 30
|
|
|
1222 |
492 176 5 1 2 6 1099263600 30
|
|
|
1223 |
493 176 5 1 2 6 1101855600 30
|
|
|
1224 |
494 176 5 1 2 6 1104534000 30
|
|
|
1225 |
495 176 5 1 2 6 1107212400 30
|
|
|
1226 |
496 176 5 1 2 6 1109631600 30
|
|
|
1227 |
498 176 7 2 3 6 1075590000 30
|
|
|
1228 |
499 176 7 2 3 6 1078095600 30
|
|
|
1229 |
500 176 7 2 3 6 1080770400 30
|
|
|
1230 |
501 176 7 2 3 6 1083362400 30
|
|
|
1231 |
502 176 7 1 3 6 1086040800 30
|
|
|
1232 |
503 176 7 0.5 3 6 1088632800 30
|
|
|
1233 |
504 176 7 1 3 6 1093989600 30
|
|
|
1234 |
505 176 7 1 3 6 1096581600 30
|
|
|
1235 |
506 176 7 1 3 6 1099263600 30
|
|
|
1236 |
507 176 7 1 3 6 1101855600 30
|
|
|
1237 |
508 176 7 1 3 6 1104534000 30
|
|
|
1238 |
509 176 7 1 3 6 1107212400 30
|
|
|
1239 |
510 176 7 1 3 6 1109631600 30
|
|
|
1240 |
512 136 3 1 3 2 1093989600 30
|
|
|
1241 |
513 136 3 2 3 2 1096581600 30
|
|
|
1242 |
514 136 3 3 3 2 1099263600 30
|
|
|
1243 |
216 133 3 10 3 1 1093989600 30
|
|
|
1244 |
259 142 11 1 3 4 1099263600 30
|
|
|
1245 |
516 142 11 2 3 4 1101855600 30
|
|
|
1246 |
260 142 11 2 3 4 1104534000 30
|
|
|
1247 |
256 142 10 1 3 4 1099263600 30
|
|
|
1248 |
517 142 10 2 3 4 1101855600 30
|
|
|
1249 |
257 142 10 3 3 4 1104534000 30
|
|
|
1250 |
224 142 3 4 3 4 1099263600 30
|
|
|
1251 |
225 142 3 2 3 4 1101855600 30
|
|
|
1252 |
226 142 3 5 3 4 1104534000 30
|
|
|
1253 |
518 143 1 8 1 4 1101855600 30
|
|
|
1254 |
519 143 1 8 1 4 1104534000 30
|
|
|
1255 |
520 128 1 5 1 0 1093989600 30
|
|
|
1256 |
521 128 1 5 1 0 1096581600 30
|
|
|
1257 |
522 32 2 1 1 3 1086040800 30
|
|
|
1258 |
523 47 2 0.5 1 6 1083362400 30
|
|
|
1259 |
524 47 2 0.5 1 6 1086040800 30
|
|
|
1260 |
525 47 1 0.5 1 6 1091311200 30
|
|
|
1261 |
526 48 2 0.5 1 6 1083362400 30
|
|
|
1262 |
527 48 2 0.5 1 6 1086040800 30
|
|
|
1263 |
528 48 2 0.5 1 6 1088632800 30
|
|
|
1264 |
536 49 2 0.5 1 6 1086040800 30
|
|
|
1265 |
537 49 2 0.5 1 6 1088632800 30
|
|
|
1266 |
538 49 2 0.5 1 6 1091311200 30
|
|
|
1267 |
560 34 10 1.5 3 3 1107212400 30
|
|
|
1268 |
561 34 4 1.5 3 3 1107212400 30
|
|
|
1269 |
562 34 1 0.5 1 3 1104534000 30
|
|
|
1270 |
563 34 1 0.5 1 3 1107212400 30
|
|
|
1271 |
568 94 10 2 3 4 1091311200 30
|
|
|
1272 |
569 94 10 1 3 4 1104534000 30
|
|
|
1273 |
570 94 10 3 3 4 1107212400 30
|
|
|
1274 |
571 150 1 1 3 1 1086040800 30
|
|
|
1275 |
572 153 1 1 3 3 1086040800 30
|
|
|
1276 |
573 155 2 0.5 1 3 1091311200 30
|
|
|
1277 |
574 155 1 0.5 3 3 1091311200 30
|
|
|
1278 |
575 158 1 1 3 4 1086040800 30
|
|
|
1279 |
576 164 2 0.5 1 6 1093989600 30
|
|
|
1280 |
577 165 2 0.5 1 6 1083362400 30
|
|
|
1281 |
578 165 2 0.5 1 6 1088632800 30
|
|
|
1282 |
579 165 2 0.5 1 6 1093989600 30
|
|
|
1283 |
580 165 1 0.5 3 6 1091311200 30
|
|
|
1284 |
581 165 1 0.5 3 6 1093989600 30
|
|
|
1285 |
582 98 3 3 3 0 1080770400 30
|
|
|
1286 |
583 98 3 4 3 0 1083362400 30
|
|
|
1287 |
584 98 2 2 1 0 1080770400 30
|
|
|
1288 |
585 98 2 3 1 0 1083362400 30
|
|
|
1289 |
586 98 1 5 3 0 1080770400 30
|
|
|
1290 |
587 98 1 7 3 0 1083362400 30
|
|
|
1291 |
590 104 1 0.5 3 3 1093989600 30
|
|
|
1292 |
552 49 5 0.5 2 6 1086040800 30
|
|
|
1293 |
553 49 5 0.5 2 6 1088632800 30
|
|
|
1294 |
554 49 5 0.5 2 6 1091311200 30
|
|
|
1295 |
557 49 5 1 2 6 1104534000 30
|
|
|
1296 |
558 49 5 1 2 6 1107212400 30
|
|
|
1297 |
559 49 5 0.5 2 6 1109631600 30
|
|
|
1298 |
529 48 1 0.5 1 6 1088632800 30
|
|
|
1299 |
530 48 1 1 1 6 1091311200 30
|
|
|
1300 |
533 48 1 1 1 6 1104534000 30
|
|
|
1301 |
534 48 1 1 1 6 1107212400 30
|
|
|
1302 |
535 48 1 0.5 1 6 1109631600 30
|
|
|
1303 |
591 181 3 5 3 1 1072911600 30
|
|
|
1304 |
592 181 7 1 1 1 1072911600 30
|
|
|
1305 |
593 183 3 5 3 2 1075590000 30
|
|
|
1306 |
594 183 3 5 3 2 1078095600 30
|
|
|
1307 |
595 183 7 1 1 2 1075590000 30
|
|
|
1308 |
596 183 7 1 1 2 1078095600 30
|
|
|
1309 |
597 185 3 2 3 3 1078095600 30
|
|
|
1310 |
598 185 3 8 3 3 1080770400 30
|
|
|
1311 |
599 185 3 10 3 3 1083362400 30
|
|
|
1312 |
600 185 3 10 3 3 1086040800 30
|
|
|
1313 |
601 185 7 1 1 3 1078095600 30
|
|
|
1314 |
602 185 7 1 1 3 1080770400 30
|
|
|
1315 |
603 185 7 1 1 3 1083362400 30
|
|
|
1316 |
604 185 7 1 1 3 1086040800 30
|
|
|
1317 |
605 186 3 5 3 3 1093989600 30
|
|
|
1318 |
606 186 3 5 3 3 1096581600 30
|
|
|
1319 |
615 187 31 15.25 4 3 1088632800 30
|
|
|
1320 |
616 187 31 15.25 4 3 1091311200 30
|
|
|
1321 |
617 187 31 15.25 4 3 1093989600 30
|
|
|
1322 |
618 187 31 15.25 4 3 1096581600 30
|
|
|
1323 |
619 187 31 15.25 4 3 1099263600 30
|
|
|
1324 |
620 187 31 15.25 4 3 1101855600 30
|
|
|
1325 |
621 187 31 15.25 4 3 1104534000 30
|
|
|
1326 |
622 187 31 15.25 4 3 1107212400 30
|
|
|
1327 |
149 30 1 2 3 3 1088632800 30
|
|
|
1328 |
147 30 11 0.5 3 3 1086040800 30
|
|
|
1329 |
156 34 8 2 3 3 1105916400 30
|
|
|
1330 |
564 34 11 1 3 3 1107212400 30
|
|
|
1331 |
623 94 4 2 3 4 1091311200 30
|
|
|
1332 |
624 94 4 1 3 4 1104534000 30
|
|
|
1333 |
625 94 4 3 3 4 1107212400 30
|
|
|
1334 |
626 94 8 0.5 3 4 1091311200 30
|
|
|
1335 |
627 94 8 1 3 4 1104534000 30
|
|
|
1336 |
628 94 8 1 3 4 1107212400 30
|
|
|
1337 |
629 94 1 1.5 1 4 1091311200 30
|
|
|
1338 |
630 94 1 1 1 4 1104534000 30
|
|
|
1339 |
631 94 1 2 1 4 1107212400 30
|
|
|
1340 |
632 94 11 1 3 4 1091311200 30
|
|
|
1341 |
633 94 11 1 3 4 1104534000 30
|
|
|
1342 |
634 94 11 2 3 4 1107212400 30
|
|
|
1343 |
635 130 10 0.5 3 1 1093989600 30
|
|
|
1344 |
636 130 4 0.5 3 1 1093989600 30
|
|
|
1345 |
637 130 11 0.5 3 1 1093989600 30
|
|
|
1346 |
638 130 8 0.5 3 1 1093989600 30
|
|
|
1347 |
639 188 17 3 1 1 1093989600 30
|
|
|
1348 |
640 130 33 0.5 3 1 1093989600 30
|
|
|
1349 |
641 191 17 3 1 3 1096581600 30
|
|
|
1350 |
642 191 1 2 3 3 1096581600 30
|
|
|
1351 |
645 130 34 0.5 3 1 1093989600 30
|
|
|
1352 |
646 191 34 0.5 3 3 1096581600 30
|
|
|
1353 |
644 191 4 1 3 3 1096581600 30
|
|
|
1354 |
647 191 11 1 3 3 1096581600 30
|
|
|
1355 |
648 191 8 2 3 3 1096581600 30
|
|
|
1356 |
643 191 10 0.5 3 3 1096581600 30
|
|
|
1357 |
649 192 17 1 1 3 1096581600 30
|
|
|
1358 |
650 192 8 1 3 3 1096581600 30
|
|
|
1359 |
651 198 1 2 3 3 1096581600 30
|
|
|
1360 |
652 198 17 3 1 3 1096581600 30
|
|
|
1361 |
653 198 10 0.5 3 3 1098050400 30
|
|
|
1362 |
654 198 34 0.5 3 3 1098050400 30
|
|
|
1363 |
655 198 4 1 3 3 1098050400 30
|
|
|
1364 |
656 198 11 1 3 3 1098050400 30
|
|
|
1365 |
657 198 8 3 3 3 1098050400 30
|
|
|
1366 |
660 196 17 3 1 6 1093989600 30
|
|
|
1367 |
661 196 17 3 1 6 1096581600 30
|
|
|
1368 |
662 197 17 2 1 6 1093989600 30
|
|
|
1369 |
663 197 17 2 1 6 1096581600 30
|
|
|
1370 |
664 199 17 1.5 1 6 1093989600 30
|
|
|
1371 |
665 199 17 1.5 1 6 1096581600 30
|
|
|
1372 |
666 130 1 1 3 1 1094421600 30
|
|
|
1373 |
667 130 17 1 1 1 1093989600 30
|
|
|
1374 |
669 124 1 5 3 4 1096581600 30
|
|
|
1375 |
670 124 1 8 3 4 1099263600 30
|
|
|
1376 |
345 177 1 10 3 3 1072911600 30
|
|
|
1377 |
346 177 1 13.5 3 3 1075590000 30
|
|
|
1378 |
347 177 1 11.5 3 3 1078095600 30
|
|
|
1379 |
348 177 1 8.25 3 3 1080770400 30
|
|
|
1380 |
349 177 1 2 3 3 1083362400 30
|
|
|
1381 |
350 177 1 2 3 3 1086040800 30
|
|
|
1382 |
351 177 1 0.5 3 3 1088632800 30
|
|
|
1383 |
352 177 1 2 3 3 1091311200 30
|
|
|
1384 |
353 177 1 8 3 3 1096581600 30
|
|
|
1385 |
354 177 1 3 3 3 1104534000 30
|
|
|
1386 |
355 177 1 4 3 3 1107212400 30
|
|
|
1387 |
807 298 1 1 1 1 1096581600 30
|
|
|
1388 |
808 299 1 2 1 1 1099263600 30
|
|
|
1389 |
824 311 1 0.5 1 6 1096581600 30
|
|
|
1390 |
825 311 1 0.5 1 6 1112306400 30
|
|
|
1391 |
827 303 1 1 1 3 1101855600 30
|
|
|
1392 |
831 305 1 2 1 3 1107212400 30
|
|
|
1393 |
826 302 1 2 1 3 1101855600 30
|
|
|
1394 |
809 309 1 0.5 1 6 1096581600 30
|
|
|
1395 |
834 309 1 0.5 1 6 1104534000 30
|
|
|
1396 |
835 309 1 0.5 1 6 1109631600 30
|
|
|
1397 |
813 309 1 0.5 1 6 1112306400 30
|
|
|
1398 |
837 310 5 0.5 2 6 1099263600 30
|
|
|
1399 |
842 310 5 0.5 2 6 1112306400 30
|
|
|
1400 |
820 310 1 0.5 1 6 1099263600 30
|
|
|
1401 |
823 310 1 0.5 1 6 1112306400 30
|
|
|
1402 |
\.
|
|
|
1403 |
--
|
|
|
1404 |
-- Data for TOC Entry ID 68 (OID 157223)
|
|
|
1405 |
--
|
|
|
1406 |
-- Name: wdone Type: TABLE DATA Owner: wwwrun
|
|
|
1407 |
--
|
|
|
1408 |
|
|
|
1409 |
|
|
|
1410 |
COPY "wdone" FROM stdin;
|
|
|
1411 |
1 13510 1 1086559200 8 89 0 1 t \N
|
|
|
1412 |
2 13510 1 1086645600 8 89 0 1 t \N
|
|
|
1413 |
3 13510 1 1086732000 8 89 0 1 t \N
|
|
|
1414 |
8 13510 1 1086818400 8 89 0 1 t \N
|
|
|
1415 |
9 13510 1 1086904800 8 89 0 1 t \N
|
|
|
1416 |
10 13510 1 1087164000 8 89 0 1 t \N
|
|
|
1417 |
11 13510 1 1087250400 8 89 0 1 t \N
|
|
|
1418 |
12 13510 1 1088978400 8 27 0 2 t \N
|
|
|
1419 |
13 13510 1 1089064800 8 27 0 2 t \N
|
|
|
1420 |
14 13510 1 1089756000 8 30 0 3 t \N
|
|
|
1421 |
16 13510 1 1093903200 4 48 0 6 t \N
|
|
|
1422 |
17 13510 2 1084140000 8 88 0 1 t \N
|
|
|
1423 |
18 13510 2 1086559200 8 89 0 1 t \N
|
|
|
1424 |
19 13510 2 1086645600 8 89 0 1 t \N
|
|
|
1425 |
21 13510 2 1088978400 8 27 0 2 t \N
|
|
|
1426 |
22 13510 2 1090360800 3 27 0 2 t \N
|
|
|
1427 |
23 13510 2 1090360800 5 30 0 3 t \N
|
|
|
1428 |
25 13510 2 1088460000 8 48 0 6 t \N
|
|
|
1429 |
26 13510 2 1088546400 4 47 0 6 t \N
|
|
|
1430 |
27 13510 2 1092693600 4 31 0 3 t \N
|
|
|
1431 |
28 13510 2 1093903200 4 47 0 6 t \N
|
|
|
1432 |
29 90757 1 1094680800 8 128 0 0 t \N
|
|
|
1433 |
30 13510 1 1091138400 4 48 0 6 t \N
|
|
|
1434 |
31 13510 10 1084744800 8 88 0 1 t \N
|
|
|
1435 |
32 13510 10 1086559200 8 89 0 1 t \N
|
|
|
1436 |
33 13510 10 1086645600 8 89 0 1 t \N
|
|
|
1437 |
34 13510 10 1089669600 4 27 0 2 t \N
|
|
|
1438 |
35 13510 10 1090274400 4 30 0 3 t \N
|
|
|
1439 |
36 13510 10 1092780000 8 94 0 4 t \N
|
|
|
1440 |
37 13510 10 1092866400 8 94 0 4 t \N
|
|
|
1441 |
38 13510 4 1084140000 8 88 0 1 t \N
|
|
|
1442 |
41 13510 4 1089583200 4 27 0 2 t \N
|
|
|
1443 |
42 13510 4 1089669600 4 30 0 3 t \N
|
|
|
1444 |
43 13510 4 1092607200 8 31 0 3 t \N
|
|
|
1445 |
44 13510 4 1092693600 8 31 0 3 t \N
|
|
|
1446 |
45 13510 4 1092780000 8 31 0 3 t \N
|
|
|
1447 |
46 13510 4 1092866400 8 31 0 3 t \N
|
|
|
1448 |
47 13510 4 1092952800 8 31 0 3 t \N
|
|
|
1449 |
48 13510 4 1093212000 8 31 0 3 t \N
|
|
|
1450 |
49 13510 4 1093212000 8 94 0 4 t \N
|
|
|
1451 |
50 13510 4 1093298400 8 94 0 4 t \N
|
|
|
1452 |
51 13510 11 1084140000 8 88 0 1 t \N
|
|
|
1453 |
52 13510 11 1086559200 8 89 0 1 t \N
|
|
|
1454 |
53 13510 11 1086645600 8 89 0 1 t \N
|
|
|
1455 |
54 13510 11 1089583200 4 27 0 2 t \N
|
|
|
1456 |
55 13510 11 1089669600 4 30 0 3 t \N
|
|
|
1457 |
56 13510 11 1092002400 8 94 0 4 t \N
|
|
|
1458 |
57 13510 12 1086559200 8 89 0 1 t \N
|
|
|
1459 |
58 13510 12 1086645600 8 89 0 1 t \N
|
|
|
1460 |
59 13510 12 1089583200 4 27 0 2 t \N
|
|
|
1461 |
60 13510 12 1089669600 4 30 0 3 t \N
|
|
|
1462 |
61 13510 12 1092002400 8 30 0 3 t \N
|
|
|
1463 |
62 13510 12 1092088800 4 30 0 3 t \N
|
|
|
1464 |
63 13510 12 1092175200 8 94 0 4 t \N
|
|
|
1465 |
64 13510 12 1092693600 8 94 0 4 t \N
|
|
|
1466 |
65 13200 1 1079910000 2 98 0 0 t \N
|
|
|
1467 |
66 13200 1 1080169200 8 98 0 0 t \N
|
|
|
1468 |
67 13200 1 1080770400 2 98 0 0 t \N
|
|
|
1469 |
68 13200 1 1080856800 4 98 0 0 t \N
|
|
|
1470 |
69 13200 1 1081116000 4 98 0 0 t \N
|
|
|
1471 |
70 13200 1 1081375200 8 98 0 0 t \N
|
|
|
1472 |
71 13200 1 1081893600 1 98 0 0 t \N
|
|
|
1473 |
72 13200 1 1083708000 4 98 0 0 t \N
|
|
|
1474 |
73 13200 1 1083794400 2 98 0 0 t \N
|
|
|
1475 |
74 13200 1 1084140000 8 98 0 0 t \N
|
|
|
1476 |
75 13200 1 1084226400 2 98 0 0 t \N
|
|
|
1477 |
76 13200 1 1084312800 6 98 0 0 t \N
|
|
|
1478 |
77 13200 1 1084399200 6 98 0 0 t \N
|
|
|
1479 |
78 13200 1 1084485600 4 98 0 0 t \N
|
|
|
1480 |
79 13200 1 1084744800 6 98 0 0 t \N
|
|
|
1481 |
80 13200 1 1084831200 8 98 0 0 t \N
|
|
|
1482 |
81 13200 1 1084917600 8 98 0 0 t \N
|
|
|
1483 |
82 13200 1 1085608800 8 98 0 0 t \N
|
|
|
1484 |
83 13200 1 1085695200 2 98 0 0 t \N
|
|
|
1485 |
85 10388 1 1095026400 8 121 0 3 t \N
|
|
|
1486 |
6 10388 1 1094594400 8 121 0 3 t \N
|
|
|
1487 |
5 10388 1 1094508000 8 121 0 3 t \N
|
|
|
1488 |
86 10388 1 1095112800 8 121 0 3 t \N
|
|
|
1489 |
87 13200 1 1095285600 4 104 0 3 t \N
|
|
|
1490 |
88 13200 2 1219183200 8 112 0 3 t \N
|
|
|
1491 |
90 12661 1 1086645600 8 150 0 1 t \N
|
|
|
1492 |
92 12661 1 1087941600 8 158 0 4 t \N
|
|
|
1493 |
93 12661 1 1088460000 8 153 0 3 t \N
|
|
|
1494 |
95 12661 1 1086732000 8 165 0 6 t \N
|
|
|
1495 |
99 12661 1 1088546400 4 165 0 6 t \N
|
|
|
1496 |
100 12661 2 1086732000 8 165 0 6 t \N
|
|
|
1497 |
101 12661 2 1088546400 4 165 0 6 t \N
|
|
|
1498 |
103 12661 1 1093903200 4 165 0 6 t \N
|
|
|
1499 |
104 12661 2 1093903200 4 165 0 6 t \N
|
|
|
1500 |
105 10388 1 1095890400 8 121 0 3 t \N
|
|
|
1501 |
89 10388 1 1095631200 8 121 0 3 t \N
|
|
|
1502 |
106 90757 1 1096322400 8 128 0 0 t \N
|
|
|
1503 |
107 90757 1 1095976800 4 128 0 0 t \N
|
|
|
1504 |
108 10388 1 1096408800 4 122 0 3 t \N
|
|
|
1505 |
109 13510 2 1086732000 8 10 0 1 t \N
|
|
|
1506 |
110 13510 2 1091138400 4 48 0 6 t \N
|
|
|
1507 |
111 13510 2 1091138400 4 49 0 6 t \N
|
|
|
1508 |
112 90757 1 1096495200 8 128 0 0 t \N
|
|
|
1509 |
113 90757 1 1096408800 8 128 0 0 t \N
|
|
|
1510 |
39 13510 4 1086559200 8 89 1 1 t \N
|
|
|
1511 |
40 13510 4 1086645600 8 89 1 1 t \N
|
|
|
1512 |
115 11230 3 1095026400 8 186 0 3 t \N
|
|
|
1513 |
116 11230 3 1095112800 8 186 0 3 t \N
|
|
|
1514 |
117 11230 3 1095285600 8 186 0 3 t \N
|
|
|
1515 |
120 13510 5 1091138400 4 49 0 6 t \N
|
|
|
1516 |
121 13510 5 1093903200 4 49 0 6 t \N
|
|
|
1517 |
119 13510 5 1088546400 4 49 0 6 t \N
|
|
|
1518 |
124 13510 8 1086645600 8 89 0 1 t \N
|
|
|
1519 |
123 13510 8 1086559200 8 89 0 1 t \N
|
|
|
1520 |
126 13510 8 1088978400 8 91 0 3 t \N
|
|
|
1521 |
127 13510 8 1089064800 8 91 0 3 t \N
|
|
|
1522 |
125 13510 8 1086732000 8 90 0 3 t \N
|
|
|
1523 |
128 13510 8 1092002400 4 94 0 4 t \N
|
|
|
1524 |
149 90757 1 1096840800 8 128 0 0 t \N
|
|
|
1525 |
151 13860 17 1094680800 8 130 0 1 t \N
|
|
|
1526 |
152 13860 17 1094508000 2 196 0 6 t \N
|
|
|
1527 |
153 13860 17 1094767200 8 196 0 6 t \N
|
|
|
1528 |
154 13860 17 1095112800 4 188 0 1 t \N
|
|
|
1529 |
155 13860 17 1095199200 4 188 0 1 t \N
|
|
|
1530 |
156 13860 17 1095372000 4 188 0 1 t \N
|
|
|
1531 |
157 13860 17 1095804000 3 196 0 6 t \N
|
|
|
1532 |
158 13860 17 1095976800 4 188 0 1 t \N
|
|
|
1533 |
159 13860 17 1095976800 4 196 0 6 t \N
|
|
|
1534 |
160 13860 17 1096149600 3 196 0 6 t \N
|
|
|
1535 |
161 13860 17 1096495200 4 188 0 1 t \N
|
|
|
1536 |
84 13860 1 1094767200 4 130 0 1 t \N
|
|
|
1537 |
162 90757 1 1096927200 8 128 0 0 t \N
|
|
|
1538 |
163 10388 1 1097100000 8 177 0 3 t \N
|
|
|
1539 |
165 999999 1 1096927200 8 139 0 3 t \N
|
|
|
1540 |
164 999999 1 1093989600 8 133 0 1 t \N
|
|
|
1541 |
166 999999 1 1094076000 8 133 0 1 t \N
|
|
|
1542 |
167 999999 1 1097013600 4 139 0 3 t \N
|
|
|
1543 |
168 10388 1 1097445600 8 177 0 3 t \N
|
|
|
1544 |
169 10388 1 1097532000 8 177 0 3 t \N
|
|
|
1545 |
171 14060 1 1097704800 8 298 0 1 t \N
|
|
|
1546 |
\.
|
|
|
1547 |
\connect - andreas
|
|
|
1548 |
|
|
|
1549 |
--
|
|
|
1550 |
-- Data for TOC Entry ID 69 (OID 157245)
|
|
|
1551 |
--
|
|
|
1552 |
-- Name: pga_graphs Type: TABLE DATA Owner: andreas
|
|
|
1553 |
--
|
|
|
1554 |
|
|
|
1555 |
|
|
|
1556 |
COPY "pga_graphs" FROM stdin;
|
|
|
1557 |
\.
|
|
|
1558 |
--
|
|
|
1559 |
-- Data for TOC Entry ID 70 (OID 157251)
|
|
|
1560 |
--
|
|
|
1561 |
-- Name: pga_layout Type: TABLE DATA Owner: andreas
|
|
|
1562 |
--
|
|
|
1563 |
|
|
|
1564 |
|
|
|
1565 |
COPY "pga_layout" FROM stdin;
|
|
|
1566 |
key_land 2 kl_num kl_land 150 150
|
|
|
1567 |
key_tmgroup 2 kt_num kt_tm 150 150
|
|
|
1568 |
key_sgf 2 ks_num ks_sgf 150 150
|
|
|
1569 |
key_abt 2 ka_num ka_abt 150 150
|
|
|
1570 |
key_role 2 kr_num kr_role 150 150
|
|
|
1571 |
project 7 pr_num pr_name pr_pl pr_plav pr_sgf {pr_tmgroup} {pr_status} 150 150 150 150 150 150 150
|
|
|
1572 |
key_status 2 ks_num ks_status 150 150
|
|
|
1573 |
plan 4 pl_num pl_lfd pl_prnum pl_status 150 150 150 150
|
|
|
1574 |
counter 5 co_mitarbeiter co_plan co_task co_wdone {co_allocation} 150 150 150 150 150
|
|
|
1575 |
mitarbeiter 11 mi_num mi_vname mi_nname mi_land mi_abt mi_tel mi_mail mi_userid mi_passwd {mi_rstufe} {mi_hacker} 150 150 150 150 150 150 150 150 150 150 150
|
|
|
1576 |
allocmi 9 am_num am_task am_ressource am_hours am_phase am_role am_krnum am_vname am_nname 150 150 150 150 150 150 150 150 150
|
|
|
1577 |
task 17 ta_num ta_plnum ta_id ta_depend ta_deptype ta_name ta_color ta_shape ta_meeting ta_start ta_duration ta_complete ta_fixed_start ta_priority ta_level ta_notiz {ta_phase} 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150 150
|
|
|
1578 |
allocation 8 al_num al_task al_ressource al_hours al_role al_phase al_pstart al_pduration 150 150 150 150 150 150 150 150
|
|
|
1579 |
wdone 10 wd_num wd_prnum wd_minum wd_datum wd_hours wd_task wd_rk {wd_phase} {wd_edit} {wd_periode} 150 150 150 150 150 150 150 150 150 150
|
|
|
1580 |
10 wd_num wd_prnum wd_minum wd_datum wd_hours wd_task wd_rk wd_phase wd_edit wd_periode 150 150 150 150 150 150 150 150 150 150
|
|
|
1581 |
tempidx 3 te_num te_name te_zweck 150 150 150
|
|
|
1582 |
\.
|
|
|
1583 |
--
|
|
|
1584 |
-- Data for TOC Entry ID 71 (OID 157257)
|
|
|
1585 |
--
|
|
|
1586 |
-- Name: pga_images Type: TABLE DATA Owner: andreas
|
|
|
1587 |
--
|
|
|
1588 |
|
|
|
1589 |
|
|
|
1590 |
COPY "pga_images" FROM stdin;
|
|
|
1591 |
\.
|
|
|
1592 |
--
|
|
|
1593 |
-- Data for TOC Entry ID 72 (OID 157263)
|
|
|
1594 |
--
|
|
|
1595 |
-- Name: pga_queries Type: TABLE DATA Owner: andreas
|
|
|
1596 |
--
|
|
|
1597 |
|
|
|
1598 |
|
|
|
1599 |
COPY "pga_queries" FROM stdin;
|
|
|
1600 |
\.
|
|
|
1601 |
--
|
|
|
1602 |
-- Data for TOC Entry ID 73 (OID 157269)
|
|
|
1603 |
--
|
|
|
1604 |
-- Name: pga_reports Type: TABLE DATA Owner: andreas
|
|
|
1605 |
--
|
|
|
1606 |
|
|
|
1607 |
|
|
|
1608 |
COPY "pga_reports" FROM stdin;
|
|
|
1609 |
\.
|
|
|
1610 |
--
|
|
|
1611 |
-- Data for TOC Entry ID 74 (OID 157275)
|
|
|
1612 |
--
|
|
|
1613 |
-- Name: pga_forms Type: TABLE DATA Owner: andreas
|
|
|
1614 |
--
|
|
|
1615 |
|
|
|
1616 |
|
|
|
1617 |
COPY "pga_forms" FROM stdin;
|
|
|
1618 |
\.
|
|
|
1619 |
--
|
|
|
1620 |
-- Data for TOC Entry ID 75 (OID 157281)
|
|
|
1621 |
--
|
|
|
1622 |
-- Name: pga_diagrams Type: TABLE DATA Owner: andreas
|
|
|
1623 |
--
|
|
|
1624 |
|
|
|
1625 |
|
|
|
1626 |
COPY "pga_diagrams" FROM stdin;
|
|
|
1627 |
\.
|
|
|
1628 |
--
|
|
|
1629 |
-- Data for TOC Entry ID 76 (OID 157287)
|
|
|
1630 |
--
|
|
|
1631 |
-- Name: pga_scripts Type: TABLE DATA Owner: andreas
|
|
|
1632 |
--
|
|
|
1633 |
|
|
|
1634 |
|
|
|
1635 |
COPY "pga_scripts" FROM stdin;
|
|
|
1636 |
\.
|
|
|
1637 |
\connect - wwwrun
|
|
|
1638 |
|
|
|
1639 |
--
|
|
|
1640 |
-- Data for TOC Entry ID 77 (OID 157338)
|
|
|
1641 |
--
|
|
|
1642 |
-- Name: key_status Type: TABLE DATA Owner: wwwrun
|
|
|
1643 |
--
|
|
|
1644 |
|
|
|
1645 |
|
|
|
1646 |
COPY "key_status" FROM stdin;
|
|
|
1647 |
2 INI
|
|
|
1648 |
1 PLG
|
|
|
1649 |
3 AKT
|
|
|
1650 |
4 ABG
|
|
|
1651 |
5 ABS
|
|
|
1652 |
6 TMA
|
|
|
1653 |
\.
|
|
|
1654 |
--
|
|
|
1655 |
-- Data for TOC Entry ID 78 (OID 157341)
|
|
|
1656 |
--
|
|
|
1657 |
-- Name: ptemp Type: TABLE DATA Owner: wwwrun
|
|
|
1658 |
--
|
|
|
1659 |
|
|
|
1660 |
|
|
|
1661 |
COPY "ptemp" FROM stdin;
|
|
|
1662 |
\.
|
|
|
1663 |
--
|
|
|
1664 |
-- Data for TOC Entry ID 79 (OID 165403)
|
|
|
1665 |
--
|
|
|
1666 |
-- Name: key_phase Type: TABLE DATA Owner: wwwrun
|
|
|
1667 |
--
|
|
|
1668 |
|
|
|
1669 |
|
|
|
1670 |
COPY "key_phase" FROM stdin;
|
|
|
1671 |
1 Angebot
|
|
|
1672 |
2 Organisationsentwicklung
|
|
|
1673 |
3 Systementwicklung
|
|
|
1674 |
4 Zentrale Rolloutplanung
|
|
|
1675 |
5 Dezentraler Rollout
|
|
|
1676 |
6 Phasenübergreifende Projektaktivitäten
|
|
|
1677 |
|
|
|
1678 |
\.
|
|
|
1679 |
--
|
|
|
1680 |
-- Data for TOC Entry ID 80 (OID 190526)
|
|
|
1681 |
--
|
|
|
1682 |
-- Name: tempidx Type: TABLE DATA Owner: wwwrun
|
|
|
1683 |
--
|
|
|
1684 |
|
|
|
1685 |
|
|
|
1686 |
COPY "tempidx" FROM stdin;
|
|
|
1687 |
\.
|
|
|
1688 |
--
|
|
|
1689 |
-- TOC Entry ID 49 (OID 157155)
|
|
|
1690 |
--
|
|
|
1691 |
-- Name: "idx_mi_name" Type: INDEX Owner: wwwrun
|
|
|
1692 |
--
|
|
|
1693 |
|
|
|
1694 |
CREATE UNIQUE INDEX idx_mi_name ON mitarbeiter USING btree (mi_nname, mi_vname);
|
|
|
1695 |
|
|
|
1696 |
--
|
|
|
1697 |
-- TOC Entry ID 50 (OID 157156)
|
|
|
1698 |
--
|
|
|
1699 |
-- Name: "idx_mi_userid" Type: INDEX Owner: wwwrun
|
|
|
1700 |
--
|
|
|
1701 |
|
|
|
1702 |
CREATE UNIQUE INDEX idx_mi_userid ON mitarbeiter USING btree (mi_userid);
|
|
|
1703 |
|
|
|
1704 |
--
|
|
|
1705 |
-- TOC Entry ID 51 (OID 157178)
|
|
|
1706 |
--
|
|
|
1707 |
-- Name: "idx_project_name" Type: INDEX Owner: wwwrun
|
|
|
1708 |
--
|
|
|
1709 |
|
|
|
1710 |
CREATE UNIQUE INDEX idx_project_name ON project USING btree (pr_name);
|
|
|
1711 |
|
|
|
1712 |
--
|
|
|
1713 |
-- TOC Entry ID 52 (OID 157200)
|
|
|
1714 |
--
|
|
|
1715 |
-- Name: "idx_task_plnum" Type: INDEX Owner: wwwrun
|
|
|
1716 |
--
|
|
|
1717 |
|
|
|
1718 |
CREATE INDEX idx_task_plnum ON task USING btree (ta_plnum);
|
|
|
1719 |
|
|
|
1720 |
--
|
|
|
1721 |
-- TOC Entry ID 53 (OID 157222)
|
|
|
1722 |
--
|
|
|
1723 |
-- Name: "idx_alloc_task" Type: INDEX Owner: wwwrun
|
|
|
1724 |
--
|
|
|
1725 |
|
|
|
1726 |
CREATE INDEX idx_alloc_task ON allocation USING btree (al_task);
|
|
|
1727 |
|
|
|
1728 |
--
|
|
|
1729 |
-- TOC Entry ID 54 (OID 157344)
|
|
|
1730 |
--
|
|
|
1731 |
-- Name: "idx_ptemp_num" Type: INDEX Owner: wwwrun
|
|
|
1732 |
--
|
|
|
1733 |
|
|
|
1734 |
CREATE UNIQUE INDEX idx_ptemp_num ON ptemp USING btree (pt_tnum, pt_lfd);
|
|
|
1735 |
|
|
|
1736 |
--
|
|
|
1737 |
-- TOC Entry ID 55 (OID 165156)
|
|
|
1738 |
--
|
|
|
1739 |
-- Name: "idx_task_numid" Type: INDEX Owner: wwwrun
|
|
|
1740 |
--
|
|
|
1741 |
|
|
|
1742 |
CREATE UNIQUE INDEX idx_task_numid ON task USING btree (ta_plnum, ta_id);
|
|
|
1743 |
|
|
|
1744 |
--
|
|
|
1745 |
-- TOC Entry ID 56 (OID 190533)
|
|
|
1746 |
--
|
|
|
1747 |
-- Name: "idx_tempidx_name" Type: INDEX Owner: wwwrun
|
|
|
1748 |
--
|
|
|
1749 |
|
|
|
1750 |
CREATE UNIQUE INDEX idx_tempidx_name ON tempidx USING btree (te_name);
|
|
|
1751 |
|
|
|
1752 |
--
|
|
|
1753 |
-- TOC Entry ID 89 (OID 157144)
|
|
|
1754 |
--
|
|
|
1755 |
-- Name: "RI_ConstraintTrigger_157143" Type: TRIGGER Owner: wwwrun
|
|
|
1756 |
--
|
|
|
1757 |
|
|
|
1758 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "mitarbeiter" FROM "key_land" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
|
|
|
1759 |
|
|
|
1760 |
--
|
|
|
1761 |
-- TOC Entry ID 83 (OID 157146)
|
|
|
1762 |
--
|
|
|
1763 |
-- Name: "RI_ConstraintTrigger_157145" Type: TRIGGER Owner: wwwrun
|
|
|
1764 |
--
|
|
|
1765 |
|
|
|
1766 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_land" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
|
|
|
1767 |
|
|
|
1768 |
--
|
|
|
1769 |
-- TOC Entry ID 84 (OID 157148)
|
|
|
1770 |
--
|
|
|
1771 |
-- Name: "RI_ConstraintTrigger_157147" Type: TRIGGER Owner: wwwrun
|
|
|
1772 |
--
|
|
|
1773 |
|
|
|
1774 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_land" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mitarbeiter', 'key_land', 'UNSPECIFIED', 'mi_land', 'kl_num');
|
|
|
1775 |
|
|
|
1776 |
--
|
|
|
1777 |
-- TOC Entry ID 90 (OID 157150)
|
|
|
1778 |
--
|
|
|
1779 |
-- Name: "RI_ConstraintTrigger_157149" Type: TRIGGER Owner: wwwrun
|
|
|
1780 |
--
|
|
|
1781 |
|
|
|
1782 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "mitarbeiter" FROM "key_abt" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
|
|
|
1783 |
|
|
|
1784 |
--
|
|
|
1785 |
-- TOC Entry ID 85 (OID 157152)
|
|
|
1786 |
--
|
|
|
1787 |
-- Name: "RI_ConstraintTrigger_157151" Type: TRIGGER Owner: wwwrun
|
|
|
1788 |
--
|
|
|
1789 |
|
|
|
1790 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_abt" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
|
|
|
1791 |
|
|
|
1792 |
--
|
|
|
1793 |
-- TOC Entry ID 86 (OID 157154)
|
|
|
1794 |
--
|
|
|
1795 |
-- Name: "RI_ConstraintTrigger_157153" Type: TRIGGER Owner: wwwrun
|
|
|
1796 |
--
|
|
|
1797 |
|
|
|
1798 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_abt" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'mitarbeiter', 'key_abt', 'UNSPECIFIED', 'mi_abt', 'ka_num');
|
|
|
1799 |
|
|
|
1800 |
--
|
|
|
1801 |
-- TOC Entry ID 99 (OID 157161)
|
|
|
1802 |
--
|
|
|
1803 |
-- Name: "RI_ConstraintTrigger_157160" Type: TRIGGER Owner: wwwrun
|
|
|
1804 |
--
|
|
|
1805 |
|
|
|
1806 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
|
|
|
1807 |
|
|
|
1808 |
--
|
|
|
1809 |
-- TOC Entry ID 91 (OID 157163)
|
|
|
1810 |
--
|
|
|
1811 |
-- Name: "RI_ConstraintTrigger_157162" Type: TRIGGER Owner: wwwrun
|
|
|
1812 |
--
|
|
|
1813 |
|
|
|
1814 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
|
|
|
1815 |
|
|
|
1816 |
--
|
|
|
1817 |
-- TOC Entry ID 92 (OID 157165)
|
|
|
1818 |
--
|
|
|
1819 |
-- Name: "RI_ConstraintTrigger_157164" Type: TRIGGER Owner: wwwrun
|
|
|
1820 |
--
|
|
|
1821 |
|
|
|
1822 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_pl', 'mi_num');
|
|
|
1823 |
|
|
|
1824 |
--
|
|
|
1825 |
-- TOC Entry ID 100 (OID 157167)
|
|
|
1826 |
--
|
|
|
1827 |
-- Name: "RI_ConstraintTrigger_157166" Type: TRIGGER Owner: wwwrun
|
|
|
1828 |
--
|
|
|
1829 |
|
|
|
1830 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
|
|
|
1831 |
|
|
|
1832 |
--
|
|
|
1833 |
-- TOC Entry ID 93 (OID 157169)
|
|
|
1834 |
--
|
|
|
1835 |
-- Name: "RI_ConstraintTrigger_157168" Type: TRIGGER Owner: wwwrun
|
|
|
1836 |
--
|
|
|
1837 |
|
|
|
1838 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
|
|
|
1839 |
|
|
|
1840 |
--
|
|
|
1841 |
-- TOC Entry ID 94 (OID 157171)
|
|
|
1842 |
--
|
|
|
1843 |
-- Name: "RI_ConstraintTrigger_157170" Type: TRIGGER Owner: wwwrun
|
|
|
1844 |
--
|
|
|
1845 |
|
|
|
1846 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'mitarbeiter', 'UNSPECIFIED', 'pr_plav', 'mi_num');
|
|
|
1847 |
|
|
|
1848 |
--
|
|
|
1849 |
-- TOC Entry ID 101 (OID 157173)
|
|
|
1850 |
--
|
|
|
1851 |
-- Name: "RI_ConstraintTrigger_157172" Type: TRIGGER Owner: wwwrun
|
|
|
1852 |
--
|
|
|
1853 |
|
|
|
1854 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "project" FROM "key_sgf" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
|
|
|
1855 |
|
|
|
1856 |
--
|
|
|
1857 |
-- TOC Entry ID 87 (OID 157175)
|
|
|
1858 |
--
|
|
|
1859 |
-- Name: "RI_ConstraintTrigger_157174" Type: TRIGGER Owner: wwwrun
|
|
|
1860 |
--
|
|
|
1861 |
|
|
|
1862 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_sgf" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
|
|
|
1863 |
|
|
|
1864 |
--
|
|
|
1865 |
-- TOC Entry ID 88 (OID 157177)
|
|
|
1866 |
--
|
|
|
1867 |
-- Name: "RI_ConstraintTrigger_157176" Type: TRIGGER Owner: wwwrun
|
|
|
1868 |
--
|
|
|
1869 |
|
|
|
1870 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_sgf" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'project', 'key_sgf', 'UNSPECIFIED', 'pr_sgf', 'ks_num');
|
|
|
1871 |
|
|
|
1872 |
--
|
|
|
1873 |
-- TOC Entry ID 106 (OID 157183)
|
|
|
1874 |
--
|
|
|
1875 |
-- Name: "RI_ConstraintTrigger_157182" Type: TRIGGER Owner: wwwrun
|
|
|
1876 |
--
|
|
|
1877 |
|
|
|
1878 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "plan" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
|
|
|
1879 |
|
|
|
1880 |
--
|
|
|
1881 |
-- TOC Entry ID 102 (OID 157185)
|
|
|
1882 |
--
|
|
|
1883 |
-- Name: "RI_ConstraintTrigger_157184" Type: TRIGGER Owner: wwwrun
|
|
|
1884 |
--
|
|
|
1885 |
|
|
|
1886 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "project" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
|
|
|
1887 |
|
|
|
1888 |
--
|
|
|
1889 |
-- TOC Entry ID 103 (OID 157187)
|
|
|
1890 |
--
|
|
|
1891 |
-- Name: "RI_ConstraintTrigger_157186" Type: TRIGGER Owner: wwwrun
|
|
|
1892 |
--
|
|
|
1893 |
|
|
|
1894 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "project" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'plan', 'project', 'UNSPECIFIED', 'pl_prnum', 'pr_num');
|
|
|
1895 |
|
|
|
1896 |
--
|
|
|
1897 |
-- TOC Entry ID 109 (OID 157195)
|
|
|
1898 |
--
|
|
|
1899 |
-- Name: "RI_ConstraintTrigger_157194" Type: TRIGGER Owner: wwwrun
|
|
|
1900 |
--
|
|
|
1901 |
|
|
|
1902 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "task" FROM "plan" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
|
|
|
1903 |
|
|
|
1904 |
--
|
|
|
1905 |
-- TOC Entry ID 107 (OID 157197)
|
|
|
1906 |
--
|
|
|
1907 |
-- Name: "RI_ConstraintTrigger_157196" Type: TRIGGER Owner: wwwrun
|
|
|
1908 |
--
|
|
|
1909 |
|
|
|
1910 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "plan" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
|
|
|
1911 |
|
|
|
1912 |
--
|
|
|
1913 |
-- TOC Entry ID 108 (OID 157199)
|
|
|
1914 |
--
|
|
|
1915 |
-- Name: "RI_ConstraintTrigger_157198" Type: TRIGGER Owner: wwwrun
|
|
|
1916 |
--
|
|
|
1917 |
|
|
|
1918 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "plan" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'task', 'plan', 'UNSPECIFIED', 'ta_plnum', 'pl_num');
|
|
|
1919 |
|
|
|
1920 |
--
|
|
|
1921 |
-- TOC Entry ID 114 (OID 157205)
|
|
|
1922 |
--
|
|
|
1923 |
-- Name: "RI_ConstraintTrigger_157204" Type: TRIGGER Owner: wwwrun
|
|
|
1924 |
--
|
|
|
1925 |
|
|
|
1926 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
|
|
|
1927 |
|
|
|
1928 |
--
|
|
|
1929 |
-- TOC Entry ID 110 (OID 157207)
|
|
|
1930 |
--
|
|
|
1931 |
-- Name: "RI_ConstraintTrigger_157206" Type: TRIGGER Owner: wwwrun
|
|
|
1932 |
--
|
|
|
1933 |
|
|
|
1934 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "task" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
|
|
|
1935 |
|
|
|
1936 |
--
|
|
|
1937 |
-- TOC Entry ID 111 (OID 157209)
|
|
|
1938 |
--
|
|
|
1939 |
-- Name: "RI_ConstraintTrigger_157208" Type: TRIGGER Owner: wwwrun
|
|
|
1940 |
--
|
|
|
1941 |
|
|
|
1942 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "task" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'task', 'UNSPECIFIED', 'al_task', 'ta_num');
|
|
|
1943 |
|
|
|
1944 |
--
|
|
|
1945 |
-- TOC Entry ID 115 (OID 157211)
|
|
|
1946 |
--
|
|
|
1947 |
-- Name: "RI_ConstraintTrigger_157210" Type: TRIGGER Owner: wwwrun
|
|
|
1948 |
--
|
|
|
1949 |
|
|
|
1950 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
|
|
|
1951 |
|
|
|
1952 |
--
|
|
|
1953 |
-- TOC Entry ID 95 (OID 157213)
|
|
|
1954 |
--
|
|
|
1955 |
-- Name: "RI_ConstraintTrigger_157212" Type: TRIGGER Owner: wwwrun
|
|
|
1956 |
--
|
|
|
1957 |
|
|
|
1958 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
|
|
|
1959 |
|
|
|
1960 |
--
|
|
|
1961 |
-- TOC Entry ID 96 (OID 157215)
|
|
|
1962 |
--
|
|
|
1963 |
-- Name: "RI_ConstraintTrigger_157214" Type: TRIGGER Owner: wwwrun
|
|
|
1964 |
--
|
|
|
1965 |
|
|
|
1966 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'mitarbeiter', 'UNSPECIFIED', 'al_ressource', 'mi_num');
|
|
|
1967 |
|
|
|
1968 |
--
|
|
|
1969 |
-- TOC Entry ID 116 (OID 157217)
|
|
|
1970 |
--
|
|
|
1971 |
-- Name: "RI_ConstraintTrigger_157216" Type: TRIGGER Owner: wwwrun
|
|
|
1972 |
--
|
|
|
1973 |
|
|
|
1974 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "allocation" FROM "key_role" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
|
|
|
1975 |
|
|
|
1976 |
--
|
|
|
1977 |
-- TOC Entry ID 81 (OID 157219)
|
|
|
1978 |
--
|
|
|
1979 |
-- Name: "RI_ConstraintTrigger_157218" Type: TRIGGER Owner: wwwrun
|
|
|
1980 |
--
|
|
|
1981 |
|
|
|
1982 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "key_role" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
|
|
|
1983 |
|
|
|
1984 |
--
|
|
|
1985 |
-- TOC Entry ID 82 (OID 157221)
|
|
|
1986 |
--
|
|
|
1987 |
-- Name: "RI_ConstraintTrigger_157220" Type: TRIGGER Owner: wwwrun
|
|
|
1988 |
--
|
|
|
1989 |
|
|
|
1990 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "key_role" FROM "allocation" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'allocation', 'key_role', 'UNSPECIFIED', 'al_role', 'kr_num');
|
|
|
1991 |
|
|
|
1992 |
--
|
|
|
1993 |
-- TOC Entry ID 117 (OID 157227)
|
|
|
1994 |
--
|
|
|
1995 |
-- Name: "RI_ConstraintTrigger_157226" Type: TRIGGER Owner: wwwrun
|
|
|
1996 |
--
|
|
|
1997 |
|
|
|
1998 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "project" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
|
|
|
1999 |
|
|
|
2000 |
--
|
|
|
2001 |
-- TOC Entry ID 104 (OID 157229)
|
|
|
2002 |
--
|
|
|
2003 |
-- Name: "RI_ConstraintTrigger_157228" Type: TRIGGER Owner: wwwrun
|
|
|
2004 |
--
|
|
|
2005 |
|
|
|
2006 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "project" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
|
|
|
2007 |
|
|
|
2008 |
--
|
|
|
2009 |
-- TOC Entry ID 105 (OID 157231)
|
|
|
2010 |
--
|
|
|
2011 |
-- Name: "RI_ConstraintTrigger_157230" Type: TRIGGER Owner: wwwrun
|
|
|
2012 |
--
|
|
|
2013 |
|
|
|
2014 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "project" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'project', 'UNSPECIFIED', 'wd_prnum', 'pr_num');
|
|
|
2015 |
|
|
|
2016 |
--
|
|
|
2017 |
-- TOC Entry ID 118 (OID 157233)
|
|
|
2018 |
--
|
|
|
2019 |
-- Name: "RI_ConstraintTrigger_157232" Type: TRIGGER Owner: wwwrun
|
|
|
2020 |
--
|
|
|
2021 |
|
|
|
2022 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "mitarbeiter" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
|
|
|
2023 |
|
|
|
2024 |
--
|
|
|
2025 |
-- TOC Entry ID 97 (OID 157235)
|
|
|
2026 |
--
|
|
|
2027 |
-- Name: "RI_ConstraintTrigger_157234" Type: TRIGGER Owner: wwwrun
|
|
|
2028 |
--
|
|
|
2029 |
|
|
|
2030 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "mitarbeiter" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
|
|
|
2031 |
|
|
|
2032 |
--
|
|
|
2033 |
-- TOC Entry ID 98 (OID 157237)
|
|
|
2034 |
--
|
|
|
2035 |
-- Name: "RI_ConstraintTrigger_157236" Type: TRIGGER Owner: wwwrun
|
|
|
2036 |
--
|
|
|
2037 |
|
|
|
2038 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "mitarbeiter" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'mitarbeiter', 'UNSPECIFIED', 'wd_minum', 'mi_num');
|
|
|
2039 |
|
|
|
2040 |
--
|
|
|
2041 |
-- TOC Entry ID 119 (OID 157239)
|
|
|
2042 |
--
|
|
|
2043 |
-- Name: "RI_ConstraintTrigger_157238" Type: TRIGGER Owner: wwwrun
|
|
|
2044 |
--
|
|
|
2045 |
|
|
|
2046 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "wdone" FROM "task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');
|
|
|
2047 |
|
|
|
2048 |
--
|
|
|
2049 |
-- TOC Entry ID 112 (OID 157241)
|
|
|
2050 |
--
|
|
|
2051 |
-- Name: "RI_ConstraintTrigger_157240" Type: TRIGGER Owner: wwwrun
|
|
|
2052 |
--
|
|
|
2053 |
|
|
|
2054 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER DELETE ON "task" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');
|
|
|
2055 |
|
|
|
2056 |
--
|
|
|
2057 |
-- TOC Entry ID 113 (OID 157243)
|
|
|
2058 |
--
|
|
|
2059 |
-- Name: "RI_ConstraintTrigger_157242" Type: TRIGGER Owner: wwwrun
|
|
|
2060 |
--
|
|
|
2061 |
|
|
|
2062 |
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "task" FROM "wdone" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'wdone', 'task', 'UNSPECIFIED', 'wd_task', 'ta_num');
|
|
|
2063 |
|