· 9 years ago · Dec 01, 2016, 08:56 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for advent
5-- ----------------------------
6DROP TABLE IF EXISTS `advent`;
7CREATE TABLE `advent` (
8 `day` varchar(2) NOT NULL,
9 `value` int(255) NOT NULL,
10 `type` varchar(255) NOT NULL,
11 PRIMARY KEY (`day`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13
14-- ----------------------------
15-- Records of advent
16-- ----------------------------
17INSERT INTO `advent` VALUES ('01', '10', 'vip_points');
18
19-- ----------------------------
20-- Table structure for advent_used
21-- ----------------------------
22DROP TABLE IF EXISTS `advent_used`;
23CREATE TABLE `advent_used` (
24 `day` varchar(255) NOT NULL,
25 `user_id` int(255) NOT NULL
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- ----------------------------
29-- Records of advent_used
30-- ----------------------------
31SET FOREIGN_KEY_CHECKS=1;