install.sql

太烦了

CREATE TABLE `__DB_PREFIX__compQuest_answer` (
  `aid` int(11) NOT NULL auto_increment,
  `qid` int(11) NOT NULL default '0',
  `qcid` int(11) NOT NULL default '0',
  `answer` int(11) NOT NULL default '0',
  `uid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`aid`)
) AUTO_INCREMENT=1 ;

CREATE TABLE `__DB_PREFIX__compQuest_content` (
  `qcid` int(11) NOT NULL auto_increment,
  `answer` text NOT NULL,
  `qid` int(11) NOT NULL default '0',
  `ord` int(11) NOT NULL default '0',
  PRIMARY KEY  (`qcid`)
) AUTO_INCREMENT=582 ;

INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (57, 'Warm', 1, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (58, 'Clever', 1, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (59, 'Dominant', 1, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (60, 'Ambitious', 1, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (61, 'Outgoing', 1, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (62, 'Agreeable', 1, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (63, 'Submissive', 1, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (64, 'Introverted', 1, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (65, 'Aloof', 1, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (66, 'Quarrelsome', 1, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (67, 'Cold', 1, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (68, 'Arrogant', 1, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (69, 'Stable', 9, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (70, 'Energetic', 9, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (71, 'Spiritual', 9, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (72, 'Adventuresome', 9, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (73, 'Frugal', 9, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (74, 'Predictable', 9, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (75, 'Affectionate', 9, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (76, 'Organized', 9, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (77, 'Intelligent', 9, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (78, 'Compassionate', 9, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (79, 'Attractive', 9, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (80, 'Loyal', 9, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (81, 'Witty', 9, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (82, 'Neat', 9, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (83, 'Good Listener', 10, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (84, 'Caring', 10, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (85, 'Outgoing', 10, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (86, 'Creative', 10, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (87, 'Ambitious', 10, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (88, 'Intelligent', 10, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (89, 'Passionate', 10, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (90, 'Modest', 10, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (91, 'Spontaneous', 10, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (92, 'Optimistic', 10, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (93, 'Loyal', 10, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (94, 'Articulate', 10, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (95, 'Happy', 10, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (96, 'Hard Working', 10, 15);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (97, 'Energetic', 10, 16);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (98, 'Respectful', 10, 17);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (99, 'Physically Fit', 10, 18);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (100, 'Dependable', 10, 19);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (101, 'Spiritual', 10, 20);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (102, 'Rational', 10, 21);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (103, 'Quiet', 10, 22);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (104, 'Thoughtful', 10, 23);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (105, 'Funny', 10, 24);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (106, 'Affectionate', 10, 25);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (107, 'Warm', 10, 26);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (108, 'Romantic', 10, 27);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (109, 'Kind', 10, 28);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (110, 'Easy-Going', 10, 29);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (111, 'Genuine', 10, 30);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (112, 'Sweet', 10, 31);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (113, 'Perceptive', 10, 32);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (114, 'Generous', 10, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (115, 'Content', 11, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (116, 'Humorous', 11, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (117, 'Efficient', 11, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (118, 'Artistic', 11, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (119, 'Perfectionist', 11, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (120, 'Creative', 11, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (121, 'Spontaneous', 11, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (122, 'Sensitive', 11, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (123, 'Under-Achiever', 11, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (124, 'Generous', 11, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (125, 'Intellectual', 11, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (126, 'Moral', 11, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (127, 'Disciplined', 11, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (128, 'Adaptable', 11, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (129, 'Communicative', 12, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (130, 'Honest', 12, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (131, 'Sensual', 12, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (132, 'Liberal', 12, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (133, 'Charming', 12, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (134, 'Patient', 12, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (135, 'Reliable', 12, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (136, 'Resilient', 12, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (137, 'Optimistic', 12, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (138, 'Conservative', 12, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (139, 'Passionate', 12, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (140, 'Reflective', 12, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (141, 'Caring', 12, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (142, 'Genuine', 12, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (143, 'Open', 12, 15);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (144, 'Self-aware', 13, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (145, 'Competitive', 13, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (146, 'Over-Achiever', 13, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (147, 'Vivacious', 13, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (148, 'Wise', 13, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (149, 'Bossy', 13, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (150, 'Leader', 13, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (151, 'Irritable', 13, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (152, 'Show-off', 13, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (153, 'Kind', 13, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (154, 'Calm', 13, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (155, 'Aggresive', 13, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (156, 'Persistent', 13, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (157, 'Outspoken', 14, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (158, 'Follower', 14, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (159, 'Rational', 14, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (160, 'Opinionated', 14, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (161, 'Restless', 14, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (162, 'Romantic', 14, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (163, 'Selfish', 14, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (164, 'Shy', 14, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (165, 'Stubborn', 14, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (166, 'Trusting', 14, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (167, 'Jealous', 14, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (168, 'I enjoy a good joke', 15, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (169, 'I enjoy work for work''s sake', 15, 2);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (170, 'I enjoy mingling with people on social occasions', 15, 3);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (171, 'I like reading everything I can about a subject', 15, 4);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (172, 'I am satisfied with my level of emotional development', 15, 5);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (173, 'I like to spend my spare time being physically active', 15, 6);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (174, 'I am able to express myself in unique ways (e.g., words, music, art)', 15, 7);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (175, 'My personal religious beliefs are important to me', 15, 8);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (176, 'I have a high desire for sexual activity', 15, 9);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (177, 'I strive to advance in my career', 15, 10);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (178, 'I take great pleasure in knowing I have done a good job, whether or not others recognize it', 15, 11);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (179, 'It is easy for me to engage in conversations with people I have just met', 15, 12);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (180, 'I tend to think "outside the box"', 15, 13);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (181, 'I view myself as well adjusted', 15, 14);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (182, 'I an a good artist', 15, 15);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (183, 'My faith affects my life', 15, 16);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (184, 'I greatly appreciate the physical beauty of the opposite sex', 15, 17);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (185, 'I often see humor in everyday life', 15, 18);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (186, 'It is important for me to be viewed by others as a succesfull person', 15, 19);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (187, 'I feel a bit guilty if I am not being productive', 15, 20);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (188, 'Being in settings where I will meet new people is an important part of my life', 15, 21);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (189, 'I ask questions in search of information', 15, 22);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (190, 'I think it is important to continually try to improve myself', 15, 23);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (191, 'I care a lot about the physical shape I am in', 15, 24);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (192, 'I find that going to church is a good way to meet people who benefit my social and/or professional life', 16, 1);
INSERT INTO `__DB_PREFIX__compQuest_content` VALUES (193, 'I like to look at people of the opposite sex', 16, 2);