diff options
author | AliciaRaven | 2015-07-12 01:35:57 +0100 |
---|---|---|
committer | Melanie Thielker | 2015-07-12 04:03:08 +0200 |
commit | f3f748ed111223bdf9cbc25fcabb18b4ab427d37 (patch) | |
tree | 382d6390ec5ae88149bd03df8d5d82787df60bda /OpenSim/Data/MySQL/Resources | |
parent | More cleanup, add missing refs to prebuild, remove refs to stuff not (diff) | |
download | opensim-SC_OLD-f3f748ed111223bdf9cbc25fcabb18b4ab427d37.zip opensim-SC_OLD-f3f748ed111223bdf9cbc25fcabb18b4ab427d37.tar.gz opensim-SC_OLD-f3f748ed111223bdf9cbc25fcabb18b4ab427d37.tar.bz2 opensim-SC_OLD-f3f748ed111223bdf9cbc25fcabb18b4ab427d37.tar.xz |
Bringing FSAssets more inline with current OpenSim standards. * If no connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets
Signed-off-by: Melanie Thielker <melanie@t-data.com>
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/FSAssetStore.migrations | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations new file mode 100644 index 0000000..87d08c6 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/FSAssetStore.migrations | |||
@@ -0,0 +1,18 @@ | |||
1 | # ----------------- | ||
2 | :VERSION 1 | ||
3 | |||
4 | BEGIN; | ||
5 | |||
6 | CREATE TABLE `fsassets` ( | ||
7 | `id` char(36) NOT NULL, | ||
8 | `name` varchar(64) NOT NULL DEFAULT '', | ||
9 | `description` varchar(64) NOT NULL DEFAULT '', | ||
10 | `type` int(11) NOT NULL, | ||
11 | `hash` char(80) NOT NULL, | ||
12 | `create_time` int(11) NOT NULL DEFAULT '0', | ||
13 | `access_time` int(11) NOT NULL DEFAULT '0', | ||
14 | `asset_flags` int(11) NOT NULL DEFAULT '0', | ||
15 | PRIMARY KEY (`id`) | ||
16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
17 | |||
18 | COMMIT; \ No newline at end of file | ||