From 68b98aecab0906f6c55f8c567552fb39a3bda1a2 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Wed, 11 Jun 2008 20:04:01 +0000
Subject: updated resources for current sqlite schema for migrations

---
 OpenSim/Data/SQLite/Resources/001_UserStore.sql | 64 +++++++++++++------------
 1 file changed, 33 insertions(+), 31 deletions(-)

(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
index 070e340..b584594 100644
--- a/OpenSim/Data/SQLite/Resources/001_UserStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_UserStore.sql
@@ -1,37 +1,39 @@
 BEGIN TRANSACTION;
 
+-- users table
 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');
-
+       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');
+-- friends table
 CREATE TABLE userfriends(
-        ownerID varchar(255),
-        friendID varchar(255),
-        friendPerms integer,
-        ownerPerms integer,
-        datetimestamp integer);
+       ownerID varchar(255),
+       friendID varchar(255),
+       friendPerms integer,
+       ownerPerms integer,
+       datetimestamp integer);
 
 COMMIT;
+
-- 
cgit v1.1