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
The following website policies have been updated as of June 25, 2023. Click on the titles below to be taken directly to each of the policy pages. Please send any questions to Kathleen@blackbrookshop.com. GENERAL DISCLAIMER TERMS PRIVACY POLICY