TelegramLenta4Bot/base.sql at master · codels/TelegramLenta4Bot · 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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `bots`
-- ----------------------------
DROP TABLE IF EXISTS `bots`;
CREATE TABLE `bots` (
  `id` bigint(255) unsigned NOT NULL AUTO_INCREMENT,
  `bot_name` varchar(255) NOT NULL,
  `token` text NOT NULL,
  `last_update_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bots
-- ----------------------------

-- ----------------------------
-- Table structure for `resources`
-- ----------------------------
DROP TABLE IF EXISTS `resources`;
CREATE TABLE `resources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscribe_type_id` tinyint(4) NOT NULL,
  `subscribe_name` varchar(255) NOT NULL,
  `subscribe_id` varchar(255) DEFAULT NULL,
  `time_last_monitoring` timestamp NULL DEFAULT NULL,
  `last_monitoring_info` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of resources
-- ----------------------------
INSERT INTO `resources` VALUES ('1', '1', 'Lenta4', '29534144', null, '');

-- ----------------------------
-- Table structure for `subscribe_types`
-- ----------------------------
DROP TABLE IF EXISTS `subscribe_types`;
CREATE TABLE `subscribe_types` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `tags` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of subscribe_types
-- ----------------------------
INSERT INTO `subscribe_types` VALUES ('1', 'VK Wall Group', 'vk,vk_wall,vk_group');

-- ----------------------------
-- Table structure for `subscribers`
-- ----------------------------
DROP TABLE IF EXISTS `subscribers`;
CREATE TABLE `subscribers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `chat_id` varchar(255) NOT NULL,
  `resource_id` bigint(20) unsigned NOT NULL,
  `is_display_preview` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of subscribers
-- ----------------------------

ALTER TABLE `resources`
ADD COLUMN `bot_id`  bigint UNSIGNED NOT NULL DEFAULT 0 AFTER `id`;

UPDATE `resources` SET `bot_id`='1' WHERE (`id`='1');

ALTER TABLE `resources`
CHANGE COLUMN `subscribe_name` `name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `subscribe_type_id`,
CHANGE COLUMN `subscribe_id` `id_in_resource`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `name`,
ADD COLUMN `name_in_resource`  varchar(255) NULL AFTER `id_in_resource`;

UPDATE `resources` SET `name_in_resource`='oldlentach' WHERE (`id`='1');