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 
 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(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 new bean id for the 
 new DaoImpl class
 
 I was expecting with the change and a reinstall of my cloudstack-management 
 service (even doing cloudstack-setup-databases again), a new table would be 
 created.  However, this is not happening.
 
 Is there some step I missed?
 
 Thanks,
 KC

--
Dr. Wang, Kuang-Ching, Associate Professor
308 Fluor Daniel Building
ECE Department, Clemson University
Clemson, SC 29634
864-656-0846 (Office)
864-656-7220 (Fax)
kw...@clemson.edu



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 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, 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 
 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(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 new bean id for the 
 new DaoImpl class
 
 I was expecting with the change and a reinstall of my cloudstack-management 
 service (even doing cloudstack-setup-databases again), a new table would be 
 created.  However, this is not happening.
 
 Is there some step I missed?
 
 Thanks,
 KC
 

--
Dr. Wang, Kuang-Ching, Associate Professor
308 Fluor Daniel Building
ECE Department, Clemson University
Clemson, SC 29634
864-656-0846 (Office)
864-656-7220 (Fax)
kw...@clemson.edu