[wellwell-devel] [wellwell] Add approved column to reviews table.
Stefan Hornburg
wellwell-devel at rt.icdevgroup.org
Wed Sep 15 10:45:07 UTC 2010
commit b0d8d30caf7ab2b9a64864ab361718f4f2444a9e
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