projects / mir.git / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 760eb8e)
Added index creation to database creation script.
authormj <mj>
Tue, 2 Oct 2001 09:52:25 +0000 (09:52 +0000)
committermj <mj>
Tue, 2 Oct 2001 09:52:25 +0000 (09:52 +0000)
Enhanced the debugging versions of the posting_dupe.template
Put info to install dupe prevention trigger into INSTALL.mir

dbscripts/create_pg.sql patch | blob | history
doc/INSTALL.mir patch | blob | history
templates-dist/de/open/posting_dupe.template patch | blob | history
templates-dist/open/posting_dupe.template patch | blob | history

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 530591e..9173fdf 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -359,10 +359,13 @@ CREATE TABLE "content" (
        "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)
 --
diff --git a/doc/INSTALL.mir b/doc/INSTALL.mir
index b35d9a2..d74d5ec 100755 (executable)
--- a/doc/INSTALL.mir
+++ b/doc/INSTALL.mir
@@ -59,11 +59,17 @@ as user postgres:
        cat dbscript/help*.sql | psql -Upostgres dbname
        cat dbscript/populate*.sql | psql -Upostgres dbname
 
-9. chmod 777 Mir/log 
+9. Add the dupe prevention trigger to the database:
+       cd dbscripts/dupetrigger
+       
+       There, read INSTALL and follow the instructions.
+       
+
+10. chmod 777 Mir/log 
 
-10. restart tomcat 
+11. restart tomcat 
 
-11. configure mod_jk 
+12. configure mod_jk 
 
 insert the following patch into /etc/apache/httpd.conf. Edit the directories
 to suit your needs.
@@ -79,7 +85,7 @@ If mod_jk.conf-auto doesn't get written or is 0 bytes in size, check your
 system for file ownership/permissions problems.
 
 
-12. Add a password to your PostgreSQL user and link it to Mir (optional)
+13. Add a password to your PostgreSQL user and link it to Mir (optional)
 
 Add a hard to guess password to the PostgreSQL user database:
 
diff --git a/templates-dist/de/open/posting_dupe.template b/templates-dist/de/open/posting_dupe.template
index 2ea225b..d8b5d20 100755 (executable)
--- a/templates-dist/de/open/posting_dupe.template
+++ b/templates-dist/de/open/posting_dupe.template
@@ -1,9 +1,43 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+
 <html>
 <head>
-<title>Test</title>
+       <title>indymedia.de | open posting - Posting-Duplikat</title>
 </head>
-<body>
-<p>
-Dupe
+
+<body bgcolor="White" text="Black" link="white" vlink="#009900" alink="Red">
+
+<table width="100%" border="0" cellspacing="0" cellpadding="10">
+       <tr>
+               <td valign="top" align="center" bgcolor="#663399">
+                       <font color="White"><b>
+                               Immer ruhig mit den jungen Pferden!
+                       </b></font
+               </td>
+       </tr> 
+       <tr>
+               <td bgcolor="003300" width=70%>
+                       <font color="White">
+                               <br>
+                                       Du hast vermutlich den Reload-Button
+                                       benutzt oder versucht, Deinen Artikel noch einmal zu posten. Das ist aber
+                                       unn&ouml;tig. Die Tatsache, dass Du diesen Text liest, bedeutet, dass Dein
+                                       Posting schon angekommen ist. Er wird gleich auf der Seite auftauchen. Versprochen.
+                               <br>
+                                       Technischer Hintergrund ist, daß de.indy &uuml;ber einen
+                                       Proxy-Server läuft und der ist nicht immer minuten-aktuell.
+                               <br> 
+                               <center><em>Keine Panik</em></center><br>
+                               <br>
+                       </font>
+               </td>
+       </tr>
+       <tr>
+               <td valign="top" align="center" bgcolor="#663399">
+                       <a href="javascript:history.go(-2)"><font color="White"><b>&gt;&gt; Zur&uuml;ck</b></font></a>
+               </td>
+       </tr> 
+</table>
+
 </body>
-</html>
\ No newline at end of file
+</html>
diff --git a/templates-dist/open/posting_dupe.template b/templates-dist/open/posting_dupe.template
index 2ea225b..d8b5d20 100755 (executable)
--- a/templates-dist/open/posting_dupe.template
+++ b/templates-dist/open/posting_dupe.template
@@ -1,9 +1,43 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+
 <html>
 <head>
-<title>Test</title>
+       <title>indymedia.de | open posting - Posting-Duplikat</title>
 </head>
-<body>
-<p>
-Dupe
+
+<body bgcolor="White" text="Black" link="white" vlink="#009900" alink="Red">
+
+<table width="100%" border="0" cellspacing="0" cellpadding="10">
+       <tr>
+               <td valign="top" align="center" bgcolor="#663399">
+                       <font color="White"><b>
+                               Immer ruhig mit den jungen Pferden!
+                       </b></font
+               </td>
+       </tr> 
+       <tr>
+               <td bgcolor="003300" width=70%>
+                       <font color="White">
+                               <br>
+                                       Du hast vermutlich den Reload-Button
+                                       benutzt oder versucht, Deinen Artikel noch einmal zu posten. Das ist aber
+                                       unn&ouml;tig. Die Tatsache, dass Du diesen Text liest, bedeutet, dass Dein
+                                       Posting schon angekommen ist. Er wird gleich auf der Seite auftauchen. Versprochen.
+                               <br>
+                                       Technischer Hintergrund ist, daß de.indy &uuml;ber einen
+                                       Proxy-Server läuft und der ist nicht immer minuten-aktuell.
+                               <br> 
+                               <center><em>Keine Panik</em></center><br>
+                               <br>
+                       </font>
+               </td>
+       </tr>
+       <tr>
+               <td valign="top" align="center" bgcolor="#663399">
+                       <a href="javascript:history.go(-2)"><font color="White"><b>&gt;&gt; Zur&uuml;ck</b></font></a>
+               </td>
+       </tr> 
+</table>
+
 </body>
-</html>
\ No newline at end of file
+</html>
The Mir CMS