+-- TOC entry 81 (OID 622207)
+-- Name: contents_pageid_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX contents_pageid_idx ON contents USING btree (pageid);
+
+
+--
+-- TOC entry 85 (OID 622519)
+-- Name: hostnames_name_uq; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE UNIQUE INDEX hostnames_name_uq ON hostnames USING btree (name);
+
+
+--
+-- TOC entry 93 (OID 622520)
+-- Name: usercookies_cookie_idx; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX usercookies_cookie_idx ON usercookies USING btree (cookie);
+
+
+--
+-- TOC entry 75 (OID 623111)
+-- Name: pages_lc_title; Type: INDEX; Schema: public; Owner: rich
+--
+
+CREATE INDEX pages_lc_title ON pages USING btree (lower(title));
+
+
+--
+-- TOC entry 76 (OID 536012)