aboutsummaryrefslogtreecommitdiffstatshomepage
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql27
1 files changed, 27 insertions, 0 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql
new file mode 100644
index 0000000..2cf46b5
--- /dev/null
+++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql
@@ -0,0 +1,27 @@
1BEGIN;
2
3CREATE TABLE `PrimItems` (
4 `InvType` int(11) default NULL,
5 `AssetType` int(11) default NULL,
6 `Name` varchar(255) default NULL,
7 `Description` varchar(255) default NULL,
8 `CreationDate` bigint(20) default NULL,
9 `NextPermissions` int(11) default NULL,
10 `CurrentPermissions` int(11) default NULL,
11 `BasePermissions` int(11) default NULL,
12 `EveryonePermissions` int(11) default NULL,
13 `GroupPermissions` int(11) default NULL,
14 `Flags` int(11) NOT NULL default '0',
15 `ItemID` char(36) NOT NULL default '',
16 `PrimID` char(36) default NULL,
17 `AssetID` char(36) default NULL,
18 `ParentFolderID` char(36) default NULL,
19 `CreatorID` char(36) default NULL,
20 `OwnerID` char(36) default NULL,
21 `GroupID` char(36) default NULL,
22 `LastOwnerID` char(36) default NULL,
23 PRIMARY KEY (`ItemID`),
24 KEY `primitems_primid` (`PrimID`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8;
26
27COMMIT; \ No newline at end of file