-- MySQL dump 10.13  Distrib 8.0.37, for Linux (aarch64)
--
-- Host: localhost    Database: stagingsugarcrm
-- ------------------------------------------------------
-- Server version	8.0.37-0ubuntu0.22.04.3

/*!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 */;
/*!50503 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 `fields_meta_data`
--

DROP TABLE IF EXISTS `fields_meta_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fields_meta_data` (
  `id` char(36) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vname` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `help` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `custom_module` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `len` int DEFAULT NULL,
  `required` tinyint(1) DEFAULT '0',
  `default_value` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_modified` datetime DEFAULT NULL,
  `deleted` tinyint(1) DEFAULT '0',
  `audited` tinyint(1) DEFAULT '0',
  `massupdate` tinyint(1) DEFAULT '0',
  `duplicate_merge` smallint DEFAULT '0',
  `reportable` tinyint(1) DEFAULT '1',
  `importable` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ext1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '',
  `ext2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '',
  `ext3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '',
  `ext4` text COLLATE utf8mb4_general_ci,
  `autoinc_next` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_fields_meta_data_custom_module_name` (`custom_module`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fields_meta_data`
--

LOCK TABLES `fields_meta_data` WRITE;
/*!40000 ALTER TABLE `fields_meta_data` DISABLE KEYS */;
INSERT INTO `fields_meta_data` VALUES ('3742d954-0b98-11ef-9165-1289808c645b','stole_building_description_c','LBL_STOLE_BUILDING_DES',NULL,NULL,'Leads','text',NULL,0,NULL,'2024-05-06 11:30:58',0,0,0,0,1,'true',NULL,'6','80',NULL,NULL),('4cf28672-1c24-11ef-aeb9-1289808c645b','job_duration_c','LBL_JOB_DURATION',NULL,NULL,'Leads','enum',100,0,NULL,'2024-05-27 12:26:10',0,0,1,1,1,'true','job_duration_list',NULL,NULL,NULL,NULL),('60b47a9e-2246-11ef-9969-1289808c645b','building_states_c','LBL_BUILDING_STATES',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-04 07:45:13',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('6e8040d0-2247-11ef-ad5c-1289808c645b','intrested_programe_c','LBL_INTRESTED_PROGRAME',NULL,NULL,'Leads','enum',100,0,NULL,'2024-06-04 07:52:46',0,0,1,1,1,'true','intrested_programe_list',NULL,NULL,NULL,NULL),('819e43ac-2246-11ef-afbb-1289808c645b','building_count_c','LBL_BUILDING_COUNT',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-04 07:46:08',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('8d63aac6-33ba-11ef-838b-1289808c645b','building_site_c','LBL_BUILDING_SITE',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-26 12:49:39',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('8ff5507a-2247-11ef-80db-1289808c645b','daytime_num_c','LBL_DAYTIME_NUM',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-04 07:53:42',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('9aafb150-2fd4-11ef-9b9c-1289808c645b','price_c','LBL_PRICE',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-21 13:46:04',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('a597d5ba-1c25-11ef-855d-1289808c645b','covering_range_c','LBL_COVERING_RANGE',NULL,NULL,'Leads','enum',100,0,NULL,'2024-05-27 12:51:47',0,0,1,1,1,'true','covering_range_list',NULL,NULL,NULL,NULL),('c80703e8-33ac-11ef-941a-1289808c645b','wherefindus_c','LBL_WHEREFINDUS',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-26 11:11:05',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('f19033c0-1c22-11ef-aa19-1289808c645b','previous_dealer_c','LBL_PREVIOUS_DEALER',NULL,NULL,'Leads','bool',NULL,0,'0','2024-05-27 12:16:27',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('f3f1dcb4-33be-11ef-90ad-1289808c645b','building_line_c','LBL_BUILDING_LINE',NULL,NULL,'Leads','varchar',255,0,NULL,'2024-06-26 13:21:09',0,0,1,1,1,'true',NULL,NULL,NULL,NULL,NULL),('fc6e0edc-1c24-11ef-8933-1289808c645b','expr_desc_c','LBL_EXPR_DESC',NULL,NULL,'Leads','text',NULL,0,NULL,'2024-05-27 12:31:04',0,0,0,1,1,'true',NULL,'4','20',NULL,NULL);
/*!40000 ALTER TABLE `fields_meta_data` 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-07-15  8:05:54
