# HG changeset patch
# User jbe
# Date 1288482464 -7200
# Node ID 1934f9b4f803ca664b1ddba6c4276f5507cb46c2
# Parent  d7eadecc7b053655bf0ee4c019d4fab09a2dcb87
Removed "auto_support" stub
(update file not modified)

diff -r d7eadecc7b05 -r 1934f9b4f803 core.sql
--- a/core.sql	Fri Oct 29 18:36:36 2010 +0200
+++ b/core.sql	Sun Oct 31 01:47:44 2010 +0200
@@ -632,15 +632,13 @@
         "initiative_id"         INT4,
         "member_id"             INT4,
         "draft_id"              INT8            NOT NULL,
-        "auto_support"          BOOLEAN         NOT NULL DEFAULT FALSE,
         FOREIGN KEY ("issue_id", "member_id") REFERENCES "interest" ("issue_id", "member_id") ON DELETE CASCADE ON UPDATE CASCADE,
         FOREIGN KEY ("initiative_id", "draft_id") REFERENCES "draft" ("initiative_id", "id") ON DELETE CASCADE ON UPDATE CASCADE );
 CREATE INDEX "supporter_member_id_idx" ON "supporter" ("member_id");
 
 COMMENT ON TABLE "supporter" IS 'Members who support an initiative (conditionally); Frontends must ensure that supporters are not added or removed from fully_frozen or closed initiatives.';
 
-COMMENT ON COLUMN "supporter"."draft_id"     IS 'Latest seen draft, defaults to current draft of the initiative (implemented by trigger "default_for_draft_id")';
-COMMENT ON COLUMN "supporter"."auto_support" IS 'Supporting member does not want to confirm new drafts of the initiative';
+COMMENT ON COLUMN "supporter"."draft_id" IS 'Latest seen draft, defaults to current draft of the initiative (implemented by trigger "default_for_draft_id")';
 
 
 CREATE TABLE "opinion" (