crawlerhelper/dbstructure.sql at master · kotkovdev/crawlerhelper · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
-- Adminer 4.7.0 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `crw_instances`;
CREATE TABLE `crw_instances` (
  `id` int(6) DEFAULT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `path` longtext NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_exists` int(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `crw_queue`;
CREATE TABLE `crw_queue` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `url` longtext,
  `type` int(1) DEFAULT NULL,
  `settings` text,
  `command` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `instance_id` int(6) DEFAULT NULL,
  `status` int(3) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `crw_settings`;
CREATE TABLE `crw_settings` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `settings` text NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `crw_users`;
CREATE TABLE `crw_users` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `reset_hash` varchar(255) NOT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2019-01-01 22:01:22