Re: [sqlite] Re: Performance tuning, and other (silly?) SQLite questions.

On Mon, 2007-11-19 at 18:14 -0500, Igor Tandetnik wrote: > James Steward > wrote: > > db eval {CREATE TABLE position(\ > > position_id INTEGER PRIMARY_KEY, \ > > odo INTEGER, \ > > time CURRENT_TIMESTAMP);} > > You probably meant > > -- note no underscore between PRIMARY and KEY > position_id

[sqlite] Re: Performance tuning, and other (silly?) SQLite questions.

James Steward wrote: db eval {CREATE TABLE position(\ position_id INTEGER PRIMARY_KEY, \ odo INTEGER, \ time CURRENT_TIMESTAMP);} You probably meant -- note no underscore between PRIMARY and KEY position_id INTEGER PRIMARY KEY -- note DEFAULT keyword time DEFAULT CURRENT_TIMESTAMP db eval