1 files changed, 0 insertions, 106 deletions

diff --git a/OpenSim/Data/MSSQL/Resources/AssetStore.migrations b/OpenSim/Data/MSSQL/Resources/AssetStore.migrations
deleted file mode 100644
index 8664ce9..0000000
--- a/OpenSim/Data/MSSQL/Resources/AssetStore.migrations
+++ /dev/null
@@ -1,106 +0,0 @@
-:VERSION 1
-
-CREATE TABLE [assets] (
-  [id] [varchar](36) NOT NULL,
-  [name] [varchar](64) NOT NULL,
-  [description] [varchar](64) NOT NULL,
-  [assetType] [tinyint] NOT NULL,
-  [local] [tinyint] NOT NULL,
-  [temporary] [tinyint] NOT NULL,
-  [data] [image] NOT NULL,
-PRIMARY KEY CLUSTERED 
-(
-        [id] ASC
-)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
-) ON [PRIMARY]
-
-
-:VERSION 2
-
-BEGIN TRANSACTION
-
-CREATE TABLE Tmp_assets
-        (
-        id varchar(36) NOT NULL,
-        name varchar(64) NOT NULL,
-        description varchar(64) NOT NULL,
-        assetType tinyint NOT NULL,
-        local bit NOT NULL,
-        temporary bit NOT NULL,
-        data image NOT NULL
-        )  ON [PRIMARY]
-         TEXTIMAGE_ON [PRIMARY]
-
-IF EXISTS(SELECT * FROM assets)
-         EXEC('INSERT INTO Tmp_assets (id, name, description, assetType, local, temporary, data)
-                SELECT id, name, description, assetType, CONVERT(bit, local), CONVERT(bit, temporary), data FROM assets WITH (HOLDLOCK TABLOCKX)')
-
-DROP TABLE assets
-
-EXECUTE sp_rename N'Tmp_assets', N'assets', 'OBJECT' 
-
-ALTER TABLE dbo.assets ADD CONSTRAINT
-        PK__assets__id PRIMARY KEY CLUSTERED 
-        (
-        id
-        ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-
-COMMIT
-
-
-:VERSION 3
-
-BEGIN TRANSACTION
-
-ALTER TABLE assets add create_time integer default 0
-ALTER TABLE assets add access_time integer default 0
-
-COMMIT
-
-
-:VERSION 4
-
-BEGIN TRANSACTION
-
-CREATE TABLE dbo.Tmp_assets
-        (
-        id uniqueidentifier NOT NULL,
-        name varchar(64) NOT NULL,
-        description varchar(64) NOT NULL,
-        assetType tinyint NOT NULL,
-        local bit NOT NULL,
-        temporary bit NOT NULL,
-        data image NOT NULL,
-        create_time int NULL,
-        access_time int NULL
-        )  ON [PRIMARY]
-         TEXTIMAGE_ON [PRIMARY]
-
-IF EXISTS(SELECT * FROM dbo.assets)
-         EXEC('INSERT INTO dbo.Tmp_assets (id, name, description, assetType, local, temporary, data, create_time, access_time)
-                SELECT CONVERT(uniqueidentifier, id), name, description, assetType, local, temporary, data, create_time, access_time FROM dbo.assets WITH (HOLDLOCK TABLOCKX)')
-
-DROP TABLE assets
-
-EXECUTE sp_rename N'Tmp_assets', N'assets', 'OBJECT' 
-
-ALTER TABLE dbo.assets ADD CONSTRAINT
-        PK__assets__id PRIMARY KEY CLUSTERED 
-        (
-        id
-        ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-
-COMMIT
-
-
-:VERSION 5
-
-DELETE FROM assets WHERE id = 'dc4b9f0b-d008-45c6-96a4-01dd947ac621';
-
-:VERSION 6
-
-ALTER TABLE assets ADD asset_flags INTEGER NOT NULL DEFAULT 0;
-
-:VERSION 7
-
-alter table assets add creatorid varchar(36) not null default '';