uFCcwNUm

1-- Adminer 4.7.4 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `basket`;
11CREATE TABLE `basket` (
12  `u_id` varchar(30) DEFAULT NULL,
13  `i_id` varchar(45) DEFAULT NULL,
14  `c_id` varchar(45) DEFAULT NULL,
15  `count` int(11) DEFAULT NULL,
16  `price` float DEFAULT NULL,
17  `offer_id` int(10) DEFAULT NULL,
18  `border_id` int(10) DEFAULT NULL,
19  `name` varchar(100) DEFAULT NULL
20) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
21
22
23DROP TABLE IF EXISTS `orders`;
24CREATE TABLE `orders` (
25  `u_id` varchar(50) DEFAULT NULL,
26  `summ` varchar(45) DEFAULT NULL,
27  `dat` date DEFAULT NULL
28) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
29
30
31DROP TABLE IF EXISTS `pizza_options`;
32CREATE TABLE `pizza_options` (
33  `user_id` varchar(40) NOT NULL,
34  `product_id` int(11) NOT NULL,
35  `offer_id` int(11) NOT NULL,
36  `options` varchar(40) NOT NULL,
37  `price` varchar(5) NOT NULL
38) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
39
40
41DROP TABLE IF EXISTS `stat`;
42CREATE TABLE `stat` (
43  `id` varchar(50) NOT NULL,
44  `subscr` varchar(45) DEFAULT NULL,
45  `date_sub` datetime DEFAULT NULL,
46  `wasl` varchar(45) DEFAULT NULL,
47  `out_date` datetime DEFAULT NULL,
48  PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
50
51
52DROP TABLE IF EXISTS `users`;
53CREATE TABLE `users` (
54  `id` varchar(30) DEFAULT NULL,
55  `city` varchar(100) DEFAULT NULL,
56  `full_name` varchar(150) DEFAULT NULL,
57  `phone_number` varchar(45) DEFAULT NULL,
58  `context` varchar(100) DEFAULT NULL,
59  `p_id` varchar(45) DEFAULT NULL,
60  `c_id` varchar(45) DEFAULT NULL,
61  `address` varchar(45) DEFAULT '-',
62  `date` date DEFAULT NULL
63) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
64
65
66-- 2020-02-03 23:04:45