projects
/
brisk.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
use class instead of id to hide tables
[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
1fd6ce2
..
1c780b7
100644
(file)
--- 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);
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;
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;