-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 19, 2022 at 04:49 PM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 7.4.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `nowara`
--

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

--
-- Table structure for table `business`
--

CREATE TABLE `business` (
  `id` int(11) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `title_slug` varchar(500) DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `post_sub_type` varchar(50) DEFAULT NULL,
  `category_id` tinyint(2) DEFAULT NULL,
  `post_image_id` varchar(255) DEFAULT 'jpg',
  `optional_url` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT 1,
  `need_auth` int(11) NOT NULL DEFAULT 0,
  `website_url` varchar(500) NOT NULL DEFAULT '#',
  `website_name` varchar(255) DEFAULT NULL,
  `show_item_numbers` int(11) NOT NULL DEFAULT 3,
  `is_default` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `business`
--

INSERT INTO `business` (`id`, `title`, `title_slug`, `summary`, `content`, `post_sub_type`, `category_id`, `post_image_id`, `optional_url`, `user_id`, `need_auth`, `website_url`, `website_name`, `show_item_numbers`, `is_default`, `created_at`, `updated_at`) VALUES
(5, 'Microsoft Dynamics 365', 'microsoft-dynamics-365', 'Microsoft Dynamics 365 is a set-up of Intelligent Business Applications from Microsoft that empower associations run all parts of their activities, and convey truly further developing outcomes through prescient AI drive experiences.', '<p>Microsoft Dynamics 365 is a set-up of Intelligent Business Applications from Microsoft that empower associations run all parts of their activities, and convey truly further developing outcomes through prescient AI drive experiences. Elements 365 covers the customary extent of ERP and CRM, and stretches a long ways past covering regions that were not considered until two or three years prior. There is Dynamics 365 Business Central ERP for little and moderate sized associations, Dynamics 365 Finance and SCM for huge associations, Customer Engagement, Sales, Marketing, Customer Service, Field Service, Project Operations, and HR capacities - all pieces of the consistently developing Dynamics 365 suite. Nearby the Dynamics 365 suite are the different parts of Power stage that increment the force of Dynamics 365 dramatically.</p>', 'business', 3, '126', '', 1, 0, '', '', 3, 1, '2021-12-22 16:29:06', '2022-01-18 14:13:17'),
(8, 'Power Platform', 'power-platform', 'Microsoft Power Platform addresses an exquisite easy to understand point of interaction to the assorted modern advances that are essential for the generally Microsoft Stack.', '<p>Microsoft Power Platform addresses an exquisite easy to understand point of interaction to the assorted modern advances that are essential for the generally Microsoft Stack. Microsoft CEO Satya Nadella had said<br />\"Without precedent for reality, in our own Microsoft history, we have an extensibility model that is no different for Office 365 and Dynamics 365. This has been a fantasy of dig for, I don\'t have the foggiest idea, for a considerable length of time most likely. What\'s more we are at long last here and we execute very well.\"</p>\r\n<p>Including the essential parts of Power BI, Power Apps, Power Automate and Virtual Agents - the Microsoft Power Platform is \'more than the amount of its parts\'.</p>', 'business', 15, '127', '', 1, 0, '', '', 3, 0, '2021-12-23 12:01:18', '2022-01-17 14:31:48'),
(15, 'Data and AI', 'data-and-ai', 'Microsoft is working with Amazon Alexa, KPMG, and a few different accomplices in complete pair to utilize AI and Machine Learning apparatuses for a superior tomorrow.', '<p>Microsoft is working with Amazon Alexa, KPMG, and a few different accomplices in complete pair to utilize AI and Machine Learning apparatuses for a superior tomorrow. Our answers are not restricted to Microsoft stages however are presently more comprehensive and hearty with innovation and information offering to other significant AI and ML R&amp;D focuses. Alletec Designs AI and ML arrangements in light of the strong Azure AI stage.&nbsp;</p>', 'business', 15, '128', '', 1, 0, '', '', 3, 0, '2021-12-29 05:44:54', '2022-01-17 14:35:00'),
(16, 'Microsoft Azure', 'microsoft-azure', 'Foundation as a help (IaaS) is a distributed computing arrangement that offers virtualized registering assets which can be gotten to over the Internet.', '<p>Foundation as a help (IaaS) is a distributed computing arrangement that offers virtualized registering assets which can be gotten to over the Internet. IaaS being a pay-more only as costs arise foundation stage can rapidly increase assets or down to match interest, so you just compensation for the administrations and framework you use. It assists you with keeping away from the costs and the requirement for a group to deal with the complicated purchasing and overseeing endeavors for your actual servers and different server farm framework. Every asset and administration is presented as a different contribution in the Platform, and the framework consequently allocates you the assets</p>', 'business', 15, '129', '', 1, 0, '', '', 3, 0, '2021-12-29 05:47:15', '2022-01-17 14:42:02'),
(18, 'Services', 'services', 'Going by the way of thinking of \'Purchase what you can, and assemble what you should\' - Alletec use the a-list stages like Microsoft Dynamics 365, Microsoft Dynamics NAV', '<p>Going by the way of thinking of \'Purchase what you can, and assemble what you should\' - Alletec use the a-list stages like Microsoft Dynamics 365, Microsoft Dynamics NAV (NAVISION), Dynamics AX, Dynamics CRM, SharePoint, Power BI and Microsoft Azure to fabricate driving industry answers for its clients.</p>\r\n<p>Versatility arrangements are worked across stages (Android, iOS, Windows) and Business Analytics arrangements conveyed over Microsoft\'s Power BI. On the off chance that your business application should be \'specially fabricated\' - Alletec utilizes both Microsoft and Open source stages for custom application advancement.</p>', 'business', 3, '130', '', 1, 0, '', '', 3, 0, '2021-12-29 05:52:40', '2022-01-17 14:44:30'),
(25, 'test', 'test-business', 'test', '<p>test</p>', 'business', 3, '130', 'www.testing.com', 1, 0, 'www.testing.com', 'Test by prachi', 3, 0, '2022-01-18 14:33:11', '2022-01-19 12:20:12'),
(28, 'test by prachi', 'test-by-prachi', 'test by prachi', '<p><span>test by prachi</span></p>', 'business', 15, '130', '', 1, 0, '', '', 3, 0, '2022-01-19 13:34:42', '2022-01-19 13:37:02'),
(29, 'test two', 'test-two', '', '<p>test two</p>', 'business', 15, '127', '', 1, 0, '', '', 3, 0, '2022-01-19 13:40:04', '2022-01-19 14:43:07');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
