{"id":914,"date":"2010-04-27T00:46:14","date_gmt":"2010-04-26T15:46:14","guid":{"rendered":"http:\/\/www.kazu.tv\/blog\/?p=914"},"modified":"2010-04-27T00:46:14","modified_gmt":"2010-04-26T15:46:14","slug":"mysql_5","status":"publish","type":"post","link":"https:\/\/kazu.tv\/blog\/2010\/04\/27\/mysql_5\/","title":{"rendered":"MySQL\u3067\u5916\u90e8\u30ad\u30fc\u3092\u4ed8\u3051\u308b\u6642\u306b\u30a8\u30e9\u30fc"},"content":{"rendered":"<p>symfony\u3067schema.yml\u306b\u3054\u306b\u3087\u3054\u306b\u3087\u66f8\u3044\u3066\u3044\u3056\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\uff01\u3068\u601d\u3063\u305f\u3089\u4ee5\u4e0b\u306e\u30a8\u30e9\u30fc\u3002<\/p>\n<pre class=\"brush: plain\">\nSQLSTATE[HY000]: General error: 1005 Can't create table 'dbname.#sql-192c_1a6' (errno: 150). Failing Query: &quot;ALTER TABLE table1 ADD CONSTRAINT table1_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id)&quot;. Failing Query: ALTER TABLE table1 ADD CONSTRAINT domain_user_id_sf_guard_user_id FOREIGN KEY (user_id) REFERENCES sf_guard_user(id)<\/pre>\n<p>\u7d50\u8ad6\uff1a\u539f\u56e0\u306f\u5916\u90e8\u30ad\u30fc\u3092\u4ed8\u3051\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u3068\u53c2\u7167\u5148\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u578b\u304c\u3042\u3063\u3066\u3044\u306a\u3044\u3053\u3068\u3002<\/p>\n<p><!--more--><\/p>\n<p>\u3053\u308c\u3001\u666e\u901a\u306bDDL\u3092\u66f8\u3044\u3066\u3044\u308c\u3070\u6ec5\u591a\u306b\u767a\u751f\u3057\u306a\u3044\u3068\u601d\u3046\u3051\u3069\u3001\u4eca\u56de\u306e\u3088\u3046\u306bOR\u30de\u30c3\u30d1\u30fc\uff08\u3053\u3053\u3067\u306fDoctrine\uff09\u306b\u4f5c\u6210\u3055\u305b\u308b\u5834\u5408\u3001OR\u30de\u30c3\u30d1\u30fc\u3067\u306e\u578b\u540d\u3068DBMS\u3067\u306e\u578b\u540d\u306e\u5bfe\u5fdc\u304c\u3061\u3083\u3093\u3068\u3057\u3066\u306a\u3044\u3068\u8d77\u3053\u308b\u304b\u3082\u3002<\/p>\n<p>\u5177\u4f53\u7684\u306b\u8a00\u3046\u3068\u3001schema.yml\u3067integer\u3068\u8a18\u8f09\u3059\u308b\u3068\u3001MySQL\u306ebigint\u3067\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u4f5c\u6210\u3055\u308c\u308b\u3002integer(4)\u3068\u3059\u308c\u3070MySQL\u3067\u3082integer\u306b\u306a\u308b\u3002\u5206\u304b\u308a\u306b\u304f\u3044\u30fb\u30fb\u30fb<\/p>\n","protected":false},"excerpt":{"rendered":"<p>symfony\u3067schema.yml\u306b\u3054\u306b\u3087\u3054\u306b\u3087\u66f8\u3044\u3066\u3044\u3056\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\uff01\u3068\u601d\u3063\u305f\u3089\u4ee5\u4e0b\u306e\u30a8\u30e9\u30fc\u3002 SQLSTATE[HY000]: General error: 1005 Can&#8217;t create table &#8216;dbn&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15],"tags":[683,617,684,178,442,180],"class_list":["post-914","post","type-post","status-publish","format-standard","hentry","category-15","tag-bigint","tag-error-1005","tag-integer","tag-mysql","tag-symfony","tag-180"],"_links":{"self":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts\/914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/comments?post=914"}],"version-history":[{"count":0,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/posts\/914\/revisions"}],"wp:attachment":[{"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kazu.tv\/blog\/wp-json\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}