projects
/
brisk.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
add usersnet_narrowfriend view
[brisk.git]
/
sql
/
sql.d
/
910-usernet_devel.sql
diff --git
a/sql/sql.d/910-usernet_devel.sql
b/sql/sql.d/910-usernet_devel.sql
index
d082220
..
9efb9f9
100644
(file)
--- a/
sql/sql.d/910-usernet_devel.sql
+++ b/
sql/sql.d/910-usernet_devel.sql
@@
-69,3
+69,5
@@
SELECT un.owner, ur.target, SUM(ur.skill * un.trust) AS num, SUM(un.trust) AS de
SELECT us.login, pa.* FROM #PFX#usersnet_party pa, #PFX#users as us WHERE pa.target = us.code AND pa.owner = 10101;
SELECT us.login, pa.* FROM #PFX#usersnet_party pa, #PFX#users as us WHERE pa.target = us.code AND pa.owner = 10101;
+SELECT * FROM #PFX#usersnet_widefriend ORDER BY owner, target, friend;
+SELECT * FROM #PFX#usersnet_narrowfriend ORDER BY owner, target, friend;