Changeset 3520

Show
Ignore:
Timestamp:
04/16/08 13:16:46 (6 months ago)
Author:
bobbysmith007
Message:

closes #2862

version 0.5.6 update reports sql to be mysql 5 compatible

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • timingandestimationplugin/branches/trac0.10/setup.py

    r3398 r3520  
    88      description='Plugin to make Trac support time estimation and tracking', 
    99      keywords='trac plugin estimation timetracking', 
    10       version='0.5.5', 
     10      version='0.5.6', 
    1111      url='http://www.trac-hacks.org/wiki/TimingAndEstimationPlugin', 
    1212      license='http://www.opensource.org/licenses/mit-license.php', 

  • timingandestimationplugin/branches/trac0.10/timingandestimationplugin/reports.py

    r3398 r3520  
    200200       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    201201         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    202          AS VARCHAR(1024))  as owner, 
     202         AS CHAR(512))  as owner, 
    203203         SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    204204      ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    238238SELECT __color__,  __style__,  ticket, summary, component ,version, severity, 
    239239 milestone, status, owner, Estimated_work, Total_work, billable 
    240 --## ,created,  modified,         -- ## Dates are formatted 
     240-- ##,created,  modified,         -- ## Dates are formatted 
    241241,_description_ 
    242 --## _changetime, 
    243 --## _reporter 
     242-- ## _changetime, 
     243-- ## _reporter 
    244244,_ord 
    245245 
    …… 
    288288       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    289289         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    290          AS VARCHAR(1024))  as owner, 
     290         AS CHAR(512))  as owner, 
    291291       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    292292         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    375375       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    376376         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    377          AS VARCHAR(1024))  as owner, 
     377         AS CHAR(512))  as owner, 
    378378       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    379379         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    462462       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    463463         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    464          AS VARCHAR(1024))  as owner, 
     464         AS CHAR(512))  as owner, 
    465465       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    466466         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    548548       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    549549         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    550          AS VARCHAR(1024)) as owner, 
     550         AS CHAR(512)) as owner, 
    551551       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    552552         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work, 
    …… 
    636636       SUM(CASE WHEN totalhours.value = '' OR totalhours.value IS NULL THEN 0 
    637637         ELSE CAST( totalhours.value AS DECIMAL ) END) 
    638          AS VARCHAR(1024)) as owner, 
     638         AS CHAR(512)) as owner, 
    639639       SUM(CASE WHEN EstimatedHours.value = '' OR EstimatedHours.value IS NULL THEN 0 
    640640         ELSE CAST( EstimatedHours.value AS DECIMAL ) END) as Estimated_work,