Re: how to add new data table to DB

2014-10-08 Thread Kuang-Ching Wang
Thanks Mike, I added the table successfully. And also thanks for the suggestion. I spent some time looking into what we need - we need to store some topology/tenant mapping info specific to our plugin for syncing purpose. Logically it really needs to be maintained in a separate table.

Re: how to add new data table to DB

2014-10-08 Thread Nitin Mehta
I kind of agree with Mike. We shouldn¹t really be adding tables with plugins. If there is a need to do so then its a limitation with our plugin framework and should be enhanced accordingly. It would good if you could specify your use case and why it can't be fitted with existing schema. Thanks,

Re: how to add new data table to DB

2014-09-29 Thread Kuangching Wang
By convention, which file should I add to? create-database.sql? KC On Sep 28, 2014, at 9:07 PM, Abhinandan Prateek agneya2...@gmail.com wrote: You still need to write Sql for creating new db table in MySQL db. -abhi On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang kuangching.w...@gmail.com

Re: how to add new data table to DB

2014-09-29 Thread Kuangching Wang
Why 440to441? What’s the convention to choose which .sql file to add to? I am working against master, which is 4.5.0. KC On Sep 28, 2014, at 9:25 PM, Jayapal Reddy Uradi jayapalreddy.ur...@citrix.com wrote: You need to add you create table entries in schema-440to441.sql. If you do not

how to add new data table to DB

2014-09-28 Thread Kuang-Ching Wang
Hi, I need to create a new table to store data in the cloudstack DB. I followed existing examples to: - add a new VO class, with @Entity and @Table(name = “new_table_name) - add a new Dao interface - add a new DaoImpl class for the interface - update spring context (of my network plugin) with a

Re: how to add new data table to DB

2014-09-28 Thread Abhinandan Prateek
You still need to write Sql for creating new db table in MySQL db. -abhi On 29-Sep-2014, at 6:41 am, Kuang-Ching Wang kuangching.w...@gmail.com wrote: Hi, I need to create a new table to store data in the cloudstack DB. I followed existing examples to: - add a new VO class, with

Re: how to add new data table to DB

2014-09-28 Thread Mike Tutkowski
Assuming you are doing this for version 4.5, please take a look at adding your table to this file: schema-441to450.sql By the way, do we really need to add a new table for this plug-in or is there some *_details table (ex. storage_pool_details) where you can store information specific to your

Re: how to add new data table to DB

2014-09-28 Thread Jayapal Reddy Uradi
You need to add you create table entries in schema-440to441.sql. If you do not want to redeploy (without using cloudstack-setup-databases) you can go to mysql prompt, use cloud db and create table. After creating table restart the MS will work. Thanks, Jayapal On 29-Sep-2014, at 9:37 AM,