• Robert Ricci's avatar
    Add duplicate fields from the location_info table into the new_nodes · b6341a4e
    Robert Ricci authored
    table - this will allow us to place them on the map while they are still
    in limbo.
     ALTER TABLE new_nodes ADD COLUMN (floor varchar(32) default NULL,
        building varchar(32) default NULL,
        loc_x int(10) unsigned NOT NULL default '0',
        loc_y int(10) unsigned NOT NULL default '0',
        contact tinytext,
        phone tinytext,
        room varchar(32) default NULL);
database-migrate.txt 64.3 KB