From 5e4b519b81ef7a2699f3870e5262163ba2e7acd9 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Mon, 21 Dec 2015 08:13:26 +0100 Subject: [PATCH] add new user for usersnet tests --- sql/sql.d/900-anagr_devel.sql | 4 +++- sql/sql.d/910-usernet_devel.sql | 4 ++++ 2 files changed, 7 insertions(+), 1 deletion(-) diff --git a/sql/sql.d/900-anagr_devel.sql b/sql/sql.d/900-anagr_devel.sql index 9ed830e..4730163 100644 --- a/sql/sql.d/900-anagr_devel.sql +++ b/sql/sql.d/900-anagr_devel.sql @@ -43,5 +43,7 @@ DELETE FROM #PFX#users WHERE code = 10113; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10113, 'doub', md5('boub'), 'doub@pluto.com', CAST (X'00010000' as integer), 10103); DELETE FROM #PFX#users WHERE code = 10114; INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10114, 'selfguar', md5('self'), 'self@pluto.com', CAST (X'00010000' as integer), 10103); +DELETE FROM #PFX#users WHERE code = 10115; +INSERT INTO #PFX#users (code, login, pass, email, type, guar_code) VALUES (10115, 'bonoonly', md5('bonoonly'), 'bonoonly@pluto.com', CAST (X'00010000' as integer), 10101); -ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 10115; +ALTER SEQUENCE #PFX#users_code_seq RESTART WITH 10116; diff --git a/sql/sql.d/910-usernet_devel.sql b/sql/sql.d/910-usernet_devel.sql index 1fd6ce2..1c780b7 100644 --- a/sql/sql.d/910-usernet_devel.sql +++ b/sql/sql.d/910-usernet_devel.sql @@ -53,6 +53,10 @@ INSERT INTO #PFX#usersnet (owner, target, friend, skill, trust) VALUES (10102, DELETE FROM #PFX#usersnet WHERE owner = 10103 AND target = 10112; INSERT INTO #PFX#usersnet (owner, target, friend, skill, trust) VALUES (10103, 10112, 1, 2, 3); +-- bonoonly +DELETE FROM #PFX#usersnet WHERE owner = 10103 AND target = 10115; +INSERT INTO #PFX#usersnet (owner, target, friend, skill, trust) VALUES (10103, 10115, 1, 0, 0); + SELECT * FROM #PFX#usersnet WHERE owner = 10101 OR owner IN (10102, 10103, 10113) ORDER BY target; SELECT * FROM #PFX#usersnet_wideskill ORDER BY owner, target; -- 2.17.1