INSERT INTO ROLES (ID,NAME) 
VALUES (1,'ADMIN_USER');
INSERT INTO ROLES (ID,NAME) 
VALUES (2,'END_USER');

INSERT INTO POLLS(ID, NAME)
VALUES(1, 'Anket-1');
INSERT INTO POLLS(ID, NAME)
VALUES(2, 'Anket-2');

INSERT INTO USERS (ID, USER_NAME, PASSWORD, ROLE_ID) 
VALUES (1, 'mumi', <PASSWORD>', 2); -- password=<PASSWORD>
INSERT INTO USERS (ID, USER_NAME, PASSWORD, ROLE_ID) 
VALUES (2, 'ozcan', <PASSWORD>', 2); -- password=<PASSWORD>
INSERT INTO USERS (ID, USER_NAME, PASSWORD, ROLE_ID) 
VALUES (3, 'admin', <PASSWORD>G', 1); -- password=admin

INSERT INTO QUESTIONS (ID, TEXT, STATUS, POLL_ID) VALUES (1,'XY ürününü ne hangi siklikla kullaniyorsunuz?', 1, 1);
INSERT INTO QUESTIONS (ID, TEXT, STATUS, POLL_ID) VALUES (2,'XY ürünü için ne kadar ödersiniz?', 1, 1);
INSERT INTO QUESTIONS (ID, TEXT, STATUS, POLL_ID) VALUES (3,'Cep Telefonu markaniz nedir?', 1, 2);
INSERT INTO QUESTIONS (ID, TEXT, STATUS, POLL_ID) VALUES (4,'XYZ ürünü için ne kadar ödersiniz?', 0, 1);
INSERT INTO QUESTIONS (ID, TEXT, STATUS, POLL_ID) VALUES (5,'Bilgisayar markaniz nedir?', 0, 2);

INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (1,1, 'Günlük');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (2,1, 'Haftalik');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (3,1, 'Aylik');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (4,1, 'Yillik');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (5,2, '50 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (6,2, '100 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (7,2, '200 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (8,2, '500 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (9,2, '1000 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (10,3, 'Iphone');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (11,3, 'Samsung');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (12,3, 'Ericsson');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (13,4, '1 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (14,4, '5 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (15,4, '10 TL');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (16,5, 'Asus');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (17,5, 'Samsung');
INSERT INTO OPTIONS (ID, QUESTION_ID, OPTION_TEXT) VALUES (18,5, 'Dell');



INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (1,1, 1,1);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (2,2, 1,1);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (3,1, 2,5);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (4,1, 3,12);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (5,2, 2,6);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (6,2, 3,12);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (7,3, 1,4);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (8,3, 2,5);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (9,3, 3,12);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (10,1, 4,15);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (11,2, 4,13);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (12,3, 4,13);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (13,1, 5,16);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (14,2, 5,18);
INSERT INTO ANSWERS (ID, USER_ID, QUESTION_ID, OPTION_ID) VALUES (15,3, 5,18);



