tweetnest\u3067\u3064\u3076\u3084\u304d\u3092\u30a2\u30fc\u30ab\u30a4\u30d6\u3057\u3066\u3044\u305f\u306e\u3060\u304c\u3001\u9577\u3044\u3064\u3076\u3084\u304d\u306e\u30a2\u30fc\u30ab\u30a4\u30d6\u304c\u9014\u4e2d\u3067\u5207\u308c\u3066\u3044\u305f\u3002\u3044\u308d\u3044\u308d\u3068\u8abf\u3079\u3066\u307f\u308b\u3068\u3001\u3042\u308b\u4e00\u5b9a\u306e\u6587\u5b57\u6570\u3092\u8d85\u3048\u308b\u3068\u3001\u9014\u4e2d\u3067\u304d\u308c\u305f\u308a\u5316\u3051\u305f\u308a\u3057\u3066\u3044\u305f\u3002<\/p>\n\n\n\n
\u539f\u56e0\u3092\u63a2\u3063\u3066\u307f\u308b\u3068\u3001tweetnest\u3067\u3064\u3076\u3084\u304d\u3092\u683c\u7d0d\u3057\u3066\u3044\u308bDB\u306e\u7d61\u3080\u304cvarchar(255)\u3067\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u305f\u3002varchar(255)\u3060\u3068\u3001\u65e5\u672c\u8a9e\u3067140\u6587\u5b57\u3082\u683c\u7d0d\u3067\u304d\u306a\u3044\u3002\u305d\u306e\u305f\u3081\u3001\u9014\u4e2d\u3067\u30c7\u30fc\u30bf\u304c\u5207\u308c\u3066\u3044\u305f\u3088\u3046\u3067\u3042\u308b\u3002\u4ed6\u306e\u30ab\u30e9\u30e0\u306e\u8a2d\u5b9a\u3092\u898b\u3066\u307f\u308b\u3068\u3001text\u578b\u3067\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u3068\u3053\u308d\u3082\u3042\u308b\u306e\u3067\u3001\u5c11\u3005\u30a2\u30d0\u30a6\u30c8\u3060\u304c\u3001\u5bfe\u8c61\u306e\u30ab\u30e9\u30e0\u3092text\u578b\u306b\u5909\u63db\u3057\u3066\u307f\u305f\u3002\u5909\u63db\u306b\u4f7f\u3063\u305fSQL\u6587\u306f\u4ee5\u4e0b\u3002<\/p>\n\n\n\n
\nmysql> alter table tn_tweets modify text text not null;\n<\/pre>\n\n\n\n\u3053\u308c\u3067\u62e1\u5f35\u306f\u7d42\u4e86\u3002\u6b21\u306e\u3064\u3076\u3084\u304d\u53d6\u5f97\u304b\u3089\u3001\u65e5\u672c\u8a9e\u3067140\u6587\u5b57\u3042\u3063\u3066\u3082\u3061\u3083\u3093\u3068\u30a2\u30fc\u30ab\u30a4\u30d6\u3055\u308c\u308b\u3002<\/p>\n\n\n\n
\u304a\u307e\u3051\u3002
\u901a\u3057\u3067\u4f5c\u696d\u3092\u3059\u308b\u3068\u3053\u3093\u306a\u611f\u3058\u3002<\/p>\n\n\n\n\nmysql> use tweetnest;\nmysql> desc tn_tweets;\n+--------------+---------------------+------+-----+---------+----------------+\n| Field | Type | Null | Key | Default | Extra |\n+--------------+---------------------+------+-----+---------+----------------+\n| id | int(10) unsigned | NO | PRI | NULL | auto_increment |\n| userid | int(10) unsigned | NO | | | |\n| tweetid | bigint(20) unsigned | NO | | | |\n| type | tinyint(4) | NO | | 0 | |\n| time | int(10) unsigned | NO | | | |\n| text | varchar(255) | NO | MUL | | |\n| source | varchar(255) | NO | | | |\n| favorite | tinyint(4) | NO | | 0 | |\n| extra | text | NO | | | |\n| coordinates | text | NO | | | |\n| geo | text | NO | | | |\n| place | text | NO | | | |\n| contributors | text | NO | | | |\n+--------------+---------------------+------+-----+---------+----------------+\n13 rows in set (0.07 sec)\n\nmysql> alter table tn_tweets modify text text not null;\nQuery OK, 1287 rows affected (0.28 sec)\nRecords: 1287 Duplicates: 0 Warnings: 0\n\nmysql> desc tn_tweets;\n+--------------+---------------------+------+-----+---------+----------------+\n| Field | Type | Null | Key | Default | Extra |\n+--------------+---------------------+------+-----+---------+----------------+\n| id | int(10) unsigned | NO | PRI | NULL | auto_increment |\n| userid | int(10) unsigned | NO | | | |\n| tweetid | bigint(20) unsigned | NO | | | |\n| type | tinyint(4) | NO | | 0 | |\n| time | int(10) unsigned | NO | | | |\n| text | text | NO | MUL | | |\n| source | varchar(255) | NO | | | |\n| favorite | tinyint(4) | NO | | 0 | |\n| extra | text | NO | | | |\n| coordinates | text | NO | | | |\n| geo | text | NO | | | |\n| place | text | NO | | | |\n| contributors | text | NO | | | |\n+--------------+---------------------+------+-----+---------+----------------+\n13 rows in set (0.00 sec)\n\nmysql>\n<\/pre>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
tweetnest\u3067\u3064\u3076\u3084\u304d\u3092\u30a2\u30fc\u30ab\u30a4\u30d6\u3057\u3066\u3044\u305f\u306e\u3060\u304c\u3001\u9577\u3044\u3064\u3076\u3084\u304d\u306e\u30a2\u30fc\u30ab\u30a4\u30d6\u304c\u9014\u4e2d\u3067\u5207\u308c\u3066\u3044\u305f\u3002\u3044\u308d\u3044\u308d\u3068\u8abf\u3079\u3066\u307f\u308b\u3068\u3001\u3042\u308b\u4e00\u5b9a\u306e\u6587\u5b57\u6570\u3092\u8d85\u3048\u308b\u3068\u3001\u9014\u4e2d\u3067\u304d\u308c\u305f\u308a\u5316\u3051\u305f\u308a\u3057\u3066\u3044\u305f\u3002 \u539f\u56e0\u3092\u63a2\u3063\u3066\u307f\u308b\u3068\u3001tweetne […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,9],"tags":[49],"class_list":["post-2157","post","type-post","status-publish","format-standard","hentry","category-diary","category-network","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/2157","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=2157"}],"version-history":[{"count":1,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/2157\/revisions"}],"predecessor-version":[{"id":2158,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/2157\/revisions\/2158"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=2157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=2157"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=2157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}