o k`Z@s ddZdS)cCs|d|d|d|d|jdddrC|d|d |d |d |d |d |ddSdS)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)tracdatabasepostgresz@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))executeconfigget startswith)envvercursorr 4/usr/lib/python3/dist-packages/trac/upgrades/db16.py do_upgrades          r N)r r r r r s