Dashboard
PHP:
8.2.30
OS:
Linux
User:
dh_nv8b2m
/
/
usr
/
lib
/
python3
/
dist-packages
/
trac
/
upgrades
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: db13.cpython-310.pyc
o �k�` � @ s g d �Z dd� ZdS )) 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 C s� t D ]}|�|� q|�d� i }|D ]\}}|||< q|�� D ](\}}|�dd�}t|�dkr6d|d p7d}|�d|d �dd�| |f� q d S ) 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& �����r N)r r r r r r �<module> s ,
Save
Cancel