From 9b9804a498a3d48e7356c0a2cd12bf98887f5a53 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Tue, 8 Jun 2010 15:47:14 -0700
Subject: * Changed CreatorIDs consistently to varchar(128) * Deleted redundant
 migration for assets in SQLite * Rewrote XInventory migrations in SQLite in
 the new style

---
 .../Data/SQLite/Resources/001_XInventoryStore.sql  | 38 ----------------------
 1 file changed, 38 deletions(-)
 delete mode 100644 OpenSim/Data/SQLite/Resources/001_XInventoryStore.sql

(limited to 'OpenSim/Data/SQLite/Resources/001_XInventoryStore.sql')

diff --git a/OpenSim/Data/SQLite/Resources/001_XInventoryStore.sql b/OpenSim/Data/SQLite/Resources/001_XInventoryStore.sql
deleted file mode 100644
index 7e21996..0000000
--- a/OpenSim/Data/SQLite/Resources/001_XInventoryStore.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-BEGIN TRANSACTION;
-
-CREATE TABLE inventoryfolders(
-       folderName varchar(255),
-       type integer,
-       version integer,
-       folderID varchar(255) primary key,
-       agentID varchar(255) not null default '00000000-0000-0000-0000-000000000000',
-       parentFolderID varchar(255) not null default '00000000-0000-0000-0000-000000000000');
-
-CREATE TABLE inventoryitems(
-       assetID varchar(255),
-       assetType integer,
-       inventoryName varchar(255),
-       inventoryDescription varchar(255),
-       inventoryNextPermissions integer,
-       inventoryCurrentPermissions integer,
-       invType integer,
-       creatorID varchar(255),
-       inventoryBasePermissions integer,
-       inventoryEveryOnePermissions integer, 
-       salePrice integer default 99, 
-       saleType integer default 0, 
-       creationDate integer default 2000, 
-       groupID varchar(255) default '00000000-0000-0000-0000-000000000000', 
-       groupOwned integer default 0, 
-       flags integer default 0,
-       inventoryID varchar(255) primary key,
-       parentFolderID varchar(255) not null default '00000000-0000-0000-0000-000000000000',
-       avatarID varchar(255) not null default '00000000-0000-0000-0000-000000000000',
-       inventoryGroupPermissions integer not null default 0);
-
-create index inventoryfolders_agentid on inventoryfolders(agentID);
-create index inventoryfolders_parentid on inventoryfolders(parentFolderID);
-create index inventoryitems_parentfolderid on inventoryitems(parentFolderID);
-create index inventoryitems_avatarid on inventoryitems(avatarID);
-
-COMMIT;
-- 
cgit v1.1

