CURRENT PATH:
/
home
/
u921493091
/
domains
/
dpsinstitute.ac.in
/
public_html
/
db
/
[ ⬅ KEMBALI ]
|
[ HOME ]
Upload File:
Upload Ke Sini
Dir Baru
File Baru
Editing:
dpsinsti_db.sql
-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: May 05, 2023 at 11:12 AM -- Server version: 5.7.23-23 -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `dpsinsti_db` -- -- -------------------------------------------------------- -- -- Table structure for table `admissions` -- CREATE TABLE `admissions` ( `id` bigint(20) UNSIGNED NOT NULL, `sname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `fname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `qual` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `pass` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `percent` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `pincode` int(11) NOT NULL, `mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `course` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `dob` date NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `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 `admissions` -- INSERT INTO `admissions` (`id`, `sname`, `fname`, `qual`, `pass`, `percent`, `pincode`, `mobile`, `email`, `course`, `dob`, `address`, `created_at`, `updated_at`) VALUES (17, 'Regan Alston', 'Violet May', 'MSC', '2001', '92', 39, '96', 'fezym@mailinator.com', 'D.El.Ed', '2016-05-15', 'Aperiam et magna a o', '2023-02-17 05:15:17', '2023-02-17 05:15:17'), (18, 'Regan Alston', 'Violet May', 'MSC', '2001', '92', 39, '96', 'fezym@mailinator.com', 'D.El.Ed', '2016-05-15', 'Aperiam et magna a o', '2023-02-17 05:16:24', '2023-02-17 05:16:24'), (19, 'Jyoti kumari', 'JANAK THAKUR', 'BSC', '2022', '79', 735214, '8158888151', '1100jyoti.kumari@gmail.com', 'B.ED', '2000-03-26', 'Paschim satali, HASIMARA, ALIPURDUAR-735214 (WEST BENGAL)', '2023-04-24 00:18:05', '2023-04-24 00:18:05'); -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `by` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `desc` text COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL, `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`, `title`, `by`, `image`, `desc`, `date`, `created_at`, `updated_at`) VALUES (5, 'Asperiores fuga Ame', 'Reiciendis quasi pla', '922-image4.jpg', '<p><strong>iudsfhgh d ufg fd ghd g</strong></p><h2>fsd mfhj fhgdysg sd</h2>', '1994-08-11', '2023-02-17 03:08:46', '2023-02-21 06:15:20'), (6, 'School Vacatiobngdsiufkajfnhbbhf i fdgb xvxxc', 'Dr Saurav Kumar ashgfsd', '363-image3.jpg', '<h2>Hellow Every One</h2><p>jhf sdhfs jdfh sjkskdhfkjshdkfhs sdkfhus fsds</p><p><strong>hasgduya sduyfg suydfh sif sdd</strong></p>', '2023-02-11', '2023-02-21 05:26:30', '2023-02-21 05:26:30'); -- -------------------------------------------------------- -- -- Table structure for table `enquiries` -- CREATE TABLE `enquiries` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `for` text COLLATE utf8mb4_unicode_ci, `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 `enquiries` -- INSERT INTO `enquiries` (`id`, `name`, `email`, `phone`, `for`, `created_at`, `updated_at`) VALUES (1, 'Acton Irwin', 'somoxyzybu@mailinator.com', '8979848979', 'Acton Irwin', '2023-04-08 02:51:45', '2023-04-08 02:51:45'); -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `fee_collections` -- CREATE TABLE `fee_collections` ( `id` bigint(20) UNSIGNED NOT NULL, `payment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `sname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `pname` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `address` text COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `pincode` varchar(8) COLLATE utf8mb4_unicode_ci NOT NULL, `fee_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL, `course` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `reg_no` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `payment_status` tinyint(1) DEFAULT NULL, `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 `fee_collections` -- INSERT INTO `fee_collections` (`id`, `payment_id`, `order_id`, `sname`, `pname`, `mobile`, `email`, `address`, `city`, `pincode`, `fee_type`, `amount`, `course`, `reg_no`, `payment_status`, `created_at`, `updated_at`) VALUES (39, 'pay_LJ6zUTXdHVwmzK', 'order_LJ6zKle2EIDF66', 'Briar Padilla', 'Philip Fuentes', '47', 'rogukutup@mailinator.com', 'Enim pariatur Moles', 'A facere illum mini', '3', 'registration fee', '96', 'B.ED', 'Incidunt in impedit', 1, '2023-02-21 08:01:47', '2023-02-21 08:01:47'), (40, 'pay_LJMOUeAn7KTpiE', 'order_LJMO05cEvCCqyL', 'Daquan Benson', 'Arden Munoz', '23', 'hidifod@mailinator.com', 'Dolore id et nulla m', 'Dolor vero vitae con', '95', 'Tution Fee', '96', 'B.ED', 'Quo nisi corrupti i', 1, '2023-02-21 23:05:53', '2023-02-21 23:05:53'); -- -------------------------------------------------------- -- -- Table structure for table `galleries` -- CREATE TABLE `galleries` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `img` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `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 `galleries` -- INSERT INTO `galleries` (`id`, `title`, `img`, `created_at`, `updated_at`) VALUES (1, 'ewrw', '1676958373-img.jpg', '2023-02-21 00:16:13', '2023-02-21 00:16:13'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) COLLATE utf8mb4_unicode_ci 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_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2019_12_14_000001_create_personal_access_tokens_table', 1), (5, '2023_02_15_054005_create_sliders_table', 2), (6, '2023_02_15_054049_create_photos_table', 2), (7, '2023_02_15_103406_create_news_table', 3), (8, '2023_02_16_075241_create_notices_table', 4), (9, '2023_02_16_101753_create_syllabi_table', 5), (10, '2023_02_16_101926_create_routines_table', 5), (12, '2023_02_17_051810_create_blogs_table', 6), (13, '2023_02_17_092211_create_admissions_table', 7), (14, '2023_02_20_053003_create_fee_collections_table', 8), (15, '2023_02_21_045301_create_galleries_table', 9), (16, '2023_02_21_045339_create_photos_table', 9), (17, '2023_02_21_122844_create_presses_table', 10), (18, '2023_04_08_075632_create_enquiries_table', 11); -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL, `details` text COLLATE utf8mb4_unicode_ci NOT NULL, `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 `news` -- INSERT INTO `news` (`id`, `image`, `title`, `date`, `details`, `created_at`, `updated_at`) VALUES (10, '460-image86.jpg', 'Updated', '2023-02-17', 'updated', '2023-02-16 01:39:26', '2023-02-16 02:01:40'); -- -------------------------------------------------------- -- -- Table structure for table `notices` -- CREATE TABLE `notices` ( `id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `date` date NOT NULL, `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 `notices` -- INSERT INTO `notices` (`id`, `title`, `date`, `created_at`, `updated_at`) VALUES (3, 'eritwenrchwyrucuwn', '2023-02-04', '2023-02-16 03:12:36', '2023-02-16 03:12:36'), (4, 'Admission Is Open', '2023-02-03', '2023-02-16 04:01:40', '2023-02-16 04:01:40'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT 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 `photos` -- CREATE TABLE `photos` ( `id` bigint(20) UNSIGNED NOT NULL, `img` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `gallery_id` int(11) 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 `presses` -- CREATE TABLE `presses` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `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 `presses` -- INSERT INTO `presses` (`id`, `image`, `created_at`, `updated_at`) VALUES (17, '807-press.348.jpg', '2023-02-21 23:14:40', '2023-02-21 23:14:40'); -- -------------------------------------------------------- -- -- Table structure for table `routines` -- CREATE TABLE `routines` ( `id` bigint(20) UNSIGNED NOT NULL, `course` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `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 `routines` -- INSERT INTO `routines` (`id`, `course`, `desc`, `file`, `created_at`, `updated_at`) VALUES (1, 'jhhhgcfgvdgc', 'fghbhgjnghb', '118-file77.pdf', '2023-02-16 23:39:00', '2023-02-16 23:39:00'); -- -------------------------------------------------------- -- -- Table structure for table `sliders` -- CREATE TABLE `sliders` ( `id` bigint(20) UNSIGNED NOT NULL, `image` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `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 `sliders` -- INSERT INTO `sliders` (`id`, `image`, `created_at`, `updated_at`) VALUES (16, '558-image1.jpg', '2023-02-15 02:47:51', '2023-02-15 02:47:51'), (17, '374-image4.jpg', '2023-02-15 02:47:58', '2023-02-15 02:47:58'); -- -------------------------------------------------------- -- -- Table structure for table `syllabus` -- CREATE TABLE `syllabus` ( `id` bigint(20) UNSIGNED NOT NULL, `course` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `desc` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `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 `syllabus` -- INSERT INTO `syllabus` (`id`, `course`, `desc`, `file`, `created_at`, `updated_at`) VALUES (5, 'sdkufhishfsdf', 'ewtwertertvecer vcb cb cvbcvbdfb b', '963-file93.pdf', '2023-02-16 07:40:30', '2023-02-16 07:40:30'), (6, 'dfgagfdg', 'dfgsdfhbfgbxcbv', '732-file83.pdf', '2023-02-16 23:45:28', '2023-02-16 23:45:28'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `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 `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (2, 'dpsingh institute', 'admin@gmail.com', NULL, '$2y$10$LmQowDhNHcuq.gFObgTOX.bb/jEwQ58eqeeMRbrgWajaeP8mRnW7G', NULL, '2023-03-29 05:41:36', '2023-03-29 05:41:36'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admissions` -- ALTER TABLE `admissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `enquiries` -- ALTER TABLE `enquiries` 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 `fee_collections` -- ALTER TABLE `fee_collections` ADD PRIMARY KEY (`id`); -- -- Indexes for table `galleries` -- ALTER TABLE `galleries` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `news` -- ALTER TABLE `news` ADD PRIMARY KEY (`id`); -- -- Indexes for table `notices` -- ALTER TABLE `notices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `photos` -- ALTER TABLE `photos` ADD PRIMARY KEY (`id`); -- -- Indexes for table `presses` -- ALTER TABLE `presses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `routines` -- ALTER TABLE `routines` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sliders` -- ALTER TABLE `sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `syllabus` -- ALTER TABLE `syllabus` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admissions` -- ALTER TABLE `admissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `enquiries` -- ALTER TABLE `enquiries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `fee_collections` -- ALTER TABLE `fee_collections` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `galleries` -- ALTER TABLE `galleries` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `news` -- ALTER TABLE `news` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `notices` -- ALTER TABLE `notices` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `photos` -- ALTER TABLE `photos` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `presses` -- ALTER TABLE `presses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `routines` -- ALTER TABLE `routines` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `sliders` -- ALTER TABLE `sliders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `syllabus` -- ALTER TABLE `syllabus` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; 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 */;
SIMPAN
[ BATAL ]