{
  "trx_id": "04f26205b717df2a70c295c891327aed26ae2dbc",
  "block": 89907119,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2024-10-29T16:45:57",
  "op": [
    "comment",
    {
      "parent_author": "iwaydi",
      "parent_permlink": "how-to-use-feature-dropping-and-rollback-with-migration-in-laravel",
      "author": "phernandez41",
      "permlink": "sm4mkk",
      "title": "",
      "body": "Using feature dropping and rollback with migration in Laravel is essential for managing database changes effectively. When working with an AWS migration partner, you can implement migrations seamlessly across your application. Start by creating a migration file using the Artisan command, specifying the changes needed. Use the down method to drop features or roll back changes, ensuring your database remains consistent. If an issue arises, executing the rollback command will revert the last migration. This practice not only aids in maintaining a stable environment but also enhances collaboration with your <a href=\"https://www.searce.com/\">aws migration partner</a> for smoother deployments.",
      "json_metadata": "{\"links\":[\"https://www.searce.com/\"],\"app\":\"steemit/0.2\"}"
    }
  ]
}

{
  "trx_id": "3b2f6cde1e196442ea7094b85f436e3bbfe52be9",
  "block": 44052736,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2020-06-07T19:59:33",
  "op": [
    "vote",
    {
      "voter": "my-shopseu",
      "author": "iwaydi",
      "permlink": "how-to-create-a-table-database-in-laravel-with-php-artisan-migration",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "1642ebc2d750e0e7c4c5b529e258ab3bd62787a1",
  "block": 36723824,
  "trx_in_block": 19,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-09-25T07:03:36",
  "op": [
    "vote",
    {
      "voter": "laciprian",
      "author": "iwaydi",
      "permlink": "how-to-create-a-table-database-in-laravel-with-php-artisan-migration",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "dfb654b603e71bff076214b762deaefa0c4e3d5f",
  "block": 35780449,
  "trx_in_block": 47,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-08-22T17:02:00",
  "op": [
    "transfer",
    {
      "from": "dtube",
      "to": "iwaydi",
      "amount": "0.001 STEEM",
      "memo": "Time is running out, claim your DTube account now before anyone else can! Login at https://d.tube"
    }
  ]
}

{
  "trx_id": "c237da9f88f7231fe109fdde3300dc222d67c04e",
  "block": 34003092,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-06-21T20:43:00",
  "op": [
    "comment",
    {
      "parent_author": "iwaydi",
      "parent_permlink": "how-to-use-routing-in-codeigniter",
      "author": "kalangaum",
      "permlink": "ptguvm",
      "title": "",
      "body": "Nice post man!\nJust posted a similar php routing solution using Flight PHP, check out on my profile!",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}

{
  "trx_id": "861f1802addab8e95430d88e80ed275d0cda3474",
  "block": 33940723,
  "trx_in_block": 6,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2019-06-19T16:41:21",
  "op": [
    "comment",
    {
      "parent_author": "iwaydi",
      "parent_permlink": "web-2018-2-6-17-31-49",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-iwaydi-20190619t164120000z",
      "title": "",
      "body": "Congratulations @iwaydi! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@iwaydi/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@iwaydi) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=iwaydi)_</sub>\n\n\n**Do not miss the last post from @steemitboard:**\n<table><tr><td><a href=\"https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed\"><img src=\"https://steemitimages.com/64x128/http://i.cubeupload.com/7CiQEO.png\"></a></td><td><a href=\"https://steemit.com/steemtoolbar/@steemitboard/steemtoolbar-update-display-bug-fixed\">SteemitBoard - Witness Update</a></td></tr><tr><td><a href=\"https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge\"><img src=\"https://steemitimages.com/64x128/https://cdn.steemitimages.com/DQmUphCGZFWgt6bJ1XTtunV7esnwy6bxnGqcLcHAV3NEqnQ/meetup-rocky-mountain.png\"></a></td><td><a href=\"https://steemit.com/steem/@steemitboard/do-not-miss-the-coming-rocky-mountain-steem-meetup-and-get-a-new-community-badge\">Do not miss the coming Rocky Mountain Steem Meetup and get a new community badge!</a></td></tr></table>\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 26806104,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 81,
  "timestamp": "2018-10-14T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "0.000003 VESTS",
      "deposited": "0.000 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 26604629,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 9,
  "timestamp": "2018-10-07T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.159 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 26403158,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 3,
  "timestamp": "2018-09-30T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.159 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 26201886,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 6,
  "timestamp": "2018-09-23T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.158 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 26016004,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 12,
  "timestamp": "2018-09-16T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.158 STEEM"
    }
  ]
}

{
  "trx_id": "7fb884ace3fd090ba70f9decd66b9f02b757c400",
  "block": 25954853,
  "trx_in_block": 4,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-09-14T14:16:39",
  "op": [
    "comment",
    {
      "parent_author": "iwaydi",
      "parent_permlink": "how-to-use-feature-dropping-and-rollback-with-migration-in-laravel",
      "author": "masterzaghato",
      "permlink": "re-iwaydi-how-to-use-feature-dropping-and-rollback-with-migration-in-laravel-20180914t141635146z",
      "title": "",
      "body": "Thank you very useful for all",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"app\":\"steemit/0.1\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 25814456,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 8,
  "timestamp": "2018-09-09T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.157 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 25612962,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 11,
  "timestamp": "2018-09-02T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.157 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 25411468,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 9,
  "timestamp": "2018-08-26T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.156 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 25209958,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 58,
  "timestamp": "2018-08-19T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.156 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 25008431,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 8,
  "timestamp": "2018-08-12T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.155 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 24806908,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 19,
  "timestamp": "2018-08-05T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.155 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 24605392,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 28,
  "timestamp": "2018-07-29T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.155 STEEM"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 24404349,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 27,
  "timestamp": "2018-07-22T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.154 STEEM"
    }
  ]
}

{
  "trx_id": "7a63d98199d09e616ba945945a8258aff3c3b3cc",
  "block": 24223466,
  "trx_in_block": 3,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-16T10:22:06",
  "op": [
    "account_update",
    {
      "account": "iwaydi",
      "posting": {
        "weight_threshold": 1,
        "account_auths": [
          [
            "busy.app",
            1
          ],
          [
            "dmania.app",
            1
          ],
          [
            "dtube.app",
            1
          ],
          [
            "streemian",
            1
          ],
          [
            "utopian.app",
            1
          ],
          [
            "utopianpay",
            1
          ]
        ],
        "key_auths": [
          [
            "STM6QksZNiLYwMATDZ24BSUvzoxKMMVdgxsV39F3wuT3CVbqFNND9",
            1
          ]
        ]
      },
      "memo_key": "STM6Kuw9dxStg8mAaMvKQ7uA1fW7aqgUXzMounQmtPAQhCDAsQ9bi",
      "json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-87BIycDpta0/WUuTMgAIMbI/AAAAAAAAB_w/wp1pL4mI7HIjpFpOMMTKYHOeBFXJeV8zACEwYBhgL/w140-h140-p/1497888514786.jpg\",\"name\":\"IW\",\"about\":\"Tutorials laravel , suggestion, video tutorial, meme  and other be usefull\",\"location\":\"indonesian\",\"cover_image\":\"https://upload.wikimedia.org/wikipedia/commons/c/c6/Edinburgh_Night_Panorama_from_Calton_Hill.jpg\"}}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 24202921,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 5,
  "timestamp": "2018-07-15T17:14:42",
  "op": [
    "fill_vesting_withdraw",
    {
      "from_account": "iwaydi",
      "to_account": "iwaydi",
      "withdrawn": "2341.427923 VESTS",
      "deposited": "1.154 STEEM"
    }
  ]
}

{
  "trx_id": "e9e7c157c797f0b099d91beea672d1f3ef64d805",
  "block": 24001382,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-08T17:14:42",
  "op": [
    "withdraw_vesting",
    {
      "account": "iwaydi",
      "vesting_shares": "30438.563002 VESTS"
    }
  ]
}

{
  "trx_id": "f15b1a0b30da226e5524c8345245dd00f059ff32",
  "block": 24001363,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-08T17:13:45",
  "op": [
    "withdraw_vesting",
    {
      "account": "iwaydi",
      "vesting_shares": "30438.563671 VESTS"
    }
  ]
}

{
  "trx_id": "903b30ac5fb1005eaa2fdd582013a44c331c0c06",
  "block": 23913249,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-05T15:45:39",
  "op": [
    "vote",
    {
      "voter": "ericktabora92",
      "author": "iwaydi",
      "permlink": "how-to-modifications-a-table-database-with-php-artisan-migration-in-laravel",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "c55a68c400d9b5ab75d06043e97029c37913f3b0",
  "block": 23892490,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-04T22:26:36",
  "op": [
    "vote",
    {
      "voter": "ericktabora92",
      "author": "iwaydi",
      "permlink": "how-to-modifications-a-table-database-with-php-artisan-migration-in-laravel",
      "weight": 0
    }
  ]
}

{
  "trx_id": "55a58c200d3abd815d96b5010b281fda9205d55c",
  "block": 23892464,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-07-04T22:25:18",
  "op": [
    "vote",
    {
      "voter": "ericktabora92",
      "author": "iwaydi",
      "permlink": "how-to-modifications-a-table-database-with-php-artisan-migration-in-laravel",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "7c89254ab95d5e54640404032a2fdb66ed259c03",
  "block": 23465712,
  "trx_in_block": 58,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-06-19T18:28:36",
  "op": [
    "comment",
    {
      "parent_author": "iwaydi",
      "parent_permlink": "web-2018-2-6-17-31-49",
      "author": "steemitboard",
      "permlink": "steemitboard-notify-iwaydi-20180619t182838000z",
      "title": "",
      "body": "Congratulations @iwaydi! You have received a personal award!\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/@iwaydi/birthday1.png)](http://steemitboard.com/@iwaydi)  1 Year on Steemit\n<sub>_Click on the badge to view your Board of Honor._</sub>\n\n\n**Do not miss the [last post](https://steemit.com/steemitboard/@steemitboard/steemitboard-world-cup-contest-iran-vs-spain) from @steemitboard!**\n\n---\n**Participate in the [SteemitBoard World Cup Contest](https://steemit.com/steemitboard/@steemitboard/steemitboard-world-cup-contest-collect-badges-and-win-free-sbd)!**\nCollect World Cup badges and win free SBD\nSupport the Gold Sponsors of the contest: [@good-karma](https://v2.steemconnect.com/sign/account-witness-vote?witness=good-karma&approve=1) and [@lukestokes](https://v2.steemconnect.com/sign/account-witness-vote?witness=lukestokes.mhth&approve=1)\n\n---\n\n> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}"
    }
  ]
}

{
  "trx_id": "8e6fb54a99052259252dd673cd4b67208c8512c3",
  "block": 21997465,
  "trx_in_block": 97,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-29T17:53:06",
  "op": [
    "transfer",
    {
      "from": "iwaydi",
      "to": "blocktrades",
      "amount": "28.157 SBD",
      "memo": "c328e670-06fa-4b0b-bab8-8a16018992e1"
    }
  ]
}

{
  "trx_id": "b995db8b97e51f4c31dfba6a15740938dde3a57f",
  "block": 21235302,
  "trx_in_block": 53,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-03T06:06:51",
  "op": [
    "transfer",
    {
      "from": "iwaydi",
      "to": "blocktrades",
      "amount": "18.000 SBD",
      "memo": "bf4ab2ce-8c69-448e-b01a-efd1305f741f"
    }
  ]
}

{
  "trx_id": "3ed6e0bc67f9ac281d4a8581d0afa33c696f76b0",
  "block": 21235199,
  "trx_in_block": 11,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-04-03T06:01:42",
  "op": [
    "claim_reward_balance",
    {
      "account": "iwaydi",
      "reward_steem": "0.001 STEEM",
      "reward_sbd": "0.006 SBD",
      "reward_vests": "12.238702 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 21154233,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 16,
  "timestamp": "2018-03-31T10:32:36",
  "op": [
    "author_reward",
    {
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "sbd_payout": "0.006 SBD",
      "steem_payout": "0.001 STEEM",
      "vesting_payout": "12.238702 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 21154233,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 15,
  "timestamp": "2018-03-31T10:32:36",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "steepshot.pay",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 21154233,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 14,
  "timestamp": "2018-03-31T10:32:36",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "steepshot.fund",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 21154233,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 13,
  "timestamp": "2018-03-31T10:32:36",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "steepshot",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "0.000000 VESTS"
    }
  ]
}

{
  "trx_id": "7585cb430b121de6aba2fd83c40a721a0095aab7",
  "block": 20996214,
  "trx_in_block": 59,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-25T22:48:48",
  "op": [
    "transfer",
    {
      "from": "steempromos",
      "to": "iwaydi",
      "amount": "0.001 SBD",
      "memo": "LIMITED OFFER! Send 1 to 5 SBD or STEEM to @steempromos with post URL in Memo and get 4 to 21 SBD upvote on your post.  Pre-service-launch PROMOTION is valid till 1st april only so hurry up!"
    }
  ]
}

{
  "trx_id": "3ddc05834615aec951047b6eb8c737fe858b2c61",
  "block": 20960551,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T17:05:09",
  "op": [
    "comment_options",
    {
      "author": "iwaydi",
      "permlink": "re-iwaydi-re-divasafitri-web-2018-2-6-2--20180324t170506z",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "steepshot",
                "weight": 900
              },
              {
                "account": "steepshot.fund",
                "weight": 100
              },
              {
                "account": "steepshot.pay",
                "weight": 500
              }
            ]
          }
        ]
      ]
    }
  ]
}

{
  "trx_id": "3ddc05834615aec951047b6eb8c737fe858b2c61",
  "block": 20960551,
  "trx_in_block": 12,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T17:05:09",
  "op": [
    "comment",
    {
      "parent_author": "divasafitri",
      "parent_permlink": "web-2018-2-6-2-38-57",
      "author": "iwaydi",
      "permlink": "re-iwaydi-re-divasafitri-web-2018-2-6-2--20180324t170506z",
      "title": "",
      "body": "promo di ig juga pa. biar followernya yg ada main steemit ngefollow dipa",
      "json_metadata": "{\"app\": \"steepshot/v0.1.1 b60 t\"}"
    }
  ]
}

{
  "trx_id": "9cbe60a20140b85aa318062919e16637d95418a7",
  "block": 20960529,
  "trx_in_block": 56,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T17:04:03",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\", {\"follower\": \"iwaydi\", \"following\": \"egregorian\", \"what\": [\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "f13bb85e339b5bb0b61a356bb796add7ae0629f5",
  "block": 20960512,
  "trx_in_block": 14,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T17:03:12",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\", {\"follower\": \"iwaydi\", \"following\": \"divasafitri\", \"what\": [\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "f7a39545350bbcf3e83a3a914dbebba560efc381",
  "block": 20959574,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T16:16:18",
  "op": [
    "vote",
    {
      "voter": "divasafitri",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "c2fc695ddde92d22745d8994cdbf4ce72ae3ed82",
  "block": 20955626,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T12:58:48",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "steepshot",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "title": "Yellow Rose Today",
      "body": "[![c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg](http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg)](https://alpha.steepshot.io/post/web-2018-2-6-17-31-49)\n\n-   --  -   - ---  -- - -  -- - -   -----   --  -  - ----  -    -   - --\n\nYou can see the beautiful colors of today. flowers jealousy, yellow roses. you can say taste it through the beauty of this flower\n\n-- -   -    -  ---- -  -  --   -----   - - --  - - --  --- -   -  --   -\n\n###### ![Steepshot_footer2.PNG](https://steemitimages.com/DQmd4wyZvtAUifJDLZD9vaqek17S1cUhN3PyEbFMMMgLW8o/Steepshot_footer2.PNG) Steepshot | [IPFS](http://steepshot.org/ipfs/QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn) | [Google Play](https://play.google.com/store/apps/details?id=com.droid.steepshot)",
      "json_metadata": "{\"tags\":[\"steepshot\"],\"app\":\"steepshot/0.1.2.13\",\"image_size\":{\"height\":3120,\"width\":2340},\"ipfs_photo\":\"QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn\",\"image\":[\"http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg\"],\"media\":[{\"ipfs_hash\":\"QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn\",\"thumbnails\":{\"256\":\"http://steepshot.org/api/v1/image/d2de0cbc-f5ae-4402-9833-d75f1909884a.jpeg\",\"1024\":\"http://steepshot.org/api/v1/image/0b130e18-130b-4cba-81d9-ae1dad56d0d2.jpeg\"},\"content_type\":\"image/jpeg\",\"url\":\"http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg\",\"size\":{\"height\":3120,\"width\":2340}}]}"
    }
  ]
}

{
  "trx_id": "2075de4d05e69061b53ef1031c68cd96f82a6aaf",
  "block": 20955559,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T12:55:27",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "9b8546e08164c8a1004291fcae7d5a19ee7a7e62",
  "block": 20954173,
  "trx_in_block": 21,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T11:46:09",
  "op": [
    "vote",
    {
      "voter": "bustillo",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "ea1d4805fefa7c45c68b78bd78d6123f83ce1bc9",
  "block": 20953283,
  "trx_in_block": 51,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T11:01:39",
  "op": [
    "vote",
    {
      "voter": "marketstack",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "weight": 85
    }
  ]
}

{
  "trx_id": "b8a71a8d019fccca857915cdd3a43da783e93102",
  "block": 20952702,
  "trx_in_block": 34,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T10:32:36",
  "op": [
    "comment_options",
    {
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "steepshot",
                "weight": 900
              },
              {
                "account": "steepshot.fund",
                "weight": 100
              },
              {
                "account": "steepshot.pay",
                "weight": 500
              }
            ]
          }
        ]
      ]
    }
  ]
}

{
  "trx_id": "b8a71a8d019fccca857915cdd3a43da783e93102",
  "block": 20952702,
  "trx_in_block": 34,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-03-24T10:32:36",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "steepshot",
      "author": "iwaydi",
      "permlink": "web-2018-2-6-17-31-49",
      "title": "Yellow Rose Today",
      "body": "[![c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg](http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg)](https://alpha.steepshot.io/post/web-2018-2-6-17-31-49)\n\n-   --  -   - ---  -- - -  -- - -   -----   --  -  - ----  -    -   - --\n\nYou can see the beautiful colors of today. flowers jealousy, yellow roses. you can say taste it through the beauty of this flower\n\n-- -   -    -  ---- -  -  --   -----   - - --  - - --  --- -   -  --   -\n\n###### ![Steepshot_footer2.PNG](https://steemitimages.com/DQmd4wyZvtAUifJDLZD9vaqek17S1cUhN3PyEbFMMMgLW8o/Steepshot_footer2.PNG) Steepshot | [IPFS](http://steepshot.org/ipfs/QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn) | [Google Play](https://play.google.com/store/apps/details?id=com.droid.steepshot)",
      "json_metadata": "{\"tags\":[\"steepshot\"],\"app\":\"steepshot/0.1.2.13\",\"image_size\":{\"height\":3120,\"width\":2340},\"ipfs_photo\":\"QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn\",\"image\":[\"http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg\"],\"media\":[{\"ipfs_hash\":\"QmZ9TZZ6U2rwioawan7WzjMAhNrXrq8CwyzgDPRZNbc5Pn\",\"thumbnails\":{\"256\":\"http://steepshot.org/api/v1/image/d2de0cbc-f5ae-4402-9833-d75f1909884a.jpeg\",\"1024\":\"http://steepshot.org/api/v1/image/0b130e18-130b-4cba-81d9-ae1dad56d0d2.jpeg\"},\"content_type\":\"image/jpeg\",\"url\":\"http://steepshot.org/api/v1/image/c7325c3b-46eb-4a5e-9086-0af37137b823.jpeg\",\"size\":{\"height\":3120,\"width\":2340}}]}"
    }
  ]
}

{
  "trx_id": "d498040249c3f94c53fef16d503607b49ca9f97c",
  "block": 20184530,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-25T17:06:03",
  "op": [
    "claim_reward_balance",
    {
      "account": "iwaydi",
      "reward_steem": "0.000 STEEM",
      "reward_sbd": "7.080 SBD",
      "reward_vests": "4374.932733 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20184420,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 40,
  "timestamp": "2018-02-25T17:00:36",
  "op": [
    "author_reward",
    {
      "author": "iwaydi",
      "permlink": "laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel",
      "sbd_payout": "7.080 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "4374.932733 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20184420,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 39,
  "timestamp": "2018-02-25T17:00:36",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "iwaydi",
      "permlink": "laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2915.940686 VESTS"
    }
  ]
}

{
  "trx_id": "a384770eaf11ab477db215e2567ba78083311a8f",
  "block": 20151854,
  "trx_in_block": 28,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-24T13:51:42",
  "op": [
    "claim_reward_balance",
    {
      "account": "iwaydi",
      "reward_steem": "0.000 STEEM",
      "reward_sbd": "3.812 SBD",
      "reward_vests": "2243.816175 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20146487,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 25,
  "timestamp": "2018-02-24T09:23:24",
  "op": [
    "author_reward",
    {
      "author": "iwaydi",
      "permlink": "laravel-5-how-to-use-rename-table-with-schema-in-laravel",
      "sbd_payout": "3.812 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "2243.816175 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20146487,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 24,
  "timestamp": "2018-02-24T09:23:24",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "iwaydi",
      "permlink": "laravel-5-how-to-use-rename-table-with-schema-in-laravel",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "1493.833901 VESTS"
    }
  ]
}

{
  "trx_id": "b4b3df7c329e6b2e8796222b9a08e46688cdfcd1",
  "block": 20084298,
  "trx_in_block": 29,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-22T05:33:27",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"codesenpai\",\"what\":[\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "1070fff4e4bcb2b1c7a9c97caffa797766611c8e",
  "block": 20084152,
  "trx_in_block": 39,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-22T05:26:09",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "adiethaulia",
      "permlink": "perkenalan-465e4493e080b",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "919249f01cde59d696daaad1980902939e551e9c",
  "block": 20084142,
  "trx_in_block": 37,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-22T05:25:39",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"adiethaulia\",\"what\":[\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "27888e9d20f3a743d731cadeccb28634c27bd5d4",
  "block": 20071426,
  "trx_in_block": 2,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T18:49:36",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"khairamuliani\",\"what\":[\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "fcb0fb9bc06017768659678b0d088331440efede",
  "block": 20071396,
  "trx_in_block": 20,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T18:48:06",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"newsupdate\",\"what\":[\"blog\"]}]"
    }
  ]
}

{
  "trx_id": "981cd3b094c6b7671e811e6a0440b63c30a80729",
  "block": 20071393,
  "trx_in_block": 1,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T18:47:57",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"newsupdate\",\"what\":[]}]"
    }
  ]
}

{
  "trx_id": "8630e82eafe552d3e59775891ea372d95d6054b8",
  "block": 20068255,
  "trx_in_block": 17,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T16:11:03",
  "op": [
    "custom_json",
    {
      "required_auths": [],
      "required_posting_auths": [
        "iwaydi"
      ],
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"iwaydi\",\"following\":\"newsupdate\",\"what\":[\"ignore\"]}]"
    }
  ]
}

{
  "trx_id": "5feaa4a06eb07a9570c3e30f4ad51fc3a1e60dbc",
  "block": 20066590,
  "trx_in_block": 14,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:47:45",
  "op": [
    "transfer_to_vesting",
    {
      "from": "blocktrades",
      "to": "iwaydi",
      "amount": "1.178 STEEM"
    }
  ]
}

{
  "trx_id": "5db58d8901199f9103a4bcbf1af0358959a913bf",
  "block": 20066587,
  "trx_in_block": 48,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:47:36",
  "op": [
    "transfer",
    {
      "from": "iwaydi",
      "to": "blocktrades",
      "amount": "1.000 SBD",
      "memo": "f6e3a9d5-73a5-4133-9b2a-253effed6dfa"
    }
  ]
}

{
  "trx_id": "af8b5f607ad0668663e47b62a218a489d76ab5bd",
  "block": 20066461,
  "trx_in_block": 25,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:41:18",
  "op": [
    "claim_reward_balance",
    {
      "account": "iwaydi",
      "reward_steem": "0.000 STEEM",
      "reward_sbd": "2.972 SBD",
      "reward_vests": "1479.746636 VESTS"
    }
  ]
}

{
  "trx_id": "5694e99229caebf75cb26b3020e47b6ab6222ca3",
  "block": 20066406,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:38:33",
  "op": [
    "comment_options",
    {
      "author": "iwaydi",
      "permlink": "re-newsupdate-genius-zg1hbmlh-s28qk-20180221t143832565z",
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "allow_votes": true,
      "allow_curation_rewards": true,
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "cnts",
                "weight": 500
              },
              {
                "account": "dmania",
                "weight": 1000
              },
              {
                "account": "snubbermike",
                "weight": 500
              },
              {
                "account": "xeldal",
                "weight": 500
              }
            ]
          }
        ]
      ]
    }
  ]
}

