2 -- Selected TOC Entries:
6 -- TOC Entry ID 2 (OID 19796)
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 19815)
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 19834)
24 -- Name: feature_id_seq Type: SEQUENCE Owner: postgres
27 CREATE SEQUENCE "feature_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
30 -- TOC Entry ID 5 (OID 19853)
32 -- Name: topic_id_seq Type: SEQUENCE Owner: postgres
35 CREATE SEQUENCE "topic_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
38 -- TOC Entry ID 6 (OID 19872)
40 -- Name: webdb_users_id_seq Type: SEQUENCE Owner: postgres
43 CREATE SEQUENCE "webdb_users_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
46 -- TOC Entry ID 7 (OID 19891)
48 -- Name: comment_id_seq Type: SEQUENCE Owner: postgres
51 CREATE SEQUENCE "comment_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
54 -- TOC Entry ID 8 (OID 19910)
56 -- Name: breaking_id_seq Type: SEQUENCE Owner: postgres
59 CREATE SEQUENCE "breaking_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
62 -- TOC Entry ID 9 (OID 19929)
64 -- Name: messages_id_seq Type: SEQUENCE Owner: postgres
67 CREATE SEQUENCE "messages_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
70 -- TOC Entry ID 10 (OID 19948)
72 -- Name: media_type_id_seq Type: SEQUENCE Owner: postgres
75 CREATE SEQUENCE "media_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
78 -- TOC Entry ID 12 (OID 19967)
80 -- Name: media_folder Type: TABLE Owner: postgres
83 CREATE TABLE "media_folder" (
84 "id" integer DEFAULT nextval('media_folder_id_seq'::text) NOT NULL,
85 "name" character varying(255) NOT NULL,
86 "date" character(8) NOT NULL,
87 "place" character varying(80),
90 "webdb_create" timestamp with time zone NOT NULL,
91 "webdb_lastchange" timestamp with time zone
95 -- TOC Entry ID 13 (OID 20000)
97 -- Name: media_type Type: TABLE Owner: postgres
100 CREATE TABLE "media_type" (
101 "id" integer DEFAULT nextval('media_type_id_seq'::text) NOT NULL,
102 "name" character varying(80) NOT NULL,
103 "mime_type" character varying(40) NOT NULL,
104 "classname" character varying(80) NOT NULL,
105 "tablename" character varying(80) NOT NULL,
106 "dcname" character varying(20)
110 -- TOC Entry ID 14 (OID 20016)
112 -- Name: img_format Type: TABLE Owner: postgres
115 CREATE TABLE "img_format" (
116 "id" smallint NOT NULL,
117 "name" character varying(20) NOT NULL,
118 "extension" character varying(10) NOT NULL,
119 "mimetype" character varying(40) NOT NULL,
120 "commment" character varying(255)
124 -- TOC Entry ID 15 (OID 20030)
126 -- Name: img_layout Type: TABLE Owner: postgres
129 CREATE TABLE "img_layout" (
130 "id" smallint NOT NULL,
131 "name" character varying(20) NOT NULL
135 -- TOC Entry ID 16 (OID 20041)
137 -- Name: img_type Type: TABLE Owner: postgres
140 CREATE TABLE "img_type" (
141 "id" smallint NOT NULL,
142 "name" character varying(30) NOT NULL
146 -- TOC Entry ID 17 (OID 20052)
148 -- Name: img_color Type: TABLE Owner: postgres
151 CREATE TABLE "img_color" (
152 "id" smallint NOT NULL,
153 "name" character varying(30) NOT NULL
157 -- TOC Entry ID 18 (OID 20063)
159 -- Name: language Type: TABLE Owner: postgres
162 CREATE TABLE "language" (
163 "id" integer NOT NULL,
164 "name" character varying(40) NOT NULL,
165 "code" character varying(2) NOT NULL,
166 Constraint "language_pkey" Primary Key ("id")
170 -- TOC Entry ID 19 (OID 20078)
172 -- Name: rights Type: TABLE Owner: postgres
175 CREATE TABLE "rights" (
176 "id" integer NOT NULL,
177 "name" character varying(80) NOT NULL,
179 Constraint "rights_pkey" Primary Key ("id")
183 -- TOC Entry ID 20 (OID 20108)
185 -- Name: feature Type: TABLE Owner: postgres
188 CREATE TABLE "feature" (
189 "id" integer DEFAULT nextval('feature_id_seq'::text) NOT NULL,
190 "title" character varying(80) NOT NULL,
192 "filename" character varying(20) NOT NULL,
193 "main_url" character varying(255),
194 "is_published" boolean DEFAULT '0' NOT NULL,
195 Constraint "feature_pkey" Primary Key ("id")
199 -- TOC Entry ID 21 (OID 20143)
201 -- Name: webdb_users Type: TABLE Owner: postgres
204 CREATE TABLE "webdb_users" (
205 "id" integer DEFAULT nextval('webdb_users_id_seq'::text) NOT NULL,
206 "login" character varying(16) NOT NULL,
207 "password" character varying(16) NOT NULL,
208 "is_admin" boolean DEFAULT '0' NOT NULL,
209 Constraint "webdb_users_pkey" Primary Key ("id")
213 -- TOC Entry ID 22 (OID 20161)
215 -- Name: content_x_topic Type: TABLE Owner: postgres
218 CREATE TABLE "content_x_topic" (
219 "content_id" integer NOT NULL,
220 "topic_id" integer NOT NULL
224 -- TOC Entry ID 23 (OID 20172)
226 -- Name: article_type Type: TABLE Owner: postgres
229 CREATE TABLE "article_type" (
230 "id" integer NOT NULL,
231 "name" character varying(20) NOT NULL
235 -- TOC Entry ID 24 (OID 20183)
237 -- Name: topic Type: TABLE Owner: postgres
240 CREATE TABLE "topic" (
241 "id" integer DEFAULT nextval('topic_id_seq'::text) NOT NULL,
242 "parent_id" integer DEFAULT '0' NOT NULL,
243 "title" character varying(80) NOT NULL,
245 "filename" character varying(20) NOT NULL,
246 "main_url" character varying(255),
247 "archiv_url" character varying(255),
248 Constraint "topic_pkey" Primary Key ("id")
252 -- TOC Entry ID 25 (OID 20219)
254 -- Name: comment Type: TABLE Owner: postgres
257 CREATE TABLE "comment" (
258 "id" integer DEFAULT nextval('comment_id_seq'::text) NOT NULL,
259 "title" character varying(80) NOT NULL,
260 "creator" character varying(80) NOT NULL,
261 "description" text NOT NULL,
262 "main_url" character varying(255),
263 "email" character varying(80),
264 "address" character varying(80),
265 "phone" character varying(20),
266 "webdb_create" timestamp with time zone NOT NULL,
267 "is_published" boolean DEFAULT '1' NOT NULL,
268 "to_language" integer DEFAULT '0' NOT NULL,
269 "to_media" integer NOT NULL,
270 "to_comment_status" smallint,
272 Constraint "comment_pkey" Primary Key ("id")
276 -- TOC Entry ID 26 (OID 20266)
278 -- Name: media Type: TABLE Owner: postgres
281 CREATE TABLE "media" (
282 "id" integer DEFAULT nextval('media_id_seq'::text) NOT NULL,
283 "title" character varying(80) NOT NULL,
284 "subtitle" character varying(30),
285 "edittitle" character varying(30),
286 "date" character(8) NOT NULL,
287 "creator" character varying(80),
288 "creator_main_url" character varying(255),
289 "creator_email" character varying(80),
290 "creator_address" character varying(80),
291 "creator_phone" character varying(20),
295 "source" character varying(255),
296 "publish_date" timestamp with time zone,
297 "publish_server" character varying(255),
298 "publish_path" character varying(255),
299 "is_published" boolean DEFAULT '0' NOT NULL,
300 "is_produced" boolean DEFAULT '0' NOT NULL,
301 "to_feature" integer DEFAULT '0' NOT NULL,
302 "to_media_folder" integer DEFAULT '0' NOT NULL,
303 "to_media_type" smallint DEFAULT '0' NOT NULL,
304 "to_publisher" integer NOT NULL,
305 "to_language" integer DEFAULT '0',
306 "to_rights" integer DEFAULT '0',
307 "webdb_create" timestamp with time zone NOT NULL,
308 "webdb_lastchange" timestamp with time zone,
313 -- TOC Entry ID 27 (OID 20326)
315 -- Name: uploaded_media Type: TABLE Owner: postgres
318 CREATE TABLE "uploaded_media" (
319 "icon_is_produced" boolean DEFAULT '0' NOT NULL,
320 "icon_path" character varying(255),
326 -- TOC Entry ID 28 (OID 20392)
328 -- Name: images Type: TABLE Owner: postgres
331 CREATE TABLE "images" (
334 "year" character varying(40),
335 "img_width" smallint,
336 "img_height" smallint,
337 "to_img_format" smallint DEFAULT '0' NOT NULL,
338 "to_img_layout" smallint DEFAULT '0' NOT NULL,
339 "to_img_type" smallint DEFAULT '0' NOT NULL,
340 "to_img_color" smallint DEFAULT '0' NOT NULL,
341 "icon_width" smallint,
342 "icon_height" smallint
344 INHERITS ("uploaded_media");
347 -- TOC Entry ID 29 (OID 20474)
349 -- Name: content Type: TABLE Owner: postgres
352 CREATE TABLE "content" (
354 "link_url" character varying(255),
355 "is_html" boolean DEFAULT '0' NOT NULL,
356 "is_stored" boolean DEFAULT '0' NOT NULL,
357 "to_article_type" smallint DEFAULT '0' NOT NULL,
358 "to_content" integer,
364 -- TOC Entry ID 30 (OID 20549)
366 -- Name: breaking Type: TABLE Owner: postgres
369 CREATE TABLE "breaking" (
370 "id" integer DEFAULT nextval('breaking_id_seq'::text) NOT NULL,
371 "text" character varying(255) NOT NULL,
372 "webdb_create" timestamp with time zone NOT NULL
376 -- TOC Entry ID 31 (OID 20562)
378 -- Name: messages Type: TABLE Owner: postgres
381 CREATE TABLE "messages" (
382 "id" integer DEFAULT nextval('messages_id_seq'::text) NOT NULL,
383 "title" character varying(30),
384 "description" character varying(255) NOT NULL,
385 "creator" character varying(30) NOT NULL,
386 "webdb_create" timestamp with time zone NOT NULL
390 -- TOC Entry ID 32 (OID 20577)
392 -- Name: comment_status Type: TABLE Owner: postgres
395 CREATE TABLE "comment_status" (
396 "id" smallint NOT NULL,
397 "name" character varying(40) NOT NULL
401 -- TOC Entry ID 33 (OID 20588)
403 -- Name: content_x_media Type: TABLE Owner: postgres
406 CREATE TABLE "content_x_media" (
407 "content_id" integer,
412 -- TOC Entry ID 11 (OID 20599)
414 -- Name: links_imcs_id_seq Type: SEQUENCE Owner: postgres
417 CREATE SEQUENCE "links_imcs_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
420 -- TOC Entry ID 34 (OID 20618)
422 -- Name: links_imcs Type: TABLE Owner: postgres
425 CREATE TABLE "links_imcs" (
426 "id" integer DEFAULT nextval('links_imcs_id_seq'::text) NOT NULL,
427 "to_parent_id" integer,
428 "title" character varying(80) NOT NULL,
429 "url" character varying(255) NOT NULL,
430 "sortpriority" integer DEFAULT '1',
431 "to_language" integer DEFAULT '0' NOT NULL,
432 Constraint "links_imcs_pkey" Primary Key ("id")
436 -- TOC Entry ID 35 (OID 37215)
438 -- Name: audio Type: TABLE Owner: postgres
441 CREATE TABLE "audio" (
445 INHERITS ("uploaded_media");
448 -- TOC Entry ID 36 (OID 37284)
450 -- Name: video Type: TABLE Owner: postgres
453 CREATE TABLE "video" (
456 INHERITS ("uploaded_media");
459 -- TOC Entry ID 37 (OID 45396)
461 -- Name: other_media Type: TABLE Owner: postgres
464 CREATE TABLE "other_media" (
467 INHERITS ("uploaded_media");
470 -- TOC Entry ID 40 (OID 20143)
472 -- Name: "idx_webdb_user_log_pas_is_admin" Type: INDEX Owner: postgres
475 CREATE INDEX "idx_webdb_user_log_pas_is_admin" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops", "is_admin" "bool_ops" );
478 -- TOC Entry ID 41 (OID 20143)
480 -- Name: "idx_webdb_user_log_pas" Type: INDEX Owner: postgres
483 CREATE INDEX "idx_webdb_user_log_pas" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops" );
486 -- TOC Entry ID 42 (OID 20161)
488 -- Name: "idx_content" Type: INDEX Owner: postgres
491 CREATE UNIQUE INDEX "idx_content" on "content_x_topic" using btree ( "content_id" "int4_ops", "topic_id" "int4_ops" );
494 -- TOC Entry ID 43 (OID 20161)
496 -- Name: "idx_topic" Type: INDEX Owner: postgres
499 CREATE UNIQUE INDEX "idx_topic" on "content_x_topic" using btree ( "topic_id" "int4_ops", "content_id" "int4_ops" );
502 -- TOC Entry ID 44 (OID 20183)
504 -- Name: "idx_topic_title" Type: INDEX Owner: postgres
507 CREATE INDEX "idx_topic_title" on "topic" using btree ( "title" "varchar_ops" );
510 -- TOC Entry ID 45 (OID 20183)
512 -- Name: "idx_topic_id" Type: INDEX Owner: postgres
515 CREATE UNIQUE INDEX "idx_topic_id" on "topic" using btree ( "id" "int4_ops" );
518 -- TOC Entry ID 38 (OID 20219)
520 -- Name: "comment_checksum_index" Type: INDEX Owner: postgres
523 CREATE INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "int4_ops" );
526 -- TOC Entry ID 46 (OID 20219)
528 -- Name: "idx_comment_to_media" Type: INDEX Owner: postgres
531 CREATE INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
536 -- TOC Entry ID 59 (OID 20326)
538 -- Name: "idx_uploaded_media_id" Type: INDEX Owner: postgres
541 CREATE UNIQUE INDEX "idx_uploaded_media_id" on "uploaded_media" using btree ( "id" "int4_ops" );
544 -- TOC Entry ID 60 (OID 20326)
546 -- Name: "idx_uploaded_media_is_published" Type: INDEX Owner: postgres
549 CREATE UNIQUE INDEX "idx_uploaded_media_is_published" on "uploaded_media" using btree ( "id" "int4_ops", "is_published" "bool_ops" );
552 -- TOC Entry ID 47 (OID 20392)
554 -- Name: "idx_images_is_published__icon_i" Type: INDEX Owner: postgres
557 CREATE INDEX "idx_images_is_published__icon_i" on "images" using btree ( "is_published" "bool_ops", "icon_is_produced" "bool_ops" );
560 -- TOC Entry ID 48 (OID 20392)
562 -- Name: "idx_images_id" Type: INDEX Owner: postgres
565 CREATE UNIQUE INDEX "idx_images_id" on "images" using btree ( "id" "int4_ops" );
568 -- TOC Entry ID 39 (OID 20474)
570 -- Name: "content_checksum_index" Type: INDEX Owner: postgres
573 CREATE INDEX "content_checksum_index" on "content" using btree ( "checksum" "int4_ops" );
576 -- TOC Entry ID 49 (OID 20474)
578 -- Name: "idx_content_to_article_type" Type: INDEX Owner: postgres
581 CREATE INDEX "idx_content_to_article_type" on "content" using btree ( "to_article_type" "int2_ops" );
584 -- TOC Entry ID 50 (OID 20474)
586 -- Name: "idx_content_is_produced" Type: INDEX Owner: postgres
589 CREATE INDEX "idx_content_is_produced" on "content" using btree ( "is_produced" "bool_ops" );
592 -- TOC Entry ID 51 (OID 20474)
594 -- Name: "idx_content_is_published__to_ar" Type: INDEX Owner: postgres
597 CREATE INDEX "idx_content_is_published__to_ar" on "content" using btree ( "is_published" "bool_ops", "to_article_type" "int2_ops" );
600 -- TOC Entry ID 52 (OID 20474)
602 -- Name: "idx_content_is_stored" Type: INDEX Owner: postgres
605 CREATE INDEX "idx_content_is_stored" on "content" using btree ( "is_stored" "bool_ops" );
608 -- TOC Entry ID 53 (OID 20474)
610 -- Name: "idx_content_is_published__id" Type: INDEX Owner: postgres
613 CREATE INDEX "idx_content_is_published__id" on "content" using btree ( "is_published" "bool_ops", "id" "int4_ops" );
616 -- TOC Entry ID 54 (OID 20474)
618 -- Name: "idx_content_is_pub__to_art__to_" Type: INDEX Owner: postgres
621 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" );
624 -- TOC Entry ID 55 (OID 20474)
626 -- Name: "idx_content_id" Type: INDEX Owner: postgres
629 CREATE UNIQUE INDEX "idx_content_id" on "content" using btree ( "id" "int4_ops" );
632 -- TOC Entry ID 56 (OID 20588)
634 -- Name: "idx_content_media" Type: INDEX Owner: postgres
637 CREATE UNIQUE INDEX "idx_content_media" on "content_x_media" using btree ( "content_id" "int4_ops", "media_id" "int4_ops" );
640 -- TOC Entry ID 57 (OID 20588)
642 -- Name: "idx_media_content" Type: INDEX Owner: postgres
645 CREATE UNIQUE INDEX "idx_media_content" on "content_x_media" using btree ( "media_id" "int4_ops", "content_id" "int4_ops" );
648 -- TOC Entry ID 62 (OID 37215)
650 -- Name: "idx_audio_is_published_produced" Type: INDEX Owner: postgres
653 CREATE INDEX "idx_audio_is_published_produced" on "audio" using btree ( "is_published" "bool_ops", "is_produced" "bool_ops" );
656 -- TOC Entry ID 64 (OID 37215)
658 -- Name: "idx_audio_id" Type: INDEX Owner: postgres
661 CREATE UNIQUE INDEX "idx_audio_id" on "audio" using btree ( "id" "int4_ops" );
664 -- TOC Entry ID 65 (OID 37215)
666 -- Name: "idx_video_id" Type: INDEX Owner: postgres
669 CREATE UNIQUE INDEX "idx_video_id" on "audio" using btree ( "id" "int4_ops" );
672 -- TOC Entry ID 63 (OID 37284)
674 -- Name: "idx_video_is_published_produced" Type: INDEX Owner: postgres
677 CREATE INDEX "idx_video_is_published_produced" on "video" using btree ( "is_published" "bool_ops", "is_produced" "bool_ops" );
681 -- TOC Entry ID 37 (OID 520246)
683 -- Name: "idx_content_is_published" Type: INDEX Owner: postgres
686 CREATE INDEX "idx_content_is_published" on "content" using btree ( "is_published" "bool_ops" );
689 -- TOC Entry ID 47 (OID 465036)
691 -- Name: "idx_comment_tomedia_ispublished" Type: INDEX Owner: postgres
694 CREATE INDEX "idx_comment_tomedia_ispublished" on "comment" using btree ( "to_media" "int4_ops", "is_published" "bool_ops" );