diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql index 6e67630..afe702f 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_EstateStore.sql | |||
@@ -59,3 +59,13 @@ CREATE TABLE EstateGroups ( | |||
59 | ArrayIndex INT NOT NULL, | 59 | ArrayIndex INT NOT NULL, |
60 | PRIMARY KEY (EstateID,ArrayIndex) | 60 | PRIMARY KEY (EstateID,ArrayIndex) |
61 | ); | 61 | ); |
62 | |||
63 | CREATE TABLE EstateBans ( | ||
64 | EstateID INT NOT NULL, | ||
65 | ArrayIndex INT NOT NULL, | ||
66 | BannedUserID VARCHAR(36) NOT NULL, | ||
67 | BannedHostAddress VARCHAR(16) NOT NULL, | ||
68 | BannedHostIPMask VARCHAR(16) NOT NULL, | ||
69 | BannedHostNameMask VARCHAR(16) NOT NULL, | ||
70 | PRIMARY KEY (EstateID,ArrayIndex) | ||
71 | ); | ||