diff options
author | Justin Clarke Casey | 2009-02-16 19:33:11 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-02-16 19:33:11 +0000 |
commit | 80759f708b1766b6fd36bbdb6ce69f292e64e2f0 (patch) | |
tree | 2ca913692571127b1b9bc5327ddc937b8d0211ab /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql | |
parent | line ending fixes and set native eol property (diff) | |
download | opensim-SC_OLD-80759f708b1766b6fd36bbdb6ce69f292e64e2f0.zip opensim-SC_OLD-80759f708b1766b6fd36bbdb6ce69f292e64e2f0.tar.gz opensim-SC_OLD-80759f708b1766b6fd36bbdb6ce69f292e64e2f0.tar.bz2 opensim-SC_OLD-80759f708b1766b6fd36bbdb6ce69f292e64e2f0.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=3166
* Adds estate access list supports to NHibernate data module
* Thanks Tommil
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql index b540bc6..6e67630 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql | |||
@@ -38,3 +38,24 @@ 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 | ); | ||
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 | ); | ||
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 | ); | ||