X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F054-continue-match.sql;h=0ed40fb6701333fa6c2a63aff495ace4ba9d5596;hb=9cca3b21eb54b1c6c14610b93e7a3dc5fa362cc1;hp=3db1ff9579f768f91b3b7f215608a6be1cc38b63;hpb=ebf674a03fdbc3e281dd99e6e271ebec24e2448e;p=brisk.git diff --git a/sql/sql.d/054-continue-match.sql b/sql/sql.d/054-continue-match.sql index 3db1ff9..0ed40fb 100644 --- a/sql/sql.d/054-continue-match.sql +++ b/sql/sql.d/054-continue-match.sql @@ -1,8 +1,8 @@ DROP TABLE #PFX#bin5_table_orders; CREATE TABLE #PFX#bin5_table_orders ( mcode integer REFERENCES #PFX#bin5_matches (code) ON DELETE cascade ON UPDATE cascade, - ucode integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade, - pos integer + pos integer, + ucode integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade ); ALTER TABLE #PFX#bin5_matches DROP COLUMN mult_next;