-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `confide`
--

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` int(11) NOT NULL,
  `countrycode` char(3) NOT NULL,
  `countryname` varchar(200) NOT NULL,
  `code` char(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `countrycode`, `countryname`, `code`) VALUES
(1, 'AFG', 'Afghanistan', 'AF'),
(2, 'ALA', 'Åland', 'AX'),
(3, 'ALB', 'Albania', 'AL'),
(4, 'DZA', 'Algeria', 'DZ'),
(5, 'ASM', 'American Samoa', 'AS'),
(6, 'AND', 'Andorra', 'AD'),
(7, 'AGO', 'Angola', 'AO'),
(8, 'AIA', 'Anguilla', 'AI'),
(9, 'ATA', 'Antarctica', 'AQ'),
(10, 'ATG', 'Antigua and Barbuda', 'AG'),
(11, 'ARG', 'Argentina', 'AR'),
(12, 'ARM', 'Armenia', 'AM'),
(13, 'ABW', 'Aruba', 'AW'),
(14, 'AUS', 'Australia', 'AU'),
(15, 'AUT', 'Austria', 'AT'),
(16, 'AZE', 'Azerbaijan', 'AZ'),
(17, 'BHS', 'Bahamas', 'BS'),
(18, 'BHR', 'Bahrain', 'BH'),
(19, 'BGD', 'Bangladesh', 'BD'),
(20, 'BRB', 'Barbados', 'BB'),
(21, 'BLR', 'Belarus', 'BY'),
(22, 'BEL', 'Belgium', 'BE'),
(23, 'BLZ', 'Belize', 'BZ'),
(24, 'BEN', 'Benin', 'BJ'),
(25, 'BMU', 'Bermuda', 'BM'),
(26, 'BTN', 'Bhutan', 'BT'),
(27, 'BOL', 'Bolivia', 'BO'),
(28, 'BES', 'Bonaire', 'BQ'),
(29, 'BIH', 'Bosnia and Herzegovina', 'BA'),
(30, 'BWA', 'Botswana', 'BW'),
(31, 'BVT', 'Bouvet Island', 'BV'),
(32, 'BRA', 'Brazil', 'BR'),
(33, 'IOT', 'British Indian Ocean Territory', 'IO'),
(34, 'VGB', 'British Virgin Islands', 'VG'),
(35, 'BRN', 'Brunei', 'BN'),
(36, 'BGR', 'Bulgaria', 'BG'),
(37, 'BFA', 'Burkina Faso', 'BF'),
(38, 'BDI', 'Burundi', 'BI'),
(39, 'KHM', 'Cambodia', 'KH'),
(40, 'CMR', 'Cameroon', 'CM'),
(41, 'CAN', 'Canada', 'CA'),
(42, 'CPV', 'Cape Verde', 'CV'),
(43, 'CYM', 'Cayman Islands', 'KY'),
(44, 'CAF', 'Central African Republic', 'CF'),
(45, 'TCD', 'Chad', 'TD'),
(46, 'CHL', 'Chile', 'CL'),
(47, 'CHN', 'China', 'CN'),
(48, 'CXR', 'Christmas Island', 'CX'),
(49, 'CCK', 'Cocos [Keeling] Islands', 'CC'),
(50, 'COL', 'Colombia', 'CO'),
(51, 'COM', 'Comoros', 'KM'),
(52, 'COK', 'Cook Islands', 'CK'),
(53, 'CRI', 'Costa Rica', 'CR'),
(54, 'HRV', 'Croatia', 'HR'),
(55, 'CUB', 'Cuba', 'CU'),
(56, 'CUW', 'Curacao', 'CW'),
(57, 'CYP', 'Cyprus', 'CY'),
(58, 'CZE', 'Czech Republic', 'CZ'),
(59, 'COD', 'Democratic Republic of the Congo', 'CD'),
(60, 'DNK', 'Denmark', 'DK'),
(61, 'DJI', 'Djibouti', 'DJ'),
(62, 'DMA', 'Dominica', 'DM'),
(63, 'DOM', 'Dominican Republic', 'DO'),
(64, 'TLS', 'East Timor', 'TL'),
(65, 'ECU', 'Ecuador', 'EC'),
(66, 'EGY', 'Egypt', 'EG'),
(67, 'SLV', 'El Salvador', 'SV'),
(68, 'GNQ', 'Equatorial Guinea', 'GQ'),
(69, 'ERI', 'Eritrea', 'ER'),
(70, 'EST', 'Estonia', 'EE'),
(71, 'ETH', 'Ethiopia', 'ET'),
(72, 'FLK', 'Falkland Islands', 'FK'),
(73, 'FRO', 'Faroe Islands', 'FO'),
(74, 'FJI', 'Fiji', 'FJ'),
(75, 'FIN', 'Finland', 'FI'),
(76, 'FRA', 'France', 'FR'),
(77, 'GUF', 'French Guiana', 'GF'),
(78, 'PYF', 'French Polynesia', 'PF'),
(79, 'ATF', 'French Southern Territories', 'TF'),
(80, 'GAB', 'Gabon', 'GA'),
(81, 'GMB', 'Gambia', 'GM'),
(82, 'GEO', 'Georgia', 'GE'),
(83, 'DEU', 'Germany', 'DE'),
(84, 'GHA', 'Ghana', 'GH'),
(85, 'GIB', 'Gibraltar', 'GI'),
(86, 'GRC', 'Greece', 'GR'),
(87, 'GRL', 'Greenland', 'GL'),
(88, 'GRD', 'Grenada', 'GD'),
(89, 'GLP', 'Guadeloupe', 'GP'),
(90, 'GUM', 'Guam', 'GU'),
(91, 'GTM', 'Guatemala', 'GT'),
(92, 'GGY', 'Guernsey', 'GG'),
(93, 'GIN', 'Guinea', 'GN'),
(94, 'GNB', 'Guinea-Bissau', 'GW'),
(95, 'GUY', 'Guyana', 'GY'),
(96, 'HTI', 'Haiti', 'HT'),
(97, 'HMD', 'Heard Island and McDonald Islands', 'HM'),
(98, 'HND', 'Honduras', 'HN'),
(99, 'HKG', 'Hong Kong', 'HK'),
(100, 'HUN', 'Hungary', 'HU'),
(101, 'ISL', 'Iceland', 'IS'),
(102, 'IND', 'India', 'IN'),
(103, 'IDN', 'Indonesia', 'ID'),
(104, 'IRN', 'Iran', 'IR'),
(105, 'IRQ', 'Iraq', 'IQ'),
(106, 'IRL', 'Ireland', 'IE'),
(107, 'IMN', 'Isle of Man', 'IM'),
(108, 'ISR', 'Israel', 'IL'),
(109, 'ITA', 'Italy', 'IT'),
(110, 'CIV', 'Ivory Coast', 'CI'),
(111, 'JAM', 'Jamaica', 'JM'),
(112, 'JPN', 'Japan', 'JP'),
(113, 'JEY', 'Jersey', 'JE'),
(114, 'JOR', 'Jordan', 'JO'),
(115, 'KAZ', 'Kazakhstan', 'KZ'),
(116, 'KEN', 'Kenya', 'KE'),
(117, 'KIR', 'Kiribati', 'KI'),
(118, 'XKX', 'Kosovo', 'XK'),
(119, 'KWT', 'Kuwait', 'KW'),
(120, 'KGZ', 'Kyrgyzstan', 'KG'),
(121, 'LAO', 'Laos', 'LA'),
(122, 'LVA', 'Latvia', 'LV'),
(123, 'LBN', 'Lebanon', 'LB'),
(124, 'LSO', 'Lesotho', 'LS'),
(125, 'LBR', 'Liberia', 'LR'),
(126, 'LBY', 'Libya', 'LY'),
(127, 'LIE', 'Liechtenstein', 'LI'),
(128, 'LTU', 'Lithuania', 'LT'),
(129, 'LUX', 'Luxembourg', 'LU'),
(130, 'MAC', 'Macao', 'MO'),
(131, 'MKD', 'Macedonia', 'MK'),
(132, 'MDG', 'Madagascar', 'MG'),
(133, 'MWI', 'Malawi', 'MW'),
(134, 'MYS', 'Malaysia', 'MY'),
(135, 'MDV', 'Maldives', 'MV'),
(136, 'MLI', 'Mali', 'ML'),
(137, 'MLT', 'Malta', 'MT'),
(138, 'MHL', 'Marshall Islands', 'MH'),
(139, 'MTQ', 'Martinique', 'MQ'),
(140, 'MRT', 'Mauritania', 'MR'),
(141, 'MUS', 'Mauritius', 'MU'),
(142, 'MYT', 'Mayotte', 'YT'),
(143, 'MEX', 'Mexico', 'MX'),
(144, 'FSM', 'Micronesia', 'FM'),
(145, 'MDA', 'Moldova', 'MD'),
(146, 'MCO', 'Monaco', 'MC'),
(147, 'MNG', 'Mongolia', 'MN'),
(148, 'MNE', 'Montenegro', 'ME'),
(149, 'MSR', 'Montserrat', 'MS'),
(150, 'MAR', 'Morocco', 'MA'),
(151, 'MOZ', 'Mozambique', 'MZ'),
(152, 'MMR', 'Myanmar [Burma]', 'MM'),
(153, 'NAM', 'Namibia', 'NA'),
(154, 'NRU', 'Nauru', 'NR'),
(155, 'NPL', 'Nepal', 'NP'),
(156, 'NLD', 'Netherlands', 'NL'),
(157, 'NCL', 'New Caledonia', 'NC'),
(158, 'NZL', 'New Zealand', 'NZ'),
(159, 'NIC', 'Nicaragua', 'NI'),
(160, 'NER', 'Niger', 'NE'),
(161, 'NGA', 'Nigeria', 'NG'),
(162, 'NIU', 'Niue', 'NU'),
(163, 'NFK', 'Norfolk Island', 'NF'),
(164, 'PRK', 'North Korea', 'KP'),
(165, 'MNP', 'Northern Mariana Islands', 'MP'),
(166, 'NOR', 'Norway', 'NO'),
(167, 'OMN', 'Oman', 'OM'),
(168, 'PAK', 'Pakistan', 'PK'),
(169, 'PLW', 'Palau', 'PW'),
(170, 'PSE', 'Palestine', 'PS'),
(171, 'PAN', 'Panama', 'PA'),
(172, 'PNG', 'Papua New Guinea', 'PG'),
(173, 'PRY', 'Paraguay', 'PY'),
(174, 'PER', 'Peru', 'PE'),
(175, 'PHL', 'Philippines', 'PH'),
(176, 'PCN', 'Pitcairn Islands', 'PN'),
(177, 'POL', 'Poland', 'PL'),
(178, 'PRT', 'Portugal', 'PT'),
(179, 'PRI', 'Puerto Rico', 'PR'),
(180, 'QAT', 'Qatar', 'QA'),
(181, 'COG', 'Republic of the Congo', 'CG'),
(182, 'REU', 'Réunion', 'RE'),
(183, 'ROU', 'Romania', 'RO'),
(184, 'RUS', 'Russia', 'RU'),
(185, 'RWA', 'Rwanda', 'RW'),
(186, 'BLM', 'Saint Barthélemy', 'BL'),
(187, 'SHN', 'Saint Helena', 'SH'),
(188, 'KNA', 'Saint Kitts and Nevis', 'KN'),
(189, 'LCA', 'Saint Lucia', 'LC'),
(190, 'MAF', 'Saint Martin', 'MF'),
(191, 'SPM', 'Saint Pierre and Miquelon', 'PM'),
(192, 'VCT', 'Saint Vincent and the Grenadines', 'VC'),
(193, 'WSM', 'Samoa', 'WS'),
(194, 'SMR', 'San Marino', 'SM'),
(195, 'STP', 'São Tomé and Príncipe', 'ST'),
(196, 'SAU', 'Saudi Arabia', 'SA'),
(197, 'SEN', 'Senegal', 'SN'),
(198, 'SRB', 'Serbia', 'RS'),
(199, 'SYC', 'Seychelles', 'SC'),
(200, 'SLE', 'Sierra Leone', 'SL'),
(201, 'SGP', 'Singapore', 'SG'),
(202, 'SXM', 'Sint Maarten', 'SX'),
(203, 'SVK', 'Slovakia', 'SK'),
(204, 'SVN', 'Slovenia', 'SI'),
(205, 'SLB', 'Solomon Islands', 'SB'),
(206, 'SOM', 'Somalia', 'SO'),
(207, 'ZAF', 'South Africa', 'ZA'),
(208, 'SGS', 'South Georgia and the South Sandwich Islands', 'GS'),
(209, 'KOR', 'South Korea', 'KR'),
(210, 'SSD', 'South Sudan', 'SS'),
(211, 'ESP', 'Spain', 'ES'),
(212, 'LKA', 'Sri Lanka', 'LK'),
(213, 'SDN', 'Sudan', 'SD'),
(214, 'SUR', 'Suriname', 'SR'),
(215, 'SJM', 'Svalbard and Jan Mayen', 'SJ'),
(216, 'SWZ', 'Swaziland', 'SZ'),
(217, 'SWE', 'Sweden', 'SE'),
(218, 'CHE', 'Switzerland', 'CH'),
(219, 'SYR', 'Syria', 'SY'),
(220, 'TWN', 'Taiwan', 'TW'),
(221, 'TJK', 'Tajikistan', 'TJ'),
(222, 'TZA', 'Tanzania', 'TZ'),
(223, 'THA', 'Thailand', 'TH'),
(224, 'TGO', 'Togo', 'TG'),
(225, 'TKL', 'Tokelau', 'TK'),
(226, 'TON', 'Tonga', 'TO'),
(227, 'TTO', 'Trinidad and Tobago', 'TT'),
(228, 'TUN', 'Tunisia', 'TN'),
(229, 'TUR', 'Turkey', 'TR'),
(230, 'TKM', 'Turkmenistan', 'TM'),
(231, 'TCA', 'Turks and Caicos Islands', 'TC'),
(232, 'TUV', 'Tuvalu', 'TV'),
(233, 'UMI', 'U.S. Minor Outlying Islands', 'UM'),
(234, 'VIR', 'U.S. Virgin Islands', 'VI'),
(235, 'UGA', 'Uganda', 'UG'),
(236, 'UKR', 'Ukraine', 'UA'),
(237, 'ARE', 'United Arab Emirates', 'AE'),
(238, 'GBR', 'United Kingdom', 'GB'),
(239, 'USA', 'United States', 'US'),
(240, 'URY', 'Uruguay', 'UY'),
(241, 'UZB', 'Uzbekistan', 'UZ'),
(242, 'VUT', 'Vanuatu', 'VU'),
(243, 'VAT', 'Vatican City', 'VA'),
(244, 'VEN', 'Venezuela', 'VE'),
(245, 'VNM', 'Vietnam', 'VN'),
(246, 'WLF', 'Wallis and Futuna', 'WF'),
(247, 'ESH', 'Western Sahara', 'EH'),
(248, 'YEM', 'Yemen', 'YE'),
(249, 'ZMB', 'Zambia', 'ZM'),
(250, 'ZWE', 'Zimbabwe', 'ZW');

-- --------------------------------------------------------

--
-- Table structure for table `interests`
--

CREATE TABLE `interests` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interests`
--

