· 7 years ago · Feb 16, 2019, 01:40 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : _LOKAL
5Source Server Version : 50505
6Source Host : localhost:3306
7Source Database : _wordpress
8
9Target Server Type : MYSQL
10Target Server Version : 50505
11File Encoding : 65001
12
13Date: 2019-02-16 14:34:10
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `ecwp_hybridmessenger_chats_messages`
20-- ----------------------------
21DROP TABLE IF EXISTS `ecwp_hybridmessenger_chats_messages`;
22CREATE TABLE `ecwp_hybridmessenger_chats_messages` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `message_sender` varchar(255) NOT NULL,
25 `message_receiver` varchar(255) NOT NULL,
26 `message_content` varchar(255) NOT NULL,
27 `message_time` int(11) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=latin1;
30
31-- ----------------------------
32-- Records of ecwp_hybridmessenger_chats_messages
33-- ----------------------------
34
35-- ----------------------------
36-- Table structure for `ecwp_hybridmessenger_users`
37-- ----------------------------
38DROP TABLE IF EXISTS `ecwp_hybridmessenger_users`;
39CREATE TABLE `ecwp_hybridmessenger_users` (
40 `id` int(11) NOT NULL AUTO_INCREMENT,
41 `user_secret_hash` varchar(255) NOT NULL,
42 `user_status` enum('AWAY','BUSY','OFFLINE','ONLINE') NOT NULL DEFAULT 'ONLINE',
43 `user_last_activity` int(11) NOT NULL,
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
46
47-- ----------------------------
48-- Records of ecwp_hybridmessenger_users
49-- ----------------------------