From c52c68f314c67c76c7181a6d0828f476290fbd66 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 2 Apr 2008 15:24:31 +0000
Subject: whole lot more moving

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

(limited to 'OpenSim/Data/SQLite/Resources/001_UserStore.sql')

diff --git a/OpenSim/Data/SQLite/Resources/001_UserStore.sql b/OpenSim/Data/SQLite/Resources/001_UserStore.sql
new file mode 100644
index 0000000..070e340
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/001_UserStore.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