· 9 years ago · Dec 02, 2016, 03:54 PM
1SET FOREIGN_KEY_CHECKS=0;
2ALTER TABLE users ADD advent date
3DROP TABLE IF EXISTS `advent_gifts`;
4DROP TABLE IF EXISTS `advent_used`;
5-- ----------------------------
6-- Table structure for advent
7-- ----------------------------
8DROP TABLE IF EXISTS `advent`;
9CREATE TABLE `advent` (
10 `id` int(255) NOT NULL AUTO_INCREMENT,
11 `value` varchar(255) NOT NULL DEFAULT '',
12 `type` varchar(255) NOT NULL DEFAULT '',
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
15
16-- ----------------------------
17-- Records of advent
18-- ----------------------------
19INSERT INTO `advent` VALUES ('1', '1250', 'credits');
20INSERT INTO `advent` VALUES ('2', '2500', 'duckets');
21SET FOREIGN_KEY_CHECKS=1;