{"action":"created","issue":{"url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/1711","repository_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro","labels_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/1711/labels{/name}","comments_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/1711/comments","events_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/1711/events","html_url":"https://github.com/restrictcontentpro/restrict-content-pro/issues/1711","id":303136625,"number":1711,"title":"Custom table for subscriptions","user":{"login":"mindctrl","id":1254870,"avatar_url":"https://avatars0.githubusercontent.com/u/1254870?v=4","gravatar_id":"","url":"https://api.github.com/users/mindctrl","html_url":"https://github.com/mindctrl","followers_url":"https://api.github.com/users/mindctrl/followers","following_url":"https://api.github.com/users/mindctrl/following{/other_user}","gists_url":"https://api.github.com/users/mindctrl/gists{/gist_id}","starred_url":"https://api.github.com/users/mindctrl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mindctrl/subscriptions","organizations_url":"https://api.github.com/users/mindctrl/orgs","repos_url":"https://api.github.com/users/mindctrl/repos","events_url":"https://api.github.com/users/mindctrl/events{/privacy}","received_events_url":"https://api.github.com/users/mindctrl/received_events","type":"User","site_admin":false},"labels":[{"id":5100961,"url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"state":"open","locked":false,"assignee":{"login":"mindctrl","id":1254870,"avatar_url":"https://avatars0.githubusercontent.com/u/1254870?v=4","gravatar_id":"","url":"https://api.github.com/users/mindctrl","html_url":"https://github.com/mindctrl","followers_url":"https://api.github.com/users/mindctrl/followers","following_url":"https://api.github.com/users/mindctrl/following{/other_user}","gists_url":"https://api.github.com/users/mindctrl/gists{/gist_id}","starred_url":"https://api.github.com/users/mindctrl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mindctrl/subscriptions","organizations_url":"https://api.github.com/users/mindctrl/orgs","repos_url":"https://api.github.com/users/mindctrl/repos","events_url":"https://api.github.com/users/mindctrl/events{/privacy}","received_events_url":"https://api.github.com/users/mindctrl/received_events","type":"User","site_admin":false},"assignees":[{"login":"mindctrl","id":1254870,"avatar_url":"https://avatars0.githubusercontent.com/u/1254870?v=4","gravatar_id":"","url":"https://api.github.com/users/mindctrl","html_url":"https://github.com/mindctrl","followers_url":"https://api.github.com/users/mindctrl/followers","following_url":"https://api.github.com/users/mindctrl/following{/other_user}","gists_url":"https://api.github.com/users/mindctrl/gists{/gist_id}","starred_url":"https://api.github.com/users/mindctrl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mindctrl/subscriptions","organizations_url":"https://api.github.com/users/mindctrl/orgs","repos_url":"https://api.github.com/users/mindctrl/repos","events_url":"https://api.github.com/users/mindctrl/events{/privacy}","received_events_url":"https://api.github.com/users/mindctrl/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/milestones/10","html_url":"https://github.com/restrictcontentpro/restrict-content-pro/milestone/10","labels_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/milestones/10/labels","id":892505,"number":10,"title":"3.0","description":null,"creator":{"login":"pippinsplugins","id":1034109,"avatar_url":"https://avatars1.githubusercontent.com/u/1034109?v=4","gravatar_id":"","url":"https://api.github.com/users/pippinsplugins","html_url":"https://github.com/pippinsplugins","followers_url":"https://api.github.com/users/pippinsplugins/followers","following_url":"https://api.github.com/users/pippinsplugins/following{/other_user}","gists_url":"https://api.github.com/users/pippinsplugins/gists{/gist_id}","starred_url":"https://api.github.com/users/pippinsplugins/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pippinsplugins/subscriptions","organizations_url":"https://api.github.com/users/pippinsplugins/orgs","repos_url":"https://api.github.com/users/pippinsplugins/repos","events_url":"https://api.github.com/users/pippinsplugins/events{/privacy}","received_events_url":"https://api.github.com/users/pippinsplugins/received_events","type":"User","site_admin":false},"open_issues":24,"closed_issues":7,"state":"open","created_at":"2014-12-05T04:16:04Z","updated_at":"2018-03-19T13:54:13Z","due_on":null,"closed_at":null},"comments":9,"created_at":"2018-03-07T15:12:23Z","updated_at":"2018-03-23T14:04:22Z","closed_at":null,"author_association":"MEMBER","body":"I'm breaking this out separate from #774.\r\n\r\nThis may be updated, but the current schema proposal is:\r\n\r\nField | Type | Null | Key | Default | Extra\r\n-- | -- | -- | -- | -- | --\r\nid | int unsigned | NO | PRI | NULL | auto_increment\r\nobject_id | bigint unsigned | NO | MUL | NULL |\r\nobject_type | varchar(20) | NO |   | 'subscription' | \r\nuser_id | int unsigned | NO | MUL | NULL |\r\ncurrency | varchar(20) | NO | | USD |\r\ninitial_amount | mediumint | NO | | NULL |\r\nrecurring_amount | mediumint unsigned | NO | | NULL |\r\ncreated_date | datetime | NO | | CURRENT_TIMESTAMP |\r\ntrial_end_date | datetime | YES | | NULL |\r\ncancellation_date | datetime | YES | | NULL |\r\nexpiration_date | datetime | YES | | NULL |\r\ntimes_billed unsigned | smallint | NO | NO | 1 | |\r\nstatus | varchar(12) | NO | MUL | active |\r\npayment_profile_id | tinytext | YES | | NULL |\r\ngateway | tinytext | NO | | NULL |\r\n"},"comment":{"url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/comments/375675270","html_url":"https://github.com/restrictcontentpro/restrict-content-pro/issues/1711#issuecomment-375675270","issue_url":"https://api.github.com/repos/restrictcontentpro/restrict-content-pro/issues/1711","id":375675270,"user":{"login":"mindctrl","id":1254870,"avatar_url":"https://avatars0.githubusercontent.com/u/1254870?v=4","gravatar_id":"","url":"https://api.github.com/users/mindctrl","html_url":"https://github.com/mindctrl","followers_url":"https://api.github.com/users/mindctrl/followers","following_url":"https://api.github.com/users/mindctrl/following{/other_user}","gists_url":"https://api.github.com/users/mindctrl/gists{/gist_id}","starred_url":"https://api.github.com/users/mindctrl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mindctrl/subscriptions","organizations_url":"https://api.github.com/users/mindctrl/orgs","repos_url":"https://api.github.com/users/mindctrl/repos","events_url":"https://api.github.com/users/mindctrl/events{/privacy}","received_events_url":"https://api.github.com/users/mindctrl/received_events","type":"User","site_admin":false},"created_at":"2018-03-23T14:04:22Z","updated_at":"2018-03-23T14:04:22Z","author_association":"MEMBER","body":"Unless we have a specific need for it, I vote no. If we do have a need for it, we may want to consider if that data should be a column in the subscriptions table.\r\n\r\nWe added payment meta and still don't use it. The one plugin I know of that does use it uses it wrong."}}
{"actor":{"display_login":"mindctrl"}}