From a3e1e6dd611a179eb2d894a45ae45ef278ae2e85 Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Mon, 16 Aug 2010 21:57:08 +0100
Subject: Implement dynamic attribute persistence on mysql and mssql

mssql is untested
---
 OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')

diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
index 350e548..5e88e36 100644
--- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
@@ -1148,3 +1148,12 @@ CREATE TABLE [dbo].[regionenvironment](
 ) ON [PRIMARY]
 
 COMMIT
+
+:VERSION 38       #---------------- Dynamic attributes
+
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
+ALTER TABLE primshapes ADD COLUMN DynAttrs TEXT;
+
+COMMIT
-- 
cgit v1.1


From fdec05a15ef126f344c03427e9ef264b4248646b Mon Sep 17 00:00:00 2001
From: Oren Hurvitz
Date: Tue, 22 Jan 2013 08:49:36 +0200
Subject: Stopped storing dynamic attributes in the PrimShape

---
 OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 1 -
 1 file changed, 1 deletion(-)

(limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')

diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
index 5e88e36..92cc38a 100644
--- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
@@ -1154,6 +1154,5 @@ COMMIT
 BEGIN TRANSACTION
 
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
-ALTER TABLE primshapes ADD COLUMN DynAttrs TEXT;
 
 COMMIT
-- 
cgit v1.1


From 85b81ff7f20334ebe50a5a33e41060fdcbd69d65 Mon Sep 17 00:00:00 2001
From: Oren Hurvitz
Date: Thu, 7 Feb 2013 08:23:57 +0200
Subject: Added physics parameters support to MSSQL and SQLite (not tested)

---
 OpenSim/Data/MSSQL/Resources/RegionStore.migrations | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'OpenSim/Data/MSSQL/Resources/RegionStore.migrations')

diff --git a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
index 92cc38a..b84c2a4 100644
--- a/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MSSQL/Resources/RegionStore.migrations
@@ -1156,3 +1156,15 @@ BEGIN TRANSACTION
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
 
 COMMIT
+
+:VERSION 39       #---------------- Extra physics params
+
+BEGIN TRANSACTION
+
+ALTER TABLE prims ADD COLUMN `PhysicsShapeType` tinyint(4) NOT NULL default '0';
+ALTER TABLE prims ADD COLUMN `Density` double NOT NULL default '1000';
+ALTER TABLE prims ADD COLUMN `GravityModifier` double NOT NULL default '1';
+ALTER TABLE prims ADD COLUMN `Friction` double NOT NULL default '0.6';
+ALTER TABLE prims ADD COLUMN `Restitution` double NOT NULL default '0.5';
+
+COMMIT
-- 
cgit v1.1