aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
diff options
context:
space:
mode:
authorJeff Ames2008-11-09 01:31:38 +0000
committerJeff Ames2008-11-09 01:31:38 +0000
commit8da726c3a8a3ab983fc11ad890a0b91016c86a1f (patch)
treea19c3a3a813bafedf876fb8943c7ef60ccbbb851 /OpenSim/Data/MSSQL/Resources/003_EstateStore.sql
parentReintroduce transactionID to the parameter list for SendInstantMessage. (diff)
downloadopensim-SC-8da726c3a8a3ab983fc11ad890a0b91016c86a1f.zip
opensim-SC-8da726c3a8a3ab983fc11ad890a0b91016c86a1f.tar.gz
opensim-SC-8da726c3a8a3ab983fc11ad890a0b91016c86a1f.tar.bz2
opensim-SC-8da726c3a8a3ab983fc11ad890a0b91016c86a1f.tar.xz
Update svn properties. Add copyright headers. Minor formatting cleanup.
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