aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2012-03-02 03:57:55 +0000
committerJustin Clark-Casey (justincc)2012-03-02 03:57:55 +0000
commitbe4199c3bc2439b0eb4ea5beef7d5702e55809c7 (patch)
treeab1931a28dbddaf1334d8004272eb3acbfe8b80e /OpenSim/Data/MySQL/Resources/XAssetStore.migrations
parentStart by adding XAssetService as a copy of the existing AssetService. (diff)
downloadopensim-SC_OLD-be4199c3bc2439b0eb4ea5beef7d5702e55809c7.zip
opensim-SC_OLD-be4199c3bc2439b0eb4ea5beef7d5702e55809c7.tar.gz
opensim-SC_OLD-be4199c3bc2439b0eb4ea5beef7d5702e55809c7.tar.bz2
opensim-SC_OLD-be4199c3bc2439b0eb4ea5beef7d5702e55809c7.tar.xz
Make XAssetService a de-duplicating asset service.
This is an extremely crude implemenation which almost works by accident. Nevertheless it does work. It can be tested with the instructions at http://opensimulator.org/wiki/Feature_Proposals/Deduplicating_Asset_Service#Testing It does not interact at all with the existing asset service or any data stored there. This code is subject to change without notice and should not be used for anything other than gawking.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/XAssetStore.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/XAssetStore.migrations27
1 files changed, 27 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
new file mode 100644
index 0000000..b89eab2
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
@@ -0,0 +1,27 @@
1# -----------------
2:VERSION 1
3
4BEGIN;
5
6CREATE TABLE `xassetsmeta` (
7 `id` char(36) NOT NULL,
8 `hash` char(64) NOT NULL,
9 `name` varchar(64) NOT NULL,
10 `description` varchar(64) NOT NULL,
11 `asset_type` tinyint(4) NOT NULL,
12 `local` tinyint(1) NOT NULL,
13 `temporary` tinyint(1) NOT NULL,
14 `create_time` int(11) NOT NULL,
15 `access_time` int(11) NOT NULL,
16 `asset_flags` int(11) NOT NULL,
17 `creator_id` varchar(128) NOT NULL,
18 PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1';
20
21CREATE TABLE `xassetsdata` (
22 `hash` char(64) NOT NULL,
23 `data` longblob NOT NULL,
24 PRIMARY KEY (`hash`)
25) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1';
26
27COMMIT; \ No newline at end of file