INSERT INTO `interests` (`id`, `name`) VALUES
(1, 'Hobbies'),
(2, 'Sports'),
(3, 'Technology'),
(4, 'Music'),
(5, 'Movies and TV Shows'),
(6, 'Food and Cooking'),
(7, 'Fitness'),
(8, 'Books and Literature'),
(9, 'Art and Design'),
(10, 'Science and Nature'),
(11, 'Career and Business'),
(12, 'Gaming'),
(13, 'Parenting'),
(14, 'Volunteering and Causes'),
(15, 'Learning and Education'),
(16, 'Travel'),
(17, 'Fashion and Beauty'),
(18, 'Photography'),
(19, 'Relationships'),
(20, 'Spirituality and Mindfulness');

-- --------------------------------------------------------

--
-- Table structure for table `interests_cat`
--

CREATE TABLE `interests_cat` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interests_cat`
--

INSERT INTO `interests_cat` (`id`, `name`, `image`) VALUES
(1, 'Health', ''),
(2, 'Family', ''),
(3, 'Life Experience', ''),
(4, 'Relationship', ''),
(5, 'LGBTQ', ''),
(6, 'Secrets', ''),
(7, 'Sex', ''),
(8, 'Depression', ''),
(9, 'Emotional Support', '');

-- --------------------------------------------------------

--
-- Table structure for table `interests_sub_cat`
--

CREATE TABLE `interests_sub_cat` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interests_sub_cat`
--

