Commits

Mikela Clemmons  committed c0fa9f0

migration

  • Participants
  • Parent commits 1b7b05d

Comments (0)

Files changed (1)

File sponsors/migrations/000_ordering.sql

+begin;
+alter table sponsors_sponsortype add column "order" integer;
+alter table sponsors_sponsor add column "order" integer;
+alter table sponsors_sponsor alter column url drop not null;
+alter table sponsors_sponsor alter column logo drop not null;
+alter table sponsors_sponsor add constraint order_unique UNIQUE ("order");
+ALTER TABLE "sponsors_sponsor" ADD CONSTRAINT "stype_id_refs_id_2637faad" FOREIGN KEY ("stype_id") REFERENCES "sponsors_sponsortype" ("id") DEFERRABLE INITIALLY DEFERRED;
+commit;