From 56604b9b6d2f1184c67dfdf0592116cb2f6f8a3e Mon Sep 17 00:00:00 2001
From: Matthias Andreas Benkard <code@mail.matthias.benkard.de>
Date: Sun, 13 Mar 2011 14:43:31 +0100
Subject: Database schema: Stylistic changes.

---
 schema.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 52a6ff2..39ddb53 100644
--- a/schema.sql
+++ b/schema.sql
@@ -238,7 +238,7 @@ $$ LANGUAGE plpgsql;
 --   SELECT article_revisions_for_characteristics(70, ARRAY[ROW(ARRAY[ROW('language', 'de')::characteristic])]::characteristic_list[]);
 
 
-CREATE OR REPLACE FUNCTION older_revision(
+CREATE FUNCTION older_revision(
   IN article_revisions,
   IN article_revisions,
   OUT article_revisions
@@ -256,7 +256,7 @@ CREATE AGGREGATE oldest_revision (article_revisions) (
 );
 
 
-CREATE OR REPLACE FUNCTION more_recent_revision(
+CREATE FUNCTION more_recent_revision(
   IN article_revisions,
   IN article_revisions,
   OUT article_revisions
@@ -279,7 +279,7 @@ CREATE VIEW article_comment_counts AS
   SELECT a.id       AS article,
          count(c.*) AS comment_count
     FROM articles a
-    LEFT JOIN comments c
+    LEFT OUTER JOIN comments c
       ON c.article = a.id
      AND EXISTS (SELECT *
                    FROM comment_revisions
-- 
cgit v1.2.3

