{"action":"created","issue":{"url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20","labels_url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20/comments","events_url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20/events","html_url":"https://github.com/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20","id":130472787,"number":20,"title":"Perubahan struktur tabel pokok_bahasan dan sub_pokok_bahasan","user":{"login":"wildanm","id":462398,"avatar_url":"https://avatars.githubusercontent.com/u/462398?v=3","gravatar_id":"","url":"https://api.github.com/users/wildanm","html_url":"https://github.com/wildanm","followers_url":"https://api.github.com/users/wildanm/followers","following_url":"https://api.github.com/users/wildanm/following{/other_user}","gists_url":"https://api.github.com/users/wildanm/gists{/gist_id}","starred_url":"https://api.github.com/users/wildanm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wildanm/subscriptions","organizations_url":"https://api.github.com/users/wildanm/orgs","repos_url":"https://api.github.com/users/wildanm/repos","events_url":"https://api.github.com/users/wildanm/events{/privacy}","received_events_url":"https://api.github.com/users/wildanm/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"wildanm","id":462398,"avatar_url":"https://avatars.githubusercontent.com/u/462398?v=3","gravatar_id":"","url":"https://api.github.com/users/wildanm","html_url":"https://github.com/wildanm","followers_url":"https://api.github.com/users/wildanm/followers","following_url":"https://api.github.com/users/wildanm/following{/other_user}","gists_url":"https://api.github.com/users/wildanm/gists{/gist_id}","starred_url":"https://api.github.com/users/wildanm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wildanm/subscriptions","organizations_url":"https://api.github.com/users/wildanm/orgs","repos_url":"https://api.github.com/users/wildanm/repos","events_url":"https://api.github.com/users/wildanm/events{/privacy}","received_events_url":"https://api.github.com/users/wildanm/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/milestones/2","html_url":"https://github.com/OpenThink-Labs/Sistem-Informasi-Bank-Soal/milestones/2016","labels_url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/milestones/2/labels","id":1508273,"number":2,"title":"2016","description":null,"creator":{"login":"wildanm","id":462398,"avatar_url":"https://avatars.githubusercontent.com/u/462398?v=3","gravatar_id":"","url":"https://api.github.com/users/wildanm","html_url":"https://github.com/wildanm","followers_url":"https://api.github.com/users/wildanm/followers","following_url":"https://api.github.com/users/wildanm/following{/other_user}","gists_url":"https://api.github.com/users/wildanm/gists{/gist_id}","starred_url":"https://api.github.com/users/wildanm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wildanm/subscriptions","organizations_url":"https://api.github.com/users/wildanm/orgs","repos_url":"https://api.github.com/users/wildanm/repos","events_url":"https://api.github.com/users/wildanm/events{/privacy}","received_events_url":"https://api.github.com/users/wildanm/received_events","type":"User","site_admin":false},"open_issues":17,"closed_issues":2,"state":"open","created_at":"2016-01-15T04:28:06Z","updated_at":"2016-02-01T20:26:22Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2016-02-01T20:26:22Z","updated_at":"2016-02-02T03:59:15Z","closed_at":null,"body":"1. pokok_bahasan.id_pokok_bahasan diubah dari serial menjadi characer varying (10)\r\n2. sub_pokok_bahasan.id_sub_pokok_bahasan diubah dari serial menjadi characer varying (10)\r\n3. sub_pokok_bahasan.id_pokok_bahasan diubah dari serial menjadi characer varying (10)"},"comment":{"url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/comments/178357734","html_url":"https://github.com/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20#issuecomment-178357734","issue_url":"https://api.github.com/repos/OpenThink-Labs/Sistem-Informasi-Bank-Soal/issues/20","id":178357734,"user":{"login":"wildanm","id":462398,"avatar_url":"https://avatars.githubusercontent.com/u/462398?v=3","gravatar_id":"","url":"https://api.github.com/users/wildanm","html_url":"https://github.com/wildanm","followers_url":"https://api.github.com/users/wildanm/followers","following_url":"https://api.github.com/users/wildanm/following{/other_user}","gists_url":"https://api.github.com/users/wildanm/gists{/gist_id}","starred_url":"https://api.github.com/users/wildanm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wildanm/subscriptions","organizations_url":"https://api.github.com/users/wildanm/orgs","repos_url":"https://api.github.com/users/wildanm/repos","events_url":"https://api.github.com/users/wildanm/events{/privacy}","received_events_url":"https://api.github.com/users/wildanm/received_events","type":"User","site_admin":false},"created_at":"2016-02-02T03:59:15Z","updated_at":"2016-02-02T03:59:15Z","body":"Jalankan SQL berikut : \r\n\r\nCREATE TABLE pokok_bahasan\r\n(\r\n  id_pokok_bahasan character varying(10),\r\n  id_mata_pelajaran integer NOT NULL,\r\n  nama character varying(100) NOT NULL,\r\n  CONSTRAINT pokok_bahasan_id_mata_pelajaran_fkey FOREIGN KEY (id_mata_pelajaran)\r\n      REFERENCES mata_pelajaran (id_mata_pelajaran) MATCH SIMPLE\r\n      ON UPDATE NO ACTION ON DELETE NO ACTION,\r\n  CONSTRAINT id_pokok_bahasan_pk PRIMARY KEY (id_pokok_bahasan)\r\n)\r\nWITH (\r\n  OIDS=FALSE\r\n);\r\nALTER TABLE pokok_bahasan\r\n  OWNER TO banksoal;\r\n\r\n-- Index: idx_pokok_bahasan_mp\r\n\r\n-- DROP INDEX idx_pokok_bahasan_mp;\r\n\r\nCREATE INDEX idx_pokok_bahasan_mata_pelajaran\r\n  ON pokok_bahasan\r\n  USING btree\r\n  (id_mata_pelajaran);\r\n\r\n-- Index: idx_pokok_bahasan\r\n\r\n-- DROP INDEX idx_pokok_bahasan;\r\n\r\nCREATE INDEX idx_pokok_bahasan\r\n  ON pokok_bahasan\r\n  USING btree\r\n  (id_pokok_bahasan);\r\n"}}