aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-07-02 16:20:54 +0000
committerJustin Clarke Casey2008-07-02 16:20:54 +0000
commit9052c43319ab69f57b80e363d965780be625b0e2 (patch)
tree3e17e9c0908be54ecb01ddff824d6c1a32020e88 /OpenSim/Data/MSSQL/Resources/CreateAssetsTable.sql
parentMantis#1647. Thank you kindly, Sempuki for a patch that: (diff)
downloadopensim-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.sql1
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,