diff options
author | Justin Clarke Casey | 2008-09-29 20:26:34 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2008-09-29 20:26:34 +0000 |
commit | 464c3c709102954e502a5d3868bac615c73c64b4 (patch) | |
tree | e9d9ab1eded503268cf379ed8bcd8d2853095105 | |
parent | Mantis#2299. Thank you kindly, Idb for a patch that: (diff) | |
download | opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.zip opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.gz opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.bz2 opensim-SC_OLD-464c3c709102954e502a5d3868bac615c73c64b4.tar.xz |
* Add missing mssql migration files from http://opensimulator.org/mantis/view.php?id=2295
* Sorry about that
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/001_LogStore.sql | 17 | ||||
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/002_GridStore.sql | 49 | ||||
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | 10 |
3 files changed, 76 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/001_LogStore.sql b/OpenSim/Data/MSSQL/Resources/001_LogStore.sql new file mode 100644 index 0000000..9ece627 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/001_LogStore.sql | |||
@@ -0,0 +1,17 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE [logs] ( | ||
4 | [logID] [int] NOT NULL, | ||
5 | [target] [varchar](36) default NULL, | ||
6 | [server] [varchar](64) default NULL, | ||
7 | [method] [varchar](64) default NULL, | ||
8 | [arguments] [varchar](255) default NULL, | ||
9 | [priority] [int] default NULL, | ||
10 | [message] [ntext], | ||
11 | PRIMARY KEY CLUSTERED | ||
12 | ( | ||
13 | [logID] ASC | ||
14 | )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
15 | ) ON [PRIMARY] | ||
16 | |||
17 | COMMIT | ||
diff --git a/OpenSim/Data/MSSQL/Resources/002_GridStore.sql b/OpenSim/Data/MSSQL/Resources/002_GridStore.sql new file mode 100644 index 0000000..f5901cb --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/002_GridStore.sql | |||
@@ -0,0 +1,49 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE Tmp_regions | ||
4 | ( | ||
5 | uuid varchar(36) COLLATE Latin1_General_CI_AS NOT NULL, | ||
6 | regionHandle bigint NULL, | ||
7 | regionName varchar(20) NULL, | ||
8 | regionRecvKey varchar(128) NULL, | ||
9 | regionSendKey varchar(128) NULL, | ||
10 | regionSecret varchar(128) NULL, | ||
11 | regionDataURI varchar(128) NULL, | ||
12 | serverIP varchar(64) NULL, | ||
13 | serverPort int NULL, | ||
14 | serverURI varchar(255) NULL, | ||
15 | locX int NULL, | ||
16 | locY int NULL, | ||
17 | locZ int NULL, | ||
18 | eastOverrideHandle bigint NULL, | ||
19 | westOverrideHandle bigint NULL, | ||
20 | southOverrideHandle bigint NULL, | ||
21 | northOverrideHandle bigint NULL, | ||
22 | regionAssetURI varchar(255) NULL, | ||
23 | regionAssetRecvKey varchar(128) NULL, | ||
24 | regionAssetSendKey varchar(128) NULL, | ||
25 | regionUserURI varchar(255) NULL, | ||
26 | regionUserRecvKey varchar(128) NULL, | ||
27 | regionUserSendKey varchar(128) NULL, | ||
28 | regionMapTexture varchar(36) NULL, | ||
29 | serverHttpPort int NULL, | ||
30 | serverRemotingPort int NULL, | ||
31 | owner_uuid varchar(36) NULL, | ||
32 | originUUID varchar(36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000') | ||
33 | ) ON [PRIMARY] | ||
34 | |||
35 | IF EXISTS(SELECT * FROM regions) | ||
36 | EXEC('INSERT INTO Tmp_regions (uuid, regionHandle, regionName, regionRecvKey, regionSendKey, regionSecret, regionDataURI, serverIP, serverPort, serverURI, locX, locY, locZ, eastOverrideHandle, westOverrideHandle, southOverrideHandle, northOverrideHandle, regionAssetURI, regionAssetRecvKey, regionAssetSendKey, regionUserURI, regionUserRecvKey, regionUserSendKey, regionMapTexture, serverHttpPort, serverRemotingPort, owner_uuid) | ||
37 | SELECT CONVERT(varchar(36), uuid), CONVERT(bigint, regionHandle), CONVERT(varchar(20), regionName), CONVERT(varchar(128), regionRecvKey), CONVERT(varchar(128), regionSendKey), CONVERT(varchar(128), regionSecret), CONVERT(varchar(128), regionDataURI), CONVERT(varchar(64), serverIP), CONVERT(int, serverPort), serverURI, CONVERT(int, locX), CONVERT(int, locY), CONVERT(int, locZ), CONVERT(bigint, eastOverrideHandle), CONVERT(bigint, westOverrideHandle), CONVERT(bigint, southOverrideHandle), CONVERT(bigint, northOverrideHandle), regionAssetURI, CONVERT(varchar(128), regionAssetRecvKey), CONVERT(varchar(128), regionAssetSendKey), regionUserURI, CONVERT(varchar(128), regionUserRecvKey), CONVERT(varchar(128), regionUserSendKey), CONVERT(varchar(36), regionMapTexture), CONVERT(int, serverHttpPort), CONVERT(int, serverRemotingPort), owner_uuid FROM regions') | ||
38 | |||
39 | DROP TABLE regions | ||
40 | |||
41 | EXECUTE sp_rename N'Tmp_regions', N'regions', 'OBJECT' | ||
42 | |||
43 | ALTER TABLE regions ADD CONSTRAINT | ||
44 | PK__regions__uuid PRIMARY KEY CLUSTERED | ||
45 | ( | ||
46 | uuid | ||
47 | ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | ||
48 | |||
49 | COMMIT \ No newline at end of file | ||
diff --git a/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql new file mode 100644 index 0000000..684f937 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/007_RegionStore.sql | |||
@@ -0,0 +1,10 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | ALTER TABLE prims ADD ColorR int not null default 0; | ||
4 | ALTER TABLE prims ADD ColorG int not null default 0; | ||
5 | ALTER TABLE prims ADD ColorB int not null default 0; | ||
6 | ALTER TABLE prims ADD ColorA int not null default 0; | ||
7 | ALTER TABLE prims ADD ParticleSystem IMAGE; | ||
8 | ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0; | ||
9 | |||
10 | COMMIT | ||