laravel migratie 创建外键的时候报错:
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `classname` add constraint `classname_classname_id_foreign` foreign key (`classname_id`) references `classnamev2` (`id`))
表名都是测试用的。看了一下,原来是因为classnamev2用了$table->id()来创建主键。所以在创建外键的时候,必须要字段格式完全一致,关联字段必须得unsignedBigInteger()才OK。
默认的主键是无符号大整型,仅仅记录一下。用migrate的时候不能弄混了。
mac下运行ioreg -rn AppleSmartBattery | grep -i capacity
可以得到:
XML/HTML代码
- "AppleRawCurrentCapacity" = 6392
-
- "AppleRawMaxCapacity" = 6452
-
- "MaxCapacity" = 6452
-
- "CurrentCapacity" = 6392
-
- "LegacyBatteryInfo" = {"Amperage"=18446744073709551590,"Flags"=5,"Capacity"=6452,"Current"=6392,"Voltage"=12923,"Cycle Count"=94}
-
- "DesignCapacity" = 7336
-
- "BatteryData" = {"StateOfCharge"=100,"PMUConfigured"=0,"Voltage"=12930,"QmaxCell1"=7165,"AdapterPower"=1109165984,"SystemPower"=1108102207,"ResScale"=220,"QmaxCell2"=7161,"QmaxCell0"=7192,"CycleCount"=94,"DesignCapacity"=7336}
设计容量 7336,现在只有 6392了。。。2年不到,掉了1000了。。。不知道还能再战多久