INSERT INTO `interests_sub_cat` (`id`, `cat_id`, `name`, `image`) VALUES
(1, 1, 'Addction', ''),
(2, 1, 'Disability', ''),
(3, 1, 'Diabetes', ''),
(4, 1, 'Cancer', ''),
(5, 1, 'Autism', ''),
(6, 1, 'Skin Problems', ''),
(7, 1, 'Obesity', ''),
(8, 1, 'Arthritis', ''),
(9, 1, 'Down Syndrome', ''),
(10, 1, 'Dementia', ''),
(11, 1, 'Multiple Sclerosis', ''),
(12, 1, 'Kidney', ''),
(13, 1, 'Liver', ''),
(14, 1, 'HIV/Aids', ''),
(15, 1, 'Heart Attack', ''),
(16, 1, 'Cerebral Palsy', ''),
(17, 1, 'Infertility', ''),
(18, 1, 'Epilepsy', ''),
(19, 1, 'Deafness', ''),
(20, 1, 'Blindness', ''),
(21, 2, 'Child Birth', ''),
(22, 3, 'Financial Problems', ''),
(23, 3, 'Unemployment', ''),
(24, 4, 'Marital Problems', ''),
(25, 4, 'Relationships', ''),
(26, 5, 'Lesbian ', ''),
(27, 5, 'Gay', ''),
(28, 5, 'Bisexual', ''),
(29, 5, 'Transgender', ''),
(30, 5, 'Queer', ''),
(31, 6, 'Secrets', ''),
(32, 7, 'Sex Life', ''),
(33, 8, 'Depression', ''),
(34, 9, 'Emotional Challenges', ''),
(35, 9, 'Anxiety', '');

