Skip to content

Instantly share code, notes, and snippets.

@poikilotherm
Created November 18, 2014 08:40
Show Gist options
  • Save poikilotherm/76999dcd3faf1de5cc47 to your computer and use it in GitHub Desktop.
Save poikilotherm/76999dcd3faf1de5cc47 to your computer and use it in GitHub Desktop.
Just a test data set
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