View file File name : blog_categories.sql Content :-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Nov 16, 2025 at 03:37 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `smartlinks_local` -- -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` bigint(20) UNSIGNED NOT NULL, `app_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(191) NOT NULL, `slug` varchar(191) NOT NULL, `description` text DEFAULT NULL, `color` varchar(7) NOT NULL DEFAULT '#3B82F6', `posts_count` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `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`, `app_id`, `name`, `slug`, `description`, `color`, `posts_count`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (1, 11, 'Alcohol', 'alcohol', NULL, '#3B82F6', 0, 1, 1, '2025-11-16 12:19:30', '2025-11-16 12:19:30'), (2, 11, 'Recovery', 'recovery', NULL, '#3B82F6', 0, 1, 2, '2025-11-16 12:19:31', '2025-11-16 12:19:31'), (3, 11, 'Porn', 'porn', NULL, '#3B82F6', 0, 1, 3, '2025-11-16 12:19:31', '2025-11-16 12:19:31'), (4, 11, 'Smoking', 'smoking', NULL, '#3B82F6', 0, 1, 4, '2025-11-16 12:19:57', '2025-11-16 12:19:57'); -- -- Indexes for dumped tables -- -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `blog_categories_slug_unique` (`slug`), ADD KEY `blog_categories_app_id_is_active_index` (`app_id`,`is_active`), ADD KEY `blog_categories_slug_index` (`slug`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- Constraints for dumped tables -- -- -- Constraints for table `blog_categories` -- ALTER TABLE `blog_categories` ADD CONSTRAINT `blog_categories_app_id_foreign` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE CASCADE; 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 */;