-- --------------------------------------------------------

--
-- Table structure for table `logging`
--

CREATE TABLE `logging` (
  `id` int(11) NOT NULL,
  `dt` datetime NOT NULL,
  `ip` varchar(255) NOT NULL,
  `referer` varchar(255) NOT NULL,
  `issues` text NOT NULL,
  `epost` varchar(255) NOT NULL,
  `ppost` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `url` varchar(100) NOT NULL,
  `initiator` varchar(100) NOT NULL,
  `app` varchar(255) NOT NULL,
  `note` varchar(255) NOT NULL,
  `did_read` enum('0','1') NOT NULL DEFAULT '0',
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `title` varchar(300) NOT NULL,
  `post` text NOT NULL,
  `experience` int(2) NOT NULL,
  `post_likes` int(11) NOT NULL,
  `post_comments` int(11) NOT NULL,
  `post_views` int(11) NOT NULL,
  `edited` enum('0','1') NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `last_updated` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `post_comments`
--

CREATE TABLE `post_comments` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `comment` text NOT NULL,
  `edited` enum('0','1') NOT NULL DEFAULT '0',
  `comment_likes` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `last_updated` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `post_comment_likes`
--

CREATE TABLE `post_comment_likes` (
  `id` int(11) NOT NULL,
  `comment_id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `post_likes`
--

CREATE TABLE `post_likes` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `post_media`
--

CREATE TABLE `post_media` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `file` varchar(200) NOT NULL,
  `folder` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `post_tags`
--

CREATE TABLE `post_tags` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `interest_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `post_tags`
--

INSERT INTO `post_tags` (`id`, `post_id`, `interest_id`) VALUES
(1, 1, 1),
(3, 1, 3);

-- --------------------------------------------------------

--
-- Table structure for table `post_views`
--

CREATE TABLE `post_views` (
  `id` int(11) NOT NULL,
  `post_id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `status_dislikes`
--

CREATE TABLE `status_dislikes` (
  `id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  `creator` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `status_share`
--

CREATE TABLE `status_share` (
  `id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  `creator` varchar(100) NOT NULL,
  `owner` varchar(100) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `temp_uploads`
--

CREATE TABLE `temp_uploads` (
  `id` int(11) NOT NULL,
  `uid` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL,
  `location` enum('1','2') DEFAULT '1',
  `size` int(11) DEFAULT NULL,
  `ext` varchar(15) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `users_interests`
--

CREATE TABLE `users_interests` (
  `id` int(11) NOT NULL,
  `uniq_id` varchar(100) NOT NULL,
  `interest_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users_interests`
--

INSERT INTO `users_interests` (`id`, `uniq_id`, `interest_id`) VALUES
(1, 'YOUB5O68092', 1),
(2, 'YOUB5O68092', 2),
(3, 'YOUB5O68092', 4);

-- --------------------------------------------------------

--
-- Table structure for table `users_profile`
--

CREATE TABLE `users_profile` (
  `id` int(11) NOT NULL,
  `uniq_id` varchar(50) NOT NULL,
  `dob` varchar(15) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `interests` varchar(100) NOT NULL,
  `country` varchar(50) NOT NULL,
  `city` varchar(100) NOT NULL,
  `bio` text NOT NULL,
  `signup_device` varchar(30) NOT NULL,
  `signup_browser` varchar(30) NOT NULL,
  `current_device` varchar(30) NOT NULL,
  `current_browser` varchar(30) NOT NULL,
  `channel` int(11) NOT NULL,
  `current_ip` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users_profile`
--

INSERT INTO `users_profile` (`id`, `uniq_id`, `dob`, `mobile`, `interests`, `country`, `city`, `bio`, `signup_device`, `signup_browser`, `current_device`, `current_browser`, `channel`, `current_ip`) VALUES
(6, 'YOUB5O68092', '', '+2345', '1, 2, 4', '1', 'City Name', 'Love', 'iphone 14', 'chrome', 'iphone 14', 'chrome', 0, ''),
(7, '46W3GXE5JNR', '', '', '', '0', '0', '', 'iphone 14', 'chrome', '', '', 0, '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `country`
--
ALTER TABLE `country`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `interests`
--
ALTER TABLE `interests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `interests_cat`
--
ALTER TABLE `interests_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `interests_sub_cat`
--
ALTER TABLE `interests_sub_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `logging`
--
ALTER TABLE `logging`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_comments`
--
ALTER TABLE `post_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_comment_likes`
--
ALTER TABLE `post_comment_likes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_likes`
--
ALTER TABLE `post_likes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_media`
--
ALTER TABLE `post_media`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_tags`
--
ALTER TABLE `post_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `post_views`
--
ALTER TABLE `post_views`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `status_dislikes`
--
ALTER TABLE `status_dislikes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `status_share`
--
ALTER TABLE `status_share`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `temp_uploads`
--
ALTER TABLE `temp_uploads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_interests`
--
ALTER TABLE `users_interests`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_profile`
--
ALTER TABLE `users_profile`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `country`
--
ALTER TABLE `country`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- AUTO_INCREMENT for table `interests`
--
ALTER TABLE `interests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `interests_cat`
--
ALTER TABLE `interests_cat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `interests_sub_cat`
--
ALTER TABLE `interests_sub_cat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `logging`
--
ALTER TABLE `logging`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post_comments`
--
ALTER TABLE `post_comments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `post_comment_likes`
--
ALTER TABLE `post_comment_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `post_likes`
--
ALTER TABLE `post_likes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `post_media`
--
ALTER TABLE `post_media`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post_tags`
--
ALTER TABLE `post_tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `post_views`
--
ALTER TABLE `post_views`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `status_dislikes`
--
ALTER TABLE `status_dislikes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `status_share`
--
ALTER TABLE `status_share`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `temp_uploads`
--
ALTER TABLE `temp_uploads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users_interests`
--
ALTER TABLE `users_interests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

