diff options
| author | Jeff Ames | 2008-07-03 03:01:02 +0000 |
|---|---|---|
| committer | Jeff Ames | 2008-07-03 03:01:02 +0000 |
| commit | fde6983cce7a6501facba9a3f6d9b86f4dcac8e5 (patch) | |
| tree | c1f5802581d547fc80646b7f2730d51a8715dd84 /OpenSim/Data | |
| parent | *Parcel Claim date is no longer Epoch (Jan 1, 1970). Now shows the actual cre... (diff) | |
| download | opensim-SC-fde6983cce7a6501facba9a3f6d9b86f4dcac8e5.zip opensim-SC-fde6983cce7a6501facba9a3f6d9b86f4dcac8e5.tar.gz opensim-SC-fde6983cce7a6501facba9a3f6d9b86f4dcac8e5.tar.bz2 opensim-SC-fde6983cce7a6501facba9a3f6d9b86f4dcac8e5.tar.xz | |
Update svn properties.
Diffstat (limited to 'OpenSim/Data')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/004_AssetStore.sql | 10 | ||||
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/002_AssetStore.sql | 20 |
2 files changed, 15 insertions, 15 deletions
diff --git a/OpenSim/Data/MySQL/Resources/004_AssetStore.sql b/OpenSim/Data/MySQL/Resources/004_AssetStore.sql index 9e9b9fe..ae1951d 100644 --- a/OpenSim/Data/MySQL/Resources/004_AssetStore.sql +++ b/OpenSim/Data/MySQL/Resources/004_AssetStore.sql | |||
| @@ -1,5 +1,5 @@ | |||
| 1 | BEGIN; | 1 | BEGIN; |
| 2 | 2 | ||
| 3 | ALTER TABLE assets drop InvType; | 3 | ALTER TABLE assets drop InvType; |
| 4 | 4 | ||
| 5 | COMMIT; | 5 | COMMIT; |
diff --git a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql b/OpenSim/Data/SQLite/Resources/002_AssetStore.sql index 41ca640..5339b84 100644 --- a/OpenSim/Data/SQLite/Resources/002_AssetStore.sql +++ b/OpenSim/Data/SQLite/Resources/002_AssetStore.sql | |||
| @@ -1,10 +1,10 @@ | |||
| 1 | BEGIN TRANSACTION; | 1 | BEGIN TRANSACTION; |
| 2 | 2 | ||
| 3 | CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); | 3 | CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data); |
| 4 | INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; | 4 | INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets; |
| 5 | DROP TABLE assets; | 5 | DROP TABLE assets; |
| 6 | CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); | 6 | CREATE TABLE assets(UUID,Name,Description,Type,Local,Temporary,Data); |
| 7 | INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; | 7 | INSERT INTO assets SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup; |
| 8 | DROP TABLE assets_backup; | 8 | DROP TABLE assets_backup; |
| 9 | 9 | ||
| 10 | COMMIT; | 10 | COMMIT; |