From b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 9 May 2010 13:39:56 -0700
Subject: * Fixed spamming the assets table with map tiles. The tile image ID
 is now stored in regionsettings. Upon generation of a new tile image, the old
 one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug
 with map search where the local sim regions weren't found.

---
 OpenSim/Data/SQLite/Resources/005_AssetStore.sql  | 5 +++++
 OpenSim/Data/SQLite/Resources/019_RegionStore.sql | 5 +++++
 2 files changed, 10 insertions(+)
 create mode 100644 OpenSim/Data/SQLite/Resources/005_AssetStore.sql
 create mode 100644 OpenSim/Data/SQLite/Resources/019_RegionStore.sql

(limited to 'OpenSim/Data/SQLite/Resources')

diff --git a/OpenSim/Data/SQLite/Resources/005_AssetStore.sql b/OpenSim/Data/SQLite/Resources/005_AssetStore.sql
new file mode 100644
index 0000000..f06121a
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/005_AssetStore.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0;
+
+COMMIT;
diff --git a/OpenSim/Data/SQLite/Resources/019_RegionStore.sql b/OpenSim/Data/SQLite/Resources/019_RegionStore.sql
new file mode 100644
index 0000000..d62f848
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/019_RegionStore.sql
@@ -0,0 +1,5 @@
+BEGIN;
+
+ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000';
+  
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1