----------------------------------------------------------------------------- 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;