aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
index b852cbc..dd579f9 100644
--- a/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/MsSql2005Dialect/001_EstateStore.sql
@@ -59,4 +59,14 @@ CREATE TABLE EstateGroups (
59 GroupID NVARCHAR(36) NOT NULL, 59 GroupID NVARCHAR(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
64CREATE TABLE EstateBans (
65 EstateID INT NOT NULL,
66 ArrayIndex INT NOT NULL,
67 BannedUserID NVARCHAR(36) NOT NULL,
68 BannedHostAddress NVARCHAR(16) NOT NULL,
69 BannedHostIPMask NVARCHAR(16) NOT NULL,
70 BannedHostNameMask NVARCHAR(16) NOT NULL,
71 PRIMARY KEY (EstateID,ArrayIndex)
62); \ No newline at end of file 72); \ No newline at end of file