aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/AssetStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-19 10:07:48 +0300
committerAlexRa2010-05-19 21:49:30 +0300
commitaccf8c420de3b77f80e35c848291b2bb358f6a14 (patch)
tree4c0e79a79d91af86ac4f14def140638990cc012c /OpenSim/Data/SQLite/Resources/AssetStore.migrations
parentAdded CreatorID to SQLite asset data (diff)
downloadopensim-SC_OLD-accf8c420de3b77f80e35c848291b2bb358f6a14.zip
opensim-SC_OLD-accf8c420de3b77f80e35c848291b2bb358f6a14.tar.gz
opensim-SC_OLD-accf8c420de3b77f80e35c848291b2bb358f6a14.tar.bz2
opensim-SC_OLD-accf8c420de3b77f80e35c848291b2bb358f6a14.tar.xz
SQLite: CreatorID added (and asset_flags moved) to the migration script
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/AssetStore.migrations')
-rw-r--r--OpenSim/Data/SQLite/Resources/AssetStore.migrations24
1 files changed, 24 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/AssetStore.migrations b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
index fb72b91..bc11e13 100644
--- a/OpenSim/Data/SQLite/Resources/AssetStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/AssetStore.migrations
@@ -40,3 +40,27 @@ update assets
40 40
41COMMIT; 41COMMIT;
42 42
43:VERSION 5
44
45BEGIN TRANSACTION;
46
47CREATE TEMPORARY TABLE assets_backup(UUID,Name,Description,Type,Local,Temporary,Data);
48INSERT INTO assets_backup SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets;
49DROP TABLE assets;
50CREATE TABLE assets(
51 UUID NOT NULL PRIMARY KEY,
52 Name,
53 Description,
54 Type,
55 Local,
56 Temporary,
57 asset_flags INTEGER NOT NULL DEFAULT 0,
58 CreatorID varchar(36) default '',
59 Data);
60
61INSERT INTO assets(UUID,Name,Description,Type,Local,Temporary,Data)
62SELECT UUID,Name,Description,Type,Local,Temporary,Data FROM assets_backup;
63DROP TABLE assets_backup;
64
65COMMIT;
66