CREATE TABLE `{{table_prefix}}ps` (
 `version` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
 `purchase_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 PRIMARY KEY (`version`),
 KEY `purchase_code` (`purchase_code`),
 KEY `version` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO {{table_prefix}}ps (version, purchase_code) VALUES ("{{version}}",NULL);

INSERT INTO {{table_prefix}}options (option_name, option_value, autoload) VALUES (
  'ps_all_global_options_default',
  'a:2:{s:17:"ps_global_options";a:169:{s:30:"ps_options_progress_bar_active";s:16:"progress_bar_off";s:31:"ps_options_position_progressbar";s:18:"progressbar_bottom";s:36:"ps_options_background_first_progress";s:7:"#f2f2f2";s:37:"ps_options_background_second_progress";s:7:"#0f9bd4";s:36:"ps_options_progress_bar_height_value";s:2:"15";s:31:"ps_options_br_top_left_progress";s:2:"10";s:32:"ps_options_br_top_right_progress";s:2:"10";s:34:"ps_options_br_bottom_left_progress";s:2:"10";s:35:"ps_options_br_bottom_right_progress";s:2:"10";s:30:"ps_options_margin_top_progress";s:2:"10";s:32:"ps_options_margin_right_progress";s:1:"0";s:33:"ps_options_margin_bottom_progress";s:1:"0";s:31:"ps_options_margin_left_progress";s:1:"0";s:40:"ps_options_br_top_left_general_container";s:1:"5";s:41:"ps_options_br_top_right_general_container";s:1:"5";s:43:"ps_options_br_bottom_left_general_container";s:1:"5";s:44:"ps_options_br_bottom_right_general_container";s:1:"5";s:40:"ps_options_padding_top_general_container";s:2:"10";s:42:"ps_options_padding_right_general_container";s:1:"0";s:41:"ps_options_padding_left_general_container";s:1:"0";s:43:"ps_options_padding_bottom_general_container";s:2:"10";s:39:"ps_options_margin_top_general_container";s:2:"10";s:41:"ps_options_margin_right_general_container";s:1:"0";s:40:"ps_options_margin_left_general_container";s:1:"0";s:42:"ps_options_margin_bottom_general_container";s:2:"10";s:41:"ps_options_color_border_general_container";s:7:"#fcfcfc";s:45:"ps_options_color_background_general_container";s:7:"#ffffff";s:41:"ps_options_border_width_general_container";s:1:"1";s:41:"ps_options_border_style_general_container";s:5:"solid";s:28:"ps_options_br_top_left_boxed";s:1:"5";s:29:"ps_options_br_top_right_boxed";s:1:"5";s:31:"ps_options_br_bottom_left_boxed";s:1:"5";s:32:"ps_options_br_bottom_right_boxed";s:1:"5";s:28:"ps_options_padding_boxed_top";s:2:"30";s:30:"ps_options_padding_boxed_right";s:2:"30";s:29:"ps_options_padding_boxed_left";s:2:"30";s:31:"ps_options_padding_boxed_bottom";s:2:"30";s:27:"ps_options_margin_boxed_top";s:2:"15";s:29:"ps_options_margin_boxed_right";s:1:"0";s:28:"ps_options_margin_boxed_left";s:1:"0";s:30:"ps_options_margin_boxed_bottom";s:2:"15";s:29:"ps_options_color_border_boxed";s:7:"#ffffff";s:33:"ps_options_color_background_boxed";s:7:"#ffffff";s:29:"ps_options_border_width_boxed";s:1:"1";s:29:"ps_options_border_style_boxed";s:5:"solid";s:32:"ps_options_setting_question_font";s:28:"Arial, Helvetica, sans-serif";s:32:"ps_options_font_weight_questions";s:3:"500";s:35:"ps_options_setting_description_font";s:28:"Arial, Helvetica, sans-serif";s:35:"ps_options_font_weight_descriptions";s:3:"100";s:29:"ps_options_setting_label_font";s:28:"Arial, Helvetica, sans-serif";s:29:"ps_options_font_weight_labels";s:3:"100";s:30:"ps_options_setting_button_font";s:28:"Arial, Helvetica, sans-serif";s:30:"ps_options_font_weight_buttons";s:3:"100";s:30:"ps_options_font_size_questions";s:2:"25";s:32:"ps_options_line_height_questions";s:2:"35";s:35:"ps_options_letter_spacing_questions";s:1:"1";s:33:"ps_options_font_size_descriptions";s:2:"16";s:35:"ps_options_line_height_descriptions";s:2:"25";s:38:"ps_options_letter_spacing_descriptions";s:1:"0";s:27:"ps_options_font_size_labels";s:2:"16";s:29:"ps_options_line_height_labels";s:2:"25";s:32:"ps_options_letter_spacing_labels";s:1:"0";s:28:"ps_options_font_size_buttons";s:2:"20";s:30:"ps_options_line_height_buttons";s:2:"25";s:33:"ps_options_letter_spacing_buttons";s:1:"0";s:33:"ps_options_color_questions_option";s:7:"#0f9bd4";s:35:"ps_options_color_description_option";s:7:"#4f4f4f";s:30:"ps_options_color_labels_option";s:7:"#4f4f4f";s:31:"ps_options_color_buttons_option";s:7:"#ffffff";s:34:"ps_options_color_pagination_option";s:7:"#4f4f4f";s:26:"ps_options_color_text_form";s:7:"#444444";s:32:"ps_options_color_background_form";s:7:"#f7f7f7";s:28:"ps_options_color_border_form";s:7:"#f2f2f2";s:28:"ps_options_border_width_form";s:1:"2";s:28:"ps_options_border_style_form";s:5:"solid";s:28:"ps_options_br_top_left_forms";s:1:"3";s:29:"ps_options_br_top_right_forms";s:1:"3";s:31:"ps_options_br_bottom_left_forms";s:1:"3";s:32:"ps_options_br_bottom_right_forms";s:1:"3";s:28:"ps_options_padding_forms_top";s:2:"10";s:30:"ps_options_padding_forms_right";s:2:"10";s:29:"ps_options_padding_forms_left";s:2:"10";s:31:"ps_options_padding_forms_bottom";s:2:"10";s:32:"ps_options_color_text_form_focus";s:7:"#0f9bd4";s:38:"ps_options_color_background_form_focus";s:7:"#ffffff";s:34:"ps_options_color_border_form_focus";s:7:"#0f9bd4";s:34:"ps_options_border_width_form_focus";s:1:"2";s:34:"ps_options_border_style_form_focus";s:5:"solid";s:34:"ps_options_br_top_left_forms_focus";s:1:"3";s:35:"ps_options_br_top_right_forms_focus";s:1:"3";s:37:"ps_options_br_bottom_left_forms_focus";s:1:"3";s:38:"ps_options_br_bottom_right_forms_focus";s:1:"3";s:34:"ps_options_padding_forms_top_focus";s:2:"10";s:36:"ps_options_padding_forms_right_focus";s:2:"10";s:35:"ps_options_padding_forms_left_focus";s:2:"10";s:37:"ps_options_padding_forms_bottom_focus";s:2:"10";s:30:"ps_options_br_top_left_buttons";s:1:"3";s:31:"ps_options_br_top_right_buttons";s:1:"3";s:33:"ps_options_br_bottom_left_buttons";s:1:"3";s:34:"ps_options_br_bottom_right_buttons";s:1:"3";s:30:"ps_options_padding_buttons_top";s:2:"15";s:32:"ps_options_padding_buttons_right";s:2:"20";s:31:"ps_options_padding_buttons_left";s:2:"20";s:33:"ps_options_padding_buttons_bottom";s:2:"15";s:29:"ps_options_margin_buttons_top";s:2:"20";s:31:"ps_options_margin_buttons_right";s:1:"0";s:30:"ps_options_margin_buttons_left";s:1:"0";s:32:"ps_options_margin_buttons_bottom";s:2:"10";s:31:"ps_options_color_border_buttons";s:7:"#0f9bd4";s:35:"ps_options_color_background_buttons";s:7:"#0f9bd4";s:31:"ps_options_border_width_buttons";s:1:"1";s:31:"ps_options_border_style_buttons";s:5:"solid";s:38:"ps_options_color_background_datepicker";s:7:"#0f9bd4";s:34:"ps_options_border_color_checkradio";s:7:"#353535";s:38:"ps_options_background_color_checkradio";s:7:"#ffffff";s:45:"ps_options_active_background_color_checkradio";s:7:"#0f9bd4";s:40:"ps_options_background_color_table_matrix";s:7:"#ffffff";s:39:"ps_options_alternate_color_table_matrix";s:7:"#f4f4f4";s:36:"ps_options_border_color_table_matrix";s:7:"#efefef";s:36:"ps_options_border_width_table_matrix";s:1:"1";s:36:"ps_options_border_style_table_matrix";s:5:"solid";s:41:"ps_options_padding_top_bottom_cell_matrix";s:2:"10";s:41:"ps_options_padding_right_left_cell_matrix";s:2:"10";s:27:"ps_options_modal_bar_active";s:11:"ps_modal_on";s:35:"ps_options_br_top_left_image_choice";s:1:"3";s:36:"ps_options_br_top_right_image_choice";s:1:"3";s:38:"ps_options_br_bottom_left_image_choice";s:1:"3";s:39:"ps_options_br_bottom_right_image_choice";s:1:"3";s:35:"ps_options_padding_top_image_choice";s:2:"10";s:37:"ps_options_padding_right_image_choice";s:2:"10";s:36:"ps_options_padding_left_image_choice";s:2:"10";s:38:"ps_options_padding_bottom_image_choice";s:2:"10";s:36:"ps_options_color_border_image_choice";s:7:"#eaeaea";s:40:"ps_options_color_background_image_choice";s:7:"#ffffff";s:36:"ps_options_border_width_image_choice";s:1:"1";s:36:"ps_options_border_style_image_choice";s:5:"solid";s:39:"ps_options_settings_position_pagination";s:15:"above_questions";s:21:"ps_options_dots_width";s:2:"15";s:22:"ps_options_dots_height";s:2:"15";s:39:"ps_options_color_border_pagination_dots";s:7:"#f4f4f4";s:43:"ps_options_color_background_pagination_dots";s:7:"#dddddd";s:47:"ps_options_color_border_pagination_current_dots";s:7:"#0f9bd4";s:51:"ps_options_color_background_pagination_current_dots";s:7:"#0f9bd4";s:48:"ps_options_color_border_pagination_complete_dots";s:7:"#0f9bd4";s:52:"ps_options_color_background_pagination_complete_dots";s:7:"#ffffff";s:39:"ps_options_border_width_pagination_dots";s:1:"2";s:39:"ps_options_border_style_pagination_dots";s:5:"solid";s:27:"ps_options_br_top_left_dots";s:3:"100";s:28:"ps_options_br_top_right_dots";s:3:"100";s:30:"ps_options_br_bottom_left_dots";s:3:"100";s:31:"ps_options_br_bottom_right_dots";s:3:"100";s:33:"ps_options_br_top_left_pagination";s:1:"5";s:34:"ps_options_br_top_right_pagination";s:1:"5";s:36:"ps_options_br_bottom_left_pagination";s:1:"5";s:37:"ps_options_br_bottom_right_pagination";s:1:"5";s:33:"ps_options_padding_pagination_top";s:2:"10";s:35:"ps_options_padding_pagination_right";s:2:"10";s:34:"ps_options_padding_pagination_left";s:2:"10";s:36:"ps_options_padding_pagination_bottom";s:2:"10";s:32:"ps_options_margin_pagination_top";s:2:"10";s:34:"ps_options_margin_pagination_right";s:1:"0";s:33:"ps_options_margin_pagination_left";s:1:"0";s:35:"ps_options_margin_pagination_bottom";s:2:"30";s:34:"ps_options_color_border_pagination";s:7:"#ffffff";s:38:"ps_options_color_background_pagination";s:7:"#ffffff";s:34:"ps_options_border_width_pagination";s:1:"1";s:34:"ps_options_border_style_pagination";s:5:"solid";s:32:"ps_options_pagination_text_align";s:6:"Center";s:21:"ps_options_custom_css";s:0:"";}s:6:"action";s:19:"save_global_setting";}',
  'yes'
),(
  'ps_all_global_options',
  'a:2:{s:17:"ps_global_options";a:169:{s:30:"ps_options_progress_bar_active";s:16:"progress_bar_off";s:31:"ps_options_position_progressbar";s:18:"progressbar_bottom";s:36:"ps_options_background_first_progress";s:7:"#f2f2f2";s:37:"ps_options_background_second_progress";s:7:"#0f9bd4";s:36:"ps_options_progress_bar_height_value";s:2:"15";s:31:"ps_options_br_top_left_progress";s:2:"10";s:32:"ps_options_br_top_right_progress";s:2:"10";s:34:"ps_options_br_bottom_left_progress";s:2:"10";s:35:"ps_options_br_bottom_right_progress";s:2:"10";s:30:"ps_options_margin_top_progress";s:2:"10";s:32:"ps_options_margin_right_progress";s:1:"0";s:33:"ps_options_margin_bottom_progress";s:1:"0";s:31:"ps_options_margin_left_progress";s:1:"0";s:40:"ps_options_br_top_left_general_container";s:1:"5";s:41:"ps_options_br_top_right_general_container";s:1:"5";s:43:"ps_options_br_bottom_left_general_container";s:1:"5";s:44:"ps_options_br_bottom_right_general_container";s:1:"5";s:40:"ps_options_padding_top_general_container";s:2:"10";s:42:"ps_options_padding_right_general_container";s:1:"0";s:41:"ps_options_padding_left_general_container";s:1:"0";s:43:"ps_options_padding_bottom_general_container";s:2:"10";s:39:"ps_options_margin_top_general_container";s:2:"10";s:41:"ps_options_margin_right_general_container";s:1:"0";s:40:"ps_options_margin_left_general_container";s:1:"0";s:42:"ps_options_margin_bottom_general_container";s:2:"10";s:41:"ps_options_color_border_general_container";s:7:"#fcfcfc";s:45:"ps_options_color_background_general_container";s:7:"#ffffff";s:41:"ps_options_border_width_general_container";s:1:"1";s:41:"ps_options_border_style_general_container";s:5:"solid";s:28:"ps_options_br_top_left_boxed";s:1:"5";s:29:"ps_options_br_top_right_boxed";s:1:"5";s:31:"ps_options_br_bottom_left_boxed";s:1:"5";s:32:"ps_options_br_bottom_right_boxed";s:1:"5";s:28:"ps_options_padding_boxed_top";s:2:"30";s:30:"ps_options_padding_boxed_right";s:2:"30";s:29:"ps_options_padding_boxed_left";s:2:"30";s:31:"ps_options_padding_boxed_bottom";s:2:"30";s:27:"ps_options_margin_boxed_top";s:2:"15";s:29:"ps_options_margin_boxed_right";s:1:"0";s:28:"ps_options_margin_boxed_left";s:1:"0";s:30:"ps_options_margin_boxed_bottom";s:2:"15";s:29:"ps_options_color_border_boxed";s:7:"#ffffff";s:33:"ps_options_color_background_boxed";s:7:"#ffffff";s:29:"ps_options_border_width_boxed";s:1:"1";s:29:"ps_options_border_style_boxed";s:5:"solid";s:32:"ps_options_setting_question_font";s:28:"Arial, Helvetica, sans-serif";s:32:"ps_options_font_weight_questions";s:3:"500";s:35:"ps_options_setting_description_font";s:28:"Arial, Helvetica, sans-serif";s:35:"ps_options_font_weight_descriptions";s:3:"100";s:29:"ps_options_setting_label_font";s:28:"Arial, Helvetica, sans-serif";s:29:"ps_options_font_weight_labels";s:3:"100";s:30:"ps_options_setting_button_font";s:28:"Arial, Helvetica, sans-serif";s:30:"ps_options_font_weight_buttons";s:3:"100";s:30:"ps_options_font_size_questions";s:2:"25";s:32:"ps_options_line_height_questions";s:2:"35";s:35:"ps_options_letter_spacing_questions";s:1:"1";s:33:"ps_options_font_size_descriptions";s:2:"16";s:35:"ps_options_line_height_descriptions";s:2:"25";s:38:"ps_options_letter_spacing_descriptions";s:1:"0";s:27:"ps_options_font_size_labels";s:2:"16";s:29:"ps_options_line_height_labels";s:2:"25";s:32:"ps_options_letter_spacing_labels";s:1:"0";s:28:"ps_options_font_size_buttons";s:2:"20";s:30:"ps_options_line_height_buttons";s:2:"25";s:33:"ps_options_letter_spacing_buttons";s:1:"0";s:33:"ps_options_color_questions_option";s:7:"#0f9bd4";s:35:"ps_options_color_description_option";s:7:"#4f4f4f";s:30:"ps_options_color_labels_option";s:7:"#4f4f4f";s:31:"ps_options_color_buttons_option";s:7:"#ffffff";s:34:"ps_options_color_pagination_option";s:7:"#4f4f4f";s:26:"ps_options_color_text_form";s:7:"#444444";s:32:"ps_options_color_background_form";s:7:"#f7f7f7";s:28:"ps_options_color_border_form";s:7:"#f2f2f2";s:28:"ps_options_border_width_form";s:1:"2";s:28:"ps_options_border_style_form";s:5:"solid";s:28:"ps_options_br_top_left_forms";s:1:"3";s:29:"ps_options_br_top_right_forms";s:1:"3";s:31:"ps_options_br_bottom_left_forms";s:1:"3";s:32:"ps_options_br_bottom_right_forms";s:1:"3";s:28:"ps_options_padding_forms_top";s:2:"10";s:30:"ps_options_padding_forms_right";s:2:"10";s:29:"ps_options_padding_forms_left";s:2:"10";s:31:"ps_options_padding_forms_bottom";s:2:"10";s:32:"ps_options_color_text_form_focus";s:7:"#0f9bd4";s:38:"ps_options_color_background_form_focus";s:7:"#ffffff";s:34:"ps_options_color_border_form_focus";s:7:"#0f9bd4";s:34:"ps_options_border_width_form_focus";s:1:"2";s:34:"ps_options_border_style_form_focus";s:5:"solid";s:34:"ps_options_br_top_left_forms_focus";s:1:"3";s:35:"ps_options_br_top_right_forms_focus";s:1:"3";s:37:"ps_options_br_bottom_left_forms_focus";s:1:"3";s:38:"ps_options_br_bottom_right_forms_focus";s:1:"3";s:34:"ps_options_padding_forms_top_focus";s:2:"10";s:36:"ps_options_padding_forms_right_focus";s:2:"10";s:35:"ps_options_padding_forms_left_focus";s:2:"10";s:37:"ps_options_padding_forms_bottom_focus";s:2:"10";s:30:"ps_options_br_top_left_buttons";s:1:"3";s:31:"ps_options_br_top_right_buttons";s:1:"3";s:33:"ps_options_br_bottom_left_buttons";s:1:"3";s:34:"ps_options_br_bottom_right_buttons";s:1:"3";s:30:"ps_options_padding_buttons_top";s:2:"15";s:32:"ps_options_padding_buttons_right";s:2:"20";s:31:"ps_options_padding_buttons_left";s:2:"20";s:33:"ps_options_padding_buttons_bottom";s:2:"15";s:29:"ps_options_margin_buttons_top";s:2:"20";s:31:"ps_options_margin_buttons_right";s:1:"0";s:30:"ps_options_margin_buttons_left";s:1:"0";s:32:"ps_options_margin_buttons_bottom";s:2:"10";s:31:"ps_options_color_border_buttons";s:7:"#0f9bd4";s:35:"ps_options_color_background_buttons";s:7:"#0f9bd4";s:31:"ps_options_border_width_buttons";s:1:"1";s:31:"ps_options_border_style_buttons";s:5:"solid";s:38:"ps_options_color_background_datepicker";s:7:"#0f9bd4";s:34:"ps_options_border_color_checkradio";s:7:"#353535";s:38:"ps_options_background_color_checkradio";s:7:"#ffffff";s:45:"ps_options_active_background_color_checkradio";s:7:"#0f9bd4";s:40:"ps_options_background_color_table_matrix";s:7:"#ffffff";s:39:"ps_options_alternate_color_table_matrix";s:7:"#f4f4f4";s:36:"ps_options_border_color_table_matrix";s:7:"#efefef";s:36:"ps_options_border_width_table_matrix";s:1:"1";s:36:"ps_options_border_style_table_matrix";s:5:"solid";s:41:"ps_options_padding_top_bottom_cell_matrix";s:2:"10";s:41:"ps_options_padding_right_left_cell_matrix";s:2:"10";s:27:"ps_options_modal_bar_active";s:11:"ps_modal_on";s:35:"ps_options_br_top_left_image_choice";s:1:"3";s:36:"ps_options_br_top_right_image_choice";s:1:"3";s:38:"ps_options_br_bottom_left_image_choice";s:1:"3";s:39:"ps_options_br_bottom_right_image_choice";s:1:"3";s:35:"ps_options_padding_top_image_choice";s:2:"10";s:37:"ps_options_padding_right_image_choice";s:2:"10";s:36:"ps_options_padding_left_image_choice";s:2:"10";s:38:"ps_options_padding_bottom_image_choice";s:2:"10";s:36:"ps_options_color_border_image_choice";s:7:"#eaeaea";s:40:"ps_options_color_background_image_choice";s:7:"#ffffff";s:36:"ps_options_border_width_image_choice";s:1:"1";s:36:"ps_options_border_style_image_choice";s:5:"solid";s:39:"ps_options_settings_position_pagination";s:15:"above_questions";s:21:"ps_options_dots_width";s:2:"15";s:22:"ps_options_dots_height";s:2:"15";s:39:"ps_options_color_border_pagination_dots";s:7:"#f4f4f4";s:43:"ps_options_color_background_pagination_dots";s:7:"#dddddd";s:47:"ps_options_color_border_pagination_current_dots";s:7:"#0f9bd4";s:51:"ps_options_color_background_pagination_current_dots";s:7:"#0f9bd4";s:48:"ps_options_color_border_pagination_complete_dots";s:7:"#0f9bd4";s:52:"ps_options_color_background_pagination_complete_dots";s:7:"#ffffff";s:39:"ps_options_border_width_pagination_dots";s:1:"2";s:39:"ps_options_border_style_pagination_dots";s:5:"solid";s:27:"ps_options_br_top_left_dots";s:3:"100";s:28:"ps_options_br_top_right_dots";s:3:"100";s:30:"ps_options_br_bottom_left_dots";s:3:"100";s:31:"ps_options_br_bottom_right_dots";s:3:"100";s:33:"ps_options_br_top_left_pagination";s:1:"5";s:34:"ps_options_br_top_right_pagination";s:1:"5";s:36:"ps_options_br_bottom_left_pagination";s:1:"5";s:37:"ps_options_br_bottom_right_pagination";s:1:"5";s:33:"ps_options_padding_pagination_top";s:2:"10";s:35:"ps_options_padding_pagination_right";s:2:"10";s:34:"ps_options_padding_pagination_left";s:2:"10";s:36:"ps_options_padding_pagination_bottom";s:2:"10";s:32:"ps_options_margin_pagination_top";s:2:"10";s:34:"ps_options_margin_pagination_right";s:1:"0";s:33:"ps_options_margin_pagination_left";s:1:"0";s:35:"ps_options_margin_pagination_bottom";s:2:"30";s:34:"ps_options_color_border_pagination";s:7:"#ffffff";s:38:"ps_options_color_background_pagination";s:7:"#ffffff";s:34:"ps_options_border_width_pagination";s:1:"1";s:34:"ps_options_border_style_pagination";s:5:"solid";s:32:"ps_options_pagination_text_align";s:6:"Center";s:21:"ps_options_custom_css";s:0:"";}s:6:"action";s:19:"save_global_setting";}',
  'yes'
);

CREATE TABLE `{{table_prefix}}ps_answers` (
 `answer_id` int(11) NOT NULL AUTO_INCREMENT,
 `question_id` int(11) NOT NULL,
 `image` int(11) DEFAULT NULL COMMENT 'id post media',
 `image_properties` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `text` varchar(255) CHARACTER SET utf32 COLLATE utf32_unicode_ci NOT NULL,
 `description` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
 `position` int(11) DEFAULT NULL,
 PRIMARY KEY (`answer_id`),
 KEY `position` (`position`),
 KEY `question_id` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `{{table_prefix}}ps_answers_values` (
 `answer_value_id` int(11) NOT NULL AUTO_INCREMENT,
 `question_id` int(11) NOT NULL,
 `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `position` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`answer_value_id`),
 KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `{{table_prefix}}ps_data` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `question_id` int(11) NOT NULL,
 `user_id` int(11) DEFAULT NULL,
 `session_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
 `answer_id` int(11) DEFAULT NULL,
 `answer_value_id` int(11) DEFAULT NULL,
 `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `creation_datetime` datetime NOT NULL,
 `ip` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
 PRIMARY KEY (`id`),
 KEY `answer_value_id` (`answer_value_id`),
 KEY `session_id` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `{{table_prefix}}ps_questions` (
 `question_id` int(11) NOT NULL AUTO_INCREMENT,
 `ID` int(11) NOT NULL COMMENT 'the post ID',
 `type` enum('single_choice','multiple_choice','text_span','image','rating','slider','text','matrix') COLLATE utf8_unicode_ci NOT NULL,
 `text` text COLLATE utf8_unicode_ci,
 `description` text COLLATE utf8_unicode_ci,
 `required` tinyint(1) NOT NULL DEFAULT '0',
 `multiple` tinyint(1) NOT NULL DEFAULT '0',
 `image` int(11) DEFAULT NULL,
 `image_properties` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
 `answer_field_type` enum('text','date','number','email','textarea','image','radio','select','checkbox') COLLATE utf8_unicode_ci DEFAULT NULL,
 `answer_show_type` enum('survey_column_settings_layout','survey_row_settings_layout','select') COLLATE utf8_unicode_ci DEFAULT NULL,
 `answer_min_value` int(11) DEFAULT NULL,
 `answer_max_value` int(11) DEFAULT NULL,
 `answer_step_value` int(11) DEFAULT NULL,
 `answer_css_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
 `position` int(11) DEFAULT NULL,
 PRIMARY KEY (`question_id`),
 KEY `multiple` (`multiple`),
 KEY `required` (`required`),
 KEY `answer_min_value` (`answer_min_value`),
 KEY `answer_max_value` (`answer_max_value`),
 KEY `answer_step_value` (`answer_step_value`),
 KEY `post_id` (`ID`),
 KEY `position` (`position`),
 KEY `answer_field_type` (`answer_field_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `{{table_prefix}}ps_logic_conditions` (
 `logic_condition_id` int(11) NOT NULL AUTO_INCREMENT,
 `ID` int(11) NOT NULL,
 `question_id` int(11) DEFAULT NULL,
 `position` int(11) DEFAULT NULL,
 `type` enum('eq','diff') COLLATE utf8_unicode_ci DEFAULT NULL,
 `answer_id` int(11) DEFAULT NULL,
 `question_id_to` int(11) DEFAULT NULL COMMENT 'if 0 go to end, int to relative question id',
 PRIMARY KEY (`logic_condition_id`),
 KEY `question_id` (`question_id`),
 KEY `condition` (`type`),
 KEY `question_id_to` (`question_id_to`),
 KEY `answer_id` (`answer_id`),
 KEY `ID` (`ID`),
 KEY `position` (`position`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci