X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F100-anagr.sql.devel;h=d65f9200b73d6a5422a083c4b70cd6bed3cac594;hb=ad1adc9cdd234ce4904a31f244469993a0f2cb7e;hp=6b3796aaf1b0a62cc522c57770e5c792498bc81e;hpb=5afa7681faebc92f25f73074e599b4048bcdd2a0;p=brisk.git diff --git a/sql/sql.d/100-anagr.sql.devel b/sql/sql.d/100-anagr.sql.devel index 6b3796a..d65f920 100644 --- a/sql/sql.d/100-anagr.sql.devel +++ b/sql/sql.d/100-anagr.sql.devel @@ -11,7 +11,8 @@ -- define(USER_FLAG_TY_DISABLE, 0x00800000); // done DELETE FROM #PFX#users WHERE code = 10101; -INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10101, 'uno', md5('one'), 'uno@pluto.com', CAST (X'00020000' as integer), 10101); +DELETE FROM #PFX#users WHERE guar_code = 10101 AND code != 10101; +INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10101, 'uno', md5('one'), 'uno@pluto.com', CAST (X'00410000' as integer), 10101); DELETE FROM #PFX#users WHERE code = 10102; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10102, 'due', md5('two'), 'due@pluto.com', CAST (X'00010000' as integer), 10101); DELETE FROM #PFX#users WHERE code = 10103;