--
--

\connect - postgres


--
-- TOC entry 2 (OID 8867406)
-- Name: master_sku_descr; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE master_sku_descr (
    group_code text,
    sku text,
    sku_descr text,
    dep_code text,
    dep_descr text,
    cat_code text,
    cat_descr text,
    subcat_code text,
    subcat_descr text,
    control_code text,
    control_descr text,
    supplier_code text,
    supplier_descr text
) WITHOUT OIDS;


--
-- TOC entry 9 (OID 8867411)
-- Name: master_sku_descr_idx2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx2 ON master_sku_descr USING btree (group_code, sku, dep_code, cat_code, subcat_code, control_code);


--
-- TOC entry 18 (OID 8867412)
-- Name: master_sku_descr_uidx3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_uidx3 ON master_sku_descr USING btree (sku);


--
-- TOC entry 3 (OID 8867413)
-- Name: master_sku_descr_idx1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx1 ON master_sku_descr USING btree (group_code, sku, control_code);


--
-- TOC entry 13 (OID 8867414)
-- Name: master_sku_descr_idx6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx6 ON master_sku_descr USING btree (group_code, sku);


--
-- TOC entry 17 (OID 8867415)
-- Name: master_sku_descr_uidx1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX master_sku_descr_uidx1 ON master_sku_descr USING btree (sku, group_code);


--
-- TOC entry 10 (OID 8867416)
-- Name: master_sku_descr_idx3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx3 ON master_sku_descr USING btree (group_code);


--
-- TOC entry 11 (OID 8867417)
-- Name: master_sku_descr_idx4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx4 ON master_sku_descr USING btree (sku_descr);


--
-- TOC entry 12 (OID 8867418)
-- Name: master_sku_descr_idx5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx5 ON master_sku_descr USING btree (dep_code);


--
-- TOC entry 14 (OID 8867419)
-- Name: master_sku_descr_idx7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx7 ON master_sku_descr USING btree (dep_descr);


--
-- TOC entry 15 (OID 8867420)
-- Name: master_sku_descr_idx8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx8 ON master_sku_descr USING btree (cat_code);


--
-- TOC entry 16 (OID 8867421)
-- Name: master_sku_descr_idx9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx9 ON master_sku_descr USING btree (subcat_descr);


--
-- TOC entry 4 (OID 8867422)
-- Name: master_sku_descr_idx10; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx10 ON master_sku_descr USING btree (subcat_code);


--
-- TOC entry 5 (OID 8867423)
-- Name: master_sku_descr_idx11; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx11 ON master_sku_descr USING btree (control_code);


--
-- TOC entry 6 (OID 8867424)
-- Name: master_sku_descr_idx12; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx12 ON master_sku_descr USING btree (control_descr);


--
-- TOC entry 7 (OID 8867425)
-- Name: master_sku_descr_idx13; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx13 ON master_sku_descr USING btree (supplier_code);


--
-- TOC entry 8 (OID 8867426)
-- Name: master_sku_descr_idx14; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX master_sku_descr_idx14 ON master_sku_descr USING btree (supplier_descr);


