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