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 _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
