diff options
| author | AlexRa | 2010-05-19 10:28:10 +0300 |
|---|---|---|
| committer | AlexRa | 2010-05-23 11:47:48 +0300 |
| commit | 187a98615bd73a0a21b66e7137658939fe4664e2 (patch) | |
| tree | a48fdd005d8d3b5e9d6dbff2dae3eac8e582f2ae /OpenSim/Data/MSSQL/Resources/AssetStore.migrations | |
| parent | MSSQLAssetData updated to support [CreatorID], [asset_flags] (diff) | |
| download | opensim-SC_OLD-187a98615bd73a0a21b66e7137658939fe4664e2.zip opensim-SC_OLD-187a98615bd73a0a21b66e7137658939fe4664e2.tar.gz opensim-SC_OLD-187a98615bd73a0a21b66e7137658939fe4664e2.tar.bz2 opensim-SC_OLD-187a98615bd73a0a21b66e7137658939fe4664e2.tar.xz | |
MSSQL: added asset_flags, CreatorID to migrations
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/AssetStore.migrations')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/AssetStore.migrations | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/AssetStore.migrations b/OpenSim/Data/MSSQL/Resources/AssetStore.migrations index beb82b9..8664ce9 100644 --- a/OpenSim/Data/MSSQL/Resources/AssetStore.migrations +++ b/OpenSim/Data/MSSQL/Resources/AssetStore.migrations | |||
| @@ -97,4 +97,10 @@ COMMIT | |||
| 97 | 97 | ||
| 98 | DELETE FROM assets WHERE id = 'dc4b9f0b-d008-45c6-96a4-01dd947ac621'; | 98 | DELETE FROM assets WHERE id = 'dc4b9f0b-d008-45c6-96a4-01dd947ac621'; |
| 99 | 99 | ||
| 100 | :VERSION 6 | ||
| 100 | 101 | ||
| 102 | ALTER TABLE assets ADD asset_flags INTEGER NOT NULL DEFAULT 0; | ||
| 103 | |||
| 104 | :VERSION 7 | ||
| 105 | |||
| 106 | alter table assets add creatorid varchar(36) not null default ''; | ||