diff options
author | Charles Krinke | 2009-01-12 20:14:39 +0000 |
---|---|---|
committer | Charles Krinke | 2009-01-12 20:14:39 +0000 |
commit | c00c855cc5decf73d598af5d74a2ef57c547efd3 (patch) | |
tree | 03a6e3622db531537c2cfb47a99acd5edf4fe6b7 /OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql | |
parent | * Separate starting a client thread into a separate Start() method (which mat... (diff) | |
download | opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.zip opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.gz opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.bz2 opensim-SC_OLD-c00c855cc5decf73d598af5d74a2ef57c547efd3.tar.xz |
Thank you kindly, Tlaukkan (Tommil) for a patch that:
Cleaned up schema creation scripts of MySQL to compliant form and created
SQLite scripts from them. In future it would be optimal if scripts from
different databases could be generated from MySQL scripts to ensure optimal
consistency between schemas of different databases. Did not yet review
column names. ID columns seem to have variety in naming which can be confusing.
Diffstat (limited to 'OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql')
-rw-r--r-- | OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql | 69 |
1 files changed, 34 insertions, 35 deletions
diff --git a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql index 89892df..5f4dcaa 100644 --- a/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql +++ b/OpenSim/Data/NHibernate/Resources/SQLiteDialect/001_InventoryStore.sql | |||
@@ -1,40 +1,39 @@ | |||
1 | BEGIN TRANSACTION; | ||
2 | |||
3 | CREATE TABLE InventoryFolders ( | 1 | CREATE TABLE InventoryFolders ( |
4 | ID varchar(36) not null primary key, | 2 | ID VARCHAR(36) NOT NULL, |
5 | Type int, | 3 | Type SMALLINT DEFAULT NULL, |
6 | Version int, | 4 | Version SMALLINT DEFAULT NULL, |
7 | ParentID varchar(36), | 5 | ParentID VARCHAR(36) DEFAULT NULL, |
8 | Owner varchar(36), | 6 | Owner VARCHAR(36) DEFAULT NULL, |
9 | Name varchar(64) | 7 | Name VARCHAR(64) DEFAULT NULL, |
8 | PRIMARY KEY (ID) | ||
10 | ); | 9 | ); |
11 | 10 | ||
12 | create table InventoryItems ( | 11 | CREATE INDEX InventoryFoldersOwnerIdIndex ON InventoryFolders (Owner); |
13 | ID varchar(36) not null primary key, | 12 | CREATE INDEX InventoryFoldersParentIdIndex ON InventoryFolders (ParentID); |
14 | InvType int, | ||
15 | AssetType int, | ||
16 | AssetID varchar(36), | ||
17 | Folder varchar(36), | ||
18 | Owner varchar(36), | ||
19 | Creator varchar(36), | ||
20 | Name varchar(64), | ||
21 | Description varchar(64), | ||
22 | NextPermissions int, | ||
23 | CurrentPermissions int, | ||
24 | BasePermissions int, | ||
25 | EveryOnePermissions int, | ||
26 | GroupID varchar(36), | ||
27 | GroupOwned int, | ||
28 | SalePrice int, | ||
29 | SaleType int, | ||
30 | Flags int, | ||
31 | CreationDate int | ||
32 | ); | ||
33 | 13 | ||
34 | CREATE INDEX folder_owner_id on InventoryFolders (Owner); | 14 | CREATE TABLE InventoryItems ( |
35 | CREATE INDEX folder_parent_id on InventoryFolders (ParentID); | 15 | ID VARCHAR(36) NOT NULL, |
36 | CREATE INDEX item_group_id on InventoryItems (GroupID); | 16 | InvType SMALLINT DEFAULT NULL, |
37 | CREATE INDEX item_owner_id on InventoryItems (Owner); | 17 | AssetType SMALLINT DEFAULT NULL, |
38 | CREATE INDEX item_folder_id on InventoryItems (Folder); | 18 | AssetID VARCHAR(36) DEFAULT NULL, |
19 | Folder VARCHAR(36) DEFAULT NULL, | ||
20 | Owner VARCHAR(36) DEFAULT NULL, | ||
21 | Creator VARCHAR(36) DEFAULT NULL, | ||
22 | Name VARCHAR(64) DEFAULT NULL, | ||
23 | Description VARCHAR(64) DEFAULT NULL, | ||
24 | NextPermissions INT DEFAULT NULL, | ||
25 | CurrentPermissions INT DEFAULT NULL, | ||
26 | BasePermissions INT DEFAULT NULL, | ||
27 | EveryOnePermissions INT DEFAULT NULL, | ||
28 | GroupID VARCHAR(36) DEFAULT NULL, | ||
29 | GroupOwned BIT DEFAULT NULL, | ||
30 | SalePrice INT DEFAULT NULL, | ||
31 | SaleType TINYINT DEFAULT NULL, | ||
32 | Flags INT DEFAULT NULL, | ||
33 | CreationDate INT DEFAULT NULL, | ||
34 | PRIMARY KEY (ID) | ||
35 | ); | ||
39 | 36 | ||
40 | COMMIT; | 37 | CREATE INDEX InventoryItemsGroupIdIndex ON InventoryItems (GroupID); |
38 | CREATE INDEX InventoryItemsOwnerIdIndex ON InventoryItems (Owner); | ||
39 | CREATE INDEX InventoryItemsFolderIdIndex ON InventoryItems (Folder); | ||