diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql index e43fd86..d13a4d3 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql | |||
| @@ -38,3 +38,25 @@ CREATE TABLE EstateRegionLink ( | |||
| 38 | 38 | ||
| 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); | 39 | CREATE INDEX EstateRegionLinkEstateIDIndex ON EstateRegionLink (EstateID); |
| 40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); | 40 | CREATE INDEX EstateRegionLinkERegionIDIndex ON EstateRegionLink (RegionID); |
| 41 | |||
| 42 | |||
| 43 | CREATE TABLE EstateManagers ( | ||
| 44 | EstateID INT NOT NULL, | ||
| 45 | ManagerID VARCHAR(36) NOT NULL, | ||
| 46 | ArrayIndex INT NOT NULL, | ||
| 47 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 48 | ); | ||
| 49 | |||
| 50 | CREATE TABLE EstateUsers ( | ||
| 51 | EstateID INT NOT NULL, | ||
| 52 | UserID VARCHAR(36) NOT NULL, | ||
| 53 | ArrayIndex INT NOT NULL, | ||
| 54 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 55 | ); | ||
| 56 | |||
| 57 | CREATE TABLE EstateGroups ( | ||
| 58 | EstateID INT NOT NULL, | ||
| 59 | GroupID VARCHAR(36) NOT NULL, | ||
| 60 | ArrayIndex INT NOT NULL, | ||
| 61 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 62 | ); \ No newline at end of file | ||