From: Matteo Nastasi (mop) Date: Tue, 8 Oct 2013 16:05:13 +0000 (+0200) Subject: add another user and change id value to be able to use imported data from real site X-Git-Tag: v4.10.0^2~16 X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=commitdiff_plain;h=8d16e0d849f5b04cf58e439934c498a78ea5a1eb add another user and change id value to be able to use imported data from real site --- diff --git a/sql/sql.d/100-anagr.sql.noinsert b/sql/sql.d/100-anagr.sql.noinsert index e87cb6d..474c39b 100644 --- a/sql/sql.d/100-anagr.sql.noinsert +++ b/sql/sql.d/100-anagr.sql.noinsert @@ -10,9 +10,10 @@ -- define(USER_FLAG_TY_SUSPEND, 0x00400000); // done -- define(USER_FLAG_TY_DISABLE, 0x00800000); // done -INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (101, 'uno', md5('one'), 'uno@pluto.com', CAST (X'00020000' as integer)); -INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (102, 'due', md5('two'), 'due@pluto.com', CAST (X'00010000' as integer)); -INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (103, 'tre', md5('thr'), 'tre@pluto.com', CAST (X'00010000' as integer)); -INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (104, 'qua', md5('for'), 'qua@pluto.com', CAST (X'00210000' as integer)); -INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (105, 'cin', md5('fiv'), 'cin@pluto.com', CAST (X'00010000' as integer)); -ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 106; +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10101, 'uno', md5('one'), 'uno@pluto.com', CAST (X'00020000' as integer)); +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10102, 'due', md5('two'), 'due@pluto.com', CAST (X'00010000' as integer)); +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10103, 'tre', md5('thr'), 'tre@pluto.com', CAST (X'00010000' as integer)); +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10104, 'qua', md5('for'), 'qua@pluto.com', CAST (X'00010000' as integer)); +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10105, 'cin', md5('fiv'), 'cin@pluto.com', CAST (X'00010000' as integer)); +INSERT INTO #PFX#users (code, login, pass, email, type) VALUES (10106, 'sei', md5('six'), 'sei@pluto.com', CAST (X'00210000' as integer)); +ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 10107;