SQLite format 3@     H33  Do stuff2007-09-06 11:37:412007-09-06 11:37:13COMPLETED  estimates works tasks periods backlogs parties  Stufftttttt42 32007-09-06 11:37:41 qqL##atableschema_infoschema_infoCREATE TABLE schema_info (version integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)wtablebacklogsbacklogsCREATE TABLE backlogs ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(64) NOT NULL, "track_todo" boolean DEFAULT NULL, "track_done" boolean DEFAULT NULL, "track_times" boolean DEFAULT NULL, "enable_subtasks" boolean DEFAULT 'f' NOT NULL, "enable_customer" boolean DEFAULT NULL, "enable_users" boolean DEFAULT NULL, "invoice_code" varchar(255) DEFAULT NULL)m)tableestimatesestimatesCREATE TABLE estimates ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer NOT NULL, "todo" decimal(6,2) DEFAULT 1.0 NOT NULL, "created_at" datetime NOT NULL, "user_id" integer DEFAULT NULL)h+tablegroupsgroups CREATE TABLE groups ("party_id" integer NOT NULL, "name" varchar(255) NOT NULL) Bx%%3tablegroups_usersgroups_users CREATE TABLE groups_users ("group_id" integer NOT NULL, "user_id" integer NOT NULL)+a%]indexindex_groups_users_on_group_id_and_user_idgroups_users CREATE UNIQUE INDEX "index_groups_users_on_group_id_and_user_id" ON groups_users ("group_id", "user_id") ]tablepartiesparties CREATE TABLE parties ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255) DEFAULT NULL)Q ytableperiodsperiods CREATE TABLE periods ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer NOT NULL, "start_on" date NOT NULL, "end_on" date NOT NULL, "party_id" integer DEFAULT NULL)g !!tabletask_filestask_filesCREATE TABLE task_files ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer NOT NULL, "name" varchar(64) NOT NULL, "content_type" varchar(255) NOT NULL, "content_data" blob NOT NULL)    User !!2007-09-062007-09-09  7  tabletaskstasksCREATE TABLE tasks ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer DEFAULT NULL, "description" varchar(80) NOT NULL, "finished_at" datetime DEFAULT NULL, "initial_estimate" decimal(6,2) DEFAULT 1.0 NOT NULL, "period_id" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL, "parent_id" integer DEFAULT NULL, "resolution" varchar(16) DEFAULT NULL, "previous_task_id" integer DEFAULT NULL, "customer" varchar(64) DEFAULT NULL, "backlog_id" integer DEFAULT NULL, "notes" text DEFAULT NULL)F ktableusersusersCREATE TABLE users ("party_id" integer NOT NULL, "login" varchar(80) NOT NULL, "salted_password" varchar(40) NOT NULL, "email" varchar(60) NOT NULL, "first_name" varchar(40) DEFAULT NULL, "last_name" varchar(40) DEFAULT NULL, "salt" varchar(40) NOT NULL, "verified" boolean DEFAULT 'f', "security_token" varchar(40) DEFAULT NULL, "role" varchar(40) DEFAULT NULL, "token_expiry" datetime DEFAULT NULL, "deleted" boolean DEFAULT 'f') II4 ]%]]3uweb6406765910ce0f1d22a69add395d0f5db0f0917uwe@datek.noUweKubosch1f3dbbffd68e4f12ea0a8eeeb0f6658684f1d9b9tc650a2a08d2a674bf9e5b9ee21d3be4898a948c02007-09-07 11:29:15f 933?2007-09-06 11:45:002007-09-06 11:30:00f ,7tableworksworksCREATE TABLE works ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "task_id" integer NOT NULL, "hours" decimal(6,2) DEFAULT 0.0 NOT NULL, "completed_at" datetime DEFAULT NULL, "started_at" datetime DEFAULT NULL, "user_id" integer DEFAULT NULL, "invoice" boolean DEFAULT NULL)