Secondary literature table rename: migration tasks

[fjorba]

There are a few db migration tasks for the secondary literature table rename. As they are scattered among different issues, I think that it is better to document them in a single one, so @xhero can find them easily:

• Table "catalogues" (rename to: "publications", see Proposal: use Publications instead of Catalogues for Secondary literature #975; done in 1fb8c04)

Columns:

• t.string "name" (rename to: "short_name", see Proposal: rename the "name" column to "short_name" in the Secondary literature table #1027; done in 94f021b)
• (new integer field -> "record_type", see Should secondary literature have more than one template? #1013, Allow different templates for secondary literature #1043, Add record_type to publications #1102)
  t.string "author"
  [not sure yet] (new string field -> "author_d", to match sources table)
• t.string "description" (rename to: "title", see Secondary literature: change 240 to 245 #626, Rename description to title in publications #1104)
  [not sure yet] (new string field -> "title_d", to match sources table)
• t.string "revue_title" (rename to: "journal", see Secondary literature: change 240 to 245 #626, Rename revue_title to journal in Publications #1162)
  [not sure yet] (new string field -> "journal_d", to match sources table)
  t.string "volume"
  [not sure yet] ] (new string field) -> "number" (not discussed yet anywhere, but it is needed because many academic journals have both volume and number; or a single one, but they are not interchangeable)
  t.string "place"
  t.string "date"
  t.string "pages"
  t.integer "wf_audit", default: 0
  t.integer "wf_stage", default: 0
  t.string "wf_notes"
  t.integer "wf_owner", default: 0
  t.integer "wf_version", default: 0
  t.integer "src_count", default: 0
  t.datetime "created_at"
  t.datetime "updated_at"
• t.text "marc_source" (change type to: mediumtext, see Please change column type marc_source to mediumtext #792; done in 8162261)
  t.integer "lock_version", default: 0, null: false
  t.index ["name"], name: "index_catalogues_on_name"
  t.index ["wf_stage"], name: "index_catalogues_on_wf_stage"

[xhero]

I did the first step! The others (like renaming) will need a bit of testing so I would like to do them as a next step. We are planning a release next week, I think we can add all these mods just after (we plan another one in a month or so)

[fjorba]

Of course; please let me know which steps am I supposed to do, because I cannot easily distinguish them. I think that db migration changes should be done by you, @xhero, but if you consider that there is something in the software that I should take care of, please let me know and I'll do my best.