Any idea why I get the error (above) when I try to create the table
below?

CREATE TABLE jobhistory (jobnum INTEGER not null, id VARCHAR(255)
not null UNIQUE, name VARCHAR(255) not null, submitter VARCHAR(255)
not null, location VARCHAR(255) not null, created INTEGER
DEFAULT '0', submitted INTEGER DEFAULT '0', started INTEGER
DEFAULT '0', ended INTEGER DEFAULT '0', status INTEGER DEFAULT '0',
PRIMARY KEY (jobnum))

Thanks,
-Jeff