· 8 years ago · Dec 01, 2017, 10:00 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for `character_cp_weekcap`
5-- ----------------------------
6DROP TABLE IF EXISTS `character_cp_weekcap`;
7CREATE TABLE `character_cp_weekcap` (
8 `guid` int(10) unsigned NOT NULL default '0',
9 `source` tinyint(3) unsigned NOT NULL default '0',
10 `maxWeekRating` smallint(5) unsigned NOT NULL default '0',
11 `weekCap` smallint(5) unsigned NOT NULL default '0',
12 PRIMARY KEY (`guid`,`source`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15-- ----------------------------
16-- Records of character_cp_weekcap
17-- ----------------------------
18INSERT INTO `character_cp_weekcap` VALUES ('1', '0', '0', '1350');
19INSERT INTO `character_cp_weekcap` VALUES ('1', '1', '0', '1649');