o

�k�`Z�@sdd
�ZdS)cCs�|�d
�

|�d�

|�d�

|�d�

|j
�dd��d�
rC|�d�

|�d	�

|�d
�

|�d�

|�d�

|�d
�

|�d�

dSdS)Nz)CREATE INDEX wiki_time_idx ON wiki (time)z1CREATE INDEX revision_time_idx ON revision (time)z1CREATE INDEX ticket_status_idx ON ticket (status)z-CREATE INDEX ticket_time_idx ON ticket (time)�trac�database�postgresz@ALTER TABLE system ADD CONSTRAINT system_pkey PRIMARY KEY (name)zCALTER TABLE revision ADD CONSTRAINT revision_pkey PRIMARY KEY (rev)z>ALTER TABLE ticket ADD CONSTRAINT ticket_pkey PRIMARY KEY (id)zFALTER TABLE component ADD CONSTRAINT component_pkey PRIMARY KEY (name)zFALTER TABLE milestone ADD CONSTRAINT milestone_pkey PRIMARY KEY (name)zBALTER TABLE version ADD CONSTRAINT version_pkey PRIMARY KEY (name)z>ALTER TABLE report ADD CONSTRAINT report_pkey PRIMARY KEY (id))�execute�config�get�
startswith)�env�ver�cursor�r�4/usr/lib/python3/dist-packages/trac/upgrades/db16.py�
do_upgrades



















�r
N)
r
rrrr�<module>
s