-- MySQL dump 10.13 Distrib 8.0.24, for macos11 (x86_64) -- -- Host: nearbeach-application.mysql.database.azure.com Database: nearbeach_production -- ------------------------------------------------------ -- Server version 8.0.32 /*!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 utf8 */; /*!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 `auth_group` -- DROP TABLE IF EXISTS `auth_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group` -- LOCK TABLES `auth_group` WRITE; /*!40000 ALTER TABLE `auth_group` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_group_permissions` -- DROP TABLE IF EXISTS `auth_group_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_group_permissions` ( `id` int NOT NULL AUTO_INCREMENT, `group_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`), KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_group_permissions` -- LOCK TABLES `auth_group_permissions` WRITE; /*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_permission` -- DROP TABLE IF EXISTS `auth_permission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_permission` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `content_type_id` int NOT NULL, `codename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`), CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_permission` -- LOCK TABLES `auth_permission` WRITE; /*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user` -- DROP TABLE IF EXISTS `auth_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user` ( `id` int NOT NULL AUTO_INCREMENT, `password` varchar(128) NOT NULL, `last_login` datetime(6) DEFAULT NULL, `is_superuser` tinyint(1) NOT NULL, `username` varchar(150) NOT NULL, `first_name` varchar(150) NOT NULL, `last_name` varchar(150) NOT NULL, `email` varchar(254) NOT NULL, `is_staff` tinyint(1) NOT NULL, `is_active` tinyint(1) NOT NULL, `date_joined` datetime(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user` -- LOCK TABLES `auth_user` WRITE; /*!40000 ALTER TABLE `auth_user` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_groups` -- DROP TABLE IF EXISTS `auth_user_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_groups` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `group_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`), KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`), CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_groups` -- LOCK TABLES `auth_user_groups` WRITE; /*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_user_user_permissions` -- DROP TABLE IF EXISTS `auth_user_user_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_user_user_permissions` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL, `permission_id` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`), KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`), CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`), CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_user_user_permissions` -- LOCK TABLES `auth_user_user_permissions` WRITE; /*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_admin_log` -- DROP TABLE IF EXISTS `django_admin_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_admin_log` ( `id` int NOT NULL AUTO_INCREMENT, `action_time` datetime(6) NOT NULL, `object_id` longtext, `object_repr` varchar(200) NOT NULL, `action_flag` smallint unsigned NOT NULL, `change_message` longtext NOT NULL, `content_type_id` int DEFAULT NULL, `user_id` int NOT NULL, PRIMARY KEY (`id`), KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`), KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`), CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_admin_log` -- LOCK TABLES `django_admin_log` WRITE; /*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */; /*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_content_type` -- DROP TABLE IF EXISTS `django_content_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_content_type` ( `id` int NOT NULL AUTO_INCREMENT, `app_label` varchar(100) NOT NULL, `model` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_content_type` -- LOCK TABLES `django_content_type` WRITE; /*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */; /*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_migrations` -- DROP TABLE IF EXISTS `django_migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_migrations` ( `id` int NOT NULL AUTO_INCREMENT, `app` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `applied` datetime(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_migrations` -- LOCK TABLES `django_migrations` WRITE; /*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */; /*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `django_session` -- DROP TABLE IF EXISTS `django_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `django_session` ( `session_key` varchar(40) NOT NULL, `session_data` longtext NOT NULL, `expire_date` datetime(6) NOT NULL, PRIMARY KEY (`session_key`), KEY `django_session_expire_date_a5c62663` (`expire_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `django_session` -- LOCK TABLES `django_session` WRITE; /*!40000 ALTER TABLE `django_session` DISABLE KEYS */; /*!40000 ALTER TABLE `django_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_bug` -- DROP TABLE IF EXISTS `nearbeach_bug`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_bug` ( `bug_id` bigint NOT NULL AUTO_INCREMENT, `bug_code` varchar(255) NOT NULL, `bug_description` longtext NOT NULL, `bug_status` varchar(50) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `bug_client_id` bigint NOT NULL, `change_user_id` int NOT NULL, `project_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, PRIMARY KEY (`bug_id`), KEY `NearBeach_bug_bug_client_id_8085c86a_fk_NearBeach` (`bug_client_id`), KEY `NearBeach_bug_change_user_id_9debd1af_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_bug_project_id_0597aff0_fk_NearBeach` (`project_id`), KEY `NearBeach_bug_requirement_id_e8e7eec9_fk_NearBeach` (`requirement_id`), KEY `NearBeach_bug_task_id_180121f8_fk_NearBeach_task_task_id` (`task_id`), CONSTRAINT `NearBeach_bug_bug_client_id_8085c86a_fk_NearBeach` FOREIGN KEY (`bug_client_id`) REFERENCES `nearbeach_bugclient` (`bug_client_id`), CONSTRAINT `NearBeach_bug_change_user_id_9debd1af_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_bug_project_id_0597aff0_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_bug_requirement_id_e8e7eec9_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_bug_task_id_180121f8_fk_NearBeach_task_task_id` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_bug` -- LOCK TABLES `nearbeach_bug` WRITE; /*!40000 ALTER TABLE `nearbeach_bug` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_bug` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_bugclient` -- DROP TABLE IF EXISTS `nearbeach_bugclient`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_bugclient` ( `bug_client_id` bigint NOT NULL AUTO_INCREMENT, `bug_client_name` varchar(50) NOT NULL, `bug_client_url` varchar(200) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `list_of_bug_client_id` bigint NOT NULL, PRIMARY KEY (`bug_client_id`), KEY `NearBeach_bugclient_change_user_id_0e499ba0_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_bugclient_list_of_bug_client_i_76304976_fk_NearBeach` (`list_of_bug_client_id`), CONSTRAINT `NearBeach_bugclient_change_user_id_0e499ba0_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_bugclient_list_of_bug_client_i_76304976_fk_NearBeach` FOREIGN KEY (`list_of_bug_client_id`) REFERENCES `nearbeach_listofbugclient` (`list_of_bug_client_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_bugclient` -- LOCK TABLES `nearbeach_bugclient` WRITE; /*!40000 ALTER TABLE `nearbeach_bugclient` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_bugclient` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_changetask` -- DROP TABLE IF EXISTS `nearbeach_changetask`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_changetask` ( `change_task_id` bigint NOT NULL AUTO_INCREMENT, `change_task_title` varchar(255) NOT NULL, `change_task_description` longtext, `change_task_start_date` datetime(6) NOT NULL, `change_task_end_date` datetime(6) NOT NULL, `change_task_seconds` bigint NOT NULL, `change_task_required_by` varchar(255) NOT NULL, `change_task_status` int NOT NULL, `is_downtime` tinyint(1) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_task_assigned_user_id` int NOT NULL, `change_task_qa_user_id` int NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `request_for_change_id` bigint NOT NULL, PRIMARY KEY (`change_task_id`), KEY `NearBeach_changetask_request_for_change_i_fc8ae87c_fk_NearBeach` (`request_for_change_id`), KEY `NearBeach_changetask_change_task_assigned_8358d2ef_fk_auth_user` (`change_task_assigned_user_id`), KEY `NearBeach_changetask_change_task_qa_user__8c11c582_fk_auth_user` (`change_task_qa_user_id`), KEY `NearBeach_changetask_change_user_id_04e2d99c_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_changetask_creation_user_id_84fb2709_fk_auth_user_id` (`creation_user_id`), CONSTRAINT `NearBeach_changetask_change_task_assigned_8358d2ef_fk_auth_user` FOREIGN KEY (`change_task_assigned_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_changetask_change_task_qa_user__8c11c582_fk_auth_user` FOREIGN KEY (`change_task_qa_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_changetask_change_user_id_04e2d99c_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_changetask_creation_user_id_84fb2709_fk_auth_user_id` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_changetask_request_for_change_i_fc8ae87c_fk_NearBeach` FOREIGN KEY (`request_for_change_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_changetask` -- LOCK TABLES `nearbeach_changetask` WRITE; /*!40000 ALTER TABLE `nearbeach_changetask` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_changetask` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_changetaskblock` -- DROP TABLE IF EXISTS `nearbeach_changetaskblock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_changetaskblock` ( `change_task_block_id` bigint NOT NULL AUTO_INCREMENT, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `blocked_change_task_id` bigint NOT NULL, `change_task_blocks_id` bigint NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, PRIMARY KEY (`change_task_block_id`), KEY `NearBeach_changetask_blocked_change_task__c3fa35f1_fk_NearBeach` (`blocked_change_task_id`), KEY `NearBeach_changetask_change_task_blocks_i_0f6c143e_fk_NearBeach` (`change_task_blocks_id`), KEY `NearBeach_changetask_change_user_id_248537b4_fk_auth_user` (`change_user_id`), KEY `NearBeach_changetask_creation_user_id_22c67ef4_fk_auth_user` (`creation_user_id`), CONSTRAINT `NearBeach_changetask_blocked_change_task__c3fa35f1_fk_NearBeach` FOREIGN KEY (`blocked_change_task_id`) REFERENCES `nearbeach_changetask` (`change_task_id`), CONSTRAINT `NearBeach_changetask_change_task_blocks_i_0f6c143e_fk_NearBeach` FOREIGN KEY (`change_task_blocks_id`) REFERENCES `nearbeach_changetask` (`change_task_id`), CONSTRAINT `NearBeach_changetask_change_user_id_248537b4_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_changetask_creation_user_id_22c67ef4_fk_auth_user` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_changetaskblock` -- LOCK TABLES `nearbeach_changetaskblock` WRITE; /*!40000 ALTER TABLE `nearbeach_changetaskblock` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_changetaskblock` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_customer` -- DROP TABLE IF EXISTS `nearbeach_customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_customer` ( `customer_id` bigint NOT NULL AUTO_INCREMENT, `customer_first_name` varchar(50) NOT NULL, `customer_last_name` varchar(50) NOT NULL, `customer_email` varchar(200) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `customer_profile_picture_id` char(32) DEFAULT NULL, `customer_title_id` bigint NOT NULL, `organisation_id` bigint DEFAULT NULL, PRIMARY KEY (`customer_id`), KEY `NearBeach_customer_customer_profile_pic_a538a055_fk_NearBeach` (`customer_profile_picture_id`), KEY `NearBeach_customer_customer_title_id_30c6019e_fk_NearBeach` (`customer_title_id`), KEY `NearBeach_customer_organisation_id_421fb20c_fk_NearBeach` (`organisation_id`), KEY `NearBeach_customer_change_user_id_f9ba5726_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_customer_change_user_id_f9ba5726_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_customer_customer_profile_pic_a538a055_fk_NearBeach` FOREIGN KEY (`customer_profile_picture_id`) REFERENCES `nearbeach_document` (`document_key`), CONSTRAINT `NearBeach_customer_customer_title_id_30c6019e_fk_NearBeach` FOREIGN KEY (`customer_title_id`) REFERENCES `nearbeach_listoftitle` (`title_id`), CONSTRAINT `NearBeach_customer_organisation_id_421fb20c_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_customer` -- LOCK TABLES `nearbeach_customer` WRITE; /*!40000 ALTER TABLE `nearbeach_customer` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_document` -- DROP TABLE IF EXISTS `nearbeach_document`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_document` ( `document_key` char(32) NOT NULL, `document_description` varchar(255) NOT NULL, `document_url_location` longtext, `document` varchar(100) DEFAULT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, PRIMARY KEY (`document_key`), KEY `NearBeach_document_change_user_id_6cb3ac66_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_document_change_user_id_6cb3ac66_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_document` -- LOCK TABLES `nearbeach_document` WRITE; /*!40000 ALTER TABLE `nearbeach_document` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_document` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_documentpermission` -- DROP TABLE IF EXISTS `nearbeach_documentpermission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_documentpermission` ( `document_permisssion_id` bigint NOT NULL AUTO_INCREMENT, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `customer_id` bigint DEFAULT NULL, `document_key_id` char(32) NOT NULL, `folder_id` bigint DEFAULT NULL, `organisation_id` bigint DEFAULT NULL, `project_id` bigint DEFAULT NULL, `request_for_change_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `requirement_item_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, `user_id` int DEFAULT NULL, `kanban_card_id` bigint DEFAULT NULL, PRIMARY KEY (`document_permisssion_id`), KEY `NearBeach_documentpe_change_user_id_da280256_fk_auth_user` (`change_user_id`), KEY `NearBeach_documentpe_customer_id_849cb1a2_fk_NearBeach` (`customer_id`), KEY `NearBeach_documentpe_document_key_id_5af67eca_fk_NearBeach` (`document_key_id`), KEY `NearBeach_documentpe_folder_id_2e5e3b4b_fk_NearBeach` (`folder_id`), KEY `NearBeach_documentpe_organisation_id_107cfcd9_fk_NearBeach` (`organisation_id`), KEY `NearBeach_documentpe_project_id_08045cab_fk_NearBeach` (`project_id`), KEY `NearBeach_documentpe_request_for_change_i_a16769de_fk_NearBeach` (`request_for_change_id`), KEY `NearBeach_documentpe_requirement_id_c26dbb3c_fk_NearBeach` (`requirement_id`), KEY `NearBeach_documentpe_requirement_item_id_57a55500_fk_NearBeach` (`requirement_item_id`), KEY `NearBeach_documentpe_task_id_299f86ae_fk_NearBeach` (`task_id`), KEY `NearBeach_documentpermission_user_id_0d037eff_fk_auth_user_id` (`user_id`), KEY `NearBeach_documentpe_kanban_card_id_0fe93731_fk_NearBeach` (`kanban_card_id`), CONSTRAINT `NearBeach_documentpe_change_user_id_da280256_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_documentpe_customer_id_849cb1a2_fk_NearBeach` FOREIGN KEY (`customer_id`) REFERENCES `nearbeach_customer` (`customer_id`), CONSTRAINT `NearBeach_documentpe_document_key_id_5af67eca_fk_NearBeach` FOREIGN KEY (`document_key_id`) REFERENCES `nearbeach_document` (`document_key`), CONSTRAINT `NearBeach_documentpe_folder_id_2e5e3b4b_fk_NearBeach` FOREIGN KEY (`folder_id`) REFERENCES `nearbeach_folder` (`folder_id`), CONSTRAINT `NearBeach_documentpe_kanban_card_id_0fe93731_fk_NearBeach` FOREIGN KEY (`kanban_card_id`) REFERENCES `nearbeach_kanbancard` (`kanban_card_id`), CONSTRAINT `NearBeach_documentpe_organisation_id_107cfcd9_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_documentpe_project_id_08045cab_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_documentpe_request_for_change_i_a16769de_fk_NearBeach` FOREIGN KEY (`request_for_change_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`), CONSTRAINT `NearBeach_documentpe_requirement_id_c26dbb3c_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_documentpe_requirement_item_id_57a55500_fk_NearBeach` FOREIGN KEY (`requirement_item_id`) REFERENCES `nearbeach_requirementitem` (`requirement_item_id`), CONSTRAINT `NearBeach_documentpe_task_id_299f86ae_fk_NearBeach` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`), CONSTRAINT `NearBeach_documentpermission_user_id_0d037eff_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_documentpermission` -- LOCK TABLES `nearbeach_documentpermission` WRITE; /*!40000 ALTER TABLE `nearbeach_documentpermission` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_documentpermission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_folder` -- DROP TABLE IF EXISTS `nearbeach_folder`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_folder` ( `folder_id` bigint NOT NULL AUTO_INCREMENT, `folder_description` varchar(255) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `customer_id` bigint DEFAULT NULL, `organisation_id` bigint DEFAULT NULL, `parent_folder_id` bigint DEFAULT NULL, `project_id` bigint DEFAULT NULL, `request_for_change_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `requirement_item_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, `kanban_card_id` bigint DEFAULT NULL, PRIMARY KEY (`folder_id`), KEY `NearBeach_folder_change_user_id_ecb3f31e_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_folder_customer_id_1445d49a_fk_NearBeach` (`customer_id`), KEY `NearBeach_folder_organisation_id_146087e1_fk_NearBeach` (`organisation_id`), KEY `NearBeach_folder_parent_folder_id_a685812e_fk_NearBeach` (`parent_folder_id`), KEY `NearBeach_folder_project_id_ab53d226_fk_NearBeach` (`project_id`), KEY `NearBeach_folder_request_for_change_i_707b3751_fk_NearBeach` (`request_for_change_id`), KEY `NearBeach_folder_requirement_id_d3d96ecd_fk_NearBeach` (`requirement_id`), KEY `NearBeach_folder_requirement_item_id_c2de263d_fk_NearBeach` (`requirement_item_id`), KEY `NearBeach_folder_task_id_de4c21e4_fk_NearBeach_task_task_id` (`task_id`), KEY `NearBeach_folder_kanban_card_id_f2156263_fk_NearBeach` (`kanban_card_id`), CONSTRAINT `NearBeach_folder_change_user_id_ecb3f31e_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_folder_customer_id_1445d49a_fk_NearBeach` FOREIGN KEY (`customer_id`) REFERENCES `nearbeach_customer` (`customer_id`), CONSTRAINT `NearBeach_folder_kanban_card_id_f2156263_fk_NearBeach` FOREIGN KEY (`kanban_card_id`) REFERENCES `nearbeach_kanbancard` (`kanban_card_id`), CONSTRAINT `NearBeach_folder_organisation_id_146087e1_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_folder_parent_folder_id_a685812e_fk_NearBeach` FOREIGN KEY (`parent_folder_id`) REFERENCES `nearbeach_folder` (`folder_id`), CONSTRAINT `NearBeach_folder_project_id_ab53d226_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_folder_request_for_change_i_707b3751_fk_NearBeach` FOREIGN KEY (`request_for_change_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`), CONSTRAINT `NearBeach_folder_requirement_id_d3d96ecd_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_folder_requirement_item_id_c2de263d_fk_NearBeach` FOREIGN KEY (`requirement_item_id`) REFERENCES `nearbeach_requirementitem` (`requirement_item_id`), CONSTRAINT `NearBeach_folder_task_id_de4c21e4_fk_NearBeach_task_task_id` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_folder` -- LOCK TABLES `nearbeach_folder` WRITE; /*!40000 ALTER TABLE `nearbeach_folder` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_folder` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_group` -- DROP TABLE IF EXISTS `nearbeach_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_group` ( `group_id` bigint NOT NULL AUTO_INCREMENT, `group_name` varchar(50) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `parent_group_id` bigint DEFAULT NULL, PRIMARY KEY (`group_id`), KEY `NearBeach_group_change_user_id_ebc66453_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_group_parent_group_id_5ae8c9d0_fk_NearBeach` (`parent_group_id`), CONSTRAINT `NearBeach_group_change_user_id_ebc66453_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_group_parent_group_id_5ae8c9d0_fk_NearBeach` FOREIGN KEY (`parent_group_id`) REFERENCES `nearbeach_group` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_group` -- LOCK TABLES `nearbeach_group` WRITE; /*!40000 ALTER TABLE `nearbeach_group` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_grouppermission` -- DROP TABLE IF EXISTS `nearbeach_grouppermission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_grouppermission` ( `group_permission_id` bigint NOT NULL AUTO_INCREMENT, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `group_id` bigint NOT NULL, `permission_set_id` bigint NOT NULL, PRIMARY KEY (`group_permission_id`), KEY `NearBeach_grouppermi_change_user_id_eed5ebd3_fk_auth_user` (`change_user_id`), KEY `NearBeach_grouppermi_group_id_80fe07c9_fk_NearBeach` (`group_id`), KEY `NearBeach_grouppermi_permission_set_id_3299fa11_fk_NearBeach` (`permission_set_id`), CONSTRAINT `NearBeach_grouppermi_change_user_id_eed5ebd3_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_grouppermi_group_id_80fe07c9_fk_NearBeach` FOREIGN KEY (`group_id`) REFERENCES `nearbeach_group` (`group_id`), CONSTRAINT `NearBeach_grouppermi_permission_set_id_3299fa11_fk_NearBeach` FOREIGN KEY (`permission_set_id`) REFERENCES `nearbeach_permissionset` (`permission_set_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_grouppermission` -- LOCK TABLES `nearbeach_grouppermission` WRITE; /*!40000 ALTER TABLE `nearbeach_grouppermission` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_grouppermission` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_kanbanboard` -- DROP TABLE IF EXISTS `nearbeach_kanbanboard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_kanbanboard` ( `kanban_board_id` bigint NOT NULL AUTO_INCREMENT, `kanban_board_name` varchar(255) NOT NULL, `kanban_board_status` varchar(10) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `requirement_id` bigint DEFAULT NULL, PRIMARY KEY (`kanban_board_id`), KEY `NearBeach_kanbanboar_requirement_id_5c50d6b1_fk_NearBeach` (`requirement_id`), KEY `NearBeach_kanbanboard_change_user_id_27206c7e_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_kanbanboard_creation_user_id_85d926af_fk_auth_user_id` (`creation_user_id`), CONSTRAINT `NearBeach_kanbanboar_requirement_id_5c50d6b1_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_kanbanboard_change_user_id_27206c7e_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_kanbanboard_creation_user_id_85d926af_fk_auth_user_id` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_kanbanboard` -- LOCK TABLES `nearbeach_kanbanboard` WRITE; /*!40000 ALTER TABLE `nearbeach_kanbanboard` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_kanbanboard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_kanbancard` -- DROP TABLE IF EXISTS `nearbeach_kanbancard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_kanbancard` ( `kanban_card_id` bigint NOT NULL AUTO_INCREMENT, `kanban_card_text` varchar(255) NOT NULL, `kanban_card_description` longtext NOT NULL, `kanban_card_sort_number` int NOT NULL, `is_archived` tinyint(1) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `kanban_board_id` bigint NOT NULL, `kanban_column_id` bigint NOT NULL, `kanban_level_id` bigint NOT NULL, `project_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, `kanban_card_priority` int NOT NULL, PRIMARY KEY (`kanban_card_id`), KEY `NearBeach_kanbancard_kanban_column_id_be452751_fk_NearBeach` (`kanban_column_id`), KEY `NearBeach_kanbancard_kanban_level_id_6d824292_fk_NearBeach` (`kanban_level_id`), KEY `NearBeach_kanbancard_project_id_0a8303d2_fk_NearBeach` (`project_id`), KEY `NearBeach_kanbancard_requirement_id_c9d52a81_fk_NearBeach` (`requirement_id`), KEY `NearBeach_kanbancard_task_id_ca7b5ffa_fk_NearBeach_task_task_id` (`task_id`), KEY `NearBeach_kanbancard_change_user_id_c83133e6_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_kanbancard_kanban_board_id_0ab18d47_fk_NearBeach` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbancard_change_user_id_c83133e6_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_kanbancard_kanban_board_id_0ab18d47_fk_NearBeach` FOREIGN KEY (`kanban_board_id`) REFERENCES `nearbeach_kanbanboard` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbancard_kanban_column_id_be452751_fk_NearBeach` FOREIGN KEY (`kanban_column_id`) REFERENCES `nearbeach_kanbancolumn` (`kanban_column_id`), CONSTRAINT `NearBeach_kanbancard_kanban_level_id_6d824292_fk_NearBeach` FOREIGN KEY (`kanban_level_id`) REFERENCES `nearbeach_kanbanlevel` (`kanban_level_id`), CONSTRAINT `NearBeach_kanbancard_project_id_0a8303d2_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_kanbancard_requirement_id_c9d52a81_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_kanbancard_task_id_ca7b5ffa_fk_NearBeach_task_task_id` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_kanbancard` -- LOCK TABLES `nearbeach_kanbancard` WRITE; /*!40000 ALTER TABLE `nearbeach_kanbancard` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_kanbancard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_kanbancolumn` -- DROP TABLE IF EXISTS `nearbeach_kanbancolumn`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_kanbancolumn` ( `kanban_column_id` bigint NOT NULL AUTO_INCREMENT, `kanban_column_name` varchar(255) NOT NULL, `kanban_column_sort_number` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `kanban_board_id` bigint NOT NULL, `kanban_column_property` varchar(10) NOT NULL, PRIMARY KEY (`kanban_column_id`), KEY `NearBeach_kanbancolumn_change_user_id_5280cff6_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_kanbancolu_kanban_board_id_ba2cabaa_fk_NearBeach` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbancolu_kanban_board_id_ba2cabaa_fk_NearBeach` FOREIGN KEY (`kanban_board_id`) REFERENCES `nearbeach_kanbanboard` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbancolumn_change_user_id_5280cff6_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_kanbancolumn` -- LOCK TABLES `nearbeach_kanbancolumn` WRITE; /*!40000 ALTER TABLE `nearbeach_kanbancolumn` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_kanbancolumn` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_kanbanlevel` -- DROP TABLE IF EXISTS `nearbeach_kanbanlevel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_kanbanlevel` ( `kanban_level_id` bigint NOT NULL AUTO_INCREMENT, `kanban_level_name` varchar(255) NOT NULL, `kanban_level_sort_number` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `kanban_board_id` bigint NOT NULL, PRIMARY KEY (`kanban_level_id`), KEY `NearBeach_kanbanlevel_change_user_id_b8016a90_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_kanbanleve_kanban_board_id_99315aa8_fk_NearBeach` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbanleve_kanban_board_id_99315aa8_fk_NearBeach` FOREIGN KEY (`kanban_board_id`) REFERENCES `nearbeach_kanbanboard` (`kanban_board_id`), CONSTRAINT `NearBeach_kanbanlevel_change_user_id_b8016a90_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_kanbanlevel` -- LOCK TABLES `nearbeach_kanbanlevel` WRITE; /*!40000 ALTER TABLE `nearbeach_kanbanlevel` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_kanbanlevel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofbugclient` -- DROP TABLE IF EXISTS `nearbeach_listofbugclient`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofbugclient` ( `list_of_bug_client_id` bigint NOT NULL AUTO_INCREMENT, `bug_client_name` varchar(50) NOT NULL, `bug_client_api_url` varchar(255) NOT NULL, `api_open_bugs` varchar(255) NOT NULL, `api_search_bugs` varchar(255) NOT NULL, `api_bug` varchar(255) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`list_of_bug_client_id`), KEY `NearBeach_listofbugc_change_user_id_3f858a7b_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofbugc_change_user_id_3f858a7b_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofbugclient` -- LOCK TABLES `nearbeach_listofbugclient` WRITE; /*!40000 ALTER TABLE `nearbeach_listofbugclient` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofbugclient` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofrequirementitemstatus` -- DROP TABLE IF EXISTS `nearbeach_listofrequirementitemstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofrequirementitemstatus` ( `requirement_item_status_id` bigint NOT NULL AUTO_INCREMENT, `requirement_item_status` varchar(100) NOT NULL, `status_is_closed` tinyint(1) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`requirement_item_status_id`), KEY `NearBeach_listofrequ_change_user_id_b8bc99b5_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofrequ_change_user_id_b8bc99b5_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofrequirementitemstatus` -- LOCK TABLES `nearbeach_listofrequirementitemstatus` WRITE; /*!40000 ALTER TABLE `nearbeach_listofrequirementitemstatus` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofrequirementitemstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofrequirementitemtype` -- DROP TABLE IF EXISTS `nearbeach_listofrequirementitemtype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofrequirementitemtype` ( `requirement_item_type_id` bigint NOT NULL AUTO_INCREMENT, `requirement_item_type` varchar(100) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`requirement_item_type_id`), KEY `NearBeach_listofrequ_change_user_id_2309a671_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofrequ_change_user_id_2309a671_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofrequirementitemtype` -- LOCK TABLES `nearbeach_listofrequirementitemtype` WRITE; /*!40000 ALTER TABLE `nearbeach_listofrequirementitemtype` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofrequirementitemtype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofrequirementstatus` -- DROP TABLE IF EXISTS `nearbeach_listofrequirementstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofrequirementstatus` ( `requirement_status_id` bigint NOT NULL AUTO_INCREMENT, `requirement_status` varchar(50) NOT NULL, `requirement_status_is_closed` tinyint(1) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`requirement_status_id`), KEY `NearBeach_listofrequ_change_user_id_a2be7482_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofrequ_change_user_id_a2be7482_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofrequirementstatus` -- LOCK TABLES `nearbeach_listofrequirementstatus` WRITE; /*!40000 ALTER TABLE `nearbeach_listofrequirementstatus` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofrequirementstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofrequirementtype` -- DROP TABLE IF EXISTS `nearbeach_listofrequirementtype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofrequirementtype` ( `requirement_type_id` bigint NOT NULL AUTO_INCREMENT, `requirement_type` varchar(100) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`requirement_type_id`), KEY `NearBeach_listofrequ_change_user_id_71b8f0b4_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofrequ_change_user_id_71b8f0b4_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofrequirementtype` -- LOCK TABLES `nearbeach_listofrequirementtype` WRITE; /*!40000 ALTER TABLE `nearbeach_listofrequirementtype` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofrequirementtype` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listofrfcstatus` -- DROP TABLE IF EXISTS `nearbeach_listofrfcstatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listofrfcstatus` ( `rfc_status_id` bigint NOT NULL AUTO_INCREMENT, `rfc_status` varchar(100) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`rfc_status_id`), KEY `NearBeach_listofrfcs_change_user_id_1d4b9a28_fk_auth_user` (`change_user_id`), CONSTRAINT `NearBeach_listofrfcs_change_user_id_1d4b9a28_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listofrfcstatus` -- LOCK TABLES `nearbeach_listofrfcstatus` WRITE; /*!40000 ALTER TABLE `nearbeach_listofrfcstatus` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listofrfcstatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_listoftitle` -- DROP TABLE IF EXISTS `nearbeach_listoftitle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_listoftitle` ( `title_id` bigint NOT NULL AUTO_INCREMENT, `title` varchar(10) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`title_id`), KEY `NearBeach_listoftitle_change_user_id_056e2595_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_listoftitle_change_user_id_056e2595_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_listoftitle` -- LOCK TABLES `nearbeach_listoftitle` WRITE; /*!40000 ALTER TABLE `nearbeach_listoftitle` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_listoftitle` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_notification` -- DROP TABLE IF EXISTS `nearbeach_notification`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_notification` ( `notification_id` bigint NOT NULL AUTO_INCREMENT, `notification_header` varchar(255) NOT NULL, `notification_message` longtext NOT NULL, `notification_start_date` datetime(6) NOT NULL, `notification_end_date` datetime(6) NOT NULL, `notification_location` varchar(20) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `change_user_id` int DEFAULT NULL, PRIMARY KEY (`notification_id`), KEY `NearBeach_notification_change_user_id_2248a12d_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_notification_change_user_id_2248a12d_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_notification` -- LOCK TABLES `nearbeach_notification` WRITE; /*!40000 ALTER TABLE `nearbeach_notification` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_notification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_objectassignment` -- DROP TABLE IF EXISTS `nearbeach_objectassignment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_objectassignment` ( `object_assignment_id` bigint NOT NULL AUTO_INCREMENT, `meta_object` bigint DEFAULT NULL, `meta_object_title` varchar(255) DEFAULT NULL, `meta_object_status` varchar(255) DEFAULT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `assigned_user_id` int DEFAULT NULL, `change_user_id` int NOT NULL, `customer_id` bigint DEFAULT NULL, `group_id_id` bigint DEFAULT NULL, `kanban_board_id` bigint DEFAULT NULL, `kanban_card_id` bigint DEFAULT NULL, `organisation_id` bigint DEFAULT NULL, `project_id` bigint DEFAULT NULL, `request_for_change_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `requirement_item_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, `link_relationship` varchar(10) DEFAULT NULL, `parent_link` varchar(20) DEFAULT NULL, `change_task_id` bigint DEFAULT NULL, PRIMARY KEY (`object_assignment_id`), KEY `NearBeach_objectassi_assigned_user_id_691a7103_fk_auth_user` (`assigned_user_id`), KEY `NearBeach_objectassi_change_user_id_422649db_fk_auth_user` (`change_user_id`), KEY `NearBeach_objectassi_customer_id_b82ae1c8_fk_NearBeach` (`customer_id`), KEY `NearBeach_objectassi_group_id_id_4627b1e6_fk_NearBeach` (`group_id_id`), KEY `NearBeach_objectassi_kanban_board_id_e3a05b37_fk_NearBeach` (`kanban_board_id`), KEY `NearBeach_objectassi_kanban_card_id_1ebdede6_fk_NearBeach` (`kanban_card_id`), KEY `NearBeach_objectassi_organisation_id_8b08eb0c_fk_NearBeach` (`organisation_id`), KEY `NearBeach_objectassi_project_id_05a252b3_fk_NearBeach` (`project_id`), KEY `NearBeach_objectassi_request_for_change_i_fbecc166_fk_NearBeach` (`request_for_change_id`), KEY `NearBeach_objectassi_requirement_id_66fc4c13_fk_NearBeach` (`requirement_id`), KEY `NearBeach_objectassi_requirement_item_id_337251c1_fk_NearBeach` (`requirement_item_id`), KEY `NearBeach_objectassi_task_id_05fd9c3d_fk_NearBeach` (`task_id`), KEY `NearBeach_objectassi_change_task_id_3a733697_fk_NearBeach` (`change_task_id`), CONSTRAINT `NearBeach_objectassi_assigned_user_id_691a7103_fk_auth_user` FOREIGN KEY (`assigned_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_objectassi_change_task_id_3a733697_fk_NearBeach` FOREIGN KEY (`change_task_id`) REFERENCES `nearbeach_changetask` (`change_task_id`), CONSTRAINT `NearBeach_objectassi_change_user_id_422649db_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_objectassi_customer_id_b82ae1c8_fk_NearBeach` FOREIGN KEY (`customer_id`) REFERENCES `nearbeach_customer` (`customer_id`), CONSTRAINT `NearBeach_objectassi_group_id_id_4627b1e6_fk_NearBeach` FOREIGN KEY (`group_id_id`) REFERENCES `nearbeach_group` (`group_id`), CONSTRAINT `NearBeach_objectassi_kanban_board_id_e3a05b37_fk_NearBeach` FOREIGN KEY (`kanban_board_id`) REFERENCES `nearbeach_kanbanboard` (`kanban_board_id`), CONSTRAINT `NearBeach_objectassi_kanban_card_id_1ebdede6_fk_NearBeach` FOREIGN KEY (`kanban_card_id`) REFERENCES `nearbeach_kanbancard` (`kanban_card_id`), CONSTRAINT `NearBeach_objectassi_organisation_id_8b08eb0c_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_objectassi_project_id_05a252b3_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_objectassi_request_for_change_i_fbecc166_fk_NearBeach` FOREIGN KEY (`request_for_change_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`), CONSTRAINT `NearBeach_objectassi_requirement_id_66fc4c13_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_objectassi_requirement_item_id_337251c1_fk_NearBeach` FOREIGN KEY (`requirement_item_id`) REFERENCES `nearbeach_requirementitem` (`requirement_item_id`), CONSTRAINT `NearBeach_objectassi_task_id_05fd9c3d_fk_NearBeach` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_objectassignment` -- LOCK TABLES `nearbeach_objectassignment` WRITE; /*!40000 ALTER TABLE `nearbeach_objectassignment` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_objectassignment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_objectnote` -- DROP TABLE IF EXISTS `nearbeach_objectnote`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_objectnote` ( `object_note_id` bigint NOT NULL AUTO_INCREMENT, `object_note` longtext NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `kanban_card_id` bigint DEFAULT NULL, `organisation_id` bigint DEFAULT NULL, `project_id` bigint DEFAULT NULL, `request_for_change_id` bigint DEFAULT NULL, `requirement_id` bigint DEFAULT NULL, `requirement_item_id` bigint DEFAULT NULL, `task_id` bigint DEFAULT NULL, PRIMARY KEY (`object_note_id`), KEY `NearBeach_objectnote_change_user_id_9f56cb43_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_objectnote_kanban_card_id_8fab1ba5_fk_NearBeach` (`kanban_card_id`), KEY `NearBeach_objectnote_organisation_id_bce1e7fc_fk_NearBeach` (`organisation_id`), KEY `NearBeach_objectnote_project_id_a9df0a77_fk_NearBeach` (`project_id`), KEY `NearBeach_objectnote_request_for_change_i_e973fefe_fk_NearBeach` (`request_for_change_id`), KEY `NearBeach_objectnote_requirement_id_0462e08b_fk_NearBeach` (`requirement_id`), KEY `NearBeach_objectnote_requirement_item_id_0517225f_fk_NearBeach` (`requirement_item_id`), KEY `NearBeach_objectnote_task_id_3fefd304_fk_NearBeach_task_task_id` (`task_id`), CONSTRAINT `NearBeach_objectnote_change_user_id_9f56cb43_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_objectnote_kanban_card_id_8fab1ba5_fk_NearBeach` FOREIGN KEY (`kanban_card_id`) REFERENCES `nearbeach_kanbancard` (`kanban_card_id`), CONSTRAINT `NearBeach_objectnote_organisation_id_bce1e7fc_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_objectnote_project_id_a9df0a77_fk_NearBeach` FOREIGN KEY (`project_id`) REFERENCES `nearbeach_project` (`project_id`), CONSTRAINT `NearBeach_objectnote_request_for_change_i_e973fefe_fk_NearBeach` FOREIGN KEY (`request_for_change_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`), CONSTRAINT `NearBeach_objectnote_requirement_id_0462e08b_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_objectnote_requirement_item_id_0517225f_fk_NearBeach` FOREIGN KEY (`requirement_item_id`) REFERENCES `nearbeach_requirementitem` (`requirement_item_id`), CONSTRAINT `NearBeach_objectnote_task_id_3fefd304_fk_NearBeach_task_task_id` FOREIGN KEY (`task_id`) REFERENCES `nearbeach_task` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_objectnote` -- LOCK TABLES `nearbeach_objectnote` WRITE; /*!40000 ALTER TABLE `nearbeach_objectnote` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_objectnote` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_organisation` -- DROP TABLE IF EXISTS `nearbeach_organisation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_organisation` ( `organisation_id` bigint NOT NULL AUTO_INCREMENT, `organisation_name` varchar(255) NOT NULL, `organisation_website` varchar(50) NOT NULL, `organisation_email` varchar(100) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `organisation_profile_picture_id` char(32) DEFAULT NULL, PRIMARY KEY (`organisation_id`), KEY `NearBeach_organisation_change_user_id_8d87fa24_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_organisati_organisation_profile_5462b974_fk_NearBeach` (`organisation_profile_picture_id`), CONSTRAINT `NearBeach_organisati_organisation_profile_5462b974_fk_NearBeach` FOREIGN KEY (`organisation_profile_picture_id`) REFERENCES `nearbeach_document` (`document_key`), CONSTRAINT `NearBeach_organisation_change_user_id_8d87fa24_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_organisation` -- LOCK TABLES `nearbeach_organisation` WRITE; /*!40000 ALTER TABLE `nearbeach_organisation` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_organisation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_permissionset` -- DROP TABLE IF EXISTS `nearbeach_permissionset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_permissionset` ( `permission_set_id` bigint NOT NULL AUTO_INCREMENT, `permission_set_name` varchar(255) NOT NULL, `administration_assign_user_to_group` int NOT NULL, `administration_create_group` int NOT NULL, `administration_create_permission_set` int NOT NULL, `administration_create_user` int NOT NULL, `bug_client` int NOT NULL, `customer` int NOT NULL, `kanban_board` int NOT NULL, `kanban_card` int NOT NULL, `organisation` int NOT NULL, `project` int NOT NULL, `request_for_change` int NOT NULL, `requirement` int NOT NULL, `task` int NOT NULL, `document` int NOT NULL, `kanban_comment` int NOT NULL, `project_history` int NOT NULL, `task_history` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `tag` int NOT NULL, PRIMARY KEY (`permission_set_id`), KEY `NearBeach_permissionset_change_user_id_2c898095_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_permissionset_change_user_id_2c898095_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_permissionset` -- LOCK TABLES `nearbeach_permissionset` WRITE; /*!40000 ALTER TABLE `nearbeach_permissionset` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_permissionset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_project` -- DROP TABLE IF EXISTS `nearbeach_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_project` ( `project_id` bigint NOT NULL AUTO_INCREMENT, `project_name` varchar(255) NOT NULL, `project_description` longtext NOT NULL, `project_start_date` datetime(6) NOT NULL, `project_end_date` datetime(6) NOT NULL, `project_status` varchar(15) NOT NULL, `project_story_point_min` int NOT NULL, `project_story_point_max` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `customer_id` bigint DEFAULT NULL, `organisation_id` bigint DEFAULT NULL, PRIMARY KEY (`project_id`), KEY `NearBeach_project_change_user_id_93cf1d60_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_project_creation_user_id_7c77449e_fk_auth_user_id` (`creation_user_id`), KEY `NearBeach_project_customer_id_b25feaef_fk_NearBeach` (`customer_id`), KEY `NearBeach_project_organisation_id_fc805242_fk_NearBeach` (`organisation_id`), CONSTRAINT `NearBeach_project_change_user_id_93cf1d60_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_project_creation_user_id_7c77449e_fk_auth_user_id` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_project_customer_id_b25feaef_fk_NearBeach` FOREIGN KEY (`customer_id`) REFERENCES `nearbeach_customer` (`customer_id`), CONSTRAINT `NearBeach_project_organisation_id_fc805242_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_project` -- LOCK TABLES `nearbeach_project` WRITE; /*!40000 ALTER TABLE `nearbeach_project` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_requestforchange` -- DROP TABLE IF EXISTS `nearbeach_requestforchange`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_requestforchange` ( `rfc_id` bigint NOT NULL AUTO_INCREMENT, `rfc_title` varchar(255) NOT NULL, `rfc_summary` longtext NOT NULL, `rfc_type` int NOT NULL, `rfc_implementation_start_date` datetime(6) NOT NULL, `rfc_implementation_end_date` datetime(6) NOT NULL, `rfc_implementation_release_date` datetime(6) NOT NULL, `rfc_version_number` varchar(25) DEFAULT NULL, `rfc_priority` int NOT NULL, `rfc_risk` int NOT NULL, `rfc_impact` int NOT NULL, `rfc_risk_and_impact_analysis` longtext NOT NULL, `rfc_implementation_plan` longtext NOT NULL, `rfc_backout_plan` longtext NOT NULL, `rfc_test_plan` longtext NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `rfc_lead_id` int NOT NULL, `rfc_status_id` bigint NOT NULL, PRIMARY KEY (`rfc_id`), KEY `NearBeach_requestfor_change_user_id_f1f21ec6_fk_auth_user` (`change_user_id`), KEY `NearBeach_requestfor_creation_user_id_98840143_fk_auth_user` (`creation_user_id`), KEY `NearBeach_requestforchange_rfc_lead_id_5fcaa82f_fk_auth_user_id` (`rfc_lead_id`), KEY `NearBeach_requestfor_rfc_status_id_0433525a_fk_NearBeach` (`rfc_status_id`), CONSTRAINT `NearBeach_requestfor_change_user_id_f1f21ec6_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_requestfor_creation_user_id_98840143_fk_auth_user` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_requestfor_rfc_status_id_0433525a_fk_NearBeach` FOREIGN KEY (`rfc_status_id`) REFERENCES `nearbeach_listofrfcstatus` (`rfc_status_id`), CONSTRAINT `NearBeach_requestforchange_rfc_lead_id_5fcaa82f_fk_auth_user_id` FOREIGN KEY (`rfc_lead_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_requestforchange` -- LOCK TABLES `nearbeach_requestforchange` WRITE; /*!40000 ALTER TABLE `nearbeach_requestforchange` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_requestforchange` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_requestforchangegroupapproval` -- DROP TABLE IF EXISTS `nearbeach_requestforchangegroupapproval`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_requestforchangegroupapproval` ( `rfc_group_approval_id` bigint NOT NULL AUTO_INCREMENT, `approval` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `group_id` bigint NOT NULL, `rfc_id` bigint NOT NULL, PRIMARY KEY (`rfc_group_approval_id`), KEY `NearBeach_requestfor_change_user_id_39cbbaf8_fk_auth_user` (`change_user_id`), KEY `NearBeach_requestfor_group_id_d4b6e138_fk_NearBeach` (`group_id`), KEY `NearBeach_requestfor_rfc_id_16bec85b_fk_NearBeach` (`rfc_id`), CONSTRAINT `NearBeach_requestfor_change_user_id_39cbbaf8_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_requestfor_group_id_d4b6e138_fk_NearBeach` FOREIGN KEY (`group_id`) REFERENCES `nearbeach_group` (`group_id`), CONSTRAINT `NearBeach_requestfor_rfc_id_16bec85b_fk_NearBeach` FOREIGN KEY (`rfc_id`) REFERENCES `nearbeach_requestforchange` (`rfc_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_requestforchangegroupapproval` -- LOCK TABLES `nearbeach_requestforchangegroupapproval` WRITE; /*!40000 ALTER TABLE `nearbeach_requestforchangegroupapproval` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_requestforchangegroupapproval` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_requirement` -- DROP TABLE IF EXISTS `nearbeach_requirement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_requirement` ( `requirement_id` bigint NOT NULL AUTO_INCREMENT, `requirement_title` varchar(255) NOT NULL, `requirement_scope` longtext NOT NULL, `requirement_story_point_min` int NOT NULL, `requirement_story_point_max` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `organisation_id` bigint DEFAULT NULL, `requirement_status_id` bigint NOT NULL, `requirement_type_id` bigint NOT NULL, PRIMARY KEY (`requirement_id`), KEY `NearBeach_requirement_change_user_id_f95f90a6_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_requirement_creation_user_id_36ec5a1d_fk_auth_user_id` (`creation_user_id`), KEY `NearBeach_requiremen_organisation_id_080e7a16_fk_NearBeach` (`organisation_id`), KEY `NearBeach_requiremen_requirement_status_i_69b17c27_fk_NearBeach` (`requirement_status_id`), KEY `NearBeach_requiremen_requirement_type_id_ceb30fa8_fk_NearBeach` (`requirement_type_id`), CONSTRAINT `NearBeach_requiremen_organisation_id_080e7a16_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_requiremen_requirement_status_i_69b17c27_fk_NearBeach` FOREIGN KEY (`requirement_status_id`) REFERENCES `nearbeach_listofrequirementstatus` (`requirement_status_id`), CONSTRAINT `NearBeach_requiremen_requirement_type_id_ceb30fa8_fk_NearBeach` FOREIGN KEY (`requirement_type_id`) REFERENCES `nearbeach_listofrequirementtype` (`requirement_type_id`), CONSTRAINT `NearBeach_requirement_change_user_id_f95f90a6_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_requirement_creation_user_id_36ec5a1d_fk_auth_user_id` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_requirement` -- LOCK TABLES `nearbeach_requirement` WRITE; /*!40000 ALTER TABLE `nearbeach_requirement` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_requirement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_requirementitem` -- DROP TABLE IF EXISTS `nearbeach_requirementitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_requirementitem` ( `requirement_item_id` bigint NOT NULL AUTO_INCREMENT, `requirement_item_title` varchar(255) NOT NULL, `requirement_item_scope` longtext NOT NULL, `ri_story_point_min` int NOT NULL, `ri_story_point_max` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `requirement_id` bigint NOT NULL, `requirement_item_status_id` bigint NOT NULL, `requirement_item_type_id` bigint NOT NULL, PRIMARY KEY (`requirement_item_id`), KEY `NearBeach_requiremen_change_user_id_93b1f209_fk_auth_user` (`change_user_id`), KEY `NearBeach_requiremen_requirement_id_f276352d_fk_NearBeach` (`requirement_id`), KEY `NearBeach_requiremen_requirement_item_sta_037363ce_fk_NearBeach` (`requirement_item_status_id`), KEY `NearBeach_requiremen_requirement_item_typ_6cce3ea6_fk_NearBeach` (`requirement_item_type_id`), CONSTRAINT `NearBeach_requiremen_change_user_id_93b1f209_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_requiremen_requirement_id_f276352d_fk_NearBeach` FOREIGN KEY (`requirement_id`) REFERENCES `nearbeach_requirement` (`requirement_id`), CONSTRAINT `NearBeach_requiremen_requirement_item_sta_037363ce_fk_NearBeach` FOREIGN KEY (`requirement_item_status_id`) REFERENCES `nearbeach_listofrequirementitemstatus` (`requirement_item_status_id`), CONSTRAINT `NearBeach_requiremen_requirement_item_typ_6cce3ea6_fk_NearBeach` FOREIGN KEY (`requirement_item_type_id`) REFERENCES `nearbeach_listofrequirementitemtype` (`requirement_item_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_requirementitem` -- LOCK TABLES `nearbeach_requirementitem` WRITE; /*!40000 ALTER TABLE `nearbeach_requirementitem` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_requirementitem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_tag` -- DROP TABLE IF EXISTS `nearbeach_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_tag` ( `tag_id` bigint NOT NULL AUTO_INCREMENT, `tag_name` varchar(50) NOT NULL, `tag_colour` varchar(7) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, PRIMARY KEY (`tag_id`), KEY `NearBeach_tag_change_user_id_e8005af1_fk_auth_user_id` (`change_user_id`), CONSTRAINT `NearBeach_tag_change_user_id_e8005af1_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_tag` -- LOCK TABLES `nearbeach_tag` WRITE; /*!40000 ALTER TABLE `nearbeach_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_tagassignment` -- DROP TABLE IF EXISTS `nearbeach_tagassignment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_tagassignment` ( `tag_assignment_id` bigint NOT NULL AUTO_INCREMENT, `object_enum` varchar(40) NOT NULL, `object_id` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `tag_id` bigint NOT NULL, PRIMARY KEY (`tag_assignment_id`), KEY `NearBeach_tagassignment_change_user_id_6d59a669_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_tagassignment_tag_id_ff09c4b3_fk_NearBeach_tag_tag_id` (`tag_id`), CONSTRAINT `NearBeach_tagassignment_change_user_id_6d59a669_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_tagassignment_tag_id_ff09c4b3_fk_NearBeach_tag_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `nearbeach_tag` (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_tagassignment` -- LOCK TABLES `nearbeach_tagassignment` WRITE; /*!40000 ALTER TABLE `nearbeach_tagassignment` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_tagassignment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_task` -- DROP TABLE IF EXISTS `nearbeach_task`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_task` ( `task_id` bigint NOT NULL AUTO_INCREMENT, `task_short_description` varchar(255) NOT NULL, `task_long_description` longtext NOT NULL, `task_start_date` datetime(6) NOT NULL, `task_end_date` datetime(6) NOT NULL, `task_status` varchar(15) NOT NULL, `task_story_point_min` int NOT NULL, `task_story_point_max` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `creation_user_id` int NOT NULL, `organisation_id` bigint DEFAULT NULL, `task_assigned_to_id` int DEFAULT NULL, PRIMARY KEY (`task_id`), KEY `NearBeach_task_change_user_id_1157f540_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_task_creation_user_id_e60c37c9_fk_auth_user_id` (`creation_user_id`), KEY `NearBeach_task_organisation_id_322917a7_fk_NearBeach` (`organisation_id`), KEY `NearBeach_task_task_assigned_to_id_86f4d6ef_fk_auth_user_id` (`task_assigned_to_id`), CONSTRAINT `NearBeach_task_change_user_id_1157f540_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_task_creation_user_id_e60c37c9_fk_auth_user_id` FOREIGN KEY (`creation_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_task_organisation_id_322917a7_fk_NearBeach` FOREIGN KEY (`organisation_id`) REFERENCES `nearbeach_organisation` (`organisation_id`), CONSTRAINT `NearBeach_task_task_assigned_to_id_86f4d6ef_fk_auth_user_id` FOREIGN KEY (`task_assigned_to_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_task` -- LOCK TABLES `nearbeach_task` WRITE; /*!40000 ALTER TABLE `nearbeach_task` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_task` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_usergroup` -- DROP TABLE IF EXISTS `nearbeach_usergroup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_usergroup` ( `user_group_id` bigint NOT NULL AUTO_INCREMENT, `group_leader` tinyint(1) NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `group_id` bigint NOT NULL, `permission_set_id` bigint NOT NULL, `report_to_id` int DEFAULT NULL, `username_id` int NOT NULL, PRIMARY KEY (`user_group_id`), KEY `NearBeach_usergroup_change_user_id_6a965981_fk_auth_user_id` (`change_user_id`), KEY `NearBeach_usergroup_group_id_be8052b0_fk_NearBeach` (`group_id`), KEY `NearBeach_usergroup_permission_set_id_77fc6d25_fk_NearBeach` (`permission_set_id`), KEY `NearBeach_usergroup_report_to_id_35a16a98_fk_auth_user_id` (`report_to_id`), KEY `NearBeach_usergroup_username_id_12795f7b_fk_auth_user_id` (`username_id`), CONSTRAINT `NearBeach_usergroup_change_user_id_6a965981_fk_auth_user_id` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_usergroup_group_id_be8052b0_fk_NearBeach` FOREIGN KEY (`group_id`) REFERENCES `nearbeach_group` (`group_id`), CONSTRAINT `NearBeach_usergroup_permission_set_id_77fc6d25_fk_NearBeach` FOREIGN KEY (`permission_set_id`) REFERENCES `nearbeach_permissionset` (`permission_set_id`), CONSTRAINT `NearBeach_usergroup_report_to_id_35a16a98_fk_auth_user_id` FOREIGN KEY (`report_to_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_usergroup_username_id_12795f7b_fk_auth_user_id` FOREIGN KEY (`username_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_usergroup` -- LOCK TABLES `nearbeach_usergroup` WRITE; /*!40000 ALTER TABLE `nearbeach_usergroup` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_usergroup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nearbeach_userprofilepicture` -- DROP TABLE IF EXISTS `nearbeach_userprofilepicture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `nearbeach_userprofilepicture` ( `username_id` int NOT NULL, `date_created` datetime(6) NOT NULL, `date_modified` datetime(6) NOT NULL, `is_deleted` tinyint(1) NOT NULL, `change_user_id` int NOT NULL, `document_id` char(32) NOT NULL, PRIMARY KEY (`username_id`), KEY `NearBeach_userprofil_change_user_id_d88a8ea5_fk_auth_user` (`change_user_id`), KEY `NearBeach_userprofil_document_id_95b56224_fk_NearBeach` (`document_id`), CONSTRAINT `NearBeach_userprofil_change_user_id_d88a8ea5_fk_auth_user` FOREIGN KEY (`change_user_id`) REFERENCES `auth_user` (`id`), CONSTRAINT `NearBeach_userprofil_document_id_95b56224_fk_NearBeach` FOREIGN KEY (`document_id`) REFERENCES `nearbeach_document` (`document_key`), CONSTRAINT `NearBeach_userprofil_username_id_fbc7b208_fk_auth_user` FOREIGN KEY (`username_id`) REFERENCES `auth_user` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nearbeach_userprofilepicture` -- LOCK TABLES `nearbeach_userprofilepicture` WRITE; /*!40000 ALTER TABLE `nearbeach_userprofilepicture` DISABLE KEYS */; /*!40000 ALTER TABLE `nearbeach_userprofilepicture` 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 2023-07-09 15:17:26