---------- Forwarded message ----------
From: chinna obireddy <chinna...@gmail.com>
Date: Thu, Nov 22, 2012 at 8:32 PM
Subject: Restructure one of the database table
To: opennms-disc...@lists.sourceforge.net
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-devel mailing list
To *unsubscribe* or change your subscription options, see the bottom of this
page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel
