postgresql.jar for the OID hack

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 530591e..ffcec45 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -286,7 +286,7 @@ CREATE TABLE "media" (
        "subtitle" character varying(30),
        "edittitle" character varying(30),
        "date" character(8) NOT NULL,
-       "place" character varying(80),
+--     "place" character varying(80),
        "creator" character varying(80),
        "creator_main_url" character varying(255),
        "creator_email" character varying(80),
@@ -356,13 +356,16 @@ CREATE TABLE "content" (
        "link_url" character varying(255),
        "is_html" 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,
+--     "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)
 --
@@ -579,3 +582,4 @@ 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" );
 
+