DROP TABLE IF EXISTS `unittestvfsdir`;
CREATE TABLE `unittestvfsdir` (
  `vfsdid` int(11) NOT NULL auto_increment,
  `uid` varchar(255) NOT NULL,
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL default '' ,
  `name` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `changed` datetime NOT NULL,
  PRIMARY KEY  (`vfsdid` ),
  KEY ( `path` ),
  KEY ( `uid` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='store per user folders';

DROP TABLE IF EXISTS `unittestvfsfile`;
CREATE TABLE `unittestvfsfile` (
  `vfsfid` int(11) NOT NULL auto_increment,
  `obscure` varchar(2) NOT NULL,
  `vfsdid` int(11) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `size` int(11) NOT NULL default '0',
  `md5` varchar(32) NOT NULL,
  `storage` varchar(255) NOT NULL,
  `mimemajor` varchar(20) NOT NULL,
  `mimeminor` varchar(20) NOT NULL,
  `views` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `info` BLOB,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `changed` datetime NOT NULL,
  `deleted` tinyint(1) NOT NULL default 0,
  PRIMARY KEY  (`vfsfid`),
  KEY ( `uid` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='media file';

DROP TABLE IF EXISTS `unittestvfsfilequota`;
CREATE TABLE `unittestvfsfilequota` (
  `uid` int(11) NOT NULL,
  `changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `sizemax` int(11) UNSIGNED NOT NULL default '104857600',
  `filemax` int(11) UNSIGNED NOT NULL default '1000',
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='media file per user quota';


LOCK TABLES `unittestvfsdir` WRITE;
/*!40000 ALTER TABLE `unittestvfsdir` DISABLE KEYS */;
INSERT INTO `unittestvfsdir` VALUES (1,'42','++++','first','2009-04-16 10:20:15','2009-04-16 10:20:15'),(2,'42','+++-','second','2009-04-16 10:20:15','2009-04-16 10:20:15'),(3,'42','+++.','same','2009-04-16 10:20:15','2009-04-16 10:20:15'),(4,'42','+++/','same (2)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(5,'42','+++0','same (3)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(6,'42','+++1','same (4)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(7,'42','+++2','inRoot','2009-04-16 10:20:15','2009-04-16 10:20:15'),(8,'42','+++2++++','rename','2009-04-16 10:20:15','2009-04-16 10:20:15'),(9,'42','+++3','inRoot (2)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(10,'42','+++3++++','first','2009-04-16 10:20:15','2009-04-16 10:20:15'),(11,'42','+++3+++-','first (2)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(12,'42','+++3+++-++++','move me','2009-04-16 10:20:15','2009-04-16 10:20:15'),(13,'42','+++4','inRoot (3)','2009-04-16 10:20:15','2009-04-16 10:20:15'),(35,'42','+++5+++++++.','bar3','2009-04-16 10:20:15','2009-04-16 10:20:15'),(34,'42','+++5+++++++-','bar2','2009-04-16 10:20:15','2009-04-16 10:20:15'),(33,'42','+++5++++++++','bar','2009-04-16 10:20:15','2009-04-16 10:20:15'),(32,'42','+++5+++.','foo3','2009-04-16 10:20:15','2009-04-16 10:20:15'),(31,'42','+++5+++-','foo2','2009-04-16 10:20:15','2009-04-16 10:20:15'),(30,'42','+++5++++','foo','2009-04-16 10:20:15','2009-04-16 10:20:15'),(29,'42','+++5','rootfolder','2009-04-16 10:20:15','2009-04-16 10:20:15');
/*!40000 ALTER TABLE `unittestvfsdir` ENABLE KEYS */;
UNLOCK TABLES;

