aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/XAssetStore.migrations
diff options
context:
space:
mode:
authorMelanie2012-03-09 00:56:52 +0000
committerMelanie2012-03-09 00:56:52 +0000
commitac577bf606ddc24db70e4662770972999cfce751 (patch)
tree08c1b49af3574693b03682f944ec3cd60e9caa29 /OpenSim/Data/MySQL/Resources/XAssetStore.migrations
parentMerge branch 'master' into careminster (diff)
parentMerge branch 'master' of ssh://opensimulator.org/var/git/opensim (diff)
downloadopensim-SC-ac577bf606ddc24db70e4662770972999cfce751.zip
opensim-SC-ac577bf606ddc24db70e4662770972999cfce751.tar.gz
opensim-SC-ac577bf606ddc24db70e4662770972999cfce751.tar.bz2
opensim-SC-ac577bf606ddc24db70e4662770972999cfce751.tar.xz
Merge branch 'master' into careminster
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..d3cca5e
--- /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` binary(32) 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` binary(32) 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