API tools faq
paste
palx

fresh install.log

palx
Aug 19th, 2021
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 95.44 KB | None | 0 0
raw download clone embed print report
  1. # /var/www/alaveteli.myfoia.org/alaveteli/log/install.log
  2. # after running:
  3. # sudo sh install-site.sh alaveteli alaveteli-usr alaveteli.myfoia.org >> install-sh.log
  4. # on Ubuntu 18.04
  5. # see also: production.log https://pastebin.com/8JUaAJj0
  6.  
  7. ==== Installing alaveteli
  8. Updating package lists... done
  9. Installing some core packages...
  10.   apt-utils... done
  11.   git... done
  12.   locales... done
  13.   lockfile-progs... done
  14.   curl... done
  15.   dnsutils... done
  16.   lsb-release... done
  17. Testing for being on EC2... done
  18. Generating locales...
  19. Generating locale en_GB... already done
  20. done
  21. Adding unix user... done
  22. Updating APT sources... done
  23. Cloning or updating repository... cloning... Submodule path 'commonlib': checked out '5fb846276502efc8c35a0155e2c336230427fffe'
  24. done
  25. Updating mySociety APT source... OK
  26. done
  27. Hit:1 http://archive.ubuntu.com/ubuntu focal InRelease
  28. Ign:2 http://debian.mysociety.org bionic InRelease
  29. Hit:3 http://debian.mysociety.org bionic Release
  30. Hit:4 http://nova.clouds.archive.ubuntu.com/ubuntu bionic InRelease
  31. Hit:5 http://security.ubuntu.com/ubuntu bionic-security InRelease
  32. Hit:7 http://nova.clouds.archive.ubuntu.com/ubuntu bionic-updates InRelease
  33. Hit:8 http://nova.clouds.archive.ubuntu.com/ubuntu bionic-backports InRelease
  34. Reading package lists...
  35. Setting hostname...
  36. Installing nginx... done
  37. Adding site to nginx... done
  38. Your branch is up-to-date with 'origin/master'.
  39. Installing postfix... done
  40. Restarting rsyslog (via systemctl): rsyslog.service.
  41. Installing packages from repository packages file...
  42.   done
  43. Current Ruby (2.5.1) is less than required version (2.5.8)
  44. Installing packages required for ruby-build...
  45. Checking for postgres template_utf8 database... Created.done
  46. Install rbenv & ruby-build
  47. make: Entering directory '/home/alaveteli-usr/.rbenv/src'
  48. gcc -fPIC     -c -o realpath.o realpath.c
  49. gcc -shared -Wl,-soname,../libexec/rbenv-realpath.dylib  -o ../libexec/rbenv-realpath.dylib realpath.o
  50. make: Leaving directory '/home/alaveteli-usr/.rbenv/src'
  51. Installing Ruby 2.5.8
  52. Successfully installed bundler-2.2.26
  53. Parsing documentation for bundler-2.2.26
  54. Installing ri documentation for bundler-2.2.26
  55. Done installing documentation for bundler after 5 seconds
  56. 1 gem installed
  57. Creating the database alaveteli_production
  58. Creating the database alaveteli_test
  59. Creating the database alaveteli_development
  60. Running rails-post-deploy
  61. Running bundle install with options: --path /home/alaveteli-usr/bundle/
  62. Fetching gem metadata from https://rubygems.org/.........
  63. Fetching https://github.com/technoweenie/acts_as_versioned.git
  64. Fetching https://github.com/mysociety/ruby-msg.git
  65. Fetching https://github.com/mysociety/strip_attributes.git
  66. Fetching https://github.com/stripe-ruby-mock/stripe-ruby-mock
  67. Fetching rake 13.0.3
  68. Installing rake 13.0.3
  69. Fetching concurrent-ruby 1.1.8
  70. Installing concurrent-ruby 1.1.8
  71. Fetching i18n 1.8.10
  72. Installing i18n 1.8.10
  73. Fetching minitest 5.14.4
  74. Installing minitest 5.14.4
  75. Fetching thread_safe 0.3.6
  76. Installing thread_safe 0.3.6
  77. Fetching tzinfo 1.2.9
  78. Installing tzinfo 1.2.9
  79. Fetching activesupport 5.2.6
  80. Installing activesupport 5.2.6
  81. Fetching builder 3.2.4
  82. Installing builder 3.2.4
  83. Fetching erubi 1.10.0
  84. Installing erubi 1.10.0
  85. Fetching mini_portile2 2.5.3
  86. Installing mini_portile2 2.5.3
  87. Fetching racc 1.5.2
  88. Installing racc 1.5.2 with native extensions
  89. Fetching nokogiri 1.11.7 (x86_64-linux)
  90. Installing nokogiri 1.11.7 (x86_64-linux)
  91. Fetching rails-dom-testing 2.0.3
  92. Installing rails-dom-testing 2.0.3
  93. Fetching crass 1.0.6
  94. Installing crass 1.0.6
  95. Fetching loofah 2.9.1
  96. Installing loofah 2.9.1
  97. Fetching rails-html-sanitizer 1.3.0
  98. Installing rails-html-sanitizer 1.3.0
  99. Fetching actionview 5.2.6
  100. Installing actionview 5.2.6
  101. Fetching rack 2.2.3
  102. Installing rack 2.2.3
  103. Fetching rack-test 1.1.0
  104. Installing rack-test 1.1.0
  105. Fetching actionpack 5.2.6
  106. Installing actionpack 5.2.6
  107. Fetching nio4r 2.5.2
  108. Installing nio4r 2.5.2 with native extensions
  109. Fetching websocket-extensions 0.1.5
  110. Installing websocket-extensions 0.1.5
  111. Fetching websocket-driver 0.7.3
  112. Installing websocket-driver 0.7.3 with native extensions
  113. Fetching actioncable 5.2.6
  114. Installing actioncable 5.2.6
  115. Fetching globalid 0.4.2
  116. Installing globalid 0.4.2
  117. Fetching activejob 5.2.6
  118. Installing activejob 5.2.6
  119. Fetching mini_mime 1.1.0
  120. Installing mini_mime 1.1.0
  121. Fetching mail 2.7.1
  122. Installing mail 2.7.1
  123. Fetching actionmailer 5.2.6
  124. Installing actionmailer 5.2.6
  125. Fetching activemodel 5.2.6
  126. Installing activemodel 5.2.6
  127. Fetching rotp 6.2.0
  128. Installing rotp 6.2.0
  129. Fetching active_model_otp 2.2.0
  130. Installing active_model_otp 2.2.0
  131. Fetching arel 9.0.0
  132. Installing arel 9.0.0
  133. Fetching activerecord 5.2.6
  134. Installing activerecord 5.2.6
  135. Fetching marcel 1.0.1
  136. Installing marcel 1.0.1
  137. Fetching activestorage 5.2.6
  138. Installing activestorage 5.2.6
  139. Using acts_as_versioned 0.6.0 from https://github.com/technoweenie/acts_as_versioned.git (at 63b1fc8@63b1fc8)
  140. Fetching public_suffix 4.0.6
  141. Installing public_suffix 4.0.6
  142. Fetching addressable 2.8.0
  143. Installing addressable 2.8.0
  144. Fetching flipper 0.17.2
  145. Installing flipper 0.17.2
  146. Fetching flipper-active_record 0.17.2
  147. Installing flipper-active_record 0.17.2
  148. Fetching mime-types 2.99.3
  149. Installing mime-types 2.99.3
  150. Using bundler 2.2.26
  151. Fetching method_source 0.9.2
  152. Installing method_source 0.9.2
  153. Fetching thor 1.1.0
  154. Installing thor 1.1.0
  155. Fetching railties 5.2.6
  156. Installing railties 5.2.6
  157. Fetching sprockets 3.7.2
  158. Installing sprockets 3.7.2
  159. Fetching sprockets-rails 3.2.2
  160. Installing sprockets-rails 3.2.2
  161. Fetching rails 5.2.6
  162. Installing rails 5.2.6
  163. Using alaveteli_features 0.0.1 from source at `gems/alaveteli_features`
  164. Fetching annotate 3.1.0
  165. Installing annotate 3.1.0
  166. Fetching ast 2.4.1
  167. Installing ast 2.4.1
  168. Fetching bcrypt 3.1.16
  169. Installing bcrypt 3.1.16 with native extensions
  170. Fetching bindex 0.7.0
  171. Installing bindex 0.7.0 with native extensions
  172. Fetching sass 3.4.25
  173. Installing sass 3.4.25
  174. Fetching bootstrap-sass 2.3.2.2
  175. Installing bootstrap-sass 2.3.2.2
  176. Fetching uniform_notifier 1.14.1
  177. Installing uniform_notifier 1.14.1
  178. Fetching bullet 6.1.4
  179. Installing bullet 6.1.4
  180. Fetching byebug 11.0.1
  181. Installing byebug 11.0.1 with native extensions
  182. Fetching cancancan 3.2.2
  183. Installing cancancan 3.2.2
  184. Fetching highline 2.0.0
  185. Installing highline 2.0.0
  186. Fetching net-ssh 6.1.0
  187. Installing net-ssh 6.1.0
  188. Fetching net-scp 1.2.1
  189. Installing net-scp 1.2.1
  190. Fetching net-sftp 2.1.2
  191. Installing net-sftp 2.1.2
  192. Fetching net-ssh-gateway 2.0.0
  193. Installing net-ssh-gateway 2.0.0
  194. Fetching capistrano 2.15.9
  195. Installing capistrano 2.15.9
  196. Fetching regexp_parser 1.7.1
  197. Installing regexp_parser 1.7.1
  198. Fetching xpath 3.2.0
  199. Installing xpath 3.2.0
  200. Fetching capybara 3.15.1
  201. Installing capybara 3.15.1
  202. Fetching charlock_holmes 0.7.7
  203. Installing charlock_holmes 0.7.7 with native extensions
  204. Fetching coderay 1.1.2
  205. Installing coderay 1.1.2
  206. Fetching rexml 3.2.5
  207. Installing rexml 3.2.5
  208. Fetching crack 0.4.5
  209. Installing crack 0.4.5
  210. Fetching csv 3.2.0
  211. Installing csv 3.2.0
  212. Fetching daemons 1.4.0
  213. Installing daemons 1.4.0
  214. Fetching dalli 2.7.11
  215. Installing dalli 2.7.11
  216. Fetching dante 0.2.0
  217. Installing dante 0.2.0
  218. Fetching diff-lcs 1.4.4
  219. Installing diff-lcs 1.4.4
  220. Fetching docile 1.3.5
  221. Installing docile 1.3.5
  222. Fetching dynamic_form 1.1.4
  223. Installing dynamic_form 1.1.4
  224. Fetching eventmachine 1.2.7
  225. Installing eventmachine 1.2.7 with native extensions
  226. Fetching exception_notification 4.4.3
  227. Installing exception_notification 4.4.3
  228. Fetching execjs 2.7.0
  229. Installing execjs 2.7.0
  230. Fetching factory_bot 5.2.0
  231. Installing factory_bot 5.2.0
  232. Fetching factory_bot_rails 5.2.0
  233. Installing factory_bot_rails 5.2.0
  234. Fetching fancybox-rails 0.3.1
  235. Installing fancybox-rails 0.3.1
  236. Fetching fast_gettext 2.0.3
  237. Installing fast_gettext 2.0.3
  238. Fetching ffi 1.15.0
  239. Installing ffi 1.15.0 with native extensions
  240. Fetching fivemat 1.3.7
  241. Installing fivemat 1.3.7
  242. Fetching gender_detector 2.0.0
  243. Installing gender_detector 2.0.0
  244. Fetching locale 2.1.3
  245. Installing locale 2.1.3
  246. Fetching rubyzip 1.3.0
  247. Installing rubyzip 1.3.0
  248. Fetching red-datasets 0.1.4
  249. Installing red-datasets 0.1.4
  250. Fetching text 1.3.1
  251. Installing text 1.3.1
  252. Fetching gettext 3.3.8
  253. Installing gettext 3.3.8
  254. Fetching gettext_i18n_rails 1.8.1
  255. Installing gettext_i18n_rails 1.8.1
  256. Fetching request_store 1.4.1
  257. Installing request_store 1.4.1
  258. Fetching globalize 5.2.0
  259. Installing globalize 5.2.0
  260. Fetching gnuplot 2.6.2
  261. Installing gnuplot 2.6.2
  262. Fetching hashdiff 1.0.1
  263. Installing hashdiff 1.0.1
  264. Fetching hodel_3000_compliant_logger 0.1.1
  265. Installing hodel_3000_compliant_logger 0.1.1
  266. Fetching holidays 7.1.0
  267. Installing holidays 7.1.0
  268. Fetching htmlentities 4.3.4
  269. Installing htmlentities 4.3.4
  270. Fetching ice_cube 0.16.3
  271. Installing ice_cube 0.16.3
  272. Fetching icalendar 2.5.3
  273. Installing icalendar 2.5.3
  274. Fetching iso_country_codes 0.7.8
  275. Installing iso_country_codes 0.7.8
  276. Fetching jaro_winkler 1.5.4
  277. Installing jaro_winkler 1.5.4 with native extensions
  278. Fetching jquery-rails 4.4.0
  279. Installing jquery-rails 4.4.0
  280. Fetching jquery-ui-rails 6.0.1
  281. Installing jquery-ui-rails 6.0.1
  282. Fetching json 2.5.1
  283. Installing json 2.5.1 with native extensions
  284. Fetching launchy 2.4.3
  285. Installing launchy 2.4.3
  286. Fetching libv8-node 15.14.0.1 (x86_64-linux-musl)
  287. Installing libv8-node 15.14.0.1 (x86_64-linux-musl)
  288. Fetching rb-fsevent 0.10.4
  289. Installing rb-fsevent 0.10.4
  290. Fetching rb-inotify 0.10.1
  291. Installing rb-inotify 0.10.1
  292. Fetching listen 3.5.0
  293. Installing listen 3.5.0
  294. Fetching mahoro 0.5
  295. Installing mahoro 0.5 with native extensions
  296. Fetching maxmind-db 1.0.0
  297. Installing maxmind-db 1.0.0
  298. Fetching mini_magick 4.11.0
  299. Installing mini_magick 4.11.0
  300. Fetching mini_racer 0.4.0
  301. Installing mini_racer 0.4.0 with native extensions
  302. Fetching money 6.16.0
  303. Installing money 6.16.0
  304. Fetching multi_json 1.13.1
  305. Installing multi_json 1.13.1
  306. Fetching oink 0.10.1
  307. Installing oink 0.10.1
  308. Fetching open4 1.3.4
  309. Installing open4 1.3.4
  310. Fetching parallel 1.19.2
  311. Installing parallel 1.19.2
  312. Fetching parser 2.7.1.4
  313. Installing parser 2.7.1.4
  314. Fetching pg 1.2.3
  315. Installing pg 1.2.3 with native extensions
  316. Fetching pry 0.12.2
  317. Installing pry 0.12.2
  318. Fetching pry-byebug 3.7.0
  319. Installing pry-byebug 3.7.0
  320. Fetching rack-ssl 1.4.1
  321. Installing rack-ssl 1.4.1
  322. Fetching rack-utf8_sanitizer 1.7.0
  323. Installing rack-utf8_sanitizer 1.7.0
  324. Fetching rails-controller-testing 1.0.5
  325. Installing rails-controller-testing 1.0.5
  326. Fetching rails-i18n 5.1.3
  327. Installing rails-i18n 5.1.3
  328. Fetching rainbow 3.0.0
  329. Installing rainbow 3.0.0
  330. Fetching recaptcha 5.6.0
  331. Installing recaptcha 5.6.0
  332. Fetching rolify 5.3.0
  333. Installing rolify 5.3.0
  334. Fetching routing-filter 0.6.3
  335. Installing routing-filter 0.6.3
  336. Fetching rspec-support 3.10.2
  337. Installing rspec-support 3.10.2
  338. Fetching rspec-mocks 3.10.2
  339. Installing rspec-mocks 3.10.2
  340. Fetching rspec-activemodel-mocks 1.1.0
  341. Installing rspec-activemodel-mocks 1.1.0
  342. Fetching rspec-core 3.10.1
  343. Installing rspec-core 3.10.1
  344. Fetching rspec-expectations 3.10.1
  345. Installing rspec-expectations 3.10.1
  346. Fetching rspec-rails 5.0.1
  347. Installing rspec-rails 5.0.1
  348. Fetching ruby-progressbar 1.10.1
  349. Installing ruby-progressbar 1.10.1
  350. Fetching unicode-display_width 1.7.0
  351. Installing unicode-display_width 1.7.0
  352. Fetching rubocop 0.81.0
  353. Installing rubocop 0.81.0
  354. Fetching rubocop-performance 1.5.2
  355. Installing rubocop-performance 1.5.2
  356. Fetching rubocop-rails 2.5.2
  357. Installing rubocop-rails 2.5.2
  358. Fetching ruby-ole 1.2.12.1
  359. Installing ruby-ole 1.2.12.1
  360. Fetching vpim 13.11.11
  361. Installing vpim 13.11.11
  362. Using ruby-msg 1.5.2 from https://github.com/mysociety/ruby-msg.git (at ascii-encoding@fae72e5)
  363. Fetching tilt 2.0.8
  364. Installing tilt 2.0.8
  365. Fetching sass-rails 5.0.7
  366. Installing sass-rails 5.0.7
  367. Fetching secure_headers 6.3.2
  368. Installing secure_headers 6.3.2
  369. Fetching simplecov-html 0.10.2
  370. Installing simplecov-html 0.10.2
  371. Fetching simplecov 0.17.1
  372. Installing simplecov 0.17.1
  373. Fetching simplecov-lcov 0.7.0
  374. Installing simplecov-lcov 0.7.0
  375. Fetching statistics2 0.54
  376. Installing statistics2 0.54 with native extensions
  377. Using strip_attributes 1.11.0 from https://github.com/mysociety/strip_attributes.git (at globalize3-rails5.2@62a5e1e)
  378. Fetching stripe 5.34.0
  379. Installing stripe 5.34.0
  380. Using stripe-ruby-mock 3.0.1 from https://github.com/stripe-ruby-mock/stripe-ruby-mock (at 2c925fd@2c925fd)
  381. Fetching syslog_protocol 0.9.2
  382. Installing syslog_protocol 0.9.2
  383. Fetching thin 1.8.1
  384. Installing thin 1.8.1 with native extensions
  385. Fetching uglifier 4.2.0
  386. Installing uglifier 4.2.0
  387. Fetching unicode 0.4.4.4
  388. Installing unicode 0.4.4.4 with native extensions
  389. Fetching unidecoder 1.1.2
  390. Installing unidecoder 1.1.2
  391. Fetching web-console 3.7.0
  392. Installing web-console 3.7.0
  393. Fetching webmock 3.13.0
  394. Installing webmock 3.13.0
  395. Fetching will_paginate 3.3.0
  396. Installing will_paginate 3.3.0
  397. Fetching xapian-full-alaveteli 1.4.18.1
  398. Installing xapian-full-alaveteli 1.4.18.1 with native extensions
  399. Fetching xml-simple 1.1.8
  400. Installing xml-simple 1.1.8
  401. Fetching zip_tricks 5.6.0
  402. Installing zip_tricks 5.6.0
  403. Bundle complete! 86 Gemfile dependencies, 171 gems now installed.
  404. Bundled gems are installed into `/home/alaveteli-usr/bundle/`
  405. Post-install message from gender_detector:
  406. For unicode support you'll need to also install the unicode_utils or activesupport gem
  407. Post-install message from icalendar:
  408. ActiveSupport is required for TimeWithZone support, but not required for general use.
  409. Installing theme alavetelitheme from git://github.com/mysociety/alavetelitheme.git
  410. 9280b9493a83ca1cbc2b3eb1317e0f06c4e16273
  411. Checking out origin/develop
  412. Running install hook in /var/www/alaveteli.myfoia.org/alaveteli/lib/themes/alavetelitheme
  413. Running post_install hook in /var/www/alaveteli.myfoia.org/alaveteli/lib/themes/alavetelitheme
  414. alavetelitheme successfully installed in: /var/www/alaveteli.myfoia.org/alaveteli/lib/themes/alavetelitheme
  415.  
  416. Can't download the latest MaxMind geoip data file. Please add MAXMIND_LICENSE_KEY setting to config/general.yml
  417. == 1 CreateUsers: migrating ===================================================
  418. -- create_table(:users, {:id=>:integer})
  419.    -> 0.0057s
  420. == 1 CreateUsers: migrated (0.0058s) ==========================================
  421.  
  422. == 2 AddSessions: migrating ===================================================
  423. -- create_table(:sessions, {:id=>:integer})
  424.    -> 0.0060s
  425. -- add_index(:sessions, :session_id)
  426.    -> 0.0041s
  427. -- add_index(:sessions, :updated_at)
  428.    -> 0.0029s
  429. == 2 AddSessions: migrated (0.0131s) ==========================================
  430.  
  431. == 4 CreateInfoRequests: migrating ============================================
  432. -- create_table(:info_requests, {:id=>:integer})
  433.    -> 0.0038s
  434. == 4 CreateInfoRequests: migrated (0.0038s) ===================================
  435.  
  436. == 5 CreatePublicBodies: migrating ============================================
  437. -- create_table(:public_bodies, {:id=>:integer})
  438.    -> 0.0043s
  439. == 5 CreatePublicBodies: migrated (0.0043s) ===================================
  440.  
  441. == 6 VersionPublicBody: migrating =============================================
  442. -- add_timestamps(:public_body_versions, {:null=>false})
  443.    -> 0.0011s
  444. == 6 VersionPublicBody: migrated (0.0189s) ====================================
  445.  
  446. == 7 AddPublicBodyEditorNotes: migrating ======================================
  447. -- add_column(:public_bodies, :last_edit_editor, :string, {})
  448.    -> 0.0006s
  449. -- add_column(:public_bodies, :last_edit_comment, :string, {})
  450.    -> 0.0005s
  451. -- add_column(:public_body_versions, :last_edit_editor, :string, {})
  452.    -> 0.0005s
  453. -- add_column(:public_body_versions, :last_edit_comment, :string, {})
  454.    -> 0.0004s
  455. == 7 AddPublicBodyEditorNotes: migrated (0.0022s) =============================
  456.  
  457. == 8 RequestHasPublicBody: migrating ==========================================
  458. -- add_column(:info_requests, :public_body_id, :integer, {})
  459.    -> 0.0005s
  460. == 8 RequestHasPublicBody: migrated (0.0006s) =================================
  461.  
  462. == 9 CreateOutgoingMessages: migrating ========================================
  463. -- create_table(:outgoing_messages, {:id=>:integer})
  464.    -> 0.0047s
  465. == 9 CreateOutgoingMessages: migrated (0.0048s) ===============================
  466.  
  467. == 10 RemovePublicBodyIdFromOutgoingMessages: migrating =======================
  468. -- remove_column(:outgoing_messages, :public_body_id)
  469.    -> 0.0013s
  470. == 10 RemovePublicBodyIdFromOutgoingMessages: migrated (0.0014s) ==============
  471.  
  472. == 11 AddCreatedUpdatedFields: migrating ======================================
  473. -- add_column(:info_requests, :created_at, :datetime, {})
  474.    -> 0.0007s
  475. -- add_column(:info_requests, :updated_at, :datetime, {})
  476.    -> 0.0006s
  477. -- add_column(:public_bodies, :created_at, :datetime, {})
  478.    -> 0.0005s
  479. -- add_column(:public_bodies, :updated_at, :datetime, {})
  480.    -> 0.0005s
  481. -- add_column(:sessions, :created_at, :datetime, {})
  482.    -> 0.0006s
  483. -- add_column(:users, :created_at, :datetime, {})
  484.    -> 0.0006s
  485. -- add_column(:users, :updated_at, :datetime, {})
  486.    -> 0.0005s
  487. == 11 AddCreatedUpdatedFields: migrated (0.0042s) =============================
  488.  
  489. == 12 AddSentOutgoingMessage: migrating =======================================
  490. -- add_column(:outgoing_messages, :sent_at, :datetime, {})
  491.    -> 0.0006s
  492. == 12 AddSentOutgoingMessage: migrated (0.0007s) ==============================
  493.  
  494. == 13 CreateIncomingMessages: migrating =======================================
  495. -- create_table(:incoming_messages, {:id=>:integer})
  496.    -> 0.0048s
  497. == 13 CreateIncomingMessages: migrated (0.0049s) ==============================
  498.  
  499. == 14 CreatePostRedirects: migrating ==========================================
  500. -- create_table(:post_redirects, {:id=>:integer})
  501.    -> 0.0043s
  502. == 14 CreatePostRedirects: migrated (0.0044s) =================================
  503.  
  504. == 15 AddEmailTokenToPostRedirects: migrating =================================
  505. -- add_column(:post_redirects, :email_token, :text, {})
  506.    -> 0.0006s
  507. == 15 AddEmailTokenToPostRedirects: migrated (0.0006s) ========================
  508.  
  509. == 16 AddReasonsToPostRedirects: migrating ====================================
  510. -- add_column(:post_redirects, :reason_params_yaml, :text, {})
  511.    -> 0.0005s
  512. -- add_column(:post_redirects, :user_id, :integer, {})
  513.    -> 0.0006s
  514. == 16 AddReasonsToPostRedirects: migrated (0.0012s) ===========================
  515.  
  516. == 17 AddEmailConfirmedToUsers: migrating =====================================
  517. -- add_column(:users, :email_confirmed, :boolean, {:default=>false})
  518.    -> 0.0043s
  519. == 17 AddEmailConfirmedToUsers: migrated (0.0044s) ============================
  520.  
  521. == 18 AddResponseTypeToIncomingMessage: migrating =============================
  522. -- add_column(:incoming_messages, :user_classified, :boolean, {:default=>false})
  523.    -> 0.0044s
  524. -- add_column(:incoming_messages, :contains_information, :boolean, {:default=>false})
  525.    -> 0.0047s
  526. -- create_table(:rejection_reasons, {:id=>:integer})
  527.    -> 0.0043s
  528. == 18 AddResponseTypeToIncomingMessage: migrated (0.0136s) ====================
  529.  
  530. == 21 RemoveContainsInformationDefault: migrating =============================
  531. -- change_column(:incoming_messages, :contains_information, :boolean, {})
  532.    -> 0.0010s
  533. -- drop_table(:rejection_reasons)
  534.    -> 0.0010s
  535. == 21 RemoveContainsInformationDefault: migrated (0.0046s) ====================
  536.  
  537. == 22 CreateInfoRequestEvents: migrating ======================================
  538. -- create_table(:info_request_events, {:id=>:integer})
  539.    -> 0.0045s
  540. == 22 CreateInfoRequestEvents: migrated (0.0127s) =============================
  541.  
  542. == 23 OutgoingMessageLastSentAt: migrating ====================================
  543. -- rename_column(:outgoing_messages, :sent_at, :last_sent_at)
  544.    -> 0.0024s
  545. == 23 OutgoingMessageLastSentAt: migrated (0.0025s) ===========================
  546.  
  547. == 24 AddIsBounceToIncomingMessages: migrating ================================
  548. -- add_column(:incoming_messages, :is_bounce, :boolean, {:default=>false})
  549.    -> 0.0045s
  550. == 24 AddIsBounceToIncomingMessages: migrated (0.0188s) =======================
  551.  
  552. == 25 AddFollowupToOutgoingMessage: migrating =================================
  553. -- add_column(:outgoing_messages, :incoming_message_followup_id, :integer, {})
  554.    -> 0.0007s
  555. == 25 AddFollowupToOutgoingMessage: migrated (0.0008s) ========================
  556.  
  557. == 26 AddManyNullConstraints: migrating =======================================
  558. -- change_column(:users, :email, :string, {})
  559.    -> 0.0006s
  560. -- change_column(:users, :name, :string, {})
  561.    -> 0.0005s
  562. -- change_column(:users, :hashed_password, :string, {})
  563.    -> 0.0006s
  564. -- change_column(:users, :salt, :string, {})
  565.    -> 0.0005s
  566. -- change_column(:users, :created_at, :datetime, {})
  567.    -> 0.0005s
  568. -- change_column(:users, :updated_at, :datetime, {})
  569.    -> 0.0005s
  570. -- change_column(:users, :email_confirmed, :boolean, {})
  571.    -> 0.0008s
  572. -- change_column(:public_bodies, :name, :text, {})
  573.    -> 0.0006s
  574. -- change_column(:public_bodies, :short_name, :text, {})
  575.    -> 0.0005s
  576. -- change_column(:public_bodies, :request_email, :text, {})
  577.    -> 0.0006s
  578. -- change_column(:public_bodies, :version, :integer, {})
  579.    -> 0.0005s
  580. -- change_column(:public_bodies, :last_edit_editor, :string, {})
  581.    -> 0.0006s
  582. -- change_column(:public_bodies, :last_edit_comment, :text, {})
  583.    -> 0.0005s
  584. -- change_column(:public_bodies, :created_at, :datetime, {})
  585.    -> 0.0005s
  586. -- change_column(:public_bodies, :updated_at, :datetime, {})
  587.    -> 0.0005s
  588. -- change_column(:post_redirects, :token, :text, {})
  589.    -> 0.0006s
  590. -- change_column(:post_redirects, :uri, :text, {})
  591.    -> 0.0005s
  592. -- change_column(:post_redirects, :created_at, :datetime, {})
  593.    -> 0.0004s
  594. -- change_column(:post_redirects, :updated_at, :datetime, {})
  595.    -> 0.0004s
  596. -- change_column(:post_redirects, :email_token, :text, {})
  597.    -> 0.0005s
  598. -- change_column(:outgoing_messages, :info_request_id, :integer, {})
  599.    -> 0.0006s
  600. -- change_column(:outgoing_messages, :body, :text, {})
  601.    -> 0.0006s
  602. -- change_column(:outgoing_messages, :status, :string, {})
  603.    -> 0.0005s
  604. -- change_column(:outgoing_messages, :message_type, :string, {})
  605.    -> 0.0006s
  606. -- change_column(:outgoing_messages, :created_at, :datetime, {})
  607.    -> 0.0006s
  608. -- change_column(:outgoing_messages, :updated_at, :datetime, {})
  609.    -> 0.0005s
  610. -- change_column(:info_requests, :title, :text, {})
  611.    -> 0.0007s
  612. -- change_column(:info_requests, :user_id, :integer, {})
  613.    -> 0.0005s
  614. -- change_column(:info_requests, :public_body_id, :integer, {})
  615.    -> 0.0006s
  616. -- change_column(:info_requests, :created_at, :datetime, {})
  617.    -> 0.0006s
  618. -- change_column(:info_requests, :updated_at, :datetime, {})
  619.    -> 0.0006s
  620. -- change_column(:info_request_events, :info_request_id, :integer, {})
  621.    -> 0.0006s
  622. -- change_column(:info_request_events, :event_type, :text, {})
  623.    -> 0.0006s
  624. -- change_column(:info_request_events, :params_yaml, :text, {})
  625.    -> 0.0005s
  626. -- change_column(:info_request_events, :created_at, :datetime, {})
  627.    -> 0.0005s
  628. -- change_column(:incoming_messages, :info_request_id, :integer, {})
  629.    -> 0.0006s
  630. -- change_column(:incoming_messages, :raw_data, :text, {})
  631.    -> 0.0004s
  632. -- change_column(:incoming_messages, :created_at, :datetime, {})
  633.    -> 0.0005s
  634. -- change_column(:incoming_messages, :updated_at, :datetime, {})
  635.    -> 0.0005s
  636. -- change_column(:incoming_messages, :user_classified, :boolean, {})
  637.    -> 0.0008s
  638. -- change_column(:incoming_messages, :is_bounce, :boolean, {})
  639.    -> 0.0007s
  640. == 26 AddManyNullConstraints: migrated (0.0571s) ==============================
  641.  
  642. == 27 ChangeClassificationSystem: migrating ===================================
  643. -- remove_column(:incoming_messages, :contains_information)
  644.    -> 0.0005s
  645. -- remove_column(:incoming_messages, :user_classified)
  646.    -> 0.0005s
  647. -- add_column(:info_requests, :described_state, :string, {})
  648.    -> 0.0007s
  649. -- change_column(:info_requests, :described_state, :string, {})
  650.    -> 0.0005s
  651. -- add_column(:info_requests, :awaiting_description, :boolean, {:default=>false, :null=>false})
  652.    -> 0.0056s
  653. -- add_column(:info_requests, :described_last_incoming_message_id, :integer, {})
  654.    -> 0.0005s
  655. == 27 ChangeClassificationSystem: migrated (0.0121s) ==========================
  656.  
  657. == 28 GiveIncomingMessagesEvents: migrating ===================================
  658. == 28 GiveIncomingMessagesEvents: migrated (0.0035s) ==========================
  659.  
  660. == 29 AddDescribeStatusHistory: migrating =====================================
  661. -- add_column(:info_request_events, :described_state, :string, {})
  662.    -> 0.0007s
  663. -- remove_column(:info_requests, :described_last_incoming_message_id)
  664.    -> 0.0005s
  665. == 29 AddDescribeStatusHistory: migrated (0.0013s) ============================
  666.  
  667. == 30 AddSomeIndices: migrating ===============================================
  668. -- execute("create index users_lower_email_index on users(lower(email))")
  669.    -> 0.0019s
  670. -- add_index(:info_requests, :created_at)
  671.    -> 0.0032s
  672. -- add_index(:info_requests, :title)
  673.    -> 0.0029s
  674. -- execute("create index public_bodies_url_short_name_index on public_bodies(regexp_replace(replace(lower(short_name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
  675.    -> 0.0018s
  676. -- execute("create index public_body_versions_url_short_name_index on public_body_versions(regexp_replace(replace(lower(short_name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
  677.    -> 0.0020s
  678. -- execute("create index users_url_name_index on users (regexp_replace(replace(lower(name), ' ', '-'), '[^a-z0-9_-]', '', 'g'))")
  679.    -> 0.0021s
  680. -- add_index(:post_redirects, :email_token)
  681.    -> 0.0037s
  682. -- add_index(:post_redirects, :token)
  683.    -> 0.0030s
  684. == 30 AddSomeIndices: migrated (0.0210s) ======================================
  685.  
  686. == 31 AddIndicesForSessionDeletion: migrating =================================
  687. -- add_index(:post_redirects, :updated_at)
  688.    -> 0.0032s
  689. == 31 AddIndicesForSessionDeletion: migrated (0.0033s) ========================
  690.  
  691. == 32 Addforeignkeys: migrating ===============================================
  692. -- execute("ALTER TABLE incoming_messages ADD CONSTRAINT fk_incoming_messages_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  693.    -> 0.0026s
  694. -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  695.    -> 0.0014s
  696. -- execute("ALTER TABLE info_requests ADD CONSTRAINT fk_info_requests_user FOREIGN KEY (user_id) REFERENCES users(id)")
  697.    -> 0.0014s
  698. -- execute("ALTER TABLE info_requests ADD CONSTRAINT fk_info_requests_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  699.    -> 0.0012s
  700. -- execute("ALTER TABLE outgoing_messages ADD CONSTRAINT fk_outgoing_messages_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  701.    -> 0.0014s
  702. -- execute("ALTER TABLE outgoing_messages ADD CONSTRAINT fk_incoming_message_followup_info_request FOREIGN KEY (incoming_message_followup_id) REFERENCES incoming_messages(id)")
  703.    -> 0.0010s
  704. -- execute("ALTER TABLE post_redirects ADD CONSTRAINT fk_post_redirects_user FOREIGN KEY (user_id) REFERENCES users(id)")
  705.    -> 0.0015s
  706. -- execute("ALTER TABLE public_body_versions ADD CONSTRAINT fk_public_body_versions_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  707.    -> 0.0016s
  708. == 32 Addforeignkeys: migrated (0.0125s) ======================================
  709.  
  710. == 33 AddProminence: migrating ================================================
  711. -- add_column(:info_requests, :prominence, :string, {:null=>false, :default=>"normal"})
  712.    -> 0.0073s
  713. == 33 AddProminence: migrated (0.0074s) =======================================
  714.  
  715. == 34 RunSolrIndexing: migrating ==============================================
  716. == 34 RunSolrIndexing: migrated (0.0000s) =====================================
  717.  
  718. == 35 TrackOverdueAlerts: migrating ===========================================
  719. -- create_table(:user_info_request_sent_alerts, {:id=>:integer})
  720.    -> 0.0053s
  721. -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_info_request_sent_alerts_user FOREIGN KEY (user_id) REFERENCES users(id)")
  722.    -> 0.0015s
  723. -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_info_request_sent_alerts_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  724.    -> 0.0015s
  725. == 35 TrackOverdueAlerts: migrated (0.0085s) ==================================
  726.  
  727. == 36 AddPublicBodyTags: migrating ============================================
  728. -- create_table(:public_body_tags, {:id=>:integer})
  729.    -> 0.0053s
  730. -- execute("ALTER TABLE public_body_tags ADD CONSTRAINT fk_public_body_tags_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  731.    -> 0.0012s
  732. -- add_index(:public_body_tags, [:public_body_id, :name], {:unique=>true})
  733.    -> 0.0033s
  734. == 36 AddPublicBodyTags: migrated (0.0100s) ===================================
  735.  
  736. == 37 AddUrlName: migrating ===================================================
  737. -- add_column(:public_bodies, :url_name, :text, {})
  738.    -> 0.0007s
  739. -- add_column(:public_body_versions, :url_name, :text, {})
  740.    -> 0.0006s
  741. -- add_index(:public_bodies, :url_name, {:unique=>true})
  742.    -> 0.0032s
  743. -- change_column(:public_bodies, :url_name, :text, {})
  744.    -> 0.0010s
  745. == 37 AddUrlName: migrated (0.0102s) ==========================================
  746.  
  747. == 38 AddMoreUrlNames: migrating ==============================================
  748. -- add_column(:users, :url_name, :text, {})
  749.    -> 0.0008s
  750. -- add_index(:users, :url_name)
  751.    -> 0.0031s
  752. -- change_column(:users, :url_name, :text, {})
  753.    -> 0.0011s
  754. == 38 AddMoreUrlNames: migrated (0.0128s) =====================================
  755.  
  756. == 39 RequestUrlNames: migrating ==============================================
  757. -- add_column(:info_requests, :url_title, :text, {})
  758.    -> 0.0007s
  759. -- add_index(:info_requests, :url_title, {:unique=>true})
  760.    -> 0.0034s
  761. -- change_column(:info_requests, :url_title, :text, {})
  762.    -> 0.0010s
  763. == 39 RequestUrlNames: migrated (0.0072s) =====================================
  764.  
  765. == 40 EmailIsUnique: migrating ================================================
  766. -- execute("create unique index users_email_index on users (lower(email))")
  767.    -> 0.0017s
  768. -- execute("drop index users_url_name_index")
  769.    -> 0.0005s
  770. -- execute("drop index public_bodies_url_short_name_index")
  771.    -> 0.0007s
  772. -- execute("drop index public_body_versions_url_short_name_index")
  773.    -> 0.0007s
  774. == 40 EmailIsUnique: migrated (0.0037s) =======================================
  775.  
  776. == 41 IndexRequestsWithSolr: migrating ========================================
  777. -- add_column(:info_requests, :solr_up_to_date, :boolean, {:default=>false, :null=>false})
  778.    -> 0.0093s
  779. -- add_index(:info_requests, :solr_up_to_date)
  780.    -> 0.0036s
  781. == 41 IndexRequestsWithSolr: migrated (0.0131s) ===============================
  782.  
  783. == 42 UniqueUserUrls: migrating ===============================================
  784. -- remove_index(:users, {:column=>:url_name, :name=>"index_users_on_url_name"})
  785.    -> 0.0027s
  786. -- add_index(:users, :url_name, {:unique=>true})
  787.    -> 0.0031s
  788. == 42 UniqueUserUrls: migrated (0.0082s) ======================================
  789.  
  790. == 43 RemoveComplaintEmail: migrating =========================================
  791. -- remove_column(:public_body_versions, :complaint_email)
  792.    -> 0.0005s
  793. -- remove_column(:public_bodies, :complaint_email)
  794.    -> 0.0005s
  795. == 43 RemoveComplaintEmail: migrated (0.0011s) ================================
  796.  
  797. == 44 RemoveIsBounce: migrating ===============================================
  798. -- remove_column(:incoming_messages, :is_bounce)
  799.    -> 0.0007s
  800. == 44 RemoveIsBounce: migrated (0.0007s) ======================================
  801.  
  802. == 45 AddCircumstanceToPostRedirect: migrating ================================
  803. -- add_column(:post_redirects, :circumstance, :text, {:default=>"normal"})
  804.    -> 0.0074s
  805. -- change_column(:post_redirects, :circumstance, :text, {})
  806.    -> 0.0009s
  807. == 45 AddCircumstanceToPostRedirect: migrated (0.0203s) =======================
  808.  
  809. == 46 AddLastEventIdToAlertTable: migrating ===================================
  810. -- add_column(:user_info_request_sent_alerts, :info_request_event_id, :integer, {:default=>nil})
  811.    -> 0.0009s
  812. -- execute("ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_user_info_request_sent_alert_info_request_event FOREIGN KEY (info_request_event_id) REFERENCES info_request_events(id)")
  813.    -> 0.0011s
  814. -- execute("create unique index user_info_request_sent_alerts_unique_index on user_info_request_sent_alerts (user_id, info_request_id, alert_type, coalesce(info_request_event_id, -1))")
  815.    -> 0.0018s
  816. == 46 AddLastEventIdToAlertTable: migrated (0.0040s) ==========================
  817.  
  818. == 47 AddCalculatedState: migrating ===========================================
  819. -- add_column(:info_request_events, :calculated_state, :string, {:default=>nil})
  820.    -> 0.0010s
  821. == 47 AddCalculatedState: migrated (0.0011s) ==================================
  822.  
  823. == 48 AddCalculatedStateAt: migrating =========================================
  824. -- add_column(:info_request_events, :last_described_at, :datetime, {})
  825.    -> 0.0007s
  826. == 48 AddCalculatedStateAt: migrated (0.0007s) ================================
  827.  
  828. == 49 TrackThings: migrating ==================================================
  829. -- create_table(:track_things, {:id=>:integer})
  830.    -> 0.0055s
  831. -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_tracking_user FOREIGN KEY (tracking_user_id) REFERENCES users(id)")
  832.    -> 0.0020s
  833. -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_tracked_user FOREIGN KEY (tracked_user_id) REFERENCES users(id)")
  834.    -> 0.0012s
  835. -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  836.    -> 0.0012s
  837. -- execute("ALTER TABLE track_things ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  838.    -> 0.0016s
  839. -- create_table(:track_things_sent_emails, {:id=>:integer})
  840.    -> 0.0039s
  841. -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_info_request_event FOREIGN KEY (info_request_event_id) REFERENCES info_request_events(id)")
  842.    -> 0.0015s
  843. -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_user FOREIGN KEY (user_id) REFERENCES users(id)")
  844.    -> 0.0014s
  845. -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (user_id) REFERENCES users(id)")
  846.    -> 0.0011s
  847. == 49 TrackThings: migrated (0.0199s) =========================================
  848.  
  849. == 50 ImproveTrackThings: migrating ===========================================
  850. -- add_column(:track_things, :track_type, :string, {:null=>false, :default=>"internal_error"})
  851.    -> 0.0053s
  852. -- add_column(:track_things, :created_at, :datetime, {})
  853.    -> 0.0005s
  854. -- add_column(:track_things, :updated_at, :datetime, {})
  855.    -> 0.0008s
  856. -- add_column(:track_things_sent_emails, :created_at, :datetime, {})
  857.    -> 0.0006s
  858. -- add_column(:track_things_sent_emails, :updated_at, :datetime, {})
  859.    -> 0.0006s
  860. -- add_column(:users, :last_daily_track_email, :datetime, {})
  861.    -> 0.0006s
  862. -- change_column(:users, :last_daily_track_email, :datetime, {})
  863.    -> 0.0005s
  864. == 50 ImproveTrackThings: migrated (0.0129s) ==================================
  865.  
  866. == 51 AddTrackThingsUniqueIndices: migrating ==================================
  867. -- add_index(:track_things, [:tracking_user_id, :track_query], {:unique=>true})
  868.    -> 0.0035s
  869. == 51 AddTrackThingsUniqueIndices: migrated (0.0036s) =========================
  870.  
  871. == 52 IncludeEventForeignReferences: migrating ================================
  872. -- add_column(:info_request_events, :incoming_message_id, :integer, {})
  873.    -> 0.0006s
  874. -- add_column(:info_request_events, :outgoing_message_id, :integer, {})
  875.    -> 0.0006s
  876. -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_incoming_message_id FOREIGN KEY (incoming_message_id) REFERENCES incoming_messages(id)")
  877.    -> 0.0011s
  878. -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_outgoing_message_id FOREIGN KEY (outgoing_message_id) REFERENCES outgoing_messages(id)")
  879.    -> 0.0011s
  880. == 52 IncludeEventForeignReferences: migrated (0.0197s) =======================
  881.  
  882. == 53 ActsAsXapianMigration: migrating ========================================
  883. -- create_table(:acts_as_xapian_jobs, {:id=>:integer})
  884.    -> 0.0043s
  885. -- add_index(:acts_as_xapian_jobs, [:model, :model_id], {:unique=>true})
  886.    -> 0.0030s
  887. -- remove_index(:info_requests, {:column=>:solr_up_to_date, :name=>"index_info_requests_on_solr_up_to_date"})
  888.    -> 0.0037s
  889. -- remove_column(:info_requests, :solr_up_to_date)
  890.    -> 0.0006s
  891. == 53 ActsAsXapianMigration: migrated (0.0142s) ===============================
  892.  
  893. == 54 AllowLongerComments: migrating ==========================================
  894. -- change_column(:public_body_versions, :last_edit_comment, :text, {})
  895.    -> 0.0007s
  896. == 54 AllowLongerComments: migrated (0.0008s) =================================
  897.  
  898. == 55 StopNewResponses: migrating =============================================
  899. -- add_column(:info_requests, :stop_new_responses, :boolean, {:default=>false, :null=>false})
  900.    -> 0.0079s
  901. == 55 StopNewResponses: migrated (0.0080s) ====================================
  902.  
  903. == 56 AddAttachmentText: migrating ============================================
  904. -- add_column(:incoming_messages, :cached_attachment_text, :text, {})
  905.    -> 0.0006s
  906. == 56 AddAttachmentText: migrated (0.0007s) ===================================
  907.  
  908. == 57 AddLawUsed: migrating ===================================================
  909. -- add_column(:info_requests, :law_used, :string, {:null=>false, :default=>"foi"})
  910.    -> 0.0077s
  911. == 57 AddLawUsed: migrated (0.0078s) ==========================================
  912.  
  913. == 58 RemoveSessions: migrating ===============================================
  914. -- drop_table(:sessions)
  915.    -> 0.0010s
  916. == 58 RemoveSessions: migrated (0.0011s) ======================================
  917.  
  918. == 59 AddUrlNotes: migrating ==================================================
  919. -- add_column(:public_bodies, :home_page, :text, {:null=>false, :default=>""})
  920.    -> 0.0050s
  921. -- add_column(:public_bodies, :notes, :text, {:null=>false, :default=>""})
  922.    -> 0.0052s
  923. -- add_column(:public_body_versions, :home_page, :text, {})
  924.    -> 0.0006s
  925. -- add_column(:public_body_versions, :notes, :text, {})
  926.    -> 0.0006s
  927. == 59 AddUrlNotes: migrated (0.0116s) =========================================
  928.  
  929. == 60 AddCachedMainText: migrating ============================================
  930. -- add_column(:incoming_messages, :cached_main_body_text, :text, {})
  931.    -> 0.0006s
  932. == 60 AddCachedMainText: migrated (0.0007s) ===================================
  933.  
  934. == 61 IncludeResponsesInTracks: migrating =====================================
  935. == 61 IncludeResponsesInTracks: migrated (0.0106s) ============================
  936.  
  937. == 62 AddComments: migrating ==================================================
  938. -- create_table(:comments, {:id=>:integer})
  939.    -> 0.0050s
  940. -- execute("ALTER TABLE comments ADD CONSTRAINT fk_comments_user FOREIGN KEY (user_id) REFERENCES users(id)")
  941.    -> 0.0012s
  942. -- execute("ALTER TABLE comments ADD CONSTRAINT fk_comments_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  943.    -> 0.0015s
  944. -- add_column(:info_request_events, :comment_id, :integer, {})
  945.    -> 0.0006s
  946. -- execute("ALTER TABLE info_request_events ADD CONSTRAINT fk_info_request_events_comment_id FOREIGN KEY (comment_id) REFERENCES comments(id)")
  947.    -> 0.0010s
  948. == 62 AddComments: migrated (0.0097s) =========================================
  949.  
  950. == 63 AddAdminUsers: migrating ================================================
  951. -- add_column(:users, :admin_level, :string, {:null=>false, :default=>"none"})
  952.    -> 0.0073s
  953. == 63 AddAdminUsers: migrated (0.0074s) =======================================
  954.  
  955. == 64 IndicesForAnnotations: migrating ========================================
  956. -- add_index(:info_request_events, :created_at)
  957.    -> 0.0030s
  958. -- add_index(:info_request_events, :info_request_id)
  959.    -> 0.0028s
  960. == 64 IndicesForAnnotations: migrated (0.0059s) ===============================
  961.  
  962. == 65 AddCommentsToUserTrack: migrating =======================================
  963. == 65 AddCommentsToUserTrack: migrated (0.0062s) ==============================
  964.  
  965. == 66 AddFirstLetter: migrating ===============================================
  966. -- add_column(:public_bodies, :first_letter, :string, {})
  967.    -> 0.0008s
  968. -- add_index(:public_bodies, :first_letter)
  969.    -> 0.0029s
  970. -- change_column(:public_bodies, :first_letter, :string, {})
  971.    -> 0.0010s
  972. == 66 AddFirstLetter: migrated (0.0063s) ======================================
  973.  
  974. == 67 FactorOutRawEmail: migrating ============================================
  975. -- create_table(:raw_emails, {:id=>:integer})
  976.    -> 0.0039s
  977. -- add_column(:incoming_messages, :raw_email_id, :integer, {:null=>true})
  978.    -> 0.0007s
  979. -- change_column(:incoming_messages, :raw_data, :text, {})
  980.    -> 0.0005s
  981. -- execute("ALTER TABLE incoming_messages ADD CONSTRAINT fk_incoming_messages_raw_email FOREIGN KEY (raw_email_id) REFERENCES raw_emails(id)")
  982.    -> 0.0015s
  983. -- change_column(:incoming_messages, :raw_email_id, :integer, {})
  984.    -> 0.0014s
  985. -- remove_column(:incoming_messages, :raw_data)
  986.    -> 0.0004s
  987. == 67 FactorOutRawEmail: migrated (0.0108s) ===================================
  988.  
  989. == 68 AddCensorTable: migrating ===============================================
  990. -- create_table(:censor_rules, {:id=>:integer})
  991.    -> 0.0042s
  992. -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  993.    -> 0.0012s
  994. -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_user FOREIGN KEY (user_id) REFERENCES users(id)")
  995.    -> 0.0015s
  996. -- execute("ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  997.    -> 0.0011s
  998. == 68 AddCensorTable: migrated (0.0082s) ======================================
  999.  
  1000. == 69 AddWhatDoing: migrating =================================================
  1001. -- add_column(:outgoing_messages, :what_doing, :string, {})
  1002.    -> 0.0006s
  1003. -- add_index(:outgoing_messages, :what_doing)
  1004.    -> 0.0031s
  1005. -- change_column(:outgoing_messages, :what_doing, :string, {})
  1006.    -> 0.0010s
  1007. == 69 AddWhatDoing: migrated (0.0181s) ========================================
  1008.  
  1009. == 70 SentAreWaitingResponse: migrating =======================================
  1010. == 70 SentAreWaitingResponse: migrated (0.0010s) ==============================
  1011.  
  1012. == 71 AddEximLog: migrating ===================================================
  1013. -- create_table(:exim_logs, {:id=>:integer})
  1014.    -> 0.0044s
  1015. -- create_table(:exim_log_dones, {:id=>:integer})
  1016.    -> 0.0042s
  1017. -- add_index(:exim_log_dones, :last_stat)
  1018.    -> 0.0032s
  1019. -- execute("ALTER TABLE exim_logs ADD CONSTRAINT fk_exim_log_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)")
  1020.    -> 0.0014s
  1021. -- execute("ALTER TABLE exim_logs ADD CONSTRAINT fk_exim_log_done FOREIGN KEY (exim_log_done_id) REFERENCES exim_log_dones(id)")
  1022.    -> 0.0012s
  1023. == 71 AddEximLog: migrated (0.0146s) ==========================================
  1024.  
  1025. == 72 AddPublicationScheme: migrating =========================================
  1026. -- add_column(:public_bodies, :publication_scheme, :text, {:null=>false, :default=>""})
  1027.    -> 0.0071s
  1028. -- add_column(:public_body_versions, :publication_scheme, :text, {:null=>false, :default=>""})
  1029.    -> 0.0051s
  1030. == 72 AddPublicationScheme: migrated (0.0123s) ================================
  1031.  
  1032. == 73 AddBanUser: migrating ===================================================
  1033. -- add_column(:users, :ban_text, :text, {:null=>false, :default=>""})
  1034.    -> 0.0067s
  1035. == 73 AddBanUser: migrated (0.0068s) ==========================================
  1036.  
  1037. == 74 CreateHolidays: migrating ===============================================
  1038. -- create_table(:holidays, {:id=>:integer})
  1039.    -> 0.0037s
  1040. -- add_index(:holidays, :day)
  1041.    -> 0.0028s
  1042. == 74 CreateHolidays: migrated (0.0562s) ======================================
  1043.  
  1044. == 75 AddCharityNumber: migrating =============================================
  1045. -- add_column(:public_bodies, :charity_number, :text, {:null=>false, :default=>""})
  1046.    -> 0.0068s
  1047. -- add_column(:public_body_versions, :charity_number, :text, {:null=>false, :default=>""})
  1048.    -> 0.0056s
  1049. == 75 AddCharityNumber: migrated (0.0125s) ====================================
  1050.  
  1051. == 76 AddIndices: migrating ===================================================
  1052. -- add_index(:track_things_sent_emails, :track_thing_id)
  1053.    -> 0.0034s
  1054. == 76 AddIndices: migrated (0.0035s) ==========================================
  1055.  
  1056. == 77 AddEximLogIndex: migrating ==============================================
  1057. -- add_index(:exim_logs, :exim_log_done_id)
  1058.    -> 0.0029s
  1059. == 77 AddEximLogIndex: migrated (0.0029s) =====================================
  1060.  
  1061. == 78 ExpandStopNewResponses: migrating =======================================
  1062. -- add_column(:info_requests, :allow_new_responses_from, :string, {})
  1063.    -> 0.0008s
  1064. -- change_column(:info_requests, :allow_new_responses_from, :string, {})
  1065.    -> 0.0008s
  1066. -- remove_column(:info_requests, :stop_new_responses)
  1067.    -> 0.0007s
  1068. -- add_column(:info_requests, :handle_rejected_responses, :string, {})
  1069.    -> 0.0005s
  1070. -- change_column(:info_requests, :handle_rejected_responses, :string, {})
  1071.    -> 0.0006s
  1072. == 78 ExpandStopNewResponses: migrated (0.0177s) ==============================
  1073.  
  1074. == 79 AddProfilePhoto: migrating ==============================================
  1075. -- create_table(:profile_photos, {:id=>:integer})
  1076.    -> 0.0048s
  1077. -- add_column(:users, :profile_photo_id, :integer, {:null=>true})
  1078.    -> 0.0007s
  1079. -- execute("ALTER TABLE profile_photos ADD CONSTRAINT fk_profile_photos_user FOREIGN KEY (user_id) REFERENCES users(id)")
  1080.    -> 0.0016s
  1081. -- execute("ALTER TABLE users ADD CONSTRAINT fk_users_profile_photo FOREIGN KEY (profile_photo_id) REFERENCES profile_photos(id)")
  1082.    -> 0.0010s
  1083. == 79 AddProfilePhoto: migrated (0.0083s) =====================================
  1084.  
  1085. == 80 CacheOnlyClippedAttachmentText: migrating ===============================
  1086. -- remove_column(:incoming_messages, :cached_attachment_text)
  1087.    -> 0.0006s
  1088. -- add_column(:incoming_messages, :cached_attachment_text_clipped, :text, {})
  1089.    -> 0.0005s
  1090. == 80 CacheOnlyClippedAttachmentText: migrated (0.0013s) ======================
  1091.  
  1092. == 81 AddEventProminence: migrating ===========================================
  1093. -- add_column(:info_request_events, :prominence, :string, {:null=>false, :default=>"normal"})
  1094.    -> 0.0062s
  1095. == 81 AddEventProminence: migrated (0.0063s) ==================================
  1096.  
  1097. == 82 ChangeRawEmailToBinary: migrating =======================================
  1098. -- change_column(:raw_emails, :data, :text, {})
  1099.    -> 0.0006s
  1100. -- rename_column(:raw_emails, :data, :data_text)
  1101.    -> 0.0015s
  1102. -- add_column(:raw_emails, :data_binary, :binary, {})
  1103.    -> 0.0005s
  1104. == 82 ChangeRawEmailToBinary: migrated (0.0033s) ==============================
  1105.  
  1106. == 83 AddIndicesTrackSent: migrating ==========================================
  1107. -- add_index(:track_things_sent_emails, :created_at)
  1108.    -> 0.0029s
  1109. == 83 AddIndicesTrackSent: migrated (0.0030s) =================================
  1110.  
  1111. == 84 AlterProfilePhoto: migrating ============================================
  1112. -- remove_column(:users, :profile_photo_id)
  1113.    -> 0.0010s
  1114. == 84 AlterProfilePhoto: migrated (0.0010s) ===================================
  1115.  
  1116. == 85 DraftProfilePhoto: migrating ============================================
  1117. -- add_column(:profile_photos, :draft, :boolean, {:default=>false, :null=>false})
  1118.    -> 0.0047s
  1119. == 85 DraftProfilePhoto: migrated (0.0048s) ===================================
  1120.  
  1121. == 86 AllowNullProfilePhotoUser: migrating ====================================
  1122. -- change_column(:profile_photos, :user_id, :integer, {})
  1123.    -> 0.0015s
  1124. == 86 AllowNullProfilePhotoUser: migrated (0.0021s) ===========================
  1125.  
  1126. == 87 AddAboutMe: migrating ===================================================
  1127. -- add_column(:users, :about_me, :text, {:null=>false, :default=>""})
  1128.    -> 0.0084s
  1129. == 87 AddAboutMe: migrated (0.0085s) ==========================================
  1130.  
  1131. == 88 PublicBodyMachineTags: migrating ========================================
  1132. -- add_column(:public_body_tags, :value, :text, {})
  1133.    -> 0.0006s
  1134. -- add_index(:public_body_tags, :name)
  1135.    -> 0.0033s
  1136. == 88 PublicBodyMachineTags: migrated (0.0040s) ===============================
  1137.  
  1138. == 89 RemoveCharityNumber: migrating ==========================================
  1139. -- remove_column(:public_bodies, :charity_number)
  1140.    -> 0.0009s
  1141. == 89 RemoveCharityNumber: migrated (0.0009s) =================================
  1142.  
  1143. == 90 RemoveTagUniqueness: migrating ==========================================
  1144. -- remove_index(:public_body_tags, {:column=>[:public_body_id, :name], :name=>"index_public_body_tags_on_public_body_id_and_name"})
  1145.    -> 0.0032s
  1146. -- add_index(:public_body_tags, [:public_body_id, :name, :value], {:unique=>true})
  1147.    -> 0.0030s
  1148. == 90 RemoveTagUniqueness: migrated (0.0072s) =================================
  1149.  
  1150. == 91 AddCensorRulesIndices: migrating ========================================
  1151. -- add_index(:censor_rules, :info_request_id)
  1152.    -> 0.0040s
  1153. -- add_index(:censor_rules, :user_id)
  1154.    -> 0.0037s
  1155. -- add_index(:censor_rules, :public_body_id)
  1156.    -> 0.0032s
  1157. == 91 AddCensorRulesIndices: migrated (0.0110s) ===============================
  1158.  
  1159. == 92 CacheOnlyMarkedBodyText: migrating ======================================
  1160. -- remove_column(:incoming_messages, :cached_main_body_text)
  1161.    -> 0.0008s
  1162. -- add_column(:incoming_messages, :cached_main_body_text_folded, :text, {})
  1163.    -> 0.0007s
  1164. -- add_column(:incoming_messages, :cached_main_body_text_unfolded, :text, {})
  1165.    -> 0.0008s
  1166. == 92 CacheOnlyMarkedBodyText: migrated (0.0025s) =============================
  1167.  
  1168. == 93 MoveToHasTagString: migrating ===========================================
  1169. -- rename_table(:public_body_tags, :has_tag_string_tags)
  1170.    -> 0.0079s
  1171. -- rename_column(:has_tag_string_tags, :public_body_id, :model_id)
  1172.    -> 0.0028s
  1173. -- add_column(:has_tag_string_tags, :model, :string, {})
  1174.    -> 0.0009s
  1175. -- change_column(:has_tag_string_tags, :model, :string, {})
  1176.    -> 0.0007s
  1177. -- add_index(:has_tag_string_tags, [:model, :model_id])
  1178.    -> 0.0030s
  1179. == 93 MoveToHasTagString: migrated (0.0199s) ==================================
  1180.  
  1181. == 94 RemoveOldTagsForeignKey: migrating ======================================
  1182. -- execute("ALTER TABLE has_tag_string_tags DROP CONSTRAINT fk_public_body_tags_public_body")
  1183.    -> 0.0007s
  1184. -- add_index(:has_tag_string_tags, [:model, :model_id, :name, :value], {:name=>"by_model_and_model_id_and_name_and_value"})
  1185.    -> 0.0029s
  1186. == 94 RemoveOldTagsForeignKey: migrated (0.0037s) =============================
  1187.  
  1188. == 95 AddPostRedirectUserIndex: migrating =====================================
  1189. -- add_index(:post_redirects, :user_id)
  1190.    -> 0.0031s
  1191. == 95 AddPostRedirectUserIndex: migrated (0.0031s) ============================
  1192.  
  1193. == 96 CreateTranslationTables: migrating ======================================
  1194. == 96 CreateTranslationTables: migrated (0.0193s) =============================
  1195.  
  1196. == 97 AddCommentLocale: migrating =============================================
  1197. -- add_column(:comments, :locale, :text, {:null=>false, :default=>""})
  1198.    -> 0.0048s
  1199. == 97 AddCommentLocale: migrated (0.0049s) ====================================
  1200.  
  1201. == 98 FixPublicBodyTranslations: migrating ====================================
  1202. -- execute("    update public_body_translations\n    set first_letter = upper(substr(name, 1, 1))\n    where first_letter is null\n    ;\n")
  1203.    -> 0.0008s
  1204. -- execute("    update public_body_translations\n    set publication_scheme = (SELECT public_bodies.publication_scheme FROM public_bodies WHERE\n                              public_body_translations.public_body_id = public_bodies.id )\n    where public_body_translations.publication_scheme is null\n    ;\n")
  1205.    -> 0.0006s
  1206. == 98 FixPublicBodyTranslations: migrated (0.0015s) ===========================
  1207.  
  1208. == 99 MoveRawEmailToFilesystem: migrating =====================================
  1209. == 99 MoveRawEmailToFilesystem: migrated (0.0099s) ============================
  1210.  
  1211. == 100 RemoveRedundantRawEmailColumns: migrating ==============================
  1212. -- remove_column(:raw_emails, :data_text)
  1213.    -> 0.0006s
  1214. -- remove_column(:raw_emails, :data_binary)
  1215.    -> 0.0005s
  1216. == 100 RemoveRedundantRawEmailColumns: migrated (0.0012s) =====================
  1217.  
  1218. == 101 AddHashToInfoRequest: migrating ========================================
  1219. -- add_column(:info_requests, :idhash, :string, {})
  1220.    -> 0.0009s
  1221. -- change_column(:info_requests, :idhash, :string, {})
  1222.    -> 0.0006s
  1223. == 101 AddHashToInfoRequest: migrated (0.0030s) ===============================
  1224.  
  1225. == 102 AddLocaleToUsers: migrating ============================================
  1226. -- add_column(:users, :locale, :string, {})
  1227.    -> 0.0007s
  1228. == 102 AddLocaleToUsers: migrated (0.0007s) ===================================
  1229.  
  1230. == 103 AddUserBounceColumns: migrating ========================================
  1231. -- add_column(:users, :email_bounced_at, :datetime, {})
  1232.    -> 0.0007s
  1233. -- add_column(:users, :email_bounce_message, :text, {:default=>"", :null=>false})
  1234.    -> 0.0075s
  1235. == 103 AddUserBounceColumns: migrated (0.0083s) ===============================
  1236.  
  1237. == 104 CreateFoiAttachments: migrating ========================================
  1238. -- create_table(:foi_attachments, {:id=>:integer})
  1239.    -> 0.0042s
  1240. == 104 CreateFoiAttachments: migrated (0.0043s) ===============================
  1241.  
  1242. == 105 ExtendIncomingMessage: migrating =======================================
  1243. -- add_column(:incoming_messages, :sent_at, :time, {})
  1244.    -> 0.0007s
  1245. -- add_column(:incoming_messages, :subject, :text, {})
  1246.    -> 0.0005s
  1247. -- add_column(:incoming_messages, :safe_mail_from, :text, {})
  1248.    -> 0.0006s
  1249. -- add_column(:incoming_messages, :mail_from_domain, :text, {})
  1250.    -> 0.0005s
  1251. -- add_column(:incoming_messages, :valid_to_reply_to, :boolean, {})
  1252.    -> 0.0006s
  1253. == 105 ExtendIncomingMessage: migrated (0.0032s) ==============================
  1254.  
  1255. == 106 AddHexDigestToFoiAttachment: migrating =================================
  1256. -- add_column(:foi_attachments, :hexdigest, :string, {:limit=>32})
  1257.    -> 0.0006s
  1258. == 106 AddHexDigestToFoiAttachment: migrated (0.0007s) ========================
  1259.  
  1260. == 107 AddDateParsedFieldToIncomingMessage: migrating =========================
  1261. -- add_column(:incoming_messages, :last_parsed, :datetime, {})
  1262.    -> 0.0006s
  1263. == 107 AddDateParsedFieldToIncomingMessage: migrated (0.0006s) ================
  1264.  
  1265. == 108 ChangeSafeMailFromToMailFrom: migrating ================================
  1266. -- remove_column(:incoming_messages, :safe_mail_from)
  1267.    -> 0.0007s
  1268. -- add_column(:incoming_messages, :mail_from, :text, {})
  1269.    -> 0.0006s
  1270. == 108 ChangeSafeMailFromToMailFrom: migrated (0.0014s) =======================
  1271.  
  1272. == 109 ChangeSentAtToDatetime: migrating ======================================
  1273. -- remove_column(:incoming_messages, :sent_at)
  1274.    -> 0.0005s
  1275. -- add_column(:incoming_messages, :sent_at, :timestamp, {})
  1276.    -> 0.0005s
  1277. == 109 ChangeSentAtToDatetime: migrated (0.0017s) =============================
  1278.  
  1279. == 110 AddUserNoLimit: migrating ==============================================
  1280. -- add_column(:users, :no_limit, :boolean, {:default=>false, :null=>false})
  1281.    -> 0.0071s
  1282. == 110 AddUserNoLimit: migrated (0.0071s) =====================================
  1283.  
  1284. == 111 CreatePurgeRequests: migrating =========================================
  1285. -- create_table(:purge_requests, {:id=>:integer})
  1286.    -> 0.0042s
  1287. == 111 CreatePurgeRequests: migrated (0.0042s) ================================
  1288.  
  1289. == 112 AddApiKeyToPublicBodies: migrating =====================================
  1290. -- add_column(:public_bodies, :api_key, :string, {})
  1291.    -> 0.0006s
  1292. -- execute("      update public_bodies\n      set api_key = encode(decode(\n          lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n        ||lpad(to_hex(floor(random()*256) :: integer), 2, '0')\n      , 'hex'), 'base64')\n")
  1293.    -> 0.0018s
  1294. -- change_column_null(:public_bodies, :api_key, false)
  1295.    -> 0.0005s
  1296. == 112 AddApiKeyToPublicBodies: migrated (0.0032s) ============================
  1297.  
  1298. == 113 AddExternalFieldsToInfoRequests: migrating =============================
  1299. -- change_column_null(:info_requests, :user_id, true)
  1300.    -> 0.0005s
  1301. -- add_column(:info_requests, :external_user_name, :string, {:null=>true})
  1302.    -> 0.0005s
  1303. -- add_column(:info_requests, :external_url, :string, {:null=>true})
  1304.    -> 0.0006s
  1305. -- execute("ALTER TABLE info_requests ADD CONSTRAINT info_requests_external_ck CHECK ( (user_id is null) = (external_url is not null) and (external_user_name is not null or external_url is null) )")
  1306.    -> 0.0007s
  1307. == 113 AddExternalFieldsToInfoRequests: migrated (0.0024s) ====================
  1308.  
  1309. == 114 AddAttentionRequestedFlagToInfoRequests: migrating =====================
  1310. -- add_column(:info_requests, :attention_requested, :boolean, {:default=>false})
  1311.    -> 0.0073s
  1312. == 114 AddAttentionRequestedFlagToInfoRequests: migrated (0.0074s) ============
  1313.  
  1314. == 115 AddReceiveEmailAlertsToUser: migrating =================================
  1315. -- add_column(:users, :receive_email_alerts, :boolean, {:default=>true, :null=>false})
  1316.    -> 0.0073s
  1317. == 115 AddReceiveEmailAlertsToUser: migrated (0.0073s) ========================
  1318.  
  1319. == 116 AddCensorRuleRegexp: migrating =========================================
  1320. -- add_column(:censor_rules, :regexp, :boolean, {})
  1321.    -> 0.0006s
  1322. == 116 AddCensorRuleRegexp: migrated (0.0006s) ================================
  1323.  
  1324. == 117 CreateSessions: migrating ==============================================
  1325. -- create_table(:sessions, {:id=>:integer})
  1326.    -> 0.0041s
  1327. -- add_index(:sessions, :session_id)
  1328.    -> 0.0030s
  1329. -- add_index(:sessions, :updated_at)
  1330.    -> 0.0027s
  1331. == 117 CreateSessions: migrated (0.0099s) =====================================
  1332.  
  1333. == 118 RemoveSessionsAgain: migrating =========================================
  1334. -- drop_table(:sessions)
  1335.    -> 0.0011s
  1336. == 118 RemoveSessionsAgain: migrated (0.0012s) ================================
  1337.  
  1338. == 20120822145640 CorrectExternalRequestConstraint: migrating =================
  1339. -- execute("ALTER TABLE info_requests DROP CONSTRAINT info_requests_external_ck")
  1340.    -> 0.0005s
  1341. -- execute("ALTER TABLE info_requests ADD CONSTRAINT info_requests_external_ck CHECK ( (user_id is null) = (external_url is not null) and (external_url is not null or external_user_name is null) )")
  1342.    -> 0.0007s
  1343. == 20120822145640 CorrectExternalRequestConstraint: migrated (0.0013s) ========
  1344.  
  1345. == 20120910153022 CreateRequestClassifications: migrating =====================
  1346. -- create_table(:request_classifications, {:id=>:integer})
  1347.    -> 0.0026s
  1348. -- add_index(:request_classifications, :user_id)
  1349.    -> 0.0028s
  1350. == 20120910153022 CreateRequestClassifications: migrated (0.0055s) ============
  1351.  
  1352. == 20120912111713 AddRawEmailIndexToIncomingMessages: migrating ===============
  1353. -- add_index(:incoming_messages, :raw_email_id)
  1354.    -> 0.0028s
  1355. == 20120912111713 AddRawEmailIndexToIncomingMessages: migrated (0.0028s) ======
  1356.  
  1357. == 20120912112036 AddInfoRequestIdIndexToEximLogs: migrating ==================
  1358. -- add_index(:exim_logs, :info_request_id)
  1359.    -> 0.0026s
  1360. == 20120912112036 AddInfoRequestIdIndexToEximLogs: migrated (0.0027s) =========
  1361.  
  1362. == 20120912112312 AddInfoRequestIdIndexToIncomingAndOutgoingMessages: migrating
  1363. -- add_index(:incoming_messages, :info_request_id)
  1364.    -> 0.0028s
  1365. -- add_index(:outgoing_messages, :info_request_id)
  1366.    -> 0.0027s
  1367. == 20120912112312 AddInfoRequestIdIndexToIncomingAndOutgoingMessages: migrated (0.0056s)
  1368.  
  1369. == 20120912112655 AddIncomingMessageIdIndexToFoiAttachments: migrating ========
  1370. -- add_index(:foi_attachments, :incoming_message_id)
  1371.    -> 0.0025s
  1372. == 20120912112655 AddIncomingMessageIdIndexToFoiAttachments: migrated (0.0026s)
  1373.  
  1374. == 20120912113004 AddIndexesToInfoRequestEvents: migrating ====================
  1375. -- add_index(:info_request_events, :incoming_message_id)
  1376.    -> 0.0026s
  1377. -- add_index(:info_request_events, :outgoing_message_id)
  1378.    -> 0.0028s
  1379. -- add_index(:info_request_events, :comment_id)
  1380.    -> 0.0026s
  1381. == 20120912113004 AddIndexesToInfoRequestEvents: migrated (0.0081s) ===========
  1382.  
  1383. == 20120912113720 AddPublicBodyIndexToInfoRequests: migrating =================
  1384. -- add_index(:info_requests, :public_body_id)
  1385.    -> 0.0033s
  1386. == 20120912113720 AddPublicBodyIndexToInfoRequests: migrated (0.0033s) ========
  1387.  
  1388. == 20120912114022 AddUserIndexToInfoRequests: migrating =======================
  1389. -- add_index(:info_requests, :user_id)
  1390.    -> 0.0030s
  1391. == 20120912114022 AddUserIndexToInfoRequests: migrated (0.0031s) ==============
  1392.  
  1393. == 20120912170035 AddInfoRequestsCountToPublicBodies: migrating ===============
  1394. -- add_column(:public_bodies, :info_requests_count, :integer, {:null=>false, :default=>0})
  1395.    -> 0.0068s
  1396. == 20120912170035 AddInfoRequestsCountToPublicBodies: migrated (0.0079s) ======
  1397.  
  1398. == 20120913074940 AddIncomingMessageIndexToOutgoingMessages: migrating ========
  1399. -- add_index(:outgoing_messages, :incoming_message_followup_id)
  1400.    -> 0.0037s
  1401. == 20120913074940 AddIncomingMessageIndexToOutgoingMessages: migrated (0.0038s)
  1402.  
  1403. == 20120913080807 AddInfoRequestEventIndexToTrackThingsSentEmails: migrating ==
  1404. -- add_index(:track_things_sent_emails, :info_request_event_id)
  1405.    -> 0.0033s
  1406. == 20120913080807 AddInfoRequestEventIndexToTrackThingsSentEmails: migrated (0.0034s)
  1407.  
  1408. == 20120913081136 AddInfoRequestEventIndexToUserInfoRequestSentAlerts: migrating
  1409. -- add_index(:user_info_request_sent_alerts, :info_request_event_id)
  1410.    -> 0.0027s
  1411. == 20120913081136 AddInfoRequestEventIndexToUserInfoRequestSentAlerts: migrated (0.0027s)
  1412.  
  1413. == 20120913135745 AddUpdatedAtIndexToPublicBodyVersions: migrating ============
  1414. -- add_index(:public_body_versions, :updated_at)
  1415.    -> 0.0028s
  1416. == 20120913135745 AddUpdatedAtIndexToPublicBodyVersions: migrated (0.0028s) ===
  1417.  
  1418. == 20120919140404 AddCommentsAllowedToInfoRequest: migrating ==================
  1419. -- add_column(:info_requests, :comments_allowed, :boolean, {:null=>false, :default=>true})
  1420.    -> 0.0091s
  1421. == 20120919140404 AddCommentsAllowedToInfoRequest: migrated (0.0092s) =========
  1422.  
  1423. == 20121010214348 RenameEximLogTables: migrating ==============================
  1424. -- rename_table(:exim_logs, :mail_server_logs)
  1425.    -> 0.0065s
  1426. -- rename_table(:exim_log_dones, :mail_server_log_dones)
  1427.    -> 0.0045s
  1428. -- rename_column(:mail_server_logs, :exim_log_done_id, :mail_server_log_done_id)
  1429.    -> 0.0027s
  1430. == 20121010214348 RenameEximLogTables: migrated (0.0139s) =====================
  1431.  
  1432. == 20121022031914 AddDisclosureLog: migrating =================================
  1433. -- add_column(:public_bodies, :disclosure_log, :text, {:null=>false, :default=>""})
  1434.    -> 0.0062s
  1435. -- add_column(:public_body_versions, :disclosure_log, :text, {:null=>false, :default=>""})
  1436.    -> 0.0062s
  1437. -- add_column(:public_body_translations, :disclosure_log, :text, {})
  1438.    -> 0.0006s
  1439. == 20121022031914 AddDisclosureLog: migrated (0.0131s) ========================
  1440.  
  1441. == 20130731142632 RemoveProminenceFromInfoRequestEvent: migrating =============
  1442. -- remove_column(:info_request_events, :prominence)
  1443.    -> 0.0007s
  1444. == 20130731142632 RemoveProminenceFromInfoRequestEvent: migrated (0.0007s) ====
  1445.  
  1446. == 20130731145325 AddProminenceToIncomingMessage: migrating ===================
  1447. -- add_column(:incoming_messages, :prominence, :string, {:null=>false, :default=>"normal"})
  1448.    -> 0.0060s
  1449. == 20130731145325 AddProminenceToIncomingMessage: migrated (0.0060s) ==========
  1450.  
  1451. == 20130801154033 AddProminenceReasonToIncomingMessage: migrating =============
  1452. -- add_column(:incoming_messages, :prominence_reason, :text, {})
  1453.    -> 0.0006s
  1454. == 20130801154033 AddProminenceReasonToIncomingMessage: migrated (0.0006s) ====
  1455.  
  1456. == 20130816150110 AddStatisticsToPublicBody: migrating ========================
  1457. -- add_column(:public_bodies, :info_requests_successful_count, :integer, {})
  1458.    -> 0.0006s
  1459. -- add_column(:public_bodies, :info_requests_not_held_count, :integer, {})
  1460.    -> 0.0005s
  1461. -- add_column(:public_bodies, :info_requests_overdue_count, :integer, {})
  1462.    -> 0.0005s
  1463. == 20130816150110 AddStatisticsToPublicBody: migrated (0.0034s) ===============
  1464.  
  1465. == 20130822161803 AddProminenceFieldsToOutgoingMessage: migrating =============
  1466. -- add_column(:outgoing_messages, :prominence, :string, {:null=>false, :default=>"normal"})
  1467.    -> 0.0070s
  1468. -- add_column(:outgoing_messages, :prominence_reason, :text, {})
  1469.    -> 0.0005s
  1470. == 20130822161803 AddProminenceFieldsToOutgoingMessage: migrated (0.0076s) ====
  1471.  
  1472. == 20130919151140 AddCanMakeBatchRequestsToUser: migrating ====================
  1473. -- add_column(:users, :can_make_batch_requests, :boolean, {:default=>false, :null=>false})
  1474.    -> 0.0074s
  1475. == 20130919151140 AddCanMakeBatchRequestsToUser: migrated (0.0075s) ===========
  1476.  
  1477. == 20131024114346 CreateInfoRequestBatches: migrating =========================
  1478. -- create_table(:info_request_batches, {:id=>:integer})
  1479.    -> 0.0041s
  1480. -- add_column(:info_requests, :info_request_batch_id, :integer, {:null=>true})
  1481.    -> 0.0006s
  1482. -- execute("ALTER TABLE info_requests\n                    ADD CONSTRAINT fk_info_requests_info_request_batch\n                    FOREIGN KEY (info_request_batch_id) REFERENCES info_request_batches(id)")
  1483.    -> 0.0013s
  1484. -- add_index(:info_requests, :info_request_batch_id)
  1485.    -> 0.0027s
  1486. -- add_index(:info_request_batches, :user_id)
  1487.    -> 0.0027s
  1488. == 20131024114346 CreateInfoRequestBatches: migrated (0.0116s) ================
  1489.  
  1490. == 20131024152540 AddBodyToInfoRequestBatches: migrating ======================
  1491. -- add_column(:info_request_batches, :body, :text, {})
  1492.    -> 0.0006s
  1493. -- add_index(:info_request_batches, [:user_id, :body, :title])
  1494.    -> 0.0028s
  1495. == 20131024152540 AddBodyToInfoRequestBatches: migrated (0.0035s) =============
  1496.  
  1497. == 20131101155844 AddStatsDenominator: migrating ==============================
  1498. -- add_column(:public_bodies, :info_requests_visible_classified_count, :integer, {})
  1499.    -> 0.0006s
  1500. == 20131101155844 AddStatsDenominator: migrated (0.0014s) =====================
  1501.  
  1502. == 20131127105438 CreateInfoRequestBatchPublicBodiesJoinTable: migrating ======
  1503. -- create_table(:info_request_batches_public_bodies, {:id=>false})
  1504.    -> 0.0009s
  1505. == 20131127105438 CreateInfoRequestBatchPublicBodiesJoinTable: migrated (0.0010s)
  1506.  
  1507. == 20131127135622 AddSentAtToInfoRequestBatch: migrating ======================
  1508. -- add_column(:info_request_batches, :sent_at, :datetime, {})
  1509.    -> 0.0006s
  1510. == 20131127135622 AddSentAtToInfoRequestBatch: migrated (0.0006s) =============
  1511.  
  1512. == 20131211152641 CreatePublicBodyChangeRequests: migrating ===================
  1513. -- create_table(:public_body_change_requests, {:id=>:integer})
  1514.    -> 0.0043s
  1515. == 20131211152641 CreatePublicBodyChangeRequests: migrated (0.0044s) ==========
  1516.  
  1517. == 20140325120619 CreateSpamAddresses: migrating ==============================
  1518. -- create_table(:spam_addresses, {:id=>:integer})
  1519.    -> 0.0043s
  1520. == 20140325120619 CreateSpamAddresses: migrated (0.0044s) =====================
  1521.  
  1522. == 20140408145616 AddDefaultShortNameToPublicBodies: migrating ================
  1523. -- change_column_default(:public_bodies, :short_name, "")
  1524.    -> 0.0029s
  1525. == 20140408145616 AddDefaultShortNameToPublicBodies: migrated (0.0029s) =======
  1526.  
  1527. == 20140528110536 UpdateTrackThingsIndex: migrating ===========================
  1528. -- execute("ALTER TABLE track_things_sent_emails DROP CONSTRAINT fk_track_request_public_body")
  1529.    -> 0.0009s
  1530. -- execute("ALTER TABLE track_things_sent_emails ADD CONSTRAINT fk_track_request_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)")
  1531.    -> 0.0014s
  1532. == 20140528110536 UpdateTrackThingsIndex: migrated (0.0024s) ==================
  1533.  
  1534. == 20140710094405 CreatePublicBodyHeadingsAndCategories: migrating ============
  1535. -- create_table(:public_body_headings, {:force=>true, :id=>:integer})
  1536.    -> 0.0049s
  1537. -- create_table(:public_body_categories, {:force=>true, :id=>:integer})
  1538.    -> 0.0043s
  1539. -- create_table(:public_body_categories_public_body_headings, {:id=>false})
  1540.    -> 0.0008s
  1541. == 20140710094405 CreatePublicBodyHeadingsAndCategories: migrated (0.0101s) ===
  1542.  
  1543. == 20140716131107 CreateCategoryTranslationTables: migrating ==================
  1544. -- remove_column(:public_body_headings, :locale)
  1545.    -> 0.0005s
  1546. -- remove_column(:public_body_categories, :locale)
  1547.    -> 0.0005s
  1548. -- remove_column(:public_body_headings, :name)
  1549.    -> 0.0004s
  1550. -- remove_column(:public_body_categories, :title)
  1551.    -> 0.0005s
  1552. -- remove_column(:public_body_categories, :description)
  1553.    -> 0.0005s
  1554. -- add_index(:public_body_categories, :category_tag, {:unique=>true})
  1555.    -> 0.0040s
  1556. == 20140716131107 CreateCategoryTranslationTables: migrated (0.0525s) =========
  1557.  
  1558. == 20140801132719 AddIndexToInfoRequestEvents: migrating ======================
  1559. -- add_index(:info_request_events, :event_type)
  1560.    -> 0.0037s
  1561. == 20140801132719 AddIndexToInfoRequestEvents: migrated (0.0038s) =============
  1562.  
  1563. == 20140804120601 AddDisplayOrderToCategoriesAndHeadings: migrating ===========
  1564. -- add_column(:public_body_categories_public_body_headings, :category_display_order, :integer, {})
  1565.    -> 0.0010s
  1566. -- rename_table(:public_body_categories_public_body_headings, :public_body_category_links)
  1567.    -> 0.0069s
  1568. -- add_column(:public_body_category_links, :id, :integer, {:primary_key=>true})
  1569.    -> 0.0043s
  1570. -- add_index(:public_body_category_links, [:public_body_category_id, :public_body_heading_id], {:name=>"index_public_body_category_links_on_join_ids"})
  1571.    -> 0.0039s
  1572. == 20140804120601 AddDisplayOrderToCategoriesAndHeadings: migrated (0.0165s) ==
  1573.  
  1574. == 20140824191444 CreateWidgetVotes: migrating ================================
  1575. -- create_table(:widget_votes, {:id=>:integer})
  1576.    -> 0.0049s
  1577. -- add_index(:widget_votes, :info_request_id)
  1578.    -> 0.0029s
  1579. == 20140824191444 CreateWidgetVotes: migrated (0.0079s) =======================
  1580.  
  1581. == 20151006101417 AddOtpEnabledToUsers: migrating =============================
  1582. -- add_column(:users, :otp_enabled, :boolean, {:default=>false, :null=>false})
  1583.    -> 0.0075s
  1584. == 20151006101417 AddOtpEnabledToUsers: migrated (0.0076s) ====================
  1585.  
  1586. == 20151006104552 AddOtpSecretKeyToUsers: migrating ===========================
  1587. -- add_column(:users, :otp_secret_key, :string, {})
  1588.    -> 0.0010s
  1589. == 20151006104552 AddOtpSecretKeyToUsers: migrated (0.0010s) ==================
  1590.  
  1591. == 20151006104739 AddCounterForOtpToUsers: migrating ==========================
  1592. -- add_column(:users, :otp_counter, :integer, {:default=>1})
  1593.    -> 0.0083s
  1594. == 20151006104739 AddCounterForOtpToUsers: migrated (0.0083s) =================
  1595.  
  1596. == 20151009162421 AddInfoRequestsVisibleCountToPublicBodies: migrating ========
  1597. -- add_column(:public_bodies, :info_requests_visible_count, :integer, {:null=>false, :default=>0})
  1598.    -> 0.0063s
  1599. == 20151009162421 AddInfoRequestsVisibleCountToPublicBodies: migrated (0.0073s)
  1600.  
  1601. == 20151020112248 SetLongerLengthForTrackThingsTrackQuery: migrating ==========
  1602. -- change_column(:track_things, :track_query, :string, {:limit=>500})
  1603.    -> 0.0054s
  1604. == 20151020112248 SetLongerLengthForTrackThingsTrackQuery: migrated (0.0055s) =
  1605.  
  1606. == 20151104131702 AddLastPublicResponseAtToInfoRequest: migrating =============
  1607. -- add_column(:info_requests, :last_public_response_at, :datetime, {:null=>true})
  1608.    -> 0.0007s
  1609. == 20151104131702 AddLastPublicResponseAtToInfoRequest: migrated (0.0022s) ====
  1610.  
  1611. == 20160526154304 AddConfirmedNotSpamToUsers: migrating =======================
  1612. -- add_column(:users, :confirmed_not_spam, :boolean, {:default=>false, :null=>false})
  1613.    -> 0.0077s
  1614. == 20160526154304 AddConfirmedNotSpamToUsers: migrated (0.0077s) ==============
  1615.  
  1616. == 20160602143125 AddRejectIncomingAtMtaToInfoRequest: migrating ==============
  1617. -- add_column(:info_requests, :reject_incoming_at_mta, :boolean, {:default=>false, :null=>false})
  1618.    -> 0.0108s
  1619. == 20160602143125 AddRejectIncomingAtMtaToInfoRequest: migrated (0.0108s) =====
  1620.  
  1621. == 20160602145046 AddRejectedIncomingCountToInfoRequest: migrating ============
  1622. -- add_column(:info_requests, :rejected_incoming_count, :integer, {:default=>0})
  1623.    -> 0.0113s
  1624. == 20160602145046 AddRejectedIncomingCountToInfoRequest: migrated (0.0114s) ===
  1625.  
  1626. == 20160613145644 AddCommentsCountToUsers: migrating ==========================
  1627. -- add_column(:users, :comments_count, :integer, {:default=>0, :null=>false})
  1628.    -> 0.0076s
  1629. == 20160613145644 AddCommentsCountToUsers: migrated (0.0172s) =================
  1630.  
  1631. == 20160613151127 AddInfoRequestsCountToUsers: migrating ======================
  1632. -- add_column(:users, :info_requests_count, :integer, {:default=>0, :null=>false})
  1633.    -> 0.0072s
  1634. == 20160613151127 AddInfoRequestsCountToUsers: migrated (0.0084s) =============
  1635.  
  1636. == 20160613151912 AddTrackThingsCountToUsers: migrating =======================
  1637. -- add_column(:users, :track_things_count, :integer, {:default=>0, :null=>false})
  1638.    -> 0.0087s
  1639. == 20160613151912 AddTrackThingsCountToUsers: migrated (0.0099s) ==============
  1640.  
  1641. == 20160613152433 AddRequestClassificationsCountToUsers: migrating ============
  1642. -- add_column(:users, :request_classifications_count, :integer, {:default=>0, :null=>false})
  1643.    -> 0.0093s
  1644. == 20160613152433 AddRequestClassificationsCountToUsers: migrated (0.0156s) ===
  1645.  
  1646. == 20160613153739 AddPublicBodyChangeRequestsCountToUsers: migrating ==========
  1647. -- add_column(:users, :public_body_change_requests_count, :integer, {:default=>0, :null=>false})
  1648.    -> 0.0074s
  1649. == 20160613153739 AddPublicBodyChangeRequestsCountToUsers: migrated (0.0144s) =
  1650.  
  1651. == 20160613154616 AddInfoRequestBatchesCountToUsers: migrating ================
  1652. -- add_column(:users, :info_request_batches_count, :integer, {:default=>0, :null=>false})
  1653.    -> 0.0071s
  1654. == 20160613154616 AddInfoRequestBatchesCountToUsers: migrated (0.0185s) =======
  1655.  
  1656. == 20160701155339 RemoveCommentTypeFromComment: migrating =====================
  1657. -- remove_column(:comments, :comment_type)
  1658.    -> 0.0005s
  1659. == 20160701155339 RemoveCommentTypeFromComment: migrated (0.0006s) ============
  1660.  
  1661. == 20160907144809 AddDeliveryStatusToMailServerLogs: migrating ================
  1662. -- add_column(:mail_server_logs, :delivery_status, :string, {})
  1663.    -> 0.0006s
  1664. == 20160907144809 AddDeliveryStatusToMailServerLogs: migrated (0.0007s) =======
  1665.  
  1666. == 20161006142352 CreateFlipperTables: migrating ==============================
  1667. -- create_table(:flipper_features, {:id=>:integer})
  1668.    -> 0.0043s
  1669. -- add_index(:flipper_features, :key, {:unique=>true})
  1670.    -> 0.0029s
  1671. -- create_table(:flipper_gates, {:id=>:integer})
  1672.    -> 0.0045s
  1673. -- add_index(:flipper_gates, [:feature_key, :key, :value], {:unique=>true})
  1674.    -> 0.0037s
  1675. == 20161006142352 CreateFlipperTables: migrated (0.0155s) =====================
  1676.  
  1677. == 20161101110656 CreateProAccounts: migrating ================================
  1678. -- create_table(:pro_accounts, {:id=>:integer})
  1679.    -> 0.0057s
  1680. == 20161101110656 CreateProAccounts: migrated (0.0058s) =======================
  1681.  
  1682. == 20161101151318 CreateEmbargoes: migrating ==================================
  1683. -- create_table(:embargoes, {:id=>:integer})
  1684.    -> 0.0075s
  1685. == 20161101151318 CreateEmbargoes: migrated (0.0076s) =========================
  1686.  
  1687. == 20161116121007 CreateDraftInfoRequests: migrating ==========================
  1688. -- create_table(:draft_info_requests, {:id=>:integer})
  1689.    -> 0.0053s
  1690. == 20161116121007 CreateDraftInfoRequests: migrated (0.0054s) =================
  1691.  
  1692. == 20161128095350 AddDurationToEmbargo: migrating =============================
  1693. -- add_column(:embargoes, :embargo_duration, :string, {})
  1694.    -> 0.0020s
  1695. == 20161128095350 AddDurationToEmbargo: migrated (0.0020s) ====================
  1696.  
  1697. == 20161206174634 AddDateInitialRequestLastSentAtToInfoRequest: migrating =====
  1698. -- add_column(:info_requests, :date_initial_request_last_sent_at, :date, {})
  1699.    -> 0.0006s
  1700. == 20161206174634 AddDateInitialRequestLastSentAtToInfoRequest: migrated (0.0007s)
  1701.  
  1702. == 20161206175711 AddDateResponseRequiredByToInfoRequest: migrating ===========
  1703. -- add_column(:info_requests, :date_response_required_by, :date, {})
  1704.    -> 0.0006s
  1705. == 20161206175711 AddDateResponseRequiredByToInfoRequest: migrated (0.0007s) ==
  1706.  
  1707. == 20161206175737 AddDateVeryOverdueAfterToInfoRequest: migrating =============
  1708. -- add_column(:info_requests, :date_very_overdue_after, :date, {})
  1709.    -> 0.0007s
  1710. == 20161206175737 AddDateVeryOverdueAfterToInfoRequest: migrated (0.0007s) ====
  1711.  
  1712. == 20161207184708 CreateEmbargoExtensions: migrating ==========================
  1713. -- create_table(:embargo_extensions, {:id=>:integer})
  1714.    -> 0.0046s
  1715. == 20161207184708 CreateEmbargoExtensions: migrated (0.0046s) =================
  1716.  
  1717. == 20161222101600 AddLastEventFormingInitialRequestIdToInfoRequests: migrating
  1718. -- add_column(:info_requests, :last_event_forming_initial_request_id, :integer, {})
  1719.    -> 0.0009s
  1720. == 20161222101600 AddLastEventFormingInitialRequestIdToInfoRequests: migrated (0.0009s)
  1721.  
  1722. == 20170216101547 AddAttentionRequestedToComment: migrating ===================
  1723. -- add_column(:comments, :attention_requested, :boolean, {:null=>false, :default=>false})
  1724.    -> 0.0046s
  1725. == 20170216101547 AddAttentionRequestedToComment: migrated (0.0047s) ==========
  1726.  
  1727. == 20170227140831 RolifyCreateRoles: migrating ================================
  1728. -- create_table(:roles, {:id=>:integer})
  1729.    -> 0.0044s
  1730. -- create_table(:users_roles, {:id=>false})
  1731.    -> 0.0009s
  1732. -- add_index(:roles, :name)
  1733.    -> 0.0030s
  1734. -- add_index(:roles, [:name, :resource_type, :resource_id])
  1735.    -> 0.0029s
  1736. -- add_index(:users_roles, [:user_id, :role_id])
  1737.    -> 0.0029s
  1738. == 20170227140831 RolifyCreateRoles: migrated (0.0143s) =======================
  1739.  
  1740. == 20170301163735 CreateDraftInfoRequestBatches: migrating ====================
  1741. -- create_table(:draft_info_request_batches, {:id=>:integer})
  1742.    -> 0.0044s
  1743. -- add_index(:draft_info_request_batches, :user_id)
  1744.    -> 0.0027s
  1745. == 20170301163735 CreateDraftInfoRequestBatches: migrated (0.0072s) ===========
  1746.  
  1747. == 20170301164705 CreateDraftInfoRequestBatchesPublicBodiesTable: migrating ===
  1748. -- create_table(:draft_info_request_batches_public_bodies, {:id=>false})
  1749.    -> 0.0009s
  1750. -- add_index(:draft_info_request_batches_public_bodies, [:draft_info_request_batch_id, :public_body_id], {:name=>"index_draft_batch_body_and_draft"})
  1751.    -> 0.0030s
  1752. -- add_index(:draft_info_request_batches_public_bodies, :public_body_id, {:name=>"index_draft_batch_body"})
  1753.    -> 0.0032s
  1754. == 20170301164705 CreateDraftInfoRequestBatchesPublicBodiesTable: migrated (0.0072s)
  1755.  
  1756. == 20170316170248 EditInfoRequestBatchIndex: migrating ========================
  1757. -- remove_index(:info_request_batches, {:column=>[:user_id, :body, :title], :name=>"index_info_request_batches_on_user_id_and_body_and_title"})
  1758.    -> 0.0028s
  1759. -- add_index(:info_request_batches, [:user_id, :title])
  1760.    -> 0.0029s
  1761. == 20170316170248 EditInfoRequestBatchIndex: migrated (0.0067s) ===============
  1762.  
  1763. == 20170323165519 AddEmbargoDurationToDraftInfoRequestBatch: migrating ========
  1764. -- add_column(:draft_info_request_batches, :embargo_duration, :string, {})
  1765.    -> 0.0006s
  1766. == 20170323165519 AddEmbargoDurationToDraftInfoRequestBatch: migrated (0.0007s)
  1767.  
  1768. == 20170328100359 AddEmbargoDurationToInfoRequestBatch: migrating =============
  1769. -- add_column(:info_request_batches, :embargo_duration, :string, {})
  1770.    -> 0.0006s
  1771. == 20170328100359 AddEmbargoDurationToInfoRequestBatch: migrated (0.0006s) ====
  1772.  
  1773. == 20170411113908 CreateAlaveteliProRequestSummaries: migrating ===============
  1774. -- create_table(:request_summaries, {:id=>:integer})
  1775.    -> 0.0052s
  1776. == 20170411113908 CreateAlaveteliProRequestSummaries: migrated (0.0052s) ======
  1777.  
  1778. == 20170412141214 AddUniqueIndexToSummarisable: migrating =====================
  1779. -- add_index(:request_summaries, [:summarisable_type, :summarisable_id], {:unique=>true, :name=>"index_request_summaries_on_summarisable"})
  1780.    -> 0.0035s
  1781. == 20170412141214 AddUniqueIndexToSummarisable: migrated (0.0035s) ============
  1782.  
  1783. == 20170412143304 MakeSummarisableNotNull: migrating ==========================
  1784. -- change_column_null(:request_summaries, :summarisable_type, false)
  1785.    -> 0.0004s
  1786. -- change_column_null(:request_summaries, :summarisable_id, false)
  1787.    -> 0.0003s
  1788. == 20170412143304 MakeSummarisableNotNull: migrated (0.0008s) =================
  1789.  
  1790. == 20170412145313 AddUserToRequestSummary: migrating ==========================
  1791. -- add_reference(:request_summaries, :user, {:type=>:integer, :index=>true, :null=>false})
  1792.    -> 0.0036s
  1793. == 20170412145313 AddUserToRequestSummary: migrated (0.0037s) =================
  1794.  
  1795. == 20170412150729 CreateAlaveteliProRequestSummaryCategories: migrating =======
  1796. -- create_table(:request_summary_categories, {:id=>:integer})
  1797.    -> 0.0043s
  1798. -- create_join_table(:request_summaries, :request_summary_categories, {:table_name=>"request_summaries_summary_categories", :column_options=>{:type=>:integer}})
  1799.    -> 0.0073s
  1800. == 20170412150729 CreateAlaveteliProRequestSummaryCategories: migrated (0.0117s)
  1801.  
  1802. == 20170413135231 AllowUserToBeNullOnRequestSummary: migrating ================
  1803. -- change_column_null(:request_summaries, :user_id, true)
  1804.    -> 0.0005s
  1805. == 20170413135231 AllowUserToBeNullOnRequestSummary: migrated (0.0005s) =======
  1806.  
  1807. == 20170414140927 CreateIncomingMessageError: migrating =======================
  1808. -- create_table(:incoming_message_errors, {:id=>:integer})
  1809.    -> 0.0046s
  1810. -- add_index(:incoming_message_errors, :unique_id)
  1811.    -> 0.0032s
  1812. == 20170414140927 CreateIncomingMessageError: migrated (0.0080s) ==============
  1813.  
  1814. == 20170421145745 AddRequestCreatedAtAndRequestUpdatedAtToRequestSummary: migrating
  1815. -- add_column(:request_summaries, :request_created_at, :datetime, {:null=>false, :default=>2021-08-19 10:46:01 +0000})
  1816.    -> 0.0087s
  1817. -- add_column(:request_summaries, :request_updated_at, :datetime, {:null=>false, :default=>2021-08-19 10:46:01 +0000})
  1818.    -> 0.0076s
  1819. == 20170421145745 AddRequestCreatedAtAndRequestUpdatedAtToRequestSummary: migrated (0.0165s)
  1820.  
  1821. == 20170509210708 AddUseNotificationsToInfoRequest: migrating =================
  1822. -- add_column(:info_requests, :use_notifications, :boolean, {})
  1823.    -> 0.0012s
  1824. == 20170509210708 AddUseNotificationsToInfoRequest: migrated (0.0013s) ========
  1825.  
  1826. == 20170516120853 CreateNotifications: migrating ==============================
  1827. -- create_table(:notifications, {:id=>:integer})
  1828.    -> 0.0197s
  1829. == 20170516120853 CreateNotifications: migrated (0.0198s) =====================
  1830.  
  1831. == 20170516132204 AddDailySummaryTimeToUser: migrating ========================
  1832. -- add_column(:users, :daily_summary_hour, :integer, {})
  1833.    -> 0.0008s
  1834. -- add_column(:users, :daily_summary_minute, :integer, {})
  1835.    -> 0.0006s
  1836. == 20170516132204 AddDailySummaryTimeToUser: migrated (0.0015s) ===============
  1837.  
  1838. == 20170606141753 AddLastEventTimeToInfoRequest: migrating ====================
  1839. -- add_column(:info_requests, :last_event_time, :datetime, {})
  1840.    -> 0.0006s
  1841. == 20170606141753 AddLastEventTimeToInfoRequest: migrated (0.0007s) ===========
  1842.  
  1843. == 20170621112453 RemoveDefaultValueFromRequestCreatedAtAndRequestUpdatedAtOnRequestSummary: migrating
  1844. -- change_column_default(:request_summaries, :request_created_at, nil)
  1845.    -> 0.0024s
  1846. -- change_column_default(:request_summaries, :request_updated_at, nil)
  1847.    -> 0.0019s
  1848. == 20170621112453 RemoveDefaultValueFromRequestCreatedAtAndRequestUpdatedAtOnRequestSummary: migrated (0.0044s)
  1849.  
  1850. == 20170704143210 DropUnconventionalPublicBodyConstraints: migrating ==========
  1851. -- change_column_null("public_bodies", :short_name, true)
  1852.    -> 0.0007s
  1853. -- change_column_default("public_bodies", :short_name, nil)
  1854.    -> 0.0035s
  1855. -- change_column_null("public_bodies", :home_page, true)
  1856.    -> 0.0007s
  1857. -- change_column_default("public_bodies", :home_page, nil)
  1858.    -> 0.0031s
  1859. -- change_column_null("public_bodies", :notes, true)
  1860.    -> 0.0005s
  1861. -- change_column_default("public_bodies", :notes, nil)
  1862.    -> 0.0030s
  1863. -- change_column_null("public_bodies", :publication_scheme, true)
  1864.    -> 0.0007s
  1865. -- change_column_default("public_bodies", :publication_scheme, nil)
  1866.    -> 0.0028s
  1867. -- change_column_null("public_bodies", :disclosure_log, true)
  1868.    -> 0.0007s
  1869. -- change_column_default("public_bodies", :disclosure_log, nil)
  1870.    -> 0.0033s
  1871. -- change_column_null("public_bodies", :last_edit_comment, true)
  1872.    -> 0.0007s
  1873. -- change_column_default("public_bodies", :last_edit_comment, nil)
  1874.    -> 0.0027s
  1875. -- change_column_null("public_body_versions", :publication_scheme, true)
  1876.    -> 0.0008s
  1877. -- change_column_default("public_body_versions", :publication_scheme, nil)
  1878.    -> 0.0027s
  1879. -- change_column_null("public_body_versions", :disclosure_log, true)
  1880.    -> 0.0007s
  1881. -- change_column_default("public_body_versions", :disclosure_log, nil)
  1882.    -> 0.0029s
  1883. -- change_column_null("public_body_versions", :charity_number, true)
  1884.    -> 0.0006s
  1885. -- change_column_default("public_body_versions", :charity_number, nil)
  1886.    -> 0.0034s
  1887. == 20170704143210 DropUnconventionalPublicBodyConstraints: migrated (0.0883s) =
  1888.  
  1889. == 20170717141302 DropPublicBodyTranslatedColumns: migrating ==================
  1890. -- remove_column(:public_bodies, :name)
  1891.    -> 0.0008s
  1892. -- remove_column(:public_bodies, :short_name)
  1893.    -> 0.0006s
  1894. -- remove_column(:public_bodies, :request_email)
  1895.    -> 0.0007s
  1896. -- remove_column(:public_bodies, :url_name)
  1897.    -> 0.0009s
  1898. -- remove_column(:public_bodies, :notes)
  1899.    -> 0.0006s
  1900. -- remove_column(:public_bodies, :first_letter)
  1901.    -> 0.0007s
  1902. -- remove_column(:public_bodies, :publication_scheme)
  1903.    -> 0.0005s
  1904. == 20170717141302 DropPublicBodyTranslatedColumns: migrated (0.0072s) =========
  1905.  
  1906. == 20170718261524 AddExpiringNotificationAt: migrating ========================
  1907. -- add_column(:embargoes, :expiring_notification_at, :datetime, {})
  1908.    -> 0.0008s
  1909. == 20170718261524 AddExpiringNotificationAt: migrated (0.0031s) ===============
  1910.  
  1911. == 20170726114401 AddExpiredToNotification: migrating =========================
  1912. -- add_column(:notifications, :expired, :boolean, {:default=>false})
  1913.    -> 0.0095s
  1914. == 20170726114401 AddExpiredToNotification: migrated (0.0096s) ================
  1915.  
  1916. == 20170825150448 AddStripeCustomerIdToProAccount: migrating ==================
  1917. -- add_column(:pro_accounts, :stripe_customer_id, :string, {})
  1918.    -> 0.0008s
  1919. == 20170825150448 AddStripeCustomerIdToProAccount: migrated (0.0031s) =========
  1920.  
  1921. == 20170914164031 RemovePurgeRequest: migrating ===============================
  1922. -- drop_table(:purge_requests)
  1923.    -> 0.0010s
  1924. == 20170914164031 RemovePurgeRequest: migrated (0.0011s) ======================
  1925.  
  1926. == 20170922160120 RemoveAdminLevel: migrating =================================
  1927. -- remove_column(:users, :admin_level)
  1928.    -> 0.0009s
  1929. == 20170922160120 RemoveAdminLevel: migrated (0.0010s) ========================
  1930.  
  1931. == 20171207140915 CreateAnnouncements: migrating ==============================
  1932. -- create_table(:announcements, {:id=>:integer})
  1933.    -> 0.0180s
  1934. -- create_table(:announcement_translations, {:id=>:integer})
  1935.    -> 0.0086s
  1936. == 20171207140915 CreateAnnouncements: migrated (0.0267s) =====================
  1937.  
  1938. == 20171207140945 CreateAnnouncementDismissals: migrating =====================
  1939. -- create_table(:announcement_dismissals, {:force=>true, :id=>:integer})
  1940.    -> 0.0110s
  1941. == 20171207140945 CreateAnnouncementDismissals: migrated (0.0111s) ============
  1942.  
  1943. == 20171222121709 ChangeUserSaltNull: migrating ===============================
  1944. -- change_column_null(:users, :salt, true)
  1945.    -> 0.0006s
  1946. == 20171222121709 ChangeUserSaltNull: migrated (0.0007s) ======================
  1947.  
  1948. == 20180412135329 FixBrokenMigrationTimestamps: migrating =====================
  1949. -- execute("      DELETE FROM schema_migrations\n      WHERE version = '2017071826152436'\n")
  1950.    -> 0.0004s
  1951. -- execute("      DELETE FROM schema_migrations\n      WHERE version = '2017082515044823'\n")
  1952.    -> 0.0004s
  1953. == 20180412135329 FixBrokenMigrationTimestamps: migrated (0.0011s) ============
  1954.  
  1955. == 20180418154555 AddTimestampsToFoiAttachments: migrating ====================
  1956. -- add_timestamps(:foi_attachments, {:null=>true})
  1957.    -> 0.0013s
  1958. == 20180418154555 AddTimestampsToFoiAttachments: migrated (0.0014s) ===========
  1959.  
  1960. == 20180418154949 AddTimestampsToHolidays: migrating ==========================
  1961. -- add_timestamps(:holidays, {:null=>true})
  1962.    -> 0.0011s
  1963. == 20180418154949 AddTimestampsToHolidays: migrated (0.0012s) =================
  1964.  
  1965. == 20180418155130 AddUpdatedAtToInfoRequestEvents: migrating ==================
  1966. -- add_column(:info_request_events, :updated_at, :datetime, {})
  1967.    -> 0.0012s
  1968. == 20180418155130 AddUpdatedAtToInfoRequestEvents: migrated (0.0013s) =========
  1969.  
  1970. == 20180418155632 AddTimestampsToProfilePhotos: migrating =====================
  1971. -- add_timestamps(:profile_photos, {:null=>true})
  1972.    -> 0.0018s
  1973. == 20180418155632 AddTimestampsToProfilePhotos: migrated (0.0019s) ============
  1974.  
  1975. == 20180418155850 AddTimestampsToPublicBodyCategoryLinks: migrating ===========
  1976. -- add_timestamps(:public_body_category_links, {:null=>true})
  1977.    -> 0.0015s
  1978. == 20180418155850 AddTimestampsToPublicBodyCategoryLinks: migrated (0.0016s) ==
  1979.  
  1980. == 20180418155927 AddTimestampsToPublicBodyCategories: migrating ==============
  1981. -- add_timestamps(:public_body_categories, {:null=>true})
  1982.    -> 0.0017s
  1983. == 20180418155927 AddTimestampsToPublicBodyCategories: migrated (0.0018s) =====
  1984.  
  1985. == 20180418160008 AddTimestampsToPublicBodyHeadings: migrating ================
  1986. -- add_timestamps(:public_body_headings, {:null=>true})
  1987.    -> 0.0016s
  1988. == 20180418160008 AddTimestampsToPublicBodyHeadings: migrated (0.0017s) =======
  1989.  
  1990. == 20180418160048 AddTimestampsToRawEmails: migrating =========================
  1991. -- add_timestamps(:raw_emails, {:null=>true})
  1992.    -> 0.0015s
  1993. == 20180418160048 AddTimestampsToRawEmails: migrated (0.0016s) ================
  1994.  
  1995. == 20180418160204 AddTimestampsToUserInfoRequestSentAlerts: migrating =========
  1996. -- add_timestamps(:user_info_request_sent_alerts, {:null=>true})
  1997.    -> 0.0017s
  1998. == 20180418160204 AddTimestampsToUserInfoRequestSentAlerts: migrated (0.0018s)
  1999.  
  2000. == 20180418160205 AddUpdatedAtToHasTagStringTags: migrating ===================
  2001. -- add_column(:has_tag_string_tags, :updated_at, :datetime, {})
  2002.    -> 0.0010s
  2003. == 20180418160205 AddUpdatedAtToHasTagStringTags: migrated (0.0011s) ==========
  2004.  
  2005. == 20180418160206 AddTimestampsToActsAsXapianJobs: migrating ==================
  2006. -- add_timestamps(:acts_as_xapian_jobs, {:null=>true})
  2007.    -> 0.0016s
  2008. == 20180418160206 AddTimestampsToActsAsXapianJobs: migrated (0.0016s) =========
  2009.  
  2010. == 20180801085621 AddClosedAtToUsers: migrating ===============================
  2011. -- add_column(:users, :closed_at, :timestamp, {})
  2012.    -> 0.0007s
  2013. == 20180801085621 AddClosedAtToUsers: migrated (0.0007s) ======================
  2014.  
  2015. == 20181128160243 AddIncomingMessagesCountToInfoRequests: migrating ===========
  2016. -- add_column(:info_requests, :incoming_messages_count, :integer, {:default=>0})
  2017.    -> 0.0136s
  2018. == 20181128160243 AddIncomingMessagesCountToInfoRequests: migrated (0.0137s) ==
  2019.  
  2020. == 20190626153909 CreateWebhooks: migrating ===================================
  2021. -- create_table(:webhooks, {:id=>:integer})
  2022.    -> 0.0058s
  2023. == 20190626153909 CreateWebhooks: migrated (0.0059s) ==========================
  2024.  
  2025. == 20191211155455 CreateCitations: migrating ==================================
  2026. -- create_table(:citations, {})
  2027.    -> 0.0194s
  2028. == 20191211155455 CreateCitations: migrated (0.0196s) =========================
  2029.  
  2030. == 20200311141432 CreateProjects: migrating ===================================
  2031. -- create_table(:projects, {})
  2032.    -> 0.0117s
  2033. == 20200311141432 CreateProjects: migrated (0.0119s) ==========================
  2034.  
  2035. == 20200311141504 CreateProjectMemberships: migrating =========================
  2036. -- create_table(:project_memberships, {})
  2037.    -> 0.0211s
  2038. == 20200311141504 CreateProjectMemberships: migrated (0.0212s) ================
  2039.  
  2040. == 20200314215007 CreateProjectResources: migrating ===========================
  2041. -- create_table(:project_resources, {})
  2042.    -> 0.0130s
  2043. == 20200314215007 CreateProjectResources: migrated (0.0130s) ==================
  2044.  
  2045. == 20200501183039 CreateDatasetKeySets: migrating =============================
  2046. -- create_table(:dataset_key_sets, {})
  2047.    -> 0.0083s
  2048. == 20200501183039 CreateDatasetKeySets: migrated (0.0083s) ====================
  2049.  
  2050. == 20200501183049 CreateDatasetKeys: migrating ================================
  2051. -- create_table(:dataset_keys, {})
  2052.    -> 0.0107s
  2053. == 20200501183049 CreateDatasetKeys: migrated (0.0108s) =======================
  2054.  
  2055. == 20200501183102 CreateDatasetValueSets: migrating ===========================
  2056. -- create_table(:dataset_value_sets, {})
  2057.    -> 0.0115s
  2058. == 20200501183102 CreateDatasetValueSets: migrated (0.0116s) ==================
  2059.  
  2060. == 20200501183111 CreateDatasetValues: migrating ==============================
  2061. -- create_table(:dataset_values, {})
  2062.    -> 0.0122s
  2063. == 20200501183111 CreateDatasetValues: migrated (0.0123s) =====================
  2064.  
  2065. == 20200509082917 CreateProjectSubmissions: migrating =========================
  2066. -- create_table(:project_submissions, {})
  2067.    -> 0.0146s
  2068. == 20200509082917 CreateProjectSubmissions: migrated (0.0146s) ================
  2069.  
  2070. == 20200515141039 AddInviteTokenToProjects: migrating =========================
  2071. -- add_column(:projects, :invite_token, :string)
  2072.    -> 0.0008s
  2073. == 20200515141039 AddInviteTokenToProjects: migrated (0.0008s) ================
  2074.  
  2075. == 20200520073810 AddInfoRequestToProjectSubmission: migrating ================
  2076. -- add_reference(:project_submissions, :info_request)
  2077.    -> 0.0040s
  2078. == 20200520073810 AddInfoRequestToProjectSubmission: migrated (0.0040s) =======
  2079.  
  2080. == 20210114132408 CreateOutgoingMessageSnippets: migrating ====================
  2081. -- create_table(:outgoing_message_snippets)
  2082.    -> 0.0034s
  2083. == 20210114132408 CreateOutgoingMessageSnippets: migrated (0.0035s) ===========
  2084.  
  2085. == 20210114161442 CreateOutgoingMessageSnippetsTranslations: migrating ========
  2086. == 20210114161442 CreateOutgoingMessageSnippetsTranslations: migrated (0.0336s)
  2087.  
  2088. Model files unchanged.
  2089. Running load-sample-data
  2090. Loaded fixtures. You may now wish to run script/update-xapian-index
  2091. Running destroy-and-rebuild-xapian-index
  2092. ALTER ROLE
  2093. Creating /etc/cron.d/alaveteli... done
  2094. Creating /etc/init.d/alaveteli... done
  2095. Clearing any existing daemons
  2096. Removing /etc/init.d/alaveteli-alert-tracks... done
  2097. Removing /etc/init.d/alaveteli-send-notifications... done
  2098. Removing /etc/init.d/alaveteli-poll-for-incoming... done
  2099. Creating daemons for active daemons
  2100. Creating /etc/init.d/alaveteli-alert-tracks... done
  2101. Creating /etc/init.d/alaveteli-send-notifications... done
  2102. Installation complete
  2103.  
  2104.  
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!