ALTER TABLE ONLY acl
    ADD CONSTRAINT acl_pkey PRIMARY KEY (id);
ALTER TABLE ONLY attachments
    ADD CONSTRAINT attachments_pkey PRIMARY KEY (id);
ALTER TABLE ONLY attributes
    ADD CONSTRAINT attributes_pkey PRIMARY KEY (id);
ALTER TABLE ONLY cachedgroupmembers
    ADD CONSTRAINT cachedgroupmembers_pkey PRIMARY KEY (id);
ALTER TABLE ONLY customfields
    ADD CONSTRAINT customfields_pkey PRIMARY KEY (id);
ALTER TABLE ONLY customfieldvalues
    ADD CONSTRAINT customfieldvalues_pkey PRIMARY KEY (id);
ALTER TABLE ONLY groupmembers
    ADD CONSTRAINT groupmembers_pkey PRIMARY KEY (id);
ALTER TABLE ONLY groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (id);
ALTER TABLE ONLY links
    ADD CONSTRAINT links_pkey PRIMARY KEY (id);
ALTER TABLE ONLY objectcustomfields
    ADD CONSTRAINT objectcustomfields_pkey PRIMARY KEY (id);
ALTER TABLE ONLY objectcustomfieldvalues
    ADD CONSTRAINT objectcustomfieldvalues_pkey PRIMARY KEY (id);
ALTER TABLE ONLY principals
    ADD CONSTRAINT principals_pkey PRIMARY KEY (id);
ALTER TABLE ONLY queues
    ADD CONSTRAINT queues_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scripactions
    ADD CONSTRAINT scripactions_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scripconditions
    ADD CONSTRAINT scripconditions_pkey PRIMARY KEY (id);
ALTER TABLE ONLY scrips
    ADD CONSTRAINT scrips_pkey PRIMARY KEY (id);
ALTER TABLE ONLY templates
    ADD CONSTRAINT templates_pkey PRIMARY KEY (id);
ALTER TABLE ONLY tickets
    ADD CONSTRAINT tickets_pkey PRIMARY KEY (id);
ALTER TABLE ONLY transactions
    ADD CONSTRAINT transactions_pkey PRIMARY KEY (id);
ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);
CREATE INDEX acl1 ON acl USING btree (rightname, objecttype, objectid, principaltype, principalid);
CREATE INDEX attachments1 ON attachments USING btree (parent);
CREATE INDEX attachments2 ON attachments USING btree (transactionid);
CREATE INDEX attachments3 ON attachments USING btree (parent, transactionid);
CREATE INDEX attributes1 ON attributes USING btree (name);
CREATE INDEX attributes2 ON attributes USING btree (objecttype, objectid);
CREATE INDEX cachedgroupmembers2 ON cachedgroupmembers USING btree (memberid);
CREATE INDEX cachedgroupmembers3 ON cachedgroupmembers USING btree (groupid);
CREATE INDEX customfieldvalues1 ON customfieldvalues USING btree (customfield);
CREATE INDEX disgroumem ON cachedgroupmembers USING btree (groupid, memberid, disabled);
CREATE UNIQUE INDEX groups1 ON groups USING btree ("domain", instance, "type", id, name);
CREATE INDEX groups2 ON groups USING btree ("type", instance, "domain");
CREATE UNIQUE INDEX links1 ON links USING btree (base, target, "type");
CREATE INDEX links4 ON links USING btree ("type", localbase);
CREATE INDEX objectcustomfieldvalues1 ON objectcustomfieldvalues USING btree (customfield, objecttype, objectid, content);
CREATE INDEX objectcustomfieldvalues2 ON objectcustomfieldvalues USING btree (customfield, objecttype, objectid);
CREATE INDEX objectcustomfieldvalues3 ON objectcustomfieldvalues USING btree (objectid,objecttype);
CREATE INDEX principals2 ON principals USING btree (objectid);
CREATE UNIQUE INDEX queues1 ON queues USING btree (name);
CREATE INDEX tickets1 ON tickets USING btree (queue, status);
CREATE INDEX tickets2 ON tickets USING btree ("owner");
CREATE INDEX tickets3 ON tickets USING btree (effectiveid);
CREATE INDEX tickets4 ON tickets USING btree (id, status);
CREATE INDEX tickets5 ON tickets USING btree (id, effectiveid);
CREATE INDEX transactions1 ON transactions USING btree (objecttype, objectid);
CREATE UNIQUE INDEX users1 ON users USING btree (name);
CREATE INDEX users2 ON users USING btree (name);
CREATE INDEX users3 ON users USING btree (id, emailaddress);
CREATE INDEX users4 ON users USING btree (emailaddress);
VACUUM FULL ANALYZE acl;
VACUUM FULL ANALYZE attachments;
VACUUM FULL ANALYZE attributes;
VACUUM FULL ANALYZE cachedgroupmembers;
VACUUM FULL ANALYZE customfieldvalues;
VACUUM FULL ANALYZE customfields;
VACUUM FULL ANALYZE groupmembers;
VACUUM FULL ANALYZE groups;
VACUUM FULL ANALYZE links;
VACUUM FULL ANALYZE objectcustomfieldvalues;
VACUUM FULL ANALYZE objectcustomfields;
VACUUM FULL ANALYZE principals;
VACUUM FULL ANALYZE queues;
VACUUM FULL ANALYZE scripactions;
VACUUM FULL ANALYZE scripconditions;
VACUUM FULL ANALYZE scrips;
VACUUM FULL ANALYZE templates;
VACUUM FULL ANALYZE tickets;
VACUUM FULL ANALYZE transactions;
VACUUM FULL ANALYZE users;