Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.5.1
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Czas generowania: 27 Paź 2017, 11:14
- -- Wersja serwera: 10.1.10-MariaDB
- -- Wersja PHP: 5.6.15
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- 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 */;
- --
- -- Baza danych: `ksiegarnia_internetowa`
- --
- -- --------------------------------------------------------
- --
- -- Struktura tabeli dla tabeli `klient`
- --
- CREATE TABLE `klient` (
- `id_klienta` int(11) DEFAULT NULL,
- `nazwisko` varchar(20) DEFAULT NULL,
- `imie` varchar(20) DEFAULT NULL,
- `kod_pocztowy` varchar(6) DEFAULT NULL,
- `miejscowosc` varchar(40) DEFAULT NULL,
- `ulica` varchar(40) DEFAULT NULL,
- `nr_domu` varchar(7) DEFAULT NULL,
- `PESEL` char(11) NOT NULL,
- `telefon` varchar(7) DEFAULT NULL,
- `adres_e_mail` varchar(55) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Zrzut danych tabeli `klient`
- --
- INSERT INTO `klient` (`id_klienta`, `nazwisko`, `imie`, `kod_pocztowy`, `miejscowosc`, `ulica`, `nr_domu`, `PESEL`, `telefon`, `adres_e_mail`) VALUES
- (1, 'Kowalski', 'Jan', '09-100', 'Plonsk', 'Kocia', '17a', '12345678923', '55-66-8', 'd1@gmail.com'),
- (2, 'Nowak', 'Adam', '87-100', 'Warszawa', 'Mysia', '23', '98765432198', '24367', 'd2@gmail.com'),
- (NULL, 'Anna', 'Lisek', '34-100', 'Wadowice', 'Lwowska', '11', '95031203267', '9367894', 'ania@gmail.com'),
- (NULL, 'adasad', 'adadas', '213', '', '', '', '', '', '');
- /*!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