1#@!#!123s

��JFIF�� 1#@!#!123s
: / usr / tmp / wp_testing_886f23129a277d7487e9225d0508487d /
Filename : development.log
back
May 20 06:10:31 [info] SELECT version FROM wp_t_schema_migrations
May 20 06:10:31 [info] SELECT version FROM wp_t_schema_migrations
May 20 06:10:31 [info] SELECT version FROM wp_t_schema_migrations
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_posts (
              ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
              post_author bigint(20) unsigned NOT NULL DEFAULT "0",
              post_date datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
              post_date_gmt datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
              post_content longtext NOT NULL,
              post_title text NOT NULL,
              post_excerpt text NOT NULL,
              post_status varchar(20) NOT NULL DEFAULT "publish",
              comment_status varchar(20) NOT NULL DEFAULT "open",
              ping_status varchar(20) NOT NULL DEFAULT "open",
              post_password varchar(20) NOT NULL DEFAULT "",
              post_name varchar(200) NOT NULL DEFAULT "",
              to_ping text NOT NULL,
              pinged text NOT NULL,
              post_modified datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
              post_modified_gmt datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
              post_content_filtered longtext NOT NULL,
              post_parent bigint(20) unsigned NOT NULL DEFAULT "0",
              guid varchar(255) NOT NULL DEFAULT "",
              menu_order int(11) NOT NULL DEFAULT "0",
              post_type varchar(20) NOT NULL DEFAULT "post",
              post_mime_type varchar(100) NOT NULL DEFAULT "",
              comment_count bigint(20) NOT NULL DEFAULT "0",
              PRIMARY KEY (ID),
              KEY post_name (post_name),
              KEY type_status_date (post_type,post_status,post_date,ID),
              KEY post_parent (post_parent),
              KEY post_author (post_author)
            ) DEFAULT CHARSET=utf8
        ;
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_terms (
              term_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
              name varchar(200) NOT NULL DEFAULT "",
              slug varchar(200) NOT NULL DEFAULT "",
              term_group bigint(10) NOT NULL DEFAULT "0",
              PRIMARY KEY (term_id),
              UNIQUE KEY slug (slug),
              KEY name (name)
            ) DEFAULT CHARSET=utf8 ENGINE=MyISAM
        ;
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_users (
              ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
              user_login varchar(60) NOT NULL DEFAULT "",
              user_pass varchar(64) NOT NULL DEFAULT "",
              user_nicename varchar(50) NOT NULL DEFAULT "",
              user_email varchar(100) NOT NULL DEFAULT "",
              user_url varchar(100) NOT NULL DEFAULT "",
              user_registered datetime NOT NULL DEFAULT "0000-00-00 00:00:00",
              user_activation_key varchar(60) NOT NULL DEFAULT "",
              user_status int(11) NOT NULL DEFAULT "0",
              display_name varchar(250) NOT NULL DEFAULT "",
              PRIMARY KEY (ID),
              KEY user_login_key (user_login),
              KEY user_nicename (user_nicename)
            ) DEFAULT CHARSET=utf8
        ;
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_term_taxonomy (
              term_taxonomy_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
              term_id bigint(20) unsigned NOT NULL DEFAULT "0",
              taxonomy varchar(32) NOT NULL DEFAULT "",
              description longtext NOT NULL,
              parent bigint(20) unsigned NOT NULL DEFAULT "0",
              count bigint(20) NOT NULL DEFAULT "0",
              PRIMARY KEY (term_taxonomy_id),
              UNIQUE KEY term_id_taxonomy (term_id,taxonomy),
              KEY taxonomy (taxonomy)
            ) DEFAULT CHARSET=utf8
        ;
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_term_relationships (
              object_id bigint(20) unsigned NOT NULL DEFAULT "0",
              term_taxonomy_id bigint(20) unsigned NOT NULL DEFAULT "0",
              term_order int(11) NOT NULL DEFAULT "0",
              PRIMARY KEY (object_id,term_taxonomy_id),
              KEY term_taxonomy_id (term_taxonomy_id)
            ) DEFAULT CHARSET=utf8
        ;
May 20 06:10:31 [info] 
            CREATE TABLE IF NOT EXISTS wp_postmeta (
                meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                post_id bigint(20) unsigned NOT NULL DEFAULT "0",
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext,
                PRIMARY KEY (meta_id),
                KEY post_id (post_id),
                KEY meta_key (meta_key)
            ) DEFAULT CHARSET=utf8
        ;
May 20 06:10:31 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20140901000000')
May 20 06:10:31 [info] SHOW TABLE STATUS
May 20 06:10:31 [info] DROP TABLE IF EXISTS `wp_t_questions`
May 20 06:10:31 [info] CREATE TABLE `wp_t_questions` (
`question_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`question_title` text NOT NULL,
 PRIMARY KEY (`question_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:31 [info] ALTER TABLE wp_t_questions 
            ADD CONSTRAINT wp_t_fk_question_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_question_test(test_id)
        
May 20 06:10:31 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20140913082248')
May 20 06:10:31 [info] SHOW TABLE STATUS
May 20 06:10:31 [info] DROP TABLE IF EXISTS `wp_t_scores`
May 20 06:10:31 [info] CREATE TABLE `wp_t_scores` (
`answer_id` bigint UNSIGNED NOT NULL,
`question_id` bigint UNSIGNED NOT NULL,
`scale_id` bigint UNSIGNED NOT NULL,
`score_value` tinyint DEFAULT 0 NOT NULL,
 PRIMARY KEY (`answer_id`,`question_id`,`scale_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:31 [info] ALTER TABLE wp_t_scores 
            ADD CONSTRAINT wp_t_fk_score_answer
            FOREIGN KEY (answer_id)
            REFERENCES wp_terms(term_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_score_answer(answer_id)
        ,

            ADD CONSTRAINT wp_t_fk_score_question
            FOREIGN KEY (question_id)
            REFERENCES wp_t_questions(question_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_score_question(question_id)
        ,

            ADD CONSTRAINT wp_t_fk_score_scale
            FOREIGN KEY (scale_id)
            REFERENCES wp_terms(term_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_score_scale(scale_id)
        
May 20 06:10:31 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20140916030608')
May 20 06:10:31 [info] SHOW TABLE STATUS
May 20 06:10:31 [info] DROP TABLE IF EXISTS `wp_t_passings`
May 20 06:10:31 [info] CREATE TABLE `wp_t_passings` (
`passing_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`respondent_id` bigint UNSIGNED,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
 PRIMARY KEY (`passing_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:31 [info] ALTER TABLE wp_t_passings 
            ADD CONSTRAINT wp_t_fk_passing_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_passing_test(test_id)
        ,

            ADD CONSTRAINT wp_t_fk_passing_respondent
            FOREIGN KEY (respondent_id)
            REFERENCES wp_users(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_passing_respondent(respondent_id)
        
May 20 06:10:31 [info] SHOW TABLE STATUS
May 20 06:10:31 [info] DROP TABLE IF EXISTS `wp_t_passing_answers`
May 20 06:10:31 [info] CREATE TABLE `wp_t_passing_answers` (
`answer_id` bigint UNSIGNED NOT NULL,
`question_id` bigint UNSIGNED NOT NULL,
`passing_id` bigint UNSIGNED NOT NULL,
 PRIMARY KEY (`answer_id`,`question_id`,`passing_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:31 [info] ALTER TABLE wp_t_passing_answers 
            ADD CONSTRAINT wp_t_fk_passing_answer_answer
            FOREIGN KEY (answer_id)
            REFERENCES wp_terms(term_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_passing_answer_answer(answer_id)
        ,

            ADD CONSTRAINT wp_t_fk_passing_answer_question
            FOREIGN KEY (question_id)
            REFERENCES wp_t_questions(question_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_passing_answer_question(question_id)
        ,

            ADD CONSTRAINT wp_t_fk_passing_answer_passing
            FOREIGN KEY (passing_id)
            REFERENCES wp_t_passings(passing_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_passing_answer_passing(passing_id)
        
May 20 06:10:31 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20140925023344')
May 20 06:10:31 [info] 
            INSERT INTO wp_posts (
                post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt,
                post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged,
                post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order,
                post_type, post_mime_type, comment_count
            ) VALUES (
                1, NOW(), NOW(), 'The Eysenck Personality Inventory (EPI) measures two pervasive,  independent dimensions of personality,  Extraversion-Introversion and Neuroticism-Stability,  which account for most of the variance in the personality domain. Each form contains 57 "Yes-No" items with no repetition of items. The inclusion of a falsification scale provides for the detection of response distortion. The traits measured are Extraversion-Introversion and Neuroticism.<!--more--> When you fill out Eysenck’s Personality Inventory (EPI) you get three scores.
<ul>
	<li>The ‘lie score’ is out of 9. It measures how socially desirable you are trying to be in your answers.Those who score 5 or more on this scale are probably trying to make themselves look good and are not being totally honest in their responses.</li>
	<li>The ‘E score’ is out of 24 and measures how much of an extrovert you are.</li>
	<li>The ‘N score’ is out of 24 and measures how neurotic you are.</li>
</ul>
To interpret the scores,  your E score and your N score are plotted on a graph from which you can read your personality characteristics. The nearer the outside of the circle you are,  the more marked are the personality traits. Please note that the EPI is a very simplistic type of personality measurement scale,  so if you have come out as a personality that does not match what you thought before you took the test,  you are probably right and the test is probably wrong!

<img src="http://blog.luckytobeyoung.com/wp-content/plugins/wp-testing/img/EPI-scales.png" alt="EPI scales" />
<h2>Instructions</h2>
Here are some questions regarding the way you behave,  feel and act. Each question has radio buttons to answer YES or NO. Try to decide whether YES or NO represents your usual way of acting or feeling. Then check those radio named YES or NO. Work quickly,  and don’t spend too much time over any question,  we want your first reaction,  not a long drawn-out thought process. The whole questionnaire shouldn’t take more than a few minutes. Be sure not to omit any questions. Start now,  work quickly and remember to answer every question. There are no right or wrong answers,  and this isn’t a test of intelligence or ability,  but simply a measure of the way you behave.', 'Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)', '', 'publish', 'closed', 'closed', '', 'eysencks-personality-inventory-epi-extroversionintroversion', '', '', NOW(), NOW(), '', 0, UUID(), 0, 'wpt_test', '', 0);

            INSERT INTO wp_terms (name, slug, term_group) VALUES
            ('Yes', 'answer-yes', 0),
            ('No', 'answer-no', 0),
            ('Extraversion/Introversion', 'scale-extraversion-introversion', 0),
            ('Neuroticism/Stability', 'scale-neuroticism-stability', 0),
            ('Lie', 'scale-lie', 0);
        ;
May 20 06:10:32 [info] SELECT ID FROM wp_posts WHERE post_type = 'wpt_test' ORDER BY ID DESC LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'answer-yes' LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'answer-no' LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'scale-extraversion-introversion' LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'scale-neuroticism-stability' LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'scale-lie' LIMIT 1
May 20 06:10:32 [info] 
            INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES
            (713, 'wpt_answer', '', 0, 1),
            (714,  'wpt_answer', '', 0, 1),
            (715,  'wpt_scale',  'Extraversion is characterized by being outgoing,  talkative,  high on positive affect (feeling good),  and in need of external stimulation. According to Eysenck\'s arousal theory of extraversion,  there is an optimal level of cortical arousal,  and performance deteriorates as one becomes more or less aroused than this optimal level. Arousal can be measured by skin conductance,  brain waves or sweating. At very low and very high levels of arousal,  performance is low,  but at a better mid-level of arousal,  performance is maximized.

Extraverts,  according to Eysenck\'s theory,  are chronically under-aroused and bored and are therefore in need of external stimulation to bring them up to an optimal level of performance. About 16 percent of the population tend to fall in this range.

Introverts,  on the other hand,  (also about 16 percent of the population) are chronically over-aroused and jittery and are therefore in need of peace and quiet to bring them up to an optimal level of performance.

Most people (about 68 percent of the population) fall in the midrange of the extraversion/introversion continuum,  an area referred to as ambiversion.', 0, 1),
            (716,  'wpt_scale',  'Neuroticism or emotionality is characterized by high levels of negative affect such as depression and anxiety. Neuroticism,  according to Eysenck\'s theory,  is based on activation thresholds in the sympathetic nervous system or visceral brain. This is the part of the brain that is responsible for the fight-or-flight response in the face of danger. Activation can be measured by heart rate,  blood pressure,  cold hands,  sweating and muscular tension (especially in the forehead).

Neurotic people — who have low activation thresholds,  and unable to inhibit or control their emotional reactions,  experience negative affect (fight-or-flight) in the face of very minor stressors — are easily nervous or upset.

Emotionally stable people — who have high activation thresholds and good emotional control,  experience negative affect only in the face of very major stressors — are calm and collected under pressure.', 0, 1),
            (717, 'wpt_scale',  'It measures how socially desirable you are trying to be in your answers. Those who score 5 or more on this scale are probably trying to make themselves look good and are not being totally honest in their responses.', 0, 1);
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order) VALUES
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 713), 1),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 714),  2),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 715),  1),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 716),  2),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 717), 3);

            INSERT INTO wp_t_questions (test_id, question_title) VALUES
            (1467, 'Do you often long for excitement?'),
            (1467, 'Do you often need understanding friends to cheer you up?'),
            (1467, 'Are you usually carefree?'),
            (1467, 'Do you find it very hard to take no for an answer?'),
            (1467, 'Do you stop and think things over before doing anything?'),
            (1467, 'If you say you will do something do you always keep your promise, no matter how inconvenient it might be to do so?'),
            (1467, 'Do your moods go up and down?'),
            (1467, 'Do you generally do and say things quickly without stopping to think?'),
            (1467, 'Do you ever feel ‘just miserable’ for no good reason?'),
            (1467, 'Would you do almost anything for a dare?'),
            (1467, 'Do you suddenly feel shy when you want to talk to an attractive stranger?'),
            (1467, 'Once in a while do you lose your temper and get angry?'),
            (1467, 'Do you often do things on the spur of the moment?'),
            (1467, 'Do you often worry about things you should have done or said?'),
            (1467, 'Generally do you prefer reading to meeting people?'),
            (1467, 'Are your feelings rather easily hurt?'),
            (1467, 'Do you like going out a lot?'),
            (1467, 'Do you occasionally have thoughts and ideas that you would not like otherpeople to know about?'),
            (1467, 'Are you sometimes bubbling over with energy and sometimes very sluggish?'),
            (1467, 'Do you prefer to have few but special friends?'),
            (1467, 'Do you daydream a lot?'),
            (1467, 'When people shout at you do you shout back?'),
            (1467, 'Are you often troubled about feelings of guilt?'),
            (1467, 'Are all your habits good and desirable ones?'),
            (1467, 'Can you usually let yourself go and enjoy yourself a lot at a lively party?'),
            (1467, 'Would you call yourself tense or ‘highly strung’?'),
            (1467, 'Do other people think of you as being very lively?'),
            (1467, 'After you have done something important, do you come away feelingyou could have done better?'),
            (1467, 'Are you mostly quiet when you are with other people?'),
            (1467, 'Do you sometimes gossip?'),
            (1467, 'Do ideas run through your head so that you cannot sleep?'),
            (1467, 'If there is something you want to know about, would you rather look it upin a book than talk to someone about it?'),
            (1467, 'Do you get palpitations or thumping in your hear?'),
            (1467, 'Do you like the kind of work that you need to pay close attention to?'),
            (1467, 'Do you get attacks of shaking or trembling?'),
            (1467, 'Would you always declare everything at customs, even if you knewyou could never be found out?'),
            (1467, 'Do you hate being with a crowd who play jokes on one another?'),
            (1467, 'Are you an irritable person?'),
            (1467, 'Do you like doing things in which you have to act quickly?'),
            (1467, 'Do you worry about awful things that might happen?'),
            (1467, 'Are you slow and unhurried in the way you move?'),
            (1467, 'Have you ever been late for an appointment or work?'),
            (1467, 'Do you have many nightmares?'),
            (1467, 'Do you like talking to people so much that you never miss a chance of talking toa stranger?'),
            (1467, 'Are you troubled by aches and pains?'),
            (1467, 'Would you be very unhappy if you could not see lots of people most of the time?'),
            (1467, 'Would you call yourself a nervous person?'),
            (1467, 'Of all the people you know, are there some whom you definitely do not like?'),
            (1467, 'Would you say that you were fairly self-confident?'),
            (1467, 'Are you easily hurt when people find fault with you or your work?'),
            (1467, 'Do you find it hard to really enjoy yourself at a lively party?'),
            (1467, 'Are you troubled by feelings of inferiority?'),
            (1467, 'Can you easily get some life into a dull party?'),
            (1467, 'Do you sometimes talk about things you know nothing about?'),
            (1467, 'Do you worry about your health?'),
            (1467, 'Do you like playing pranks on others?'),
            (1467, 'Do you suffer from sleeplessness?');

            INSERT INTO wp_t_scores (answer_id, question_id, scale_id, score_value) VALUES
            (713, 1, 715,  1),
            (713, 2, 716,  1),
            (713, 3, 715,  1),
            (713, 4, 716,  1),
            (714,  5, 715,  1),
            (713, 6, 717, 1),
            (713, 7, 716,  1),
            (713, 8, 715,  1),
            (713, 9, 716,  1),
            (713, 10, 715,  1),
            (713, 11, 716,  1),
            (714,  12, 717, 1),
            (713, 13, 715,  1),
            (713, 14, 716,  1),
            (714,  15, 715,  1),
            (713, 16, 716,  1),
            (713, 17, 715,  1),
            (714,  18, 717, 1),
            (713, 19, 716,  1),
            (714,  20, 715,  1),
            (713, 21, 716,  1),
            (713, 22, 715,  1),
            (713, 23, 716,  1),
            (713, 24, 717, 1),
            (713, 25, 715,  1),
            (713, 26, 716,  1),
            (713, 27, 715,  1),
            (713, 28, 716,  1),
            (714,  29, 715,  1),
            (714,  30, 717, 1),
            (713, 31, 716,  1),
            (714,  32, 715,  1),
            (713, 33, 716,  1),
            (714,  34, 715,  1),
            (713, 35, 716,  1),
            (713, 36, 717, 1),
            (714,  37, 715,  1),
            (713, 38, 716,  1),
            (713, 39, 715,  1),
            (713, 40, 716,  1),
            (714,  41, 715,  1),
            (714,  42, 717, 1),
            (713, 43, 716,  1),
            (713, 44, 715,  1),
            (713, 45, 716,  1),
            (713, 46, 715,  1),
            (713, 47, 716,  1),
            (714,  48, 717, 1),
            (713, 49, 715,  1),
            (713, 50, 716,  1),
            (714,  51, 715,  1),
            (713, 52, 716,  1),
            (713, 53, 715,  1),
            (714,  54, 717, 1),
            (713, 55, 716,  1),
            (713, 56, 715,  1),
            (713, 57, 716,  1);
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20140928160013')
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_formulas`
May 20 06:10:32 [info] CREATE TABLE `wp_t_formulas` (
`formula_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`result_id` bigint UNSIGNED NOT NULL,
`formula_source` text NOT NULL,
 PRIMARY KEY (`formula_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_formulas 
            ADD CONSTRAINT wp_t_fk_formula_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_formula_test(test_id)
        ,

            ADD CONSTRAINT wp_t_fk_formula_result
            FOREIGN KEY (result_id)
            REFERENCES wp_terms(term_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_formula_result(result_id)
        ,

            ADD UNIQUE INDEX uq_formula_test_result(test_id, result_id)
        
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141004124247')
May 20 06:10:32 [info] SELECT ID FROM wp_posts WHERE post_type = 'wpt_test' AND post_name = 'eysencks-personality-inventory-epi-extroversionintroversion' ORDER BY ID LIMIT 1
May 20 06:10:32 [info] 
            INSERT INTO wp_terms
            (name,          slug,                 term_group) VALUES
            ('Sanguine',    'result-sanguine',    0),
            ('Choleric',    'result-choleric',    0),
            ('Melancholic', 'result-melancholic', 0),
            ('Phlegmatic',  'result-phlegmatic',  0);
        ;
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'result-sanguine'    LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'result-choleric'    LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'result-melancholic' LIMIT 1
May 20 06:10:32 [info] SELECT term_id FROM wp_terms WHERE slug = 'result-phlegmatic'  LIMIT 1
May 20 06:10:32 [info] 
            INSERT INTO wp_term_taxonomy
            (taxonomy,     parent, count, term_id,        description) VALUES
            ('wpt_result', 0,      1,     718,    'The sanguine temperament is traditionally associated with air. People with this temperament tend to be lively, sociable, carefree, talkative, and pleasure-seeking. They may be warm-hearted and optimistic. They can make new friends easily, be imaginative and artistic, and often have many ideas. They can be flighty and changeable; thus sanguine personalities may struggle with following tasks all the way through and be chronically late or forgetful.

Pedagogically, they can be best reached through awakening their love for a subject and admiration of people.'),
            ('wpt_result', 0,      1,     719,    'The choleric temperament is traditionally associated with fire. People with this temperament tend to be egocentric and extroverted. They may be excitable, impulsive, and restless, with reserves of aggression, energy, and/or passion, and try to instill that in others.

They tend to be task-oriented people and are focused on getting a job done efficiently; their motto is usually "do it now." They can be ambitious, strong-willed and like to be in charge. They can show leadership, are good at planning, and are often practical and solution-oriented. They appreciate receiving respect and esteem for their work.

Pedagogically, they can be best reached through mutual respect and appropriate challenges that recognize their capacities.'),
            ('wpt_result', 0,      1,     720, 'The melancholic temperament is traditionally associated with the element of earth. People with this temperament may appear serious, introverted, cautious or even suspicious. They can become preoccupied with the tragedy and cruelty in the world and are susceptible to depression and moodiness. They may be focused and conscientious. They often prefer to do things themselves, both to meet their own standards and because they are not inherently sociable.

Pedagogically, they can be best met by awakening their sympathy for others and the suffering of the world.'),
            ('wpt_result', 0,      1,     721,  'The phlegmatic temperament is traditionally associated with water. People with this temperament may be inward and private, thoughtful, reasonable, calm, patient, caring, and tolerant. They tend to have a rich inner life, seek a quiet, peaceful atmosphere, and be content with themselves. They tend to be steadfast, consistent in their habits, and thus steady and faithful friends.

Pedagogically, their interest is often awakened by experiencing others\' interest in a subject.

People of this temperament may appear somewhat ponderous or clumsy. Their speech tends to be slow or appear hesitant.');
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order) VALUES
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 718),    1),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 719),    2),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 720), 3),
            (1467, (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 721),  4);
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_t_formulas (test_id, result_id, formula_source) VALUES
            (1467, 718,     'scale-extraversion-introversion  > 50% AND scale-neuroticism-stability <= 50%'),
            (1467, 719,     'scale-extraversion-introversion  > 50% AND scale-neuroticism-stability  > 50%'),
            (1467, 720,  'scale-extraversion-introversion <= 50% AND scale-neuroticism-stability  > 50%'),
            (1467, 721,   'scale-extraversion-introversion <= 50% AND scale-neuroticism-stability <= 50%');
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141007035029')
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_formulas` LIKE 'formula_source'
May 20 06:10:32 [info] ALTER TABLE `wp_t_formulas` CHANGE `formula_source` `formula_source` text
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141102190330')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_publish_on_home', '1'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141108033658')
May 20 06:10:32 [info] SELECT * FROM wp_t_formulas
May 20 06:10:32 [info] UPDATE wp_t_formulas SET formula_source = "scale-extraversion-introversion  > 50% AND scale-neuroticism-stability <= 50%" WHERE formula_id = 1;
May 20 06:10:32 [info] UPDATE wp_t_formulas SET formula_source = "scale-extraversion-introversion  > 50% AND scale-neuroticism-stability  > 50%" WHERE formula_id = 2;
May 20 06:10:32 [info] UPDATE wp_t_formulas SET formula_source = "scale-extraversion-introversion <= 50% AND scale-neuroticism-stability  > 50%" WHERE formula_id = 3;
May 20 06:10:32 [info] UPDATE wp_t_formulas SET formula_source = "scale-extraversion-introversion <= 50% AND scale-neuroticism-stability <= 50%" WHERE formula_id = 4;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141122130034')
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_answers`
May 20 06:10:32 [info] CREATE TABLE `wp_t_answers` (
`answer_id` bigint UNSIGNED auto_increment NOT NULL,
`question_id` bigint UNSIGNED NOT NULL,
`global_answer_id` bigint UNSIGNED,
`answer_title` text,
 PRIMARY KEY (`answer_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_answers 
            ADD CONSTRAINT wp_t_fk_answer_question
            FOREIGN KEY (question_id)
            REFERENCES wp_t_questions(question_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_answer_question(question_id)
        ,

            ADD CONSTRAINT wp_t_fk_answer_global_answer
            FOREIGN KEY (global_answer_id)
            REFERENCES wp_terms(term_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_answer_global_answer(global_answer_id)
        
May 20 06:10:32 [info] 
            INSERT INTO wp_t_answers
            SELECT DISTINCT
                NULL           AS answer_id,
                q.question_id  AS question_id,
                tt.term_id     AS global_answer_id,
                ''             AS answer_title
            FROM wp_term_taxonomy      AS tt
            JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id
                                                   AND tt.taxonomy = 'wpt_answer'
            JOIN wp_posts              AS t ON tr.object_id = t.id
            JOIN wp_t_questions          AS q ON q.test_id = t.id
            ORDER BY q.question_id, tt.term_id
        ;
May 20 06:10:32 [info] 
            DROP TABLE IF EXISTS wp_t_scores_backup;
            CREATE TABLE wp_t_scores_backup AS
            SELECT
                a.answer_id    AS answer_id,
                scale_id       AS scale_id,
                score_value    AS score_value
            FROM
                wp_t_scores  AS s,
                wp_t_answers AS a
            WHERE TRUE
                AND s.answer_id   = a.global_answer_id
                AND s.question_id = a.question_id
            ;
        ;
May 20 06:10:32 [info] TRUNCATE TABLE wp_t_scores;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_passing_answers
                DROP FOREIGN KEY wp_t_fk_passing_answer_question;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_passing_answers
                DROP FOREIGN KEY wp_t_fk_passing_answer_answer;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_passing_answers
                DROP COLUMN question_id,
                DROP PRIMARY KEY,
                ADD PRIMARY KEY (answer_id, passing_id),
                DROP INDEX fk_passing_answer_question,
                DROP INDEX fk_passing_answer_answer
            ;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_passing_answers
                ADD CONSTRAINT wp_t_fk_passing_answer_answer
                FOREIGN KEY (answer_id)
                REFERENCES wp_t_answers (answer_id)
                ON DELETE CASCADE
                ON UPDATE CASCADE;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_passing_answers
                ADD INDEX fk_passing_answer_answer (answer_id)
        ;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_scores
                DROP FOREIGN KEY wp_t_fk_score_question;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_scores
                DROP FOREIGN KEY wp_t_fk_score_answer;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_scores
                DROP COLUMN question_id,
                DROP PRIMARY KEY,
                ADD PRIMARY KEY (answer_id, scale_id),
                DROP INDEX fk_score_question,
                DROP INDEX fk_score_answer
            ;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_scores
                ADD CONSTRAINT wp_t_fk_score_answer
                FOREIGN KEY (answer_id)
                REFERENCES wp_t_answers (answer_id)
                ON DELETE CASCADE
                ON UPDATE CASCADE;
May 20 06:10:32 [info] 
            ALTER TABLE wp_t_scores
                ADD INDEX fk_score_answer (answer_id)
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_t_scores
            SELECT * FROM wp_t_scores_backup;
            DROP TABLE wp_t_scores_backup;
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20141126191658')
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` ADD `ip` varchar(45)
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` ADD `device_uuid` char(36)
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150117155757')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_result_page_show_scales', '1'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_result_page_show_test_description', '1'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150120194216')
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` ADD `user_agent` text
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150131233053')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_test_page_submit_button_caption', ''
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_test_page_reset_answers_on_back', '0'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150201011503')
May 20 06:10:32 [info] ALTER TABLE `wp_t_answers` ADD `answer_sort` int(11) DEFAULT 100
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150215143537')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_result_page_sort_scales_by_score', '0'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150215150706')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_test_page_show_progress_meter', '0'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150216181127')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_result_page_show_scales_diagram', '0'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150221150014')
May 20 06:10:32 [info] 
            INSERT INTO wp_postmeta(post_id, meta_key, meta_value)
            SELECT ID, 'wpt_test_page_multiple_answers', '0'
            FROM wp_posts WHERE post_type = 'wpt_test'
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150228141341')
May 20 06:10:32 [info] 
            UPDATE wp_posts AS p, wp_postmeta AS m
            SET m.meta_value = '0'
            WHERE TRUE
            AND m.meta_key   = 'wpt_result_page_show_test_description'
            AND p.post_type  = 'wpt_test'
            AND p.post_title = 'Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)'
            AND m.post_id    = p.ID
        ;
May 20 06:10:32 [info] 
            UPDATE wp_posts AS p, wp_postmeta AS m
            SET m.meta_value = '1'
            WHERE TRUE
            AND m.meta_key   = 'wpt_test_page_show_progress_meter'
            AND p.post_type  = 'wpt_test'
            AND p.post_title = 'Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)'
            AND m.post_id    = p.ID
        ;
May 20 06:10:32 [info] 
            UPDATE wp_posts AS p, wp_postmeta AS m
            SET m.meta_value = '0'
            WHERE TRUE
            AND m.meta_key   = 'wpt_result_page_show_scales_diagram'
            AND p.post_type  = 'wpt_test'
            AND p.post_title = 'Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)'
            AND m.post_id    = p.ID
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150308201857')
May 20 06:10:32 [info] 
            DELETE FROM wp_t_schema_migrations
            WHERE version IN (
                20140831002425,
                20140831142817,
                20140831155940,
                20140913080127
            )
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150320053524')
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_sections`
May 20 06:10:32 [info] CREATE TABLE `wp_t_sections` (
`section_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`question_id` bigint UNSIGNED NOT NULL,
`section_title` text NOT NULL,
 PRIMARY KEY (`section_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_sections 
            ADD CONSTRAINT wp_t_fk_section_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_section_test(test_id)
        ,

            ADD CONSTRAINT wp_t_fk_section_question
            FOREIGN KEY (question_id)
            REFERENCES wp_t_questions(question_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_section_question(question_id)
        ,

            ADD UNIQUE INDEX uq_section_test_question(test_id, question_id)
        
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150324041508')
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_fields`
May 20 06:10:32 [info] CREATE TABLE `wp_t_fields` (
`field_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`field_title` text NOT NULL,
`field_type` varchar(255) NOT NULL,
`field_is_required` tinyint(1) DEFAULT 1 NOT NULL,
`field_sort` int(11) DEFAULT 100 NOT NULL,
`field_clarification` text,
`field_list_values` text,
`field_default_value` text,
 PRIMARY KEY (`field_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_fields 
            ADD CONSTRAINT wp_t_fk_field_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_field_test(test_id)
        
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_field_values`
May 20 06:10:32 [info] CREATE TABLE `wp_t_field_values` (
`field_value_id` bigint UNSIGNED auto_increment NOT NULL,
`field_id` bigint UNSIGNED NOT NULL,
`passing_id` bigint UNSIGNED NOT NULL,
`field_value` text,
 PRIMARY KEY (`field_value_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_field_values 
            ADD CONSTRAINT wp_t_fk_field_value_field
            FOREIGN KEY (field_id)
            REFERENCES wp_t_fields(field_id)
            ON DELETE RESTRICT
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_field_value_field(field_id)
        ,

            ADD CONSTRAINT wp_t_fk_field_value_passing
            FOREIGN KEY (passing_id)
            REFERENCES wp_t_passings(passing_id)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_field_value_passing(passing_id)
        
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150426194928')
May 20 06:10:32 [info] 
            UPDATE wp_posts
            SET post_content = CONCAT(post_content, '\n\n<p style="color: gray; font-size: 70%; text-align: right;">This test is a demonstration of <a href="http://apsiholog.ru/psychological-tests/">psychological tests</a> plugin.</p>')
            WHERE post_type = 'wpt_test'
            AND post_title = 'Eysenck’s Personality Inventory (EPI) (Extroversion/Introversion)'
            AND post_content NOT LIKE '%apsiholog%' LIMIT 1
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150510175539')
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_passings` LIKE 'created'
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` CHANGE `created` `passing_created` datetime NOT NULL COMMENT '' 
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_passings` LIKE 'modified'
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` CHANGE `modified` `passing_modified` datetime NOT NULL COMMENT '' 
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_passings` LIKE 'ip'
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` CHANGE `ip` `passing_ip` varchar(45) COMMENT '' 
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_passings` LIKE 'device_uuid'
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` CHANGE `device_uuid` `passing_device_uuid` char(36) COMMENT '' 
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_passings` LIKE 'user_agent'
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` CHANGE `user_agent` `passing_user_agent` text COMMENT '' 
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150530145555')
May 20 06:10:32 [info] ALTER TABLE `wp_t_passings` ADD `passing_status` enum('publish','trash') DEFAULT 'publish' NOT NULL AFTER `respondent_id`
May 20 06:10:32 [info] CREATE INDEX `i_passing_status_created_id` ON `wp_t_passings`(`passing_status`, `passing_created`, `passing_id`)
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150530160000')
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_sections` LIKE 'question_id'
May 20 06:10:32 [info] ALTER TABLE `wp_t_sections` CHANGE `question_id` `question_id` bigint UNSIGNED
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150614145310')
May 20 06:10:32 [info] DROP INDEX `uq_section_test_question` ON `wp_t_sections`
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150804182815')
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_sections` LIKE 'section_title'
May 20 06:10:32 [info] ALTER TABLE `wp_t_sections` CHANGE `section_title` `section_title` text
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150806190742')
May 20 06:10:32 [info] ALTER TABLE `wp_t_sections` ADD `section_description` mediumtext
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150807044411')
May 20 06:10:32 [info] SHOW FULL COLUMNS FROM `wp_t_scores` LIKE 'score_value'
May 20 06:10:32 [info] ALTER TABLE `wp_t_scores` CHANGE `score_value` `score_value` decimal(6, 3) DEFAULT 0 NOT NULL
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20150808133733')
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20151129164228')
May 20 06:10:32 [info] SHOW TABLE STATUS
May 20 06:10:32 [info] DROP TABLE IF EXISTS `wp_t_computed_variables`
May 20 06:10:32 [info] CREATE TABLE `wp_t_computed_variables` (
`computed_variable_id` bigint UNSIGNED auto_increment NOT NULL,
`test_id` bigint UNSIGNED NOT NULL,
`computed_variable_name` varchar(190) NOT NULL,
`computed_variable_source` text NOT NULL,
`computed_variable_sort` int(11) DEFAULT 100 NOT NULL,
 PRIMARY KEY (`computed_variable_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
May 20 06:10:32 [info] ALTER TABLE wp_t_computed_variables 
            ADD CONSTRAINT wp_t_fk_computed_variable_test
            FOREIGN KEY (test_id)
            REFERENCES wp_posts(ID)
            ON DELETE CASCADE
            ON UPDATE CASCADE
        ,

            ADD  INDEX fk_computed_variable_test(test_id)
        ,

            ADD UNIQUE INDEX uq_computed_variable_name_test(test_id, computed_variable_name)
        
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20170420170659')
May 20 06:10:32 [info] SELECT ID FROM wp_posts WHERE post_type = 'wpt_test' AND post_name = 'eysencks-personality-inventory-epi-extroversionintroversion' ORDER BY ID LIMIT 1
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'otherpeople', 'other people')
                WHERE test_id = 1467 AND question_title LIKE '%otherpeople%'
            ;
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'feelingyou', 'feeling you')
                WHERE test_id = 1467 AND question_title LIKE '%feelingyou%'
            ;
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'upin', 'up in')
                WHERE test_id = 1467 AND question_title LIKE '%upin%'
            ;
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'knew you', 'knew you')
                WHERE test_id = 1467 AND question_title LIKE '%knew you%'
            ;
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'toa', 'to a')
                WHERE test_id = 1467 AND question_title LIKE '%toa%'
            ;
May 20 06:10:32 [info] 
                UPDATE wp_t_questions SET question_title = REPLACE(question_title, 'hear?', 'heart?')
                WHERE test_id = 1467 AND question_title LIKE '%hear?%'
            ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20170518191821')
May 20 06:10:32 [info] SELECT ID FROM wp_posts WHERE post_type = 'wpt_test' AND post_name = 'eysencks-personality-inventory-epi-extroversionintroversion' ORDER BY ID LIMIT 1
May 20 06:10:32 [info] 
            UPDATE wp_t_answers
            SET answer_title = NULL
            WHERE answer_title = '' AND question_id IN (
                SELECT question_id FROM wp_t_questions WHERE test_id = 1467
            )
        ;
May 20 06:10:32 [info] INSERT INTO wp_t_schema_migrations (version) VALUES ('20170724182147')