o

�k�`
�@sgd�
Zd
d�Z
dS))
z:CREATE TEMPORARY TABLE ticket_old AS SELECT * FROM ticket;zDROP TABLE ticket;a%CREATE TABLE ticket (
        id              integer PRIMARY KEY,
        type            text,           -- the nature of the ticket
        time            integer,        -- the time it was created
        changetime      integer,
        component       text,
        severity        text,
        priority        text,
        owner           text,           -- who is this ticket assigned to
        reporter        text,
        cc              text,           -- email addresses to notify
        version         text,           --
        milestone       text,           --
        status          text,
        resolution      text,
        summary         text,           -- one-line summary
        description     text,           -- problem description (long)
        keywords        text
);a�
INSERT INTO ticket(id, type, time, changetime, component, severity, priority,
                   owner, reporter, cc, version, milestone, status, resolution,
                   summary, description, keywords)
  SELECT id, 'defect', time, changetime, component, severity, priority, owner,
         reporter, cc, version, milestone, status, resolution, summary,
         description, keywords FROM ticket_old
  WHERE COALESCE(severity,'') <> 'enhancement';a�
INSERT INTO ticket(id, type, time, changetime, component, severity, priority,
                   owner, reporter, cc, version, milestone, status, resolution,
                   summary, description, keywords)
  SELECT id, 'enhancement', time, changetime, component, 'normal', priority,
         owner, reporter, cc, version, milestone, status, resolution, summary,
         description, keywords FROM ticket_old
  WHERE severity = 'enhancement';zKINSERT INTO enum (type, name, value) VALUES ('ticket_type', 'defect', '1');zPINSERT INTO enum (type, name, value) VALUES ('ticket_type', 'enhancement', '2');zIINSERT INTO enum (type, name, value) VALUES ('ticket_type', 'task', '3');zBDELETE FROM enum WHERE type = 'severity' AND name = 'enhancement';zDROP TABLE ticket_old;c	Cs�tD]}|�
|�

q|�
d
�

i}|D]\}}|||<q|��D](\}}|�dd�}t|�
dkr6d|dp7d}|�
d|d�dd�||f�
q dS)	NzSELECT id,sql FROM reportzORDER BY�
�z$UPDATE report SET sql=%s WHERE id=%s�z	severity,zt.type AS type, severity,)�sql�execute�items�split�len�replace)	�env�ver�cursor�
s�reports�id�rsql�parts�ending�r�4/usr/lib/python3/dist-packages/trac/upgrades/db13.py�
do_upgrade:s&













�
����rN)rrrrrr�<module>
s
,