--
-- Host: localhost    Database: faceforensics_benchmark
-- ------------------------------------------------------


--
-- Table structure for table `binary_classification_results`
--

CREATE TABLE `binary_classification_results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_id` int(11) DEFAULT NULL,
  `avg_acc` float DEFAULT NULL,
  `pristine_acc` float DEFAULT NULL,
  `face2face_acc` float DEFAULT NULL,
  `deepfakes_acc` float DEFAULT NULL,
  `faceswap_acc` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `binary_classification_results`
--

INSERT INTO `binary_classification_results` VALUES (2,2,0.718571,0.697143,0.759124,0.754545,0.699029),(3,3,0.725714,0.88,0.321168,0.772727,0.68932),(5,1,0.782857,0.797143,0.715328,0.881818,0.718447),(6,4,0.707143,0.822857,0.489051,0.7,0.61165),(7,5,0.684286,0.614286,0.729927,0.881818,0.650485),(9,6,0.581429,0.325714,0.846715,0.836364,0.825243),(10,7,0.607143,0.708571,0.40146,0.690909,0.446602);

--
-- Table structure for table `maintainers`
--

CREATE TABLE `maintainers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `maintainers`
--


--
-- Table structure for table `submissions`
--

CREATE TABLE `submissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `upload_folder_random` varchar(225) NOT NULL,
  `short_name` varchar(20) NOT NULL,
  `full_name` varchar(80) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `task_type` tinyint(1) NOT NULL,
  `publication_title` varchar(400) NOT NULL,
  `publication_authors` varchar(400) NOT NULL,
  `publication_venue` varchar(200) NOT NULL,
  `publication_url` varchar(200) NOT NULL,
  `languages` varchar(200) NOT NULL,
  `hardware` varchar(200) NOT NULL,
  `website_url` varchar(200) NOT NULL,
  `source_url` varchar(200) NOT NULL,
  `availability` tinyint(1) NOT NULL,
  `anonymous` tinyint(1) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `creation_stamp` bigint(11) NOT NULL,
  `last_upload_number` int(11) NOT NULL,
  `last_upload_stamp` bigint(11) NOT NULL,
  `last_test_set_upload_stamp` bigint(11) NOT NULL,
  `submitted_by_user_id` int(11) NOT NULL,
  `last_change_stamp` bigint(11) NOT NULL,
  `uses_full_image` tinyint(1) NOT NULL,
  `uses_face_detection` tinyint(1) NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `submissions`
--

