On Thu, 2007-12-27 at 08:10 -0800, Bill Moseley wrote: > sqlite> .schema photos > CREATE TABLE photos ( > id INTEGER PRIMARY KEY NOT NULL, > time INTEGER NOT NULL, > directory_path STRING NOT NULL, > name STRING NOT NULL, > description TEXT NOT NULL, > roll_id INTEGER NOT NULL, > default_version_id INTEGER NOT NULL > ); > > (The id is AUTOINCREMENT -- not sure why sqlite doesn't show that.) >
Because according to the documentation: > Specifying a PRIMARY KEY normally just creates a UNIQUE index on the > corresponding columns. However, if primary key is on a single column > that has datatype INTEGER, then that column is used internally as the > actual key of the B-Tree for the table. In short specifying id as it is is enough. :-) Hub _______________________________________________ F-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
