D44QecAe

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : jobyo
5Source Server Version : 50505
6Source Host           : localhost:3306
7Source Database       : jobyo
8
9Target Server Type    : MYSQL
10Target Server Version : 50505
11File Encoding         : 65001
12
13Date: 2016-11-23 18:27:03
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for logs_client_staff
20-- ----------------------------
21DROP TABLE IF EXISTS `logs_client_staff`;
22CREATE TABLE `logs_client_staff` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `user_id` int(11) NOT NULL DEFAULT '0',
25  `data_string` text NOT NULL,
26  `machine_id` varchar(75) NOT NULL DEFAULT '',
27  `timestamp` double NOT NULL DEFAULT '0',
28  PRIMARY KEY (`id`)
29) ENGINE=InnoDB AUTO_INCREMENT=66312 DEFAULT CHARSET=latin1;
30
31-- ----------------------------
32-- Table structure for logs_client_trade
33-- ----------------------------
34DROP TABLE IF EXISTS `logs_client_trade`;
35CREATE TABLE `logs_client_trade` (
36  `id` int(11) NOT NULL AUTO_INCREMENT,
37  `1id` int(11) DEFAULT '0',
38  `2id` int(11) DEFAULT '0',
39  `1items` text,
40  `2items` text,
41  `timestamp` char(20) DEFAULT '',
42  PRIMARY KEY (`id`)
43) ENGINE=InnoDB AUTO_INCREMENT=6802 DEFAULT CHARSET=latin1;
44
45-- ----------------------------
46-- Table structure for logs_cms_staff
47-- ----------------------------
48DROP TABLE IF EXISTS `logs_cms_staff`;
49CREATE TABLE `logs_cms_staff` (
50  `id` int(11) NOT NULL AUTO_INCREMENT,
51  `user_id` int(11) NOT NULL DEFAULT '0',
52  `target_id` int(11) NOT NULL DEFAULT '0',
53  `data` text NOT NULL,
54  `timestamp` int(11) NOT NULL DEFAULT '0',
55  `ip_address` char(20) NOT NULL DEFAULT '0',
56  PRIMARY KEY (`id`)
57) ENGINE=InnoDB AUTO_INCREMENT=1149 DEFAULT CHARSET=latin1;
58
59-- ----------------------------
60-- Table structure for logs_cms_users
61-- ----------------------------
62DROP TABLE IF EXISTS `logs_cms_users`;
63CREATE TABLE `logs_cms_users` (
64  `id` int(11) NOT NULL AUTO_INCREMENT,
65  `user_id` int(11) DEFAULT '0',
66  `page` varchar(15) DEFAULT '',
67  `timestamp` int(11) DEFAULT '0',
68  `extra_data` text,
69  `ip_address` char(20) DEFAULT '0',
70  `hostname` text,
71  PRIMARY KEY (`id`)
72) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
73
74-- ----------------------------
75-- Table structure for logs_client_namechange
76-- ----------------------------
77DROP TABLE IF EXISTS `logs_client_namechange`;
78CREATE TABLE `logs_client_namechange` (
79  `id` int(11) NOT NULL AUTO_INCREMENT,
80  `user_id` int(11) NOT NULL,
81  `new_name` varchar(50) NOT NULL DEFAULT '',
82  `old_name` varchar(50) NOT NULL DEFAULT '',
83  `timestamp` int(11) NOT NULL,
84  PRIMARY KEY (`id`)
85) ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=latin1;
86
87-- ----------------------------
88-- Table structure for logs_client_roomsales
89-- ----------------------------
90DROP TABLE IF EXISTS `logs_client_roomsales`;
91CREATE TABLE `logs_client_roomsales` (
92  `id` int(11) NOT NULL AUTO_INCREMENT,
93  `room_id` int(11) NOT NULL,
94  `room_seller` int(11) NOT NULL,
95  `room_buyer` int(11) NOT NULL,
96  `timestamp` int(11) NOT NULL,
97  PRIMARY KEY (`id`)
98) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
99
100-- ----------------------------
101-- Table structure for fuserights
102-- ----------------------------
103DROP TABLE IF EXISTS `fuserights`;
104CREATE TABLE `fuserights` (
105  `rank` int(11) unsigned NOT NULL,
106  `fuse` varchar(50) NOT NULL,
107  KEY `rank` (`rank`)
108) ENGINE=MyISAM DEFAULT CHARSET=latin1;