[Devel] [Users] eta for v1.2.0 - March 12

[Juha Heinanen]

Daniel-Constantin Mierla writes:

 > If you have good DB (mysql/postgres) skills and want to help, just say 
 > it, it is enough work around :-) . Some tables changed the structure of 
 > the fields (like LCR with the IP address), and a bit more advanced 
 > migration mechanism should be in place.

daniel,

the following mysql commands can be used to update gw table:

  ALTER TABLE gw ADD address varchar(15) NOT NULL
  UPDATE gw SET address = INET_NTOA(((ip_addr & 0x000000ff) << 24) + ((ip_addr & 0x0000ff00) << 8) + ((ip_addr & 0x00ff0000) >> 8) + ((ip_addr & 0xff000000) >> 24))
  ALTER TABLE gw DROP ip_addr
  ALTER TABLE gw ADD ip_addr varchar(15) NOT NULL
  UPDATE gw SET ip_addr = address

-- juha