diff options
| author | Justin Clarke Casey | 2009-02-19 18:31:45 +0000 |
|---|---|---|
| committer | Justin Clarke Casey | 2009-02-19 18:31:45 +0000 |
| commit | 631e10f269210cc352acc453fe04f56343c73360 (patch) | |
| tree | aa38818eb01549179f0f90322b8cd5c0a249c5d1 /OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql | |
| parent | * It think it actually works now. Only that AssetService weirdness left to fix. (diff) | |
| download | opensim-SC_OLD-631e10f269210cc352acc453fe04f56343c73360.zip opensim-SC_OLD-631e10f269210cc352acc453fe04f56343c73360.tar.gz opensim-SC_OLD-631e10f269210cc352acc453fe04f56343c73360.tar.bz2 opensim-SC_OLD-631e10f269210cc352acc453fe04f56343c73360.tar.xz | |
* Apply http://opensimulator.org/mantis/view.php?id=3151
* Fixes NHibernate overflow exception when saving some objects (under at least PostgreSQL 8.3)
* Thanks Tommil!
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql index 13d8cf6..93d282b 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_InventoryStore.sql | |||
| @@ -1,7 +1,7 @@ | |||
| 1 | CREATE TABLE InventoryFolders ( | 1 | CREATE TABLE InventoryFolders ( |
| 2 | ID VARCHAR(36) NOT NULL, | 2 | ID VARCHAR(36) NOT NULL, |
| 3 | Type SMALLINT DEFAULT NULL, | 3 | Type SMALLINT DEFAULT NULL, |
| 4 | Version SMALLINT DEFAULT NULL, | 4 | Version INT DEFAULT NULL, |
| 5 | ParentID VARCHAR(36) DEFAULT NULL, | 5 | ParentID VARCHAR(36) DEFAULT NULL, |
| 6 | Owner VARCHAR(36) DEFAULT NULL, | 6 | Owner VARCHAR(36) DEFAULT NULL, |
| 7 | Name VARCHAR(64) DEFAULT NULL, | 7 | Name VARCHAR(64) DEFAULT NULL, |
| @@ -13,8 +13,8 @@ CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); | |||
| 13 | 13 | ||
| 14 | CREATE TABLE InventoryItems ( | 14 | CREATE TABLE InventoryItems ( |
| 15 | ID VARCHAR(36) NOT NULL, | 15 | ID VARCHAR(36) NOT NULL, |
| 16 | InvType SMALLINT DEFAULT NULL, | 16 | InvType INT DEFAULT NULL, |
| 17 | AssetType SMALLINT DEFAULT NULL, | 17 | AssetType INT DEFAULT NULL, |
| 18 | AssetID VARCHAR(36) DEFAULT NULL, | 18 | AssetID VARCHAR(36) DEFAULT NULL, |
| 19 | Folder VARCHAR(36) DEFAULT NULL, | 19 | Folder VARCHAR(36) DEFAULT NULL, |
| 20 | Owner VARCHAR(36) DEFAULT NULL, | 20 | Owner VARCHAR(36) DEFAULT NULL, |