{"action":"created","issue":{"url":"https://api.github.com/repos/ArmaLife/Framework/issues/843","repository_url":"https://api.github.com/repos/ArmaLife/Framework","labels_url":"https://api.github.com/repos/ArmaLife/Framework/issues/843/labels{/name}","comments_url":"https://api.github.com/repos/ArmaLife/Framework/issues/843/comments","events_url":"https://api.github.com/repos/ArmaLife/Framework/issues/843/events","html_url":"https://github.com/ArmaLife/Framework/issues/843","id":163435301,"number":843,"title":"altislife.sql Import error","user":{"login":"judokan9","id":18271781,"avatar_url":"https://avatars.githubusercontent.com/u/18271781?v=3","gravatar_id":"","url":"https://api.github.com/users/judokan9","html_url":"https://github.com/judokan9","followers_url":"https://api.github.com/users/judokan9/followers","following_url":"https://api.github.com/users/judokan9/following{/other_user}","gists_url":"https://api.github.com/users/judokan9/gists{/gist_id}","starred_url":"https://api.github.com/users/judokan9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/judokan9/subscriptions","organizations_url":"https://api.github.com/users/judokan9/orgs","repos_url":"https://api.github.com/users/judokan9/repos","events_url":"https://api.github.com/users/judokan9/events{/privacy}","received_events_url":"https://api.github.com/users/judokan9/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-07-01T16:56:21Z","updated_at":"2016-07-01T20:13:26Z","closed_at":"2016-07-01T18:40:43Z","body":"SQL-Befehl:\r\n\r\n\r\nDELIMITER ;\r\n\r\n-- --------------------------------------------------------\r\n\r\n--\r\n-- Table structure for table `players`\r\n--\r\n\r\nCREATE TABLE IF NOT EXISTS `players` (\r\n  `uid` int(12) NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(32) NOT NULL,\r\n  `aliases` text NOT NULL,\r\n  `playerid` varchar(64) NOT NULL,\r\n  `cash` int(100) NOT NULL DEFAULT '0',\r\n  `bankacc` int(100) NOT NULL DEFAULT '0',\r\n  `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',\r\n  `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',\r\n  `civ_licenses` text NOT NULL,\r\n  `cop_licenses` text NOT NULL,\r\n  `med_licenses` text NOT NULL,\r\n  `civ_gear` text NOT NULL,\r\n  `cop_gear` text NOT NULL,\r\n  `med_gear` text NOT NULL,\r\n  `civ_stats` varchar(32) NOT NULL DEFAULT '\"[100,100,0]\"',\r\n  `cop_stats` varchar(32) NOT NULL DEFAULT '\"[100,100,0]\"',\r\n  `med_stats` varchar(32) NOT NULL DEFAULT '\"[100,100,0]\"',\r\n  `arrested` tinyint(1) NOT NULL DEFAULT '0',\r\n  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',\r\n  `donorlev[...]\r\nMySQL meldet: Dokumentation\r\n\r\n#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause "},"comment":{"url":"https://api.github.com/repos/ArmaLife/Framework/issues/comments/230037679","html_url":"https://github.com/ArmaLife/Framework/issues/843#issuecomment-230037679","issue_url":"https://api.github.com/repos/ArmaLife/Framework/issues/843","id":230037679,"user":{"login":"danielstuart14","id":8076962,"avatar_url":"https://avatars.githubusercontent.com/u/8076962?v=3","gravatar_id":"","url":"https://api.github.com/users/danielstuart14","html_url":"https://github.com/danielstuart14","followers_url":"https://api.github.com/users/danielstuart14/followers","following_url":"https://api.github.com/users/danielstuart14/following{/other_user}","gists_url":"https://api.github.com/users/danielstuart14/gists{/gist_id}","starred_url":"https://api.github.com/users/danielstuart14/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielstuart14/subscriptions","organizations_url":"https://api.github.com/users/danielstuart14/orgs","repos_url":"https://api.github.com/users/danielstuart14/repos","events_url":"https://api.github.com/users/danielstuart14/events{/privacy}","received_events_url":"https://api.github.com/users/danielstuart14/received_events","type":"User","site_admin":false},"created_at":"2016-07-01T20:13:26Z","updated_at":"2016-07-01T20:13:26Z","body":"```\r\n--\r\n-- Compatible with newer MySQL versions. (After MySQL-5.5)\r\n-- This SQL uses utf8mb4 and has CURRENT_TIMESTAMP function.\r\n--\r\n```\r\nfrom: https://github.com/ArmaLife/Framework/blob/master/altislife.sql"}}
{"actor":{"display_login":"danielstuart14"}}