{
  "trx_id": "5694e99229caebf75cb26b3020e47b6ab6222ca3",
  "block": 20066406,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:38:33",
  "op": [
    "comment",
    {
      "parent_author": "newsupdate",
      "parent_permlink": "genius-zg1hbmlh-s28qk",
      "author": "iwaydi",
      "permlink": "re-newsupdate-genius-zg1hbmlh-s28qk-20180221t143832565z",
      "title": "re-newsupdate-genius-zg1hbmlh-s28qk-20180221t143832565z",
      "body": "Amazing hahaha",
      "json_metadata": "{\"tags\":[\"dmania\"],\"app\":\"dmania/0.7\"}"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20066396,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 21,
  "timestamp": "2018-02-21T14:38:06",
  "op": [
    "author_reward",
    {
      "author": "iwaydi",
      "permlink": "how-to-use-feature-dropping-and-rollback-with-migration-in-laravel",
      "sbd_payout": "2.972 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "1479.746636 VESTS"
    }
  ]
}

{
  "trx_id": "0000000000000000000000000000000000000000",
  "block": 20066396,
  "trx_in_block": 4294967295,
  "op_in_trx": 0,
  "virtual_op": 20,
  "timestamp": "2018-02-21T14:38:06",
  "op": [
    "comment_benefactor_reward",
    {
      "benefactor": "utopian.pay",
      "author": "iwaydi",
      "permlink": "how-to-use-feature-dropping-and-rollback-with-migration-in-laravel",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "985.135191 VESTS"
    }
  ]
}

{
  "trx_id": "c4a98d03ac44d6e8528be3a3e628bb1a725f2812",
  "block": 20066322,
  "trx_in_block": 10,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:34:21",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "newsupdate",
      "permlink": "the-power-of-mother-zg1hbmlh-iei5c",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "f8355c7fa027ba19355515610a820a99e95ca70d",
  "block": 20066320,
  "trx_in_block": 30,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:34:15",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "newsupdate",
      "permlink": "you-lied-to-me-zg1hbmlh-i4urj",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "be95cdb9c5fb004cddeabf1f9b539595ce513c09",
  "block": 20066312,
  "trx_in_block": 9,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:33:51",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "newsupdate",
      "permlink": "i-finally-found-out-zg1hbmlh-1zgd2",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "502e3b95d21cc19a9beb6c097cb63cd79e885e20",
  "block": 20066275,
  "trx_in_block": 14,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-21T14:32:00",
  "op": [
    "vote",
    {
      "voter": "iwaydi",
      "author": "newsupdate",
      "permlink": "genius-zg1hbmlh-s28qk",
      "weight": 10000
    }
  ]
}

{
  "trx_id": "d9efebfd03479f5ef8306296bbe25b9e3d3e2b8f",
  "block": 20025232,
  "trx_in_block": 23,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-20T04:19:39",
  "op": [
    "account_witness_vote",
    {
      "account": "iwaydi",
      "witness": "utopian-io",
      "approve": true
    }
  ]
}

{
  "trx_id": "1a5a93ef516051c699375b72b84a6874b4bf0eb0",
  "block": 20025216,
  "trx_in_block": 32,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-20T04:18:51",
  "op": [
    "account_witness_vote",
    {
      "account": "iwaydi",
      "witness": "utopian-io",
      "approve": false
    }
  ]
}

{
  "trx_id": "10b598750beef2eb7a19db89192d6519f90a36a0",
  "block": 20012922,
  "trx_in_block": 18,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-19T18:03:24",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "author": "iwaydi",
      "permlink": "laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel",
      "title": "Laravel #6 -  How to fix SQLSTATE error [42000]: Syntax error or access violation: 1071 Specified key was too long in laravel",
      "body": "\n#### What Will I Learn?\n<hr>\n\nErrors are often encountered while running a program and are no exception in laravel and this is very disturbing and slowing down our work. So in this tutorial, we will try to fix errors that may occur in this project. Here's what you'll learn:\n\n- you will learn to find the source of SQLSTATE errors [42000]\n- you will learn to fix SQLSTATE error [42000]\n\n#### Requirements\n<hr>\n\nTo follow this tutorial. You only need to provide some tools. o this is the list of the requirements for the user:\n\n- Xampp 5.6.3\n- Framework Laravel 5.4\n- Composer\n- Atom text editor\n\n#### Difficulty\n<hr>\n\n- Intermediate\n\n#### Preliminary\n<hr>\n\n**Errors** are Error, Incorrect, or Malfunction. With the occurrence of this error, the execution of the command does not match what is expected. On some occurrence, if an error occurs, the current command who be working will be stopped because it can not continue, because the server is not running yet. But in other circumstances, the work can still continue, because the errors that occur do not affect the system and can be ignored. Just like our mistakes. Some commands have been executed but there are commands that can not be executed and errors occur.\n\n\n**SQLSTATE error [42000]** is a warning that appears when there is an error in the process and this affects the existing database and 42000 is the number used to recognize the error that occurred and it is indicated for syntax errors or access violations. This error can occur because there are some incorrect syntax we make or not listed in the system and usually the error occurs because there are other errors as the trigger associated with the error displayed on the screen and you need to know the error on display is not the real problem in this case but it will be a clue to find the actual error.\n\n#### Tutorial Content : Practice Fixing error SQLSTATE  [42000]\n<hr>\n\nIn this tutorial, we will discuss how to fix the error and as usual, we will finish in 3 steps. We start from making the error, then look for the source of error, and fix the error.\n\n##### Step 1: Making eror SQLSTATE  [42000] \n<hr>\n\nThe first, we will discuss the error below and we will start trying to make something and display the error.\n\n> <code>SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))</code>\n\nNow we will create the error as above and we will try to create a table so we can get the error it. First, create a migration file named **table_error**. So use the command below to create a migration file.\n\n<code>php artisan make:migration table_error</code>\n\nAfter that open the migration file and add this code:\n```laravel\n  public function up()\n    {\n        Schema::create('eror', function (Blueprint $table) {\n            $table->increments('id');\n            $table->integer('No.Error',60);\n            $table->varchar('name',60);\n            $table->text('category');\n            $table->text('information');\n            $table->varchar('Description',60);\n            $table->text('solution');\n            $table->timestamps();\n        });\n    }\n```\nAfter that, use this script to execute migration files that have been edited\n\n<code>php artisan migrate</code>\n\nHere is an output  the command prompt after running:\n![eror1.PNG](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518966696/uwpbbh1usolclbdk2bhw.png)\n\nYou can see the output above. It says Migration table created successfully. But why error?. Now we already have the error and in the next step we will find out why this can happen.\n\n##### Step 2: Looking for the source of error SQLSTATE [42000] \n<hr>\n\nBefore looking for it. We look again the following output and you will find the **table user**. Why can the **table user** appear while we create **table_error**?\n![eror2.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518967781/fvakkxygxppilocykcey.png)\n\nAfter looking at it I assume if the error is in file migration and it turns out I am right. I'll show you how I found the error. Open the atomic text editor and then open the laravel folder into it. After that go to <code> database/migrations </code>.This is my migration file view and you can see there is **create_users_table** file. So I think this is the source of the problem and I delete that file and a new problem arises when I execute again using <code>php artisan merge</code>.\n\n![eror3.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518968616/v40xg4xbl9htb5lwous1.png)\n\nThis is the output at the command prompt after I delete the **create_user** migration file and the results are similar to before but there are different there. Now appears <code> table `password_resets` </code>\n\n![eror4.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969245/ekyovluehzma8o8nmrij.png)\n\nSo I think this is the same as the previous user. Because I see it also in the migration folder. So I delete it and now inside the migration folder there is only 1 migration file left and that is **table_eror**  but other errors appear but I think this is the source of the problem. This is the cause of the previous error. Although Migration table created successfully. This is the migration folder view now.\n\n![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969743/te9rfawytwflxyru902n.png)\n\nThe following is the output at the command prompt after the migration file has one left in the folder and is executed\n\n![eror5.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969847/ngihjqkimcwtg1tceaqs.png)\n\nNow we have found the problem. it turns out the **varchar** method cannot be used in the migration file and this is the cause of all previous errors. migration user files that we have previously deleted have execution and because there is an error then the system does re-execute the user file while the table user was successfully created so that there was an error. well in the next step we will fix this error.\n\n##### Step 3: Fixing error SQLSTATE  [42000] \n<hr>\n\nNow open the table_error migration file and then replace it with the code below that I have fixed:\n\n```laravel\n    public function up()\n    {\n        Schema::create('eror', function (Blueprint $table) {\n            $table->integer('eror_id');\n            $table->increments('id');\n            $table->string('nameeror',60);\n            $table->text('category');\n            $table->text('information');\n            $table->string('Description',60);\n            $table->text('solution');\n            $table->timestamps();\n        });\n    }\n```\n\nAfter that, use this script to execute migration files that have been edited\n\n<code>php artisan migrate</code>\n\nHere is an output from the command prompt after running:\n![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518971591/kqvgycdpsnpahskk2oxu.png)\n\nI replace the **varchar** method into the **string<**and then the object **No.Error** becomes **eror_id** and I put it in the first position. then I change the object **name** to **name error** and the results do not appear again error and the table successfully created and now we see the column of the table and you will find interesting facts.\n\n![eror5.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1518972432/tg3eugzl2jjoojtrusly.png)\n\nFrom the table structure above we can see. All **string** methods change to **varchar** after the file migration in execution. this is what I want to show you. File migration can not use **varchar** but you can use **string** for **varchar**method because it will change after going into the database and remember this to avoid this kind of error again.\n\n#### Conclusion\n<hr>\n\nSQLSTATE error [42000] can happen because there is an error in the migration file we created so that the system will automatically execute the migration file on it that has already been executed previously so this error can occasion. In our case, the error we made is using the **varchar** method and the solution by replacing the **varchar** into a **string**.\n\n#### Curriculum\n<hr>\n\n- [Laravel #5 - How to Use Rename table with schema in laravel](https://utopian.io/u/33254961)\n- [Laravel #4 - How to Use Feature Dropping and Rollback with Migration in Laravel](https://utopian.io/u/32624333)\n- [Laravel #3 - How to Use Maintenance Mode with composer in Laravel](https://utopian.io/u/31714784)\n- [Laravel #2 - How to Modifications a table database with PHP artisan migration in laravel](https://utopian.io/u/31071228)\n- [Laravel #1 - How to Create a Table Database in Laravel With PHP Artisan Migration](https://utopian.io/u/30328342)\n    \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@iwaydi/laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1863329,\"name\":\"laravel\",\"full_name\":\"laravel/laravel\",\"html_url\":\"https://github.com/laravel/laravel\",\"fork\":false,\"owner\":{\"login\":\"laravel\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"laravel\",\"tutorial\",\"contribution\",\"programming\"],\"users\":[\"iwaydi\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518966696/uwpbbh1usolclbdk2bhw.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518967781/fvakkxygxppilocykcey.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518968616/v40xg4xbl9htb5lwous1.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969245/ekyovluehzma8o8nmrij.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969743/te9rfawytwflxyru902n.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969847/ngihjqkimcwtg1tceaqs.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518971591/kqvgycdpsnpahskk2oxu.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518972432/tg3eugzl2jjoojtrusly.png\",\"https://utopian.io/u/33254961\",\"https://utopian.io/u/32624333\",\"https://utopian.io/u/31714784\",\"https://utopian.io/u/31071228\",\"https://utopian.io/u/30328342\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518966696/uwpbbh1usolclbdk2bhw.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518967781/fvakkxygxppilocykcey.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518968616/v40xg4xbl9htb5lwous1.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969245/ekyovluehzma8o8nmrij.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969743/te9rfawytwflxyru902n.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969847/ngihjqkimcwtg1tceaqs.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518971591/kqvgycdpsnpahskk2oxu.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518972432/tg3eugzl2jjoojtrusly.png\"],\"moderator\":{\"account\":\"yokunjon\",\"time\":\"2018-02-19T08:24:19.184Z\",\"reviewed\":true,\"pending\":false,\"flagged\":false},\"questions\":null,\"score\":null}"
    }
  ]
}

