Data for the sample database. Should be in its own file:

# Create the contractor tables

customer customer_id[integer] name

customer2project customer_id[integer] project_id[integer]

project project_id[integer] name

project2contact project_id[integer] contact_id[integer]

contact contact_id[integer] forename surname directline[char(20)] mobile[char(20)] email address[char(80)] postcode[char(10)] country[char(20)] switchboard[char(20)] fax[char(20)] url

# Duration is counted in seconds activity action_id[integer] project_id[integer] rate_id[integer] start[date] finish[date] duration[integer] notes[char(255)]

action action_id[integer] name

rate rate_id[integer] name

# Due is counted in UK pennies invoice invoice_id[integer] customer_id[integer] project_id[integer] due[integer] raised[date] paid[date]

# Duration is counted in seconds invoice_item invoice_id[integer] action_id[integer] rate_id[integer] duration[integer]