diff options
| author | Diva Canto | 2010-05-09 13:39:56 -0700 |
|---|---|---|
| committer | Diva Canto | 2010-05-09 13:39:56 -0700 |
| commit | b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb (patch) | |
| tree | 0f895f8334a1f98f3ed9f273906f989314400ce5 /OpenSim/Data/SQLite/Resources | |
| parent | Add Delete handler to SQLite (NG) (diff) | |
| download | opensim-SC_OLD-b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb.zip opensim-SC_OLD-b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb.tar.gz opensim-SC_OLD-b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb.tar.bz2 opensim-SC_OLD-b233a4b2cab3a39f9edc17130cd7c2f2f807d6bb.tar.xz | |
* 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.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/005_AssetStore.sql | 5 | ||||
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/019_RegionStore.sql | 5 |
2 files changed, 10 insertions, 0 deletions
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 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0; | ||
| 4 | |||
| 5 | 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 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE regionsettings ADD COLUMN map_tile_ID varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; | ||
| 4 | |||
| 5 | COMMIT; \ No newline at end of file | ||