Jxsbb2Yk

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : Sync
5Source Server Version : 50717
6Source Host           : 144.217.94.197:3306
7Source Database       : sync
8
9Target Server Type    : MYSQL
10Target Server Version : 50717
11File Encoding         : 65001
12
13Date: 2016-12-26 10:01:42
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for daily_gift
20-- ----------------------------
21DROP TABLE IF EXISTS `daily_gift`;
22CREATE TABLE `daily_gift` (
23  `id` int(11) NOT NULL AUTO_INCREMENT,
24  `rare_id` varchar(255) DEFAULT NULL,
25  `rare_name` varchar(255) DEFAULT NULL,
26  `rare_img` varchar(255) DEFAULT NULL,
27  PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
29
30-- ----------------------------
31-- Records of daily_gift
32-- ----------------------------
33INSERT INTO `daily_gift` VALUES ('1', '72021', 'Suitcase', 'https://hydra-media.cursecdn.com/habbo.gamepedia.com/b/b3/CF_1500_suitcase.png');
34INSERT INTO `daily_gift` VALUES ('2', '758', 'Gold Bar', 'https://hydra-media.cursecdn.com/habbo.gamepedia.com/3/38/CF_50_goldbar.png');
35INSERT INTO `daily_gift` VALUES ('3', '5048', '25 Diamonds', 'https://hydra-media.cursecdn.com/habbo.gamepedia.com/f/fe/CF_diamond_250.png');
36INSERT INTO `daily_gift` VALUES ('4', '5049', '10 Diamonds', 'https://hydra-media.cursecdn.com/habbo.gamepedia.com/6/61/CF_diamond_100.png');
37
38ALTER TABLE `users` ADD LastDailyGift VARCHAR(255);
39ALTER TABLE `users` ADD LastUsedGift VARCHAR(255);