X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=c8936554fb00d72db39925414bd552ec48d8cdf2;hb=1bdfa2827063cec81a2520d2096ed019ebe4244d;hp=1015712046107e42a64be192f80375a354e0ce2b;hpb=9a4657fc2acfa3e38074ebf18991fd2f88e15e84;p=mir.git

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 10157120..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
@@ -188,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
@@ -296,6 +272,8 @@ CREATE TABLE "comment" (
 	Constraint "comment_pkey" Primary Key ("id")
 );
 
+CREATE INDEX comment_checksum_index ON comment (checksum);
+
 --
 -- TOC Entry ID 27 (OID 29196)
 --
@@ -322,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',
@@ -340,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,
@@ -366,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)
 --
@@ -406,16 +395,6 @@ CREATE TABLE "messages" (
 );
 
 --
--- TOC Entry ID 32 (OID 29446)
---
--- Name: uploaded_media Type: TABLE Owner: postgres
---
-
-CREATE TABLE "uploaded_media" (
- 
-) INHERITS ("media");
-
---
 -- TOC Entry ID 33 (OID 30026)
 --
 -- Name: comment_status Type: TABLE Owner: postgres
@@ -605,32 +584,3 @@ CREATE UNIQUE INDEX "idx_content_media" on "content_x_media" using btree ( "cont
 
 CREATE UNIQUE INDEX "idx_media_content" on "content_x_media" using btree ( "media_id" "int4_ops", "content_id" "int4_ops" );
 
---
--- Selected TOC Entries:
---
---
--- Data for TOC Entry ID 2 (OID 28909)
---
--- Name: media_type Type: TABLE DATA Owner: postgres
---
-
-
-\connect - postgres
--- Disable triggers
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'media_type';
-
-COPY "media_type"  FROM stdin;
-2	unknown	application/octet-stream	--	UploadedMedia	\N
-3	gif	image/gif	ImagesGif	Images	\N
-\.
--- Enable triggers
-UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'media_type';
-
---
--- TOC Entry ID 1 (OID 28890)
---
--- Name: media_type_id_seq Type: SEQUENCE SET Owner: 
---
-
-SELECT setval ('"media_type_id_seq"', 1, 't');
-