From 13736995d2a169f35ef9678f53275eb4b5c8ece0 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Thu, 10 Jan 2008 19:38:37 +0000
Subject: add sqlite database definitions as Resources for SQLite.dll

---
 .../Data.SQLite/Resources/UserStore_001.sql        | 37 ++++++++++++++++++++++
 1 file changed, 37 insertions(+)
 create mode 100644 OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql

(limited to 'OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql')

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;
-- 
cgit v1.1