X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=c8936554fb00d72db39925414bd552ec48d8cdf2;hb=1bdfa2827063cec81a2520d2096ed019ebe4244d;hp=3c771b5beadca8fab64fb5584772651de8a9750a;hpb=655be34abbb8616bdd0c2f4d13a1d3089f933d95;p=mir.git diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql index 3c771b5b..c8936554 100755 --- a/dbscripts/create_pg.sql +++ b/dbscripts/create_pg.sql @@ -19,14 +19,6 @@ CREATE SEQUENCE "media_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue CREATE SEQUENCE "media_folder_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 4 (OID 28752) --- --- Name: creator_id_seq Type: SEQUENCE Owner: postgres --- - -CREATE SEQUENCE "creator_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; - --- -- TOC Entry ID 5 (OID 28771) -- -- Name: feature_id_seq Type: SEQUENCE Owner: postgres @@ -75,6 +67,14 @@ CREATE SEQUENCE "breaking_id_seq" start 1 increment 1 maxvalue 2147483647 minval CREATE SEQUENCE "messages_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- +-- TOC Entry ID 10 (OID 28866) +-- +-- Name: media_type_id_seq Type: SEQUENCE Owner: postgres +-- + +CREATE SEQUENCE "media_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; + +-- -- TOC Entry ID 12 (OID 28885) -- -- Name: media_folder Type: TABLE Owner: postgres @@ -98,8 +98,9 @@ CREATE TABLE "media_folder" ( -- CREATE TABLE "media_type" ( - "id" smallint NOT NULL, + "id" integer DEFAULT nextval('media_type_id_seq'::text) NOT NULL, "name" character varying(80) NOT NULL, + "mime_type" character varying(40) NOT NULL, "classname" character varying(80) NOT NULL, "tablename" character varying(80) NOT NULL, "dcname" character varying(20) @@ -179,22 +180,6 @@ CREATE TABLE "rights" ( ); -- --- TOC Entry ID 20 (OID 29024) --- --- Name: creator Type: TABLE Owner: postgres --- - -CREATE TABLE "creator" ( - "id" integer DEFAULT nextval('creator_id_seq'::text) NOT NULL, - "name" character varying(80) NOT NULL, - "main_url" character varying(255), - "email" character varying(80), - "address" character varying(80), - "phone" character varying(20), - Constraint "creator_pkey" Primary Key ("id") -); - --- -- TOC Entry ID 21 (OID 29043) -- -- Name: feature Type: TABLE Owner: postgres @@ -283,9 +268,12 @@ CREATE TABLE "comment" ( "to_language" integer DEFAULT '0' NOT NULL, "to_media" integer NOT NULL, "to_comment_status" smallint, + "checksum" integer, Constraint "comment_pkey" Primary Key ("id") ); +CREATE INDEX comment_checksum_index ON comment (checksum); + -- -- TOC Entry ID 27 (OID 29196) -- @@ -312,10 +300,10 @@ CREATE TABLE "media" ( "publish_server" character varying(255), "publish_path" character varying(255), "is_published" boolean DEFAULT '0' NOT NULL, + "is_produced" boolean DEFAULT '0' NOT NULL, "to_feature" integer DEFAULT '0' NOT NULL, "to_media_folder" integer DEFAULT '0' NOT NULL, "to_media_type" smallint DEFAULT '0' NOT NULL, - "to_creator" integer DEFAULT '0' NOT NULL, "to_publisher" integer NOT NULL, "to_language" integer DEFAULT '0', "to_rights" integer DEFAULT '0', @@ -330,11 +318,23 @@ CREATE TABLE "media" ( -- Name: images Type: TABLE Owner: postgres -- +-- +-- TOC Entry ID 32 (OID 29446) +-- +-- Name: uploaded_media Type: TABLE Owner: postgres +-- + +CREATE TABLE "uploaded_media" ( + "icon_is_produced" boolean DEFAULT '0' NOT NULL, + "icon_path" character varying(255), + "size" integer +) INHERITS ("media"); + CREATE TABLE "images" ( "image_data" oid, "icon_data" oid, - "icon_path" character varying(255), "icon_is_produced" boolean DEFAULT '0' NOT NULL, + "icon_path" character varying(255), "year" character varying(40), "img_width" smallint, "img_height" smallint, @@ -356,19 +356,18 @@ INHERITS ("media"); CREATE TABLE "content" ( "content_data" text, "link_url" character varying(255), - "date_from" character varying(8), - "date_to" character varying(8), - "date_name" character varying(255), "is_html" boolean DEFAULT '0' NOT NULL, - "is_produced" boolean DEFAULT '0' NOT NULL, "is_stored" boolean DEFAULT '0' NOT NULL, "is_mail_sent" boolean DEFAULT '1' NOT NULL, "is_digest_sent" boolean DEFAULT '1' NOT NULL, "to_article_type" smallint DEFAULT '0' NOT NULL, - "to_content" integer + "to_content" integer, + "checksum" integer ) INHERITS ("media"); +CREATE INDEX content_checksum_index ON content (checksum); + -- -- TOC Entry ID 30 (OID 29418) -- @@ -396,64 +395,49 @@ CREATE TABLE "messages" ( ); -- --- TOC Entry ID 32 (OID 29446) --- --- Name: videos Type: TABLE Owner: postgres --- - -CREATE TABLE "videos" ( - "video_data" oid, - "to_video_type" smallint DEFAULT '0' NOT NULL -) -INHERITS ("media"); - --- --- TOC Entry ID 11 (OID 29781) +-- TOC Entry ID 33 (OID 30026) -- --- Name: links_imc_id_seq Type: SEQUENCE Owner: postgres +-- Name: comment_status Type: TABLE Owner: postgres -- -CREATE SEQUENCE "links_imc_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; +CREATE TABLE "comment_status" ( + "id" smallint NOT NULL, + "name" character varying(40) NOT NULL +); -- --- TOC Entry ID 33 (OID 29987) +-- TOC Entry ID 34 (OID 30064) -- --- Name: links_imc Type: TABLE Owner: postgres +-- Name: content_x_media Type: TABLE Owner: postgres -- -CREATE TABLE "links_imc" ( - "id" integer DEFAULT nextval('links_imc_id_seq'::text) NOT NULL, - "parent_id" integer DEFAULT '0', - "title" character varying(80) NOT NULL, - "description" text, - "filename" character varying(20) NOT NULL, - "main_url" character varying(255), - "archiv_url" character varying(255), - "sortpriority" integer, - "to_language" integer, - Constraint "links_imc_pkey" Primary Key ("id") +CREATE TABLE "content_x_media" ( + "content_id" integer, + "media_id" integer ); -- --- TOC Entry ID 34 (OID 30026) +-- TOC Entry ID 11 (OID 32812) -- --- Name: comment_status Type: TABLE Owner: postgres +-- Name: links_imcs_id_seq Type: SEQUENCE Owner: postgres -- -CREATE TABLE "comment_status" ( - "id" smallint NOT NULL, - "name" character varying(40) NOT NULL -); +CREATE SEQUENCE "links_imcs_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -- --- TOC Entry ID 35 (OID 30064) +-- TOC Entry ID 35 (OID 32831) -- --- Name: content_x_media Type: TABLE Owner: postgres +-- Name: links_imcs Type: TABLE Owner: postgres -- -CREATE TABLE "content_x_media" ( - "content_id" integer, - "media_id" integer +CREATE TABLE "links_imcs" ( + "id" integer DEFAULT nextval('links_imcs_id_seq'::text) NOT NULL, + "to_parent_id" integer, + "title" character varying(80) NOT NULL, + "url" character varying(255) NOT NULL, + "sortpriority" integer DEFAULT '1', + "to_language" integer DEFAULT '0' NOT NULL, + Constraint "links_imcs_pkey" Primary Key ("id") ); --