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 `unittestvfsfile` WRITE;
/*!40000 ALTER TABLE `unittestvfsfile` DISABLE KEYS */;
INSERT INTO `unittestvfsfile` VALUES (1,'ml',0,'42',741158,'d97455178e5da45a0547a1ec93366665','testfile01','video','x-flv',0,'boarder2-320x180-356k.flv','','a:7:{s:9:\"container\";s:3:\"flv\";s:8:\"duration\";s:11:\"00:00:00.00\";s:7:\"seconds\";d:0;s:7:\"bitrate\";s:2:\"56\";s:5:\"width\";s:3:\"320\";s:6:\"height\";s:3:\"180\";s:7:\"streams\";a:2:{i:0;a:5:{s:4:\"name\";s:11:\"Stream #0.0\";s:4:\"type\";s:5:\"video\";s:5:\"codec\";s:3:\"flv\";s:4:\"size\";s:7:\"320x180\";s:3:\"fps\";s:5:\"25.00\";}i:1;a:6:{s:4:\"name\";s:11:\"Stream #0.1\";s:4:\"type\";s:5:\"audio\";s:5:\"codec\";s:3:\"mp3\";s:12:\"samplingrate\";s:5:\"44100\";s:7:\"channel\";s:6:\"stereo\";s:7:\"bitrate\";s:2:\"56\";}}}','2009-04-16 11:27:25','2009-04-16 11:27:25',0),(2,'fg',0,'42',10306792,'5055bb5fcb3c7b55054a87c58dbd91d8','testfile01','application','pdf',0,'manual-en.pdf','','a:0:{}','2009-04-16 11:27:26','2009-04-16 11:27:26',0),(3,'Ze',0,'42',623718,'791602632402a107e7ede0f06d23f733','testfile01','image','jpeg',0,'baerBlind.jpg','','a:3:{s:5:\"width\";i:1536;s:6:\"height\";i:2048;s:4:\"exif\";a:1:{s:13:\"SectionsFound\";s:0:\"\";}}','2009-04-16 11:27:27','2009-04-16 11:27:27',0),(4,'k7',0,'42',1521702,'b22d146d69a19b8f9e41003c95c9da90','testfile01','video','mp4',0,'boarder1-640x360-864k.mp4','','a:7:{s:9:\"container\";N;s:8:\"duration\";N;s:7:\"seconds\";i:0;s:7:\"bitrate\";N;s:5:\"width\";s:0:\"\";s:6:\"height\";s:0:\"\";s:7:\"streams\";a:0:{}}','2009-04-16 11:27:27','2009-04-16 11:27:27',0),(5,'Lc',0,'42',1830081,'f9a310c77e17ff2a4ccd911376951673','testfile01','image','jpeg',0,'frogstonea.jpg','','a:3:{s:5:\"width\";i:2048;s:6:\"height\";i:3088;s:4:\"exif\";a:1:{s:13:\"SectionsFound\";s:0:\"\";}}','2009-04-16 11:27:28','2009-04-16 11:27:28',0),(6,'Dm',0,'42',25,'40d4b6502d862f0b639fc8249e8e58cc','testfile01','text','plain',0,'README.txt','','a:0:{}','2009-04-16 11:27:28','2009-04-16 11:27:28',0),(7,'pN',0,'42',720302,'606232148fd766ea91b36e34e36726a5','testfile01','video','x-ms-asf',0,'snowboardjump10.wmv','','a:7:{s:9:\"container\";s:3:\"asf\";s:8:\"duration\";s:11:\"00:00:16.79\";s:7:\"seconds\";d:16.78999999999999914734871708787977695465087890625;s:7:\"bitrate\";s:3:\"343\";s:5:\"width\";s:3:\"320\";s:6:\"height\";s:3:\"240\";s:7:\"streams\";a:2:{i:0;a:6:{s:4:\"name\";s:11:\"Stream #0.0\";s:4:\"type\";s:5:\"audio\";s:5:\"codec\";s:5:\"wmav2\";s:12:\"samplingrate\";s:5:\"32000\";s:7:\"channel\";s:6:\"stereo\";s:7:\"bitrate\";s:2:\"48\";}i:1;a:5:{s:4:\"name\";s:11:\"Stream #0.1\";s:4:\"type\";s:5:\"video\";s:5:\"codec\";s:4:\"wmv2\";s:4:\"size\";s:7:\"320x240\";s:3:\"fps\";s:3:\"302\";}}}','2009-04-16 11:27:28','2009-04-16 11:27:28',0),(8,'I3',0,'42',1220745,'2e4dc150124f659aac5cbce05238a64c','testfile01','image','jpeg',0,'ssl10393.jpg','','a:3:{s:5:\"width\";i:2592;s:6:\"height\";i:1944;s:4:\"exif\";a:50:{s:13:\"SectionsFound\";s:39:\"ANY_TAG, IFD0, THUMBNAIL, EXIF, INTEROP\";s:16:\"ImageDescription\";s:24:\"<Digimax i5, Samsung #1>\";s:4:\"Make\";s:15:\"Samsung Techwin\";s:5:\"Model\";s:24:\"<Digimax i5, Samsung #1>\";s:11:\"Orientation\";i:1;s:11:\"XResolution\";s:5:\"288/3\";s:11:\"YResolution\";s:5:\"288/3\";s:14:\"ResolutionUnit\";i:2;s:8:\"Software\";s:6:\"510062\";s:8:\"DateTime\";s:19:\"2007:12:22 18:17:05\";s:16:\"YCbCrPositioning\";i:2;s:9:\"Copyright\";s:15:\"COPYRIGHT, 2005\";s:16:\"Exif_IFD_Pointer\";i:286;s:9:\"THUMBNAIL\";a:7:{s:11:\"Compression\";i:6;s:11:\"Orientation\";i:1;s:11:\"XResolution\";s:3:\"1/1\";s:11:\"YResolution\";s:3:\"1/1\";s:14:\"ResolutionUnit\";i:2;s:21:\"JPEGInterchangeFormat\";i:41942;s:27:\"JPEGInterchangeFormatLength\";i:8227;}s:12:\"ExposureTime\";s:4:\"1/45\";s:7:\"FNumber\";s:5:\"35/10\";s:15:\"ExposureProgram\";i:2;s:15:\"ISOSpeedRatings\";i:100;s:11:\"ExifVersion\";s:4:\"0220\";s:16:\"DateTimeOriginal\";s:19:\"2007:12:22 18:17:05\";s:17:\"DateTimeDigitized\";s:19:\"2007:12:22 18:17:05\";s:23:\"ComponentsConfiguration\";s:4:\"\0\";s:22:\"CompressedBitsPerPixel\";s:16:\"10135120/5038848\";s:17:\"ShutterSpeedValue\";s:6:\"176/32\";s:13:\"ApertureValue\";s:6:\"116/32\";s:17:\"ExposureBiasValue\";s:4:\"0/10\";s:16:\"MaxApertureValue\";s:6:\"116/32\";s:12:\"MeteringMode\";i:5;s:11:\"LightSource\";i:0;s:5:\"Flash\";i:89;s:11:\"FocalLength\";s:5:\"66/10\";s:15:\"FlashPixVersion\";s:4:\"0100\";s:10:\"ColorSpace\";i:1;s:14:\"ExifImageWidth\";i:2592;s:15:\"ExifImageLength\";i:1944;s:16:\"RelatedSoundFile\";s:12:\"RelatedSound\";s:22:\"InteroperabilityOffset\";i:41806;s:13:\"ExposureIndex\";s:3:\"1/1\";s:13:\"SensingMethod\";i:2;s:10:\"FileSource\";s:1:\"\";s:9:\"SceneType\";s:1:\"\";s:12:\"ExposureMode\";i:0;s:12:\"WhiteBalance\";i:0;s:16:\"DigitalZoomRatio\";s:4:\"0/10\";s:21:\"FocalLengthIn35mmFilm\";i:39;s:16:\"SceneCaptureType\";i:0;s:10:\"Saturation\";i:0;s:9:\"Sharpness\";i:0;s:21:\"InterOperabilityIndex\";s:3:\"R98\";s:23:\"InterOperabilityVersion\";s:4:\"0100\";}}','2009-04-16 11:27:29','2009-04-16 11:27:29',0),(9,'ys',0,'42',272401,'96d6781a4b17a4a2a0e9d6de506debef','testfile01','image','jpeg',0,'fuertabruta0279.jpg','','a:3:{s:5:\"width\";i:960;s:6:\"height\";i:1280;s:4:\"exif\";a:48:{s:13:\"SectionsFound\";s:39:\"ANY_TAG, IFD0, THUMBNAIL, EXIF, INTEROP\";s:4:\"Make\";s:9:\"Panasonic\";s:5:\"Model\";s:8:\"DMC-FZ30\";s:11:\"Orientation\";i:1;s:11:\"XResolution\";s:4:\"72/1\";s:11:\"YResolution\";s:4:\"72/1\";s:14:\"ResolutionUnit\";i:2;s:8:\"Software\";s:27:\"ACD Systems Digital Imaging\";s:8:\"DateTime\";s:19:\"2007:09:17 10:57:35\";s:16:\"YCbCrPositioning\";i:1;s:16:\"Exif_IFD_Pointer\";i:217;s:9:\"THUMBNAIL\";a:3:{s:11:\"Compression\";i:6;s:21:\"JPEGInterchangeFormat\";i:6533;s:27:\"JPEGInterchangeFormatLength\";i:6543;}s:12:\"ExposureTime\";s:6:\"10/300\";s:7:\"FNumber\";s:5:\"32/10\";s:15:\"ExposureProgram\";i:2;s:15:\"ISOSpeedRatings\";i:100;s:11:\"ExifVersion\";s:4:\"0220\";s:16:\"DateTimeOriginal\";s:19:\"2007:09:15 18:11:39\";s:17:\"DateTimeDigitized\";s:19:\"2007:09:15 18:11:39\";s:23:\"ComponentsConfiguration\";s:4:\"\0\";s:22:\"CompressedBitsPerPixel\";s:3:\"2/1\";s:17:\"ExposureBiasValue\";s:5:\"0/100\";s:16:\"MaxApertureValue\";s:5:\"30/10\";s:12:\"MeteringMode\";i:5;s:11:\"LightSource\";i:4;s:5:\"Flash\";i:25;s:11:\"FocalLength\";s:6:\"158/10\";s:10:\"SubSecTime\";s:3:\"796\";s:15:\"FlashPixVersion\";s:4:\"0100\";s:10:\"ColorSpace\";i:1;s:14:\"ExifImageWidth\";i:960;s:15:\"ExifImageLength\";i:1280;s:22:\"InteroperabilityOffset\";i:6453;s:13:\"SensingMethod\";i:2;s:10:\"FileSource\";s:1:\"\";s:9:\"SceneType\";s:1:\"\";s:14:\"CustomRendered\";i:0;s:12:\"ExposureMode\";i:0;s:12:\"WhiteBalance\";i:0;s:16:\"DigitalZoomRatio\";s:4:\"0/10\";s:21:\"FocalLengthIn35mmFilm\";i:95;s:16:\"SceneCaptureType\";i:0;s:11:\"GainControl\";i:0;s:8:\"Contrast\";i:0;s:10:\"Saturation\";i:0;s:9:\"Sharpness\";i:0;s:21:\"InterOperabilityIndex\";s:3:\"R98\";s:23:\"InterOperabilityVersion\";s:4:\"0100\";}}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(10,'uI',0,'42',639432,'72c8c61c169c53daf48db433259dc34f','testfile01','video','x-flv',0,'boarder1-320x180-356k.flv','','a:7:{s:9:\"container\";s:3:\"flv\";s:8:\"duration\";s:11:\"00:00:00.00\";s:7:\"seconds\";d:0;s:7:\"bitrate\";s:2:\"56\";s:5:\"width\";s:3:\"320\";s:6:\"height\";s:3:\"180\";s:7:\"streams\";a:2:{i:0;a:5:{s:4:\"name\";s:11:\"Stream #0.0\";s:4:\"type\";s:5:\"video\";s:5:\"codec\";s:3:\"flv\";s:4:\"size\";s:7:\"320x180\";s:3:\"fps\";s:5:\"25.00\";}i:1;a:6:{s:4:\"name\";s:11:\"Stream #0.1\";s:4:\"type\";s:5:\"audio\";s:5:\"codec\";s:3:\"mp3\";s:12:\"samplingrate\";s:5:\"44100\";s:7:\"channel\";s:6:\"stereo\";s:7:\"bitrate\";s:2:\"56\";}}}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(11,'0V',0,'42',14267480,'dd39d991346f146f2f9d85b1c56b522b','testfile01','video','x-msvideo',0,'aasc.avi','','a:7:{s:9:\"container\";s:3:\"avi\";s:8:\"duration\";s:11:\"00:00:04.52\";s:7:\"seconds\";d:4.519999999999999573674358543939888477325439453125;s:7:\"bitrate\";s:5:\"25252\";s:5:\"width\";s:3:\"320\";s:6:\"height\";s:3:\"175\";s:7:\"streams\";a:1:{i:0;a:5:{s:4:\"name\";s:11:\"Stream #0.0\";s:4:\"type\";s:5:\"video\";s:5:\"codec\";s:4:\"aasc\";s:4:\"size\";s:7:\"320x175\";s:3:\"fps\";s:5:\"25.00\";}}}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(12,'Sn',0,'42',54,'93387cebd15a8ab997bb6486982d5385','testfile01','application','x-gzip',0,'text.txt.gz','','a:0:{}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(13,'mx',0,'42',67,'57ab39abf367562dff3ac2481da3149d','testfile01','application','x-bzip2',0,'text.txt.bz2','','a:0:{}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(14,'Ww',0,'42',11939692,'a8abca999ecb6e64684253d3d6d1a6cc','testfile01','application','octet-stream',0,'boarder2-720p.m2t','','a:0:{}','2009-04-16 11:27:30','2009-04-16 11:27:30',0),(15,'Fs',0,'42',16097280,'2b4a69d15a6e742b1ea9803d094bf2e7','testfile01','application','octet-stream',0,'aitd-29.4xm','','a:0:{}','2009-04-16 11:27:30','2009-04-16 11:27:30',0);
/*!40000 ALTER TABLE `unittestvfsfile` ENABLE KEYS */;
UNLOCK TABLES;
UPDATE unittestvfsfile SET uid = 77 WHERE vfsfid IN (10,11,12,13,14,15);

