Raizekas

Untitled

Apr 27th, 2021
40
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 5.0.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: 127.0.0.1:3306
  6. -- Generation Time: Apr 27, 2021 at 09:43 AM
  7. -- Server version: 5.7.31
  8. -- PHP Version: 7.3.21
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. START TRANSACTION;
  12. SET time_zone = "+00:00";
  13.  
  14.  
  15. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  16. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  17. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  18. /*!40101 SET NAMES utf8mb4 */;
  19.  
  20. --
  21. -- Database: `testuotojai_antra_pamoka`
  22. --
  23.  
  24. -- --------------------------------------------------------
  25.  
  26. --
  27. -- Table structure for table `preke`
  28. --
  29.  
  30. DROP TABLE IF EXISTS `preke`;
  31. CREATE TABLE IF NOT EXISTS `preke` (
  32. `id` smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT,
  33. `pav` varchar(40) COLLATE utf8_lithuanian_ci NOT NULL,
  34. `kaina` decimal(5,2) UNSIGNED NOT NULL,
  35. `kiekis` smallint(5) UNSIGNED NOT NULL,
  36. PRIMARY KEY (`id`)
  37. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;
  38.  
  39. --
  40. -- Dumping data for table `preke`
  41. --
  42.  
  43. INSERT INTO `preke` (`id`, `pav`, `kaina`, `kiekis`) VALUES
  44. (1, 'Kėdė', '19.99', 4),
  45. (2, 'Stalas', '149.99', 8),
  46. (3, 'Laikrodis', '43.99', 6),
  47. (4, 'Veidrodis', '19.99', 3),
  48. (5, 'Laikrodis', '23.99', 6);
  49. COMMIT;
  50.  
  51. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  52. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  53. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  54.  
RAW Paste Data