Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 25th, 2012  |  syntax: SQL  |  size: 2.41 KB  |  hits: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.4.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Počítač: 127.0.0.1
  6. -- Vygenerováno: Pát 25. kvě 2012, 10:43
  7. -- Verze MySQL: 5.5.20
  8. -- Verze PHP: 5.3.9
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Databáze: `dochazka`
  21. --
  22. CREATE DATABASE `dochazka` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  23. USE `dochazka`;
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Struktura tabulky `csv`
  29. --
  30.  
  31. CREATE TABLE IF NOT EXISTS `csv` (
  32.   `id` INT(11) NOT NULL,
  33.   `jmeno` VARCHAR(100) NOT NULL,
  34.   `prijmeni` VARCHAR(100) NOT NULL,
  35.   `stredisko` VARCHAR(100) NOT NULL,
  36.   `datum` DATE NOT NULL,
  37.   `cas` VARCHAR(100) NOT NULL,
  38.   `udalost` VARCHAR(100) NOT NULL
  39. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  40.  
  41. --
  42. -- Vypisuji data pro tabulku `csv`
  43. --
  44.  
  45. INSERT INTO `csv` (`id`, `jmeno`, `prijmeni`, `stredisko`, `datum`, `cas`, `udalost`) VALUES
  46. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prichod'),
  47. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prichod'),
  48. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'odchod'),
  49. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prerus'),
  50. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'obed'),
  51. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'sluzba'),
  52. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prichod'),
  53. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'odchod'),
  54. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prerus'),
  55. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'obed'),
  56. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'sluzba'),
  57. (45645, 'lukas', 'mrtvy', '150', '2015-02-20', '16:24', 'prichod'),
  58. (45645, 'asd', 'mrtvy', '150', '2015-02-20', '16:24', 'odchod'),
  59. (45645, 'sadas', 'mrtvy', '150', '2015-02-20', '16:24', 'prerus'),
  60. (45645, 'lukas', 'asd', '150', '2015-02-20', '16:24', 'obed'),
  61. (45645, 'lukas', 'asdasd', '150', '2015-02-20', '16:24', 'sluzba');
  62.  
  63. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  64. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  65. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
create a new version of this paste RAW Paste Data