3G0uRzt7

1-- phpMyAdmin SQL Dump
2-- version 4.0.10.6
3-- http://www.phpmyadmin.net
4--
5-- Хост: 127.0.0.1:3306
6-- Время создания: Янв 27 2018 г., 19:16
7-- Версия сервера: 5.1.73-community-log
8-- Версия PHP: 5.3.29
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- База данных: `part_crm_central`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Структура таблицы `payments`
21--
22
23CREATE TABLE IF NOT EXISTS `payments` (
24  `id` int(11) NOT NULL AUTO_INCREMENT,
25  `sum` float NOT NULL,
26  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
27  `crm_id` int(11) NOT NULL,
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
30
31-- --------------------------------------------------------
32
33--
34-- Структура таблицы `supports`
35--
36
37CREATE TABLE IF NOT EXISTS `supports` (
38  `id` int(11) NOT NULL AUTO_INCREMENT,
39  `message` text NOT NULL,
40  `link` text NOT NULL,
41  `screen_url` text NOT NULL,
42  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
43  `crm_id` int(11) NOT NULL,
44  PRIMARY KEY (`id`)
45) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
46
47-- --------------------------------------------------------
48
49--
50-- Структура таблицы `tickets`
51--
52
53CREATE TABLE IF NOT EXISTS `tickets` (
54  `id` int(11) NOT NULL AUTO_INCREMENT,
55  `domain` varchar(9) NOT NULL,
56  `login` varchar(5) NOT NULL,
57  `password` varchar(6) NOT NULL,
58  `email` varchar(60) DEFAULT NULL,
59  `name` varchar(60) DEFAULT NULL,
60  `phone` bigint(20) DEFAULT NULL,
61  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
62  `used` set('0','1') NOT NULL DEFAULT '0',
63  `bought` set('0','1') NOT NULL DEFAULT '0',
64  `till_bought_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
65  `unsubscribed` tinyint(1) DEFAULT NULL,
66  `hash` varchar(100) NOT NULL,
67  `update_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
68  PRIMARY KEY (`id`)
69) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=137 ;