API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.61 KB | None | 0 0
raw download clone embed print report
  1. Migrating up to 20191115144733 from 20191028142712
  2.  
  3. ++ migrating 20191030190955
  4.  
  5. -> CREATE UNIQUE INDEX UNIQ_20FDDF4E1623CB0A ON verification_request (verification_id)
  6.  
  7. ++ migrated (took 195.8ms, used 14M memory)
  8.  
  9. ++ migrating 20191030194916
  10.  
  11. -> DROP SEQUENCE verification_request_id_seq CASCADE
  12.  
  13. ++ migrated (took 206.4ms, used 14M memory)
  14.  
  15. ++ migrating 20191030194958
  16.  
  17. -> CREATE SEQUENCE verification_request_id_seq
  18. -> SELECT setval('verification_request_id_seq', (SELECT MAX(id) FROM verification_request))
  19. -> ALTER TABLE verification_request ALTER id SET DEFAULT nextval('verification_request_id_seq')
  20.  
  21. ++ migrated (took 219.9ms, used 14M memory)
  22.  
  23. ++ migrating 20191031134943
  24.  
  25. -> DROP SEQUENCE secure_storage_file_id_seq CASCADE
  26.  
  27. ++ migrated (took 221.3ms, used 14M memory)
  28.  
  29. ++ migrating 20191031135019
  30.  
  31. -> CREATE SEQUENCE secure_storage_file_id_seq
  32. -> SELECT setval('secure_storage_file_id_seq', (SELECT MAX(id) FROM secure_storage_file))
  33. -> ALTER TABLE secure_storage_file ALTER id SET DEFAULT nextval('secure_storage_file_id_seq')
  34.  
  35. ++ migrated (took 224.3ms, used 14M memory)
  36.  
  37. ++ migrating 20191031143732
  38.  
  39. -> ALTER TABLE document ADD verification_request_id INT DEFAULT NULL
  40. -> ALTER TABLE document ADD CONSTRAINT FK_D8698A76D9E932AB FOREIGN KEY (verification_request_id) REFERENCES verification_request (id) NOT DEFERRABLE INITIALLY IMMEDIATE
  41. -> CREATE INDEX IDX_D8698A76D9E932AB ON document (verification_request_id)
  42.  
  43. ++ migrated (took 231.5ms, used 14M memory)
  44.  
  45. ++ migrating 20191031151525
  46.  
  47. -> DROP SEQUENCE document_id_seq CASCADE
  48.  
  49. ++ migrated (took 232.4ms, used 14M memory)
  50.  
  51. ++ migrating 20191031151617
  52.  
  53. -> CREATE SEQUENCE document_id_seq
  54. -> SELECT setval('document_id_seq', (SELECT MAX(id) FROM document))
  55. -> ALTER TABLE document ALTER id SET DEFAULT nextval('document_id_seq')
  56.  
  57. ++ migrated (took 234.5ms, used 14M memory)
  58.  
  59. ++ migrating 20191031195856
  60.  
  61. -> DROP SEQUENCE address_id_seq CASCADE
  62.  
  63. ++ migrated (took 235.3ms, used 14M memory)
  64.  
  65. ++ migrating 20191031195933
  66.  
  67. -> CREATE SEQUENCE address_id_seq
  68. -> SELECT setval('address_id_seq', (SELECT MAX(id) FROM address))
  69. -> ALTER TABLE address ALTER id SET DEFAULT nextval('address_id_seq')
  70.  
  71. ++ migrated (took 237.9ms, used 14M memory)
  72.  
  73. ++ migrating 20191101054119
  74.  
  75. -> ALTER TABLE verification_request ADD face_proof_id INT DEFAULT NULL
  76. -> ALTER TABLE verification_request ADD CONSTRAINT FK_20FDDF4EF3AC6BB0 FOREIGN KEY (face_proof_id) REFERENCES secure_storage_file (id) NOT DEFERRABLE INITIALLY IMMEDIATE
  77. -> CREATE INDEX IDX_20FDDF4EF3AC6BB0 ON verification_request (face_proof_id)
  78.  
  79. ++ migrated (took 241.5ms, used 14M memory)
  80.  
  81. ++ migrating 20191101094959
  82.  
  83. -> ALTER TABLE secure_storage_file ADD account_id INT DEFAULT NULL
  84. -> ALTER TABLE secure_storage_file ADD version INT DEFAULT NULL
  85. -> ALTER TABLE secure_storage_file ADD name VARCHAR(255) DEFAULT NULL
  86.  
  87. ++ migrated (took 246.4ms, used 14M memory)
  88.  
  89. ++ migrating 20191110100709
  90.  
  91. -> ALTER TABLE secure_storage_file ADD object_type VARCHAR(255)
  92. -> UPDATE secure_storage_file SET object_type = 'document_proof'
  93. -> ALTER TABLE secure_storage_file ALTER COLUMN object_type SET NOT NULL
  94. -> ALTER TABLE secure_storage_file ADD object_id INT DEFAULT NULL
  95. -> CREATE INDEX IDX_F1D87695232D562B ON secure_storage_file (object_id)
  96. -> UPDATE secure_storage_file s SET object_type = 'address_proof', object_id = a.id FROM address a WHERE a.proof_id = s.id
  97. -> UPDATE secure_storage_file s SET object_type = 'face_proof', object_id = vr.id FROM verification_request vr WHERE vr.face_proof_id = s.id
  98. -> UPDATE secure_storage_file s SET object_type = 'document_proof', object_id = d.id FROM "document" d WHERE d.proof_id = s.id
  99. -> UPDATE secure_storage_file s SET object_type = 'document_proof', object_id = d.id FROM "document" d WHERE d.additional_proof_id = s.id
  100.  
  101. ++ migrated (took 252.1ms, used 14M memory)
  102.  
  103. ++ migrating 20191110160718
  104.  
  105. -> ALTER TABLE document DROP CONSTRAINT fk_d8698a76d7086615
  106. -> ALTER TABLE document DROP CONSTRAINT fk_d8698a766dd9dac3
  107. -> DROP INDEX uniq_d8698a76d7086615
  108. -> DROP INDEX uniq_d8698a766dd9dac3
  109. -> ALTER TABLE document DROP proof_id
  110. -> ALTER TABLE document DROP additional_proof_id
  111. -> ALTER TABLE verification_request DROP CONSTRAINT fk_20fddf4ef3ac6bb0
  112. -> ALTER TABLE verification_request DROP CONSTRAINT fk_20fddf4e45f87f75
  113. -> ALTER TABLE verification_request DROP CONSTRAINT fk_20fddf4e2ea498ba
  114. -> DROP INDEX idx_20fddf4ef3ac6bb0
  115. -> DROP INDEX idx_20fddf4e45f87f75
  116. -> DROP INDEX idx_20fddf4e2ea498ba
  117. -> ALTER TABLE verification_request DROP document_one_id
  118. -> ALTER TABLE verification_request DROP document_two_id
  119. -> ALTER TABLE verification_request DROP face_proof_id
  120. -> ALTER TABLE address DROP CONSTRAINT fk_d4e6f81d7086615
  121. -> DROP INDEX uniq_d4e6f81d7086615
  122. -> ALTER TABLE address DROP proof_id
  123.  
  124. ++ migrated (took 261.6ms, used 14M memory)
  125.  
  126. ++ migrating 20191111091811
  127.  
  128. -> ALTER TABLE verification_request DROP CONSTRAINT fk_20fddf4ef5b7af75
  129. -> DROP INDEX idx_20fddf4ef5b7af75
  130. -> ALTER TABLE address ADD verification_request_id INT DEFAULT NULL
  131. -> UPDATE address a SET verification_request_id = vr.id FROM verification_request vr WHERE vr.address_id = a.id
  132. -> ALTER TABLE verification_request DROP address_id
  133. -> ALTER TABLE address ADD CONSTRAINT FK_D4E6F81D9E932AB FOREIGN KEY (verification_request_id) REFERENCES verification_request (id) NOT DEFERRABLE INITIALLY IMMEDIATE
  134. -> CREATE UNIQUE INDEX UNIQ_D4E6F81D9E932AB ON address (verification_request_id)
  135.  
  136. ++ migrated (took 339.9ms, used 14M memory)
  137.  
  138. ++ migrating 20191111095345
  139.  
  140. -> ALTER TABLE verification_request DROP CONSTRAINT fk_20fddf4e3b7323cb
  141. -> DROP INDEX idx_20fddf4e3b7323cb
  142. -> ALTER TABLE phone ADD verification_request_id INT DEFAULT NULL
  143. -> UPDATE phone p SET verification_request_id = vr.id FROM verification_request vr WHERE vr.phone_id = p.id
  144. -> ALTER TABLE verification_request DROP phone_id
  145. -> ALTER TABLE phone ADD CONSTRAINT FK_444F97DDD9E932AB FOREIGN KEY (verification_request_id) REFERENCES verification_request (id) NOT DEFERRABLE INITIALLY IMMEDIATE
  146. -> CREATE UNIQUE INDEX UNIQ_444F97DDD9E932AB ON phone (verification_request_id)
  147.  
  148. ++ migrated (took 345.9ms, used 14M memory)
  149.  
  150. ++ migrating 20191111123546
  151.  
  152. -> CREATE TABLE background_check (id SERIAL NOT NULL, verification_request_id INT NOT NULL, birth_date DATE DEFAULT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, middle_name VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))
  153. -> CREATE UNIQUE INDEX UNIQ_6DA93E34D9E932AB ON background_check (verification_request_id)
  154. -> ALTER TABLE background_check ADD CONSTRAINT FK_6DA93E34D9E932AB FOREIGN KEY (verification_request_id) REFERENCES verification_request (id) NOT DEFERRABLE INITIALLY IMMEDIATE
  155. -> ALTER TABLE document ADD first_name VARCHAR(255) DEFAULT NULL
  156. -> ALTER TABLE document ADD last_name VARCHAR(255) DEFAULT NULL
  157. -> ALTER TABLE document ADD middle_name VARCHAR(255) DEFAULT NULL
  158. -> ALTER TABLE address ADD first_name VARCHAR(255) DEFAULT NULL
  159. -> ALTER TABLE address ADD last_name VARCHAR(255) DEFAULT NULL
  160. -> ALTER TABLE address ADD middle_name VARCHAR(255) DEFAULT NULL
  161.  
  162. ++ migrated (took 452.4ms, used 14M memory)
  163.  
  164. ++ migrating 20191114150029
  165.  
  166. -> DELETE FROM verification_request_status
  167. -> INSERT INTO verification_request_status (id, name) VALUES (1, 'not_verified')
  168. -> INSERT INTO verification_request_status (id, name) VALUES (2, 'verification_requested')
  169. -> INSERT INTO verification_request_status (id, name) VALUES (3, 'additional_request')
  170. -> INSERT INTO verification_request_status (id, name) VALUES (4, 'approved')
  171. -> INSERT INTO verification_request_status (id, name) VALUES (5, 'on_hold')
  172. -> INSERT INTO verification_request_status (id, name) VALUES (6, 'failed')
  173.  
  174. ++ migrated (took 455.7ms, used 14M memory)
  175.  
  176. ++ migrating 20191115144733
  177.  
  178. -> ALTER TABLE verification_response ALTER COLUMN id SET DEFAULT nextval('verification_response_id_seq')
  179. -> ALTER TABLE secure_storage_file ALTER COLUMN uri TYPE text
  180. -> ALTER TABLE verification_request ALTER COLUMN investor_id SET NOT NULL
  181.  
  182. ++ migrated (took 457.5ms, used 14M memory)
  183.  
  184. ------------------------
  185.  
  186. ++ finished in 510.6ms
  187. ++ used 14M memory
  188. ++ 19 migrations executed
  189. ++ 86 sql queries
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!