--
-- Host: localhost    Database: staging_slides_pathhub
-- ------------------------------------------------------


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissions_group_id_b120cbf9` (`group_id`),
  KEY `auth_group_permissions_permission_id_84c5c92e` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  KEY `auth_permission_content_type_id_2f476e4b` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add content type',5,'add_contenttype'),(18,'Can change content type',5,'change_contenttype'),(19,'Can delete content type',5,'delete_contenttype'),(20,'Can view content type',5,'view_contenttype'),(21,'Can add session',6,'add_session'),(22,'Can change session',6,'change_session'),(23,'Can delete session',6,'delete_session'),(24,'Can view session',6,'view_session'),(25,'Can add folder',7,'add_folder'),(26,'Can change folder',7,'change_folder'),(27,'Can delete folder',7,'delete_folder'),(28,'Can view folder',7,'view_folder'),(29,'Can add slide',8,'add_slide'),(30,'Can change slide',8,'change_slide'),(31,'Can delete slide',8,'delete_slide'),(32,'Can view slide',8,'view_slide'),(33,'Can add annotation',9,'add_annotation'),(34,'Can change annotation',9,'change_annotation'),(35,'Can delete annotation',9,'delete_annotation'),(36,'Can view annotation',9,'view_annotation'),(37,'Can add activity',10,'add_activity'),(38,'Can change activity',10,'change_activity'),(39,'Can delete activity',10,'delete_activity'),(40,'Can view activity',10,'view_activity'),(41,'Can add custom user',11,'add_customuser'),(42,'Can change custom user',11,'change_customuser'),(43,'Can delete custom user',11,'delete_customuser'),(44,'Can view custom user',11,'view_customuser'),(45,'Can add category',12,'add_category'),(46,'Can change category',12,'change_category'),(47,'Can delete category',12,'delete_category'),(48,'Can view category',12,'view_category'),(49,'Can add subcategory',13,'add_subcategory'),(50,'Can change subcategory',13,'change_subcategory'),(51,'Can delete subcategory',13,'delete_subcategory'),(52,'Can view subcategory',13,'view_subcategory'),(53,'Can add subtag',14,'add_subtag'),(54,'Can change subtag',14,'change_subtag'),(55,'Can delete subtag',14,'delete_subtag'),(56,'Can view subtag',14,'view_subtag'),(57,'Can add tag',15,'add_tag'),(58,'Can change tag',15,'change_tag'),(59,'Can delete tag',15,'delete_tag'),(60,'Can view tag',15,'view_tag'),(61,'Can add slide tags',16,'add_slidetags'),(62,'Can change slide tags',16,'change_slidetags'),(63,'Can delete slide tags',16,'delete_slidetags'),(64,'Can view slide tags',16,'view_slidetags'),(65,'Can add admin settings',17,'add_adminsettings'),(66,'Can change admin settings',17,'change_adminsettings'),(67,'Can delete admin settings',17,'delete_adminsettings'),(68,'Can view admin settings',17,'view_adminsettings'),(69,'Can add slide group',18,'add_slidegroup'),(70,'Can change slide group',18,'change_slidegroup'),(71,'Can delete slide group',18,'delete_slidegroup'),(72,'Can view slide group',18,'view_slidegroup');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_user_id_6a12ed8b` (`user_id`),
  KEY `auth_user_groups_group_id_97559544` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_groups`
--


--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permissions_user_id_a95ead1b` (`user_id`),
  KEY `auth_user_user_permissions_permission_id_1fbb5f2c` (`permission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_user_permissions`
--


--
-- Table structure for table `authentication_customuser`
--

CREATE TABLE `authentication_customuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `organization_name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `organization_role` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `organization_id` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `avatar` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `block` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authentication_customuser`
--

INSERT INTO `authentication_customuser` VALUES (6,'Poundbury Cancer Institute','Admin','114','9978073635',9,'Full_avatar.jpg',1),(7,'Uralensis Lab-L','Admin','115','9978073635',10,'Bird.jpeg',1),(8,'Poundbury Cancer Institute','User','114','9978073635',11,'PB2261726.png',1),(9,'Uralensis Lab-L','Admin','115','9632587410',12,'nature.jpg',1),(10,'Uralensis Lab-L','User','115','9632587410',13,'istockphoto-1180542165-612x612.jpg',1),(11,'Uralensis Lab-L','User','115','9651754201',14,'default.jpg',1),(12,'Poundbury Cancer Institute','User','114','07593044342',15,'default.jpg',1),(13,'Clinician','user','33','75658756',16,'assets/img/person-male.png',1),(14,'Clinician','user','33','',17,'assets/img/person-male.png',1),(15,'Lab System Admin','user','65','',18,'assets/img/1652094077_385.jpg',1),(16,'Lab System Admin','user','65','',19,'assets/img/1652094296_386.jpg',1),(17,'Lab System Admin','user','65','',20,'assets/img/person-male.png',1),(18,'Lab System Admin','user','65','',21,'assets/img/1652094609_388.jpg',1),(19,'Pathologist ','user','6','44 000000000',22,'assets/img/person-male.png',1),(20,'Pathologist ','user','6','',23,'assets/img/1652100243_391.png',1),(21,'Pathologist ','user','6','',24,'assets/img/1652101090_397.png',1),(23,'Pathologist ','user','6','07593043609',26,'assets/img/person-male.png',1),(24,'Pathologist ','user','6','',27,'assets/img/1652101439_399.png',1),(25,'Lab Data Entry','user','66','',28,'assets/img/1652100431_394.png',1),(26,'System Admin','user','1','',29,'assets/img/1652094354_284.png',1),(27,'Clinician','Admin','115','9978073635',31,'Bird.jpeg',1),(32,'Poundbury Cancer Institute','Admin','115','8484848484',32,'default.jpg',1),(33,'Uralensis Lab-L','Admin','114','9632587410',33,'default.jpg',1),(34,'Leon Macdonald Traders','User','115','+1 (347) 803-74',34,'',1);

--
-- Table structure for table `dashboard_activity`
--

CREATE TABLE `dashboard_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Saved` tinyint(1) NOT NULL,
  `LastAccessed` datetime(6) NOT NULL,
  `Slide_Id_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_activity_Slide_Id_id_8422ade1` (`Slide_Id_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dashboard_activity`
--


--
-- Table structure for table `dashboard_annotation`
--

CREATE TABLE `dashboard_annotation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Json` longtext NOT NULL,
  `AnnotationText` longtext NOT NULL,
  `Type` varchar(10) NOT NULL,
  `Slide_Id_id` int(11) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_annotation_Slide_Id_id_3458a1ec` (`Slide_Id_id`),
  KEY `dashboard_annotation_user_id_b03f187a` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dashboard_annotation`
--

INSERT INTO `dashboard_annotation` VALUES (1,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,14062.39571,1928.30138],\"type\":\"rectangle\",\"size\":[861.04905,373.46706],\"radius\":[0,0],\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":82.89525}]','','r',5,'2022-05-06 12:42:44.797298',NULL),(2,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[18299.8858,4278.86457],[18320.63397,4237.36823]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":82.89525}]','','l',5,'2022-05-06 12:42:44.797298',NULL),(51,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[10554.49172,8699.24948],[10790.40081,8713.34039]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":2.48673}]','','l',204,'2022-05-06 12:42:44.797298',NULL),(14,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[14286.22286,2158.45872],[20496.07283,1951.97356]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":30.59039}]','','l',6,'2022-05-06 12:42:44.797298',NULL),(42,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[2722.54506,2842.91878],[22820.43389,1986.38775]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":22.8945}]','','l',10,'2022-05-06 12:42:44.797298',NULL),(27,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[24079.00419,3026.217],[24385.00419,3443.217]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":22.89355}]','','l',10,'2022-05-06 12:42:44.797298',NULL),(32,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,11676.73235,3422.77338],\"type\":\"circle\",\"size\":[6351.88014,6351.88014],\"radius\":3175.94007,\"fillColor\":[1,1,1,0.05],\"strokeColor\":[0,0,0],\"strokeWidth\":0.78663}]','','c',6,'2022-05-06 12:42:44.797298',NULL),(33,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,2922.93194,1626.52279],\"type\":\"circle\",\"size\":[1595.09165,1595.09165],\"radius\":797.54582,\"fillColor\":[1,1,1,0.05],\"strokeColor\":[0,0,0],\"strokeWidth\":49.14851}]','','c',6,'2022-05-06 12:42:44.797298',NULL),(34,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,22203.84405,2399.01208],\"type\":\"rectangle\",\"size\":[1586.73508,1524.09987],\"radius\":[0,0],\"fillColor\":[1,1,1,0.05],\"strokeColor\":[0,0,0],\"strokeWidth\":49.14851}]','','r',6,'2022-05-06 12:42:44.797298',NULL),(53,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,13960.98508,18383.27391],\"type\":\"rectangle\",\"size\":[3325.952,475.136],\"radius\":[0,0],\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":4.45352}]','','r',221,'2022-05-06 12:42:44.797298',NULL),(81,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[103254.4982,78657.95588],[105257.04982,78637.14415]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":110.38948}]','','l',485,'2022-05-06 12:42:44.797298',NULL),(80,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[101230.47638,78720.96083],[103259.73718,78707.34163]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":217.47014}]','Annotation 22','l',485,'2022-05-06 12:42:44.797298',NULL),(83,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[76959.74856,22224.47954],[77492.08188,22463.81287]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":72.68034}]','','l',426,'2022-05-06 12:42:44.797298',NULL),(91,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[11290.56575,13102.43521],[11899.13718,13708.1495]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":67.19922}]','','l',492,'2022-05-06 12:42:44.797298',NULL),(100,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,1941.33246,997.88765],\"type\":\"rectangle\",\"size\":[190.5,122.5],\"radius\":[0,0],\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":6.03376}]','','r',494,'2022-05-13 06:25:08.870885',9),(101,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,19534.70928,11315.43379],\"type\":\"rectangle\",\"size\":[1239.08676,810.47184],\"radius\":[0,0],\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":93.102}]','','r',495,'2022-06-12 09:32:57.123466',10),(111,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[445.59788,143.55086],[525.25982,335.37683]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":1.07223}]','','l',517,'2022-07-20 15:19:43.387372',9),(104,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,6377.22717,2836.55591],\"type\":\"circle\",\"size\":[2002.77708,2002.77708],\"radius\":1001.38854,\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":29.8696}]','','c',513,'2022-06-17 10:42:41.440420',9),(106,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[4016.5024,6418.23498],[20528.86779,14207.63702]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":58.95777}]','','l',516,'2022-07-02 05:23:04.152979',9),(107,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[5095.93269,11027.69231],[9676.21875,18233.61899]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":58.95777}]','','l',516,'2022-07-02 05:23:15.764021',9),(108,'[\"Shape\",{\"applyMatrix\":false,\"matrix\":[1,0,0,1,394.32905,295.8844],\"type\":\"circle\",\"size\":[225.26738,225.26738],\"radius\":112.63369,\"fillColor\":[1,1,1,0.05],\"strokeColor\":[1,0,0],\"strokeWidth\":1.3085}]','','c',517,'2022-07-04 11:49:23.363144',9),(109,'[\"Path\",{\"applyMatrix\":true,\"segments\":[[2553.73246,1728.6503],[3808.45642,2791.47485]],\"fillColor\":[1,0,0],\"strokeColor\":[1,0,0],\"strokeWidth\":27.6428}]','','l',513,'2022-07-06 10:02:57.458791',9);

--
-- Table structure for table `dashboard_folder`
--

CREATE TABLE `dashboard_folder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` longtext NOT NULL,
  `Created` date NOT NULL,
  `Modified` date NOT NULL,
  `Parent_id` int(11) DEFAULT NULL,
  `organization` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_folder_Parent_id_15d85d30` (`Parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=339 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dashboard_folder`
--

INSERT INTO `dashboard_folder` VALUES (1,'FTP','2021-07-28','2021-07-28',NULL,NULL),(2,'PH0002D','2021-07-28','2021-07-28',1,NULL),(3,'PH0001D','2021-07-30','2021-07-30',1,NULL),(5,'PH0003D','2021-08-01','2021-08-01',1,NULL),(6,'PH0004D','2021-08-02','2021-08-02',1,NULL),(14,'LDS 2021','2021-09-09','2021-09-09',13,NULL),(13,'DermpathPRO','2021-09-09','2021-09-09',1,NULL),(44,'Self Assessment Cases','2021-09-15','2021-09-15',14,NULL),(45,'LDS Self Assessment Case 6','2021-09-15','2021-09-15',44,NULL),(19,'Slide Library case 1','2021-09-15','2021-09-15',14,NULL),(20,'Slide Library case 2','2021-09-15','2021-09-15',14,NULL),(161,'Case006','2021-09-20','2021-09-20',155,NULL),(135,'Slide Library case 12','2021-09-16','2021-09-16',14,NULL),(136,'Slide Library case 13','2021-09-16','2021-09-16',14,NULL),(137,'Slide Library case 14','2021-09-16','2021-09-16',14,NULL),(160,'Case020','2021-09-20','2021-09-20',155,NULL),(56,'Slide Library case 4','2021-09-15','2021-09-15',14,NULL),(57,'Slide Library case 5','2021-09-15','2021-09-15',14,NULL),(55,'LDS Self Assessment Case 20','2021-09-15','2021-09-15',44,NULL),(47,'LDS Self Assessment Case 8','2021-09-15','2021-09-15',44,NULL),(48,'LDS Self Assessment Case 10','2021-09-15','2021-09-15',44,NULL),(49,'LDS Self Assessment Case 19','2021-09-15','2021-09-15',44,NULL),(50,'LDS Self Assessment Case 16','2021-09-15','2021-09-15',44,NULL),(51,'LDS Self Assessment Case 18','2021-09-15','2021-09-15',44,NULL),(52,'LDS Self Assessment Case 7','2021-09-15','2021-09-15',44,NULL),(53,'LDS Self Assessment Case 17','2021-09-15','2021-09-15',44,NULL),(54,'LDS Self Assessment Case 9','2021-09-15','2021-09-15',44,NULL),(134,'Slide Library case 11','2021-09-16','2021-09-16',14,NULL),(159,'Case019','2021-09-20','2021-09-20',155,NULL),(158,'Case014','2021-09-20','2021-09-20',155,NULL),(144,'03541','2021-09-18','2021-09-18',261,NULL),(143,'36886 (2)','2021-09-18','2021-09-18',261,NULL),(157,'Case001','2021-09-20','2021-09-20',155,NULL),(156,'Case012','2021-09-20','2021-09-20',155,NULL),(155,'FRCPath Part 2','2021-09-20','2021-09-20',1,NULL),(154,'39252','2021-09-19','2021-09-19',261,NULL),(274,'38679','2021-09-23','2021-09-23',1,NULL),(145,'36168','2021-09-18','2021-09-18',261,NULL),(152,'36886 (1)','2021-09-19','2021-09-19',261,NULL),(153,'36886 (3)','2021-09-19','2021-09-19',261,NULL),(258,'Case 13','2021-09-20','2021-09-20',165,NULL),(182,'Case009','2021-09-20','2021-09-20',165,NULL),(193,'Case 15','2021-09-20','2021-09-20',165,NULL),(263,'39252','2021-09-22','2021-09-22',1,NULL),(196,'Case 08','2021-09-20','2021-09-20',165,NULL),(168,'Case007','2021-09-20','2021-09-20',165,NULL),(167,'Case006','2021-09-20','2021-09-20',165,NULL),(321,'05-08-2022','2022-08-05','2022-08-05',NULL,'115'),(165,'FRCPath P2 Mock','2021-09-20','2021-09-20',1,NULL),(164,'Case003','2021-09-20','2021-09-20',155,NULL),(163,'Case002','2021-09-20','2021-09-20',155,NULL),(162,'Case008','2021-09-20','2021-09-20',155,NULL),(275,'38679','2021-09-23','2021-09-23',13,NULL),(273,'TestCase','2021-09-23','2021-09-23',1,NULL),(272,'TestCase','2021-09-23','2021-09-23',1,NULL),(271,'TestCase','2021-09-23','2022-03-14',1,NULL),(276,'testing file','2021-09-24','2021-09-24',1,NULL),(269,'TestCase','2021-09-23','2021-09-23',1,NULL),(255,'Case017','2021-09-20','2021-09-20',246,NULL),(257,'Case018','2021-09-20','2021-09-20',246,NULL),(261,'Spot Diagnosis','2021-09-22','2021-09-22',13,NULL),(248,'Case011','2021-09-20','2021-09-20',246,NULL),(247,'Case 09','2021-09-20','2021-09-20',165,NULL),(246,'New FRCPath P2','2021-09-20','2021-09-20',1,NULL),(245,'Case004','2021-09-20','2021-09-20',246,NULL),(323,'TEST001','2022-08-06','2022-08-06',NULL,'115'),(324,'3D Histec slides','2022-08-06','2022-08-06',NULL,'115'),(325,'Ferenc Szipocs - 2022-02-18 14.24.31 - 698007','2022-08-06','2022-08-06',324,'115'),(326,'Ferenc Szipocs - 13238','2022-08-06','2022-08-06',324,'115'),(327,'slides','2022-08-06','2022-08-06',NULL,'115'),(328,'03-08-2022','2022-08-06','2022-08-06',327,'115'),(329,'06-08-2022','2022-08-06','2022-08-06',327,'115'),(320,'04-08-2022','2022-08-04','2022-08-04',NULL,'115'),(331,'17-08-2022','2022-08-17','2022-08-17',NULL,'115'),(334,'18-08-2022','2022-08-18','2022-08-18',NULL,'115'),(330,'16-08-2022','2022-08-16','2022-08-16',NULL,'115'),(335,'19-08-2022','2022-08-19','2022-08-19',NULL,'115'),(336,'22-08-2022','2022-08-22','2022-08-22',NULL,'115'),(337,'25-08-2022','2022-08-25','2022-08-25',NULL,'115'),(338,'26-08-2022','2022-08-26','2022-08-26',NULL,'115'),(318,'29-07-2022','2022-07-29','2022-07-29',317,'115'),(322,'PH0022','2022-08-06','2022-08-06',NULL,'115');

--
-- Table structure for table `dashboard_sharedannotation`
--

CREATE TABLE `dashboard_sharedannotation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Annotation_Id` int(11) NOT NULL,
  `Slide_Id_id` int(11) NOT NULL,
  `shared_from_user_id` int(11) DEFAULT NULL,
  `shared_from_user_name` varchar(255) DEFAULT NULL,
  `shared_to_user_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_annotation_Slide_Id_id_3458a1ec` (`Slide_Id_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dashboard_sharedannotation`
--

INSERT INTO `dashboard_sharedannotation` VALUES (14,80,485,2,'admin2',1,'2021-10-14 12:28:17');

--
-- Table structure for table `dashboard_slide`
--

CREATE TABLE `dashboard_slide` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` mediumtext NOT NULL,
  `ScannedBy` varchar(50) NOT NULL,
  `ScannedDate` date NOT NULL,
  `InsertedBy` varchar(50) NOT NULL,
  `InsertedDate` date NOT NULL,
  `SlideType` int(11) NOT NULL,
  `UrlPath` varchar(500) NOT NULL,
  `LabelUrlPath` varchar(500) NOT NULL,
  `Group` int(11) NOT NULL,
  `GroupName` varchar(100) NOT NULL,
  `Annotations` tinyint(1) NOT NULL,
  `Folder_id` int(11) NOT NULL,
  `Filesize` double NOT NULL,
  `Tag` varchar(50) NOT NULL,
  `CopyOf_id` int(11) DEFAULT NULL,
  `CaseNo` varchar(50) NOT NULL,
  `organization` varchar(100) DEFAULT NULL,
  `deleted_by` varchar(60) DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  `deleted_date` date DEFAULT NULL,
  `Gname_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_slide_Folder_Id_id_634bc9a7` (`Folder_id`),
  KEY `dashboard_slide_CopyOf_id_df6b512b` (`CopyOf_id`),
  KEY `dashboard_slide_Gname_id_673ff713` (`Gname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2759 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dashboard_slide`
--

INSERT INTO `dashboard_slide` VALUES (2733,'1862','Philips','2022-08-18','dev','2022-08-18',2,'/var/www/vhosts/pathhub.uk/slides.pathhub.uk/media/Clientuploads/slides/18-08-2022/1862__25483a28-a651-44a5-80a5-b45ceb51dbd9.svs','/static/images/placeholder.png',0,'Default Group',1,1,94693355,'',NULL,'1862','115',NULL,0,NULL,NULL),(2734,'1862__44d5f359-5c8d-4260-85a4-3db18066bdf0','Philips','2022-08-18','dev','2022-08-18',2,'/var/www/vhosts/pathhub.uk/slides.pathhub.uk/media/Clientuploads/slides/18-08-2022/1862__44d5f359-5c8d-4260-85a4-3db18066bdf0__740e3ef8-b46f-4b91-a9af-7f3045048198.svs','/static/images/placeholder.png',0,'Default Group',1,1,69792005,'',NULL,'1862__44d5f359-5c8d-4260-85a4-3db18066bdf0','115',NULL,0,NULL,NULL),(2735,'1856','Philips','2022-08-18','dev','2022-08-18',2,'/var/www/vhosts/pathhub.uk/slides.pathhub.uk/media/Clientuploads/slides/18-08-2022/1856__4dd13f62-1c89-411e-a93e-fe532eda7210.svs','/static/images/placeholder.png',0,'Default Group',1,1,9004505,'',NULL,'1856','115',NULL,0,NULL,NULL),(2755,'Olympia Puckett','3DHistech','2022-08-25','ajay','2022-08-25',2,'25-08-2022/1862__1d49f750-2d75-4439-a70b-ab484f6a74e2.svs','/static/images/placeholder.png',0,'Default Group',0,337,69792005,'',NULL,'1855','115',NULL,0,NULL,1),(2737,'test 151','Hamamatsu','2022-08-19','ajay','2022-08-19',2,'19-08-2022/download__78836025-9802-4abf-9e13-ee57c952225d.svs','/static/images/placeholder.png',0,'Default Group',1,335,5198,'',NULL,'151','115',NULL,0,NULL,1),(2736,'1862__25483a28-a651-44a5-80a5-b45ceb51dbd9','Philips','2022-08-18','dev','2022-08-18',2,'/var/www/vhosts/pathhub.uk/slides.pathhub.uk/media/Clientuploads/slides/18-08-2022/1862__25483a28-a651-44a5-80a5-b45ceb51dbd9__7f5b577f-124e-4d51-b7db-6abf45d4479b.svs','/static/images/placeholder.png',0,'Default Group',1,1,94693355,'',NULL,'1862__25483a28-a651-44a5-80a5-b45ceb51dbd9','115',NULL,0,NULL,NULL),(2738,'test 152','Hamamatsu','2022-08-19','ajay','2022-08-19',2,'19-08-2022/download__9b3c3a33-8edc-431b-bb0a-ff87b84de259.svs','/static/images/placeholder.png',0,'Default Group',1,335,5198,'',NULL,'152','115',NULL,0,NULL,1),(2741,'Test ','Hamamatsu','2022-08-19','dev','2022-08-19',2,'19-08-2022/1862__33d28a49-e0df-4b6f-a036-ab66acb8e763.svs','/static/images/labels/1862__b486fbce-71ce-4885-94cc-191c46d2828f.svs',0,'Default Group',1,335,9004505,'',NULL,'1862','115',NULL,0,NULL,1),(2745,'Test 1857','Hamamatsu','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__951b8225-5e01-44ce-9234-6c3384484127.svs','/static/images/placeholder.png',0,'Default Group',1,336,69792005,'',NULL,'1857','115',NULL,0,NULL,1),(2746,'test 1859','Hamamatsu','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__6faee0cb-df1f-4667-8cdf-6ccfeea6a77c.svs','/static/images/placeholder.png',0,'Default Group',1,336,69792005,'',NULL,'1859','115',NULL,0,NULL,1),(2747,'Test 1858','Leica','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__d57a7c0e-76a0-4dd5-93a6-8b6ef1805487.svs','/static/images/placeholder.png',0,'Default Group',1,336,69792005,'',NULL,'1858','115',NULL,0,NULL,1),(2748,'Test 1860','Hamamatsu','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__7981d746-e031-4a48-8461-1af2e8eae7a3.svs','/static/images/placeholder.png',0,'Default Group',1,336,69792005,'',NULL,'1860','115',NULL,0,NULL,1),(2758,'testing 1861','Motic','2022-08-26','ajay','2022-08-26',2,'26-08-2022/1862__e1cbaba9-d8d3-44d4-a8e0-825132b63a18.svs','/slide_management/static/images/labels/label (1)__cf5f1b1e-bb23-448e-b4fb-184bedf4eb08.png',0,'Default Group',1,338,69792005,'',NULL,'1861','115',NULL,0,NULL,1),(2752,'TEST 1854 1','Leica','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__899ec676-7bfd-40c0-89d1-82a6f5ffd347.svs','/static/images/labels/download__4d808570-3414-4db6-b92a-d73c4f9ce23c.svs',0,'Default Group',1,336,69792005,'',NULL,'1854','115',NULL,0,NULL,2),(2753,'TEst 1861 1','Hamamatsu','2022-08-22','ajay','2022-08-22',2,'22-08-2022/1862__0f5129fa-c5f5-4ea9-9313-5f7a189a9801.svs','/static/images/labels/label (2)__32fd69ee-fd8b-4d46-bcb4-80b7c77880ae.png',0,'Default Group',1,336,69792005,'',NULL,'1861','115',NULL,0,NULL,2),(2754,'TESTING 1854','Hamamatsu','2022-08-25','ajay','2022-08-25',2,'25-08-2022/1862__639b617e-f4d2-4c02-a7c0-290a6bd89651.svs','/static/images/placeholder.png',0,'Default Group',1,337,69792005,'',NULL,'1854','115',NULL,0,NULL,2),(2756,'Dexter Elliott','3DHistech','2022-08-26','ajay','2022-08-26',2,'26-08-2022/1862__a3ebafeb-8a59-4c3f-b114-2dbe81e9b217.svs','/slide_management/static/images/labels/label (1)__bd31807a-9fda-4926-b4cc-202fd06276cd.png',0,'Default Group',1,338,69792005,'',NULL,'1855','115',NULL,0,NULL,2),(2757,'testing1 1855','Leica','2022-08-26','ajay','2022-08-26',2,'26-08-2022/1862__2ad953d2-0a4b-4d2d-b582-7cb74cdf1c0a.svs','/slide_management/static/images/labels/label__a80799c1-44f5-4ea6-aa31-6b940f2f9aab.png',0,'Default Group',1,338,69792005,'',NULL,'1855','115',NULL,0,NULL,2);

--
-- Table structure for table `dashboard_slidegroup`
--

CREATE TABLE `dashboard_slidegroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_name` (`group_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dashboard_slidegroup`
--

INSERT INTO `dashboard_slidegroup` VALUES (1,'Test1','2022-08-03 10:22:41.896873'),(2,'Test 2','2022-08-22 12:10:28.965394');

--
-- Table structure for table `dashboard_slidetags`
--

CREATE TABLE `dashboard_slidetags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` datetime(6) NOT NULL,
  `modified_at` datetime(6) NOT NULL,
  `slide_id` int(11) NOT NULL,
  `subtag_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `dashboard_slidetags_subtag_id_01abf8f0_fk_dashboard_subtag_id` (`subtag_id`),
  KEY `dashboard_slidetags_tag_id_46174471_fk_dashboard_tag_id` (`tag_id`),
  CONSTRAINT `dashboard_slidetags_subtag_id_01abf8f0_fk_dashboard_subtag_id` FOREIGN KEY (`subtag_id`) REFERENCES `dashboard_subtag` (`id`),
  CONSTRAINT `dashboard_slidetags_tag_id_46174471_fk_dashboard_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `dashboard_tag` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dashboard_slidetags`
--

INSERT INTO `dashboard_slidetags` VALUES (12,'2022-05-16 13:05:51.009847','2022-05-16 13:05:51.009876',494,2,1),(13,'2022-05-16 13:05:51.035007','2022-05-16 13:05:51.035049',494,1,1),(16,'2022-05-28 09:09:08.142207','2022-05-28 09:09:08.142242',523,2,1),(25,'2022-05-30 11:57:40.672492','2022-05-30 11:57:40.672524',521,2,1),(26,'2022-05-30 11:57:40.701824','2022-05-30 11:57:40.701874',521,5,3),(27,'2022-05-30 11:57:40.711690','2022-05-30 11:57:40.711744',521,1,1),(34,'2022-05-30 12:04:14.315243','2022-05-30 12:04:14.315310',492,5,3),(35,'2022-05-30 12:04:14.323534','2022-05-30 12:04:14.323568',492,5,3),(39,'2022-05-30 12:15:09.224462','2022-05-30 12:15:09.224497',525,2,1),(87,'2022-05-31 10:52:33.853014','2022-05-31 10:52:33.853042',495,2,1),(88,'2022-05-31 10:52:33.872727','2022-05-31 10:52:33.872761',495,5,3),(89,'2022-05-31 10:52:33.885504','2022-05-31 10:52:33.885558',495,1,1),(90,'2022-05-31 10:52:33.892847','2022-05-31 10:52:33.892899',495,3,2),(91,'2022-06-07 11:42:38.807212','2022-06-07 11:42:38.807238',526,4,3),(92,'2022-06-07 11:42:38.832330','2022-06-07 11:42:38.832363',526,2,1),(93,'2022-06-07 11:42:38.840982','2022-06-07 11:42:38.841024',526,5,3),(94,'2022-06-15 07:05:42.717789','2022-06-15 07:05:42.717821',513,2,1),(95,'2022-08-03 10:23:30.461429','2022-08-03 10:23:30.461462',1690,4,3),(96,'2022-08-04 09:20:42.197118','2022-08-04 09:20:42.197185',2112,7,1),(97,'2022-08-04 09:21:33.680930','2022-08-04 09:21:33.680961',2113,7,1),(98,'2022-08-04 11:56:27.486371','2022-08-04 11:56:27.486394',2114,7,1),(101,'2022-08-16 13:06:43.846101','2022-08-16 13:06:43.846133',2460,7,1),(102,'2022-08-16 13:09:21.361293','2022-08-16 13:09:21.361318',2461,7,1),(103,'2022-08-17 05:42:00.168809','2022-08-17 05:42:00.168834',2462,7,1),(104,'2022-08-17 06:56:12.400662','2022-08-17 06:56:12.400687',2463,7,1),(105,'2022-08-17 09:28:56.715979','2022-08-17 09:28:56.716006',2464,2,1),(107,'2022-08-19 11:55:43.011603','2022-08-19 11:55:43.011631',2737,7,1),(108,'2022-08-19 12:37:20.476000','2022-08-19 12:37:20.476025',2738,7,1),(111,'2022-08-19 14:27:52.601574','2022-08-19 14:27:52.601599',2741,2,1),(112,'2022-08-22 05:16:18.180069','2022-08-22 05:16:18.180118',1859,2,1),(116,'2022-08-22 10:43:36.327292','2022-08-22 10:43:36.327321',2745,7,1),(117,'2022-08-22 10:59:08.403626','2022-08-22 10:59:08.403650',2746,7,1),(118,'2022-08-22 11:29:34.649499','2022-08-22 11:29:34.649523',2747,7,1),(119,'2022-08-22 11:40:55.572870','2022-08-22 11:40:55.572895',2748,7,1),(124,'2022-08-22 12:11:31.178699','2022-08-22 12:11:31.178724',2752,7,1),(125,'2022-08-22 12:15:58.085405','2022-08-22 12:15:58.085429',2753,7,1),(126,'2022-08-25 07:36:32.948270','2022-08-25 07:36:32.948294',2754,4,3),(127,'2022-08-25 12:52:46.840020','2022-08-25 12:52:46.840087',2755,5,3),(128,'2022-08-26 10:35:20.743949','2022-08-26 10:35:20.743976',2756,7,1),(129,'2022-08-26 11:32:50.349145','2022-08-26 11:32:50.349169',2757,4,3),(130,'2022-08-26 12:12:10.436687','2022-08-26 12:12:10.436711',2758,3,2);

--
-- Table structure for table `dashboard_subtag`
--

CREATE TABLE `dashboard_subtag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subtag_name` varchar(100) DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `modified_at` datetime(6) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subtag_name` (`subtag_name`),
  KEY `dashboard_subtag_tag_id_eb579657_fk_dashboard_tag_id` (`tag_id`),
  CONSTRAINT `dashboard_subtag_tag_id_eb579657_fk_dashboard_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `dashboard_tag` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dashboard_subtag`
--

INSERT INTO `dashboard_subtag` VALUES (1,'ECR',1,'2022-05-13 04:03:45.947140','2022-05-13 04:03:45.947222',1),(2,'CBR',1,'2022-05-13 04:03:53.826491','2022-06-01 12:42:15.394317',1),(3,'Red blood cells',1,'2022-05-13 04:04:04.744896','2022-05-13 04:04:04.744976',2),(4,'Brain Report',1,'2022-05-13 04:04:19.731344','2022-05-13 04:04:19.731428',3),(5,'Covid Report',1,'2022-05-13 08:46:13.943238','2022-06-01 12:54:03.522098',3),(7,'BCR',1,'2022-06-01 13:03:26.668054','2022-06-01 13:03:26.668137',1);

--
-- Table structure for table `dashboard_tag`
--

CREATE TABLE `dashboard_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` datetime(6) NOT NULL,
  `modified_at` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_name` (`tag_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dashboard_tag`
--

INSERT INTO `dashboard_tag` VALUES (1,'Blood',1,'2022-05-13 04:01:47.834006','2022-06-01 12:53:26.390690'),(2,'Urine',1,'2022-05-13 04:01:53.415340','2022-05-13 04:01:53.415420'),(3,'CT Scan',1,'2022-05-13 04:01:59.927234','2022-05-13 04:01:59.927317'),(4,'test123',1,'2022-05-31 12:09:46.472275','2022-05-31 12:09:46.472358');

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext DEFAULT NULL,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (35,'2022-03-16 06:41:41.591861','9','admin',2,'[{\"added\": {\"name\": \"custom user\", \"object\": \"CustomUser object (6)\"}}]',4,9),(36,'2022-03-16 06:41:58.744029','284','FTP1',2,'[{\"changed\": {\"fields\": [\"organization\"]}}]',7,9),(37,'2022-03-16 06:42:03.049854','283','FTP1',2,'[{\"changed\": {\"fields\": [\"organization\"]}}]',7,9),(38,'2022-03-16 06:42:46.274575','6','ajay',3,'',4,9),(39,'2022-04-28 12:00:30.078350','9','admin',2,'[{\"changed\": {\"fields\": [\"password\"]}}]',4,9),(40,'2022-05-26 06:44:23.596634','10','ajay',1,'[{\"added\": {}}, {\"added\": {\"name\": \"custom user\", \"object\": \"CustomUser object (7)\"}}]',4,9),(41,'2022-05-26 06:44:42.092685','10','ajay',2,'[{\"changed\": {\"fields\": [\"is_staff\"]}}]',4,9),(42,'2022-05-26 06:48:58.900415','11','Deepak',1,'[{\"added\": {}}, {\"added\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\"}}]',4,9),(43,'2022-05-26 06:49:18.689078','11','Deepak',2,'[{\"changed\": {\"fields\": [\"is_staff\"]}}]',4,9),(44,'2022-05-26 06:49:44.027313','11','Deepak',2,'[{\"changed\": {\"fields\": [\"first_name\", \"last_name\"]}}]',4,9),(45,'2022-05-26 06:50:02.594076','10','ajay',2,'[{\"changed\": {\"fields\": [\"first_name\", \"last_name\"]}}]',4,9),(46,'2022-05-26 06:50:19.478518','11','Deepak',2,'[{\"changed\": {\"fields\": [\"last_name\"]}}]',4,9),(47,'2022-05-26 06:50:44.136896','11','Deepak',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_id\"]}}]',4,9),(48,'2022-05-26 12:30:16.822730','9','admin',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (6)\", \"fields\": [\"organization_id\"]}}]',4,9),(49,'2022-05-26 12:30:37.180593','10','ajay',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (7)\", \"fields\": [\"organization_id\", \"organization_name\"]}}]',4,9),(50,'2022-05-26 12:30:47.135001','11','Deepak',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_id\"]}}]',4,9),(51,'2022-05-26 12:30:55.448931','10','ajay',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (7)\", \"fields\": [\"organization_id\", \"organization_name\"]}}]',4,9),(52,'2022-05-26 12:32:05.344955','11','Deepak',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_id\", \"organization_name\"]}}]',4,9),(53,'2022-05-26 12:36:46.707730','11','Deepak',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_id\", \"organization_name\"]}}]',4,9),(54,'2022-05-27 10:54:14.514217','10','ajay',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (7)\", \"fields\": [\"organization_name\"]}}]',4,9),(55,'2022-05-27 10:54:57.234750','9','admin',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (6)\", \"fields\": [\"organization_name\"]}}]',4,9),(56,'2022-05-27 10:55:05.907442','11','Deepak',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_name\"]}}]',4,9),(57,'2022-05-27 11:40:25.119091','12','Global',1,'[{\"added\": {}}, {\"added\": {\"name\": \"custom user\", \"object\": \"CustomUser object (9)\"}}]',4,9),(58,'2022-05-27 11:41:43.959938','12','Global',2,'[{\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (9)\", \"fields\": [\"organization_id\", \"organization_name\"]}}]',4,9),(59,'2022-05-31 11:53:59.804895','12','Global',2,'[{\"changed\": {\"fields\": [\"is_staff\"]}}, {\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (9)\", \"fields\": [\"organization_name\", \"organization_role\"]}}]',4,9),(60,'2022-06-01 12:52:09.448159','11','Deepak',2,'[{\"changed\": {\"fields\": [\"is_active\"]}}, {\"changed\": {\"name\": \"custom user\", \"object\": \"CustomUser object (8)\", \"fields\": [\"organization_role\"]}}]',4,9);

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(2,'auth','permission'),(3,'auth','group'),(4,'auth','user'),(5,'contenttypes','contenttype'),(6,'sessions','session'),(7,'dashboard','folder'),(8,'dashboard','slide'),(9,'dashboard','annotation'),(10,'dashboard','activity'),(11,'authentication','customuser'),(12,'dashboard','category'),(13,'dashboard','subcategory'),(14,'dashboard','subtag'),(15,'dashboard','tag'),(16,'dashboard','slidetags'),(17,'dashboard','adminsettings'),(18,'dashboard','slidegroup');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2021-07-28 11:18:10.157920'),(2,'auth','0001_initial','2021-07-28 11:18:11.106086'),(3,'admin','0001_initial','2021-07-28 11:18:11.282276'),(4,'admin','0002_logentry_remove_auto_add','2021-07-28 11:18:11.303606'),(5,'admin','0003_logentry_add_action_flag_choices','2021-07-28 11:18:11.309290'),(6,'contenttypes','0002_remove_content_type_name','2021-07-28 11:18:11.407912'),(7,'auth','0002_alter_permission_name_max_length','2021-07-28 11:18:11.524905'),(8,'auth','0003_alter_user_email_max_length','2021-07-28 11:18:11.575384'),(9,'auth','0004_alter_user_username_opts','2021-07-28 11:18:11.581267'),(10,'auth','0005_alter_user_last_login_null','2021-07-28 11:18:11.650797'),(11,'auth','0006_require_contenttypes_0002','2021-07-28 11:18:11.651520'),(12,'auth','0007_alter_validators_add_error_messages','2021-07-28 11:18:11.657164'),(13,'auth','0008_alter_user_username_max_length','2021-07-28 11:18:11.701510'),(14,'auth','0009_alter_user_last_name_max_length','2021-07-28 11:18:11.751749'),(15,'auth','0010_alter_group_name_max_length','2021-07-28 11:18:11.793539'),(16,'auth','0011_update_proxy_permissions','2021-07-28 11:18:11.799130'),(17,'auth','0012_alter_user_first_name_max_length','2021-07-28 11:18:11.835603'),(18,'dashboard','0001_initial','2021-07-28 11:18:12.197304'),(19,'dashboard','0002_folder_parent','2021-07-28 11:18:12.331427'),(20,'dashboard','0003_remove_folder_path','2021-07-28 11:18:12.365036'),(21,'dashboard','0004_auto_20210227_1548','2021-07-28 11:18:12.466104'),(22,'dashboard','0005_auto_20210227_1634','2021-07-28 11:18:12.470058'),(23,'dashboard','0006_auto_20210301_1528','2021-07-28 11:18:12.473552'),(24,'dashboard','0007_auto_20210301_1543','2021-07-28 11:18:12.575374'),(25,'dashboard','0008_slide_tag','2021-07-28 11:18:12.668802'),(26,'dashboard','0009_slide_copyof','2021-07-28 11:18:12.831545'),(27,'sessions','0001_initial','2021-07-28 11:18:12.903899'),(28,'dashboard','0010_slide_caseno','2022-03-07 12:10:12.103836'),(29,'authentication','0001_initial','2022-03-11 04:15:21.018808'),(30,'authentication','0002_auto_20220311_0440','2022-03-11 04:40:05.588720'),(31,'authentication','0003_auto_20220311_0442','2022-03-11 04:43:03.917281'),(32,'dashboard','0011_folder_organization','2022-03-11 11:26:22.981677'),(33,'dashboard','0012_slide_organization','2022-03-11 11:45:57.557340'),(34,'authentication','0002_customuser_avatar','2022-03-15 04:15:41.361384'),(35,'authentication','0003_auto_20220315_0744','2022-03-15 07:44:49.547579'),(36,'dashboard','0013_auto_20220506_1235','2022-05-06 12:42:44.892165'),(37,'dashboard','0014_auto_20220510_1152','2022-05-10 11:52:59.705437'),(38,'dashboard','0014_auto_20220510_1245','2022-05-10 12:46:31.152678'),(39,'dashboard','0015_auto_20220513_0356','2022-05-13 03:58:10.987964'),(40,'dashboard','0016_auto_20220519_0358','2022-05-19 03:58:59.829051'),(41,'dashboard','0017_auto_20220519_0401','2022-05-19 04:01:25.347694'),(42,'authentication','0004_auto_20220531_0616','2022-05-31 06:16:20.933176'),(43,'dashboard','0018_auto_20220531_0616','2022-05-31 06:16:21.033116'),(44,'authentication','0005_auto_20220607_1119','2022-06-07 11:20:03.768075'),(45,'dashboard','0019_slide_deleted_date','2022-06-07 11:20:03.795495'),(46,'authentication','0004_auto_20220526_1026','2022-06-22 11:32:00.810862'),(47,'authentication','0005_auto_20220531_0423','2022-06-22 11:32:00.826127'),(48,'authentication','0006_auto_20220606_1301','2022-06-22 11:32:00.837104'),(49,'authentication','0007_auto_20220613_0954','2022-06-22 11:32:00.847254'),(50,'authentication','0008_auto_20220621_1240','2022-06-22 11:32:00.857646'),(51,'dashboard','0020_adminsettings','2022-06-22 11:32:00.935231'),(52,'dashboard','0021_auto_20220622_0529','2022-06-22 11:32:01.430403'),(54,'authentication','0009_customuser_block','2022-07-20 12:29:51.739940'),(56,'dashboard','0022_auto_20220727_0922','2022-07-29 12:35:00.753875');


