---------------------------------------------- TO CREATE A SURVEY----------------------------------------------Create a new survey:--> INSERT INTO `surveys` (`title` ) VALUES ('How old are you ?');Get the ID of the survey just created:--> surveyID = Select LAST_INSERT_ID();Add the option 'Rock' which is number selectionNumber, to this survey:--> INSERT INTO `survey_options` (`survey_id`, `selection_number`, `text`) VALUES("+surveyID+", "+selectionNumber+", 'Rock');To modify an option:--> UPDATE `survey_options` SET `text` = 'Pop/Rock' WHERE `survey__id` ="+surveyID+" AND `selection_number`=1;Add the second option of this survey:--> INSERT INTO `survey_options` (`survey_id`, `selection_number`, `text`) VALUES("+surveyID+", 2, 'Jazz');... etc----------------------------------------------- DEFINE THE DEFAULT SURVEY-----------------------------------------------Determine if there is already a default survey: (if the number returned is greater than 0, there is already a defalu survey)--> SELECT count(*) FROM `activations` WHERE `activations`.`type` = 'survey' AND `activations`.`desactivation_date` = NULL AND `activations`.`activation_date` = NULL;Insert a new default survey:--> INSERT INTO `activations` (`type`, `type_id`) VALUES ('survey', 1);Modify the default survey (change ID 1 to 2):--> UPDATE `activations` SET `type_id` =2 WHERE `activation_date` = NULL AND `desactivation_date` = NULL LIMIT 1;