startdate => { type => 'date', default => 'now' },
enddate => { type => 'date' },
notes => { type => 'text' },
- role => { type => 'text' },
sales => { type => 'boolean', default => 'true' },
itime => { type => 'timestamp', default => 'now()' },
mtime => { type => 'timestamp' },
addr4 => { type => 'text' },
homephone => { type => 'text' },
workphone => { type => 'text' },
+ deleted => { type => 'boolean', default => 'false' },
],
primary_key_columns => [ 'id' ],