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


--
-- Current Database: `mysql`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mysql` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `mysql`;

--
-- Table structure for table `columns_priv`
--

CREATE TABLE `columns_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Column_name` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`User`,`Db`,`Table_name`,`Column_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Column privileges';

--
-- Dumping data for table `columns_priv`
--


--
-- Table structure for table `component`
--

CREATE TABLE `component` (
  `component_id` int unsigned NOT NULL AUTO_INCREMENT,
  `component_group_id` int unsigned NOT NULL,
  `component_urn` text NOT NULL,
  PRIMARY KEY (`component_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='Components';

--
-- Dumping data for table `component`
--


--
-- Table structure for table `db`
--

CREATE TABLE `db` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Host`,`User`,`Db`),
  KEY `User` (`User`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Database privileges';

--
-- Dumping data for table `db`
--

INSERT INTO `db` VALUES ('localhost','performance_schema','mysql.session','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'),('localhost','sys','mysql.sys','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y');

--
-- Table structure for table `default_roles`
--

CREATE TABLE `default_roles` (
  `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `DEFAULT_ROLE_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '%',
  `DEFAULT_ROLE_USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`HOST`,`USER`,`DEFAULT_ROLE_HOST`,`DEFAULT_ROLE_USER`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Default roles';

--
-- Dumping data for table `default_roles`
--


--
-- Table structure for table `engine_cost`
--

CREATE TABLE `engine_cost` (
  `engine_name` varchar(64) NOT NULL,
  `device_type` int NOT NULL,
  `cost_name` varchar(64) NOT NULL,
  `cost_value` float DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` varchar(1024) DEFAULT NULL,
  `default_value` float GENERATED ALWAYS AS ((case `cost_name` when _utf8mb3'io_block_read_cost' then 1.0 when _utf8mb3'memory_block_read_cost' then 0.25 else NULL end)) VIRTUAL,
  PRIMARY KEY (`cost_name`,`engine_name`,`device_type`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `engine_cost`
--

INSERT INTO `engine_cost` (`engine_name`, `device_type`, `cost_name`, `cost_value`, `last_update`, `comment`) VALUES ('default',0,'io_block_read_cost',NULL,'2024-11-04 06:07:27',NULL),('default',0,'memory_block_read_cost',NULL,'2024-11-04 06:07:27',NULL);

--
-- Table structure for table `func`
--

CREATE TABLE `func` (
  `name` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `ret` tinyint NOT NULL DEFAULT '0',
  `dl` char(128) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `type` enum('function','aggregate') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='User defined functions';

--
-- Dumping data for table `func`
--


--
-- Table structure for table `global_grants`
--

CREATE TABLE `global_grants` (
  `USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `PRIV` char(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `WITH_GRANT_OPTION` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`USER`,`HOST`,`PRIV`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Extended global grants';

--
-- Dumping data for table `global_grants`
--

INSERT INTO `global_grants` VALUES ('debian-sys-maint','localhost','APPLICATION_PASSWORD_ADMIN','Y'),('debian-sys-maint','localhost','AUDIT_ADMIN','Y'),('debian-sys-maint','localhost','AUTHENTICATION_POLICY_ADMIN','Y'),('debian-sys-maint','localhost','BACKUP_ADMIN','Y'),('debian-sys-maint','localhost','BINLOG_ADMIN','Y'),('debian-sys-maint','localhost','BINLOG_ENCRYPTION_ADMIN','Y'),('debian-sys-maint','localhost','CLONE_ADMIN','Y'),('debian-sys-maint','localhost','CONNECTION_ADMIN','Y'),('debian-sys-maint','localhost','ENCRYPTION_KEY_ADMIN','Y'),('debian-sys-maint','localhost','FLUSH_OPTIMIZER_COSTS','Y'),('debian-sys-maint','localhost','FLUSH_STATUS','Y'),('debian-sys-maint','localhost','FLUSH_TABLES','Y'),('debian-sys-maint','localhost','FLUSH_USER_RESOURCES','Y'),('debian-sys-maint','localhost','GROUP_REPLICATION_ADMIN','Y'),('debian-sys-maint','localhost','GROUP_REPLICATION_STREAM','Y'),('debian-sys-maint','localhost','INNODB_REDO_LOG_ARCHIVE','Y'),('debian-sys-maint','localhost','INNODB_REDO_LOG_ENABLE','Y'),('debian-sys-maint','localhost','PASSWORDLESS_USER_ADMIN','Y'),('debian-sys-maint','localhost','PERSIST_RO_VARIABLES_ADMIN','Y'),('debian-sys-maint','localhost','REPLICATION_APPLIER','Y'),('debian-sys-maint','localhost','REPLICATION_SLAVE_ADMIN','Y'),('debian-sys-maint','localhost','RESOURCE_GROUP_ADMIN','Y'),('debian-sys-maint','localhost','RESOURCE_GROUP_USER','Y'),('debian-sys-maint','localhost','ROLE_ADMIN','Y'),('debian-sys-maint','localhost','SENSITIVE_VARIABLES_OBSERVER','Y'),('debian-sys-maint','localhost','SERVICE_CONNECTION_ADMIN','Y'),('debian-sys-maint','localhost','SESSION_VARIABLES_ADMIN','Y'),('debian-sys-maint','localhost','SET_USER_ID','Y'),('debian-sys-maint','localhost','SHOW_ROUTINE','Y'),('debian-sys-maint','localhost','SYSTEM_USER','Y'),('debian-sys-maint','localhost','SYSTEM_VARIABLES_ADMIN','Y'),('debian-sys-maint','localhost','TABLE_ENCRYPTION_ADMIN','Y'),('debian-sys-maint','localhost','TELEMETRY_LOG_ADMIN','Y'),('debian-sys-maint','localhost','XA_RECOVER_ADMIN','Y'),('mysql.infoschema','localhost','AUDIT_ABORT_EXEMPT','N'),('mysql.infoschema','localhost','FIREWALL_EXEMPT','N'),('mysql.infoschema','localhost','SYSTEM_USER','N'),('mysql.session','localhost','AUDIT_ABORT_EXEMPT','N'),('mysql.session','localhost','AUTHENTICATION_POLICY_ADMIN','N'),('mysql.session','localhost','BACKUP_ADMIN','N'),('mysql.session','localhost','CLONE_ADMIN','N'),('mysql.session','localhost','CONNECTION_ADMIN','N'),('mysql.session','localhost','FIREWALL_EXEMPT','N'),('mysql.session','localhost','PERSIST_RO_VARIABLES_ADMIN','N'),('mysql.session','localhost','SESSION_VARIABLES_ADMIN','N'),('mysql.session','localhost','SYSTEM_USER','N'),('mysql.session','localhost','SYSTEM_VARIABLES_ADMIN','N'),('mysql.sys','localhost','AUDIT_ABORT_EXEMPT','N'),('mysql.sys','localhost','FIREWALL_EXEMPT','N'),('mysql.sys','localhost','SYSTEM_USER','N'),('root','localhost','APPLICATION_PASSWORD_ADMIN','Y'),('root','localhost','AUDIT_ABORT_EXEMPT','Y'),('root','localhost','AUDIT_ADMIN','Y'),('root','localhost','AUTHENTICATION_POLICY_ADMIN','Y'),('root','localhost','BACKUP_ADMIN','Y'),('root','localhost','BINLOG_ADMIN','Y'),('root','localhost','BINLOG_ENCRYPTION_ADMIN','Y'),('root','localhost','CLONE_ADMIN','Y'),('root','localhost','CONNECTION_ADMIN','Y'),('root','localhost','ENCRYPTION_KEY_ADMIN','Y'),('root','localhost','FIREWALL_EXEMPT','Y'),('root','localhost','FLUSH_OPTIMIZER_COSTS','Y'),('root','localhost','FLUSH_STATUS','Y'),('root','localhost','FLUSH_TABLES','Y'),('root','localhost','FLUSH_USER_RESOURCES','Y'),('root','localhost','GROUP_REPLICATION_ADMIN','Y'),('root','localhost','GROUP_REPLICATION_STREAM','Y'),('root','localhost','INNODB_REDO_LOG_ARCHIVE','Y'),('root','localhost','INNODB_REDO_LOG_ENABLE','Y'),('root','localhost','PASSWORDLESS_USER_ADMIN','Y'),('root','localhost','PERSIST_RO_VARIABLES_ADMIN','Y'),('root','localhost','REPLICATION_APPLIER','Y'),('root','localhost','REPLICATION_SLAVE_ADMIN','Y'),('root','localhost','RESOURCE_GROUP_ADMIN','Y'),('root','localhost','RESOURCE_GROUP_USER','Y'),('root','localhost','ROLE_ADMIN','Y'),('root','localhost','SENSITIVE_VARIABLES_OBSERVER','Y'),('root','localhost','SERVICE_CONNECTION_ADMIN','Y'),('root','localhost','SESSION_VARIABLES_ADMIN','Y'),('root','localhost','SET_USER_ID','Y'),('root','localhost','SHOW_ROUTINE','Y'),('root','localhost','SYSTEM_USER','Y'),('root','localhost','SYSTEM_VARIABLES_ADMIN','Y'),('root','localhost','TABLE_ENCRYPTION_ADMIN','Y'),('root','localhost','TELEMETRY_LOG_ADMIN','Y'),('root','localhost','XA_RECOVER_ADMIN','Y'),('socomea','%','APPLICATION_PASSWORD_ADMIN','Y'),('socomea','%','AUDIT_ABORT_EXEMPT','Y'),('socomea','%','AUDIT_ADMIN','Y'),('socomea','%','AUTHENTICATION_POLICY_ADMIN','Y'),('socomea','%','BACKUP_ADMIN','Y'),('socomea','%','BINLOG_ADMIN','Y'),('socomea','%','BINLOG_ENCRYPTION_ADMIN','Y'),('socomea','%','CLONE_ADMIN','Y'),('socomea','%','CONNECTION_ADMIN','Y'),('socomea','%','ENCRYPTION_KEY_ADMIN','Y'),('socomea','%','FIREWALL_EXEMPT','Y'),('socomea','%','FLUSH_OPTIMIZER_COSTS','Y'),('socomea','%','FLUSH_STATUS','Y'),('socomea','%','FLUSH_TABLES','Y'),('socomea','%','FLUSH_USER_RESOURCES','Y'),('socomea','%','GROUP_REPLICATION_ADMIN','Y'),('socomea','%','GROUP_REPLICATION_STREAM','Y'),('socomea','%','INNODB_REDO_LOG_ARCHIVE','Y'),('socomea','%','INNODB_REDO_LOG_ENABLE','Y'),('socomea','%','PASSWORDLESS_USER_ADMIN','Y'),('socomea','%','PERSIST_RO_VARIABLES_ADMIN','Y'),('socomea','%','REPLICATION_APPLIER','Y'),('socomea','%','REPLICATION_SLAVE_ADMIN','Y'),('socomea','%','RESOURCE_GROUP_ADMIN','Y'),('socomea','%','RESOURCE_GROUP_USER','Y'),('socomea','%','ROLE_ADMIN','Y'),('socomea','%','SENSITIVE_VARIABLES_OBSERVER','Y'),('socomea','%','SERVICE_CONNECTION_ADMIN','Y'),('socomea','%','SESSION_VARIABLES_ADMIN','Y'),('socomea','%','SET_USER_ID','Y'),('socomea','%','SHOW_ROUTINE','Y'),('socomea','%','SYSTEM_USER','Y'),('socomea','%','SYSTEM_VARIABLES_ADMIN','Y'),('socomea','%','TABLE_ENCRYPTION_ADMIN','Y'),('socomea','%','TELEMETRY_LOG_ADMIN','Y'),('socomea','%','XA_RECOVER_ADMIN','Y');

--
-- Table structure for table `gtid_executed`
--

CREATE TABLE IF NOT EXISTS `gtid_executed` (
  `source_uuid` char(36) NOT NULL COMMENT 'uuid of the source where the transaction was originally executed.',
  `interval_start` bigint NOT NULL COMMENT 'First number of interval.',
  `interval_end` bigint NOT NULL COMMENT 'Last number of interval.',
  PRIMARY KEY (`source_uuid`,`interval_start`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Table structure for table `help_category`
--

CREATE TABLE `help_category` (
  `help_category_id` smallint unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `parent_category_id` smallint unsigned DEFAULT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_category_id`),
  UNIQUE KEY `name` (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='help categories';

--
-- Dumping data for table `help_category`
--

INSERT INTO `help_category` VALUES (0,'Contents',0,''),(1,'Help Metadata',0,''),(2,'Data Types',0,''),(3,'Administration',0,''),(4,'Functions',0,''),(5,'Enterprise Encryption Functions',4,''),(6,'Language Structure',0,''),(7,'Geographic Features',0,''),(8,'MBR',7,''),(9,'WKT',7,''),(10,'Comparison Operators',4,''),(11,'Logical Operators',4,''),(12,'Flow Control Functions',4,''),(13,'Numeric Functions',4,''),(14,'Date and Time Functions',4,''),(15,'String Functions',4,''),(16,'Cast Functions and Operators',4,''),(17,'XML',4,''),(18,'Bit Functions',4,''),(19,'Encryption Functions',4,''),(20,'Locking Functions',4,''),(21,'Information Functions',4,''),(22,'Spatial Functions',4,''),(23,'WKT Functions',22,''),(24,'WKB Functions',22,''),(25,'Geometry Constructors',22,''),(26,'Geometry Property Functions',22,''),(27,'Point Property Functions',22,''),(28,'LineString Property Functions',22,''),(29,'Polygon Property Functions',22,''),(30,'GeometryCollection Property Functions',22,''),(31,'Geometry Relation Functions',22,''),(32,'MBR Functions',22,''),(33,'GTID',4,''),(34,'Aggregate Functions and Modifiers',4,''),(35,'GROUP BY Functions and Modifiers',4,''),(36,'Window Functions',4,''),(37,'Performance Schema Functions',4,''),(38,'Internal Functions',4,''),(39,'Miscellaneous Functions',4,''),(40,'Data Definition',0,''),(41,'Data Manipulation',0,''),(42,'Transactions',0,''),(43,'Replication Statements',0,''),(44,'Prepared Statements',0,''),(45,'Compound Statements',0,''),(46,'Account Management',0,''),(47,'Table Maintenance',0,''),(48,'Loadable Functions',0,''),(49,'Components',0,''),(50,'Plugins',0,''),(51,'Utility',0,''),(52,'Storage Engines',0,'');

--
-- Table structure for table `help_keyword`
--

CREATE TABLE `help_keyword` (
  `help_keyword_id` int unsigned NOT NULL,
  `name` char(64) NOT NULL,
  PRIMARY KEY (`help_keyword_id`),
  UNIQUE KEY `name` (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='help keywords';

--
-- Dumping data for table `help_keyword`
--



--
-- Table structure for table `help_relation`
--

CREATE TABLE `help_relation` (
  `help_topic_id` int unsigned NOT NULL,
  `help_keyword_id` int unsigned NOT NULL,
  PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='keyword-topic relation';

--
-- Dumping data for table `help_relation`
--

INSERT INTO `help_relation` VALUES (0,0),(1,1),(2,2),(487,2),(504,2),(505,2),(512,2),(515,2),(516,2),(524,2),(525,2),(549,2),(556,2),(594,2),(612,2),(614,2),(620,2),(622,2),(2,3),(524,3),(2,4),(549,4),(556,4),(610,4),(611,4),(3,5),(702,5),(4,6),(5,7),(6,8),(7,9),(8,10),(9,11),(10,12),(11,13),(12,14),(13,15),(14,15),(13,16),(14,16),(16,17),(17,17),(16,18),(242,18),(16,19),(16,20),(20,20),(22,20),(23,20),(25,20),(26,20),(244,20),(16,21),(20,21),(22,21),(23,21),(25,21),(26,21),(18,22),(19,23),(19,24),(20,25),(20,26),(244,26),(632,26),(22,27),(23,28),(23,29),(524,29),(23,30),(24,31),(244,31),(632,31),(25,32),(26,33),(26,34),(26,35),(632,35),(28,36),(131,36),(133,36),(244,36),(30,37),(167,37),(31,38),(165,38),(244,38),(33,39),(35,39),(504,39),(505,39),(512,39),(515,39),(516,39),(524,39),(553,39),(554,39),(557,39),(640,39),(641,39),(643,39),(647,39),(33,40),(35,40),(33,41),(34,42),(34,43),(186,43),(244,43),(35,44),(35,45),(35,46),(44,47),(44,48),(53,49),(512,49),(513,49),(526,49),(612,49),(53,50),(504,50),(505,50),(506,50),(507,50),(508,50),(509,50),(510,50),(511,50),(512,50),(513,50),(514,50),(612,50),(617,50),(623,50),(53,51),(515,51),(516,51),(517,51),(518,51),(519,51),(520,51),(521,51),(522,51),(523,51),(524,51),(526,51),(527,51),(528,51),(613,51),(614,51),(624,51),(632,51),(643,51),(651,51),(652,51),(653,51),(654,51),(655,51),(656,51),(658,51),(53,52),(512,52),(518,52),(524,52),(532,52),(559,52),(643,52),(669,52),(691,52),(694,52),(53,53),(512,53),(524,53),(525,53),(549,53),(53,54),(512,54),(524,54),(537,54),(541,54),(542,54),(548,54),(550,54),(560,54),(627,54),(628,54),(629,54),(630,54),(631,54),(643,54),(656,54),(685,54),(54,55),(81,55),(55,56),(56,57),(57,58),(58,59),(59,60),(60,61),(61,62),(77,62),(61,63),(62,63),(62,64),(65,64),(68,64),(71,64),(73,64),(76,64),(234,64),(236,64),(515,64),(516,64),(517,64),(523,64),(613,64),(614,64),(63,65),(512,65),(64,66),(65,66),(515,66),(516,66),(517,66),(523,66),(529,66),(530,66),(531,66),(535,66),(536,66),(537,66),(540,66),(612,66),(613,66),(614,66),(615,66),(616,66),(619,66),(633,66),(696,66),(66,67),(67,68),(68,68),(242,68),(557,68),(646,68),(649,68),(650,68),(669,68),(679,68),(69,69),(133,69),(517,69),(612,69),(614,69),(70,70),(71,70),(72,70),(73,70),(72,71),(73,71),(525,71),(74,72),(75,73),(78,74),(523,74),(79,75),(80,76),(82,77),(595,77),(82,78),(595,78),(82,79),(574,79),(592,79),(595,79),(596,79),(599,79),(600,79),(602,79),(82,80),(595,80),(596,80),(82,81),(595,81),(83,82),(515,82),(516,82),(517,82),(523,82),(529,82),(530,82),(531,82),(535,82),(536,82),(537,82),(540,82),(596,82),(612,82),(613,82),(614,82),(615,82),(616,82),(619,82),(633,82),(696,82),(84,83),(85,84),(86,85),(87,86),(88,86),(89,87),(90,88),(91,89),(92,90),(111,90),(93,91),(94,92),(95,93),(96,94),(97,95),(98,96),(99,97),(100,98),(101,99),(102,100),(103,101),(104,102),(105,103),(106,104),(107,105),(108,106),(109,107),(110,108),(111,109),(112,110),(113,111),(114,112),(115,113),(116,114),(117,115),(118,116),(119,117),(120,118),(121,119),(122,120),(512,120),(542,120),(123,121),(124,122),(125,123),(126,124),(127,125),(128,126),(129,127),(130,128),(132,129),(133,130),(133,131),(135,131),(133,132),(136,132),(612,132),(614,132),(133,133),(133,134),(133,135),(133,136),(145,136),(133,137),(133,138),(133,139),(152,139),(133,140),(133,141),(153,141),(133,142),(159,142),(133,143),(181,143),(244,143),(133,144),(134,145),(137,146),(138,147),(139,148),(140,149),(141,150),(142,151),(143,152),(144,153),(146,154),(147,155),(148,156),(149,157),(150,158),(151,159),(154,160),(155,161),(156,162),(157,163),(158,164),(160,165),(161,166),(162,167),(163,168),(164,169),(165,170),(167,170),(216,170),(507,170),(520,170),(521,170),(533,170),(534,170),(632,170),(633,170),(643,170),(654,170),(666,170),(667,170),(166,171),(168,172),(169,173),(170,174),(171,175),(172,176),(173,177),(174,178),(175,179),(176,180),(177,181),(178,182),(179,183),(180,184),(182,185),(183,186),(184,187),(185,188),(187,189),(188,190),(189,191),(190,192),(191,193),(192,194),(193,195),(194,196),(195,197),(699,197),(700,197),(701,197),(196,198),(197,199),(198,200),(549,200),(550,200),(551,200),(199,201),(200,202),(201,203),(559,203),(202,204),(203,205),(204,206),(205,207),(206,208),(207,209),(208,210),(209,211),(210,212),(211,213),(212,214),(213,215),(214,216),(215,217),(600,217),(216,218),(523,218),(553,218),(554,218),(556,218),(612,218),(621,218),(217,219),(218,220),(559,220),(219,221),(220,222),(221,223),(222,224),(234,224),(643,224),(649,224),(650,224),(222,225),(223,226),(224,227),(225,228),(226,229),(227,230),(228,231),(228,232),(544,232),(548,232),(557,232),(643,232),(646,232),(649,232),(650,232),(669,232),(679,232),(228,233),(228,234),(228,235),(229,236),(230,237),(231,238),(232,239),(233,240),(235,241),(236,242),(237,243),(238,244),(239,245),(240,246),(241,247),(242,248),(242,249),(242,250),(242,251),(557,251),(242,252),(693,252),(242,253),(512,253),(518,253),(524,253),(612,253),(614,253),(617,253),(692,253),(243,254),(244,254),(575,254),(576,254),(644,254),(645,254),(692,254),(244,255),(244,256),(244,257),(244,258),(699,258),(700,258),(701,258),(244,259),(244,260),(245,261),(246,262),(247,263),(248,264),(249,265),(250,266),(251,267),(252,268),(253,269),(254,270),(255,271),(256,272),(257,273),(258,274),(259,275),(260,276),(260,277),(261,278),(262,279),(263,280),(264,281),(265,282),(266,283),(267,284),(268,285),(269,286),(270,287),(271,288),(272,289),(273,290),(640,290),(641,290),(274,291),(275,292),(643,292),(648,292),(276,293),(277,294),(278,295),(506,295),(517,295),(279,296),(504,296),(505,296),(515,296),(516,296),(522,296),(529,296),(530,296),(643,296),(651,296),(652,296),(280,297),(281,298),(282,299),(283,300),(284,301),(609,301),(285,302),(504,302),(505,302),(515,302),(516,302),(529,302),(530,302),(643,302),(651,302),(652,302),(286,303),(287,304),(288,305),(522,305),(584,305),(585,305),(612,305),(614,305),(616,305),(618,305),(619,305),(624,305),(658,305),(289,306),(290,307),(290,308),(291,309),(291,310),(292,311),(292,312),(293,313),(293,314),(294,315),(294,316),(295,317),(295,318),(296,319),(297,320),(297,321),(298,322),(298,323),(299,324),(299,325),(300,326),(300,327),(301,328),(301,329),(302,330),(302,331),(303,332),(303,333),(304,334),(305,335),(305,336),(306,337),(307,338),(308,339),(309,340),(310,341),(311,342),(312,343),(313,344),(314,345),(314,346),(315,347),(315,348),(316,349),(317,350),(318,351),(319,352),(320,353),(321,354),(322,355),(323,356),(324,357),(325,358),(326,359),(327,360),(328,361),(329,362),(330,363),(331,364),(332,365),(333,366),(334,367),(335,368),(336,369),(337,370),(337,371),(338,372),(339,373),(340,374),(341,375),(342,376),(343,377),(344,378),(345,379),(346,380),(347,381),(348,382),(349,383),(350,384),(351,385),(352,386),(353,387),(354,388),(355,389),(356,390),(357,391),(358,392),(359,393),(360,394),(361,395),(362,396),(363,397),(364,398),(365,399),(366,400),(367,401),(368,402),(369,403),(370,404),(371,405),(372,406),(373,407),(374,408),(375,409),(376,410),(377,411),(378,412),(379,413),(380,414),(381,415),(382,416),(383,417),(384,418),(385,419),(386,420),(387,421),(388,422),(389,423),(390,423),(389,424),(389,425),(390,426),(390,427),(390,428),(391,429),(392,430),(393,431),(394,432),(395,433),(395,434),(396,435),(397,436),(398,437),(399,438),(400,439),(401,440),(402,441),(403,442),(404,443),(405,444),(406,445),(407,446),(408,447),(409,448),(410,449),(411,450),(412,451),(413,452),(414,453),(415,454),(416,455),(417,456),(418,457),(419,458),(420,459),(421,460),(422,461),(422,462),(427,462),(428,462),(431,462),(432,462),(437,462),(546,462),(552,462),(557,462),(562,462),(423,463),(424,464),(425,465),(426,466),(427,466),(664,466),(689,466),(428,467),(557,467),(428,468),(512,468),(524,468),(544,468),(553,468),(554,468),(555,468),(557,468),(561,468),(612,468),(614,468),(428,469),(557,469),(699,469),(700,469),(701,469),(428,470),(428,471),(512,471),(544,471),(555,471),(557,471),(560,471),(561,471),(563,471),(428,472),(429,473),(430,474),(431,475),(432,476),(433,477),(434,478),(435,479),(436,480),(437,481),(438,482),(439,483),(440,484),(441,485),(442,486),(443,487),(444,488),(445,489),(446,490),(447,491),(448,492),(449,493),(450,494),(451,495),(452,496),(453,497),(454,498),(455,499),(456,500),(457,501),(458,502),(459,503),(460,504),(461,505),(462,506),(463,507),(464,508),(465,509),(466,510),(467,511),(468,512),(469,513),(470,514),(471,515),(472,516),(473,517),(474,518),(475,519),(476,520),(477,521),(478,522),(479,523),(480,524),(481,525),(482,526),(483,527),(484,528),(485,529),(486,530),(488,531),(489,532),(490,533),(491,534),(492,535),(493,536),(494,537),(495,538),(496,539),(497,540),(498,541),(499,542),(500,543),(501,544),(502,545),(503,546),(549,546),(556,546),(563,546),(504,547),(505,547),(512,547),(515,547),(516,547),(524,547),(504,548),(505,548),(512,548),(515,548),(516,548),(524,548),(504,549),(505,549),(564,549),(565,549),(566,549),(567,549),(573,549),(574,549),(504,550),(505,550),(547,550),(564,550),(565,550),(566,550),(567,550),(572,550),(573,550),(574,550),(692,550),(504,551),(505,551),(512,551),(515,551),(516,551),(524,551),(525,551),(549,551),(553,551),(554,551),(556,551),(557,551),(561,551),(564,551),(565,551),(566,551),(567,551),(578,551),(610,551),(611,551),(612,551),(620,551),(621,551),(622,551),(626,551),(639,551),(640,551),(641,551),(642,551),(643,551),(647,551),(506,552),(512,552),(517,552),(518,552),(524,552),(526,552),(612,552),(614,552),(506,553),(517,553),(506,554),(517,554),(506,555),(512,555),(517,555),(623,555),(624,555),(506,556),(517,556),(545,556),(602,556),(506,557),(512,557),(517,557),(623,557),(624,557),(506,558),(517,558),(531,558),(653,558),(506,559),(508,559),(517,559),(525,559),(559,559),(506,560),(517,560),(506,561),(512,561),(513,561),(541,561),(618,561),(506,562),(517,562),(506,563),(517,563),(583,563),(585,563),(587,563),(681,563),(683,563),(695,563),(508,564),(646,564),(690,564),(508,565),(579,565),(581,565),(582,565),(583,565),(584,565),(585,565),(586,565),(587,565),(679,565),(682,565),(683,565),(692,565),(508,566),(692,566),(508,567),(557,567),(579,567),(581,567),(582,567),(583,567),(584,567),(585,567),(586,567),(587,567),(604,567),(607,567),(608,567),(621,567),(626,567),(643,567),(679,567),(682,567),(683,567),(692,567),(699,567),(700,567),(701,567),(508,568),(524,568),(643,568),(508,569),(571,569),(508,570),(508,571),(575,571),(576,571),(577,571),(579,571),(644,571),(645,571),(670,571),(695,571),(508,572),(524,572),(525,572),(508,573),(508,574),(617,574),(508,575),(564,575),(565,575),(566,575),(567,575),(568,575),(569,575),(570,575),(574,575),(508,576),(509,577),(519,577),(526,577),(557,577),(623,577),(624,577),(625,577),(626,577),(509,578),(519,578),(526,578),(510,579),(520,579),(521,579),(533,579),(534,579),(643,579),(655,579),(674,579),(675,579),(511,580),(522,580),(511,581),(522,581),(535,581),(512,582),(512,583),(512,584),(627,584),(699,584),(700,584),(701,584),(512,585),(513,585),(524,585),(526,585),(512,586),(512,587),(524,587),(512,588),(579,588),(580,588),(581,588),(512,589),(524,589),(628,589),(512,590),(524,590),(629,590),(512,591),(512,592),(524,592),(553,592),(643,592),(649,592),(650,592),(512,593),(524,593),(512,594),(524,594),(693,594),(699,594),(700,594),(701,594),(512,595),(524,595),(512,596),(522,596),(524,596),(553,596),(512,597),(524,597),(512,598),(524,598),(512,599),(612,599),(512,600),(513,600),(529,600),(530,600),(531,600),(532,600),(533,600),(534,600),(535,600),(536,600),(537,600),(538,600),(539,600),(540,600),(590,600),(591,600),(612,600),(615,600),(616,600),(625,600),(633,600),(512,601),(513,601),(524,601),(526,601),(538,601),(643,601),(662,601),(692,601),(512,602),(512,603),(524,603),(547,603),(512,604),(522,604),(524,604),(525,604),(512,605),(518,605),(524,605),(512,606),(548,606),(553,606),(512,607),(524,607),(512,608),(518,608),(524,608),(512,609),(643,609),(669,609),(512,610),(524,610),(512,611),(557,611),(571,611),(572,611),(612,611),(614,611),(692,611),(512,612),(524,612),(512,613),(524,613),(512,614),(612,614),(512,615),(630,615),(512,616),(524,616),(512,617),(518,617),(524,617),(512,618),(524,618),(544,618),(549,618),(553,618),(556,618),(557,618),(559,618),(691,618),(694,618),(512,619),(512,620),(522,620),(584,620),(585,620),(612,620),(614,620),(621,620),(512,621),(512,622),(512,623),(512,624),(512,625),(631,625),(512,626),(524,626),(512,627),(518,627),(523,627),(536,627),(512,628),(524,628),(512,629),(524,629),(512,630),(524,630),(512,631),(513,631),(526,631),(538,631),(512,632),(624,632),(512,633),(555,633),(562,633),(512,634),(512,635),(628,635),(512,636),(518,636),(524,636),(513,637),(526,637),(513,638),(526,638),(513,639),(568,639),(569,639),(570,639),(575,639),(576,639),(579,639),(581,639),(621,639),(513,640),(526,640),(538,640),(608,640),(513,641),(526,641),(514,642),(528,642),(540,642),(517,643),(517,644),(517,645),(517,646),(518,647),(522,648),(522,649),(522,650),(522,651),(522,652),(523,653),(523,654),(523,655),(523,656),(523,657),(536,657),(523,658),(536,658),(624,658),(524,659),(525,659),(524,660),(524,661),(525,661),(537,661),(540,661),(524,662),(524,663),(524,664),(553,664),(524,665),(525,665),(544,665),(524,666),(524,667),(524,668),(643,668),(649,668),(650,668),(676,668),(686,668),(524,669),(524,670),(524,671),(524,672),(524,673),(524,674),(524,675),(524,676),(524,677),(525,677),(617,677),(524,678),(524,679),(525,680),(537,680),(540,680),(525,681),(549,681),(557,681),(561,681),(526,682),(526,683),(526,684),(526,685),(526,686),(559,686),(703,686),(527,687),(539,687),(643,687),(537,688),(543,689),(544,690),(547,690),(555,690),(557,690),(560,690),(561,690),(563,690),(646,690),(679,690),(544,691),(549,691),(553,691),(554,691),(556,691),(561,691),(572,691),(544,692),(628,692),(631,692),(544,693),(559,693),(589,693),(668,693),(544,694),(547,694),(561,694),(649,694),(650,694),(669,694),(546,695),(552,695),(557,695),(562,695),(582,695),(583,695),(612,695),(617,695),(619,695),(620,695),(622,695),(691,695),(694,695),(546,696),(555,696),(622,696),(547,697),(603,697),(547,698),(608,698),(547,699),(547,700),(547,701),(606,701),(643,701),(671,701),(547,702),(549,703),(551,703),(556,703),(549,704),(549,705),(557,705),(549,706),(553,706),(554,706),(557,706),(559,706),(561,706),(619,706),(694,706),(549,707),(555,707),(556,707),(557,707),(694,707),(549,708),(563,708),(549,709),(550,709),(555,709),(556,709),(557,709),(699,709),(700,709),(701,709),(552,710),(555,710),(553,711),(554,711),(553,712),(553,713),(553,714),(643,714),(649,714),(650,714),(553,715),(554,715),(553,716),(554,716),(553,717),(694,717),(553,718),(554,718),(572,718),(627,718),(630,718),(631,718),(692,718),(553,719),(553,720),(553,721),(554,722),(612,722),(614,722),(554,723),(557,724),(559,724),(572,724),(612,724),(614,724),(617,724),(557,725),(557,726),(557,727),(557,728),(559,728),(557,729),(557,730),(557,731),(557,732),(557,733),(557,734),(557,735),(557,736),(557,737),(557,738),(559,738),(558,739),(559,740),(559,741),(623,741),(625,741),(559,742),(559,743),(559,744),(564,745),(565,745),(566,745),(567,745),(564,746),(565,746),(566,746),(567,746),(574,746),(592,746),(564,747),(565,747),(566,747),(567,747),(564,748),(565,748),(566,748),(567,748),(574,748),(564,749),(565,749),(566,749),(567,749),(574,749),(564,750),(565,750),(566,750),(567,750),(568,750),(569,750),(570,750),(574,750),(564,751),(565,751),(566,751),(567,751),(574,751),(564,752),(565,752),(566,752),(567,752),(574,752),(584,752),(585,752),(564,753),(565,753),(566,753),(567,753),(573,753),(564,754),(565,754),(566,754),(567,754),(564,755),(565,755),(566,755),(567,755),(572,755),(573,755),(574,755),(568,756),(569,756),(570,756),(571,757),(571,758),(572,758),(612,758),(614,758),(572,759),(643,759),(671,759),(686,759),(692,759),(573,760),(573,761),(639,761),(684,761),(688,761),(573,762),(573,763),(573,764),(573,765),(573,766),(639,766),(684,766),(688,766),(573,767),(574,768),(588,768),(590,768),(591,768),(574,769),(574,770),(575,771),(576,771),(575,772),(576,772),(643,772),(644,772),(645,772),(692,772),(575,773),(576,773),(577,774),(582,774),(583,774),(695,774),(696,774),(578,775),(579,776),(581,776),(579,777),(581,777),(579,778),(579,779),(579,780),(579,781),(579,782),(579,783),(579,784),(579,785),(579,786),(579,787),(579,788),(579,789),(579,790),(579,791),(579,792),(579,793),(579,794),(579,795),(579,796),(579,797),(579,798),(579,799),(579,800),(579,801),(581,801),(579,802),(581,802),(579,803),(581,803),(579,804),(581,804),(580,805),(580,806),(580,807),(580,808),(580,809),(580,810),(580,811),(580,812),(580,813),(581,813),(617,813),(581,814),(581,815),(581,816),(581,817),(581,818),(581,819),(581,820),(581,821),(581,822),(581,823),(581,824),(581,825),(581,826),(581,827),(581,828),(581,829),(581,830),(581,831),(581,832),(581,833),(581,834),(581,835),(581,836),(581,837),(582,838),(584,838),(586,838),(682,838),(695,838),(584,839),(585,839),(584,840),(585,840),(586,840),(587,840),(584,841),(585,841),(584,842),(585,842),(584,843),(585,843),(584,844),(585,844),(584,845),(585,845),(586,845),(587,845),(586,846),(587,846),(589,847),(617,847),(590,848),(591,848),(594,849),(604,849),(607,849),(608,849),(596,850),(597,851),(598,852),(599,853),(600,854),(601,855),(602,856),(604,857),(605,858),(607,859),(608,860),(608,861),(609,862),(610,862),(611,862),(609,863),(610,863),(611,863),(609,864),(610,864),(611,864),(609,865),(610,865),(611,865),(609,866),(610,866),(611,866),(609,867),(610,867),(611,867),(609,868),(610,868),(611,868),(609,869),(609,870),(609,871),(610,871),(611,871),(609,872),(610,872),(611,872),(609,873),(609,874),(609,875),(610,875),(611,875),(609,876),(610,876),(611,876),(609,877),(610,877),(611,877),(610,878),(610,879),(611,879),(611,880),(612,881),(614,881),(612,882),(614,882),(612,883),(612,884),(614,884),(612,885),(614,885),(621,885),(612,886),(614,886),(612,887),(612,888),(614,888),(612,889),(612,890),(614,890),(612,891),(612,892),(614,892),(612,893),(614,893),(612,894),(614,894),(612,895),(614,895),(612,896),(614,896),(612,897),(614,897),(612,898),(617,898),(620,898),(622,898),(612,899),(612,900),(614,900),(612,901),(614,901),(612,902),(614,902),(621,902),(612,903),(612,904),(614,904),(612,905),(621,905),(612,906),(614,906),(612,907),(613,907),(614,907),(615,907),(617,907),(620,907),(622,907),(612,908),(614,908),(612,909),(614,909),(612,910),(614,910),(612,911),(612,912),(614,912),(614,913),(614,914),(617,915),(617,916),(617,917),(617,918),(619,918),(617,919),(619,919),(617,920),(619,920),(673,920),(692,920),(617,921),(617,922),(698,922),(617,923),(617,924),(619,925),(619,926),(619,927),(623,928),(624,928),(625,928),(626,928),(623,929),(624,929),(623,930),(624,930),(627,931),(630,931),(631,931),(692,931),(628,932),(628,933),(631,934),(649,934),(650,934),(669,934),(686,934),(631,935),(632,936),(632,937),(632,938),(632,939),(634,940),(636,940),(634,941),(635,941),(635,942),(637,942),(643,942),(636,943),(637,943),(638,944),(639,945),(696,945),(639,946),(639,947),(642,948),(643,949),(660,949),(661,949),(643,950),(663,950),(643,951),(664,951),(643,952),(668,952),(643,953),(681,953),(692,953),(643,954),(643,955),(662,955),(643,956),(676,956),(643,957),(660,957),(661,957),(643,958),(644,958),(645,958),(646,958),(647,958),(648,958),(649,958),(650,958),(651,958),(652,958),(653,958),(654,958),(655,958),(656,958),(658,958),(660,958),(661,958),(662,958),(663,958),(664,958),(665,958),(666,958),(667,958),(668,958),(669,958),(670,958),(671,958),(672,958),(673,958),(674,958),(675,958),(676,958),(677,958),(678,958),(679,958),(680,958),(681,958),(682,958),(683,958),(684,958),(685,958),(686,958),(687,958),(688,958),(689,958),(643,959),(662,959),(667,959),(670,959),(675,959),(682,959),(683,959),(684,959),(685,959),(692,959),(643,960),(687,960),(643,961),(688,961),(643,962),(689,962),(646,963),(665,963),(679,963),(663,964),(666,965),(674,965),(672,966),(677,967),(678,968),(679,969),(680,970),(691,971),(694,971),(692,972),(692,973),(692,974),(692,975),(692,976),(692,977),(692,978),(693,979),(694,980),(697,981),(699,982),(700,982),(701,982),(699,983),(700,983),(701,983),(699,984),(700,984),(701,984),(699,985),(700,985),(701,985);

--
-- Table structure for table `help_topic`
--

CREATE TABLE `help_topic` (
  `help_topic_id` int unsigned NOT NULL,
  `name` char(64) NOT NULL,
  `help_category_id` smallint unsigned NOT NULL,
  `description` text NOT NULL,
  `example` text NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY (`help_topic_id`),
  UNIQUE KEY `name` (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='help topics';

--
-- Dumping data for table `help_topic`
--




--
-- Dumping data for table `innodb_index_stats`
--

INSERT  IGNORE INTO `innodb_index_stats` VALUES ('mysql','component','PRIMARY','2025-01-31 06:09:26','n_diff_pfx01',0,1,'component_id'),('mysql','component','PRIMARY','2025-01-31 06:09:26','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('mysql','component','PRIMARY','2025-01-31 06:09:26','size',1,NULL,'Number of pages in the index'),('socomea','events','PRIMARY','2025-01-29 21:31:17','n_diff_pfx01',9,1,'id'),('socomea','events','PRIMARY','2025-01-29 21:31:17','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('socomea','events','PRIMARY','2025-01-29 21:31:17','size',1,NULL,'Number of pages in the index'),('socomea','users','PRIMARY','2025-01-29 22:06:32','n_diff_pfx01',4,1,'id'),('socomea','users','PRIMARY','2025-01-29 22:06:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('socomea','users','PRIMARY','2025-01-29 22:06:32','size',1,NULL,'Number of pages in the index'),('socomea','users','email','2025-01-29 22:06:32','n_diff_pfx01',4,1,'email'),('socomea','users','email','2025-01-29 22:06:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('socomea','users','email','2025-01-29 22:06:32','size',1,NULL,'Number of pages in the index'),('socomea','users','phone','2025-01-29 22:06:32','n_diff_pfx01',4,1,'phone'),('socomea','users','phone','2025-01-29 22:06:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('socomea','users','phone','2025-01-29 22:06:32','size',1,NULL,'Number of pages in the index'),('socomea','users','username','2025-01-29 22:06:32','n_diff_pfx01',4,1,'username'),('socomea','users','username','2025-01-29 22:06:32','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('socomea','users','username','2025-01-29 22:06:32','size',1,NULL,'Number of pages in the index'),('sys','sys_config','PRIMARY','2024-11-04 06:07:28','n_diff_pfx01',6,1,'variable'),('sys','sys_config','PRIMARY','2024-11-04 06:07:28','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('sys','sys_config','PRIMARY','2024-11-04 06:07:28','size',1,NULL,'Number of pages in the index');

--
-- Dumping data for table `innodb_table_stats`
--

INSERT  IGNORE INTO `innodb_table_stats` VALUES ('mysql','component','2025-01-31 06:09:26',0,1,0),('socomea','events','2025-01-29 21:31:17',9,1,0),('socomea','users','2025-01-29 22:06:32',4,1,3),('sys','sys_config','2024-11-04 06:07:28',6,1,0);

--
-- Table structure for table `password_history`
--

CREATE TABLE `password_history` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Password_timestamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `Password` text COLLATE utf8mb3_bin,
  PRIMARY KEY (`Host`,`User`,`Password_timestamp` DESC)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Password history for user accounts';

--
-- Dumping data for table `password_history`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--

INSERT INTO `plugin` VALUES ('auth_socket','auth_socket.so');

--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8mb3_bin NOT NULL,
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Db`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Proxied_host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Proxied_user` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'boot@','2024-11-04 06:07:27');

--
-- Table structure for table `replication_asynchronous_connection_failover`
--

CREATE TABLE `replication_asynchronous_connection_failover` (
  `Channel_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The source hostname that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Port` int unsigned NOT NULL COMMENT 'The source port that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Network_namespace` char(64) NOT NULL COMMENT 'The source network namespace that the replica will attempt to switch over the replication connection to in case of a failure. If its value is empty, connections use the default (global) namespace.',
  `Weight` tinyint unsigned NOT NULL COMMENT 'The order in which the replica shall try to switch the connection over to when there are failures. Weight can be set to a number between 1 and 100, where 100 is the highest weight and 1 the lowest.',
  `Managed_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the group which this server belongs to.',
  PRIMARY KEY (`Channel_name`,`Host`,`Port`,`Network_namespace`,`Managed_name`),
  KEY `Channel_name` (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover`
--


--
-- Table structure for table `replication_asynchronous_connection_failover_managed`
--

CREATE TABLE `replication_asynchronous_connection_failover_managed` (
  `Channel_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Managed_name` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the source which needs to be managed.',
  `Managed_type` char(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT 'Determines the managed type.',
  `Configuration` json DEFAULT NULL COMMENT 'The data to help manage group. For Managed_type = GroupReplication, Configuration value should contain {"Primary_weight": 80, "Secondary_weight": 60}, so that it assigns weight=80 to PRIMARY of the group, and weight=60 for rest of the members in mysql.replication_asynchronous_connection_failover table.',
  PRIMARY KEY (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The managed source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover_managed`
--


--
-- Table structure for table `replication_group_configuration_version`
--

CREATE TABLE `replication_group_configuration_version` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The configuration name.',
  `version` bigint unsigned NOT NULL COMMENT 'The version of the configuration name.',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The group configuration version.';

--
-- Dumping data for table `replication_group_configuration_version`
--

INSERT INTO `replication_group_configuration_version` VALUES ('replication_group_member_actions',1);

--
-- Table structure for table `replication_group_member_actions`
--

CREATE TABLE `replication_group_member_actions` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action name.',
  `event` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The event that will trigger the action.',
  `enabled` tinyint(1) NOT NULL COMMENT 'Whether the action is enabled.',
  `type` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action type.',
  `priority` tinyint unsigned NOT NULL COMMENT 'The order on which the action will be run, value between 1 and 100, lower values first.',
  `error_handling` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'On errors during the action will be handled: IGNORE, CRITICAL.',
  PRIMARY KEY (`name`,`event`),
  KEY `event` (`event`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The member actions configuration.';

--
-- Dumping data for table `replication_group_member_actions`
--

INSERT INTO `replication_group_member_actions` VALUES ('mysql_disable_super_read_only_if_primary','AFTER_PRIMARY_ELECTION',1,'INTERNAL',1,'IGNORE'),('mysql_start_failover_channels_if_primary','AFTER_PRIMARY_ELECTION',1,'INTERNAL',10,'CRITICAL');

--
-- Table structure for table `role_edges`
--

CREATE TABLE `role_edges` (
  `FROM_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `FROM_USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `TO_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `TO_USER` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `WITH_ADMIN_OPTION` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`FROM_HOST`,`FROM_USER`,`TO_HOST`,`TO_USER`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Role hierarchy and role grants';

--
-- Dumping data for table `role_edges`
--


--
-- Table structure for table `server_cost`
--

CREATE TABLE `server_cost` (
  `cost_name` varchar(64) NOT NULL,
  `cost_value` float DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` varchar(1024) DEFAULT NULL,
  `default_value` float GENERATED ALWAYS AS ((case `cost_name` when _utf8mb3'disk_temptable_create_cost' then 20.0 when _utf8mb3'disk_temptable_row_cost' then 0.5 when _utf8mb3'key_compare_cost' then 0.05 when _utf8mb3'memory_temptable_create_cost' then 1.0 when _utf8mb3'memory_temptable_row_cost' then 0.1 when _utf8mb3'row_evaluate_cost' then 0.1 else NULL end)) VIRTUAL,
  PRIMARY KEY (`cost_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `server_cost`
--

INSERT INTO `server_cost` (`cost_name`, `cost_value`, `last_update`, `comment`) VALUES ('disk_temptable_create_cost',NULL,'2024-11-04 06:07:27',NULL),('disk_temptable_row_cost',NULL,'2024-11-04 06:07:27',NULL),('key_compare_cost',NULL,'2024-11-04 06:07:27',NULL),('memory_temptable_create_cost',NULL,'2024-11-04 06:07:27',NULL),('memory_temptable_row_cost',NULL,'2024-11-04 06:07:27',NULL),('row_evaluate_cost',NULL,'2024-11-04 06:07:27',NULL);

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `slave_master_info`
--

CREATE TABLE IF NOT EXISTS `slave_master_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.',
  `User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.',
  `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  `Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version',
  `Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.',
  `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
  `Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.',
  `Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.',
  `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
  `Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
  `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
  `Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information';

--
-- Table structure for table `slave_relay_log_info`
--

CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
  `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
  `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
  `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
  `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
  `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
  `Number_of_workers` int unsigned DEFAULT NULL,
  `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
  `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
  `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
  `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
  `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
  `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information';

--
-- Table structure for table `slave_worker_info`
--

CREATE TABLE `slave_worker_info` (
  `Id` int unsigned NOT NULL,
  `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Relay_log_pos` bigint unsigned NOT NULL,
  `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Master_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
  `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_seqno` int unsigned NOT NULL,
  `Checkpoint_group_size` int unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL,
  `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
  PRIMARY KEY (`Channel_name`,`Id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information';

--
-- Dumping data for table `slave_worker_info`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Grantor` varchar(288) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`User`,`Db`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` VALUES ('localhost','mysql','mysql.session','user','boot@','2024-11-04 06:07:28','Select',''),('localhost','sys','mysql.sys','sys_config','root@localhost','2024-11-04 06:07:28','Select','');

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint NOT NULL,
  `Correction` int NOT NULL,
  PRIMARY KEY (`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_time` bigint NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  `Offset` int NOT NULL DEFAULT '0',
  `Is_DST` tinyint unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int unsigned NOT NULL DEFAULT '0',
  `max_updates` int unsigned NOT NULL DEFAULT '0',
  `max_connections` int unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8mb3_bin NOT NULL DEFAULT 'caching_sha2_password',
  `authentication_string` text COLLATE utf8mb3_bin,
  `password_expired` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `password_last_changed` timestamp NULL DEFAULT NULL,
  `password_lifetime` smallint unsigned DEFAULT NULL,
  `account_locked` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Create_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Drop_role_priv` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'N',
  `Password_reuse_history` smallint unsigned DEFAULT NULL,
  `Password_reuse_time` smallint unsigned DEFAULT NULL,
  `Password_require_current` enum('N','Y') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `User_attributes` json DEFAULT NULL,
  PRIMARY KEY (`Host`,`User`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('%','socomea','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'caching_sha2_password','$A$005$+u&j8z32>%cb`|=<SasdvuASlwci3eKLUTMS9ZENEfm8rz1Hf.lbvYKfiBJ4','N','2024-11-04 07:20:29',NULL,'N','Y','Y',NULL,NULL,NULL,NULL),('localhost','debian-sys-maint','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'caching_sha2_password','$A$005$EfZG^UB_PM_hRPmlsHiecaSMYvIUmUnY/oGA7u.Rz3kDCGsK8kv/03D','N','2024-11-04 06:07:28',NULL,'N','Y','Y',NULL,NULL,NULL,NULL),('localhost','mysql.infoschema','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2024-11-04 06:07:28',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.session','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2024-11-04 06:07:28',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.sys','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2024-11-04 06:07:28',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'auth_socket','','N','2024-11-04 06:07:27',NULL,'N','Y','Y',NULL,NULL,NULL,NULL);

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_id` bigint unsigned NOT NULL,
  `server_id` int unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumblob NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `query_time` time(6) NOT NULL,
  `lock_time` time(6) NOT NULL,
  `rows_sent` int NOT NULL,
  `rows_examined` int NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int NOT NULL,
  `insert_id` int NOT NULL,
  `server_id` int unsigned NOT NULL,
  `sql_text` mediumblob NOT NULL,
  `thread_id` bigint unsigned NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='Slow log';

--
-- Current Database: `socomea`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `socomea` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `socomea`;

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `created_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `event_desc` text,
  `event_dropdown` text,
  `color` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` VALUES (5,'vince','2025-01-29 18:53:13','asdfasdf','Chore','green'),(6,'vince','2025-01-29 18:55:23','a','Chore','green'),(7,'vince','2025-01-29 18:55:33','b','Chore','red'),(8,'Vince','2025-01-29 19:27:31','workout completed ','Exercise','green'),(9,'Vince','2025-01-29 19:29:02','extra ordinary ','Dose','green'),(10,'Tabitha','2025-01-29 19:33:32','Vince vincy Vince Vince','Argument','red'),(11,'Vince','2025-01-29 19:41:46','Tabi','Argument','red'),(12,'Vince','2025-01-29 21:29:38','got here','Exercise','green'),(13,'testaccount','2025-01-29 21:31:17','Fromt test','Dose','red'),(14,'vince','2025-01-29 22:04:41','he','Exercise','green'),(15,'vince','2025-01-29 22:36:54','garbage','Chore','red');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `firstName` text NOT NULL,
  `lastName` text NOT NULL,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `password` text NOT NULL,
  `social_facebook` text,
  `social_instagram` text,
  `social_linkedin` text,
  `social_pinterest` text,
  `social_reddit` text,
  `social_snapchat` text,
  `social_tiktok` text,
  `social_twitter_x` text,
  `social_whatsapp` text,
  `social_youtube` text,
  `email_verified` tinyint(1) NOT NULL DEFAULT '0',
  `phone_verified` tinyint(1) NOT NULL DEFAULT '0',
  `created_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`(255)),
  UNIQUE KEY `email` (`email`(255)),
  UNIQUE KEY `phone` (`phone`(255))
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--




