diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/XAssetStore.migrations | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations index b89eab2..d3cca5e 100644 --- a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations | |||
@@ -5,7 +5,7 @@ BEGIN; | |||
5 | 5 | ||
6 | CREATE TABLE `xassetsmeta` ( | 6 | CREATE TABLE `xassetsmeta` ( |
7 | `id` char(36) NOT NULL, | 7 | `id` char(36) NOT NULL, |
8 | `hash` char(64) NOT NULL, | 8 | `hash` binary(32) NOT NULL, |
9 | `name` varchar(64) NOT NULL, | 9 | `name` varchar(64) NOT NULL, |
10 | `description` varchar(64) NOT NULL, | 10 | `description` varchar(64) NOT NULL, |
11 | `asset_type` tinyint(4) NOT NULL, | 11 | `asset_type` tinyint(4) NOT NULL, |
@@ -19,7 +19,7 @@ CREATE TABLE `xassetsmeta` ( | |||
19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; |
20 | 20 | ||
21 | CREATE TABLE `xassetsdata` ( | 21 | CREATE TABLE `xassetsdata` ( |
22 | `hash` char(64) NOT NULL, | 22 | `hash` binary(32) NOT NULL, |
23 | `data` longblob NOT NULL, | 23 | `data` longblob NOT NULL, |
24 | PRIMARY KEY (`hash`) | 24 | PRIMARY KEY (`hash`) |
25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; |