| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] |
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0003853 | opensim | [REGION] OpenSim Core | public | 2009-06-29 17:21 | 2009-08-10 14:52 |
|
| Reporter | StrawberryFride | |
| Assigned To | | |
| Priority | normal | Severity | crash | Reproducibility | N/A |
| Status | closed | Resolution | open | |
| Platform | | OS | | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
|
| Summary | 0003853: MSSQL RegionStore SQL fix for trunk |
| Description | Minor tweak to a region migration SQL script for the OAR DateTime field - SQL Server syntax slightly different from MySQL (and there is no unsigned in MSSQL, sadly) |
| Tags | No tags attached. |
|
| Git Revision or version number | |
| Run Mode | Grid (Multiple Regions per Sim) |
| Physics Engine | ODE |
| Environment | .NET / Windows64 |
| Mono Version | None |
| Viewer | |
|
| Attached Files |  MSSQLRegionStore023.patch [^] (739 bytes) 2009-06-29 17:21 [Show Content] [Hide Content]Index: OpenSim/Data/MSSQL/Resources/023_RegionStore.sql
===================================================================
--- OpenSim/Data/MSSQL/Resources/023_RegionStore.sql (revision 9956)
+++ OpenSim/Data/MSSQL/Resources/023_RegionStore.sql (working copy)
@@ -1,7 +1,7 @@
BEGIN TRANSACTION
-ALTER TABLE regionsettings DROP COLUMN loaded_creation_date;
-ALTER TABLE regionsettings DROP COLUMN loaded_creation_time;
-ALTER TABLE regionsettings ADD COLUMN loaded_creation_datetime int unsigned NOT NULL default 0;
+ALTER TABLE regionsettings DROP COLUMN loaded_creation_date
+ALTER TABLE regionsettings DROP COLUMN loaded_creation_time
+ALTER TABLE regionsettings ADD loaded_creation_datetime int NOT NULL default 0
COMMIT
|
|
Relationships 
Relationships 