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_RegionStore.sql | 242 ++++++++++++----------
 1 file changed, 132 insertions(+), 110 deletions(-)

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

diff --git a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
index 15f3d9f..39e8180 100644
--- a/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/001_RegionStore.sql
@@ -1,122 +1,144 @@
 BEGIN TRANSACTION;
 
 CREATE TABLE prims(
-        UUID varchar(255) primary key,
-        RegionUUID varchar(255),
-        ParentID integer,
-        CreationDate integer,
-        Name varchar(255),
-        SceneGroupID varchar(255),
-        Text varchar(255),
-        Description varchar(255),
-        SitName varchar(255),
-        TouchName varchar(255),
-        CreatorID varchar(255),
-        OwnerID varchar(255),
-        GroupID varchar(255),
-        LastOwnerID varchar(255),
-        OwnerMask integer,
-        NextOwnerMask integer,
-        GroupMask integer,
-        EveryoneMask integer,
-        BaseMask integer,
-        PositionX float,
-        PositionY float,
-        PositionZ float,
-        GroupPositionX float,
-        GroupPositionY float,
-        GroupPositionZ float,
-        VelocityX float,
-        VelocityY float,
-        VelocityZ float,
-        AngularVelocityX float,
-        AngularVelocityY float,
-        AngularVelocityZ float,
-        AccelerationX float,
-        AccelerationY float,
-        AccelerationZ float,
-        RotationX float,
-        RotationY float,
-        RotationZ float,
-        RotationW float, 
-        ObjectFlags integer, 
-        SitTargetOffsetX float NOT NULL default 0, 
-        SitTargetOffsetY float NOT NULL default 0, 
-        SitTargetOffsetZ float NOT NULL default 0, 
-        SitTargetOrientW float NOT NULL default 0, 
-        SitTargetOrientX float NOT NULL default 0, 
-        SitTargetOrientY float NOT NULL default 0, 
-        SitTargetOrientZ float NOT NULL default 0);
+       UUID varchar(255) primary key,
+       RegionUUID varchar(255),
+       ParentID integer,
+       CreationDate integer,
+       Name varchar(255),
+       SceneGroupID varchar(255),
+       Text varchar(255),
+       Description varchar(255),
+       SitName varchar(255),
+       TouchName varchar(255),
+       CreatorID varchar(255),
+       OwnerID varchar(255),
+       GroupID varchar(255),
+       LastOwnerID varchar(255),
+       OwnerMask integer,
+       NextOwnerMask integer,
+       GroupMask integer,
+       EveryoneMask integer,
+       BaseMask integer,
+       PositionX float,
+       PositionY float,
+       PositionZ float,
+       GroupPositionX float,
+       GroupPositionY float,
+       GroupPositionZ float,
+       VelocityX float,
+       VelocityY float,
+       VelocityZ float,
+       AngularVelocityX float,
+       AngularVelocityY float,
+       AngularVelocityZ float,
+       AccelerationX float,
+       AccelerationY float,
+       AccelerationZ float,
+       RotationX float,
+       RotationY float,
+       RotationZ float,
+       RotationW float, 
+       ObjectFlags integer, 
+       SitTargetOffsetX float NOT NULL default 0, 
+       SitTargetOffsetY float NOT NULL default 0, 
+       SitTargetOffsetZ float NOT NULL default 0, 
+       SitTargetOrientW float NOT NULL default 0, 
+       SitTargetOrientX float NOT NULL default 0, 
+       SitTargetOrientY float NOT NULL default 0, 
+       SitTargetOrientZ float NOT NULL default 0);
 
