aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/003_EstateStore.sql')
-rw-r--r--OpenSim/Data/MSSQL/Resources/003_EstateStore.sql50
1 files changed, 25 insertions, 25 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql b/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
index 7dd0ec8..120966a 100644
--- a/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
@@ -1,25 +1,25 @@
1BEGIN TRANSACTION 1BEGIN TRANSACTION
2 2
3CREATE TABLE dbo.Tmp_estateban 3CREATE TABLE dbo.Tmp_estateban
4 ( 4 (
5 EstateID int NOT NULL, 5 EstateID int NOT NULL,
6 bannedUUID varchar(36) NOT NULL, 6 bannedUUID varchar(36) NOT NULL,
7 bannedIp varchar(16) NULL, 7 bannedIp varchar(16) NULL,
8 bannedIpHostMask varchar(16) NULL, 8 bannedIpHostMask varchar(16) NULL,
9 bannedNameMask varchar(64) NULL 9 bannedNameMask varchar(64) NULL
10 ) ON [PRIMARY] 10 ) ON [PRIMARY]
11 11
12IF EXISTS(SELECT * FROM dbo.estateban) 12IF EXISTS(SELECT * FROM dbo.estateban)
13 EXEC('INSERT INTO dbo.Tmp_estateban (EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask) 13 EXEC('INSERT INTO dbo.Tmp_estateban (EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask)
14 SELECT EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask FROM dbo.estateban') 14 SELECT EstateID, bannedUUID, bannedIp, bannedIpHostMask, bannedNameMask FROM dbo.estateban')
15 15
16DROP TABLE dbo.estateban 16DROP TABLE dbo.estateban
17 17
18EXECUTE sp_rename N'dbo.Tmp_estateban', N'estateban', 'OBJECT' 18EXECUTE sp_rename N'dbo.Tmp_estateban', N'estateban', 'OBJECT'
19 19
20CREATE NONCLUSTERED INDEX IX_estateban ON dbo.estateban 20CREATE NONCLUSTERED INDEX IX_estateban ON dbo.estateban
21 ( 21 (
22 EstateID 22 EstateID
23 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 23 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
24 24
25COMMIT 25COMMIT