-- --------------------------------------------------------------------------------
-- _0001_node_isRoot
-- --------------------------------------------------------------------------------


alter table nodeT add isRoot enum('n', 'y') not null default 'n' after name;
alter table nodeT add index `isroot_idx` (`isRoot` asc);

/* run once when initializing

    update nodeT n set
        n.isRoot = 'y'
    where n.forceSingleNode = 'y';
    
    drop view if exists nodeRootV;
    
*/