diff options
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/MySQLDialect')
3 files changed, 4 insertions, 5 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql index 9573781..cd0958d 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_AssetStore.sql | |||
@@ -1,6 +1,6 @@ | |||
1 | CREATE TABLE Assets ( | 1 | CREATE TABLE Assets ( |
2 | ID VARCHAR(36) NOT NULL, | 2 | ID VARCHAR(36) NOT NULL, |
3 | Type TINYINT DEFAULT NULL, | 3 | Type SMALLINT DEFAULT NULL, |
4 | Name VARCHAR(64) DEFAULT NULL, | 4 | Name VARCHAR(64) DEFAULT NULL, |
5 | Description VARCHAR(64) DEFAULT NULL, | 5 | Description VARCHAR(64) DEFAULT NULL, |
6 | Local BIT DEFAULT NULL, | 6 | Local BIT DEFAULT NULL, |
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, |
diff --git a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql index e44f012..74f67f2 100644 --- a/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql +++ b/OpenSim/Data/NHibernate/Resources/MySQLDialect/001_RegionStore.sql | |||
@@ -71,7 +71,6 @@ CREATE TABLE Prims ( | |||
71 | PathTaperX INT DEFAULT NULL, | 71 | PathTaperX INT DEFAULT NULL, |
72 | PathTaperY INT DEFAULT NULL, | 72 | PathTaperY INT DEFAULT NULL, |
73 | PathTwist INT DEFAULT NULL, | 73 | PathTwist INT DEFAULT NULL, |
74 | PathTwistBegin INT DEFAULT NULL, | ||
75 | ProfileBegin INT DEFAULT NULL, | 74 | ProfileBegin INT DEFAULT NULL, |
76 | ProfileEnd INT DEFAULT NULL, | 75 | ProfileEnd INT DEFAULT NULL, |
77 | ProfileCurve INT DEFAULT NULL, | 76 | ProfileCurve INT DEFAULT NULL, |