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/PostgreSQLDialect | |
parent | * It think it actually works now. Only that AssetService weirdness left to fix. (diff) | |
download | opensim-SC-631e10f269210cc352acc453fe04f56343c73360.zip opensim-SC-631e10f269210cc352acc453fe04f56343c73360.tar.gz opensim-SC-631e10f269210cc352acc453fe04f56343c73360.tar.bz2 opensim-SC-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 'OpenSim/Data/NHibernate/Resources/PostgreSQLDialect')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql | 6 | ||||
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | 11 |
2 files changed, 8 insertions, 9 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql index 9d0f711..42af659 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_InventoryStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/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, |
diff --git a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql index ff227c1..25c3945 100644 --- a/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql | |||
@@ -58,8 +58,8 @@ CREATE TABLE Prims ( | |||
58 | ScaleY DOUBLE PRECISION DEFAULT NULL, | 58 | ScaleY DOUBLE PRECISION DEFAULT NULL, |
59 | ScaleZ DOUBLE PRECISION DEFAULT NULL, | 59 | ScaleZ DOUBLE PRECISION DEFAULT NULL, |
60 | PCode INT DEFAULT NULL, | 60 | PCode INT DEFAULT NULL, |
61 | PathBegin SMALLINT DEFAULT NULL, | 61 | PathBegin INT DEFAULT NULL, |
62 | PathEnd SMALLINT DEFAULT NULL, | 62 | PathEnd INT DEFAULT NULL, |
63 | PathScaleX INT DEFAULT NULL, | 63 | PathScaleX INT DEFAULT NULL, |
64 | PathScaleY INT DEFAULT NULL, | 64 | PathScaleY INT DEFAULT NULL, |
65 | PathShearX INT DEFAULT NULL, | 65 | PathShearX INT DEFAULT NULL, |
@@ -71,11 +71,10 @@ CREATE TABLE Prims ( | |||
71 | PathTaperX SMALLINT DEFAULT NULL, | 71 | PathTaperX SMALLINT DEFAULT NULL, |
72 | PathTaperY SMALLINT DEFAULT NULL, | 72 | PathTaperY SMALLINT DEFAULT NULL, |
73 | PathTwist SMALLINT DEFAULT NULL, | 73 | PathTwist SMALLINT DEFAULT NULL, |
74 | PathTwistBegin INT DEFAULT NULL, | 74 | ProfileBegin INT DEFAULT NULL, |
75 | ProfileBegin SMALLINT DEFAULT NULL, | 75 | ProfileEnd INT DEFAULT NULL, |
76 | ProfileEnd SMALLINT DEFAULT NULL, | ||
77 | ProfileCurve INT DEFAULT NULL, | 76 | ProfileCurve INT DEFAULT NULL, |
78 | ProfileHollow SMALLINT DEFAULT NULL, | 77 | ProfileHollow INT DEFAULT NULL, |
79 | State INT DEFAULT NULL, | 78 | State INT DEFAULT NULL, |
80 | Texture BYTEA, | 79 | Texture BYTEA, |
81 | ExtraParams BYTEA, | 80 | ExtraParams BYTEA, |