diff options
author | Sean Dague | 2008-11-06 21:21:46 +0000 |
---|---|---|
committer | Sean Dague | 2008-11-06 21:21:46 +0000 |
commit | 629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3 (patch) | |
tree | 7a024be534000336d5216095ac41c5d1fbc33c7f /OpenSim/Data/MySQL/Resources/005_AssetStore.sql | |
parent | * minor: remove some mono compiler warnings (diff) | |
download | opensim-SC-629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3.zip opensim-SC-629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3.tar.gz opensim-SC-629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3.tar.bz2 opensim-SC-629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3.tar.xz |
add create_time and access_time to asset db for mysql, as well
as the code to update these at the appropriate time. This isn't
surfaced in AssetBase yet.
Change the replace into to an insert into for asset create. Assets
are not supposed to be updatable, and the replace into is more
expensive.
From: Sean Dague <sdague@gmail.com>
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/005_AssetStore.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/005_AssetStore.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/005_AssetStore.sql b/OpenSim/Data/MySQL/Resources/005_AssetStore.sql new file mode 100644 index 0000000..bfeb652 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/005_AssetStore.sql | |||
@@ -0,0 +1,6 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE assets add create_time integer default 0; | ||
4 | ALTER TABLE assets add access_time integer default 0; | ||
5 | |||
6 | COMMIT; | ||