diff options
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/003_InventoryStore.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/003_InventoryStore.sql | 38 |
1 files changed, 0 insertions, 38 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/003_InventoryStore.sql b/OpenSim/Data/MSSQL/Resources/003_InventoryStore.sql deleted file mode 100644 index 2f623ec..0000000 --- a/OpenSim/Data/MSSQL/Resources/003_InventoryStore.sql +++ /dev/null | |||
@@ -1,38 +0,0 @@ | |||
1 | /* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/ | ||
2 | BEGIN TRANSACTION | ||
3 | |||
4 | CREATE TABLE dbo.Tmp_inventoryfolders | ||
5 | ( | ||
6 | folderID uniqueidentifier NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'), | ||
7 | agentID uniqueidentifier NULL DEFAULT (NULL), | ||
8 | parentFolderID uniqueidentifier NULL DEFAULT (NULL), | ||
9 | folderName varchar(64) NULL DEFAULT (NULL), | ||
10 | type smallint NOT NULL DEFAULT ((0)), | ||
11 | version int NOT NULL DEFAULT ((0)) | ||
12 | ) ON [PRIMARY] | ||
13 | |||
14 | IF EXISTS(SELECT * FROM dbo.inventoryfolders) | ||
15 | EXEC('INSERT INTO dbo.Tmp_inventoryfolders (folderID, agentID, parentFolderID, folderName, type, version) | ||
16 | SELECT CONVERT(uniqueidentifier, folderID), CONVERT(uniqueidentifier, agentID), CONVERT(uniqueidentifier, parentFolderID), folderName, type, version FROM dbo.inventoryfolders WITH (HOLDLOCK TABLOCKX)') | ||
17 | |||
18 | DROP TABLE dbo.inventoryfolders | ||
19 | |||
20 | EXECUTE sp_rename N'dbo.Tmp_inventoryfolders', N'inventoryfolders', 'OBJECT' | ||
21 | |||
22 | ALTER TABLE dbo.inventoryfolders ADD CONSTRAINT | ||
23 | PK__inventor__C2FABFB3173876EA PRIMARY KEY CLUSTERED | ||
24 | ( | ||
25 | folderID | ||
26 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
27 | |||
28 | CREATE NONCLUSTERED INDEX owner ON dbo.inventoryfolders | ||
29 | ( | ||
30 | agentID | ||
31 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
32 | |||
33 | CREATE NONCLUSTERED INDEX parent ON dbo.inventoryfolders | ||
34 | ( | ||
35 | parentFolderID | ||
36 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
37 | |||
38 | COMMIT | ||