Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.8.2
- -- https://www.phpmyadmin.net/
- --
- -- Host: 127.0.0.1
- -- Generation Time: Dec 13, 2018 at 12:51 AM
- -- Server version: 10.1.34-MariaDB
- -- PHP Version: 7.2.8
- 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: `ppdb`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `migrations`
- --
- CREATE TABLE `migrations` (
- `id` int(10) UNSIGNED NOT NULL,
- `migration` varchar(191) 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, '2018_12_12_072919_create_siswas_table', 1),
- (4, '2018_12_12_091004_create_sekolahs_table', 1);
- -- --------------------------------------------------------
- --
- -- Table structure for table `password_resets`
- --
- CREATE TABLE `password_resets` (
- `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `token` varchar(191) 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 `sekolahs`
- --
- CREATE TABLE `sekolahs` (
- `id` int(10) UNSIGNED NOT NULL,
- `nama` varchar(191) 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 `sekolahs`
- --
- INSERT INTO `sekolahs` (`id`, `nama`, `created_at`, `updated_at`) VALUES
- (1, 'SMPN 1 Bojonegoro', NULL, NULL),
- (2, 'SMPN 2 Bojonegoro', NULL, NULL),
- (3, 'SMPN 3 Bojonegoro', NULL, NULL),
- (4, 'SMPN 4 Bojonegoro', NULL, NULL);
- -- --------------------------------------------------------
- --
- -- Table structure for table `siswas`
- --
- CREATE TABLE `siswas` (
- `id` int(10) UNSIGNED NOT NULL,
- `user_id` int(10) UNSIGNED DEFAULT NULL,
- `nisn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `alamat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `provinsi` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `kota` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `agama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `jeniskelamin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `tempat_lahir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `tanggal_lahir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `sekolah_tujuan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `status` 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;
- -- --------------------------------------------------------
- --
- -- Table structure for table `users`
- --
- CREATE TABLE `users` (
- `id` int(10) UNSIGNED NOT NULL,
- `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
- `email_verified_at` timestamp NULL DEFAULT NULL,
- `password` varchar(191) 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;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `migrations`
- --
- ALTER TABLE `migrations`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `password_resets`
- --
- ALTER TABLE `password_resets`
- ADD KEY `password_resets_email_index` (`email`);
- --
- -- Indexes for table `sekolahs`
- --
- ALTER TABLE `sekolahs`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `siswas`
- --
- ALTER TABLE `siswas`
- 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 `migrations`
- --
- ALTER TABLE `migrations`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `sekolahs`
- --
- ALTER TABLE `sekolahs`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `siswas`
- --
- ALTER TABLE `siswas`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` int(10) 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement