Created
November 18, 2014 08:40
-
-
Save poikilotherm/76999dcd3faf1de5cc47 to your computer and use it in GitHub Desktop.
Just a test data set
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PRAGMA foreign_keys=OFF; | |
| BEGIN TRANSACTION; | |
| INSERT INTO "users" VALUES(1,'admin','$2y$10$azqlLpQDRv1MOQclyhgVPeFL0Rj6O9YMiiWTXLZMAqYMsQttD3Ypq',1,0,0,NULL,NULL,NULL,NULL,0,NULL); | |
| INSERT INTO "projects" VALUES(1,'Test',1,'',1416299176,0,0,0); | |
| INSERT INTO "columns" VALUES(1,'Backlog',1,1,4); | |
| INSERT INTO "columns" VALUES(2,'Ready',2,1,2); | |
| INSERT INTO "columns" VALUES(3,'Work in progress',3,1,1); | |
| INSERT INTO "columns" VALUES(4,'Done',4,1,0); | |
| INSERT INTO "tasks" VALUES(1,'Test','test #1',1414066449,'yellow',1,1,0,1,1,NULL,0,0,0,1,1414155137,'',NULL,0,0); | |
| INSERT INTO "tasks" VALUES(2,'Test1234','Test',1416299176,'yellow',1,1,0,2,1,NULL,0,0,0,1,1416299176,'',NULL,0,0); | |
| INSERT INTO "project_has_users" VALUES(1,1,1); | |
| INSERT INTO "comments" VALUES(1,1,1,1414068454,'Test',''); | |
| INSERT INTO "comments" VALUES(2,1,1,1414143759,'### Test | |
| * Liste 1 | |
| * Liste 2 | |
| * Liste 3 | |
| Test1234 | |
| Hallo!',''); | |
| INSERT INTO "comments" VALUES(3,1,1,1414156683,'test #1 test',''); | |
| INSERT INTO "last_logins" VALUES(1,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0',1414056548); | |
| INSERT INTO "last_logins" VALUES(2,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0',1414064768); | |
| INSERT INTO "last_logins" VALUES(3,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.152 Safari/537.36',1414070422); | |
| INSERT INTO "last_logins" VALUES(4,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.152 Safari/537.36',1414072184); | |
| INSERT INTO "last_logins" VALUES(5,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/33.0.1750.152 Safari/537.36',1414146686); | |
| INSERT INTO "last_logins" VALUES(6,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0',1414154419); | |
| INSERT INTO "last_logins" VALUES(7,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0',1414390275); | |
| INSERT INTO "last_logins" VALUES(8,'Database',1,'10.0.2.2','Mozilla/5.0 (X11; Linux x86_64; rv:33.0) Gecko/20100101 Firefox/33.0',1416299125); | |
| INSERT INTO "project_has_categories" VALUES(1,'Test',1); | |
| INSERT INTO "task_has_files" VALUES(1,'vi-vim-cheat-sheet.png','1/1/bc40c9d469914ab896e82c212cef4b21f717e061',1,1); | |
| INSERT INTO "settings" VALUES('board_highlight_period','172800'); | |
| INSERT INTO "settings" VALUES('board_public_refresh_interval','60'); | |
| INSERT INTO "settings" VALUES('board_private_refresh_interval','10'); | |
| INSERT INTO "settings" VALUES('board_columns',''); | |
| INSERT INTO "settings" VALUES('webhook_url_task_creation',NULL); | |
| INSERT INTO "settings" VALUES('webhook_url_task_modification',NULL); | |
| INSERT INTO "settings" VALUES('webhook_token','f796aaa389505811dd5293fda0dbc3e38221374f7e8cb43bd2e54318b9dd'); | |
| INSERT INTO "settings" VALUES('api_token','c14a14130d78f0326ebb45da855dbf2bc3735c036905ce30cdf01228d9e6'); | |
| INSERT INTO "settings" VALUES('application_language','en_US'); | |
| INSERT INTO "settings" VALUES('application_timezone','UTC'); | |
| INSERT INTO "settings" VALUES('application_url',''); | |
| INSERT INTO "settings" VALUES('application_date_format','m/d/Y'); | |
| INSERT INTO "settings" VALUES('icon_url_default',''); | |
| INSERT INTO "project_activities" VALUES(1,1414066449,'task.create',1,1,1,'a:1:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(2,1414068454,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"1";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414068454";s:7:"comment";s:4:"Test";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(3,1414069001,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"2";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414069001";s:7:"comment";s:1:"t";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(4,1414070334,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"3";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414070334";s:7:"comment";s:4:"test";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(5,1414070590,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"2";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414070590";s:7:"comment";s:1:"t";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(6,1414070641,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"2";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414070641";s:7:"comment";s:1:"t";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(7,1414070722,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"2";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414070722";s:7:"comment";s:1:"t";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(8,1414143759,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:0:"";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414066449";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"2";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414143759";s:7:"comment";s:64:"### Test | |
| * Liste 1 | |
| * Liste 2 | |
| * Liste 3 | |
| Test1234 | |
| Hallo!";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(9,1414155137,'task.update',1,1,1,'a:1:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:7:"test #1";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414155137";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(10,1414156683,'comment.create',1,1,1,'a:2:{s:4:"task";a:27:{s:2:"id";s:1:"1";s:9:"reference";s:0:"";s:5:"title";s:4:"Test";s:11:"description";s:7:"test #1";s:13:"date_creation";s:10:"1414066449";s:14:"date_completed";N;s:17:"date_modification";s:10:"1414155137";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"1";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}s:7:"comment";a:7:{s:2:"id";s:1:"3";s:7:"task_id";s:1:"1";s:7:"user_id";s:1:"1";s:4:"date";s:10:"1414156683";s:7:"comment";s:12:"test #1 test";s:8:"username";s:5:"admin";s:4:"name";N;}}'); | |
| INSERT INTO "project_activities" VALUES(11,1416299176,'task.create',1,1,2,'a:1:{s:4:"task";a:27:{s:2:"id";s:1:"2";s:9:"reference";s:0:"";s:5:"title";s:8:"Test1234";s:11:"description";s:4:"Test";s:13:"date_creation";s:10:"1416299176";s:14:"date_completed";N;s:17:"date_modification";s:10:"1416299176";s:8:"date_due";s:1:"0";s:12:"date_started";N;s:14:"time_estimated";s:1:"0";s:10:"time_spent";s:1:"0";s:8:"color_id";s:6:"yellow";s:10:"project_id";s:1:"1";s:9:"column_id";s:1:"1";s:8:"owner_id";s:1:"0";s:10:"creator_id";s:1:"1";s:8:"position";s:1:"2";s:9:"is_active";s:1:"1";s:5:"score";s:1:"0";s:11:"category_id";s:1:"0";s:13:"category_name";N;s:12:"project_name";s:4:"Test";s:12:"column_title";s:7:"Backlog";s:17:"assignee_username";N;s:13:"assignee_name";N;s:16:"creator_username";s:5:"admin";s:12:"creator_name";N;}}'); | |
| COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment