aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data
diff options
context:
space:
mode:
authorJustin Clarke Casey2008-09-29 20:26:34 +0000
committerJustin Clarke Casey2008-09-29 20:26:34 +0000
commit464c3c709102954e502a5d3868bac615c73c64b4 (patch)
treee9d9ab1eded503268cf379ed8bcd8d2853095105 /OpenSim/Data
parentMantis#2299. Thank you kindly, Idb for a patch that: (diff)
downloadopensim-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 'OpenSim/Data')
-rw-r--r--OpenSim/Data/MSSQL/Resources/001_LogStore.sql17
-rw-r--r--OpenSim/Data/MSSQL/Resources/002_GridStore.sql49
-rw-r--r--OpenSim/Data/MSSQL/Resources/007_RegionStore.sql10
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 @@
1BEGIN TRANSACTION
2
3CREATE 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
17COMMIT
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 @@
1BEGIN TRANSACTION
2
3CREATE 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
35IF 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
39DROP TABLE regions
40
41EXECUTE sp_rename N'Tmp_regions', N'regions', 'OBJECT'
42
43ALTER 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
49COMMIT \ 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 @@
1BEGIN TRANSACTION
2
3ALTER TABLE prims ADD ColorR int not null default 0;
4ALTER TABLE prims ADD ColorG int not null default 0;
5ALTER TABLE prims ADD ColorB int not null default 0;
6ALTER TABLE prims ADD ColorA int not null default 0;
7ALTER TABLE prims ADD ParticleSystem IMAGE;
8ALTER TABLE prims ADD ClickAction tinyint NOT NULL default 0;
9
10COMMIT