SET client_encoding = 'UTF8';

CREATE TABLE cid_sid
(
  cid INTEGER NOT NULL,
  sid INTEGER NOT NULL,
  typ CHAR(1) NOT NULL,

  PRIMARY KEY (cid, sid)
);

CREATE TABLE cid_synonym
(
  cid INTEGER NOT NULL,
  syn VARCHAR(1000) NOT NULL,

  PRIMARY KEY (cid, syn)
);

CREATE TABLE tmp_cid_synonym
(
  cid INTEGER NOT NULL,
  syn VARCHAR(1000) NOT NULL
);