From 12173034d94e7deb245bb7e3d1bf8099432ec3b8 Mon Sep 17 00:00:00 2001
From: Melanie Thielker
Date: Mon, 14 Jul 2008 01:29:48 +0000
Subject: Patch #9148 Patch 5 in the region settings series. Adds a migration
 to ensure corrupted data is purged and re-read from defaults. Some changes.
 Still no full functionality

---
 OpenSim/Data/MySQL/Resources/010_RegionStore.sql  | 9 +++++++++
 OpenSim/Data/SQLite/Resources/005_RegionStore.sql | 5 +++++
 2 files changed, 14 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/010_RegionStore.sql
 create mode 100644 OpenSim/Data/SQLite/Resources/005_RegionStore.sql

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MySQL/Resources/010_RegionStore.sql b/OpenSim/Data/MySQL/Resources/010_RegionStore.sql
new file mode 100644
index 0000000..031a746
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/010_RegionStore.sql
@@ -0,0 +1,9 @@
+# 1 "010_RegionStore.sql"
+# 1 "<built-in>"
+# 1 "<command line>"
+# 1 "010_RegionStore.sql"
+BEGIN;
+
+DELETE FROM regionsettings;
+
+COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/005_RegionStore.sql b/OpenSim/Data/SQLite/Resources/005_RegionStore.sql
new file mode 100644
index 0000000..1f6d1bd
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/005_RegionStore.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+delete from regionsettings;
+
+COMMIT;
-- 
cgit v1.1