ViZGWDcM

1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 25, 2018 at 08:32 AM
7-- Server version: 5.6.37
8-- PHP Version: 5.6.31
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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 utf8mb4 */;
18
19--
20-- Database: `Аптека`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Store`
27--
28
29CREATE TABLE IF NOT EXISTS `Store` (
30  `PregnancyСategory` enum('a','b','c','d','x') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
31  `Title` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
32  `Unit` enum('mg','lb','oz','') CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
33  `Price` float NOT NULL,
34  `UnitPackage` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
35  `ExpirationDate` date NOT NULL,
36  `Amount` float NOT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `Store`
41--
42
43INSERT INTO `Store` (`PregnancyСategory`, `Title`, `Unit`, `Price`, `UnitPackage`, `ExpirationDate`, `Amount`) VALUES
44('x', 'Achromycin V', 'mg', 49.99, 'Capsules', '2019-07-18', 250),
45('c', 'Amoxicillin', 'mg', 33.6, 'Tablets', '2019-11-18', 250),
46('a', 'Liquid Vitamin D3 5000 IU', 'oz', 10.99, 'Liquid', '2019-10-04', 2),
47('b', 'Loperamide ', 'mg', 10.45, 'Tablets', '2020-06-18', 6),
48('a', 'NOW Foods Vitamin A', 'lb', 3.8, 'Softgels', '2019-09-13', 100),
49('d', 'Nature''s Way Vitamin A', 'lb', 4.17, 'Softgels', '2019-08-03', 100),
50('c', 'Paroxetine ', 'mg', 133.74, 'Tablets', '2019-08-18', 40),
51('c', 'Phenytoin', 'mg', 27, 'Tablets', '2019-12-18', 50),
52('b', 'Rimactane-rifampicin', 'mg', 35, 'Tablets', '2019-08-18', 150),
53('a', 'Solgar Dry Vitamin A', 'lb', 7.05, 'Tablets', '2019-08-09', 100),
54('b', 'Temazepam ', 'mg', 31.5, 'Capsules', '2019-08-18', 100),
55('a', 'Theophylline', 'mg', 40.55, 'Tablets', '2019-11-18', 400),
56('a', 'Thyroxine ', 'mg', 657.52, 'Tablet', '2020-08-01', 5),
57('a', 'Vitacost Biotin', 'lb', 5.59, 'Capsules', '2019-07-04', 120),
58('a', 'Vitamin D3 5000 IU', 'mg', 15.99, 'Softgels', '2019-10-04', 100);
59
60--
61-- Indexes for dumped tables
62--
63
64--
65-- Indexes for table `Store`
66--
67ALTER TABLE `Store`
68  ADD PRIMARY KEY (`Title`);
69
70/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
71/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
72/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;