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

--
-- Table structure for table `tbl_active_log`
--

CREATE TABLE `tbl_active_log` (
  `id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `date_time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_admin`
--

CREATE TABLE `tbl_admin` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `address` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_admin`
--

INSERT INTO `tbl_admin` (`id`, `username`, `password`, `email`, `address`, `image`) VALUES
(1, 'admin', 'admin', 'viaviwebtech@gmail.com', 'rajkot', 'profile.png');

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `cid` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_image` varchar(255) NOT NULL,
  `category_image_icon` varchar(255) NOT NULL,
  `status` int(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`cid`, `category_name`, `category_image`, `category_image_icon`, `status`) VALUES
(1, 'Appetizer', '42379_78439_Appetizer.jpg', '79655_ic_9.png', 1),
(2, 'Desserts', '49420_64123_dessert-minis.jpg', '53563_ic_6.png', 1),
(3, 'Breakfast', '55456_36373_Breakfast.jpg', '72888_ic_3.png', 1),
(4, 'Healthy', '53537_32058_Healthy.jpg', '90322_ic_5.png', 1),
(5, 'Salad', '12482_14682_salad.jpg', '27961_ic_1.png', 1);

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

--
-- Table structure for table `tbl_favourite`
--

CREATE TABLE `tbl_favourite` (
  `id` int(10) NOT NULL,
  `post_id` int(10) NOT NULL,
  `user_id` int(10) NOT NULL,
  `created_at` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_favourite`
--

INSERT INTO `tbl_favourite` (`id`, `post_id`, `user_id`, `created_at`) VALUES
(2, 2, 1, '1628077030'),
(3, 8, 1, '1628077042'),
(5, 5, 1, '1628136860'),
(12, 7, 5, '1628488910'),
(16, 24, 5, '1628490168'),
(17, 8, 5, '1628510031'),
(18, 5, 11, '1662465692'),
(19, 2, 11, '1662465715'),
(20, 8, 11, '1662465748'),
(21, 7, 11, '1662465757'),
(22, 24, 11, '1662465787');

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

--
-- Table structure for table `tbl_rating`
--

CREATE TABLE `tbl_rating` (
  `id` int(11) NOT NULL,
  `recipe_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ip` varchar(255) NOT NULL,
  `rate` int(11) NOT NULL,
  `dt_rate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `message` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_rating`
--

INSERT INTO `tbl_rating` (`id`, `recipe_id`, `user_id`, `ip`, `rate`, `dt_rate`, `message`) VALUES
(27, 2, 2, '111', 2, '2022-09-06 21:51:06', 'My rate');

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

--
-- Table structure for table `tbl_recipe`
--

CREATE TABLE `tbl_recipe` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT 0,
  `sub_cat_id` int(255) NOT NULL,
  `recipe_type` varchar(255) NOT NULL,
  `recipe_name` varchar(255) NOT NULL,
  `recipe_time` varchar(255) NOT NULL,
  `recipe_ingredients` text NOT NULL,
  `recipe_direction` text NOT NULL,
  `recipe_image` varchar(255) NOT NULL,
  `video_url` varchar(255) NOT NULL,
  `video_id` varchar(255) NOT NULL,
  `recipe_views` int(11) NOT NULL DEFAULT 0,
  `total_rate` int(11) NOT NULL DEFAULT 0,
  `rate_avg` float(11,1) NOT NULL DEFAULT 0.0,
  `featured_recipe` int(1) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_recipe`
--

INSERT INTO `tbl_recipe` (`id`, `cat_id`, `user_id`, `sub_cat_id`, `recipe_type`, `recipe_name`, `recipe_time`, `recipe_ingredients`, `recipe_direction`, `recipe_image`, `video_url`, `video_id`, `recipe_views`, `total_rate`, `rate_avg`, `featured_recipe`, `status`) VALUES
(2, 1, 2, 4, 'image', 'Goat Cheese Trio', '5min', '<p>Cut a 12-ounce log of goat, cheese crosswise into 3 mini logs.</p>\r\n', '<p>Roll 1 piece in chopped mixed herbs, another in cracked mixed peppercorns and the last in chopped dried cranberries and cashews. Serve with baguette slices or crackers.</p>\r\n', '8325_Appetizers-Cannellini-Bruschetta.jpeg', '', '', 38, 1, 2.0, 1, 1),
(5, 5, 0, 10, 'video', 'Lettuce, Tomato and Cucumber Salad with Basil Dressing', '10 Mins', '<p>2 cups iceberg lettuce leaves , torn into small pieces 1 cup ,roughly chopped tomatoes 1 cup roughly chopped ,cucumber 1/2 cup quartered and blanched mushrooms (khumbh) ,1/2 cup capsicum cubes</p>\r\n', '<ul>\r\n  <li>Combine all the ingredients along with the dressing in a bowl and toss well.</li>\r\n <li>Serve immediately.</li>\r\n</ul>\r\n', '68344_03recipehealth.jpg', 'https://www.youtube.com/watch?v=oZJeYLoptzc', 'oZJeYLoptzc', 176, 4, 5.0, 1, 1),
(7, 4, 0, 6, 'image', 'Lemon and Coriander Soup', '15 Mins', '<ul>\r\n  <li>1 tbsp lemon juice,</li>\r\n  <li>1/4 cup finely chopped coriander (dhania),</li>\r\n <li>2 tsp oil,</li>\r\n <li>2 tsp finely chopped garlic (lehsun),</li>\r\n  <li>2 tsp finely chopped green chillies,</li>\r\n <li>1/4 cup finely chopped onions,</li>\r\n <li>1/4 cup finely chopped cabbage,</li>\r\n  <li>1/4 cup finely chopped carrots,</li>\r\n  <li>3 cups basic vegetable stock,</li>\r\n  <li>salt to taste,</li>\r\n <li>2 tsp cornflour dissolved in 2 tbsp water&nbsp;</li>\r\n</ul>\r\n', '<ol>\r\n <li>Heat the oil in a deep non-stick pan, add the garlic and green chillies and saut&eacute; on a medium flame for a few seconds.</li>\r\n  <li>Add the onions and saut&eacute; on a medium flame for 1 to 2 minutes.</li>\r\n  <li>Add the cabbage and carrots and saut&eacute; on a medium flame for 1 minute.</li>\r\n <li>Add the basic vegetable stock, lemon juice, salt and cornflour-water mixture, mix well and cook on a medium flame for 2 to 3 minutes, while stirring occasionally. Add the coriander and mix well.</li>\r\n <li>Serve immediately.<br />\r\n  &nbsp;</li>\r\n</ol>\r\n', '41107_curried-carrot-soup-vert.jpg', '', '', 21, 2, 4.0, 0, 1),
(8, 2, 0, 2, 'image', 'Eggless Chocolate Cake Using Microwave', '15 mins', '<ol>\r\n  <li>1/2 cup plain flour (maida),</li>\r\n <li>2 tbsp cocoa powder,</li>\r\n <li>2 tbsp sour curds (khatta dahi),</li>\r\n <li>1/4 tsp soda bi-carb,</li>\r\n  <li>1/4 cup melted butter,</li>\r\n <li>1/3 cup powdered sugar,</li>\r\n  <li>1/2 tsp vanilla essence</li>\r\n</ol>\r\n', '<ol>\r\n <li>Sieve the flour and cocoa powder. Keep aside.</li>\r\n  <li>Mix together the curds and soda bi-carb in a bowl and keep aside.</li>\r\n  <li>Heat &frac14; cup of water by microwaving on high for 1 minute.</li>\r\n  <li>Combine the butter, sugar and &frac14; cup of hot water in another bowl and whisk well.</li>\r\n  <li>Add the curds, flour, and vanilla essence and mix to make a smooth batter of dropping consistency.</li>\r\n <li>Put the mixture in a 175 mm. (7&quot;) diameter greased shallow glass dish.</li>\r\n  <li>Microwave on high for 4 minutes.</li>\r\n <li>Remove from the microwave, cool slightly and unmould.</li>\r\n</ol>\r\n', '88507_eggless-blueberry-microwave.jpg', '', '', 56, 1, 5.0, 0, 1),
(24, 3, 0, 8, 'image', 'Supreme Cheese Garlic Bread', '20 min', '<p>Place the main ingredients of the dish first,</p>\r\n\r\n<p>starting with the most expensive,</p>\r\n\r\n<p>The reason for this is that guests read,</p>\r\n\r\n<p>as little as they can when deciding,</p>\r\n\r\n<p>what they want to order,</p>\r\n', '<p>Place the main ingredients of the dish first, starting with the most expensive and important ingredients (and make sure to include any that commonly cause allergic reactions). The reason for this is that guests read as little as they can when deciding what they want to order, and the main thing they want to know about your dish is what&rsquo;s in it.</p>\r\n', '73228_37461_burger.jpg', '', '', 306, 5, 4.0, 0, 1);

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

--
-- Table structure for table `tbl_settings`
--

CREATE TABLE `tbl_settings` (
  `id` int(11) NOT NULL,
  `envato_buyer_name` varchar(255) NOT NULL,
  `envato_purchase_code` varchar(255) NOT NULL,
  `envato_purchased_status` int(1) NOT NULL DEFAULT 0,
  `envato_ios_purchase_code` varchar(255) NOT NULL,
  `envato_ios_purchased_status` int(2) NOT NULL DEFAULT 0,
  `package_name` varchar(255) NOT NULL,
  `ios_bundle_identifier` varchar(255) NOT NULL,
  `onesignal_app_id` varchar(500) NOT NULL,
  `onesignal_rest_key` varchar(500) NOT NULL,
  `from_email` varchar(255) NOT NULL,
  `app_name` varchar(255) NOT NULL,
  `app_tagline` varchar(255) NOT NULL,
  `app_logo` varchar(255) NOT NULL,
  `app_email` varchar(255) NOT NULL,
  `app_version` varchar(255) NOT NULL,
  `app_author` varchar(255) NOT NULL,
  `app_contact` varchar(255) NOT NULL,
  `app_website` varchar(255) NOT NULL,
  `app_description` text NOT NULL,
  `app_developed_by` varchar(255) NOT NULL,
  `app_privacy_policy` text NOT NULL,
  `api_all_order_by` varchar(255) NOT NULL,
  `api_latest_limit` int(3) NOT NULL,
  `api_cat_order_by` varchar(255) NOT NULL,
  `api_cat_post_order_by` varchar(255) NOT NULL,
  `publisher_id` varchar(255) DEFAULT NULL,
  `interstital_ad` varchar(255) DEFAULT NULL,
  `interstital_ad_id` varchar(255) DEFAULT NULL,
  `interstital_ad_click` varchar(255) DEFAULT NULL,
  `banner_ad` varchar(255) DEFAULT NULL,
  `banner_ad_id` varchar(255) DEFAULT NULL,
  `banner_unity_id` varchar(255) DEFAULT NULL,
  `interstital_facebook_id` varchar(255) DEFAULT NULL,
  `interstitial_unity_id` varchar(255) DEFAULT NULL,
  `android_ad_network` varchar(255) DEFAULT NULL,
  `banner_applovin_id` varchar(255) DEFAULT NULL,
  `interstitial_applovin_id` varchar(255) DEFAULT NULL,
  `start_ads_id` varchar(255) DEFAULT NULL,
  `banner_facebook_id` varchar(255) DEFAULT NULL,
  `nativ_ad` varchar(255) DEFAULT NULL,
  `nativ_ad_id` varchar(255) DEFAULT NULL,
  `nativ_ad_click` varchar(255) DEFAULT NULL,
  `nativ_facebook_id` varchar(255) DEFAULT NULL,
  `nativ_applovin_id` varchar(255) DEFAULT NULL,
  `banner_wortise_id` varchar(255) DEFAULT NULL,
  `interstitial_wortise_id` varchar(255) DEFAULT NULL,
  `nativ_wortise_id` varchar(255) DEFAULT NULL,
  `wortise_app_id` varchar(255) DEFAULT NULL,
  `unity_game_id` varchar(255) DEFAULT NULL,
  `app_update_status` varchar(10) NOT NULL DEFAULT 'false',
  `app_new_version` double NOT NULL DEFAULT 1,
  `app_update_desc` text NOT NULL,
  `app_redirect_url` text NOT NULL,
  `cancel_update_status` varchar(10) NOT NULL DEFAULT 'false',
  `account_delete_intruction` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_settings`
--

INSERT INTO `tbl_settings` (`id`, `envato_buyer_name`, `envato_purchase_code`, `envato_purchased_status`, `envato_ios_purchase_code`, `envato_ios_purchased_status`, `package_name`, `ios_bundle_identifier`, `onesignal_app_id`, `onesignal_rest_key`, `from_email`, `app_name`, `app_tagline`, `app_logo`, `app_email`, `app_version`, `app_author`, `app_contact`, `app_website`, `app_description`, `app_developed_by`, `app_privacy_policy`, `api_all_order_by`, `api_latest_limit`, `api_cat_order_by`, `api_cat_post_order_by`, `publisher_id`, `interstital_ad`, `interstital_ad_id`, `interstital_ad_click`, `banner_ad`, `banner_ad_id`, `banner_unity_id`, `interstital_facebook_id`, `interstitial_unity_id`, `android_ad_network`, `banner_applovin_id`, `interstitial_applovin_id`, `start_ads_id`, `banner_facebook_id`, `nativ_ad`, `nativ_ad_id`, `nativ_ad_click`, `nativ_facebook_id`, `nativ_applovin_id`, `banner_wortise_id`, `interstitial_wortise_id`, `nativ_wortise_id`, `wortise_app_id`, `unity_game_id`, `app_update_status`, `app_new_version`, `app_update_desc`, `app_redirect_url`, `cancel_update_status`, `account_delete_intruction`) VALUES
(1, '', '', 0, '', 0, 'com.example.recipebox', 'com.recipebox', '', '', '-', 'Recipe Book', 'Food with integrity', '96.png', 'info@viaviweb.com', '1.0.0', 'Viavi Webtech', '+91 9227777522', 'www.viaviweb.com', '<p>Your Application reflects an identity of your business and it&#39;s time to mark your identity! Viavi Webtech is by your side in your journy towards becoming a proud business owner. now a days there are plenty of brands available in same categories, Viavi Webtech helps you to be unique from the others.</p>\r\n\r\n<p>We value the trust you put in us to develop your Application, and we safeguard that trust by going beyond what is expected; delivering that little bit extra that makes all the difference. Viavi Webtech team is as creative, diverse and colorful as the country it is based in. Team Viavi Webtech has plenty to offer and we would like to branch out to as many countries as we can.</p>\r\n\r\n<p>Give us a call or just WhatsApp on +919227777522<br />\r\nSend us your requirements via email: info@viaviweb.com</p>\r\n\r\n<p>You can buy our other products via below link:&nbsp;</p>\r\n\r\n<p><a href=\"https://codecanyon.net/user/viaviwebtech/portfolio\">https://codecanyon.net/user/viaviwebtech/portfolio</a></p>\r\n', 'Viavi Webtech', '<p><strong>We are committed to protecting your privacy</strong></p>\r\n\r\n<p>We collect the minimum amount of information about you that is commensurate with providing you with a satisfactory service. This policy indicates the type of processes that may result in data being collected about you. Your use of this website gives us the right to collect that information.&nbsp;</p>\r\n\r\n<p><strong>Information Collected</strong></p>\r\n\r\n<p>We may collect any or all of the information that you give us depending on the type of transaction you enter into, including your name, address, telephone number, and email address, together with data about your use of the website. Other information that may be needed from time to time to process a request may also be collected as indicated on the website.</p>\r\n\r\n<p><strong>Information Use</strong></p>\r\n\r\n<p>We use the information collected primarily to process the task for which you visited the website. Data collected in the UK is held in accordance with the Data Protection Act. All reasonable precautions are taken to prevent unauthorised access to this information. This safeguard may require you to provide additional forms of identity should you wish to obtain information about your account details.</p>\r\n\r\n<p><strong>Cookies</strong></p>\r\n\r\n<p>Your Internet browser has the in-built facility for storing small files - &quot;cookies&quot; - that hold information which allows a website to recognise your account. Our website takes advantage of this facility to enhance your experience. You have the ability to prevent your computer from accepting cookies but, if you do, certain functionality on the website may be impaired.</p>\r\n\r\n<p><strong>Disclosing Information</strong></p>\r\n\r\n<p>We do not disclose any personal information obtained about you from this website to third parties unless you permit us to do so by ticking the relevant boxes in registration or competition forms. We may also use the information to keep in contact with you and inform you of developments associated with us. You will be given the opportunity to remove yourself from any mailing list or similar device. If at any time in the future we should wish to disclose information collected on this website to any third party, it would only be with your knowledge and consent.&nbsp;</p>\r\n\r\n<p>We may from time to time provide information of a general nature to third parties - for example, the number of individuals visiting our website or completing a registration form, but we will not use any information that could identify those individuals.&nbsp;</p>\r\n\r\n<p>In addition Dummy may work with third parties for the purpose of delivering targeted behavioural advertising to the Dummy website. Through the use of cookies, anonymous information about your use of our websites and other websites will be used to provide more relevant adverts about goods and services of interest to you. For more information on online behavioural advertising and about how to turn this feature off, please visit youronlinechoices.com/opt-out.</p>\r\n\r\n<p><strong>Changes to this Policy</strong></p>\r\n\r\n<p>Any changes to our Privacy Policy will be placed here and will supersede this version of our policy. We will take reasonable steps to draw your attention to any changes in our policy. However, to be on the safe side, we suggest that you read this document each time you use the website to ensure that it still meets with your approval.</p>\r\n\r\n<p><strong>Contacting Us</strong></p>\r\n\r\n<p>If you have any questions about our Privacy Policy, or if you want to know what information we have collected about you, please email us at hd@dummy.com. You can also correct any factual errors in that information or require us to remove your details form any list under our control.</p>\r\n', 'ASC', 15, 'category_name', 'DESC', 'pub-9456493320432553', 'true', 'ca-app-pub-3940256099942544/1033173712', '5', 'true', 'ca-app-pub-3940256099942544/6300978111', '', '', '', 'wortise', '', '', '208651629', '', 'true', 'ca-app-pub-3940256099942544/2247696110', '5', '', '', 'a2562302-14ce-476b-94d4-0c6431f1f927', 'ed6fc25c-9855-485e-9513-fed0d3acc528', 'cf65ed35-4765-4955-96fc-a33cf43d5340', 'a4e76baa-c4ce-4672-ba85-f2f7190bd19b', '', 'false', 1, 'kindly you can update new version app', 'https://play.google.com/store/apps/developer?id=Viaan+Parmar', 'true', '<p><strong>Contact&nbsp;</strong></p>\r\n\r\n<p><strong>Email :-&nbsp;&nbsp;</strong><strong>info@viaviweb.com</strong></p>');

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

--
-- Table structure for table `tbl_slider`
--

CREATE TABLE `tbl_slider` (
  `id` int(10) NOT NULL,
  `recipe_id` int(10) NOT NULL DEFAULT 0,
  `slider_type` varchar(30) DEFAULT NULL,
  `external_url` text DEFAULT NULL,
  `external_image` text DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` (`id`, `recipe_id`, `slider_type`, `external_url`, `external_image`, `status`) VALUES
(2, 0, 'external', 'https://codecanyon.net/item/android-live-tv-with-material-design/7506537?s_rank=16', '82998_slider.jpg', 1),
(8, 0, 'external', 'https://codecanyon.net/item/android-video-status-app-with-reward-points/22983826?s_rank=7', '39955_slider.jpg', 1),
(37, 5, 'Recipe', '', '91549_slider.jpg', 1);

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

--
-- Table structure for table `tbl_smtp_settings`
--

CREATE TABLE `tbl_smtp_settings` (
  `id` int(5) NOT NULL,
  `smtp_type` varchar(20) NOT NULL,
  `smtp_host` varchar(150) NOT NULL,
  `smtp_email` varchar(150) NOT NULL,
  `smtp_password` text NOT NULL,
  `smtp_secure` varchar(20) NOT NULL,
  `port_no` varchar(10) NOT NULL,
  `smtp_ghost` varchar(150) NOT NULL,
  `smtp_gemail` varchar(150) NOT NULL,
  `smtp_gpassword` text NOT NULL,
  `smtp_gsecure` varchar(20) NOT NULL,
  `gport_no` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_smtp_settings`
--

INSERT INTO `tbl_smtp_settings` (`id`, `smtp_type`, `smtp_host`, `smtp_email`, `smtp_password`, `smtp_secure`, `port_no`, `smtp_ghost`, `smtp_gemail`, `smtp_gpassword`, `smtp_gsecure`, `gport_no`) VALUES
(1, 'server', '', '', '', 'ssl', '465', 'smtp.gmail.com', 'info@gmail.com', '', 'ssl', '465');

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

--
-- Table structure for table `tbl_sub_category`
--

CREATE TABLE `tbl_sub_category` (
  `sid` int(10) NOT NULL,
  `cat_id` int(255) NOT NULL,
  `sub_cat_name` varchar(255) NOT NULL,
  `sub_cat_image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tbl_sub_category`
--

INSERT INTO `tbl_sub_category` (`sid`, `cat_id`, `sub_cat_name`, `sub_cat_image`) VALUES
(1, 2, 'Pasta', '17881_img_5.jpg'),
(2, 2, 'Pastirs', '45895_img_3.jpg'),
(4, 1, 'Salad', '89871_img_2.jpg'),
(6, 4, 'Fruits', '37684_img_4.jpg'),
(8, 3, 'Meats', '56554_img_1.jpg'),
(9, 4, 'Bread', '9596_img_5.jpg'),
(10, 5, 'Salad types', '34379_14682_salad.jpg'),
(11, 2, 'South', '86787_keral.jpg'),
(12, 2, 'Chicken', '53306_chickaen.jpg'),
(13, 2, 'Burger', '43079_burger.jpg');

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(10) NOT NULL,
  `user_type` varchar(30) NOT NULL DEFAULT 'Normal',
  `auth_id` varchar(255) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `email` varchar(60) NOT NULL,
  `password` text NOT NULL,
  `phone` varchar(30) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `register_on` varchar(200) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`cid`);

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

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

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

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

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

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

--
-- Indexes for table `tbl_sub_category`
--
ALTER TABLE `tbl_sub_category`
  ADD PRIMARY KEY (`sid`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_sub_category`
--
ALTER TABLE `tbl_sub_category`
  MODIFY `sid` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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