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/MySQL/Resources/RegionStore.migrations | 9 +++++++++
 1 file changed, 9 insertions(+)

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

diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 5b59779..1a38836 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -902,3 +902,12 @@ BEGIN;
 CREATE TABLE `regionextra` (`RegionID` char(36) not null, `Name` varchar(32) not null, `value` text, primary key(`RegionID`, `Name`));
 
 COMMIT;
+
+:VERSION 46       #---------------- Dynamic attributes
+
+BEGIN;
+
+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/MySQL/Resources/RegionStore.migrations | 1 -
 1 file changed, 1 deletion(-)

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

diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index 1a38836..c48aec2 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -908,6 +908,5 @@ COMMIT;
 BEGIN;
 
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
-ALTER TABLE primshapes ADD COLUMN DynAttrs TEXT;
 
 COMMIT;
-- 
cgit v1.1


From e5beb480eaf23fa7454728724de80b2a67ded1e8 Mon Sep 17 00:00:00 2001
From: Melanie
Date: Wed, 6 Feb 2013 08:03:04 +0000
Subject: Partial port of Avination's support for the new physics parameters.
 Implements the parameters as properties, the serialization and database
 storage (MySQL only). Implements llSetPrimitiveParams for prim physics shape
 and the other 4 extra params. Only the prim shape type "None" is currently
 functional. No support for the Viewer UI (yet), that will be ported in due
 course. Lots more to port, this is a large-ish changeset.

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

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

diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index c48aec2..48cd60b 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -910,3 +910,16 @@ BEGIN;
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
 
 COMMIT;
+
+:VERSION 47       #---------------- Extra prim params
+
+BEGIN;
+
+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