add sqlite database definitions as Resources for SQLite.dll

1 files changed, 37 insertions, 0 deletions

diff --git a/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql
new file mode 100644
index 0000000..070e340
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql
@@ -0,0 +1,37 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE users(
+        UUID varchar(255) primary key,
+        username varchar(255),
+        surname varchar(255),
+        passwordHash varchar(255),
+        passwordSalt varchar(255),
+        homeRegionX integer,
+        homeRegionY integer,
+        homeLocationX float,    
+        homeLocationY float,
+        homeLocationZ float,
+        homeLookAtX float,
+        homeLookAtY float,
+        homeLookAtZ float,
+        created integer,
+        lastLogin integer,
+        rootInventoryFolderID varchar(255),
+        userInventoryURI varchar(255),
+        userAssetURI varchar(255),
+        profileCanDoMask integer,
+        profileWantDoMask integer,
+        profileAboutText varchar(255),
+        profileFirstText varchar(255),
+        profileImage varchar(255),
+        profileFirstImage varchar(255), 
+        webLoginKey text default '00000000-0000-0000-0000-000000000000');
+
+CREATE TABLE userfriends(
+        ownerID varchar(255),
+        friendID varchar(255),
+        friendPerms integer,
+        ownerPerms integer,
+        datetimestamp integer);
+
+COMMIT;