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

START TRANSACTION;



--
-- Database: `edustack`
--

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_category` varchar(255) NOT NULL,
  `blog_author` varchar(255) NOT NULL,
  `blog_tag` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image_title` varchar(255) NOT NULL,
  `image_alt` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_keyword` varchar(255) NOT NULL,
  `meta_desc` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `blog_category`, `blog_author`, `blog_tag`, `title`, `slug`, `image_title`, `image_alt`, `image`, `description`, `meta_title`, `meta_keyword`, `meta_desc`, `status`, `created_at`, `updated_at`) VALUES
(3, '1', '1', '1,2', 'Top FinTech App Development Companies In India 2024', 'top-fintech-app-development-companies-in-india-2024', 'blog 1', 'blog 1', '1704777468.jpg', '<p>In the ever-evolving landscape of financial technology, India stands at the forefront of innovation, with a myriad of <strong>fintech app development companies </strong>paving the way for ground-breaking solutions. As we step into 2024, the significance of mobile applications in the financial sector has reached unprecedented heights, reshaping the way we manage, invest, and transact.</p><p>&nbsp;</p><p>The statistics speak volumes about this digital revolution. According to recent surveys, mobile banking users in India are expected to surpass 800 million by the end of 2023, underscoring the role of fintech apps in our daily financial activities. As technology continues to influence every aspect of our lives, the demand for seamless, secure,</p>', 'meta title', 'meta keyword', 'meta description', 1, '2024-01-08 23:47:48', '2024-01-08 23:47:48');

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

--
-- Table structure for table `blog_authors`
--

CREATE TABLE `blog_authors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_authors`
--

INSERT INTO `blog_authors` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Mohit', 1, '2024-01-08 22:46:54', '2024-01-08 22:46:54');

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Promo', 1, '2024-01-08 22:47:05', '2024-01-08 22:47:05');

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

--
-- Table structure for table `blog_tags`
--

CREATE TABLE `blog_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_tags`
--

INSERT INTO `blog_tags` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Technology', 1, '2024-01-08 22:46:45', '2024-01-08 23:45:23'),
(2, 'Laravel', 1, '2024-01-08 23:45:32', '2024-01-08 23:45:32');

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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `school` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `name`, `designation`, `school`, `image`, `description`, `status`, `created_at`, `updated_at`) VALUES
(3, 'L.K. Sharma', 'Principle', 'A.V.M. Public School', '1704777255.svg', 'Edustack, our comprehensive institution management system software, caters to diverse educational institutes beyond schools. This robust software encompasses a wide array of academic and administrative functionalities crucial for various educational institutions. From admissions to daily academic operations, exam management, fees collection, and employee payroll, EduStack\'s institution management system streamlines processes across different educational settings, reducing workload and ensuring efficiency.', 1, '2024-01-08 23:44:15', '2024-01-08 23:44:15');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `contactFirstname` varchar(255) NOT NULL,
  `contactLastname` varchar(255) NOT NULL,
  `contactemail` varchar(255) NOT NULL,
  `countrycode` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2024_01_03_044045_create_blog_tags_table', 1),
(6, '2024_01_03_054830_create_blog_authors_table', 1),
(7, '2024_01_03_060810_create_blog_categories_table', 1),
(8, '2024_01_03_061845_create_blogs_table', 1),
(9, '2024_01_04_043720_create_sliders_table', 1),
(10, '2024_01_04_055509_add_status_to_sliders_table', 1),
(11, '2024_01_04_084740_create_clients_table', 1),
(12, '2024_01_04_085507_create_contacts_table', 1),
(13, '2024_01_05_120047_add_newcolumns_to_sliders_table', 1);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1 => Main slider, 2 =>  Brand slider',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` enum('Active','De-Active') NOT NULL DEFAULT 'Active',
  `title1` varchar(255) NOT NULL DEFAULT 'null',
  `title2` varchar(255) NOT NULL DEFAULT 'null',
  `title3` varchar(255) NOT NULL DEFAULT 'null'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `image_path`, `type`, `created_at`, `updated_at`, `status`, `title1`, `title2`, `title3`) VALUES
(6, 'http://localhost/edustack/storage/main_slider/1704776917.svg', 1, '2024-01-08 23:38:37', '2024-01-08 23:38:37', 'Active', 'Leading the Way in School ERP Software Solutions', 'Efficient Institutions Administration Powered by EduStack', 'From Admissions to Finances, Ensuring Seamless Operations Across Diverse Educational Institutions.'),
(7, 'http://localhost/edustack/storage/main_slider/1704776979.svg', 1, '2024-01-08 23:39:39', '2024-01-08 23:39:39', 'Active', 'Setting the Standard in School ERP Software Solutions', 'Effortless Institution Administration with EduStack\'s Power', 'From Enrollments to Financials, Pioneering Smooth Operations Across Varied Educational Institutions.'),
(8, 'http://localhost/edustack/storage/brand_slider/1704777043.svg', 2, '2024-01-08 23:40:43', '2024-01-08 23:40:43', 'Active', 'null', 'null', 'null'),
(9, 'http://localhost/edustack/storage/brand_slider/1704777059.svg', 2, '2024-01-08 23:40:59', '2024-01-08 23:40:59', 'Active', 'null', 'null', 'null'),
(10, 'http://localhost/edustack/storage/brand_slider/1704777069.svg', 2, '2024-01-08 23:41:09', '2024-01-08 23:41:09', 'Active', 'null', 'null', 'null'),
(11, 'http://localhost/edustack/storage/brand_slider/1704777081.svg', 2, '2024-01-08 23:41:21', '2024-01-08 23:41:21', 'Active', 'null', 'null', 'null'),
(12, 'http://localhost/edustack/storage/brand_slider/1704777094.png', 2, '2024-01-08 23:41:34', '2024-01-08 23:41:34', 'Active', 'null', 'null', 'null'),
(13, 'http://localhost/edustack/storage/brand_slider/1704777109.png', 2, '2024-01-08 23:41:49', '2024-01-08 23:41:49', 'Active', 'null', 'null', 'null');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `blog_authors`
--
ALTER TABLE `blog_authors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blog_tags`
--
ALTER TABLE `blog_tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

