An alternative formulation of the problem:

<blockquote><verbatim>
CREATE TABLE t0(
  c0,
  c1 UNIQUE,
  PRIMARY KEY(c1, c1)
) WITHOUT ROWID;
INSERT INTO t0(c0,c1) VALUES('abc','xyz');
CREATE TABLE t1(
  c0,
  c1 UNIQUE,
  PRIMARY KEY(c1, c1)
) WITHOUT ROWID;
INSERT INTO t1 SELECT * FROM t0;