Add approved column to reviews table.

interchange · Sep 15, 2010 · d1d1509 · d1d1509
1 parent 84d478c
commit d1d1509
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 1 deletion.
diff --git 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
@@ -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);