diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql index d13a4d3..3f47930 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_EstateStore.sql | |||
@@ -59,4 +59,14 @@ CREATE TABLE EstateGroups ( | |||
59 | GroupID VARCHAR(36) NOT NULL, | 59 | GroupID VARCHAR(36) NOT NULL, |
60 | ArrayIndex INT NOT NULL, | 60 | ArrayIndex INT NOT NULL, |
61 | PRIMARY KEY (EstateID,ArrayIndex) | 61 | PRIMARY KEY (EstateID,ArrayIndex) |
62 | ); | ||
63 | |||
64 | CREATE TABLE EstateBans ( | ||
65 | EstateID INT NOT NULL, | ||
66 | ArrayIndex INT NOT NULL, | ||
67 | BannedUserID VARCHAR(36) NOT NULL, | ||
68 | BannedHostAddress VARCHAR(16) NOT NULL, | ||
69 | BannedHostIPMask VARCHAR(16) NOT NULL, | ||
70 | BannedHostNameMask VARCHAR(16) NOT NULL, | ||
71 | PRIMARY KEY (EstateID,ArrayIndex) | ||
62 | ); \ No newline at end of file | 72 | ); \ No newline at end of file |