You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 lines
153 B
2 lines
153 B
ALTER TABLE "match" ADD COLUMN "state" varchar not null default 'NOT_YET_PLAYED';
|
|
UPDATE match SET state='PLAYED' WHERE (id IN (SELECT match from game));
|