misspelled table

-- Table: misspelled

-- DROP TABLE misspelled;

CREATE TABLE misspelled
(
  word text,
  url text,
  occnum BIGINT,
  proper BOOLEAN,
  scanid BIGINT,
  CONSTRAINT misspelled_scanid_fkey FOREIGN KEY (scanid)
      REFERENCES scans (scanid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT misspelled_word_url_scanid_key UNIQUE (word, url, scanid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE misspelled
  OWNER TO postgres;

-- Index: test_scanid

-- DROP INDEX test_scanid;

CREATE INDEX test_scanid
  ON misspelled
  USING btree
  (word COLLATE pg_catalog."default", scanid);