---------- Forwarded message ----------
From: chinna obireddy <chinna...@gmail.com>
Date: Thu, Nov 22, 2012 at 8:53 PM
Subject: Re: [opennms-discuss] Restructure one of the database table
To: General OpenNMS Discussion <opennms-disc...@lists.sourceforge.net>
Hi Nicolas,
Thanks for the reply. Main question is when the upgrade happens the
database is migrated using liquibase java API. The table is created using
the liquibase changeSet method.
So where exactly should I write the code whether in the "migrator.java" or
in the change set XML or somewhere else ??
Thank you,
Reddy.
On Thu, Nov 22, 2012 at 8:35 PM, VEYSSIERE Nicolas <
nicolas.veyssi...@thalesgroup.com> wrote:
> UPDATE WPA2PSKSEC_T SET WPATYPE = 1 WHERE TYPENAME = ‘WPA-PSK’;****
>
> UPDATE WPA2PSKSEC_T SET WPATYPE = 2 WHERE TYPENAME = ‘WPA2-PSK’;****
>
> ** **
>
> *De :* chinna obireddy [mailto:chinna...@gmail.com]
> *Envoyé :* jeudi 22 novembre 2012 13:33
> *À :* opennms-disc...@lists.sourceforge.net
> *Objet :* [opennms-discuss] Restructure one of the database table****
>
> ** **
>
> Hello All, ****
>
> ** **
>
> I am a newbie started working on opennms from a week.****
>
> ** **
>
> I wanted to restructure the table opennms database during migration of
> database. This table is a custom table created and there is data in it and
> it must be remapped to the modified table.****
>
> ** **
>
> e.g:****
>
> ** **
>
> table wpa2psksec_t: with data ****
>
> ** **
>
> serial;secret;cipher;typename ****
>
> 1;"123456789";"AES";1;"WPA2-PSK"****
>
> 2;"tt158btc";"AES";1;"WPA-PSK"****
>
> 3;"HAHAHAHAHAHA";"AES";3;"WPA2-PSK"****
>
> ** **
>
> I have to restructure it to introducing wpa type integer column with
> corresponding value to it.****
>
> ** **
>
> serial;secret;cipher;typename,wpatype****
>
> 1;"123456789";"AES";1;"WPA2-PSK";2****
>
> 2;"tt158btc";"AES";1;"WPA2-PSK";1****
>
> 3;"HAHAHAHAHAHA";"AES";3;"WPA2-PSK";2****
>
> ** **
>
> How can I achieve this ??****
>
> ** **
>
> Regards,****
>
> Reddy.****
>
>
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
>
> opennms-discuss mailing list
>
> To *unsubscribe* or change your subscription options, see the bottom of
> this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-discuss
>
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ
opennms-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
