On Wed, 30 Jul 2014 09:10:29 +0400
Pavel Pimenov <pavel.pime...@gmail.com> wrote:
> CREATE TABLE fly_hash_block(tth_id integer PRIMARY KEY NOT NULL, tth
> number NOT NULL);
> INSERT INTO fly_hash_block VALUES(1,1);
> INSERT INTO fly_hash_block VALUES(2,2);
> INSERT INTO fly_hash_block VALUES(3,2);
> *CREATE UNIQUE INDEX iu_fly_hash_block_tth ON fly_hash_block(tth);*
Not an answer if the table already exists, but a better solution would
be to constrain the table:
sqlite> CREATE TABLE fly_hash_block(
tth_id integer PRIMARY KEY NOT NULL,
tth number not null UNIQUE);
sqlite> INSERT INTO fly_hash_block VALUES(1,1);
sqlite> INSERT INTO fly_hash_block VALUES(2,2);
sqlite> INSERT INTO fly_hash_block VALUES(3,2);
Error: column tth is not unique
sqlite>
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
