--
-- Host: localhost    Database: culturalawareness
-- ------------------------------------------------------


--
-- Table structure for table `admin_role_admin_user`
--

CREATE TABLE `admin_role_admin_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_role_id` int(10) unsigned NOT NULL,
  `admin_user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admin_role_admin_user_admin_role_id_foreign` (`admin_role_id`),
  KEY `admin_role_admin_user_admin_user_id_foreign` (`admin_user_id`),
  CONSTRAINT `admin_role_admin_user_admin_role_id_foreign` FOREIGN KEY (`admin_role_id`) REFERENCES `admin_roles` (`id`),
  CONSTRAINT `admin_role_admin_user_admin_user_id_foreign` FOREIGN KEY (`admin_user_id`) REFERENCES `admin_users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_role_admin_user`
--

INSERT INTO `admin_role_admin_user` VALUES (1,2,1,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(2,1,2,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(3,2,3,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(4,1,4,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(5,2,5,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(6,1,6,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(7,1,7,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(8,1,8,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(9,2,9,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(10,1,10,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(11,1,11,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(12,2,12,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(13,1,13,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(14,2,14,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(15,2,15,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(16,2,16,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(17,2,17,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(18,1,18,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(19,2,19,'2019-02-26 21:28:06','2019-02-26 21:28:06'),(20,2,20,'2019-02-26 21:28:06','2019-02-26 21:28:06');

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1: Super user, 0: General User',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admin_roles`
--

INSERT INTO `admin_roles` VALUES (1,'Super Admin',1,'2019-02-26 21:28:03',NULL),(2,'Admin',0,'2019-02-26 21:28:03',NULL);

--
-- Table structure for table `communities`
--

CREATE TABLE `communities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `color_code` varchar(255) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `communities`
--

INSERT INTO `communities` VALUES (2,'African American Youth','African American Youth','a2957d',1,'2020-03-25 03:49:07','2020-04-01 10:18:25'),(3,'Mexican and Mexican American','Mexican and Mexican American','646455',1,'2020-03-31 07:51:43','2020-04-02 08:18:03'),(4,'Latino Youth','Latino Youth','c29b53',1,'2020-03-31 08:13:11','2021-01-19 03:33:03'),(5,'Asian','Asian','707646',1,'2020-03-31 08:22:45','2020-04-01 10:18:47'),(6,'Vietnamese','Vietnamese','635e33',1,'2020-03-31 08:29:56','2020-04-01 10:18:53'),(7,'East African/Somali','East African/Somali','73460c',1,'2020-03-31 08:38:27','2020-04-01 10:18:58'),(8,'East African/Somali Youth','East African/Somali Youth','648393',1,'2020-03-31 08:42:23','2020-04-01 10:19:06'),(9,'Muslim','Muslim','3d6070',1,'2020-03-31 08:46:43','2020-04-01 10:19:13'),(10,'Samoan','Samoan','264a52',1,'2020-03-31 08:52:18','2020-04-01 10:19:19'),(11,'Karen/Karenni','Karen/Karenni','5a1805',1,'2020-03-31 09:05:05','2020-04-01 10:19:26'),(12,'Chaldean','Chaldean','a24029',1,'2020-03-31 09:07:07','2021-01-13 01:48:11'),(15,'Native American','Native American','f6a64c',1,'2021-01-18 00:32:18','2021-01-18 00:53:16');

--
-- Table structure for table `communities_answers`
--

CREATE TABLE `communities_answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `community_subdetail_id` int(11) NOT NULL,
  `answer` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `communities_answers`
--

INSERT INTO `communities_answers` VALUES (92,17,'The family unit is very important in Asian culture. There may be multiple generations living under the same roof.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(93,17,'Asian culture stresses the importance of showing respect for elders.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(94,17,'Many immigrant Asian elders do not speak English well. If you ask them something, they may listen, smile and nod. This does not necessarily mean they understand you; they are being friendly and polite','2020-03-31 08:22:45','2020-03-31 08:22:45'),(95,18,'Bowing your head slightly and a “hello” is the preferred greeting by Asian cultures.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(96,18,'Personal space is important; therefore, it is important to respect that.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(97,18,'Asian people typically avoid direct eye contact and may gaze downward when talking because it can be seen as disrespectful to speak to someone while making eye contact.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(98,18,'Summoning a person with a hand or finger in the upright position is reserved only for animals. May use the middle finger to point; it is not meant to be a sign of disrespect.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(99,19,'Many Asian families live in multi- generational households. If the elder does not speak English, he or she may call the second-generation child to translate.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(100,19,'The eldest male is the head of the household or the next generation male.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(101,19,'Asian immigrants who have higher education are more likely to be fluent in English and interact well when approached. Those who are not fluent in English may fear being interrogated and be reluctant to engage in a conversation.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(102,20,'Asian cultures typically view law enforcement as authority and will, therefore, show respect.','2020-03-31 08:22:45','2020-03-31 08:22:45'),(103,20,'However, many Asian cultures have experienced corruption with government and law enforcement officials in their native countries','2020-03-31 08:22:45','2020-03-31 08:22:45'),(104,21,'The family unit is very important in Vietnamese culture. A typical family has three or four generations living under the same roof.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(105,21,'Vietnamese culture stresses the importance of showing respect for elders.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(106,21,'Many Vietnamese elders do not speak English well. If you ask them something, they may listen, smile and nod. This does not necessarily mean they understand you; they are being friendly and polite.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(107,21,'Vietnamese people tend to be very polite, stoic, and avoid sharing their feelings.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(108,22,'If possible, a same gender officer should interact with or search family members.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(109,22,'Many Vietnamese men shake hands in greeting and saying goodbye. Shake with both hands, and bow your head slightly as you shake. Bowing your head slightly is the preferred greeting by Vietnamese women and elders. Women typically do not shake hands with each other or with men.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(110,22,'Vietnamese people typically avoid direct eye contact and may gaze downward when talking. Avoiding eye contact demonstrates respect to elders, people of higher status or of the opposite sex.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(111,22,'Speaking in a loud tone with excessive gestures is considered rude, especially when done by women.','2020-03-31 08:29:56','2020-03-31 08:29:56'),(112,22,'To summon a person, the entire hand with the fingers facing down is the only appropriate hand signal. Using the middle finger to point, with other fingers closed is a common gesture and is not a sign of disrespect. Pointing to other people while talking is considered disrespectful.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(113,23,'Vietnamese families live in multi- generational households. If the elder does not speak English, he or she may call their child to translate.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(114,23,'The eldest male, the husband or the wife would be considered the head of the household.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(115,23,'The use of a trained interpreter rather than a younger child is preferred in order to maintain family hierarchy dynamics.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(116,23,'Vietnamese immigrants who have higher education are more likely to be fluent in English. They are more likely to interact well when approached by a police officer. Those with less education may fear being interrogated and reluctant to engage in a conversation.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(117,24,'The demeanor of a police officer is important because the Vietnamese read faces to communicate. If police officers appear cold and serious, then they are less likely to get information.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(118,24,'The police could use more translation services. Translators are available through telephone companies. Also, the police department could partner with the county to create an employee volunteer pool of translators.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(119,24,'Vietnamese elders sometimes experience fear seeing authority figures in uniform because in Vietnam, the police pound on doors and aggressively approach people.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(120,24,'When the local police approach, Vietnamese elders may walk away due to fear and language barriers.','2020-03-31 08:29:57','2020-03-31 08:29:57'),(121,25,'Families traditionally live in multi- generational households.','2020-03-31 08:38:27','2020-03-31 08:38:27'),(122,25,'They are part of the Muslim community.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(123,25,'In Islam, prayer is performed five times a day: at dawn, noon, mid- afternoon, sunset, and in the evening. Prayer can take place at home, at school, in the workplace, outdoors, or in a mosque.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(124,25,'In the Somali Community, elders are seen as mediators.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(125,25,'Elders feel they have lost their role as problem solvers and are not respected by law enforcement.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(126,26,'It is disrespectful to use the index finger to call someone. Instead, use an open hand/palm to call someone.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(127,26,'Traditionally, men and women do not touch members of the opposite sex outside the family, such as shaking hands. According to Islamic tradition, women are expected to cover their bodies, including their hair.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(128,26,'The Somali language is spoken universally by most Somali people, with Arabic spoken as a common second language. Be aware of language barriers; speak slowly and recognize you may need to repeat yourself. Ask the individual to repeat the information or paraphrase to ensure the message has been conveyed.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(129,27,'When visiting a Somali household, ask to speak with the head of the household. The parents are the decision-makers for the family.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(130,27,'Address elders first. Ask for permission to engage with the child.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(131,27,'Youth may help with translation, but elders should still be acknowledged.\r\nIf a women answers, allow time for her to cover.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(132,28,'Many refugees are afraid of the police due to abuses faced in Somalia.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(133,28,'Youth often distrust law enforcement because they feel they are profiled and harassed.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(134,28,'Most feel targeted for being Muslim.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(135,28,'The community feels that law enforcement is culturally insensitive and they are unfairly stereotyped, which creates confrontational and hostile environments.','2020-03-31 08:38:28','2020-03-31 08:38:28'),(136,29,'Somali youth are often a part of big families and live in multi-generational households.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(137,29,'Somali youth frequently share a common language, Somali, however most youth speak English.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(138,29,'Youth tend to share close relationships and connect with each other because they share the same culture.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(139,29,'Somali youth practice Islamic traditions. They bow, kneel and pray five times a day on a prayer rug in an area that is clean.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(140,30,'“Salaam” “Assalamu Alaikum” - “Peace be with you.” This is a common greeting among Muslims.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(141,30,'When approaching, smile, be positive and offer a handshake. However, do not hug or shake hands with a person of a different gender.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(142,30,'Do not bow because Muslims only bow down to God.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(143,30,'Youth often do not engage in direct eye contact, as it is considered a sign of disrespect.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(144,30,'Be aware of respecting personal body space. Stand a few steps away.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(145,31,'Acknowledge the eldest male first. The male is considered the head of the household.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(146,31,'If only women are at home, it is important to give them sufficient time to cover.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(147,31,'If available, it is better to have a translator, instead of having the youth translate.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(148,31,'If possible, a same gender officer should interact with family members.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(149,31,'In most households, residents do not wear shoes within the home. Wear footies or shoe covering prior to entering the home, if available or provided.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(150,32,'Certain actions by police officers can be perceived as them being above the law instead of being enforcers of the law. They should be mindful of their tone and language.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(151,32,'Police are often viewed as mean, apathetic, and overreactive.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(152,32,'Police can be viewed as sarcastic and unclear about stating their intentions when stopping youth. Police officers should be more approachable and clearly explain what is happening and what their intentions are.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(153,32,'Police officers should be more interactive, build relationships, and provide more community policing to engage with youth and community members before a crime occurs.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(154,32,'Police officers should be conscious about where their hands are placed; resting your hand on your gun can be perceived as threatening.','2020-03-31 08:42:23','2020-03-31 08:42:23'),(155,33,'Islam is a monotheistic Abrahamic faith/religion, and its followers are called Muslims.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(156,33,'Within the Muslim community, there are several ethnic groups and cultures: Arabs, African American, Southeast Asian, Kurds, Somali, etc.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(157,33,'Muslims pray five times a day and must attend an obligatory prayer at their local mosque every Friday. This mid-day prayer is very important; there may be a large crowd going in and out of mosques during this time.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(158,33,'Muslims emphasize respect for the law of the land.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(159,33,'Modesty is an important aspect of the Islamic faith. As such, Muslim women cover their bodies and wear a headscarf to cover their hair. Muslim men cover their bodies and often wear a head cap (kufi) and a beard.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(160,34,'Peaceful greeting is very important (verbal, engage in open communication): “Salaam” or any common form of greeting such as “Hello” “Good morning” etc.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(161,34,'Be mindful of personal space. Physical contact such as a handshake with opposite gender is discouraged.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(162,34,'Muslims typically avoid direct eye contact and may gaze downward when talking. It can be seen as disrespectful to speak to someone while making eye contact.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(163,34,'Most households do not wear shoes within the home. Wear footies or shoe covering prior to entering the home, if available or provided.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(164,34,'If possible, a same gender officer should interact with family members and/or suspects.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(165,35,'The eldest male is considered the head of the household. Typically, a male will answer the door. The head of household may ask his wife or his daughters to cover and put on their full dress and hijab.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(166,35,'If only women are at home, it is important to give them sufficient time to cover.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(167,35,'Dress code: Mandatory hijab for women vs. optional kufi for men (man may remove from his head).','2020-03-31 08:46:43','2020-03-31 08:46:43'),(168,35,'Some Muslim cultures feel extreme discomfort around dogs and may not appreciate them entering their homes.','2020-03-31 08:46:43','2020-03-31 08:46:43'),(169,36,'Many Muslim immigrants tend to have trust issues with authority because of past traumas living in police states where they experienced religious/cultural persecution. Living in America, they are sometimes still scared, fearful, and paranoid because they have only known authorities to be abusive and corrupt.','2020-03-31 08:46:44','2020-03-31 08:46:44'),(170,36,'Post 9/11, many Muslims feel they are unfairly targeted or profiled by law enforcement due to religious and racial biases.','2020-03-31 08:46:44','2020-03-31 08:46:44'),(171,36,'Muslims often feel that there is not enough Muslim representation in law enforcement.','2020-03-31 08:46:44','2020-03-31 08:46:44'),(172,37,'Samoans are known for having close- knitted, big families and are taught to serve, respect, and honor their elders.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(173,37,'Samoans can be of different religions.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(174,37,'They are very hospitable, hardworking, and are known to sacrifice a great deal for what they value and believe.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(175,37,'There are different layers of leadership in the Samoan community.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(176,37,'Tattoos are based on tribal affiliations.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(177,38,'Explain why you are approaching and avoid walking in front of elders.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(178,38,'Youth will follow instructions based on how they are treated.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(179,38,'Family members are very close, try not to separate them or they will become defensive and protective.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(180,38,'Move quietly and do not rush or make any sudden, distracting movements.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(181,38,'Avoid making a lot of noise or any loud noises. It is considered rude and disrespectful. No hard banging on the door. Keep door tapping congenial and respectful to the family dwelling.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(182,39,'Please wait to be invited into the household.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(183,39,'Acknowledge the presence of elders. If you need to speak with a child, first ask for a parent or an elder and explain the situation. State the issues with the youth and your intention to follow-up with the family.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(184,39,'Youth may translate for elders or head of family, but the elder will identify who translates and sits with them.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(185,39,'Do not interrupt an elder or leader; they expect the listener to be quiet when they are speaking. Avoid turning your backside to elders and when sitting, avoid having your back to anyone.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(186,39,'When they offer you any food or drink, it is most hospitable and respectful to receive it.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(187,40,'Samoan people often feel that law enforcement officers are intimidated by their size. Do not make assumptions about age or maturity based on size. Ask for age.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(188,40,'Elders are the authority figures in Samoa and are sought to resolve problems in their culture. In Samoa, elders did not have police. They lived in little villages with a mayor, who oversaw the village households and held family chiefs accountable for their family members’ actions.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(189,40,'Samoans expressed feeling fear of the police because they occasionally perceive that police approach aggressively.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(190,40,'Law enforcement needs to recognize the importance of Samoan communal bonds and working with families.','2020-03-31 08:52:18','2020-03-31 08:52:18'),(191,41,'Karen and Karenni people are from Burma, which is a multiethnic, multilingual, and multicultural society. Many have resettled in the United States because of political turmoil in their homeland. Community members are very connected and seek advice from one another.','2020-03-31 09:05:05','2020-03-31 09:05:05'),(192,41,'Most Karen and Karenni people in the United States are Christians, but some are Buddhists.','2020-03-31 09:05:05','2020-03-31 09:05:05'),(193,41,'Refugees in San Diego have strong family ties and usually think in terms of the community rather than the individual. Families and friends visit each other freely. They are used to inviting neighbors over to share food and drink.','2020-03-31 09:05:05','2020-03-31 09:05:05'),(194,41,'When having conversations, it’s typical for friends to walk behind one another. When in Burma, the leader would go first and others would walk carefully behind in single file because of the jungle conditions.','2020-03-31 09:05:05','2020-03-31 09:05:05'),(195,42,'Both the Karen and Karenni speak dialects of the Karen languages. Interpreters are available through the Karen Organization of San Diego.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(196,42,'Karen and Karenni people tend to be shy and do not look at people directly in the face when speaking. Making eye contact is viewed as disrespectful.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(197,42,'When a police officer approaches, they may smile or laugh a little to show politeness.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(198,42,'Shaking hands creates trust.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(199,42,'Signs of respect and politeness in Karen and Karenni culture include crossing arms and keeping hands in pockets.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(200,43,'Families tend to be extended rather than nuclear. It’s common for three generations to live together in one household.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(201,43,'The second generation is expected to take care of their parents.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(202,43,'The father or mother of the second generation should be addressed first and are considered the head of the household.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(203,43,'Youth typically speak English, but should not speak on behalf of adults.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(204,43,'Karen and Karenni people are very hospitable and may offer food or drink.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(205,44,'They have respect for law enforcement rules and regulations in the United States. They feel safe.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(206,44,'Elders remember being young and having to run away from soldiers during interrogations at refugee camps in Thailand. They became scared to speak up during conflict because they were abused whether they told the truth or not.','2020-03-31 09:05:06','2020-03-31 09:05:06'),(264,5,'African Americans often have strong religious affiliations. Many are tied to Christian denominations, but a significant number also follow Islam.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(265,6,'Recognize youth as people and do not judge by appearances.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(266,6,'Greeting is very important. - “Hi, how are you doing?” Establish rapport; introduce yourself and extend a handshake. Respect a youth’s personal space.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(267,6,'Keep a calm composure and steady pace when approaching youth. Youth recognize you are the authority figure.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(268,6,'Be conscious of where your hands are placed; resting your hand on your gun can be perceived as threatening. Be aware of your tone of voice (tone, pace, pitch, volume). For example, yelling does not help and will only escalate the situation.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(269,6,'Provide explanations in a clear and respectful manner. For example, “I want to ensure we are in a safe situation. Can you please show me your hands?” This will help youth comply and avoid confusion.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(270,7,'Mother or father should be addressed first. Youth should be addressed in the presence of a parent or guardian. Youth may be uncomfortable speaking with officer because of parent or guardian’s rules.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(271,8,'Certain actions by police officers can be perceived as placing themselves above the law instead of being enforcers of the law. For example, pulling over an individual for not wearing a seatbelt, when the officer was not wearing one before the stop. In addition, using sirens and flashing lights to speed through traffic lights; but then turning them off can be seen as there is no apparent emergency.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(272,8,'African American males expressed feeling harassed when approached by cops because they approached in an aggressive fashion and talked in a condescending manner. Avoid making generalizations and threats.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(273,8,'Police officers should be more approachable and tell youth what is happening. Make eye contact; police officers should remove their sun glasses to appear less intimidating. Youth want to feel safe, be respected, and be aware of the situation.','2020-05-05 00:03:23','2020-05-05 00:03:23'),(274,8,'Youth behaviors such as pacing, fidgeting, and talking back are generally signs of distress from being in an uncomfortable situation. Youth may actually be venting their frustrations.','2020-05-05 00:03:24','2020-05-05 00:03:24'),(275,8,'Youth may be reluctant to trust officers due to fear and past traumatic experiences with corrupt officers in their home countries.','2020-05-05 00:03:24','2020-05-05 00:03:24'),(292,9,'Spending time with family and friends are vital parts of life.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(293,9,'Many Mexican immigrants and Mexican Americans are Roman Catholics.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(294,10,'Knock on the door and identify yourself. Be calm and use a non- confrontational tone.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(295,10,'\"Hola. ¿Cómo estás?\" \"Hello. How are you?\" instead of \"Who speaks English here?\"','2020-05-05 00:09:12','2020-05-05 00:09:12'),(296,10,'Address the situation being called to handle.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(297,10,'Bring out the person you want to speak with. For example, if approaching a group of youth separate them and talk to them individually.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(298,10,'Never assume someone is less intelligent because of a language barrier.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(299,11,'Males are typically the head of the household, especially in the older generation, and often answer all questions.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(300,11,'Ask: “May I speak to the head of the household?”','2020-05-05 00:09:12','2020-05-05 00:09:12'),(301,11,'Wait outside, do not just walk-in.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(302,12,'This community has trust issues based on history of mistreatment and racial profiling.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(303,12,'If they are undocumented, families may face fear of deportation.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(304,12,'Mexicans and Mexican Americans often feel police treat them differently and make them feel inferior.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(305,12,'They feel disrespected when the police tell them to sit on the curb.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(306,12,'Just because they dress a certain way, it is unfair to assume they are criminals.','2020-05-05 00:09:12','2020-05-05 00:09:12'),(337,45,'A simple portrayal of the Chaldeans would be that they are Christians whose ancestors can be traced as far back to ancient Mesopotamia.','2021-01-13 01:48:11','2021-01-13 01:48:11'),(338,45,'Aramaic is the language and Chaldeans are the people.','2021-01-13 01:48:11','2021-01-13 01:48:11'),(339,45,'The culture puts great emphasis on religion.','2021-01-13 01:48:11','2021-01-13 01:48:11'),(340,45,'Chaldean culture is family-oriented. They value hospitality and utilize the Pride-Shame system centered around honor and respect.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(341,46,'Greeting is very important (verbal): “Shalama elokhon”.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(342,46,'It is acceptable to have physical contact (handshake) with the opposite gender.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(343,46,'It is acceptable to have a different gender officer interact with family members.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(344,47,'If the father is not available, the eldest male or anyone who is considered the head of the household would answer the door. Typically, a male will answer the door.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(345,47,'A youth may translate if the parent’s first language is Arabic or Aramaic.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(346,48,'The majority of Chaldeans are highly respectful and trust law enforcement because of past traumas, where they experienced religious/cultural persecution. Living in America makes them feel safer.','2021-01-13 01:48:12','2021-01-13 01:48:12'),(347,49,'dserererrer','2021-01-13 07:09:17','2021-01-13 07:09:17'),(348,50,'tyuytuytutyu5465','2021-01-13 07:09:18','2021-01-13 07:09:18'),(349,51,'fhyty65y5','2021-01-13 07:09:18','2021-01-13 07:09:18'),(350,52,'t5tyyerye','2021-01-13 07:09:18','2021-01-13 07:09:18'),(351,53,'ghjghj','2021-01-15 00:12:23','2021-01-15 00:12:23'),(352,54,'ghjghj','2021-01-15 00:12:25','2021-01-15 00:12:25'),(353,55,'uyiuyiku','2021-01-15 00:12:26','2021-01-15 00:12:26'),(354,56,'t uttrtutruu','2021-01-15 00:12:27','2021-01-15 00:12:27'),(415,57,'1. There are more than 500 federally recognized tribes in the country, each with its own distinct culture and religion. They are all covered under the American Indian Religious Freedom Act of 1978. Learning about these laws provide a better understanding of the Native American culture and their rights.','2021-01-18 01:13:49','2021-01-18 01:13:49'),(416,57,'Many Native Americans come to San Diego from other states to have a better life. They tend to experience culture shock as they move from a remote reservation into a big city, so it is important for officers to be trained on inter-generational trauma and culture shock.','2021-01-18 01:13:49','2021-01-18 01:13:49'),(417,57,'Some Native Americans carry a sealed medicine bag around their neck, which may contain one of the four sacred herbs: sage, tobacco, cedar or sweetgrass. This bag is used for medical purposes or to represent the individual’s beliefs, religion and culture. Ask to see what is inside when open, but when sealed, it is sacred and is not meant to be reopened. If opened, this is seen as disrespectful and may upset the person. In certain instances, indigenous people roll their own tobacco in a paper like the paper used to role marijuana, so it is misconstrued as that.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(418,57,'During Summertime, Indigenous communities have a ceremonial dance where some tribes do sacrifices (sacred act) or have piercings above their chest area and on their back. Those piercings can be misidentified as mutilation or self-harm.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(419,57,'On the Navajo side, the Southern Indians of America ingest the peyote buds during a special religious ceremony which in certain places is illegal. Some individuals hold a card permitting them to ingest the buds.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(420,58,'There is always someone who speaks for the family, it could be the niece, the grandchild, or the grandmother. Unlike in many other cultures, it does not have to be a man. Many Native American tribes are matriarchal.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(421,58,'It would be best to ask nicely to come in and let the family know why you are there and ask for the person to speak to.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(422,58,'Out of respect when entering a home and there is an elder in the room, great them and acknowledge their presence even if they are not the person you will speak with.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(423,58,'Some tribes do not shake hands with people they do not know to avoid any ‘negative energy’ a person may have. Out of respect, some Native Americans will not make eye contact, especially with respected people.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(424,58,'In most households, a child or any adult at home may open the door slightly to check who it is then close it to inform the person in charge of the household. If grandparents who only speak their native tongue are visiting and the parent is not at home while the children are, the kids will not be able to translate for them.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(425,59,'Native Americans are known to have multi-generations living underneath one roof.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(426,59,'Hair is covered under the federal law because it is sacred to the indigenous people, so it would be more respectful to ask to touch it, if needed to.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(427,59,'It is important for the dispatcher to inform the officer that when they respond to a Native American call, have an advocate present, especially if the family does not speak English.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(428,59,'Some tribal families may be receiving social services through state or tribal programs. Consider asking if they are receiving services or have a case/social worker they can call to mitigate or prevent an issue before there needs to be an intervention.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(429,59,'Some tribal individuals and families conduct daily rituals with herbs that can smell like cannabis or other substances. Be aware of the difference.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(430,60,'Officers may unknowingly disrespect an individual, which may cause them to shut down or not cooperate. This is a consequence of a long history of mistrust in law enforcement. It is common in Native American communities to take a moment to think about an answer. The officers should be patient and not expect immediate answers.','2021-01-18 01:13:50','2021-01-18 01:13:50'),(431,60,'Native Americans are afraid of going to jail off the reservation. Furthermore, it is very hard for an indigenous person to see their family member talking with an officer alone. The whole family will congregate around that person to make sure their loved one is being respected and is comfortable with talking to the officer.','2021-01-18 01:13:51','2021-01-18 01:13:51'),(432,60,'If a third party, such as Child Welfare Services, needs to be called to an incident, the officer should inform that organization that they are working with a Native American household. There are laws that protect the children of the enrolled tribal members so a knowledgeable person of those laws should be present.','2021-01-18 01:13:51','2021-01-18 01:13:51'),(433,60,'Smiling and laughing is common in a traumatic incident such as domestic violence or sexual assault,  this is the way Native Americans deal with such situations and it does not mean they are happy. Those individuals understand they have been victimized.','2021-01-18 01:13:51','2021-01-18 01:13:51'),(434,60,'Indians have many cultural items at home and sometimes travel with them. The officer should allow the individual to open and move around their belongings themselves. It is considered very demeaning if the officers touch those items.','2021-01-18 01:13:51','2021-01-18 01:13:51'),(435,13,'Spending time with family and friends are vital parts of life.','2021-01-19 03:33:04','2021-01-19 03:33:04'),(436,13,'Many Mexican immigrants and Mexican Americans are Roman Catholics.','2021-01-19 03:33:05','2021-01-19 03:33:05'),(437,14,'Recognize youth as people, do not judge by appearances.','2021-01-19 03:33:06','2021-01-19 03:33:06'),(438,14,'Greeting is very important. - “Hi, how are you doing?” Establish rapport, introduce yourself and extend a handshake.','2021-01-19 03:33:07','2021-01-19 03:33:07'),(439,14,'Keep a calm composure and steady pace when approaching youth. Respect a youth’s personal space. Youth recognize you as the authority figure.','2021-01-19 03:33:07','2021-01-19 03:33:07'),(440,14,'Be conscious of where your hands are placed; resting your hand on your gun can be perceived as threatening. Keep communication simple and professional to avoid escalating into complicated situations.','2021-01-19 03:33:07','2021-01-19 03:33:07'),(441,14,'Be aware of your tone of voice (tone, pace, pitch, volume). For example, yelling does not help and will only escalate the situation. Provide explanations in a clear and respectful manner. For example, “I want to ensure we are in a safe situation. Can you please show me your hands?” This will help youth comply and avoid confusion.','2021-01-19 03:33:08','2021-01-19 03:33:08'),(442,15,'Youth may translate if the parent’s first language is Spanish.','2021-01-19 03:33:08','2021-01-19 03:33:08'),(443,15,'Males are typically the head of the household, especially in the older generation, and often answer all questions.','2021-01-19 03:33:09','2021-01-19 03:33:09'),(444,15,'Ask: “May I speak to the head of the household?”','2021-01-19 03:33:10','2021-01-19 03:33:10'),(445,15,'Wait outside, do not just walk-in.','2021-01-19 03:33:11','2021-01-19 03:33:11'),(446,16,'Certain actions by police officers can be perceived as them being above the law instead of being enforcers of the law. Youth feel respect must be displayed by the officer at all times. For example, pulling over an individual for not wearing a seatbelt when the officer was not wearing one before the stop sends a wrong message. In addition, using sirens and flashing lights to speed through traffic lights; but then turning them off can be seen as no apparent emergency.','2021-01-19 03:33:12','2021-01-19 03:33:12'),(447,16,'Youth in groups tend to defend each other. It matters how you address them in order to get compliance. Immigrant youth or adults may speak to an officer at the door or from a window because they feel uncertain of the officer’s intent.','2021-01-19 03:33:13','2021-01-19 03:33:13'),(448,16,'Youth immigrants and youth with immigrant parents may be reluctant to trust officers because of fear due to past traumatic experiences with corrupt officers in their home countries.','2021-01-19 03:33:13','2021-01-19 03:33:13'),(449,16,'Make eye contact; police officers should remove their sunglasses to appear less intimidating. Youth want to feel safe, be respected, positively acknowledged and made aware of the situation. If possible, ask to send the kids to another room when arresting a parent.','2021-01-19 03:33:14','2021-01-19 03:33:14'),(450,16,'Youth behaviors such as pacing, fidgeting, and talking back are generally signs of distress from being in an uncomfortable situation. Youth may be venting their frustrations.','2021-01-19 03:33:14','2021-01-19 03:33:14');

--
-- Table structure for table `communities_sub_details`
--

CREATE TABLE `communities_sub_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `community_id` int(11) NOT NULL,
  `sub_title` varchar(255) NOT NULL,
  `questions` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `communities_sub_details`
--

INSERT INTO `communities_sub_details` VALUES (5,2,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-25 03:49:08','2020-04-07 15:05:00'),(6,2,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-25 03:49:08','2020-03-31 07:39:54'),(7,2,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-25 03:49:08','2020-03-25 06:58:55'),(8,2,'Experience with law enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-25 03:49:08','2020-03-31 07:39:54'),(9,3,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 07:51:43','2020-04-07 15:04:56'),(10,3,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 07:51:43','2020-03-31 07:51:43'),(11,3,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 07:51:43','2020-03-31 07:51:43'),(12,3,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 07:51:43','2020-03-31 07:51:43'),(13,4,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:13:11','2020-04-07 15:04:52'),(14,4,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:13:11','2020-03-31 08:13:11'),(15,4,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:13:11','2020-03-31 08:13:11'),(16,4,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:13:11','2020-03-31 08:13:11'),(17,5,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:22:45','2020-04-07 15:04:48'),(18,5,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:22:45','2020-03-31 08:22:45'),(19,5,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:22:45','2020-03-31 08:22:45'),(20,5,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:22:45','2020-03-31 08:22:45'),(21,6,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:29:56','2020-04-07 15:04:45'),(22,6,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:29:56','2020-03-31 08:29:56'),(23,6,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:29:57','2020-03-31 08:29:57'),(24,6,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:29:57','2020-03-31 08:29:57'),(25,7,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:38:27','2020-04-07 15:04:42'),(26,7,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:38:28','2020-03-31 08:38:28'),(27,7,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:38:28','2020-03-31 08:38:28'),(28,7,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:38:28','2020-03-31 08:38:28'),(29,8,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:42:23','2020-04-07 15:04:39'),(30,8,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:42:23','2020-03-31 08:42:23'),(31,8,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:42:23','2020-03-31 08:42:23'),(32,8,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:42:23','2020-03-31 08:42:23'),(33,9,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:46:43','2020-04-07 15:04:35'),(34,9,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:46:43','2020-03-31 08:46:43'),(35,9,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:46:43','2020-03-31 08:46:43'),(36,9,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:46:43','2020-03-31 08:46:43'),(37,10,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 08:52:18','2020-04-07 15:04:31'),(38,10,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 08:52:18','2020-03-31 08:52:18'),(39,10,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 08:52:18','2020-03-31 08:52:18'),(40,10,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 08:52:18','2020-03-31 08:52:18'),(41,11,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 09:05:05','2020-04-07 15:04:20'),(42,11,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 09:05:06','2020-03-31 09:05:06'),(43,11,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 09:05:06','2020-03-31 09:05:06'),(44,11,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 09:05:06','2020-03-31 09:05:06'),(45,12,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2020-03-31 09:07:07','2020-04-07 15:04:15'),(46,12,'Greetings','What is the appropriate manner to greet you? (demeanor, non- verbal, body space, handshake, bow, male-female interaction etc.)','2020-03-31 09:07:07','2020-03-31 09:07:07'),(47,12,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2020-03-31 09:07:07','2020-03-31 09:07:07'),(48,12,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2020-03-31 09:07:07','2020-03-31 09:07:07'),(49,13,'Traditions and Beliefs','dstest','2021-01-13 07:09:17','2021-01-13 07:09:17'),(50,13,'Greetings','ytutyt','2021-01-13 07:09:17','2021-01-13 07:09:17'),(51,13,'Visiting Households','5y654655','2021-01-13 07:09:18','2021-01-13 07:09:18'),(52,13,'Experience with Law Enforcement','565457','2021-01-13 07:09:18','2021-01-13 07:09:18'),(53,14,'Traditions and Beliefs','ghjhj','2021-01-15 00:12:23','2021-01-15 00:12:23'),(54,14,'Greetings','ghjghj','2021-01-15 00:12:25','2021-01-15 00:12:25'),(55,14,'Visiting Households','ertert','2021-01-15 00:12:25','2021-01-15 00:12:25'),(56,14,'Experience with Law Enforcement','tyutut','2021-01-15 00:12:27','2021-01-15 00:12:27'),(57,15,'Traditions and Beliefs','What cultural / ethnic / religious traditions or beliefs should law enforcement be aware of?','2021-01-18 00:32:18','2021-01-18 00:32:18'),(58,15,'Greetings','What is the appropriate manner to greet you? (demeanor, non-verbal, body space, handshake, bow, male-female interaction etc.)','2021-01-18 00:32:21','2021-01-18 00:32:21'),(59,15,'Visiting Households','Who should be addressed or acknowledged first? Who is the head of the household?','2021-01-18 00:32:24','2021-01-18 00:32:24'),(60,15,'Experience with Law Enforcement','What is your view / perception of law enforcement? What are your experiences with law enforcement?','2021-01-18 00:32:27','2021-01-18 00:32:27');

--
-- Table structure for table `email_hooks`
--

CREATE TABLE `email_hooks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_hooks_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_hooks`
--



--
-- Table structure for table `email_preferences`
--

CREATE TABLE `email_preferences` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `layout_html` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_preferences`
--

INSERT INTO `email_preferences` VALUES (1,'Main Layout','<html>\r\n<head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /></head>\r\n<body><div>\r\n<table align=\"center\" cellpadding=\"0\" cellspacing=\"0\" style=\"border:1px solid #dddddd;\" width=\"650\">\r\n	<tbody>\r\n		<tr>\r\n			<td>\r\n			<table cellpadding=\"0\" cellspacing=\"0\" style=\"background:#ffffff; border-bottom:1px solid #dddddd; padding:15px;\" width=\"100%\">\r\n				<tbody>\r\n					<tr>\r\n						<td><a href=\"##BASE_URL##\" target=\"_blank\"><img alt=\"\" border=\"0\" src=\"##SYSTEM_LOGO##\" /></a></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"background:#ffffff; padding:15px;\">\r\n			<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\r\n				<tbody>\r\n					<tr>\r\n						<td style=\"font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#000000; font-size:16px;\">\r\n							##EMAIL_CONTENT##\r\n						</td>\r\n					</tr>\r\n					<tr>\r\n						<td style=\"font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#043f8d; font-size:16px; vertical-align:middle; text-align:left; padding-top:20px;\">\r\n						##EMAIL_FOOTER##\r\n						</td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"background:#043f8d; border-top:1px solid #dddddd; text-align:center; font-family:\'Trebuchet MS\', Arial, Helvetica, sans-serif; color:#ffffff; padding:12px; font-size:12px; text-transform:uppercase; font-weight:normal;\">##COPYRIGHT_TEXT##</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n</div>\r\n</body>\r\n</head>\r\n</html>','2019-02-27 00:05:47','2019-02-27 00:05:47');

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email_hook_id` int(10) unsigned NOT NULL,
  `subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `footer_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_preference_id` int(10) unsigned NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `email_templates_email_hook_id_foreign` (`email_hook_id`),
  KEY `email_templates_email_preference_id_foreign` (`email_preference_id`),
  CONSTRAINT `email_templates_email_hook_id_foreign` FOREIGN KEY (`email_hook_id`) REFERENCES `email_hooks` (`id`),
  CONSTRAINT `email_templates_email_preference_id_foreign` FOREIGN KEY (`email_preference_id`) REFERENCES `email_preferences` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_templates`
--

INSERT INTO `email_templates` VALUES (1,1,'##USER_NAME##, a very warm welcome to the ##SYSTEM_APPLICATION_NAME##','<p>We&rsquo;re so happy to have you with us.</p>\r\n\r\n<p>Please click on the button below to confirm we got the right email address.</p>\r\n\r\n<p><a href=\"##VERIFY_LINK##\">VERIFY MY EMAIL</a></p>\r\n\r\n<p>Or copy and paste the link below.</p>\r\n\r\n<p>##VERIFY_LINK##</p>','Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##',1,1,'2019-02-27 00:20:47','2019-10-02 08:27:45'),(2,2,'Reset Password Notification','<h1 style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #2F3133; font-size: 19px; font-weight: bold; margin-top: 0; text-align: left;\">Hello!</h1>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">You are receiving this email because we received a password reset request for your account.</p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\"><a href=\"##RESET_PASSWORD_URL##\">Reset Password</a></p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">This password reset link will expire in 60 minutes.</p>\r\n\r\n<p style=\"font-family: Avenir, Helvetica, sans-serif; box-sizing: border-box; color: #74787E; font-size: 16px; line-height: 1.5em; margin-top: 0; text-align: left;\">If you did not request a password reset, no further action is required.</p>','Thanks & Regards,\r\n##SYSTEM_APPLICATION_NAME##',1,1,'2019-02-27 00:21:52','2019-02-27 00:21:52'),(3,5,'New Password Notification','<p>Hi ##USER_NAME##,</p>\r\n\r\n<p><br />\r\nYour New Password is ##PASSWORD##.</p>\r\n\r\n<p>Please use this password to login in the mobile app.</p>','Thanks & Regards,\r\n##SYSTEM_APPLICATION_NAME##',1,1,'2019-02-27 00:21:52','2019-10-03 00:27:36'),(4,6,'##USER_NAME##, a very warm welcome to the ##SYSTEM_APPLICATION_NAME##','<p>We&rsquo;re so happy to have you with us.</p>\r\n\r\n<p>Please click on the button below to confirm we got the right email address.</p>\r\n\r\n<p><a href=\"##VERIFY_LINK##\">VERIFY MY EMAIL</a></p>\r\n\r\n<p>Your auto generated password to login in mobile app is ##PASSWORD## </p>','Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##',1,1,'2019-02-27 00:20:47','2019-10-02 08:27:45'),(5,7,'##INQUIRY_SUBJECT##','<p>Name : ##INQUIRY_NAME##<br />\r\nEmail : ##INQUIRY_EMAIL##<br />\r\nPhone : ##INQUIRY_PHONE##<br />\r\n<br />\r\nInquiry Message:<br />\r\n##INQUIRY_MESSAGE##</p>','Thanks and Regards,\r\n##SYSTEM_APPLICATION_NAME##',1,1,'2019-02-27 00:20:47','2019-10-04 03:05:19');

--
-- Table structure for table `enquiries`
--

CREATE TABLE `enquiries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_address` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `enquiries`
--

INSERT INTO `enquiries` VALUES (1,'asdasd','abc@yopmail.com','asdasd','asdasd','2019-09-17 07:45:38','2019-09-17 07:45:38'),(2,'asdasd','a@yopmail.com','','asdasdasd','2019-09-17 07:45:50','2019-09-17 07:45:50'),(3,'asdadsasd','asdasd@yopmail.com','','asdasdasd','2019-09-17 07:49:18','2019-09-17 07:49:18'),(4,'shyam','dadhich@yopmail.com','','hii user','2019-09-17 08:00:59','2019-09-17 08:00:59'),(5,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-24 22:45:43','2020-03-24 22:45:43'),(6,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-24 22:46:03','2020-03-24 22:46:03'),(7,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-24 22:46:23','2020-03-24 22:46:23'),(8,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-24 22:47:27','2020-03-24 22:47:27'),(9,'Ajay Vyas','ajay.vyas@yopmail.com','Test','Hello hellocan’t was a great time for me and my family for the weekend I love to see the new people','2020-03-25 05:39:29','2020-03-25 05:39:29'),(10,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-25 05:41:42','2020-03-25 05:41:42'),(11,'Bot2','bot2@yopmail.com','Bot2 subject','Test','2020-03-26 08:33:59','2020-03-26 08:33:59'),(12,'Amit','amit@yopmail.com','Sub','Message','2020-03-30 09:53:13','2020-03-30 09:53:13'),(13,'name','dev@yopmail.com','sthis is subject','this is your message','2020-03-31 04:07:58','2020-03-31 04:07:58'),(14,'Kumar','kd@yopmail.com','Test','we will see how it to me so I have a question regarding my order number is a bit of the rest is the kids are','2020-04-02 05:51:48','2020-04-02 05:51:48'),(15,'test','test@test.com','testest','djsjdb','2020-04-03 04:29:49','2020-04-03 04:29:49'),(16,'name','dev@yopmail.com','sthis is subject','this is your message','2020-04-27 04:14:19','2020-04-27 04:14:19'),(17,'User','kd@gmail.com','Corona','Stay At Home','2020-05-01 07:56:08','2020-05-01 07:56:08'),(18,'Ariel Freaner','arielfreaner@freaner.com','This is a test','Please confirm you received this message','2020-05-02 14:08:03','2020-05-02 14:08:03'),(19,'Gerald','gbrown@sandiego.gov','Test','Thank you for your hard work to bring this app to our Law Enforcement Professionals.','2020-08-04 23:12:45','2020-08-04 23:12:45'),(20,'Javier Ruiz','javier.ruiz@carlabadca.gov','access to phone photos','why is this app requesting access to your phones gallery and other areas?  what does this have to do with cultural awareness. we have sensitive info on PD phones that we don\'t want to allow this app to access. if we say no to the request then we basically can\'t use the app. thoughts or solutions to this would be great.','2020-09-03 11:47:47','2020-09-03 11:47:47'),(21,'Test','kumar@yopmail.com','Testsub','Test sending','2021-01-22 03:16:00','2021-01-22 03:16:00'),(22,'1234','test@mailinator.com','test','Test','2021-01-25 07:55:34','2021-01-25 07:55:34'),(23,'1qwe','test@mailinator.com','test','Test','2021-01-25 07:58:44','2021-01-25 07:58:44'),(24,'test','test@mailinator.com','test','Test','2021-01-25 08:04:26','2021-01-25 08:04:26'),(25,'Test','test@test.com','Test','Test','2021-03-18 10:45:49','2021-03-18 10:45:49'),(26,'Will','w7fontenot@gmail.com','African American Adults & Youths/Community','Hello, the title above would be more appropriate for this app and website! We\'re not a community of just Youths as it is labeled in this app and the website and the police deals with African American Adults and youths! Hopefully my constructive feedback will assist in correcting this, thanks.','2021-06-03 18:59:08','2021-06-03 18:59:08'),(27,'Erik Hanson','erikandingrid@cox.net','Native American section.','There are many errors in the Peyote section. The first sentence, with Navajo in it is a fragment keft over from somewhere. Peyote religion  (Native American Church is the proper name) is practiced in all of Indian county, all the way up into Canada, certainly in Montana, the Dakotas, Oklahoma, Etc. for 100 years certainly not just a Southwestern thing. This whole section needs a rewrite. \nPolice should not be inquiring about any bundle or pouch, even if “open”. In fact, an open bundle might likely be in the middle of a ceremony or some other sacred action. None of their business.','2021-06-03 23:46:32','2021-06-03 23:46:32'),(28,'Dr. James Starks Jr.','Emasterguns@gmail.com','No African-American Adult Section??','Hello,\n\nPerhaps I may have missed it (I do not believe so), but I did not see a section regarding the subject-matter demographic? \n\nWith the killing and harassment of  African-American Adults (e.g., Mr. George Floyd, etc), it seems that understanding and tactics for interacting with these tax payers is also extremely necessary and pertinent.\n\nAs a African-American taxpayer, as a retired military veteran of 28 years, and as a local small business owner, I am troubled by this. I also have anxiety when interacting with police, despite being a law-abiding altruistic person.\n\nPlease help me understand.\n\nKind regards,\n\nJames','2021-06-04 00:21:08','2021-06-04 00:21:08'),(29,'Erik Hanson','erikandingrid@cox.net','Native Anerican, 2','Continuation of thoughts. The likelyhood of encountering  a bundle is quite small. Much more likely to be seen is a cedar-wood box, which very likely contains ceremonial objects, especially fans and feathers. I’m shocked that feathers were not nentioned by anyone that was consulted. They have strong religions and ceremonial pourpises for most tribes, its very common for police to mess with feathers on car rearview mirrors, for example, this would be the equivilant of handeling or mocking a Roman Catholic’s rosary beads on a mirror, which I hope no policenan would do. Feathers also might be in an individual’s hair, on the car dashboard, on a graduation cap, on pictures in a home, on clothing, doorways, etc. Remember that enroled tribal citizens are allowed to own feathers for religious and cultural purposes that others are not, so its’s not a profitable time to be playing junior ornithologist. \nHair, especially braided hair, on both men or wonen, is a whole other cultural topic that is totally lacking in this app. I could go on, and on, but suffice it to say that long hair should not be played with, tugged on, or even commented on. It is not there for your judgement or analysis. \nIf you see a drum, rattle, flute or other musical instrument, do not touch or play with it, the cultural conotations are something you do not understand. \nPlease, talk to your cultural experts about all this.','2021-06-04 00:26:29','2021-06-04 00:26:29'),(30,'Carla Stayboldt, MD','cstayboldt@cox.net','Suggestions to App','Consider making <back in a paler blue to contrast better with the black background. \n\nConsider putting HOME in the blue circle for clarity.\n\nThe App is well designed, easy to use and attractive. Nice job!','2021-06-05 04:46:11','2021-06-05 04:46:11'),(31,'India','fatehjeet2k15@gmail.com','health care management','importance of cultural awareness in healthcare','2021-07-04 11:48:06','2021-07-04 11:48:06'),(32,'Chris Neal','chrislneal193@gmail.com','White /European','Why don\'t you have cultural awareness tips for this group or white people?','2022-10-17 20:24:18','2022-10-17 20:24:18');

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `heading` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=active, 1=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (26,'Lorem ipsum dolor sit amet, gubergren elaboraret eos ne, bonorum volumus interpretaris per ad.','<p>Civibus quaerendum sit ei, usu errem quidam definitionem ut, pro quod scaevola inimicus cu. Ut integre legendos incorrupte ius. Sea saperet prodesset posidonium te, usu in numquam erroribus similique. Qui facilisi scribentur dissentiunt no, prima atomorum vulputate an vim, ei eam tale assueverit.</p>',1,'2019-09-17 00:06:40','2019-09-17 00:06:40'),(27,'Cum falli expetenda in, ad nam inani discere, ludus nominavi ea eum. Sed dico timeam scriptorem ne, mei veritus platonem interpretaris te, pro ne saepe copiosae facilisis.','<p>Offendit vituperatoribus vix ne, postea dicunt tamquam mel no. Eum et docendi epicuri abhorreant, usu ea essent gloriatur necessitatibus, id ius solet graecis corpora. No nominavi interpretaris ius.</p>\r\n\r\n<p>Cum altera disputando at, ut augue ceteros democritum nam, malis cotidieque vel no. Cetero necessitatibus duo an, id fastidii epicurei abhorreant sit.</p>',1,'2019-09-17 00:07:48','2019-09-17 00:07:48'),(28,'Qui at ipsum efficiendi, nec nullam deseruisse reformidans eu. Vim erant dolorem ut, nec ut vide ludus.','<p>Ut praesent salutandi est, eu mazim lobortis vel, ad eos errem nonumy luptatum. No duo ludus labitur volutpat. Ei eum dicant delicata, noster copiosae ei vim. No sea augue definiebas, et periculis temporibus vix. Saepe quidam percipitur ei vim, per conceptam neglegentur id. Has eu ridens appetere deseruisse, essent luptatum eu per. Mea viris invenire no, vel et meliore epicuri vulputate, at viderer lobortis vulputate sea.</p>',1,'2019-09-17 00:08:08','2019-09-17 00:08:08'),(29,'Mea id consul contentiones, in essent minimum adolescens vim. Ea eam stet iusto, sea an quaeque utroque percipitur, ea debet vocent mei. Sit audiam legimus deseruisse ea, ne mea appetere aliquando.','<p><br />\r\nUt praesent salutandi est, eu mazim lobortis vel, ad eos errem nonumy luptatum. No duo ludus labitur volutpat. Ei eum dicant delicata, noster copiosae ei vim. No sea augue definiebas, et periculis temporibus vix. Saepe quidam percipitur ei vim, per conceptam neglegentur id. Has eu ridens appetere deseruisse, essent luptatum eu per. Mea viris invenire no, vel et meliore epicuri vulputate, at viderer lobortis vulputate sea.</p>',1,'2019-09-17 00:08:36','2019-09-17 00:08:36'),(30,'sdfsdf','<p>sdfsdf</p>',1,'2019-10-03 01:27:54','2019-10-03 01:27:54');

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` VALUES ('01a28ffaebcf029660f84885b64ef83667c9807cbb27e121de093367b8bc036e609debe039ac05b0',2,1,'Maxminpower','[]',0,'2019-09-30 08:57:42','2019-09-30 08:57:42','2020-09-30 14:27:42'),('12f73060ad57ca2381669f43e94388c4aa9ef02aa84929423c1dd133512d6d471af45016a0a90c38',29,1,'Maxminpower','[]',0,'2019-10-01 01:03:59','2019-10-01 01:03:59','2020-10-01 06:33:59'),('1e29e6e57370f47868a103025ba66c8d0f613b494ad48101a8dfacb057441345f7a359a2c9cadf55',2,1,'Maxminpower','[]',0,'2019-12-09 01:01:48','2019-12-09 01:01:48','2020-12-09 06:31:48'),('1f407ad514d93724c99f63c9e3a8d1bac0c3923041a36698baf725441d026db3bac023d92eced550',29,1,'Maxminpower','[]',0,'2019-10-01 01:10:52','2019-10-01 01:10:52','2020-10-01 06:40:52'),('2059a209306282437b31f6491e5b01aa931de7447a0b27f623028dbc6a54f2a6728a62905871cf97',2,1,'Maxminpower','[]',0,'2019-12-06 01:10:07','2019-12-06 01:10:07','2020-12-06 06:40:07'),('27d901c11edbe58569b92fbf9a865109d5e253dc1a4f08046979ea01eb3b664be09aa47a0fa27a55',29,1,'Maxminpower','[]',0,'2019-10-01 01:02:17','2019-10-01 01:02:17','2020-10-01 06:32:17'),('301993d337e3e35190f33862da52d01f0a9f8fda0b90b7c2d23bccb3aca1116b6250568403002b3b',2,1,'Maxminpower','[]',0,'2019-12-05 23:52:04','2019-12-05 23:52:04','2020-12-06 05:22:04'),('3300652b7c738a6057cb0b4068d290ee9e9d965a8a19aae725955aae964c0e30a951488299ecea58',29,1,'Maxminpower','[]',0,'2019-10-01 01:01:22','2019-10-01 01:01:22','2020-10-01 06:31:22'),('3c76a10f2babff31810fd946bf5fad7ff969ba14a3b3939213186b329bbe0e347c1a93ed4aad1f73',2,1,'Maxminpower','[]',0,'2019-10-01 04:25:17','2019-10-01 04:25:17','2020-10-01 09:55:17'),('3ffd941db0d04cd410c29db9c414c4cf69409a89a0159a23b96dd9752f3384f8f1751d14c5fd348b',2,1,'Maxminpower','[]',0,'2019-12-06 01:13:45','2019-12-06 01:13:45','2020-12-06 06:43:45'),('41075ea153796fc761f4072ea05b556bf01a945d5fe7bb115aa31c1f3a8a136f1e0d0cbf43dedd28',29,1,'Maxminpower','[]',0,'2019-10-01 01:00:22','2019-10-01 01:00:22','2020-10-01 06:30:22'),('4ad460d7cec1457a263011503d8db8803f7ad52a9d9da8ad8d82018ad514e0d05c9c6153276c56d3',2,1,'Maxminpower','[]',0,'2019-12-05 23:57:33','2019-12-05 23:57:33','2020-12-06 05:27:33'),('62b15f9be81d284318125cf3cf5a884fde85f604e25cbd0567e40a2c0c0f74c1cda0c4511753609e',29,1,'Maxminpower','[]',0,'2019-10-01 01:03:42','2019-10-01 01:03:42','2020-10-01 06:33:42'),('7c16e3161a848ab87322bf721e2534c2b98d6daba26e6c4059a2e55556f6b74ea6e8d6ef87110acb',49,1,'Maxminpower','[]',0,'2020-03-23 00:18:39','2020-03-23 00:18:39','2021-03-23 05:48:39'),('7cd764213384abd0d05e92eb0fa027f64e18609ce25c7543aec0db743ec0a641fae812ffb5e92739',29,1,'Maxminpower','[]',0,'2019-10-01 01:05:43','2019-10-01 01:05:43','2020-10-01 06:35:43'),('7df8c5289a0ce353739ee002457dbbe0665158d86540450028ca48557caf6a2dce2742c49d2ce451',2,1,'Maxminpower','[]',0,'2019-12-06 00:15:43','2019-12-06 00:15:43','2020-12-06 05:45:43'),('7e0bc88a4548b7fba23abe581bff5d0e6dc26d7b6878b38adfc096a138866a05ff9e262e335612b8',2,1,'Maxminpower','[]',0,'2019-12-09 00:54:59','2019-12-09 00:54:59','2020-12-09 06:24:59'),('81f23e4c0b36afd65f9cdcdaf263563444f23225a90fd262c787b5a08df287f698d39b5dbfe3d1f2',2,1,'Maxminpower','[]',0,'2019-12-06 00:41:35','2019-12-06 00:41:35','2020-12-06 06:11:35'),('927585d1e97719916d50d6edaad0e65c3af8dd613b5f29b503bb8311db6802f8481b514332d0c56b',49,1,'Maxminpower','[]',0,'2020-04-06 05:23:02','2020-04-06 05:23:02','2021-04-06 10:53:02'),('9e6851710f35324d29c197879b98a1e157499807842233a283ff01e617cef74ba27ea39306c5b412',29,1,'Maxminpower','[]',0,'2019-10-01 01:00:46','2019-10-01 01:00:46','2020-10-01 06:30:46'),('ab0af5b584a8de827b527a0ea05fb2f719b90f53bff7243eb329079fabbcdc4056466630dbb330f3',29,1,'Maxminpower','[]',0,'2019-10-01 01:10:47','2019-10-01 01:10:47','2020-10-01 06:40:47'),('bbdcf07e7c25d87f2b074492a83e9d3f2d66f9228dea5fd0f91d38700d86c440894178684793e921',2,1,'Maxminpower','[]',0,'2019-12-06 00:45:39','2019-12-06 00:45:39','2020-12-06 06:15:39'),('d83d893345e9608b5b2b0c3a4a4a56d9502897dbf65c2c8daa78c188e874cdca273776bbeaa3490c',49,1,'Maxminpower','[]',0,'2020-03-23 00:24:04','2020-03-23 00:24:04','2021-03-23 05:54:04'),('dc8ff78f7de17e248d9020ac6289552addf400ae76a078973b42f946d8ebb746b67f90a25c1e2bc6',29,1,'Maxminpower','[]',0,'2019-10-01 01:03:54','2019-10-01 01:03:54','2020-10-01 06:33:54'),('df754d428a4fcb263dc194f193033f1f034a34f7a88227dfebf92c97e01cc45886e34f8f6b4da5f5',2,1,'Maxminpower','[]',0,'2019-12-06 00:14:16','2019-12-06 00:14:16','2020-12-06 05:44:16'),('edd885b562c132b898c7a29fa39f6100a825abf8eb88ccc5bcd87768e4549fd716b8694764cc5374',2,1,'Maxminpower','[]',0,'2019-12-06 00:24:50','2019-12-06 00:24:50','2020-12-06 05:54:50'),('f4c23383d5eed962518421e32b102378b98bf0b13b082b4a8990ee4fc8cf9c5e731f553633ece528',49,1,'Maxminpower','[]',0,'2020-03-23 00:10:40','2020-03-23 00:10:40','2021-03-23 05:40:40'),('fd8c8e0a3c2c6c7568bc57950dedf5c2e4e2e8222834a8ece42de6935844fd74518cfc1c7f1aecce',2,1,'Maxminpower','[]',0,'2019-12-06 00:02:18','2019-12-06 00:02:18','2020-12-06 05:32:18');

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `client_id` int(10) unsigned NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2019-09-27 08:32:09','2019-09-27 08:32:09');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_title` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `banner` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keyword` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1=active, 0=in active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pages_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (6,'Monthly','Monthly','monthly-2','Monthly','<p>Monthly</p>',NULL,'Monthly','Monthly','Monthly',0,'2019-09-03 04:48:41','2019-09-03 04:48:41'),(7,'Frequently Answer Question','faq','faq','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>',NULL,'faq','faq','faq',1,'2019-09-16 09:08:59','2019-10-03 01:48:42'),(8,'Terms and Conditions','Terms and Conditions','terms-conditions','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.','<p>Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.</p>',NULL,'Terms and Conditions','Terms and Conditions','Terms and Conditions',1,'2019-09-16 23:30:36','2019-10-03 01:48:28'),(9,'test test','test','test','test','<p>test</p>',NULL,'test','test','test',0,'2019-09-17 01:52:34','2019-09-17 01:52:34'),(10,'test test','test test','test-test','test test','<p>test test</p>',NULL,'test test','test test','test test',0,'2019-09-17 01:53:26','2019-09-17 01:53:26'),(11,'Contact Us','Contact Us','contact-us','Contact Us','<p>Contact Us</p>',NULL,'Contact Us','Contact Us','Contact Us',1,'2019-09-17 01:54:17','2019-09-17 01:54:17'),(12,'About Us','About Us','about-us','About Us','<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n\r\n<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n</div>\r\n\r\n<div>\r\n<h2>Why do we use it?</h2>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n</div>\r\n\r\n<p>&nbsp;</p>',NULL,'About Us','About Us','About Us',1,'2019-09-17 23:31:58','2019-10-03 01:11:35');

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `manager` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--



--
-- Dumping routines for database 'culturalawareness'
--


