Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.9.0.1
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost:3306
- -- Generation Time: Aug 22, 2019 at 10:07 AM
- -- Server version: 5.7.26
- -- PHP Version: 7.3.7
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- --
- -- Database: `atrium`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `clients`
- --
- CREATE TABLE `clients` (
- `id` bigint(20) UNSIGNED NOT NULL,
- `order` bigint(20) NOT NULL,
- `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
- `logo` 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 `clients`
- --
- INSERT INTO `clients` (`id`, `order`, `name`, `logo`, `created_at`, `updated_at`) VALUES
- (1, 1, 'Testowy Hej!', 'Ays8mBmCzy4wgGEXGiY7xHGob.jpg', '2019-08-21 18:40:51', '2019-08-21 18:44:04'),
- (2, 2, 'Drugi :)', 'wpRKzpkfSPmac05ZTVM5gTHd7.jpg', '2019-08-21 18:43:36', '2019-08-21 18:44:04');
- -- --------------------------------------------------------
- --
- -- 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
- (5, '2014_10_12_000000_create_users_table', 1),
- (6, '2014_10_12_100000_create_password_resets_table', 1),
- (7, '2019_07_28_121239_create_photos', 1),
- (8, '2019_08_20_133024_create_offers', 1),
- (9, '2019_08_21_195201_create_clients', 2);
- -- --------------------------------------------------------
- --
- -- Table structure for table `offers`
- --
- CREATE TABLE `offers` (
- `id` bigint(20) UNSIGNED NOT NULL,
- `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
- `filename` 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 `offers`
- --
- INSERT INTO `offers` (`id`, `name`, `filename`, `created_at`, `updated_at`) VALUES
- (1, 'kartaDan', 'kartaDan.jpg', NULL, '2019-08-22 05:33:26'),
- (2, 'kartaWin', '', NULL, NULL),
- (3, 'kartaDrinkow', '', NULL, NULL),
- (4, 'imprezyOkolicznosciowe', '', NULL, NULL),
- (5, 'babyShower', '', NULL, NULL),
- (6, 'imprezyFirmowe', '', NULL, NULL),
- (7, 'serwisKawowy', '', NULL, NULL),
- (8, 'luncheKolacje', '', NULL, NULL),
- (9, 'wynajemSali', '', NULL, NULL);
- -- --------------------------------------------------------
- --
- -- 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 `photos`
- --
- CREATE TABLE `photos` (
- `id` bigint(20) UNSIGNED NOT NULL,
- `order` bigint(20) NOT NULL,
- `filename` 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;
- -- --------------------------------------------------------
- --
- -- 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;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `clients`
- --
- ALTER TABLE `clients`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `migrations`
- --
- ALTER TABLE `migrations`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `offers`
- --
- ALTER TABLE `offers`
- ADD PRIMARY KEY (`id`);
- --
- -- Indexes for table `password_resets`
- --
- ALTER TABLE `password_resets`
- ADD KEY `password_resets_email_index` (`email`);
- --
- -- Indexes for table `photos`
- --
- ALTER TABLE `photos`
- 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 `clients`
- --
- ALTER TABLE `clients`
- MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
- --
- -- AUTO_INCREMENT for table `migrations`
- --
- ALTER TABLE `migrations`
- MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
- --
- -- AUTO_INCREMENT for table `offers`
- --
- ALTER TABLE `offers`
- MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
- --
- -- AUTO_INCREMENT for table `photos`
- --
- ALTER TABLE `photos`
- MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `users`
- --
- ALTER TABLE `users`
- MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement