From 781187e16f27fe140b241481d4879e6de631ade8 Mon Sep 17 00:00:00 2001 From: Sean Dague Date: Wed, 23 Jan 2008 20:42:50 +0000 Subject: put the number in front of the migrations to make them easier to deal with --- .../Data.SQLite/Resources/001_InventoryStore.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 OpenSim/Framework/Data.SQLite/Resources/001_InventoryStore.sql (limited to 'OpenSim/Framework/Data.SQLite/Resources/001_InventoryStore.sql') diff --git a/OpenSim/Framework/Data.SQLite/Resources/001_InventoryStore.sql b/OpenSim/Framework/Data.SQLite/Resources/001_InventoryStore.sql new file mode 100644 index 0000000..e4951b0 --- /dev/null +++ b/OpenSim/Framework/Data.SQLite/Resources/001_InventoryStore.sql @@ -0,0 +1,26 @@ +BEGIN TRANSACTION; + +CREATE TABLE inventoryitems( + UUID varchar(255) primary key, + assetID varchar(255), + assetType integer, + invType integer, + parentFolderID varchar(255), + avatarID varchar(255), + creatorsID varchar(255), + inventoryName varchar(255), + inventoryDescription varchar(255), + inventoryNextPermissions integer, + inventoryCurrentPermissions integer, + inventoryBasePermissions integer, + inventoryEveryOnePermissions integer); + +CREATE TABLE inventoryfolders( + UUID varchar(255) primary key, + name varchar(255), + agentID varchar(255), + parentID varchar(255), + type integer, + version integer); + +COMMIT; -- cgit v1.1