]> WPIA git - gigi.git/blob - src/club/wpia/gigi/database/upgrade/from_33.sql
add: handling of RA Agent Contract
[gigi.git] / src / club / wpia / gigi / database / upgrade / from_33.sql
1 CREATE TABLE "jobLog" (
2   "jobid" int NOT NULL,
3   "attempt" smallint NOT NULL,
4   "content" text NOT NULL,
5   PRIMARY KEY ("jobid", "attempt")
6 );
7 CREATE INDEX ON "jobLog" ("jobid");
8
9 ALTER TABLE "jobs" RENAME COLUMN "warning" TO "attempt";