{"action":"created","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/1905","repository_url":"https://api.github.com/repos/tananaev/traccar","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/1905/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/1905/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/1905/events","html_url":"https://github.com/tananaev/traccar/issues/1905","id":151016519,"number":1905,"title":"Traccar server DB reset","user":{"login":"excepticons","id":15220791,"avatar_url":"https://avatars.githubusercontent.com/u/15220791?v=3","gravatar_id":"","url":"https://api.github.com/users/excepticons","html_url":"https://github.com/excepticons","followers_url":"https://api.github.com/users/excepticons/followers","following_url":"https://api.github.com/users/excepticons/following{/other_user}","gists_url":"https://api.github.com/users/excepticons/gists{/gist_id}","starred_url":"https://api.github.com/users/excepticons/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/excepticons/subscriptions","organizations_url":"https://api.github.com/users/excepticons/orgs","repos_url":"https://api.github.com/users/excepticons/repos","events_url":"https://api.github.com/users/excepticons/events{/privacy}","received_events_url":"https://api.github.com/users/excepticons/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-26T01:03:23Z","updated_at":"2016-04-26T15:27:26Z","closed_at":null,"body":"Hi, everybody. \r\nPlease, If I need to start from zero with Traccar server and clients (0 groups, 0 users, 0 devices, 0 positions), how can delete all rows of all tables and start again without a new install? VPS and DB server works fine. \r\nIs there any store procedure or script for that?\r\nThanks.\r\n\r\nGustavo."},"comment":{"url":"https://api.github.com/repos/tananaev/traccar/issues/comments/214782877","html_url":"https://github.com/tananaev/traccar/issues/1905#issuecomment-214782877","issue_url":"https://api.github.com/repos/tananaev/traccar/issues/1905","id":214782877,"user":{"login":"excepticons","id":15220791,"avatar_url":"https://avatars.githubusercontent.com/u/15220791?v=3","gravatar_id":"","url":"https://api.github.com/users/excepticons","html_url":"https://github.com/excepticons","followers_url":"https://api.github.com/users/excepticons/followers","following_url":"https://api.github.com/users/excepticons/following{/other_user}","gists_url":"https://api.github.com/users/excepticons/gists{/gist_id}","starred_url":"https://api.github.com/users/excepticons/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/excepticons/subscriptions","organizations_url":"https://api.github.com/users/excepticons/orgs","repos_url":"https://api.github.com/users/excepticons/repos","events_url":"https://api.github.com/users/excepticons/events{/privacy}","received_events_url":"https://api.github.com/users/excepticons/received_events","type":"User","site_admin":false},"created_at":"2016-04-26T15:27:26Z","updated_at":"2016-04-26T15:27:26Z","body":"Hi, Anton.\r\nI'm using a MySql database. I can see tables like users, groups, devices, positions, user-devices, etc.\r\nThank you.\r\n"}}