6 lines
373 B
SQL
6 lines
373 B
SQL
ALTER TABLE "wanjiedaoyou_sect_task_records"
|
|
ADD COLUMN "attempt" integer NOT NULL DEFAULT 1;--> statement-breakpoint
|
|
DROP INDEX "sect_task_membership_period_task_unique";--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "sect_task_membership_period_task_attempt_unique"
|
|
ON "wanjiedaoyou_sect_task_records" USING btree ("membership_id", "period_key", "task_id", "attempt");
|