On 4/16/2012 12:51 PM, Mr. Puneet Kishor wrote:
On Apr 16, 2012, at 11:47 AM, Patrik Nilsson wrote:
You can use:
create table t ( id integer primary key autoincrement, created_on
DATETIME DEFAULT CURRENT_TIMESTAMP )
No, the above will create a PK on only the 'id' column. I want a composite PK
with 'id' and 'created_on' columns
Why? What purpose do you believe a composite key would serve, that
would not be served equally well with a primary key on id column alone?
In any case, SQLite only supports AUTOINCREMENT on a column declared
INTEGER PRIMARY KEY.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
