<div dir="ltr">Hi Peeyush,<div><br></div><div>My approach is to create a file with successive number in dir "\nova\db\sqlalchemy\migrate_repo\versions\" , and realize it according to my needs.</div><div>And later, execute "nova-manage db sync", the new table will be available.<br>
</div><div><br></div><div>Please take it as your reference~</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Sep 2, 2013 at 5:01 PM, Peeyush Gupta <span dir="ltr"><<a href="mailto:gpeeyush@ymail.com" target="_blank">gpeeyush@ymail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><div><br></div><div style="font-family:'times new roman','new york',times,serif;font-size:12pt">
<div style="font-family:'times new roman','new york',times,serif;font-size:12pt"><div><div><div><div style="font-size:12pt;font-family:'times new roman','new york',times,serif"><div><span>Hi,</span></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><span><br></span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
<span>I have been trying to add a new column to compute_nodes
 table.</span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><span>I understand the table is defined at <a href="http://db.sqlalchemy.models.py" target="_blank">db.sqlalchemy.models.py</a>. So,</span></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><span>I added a new field in the file and restarted the nova-compute process.</span></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><span>But, there is no change in the table. What am I doing wrong? Where </span></div>
<div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><span>should I make changes to add the
 column?</span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
<span>P.S: I am using devstack on Ubuntu 12.04
 LTS</span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:'times new roman','new york',times,serif">
<span>Thanks,<span class="HOEnZb"><font color="#888888"><span style="white-space:pre-wrap">       </span></font></span></span></div><span class="HOEnZb"><font color="#888888"><div></div><div> </div><div><font color="#9E8FA9">~Peeyush Gupta</font></div>
</font></span></div></div></div><br><br></div> </div> </div>  </div></div><br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to     : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div><br></div>