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, -N

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. Simila

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 wrote: > You need to add you create table entries in schema-440to441.sql. > > If you do not want to redeploy (without u

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 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 >> wrote: >> >> Hi, >> >> I need to cr

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, Abhina

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 n

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 > 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 @Entity and @Table(na

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