Cecil Westerhof <cldwester...@gmail.com> wrote:
> In a create table I have:
> measureDate DATE UNIQUE DEFAULT
> (strftime('%Y-%m-%d', 'now')),
> but when I look with .schema, I get:
> measureDate DATE DEFAULT (Datetime('now')),
>
> The UNIQUE constraint is disappeared and the DEFAULT is changed.
This sounds extremely unlikely. If I had to guess, I'd suspect you already have
the table in the database, with the old schema, and the new CREATE TABLE
statement fails.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
