fix schema.rb so rake db:setup can complete

[afomi]

Hi,

I cloned theoj and tried to run rake db:setup, but ran into errors for:

• submitted_at
• location
• user_id

These fields also appear to referenced in code, so I added them back to schema.rb so the db setup task completes successfully.

[arfon]

Hrm, not sure why this is out of sync. What happens if you run rake db:migrate on a fresh install?

[afomi]

Hi @arfon, I saw the errors on a fresh install.

The schema.rb does not contain submitted_at, location, or user_id, but they are referenced in seeds.rb.

[afomi]

I tried rake db:drop db:create db:migrate, and it was successful.

But then I get an error on rake db:seed.

(Which I interpret as the same symptom and cause - the missing fields on Paper, in schema.rb)

[arfon]

Ah OK, thanks for spotting this @afomi. It seems like the seeds are out of date (i.e. they're referencing columns that have since been changed). Looking at schema.rb I believe these are the correct mappings for the seed data:

submitted_at -> created_at
location -> document_location
user_id -> submittor_id

[arfon]

...also, since this isn't an issue with the actual schema (i.e. the schema is correct) I'm going to close this. Feel free to suggest some changes to the seed data - it sounds like we haven't been keeping that up to date :-\