-- Table: categorias25830

-- DROP TABLE categorias25830;

CREATE TABLE categorias25830
(
  pid serial NOT NULL,
  geom geometry(Point,25830),
  merchant_category_key character varying,
  merchant_sub_category_key character varying,
  merchant_latitude double precision,
  merchant_longitude double precision,
  n_transacciones_total integer,
  ingresos double precision,
  CONSTRAINT categorias25830_pkey PRIMARY KEY (pid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE categorias25830
  OWNER TO postgres;

-- Index: sidx_categorias25830_geom

-- DROP INDEX sidx_categorias25830_geom;

CREATE INDEX sidx_categorias25830_geom
  ON categorias25830
  USING gist
  (geom);