2 -- Selected TOC Entries:
6 -- TOC Entry ID 2 (OID 28714)
8 -- Name: media_id_seq Type: SEQUENCE Owner: postgres
11 CREATE SEQUENCE "media_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
14 -- TOC Entry ID 3 (OID 28733)
16 -- Name: media_folder_id_seq Type: SEQUENCE Owner: postgres
19 CREATE SEQUENCE "media_folder_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
22 -- TOC Entry ID 4 (OID 28752)
24 -- Name: creator_id_seq Type: SEQUENCE Owner: postgres
27 CREATE SEQUENCE "creator_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
30 -- TOC Entry ID 5 (OID 28771)
32 -- Name: feature_id_seq Type: SEQUENCE Owner: postgres
35 CREATE SEQUENCE "feature_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
38 -- TOC Entry ID 6 (OID 28790)
40 -- Name: topic_id_seq Type: SEQUENCE Owner: postgres
43 CREATE SEQUENCE "topic_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
46 -- TOC Entry ID 7 (OID 28809)
48 -- Name: webdb_users_id_seq Type: SEQUENCE Owner: postgres
51 CREATE SEQUENCE "webdb_users_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
54 -- TOC Entry ID 8 (OID 28828)
56 -- Name: comment_id_seq Type: SEQUENCE Owner: postgres
59 CREATE SEQUENCE "comment_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
62 -- TOC Entry ID 9 (OID 28847)
64 -- Name: breaking_id_seq Type: SEQUENCE Owner: postgres
67 CREATE SEQUENCE "breaking_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
70 -- TOC Entry ID 10 (OID 28866)
72 -- Name: messages_id_seq Type: SEQUENCE Owner: postgres
75 CREATE SEQUENCE "messages_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
78 -- TOC Entry ID 10 (OID 28866)
80 -- Name: media_type_id_seq Type: SEQUENCE Owner: postgres
83 CREATE SEQUENCE "media_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
86 -- TOC Entry ID 12 (OID 28885)
88 -- Name: media_folder Type: TABLE Owner: postgres
91 CREATE TABLE "media_folder" (
92 "id" integer DEFAULT nextval('media_folder_id_seq'::text) NOT NULL,
93 "name" character varying(255) NOT NULL,
94 "date" character(8) NOT NULL,
95 "place" character varying(80),
98 "webdb_create" timestamp with time zone NOT NULL,
99 "webdb_lastchange" timestamp with time zone
103 -- TOC Entry ID 13 (OID 28918)
105 -- Name: media_type Type: TABLE Owner: postgres
108 CREATE TABLE "media_type" (
109 "id" integer DEFAULT nextval('media_type_id_seq'::text) NOT NULL,
110 "name" character varying(80) NOT NULL,
111 "mime_type" character varying(40) NOT NULL,
112 "classname" character varying(80) NOT NULL,
113 "tablename" character varying(80) NOT NULL,
114 "dcname" character varying(20)
118 -- TOC Entry ID 14 (OID 28932)
120 -- Name: img_format Type: TABLE Owner: postgres
123 CREATE TABLE "img_format" (
124 "id" smallint NOT NULL,
125 "name" character varying(20) NOT NULL,
126 "extension" character varying(10) NOT NULL,
127 "mimetype" character varying(40) NOT NULL,
128 "commment" character varying(255)
132 -- TOC Entry ID 15 (OID 28946)
134 -- Name: img_layout Type: TABLE Owner: postgres
137 CREATE TABLE "img_layout" (
138 "id" smallint NOT NULL,
139 "name" character varying(20) NOT NULL
143 -- TOC Entry ID 16 (OID 28957)
145 -- Name: img_type Type: TABLE Owner: postgres
148 CREATE TABLE "img_type" (
149 "id" smallint NOT NULL,
150 "name" character varying(30) NOT NULL
154 -- TOC Entry ID 17 (OID 28968)
156 -- Name: img_color Type: TABLE Owner: postgres
159 CREATE TABLE "img_color" (
160 "id" smallint NOT NULL,
161 "name" character varying(30) NOT NULL
165 -- TOC Entry ID 18 (OID 28979)
167 -- Name: language Type: TABLE Owner: postgres
170 CREATE TABLE "language" (
171 "id" integer NOT NULL,
172 "name" character varying(40) NOT NULL,
173 "code" character varying(2) NOT NULL,
174 Constraint "language_pkey" Primary Key ("id")
178 -- TOC Entry ID 19 (OID 28994)
180 -- Name: rights Type: TABLE Owner: postgres
183 CREATE TABLE "rights" (
184 "id" integer NOT NULL,
185 "name" character varying(80) NOT NULL,
187 Constraint "rights_pkey" Primary Key ("id")
191 -- TOC Entry ID 20 (OID 29024)
193 -- Name: creator Type: TABLE Owner: postgres
196 CREATE TABLE "creator" (
197 "id" integer DEFAULT nextval('creator_id_seq'::text) NOT NULL,
198 "name" character varying(80) NOT NULL,
199 "main_url" character varying(255),
200 "email" character varying(80),
201 "address" character varying(80),
202 "phone" character varying(20),
203 Constraint "creator_pkey" Primary Key ("id")
207 -- TOC Entry ID 21 (OID 29043)
209 -- Name: feature Type: TABLE Owner: postgres
212 CREATE TABLE "feature" (
213 "id" integer DEFAULT nextval('feature_id_seq'::text) NOT NULL,
214 "title" character varying(80) NOT NULL,
216 "filename" character varying(20) NOT NULL,
217 "main_url" character varying(255),
218 "is_published" boolean DEFAULT '0' NOT NULL,
219 Constraint "feature_pkey" Primary Key ("id")
223 -- TOC Entry ID 22 (OID 29078)
225 -- Name: webdb_users Type: TABLE Owner: postgres
228 CREATE TABLE "webdb_users" (
229 "id" integer DEFAULT nextval('webdb_users_id_seq'::text) NOT NULL,
230 "login" character varying(16) NOT NULL,
231 "password" character varying(16) NOT NULL,
232 "is_admin" boolean DEFAULT '0' NOT NULL,
233 Constraint "webdb_users_pkey" Primary Key ("id")
237 -- TOC Entry ID 23 (OID 29096)
239 -- Name: content_x_topic Type: TABLE Owner: postgres
242 CREATE TABLE "content_x_topic" (
243 "content_id" integer NOT NULL,
244 "topic_id" integer NOT NULL
248 -- TOC Entry ID 24 (OID 29107)
250 -- Name: article_type Type: TABLE Owner: postgres
253 CREATE TABLE "article_type" (
254 "id" integer NOT NULL,
255 "name" character varying(20) NOT NULL
259 -- TOC Entry ID 25 (OID 29118)
261 -- Name: topic Type: TABLE Owner: postgres
264 CREATE TABLE "topic" (
265 "id" integer DEFAULT nextval('topic_id_seq'::text) NOT NULL,
266 "parent_id" integer DEFAULT '0' NOT NULL,
267 "title" character varying(80) NOT NULL,
269 "filename" character varying(20) NOT NULL,
270 "main_url" character varying(255),
271 "archiv_url" character varying(255),
272 Constraint "topic_pkey" Primary Key ("id")
276 -- TOC Entry ID 26 (OID 29154)
278 -- Name: comment Type: TABLE Owner: postgres
281 CREATE TABLE "comment" (
282 "id" integer DEFAULT nextval('comment_id_seq'::text) NOT NULL,
283 "title" character varying(80) NOT NULL,
284 "creator" character varying(80) NOT NULL,
285 "description" text NOT NULL,
286 "main_url" character varying(255),
287 "email" character varying(80),
288 "address" character varying(80),
289 "phone" character varying(20),
290 "webdb_create" timestamp with time zone NOT NULL,
291 "is_published" boolean DEFAULT '1' NOT NULL,
292 "to_language" integer DEFAULT '0' NOT NULL,
293 "to_media" integer NOT NULL,
294 "to_comment_status" smallint,
296 Constraint "comment_pkey" Primary Key ("id")
300 -- TOC Entry ID 27 (OID 29196)
302 -- Name: media Type: TABLE Owner: postgres
305 CREATE TABLE "media" (
306 "id" integer DEFAULT nextval('media_id_seq'::text) NOT NULL,
307 "title" character varying(80) NOT NULL,
308 "subtitle" character varying(30),
309 "edittitle" character varying(30),
310 "date" character(8) NOT NULL,
311 "place" character varying(80),
312 "creator" character varying(80),
313 "creator_main_url" character varying(255),
314 "creator_email" character varying(80),
315 "creator_address" character varying(80),
316 "creator_phone" character varying(20),
320 "source" character varying(255),
321 "publish_date" timestamp with time zone,
322 "publish_server" character varying(255),
323 "publish_path" character varying(255),
324 "is_published" boolean DEFAULT '0' NOT NULL,
325 "to_feature" integer DEFAULT '0' NOT NULL,
326 "to_media_folder" integer DEFAULT '0' NOT NULL,
327 "to_media_type" smallint DEFAULT '0' NOT NULL,
328 "to_creator" integer DEFAULT '0' NOT NULL,
329 "to_publisher" integer NOT NULL,
330 "to_language" integer DEFAULT '0',
331 "to_rights" integer DEFAULT '0',
332 "webdb_create" timestamp with time zone NOT NULL,
333 "webdb_lastchange" timestamp with time zone,
338 -- TOC Entry ID 28 (OID 29257)
340 -- Name: images Type: TABLE Owner: postgres
343 CREATE TABLE "images" (
346 "icon_path" character varying(255),
347 "icon_is_produced" boolean DEFAULT '0' NOT NULL,
348 "year" character varying(40),
349 "img_width" smallint,
350 "img_height" smallint,
351 "to_img_format" smallint DEFAULT '0' NOT NULL,
352 "to_img_layout" smallint DEFAULT '0' NOT NULL,
353 "to_img_type" smallint DEFAULT '0' NOT NULL,
354 "to_img_color" smallint DEFAULT '0' NOT NULL,
355 "icon_width" smallint,
356 "icon_height" smallint
361 -- TOC Entry ID 29 (OID 29338)
363 -- Name: content Type: TABLE Owner: postgres
366 CREATE TABLE "content" (
368 "link_url" character varying(255),
369 "date_from" character varying(8),
370 "date_to" character varying(8),
371 "date_name" character varying(255),
372 "is_html" boolean DEFAULT '0' NOT NULL,
373 "is_produced" boolean DEFAULT '0' NOT NULL,
374 "is_stored" boolean DEFAULT '0' NOT NULL,
375 "is_mail_sent" boolean DEFAULT '1' NOT NULL,
376 "is_digest_sent" boolean DEFAULT '1' NOT NULL,
377 "to_article_type" smallint DEFAULT '0' NOT NULL,
383 -- TOC Entry ID 30 (OID 29418)
385 -- Name: breaking Type: TABLE Owner: postgres
388 CREATE TABLE "breaking" (
389 "id" integer DEFAULT nextval('breaking_id_seq'::text) NOT NULL,
390 "text" character varying(255) NOT NULL,
391 "webdb_create" timestamp with time zone NOT NULL
395 -- TOC Entry ID 31 (OID 29431)
397 -- Name: messages Type: TABLE Owner: postgres
400 CREATE TABLE "messages" (
401 "id" integer DEFAULT nextval('messages_id_seq'::text) NOT NULL,
402 "title" character varying(30),
403 "description" character varying(255) NOT NULL,
404 "creator" character varying(30) NOT NULL,
405 "webdb_create" timestamp with time zone NOT NULL
409 -- TOC Entry ID 32 (OID 29446)
411 -- Name: uploaded_media Type: TABLE Owner: postgres
414 CREATE TABLE "uploaded_media" (
416 ) INHERITS ("media");
419 -- TOC Entry ID 33 (OID 30026)
421 -- Name: comment_status Type: TABLE Owner: postgres
424 CREATE TABLE "comment_status" (
425 "id" smallint NOT NULL,
426 "name" character varying(40) NOT NULL
430 -- TOC Entry ID 34 (OID 30064)
432 -- Name: content_x_media Type: TABLE Owner: postgres
435 CREATE TABLE "content_x_media" (
436 "content_id" integer,
441 -- TOC Entry ID 11 (OID 32812)
443 -- Name: links_imcs_id_seq Type: SEQUENCE Owner: postgres
446 CREATE SEQUENCE "links_imcs_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
449 -- TOC Entry ID 35 (OID 32831)
451 -- Name: links_imcs Type: TABLE Owner: postgres
454 CREATE TABLE "links_imcs" (
455 "id" integer DEFAULT nextval('links_imcs_id_seq'::text) NOT NULL,
456 "to_parent_id" integer,
457 "title" character varying(80) NOT NULL,
458 "url" character varying(255) NOT NULL,
459 "sortpriority" integer DEFAULT '1',
460 "to_language" integer DEFAULT '0' NOT NULL,
461 Constraint "links_imcs_pkey" Primary Key ("id")
465 -- TOC Entry ID 40 (OID 29078)
467 -- Name: "idx_webdb_user_log_pas_is_admin" Type: INDEX Owner: postgres
470 CREATE INDEX "idx_webdb_user_log_pas_is_admin" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops", "is_admin" "bool_ops" );
473 -- TOC Entry ID 44 (OID 29078)
475 -- Name: "idx_webdb_user_log_pas" Type: INDEX Owner: postgres
478 CREATE INDEX "idx_webdb_user_log_pas" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops" );
481 -- TOC Entry ID 43 (OID 29096)
483 -- Name: "idx_content" Type: INDEX Owner: postgres
486 CREATE UNIQUE INDEX "idx_content" on "content_x_topic" using btree ( "content_id" "int4_ops", "topic_id" "int4_ops" );
489 -- TOC Entry ID 45 (OID 29096)
491 -- Name: "idx_topic" Type: INDEX Owner: postgres
494 CREATE UNIQUE INDEX "idx_topic" on "content_x_topic" using btree ( "topic_id" "int4_ops", "content_id" "int4_ops" );
497 -- TOC Entry ID 46 (OID 29118)
499 -- Name: "idx_topic_title" Type: INDEX Owner: postgres
502 CREATE INDEX "idx_topic_title" on "topic" using btree ( "title" "varchar_ops" );
505 -- TOC Entry ID 51 (OID 29118)
507 -- Name: "idx_topic_id" Type: INDEX Owner: postgres
510 CREATE UNIQUE INDEX "idx_topic_id" on "topic" using btree ( "id" "int4_ops" );
513 -- TOC Entry ID 36 (OID 29154)
515 -- Name: "idx_comment_to_media" Type: INDEX Owner: postgres
518 CREATE INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
521 -- TOC Entry ID 47 (OID 29257)
523 -- Name: "idx_images_is_published__icon_i" Type: INDEX Owner: postgres
526 CREATE INDEX "idx_images_is_published__icon_i" on "images" using btree ( "is_published" "bool_ops", "icon_is_produced" "bool_ops" );
529 -- TOC Entry ID 49 (OID 29257)
531 -- Name: "idx_images_id" Type: INDEX Owner: postgres
534 CREATE UNIQUE INDEX "idx_images_id" on "images" using btree ( "id" "int4_ops" );
537 -- TOC Entry ID 37 (OID 29338)
539 -- Name: "idx_content_to_article_type" Type: INDEX Owner: postgres
542 CREATE INDEX "idx_content_to_article_type" on "content" using btree ( "to_article_type" "int2_ops" );
545 -- TOC Entry ID 38 (OID 29338)
547 -- Name: "idx_content_is_produced" Type: INDEX Owner: postgres
550 CREATE INDEX "idx_content_is_produced" on "content" using btree ( "is_produced" "bool_ops" );
553 -- TOC Entry ID 39 (OID 29338)
555 -- Name: "idx_content_is_published__to_ar" Type: INDEX Owner: postgres
558 CREATE INDEX "idx_content_is_published__to_ar" on "content" using btree ( "is_published" "bool_ops", "to_article_type" "int2_ops" );
561 -- TOC Entry ID 41 (OID 29338)
563 -- Name: "idx_content_is_stored" Type: INDEX Owner: postgres
566 CREATE INDEX "idx_content_is_stored" on "content" using btree ( "is_stored" "bool_ops" );
569 -- TOC Entry ID 42 (OID 29338)
571 -- Name: "idx_content_is_published__id" Type: INDEX Owner: postgres
574 CREATE INDEX "idx_content_is_published__id" on "content" using btree ( "is_published" "bool_ops", "id" "int4_ops" );
577 -- TOC Entry ID 48 (OID 29338)
579 -- Name: "idx_content_is_pub__to_art__to_" Type: INDEX Owner: postgres
582 CREATE INDEX "idx_content_is_pub__to_art__to_" on "content" using btree ( "is_published" "bool_ops", "to_article_type" "int2_ops", "id" "int4_ops" );
585 -- TOC Entry ID 50 (OID 29338)
587 -- Name: "idx_content_id" Type: INDEX Owner: postgres
590 CREATE UNIQUE INDEX "idx_content_id" on "content" using btree ( "id" "int4_ops" );
593 -- TOC Entry ID 52 (OID 30064)
595 -- Name: "idx_content_media" Type: INDEX Owner: postgres
598 CREATE UNIQUE INDEX "idx_content_media" on "content_x_media" using btree ( "content_id" "int4_ops", "media_id" "int4_ops" );
601 -- TOC Entry ID 53 (OID 30064)
603 -- Name: "idx_media_content" Type: INDEX Owner: postgres
606 CREATE UNIQUE INDEX "idx_media_content" on "content_x_media" using btree ( "media_id" "int4_ops", "content_id" "int4_ops" );
609 -- Selected TOC Entries:
612 -- Data for TOC Entry ID 2 (OID 28909)
614 -- Name: media_type Type: TABLE DATA Owner: postgres
620 UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type';
622 COPY "media_type" FROM stdin;
623 2 unknown application/octet-stream -- UploadedMedia \N
624 3 gif image/gif ImagesGif Images \N
627 UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';
630 -- TOC Entry ID 1 (OID 28890)
632 -- Name: media_type_id_seq Type: SEQUENCE SET Owner:
635 SELECT setval ('"media_type_id_seq"', 1, 't');