aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql
blob: 421a0c4787dc3aad61931748fe506f54bdec6cf2 (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 DEFAULT NULL,
  EstateOwnerID VARCHAR(36) DEFAULT NULL,
  Name VARCHAR(64) DEFAULT NULL,
  RedirectGridX INT DEFAULT NULL,
  RedirectGridY INT DEFAULT NULL,
  BillableFactor DOUBLE PRECISION DEFAULT NULL,
  PricePerMeter INT DEFAULT NULL,
  SunPosition DOUBLE PRECISION DEFAULT NULL,
  
  UseGlobalTime BOOLEAN DEFAULT NULL,
  FixedSun BOOLEAN DEFAULT NULL,
  AllowVoice BOOLEAN DEFAULT NULL,
  AllowDirectTeleport BOOLEAN DEFAULT NULL,
  ResetHomeOnTeleport BOOLEAN DEFAULT NULL,
  PublicAccess BOOLEAN DEFAULT NULL,
  DenyAnonymous BOOLEAN DEFAULT NULL,
  DenyIdentified BOOLEAN DEFAULT NULL,
  DenyTransacted BOOLEAN DEFAULT NULL,
  DenyMinors BOOLEAN DEFAULT NULL,
  BlockDwell BOOLEAN DEFAULT NULL,
  EstateSkipScripts BOOLEAN DEFAULT NULL,
  TaxFree BOOLEAN DEFAULT NULL,
  AbuseEmailToEstateOwner BOOLEAN DEFAULT NULL,
  
  AbuseEmail VARCHAR(255) DEFAULT NULL,

  PRIMARY KEY (EstateID)
);

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

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