devops/postgres/upgrade/0.0.2.6.sql

   1     CREATE TABLE public.ngrams_postag (
   2         id SERIAL,
   3         lang_id INTEGER,
   4         algo_id INTEGER,
   5         postag CHARACTER varying(5),
   6         ngrams_id INTEGER NOT NULL,
   7         lemm_id   INTEGER NOT NULL,
   8         score     INTEGER DEFAULT 1 ::integer NOT NULL,
   9         FOREIGN KEY (ngrams_id) REFERENCES public.ngrams(id) ON DELETE CASCADE,
  10         FOREIGN KEY (lemm_id)   REFERENCES public.ngrams(id) ON DELETE CASCADE
  11     )  ;
  12     -- ALTER TABLE public.ngrams_postag OWNER TO gargantua;
  13
  14     CREATE UNIQUE INDEX ON public.ngrams_postag (lang_id,algo_id,postag,ngrams_id,lemm_id);
  15
  16