-- Table: merlion

-- DROP TABLE merlion;

CREATE TABLE merlion
(
  id serial NOT NULL,
  article text,
  name text,
  fav boolean DEFAULT false,
  CONSTRAINT merlion_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE merlion
  OWNER TO postgres;
GRANT ALL ON TABLE merlion TO postgres;
GRANT ALL ON TABLE merlion TO public;

-- Index: merlion_article_idx

-- DROP INDEX merlion_article_idx;

CREATE INDEX merlion_article_idx
  ON merlion
  USING btree
  (article COLLATE pg_catalog."default");

-- Index: merlion_name_idx

-- DROP INDEX merlion_name_idx;

CREATE INDEX merlion_name_idx
  ON merlion
  USING btree
  (name COLLATE pg_catalog."default");

-- Index: merlion_name_ops

-- DROP INDEX merlion_name_ops;

CREATE INDEX merlion_name_ops
  ON merlion
  USING gin
  (name COLLATE pg_catalog."default" gin_trgm_ops);

-- Table: merlion_d

-- DROP TABLE merlion_d;

CREATE TABLE merlion_d
(
  id serial NOT NULL,
  id_article integer,
  pricedate date,
  cost text,
  CONSTRAINT merlion_d_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE merlion_d
  OWNER TO postgres;
GRANT ALL ON TABLE merlion_d TO postgres;
GRANT ALL ON TABLE merlion_d TO public;

-- Index: merlion_d_id_article_idx

-- DROP INDEX merlion_d_id_article_idx;

CREATE INDEX merlion_d_id_article_idx
  ON merlion_d
  USING btree
  (id_article);

-- Index: merlion_d_id_article_pricedate_idx

-- DROP INDEX merlion_d_id_article_pricedate_idx;

CREATE INDEX merlion_d_id_article_pricedate_idx
  ON merlion_d
  USING btree
  (id_article, pricedate);

-- Index: merlion_d_pricedate_idx

-- DROP INDEX merlion_d_pricedate_idx;

CREATE INDEX merlion_d_pricedate_idx
  ON merlion_d
  USING btree
  (pricedate);