X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F900-anagr.sql.devel;h=c415d9388fea425350016b8619a2bbfa90c19ca8;hb=f831fd339d68c0dca1101499f8601562f571433f;hp=9de89242bb7c7cd00bedf094a87e9efe10d4b2b1;hpb=a77cf3db1fbace39c49b030b9e144a316f007373;p=brisk.git diff --git a/sql/sql.d/900-anagr.sql.devel b/sql/sql.d/900-anagr.sql.devel index 9de8924..c415d93 100644 --- a/sql/sql.d/900-anagr.sql.devel +++ b/sql/sql.d/900-anagr.sql.devel @@ -18,11 +18,13 @@ INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (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; -INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10103, 'tre', md5('thr'), 'tre@pluto.com', CAST (X'00010000' as integer), 10102); +INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10103, 'tre', md5('thr'), 'tre@pluto.com', CAST (X'00030000' as integer), 10102); DELETE FROM #PFX#users WHERE code = 10104; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10104, 'qua', md5('for'), 'qua@pluto.com', CAST (X'00010000' as integer), 10102); DELETE FROM #PFX#users WHERE code = 10105; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10105, 'cin', md5('fiv'), 'cin@pluto.com', CAST (X'00010000' as integer), 10103); DELETE FROM #PFX#users WHERE code = 10106; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10106, 'sei', md5('six'), 'sei@pluto.com', CAST (X'00210000' as integer), 10103); -ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 10107; +DELETE FROM #PFX#users WHERE code = 10107; +INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10107, E'"/\\''|', md5('sev'), 'sev@pluto.com', CAST (X'00210000' as integer), 10103); +ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 10108;