drop schema if exists CS0725681;
create schema CS0725681;
use CS0725681;

-- MariaDB dump 10.19  Distrib 10.11.7-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: olcc.account
-- ------------------------------------------------------
-- Server version	10.11.7-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tt_obj`
--

DROP TABLE IF EXISTS `tt_obj`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tt_obj` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Uid` varchar(40) NOT NULL,
  `ObjType` varchar(150) NOT NULL,
  `ObjData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `ObjId` int(11) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.ObjId'))) STORED,
  `ObjUid` varchar(40) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.ObjUid'))) STORED,
  `AddrId` int(11) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.AddrId'))) STORED,
  `AddrUid` varchar(40) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.AddrUid'))) STORED,
  `StartDate` datetime(3) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.StartDate'))) STORED,
  `EndDate` datetime(3) GENERATED ALWAYS AS (json_unquote(json_value(`ObjData`,'$.EndDate'))) STORED,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `ObjAddrmapping_Id_uindex` (`ObjType`,`ObjId`,`AddrId`),
  KEY `idx_ObjAddrmappingmappingObjUid` (`ObjUid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22604 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tt_obj`
--
-- WHERE:  1=1 limit 10

LOCK TABLES `tt_obj` WRITE;
/*!40000 ALTER TABLE `tt_obj` DISABLE KEYS */;
INSERT INTO `tt_obj` VALUES
(700,'8D8BBA196D70FD8DBC6EEA6','Organization','{\"Uid\":\"8D8BBA196D70FD8DBC6EEA6\",\"ObjType\":\"Organization\",\"ObjId\":2101,\"ObjUid\":\"8D8BBA196C6FF478CE79672\",\"AddrId\":2106,\"AddrUid\":\"8D8BBA196D4439A1698229A\",\"StartDate\":\"2021-01-18 11:09:56\",\"CreatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"CreatedOn\":\"2021-01-18 11:09:56\",\"UpdatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"UpdatedOn\":\"2021-01-18 11:09:56\"}',2101,'8D8BBA196C6FF478CE79672',2106,'8D8BBA196D4439A1698229A','2021-01-18 11:09:56.000',NULL),
(701,'8D8BBA196D992E9FDAD8166','Organization','{\"Uid\":\"8D8BBA196D992E9FDAD8166\",\"ObjType\":\"Organization\",\"ObjId\":2101,\"ObjUid\":\"8D8BBA196C6FF478CE79672\",\"AddrId\":2107,\"AddrUid\":\"8D8BBA196D9726C202BB025\",\"StartDate\":\"2021-01-18 11:09:56\",\"CreatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"CreatedOn\":\"2021-01-18 11:09:56\",\"UpdatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"UpdatedOn\":\"2021-01-18 11:09:56\"}',2101,'8D8BBA196C6FF478CE79672',2107,'8D8BBA196D9726C202BB025','2021-01-18 11:09:56.000',NULL),
(702,'8D8BBA1BF722547E7F5D3DF','License','{\"Uid\":\"8D8BBA1BF722547E7F5D3DF\",\"ObjType\":\"License\",\"ObjId\":210,\"ObjUid\":\"8D8BBA1BF6A81FD80DE6441\",\"AddrId\":2108,\"AddrUid\":\"8D8BBA1BF718FE307418F72\",\"StartDate\":\"2021-01-18 11:11:04\",\"CreatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"CreatedOn\":\"2021-01-18 11:11:04\",\"UpdatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"UpdatedOn\":\"2021-01-18 11:11:04\"}',210,'8D8BBA1BF6A81FD80DE6441',2108,'8D8BBA1BF718FE307418F72','2021-01-18 11:11:04.000',NULL),
(703,'8D8BBA1BF726FD4E1BDE7D1','License','{\"Uid\":\"8D8BBA1BF726FD4E1BDE7D1\",\"ObjType\":\"License\",\"ObjId\":210,\"ObjUid\":\"8D8BBA1BF6A81FD80DE6441\",\"AddrId\":2109,\"AddrUid\":\"8D8BBA1BF72544DCEB4A36D\",\"StartDate\":\"2021-01-18 11:11:04\",\"CreatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"CreatedOn\":\"2021-01-18 11:11:04\",\"UpdatedBy\":\"geetha.pusapati@sttlcccsdfsdfd.com\",\"UpdatedOn\":\"2021-01-18 11:11:04\"}',210,'8D8BBA1BF6A81FD80DE6441',2109,'8D8BBA1BF72544DCEB4A36D','2021-01-18 11:11:04.000',NULL),
(704,'8D8BC63509ABF86C206E8C6','Organization','{\"Uid\":\"8D8BC63509ABF86C206E8C6\",\"ObjType\":\"Organization\",\"ObjId\":2102,\"ObjUid\":\"8D8BC635094D4D9DE5AFEC7\",\"AddrId\":2110,\"AddrUid\":\"8D8BC63509A7598BD8DEE48\",\"StartDate\":\"2021-01-19 10:16:41\",\"CreatedBy\":\"dylan@lljjuundkdfkwkwkwkw.com\",\"CreatedOn\":\"2021-01-19 10:16:41\",\"UpdatedBy\":\"dylan@lljjuundkdfkwkwkwkw.com\",\"UpdatedOn\":\"2021-01-19 10:16:41\"}',2102,'8D8BC635094D4D9DE5AFEC7',2110,'8D8BC63509A7598BD8DEE48','2021-01-19 10:16:41.000',NULL),
(705,'8D8BC63509B304CFE500A56','Organization','{\"Uid\":\"8D8BC63509B304CFE500A56\",\"ObjType\":\"Organization\",\"ObjId\":2102,\"ObjUid\":\"8D8BC635094D4D9DE5AFEC7\",\"AddrId\":2111,\"AddrUid\":\"8D8BC63509B16A7A426D9CA\",\"StartDate\":\"2021-01-19 10:16:41\",\"CreatedBy\":\"dylan@lljjuundkdfkwkwkwkw.com\",\"CreatedOn\":\"2021-01-19 10:16:41\",\"UpdatedBy\":\"dylan@lljjuundkdfkwkwkwkw.com\",\"UpdatedOn\":\"2021-01-19 10:16:41\"}',2102,'8D8BC635094D4D9DE5AFEC7',2111,'8D8BC63509B16A7A426D9CA','2021-01-19 10:16:41.000',NULL),
(706,'8D8BC63B0D163651765F4D9','Organization','{\"Uid\":\"8D8BC63B0D163651765F4D9\",\"ObjType\":\"Organization\",\"ObjId\":2103,\"ObjUid\":\"8D8BC63B0C53D8D9D9CB29A\",\"AddrId\":2112,\"AddrUid\":\"8D8BC63B0CDFC87D44B6366\",\"StartDate\":\"2021-01-19 10:19:22\",\"CreatedBy\":\"gorglllllllllllll@gma1l.com\",\"CreatedOn\":\"2021-01-19 10:19:22\",\"UpdatedBy\":\"gorglllllllllllll@gma1l.com\",\"UpdatedOn\":\"2021-01-19 10:19:22\"}',2103,'8D8BC63B0C53D8D9D9CB29A',2112,'8D8BC63B0CDFC87D44B6366','2021-01-19 10:19:22.000',NULL),
(707,'8D8BC63B0D4099E41B31CF3','Organization','{\"Uid\":\"8D8BC63B0D4099E41B31CF3\",\"ObjType\":\"Organization\",\"ObjId\":2103,\"ObjUid\":\"8D8BC63B0C53D8D9D9CB29A\",\"AddrId\":2113,\"AddrUid\":\"8D8BC63B0D3D7BF69724D8B\",\"StartDate\":\"2021-01-19 10:19:22\",\"CreatedBy\":\"gorglllllllllllll@gma1l.com\",\"CreatedOn\":\"2021-01-19 10:19:22\",\"UpdatedBy\":\"gorglllllllllllll@gma1l.com\",\"UpdatedOn\":\"2021-01-19 10:19:22\"}',2103,'8D8BC63B0C53D8D9D9CB29A',2113,'8D8BC63B0D3D7BF69724D8B','2021-01-19 10:19:22.000',NULL),
(708,'8D8BC63B6F2F65C1C6FB4F1','Organization','{\"Uid\":\"8D8BC63B6F2F65C1C6FB4F1\",\"ObjType\":\"Organization\",\"ObjId\":2104,\"ObjUid\":\"8D8BC63B6ED65B94704632F\",\"AddrId\":2114,\"AddrUid\":\"8D8BC63B6F2D7FA044000A6\",\"StartDate\":\"2021-01-19 10:19:33\",\"CreatedBy\":\"bbarnell@stewines.com\",\"CreatedOn\":\"2021-01-19 10:19:33\",\"UpdatedBy\":\"bbarnell@stewines.com\",\"UpdatedOn\":\"2021-01-19 10:19:33\"}',2104,'8D8BC63B6ED65B94704632F',2114,'8D8BC63B6F2D7FA044000A6','2021-01-19 10:19:33.000',NULL),
(709,'8D8BC63B6F340E80F5788D6','Organization','{\"Uid\":\"8D8BC63B6F340E80F5788D6\",\"ObjType\":\"Organization\",\"ObjId\":2104,\"ObjUid\":\"8D8BC63B6ED65B94704632F\",\"AddrId\":2115,\"AddrUid\":\"8D8BC63B6F32427A8184FB9\",\"StartDate\":\"2021-01-19 10:19:33\",\"CreatedBy\":\"bbarnell@stewines.com\",\"CreatedOn\":\"2021-01-19 10:19:33\",\"UpdatedBy\":\"bbarnell@stewines.com\",\"UpdatedOn\":\"2021-01-19 10:19:33\"}',2104,'8D8BC63B6ED65B94704632F',2115,'8D8BC63B6F32427A8184FB9','2021-01-19 10:19:33.000',NULL);
/*!40000 ALTER TABLE `tt_obj` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-18 12:49:04
