| Dependency Graph | [ View Issue ] [ Relation Graph ] [ Vertical ] | |||
|
|
||||
|
||||
related to 
child of 
duplicate of | View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000030 | Branch 0.2.1-FINAL | Feature Request | public | 2008-12-25 21:24 | 2010-06-08 03:35 |
| Reporter | Quix0r | ||||
| Assigned To | Quix0r | ||||
| Priority | urgent | Severity | feature | Reproducibility | N/A |
| Status | assigned | Resolution | open | ||
| Platform | PHP5-Latest | OS | Linux | OS Version | 2.6 |
| Product Version | 0.2.1-FINAL | ||||
| Target Version | 0.2.1-FINAL | Fixed in Version | |||
| Summary | 0000030: Zeitstempel sollten nicht mehr BIGINT(20) sein, sondern TIMESTAMP | ||||
| Description | Alle Zeitstempel im gesamten Script sollten von BIGINT(20) nach TIMESTAMP umgestellt werden. Dabei müssen auch sämtliche Queries angepasst werden. Z.B. muss "last_online" nach "UNIX_TIMESTAMP(`last_online`) AS `last_online`" umgeschrieben werden. | ||||
| Additional Information | Dazu sollten erstmal alle "Zeitmarken" im Script erkannt werden (z.B. "last_online") und in diesem Ticket vermerkt werden. Dann koennen alle gemeinsam umgestellt werden und dabei z.B. "UNIX_TIMESTAMP(`last_online`) AS last_online" dann verwendet werden, damit die SQL-Abfrage zum PHP-Code kompatibel bleibt. | ||||
| Tags | No tags attached. | ||||
| Attached Files |
| ||||
 Notes |
|
| There are no notes attached to this issue. |
 Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2008-12-25 21:24 | Quix0r | New Issue | |
| 2008-12-25 21:24 | Quix0r | Status | new => assigned |
| 2008-12-25 21:24 | Quix0r | Assigned To | => Quix0r |
| 2008-12-25 21:24 | Quix0r | ETA | none => < 1 week |
| 2008-12-25 21:24 | Quix0r | Fixed in Version | => 0.2.1-FINAL |
| 2009-02-06 02:49 | Quix0r | Build | => SVN-HEAD |
| 2009-02-07 16:01 | Quix0r | Relationship added | parent of 0000031 |
| 2009-02-07 23:30 | Quix0r | Projection | none => major rework |
| 2009-02-07 23:30 | Quix0r | Additional Information Updated | |
| 2009-03-02 16:32 | Quix0r | Sticky Issue | No => Yes |
| 2009-08-06 16:03 | Quix0r | Product Version | 0.2.1-FINAL => |
| 2009-08-06 16:03 | Quix0r | Fixed in Version | 0.2.1-FINAL => |
| 2009-11-25 22:56 | Quix0r | Fixed in Version | => 0.2.1-FINAL |
| 2010-05-28 18:52 | Quix0r | Product Version | => 0.2.1-FINAL |
| 2010-06-08 03:35 | Quix0r | Fixed in Version | 0.2.1-FINAL => |
| Issue History |