add sqlite database definitions as Resources for SQLite.dll

4 files changed, 197 insertions, 0 deletions

diff --git a/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql
new file mode 100644
index 0000000..1dc05d8
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql
@@ -0,0 +1,13 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE assets(
+        UUID varchar(255) primary key,
+        Name varchar(255),
+        Description varchar(255),
+        Type integer,
+        InvType integer,
+        Local integer,
+        Temporary integer,
+        Data blob);
+
+COMMIT;
diff --git a/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql
new file mode 100644
index 0000000..e4951b0
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql
@@ -0,0 +1,26 @@
+BEGIN TRANSACTION;
+
+CREATE TABLE inventoryitems(
+        UUID varchar(255) primary key,
+        assetID varchar(255),
+        assetType integer,
+        invType integer,
+        parentFolderID varchar(255),
+        avatarID varchar(255),
+        creatorsID varchar(255),
+        inventoryName varchar(255),
+        inventoryDescription varchar(255),
+        inventoryNextPermissions integer,
+        inventoryCurrentPermissions integer,
+        inventoryBasePermissions integer,
+        inventoryEveryOnePermissions integer);
+
+CREATE TABLE inventoryfolders(
+        UUID varchar(255) primary key,
+        name varchar(255),
+        agentID varchar(255),
+        parentID varchar(255),
+        type integer,
+        version integer);
+
+COMMIT;
diff --git a/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql b/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql
new file mode 100644
index 0000000..1db8ba8
--- /dev/null
+++ b/OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql
@@ -0,0 +1,121 @@
+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);
+
+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);
+
+CREATE TABLE terrain(
+        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(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);
+
+CREATE TABLE landaccesslist(
+        LandUUID varchar(255),
+        AccessUUID varchar(255),
+        Flags string);
+
+COMMIT;
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;