diff options
author | Sean Dague | 2009-06-29 15:05:12 +0000 |
---|---|---|
committer | Sean Dague | 2009-06-29 15:05:12 +0000 |
commit | 3dc2010da6412941bfbcdb29007b12a8f37b7bef (patch) | |
tree | f9fa0ad53b712d91d8fcc21aa6513c8a94dd4bf4 /OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | |
parent | Thank you kindly, Godfrey, for a patch that: (diff) | |
download | opensim-SC_OLD-3dc2010da6412941bfbcdb29007b12a8f37b7bef.zip opensim-SC_OLD-3dc2010da6412941bfbcdb29007b12a8f37b7bef.tar.gz opensim-SC_OLD-3dc2010da6412941bfbcdb29007b12a8f37b7bef.tar.bz2 opensim-SC_OLD-3dc2010da6412941bfbcdb29007b12a8f37b7bef.tar.xz |
From: Chris Yeoh <yeohc@au1.ibm.com>
Attached is a patch that changes the oar file saving of creation date/time to an integer
instead of a string. I did this after justincc emailed me saying there is a problem
with internationalisation doing it the old way and I said I'd fix it. Its been
tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql new file mode 100644 index 0000000..61b08f1 --- /dev/null +++ b/OpenSim/Data/MSSQL/Resources/023_RegionStore.sql | |||
@@ -0,0 +1,7 @@ | |||
1 | BEGIN TRANSACTION | ||
2 | |||
3 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_date; | ||
4 | ALTER TABLE regionsettings DROP COLUMN loaded_creation_time; | ||
5 | ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0; | ||
6 | |||
7 | COMMIT | ||