[00:17:10] [[Tech]]; Matma Rex; /* Sorting */ +; https://meta.wikimedia.org/w/index.php?diff=17564496&oldid=17561203&rcid=11090188 [02:40:53] [[Tech]]; Surprizi; /* Sorting */; https://meta.wikimedia.org/w/index.php?diff=17564700&oldid=17564496&rcid=11090520 [10:37:02] Niharika: [10:37:16] How can I change the schema of a table? [10:37:41] Hi Neha16. Is this question for scholarships? [10:37:54] No, for grants app. [10:39:41] Neha16: Okay, same process for both. Add a migration file to make the change (plenty of examples in db/migrations) and update the schema.mysql. [10:40:01] Then apply the migration to your local db. Are you using vagrant? [10:40:29] Niharika: Is there a command for applying migrations? Yes, I am using vagrant. [10:41:29] Neha16: Do you know how to access the database? [10:42:29] Niharika: No, I don't know how to do that in vagrant. Are there any resources I can use? [10:42:46] Neha16: Yeah, gimme a second while I pull up my vagrant. [10:42:56] Niharika: Ok [10:44:16] Neha16: You can access the database for grants app using `mysql --database=iegreview` [10:44:31] For scholarships it's `mysql --database=scholarships` [10:45:10] Once there you can give the command `source /path/to/migration.sql` to apply the migration [10:46:43] Niharika: I did try these commands but I kept getting error 'unknown database iegerview'. [10:47:07] Neha16: Did you spell iegreview correctly? [10:47:46] Niharika: Yes. I did. [10:55:18] Neha16: Can you try with scholarships? [10:55:34] Niharika: Ok let me try. [10:55:40] Neha16: Did you ssh into vagrant? [11:10:46] Niharika: I am able to do changes for scholarships but not for iegreview. [11:11:38] Neha16: Did you ssh in to vagrant? [11:12:25] Niharika: I have just used vagrant up and vagrant provisions. not sure if vagrant up does ssh. [11:12:55] Neha16: It doesn't. You need to do `vagrant ssh` to enter the virtual machine cli. [11:13:23] Don't hesitate to ask. :) [11:13:49] Once you do that, you're inside the VM! Navigate to /vagrant/src/iegreview [11:16:05] From there, you can access the database. [11:20:42] Niharika: Oh, Now I understood what I was doing wrong. Thanks a lot:) [11:21:27] Neha16: You're welcome. :)