WordPress database error: [Cannot add foreign key constraint]CREATE TABLE IF NOT EXISTS `wp_stw_collections` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) unsigned NOT NULL,
`url_code` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT 'My Wishlist',
`description` text,
`status` varchar(50) NOT NULL DEFAULT 'publish',
`is_default` tinyint(1) NOT NULL DEFAULT 0,
`is_public` tinyint(1) NOT NULL DEFAULT 0,
`created_at` datetime DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `is_default` (`is_default`),
KEY `is_public` (`is_public`),
CONSTRAINT `fk_wishlist_collections_user` FOREIGN KEY (`user_id`) REFERENCES `wp_users` (`ID`) ON DELETE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Cannot add foreign key constraint]CREATE TABLE IF NOT EXISTS `wp_stw_collection_items` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`collection_id` bigint(20) unsigned NOT NULL,
`product_id` bigint(20) unsigned NOT NULL,
`variation_id` bigint(20) DEFAULT 0,
`sort_order` int(11) DEFAULT 0,
`quantity` int(11) NOT NULL DEFAULT 1,
`priority` enum('low','medium','high') DEFAULT 'medium',
`notes` text,
`added_at` datetime DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `collection_product_variation` (`collection_id`,`product_id`,`variation_id`),
KEY `collection_id` (`collection_id`),
KEY `product_id` (`product_id`),
KEY `variation_id` (`variation_id`),
KEY `priority` (`priority`),
KEY `added_at` (`added_at`),
CONSTRAINT `fk_wishlist_items_collection` FOREIGN KEY (`collection_id`) REFERENCES `wp_stw_collections` (`id`) ON DELETE CASCADE,
CONSTRAINT `fk_wishlist_items_product` FOREIGN KEY (`product_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Cannot add foreign key constraint]CREATE TABLE IF NOT EXISTS `wp_stw_collection_sharing` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`collection_id` bigint(20) unsigned NOT NULL,
`share_token` varchar(64) NOT NULL,
`expires_at` datetime DEFAULT NULL,
`view_count` int(11) DEFAULT 0,
`created_at` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `share_token` (`share_token`),
KEY `collection_id` (`collection_id`),
KEY `expires_at` (`expires_at`),
CONSTRAINT `fk_wishlist_shares_collection` FOREIGN KEY (`collection_id`) REFERENCES `wp_stw_collections` (`id`) ON DELETE CASCADE
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collection_items' doesn't exist]SHOW INDEX FROM `wp_stw_collection_items` WHERE Key_name = 'collection_product'
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collection_items' doesn't exist]SHOW INDEX FROM `wp_stw_collection_items` WHERE Key_name = 'variation_id'
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collection_items' doesn't exist]ALTER TABLE `wp_stw_collection_items` ADD KEY `variation_id` (`variation_id`)
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collection_items' doesn't exist]SHOW INDEX FROM `wp_stw_collection_items` WHERE Key_name = 'collection_product_variation'
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collection_items' doesn't exist]ALTER TABLE `wp_stw_collection_items` ADD UNIQUE KEY `collection_product_variation` (`collection_id`,`product_id`,`variation_id`)
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collections' doesn't exist]SELECT * FROM wp_stw_collections WHERE 1=1 AND status = 'publish' AND is_default = 1 AND is_public = 1 ORDER BY id DESC LIMIT 10 OFFSET 0
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collections' doesn't exist]SELECT COUNT(*) FROM wp_stw_collections WHERE 1=1 AND status = 'publish' AND is_default = 1 AND is_public = 1
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collections' doesn't exist]SELECT * FROM wp_stw_collections WHERE 1=1 AND status = 'publish' AND is_public = 1 ORDER BY id DESC LIMIT 10 OFFSET 0
WordPress database error: [Table 'blackbro_wrdp1.wp_stw_collections' doesn't exist]SELECT COUNT(*) FROM wp_stw_collections WHERE 1=1 AND status = 'publish' AND is_public = 1
Handmade earrings can be as simple as a single bead attached to a wire or they can be as complex as multiple tiny beads and wires intertwined to form extravagant pieces of art. The look of the earrings depends mostly on the style of the individual artist.