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


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

CREATE TABLE `localization_results` (
  `id` int NOT NULL AUTO_INCREMENT,
  `submission_id` int 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=40 DEFAULT CHARSET=latin1;

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

INSERT INTO `localization_results` VALUES (14,8,0.685903,0.435284,0.348821,0.209674,0.424399,0.260259),(17,12,0.66859,0.551525,0.330712,0.253514,0.406469,0.320333),(20,15,0.68343,0.589448,0.331189,0.252561,0.410166,0.328096),(21,16,0.624073,0.533388,0.281868,0.213009,0.358595,0.284843),(26,19,0.642209,0.419621,0.30903,0.183226,0.383734,0.236229),(28,20,0.727123,0.62737,0.318799,0.246605,0.410351,0.331978),(30,17,0.74526,0.637263,0.348821,0.268525,0.437708,0.351201),(32,21,0.753504,0.641385,0.345723,0.265666,0.437153,0.349908),(33,22,0.752679,0.636439,0.351442,0.271146,0.441405,0.35305),(34,23,0.768343,0.651278,0.349297,0.269478,0.443253,0.355083),(35,24,0.752679,0.643034,0.346676,0.270193,0.437708,0.353789),(36,13,0.747733,0.639736,0.340958,0.266619,0.432163,0.350277),(37,14,0.752679,0.644683,0.33929,0.258518,0.431978,0.345102),(38,18,0.752679,0.644683,0.33929,0.258518,0.431978,0.345102),(39,25,0.752679,0.644683,0.33929,0.258518,0.431978,0.345102);

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

CREATE TABLE `maintainers` (
  `id` int 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 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 NOT NULL,
  `last_upload_number` int NOT NULL,
  `last_upload_stamp` bigint NOT NULL,
  `last_test_set_upload_stamp` bigint NOT NULL,
  `submitted_by_user_id` int NOT NULL,
  `last_change_stamp` bigint 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=26 DEFAULT CHARSET=latin1;

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

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 Nießner','16th European Conference on Computer Vision (ECCV), 2020','https://arxiv.org/pdf/1912.08830','Python','GeForce 2080Ti','https://daveredrum.github.io/ScanRefer/','https://daveredrum.github.io/ScanRefer/',3,0,3,1,1596011547,2,1597237185,1597237185,0,1596011547,1,0,1,1,'131.159.40.127'),(12,'4d16d11a57e70271ce970aabbad95de7','gcn','gcn','',1,'','','','','Python','nvidia 1080ti','','',0,1,3,0,1598457717,1,1598458648,1598458648,11,1600240433,1,1,0,0,'140.109.19.241'),(13,'587a6dd7140a6191903bd61bc39eb1e1','3d only 35.03','test1','',1,'','','','','Python','GTX2080Ti','','',0,0,4,0,1598512275,4,1607677270,1607677270,12,1607677665,1,1,0,0,'103.116.47.197'),(14,'d2f2538c9aeb3a9d3078ca4840702d69','test2','test2','',1,'','','','','Python','GTX2080Ti','','',0,0,4,0,1598590186,4,1608007051,1608007051,12,1598590186,1,1,0,1,'103.116.47.196'),(15,'be724681ef3ed1ac66492bb560b0301b','TGNN','Text guided graph neural network','',1,'','','','','Python','nvidia 1080ti','','',0,1,3,0,1599458838,1,1599458859,1599458859,11,1600240478,1,1,0,0,'140.109.19.241'),(16,'fb9b74ae050f6552bf40c2a9b0815305','gcn_gru','gcn with gru','',1,'','','','','Python','nvidia 1080ti','','',0,1,3,0,1599462697,1,1599462714,1599462714,11,1599462697,1,1,0,0,'140.109.19.241'),(17,'9c122080d98b88e592cf8afb99e68338','test_35.12','test3','',1,'','','','','Python','GTX2080Ti','','',0,0,4,0,1601275473,2,1605440998,1605440998,12,1605443601,1,1,1,1,'103.116.47.57'),(18,'e16f33708fd51ad017255f9958579a3b','test4','test4','',1,'','','','','Python','GTX2080Ti','','',0,0,4,0,1601294838,3,1608007183,1608007183,12,1601294838,1,1,0,1,'103.116.47.196'),(19,'5314413d23243e9c668cbe4117922aa2','ScanRefer Baseline','ScanRefer Baseline','',1,'','','','','python','tesla 1080T','','',0,1,4,0,1604380328,1,1604381238,1604381238,14,1604380328,1,1,0,0,'124.126.230.100'),(20,'387b04bc976708b74edc5ae1e36b47dd','test5','test5','',1,'','','','','Python','GTX2080Ti','','',0,0,4,0,1604565549,1,1604565584,1604565584,12,1604565549,1,1,0,1,'58.250.174.73'),(21,'86ae32db8750c2de0bbcffced4e9be0a','test6','test6','',1,'','','','','Python','V100','','',0,0,4,0,1605580858,1,1605580878,1605580878,12,1605580858,1,1,1,1,'103.116.47.57'),(22,'c69455e8418cd13c6670e8b3ce97594a','test_35.31','test7','',1,'','','','','Python','V100','','',0,0,4,0,1605593802,1,1605593837,1605593837,12,1605594103,1,1,1,1,'103.116.47.57'),(23,'89113b8053f08b65bc664157a21836fa','test12_35.51','test7','',1,'','','','','Python','V100','','',0,0,4,0,1605686587,1,1605686598,1605686598,12,1605686694,1,1,1,1,'103.116.47.57'),(24,'21a34c8e725b40c75f03a036931a2601','test7','test7','',1,'','','','','Python','V100','','',0,0,4,0,1605698890,1,1605698903,1605698903,12,1605698890,1,1,1,1,'103.116.47.57'),(25,'ebfd6400fe3e325fb16b7035dbaa0661','test1','test1','',1,'','','','','Python','V100','','',0,0,4,0,1608007435,1,1608007444,1608007444,12,1608007435,1,1,1,1,'103.116.47.196');

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

CREATE TABLE `uc_configuration` (
  `id` int 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 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 NOT NULL AUTO_INCREMENT,
  `permission_id` int NOT NULL,
  `page_id` int 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 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 NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

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

INSERT INTO `uc_user_permission_matches` VALUES (16,9,1),(17,10,1),(18,11,1),(19,12,1),(20,13,1),(21,14,1);

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

CREATE TABLE `uc_users` (
  `id` int 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 NOT NULL,
  `lost_password_request` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `title` varchar(150) NOT NULL,
  `sign_up_stamp` bigint NOT NULL,
  `last_sign_in_stamp` bigint NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 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,1612535070,'::1'),(11,'haohao','5a5f8f32593d8e6df82f4c51223574e3f7abb15fbdf60a32163b060b0562b54fc','godhuang12345678@iis.sinica.edu.tw','','Pin-Hao','Huang',0,'2c7ccf3fb6bf0daaceca2ba7141998e1',1596169898,0,1,'New Member',1596169898,1600240399,'140.109.19.241'),(12,'curryyuan','a869b66fefec9ab43199ed28a08d7d7400c3be7287f4fb3b39f9cbf3832adf1f7','yuanzhh5@mail2.sysu.edu.cn','','Zhihao','Yuan',0,'3c52a53747dd3e9c3ecb4e6f4a941417',1596368328,0,1,'New Member',1596368328,1608018761,'45.135.48.12'),(13,'rexleeppp','86830c5f3ea483f6a03235bb1cb4c1fae49547cec6a6add2b1da2c8ef0d33c044','rexleeppp@gmail.com','','Han-Hung','Lee',0,'fb44fef7e41d5773a4c634fb052004e5',1598441331,0,1,'New Member',1598441331,1598441346,'123.192.88.95'),(14,'yifan','4ba110d036b1ba987df59cd79481f1a10f40a92b80e7a76b7982db383da26a8ae','ljie@buaa.edu.cn','','Jie','Liu',1,'33b8161dffe72c675faa8d93d7957be0',1604380090,0,1,'New Member',1604380090,1604380097,'124.126.230.100');


