o k` @sgdZddZdS)) 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 );aINSERT 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';aINSERT 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 CstD]}||q|di}|D]\}}|||<q|D](\}}|dd}t|dkr6d|dp7d}|d|ddd||fq dS) NzSELECT id,sql FROM reportzORDER BYz$UPDATE report SET sql=%s WHERE id=%sz severity,zt.type AS type, severity,)sqlexecuteitemssplitlenreplace) envvercursorsreportsidrsqlpartsendingr4/usr/lib/python3/dist-packages/trac/upgrades/db13.py do_upgrade:s&      rN)rrrrrrs ,