{"action":"created","issue":{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/431","labels_url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/431/labels{/name}","comments_url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/431/comments","events_url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/431/events","html_url":"https://github.com/Joomla-Bible-Study/Joomla-Bible-Study/issues/431","id":54597828,"number":431,"title":"Database differences: Migration scenario 1","user":{"login":"st-anton","id":2517417,"avatar_url":"https://avatars.githubusercontent.com/u/2517417?v=3","gravatar_id":"","url":"https://api.github.com/users/st-anton","html_url":"https://github.com/st-anton","followers_url":"https://api.github.com/users/st-anton/followers","following_url":"https://api.github.com/users/st-anton/following{/other_user}","gists_url":"https://api.github.com/users/st-anton/gists{/gist_id}","starred_url":"https://api.github.com/users/st-anton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/st-anton/subscriptions","organizations_url":"https://api.github.com/users/st-anton/orgs","repos_url":"https://api.github.com/users/st-anton/repos","events_url":"https://api.github.com/users/st-anton/events{/privacy}","received_events_url":"https://api.github.com/users/st-anton/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/labels/1+-+Ready","name":"1 - Ready","color":"CCCCCC"},{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/labels/Accepted","name":"Accepted","color":"02e10c"},{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"bcordis","id":994259,"avatar_url":"https://avatars.githubusercontent.com/u/994259?v=3","gravatar_id":"","url":"https://api.github.com/users/bcordis","html_url":"https://github.com/bcordis","followers_url":"https://api.github.com/users/bcordis/followers","following_url":"https://api.github.com/users/bcordis/following{/other_user}","gists_url":"https://api.github.com/users/bcordis/gists{/gist_id}","starred_url":"https://api.github.com/users/bcordis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcordis/subscriptions","organizations_url":"https://api.github.com/users/bcordis/orgs","repos_url":"https://api.github.com/users/bcordis/repos","events_url":"https://api.github.com/users/bcordis/events{/privacy}","received_events_url":"https://api.github.com/users/bcordis/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/milestones/6","labels_url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/milestones/6/labels","id":246567,"number":6,"title":"9.0.0 Beta","description":"Minimum Joomla Requirement: Joomla 3.3.x\r\nMinimum PHP: 5.3.10\r\n\r\nChanges Approved:\r\nNew Jloader\r\nNew JWPlayer Light-box System(dos not replace popup box)\r\nNew Responsive Design\r\nNew File Uploader\r\nNew Archiver system\r\nMove to integrated image system form the Joomla core\r\nMove to a New Installer all in one system","creator":{"login":"bcordis","id":994259,"avatar_url":"https://avatars.githubusercontent.com/u/994259?v=3","gravatar_id":"","url":"https://api.github.com/users/bcordis","html_url":"https://github.com/bcordis","followers_url":"https://api.github.com/users/bcordis/followers","following_url":"https://api.github.com/users/bcordis/following{/other_user}","gists_url":"https://api.github.com/users/bcordis/gists{/gist_id}","starred_url":"https://api.github.com/users/bcordis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcordis/subscriptions","organizations_url":"https://api.github.com/users/bcordis/orgs","repos_url":"https://api.github.com/users/bcordis/repos","events_url":"https://api.github.com/users/bcordis/events{/privacy}","received_events_url":"https://api.github.com/users/bcordis/received_events","type":"User","site_admin":false},"open_issues":28,"closed_issues":107,"state":"open","created_at":"2013-01-17T20:20:45Z","updated_at":"2015-01-20T01:23:58Z","due_on":"2015-01-31T06:00:00Z","closed_at":null},"comments":3,"created_at":"2015-01-16T16:54:05Z","updated_at":"2015-01-20T01:24:47Z","closed_at":null,"body":"After migration scenarion 1. (install 8.0.8 on j2.5. Upgrade J2.5 to J3.x,. Install JBSM 9.x.)\r\nthe database is different compared to a bs900 new installation:\r\n_bsms_mediafiles\r\n`metadata` text NOT NULL,  <->   instead of `metadata` text,\r\n`hits` int(10) DEFAULT NULL, <->  instead of   `hits` int(10) DEFAULT '0',\r\n-missing-                                            <->    `player` int(2) DEFAULT NULL,\r\n`checked_out` int(11) unsigned NOT NULL DEFAULT '0', <->    not present in new install\r\n`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', <->  not present in new install\r\nKEY `idx_checkout` (`checked_out`), <->       not present in new install\r\nKEY `idx_createdby` (`created_by`) <->      not present in new install\r\n\r\n_bsms_order\r\n    not present in new installation; table should be deleted\r\n\r\n_bsms_servers\r\n  `server_path` varchar(250) NOT NULL DEFAULT '', <->       not present in new install\r\n  `server_type` char(5) NOT NULL DEFAULT 'local',  <->       not present in new install\r\n  `ftp_username` char(255) NOT NULL, <->       not present in new install\r\n  `media` text NOT NULL,   <->   instead of   `media` text,\r\n\r\n_bsms_update\r\nINSERT INTO `#__bsms_update` SET `id`='19',`version`='9.0.0';   <-> instead of ... `id`='17'\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/comments/70589883","html_url":"https://github.com/Joomla-Bible-Study/Joomla-Bible-Study/issues/431#issuecomment-70589883","issue_url":"https://api.github.com/repos/Joomla-Bible-Study/Joomla-Bible-Study/issues/431","id":70589883,"user":{"login":"bcordis","id":994259,"avatar_url":"https://avatars.githubusercontent.com/u/994259?v=3","gravatar_id":"","url":"https://api.github.com/users/bcordis","html_url":"https://github.com/bcordis","followers_url":"https://api.github.com/users/bcordis/followers","following_url":"https://api.github.com/users/bcordis/following{/other_user}","gists_url":"https://api.github.com/users/bcordis/gists{/gist_id}","starred_url":"https://api.github.com/users/bcordis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bcordis/subscriptions","organizations_url":"https://api.github.com/users/bcordis/orgs","repos_url":"https://api.github.com/users/bcordis/repos","events_url":"https://api.github.com/users/bcordis/events{/privacy}","received_events_url":"https://api.github.com/users/bcordis/received_events","type":"User","site_admin":false},"created_at":"2015-01-20T01:24:47Z","updated_at":"2015-01-20T01:24:47Z","body":"@st-anton  are we in sync now? after the bug fix of #435?"}}