INSERT INTO `submissions` VALUES (1,'39bce46c7aca6cd0700f2c587fc256fc','Xception','Xception','Xception network, using Dlib as face detection, trained on FaceForensics++ images compressed with h264 with a compression crf of 0, 23 and 40.',1,'FaceForensics++','Andreas Rössler, Davide Cozzolino, Annalisa Verdoliva, Christian Riess, Justus Thies, Matthias Nießner','arxiv','https://arxiv.org/pdf/1901.08971.pdf','Python, Pytorch','GeForce 1080TI','https://www.niessnerlab.org/','https://github.com/ondyari/FaceForensics',3,0,3,1,1552482110,3,1552483841,1552483841,10,1552483834,0,1,'::1'),(2,'e7a650325babf9a22042244a1e18943d','Xception Full c23','Xception Full Image c23','Xception network, trained on full images compressed with h264 with a compression crf of 23',1,'FaceForensics++','Andreas Rössler, Davide Cozzolino, Annalisa Verdoliva, Christian Riess, Justus Thies, Matthias Nießner','arxiv','https://arxiv.org/pdf/1901.08971.pdf','Python, Pytorch','GeForce 1080TI','https://www.niessnerlab.org/','https://github.com/ondyari/FaceForensics',3,0,3,1,1552483244,1,1552483252,1552483252,10,1552483730,1,0,'::1'),(3,'5de1f967c4f3b26bfcf4ef917a46dc04','Expert Human','Expert Human Baseline: Justus Thies','Each benchmark image was shown for 3 seconds and hidden afterwards before the candidate had to make a decision if it is real or fake.',1,'','','','','None','None','','',0,0,3,1,1552483423,1,1552483444,1552483444,10,1552485483,1,0,'131.159.40.106'),(4,'909b428c8624aaacf6f1a9a6d7b3463b','MesoNet c40','MesoNet: a Compact Facial Video Forgery Detection Network','Based on the corresponding paper, trained the same way as the Xception network as outline in the FaceForensics++ paper. Trained on all images compressed with h264 with a crf of 40.\r\n\r\nFace Tracking: dlib',1,'MesoNet: a Compact Facial Video Forgery Detection Network','Darius Afchar, Vincent Nozick, Junichi Yamagishi, Isao Echizen','WIFS 2018','https://arxiv.org/abs/1809.00888','Python, Keras','GeForce 1080ti','','',0,0,3,1,1552484027,1,1552484055,1552484055,10,1552484079,0,1,'::1'),(5,'a5c0fdcff8fe0e02c03d1e02205b00d3','Bayar c23','Bayar c23','Network as in publication used as a classification network on a 128x128 centered crop of a benchmark tracked face. Details see the FaceForensics++ paper.',1,'A deep learning approach to universal image manipulation detection using a new convolutional layer','B. Bayar and M. Stamm','ACM Workshop on Information Hiding and Multimedia Security','https://dl.acm.org/citation.cfm?id=2930786','Python, Keras','GeForce 1080ti','','',0,0,3,1,1552484246,1,1552484264,1552484264,10,1552484246,0,1,'::1'),(6,'a800457c79a4bec3dfc21c958180ebae','Recast c23','Recast c23','Method as in publication, used on a 128x128 centered crop of a tracked face. More details see the FaceForensics++ paper.',1,'Recasting residual-based local descriptors as convolutional neural networks: an application to image forgery detection','D. Cozzolino, G. Poggi, and L. Verdoliva','ACM Workshop on Information Hiding and Multimedia Security,','https://arxiv.org/abs/1703.04615','Python, Keras','GeForce 1080ti','','',0,0,3,1,1552484392,2,1552484751,1552484751,10,1552484392,0,1,'::1'),(7,'55f140391f655d1360a54b7c35a81b89','Rahmouni c40','Rahmouni c40','Network as in paper, evaluated on a 128x128 centered face crop of h264 compressed images with a compression crf of 40.\r\n\r\nFace detection: dlib',1,'Distinguishing computer graphics from natural images using convolution neural networks','N. Rahmouni, V. Nozick, J. Yamagishi, and I. Echizeny','IEEE Workshop on Information Forensics and Security','https://ieeexplore.ieee.org/document/8267647','Python, Keras','GeForce 1080ti','','',0,0,3,1,1552484940,1,1552484959,1552484959,10,1552484940,0,1,'::1');

--
-- Table structure for table `uc_configuration`
--

CREATE TABLE `uc_configuration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `value` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `uc_configuration`
--

INSERT INTO `uc_configuration` VALUES (1,'website_name','FaceForensics Benchmark'),(2,'website_url','http://kaldir.vc.in.tum.de/faceforensics_benchmark'),(3,'email','faceforensics@googlegroups.com'),(4,'activation','false'),(5,'resend_activation_threshold','0'),(6,'language','models/languages/en.php'),(7,'template','models/site-templates/default.css');

--
-- Table structure for table `uc_pages`
--

CREATE TABLE `uc_pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page` varchar(150) NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uc_pages`
--


--
-- Table structure for table `uc_permission_page_matches`
--

CREATE TABLE `uc_permission_page_matches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_id` int(11) NOT NULL,
  `page_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uc_permission_page_matches`
--


--
-- Table structure for table `uc_permissions`
--

CREATE TABLE `uc_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `uc_permissions`
--


--
-- Table structure for table `uc_user_permission_matches`
--

CREATE TABLE `uc_user_permission_matches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `uc_user_permission_matches`
--

INSERT INTO `uc_user_permission_matches` VALUES (16,9,1),(17,10,1);

--
-- Table structure for table `uc_users`
--

CREATE TABLE `uc_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(50) NOT NULL,
  `password` varchar(225) NOT NULL,
  `email` varchar(150) NOT NULL,
  `website` varchar(200) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `newsletter_subscribed` tinyint(1) NOT NULL,
  `activation_token` varchar(225) NOT NULL,
  `last_activation_request` int(11) NOT NULL,
  `lost_password_request` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `title` varchar(150) NOT NULL,
  `sign_up_stamp` bigint(11) NOT NULL,
  `last_sign_in_stamp` bigint(11) NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uc_users`
--

INSERT INTO `uc_users` VALUES (10,'faceforensics','64f7bb82a5e045d2ef161484dc2d5c5f10c61cbc29675c486ae78cbd3d79242e7','andreas.roessler@tum.de','https://www.niessnerlab.org','Andreas','Rössler',0,'38c58047ca353b2580beebe726e092dd',1552480510,0,1,'New Member',1552480510,1552485448,'::1');


