Guest User

Untitled

a guest
May 3rd, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.10 KB | None | 0 0
  1. remigrating in RAILS_ENV=development
  2. == 1 Launch: migrating ========================================================
  3. -- create_table("actions", {:force=>true})
  4. -> 0.0741s
  5. -- create_table("activities", {:force=>true})
  6. -> 0.0043s
  7. -- create_table("advert_styles", {:force=>true})
  8. -> 0.0069s
  9. -- create_table("adverts", {:force=>true})
  10. -> 0.0086s
  11. -- create_table("asset_types", {:force=>true})
  12. -> 0.0038s
  13. -- create_table("assets", {:force=>true})
  14. -> 0.0061s
  15. -- add_index("assets", ["creator_id"], {:name=>"index_assets_on_creator_id"})
  16. -> 0.4965s
  17. -- create_table("avatars", {:force=>true})
  18. -> 0.0992s
  19. -- create_table("blogs", {:force=>true})
  20. -> 0.1082s
  21. -- create_table("brains", {:force=>true})
  22. -> 0.0800s
  23. -- create_table("categories", {:force=>true})
  24. -> 0.0374s
  25. -- create_table("challenges", {:force=>true})
  26. -> 0.0053s
  27. -- add_index("challenges", ["sender_score_id"], {:name=>"index_challenges_on_sender_score_id"})
  28. -> 0.5465s
  29. -- add_index("challenges", ["receiver_score_id"], {:name=>"index_challenges_on_receiver_score_id"})
  30. -> 0.0175s
  31. -- create_table("chats", {:force=>true})
  32. -> 0.0052s
  33. -- add_index("chats", ["user_id1"], {:name=>"index_chats_on_user_id1"})
  34. -> 0.0077s
  35. -- add_index("chats", ["user_id2"], {:name=>"index_chats_on_user_id2"})
  36. -> 0.0558s
  37. -- create_table("comments", {:force=>true})
  38. -> 0.0055s
  39. -- add_index("comments", ["user_id"], {:name=>"fk_comments_user"})
  40. -> 0.0093s
  41. -- create_table("configurations", {:force=>true})
  42. -> 0.0053s
  43. -- create_table("creators", {:force=>true})
  44. -> 0.0065s
  45. -- create_table("encounters", {:force=>true})
  46. -> 0.0048s
  47. -- create_table("events", {:force=>true})
  48. -> 0.0752s
  49. -- create_table("friendships", {:force=>true})
  50. -> 0.0276s
  51. -- add_index("friendships", ["user_id", "user_id_target"], {:name=>"index_friendships_on_user_id_and_user_id_target"})
  52. -> 0.0097s
  53. -- create_table("game_configs", {:force=>true})
  54. -> 0.0055s
  55. -- create_table("game_images", {:force=>true})
  56. -> 0.0059s
  57. -- create_table("game_scores", {:force=>true})
  58. -> 0.0063s
  59. -- add_index("game_scores", ["user_id"], {:name=>"index_game_scores_on_user_id"})
  60. -> 0.0103s
  61. -- add_index("game_scores", ["game_id"], {:name=>"index_game_scores_on_game_id"})
  62. -> 0.0093s
  63. -- create_table("games", {:force=>true})
  64. -> 0.0909s
  65. -- create_table("games_genres", {:force=>true, :id=>false})
  66. -> 0.0049s
  67. -- create_table("games_users", {:force=>true, :id=>false})
  68. -> 0.0041s
  69. -- create_table("genres", {:force=>true})
  70. -> 0.0058s
  71. -- create_table("groups", {:force=>true})
  72. -> 0.0083s
  73. -- create_table("handsets", {:force=>true})
  74. -> 0.0322s
  75. -- add_index("handsets", ["user_id"], {:name=>"index_handsets_on_user_id"})
  76. -> 0.0081s
  77. -- create_table("homes", {:force=>true})
  78. -> 0.0041s
  79. -- create_table("items", {:force=>true})
  80. -> 0.0055s
  81. -- create_table("items_shops", {:force=>true, :id=>false})
  82. -> 0.0041s
  83. -- create_table("locations", {:force=>true})
  84. -> 0.0050s
  85. -- create_table("memberships", {:force=>true})
  86. -> 0.0048s
  87. -- create_table("messages", {:force=>true})
  88. -> 0.0092s
  89. -- add_index("messages", ["sender_id", "receiver_id"], {:name=>"index_messages_on_sender_id_and_receiver_id"})
  90. -> 0.0111s
  91. -- create_table("occupations", {:force=>true})
  92. -> 0.0061s
  93. -- create_table("photos", {:force=>true})
  94. -> 0.0058s
  95. -- add_index("photos", ["user_id"], {:name=>"index_photos_on_user_id"})
  96. -> 0.0093s
  97. -- create_table("plugin_schema_info", {:force=>true, :id=>false})
  98. -> 0.0044s
  99. -- create_table("powerups", {:force=>true})
  100. -> 0.0057s
  101. -- create_table("prizes", {:force=>true})
  102. -> 0.0043s
  103. -- add_index("prizes", ["user_id"], {:name=>"index_prizes_on_user_id"})
  104. -> 0.0259s
  105. -- add_index("prizes", ["item_id"], {:name=>"index_prizes_on_item_id"})
  106. -> 0.0103s
  107. -- create_table("profiles", {:force=>true})
  108. -> 0.0056s
  109. -- add_index("profiles", ["user_id"], {:name=>"index_profiles_on_user_id"})
  110. -> 0.0095s
  111. -- create_table("scores", {:force=>true})
  112. -> 0.0044s
  113. -- add_index("scores", ["game_id"], {:name=>"index_scores_on_game_id"})
  114. -> 0.0112s
  115. -- add_index("scores", ["user_id"], {:name=>"index_scores_on_user_id"})
  116. -> 0.0270s
  117. -- create_table("screensavers", {:force=>true})
  118. -> 0.0043s
  119. -- create_table("sessions", {:force=>true})
  120. -> 0.0047s
  121. -- add_index("sessions", ["session_id"], {:name=>"index_sessions_on_session_id"})
  122. -> 0.0205s
  123. -- add_index("sessions", ["updated_at"], {:name=>"index_sessions_on_updated_at"})
  124. -> 0.0093s
  125. -- create_table("shops", {:force=>true})
  126. -> 0.0048s
  127. -- create_table("specs", {:force=>true})
  128. -> 0.0071s
  129. -- create_table("statuses", {:force=>true})
  130. -> 0.0042s
  131. -- create_table("terms", {:force=>true})
  132. -> 0.0050s
  133. -- create_table("topics", {:force=>true})
  134. -> 0.0057s
  135. -- create_table("tops", {:force=>true})
  136. -> 0.0068s
  137. -- create_table("transfers", {:force=>true})
  138. -> 0.0046s
  139. -- add_index("transfers", ["from_id"], {:name=>"index_transfers_on_from_id"})
  140. -> 0.0660s
  141. -- add_index("transfers", ["to_id"], {:name=>"index_transfers_on_to_id"})
  142. -> 0.0100s
  143. -- create_table("user_items", {:force=>true})
  144. -> 0.0042s
  145. -- add_index("user_items", ["user_id"], {:name=>"index_user_items_on_user_id"})
  146. -> 0.0639s
  147. -- add_index("user_items", ["item_id"], {:name=>"index_user_items_on_item_id"})
  148. -> 0.0089s
  149. -- create_table("user_logs", {:force=>true})
  150. -> 0.0243s
  151. -- create_table("users", {:force=>true})
  152. -> 0.0385s
  153. -- add_index("users", ["brain_id"], {:name=>"index_users_on_brain_id"})
  154. -> 0.0103s
  155. -- add_index("users", ["avatar_id"], {:name=>"index_users_on_avatar_id"})
  156. -> 0.0104s
  157. -- create_table(:user_stats)
  158. -> 0.0313s
  159. -- add_index("user_stats", ["user_id"], {:name=>"index_user_stats_on_user_id"})
  160. -> 0.0090s
  161. -- create_table(:mood_types)
  162. -> 0.0365s
  163. -- create_table(:greetings)
  164. -> 0.0038s
  165. -- create_table(:moods)
  166. -> 0.0057s
  167. -- create_table(:news)
  168. -> 0.0046s
  169. == 1 Launch: migrated (2.5467s) ===============================================
  170.  
  171. == 2 CreateVisitors: migrating ================================================
  172. -- create_table(:visitors)
  173. -> 0.0044s
  174. == 2 CreateVisitors: migrated (0.0048s) =======================================
  175.  
  176. == 3 CreatePowerupLimits: migrating ===========================================
  177. -- create_table(:powerup_limits)
  178. -> 0.0042s
  179. == 3 CreatePowerupLimits: migrated (0.0046s) ==================================
  180.  
  181. == 4 CreateAffiliates: migrating ==============================================
  182. -- create_table(:affiliates)
  183. -> 0.0042s
  184. == 4 CreateAffiliates: migrated (0.0045s) =====================================
  185.  
  186. == 5 CreateCoins: migrating ===================================================
  187. -- create_table(:coins)
  188. -> 0.0052s
  189. == 5 CreateCoins: migrated (0.0057s) ==========================================
  190.  
  191. == 6 CreateUnansweredEmails: migrating ========================================
  192. -- create_table(:unanswered_emails)
  193. -> 0.0049s
  194. == 6 CreateUnansweredEmails: migrated (0.0054s) ===============================
  195.  
  196. == 7 CreateAdwaysExceptions: migrating ========================================
  197. -- create_table(:adways_exceptions)
  198. -> 0.0053s
  199. == 7 CreateAdwaysExceptions: migrated (0.0058s) ===============================
  200.  
  201. == 8 CreateSettings: migrating ================================================
  202. -- create_table(:settings)
  203. -> 0.0033s
  204. == 8 CreateSettings: migrated (0.0036s) =======================================
  205.  
  206. == 9 CreateIntros: migrating ==================================================
  207. -- create_table(:intros)
  208. -> 0.0053s
  209. == 9 CreateIntros: migrated (0.0058s) =========================================
  210.  
  211. == 10 AddChangedEmailIntoUsers: migrating =====================================
  212. -- add_column(:users, :change_email_to, :string)
  213. -> 0.0315s
  214. == 10 AddChangedEmailIntoUsers: migrated (0.0320s) ============================
  215.  
  216. == 11 ModifyGreetingsStyle: migrating =========================================
  217. -- add_column(:greetings, :template, :string, {:limit=>150})
  218. -> 0.0613s
  219. -- add_column(:greetings, :font, :string, {:limit=>100})
  220. -> 0.0086s
  221. -- add_column(:greetings, :style, :string, {:limit=>50})
  222. -> 0.0094s
  223. -- add_column(:greetings, :size, :string, {:limit=>10})
  224. -> 0.0091s
  225. == 11 ModifyGreetingsStyle: migrated (0.0912s) ================================
  226.  
  227. == 12 AddCoinsToUsersTable: migrating =========================================
  228. -- add_column(:users, :coins, :integer, {:default=>0})
  229. -> 0.0103s
  230. == 12 AddCoinsToUsersTable: migrated (0.0126s) ================================
  231.  
  232. == 13 CreateAnsweredSurveys: migrating ========================================
  233. -- create_table(:answered_surveys)
  234. -> 0.0564s
  235. == 13 CreateAnsweredSurveys: migrated (0.0572s) ===============================
  236.  
  237. == 14 CreateSurveys: migrating ================================================
  238. -- create_table(:surveys)
  239. -> 0.0055s
  240. == 14 CreateSurveys: migrated (0.0060s) =======================================
  241.  
  242. == 15 CreateQuestions: migrating ==============================================
  243. -- create_table(:questions)
  244. -> 0.0035s
  245. == 15 CreateQuestions: migrated (0.0037s) =====================================
  246.  
  247. == 16 CreateAnswers: migrating ================================================
  248. -- create_table(:answers)
  249. -> 0.0041s
  250. == 16 CreateAnswers: migrated (0.0044s) =======================================
  251.  
  252. == 17 CreateChoices: migrating ================================================
  253. -- create_table(:choices)
  254. -> 0.0042s
  255. == 17 CreateChoices: migrated (0.0046s) =======================================
  256.  
  257. == 18 AddFriendCountToUsers: migrating ========================================
  258. -- add_column(:users, :friend_count, :integer, {:default=>0})
  259. -> 0.0132s
  260. == 18 AddFriendCountToUsers: migrated (0.0138s) ===============================
  261.  
  262. == 19 AddValueToAvatars: migrating ============================================
  263. -- add_column(:avatars, :value, :integer, {:default=>0})
  264. -> 0.0101s
  265. == 19 AddValueToAvatars: migrated (0.0102s) ===================================
  266.  
  267. == 20 AddLiveToItemsTable: migrating ==========================================
  268. -- add_column(:items, :live, :integer, {:default=>0})
  269. -> 0.0088s
  270. == 20 AddLiveToItemsTable: migrated (0.0092s) =================================
  271.  
  272. == 21 AddIndexToSurveysStuffs: migrating ======================================
  273. -- execute("ALTER TABLE answered_surveys ADD FOREIGN KEY answered_surveys_fk_index_on_user_id (user_id) REFERENCES users(id)")
  274. -> 0.0092s
  275. -- execute("ALTER TABLE answered_surveys ADD FOREIGN KEY answered_surveys_fk_index_on_survey_id (survey_id) REFERENCES surveys(id)")
  276. -> 0.0181s
  277. -- execute("ALTER TABLE questions ADD FOREIGN KEY questions_fk_index_on_survey_id (survey_id) REFERENCES surveys(id)")
  278. -> 0.0102s
  279. -- execute("ALTER TABLE choices ADD FOREIGN KEY choices_fk_index_on_question_id (question_id) REFERENCES questions(id)")
  280. -> 0.0104s
  281. -- execute("ALTER TABLE answers ADD FOREIGN KEY answers_fk_index_on_choice_id (choice_id) REFERENCES choices(id)")
  282. -> 0.0092s
  283. -- execute("ALTER TABLE answers ADD FOREIGN KEY answers_fk_index_on_answered_survey_id (answered_survey_id) REFERENCES answered_surveys(id)")
  284. -> 0.0101s
  285. == 21 AddIndexToSurveysStuffs: migrated (0.0728s) =============================
  286.  
  287. == 22 AddBlockToBlogsTable: migrating =========================================
  288. -- add_column(:blogs, :block, :integer, {:default=>0})
  289. -> 0.0085s
  290. == 22 AddBlockToBlogsTable: migrated (0.0088s) ================================
  291.  
  292. == 23 AddMoreStuffsToSurveysAndFriends: migrating =============================
  293. -- remove_column(:choices, :number)
  294. -> 0.0408s
  295. -- add_column(:questions, :choices_count, :integer, {:default=>0})
  296. -> 0.0087s
  297. -- add_column(:surveys, :close, :boolean, {:default=>false})
  298. -> 0.0092s
  299. -- add_column(:surveys, :user_id, :integer)
  300. -> 0.0089s
  301. -- execute("ALTER TABLE surveys ADD FOREIGN KEY surveys_fk_index_on_user_id (user_id) REFERENCES users(id)")
  302. -> 0.0109s
  303. == 23 AddMoreStuffsToSurveysAndFriends: migrated (0.0842s) ====================
  304.  
  305. == 24 EvenMoreStuffsToSurveys: migrating ======================================
  306. -- remove_column(:surveys, :close)
  307. -> 0.0087s
  308. -- add_column(:surveys, :published, :boolean, {:default=>false})
  309. -> 0.0091s
  310. == 24 EvenMoreStuffsToSurveys: migrated (0.0184s) =============================
  311.  
  312. == 25 AddEmail: migrating =====================================================
  313. -- create_table(:emails)
  314. -> 0.0045s
  315. == 25 AddEmail: migrated (0.0050s) ============================================
  316.  
  317. == 26 CreateMessageSettings: migrating ========================================
  318. -- create_table(:message_settings)
  319. -> 0.0037s
  320. == 26 CreateMessageSettings: migrated (0.1775s) ===============================
  321.  
  322. == 27 ChangeEventDatesFromStringToDatetime: migrating =========================
  323. -- change_column(:events, :created_at, :datetime)
  324. -> 0.3518s
  325. -- change_column(:events, :updated_at, :datetime)
  326. -> 0.4529s
  327. == 27 ChangeEventDatesFromStringToDatetime: migrated (0.8055s) ================
  328.  
  329. == 28 AddGroupIdOnGames: migrating ============================================
  330. -- add_column(:games, :group_id, :integer)
  331. -> 0.1189s
  332. == 28 AddGroupIdOnGames: migrated (0.1192s) ===================================
  333.  
  334. == 29 AddTopicIdOnGames: migrating ============================================
  335. -- add_column(:games, :topic_id, :integer)
  336. -> 0.0108s
  337. == 29 AddTopicIdOnGames: migrated (0.0113s) ===================================
  338.  
  339. == 30 CreateUserStatistics: migrating =========================================
  340. -- create_table(:user_statistics)
  341. -> 0.1732s
  342. == 30 CreateUserStatistics: migrated (0.2198s) ================================
  343.  
  344. == 31 AddCreatedAtToProfile: migrating ========================================
  345. -- add_column(:profiles, :created_at, :timestamp)
  346. -> 0.0085s
  347. == 31 AddCreatedAtToProfile: migrated (0.0243s) ===============================
  348.  
  349. == 33 AddPrivacySettingsOnProfiles: migrating =================================
  350. -- add_column(:profiles, :age_published, :boolean, {:default=>false})
  351. -> 0.0185s
  352. -- add_column(:profiles, :married_published, :boolean, {:default=>true})
  353. -> 0.0082s
  354. -- add_column(:profiles, :gender_published, :boolean, {:default=>true})
  355. -> 0.0170s
  356. -- add_column(:profiles, :location_published, :boolean, {:default=>true})
  357. -> 0.0361s
  358. -- add_column(:profiles, :occupation_published, :boolean, {:default=>true})
  359. -> 0.0167s
  360. == 33 AddPrivacySettingsOnProfiles: migrated (0.1076s) ========================
  361.  
  362. == 34 TransfersArchive: migrating =============================================
  363. -- create_table("transfers_archive", {:force=>true})
  364. -> 0.0063s
  365. -- add_index("transfers_archive", ["from_id"], {:name=>"index_transfers_archive_on_from_id"})
  366. -> 0.1096s
  367. -- add_index("transfers_archive", ["to_id"], {:name=>"index_transfers_archive_on_to_id"})
  368. -> 0.0115s
  369. == 34 TransfersArchive: migrated (0.1283s) ====================================
  370.  
  371. == 35 MessagesArchive: migrating ==============================================
  372. -- create_table("messages_archive", {:force=>true})
  373. -> 0.0069s
  374. -- add_index("messages_archive", ["sender_id", "receiver_id"], {:name=>"index_messages_archive_on_sender_id_and_receiver_id"})
  375. -> 0.0098s
  376. -- add_index("messages_archive", ["sender_id", "have_read"], {:name=>"index_messages_archive_on_have_read"})
  377. -> 0.0508s
  378. == 35 MessagesArchive: migrated (0.0688s) =====================================
  379.  
  380. == 36 EventsArchive: migrating ================================================
  381. -- create_table("events_archive", {:force=>true})
  382. -> 0.0395s
  383. -- add_index("events_archive", ["user_id"], {:name=>"index_events_archive_user_id"})
  384. -> 0.0088s
  385. == 36 EventsArchive: migrated (0.0489s) =======================================
  386.  
  387. == 37 AddingIndexes: migrating ================================================
  388. -- add_index(:handsets, :subscribe_id)
  389. -> 0.0085s
  390. == 37 AddingIndexes: migrated (0.0115s) =======================================
  391.  
  392. == 38 AddingIndexesOnItemsAndItemsShops: migrating ============================
  393. items asset_id
  394. -- add_index(:items, :asset_id)
  395. -> 0.0844s
  396. items_shops shop_id
  397. -- add_index(:items_shops, :shop_id)
  398. -> 0.0092s
  399. items_shops item_id
  400. -- add_index(:items_shops, :item_id)
  401. -> 0.0098s
  402. == 38 AddingIndexesOnItemsAndItemsShops: migrated (0.1046s) ===================
  403.  
  404. == 39 CreateCreatorSets: migrating ============================================
  405. -- create_table(:creatorsets)
  406. -> 0.0057s
  407. == 39 CreateCreatorSets: migrated (0.0118s) ===================================
  408.  
  409. == 40 MoveBackgroundColorToCreators: migrating ================================
  410. -- remove_column(:creatorsets, :background_color)
  411. -> 0.1420s
  412. -- add_column(:creators, :background_color, :string, {:default=>"#CCFFCC"})
  413. -> 1.9455s
  414. == 40 MoveBackgroundColorToCreators: migrated (2.0888s) =======================
  415.  
  416. == 41 MoveFlashPathToCreators: migrating ======================================
  417. -- remove_column(:creatorsets, :flash_path)
  418. -> 0.0072s
  419. -- add_column(:creators, :flash_path, :string)
  420. -> 2.9966s
  421. == 41 MoveFlashPathToCreators: migrated (3.0049s) =============================
  422.  
  423. == 42 ChangeHairbackToBackgroundAndAddItem: migrating =========================
  424. -- remove_column(:creatorsets, :hairback)
  425. -> 0.0140s
  426. -- add_column(:creatorsets, :background, :integer)
  427. -> 0.0284s
  428. -- add_column(:creatorsets, :item, :integer)
  429. -> 0.0118s
  430. == 42 ChangeHairbackToBackgroundAndAddItem: migrated (0.0552s) ================
  431.  
  432. == 43 AddingIndexesOnGamesRelated: migrating ==================================
  433. -- add_index(:games, :asset_id)
  434. -> 0.0088s
  435. -- add_index(:games, :trailer)
  436. -> 0.0109s
  437. -- add_index(:games, :group_id)
  438. -> 0.0131s
  439. -- add_index(:game_configs, :game_id)
  440. -> 0.0486s
  441. -- add_index(:game_configs, :item_id)
  442. -> 0.0095s
  443. -- add_index(:game_images, :game_id)
  444. -> 0.0107s
  445. -- add_index(:games_genres, :game_id)
  446. -> 0.0343s
  447. -- add_index(:games_genres, :genre_id)
  448. -> 0.0105s
  449. -- add_index(:games_users, :game_id)
  450. -> 0.0090s
  451. -- add_index(:games_users, :user_id)
  452. -> 0.0082s
  453. == 43 AddingIndexesOnGamesRelated: migrated (0.1731s) =========================
  454.  
  455. == 44 AddingIndexesOnTables: migrating ========================================
  456. -- add_index(:affiliates, :user_id)
  457. -> 0.0090s
  458. -- add_index(:answered_surveys, :user_id)
  459. -> 0.0139s
  460. -- add_index(:answers, :choice_id)
  461. -> 0.0098s
  462. -- add_index(:blogs, :user_id)
  463. -> 0.0106s
  464. -- add_index(:choices, :question_id)
  465. -> 0.0111s
  466. -- add_index(:creators, :poster_asset_id)
  467. -> 0.0116s
  468. -- add_index(:groups, :creator_id)
  469. -> 0.0591s
  470. -- add_index(:groups, :category_id)
  471. -> 0.0878s
  472. -- add_index(:intros, :profile_id)
  473. -> 0.0798s
  474. -- add_index(:memberships, :user_id)
  475. -> 0.0586s
  476. -- add_index(:memberships, :group_id)
  477. -> 0.0538s
  478. -- add_index(:message_settings, :user_id)
  479. -> 0.0543s
  480. -- add_index(:moods, :mood_type_id)
  481. -> 0.0081s
  482. -- add_index(:moods, :user_id)
  483. -> 0.0089s
  484. -- add_index(:powerup_limits, :game_id)
  485. -> 0.0096s
  486. -- add_index(:powerups, :user_id)
  487. -> 0.0671s
  488. -- add_index(:powerups, :game_id)
  489. -> 0.0096s
  490. -- add_index(:profiles, :location_id)
  491. -> 0.0112s
  492. -- add_index(:profiles, :occupation_id)
  493. -> 0.0485s
  494. -- add_index(:questions, :survey_id)
  495. -> 0.0314s
  496. -- add_index(:settings, :user_id)
  497. -> 0.0697s
  498. -- add_index(:shops, :shopkeeper)
  499. -> 0.0090s
  500. -- add_index(:shops, :shoplogo)
  501. -> 0.0102s
  502. -- add_index(:shops, :background)
  503. -> 0.0322s
  504. -- add_index(:topics, :group_id)
  505. -> 0.0413s
  506. -- add_index(:user_logs, :target_id)
  507. -> 0.0074s
  508. -- add_index(:user_logs, :viewer_id)
  509. -> 0.0113s
  510. -- add_index(:user_logs, :user_id)
  511. -> 0.0300s
  512. == 44 AddingIndexesOnTables: migrated (0.8847s) ===============================
  513.  
  514. == 45 AddRegFlagOnUsers: migrating ============================================
  515. -- add_column(:users, :reg_flag, :integer, {:default=>255})
  516. -> 0.0303s
  517. == 45 AddRegFlagOnUsers: migrated (0.0306s) ===================================
  518.  
  519. == 46 CreateUserQuests: migrating =============================================
  520. -- create_table(:user_quests)
  521. -> 0.0057s
  522. -- add_index(:user_quests, :user_id)
  523. -> 0.0111s
  524. -- add_index(:user_quests, :quest_name)
  525. -> 0.0666s
  526. == 46 CreateUserQuests: migrated (0.0843s) ====================================
  527.  
  528. == 47 CreatePlogs: migrating ==================================================
  529. -- create_table(:plogs)
  530. -> 0.0044s
  531. == 47 CreatePlogs: migrated (0.0049s) =========================================
  532.  
  533. == 48 CreateNpcs: migrating ===================================================
  534. -- create_table(:npcs)
  535. -> 0.0036s
  536. == 48 CreateNpcs: migrated (0.0040s) ==========================================
  537.  
  538. == 49 PlayerMapinfo: migrating ================================================
  539. -- add_column(:user_quests, :px, :integer, {:default=>4})
  540. -> 0.0097s
  541. -- add_column(:user_quests, :py, :integer, {:default=>2})
  542. -> 0.0503s
  543. -- add_column(:user_quests, :map_tile, :integer, {:default=>50})
  544. -> 0.0160s
  545. -- add_column(:user_quests, :map_name, :string, {:default=>"a"})
  546. -> 0.0333s
  547. == 49 PlayerMapinfo: migrated (0.1113s) =======================================
  548.  
  549. == 50 CreateStatUsers: migrating ==============================================
  550. -- create_table(:stat_users)
  551. -> 0.0059s
  552. == 50 CreateStatUsers: migrated (0.0062s) =====================================
  553.  
  554. == 51 AddFieldsOnStatsUsers: migrating ========================================
  555. -- remove_column(:stat_users, :active_users_in_prosent)
  556. -> 0.0588s
  557. -- add_column(:stat_users, :active_users_in_prosent, :float)
  558. -> 0.0089s
  559. -- rename_column(:stat_users, :updated_at, :stat_date)
  560. -> 0.0127s
  561. -- add_column(:stat_users, :batch_number, :integer, {:default=>0})
  562. -> 0.0276s
  563. == 51 AddFieldsOnStatsUsers: migrated (0.1090s) ===============================
  564.  
  565. == 52 AddStatHowSpentTable: migrating =========================================
  566. -- create_table(:stat_how_spents)
  567. -> 0.0045s
  568. == 52 AddStatHowSpentTable: migrated (0.0047s) ================================
  569.  
  570. == 53 ChangeBodyStringToTextOnBlog: migrating =================================
  571. -- change_column(:blogs, :body, :text)
  572. -> 0.0152s
  573. == 53 ChangeBodyStringToTextOnBlog: migrated (0.0223s) ========================
  574.  
  575. == 54 CreateStatAdverts: migrating ============================================
  576. -- create_table(:stat_adverts)
  577. -> 0.0094s
  578. == 54 CreateStatAdverts: migrated (0.0106s) ===================================
  579.  
  580. == 55 CreateStatGames: migrating ==============================================
  581. -- create_table(:stat_games)
  582. -> 0.0563s
  583. == 55 CreateStatGames: migrated (0.0567s) =====================================
  584.  
  585. == 56 CreateProfileQuestionsTables: migrating =================================
  586. -- create_table(:p_questions)
  587. -> 0.0037s
  588. -- add_index(:p_questions, :name)
  589. -> 0.0088s
  590. -- create_table(:p_answers)
  591. -> 0.0042s
  592. -- add_index(:p_answers, :p_question_id)
  593. -> 0.0091s
  594. -- create_table(:p_user_answers)
  595. -> 0.0042s
  596. -- add_index(:p_user_answers, :user_id)
  597. -> 0.0094s
  598. -- add_index(:p_user_answers, :p_question_id)
  599. -> 0.0117s
  600. -- add_index(:p_user_answers, :p_answer_id)
  601. -> 0.0100s
  602. == 56 CreateProfileQuestionsTables: migrated (0.0633s) ========================
  603.  
  604. == 57 AddUniqueIndexNameToItems: migrating ====================================
  605. -- add_index(:items, :name, {:unique=>true})
  606. -> 0.0089s
  607. == 57 AddUniqueIndexNameToItems: migrated (0.0094s) ===========================
  608.  
  609. == 58 CreateStatRecords: migrating ============================================
  610. -- create_table(:stat_records)
  611. -> 0.0054s
  612. == 58 CreateStatRecords: migrated (0.0056s) ===================================
  613.  
  614. == 59 AddNameToQuestions: migrating ===========================================
  615. -- add_column(:questions, :name, :string)
  616. -> 0.0115s
  617. -- add_index(:questions, :name)
  618. -> 0.0309s
  619. == 59 AddNameToQuestions: migrated (0.0433s) ==================================
  620.  
  621. == 60 AddNumberToChoices: migrating ===========================================
  622. -- add_column(:choices, :number, :integer)
  623. -> 0.0397s
  624. -- add_index(:choices, :number)
  625. -> 0.0405s
  626. == 60 AddNumberToChoices: migrated (0.0808s) ==================================
  627.  
  628. == 61 CreateUserFlags: migrating ==============================================
  629. -- create_table(:user_flags)
  630. -> 0.0032s
  631. -- add_index(:user_flags, :user_id)
  632. -> 0.0092s
  633. -- add_index(:user_flags, :name)
  634. -> 0.0095s
  635. == 61 CreateUserFlags: migrated (0.0226s) =====================================
  636.  
  637. == 62 AddFlashToUserQuests: migrating =========================================
  638. -- add_column(:user_quests, :flash, :string, {:null=>false, :default=>"initial_flash"})
  639. -> 0.0126s
  640. == 62 AddFlashToUserQuests: migrated (0.0131s) ================================
  641.  
  642. == 63 CreateRooms: migrating ==================================================
  643. -- create_table(:rooms)
  644. -> 0.0994s
  645. == 63 CreateRooms: migrated (0.1001s) =========================================
  646.  
  647. == 64 CreateUserRooms: migrating ==============================================
  648. -- create_table(:user_rooms)
  649. -> 0.0199s
  650. -- add_index(:user_rooms, :user_id)
  651. -> 0.0173s
  652. -- add_index(:user_rooms, :room_id)
  653. -> 0.0197s
  654. -- add_index(:user_rooms, :updated_at)
  655. -> 0.0558s
  656. == 64 CreateUserRooms: migrated (0.1145s) =====================================
  657.  
  658. == 65 CreateChatMessages: migrating ===========================================
  659. -- create_table(:chat_messages)
  660. -> 0.0046s
  661. -- add_index(:chat_messages, :user_room_id)
  662. -> 0.0346s
  663. == 65 CreateChatMessages: migrated (0.0402s) ==================================
  664.  
  665. == 66 AddTimestampsToRooms: migrating =========================================
  666. -- add_column(:rooms, :created_at, :datetime)
  667. -> 0.0344s
  668. -- add_column(:rooms, :updated_at, :datetime)
  669. -> 0.0264s
  670. == 66 AddTimestampsToRooms: migrated (0.0687s) ================================
  671.  
  672. == 67 RemoveUnneededStatTables: migrating =====================================
  673. -- drop_table(:stat_adverts)
  674. -> 0.0029s
  675. -- drop_table(:stat_games)
  676. -> 0.0036s
  677. -- drop_table(:stat_how_spents)
  678. -> 0.0030s
  679. -- drop_table(:stat_users)
  680. -> 0.0020s
  681. == 67 RemoveUnneededStatTables: migrated (0.0323s) ============================
Add Comment
Please, Sign In to add comment