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 | |
| 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 'OpenSim/Data/MSSQL/Resources')
| -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 | ||