26 lines
748 B
MySQL
26 lines
748 B
MySQL
|
-- Convert schema '/var/lib/las_tres/LasTres/script/../dbicdh/_source/deploy/12/001-auto.yml' to '/var/lib/las_tres/LasTres/script/../dbicdh/_source/deploy/13/001-auto.yml':;
|
||
|
|
|
||
|
|
;
|
||
|
|
BEGIN;
|
||
|
|
|
||
|
|
;
|
||
|
|
CREATE TABLE "player_pjs_known_words" (
|
||
|
|
"identifier" text NOT NULL,
|
||
|
|
"owner" uuid NOT NULL,
|
||
|
|
PRIMARY KEY ("identifier", "owner")
|
||
|
|
);
|
||
|
|
CREATE INDEX "player_pjs_known_words_idx_owner" on "player_pjs_known_words" ("owner");
|
||
|
|
CREATE INDEX "index_known_word" on "player_pjs_known_words" ("owner", "identifier");
|
||
|
|
|
||
|
|
;
|
||
|
|
ALTER TABLE "player_pjs_known_words" ADD CONSTRAINT "player_pjs_known_words_fk_owner" FOREIGN KEY ("owner")
|
||
|
|
REFERENCES "player_pjs" ("uuid") ON DELETE CASCADE ON UPDATE CASCADE DEFERRABLE;
|
||
|
|
|
||
|
|
;
|
||
|
|
ALTER TABLE teams DROP CONSTRAINT u_name;
|
||
|
|
|
||
|
|
;
|
||
|
|
|
||
|
|
COMMIT;
|
||
|
|
|