--
-- Host: localhost    Database: scanrefer_benchmark
-- ------------------------------------------------------


--
-- Table structure for table `localization_results`
--

CREATE TABLE `localization_results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_id` int(11) DEFAULT NULL,
  `unique_acc_0_25IoU` float DEFAULT NULL,
  `unique_acc_0_5IoU` float DEFAULT NULL,
  `multiple_acc_0_25IoU` float DEFAULT NULL,
  `multiple_acc_0_5IoU` float DEFAULT NULL,
  `overall_acc_0_25IoU` float DEFAULT NULL,
  `overall_acc_0_5IoU` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `localization_results`
--

INSERT INTO `localization_results` VALUES (0,0,0.6290,0.4031,0.3088,0.1654,0.3806,0.2187);

--
-- 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_xyz` tinyint(1) NOT NULL,
  `uses_rgb` tinyint(1) NOT NULL,
  `uses_multiview` tinyint(1) NOT NULL,
  `uses_normal` 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`
--

-- LOCK TABLES `submissions` WRITE;
-- /*!40000 ALTER TABLE `submissions` DISABLE KEYS */;
-- INSERT INTO `submissions` VALUES (8,'eaa4d58c4515c78dd1c00d662e3ac894','ScanRefer','VoteNet + GRU (end-to-end)','VoteNet + GRU-based localization module trained in end-to-end fashine on ScanRefer dataset.',1,'ScanRefer: 3D Object Localization in RGB-D Scans using Natural Language','Dave Zhenyu Chen, Angel X. Chang, Matthias Niessner','16th European Conference on Computer Vision (ECCV), 2020','https://arxiv.org/pdf/1912.08830','Python, Pytorch','GeForce 2080Ti','https://daveredrum.github.io/ScanRefer/','https://github.com/daveredrum/ScanRefer',3,0,3,1,1596011547,1,1596011551,1596011551,0,1596011547,1,0,1,1,'131.159.40.127');
-- /*!40000 ALTER TABLE `submissions` ENABLE KEYS */;
-- UNLOCK TABLES;

--
-- 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','ScanRefer Benchmark'),(2,'website_url','kaldir.vc.in.tum.de/scanrefer_benchmark'),(3,'email','noreplyscanrefer@gmail.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 (0,'scanrefer','0fae6d75a438bfd2876e635bc8f8c026bd4f996d996fec94d129dad3e11b159c7','zhenyu.chen@tum.de','https://www.niessnerlab.org/members/zhenyu_chen/profile.html','Dave Zhenyu','Chen',0,'38c58047ca353b2580beebe726e092dd',1552480510,0,1,'New Member',1552480510,1552485448,'::1');


