aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources
diff options
context:
space:
mode:
authorSean Dague2008-07-23 22:14:23 +0000
committerSean Dague2008-07-23 22:14:23 +0000
commit3c227390c041555e055ee839449dada676b78099 (patch)
tree7ee4c9ac0dbbff39dc68ff1f3afdd2a8110519e4 /OpenSim/Data/NHibernate/Resources
parent* refactor: split out inventory services which are only used between non-regi... (diff)
downloadopensim-SC_OLD-3c227390c041555e055ee839449dada676b78099.zip
opensim-SC_OLD-3c227390c041555e055ee839449dada676b78099.tar.gz
opensim-SC_OLD-3c227390c041555e055ee839449dada676b78099.tar.bz2
opensim-SC_OLD-3c227390c041555e055ee839449dada676b78099.tar.xz
add primitems migration for nhibernate
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources')
-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