steambot-host/steam-bot.sql at master · gridmaniac/steambot-host · 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
/*
Navicat MySQL Data Transfer

Source Server         : main
Source Server Version : 50525
Source Host           : localhost:3306
Source Database       : steam-bot

Target Server Type    : MYSQL
Target Server Version : 50525
File Encoding         : 65001

Date: 2017-08-16 10:59:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `status` text,
  `timestamp` datetime DEFAULT NULL,
  `botAccountName` text,
  `message` text CHARACTER SET utf8,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of log
-- ----------------------------

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `friendState` int(11) DEFAULT NULL,
  `steamId` text,
  `chatState` int(11) DEFAULT NULL,
  `groupState` int(11) DEFAULT NULL,
  `botAccountName` text,
  `lastInvitationDate` bigint(11) DEFAULT NULL,
  `sendThanksState` tinyint(255) DEFAULT NULL,
  `groupId` text,
  `giftState` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of users
-- ----------------------------