aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/005_AssetStore.sql
diff options
context:
space:
mode:
authorSean Dague2008-11-06 21:21:46 +0000
committerSean Dague2008-11-06 21:21:46 +0000
commit629b0d9f28d2027b4d0aecc10bc78f7aefb5d7f3 (patch)
tree7a024be534000336d5216095ac41c5d1fbc33c7f /OpenSim/Data/MySQL/Resources/005_AssetStore.sql
parent* minor: remove some mono compiler warnings (diff)
downloadopensim-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.sql6
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 @@
1BEGIN;
2
3ALTER TABLE assets add create_time integer default 0;
4ALTER TABLE assets add access_time integer default 0;
5
6COMMIT;