[wellwell-devel] [wellwell/zoom] Add approved column to reviews table.

Stefan Hornburg wellwell-devel at rt.icdevgroup.org
Wed Sep 15 10:47:30 UTC 2010


commit d1d150926f87af6ae5601d4e8086f4662367afa1
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Wed Sep 15 12:42:39 2010 +0200

    Add approved column to reviews table.

 plugins/reviews/database/mysql/reviews.sql |    1 +
 plugins/reviews/database/pgsql/reviews.sql |    3 ++-
 2 files changed, 3 insertions(+), 1 deletions(-)
---
diff --git a/plugins/reviews/database/mysql/reviews.sql b/plugins/reviews/database/mysql/reviews.sql
index b1f24ef..3053dc7 100644
--- a/plugins/reviews/database/mysql/reviews.sql
+++ b/plugins/reviews/database/mysql/reviews.sql
@@ -7,6 +7,7 @@ CREATE TABLE reviews (
   rating integer NOT NULL DEFAULT 0,
   title varchar(255) NOT NULL DEFAULT '',
   public boolean NOT NULL DEFAULT FALSE,
+  approved boolean DEFAULT NULL,
   review text NOT NULL DEFAULT '',
   KEY(sku)  
 );
diff --git a/plugins/reviews/database/pgsql/reviews.sql b/plugins/reviews/database/pgsql/reviews.sql
index af8efab..cbc44e7 100644
--- a/plugins/reviews/database/pgsql/reviews.sql
+++ b/plugins/reviews/database/pgsql/reviews.sql
@@ -7,6 +7,7 @@ CREATE TABLE reviews (
   rating integer NOT NULL DEFAULT 0,
   title varchar(255) NOT NULL DEFAULT '',
   public boolean NOT NULL DEFAULT FALSE,
-  review text NOT NULL DEFAULT ''
+  approved boolean DEFAULT NULL,
+  review text NOT NULL DEFAULT '',
 );
 CREATE INDEX reviews_sku ON reviews(sku);



More information about the wellwell-devel mailing list