diff options
author | AlexRa | 2010-05-06 23:16:36 +0300 |
---|---|---|
committer | AlexRa | 2010-05-18 22:16:13 +0300 |
commit | 020f38774fbe8e0f53b0cb28ab49b378b9dcd325 (patch) | |
tree | 5d936d6450d580cf24e133047df7ff8d759de557 /OpenSim/Data/MSSQL/Resources/001_EstateStore.sql | |
parent | Migrations for SQLite converted to new format (diff) | |
download | opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.zip opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.gz opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.bz2 opensim-SC-020f38774fbe8e0f53b0cb28ab49b378b9dcd325.tar.xz |
MS SQL migrations converted to the new format
Diffstat (limited to 'OpenSim/Data/MSSQL/Resources/001_EstateStore.sql')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/001_EstateStore.sql | 85 |
1 files changed, 0 insertions, 85 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql b/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql deleted file mode 100644 index 9bb2f75..0000000 --- a/OpenSim/Data/MSSQL/Resources/001_EstateStore.sql +++ /dev/null | |||
@@ -1,85 +0,0 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | CREATE TABLE [dbo].[estate_managers]( | ||
4 | [EstateID] [int] NOT NULL, | ||
5 | [uuid] [varchar](36) NOT NULL, | ||
6 | CONSTRAINT [PK_estate_managers] PRIMARY KEY CLUSTERED | ||
7 | ( | ||
8 | [EstateID] ASC | ||
9 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
10 | ) ON [PRIMARY]; | ||
11 | |||
12 | CREATE TABLE [dbo].[estate_groups]( | ||
13 | [EstateID] [int] NOT NULL, | ||
14 | [uuid] [varchar](36) NOT NULL, | ||
15 | CONSTRAINT [PK_estate_groups] PRIMARY KEY CLUSTERED | ||
16 | ( | ||
17 | [EstateID] ASC | ||
18 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
19 | ) ON [PRIMARY]; | ||
20 | |||
21 | |||
22 | CREATE TABLE [dbo].[estate_users]( | ||
23 | [EstateID] [int] NOT NULL, | ||
24 | [uuid] [varchar](36) NOT NULL, | ||
25 | CONSTRAINT [PK_estate_users] PRIMARY KEY CLUSTERED | ||
26 | ( | ||
27 | [EstateID] ASC | ||
28 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
29 | ) ON [PRIMARY]; | ||
30 | |||
31 | |||
32 | CREATE TABLE [dbo].[estateban]( | ||
33 | [EstateID] [int] NOT NULL, | ||
34 | [bannedUUID] [varchar](36) NOT NULL, | ||
35 | [bannedIp] [varchar](16) NOT NULL, | ||
36 | [bannedIpHostMask] [varchar](16) NOT NULL, | ||
37 | [bannedNameMask] [varchar](64) NULL DEFAULT (NULL), | ||
38 | CONSTRAINT [PK_estateban] PRIMARY KEY CLUSTERED | ||
39 | ( | ||
40 | [EstateID] ASC | ||
41 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
42 | ) ON [PRIMARY]; | ||
43 | |||
44 | CREATE TABLE [dbo].[estate_settings]( | ||
45 | [EstateID] [int] IDENTITY(1,100) NOT NULL, | ||
46 | [EstateName] [varchar](64) NULL DEFAULT (NULL), | ||
47 | [AbuseEmailToEstateOwner] [bit] NOT NULL, | ||
48 | [DenyAnonymous] [bit] NOT NULL, | ||
49 | [ResetHomeOnTeleport] [bit] NOT NULL, | ||
50 | [FixedSun] [bit] NOT NULL, | ||
51 | [DenyTransacted] [bit] NOT NULL, | ||
52 | [BlockDwell] [bit] NOT NULL, | ||
53 | [DenyIdentified] [bit] NOT NULL, | ||
54 | [AllowVoice] [bit] NOT NULL, | ||
55 | [UseGlobalTime] [bit] NOT NULL, | ||
56 | [PricePerMeter] [int] NOT NULL, | ||
57 | [TaxFree] [bit] NOT NULL, | ||
58 | [AllowDirectTeleport] [bit] NOT NULL, | ||
59 | [RedirectGridX] [int] NOT NULL, | ||
60 | [RedirectGridY] [int] NOT NULL, | ||
61 | [ParentEstateID] [int] NOT NULL, | ||
62 | [SunPosition] [float] NOT NULL, | ||
63 | [EstateSkipScripts] [bit] NOT NULL, | ||
64 | [BillableFactor] [float] NOT NULL, | ||
65 | [PublicAccess] [bit] NOT NULL, | ||
66 | [AbuseEmail] [varchar](255) NOT NULL, | ||
67 | [EstateOwner] [varchar](36) NOT NULL, | ||
68 | [DenyMinors] [bit] NOT NULL, | ||
69 | CONSTRAINT [PK_estate_settings] PRIMARY KEY CLUSTERED | ||
70 | ( | ||
71 | [EstateID] ASC | ||
72 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
73 | ) ON [PRIMARY]; | ||
74 | |||
75 | |||
76 | CREATE TABLE [dbo].[estate_map]( | ||
77 | [RegionID] [varchar](36) NOT NULL DEFAULT ('00000000-0000-0000-0000-000000000000'), | ||
78 | [EstateID] [int] NOT NULL, | ||
79 | CONSTRAINT [PK_estate_map] PRIMARY KEY CLUSTERED | ||
80 | ( | ||
81 | [RegionID] ASC | ||
82 | )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] | ||
83 | ) ON [PRIMARY]; | ||
84 | |||
85 | COMMIT \ No newline at end of file | ||