

DROP TABLE IF EXISTS `unittesttree`;
CREATE TABLE `unittesttree` (
  `treeid` int(11) NOT NULL auto_increment,
  `branch` varchar(255) NOT NULL default '',
  `payload` varchar(255) NOT NULL default 'anything',
  PRIMARY KEY  (`treeid`),
  KEY ( `branch` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='table to test tree';

DROP TABLE IF EXISTS `unittesttreecs`;
CREATE TABLE `unittesttreecs` (
  `treecsid` int(11) NOT NULL auto_increment,
  `branch` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '' ,
  `payload` varchar(255) NOT NULL default 'anything',
  PRIMARY KEY  (`treecsid`),
  KEY ( `branch` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='table to test tree case sensitive';


DROP TABLE IF EXISTS `unittesttreex`;
CREATE TABLE `unittesttreex` (
  `treexid` int(11) NOT NULL auto_increment,
  `branch` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '' ,
  `payload` varchar(255) NOT NULL default 'anything',
  `xid` varchar(255) NOT NULL,
  PRIMARY KEY  (`treexid`, `xid`),
  KEY ( `branch` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='table to test tree case sensitive with combined primary key';
