/* SQLyog Community Edition- MySQL GUI v7.11 MySQL - 5.0.51a : Database - mcmetro_met ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*Table structure for table `filter_xref` */ DROP TABLE IF EXISTS `filter_xref`; CREATE TABLE `filter_xref` ( `id` int(11) NOT NULL auto_increment, `lft` int(10) unsigned NOT NULL default '0', `rgt` int(10) unsigned NOT NULL default '0', `depth` smallint(5) unsigned NOT NULL default '0', `name` varchar(64) NOT NULL, `quicklink` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `depthindex` (`depth`), KEY `RightCount` (`rgt`), KEY `LeftCount` (`lft`) ) ENGINE=MyISAM AUTO_INCREMENT=126 DEFAULT CHARSET=latin1; /*Data for the table `filter_xref` */ insert into `filter_xref`(`id`,`lft`,`rgt`,`depth`,`name`,`quicklink`) values (1,1,22,0,'TopParent',0),(109,4294967295,4294967295,2,'b132154',0); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;