ALTER TABLE "subscription" DROP COLUMN "trial_start";
ALTER TABLE "subscription" ADD COLUMN "trial_start" timestamp;--> statement-breakpoint
ALTER TABLE "subscription" DROP COLUMN "trial_end";
ALTER TABLE "subscription" ADD COLUMN "trial_end" timestamp;--> statement-breakpoint
ALTER TABLE "subscription" DROP COLUMN "canceled_at";
ALTER TABLE "subscription" ADD COLUMN "canceled_at" timestamp;--> statement-breakpoint
ALTER TABLE "subscription" DROP COLUMN "created_at";
ALTER TABLE "subscription" ADD COLUMN "created_at" timestamp DEFAULT now();--> statement-breakpoint
ALTER TABLE "subscription" DROP COLUMN "updated_at";
ALTER TABLE "subscription" ADD COLUMN "updated_at" timestamp DEFAULT now();--> statement-breakpoint
ALTER TABLE "subscription" ADD COLUMN "period_start" timestamp;--> statement-breakpoint
ALTER TABLE "subscription" ADD COLUMN "period_end" timestamp;--> statement-breakpoint
ALTER TABLE "subscription" DROP COLUMN "current_period_start";
ALTER TABLE "subscription" DROP COLUMN "current_period_end";--> statement-breakpoint
ALTER TABLE "posts" ADD COLUMN "location_id" integer;--> statement-breakpoint
CREATE INDEX "posts_location_id_idx" ON "posts" USING btree ("location_id");--> statement-breakpoint
ALTER TABLE "posts" DROP COLUMN "location";--> statement-breakpoint