Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
178
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.3.11
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Hostiteľ: 127.0.0.1
  6. -- Čas generovania: Št 19.Jan 2017, 11:41
  7. -- Verzia serveru: 5.6.24
  8. -- Verzia PHP: 5.6.8
  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áza: `test`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Štruktúra tabuľky pre tabuľku `vozidlo`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `vozidlo` (
  30. `id` int(11) NOT NULL,
  31. `nazov` varchar(40) NOT NULL,
  32. `dveri` int(11) NOT NULL,
  33. `spotreba` float NOT NULL
  34. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  35.  
  36. --
  37. -- Kľúče pre exportované tabuľky
  38. --
  39.  
  40. --
  41. -- Indexy pre tabuľku `vozidlo`
  42. --
  43. ALTER TABLE `vozidlo`
  44. ADD PRIMARY KEY (`id`);
  45.  
  46. --
  47. -- AUTO_INCREMENT pre exportované tabuľky
  48. --
  49.  
  50. --
  51. -- AUTO_INCREMENT pre tabuľku `vozidlo`
  52. --
  53. ALTER TABLE `vozidlo`
  54. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  55. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  56. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  57. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement