diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql index 2114186..69635d8 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/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 | CREATE TABLE EstateManagers ( | ||
| 43 | EstateID INT NOT NULL, | ||
| 44 | ManagerID VARCHAR(36) NOT NULL, | ||
| 45 | ArrayIndex INT NOT NULL, | ||
| 46 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 47 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
| 48 | |||
| 49 | CREATE TABLE EstateUsers ( | ||
| 50 | EstateID INT NOT NULL, | ||
| 51 | UserID VARCHAR(36) NOT NULL, | ||
| 52 | ArrayIndex INT NOT NULL, | ||
| 53 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 54 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
| 55 | |||
| 56 | CREATE TABLE EstateGroups ( | ||
| 57 | EstateID INT NOT NULL, | ||
| 58 | GroupID VARCHAR(36) NOT NULL, | ||
| 59 | ArrayIndex INT NOT NULL, | ||
| 60 | PRIMARY KEY (EstateID,ArrayIndex) | ||
| 61 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | ||
| 62 | |||