8JHWxwD4

1-- phpMyAdmin SQL Dump
2-- version 4.4.15.9
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 21, 2018 at 03:34 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 `Аптека`
27--
28
29CREATE TABLE IF NOT EXISTS `Аптека` (
30  `Категория` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
31  `Название товара` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
32  `Единица измерения` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
33  `Цена` float NOT NULL,
34  `Упаковка` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
35  `Срок реализации` date NOT NULL,
36  `Количество` float NOT NULL
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39--
40-- Dumping data for table `Аптека`
41--
42
43INSERT INTO `Аптека` (`Категория`, `Название товара`, `Единица измерения`, `Цена`, `Упаковка`, `Срок реализации`, `Количество`) VALUES
44('????????? ?', '??????-???? ???', '0', 530, '????????', '2001-05-20', 30),
45('????????? ?', '??????-???? ?????? ????', '0', 530, '????????', '2019-04-19', 30),
46('Категория А', 'Мульти-табс Иммуно плюс', '0', 530, 'Таблетки', '2019-08-08', 30);
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `Store`
52--
53
54CREATE TABLE IF NOT EXISTS `Store` (
55  `PregnancyСategory` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
56  `Title` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
57  `Unit` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
58  `Price` float NOT NULL,
59  `UnitPackage` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
60  `ExpirationDate` date NOT NULL,
61  `Amount` float NOT NULL
62) ENGINE=InnoDB DEFAULT CHARSET=latin1;
63
64--
65-- Dumping data for table `Store`
66--
67
68INSERT INTO `Store` (`PregnancyСategory`, `Title`, `Unit`, `Price`, `UnitPackage`, `ExpirationDate`, `Amount`) VALUES
69('D', 'Achromycin V', 'mg', 49.99, 'Capsules', '2019-07-18', 250),
70('C', 'Amoxicillin', 'mg', 33.6, 'Tablets', '2019-11-18', 250),
71('A', 'Liquid Vitamin D3 5000 IU', 'oz', 10.99, 'Liquid', '2019-10-04', 2),
72('C', 'Loperamide ', 'mg', 10.45, 'Tablets', '2020-06-18', 6),
73('A', 'NOW Foods Vitamin A', 'lb', 3.8, 'Softgels', '2019-09-13', 100),
74('A', 'Nature''s Way Vitamin A', 'lb', 4.17, 'Softgels', '2019-08-03', 100),
75('D', 'Paroxetine ', 'mg', 133.74, 'Tablets', '2019-08-18', 40),
76('D', 'Phenytoin', 'mg', 27, 'Tablets', '2019-12-18', 50),
77('C', 'Rimactane-rifampicin', 'mg', 35, 'Tablets', '2019-08-18', 150),
78('A', 'Solgar Dry Vitamin A', 'lb', 7.05, 'Tablets', '2019-08-09', 100),
79('X', 'Temazepam ', 'mg', 31.5, 'Capsules', '2019-08-18', 100),
80('C', 'Theophylline', 'mg', 40.55, 'Tablets', '2019-11-18', 400),
81('B', 'Thyroxine ', 'mg', 657.52, 'Tablet', '2020-08-01', 5),
82('A', 'Vitacost Biotin', 'lb', 5.59, 'Capsules', '2019-07-04', 120),
83('A', 'Vitamin D3 5000 IU', 'mg', 15.99, 'Softgels', '2019-10-04', 100);
84
85--
86-- Indexes for dumped tables
87--
88
89--
90-- Indexes for table `Аптека`
91--
92ALTER TABLE `Аптека`
93  ADD PRIMARY KEY (`Название товара`);
94
95--
96-- Indexes for table `Store`
97--
98ALTER TABLE `Store`
99  ADD PRIMARY KEY (`Title`);
100--
101-- Database: `Сотовые телефоны`
102--
103
104/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
105/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
106/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;