Here is the output of diff. Can you see where the issues are as this is confusing to me.
*** db.sql 2024-11-01 07:13:53.217530420 -0500
--- structure_dump.sql 2024-11-01 07:28:14.961074617 -0500
***************
*** 1,8 ****
! -- MariaDB dump 10.19 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64)
--
! -- Host: localhost Database: itflow_dev
! -- Server version 10.11.6-MariaDB-0+deb12u1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
--- 1,9 ----
! /*!999999\- enable the sandbox mode */
! -- MariaDB dump 10.19 Distrib 10.11.8-MariaDB, for debian-linux-gnu (x86_64)
--
! -- Host: localhost Database: itflow
! -- Server version 10.11.8-MariaDB-0ubuntu0.24.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
***************
*** 34,40 ****
\`account_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`account_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`account_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 35,41 ----
\`account_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`account_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`account_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 140,146 ****
\`interface_network_id\` int(11) DEFAULT NULL,
\`interface_asset_id\` int(11) NOT NULL,
PRIMARY KEY (\`interface_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 141,147 ----
\`interface_network_id\` int(11) DEFAULT NULL,
\`interface_asset_id\` int(11) NOT NULL,
PRIMARY KEY (\`interface_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 178,184 ****
\`asset_contact_id\` int(11) NOT NULL DEFAULT 0,
\`asset_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`asset_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 179,185 ----
\`asset_contact_id\` int(11) NOT NULL DEFAULT 0,
\`asset_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`asset_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 216,222 ****
\`calendar_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`calendar_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`calendar_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 217,223 ----
\`calendar_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`calendar_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`calendar_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 237,243 ****
\`category_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`category_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`category_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 238,244 ----
\`category_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`category_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`category_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 263,269 ****
\`certificate_domain_id\` int(11) NOT NULL DEFAULT 0,
\`certificate_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`certificate_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 264,270 ----
\`certificate_domain_id\` int(11) NOT NULL DEFAULT 0,
\`certificate_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`certificate_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 305,311 ****
\`client_archived_at\` datetime DEFAULT NULL,
\`client_accessed_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`client_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 306,312 ----
\`client_archived_at\` datetime DEFAULT NULL,
\`client_accessed_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`client_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 332,338 ****
\`company_created_at\` datetime NOT NULL DEFAULT current_timestamp(),
\`company_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (\`company_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 333,339 ----
\`company_created_at\` datetime NOT NULL DEFAULT current_timestamp(),
\`company_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
PRIMARY KEY (\`company_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 437,443 ****
\`contact_department\` varchar(200) DEFAULT NULL,
\`contact_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`contact_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 438,444 ----
\`contact_department\` varchar(200) DEFAULT NULL,
\`contact_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`contact_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 455,461 ****
\`custom_field_location\` int(11) NOT NULL DEFAULT 0,
\`custom_field_order\` int(11) NOT NULL DEFAULT 999,
PRIMARY KEY (\`custom_field_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 456,462 ----
\`custom_field_location\` int(11) NOT NULL DEFAULT 0,
\`custom_field_order\` int(11) NOT NULL DEFAULT 999,
PRIMARY KEY (\`custom_field_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 537,543 ****
\`document_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`document_id\`),
FULLTEXT KEY \`document_content_raw\` (\`document_content_raw\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 538,544 ----
\`document_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`document_id\`),
FULLTEXT KEY \`document_content_raw\` (\`document_content_raw\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 568,574 ****
\`domain_mailhost\` int(11) NOT NULL DEFAULT 0,
\`domain_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`domain_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 569,575 ----
\`domain_mailhost\` int(11) NOT NULL DEFAULT 0,
\`domain_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`domain_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 593,599 ****
\`email_attempts\` tinyint(1) NOT NULL DEFAULT 0,
\`email_sent_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`email_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 594,600 ----
\`email_attempts\` tinyint(1) NOT NULL DEFAULT 0,
\`email_sent_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`email_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 695,701 ****
\`file_asset_id\` int(11) NOT NULL DEFAULT 0,
\`file_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`file_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 696,702 ----
\`file_asset_id\` int(11) NOT NULL DEFAULT 0,
\`file_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`file_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 712,718 ****
\`folder_location\` int(11) DEFAULT 0,
\`folder_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`folder_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 713,719 ----
\`folder_location\` int(11) DEFAULT 0,
\`folder_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`folder_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 833,839 ****
\`location_contact_id\` int(11) NOT NULL DEFAULT 0,
\`location_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`location_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 834,840 ----
\`location_contact_id\` int(11) NOT NULL DEFAULT 0,
\`location_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`location_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 881,887 ****
\`login_software_id\` int(11) NOT NULL DEFAULT 0,
\`login_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`login_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 882,888 ----
\`login_software_id\` int(11) NOT NULL DEFAULT 0,
\`login_client_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`login_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 903,909 ****
\`log_user_id\` int(11) NOT NULL DEFAULT 0,
\`log_entity_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`log_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 904,910 ----
\`log_user_id\` int(11) NOT NULL DEFAULT 0,
\`log_entity_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`log_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=161474 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 918,924 ****
\`module_name\` varchar(200) NOT NULL,
\`module_description\` varchar(200) DEFAULT NULL,
PRIMARY KEY (\`module_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 919,925 ----
\`module_name\` varchar(200) NOT NULL,
\`module_description\` varchar(200) DEFAULT NULL,
PRIMARY KEY (\`module_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 969,975 ****
\`notification_user_id\` int(11) NOT NULL DEFAULT 0,
\`notification_entity_id\` int(11) DEFAULT 0,
PRIMARY KEY (\`notification_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 970,976 ----
\`notification_user_id\` int(11) NOT NULL DEFAULT 0,
\`notification_entity_id\` int(11) DEFAULT 0,
PRIMARY KEY (\`notification_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=197 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 1562,1569 ****
\`config_timezone\` varchar(200) NOT NULL DEFAULT 'America/New_York',
\`config_destructive_deletes_enable\` tinyint(1) NOT NULL DEFAULT 0,
\`config_phone_mask\` tinyint(1) NOT NULL DEFAULT 1,
- `config_whitelabel_enabled` int(11) NOT NULL DEFAULT 0,
- `config_whitelabel_key` text DEFAULT NULL,
PRIMARY KEY (\`company_id\`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--- 1563,1568 ----
***************
*** 1622,1628 ****
\`software_client_id\` int(11) NOT NULL,
\`software_template_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`software_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 1621,1627 ----
\`software_client_id\` int(11) NOT NULL,
\`software_template_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`software_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 1827,1833 ****
\`ticket_status_color\` varchar(200) NOT NULL,
\`ticket_status_active\` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (\`ticket_status_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 1826,1832 ----
\`ticket_status_color\` varchar(200) NOT NULL,
\`ticket_status_active\` tinyint(1) NOT NULL DEFAULT 1,
PRIMARY KEY (\`ticket_status_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 2015,2021 ****
\`user_role_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`user_role_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`user_role_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 2014,2020 ----
\`user_role_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`user_role_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`user_role_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 2063,2069 ****
\`user_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`user_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`user_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- 2062,2068 ----
\`user_updated_at\` datetime DEFAULT NULL ON UPDATE current_timestamp(),
\`user_archived_at\` datetime DEFAULT NULL,
PRIMARY KEY (\`user_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
***************
*** 2137,2143 ****
\`vendor_client_id\` int(11) NOT NULL DEFAULT 0,
\`vendor_template_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`vendor_id\`)
! ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
--- 2136,2142 ----
\`vendor_client_id\` int(11) NOT NULL DEFAULT 0,
\`vendor_template_id\` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (\`vendor_id\`)
! ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
***************
*** 2149,2152 ****
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
! -- Dump completed on 2024-10-30 18:39:35
--- 2148,2151 ----
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;