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 r r r r Ús