--
-- Host: 127.0.0.1    Database: grolog
-- ------------------------------------------------------


--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_owner` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_id_uindex` (`id`),
  KEY `account_users_id_fk` (`account_owner`),
  CONSTRAINT `account_users_id_fk` FOREIGN KEY (`account_owner`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `account`
--

INSERT INTO `account` VALUES (1,1);

--
-- Table structure for table `area`
--

CREATE TABLE `area` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `type_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `aria_id_uindex` (`id`),
  KEY `area_area_id_fk` (`parent_id`),
  KEY `area_type_id_fk` (`type_id`),
  KEY `area_account_id_fk` (`account_id`),
  CONSTRAINT `area_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  CONSTRAINT `area_area_id_fk` FOREIGN KEY (`parent_id`) REFERENCES `area` (`id`) ON DELETE CASCADE,
  CONSTRAINT `area_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `area`
--

INSERT INTO `area` VALUES (1,1,NULL,3,'Raised Bed 1','Raised Bed 1',NULL,NULL);
INSERT INTO `area` VALUES (2,1,1,4,'1-A','1-A',NULL,NULL);

--
-- Table structure for table `attribute`
--

CREATE TABLE `attribute` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `type_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sequence` smallint DEFAULT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `datatype_id` int NOT NULL,
  `numerical_value` decimal(10,3) DEFAULT NULL,
  `allowed_values` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `unit_of_measure_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_id_uindex` (`id`),
  UNIQUE KEY `attribute_name_uindex` (`name`),
  KEY `attribute_type_id_fk` (`type_id`),
  KEY `attribute_account_id_fk` (`account_id`),
  CONSTRAINT `attribute_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attribute_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `attribute`
--

INSERT INTO `attribute` VALUES (1,1,3,'Description','Description',NULL,NULL,5,NULL,'',NULL,NULL,NULL);
INSERT INTO `attribute` VALUES (2,1,5,'Growing Habit','Growing Habit',NULL,NULL,3,NULL,'dwarf|determinant|indeterminate',NULL,NULL,NULL);
INSERT INTO `attribute` VALUES (3,1,1,'Descritption','Description',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `attribute` VALUES (4,1,12,'Color','Color',NULL,NULL,5,NULL,NULL,NULL,'2021-08-07 06:52:36','2021-08-07 06:52:36');

--
-- Table structure for table `attribute_sequence`
--

CREATE TABLE `attribute_sequence` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `sequence` int unsigned NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_sequence_id_uindex` (`id`),
  KEY `attribute_sequence_attribute_id_index` (`attribute_id`),
  KEY `attribute_sequence_type_id_fk` (`type_id`),
  CONSTRAINT `attribute_sequence_attribute_id_fk` FOREIGN KEY (`attribute_id`) REFERENCES `attribute` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attribute_sequence_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `attribute_sequence`
--

INSERT INTO `attribute_sequence` VALUES (1,5,3,0,'2021-08-06 00:59:26','2021-08-07 23:38:45');
INSERT INTO `attribute_sequence` VALUES (2,1,1,0,'2021-08-06 01:04:15','2021-08-06 01:04:15');
INSERT INTO `attribute_sequence` VALUES (3,5,2,2,'2021-08-06 01:15:51','2021-08-08 07:33:44');
INSERT INTO `attribute_sequence` VALUES (4,5,4,1,'2021-08-07 06:53:58','2021-08-08 07:33:44');

--
-- Table structure for table `attribute_value`
--

CREATE TABLE `attribute_value` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_id` bigint unsigned NOT NULL,
  `entity_type_id` tinyint NOT NULL,
  `entity_id` bigint unsigned NOT NULL,
  `numerical_value` decimal(8,5) DEFAULT NULL,
  `character_value` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `selected_value` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_value_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `attribute_value`
--

INSERT INTO `attribute_value` VALUES (1,1,1,3,NULL,'Marglobe is a good variety.',NULL,NULL,NULL);
INSERT INTO `attribute_value` VALUES (2,2,1,3,NULL,NULL,2,NULL,NULL);
INSERT INTO `attribute_value` VALUES (3,1,2,2,NULL,'Bed 1, square 2-A',NULL,NULL,NULL);

--
-- Table structure for table `calculated_attributes`
--

CREATE TABLE `calculated_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `calculated_attributes_id_uindex` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `calculated_attributes`
--


--
-- Table structure for table `datatype`
--

CREATE TABLE `datatype` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sql_ddl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `datatype_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `datatype`
--

INSERT INTO `datatype` VALUES (1,'boolean','bool','boolean',NULL,NULL);
INSERT INTO `datatype` VALUES (2,'character','nchar','nchar',NULL,NULL);
INSERT INTO `datatype` VALUES (3,'Short text','nvarchar(100)',NULL,NULL,NULL);
INSERT INTO `datatype` VALUES (4,'Medium text','nvarchar(1000)',NULL,NULL,NULL);
INSERT INTO `datatype` VALUES (5,'Long text','nvarchar(10000)',NULL,NULL,NULL);
INSERT INTO `datatype` VALUES (6,'Integer','int',NULL,NULL,NULL);
INSERT INTO `datatype` VALUES (7,'Float','float',NULL,NULL,NULL);
INSERT INTO `datatype` VALUES (8,'Decimal','decimal(8,5)',NULL,NULL,NULL);

--
-- Table structure for table `entity_type`
--

CREATE TABLE `entity_type` (
  `id` tinyint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `entity_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `entity_type`
--

INSERT INTO `entity_type` VALUES (1,'Plant',NULL);
INSERT INTO `entity_type` VALUES (2,'Area',NULL);
INSERT INTO `entity_type` VALUES (3,'Journal Entry',NULL);
INSERT INTO `entity_type` VALUES (4,'Task',NULL);

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `journal_entry`
--

CREATE TABLE `journal_entry` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `type_id` bigint unsigned NOT NULL,
  `description` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `journal_entry_id_uindex` (`id`),
  KEY `journal_entry_account_id_fk` (`account_id`),
  KEY `journal_type_id_fk` (`type_id`),
  CONSTRAINT `journal_entry_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  CONSTRAINT `journal_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `journal_entry`
--

INSERT INTO `journal_entry` VALUES (1,1,1,'Planted first tomatoe ',NULL,NULL);

--
-- Table structure for table `journal_entry_entity_link`
--

CREATE TABLE `journal_entry_entity_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `journal_entry_id` bigint unsigned NOT NULL,
  `entity_id` bigint unsigned NOT NULL,
  `entity_type_id` tinyint unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `journal_entry_entity_link_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `journal_entry_entity_link`
--

INSERT INTO `journal_entry_entity_link` VALUES (1,1,3,1,NULL,NULL);
INSERT INTO `journal_entry_entity_link` VALUES (2,1,2,2,NULL,NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` VALUES (2,'2014_10_12_100000_create_password_resets_table',1);
INSERT INTO `migrations` VALUES (3,'2019_08_19_000000_create_failed_jobs_table',1);

--
-- Table structure for table `plant`
--

CREATE TABLE `plant` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `type_id` bigint unsigned NOT NULL,
  `common_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `latin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `parent` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plant_id_uindex` (`id`),
  KEY `plant_account_id_fk` (`account_id`),
  KEY `plant_type_id_fk` (`type_id`),
  CONSTRAINT `plant_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  CONSTRAINT `plant_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plant`
--

INSERT INTO `plant` VALUES (1,1,1,'Vegetables',NULL,NULL,NULL,NULL);
INSERT INTO `plant` VALUES (2,1,1,'Tomato',NULL,1,NULL,NULL);
INSERT INTO `plant` VALUES (3,1,5,'Marglobe',NULL,2,NULL,NULL);

--
-- Table structure for table `plant_area_link`
--

CREATE TABLE `plant_area_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `plant_id` bigint unsigned NOT NULL,
  `area_id` bigint unsigned NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plant_area_link_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `plant_area_link`
--

INSERT INTO `plant_area_link` VALUES (1,3,2,NULL,NULL);

--
-- Table structure for table `task`
--

CREATE TABLE `task` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `type_id` bigint unsigned NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `due_datetime` datetime NOT NULL,
  `original_due_datetime` datetime NOT NULL,
  `recurrence_type_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_id_uindex` (`id`),
  KEY `task_type_id_fk` (`type_id`),
  KEY `task_account_id_fk` (`account_id`),
  CONSTRAINT `task_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE CASCADE,
  CONSTRAINT `task_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `type` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `task`
--

INSERT INTO `task` VALUES (1,1,6,'Water Tomatoes',NULL,'2021-06-23 05:32:10','2021-06-23 05:31:59',NULL,NULL,NULL);

--
-- Table structure for table `task_entity_link`
--

CREATE TABLE `task_entity_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `entity_type_id` tinyint DEFAULT NULL,
  `task_id` bigint unsigned DEFAULT NULL,
  `entity_id` bigint unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_entity_link_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `task_entity_link`
--

INSERT INTO `task_entity_link` VALUES (1,1,1,3,NULL,NULL);
INSERT INTO `task_entity_link` VALUES (2,2,1,2,NULL,NULL);

--
-- Table structure for table `type`
--

CREATE TABLE `type` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `account_id` bigint unsigned NOT NULL,
  `entity_type_id` tinyint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `image_path` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `journal_entry_type_id_uindex` (`id`),
  KEY `entity_users_id_fk` (`account_id`),
  KEY `entity_type_type_id_fk` (`entity_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='user defined types for plants, areas, journal entries, and tasks';

--
-- Dumping data for table `type`
--

INSERT INTO `type` VALUES (1,1,1,0,'Vegetables','All Vegetables','image/type/plant/AzjY0ZN3ZB6AamylT7XQrNx0af9Wzq9En6JOvIkt.png','2021-06-20 13:53:08','2021-07-28 06:37:33');
INSERT INTO `type` VALUES (2,1,2,0,'Raised Bed','Beds constructed from wood or other materials',NULL,NULL,'2021-07-31 05:20:12');
INSERT INTO `type` VALUES (3,1,2,2,'Square Foot Raised Bed','Raised beds sectioned off in square feet',NULL,NULL,NULL);
INSERT INTO `type` VALUES (4,1,2,3,'Raised Bed Square','Single square foot section of a raised bed',NULL,NULL,NULL);
INSERT INTO `type` VALUES (5,1,1,12,'Tomato','All types and varieties of tomatoes','image/type/plant/tomato.png',NULL,'2021-07-25 16:08:27');
INSERT INTO `type` VALUES (6,1,3,NULL,'Water','Taks of watering',NULL,NULL,NULL);
INSERT INTO `type` VALUES (8,1,1,11,'Kale','Kale','image/type/plant/VYS2kmPIFR2qw0VdCyzsSSFNaaVcfbH6QWJTbLCl.png',NULL,'2021-07-25 16:06:15');
INSERT INTO `type` VALUES (9,1,1,12,'Pepper',NULL,'image/type/plant/P0hhlehrxqUIykaQ3EZloV2Bgl2BCI7HnxqlpjxQ.png','2021-07-23 11:31:13','2021-08-08 14:43:08');
INSERT INTO `type` VALUES (10,1,1,11,'Arugula',NULL,'image/type/plant/B2QBugfTC6UpO73CvX3B0mtYN2nVBAdjqRzEQs22.png','2021-07-24 06:10:41','2021-07-27 06:34:33');
INSERT INTO `type` VALUES (11,1,1,1,'Brassicas','All Brassicas','image/type/plant/hzWhPB9tjrpKIV8Jc94Q3n30bDmNrs9pG7f7syaJ.png','2021-07-25 16:04:17','2021-07-29 11:17:23');
INSERT INTO `type` VALUES (12,1,1,1,'Nightshades',NULL,'image/type/plant/hIt9qdc3BMwNorUypqB4n9S6oRl7v9yiZKe7asJV.png','2021-07-25 16:08:04','2021-07-25 16:08:04');
INSERT INTO `type` VALUES (13,1,4,NULL,'Garden Tasks','Garden Tasks',NULL,NULL,NULL);

--
-- Table structure for table `unit_of_measure`
--

CREATE TABLE `unit_of_measure` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unit_of_measure_id_uindex` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `unit_of_measure`
--


--
-- Table structure for table `user_account_link`
--

CREATE TABLE `user_account_link` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `account_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_account_link_id_uindex` (`id`),
  KEY `user_account_link_account_id_fk` (`account_id`),
  KEY `user_account_link_users_id_fk` (`user_id`),
  CONSTRAINT `user_account_link_account_id_fk` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`),
  CONSTRAINT `user_account_link_users_id_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_account_link`
--

INSERT INTO `user_account_link` VALUES (1,1,1,1);


