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/AssetStore_001.sql | 13 +++ .../Data.SQLite/Resources/InventoryStore_001.sql | 26 +++++ .../Data.SQLite/Resources/RegionStore_001.sql | 121 +++++++++++++++++++++ .../Data.SQLite/Resources/UserStore_001.sql | 37 +++++++ 4 files changed, 197 insertions(+) create mode 100644 OpenSim/Framework/Data.SQLite/Resources/AssetStore_001.sql create mode 100644 OpenSim/Framework/Data.SQLite/Resources/InventoryStore_001.sql create mode 100644 OpenSim/Framework/Data.SQLite/Resources/RegionStore_001.sql create mode 100644 OpenSim/Framework/Data.SQLite/Resources/UserStore_001.sql (limited to 'OpenSim') 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; -- cgit v1.1