aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/NHibernate/Resources/SQLiteDialect
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect')
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql2
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql6
-rw-r--r--OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql1
3 files changed, 4 insertions, 5 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
index 15e10b3..aedf764 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_AssetStore.sql
@@ -1,6 +1,6 @@
1CREATE TABLE Assets ( 1CREATE 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/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
index 5f4dcaa..38978ee 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/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/SQLiteDialect/001_RegionStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
index 7b591be..1cf5e15 100644
--- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_RegionStore.sql
+++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/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,