-- Table: "ActivityBlogCampaign"

-- DROP TABLE "ActivityBlogCampaign";

CREATE TABLE "ActivityBlogCampaign"
(
  "activityId" bigint NOT NULL,
  "sphereId" bigint,
  "modifiedDate" timestamp without time zone,
  "createdDate" timestamp without time zone,
  "activityBlogCampaignId" bigserial NOT NULL,
  "optInRequired" boolean NOT NULL DEFAULT false,
  "optInStartDate" timestamp without time zone,
  "optInEndDate" timestamp without time zone,
  "optInCap" bigint,
  "badgeRequired" boolean NOT NULL DEFAULT false,
  "badgeSnippet" text,
  CONSTRAINT "ActivityBlogCampaign_pkey" PRIMARY KEY ("activityBlogCampaignId"),
  CONSTRAINT "FK_ActivityBlogCampaign_Activity_activityId" FOREIGN KEY ("activityId")
      REFERENCES "Activity" ("activityId") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "ActivityBlogCampaign"
  OWNER TO postgres;

-- Index: "IX_ActivityBlogCampaign_activityBlogCampaignId"

-- DROP INDEX "IX_ActivityBlogCampaign_activityBlogCampaignId";

CREATE INDEX "IX_ActivityBlogCampaign_activityBlogCampaignId"
  ON "ActivityBlogCampaign"
  USING btree
  ("activityBlogCampaignId");

-- Index: "IX_ActivityBlogCampaign_activityId"

-- DROP INDEX "IX_ActivityBlogCampaign_activityId";

CREATE INDEX "IX_ActivityBlogCampaign_activityId"
  ON "ActivityBlogCampaign"
  USING btree
  ("activityId");