• 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);
    b6341a4e
database-create.sql 55.2 KB