GitList
Repositories
Help
Report an Issue
vroom360
Code
Commits
Branches
Tags
Search
Tree:
e36c40f
Branches
Tags
master
vroom360
db
devghai.com_99_insert_all.sql
initial commit
Dev Ghai
commited
e36c40f
at 2013-09-26 06:24:15
devghai.com_99_insert_all.sql
Blame
History
Raw
INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (10, 15); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (16, 20); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (21, 25); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (26, 30); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (31, 35); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (36, 40); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (41, 45); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (46, 50); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (51, 55); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (56, 60); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (61, 65); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (66, 70); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (71, 75); INSERT INTO `ages`(`ages_from`,`ages_to`) VALUES (76, 80); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (51, 60); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (61, 70); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (71, 80); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (81, 90); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (91, 100); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (101, 110); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (111, 120); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (121, 130); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (131, 140); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (141, 150); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (151, 160); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (161, 170); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (171, 180); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (181, 190); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (191, 200); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (201, 210); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (211, 220); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (221, 230); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (231, 240); INSERT INTO `weights`(`weights_from`,`weights_to`) VALUES (241, 250); --- -- password = loginId INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('andy','*F96F1632B76CC8C3AE6A600874573B1077718130',7,'Female',144,8,10,15219,'L','pingliandy@gmail.com',0,90); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('anmol','*87863E3501735644D77670A7D729A26C657661EB',2,'Male',148,13,10,15219,'L','anmoln7@gmail.com',0,0); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('demo','*6949B1E7D9C44BAA168886E033AE9F551C8814D3',1,'Female',23,1,1,15219,'L','anmoln7@gmail.com',NULL,NULL); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('dev','*2785BFFB673C3DAB53F814D0812920DE22C6510F',7,'Female',147,12.5,3,15219,'L','devghai@gmail.com',11,12); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('eve','*1A6EFD23741853F1DD5DF9B944BE40169F3931F1',4,'Female',23,1,12,15219,'L','eve@gmail.com',NULL,NULL); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('henry','*D16D342FF41C2C8ACDBCB10489FE202964BEF327',3,'Male',69,10,7,15219,'SM','hbraun87@gmail.com',90,45); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('Stacey Gu','*4666BD964DDABA4BD0E30927671FFEB5F76E28F9',7,'Female',62,0,1,0,'None','Stacey.gu@gm.com',1,3); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('sam','*B5007B8831AA7CC0E2C2F5EA35A97C126011E8B9',3,'Female',63,7,10,15219,'L','samjcollier@gmail.com',0,0); INSERT INTO `users` (`users_loginId`,`users_password`,`users_ageid`,`users_gender`,`users_height`,`users_shoesize`,`users_weightid`,`users_zip`,`users_shirtsize`,`users_email`,`user_sittingheight`,`user_upperleglength`) VALUES ('tim','*E8CB293030DF5929BF3D3F0D285E235E46ABE9B1',4,'Male',69,11,13,15219,'L','forsythet@gmail.com',0,0); -- ------------------ INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (1,'... your ability to see out in this area to your left?','Integer','HigherIsBetter',-0.978,-0.025,-0.563,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (2,'...getting out of this vehicle?','Integer','HigherIsBetter',-3.624,0.911,-0.89,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (3,'... your ability to see the front end of this vehicle?','Integer','HigherIsBetter',0.873,0.157,-0.658,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (4,'... your headroom?','Integer','HigherIsBetter',0.128,-0.514,-0.355,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (5,'... your ability to see the dashboard gauges?','Integer','HigherIsBetter',0.257,0.334,-0.563,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (6,'... your ability to see out in this area to your right?','Integer','HigherIsBetter',3.93,0,-0.57,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (7,'... your ability to see out front?','Integer','HigherIsBetter',0.514,-0.334,-0.658,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (8,'... the center console?','Integer','HigherIsBetter',1.414,0.746,-0.658,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (9,'...your ability to see out left?','Integer','HigherIsBetter',-3.624,0,-0.89,1); INSERT INTO `questions` (`questions_id`,`questions_text`,`questions_ans_value_type`,`questions_ans_direction`,`questions_location_x`,`questions_location_y`,`questions_location_z`,`questions_active`) VALUES (10,'... your ability to see out right?','Integer','HigherIsBetter',4.419,0.18,-0.694,1); -- ----------------------------------- -- admins -- ----------------------------------- INSERT INTO `admins` (`admins_id`,`admins_password`,`admins_email`,`admins_active`,`admins_modified_by`,`admins_modification_date`) VALUES ('admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441','devghai@yahoo.com',1,'dev','1969-12-31 19:00:00'); INSERT INTO `admins` (`admins_id`,`admins_password`,`admins_email`,`admins_active`,`admins_modified_by`,`admins_modification_date`) VALUES ('dev','*27AEDA0D3A56422C3F1D20DAFF0C8109058134F3','devghai@yahoo.com',0,'dev','1969-12-31 19:00:00'); INSERT INTO `admins` (`admins_id`,`admins_password`,`admins_email`,`admins_active`,`admins_modified_by`,`admins_modification_date`) VALUES ('foo','*E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB','vroom360@devghai.com',1,'admin','2011-11-27 05:09:48'); INSERT INTO `admins` (`admins_id`,`admins_password`,`admins_email`,`admins_active`,`admins_modified_by`,`admins_modification_date`) VALUES ('john','*DACDE7F5744D3CB439B40D938673B8240B824853','john@doe.com',1,'dev','1969-12-31 19:00:00'); -- ----------------------------------- INSERT INTO `question_set` (`questionset_id`,`questionset_setname`,`questionset_active`,`questionset_modified_by`,`questionset_modification_date`) VALUES (1,'Visibility',1,'admin','2011-11-27 06:49:14'); INSERT INTO `question_set` (`questionset_id`,`questionset_setname`,`questionset_active`,`questionset_modified_by`,`questionset_modification_date`) VALUES (2,'Roominess',1,'admin','2011-11-27 06:49:14'); -- ----------------------------------- -- ---------- -- Visibility = 1 -- ---------- -- 1, 3, 5, 6, 7, 9, 10 INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 1); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 3); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 5); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 6); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 7); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 9); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (1, 10); -- ---------- -- Roominess = 2 -- ---------- -- 2, 4, 8 INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (2, 2); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (2, 4); INSERT INTO `questions_in_set`(`questionsinset_set_id`, `questionsinset_question_id`) VALUES (2, 8); -- ------------------------------------ -- ------------------------------------ INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (1, 'Second Survey', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (2, 'Third Survey', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (3, 'First Comment', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (4, 'Five Comments', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (5, 'Completed a Survey With Comments For All Questions', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (6, 'Completed 1 Survey', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (7, 'Completed 2 Surveys', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (8, 'Completed 3 Surveys', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (9, 'First User of the System', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (10, 'Second User of the System', 1); INSERT INTO `badges` (`badges_id`, `badges_description`, `badges_weight`) VALUES (11, 'Third User of the System', 1); -- ------------------------------------ INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'dev'); INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'henry'); INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'anmol'); INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'andy'); INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'sam'); INSERT INTO `user_badges` (`userbadges_badgeid`, `userbadges_userid`) VALUES (1, 'eve');
