I put id, pid and tstamp fields into all tables I create within modules as a matter of course, whether they are needed or not. Typolight always wants id, sometimes pid (to store parent id), often tstamp (to store a Unix timestamp.... the number of seconds since Jan 1, 1970).
Code:
CREATE TABLE `tl_joblistings_jobs` (
`id` int(12) NOT NULL auto_increment,
`pid` int(5) unsigned zerofill NOT NULL default '00000',
`tstamp` int(10) unsigned NOT NULL default '0',
`job_category` varchar(64) NOT NULL default '',
etc
Bookmarks