aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
blob: 893e2a2553a4de623f343d5d3bd6991a6d1dcd68 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE TABLE EstateSettings (
  EstateID INT NOT NULL,
  ParentEstateID INT NULL,
  EstateOwnerID NVARCHAR(36) NULL,
  Name NVARCHAR(64) NULL,
  RedirectGridX INT NULL,
  RedirectGridY INT NULL,
  BillableFactor REAL NULL,
  PricePerMeter INT NULL,
  SunPosition REAL NULL,
  
  UseGlobalTime BIT NULL,
  FixedSun BIT NULL,
  AllowVoice BIT NULL,
  AllowDirectTeleport BIT NULL,
  ResetHomeOnTeleport BIT NULL,
  PublicAccess BIT NULL,
  DenyAnonymous BIT NULL,
  DenyIdentified BIT NULL,
  DenyTransacted BIT NULL,
  DenyMinors BIT NULL,
  BlockDwell BIT NULL,
  EstateSkipScripts BIT NULL,
  TaxFree BIT NULL,
  AbuseEmailToEstateOwner BIT NULL,
  
  AbuseEmail NVARCHAR(255) NULL,

  PRIMARY KEY (EstateID)
);

CREATE TABLE EstateRegionLink (
  EstateRegionLinkID NVARCHAR(36) NOT NULL,
  EstateID INT NULL,
  RegionID NVARCHAR(36) NULL,
  PRIMARY KEY (EstateRegionLinkID)
);

CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID);
CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID);