daily pastebin goal
74%
SHARE
TWEET

Untitled

a guest Dec 12th, 2018 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Dec 13, 2018 at 12:51 AM
  7. -- Server version: 10.1.34-MariaDB
  8. -- PHP Version: 7.2.8
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `ppdb`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `migrations`
  29. --
  30.  
  31. CREATE TABLE `migrations` (
  32.   `id` int(10) UNSIGNED NOT NULL,
  33.   `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  34.   `batch` int(11) NOT NULL
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  36.  
  37. --
  38. -- Dumping data for table `migrations`
  39. --
  40.  
  41. INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  42. (1, '2014_10_12_000000_create_users_table', 1),
  43. (2, '2014_10_12_100000_create_password_resets_table', 1),
  44. (3, '2018_12_12_072919_create_siswas_table', 1),
  45. (4, '2018_12_12_091004_create_sekolahs_table', 1);
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Table structure for table `password_resets`
  51. --
  52.  
  53. CREATE TABLE `password_resets` (
  54.   `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  55.   `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  56.   `created_at` timestamp NULL DEFAULT NULL
  57. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  58.  
  59. -- --------------------------------------------------------
  60.  
  61. --
  62. -- Table structure for table `sekolahs`
  63. --
  64.  
  65. CREATE TABLE `sekolahs` (
  66.   `id` int(10) UNSIGNED NOT NULL,
  67.   `nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  68.   `created_at` timestamp NULL DEFAULT NULL,
  69.   `updated_at` timestamp NULL DEFAULT NULL
  70. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  71.  
  72. --
  73. -- Dumping data for table `sekolahs`
  74. --
  75.  
  76. INSERT INTO `sekolahs` (`id`, `nama`, `created_at`, `updated_at`) VALUES
  77. (1, 'SMPN 1 Bojonegoro', NULL, NULL),
  78. (2, 'SMPN 2 Bojonegoro', NULL, NULL),
  79. (3, 'SMPN 3 Bojonegoro', NULL, NULL),
  80. (4, 'SMPN 4 Bojonegoro', NULL, NULL);
  81.  
  82. -- --------------------------------------------------------
  83.  
  84. --
  85. -- Table structure for table `siswas`
  86. --
  87.  
  88. CREATE TABLE `siswas` (
  89.   `id` int(10) UNSIGNED NOT NULL,
  90.   `user_id` int(10) UNSIGNED DEFAULT NULL,
  91.   `nisn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  92.   `nama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  93.   `alamat` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  94.   `provinsi` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  95.   `kota` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  96.   `kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  97.   `kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  98.   `agama` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  99.   `jeniskelamin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  100.   `tempat_lahir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  101.   `tanggal_lahir` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  102.   `sekolah_tujuan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  103.   `status` int(11) NOT NULL DEFAULT '0',
  104.   `created_at` timestamp NULL DEFAULT NULL,
  105.   `updated_at` timestamp NULL DEFAULT NULL
  106. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  107.  
  108. -- --------------------------------------------------------
  109.  
  110. --
  111. -- Table structure for table `users`
  112. --
  113.  
  114. CREATE TABLE `users` (
  115.   `id` int(10) UNSIGNED NOT NULL,
  116.   `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  117.   `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  118.   `email_verified_at` timestamp NULL DEFAULT NULL,
  119.   `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  120.   `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  121.   `created_at` timestamp NULL DEFAULT NULL,
  122.   `updated_at` timestamp NULL DEFAULT NULL
  123. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  124.  
  125. --
  126. -- Indexes for dumped tables
  127. --
  128.  
  129. --
  130. -- Indexes for table `migrations`
  131. --
  132. ALTER TABLE `migrations`
  133.   ADD PRIMARY KEY (`id`);
  134.  
  135. --
  136. -- Indexes for table `password_resets`
  137. --
  138. ALTER TABLE `password_resets`
  139.   ADD KEY `password_resets_email_index` (`email`);
  140.  
  141. --
  142. -- Indexes for table `sekolahs`
  143. --
  144. ALTER TABLE `sekolahs`
  145.   ADD PRIMARY KEY (`id`);
  146.  
  147. --
  148. -- Indexes for table `siswas`
  149. --
  150. ALTER TABLE `siswas`
  151.   ADD PRIMARY KEY (`id`);
  152.  
  153. --
  154. -- Indexes for table `users`
  155. --
  156. ALTER TABLE `users`
  157.   ADD PRIMARY KEY (`id`),
  158.   ADD UNIQUE KEY `users_email_unique` (`email`);
  159.  
  160. --
  161. -- AUTO_INCREMENT for dumped tables
  162. --
  163.  
  164. --
  165. -- AUTO_INCREMENT for table `migrations`
  166. --
  167. ALTER TABLE `migrations`
  168.   MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  169.  
  170. --
  171. -- AUTO_INCREMENT for table `sekolahs`
  172. --
  173. ALTER TABLE `sekolahs`
  174.   MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  175.  
  176. --
  177. -- AUTO_INCREMENT for table `siswas`
  178. --
  179. ALTER TABLE `siswas`
  180.   MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  181.  
  182. --
  183. -- AUTO_INCREMENT for table `users`
  184. --
  185. ALTER TABLE `users`
  186.   MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  187. COMMIT;
  188.  
  189. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  190. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  191. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top