aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
authorDiva Canto2010-02-28 16:09:06 -0800
committerDiva Canto2010-02-28 16:09:06 -0800
commit774958bbbf639090e73204be1d5b6d5c7653441a (patch)
tree7a6415cbab9bf278d0d17f6b3b0b1ab640e853bd /OpenSim/Data/SQLite/Resources
parentChange the signature of SendChangeUserRights, because we have to send (diff)
downloadopensim-SC_OLD-774958bbbf639090e73204be1d5b6d5c7653441a.zip
opensim-SC_OLD-774958bbbf639090e73204be1d5b6d5c7653441a.tar.gz
opensim-SC_OLD-774958bbbf639090e73204be1d5b6d5c7653441a.tar.bz2
opensim-SC_OLD-774958bbbf639090e73204be1d5b6d5c7653441a.tar.xz
Added FriendsData to both Null storage and SQLite. Untested.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_FriendsStore.sql10
-rw-r--r--OpenSim/Data/SQLite/Resources/002_FriendsStore.sql5
2 files changed, 15 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql b/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql
new file mode 100644
index 0000000..f1b9ab9
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/001_FriendsStore.sql
@@ -0,0 +1,10 @@
1BEGIN TRANSACTION;
2
3CREATE TABLE `Friends` (
4 `PrincipalID` CHAR(36) NOT NULL,
5 `Friend` VARCHAR(255) NOT NULL,
6 `Flags` VARCHAR(16) NOT NULL DEFAULT 0,
7 `Offered` VARCHAR(32) NOT NULL DEFAULT 0,
8 PRIMARY KEY(`PrincipalID`, `Friend`));
9
10COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/002_FriendsStore.sql b/OpenSim/Data/SQLite/Resources/002_FriendsStore.sql
new file mode 100644
index 0000000..6733502
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/002_FriendsStore.sql
@@ -0,0 +1,5 @@
1BEGIN TRANSACTION;
2
3INSERT INTO `Friends` SELECT `ownerID`, `friendID`, `friendPerms`, 0 FROM `userfriends`;
4
5COMMIT;