-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             12.10.0.7000
-- --------------------------------------------------------


-- Dumping structure for table carpsilviuionut.wpcsi_userfeedback_survey_responses
CREATE TABLE IF NOT EXISTS `wpcsi_userfeedback_survey_responses` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `survey_id` bigint(20) NOT NULL,
  `answers` longtext DEFAULT NULL,
  `page_submitted` text DEFAULT NULL,
  `user_ip` varchar(256) DEFAULT NULL,
  `user_browser` varchar(128) DEFAULT NULL,
  `user_os` varchar(128) DEFAULT NULL,
  `user_device` varchar(64) DEFAULT NULL,
  `status` enum('publish','draft','trash') DEFAULT 'publish',
  `submitted_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `survey_id` (`survey_id`),
  CONSTRAINT `wpcsi_userfeedback_survey_responses_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `wpcsi_userfeedback_surveys` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

-- Dumping data for table carpsilviuionut.wpcsi_userfeedback_survey_responses: ~0 rows (approximately)
DELETE FROM `wpcsi_userfeedback_survey_responses`;

