SQLite format 3@ {    !My backlogf %Your backlogf  estimates works!task_files tasks periods backlogs partiesB 32007-06-11T13:45:0032007-06-11T13:45:00 #first_group%second_group BA EE,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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)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+tablegroupsgroupsCREATE TABLE groups ("party_id" integer NOT NULL, "name" varchar(255) NOT NULL)x%%3tablegroups_usersgroups_usersCREATE TABLE groups_users ("group_id" integer NOT NULL, "user_id" integer NOT NULL)  BA B+a%]indexindex_groups_users_on_group_id_and_user_idgroups_usersCREATE 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)Qytableperiodsperiods 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_files CREATE 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) ~~~~RRRRUserUserUserUserUserwUserlUseraUserEUserGUserGroupDUserCUserGroupFUserAUser !!2007-06-252007-09-06!!2007-09-072907-07-22!!2007-06-112007-06-24 #'!text_file.txttext/plaindata1image.pngimage/pngdata2 {4]{933task in last period2007-08-02 14:15:42#!sub task2007-06-12&!!first task2007-06-11/!3third task2007-08-02 14:15:42'#!second task2007-06-12E)3!postponed task2007-08-02 14:15:422007-06-12POSTPONED2)3unplanned task2007-08-02 14:15:42&!!super task2007-06-12 7  tabletaskstasks CREATE 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', "role" varchar(40) DEFAULT NULL, "security_token" varchar(40) DEFAULT NULL, "token_expiry" datetime DEFAULT NULL, "deleted" boolean DEFAULT 'f') kCk %]=]BEdeleted_useref94c16f6c124a4e84cc215c164767bfa25f6e92deleted_user@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889tt? -]E]3IBGno_password_user8db087dd79f0f904be5027f27becd517a9df6055no_password_user@example.com48aaecbc8568ffb9913177d5369b54c5eb603237trandom_token_stringWed Sep 12 11:25:19 +0200 2007f  )]A]BDdeletable_userc841391e1d29100a4920de7a8fbb4b0fd180c6c0deletable_user@example.comc068e3671780f16898c0a8295ae8d82cc59713e2tf ]7]BClong_userc841391e1d29100a4920de7a8fbb4b0fd180c6c0long_user@example.comc068e3671780f16898c0a8295ae8d82cc59713e2tf= +]C]3IBFunverified_useref94c16f6c124a4e84cc215c164767bfa25f6e92unverified_user@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889frandom_token_stringWed Sep 12 11:25:19 +0200 2007fx ]/]BAteslaef94c16f6c124a4e84cc215c164767bfa25f6e92tesla@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889tf 0332007-06-12T14:35:002007-06-12T13:35:0032007-06-12T13:35:00 L ##atableschema_infoschema_infoCREATE TABLE schema_info (version integer), 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)  kCk %]=]BEdeleted_useref94c16f6c124a4e84cc215c164767bfa25f6e92deleted_user@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889tt? -]E]3IBGno_password_user8db087dd79f0f904be5027f27becd517a9df6055no_password_user@example.com48aaecbc8568ffb9913177d5369b54c5eb603237trandom_token_stringWed Sep 12 11:25:19 +0200 2007f  )]A]BDdeletable_userc841391e1d29100a4920de7a8fbb4b0fd180c6c0deletable_user@example.comc068e3671780f16898c0a8295ae8d82cc59713e2tf ]7]BClong_userc841391e1d29100a4920de7a8fbb4b0fd180c6c0long_user@example.comc068e3671780f16898c0a8295ae8d82cc59713e2tf= +]C]3IBFunverified_useref94c16f6c124a4e84cc215c164767bfa25f6e92unverified_user@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889frandom_token_stringWed Sep 12 11:25:19 +0200 2007fx ]/]BAteslaef94c16f6c124a4e84cc215c164767bfa25f6e92tesla@example.com7f8b036f9b647d46d22abdbfc8113f44a88f9889tf ]C]Boktesla5630d71b5014e559fed86da0094c2f1466ba12d1bad_login_tesla@example.comb0d9e7a483352f98203cd3e114cfb8b4dfe5b320ff