diff options
| author | Justin Clarke Casey | 2008-07-02 16:20:54 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2008-07-02 16:20:54 +0000 |
| commit | 9052c43319ab69f57b80e363d965780be625b0e2 (patch) | |
| tree | 3e17e9c0908be54ecb01ddff824d6c1a32020e88 /OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql | |
| parent | Mantis#1647. Thank you kindly, Sempuki for a patch that: (diff) | |
| download | opensim-SC_OLD-9052c43319ab69f57b80e363d965780be625b0e2.zip opensim-SC_OLD-9052c43319ab69f57b80e363d965780be625b0e2.tar.gz opensim-SC_OLD-9052c43319ab69f57b80e363d965780be625b0e2.tar.bz2 opensim-SC_OLD-9052c43319ab69f57b80e363d965780be625b0e2.tar.xz | |
* Drop InvType from the assets table since it is no longer used
* Migration should be automatic on sqlite and mysql
* Migration is not automatic on mssql, you will need to drop the invType column manually
* Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql')
| -rw-r--r-- | OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql b/OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql index c7cb21a..4d94699 100644 --- a/OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql +++ b/OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql | |||
| @@ -6,7 +6,6 @@ CREATE TABLE [assets] ( | |||
| 6 | [name] [varchar](64) NOT NULL, | 6 | [name] [varchar](64) NOT NULL, |
| 7 | [description] [varchar](64) NOT NULL, | 7 | [description] [varchar](64) NOT NULL, |
| 8 | [assetType] [tinyint] NOT NULL, | 8 | [assetType] [tinyint] NOT NULL, |
| 9 | [invType] [tinyint] NOT NULL, | ||
| 10 | [local] [tinyint] NOT NULL, | 9 | [local] [tinyint] NOT NULL, |
| 11 | [temporary] [tinyint] NOT NULL, | 10 | [temporary] [tinyint] NOT NULL, |
| 12 | [data] [image] NOT NULL, | 11 | [data] [image] NOT NULL, |