CREATE TABLE `users_signup` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_id` VARCHAR(100) NOT NULL,
    `first_name` VARCHAR(100) NOT NULL,
    `last_name` VARCHAR(100) NOT NULL,
    `email` VARCHAR(150) NOT NULL,
    `password` VARCHAR(255) NOT NULL,
    `dial_code` VARCHAR(10) DEFAULT NULL,
    `phone_number` VARCHAR(20) DEFAULT NULL,
    `organization` VARCHAR(255) DEFAULT NULL,
    `category` VARCHAR(100) DEFAULT NULL,
    `created_at` TIMESTAMP NULL DEFAULT NULL,
    `updated_at` TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
);


CREATE TABLE `organization_dtl` (
    `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_id` VARCHAR(100) NOT NULL,
    `first_name` VARCHAR(100) NOT NULL,
    `last_name` VARCHAR(100) NOT NULL,
    `email` VARCHAR(150) NOT NULL,
    `password` VARCHAR(255) NOT NULL,
    `dial_code` VARCHAR(10) DEFAULT NULL,
    `phone` VARCHAR(20) DEFAULT NULL,
    `organization_name` VARCHAR(255) DEFAULT NULL,
    `organization_email` VARCHAR(150) DEFAULT NULL,
    `organization_website` VARCHAR(255) DEFAULT NULL,
    `cpa_number` VARCHAR(100) DEFAULT NULL,
    `org_dial_code` VARCHAR(10) DEFAULT NULL,
    `org_phone` VARCHAR(20) DEFAULT NULL,
    `created_at` TIMESTAMP NULL DEFAULT NULL,
    `updated_at` TIMESTAMP NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
);




CREATE TABLE questions (
    sr_no INT AUTO_INCREMENT PRIMARY KEY,
    question_id VARCHAR(20),
    question_text TEXT,
    flag TINYINT(1) DEFAULT 1
);


CREATE TABLE questions (
    sr_no INT AUTO_INCREMENT PRIMARY KEY,
    question_id VARCHAR(20),
    question_text TEXT,
    flag TINYINT(1) DEFAULT 1
);

INSERT INTO questions (question_id, p_code,question_text, flag) VALUES

-- 1
('1', 1, 'I am aware that there are differences and similarities among cultures in terms of their',1),
('1.1', '1', 'language',1),
('1.2', '1', 'clothing',1),
('1.3', '1', 'food or dietary preference',1),
('1.4', '1', 'celebrations',1),
('1.5', '1', 'artistic expression',1),
('1.6', '1', 'behavioural rules regarding taboos (undesirable behaviours)',1),
('1.7', '1', 'rules for expressing non verbal behaviours',1),
('1.8', '1', 'sense of humour',1),
('1.9', '1', 'religious beliefs',1),
('1.10', '1', 'social norms',1),
('1.11', '1', 'cultural values',1),

-- 2
('2', 2, 'I am aware of cultural diversity in Australia in terms of',1),
('2.1', '2', 'The history of cultural diversity in Australia',1),
('2.2', '2', 'The extent of cultural diversity in Australia',1),
('2.3', '2', 'The cultural diversity of people living in Australia',1),
('2.4', '2', 'The trend of immigration to Australia',1),
('2.5', '2', 'The experience of people in intercultural interactions in Australia',1),
('2.6', '2', 'The challenges faced by people in intercultural interactions in Australia',1),

-- 3
('3', 3, 'I am willing to continuously learn about diverse culture through my approach to',1),
('3.1', '3', 'Read cultural material from different sources',1),
('3.2', '3', 'attend cultural competency training programs',1),
('3.3', '3', 'watch movies from other cultures',1),
('3.4', '3', 'observe people from diverse cultural backgrounds on social media',1),
('3.5', '3', 'interact with people from diverse cultural backgrounds',1),
('3.6', '3', 'Get involved in activities with people from diverse cultural backgrounds',1),
('3.7', '3', 'work in a multicultural workspace',1),
('3.8', '3', 'ask people about their cultures',1),
('3.9', '3', 'Listen to music from other cultures',1),
('3.10', '3', 'Attend multicultural events (e.g. festivals)',1),

-- 4
('4', 4, 'I am interested in cultural diversity because it allows me to',1),
('4.1', '4', 'Meet people from diverse cultural backgrounds',1),
('4.2', '4', 'learn different ways of looking at things',1),
('4.3', '4', 'acquire new experiences',1),
('4.4', '4', 'try a wider variety of ethnic foods',1),
('4.5', '4', 'enjoy a wider variety of music',1),
('4.6', '4', 'acquire a broader range of skills',1),
('4.7', '4', 'make my personal network culturally more diverse',1),
('4.8', '4', 'make my professional network culturally more diverse',1),
('4.9', '4', 'enrich my own culture with new experiences',1),
('4.10', '4', 'build a positive attitude towards people from diverse cultural backgrounds',1),
('4.11', '4', 'grow as a person',1),

-- 5
('5', 5, 'I am able to process my knowledge about diverse cultures through my approach to',1),
('5.1', '5', 'see things from their point of view',1),
('5.2', '5', 'see the world from their eyes',1),
('5.3', '5', 'employ different cultural frames of reference',1),
('5.4', '5', 'see various sides of multicultural issue by an unbiased mindset',1),
('5.5', '5', 'assess the cultural knowledge I acquire from different sources in an unbiased manner',1),
('5.6', '5', 'apply my cultural knowledge into the way I think',1),
('5.7', '5', 'apply my cultural knowledge into the way I behave',1),
('5.8', '5', 'continuously monitor my thinking based on my cultural knowledge',1),
('5.9', '5', 'continuously monitor my behaviour based on my cultural knowledge',1),

-- 6
('6', 6, 'I am willing to accept cultural diversity in terms of how people in other cultures',1),
('6.1', '6', 'are different from me',1),
('6.2', '6', 'do not physically look like me',1),
('6.3', '6', 'speak with an accent different from me',1),
('6.4', '6', 'do not dress like me',1),
('6.5', '6', 'have food habits different from me',1),
('6.6', '6', 'have hobbies different from me',1),
('6.7', '6', 'do not behave like me',1),
('6.8', '6', 'have different cultural perspectives than my own',1),
('6.9', '6', 'have underlying social norms different from me',1),
('6.10', '6', 'have underlying cultural values different from me',1),
('6.11', '6', 'have beliefs different from me',1),
('6.12', '6', 'work differently compared to me',1),

-- 7
('7', 7, 'I am able to adjust my behaviour when interacting with people from diverse cultural backgrounds, such as',1),
('7.1', '7', 'shift my behaviours in a manner which is appropriate in a multicultural context',1),
('7.2', '7', 'alter my behavioural habits that may offend them',1),
('7.3', '7', 'respect diverse cultural practices',1),
('7.4', '7', 'respect diverse cultural norms',1),
('7.5', '7', 'not acting rude in situations when I do not understand the other person',1),
('7.6', '7', 'not acting rude if the other person does not understand me',1),
('7.7', '7', 'seek help from a person who is aware of the other culture if there is a miscommunication',1),
('7.8', '7', 'deal effectively with cultural misunderstandings',1),

-- 8
('8', 8, 'I am willing to put extra effort to adjust my behaviour when interacting with people from diverse cultural backgrounds, such as',1),
('8.1', '8', 'alter certain aspects of doing things as per my culture',1),
('8.2', '8', 'include certain interesting elements from other cultures into my behaviour',1),
('8.3', '8', 'ask for feedback from others on how I can be corrected if I am wrong',1),
('8.4', '8', 'make everyone, regardless of their culture, feels included',1),
('8.5', '8', 'demonstrate my objection to cultural discrimination',1),

-- 9
('9', 9, 'I am able to communicate effectively when interacting with people from diverse cultural backgrounds, such as',1),
('9.1', '9', 'speak very clearly',1),
('9.2', '9', 'avoid unnecessary words',1),
('9.3', '9', 'use a clear accent',1),
('9.4', '9', 'change my speaking speed in order to be understood',1),
('9.5', '9', 'choose my words carefully as not to hurt others',1),
('9.6', '9', 'change my language that may be considered offensive',1),
('9.7', '9', 'adjust my body language',1),
('9.8', '9', 'make the effort to listen carefully',1),
('9.9', '9', 'repeat sentences again if the other person does not understand me',1),

-- 10
('10', 10, 'When it comes to communication with people from diverse cultural backgrounds, I am confident enough to',1),
('10.1', '10', 'approach them in a friendly manner',1),
('10.2', '10', 'initiate conversations with them',1),
('10.3', '10', 'develop in-depth communications',1),
('10.4', '10', 'maintain a satisfying level of communication',1),
('10.5', '10', 'find mutual interest between myself and them',1),
('10.6', '10', 'work successfully with them',1),
('10.7', '10', 'easily communicate with them in english',1),

-- 11
('11', 11, 'When it comes to communication with people from diverse cultural backgrounds',1),
('11.1', '11', 'I am comfortable to have close face-to-face communication with them',1),
('11.2', '11', 'I am comfortable to have close online communication with them',1),
('11.3', '11', 'I am comfortable to be friend with them',1),
('11.4', '11', 'I am comfortable to keep them in my network',1),
('11.5', '11', 'I am comfortable to work in a multicultural organisation',1),
('11.6', '11', 'I am comfortable to work in multicultural teams',1),
('11.7', '11', 'I think I am starting from the scratch',1),
('11.8', '11', 'having less familiar things to refer to makes it uncomfortable to communicate with them',1),
('11.9', '11', 'having less similar experiences makes it uncomfortable to communicate with them',1),
('11.10', '11', 'misunderstandings make it uncomfortable to communicate with them',1),

-- 12
('12', 12, 'To what extent do you interact with the following people whose cultural background is different from your own?',1),
('12.1', '12', 'Work colleagues in your organisation',1),
('12.2', '12', 'Work colleagues in other organisation',1),
('12.3', '12', 'Customers/Clients',1),
('12.4', '12', 'Others outside the workplace',1),

-- 13



('13', 13, 'The members of the organisation I am working for are very different from each other in terms of',1),
('13.1', '13', 'Race or ethnicity',1),
('13.2', '13', 'Nationality',1),
('13.3', '13', 'Customs or culture',1),
('13.4', '13', 'language',1),
('13.5', '13', 'religious beliefs',1),

-- 14
('14', 14, 'The members of the work unit I am working in are very different from each other in terms of',1),
('14.1', '14', 'Race or ethnicity',1),
('14.2', '14', 'Nationality',1),
('14.3', '14', 'Customs or culture',1),
('14.4', '14', 'language',1),
('14.5', '14', 'religious beliefs',1),

-- 15
('15', 15, 'The organisation I am working for serves customers or clients who are very different from each other in terms of',1),
('15.1', '15', 'Race or ethnicity',1),
('15.2', '15', 'Nationality',1),
('15.3', '15', 'Customs or culture',1),
('15.4', '15', 'language',1),
('15.5', '15', 'religious beliefs',1),

-- SINGLE QUESTIONS
('16', 16, 'Which of the following sectors do you currently work in?',1),
('17', 17, 'Which industry division best describes where you are employed?',1),
('18', 18, 'Which industry sub division best describes where you are employed?',1),
('19', 19, 'Which major group best describes your occupation?',1),
('20', 20, 'Which group best describes your occupation?',1),
('21', 21, 'How long you have been in the workforce?',1),
('22', 22, 'How long you have been working in your current organisation?',1),
('23', 23, 'What is the highest qualification level you have completed?',1),
('24', 24, 'Please select your gender',1),
('25', 25, 'Please select your age range',1),
('26', 26, 'Please select your country of birth',1),
('27', 27, 'Please select your ancestry',1),
('28', 28, 'Which state or territory do you live in Australia?',1),
('39', 39, 'How long have you lived in Australia?',1),
('30', 30, 'How long have you lived outside your country of birth?',1);




CREATE TABLE user_answers (

    id INT AUTO_INCREMENT PRIMARY KEY,

    user_id INT NULL,

    StartDate DATETIME NULL,
    EndDate DATETIME NULL,
    Status VARCHAR(50) NULL,
    IPAddress VARCHAR(100) NULL,
    Progress INT NULL,
    Duration_in_seconds INT NULL,
    Finished VARCHAR(10) NULL,
    RecordedDate DATETIME NULL,
    ResponseId VARCHAR(255) NULL,
    RecipientLastName VARCHAR(255) NULL,
    RecipientFirstName VARCHAR(255) NULL,
    RecipientEmail VARCHAR(255) NULL,
    ExternalReference VARCHAR(255) NULL,
    LocationLatitude VARCHAR(100) NULL,
    LocationLongitude VARCHAR(100) NULL,
    DistributionChannel VARCHAR(100) NULL,
    UserLanguage VARCHAR(50) NULL,

    `1_1`  TINYINT NULL,
    `1_2`  TINYINT NULL,
    `1_3`  TINYINT NULL,
    `1_4`  TINYINT NULL,
    `1_5`  TINYINT NULL,
    `1_6`  TINYINT NULL,
    `1_7`  TINYINT NULL,
    `1_8`  TINYINT NULL,
    `1_9`  TINYINT NULL,
    `1_10`  TINYINT NULL,
    `1_11`  TINYINT NULL,

    `2_1`  TINYINT NULL,
    `2_2`  TINYINT NULL,
    `2_3`  TINYINT NULL,
    `2_4`  TINYINT NULL,
    `2_5`  TINYINT NULL,
    `2_6`  TINYINT NULL,

    `3_1`  TINYINT NULL,
    `3_2`  TINYINT NULL,
    `3_3`  TINYINT NULL,
    `3_4`  TINYINT NULL,
    `3_5`  TINYINT NULL,
    `3_6`  TINYINT NULL,
    `3_7`  TINYINT NULL,
    `3_8`  TINYINT NULL,
    `3_9`  TINYINT NULL,
    `3_10`  TINYINT NULL,

    `4_1`  TINYINT NULL,
    `4_2`  TINYINT NULL,
    `4_3`  TINYINT NULL,
    `4_4`  TINYINT NULL,
    `4_5`  TINYINT NULL,
    `4_6`  TINYINT NULL,
    `4_7`  TINYINT NULL,
    `4_8`  TINYINT NULL,
    `4_9`  TINYINT NULL,
    `4_10`  TINYINT NULL,
    `4_11`  TINYINT NULL,

    `5_1`  TINYINT NULL,
    `5_2`  TINYINT NULL,
    `5_3`  TINYINT NULL,
    `5_4`  TINYINT NULL,
    `5_5`  TINYINT NULL,
    `5_6`  TINYINT NULL,
    `5_7`  TINYINT NULL,
    `5_8`  TINYINT NULL,
    `5_9`  TINYINT NULL,
    `5_10`  TINYINT NULL,

    `6_1`  TINYINT NULL,
    `6_2`  TINYINT NULL,
    `6_3`  TINYINT NULL,
    `6_4`  TINYINT NULL,
    `6_5`  TINYINT NULL,
    `6_6`  TINYINT NULL,
    `6_7`  TINYINT NULL,
    `6_8`  TINYINT NULL,
    `6_9`  TINYINT NULL,
    `6_10`  TINYINT NULL,
    `6_11`  TINYINT NULL,
    `6_12`  TINYINT NULL,

    `7_1`  TINYINT NULL,
    `7_2`  TINYINT NULL,
    `7_3`  TINYINT NULL,
    `7_4`  TINYINT NULL,
    `7_5`  TINYINT NULL,
    `7_6`  TINYINT NULL,
    `7_7`  TINYINT NULL,
    `7_8`  TINYINT NULL,

    `8_1`  TINYINT NULL,
    `8_2`  TINYINT NULL,
    `8_3`  TINYINT NULL,
    `8_4`  TINYINT NULL,
    `8_5`  TINYINT NULL,

    `9_1`  TINYINT NULL,
    `9_2`  TINYINT NULL,
    `9_3`  TINYINT NULL,
    `9_4`  TINYINT NULL,
    `9_5`  TINYINT NULL,
    `9_6`  TINYINT NULL,
    `9_7`  TINYINT NULL,
    `9_8`  TINYINT NULL,
    `9_9`  TINYINT NULL,

    `10_1`  TINYINT NULL,
    `10_2`  TINYINT NULL,
    `10_3`  TINYINT NULL,
    `10_4`  TINYINT NULL,
    `10_5`  TINYINT NULL,
    `10_6`  TINYINT NULL,
    `10_7`  TINYINT NULL,

    `11_1`  TINYINT NULL,
    `11_2`  TINYINT NULL,
    `11_3`  TINYINT NULL,
    `11_4`  TINYINT NULL,
    `11_5`  TINYINT NULL,
    `11_6`  TINYINT NULL,
    `11_7`  TINYINT NULL,
    `11_8`  TINYINT NULL,
    `11_9`  TINYINT NULL,
    `11_10`  TINYINT NULL,

    `12_1`  TINYINT NULL,
    `12_2`  TINYINT NULL,
    `12_3`  TINYINT NULL,
    `12_4`  TINYINT NULL,

    `13_1`  TINYINT NULL,
    `13_2`  TINYINT NULL,
    `13_3`  TINYINT NULL,
    `13_4`  TINYINT NULL,
    `13_5`  TINYINT NULL,

    `14_1`  TINYINT NULL,
    `14_2`  TINYINT NULL,
    `14_3`  TINYINT NULL,
    `14_4`  TINYINT NULL,
    `14_5`  TINYINT NULL,

    `15_1`  TINYINT NULL,
    `15_2`  TINYINT NULL,
    `15_3`  TINYINT NULL,
    `15_4`  TINYINT NULL,
    `15_5`  TINYINT NULL,

    `16`  TINYINT NULL,
    `17`  TINYINT NULL,
    `18`  TINYINT NULL,
    `19`  TINYINT NULL,
    `20`  TINYINT NULL,
    `21`  TINYINT NULL,
    `22`  TINYINT NULL,
    `23`  TINYINT NULL,
    `24`  TINYINT NULL,
    `25`  TINYINT NULL,
    `26`  TINYINT NULL,
    `27`  TINYINT NULL,
    `28`  TINYINT NULL,

    Q_TotalDuration INT NULL,

    created_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

);