[sqlite] auto-incrementing integer in composite primary key

[Mr. Puneet Kishor]

Given

        CREATE TABLE t (
                id INTEGER NOT NULL,
                created_on DATETIME DEFAULT CURRENT_TIMESTAMP
                PRIMARY KEY (id, created_on)
        );

how can I make just the 'id' column auto-increment?


--
Puneet Kishor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users