{
  "trx_id": "6127796bbe88f1f20ecad2d5a4a5493f1cb31848",
  "block": 20012537,
  "trx_in_block": 15,
  "op_in_trx": 0,
  "virtual_op": 0,
  "timestamp": "2018-02-19T17:44:09",
  "op": [
    "comment",
    {
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "author": "iwaydi",
      "permlink": "laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel",
      "title": "Laravel #6 -  How to fix SQLSTATE error [42000]: Syntax error or access violation: 1071 Specified key was too long in laravel",
      "body": "@@ -164,17 +164,17 @@\n r work. \n-s\n+S\n o in thi\n@@ -405,17 +405,17 @@\n s%0A%3Chr%3E%0A%0A\n-t\n+T\n o follow\n@@ -430,17 +430,17 @@\n torial. \n-y\n+Y\n ou only \n@@ -467,17 +467,16 @@\n  tools. \n-s\n o this i\n@@ -881,12 +881,16 @@\n ill \n+be \n stop\n+p\n ed b\n@@ -1212,16 +1212,17 @@\n occur.%0A%0A\n+%0A\n **SQLSTA\n@@ -1300,16 +1300,8 @@\n the \n-migrate \n proc\n@@ -1408,17 +1408,16 @@\n occurred\n-.\n  and it \n@@ -1816,16 +1816,17 @@\n al error\n+.\n %0A%0A#### T\n@@ -2529,17 +2529,17 @@\n ror it. \n-f\n+F\n irst, cr\n@@ -2583,17 +2583,17 @@\n rror**. \n-s\n+S\n o use th\n@@ -2690,17 +2690,17 @@\n /code%3E%0A%0A\n-a\n+A\n fter tha\n@@ -3187,17 +3187,17 @@\n   %7D%0A%60%60%60%0A\n-a\n+A\n fter tha\n@@ -3530,17 +3530,17 @@\n sfully. \n-b\n+B\n ut why e\n@@ -3548,12 +3548,11 @@\n ror?\n- \n . \n-n\n+N\n ow w\n@@ -3683,33 +3683,32 @@\n  error SQLSTATE \n- \n %5B42000%5D %0A%3Chr%3E%0A%0AB\n@@ -3729,17 +3729,17 @@\n for it. \n-w\n+W\n e look a\n@@ -3802,17 +3802,17 @@\n user**. \n-w\n+W\n hy can t\n@@ -3971,17 +3971,17 @@\n y.png)%0A%0A\n-a\n+A\n fter loo\n@@ -4170,17 +4170,17 @@\n nto it. \n-a\n+A\n fter tha\n@@ -4222,17 +4222,17 @@\n %3C/code%3E.\n-t\n+T\n his is m\n@@ -4307,17 +4307,17 @@\n * file. \n-s\n+S\n o I thin\n@@ -4562,17 +4562,17 @@\n 1.png)%0A%0A\n-t\n+T\n his is t\n@@ -4722,17 +4722,17 @@\n  there. \n-n\n+N\n ow appea\n@@ -4876,17 +4876,17 @@\n j.png)%0A%0A\n-s\n+S\n o I thin\n@@ -4926,17 +4926,17 @@\n s user. \n-b\n+B\n ecause I\n@@ -4973,17 +4973,17 @@\n folder. \n-s\n+S\n o I dele\n@@ -5159,17 +5159,17 @@\n roblem. \n-t\n+T\n his is t\n@@ -5200,17 +5200,17 @@\n  error. \n-a\n+A\n lthough \n@@ -5247,17 +5247,17 @@\n sfully. \n-t\n+T\n his is t\n@@ -5610,17 +5610,17 @@\n s.png)%0A%0A\n-n\n+N\n ow we ha\n@@ -6077,17 +6077,17 @@\n  %0A%3Chr%3E%0A%0A\n-n\n+N\n ow open \n@@ -6621,17 +6621,17 @@\n  %7D%0A%60%60%60%0A%0A\n-a\n+A\n fter tha\n@@ -7342,17 +7342,17 @@\n y.png)%0A%0A\n-f\n+F\n rom the \n@@ -7389,48 +7389,9 @@\n ee. \n-after the file migration in execution. a\n+A\n ll *\n@@ -7429,16 +7429,54 @@\n archar**\n+ after the file migration in execution\n . this i\n@@ -7502,17 +7502,17 @@\n ow you. \n-f\n+F\n ile migr\n@@ -7642,17 +7642,16 @@\n database\n-.\n  and rem\n@@ -7953,17 +7953,17 @@\n casion. \n-i\n+I\n n our ca\n",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1863329,\"name\":\"laravel\",\"full_name\":\"laravel/laravel\",\"html_url\":\"https://github.com/laravel/laravel\",\"fork\":false,\"owner\":{\"login\":\"laravel\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"laravel\",\"tutorial\",\"contribution\",\"programming\"],\"users\":[\"iwaydi\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518966696/uwpbbh1usolclbdk2bhw.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518967781/fvakkxygxppilocykcey.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518968616/v40xg4xbl9htb5lwous1.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969245/ekyovluehzma8o8nmrij.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969743/te9rfawytwflxyru902n.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969847/ngihjqkimcwtg1tceaqs.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518971591/kqvgycdpsnpahskk2oxu.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518972432/tg3eugzl2jjoojtrusly.png\",\"https://utopian.io/u/33254961\",\"https://utopian.io/u/32624333\",\"https://utopian.io/u/31714784\",\"https://utopian.io/u/31071228\",\"https://utopian.io/u/30328342\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518966696/uwpbbh1usolclbdk2bhw.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518967781/fvakkxygxppilocykcey.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518968616/v40xg4xbl9htb5lwous1.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969245/ekyovluehzma8o8nmrij.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969743/te9rfawytwflxyru902n.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518969847/ngihjqkimcwtg1tceaqs.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518971591/kqvgycdpsnpahskk2oxu.png\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1518972432/tg3eugzl2jjoojtrusly.png\"]}"
    }
  ]
}