X-Git-Url: https://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F910-usernet_devel.sql;h=1c780b7c9556d601dd4815e58b28f2fd69df151a;hp=1fd6ce2635b3e70e027c82c256687128ae59293d;hb=5e4b519b81ef7a2699f3870e5262163ba2e7acd9;hpb=c50bd1cf600bc07608e6dfdf4f7c854ee13aee29 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;