From 77894151485e4e6ad397cee85a551a4593e57cdd Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Fri, 25 Jan 2013 04:22:32 +0000
Subject: Fix tests by adding DynAttrs add column commands to
 RegionStore.migrations (these were originally in 021_RegionStore.sql which I
 might have forgotton to add 2 years ago).

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

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

diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index e872977..4c3c55d 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -575,3 +575,9 @@ CREATE TABLE `regionenvironment` (
 );
 
 COMMIT;
+
+:VERSION 27
+BEGIN;
+ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
+ALTER TABLE primshapes ADD COLUMN DynAttrs TEXT;
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1


From 7a139f8e5324c68c58249fc21e4ac78328cfa3bf Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Fri, 25 Jan 2013 04:35:06 +0000
Subject: Remove the accidental PrimShapes column that I added back to the
 SQLite region store

---
 OpenSim/Data/SQLite/Resources/RegionStore.migrations | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

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

diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index 4c3c55d..e583dc2 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -579,5 +579,4 @@ COMMIT;
 :VERSION 27
 BEGIN;
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
-ALTER TABLE primshapes ADD COLUMN DynAttrs TEXT;
-COMMIT;
\ No newline at end of file
+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/SQLite/Resources/RegionStore.migrations | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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

diff --git a/OpenSim/Data/SQLite/Resources/RegionStore.migrations b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
index e583dc2..c6f4b48 100644
--- a/OpenSim/Data/SQLite/Resources/RegionStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/RegionStore.migrations
@@ -580,3 +580,15 @@ COMMIT;
 BEGIN;
 ALTER TABLE prims ADD COLUMN DynAttrs TEXT;
 COMMIT;
+
+:VERSION 28
+
+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