diff options
| author | Sean Dague | 2008-07-23 22:14:23 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-07-23 22:14:23 +0000 |
| commit | 3c227390c041555e055ee839449dada676b78099 (patch) | |
| tree | 7ee4c9ac0dbbff39dc68ff1f3afdd2a8110519e4 /OpenSim/Data | |
| parent | * refactor: split out inventory services which are only used between non-regi... (diff) | |
| download | opensim-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')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/003_RegionStore.sql | 27 |
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 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | CREATE 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 | |||
| 27 | COMMIT; \ No newline at end of file | ||