-CREATE TABLE primshapes(UUID varchar(255) primary key,
-        Shape integer,
-        ScaleX float,
-        ScaleY float,
-        ScaleZ float,
-        PCode integer,
-        PathBegin integer,
-        PathEnd integer,
-        PathScaleX integer,
-        PathScaleY integer,
-        PathShearX integer,
-        PathShearY integer,
-        PathSkew integer,
-        PathCurve integer,
-        PathRadiusOffset integer,
-        PathRevolutions integer,
-        PathTaperX integer,
-        PathTaperY integer,
-        PathTwist integer,
-        PathTwistBegin integer,
-        ProfileBegin integer,
-        ProfileEnd integer,
-        ProfileCurve integer,
-        ProfileHollow integer,
-        State integer,
-        Texture blob,
-        ExtraParams blob);
+CREATE TABLE primshapes(
+       UUID varchar(255) primary key,
+       Shape integer,
+       ScaleX float,
+       ScaleY float,
+       ScaleZ float,
+       PCode integer,
+       PathBegin integer,
+       PathEnd integer,
+       PathScaleX integer,
+       PathScaleY integer,
+       PathShearX integer,
+       PathShearY integer,
+       PathSkew integer,
+       PathCurve integer,
+       PathRadiusOffset integer,
+       PathRevolutions integer,
+       PathTaperX integer,
+       PathTaperY integer,
+       PathTwist integer,
+       PathTwistBegin integer,
+       ProfileBegin integer,
+       ProfileEnd integer,
+       ProfileCurve integer,
+       ProfileHollow integer,
+       Texture blob,
+       ExtraParams blob, 
+       State Integer NOT NULL default 0);
+
+CREATE TABLE primitems(
+       itemID varchar(255) primary key,
+       primID varchar(255),
+       assetID varchar(255),
+       parentFolderID varchar(255),
+       invType integer,
+       assetType integer,
+       name varchar(255),
+       description varchar(255),
+       creationDate integer,
+       creatorID varchar(255),
+       ownerID varchar(255),
+       lastOwnerID varchar(255),
+       groupID varchar(255),
+       nextPermissions string,
+       currentPermissions string,
+       basePermissions string,
+       everyonePermissions string,
+       groupPermissions string);
 
 CREATE TABLE terrain(
-        RegionUUID varchar(255),
-        Revision integer,
-        Heightfield blob);
+       RegionUUID varchar(255),
+       Revision integer,
+       Heightfield blob);
 
 CREATE TABLE land(
-        UUID varchar(255) primary key,
-        RegionUUID varchar(255),
-        LocalLandID string,
-        Bitmap blob,
-        Name varchar(255),
-        Desc varchar(255),
-        OwnerUUID varchar(36),
-        IsGroupOwned string,
-        Area integer,
-        AuctionID integer,
-        Category integer,
-        ClaimDate integer,
-        ClaimPrice integer,
-        GroupUUID varchar(255),
-        SalePrice integer,
-        LandStatus integer,
-        LandFlags string,
-        LandingType string,
-        MediaAutoScale string,
-        MediaTextureUUID varchar(255),
-        MediaURL varchar(255),
-        MusicURL varchar(255),
-        PassHours float,
-        PassPrice string,
-        SnapshotUUID varchar(255),
-        UserLocationX float,
-        UserLocationY float,
-        UserLocationZ float,    
-        UserLookAtX float,
-        UserLookAtY float,
-        UserLookAtZ float);
+       UUID varchar(255) primary key,
+       RegionUUID varchar(255),
+       LocalLandID string,
+       Bitmap blob,
+       Name varchar(255),
+       Desc varchar(255),
+       OwnerUUID varchar(255),
+       IsGroupOwned string,
+       Area integer,
+       AuctionID integer,
+       Category integer,
+       ClaimDate integer,
+       ClaimPrice integer,
+       GroupUUID varchar(255),
+       SalePrice integer,
+       LandStatus integer,
+       LandFlags string,
+       LandingType string,
+       MediaAutoScale string,
+       MediaTextureUUID varchar(255),
+       MediaURL varchar(255),
+       MusicURL varchar(255),
+       PassHours float,
+       PassPrice string,
+       SnapshotUUID varchar(255),
+       UserLocationX float,
+       UserLocationY float,
+       UserLocationZ float,
+       UserLookAtX float,
+       UserLookAtY float,
+       UserLookAtZ float, 
+       AuthbuyerID varchar(36) NOT NULL default  '00000000-0000-0000-0000-000000000000');
 
 CREATE TABLE landaccesslist(
-        LandUUID varchar(255),
-        AccessUUID varchar(255),
-        Flags string);
+       LandUUID varchar(255),
+       AccessUUID varchar(255),
+       Flags string);
 
 COMMIT;
-- 
cgit v1.1

