/* CUSTOM VARS START */
/* REAL_TABLE_NAME: `mod42_e_notes`; */
/* PRE_TABLE_NAME: `1690813095_mod42_e_notes`; */
/* CUSTOM VARS END */

CREATE TABLE IF NOT EXISTS `1690813095_mod42_e_notes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `route_url` text COLLATE utf8mb4_unicode_520_ci COMMENT 'Clean url where the note was created.', `route_title` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, `route_post_id` bigint(20) unsigned DEFAULT NULL COMMENT 'The post id of the route that the note was created on.', `post_id` bigint(20) unsigned DEFAULT NULL, `element_id` varchar(60) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'The Elementor element ID the note is attached to.', `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0', `author_id` bigint(20) unsigned DEFAULT NULL, `author_display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Save the author name when the author was deleted.', `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish', `position` text COLLATE utf8mb4_unicode_520_ci COMMENT 'A JSON string that represents the position of the note inside the element in percentages. e.g. {x:10, y:15}', `content` longtext COLLATE utf8mb4_unicode_520_ci, `is_resolved` tinyint(1) NOT NULL DEFAULT '0', `is_public` tinyint(1) NOT NULL DEFAULT '1', `last_activity_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, PRIMARY KEY (`id`), KEY `route_url_index` (`route_url`(191)), KEY `post_id_index` (`post_id`), KEY `element_id_index` (`element_id`), KEY `parent_id_index` (`parent_id`), KEY `author_id_index` (`author_id`), KEY `status_index` (`status`), KEY `is_resolved_index` (`is_resolved`), KEY `is_public_index` (`is_public`), KEY `created_at_index` (`created_at`), KEY `updated_at_index` (`updated_at`), KEY `last_activity_at_index` (`last_activity_at`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
