aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/Resources/002_EstateStore.sql50
-rw-r--r--OpenSim/Data/MSSQL/Resources/003_EstateStore.sql50
2 files changed, 50 insertions, 50 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/002_EstateStore.sql b/OpenSim/Data/MSSQL/Resources/002_EstateStore.sql
index 86c5cb6..18c12c0 100644
--- a/OpenSim/Data/MSSQL/Resources/002_EstateStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/002_EstateStore.sql
@@ -1,25 +1,25 @@
1BEGIN TRANSACTION 1BEGIN TRANSACTION
2 2
3ALTER TABLE dbo.estate_managers DROP CONSTRAINT PK_estate_managers 3ALTER TABLE dbo.estate_managers DROP CONSTRAINT PK_estate_managers
4 4
5CREATE NONCLUSTERED INDEX IX_estate_managers ON dbo.estate_managers 5CREATE NONCLUSTERED INDEX IX_estate_managers ON dbo.estate_managers
6 ( 6 (
7 EstateID 7 EstateID
8 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 8 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
9 9
10ALTER TABLE dbo.estate_groups DROP CONSTRAINT PK_estate_groups 10ALTER TABLE dbo.estate_groups DROP CONSTRAINT PK_estate_groups
11 11
12CREATE NONCLUSTERED INDEX IX_estate_groups ON dbo.estate_groups 12CREATE NONCLUSTERED INDEX IX_estate_groups ON dbo.estate_groups
13 ( 13 (
14 EstateID 14 EstateID
15 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 15 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
16 16
17 17
18ALTER TABLE dbo.estate_users DROP CONSTRAINT PK_estate_users 18ALTER TABLE dbo.estate_users DROP CONSTRAINT PK_estate_users
19 19
20CREATE NONCLUSTERED INDEX IX_estate_users ON dbo.estate_users 20CREATE NONCLUSTERED INDEX IX_estate_users ON dbo.estate_users
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
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