aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/PostgreSQLDialect
diff options
context:
space:
mode:
authorJustin Clarke Casey2009-02-19 18:31:45 +0000
committerJustin Clarke Casey2009-02-19 18:31:45 +0000
commit631e10f269210cc352acc453fe04f56343c73360 (patch)
treeaa38818eb01549179f0f90322b8cd5c0a249c5d1 /OpenSim/Data/NHibernate/Resources/PostgreSQLDialect
parent* It think it actually works now. Only that AssetService weirdness left to fix. (diff)
downloadopensim-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.sql6
-rw-r--r--OpenSim/Data/NHibernate/Resources/PostgreSQLDialect/001_RegionStore.sql11
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 @@
1CREATE TABLE InventoryFolders ( 1CREATE 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
14CREATE TABLE InventoryItems ( 14CREATE 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,