· 7 years ago · Dec 17, 2018, 03:40 PM
1Executing SQL script in server
2
3ERROR: Error 1005: Can't create table 'mctracker.mct_servers' (errno: 150)
4
5
6
7
8
9CREATE TABLE IF NOT EXISTS `mctracker`.`mct_servers` (
10
11 `id` INT(11) NOT NULL AUTO_INCREMENT ,
12
13 `name` VARCHAR(128) NULL ,
14
15 `ownerid` INT(11) NULL DEFAULT NULL ,
16
17 `slots` INT(11) NULL DEFAULT NULL ,
18
19 `dateadded` DATETIME NULL DEFAULT NULL ,
20
21 `lastchecked` DATETIME NULL DEFAULT NULL ,
22
23 `lastplayers` INT(11) NULL DEFAULT NULL ,
24
25 `vup` INT(11) NULL DEFAULT NULL ,
26
27 `vdown` INT(11) NULL DEFAULT NULL ,
28
29 `voverall` INT(11) NULL DEFAULT NULL ,
30
31 `sip` VARCHAR(20) NULL ,
32
33 `sport` INT NULL ,
34
35 `enabled` TINYINT NULL ,
36
37 PRIMARY KEY (`id`) ,
38
39 UNIQUE INDEX `id_UNIQUE` (`id` ASC) ,
40
41 UNIQUE INDEX `name_UNIQUE` (`name` ASC) ,
42
43 UNIQUE INDEX `ownerid_UNIQUE` (`ownerid` ASC) ,
44
45 UNIQUE INDEX `slots_UNIQUE` (`slots` ASC) ,
46
47 UNIQUE INDEX `dateadded_UNIQUE` (`dateadded` ASC) ,
48
49 UNIQUE INDEX `lastchecked_UNIQUE` (`lastchecked` ASC) ,
50
51 UNIQUE INDEX `lastplayers_UNIQUE` (`lastplayers` ASC) ,
52
53 UNIQUE INDEX `sport_UNIQUE` (`sport` ASC) ,
54
55 UNIQUE INDEX `enabled_UNIQUE` (`enabled` ASC) ,
56
57 UNIQUE INDEX `sip_UNIQUE` (`sip` ASC) ,
58
59 UNIQUE INDEX `voverall_UNIQUE` (`voverall` ASC) ,
60
61 UNIQUE INDEX `vdown_UNIQUE` (`vdown` ASC) ,
62
63 UNIQUE INDEX `vup_UNIQUE` (`vup` ASC) ,
64
65 CONSTRAINT `fk_mct_servers_mct_sponsored_servers1`
66
67 FOREIGN KEY (`id` )
68
69 REFERENCES `mctracker`.`mct_sponsored_servers` (`sid` )
70
71 ON DELETE NO ACTION
72
73 ON UPDATE NO ACTION)
74
75ENGINE = InnoDB
76
77DEFAULT CHARACTER SET = latin1
78
79COMMENT = 'MCServer Tracker Server list'
80
81
82
83SQL script execution finished: statements: 8 succeeded, 1 failed