CREATE TABLE stock_location
(
  id serial NOT NULL,
  parent_left integer,
  parent_right integer,
  create_uid integer,
  create_date timestamp without time zone,
  write_date timestamp without time zone,
  write_uid integer,
  comment text, -- Additional Information
  address_id integer, -- Location Address
  chained_delay integer, -- Chaining Lead Time
  chained_company_id integer, -- Chained Company
  active boolean, -- Active
  posz integer, -- Height (Z)
  posx integer, -- Corridor (X)
  posy integer, -- Shelves (Y)
  valuation_in_account_id integer, -- Stock Valuation Account (Incoming)
  location_id integer, -- Parent Location
  icon character varying(64), -- Icon
  valuation_out_account_id integer, -- Stock Valuation Account (Outgoing)
  scrap_location boolean, -- Scrap Location
  name character varying(64) NOT NULL, -- Location Name
  chained_location_id integer, -- Chained Location If Fixed
  chained_journal_id integer, -- Chaining Journal
  chained_picking_type character varying, -- Shipping Type
  company_id integer, -- Company
  chained_auto_packing character varying NOT NULL, -- Chaining Type
  complete_name character varying(256), -- Location Name
  usage character varying NOT NULL, -- Location Type
  chained_location_type character varying NOT NULL, -- Chained Location Type
  base_location boolean, -- Base
  excluir_reporte_stock boolean, -- Excluir del stock
  CONSTRAINT stock_location_pkey PRIMARY KEY (id),
  CONSTRAINT stock_location_address_id_fkey FOREIGN KEY (address_id)
      REFERENCES res_partner_address (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_chained_company_id_fkey FOREIGN KEY (chained_company_id)
      REFERENCES res_company (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_chained_journal_id_fkey FOREIGN KEY (chained_journal_id)
      REFERENCES stock_journal (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_chained_location_id_fkey FOREIGN KEY (chained_location_id)
      REFERENCES stock_location (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_company_id_fkey FOREIGN KEY (company_id)
      REFERENCES res_company (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_create_uid_fkey FOREIGN KEY (create_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_valuation_in_account_id_fkey FOREIGN KEY (valuation_in_account_id)
      REFERENCES account_account (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_valuation_out_account_id_fkey FOREIGN KEY (valuation_out_account_id)
      REFERENCES account_account (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL,
  CONSTRAINT stock_location_write_uid_fkey FOREIGN KEY (write_uid)
      REFERENCES res_users (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE SET NULL
)
WITH (
  OIDS=FALSE
);
ALTER TABLE stock_location
  OWNER TO openerp;
GRANT ALL ON TABLE stock_location TO openerp;
GRANT SELECT ON TABLE stock_location TO lectura;
GRANT SELECT ON TABLE stock_location TO esb_msp;
GRANT SELECT ON TABLE stock_location TO consulta;
GRANT ALL ON TABLE stock_location TO inven_lectu;
GRANT SELECT ON TABLE stock_location TO "wladimir.quijije";
GRANT SELECT ON TABLE stock_location TO "diego.molina";
GRANT SELECT ON TABLE stock_location TO "fausto.suarez";
COMMENT ON TABLE stock_location
  IS 'Location';
COMMENT ON COLUMN stock_location.comment IS 'Additional Information';
COMMENT ON COLUMN stock_location.address_id IS 'Location Address';
COMMENT ON COLUMN stock_location.chained_delay IS 'Chaining Lead Time';
COMMENT ON COLUMN stock_location.chained_company_id IS 'Chained Company';
COMMENT ON COLUMN stock_location.active IS 'Active';
COMMENT ON COLUMN stock_location.posz IS 'Height (Z)';
COMMENT ON COLUMN stock_location.posx IS 'Corridor (X)';
COMMENT ON COLUMN stock_location.posy IS 'Shelves (Y)';
COMMENT ON COLUMN stock_location.valuation_in_account_id IS 'Stock Valuation Account (Incoming)';
COMMENT ON COLUMN stock_location.location_id IS 'Parent Location';
COMMENT ON COLUMN stock_location.icon IS 'Icon';
COMMENT ON COLUMN stock_location.valuation_out_account_id IS 'Stock Valuation Account (Outgoing)';
COMMENT ON COLUMN stock_location.scrap_location IS 'Scrap Location';
COMMENT ON COLUMN stock_location.name IS 'Location Name';
COMMENT ON COLUMN stock_location.chained_location_id IS 'Chained Location If Fixed';
COMMENT ON COLUMN stock_location.chained_journal_id IS 'Chaining Journal';
COMMENT ON COLUMN stock_location.chained_picking_type IS 'Shipping Type';
COMMENT ON COLUMN stock_location.company_id IS 'Company';
COMMENT ON COLUMN stock_location.chained_auto_packing IS 'Chaining Type';
COMMENT ON COLUMN stock_location.complete_name IS 'Location Name';
COMMENT ON COLUMN stock_location.usage IS 'Location Type';
COMMENT ON COLUMN stock_location.chained_location_type IS 'Chained Location Type';
COMMENT ON COLUMN stock_location.base_location IS 'Base';
COMMENT ON COLUMN stock_location.excluir_reporte_stock IS 'Excluir del stock';


-- Index: idx_complete_name_tmp_2

-- DROP INDEX idx_complete_name_tmp_2;

CREATE INDEX idx_complete_name_tmp_2
  ON stock_location
  USING btree
  (complete_name COLLATE pg_catalog."default");

-- Index: stock_location_company_id_index

-- DROP INDEX stock_location_company_id_index;

CREATE INDEX stock_location_company_id_index
  ON stock_location
  USING btree
  (company_id);

-- Index: stock_location_location_id_index

-- DROP INDEX stock_location_location_id_index;

CREATE INDEX stock_location_location_id_index
  ON stock_location
  USING btree
  (location_id);

-- Index: stock_location_parent_left_index

-- DROP INDEX stock_location_parent_left_index;

CREATE INDEX stock_location_parent_left_index
  ON stock_location
  USING btree
  (parent_left);

-- Index: stock_location_parent_right_index

-- DROP INDEX stock_location_parent_right_index;

CREATE INDEX stock_location_parent_right_index
  ON stock_location
  USING btree
  (parent_right);

-- Index: stock_location_usage_index

-- DROP INDEX stock_location_usage_index;

CREATE INDEX stock_location_usage_index
  ON stock_location
  USING btree
  (usage COLLATE pg_catalog."default");