CREATE TABLE "admin_settings" (
	"key" text PRIMARY KEY NOT NULL,
	"value" jsonb NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL,
	"updated_by" uuid
);
--> statement-breakpoint
CREATE TABLE "product_pages" (
	"slug" text PRIMARY KEY NOT NULL,
	"hero_eyebrow" text DEFAULT '' NOT NULL,
	"hero_title" text DEFAULT '' NOT NULL,
	"hero_tagline" text DEFAULT '' NOT NULL,
	"hero_description" text DEFAULT '' NOT NULL,
	"hero_image_path" text,
	"hero_image_alt" text,
	"hero_primary_cta_label" text DEFAULT '' NOT NULL,
	"hero_primary_cta_href" text DEFAULT '' NOT NULL,
	"hero_secondary_cta_label" text DEFAULT '' NOT NULL,
	"hero_secondary_cta_href" text DEFAULT '' NOT NULL,
	"access_rail_tagline" text DEFAULT '' NOT NULL,
	"access_rail_members_only" boolean DEFAULT false NOT NULL,
	"access_tiles" jsonb DEFAULT '[]'::jsonb NOT NULL,
	"section_eyebrow" text DEFAULT '' NOT NULL,
	"section_heading" text DEFAULT '' NOT NULL,
	"section_body" text DEFAULT '' NOT NULL,
	"showcase_image_path" text,
	"showcase_image_alt" text,
	"showcase_eyebrow" text DEFAULT '' NOT NULL,
	"showcase_caption" text DEFAULT '' NOT NULL,
	"features" jsonb DEFAULT '[]'::jsonb NOT NULL,
	"audience_heading" text DEFAULT '' NOT NULL,
	"audience_body" text DEFAULT '' NOT NULL,
	"audiences" jsonb DEFAULT '[]'::jsonb NOT NULL,
	"faqs" jsonb DEFAULT '[]'::jsonb NOT NULL,
	"cta_title" text DEFAULT '' NOT NULL,
	"cta_body" text DEFAULT '' NOT NULL,
	"cta_primary_label" text DEFAULT '' NOT NULL,
	"cta_primary_href" text DEFAULT '' NOT NULL,
	"cta_secondary_label" text DEFAULT '' NOT NULL,
	"cta_secondary_href" text DEFAULT '' NOT NULL,
	"updated_at" timestamp DEFAULT now() NOT NULL,
	"updated_by" uuid
);
--> statement-breakpoint
ALTER TABLE "blog_posts" ADD COLUMN "scheduled_at" timestamp;--> statement-breakpoint
ALTER TABLE "store_products" ADD COLUMN "gallery" jsonb DEFAULT '[]'::jsonb NOT NULL;--> statement-breakpoint
ALTER TABLE "admin_settings" ADD CONSTRAINT "admin_settings_updated_by_users_id_fk" FOREIGN KEY ("updated_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;--> statement-breakpoint
ALTER TABLE "product_pages" ADD CONSTRAINT "product_pages_updated_by_users_id_fk" FOREIGN KEY ("updated_by") REFERENCES "public"."users"("id") ON DELETE set null ON UPDATE no action;