SQLite format 3@ }m}.Ge2xG7=%indexUNIQ_1626CFE95E237E06kimai2_invoice_templatesCREATE UNIQUE INDEX UNIQ_1626CFE95E237E06 ON kimai2_invoice_templates (name)8==tablekimai2_invoice_templateskimai2_invoice_templatesCREATE TABLE kimai2_invoice_templates (id INTEGER NOT NULL, name VARCHAR(60) NOT NULL, title VARCHAR(255) NOT NULL, company VARCHAR(255) NOT NULL, address CLOB DEFAULT NULL, due_days INTEGER NOT NULL, vat INTEGER DEFAULT NULL, calculator VARCHAR(20) NOT NULL, number_generator VARCHAR(20) NOT NULL, renderer VARCHAR(20) NOT NULL, payment_terms CLOB DEFAULT NULL, PRIMARY KEY(id))t5-indexIDX_4F60C6B181C06096kimai2_timesheetCREATE INDEX IDX_4F60C6B181C06096 ON kimai2_timesheet (activity_id)m5-indexIDX_4F60C6B18D93D649kimai2_timesheetCREATE INDEX IDX_4F60C6B18D93D649 ON kimai2_timesheet (user)H--Ctablekimai2_timesheetkimai2_timesheetCREATE TABLE kimai2_timesheet (id INTEGER NOT NULL, user INTEGER DEFAULT NULL, activity_id INTEGER DEFAULT NULL, start_time DATETIME NOT NULL, end_time DATETIME DEFAULT NULL, duration INTEGER DEFAULT NULL, description CLOB DEFAULT NULL, rate NUMERIC(10, 2) NOT NULL, PRIMARY KEY(id))u 5/indexIDX_8811FE1C166D1F9Ckimai2_activitiesCREATE INDEX IDX_8811FE1C166D1F9C ON kimai2_activities (project_id)f //{tablekimai2_activitieskimai2_activities CREATE TABLE kimai2_activities (id INTEGER NOT NULL, project_id INTEGER DEFAULT NULL, name VARCHAR(150) NOT NULL, comment CLOB DEFAULT NULL, visible BOOLEAN NOT NULL, PRIMARY KEY(id))r 5+indexIDX_407F12069395C3F3kimai2_projects CREATE INDEX IDX_407F12069395C3F3 ON kimai2_projects (customer_id)! ++ytablekimai2_projectskimai2_projects CREATE TABLE kimai2_projects (id INTEGER NOT NULL, customer_id INTEGER DEFAULT NULL, name VARCHAR(150) NOT NULL, order_number CLOB DEFAULT NULL, comment CLOB DEFAULT NULL, visible BOOLEAN NOT NULL, budget NUMERIC(10, 2) NOT NULL, PRIMARY KEY(id))E --=tablekimai2_customerskimai2_customers CREATE TABLE kimai2_customers (id INTEGER NOT NULL, name VARCHAR(150) NOT NULL, number VARCHAR(50) DEFAULT NULL, comment CLOB DEFAULT NULL, visible BOOLEAN NOT NULL, company VARCHAR(255) DEFAULT NULL, contact VARCHAR(255) DEFAULT NULL, address CLOB DEFAULT NULL, country VARCHAR(2) NOT NULL, currency VARCHAR(3) NOT NULL, phone VARCHAR(255) DEFAULT NULL, fax VARCHAR(255) DEFAULT NULL, mobile VARCHAR(255) DEFAULT NULL, mail VARCHAR(255) DEFAULT NULL, homepage VARCHAR(255) DEFAULT NULL, timezone VARCHAR(255) NOT NULL, PRIMARY KEY(id))G;EindexUNIQ_8D08F631A76ED3955E237E06kimai2_user_preferences CREATE UNIQUE INDEX UNIQ_8D08F631A76ED3955E237E06 ON kimai2_user_preferences (user_id, name)~5;indexIDX_8D08F631A76ED395kimai2_user_preferencesCREATE INDEX IDX_8D08F631A76ED395 ON kimai2_user_preferences (user_id)`;;Wtablekimai2_user_preferenceskimai2_user_preferencesCREATE TABLE kimai2_user_preferences (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, name VARCHAR(50) NOT NULL, value VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))w7% indexUNIQ_B9AC5BCE5126AC48kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCE5126AC48 ON kimai2_users (mail)n7% indexUNIQ_B9AC5BCE5E237E06kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCE5E237E06 ON kimai2_users (name)%%ktablekimai2_userskimai2_usersCREATE TABLE kimai2_users (id INTEGER NOT NULL, name VARCHAR(60) NOT NULL, mail VARCHAR(160) NOT NULL, password VARCHAR(254) DEFAULT NULL, alias VARCHAR(60) DEFAULT NULL, active BOOLEAN NOT NULL, registration_date DATETIME DEFAULT NULL, title VARCHAR(50) DEFAULT NULL, avatar VARCHAR(255) DEFAULT NULL, roles CLOB NOT NULL --(DC2Type:array) , PRIMARY D113tablemigration_versionsmigration_versionsCREATE TABLE migration_versions (version VARCHAR(14) NOT NULL, executed_at DATETIME NOT NULL --(DC2Type:datetime_immutable) , PRIMARY KEY(version))CW1indexsqlite_autoindex_migration_versions_1V@$sQ> ' 6hB^8 z T .  p J $ f @  \ 6$')3202007252134242020-12-14 16:22:14$&)3202007051523102020-12-14 16:22:14$%)3202005241420422020-12-14 16:22:14$$)3202004131332262020-12-14 16:22:14$#)3202003231630392020-12-14 16:22:14$")3202003231630382020-12-14 16:22:14$!)3202003081719502020-12-14 16:22:14$ )3202002051152442020-12-14 16:22:14$)3202002051152432020-12-14 16:22:14$)3202002041244252020-12-14 16:22:14$)3202001251239422020-12-14 16:22:14$)3202001091021382020-12-14 16:22:14$)3201912041208232020-12-14 16:22:14$)3201911161101242020-12-14 16:22:14$)3201911131326402020-12-14 16:22:14$)3201911081515342020-12-14 16:22:14$)3201910241009512020-12-14 16:22:14$)3201908131626492020-12-14 16:22:14$)3201907301233242020-12-14 16:22:14$)3201907291626552020-12-14 16:22:14$)3201907062242192020-12-14 16:22:14$)3201907062242112020-12-14 16:22:14$)3201906171008452020-12-14 16:22:14$)3201906051711572020-12-14 16:22:14$)3201905102052452020-12-14 16:22:14$)3201905021617582020-12-14 16:22:14$ )3201903211812432020-12-14 16:22:14$ )3201903051523082020-12-14 16:22:14$ )3201902192000202020-12-14 16:22:14$ )3201902011503242020-12-14 16:22:14$ )3201901240040142020-12-14 16:22:14$)3201810312200032020-12-14 16:22:14$)3201809241118532020-12-14 16:22:14$)3201809051907372020-12-14 16:22:14$)3201809032022562020-12-14 16:22:14$)3201808051835272020-12-14 16:22:14$)3201807300441392020-12-14 16:22:14$)3201807151603262020-12-14 16:22:14$)3201807011200002020-12-14 16:22:14 ' |iVC0 r_L9& { h U B / )20200725213424')20200705152310&)20200524142042%)20200413133226$)20200323163039#)20200323163038")20200308171950!)20200205115244 )20200205115243)20200204124425)20200125123942)20200109102138)20191204120823)20191116110124)20191113132640)20191108151534)20191024100951)20190813162649)20190730123324)20190729162655)20190706224219)20190706224211)20190617100845)20190605171157)20190510205245)20190502161758)20190321181243 )20190305152308 )20190219200020 )20190201150324 )20190124004014 )20181031220003)20180924111853)20180905190737)20180903202256)20180805183527)20180730044139)20180715160326) 20180701120000  T9 z J{T &1##tablekimai2_tagskimai2_tags!CREATE TABLE kimai2_tags (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(100) NOT NULL, color VARCHAR(7) DEFAULT NULL)`==Stablekimai2_invoice_templateskimai2_invoice_templatesCREATE TABLE kimai2_invoice_templates (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title VARCHAR(255) NOT NULL COLLATE BINARY, company VARCHAR(255) NOT NULL COLLATE BINARY, address CLOB DEFAULT NULL COLLATE BINARY, due_days INTEGER NOT NULL, calculator VARCHAR(20) NOT NULL COLLATE BINARY, number_generator VARCHAR(20) NOT NULL COLLATE BINARY, renderer VARCHAR(20) NOT NULL COLLATE BINARY, payment_terms CLOB DEFAULT NULL COLLATE BINARY, name VARCHAR(60) NOT NULL, vat DOUBLE PRECISION DEFAULT 0, vat_id VARCHAR(50) DEFAULT NULL, contact CLOB DEFAULT NULL, payment_details CLOB DEFAULT NULL, decimal_duration BOOLEAN DEFAULT '0' NOT NULL, language VARCHAR(6) DEFAULT NULL)*>99otablekimai2_activities_metakimai2_activities_meta-CREATE TABLE kimai2_activities_meta (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, activity_id INTEGER NOT NULL, name VARCHAR(50) NOT NULL COLLATE BINARY, value VARCHAR(255) DEFAULT NULL COLLATE BINARY, visible BOOLEAN DEFAULT '0' NOT NULL)l27# indexUNIQ_27CAF54C5E237E06kimai2_tags"CREATE UNIQUE INDEX UNIQ_27CAF54C5E237E06 ON kimai2_tags (name)~,75indexUNIQ_1C5D63D85E237E06kimai2_configurationCREATE UNIQUE INDEX UNIQ_1C5D63D85E237E06 ON kimai2_configuration (name)C+55)tablekimai2_configurationkimai2_configurationCREATE TABLE kimai2_configuration (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(100) NOT NULL, value VARCHAR(255) DEFAULT NULL)7=%indexUNIQ_1626CFE95E237E06kimai2_invoice_templatesCREATE UNIQUE INDEX UNIQ_1626CFE95E237E06 ON kimai2_invoice_templates (name)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)o7%indexUNIQ_B9AC5BCEE7927C74kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCEE7927C74 ON kimai2_users (email)r7%indexUNIQ_B9AC5BCEF85E0677kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCEF85E0677 ON kimai2_users (username)|7%)indexUNIQ_B9AC5BCEC05FB297kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCEC05FB297 ON kimai2_users (confirmation_token)y7%#indexUNIQ_B9AC5BCEA0D96FBFkimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCEA0D96FBF ON kimai2_users (email_canonical)|7%)indexUNIQ_B9AC5BCE92FC23A8kimai2_usersCREATE UNIQUE INDEX UNIQ_B9AC5BCE92FC23A8 ON kimai2_users (username_canonical)v%%/tablekimai2_userskimai2_usersCREATE TABLE kimai2_users (id INTEGER NOT NULL, alias VARCHAR(60) DEFAULT NULL COLLATE BINARY, registration_date DATETIME DEFAULT NULL, title VARCHAR(50) DEFAULT NULL COLLATE BINARY, avatar VARCHAR(255) DEFAULT NULL COLLATE BINARY, enabled BOOLEAN NOT NULL, password VARCHAR(255) NOT NULL, roles CLOB NOT NULL --(DC2Type:array) , username VARCHAR(180) NOT NULL, username_canonical VARCHAR(180) NOT NULL, email VARCHAR(180) NOT NULL, email_canonical VARCHAR(180) NOT NULL, salt VARCHAR(255) DEFAULT NULL, last_login DATETIME DEFAULT NULL, confirmation_token VARCHAR(180) DEFAULT NULL, password_requested_at DATETIME DEFAULT NULL, api_token VARCHAR(255) DEFAULT NULL, auth VARCHAR(20) DEFAULT NULL, PRIMARY KEY(id))G;EindexUNIQ_8D08F631A76ED3955E237E06kimai2_user_preferences CREATE UNIQUE INDEX UNIQ_8D08F631A76ED3955E237E06 ON kimai2_user_preferences (user_id, name)~5;indexIDX_8D08F631A76ED395kimai2_user_preferencesCREATE INDEX IDX_8D08F631A76ED395 ON kimai2_user_preferences (user_id)`;;Wtablekimai2_user_preferenceskimai2_user_preferencesCREATE TABLE kimai2_user_preferences (id INTEGER NOT NULL, user_id INTEGER DEFAULT NULL, name VARCHAR(50) NOT NULL, value VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))CW1indexsqlite_autoindex_migration_versions_1migration_versionsD113tablemigration_versionsmigration_versionsCREATE TABLE migration_versions (version VARCHAR(14) NOT NULL, executed_at DATETIME NOT NULL --(DC2Type:datetime_immutable) , PRIMARY KEY(version))              tZA'+kimai2_invoices 7kimai2_timesheet_meta 5kimai2_projects_meta 7kimai2_customers_meta 9kimai2_activities_meta/kimai2_activities-kimai2_customers-kimai2_timesheet+kimai2_projects=kimai2_invoice_templates  }S 3 p '?G9KindexUNIQ_A7C0A43D81C060965E237E06kimai2_activities_meta.CREATE UNIQUE INDEX UNIQ_A7C0A43D81C060965E237E06 ON kimai2_activities_meta (activity_id, name)%++Mtablekimai2_projectskimai2_projects CREATE TABLE kimai2_projects (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, customer_id INTEGER NOT NULL, order_number CLOB DEFAULT NULL COLLATE BINARY, comment CLOB DEFAULT NULL COLLATE BINARY, visible BOOLEAN NOT NULL, fixed_rate DOUBLE PRECISION DEFAULT NULL, hourly_rate DOUBLE PRECISION DEFAULT NULL, color VARCHAR(7) DEFAULT NULL COLLATE BINARY, budget DOUBLE PRECISION DEFAULT '0' NOT NULL, time_budget INTEGER DEFAULT 0 NOT NULL, name VARCHAR(150) NOT NULL COLLATE BINARY, order_date DATETIME DEFAULT NULL, start DATETIME DEFAULT NULL, "end" DATETIME DEFAULT NULL, timezone VARCHAR(64) DEFAULT NULL)5+indexIDX_407F12069395C3F3kimai2_projects CREATE INDEX IDX_407F12069395C3F3 ON kimai2_projects (customer_id)NE/)indexIDX_8811FE1C7AB0E8595E237E06kimai2_activities2CREATE INDEX IDX_8811FE1C7AB0E8595E237E06 ON kimai2_activities (visible, name)$MU/QindexIDX_8811FE1C7AB0E859166D1F9C5E237E06kimai2_activities1CREATE INDEX IDX_8811FE1C7AB0E859166D1F9C5E237E06 ON kimai2_activities (visible, project_id, name)LE/5indexIDX_8811FE1C7AB0E859166D1F9Ckimai2_activities0CREATE INDEX IDX_8811FE1C7AB0E859166D1F9C ON kimai2_activities (visible, project_id)uK5/indexIDX_8811FE1C166D1F9Ckimai2_activitiesCREATE INDEX IDX_8811FE1C166D1F9C ON kimai2_activities (project_id)fJ//{tablekimai2_activitieskimai2_activities CREATE TABLE kimai2_activities (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, project_id INTEGER DEFAULT NULL, comment CLOB DEFAULT NULL COLLATE BINARY, visible BOOLEAN NOT NULL, fixed_rate DOUBLE PRECISION DEFAULT NULL, hourly_rate DOUBLE PRECISION DEFAULT NULL, color VARCHAR(7) DEFAULT NULL COLLATE BINARY, time_budget INTEGER DEFAULT 0 NOT NULL, budget DOUBLE PRECISION DEFAULT '0' NOT NULL, name VARCHAR(150) NOT NULL COLLATE BINARY)I57indexIDX_CB606CBAABDD46BEkimai2_timesheet_meta&CREATE INDEX IDX_CB606CBAABDD46BE ON kimai2_timesheet_meta (timesheet_id)HG7KindexUNIQ_CB606CBAABDD46BE5E237E06kimai2_timesheet_meta%CREATE UNIQUE INDEX UNIQ_CB606CBAABDD46BE5E237E06 ON kimai2_timesheet_meta (timesheet_id, name)(G77otablekimai2_timesheet_metakimai2_timesheet_meta#CREATE TABLE kimai2_timesheet_meta (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, timesheet_id INTEGER NOT NULL, name VARCHAR(50) NOT NULL COLLATE BINARY, value VARCHAR(255) DEFAULT NULL COLLATE BINARY, visible BOOLEAN DEFAULT '0' NOT NULL){F55indexIDX_50536EF2166D1F9Ckimai2_projects_meta,CREATE INDEX IDX_50536EF2166D1F9C ON kimai2_projects_meta (project_id)EG5EindexUNIQ_50536EF2166D1F9C5E237E06kimai2_projects_meta+CREATE UNIQUE INDEX UNIQ_50536EF2166D1F9C5E237E06 ON kimai2_projects_meta (project_id, name)#D55itablekimai2_projects_metakimai2_projects_meta*CREATE TABLE kimai2_projects_meta (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, project_id INTEGER NOT NULL, name VARCHAR(50) NOT NULL COLLATE BINARY, value VARCHAR(255) DEFAULT NULL COLLATE BINARY, visible BOOLEAN DEFAULT '0' NOT NULL)~C57indexIDX_A48A760F9395C3F3kimai2_customers_meta)CREATE INDEX IDX_A48A760F9395C3F3 ON kimai2_customers_meta (customer_id)BG7IindexUNIQ_A48A760F9395C3F35E237E06kimai2_customers_meta(CREATE UNIQUE INDEX UNIQ_A48A760F9395C3F35E237E06 ON kimai2_customers_meta (customer_id, name)'A77mtablekimai2_customers_metakimai2_customers_meta'CREATE TABLE kimai2_customers_meta (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, customer_id INTEGER NOT NULL, name VARCHAR(50) NOT NULL COLLATE BINARY, value VARCHAR(255) DEFAULT NULL COLLATE BINARY, visible BOOLEAN DEFAULT '0' NOT NULL)@59indexIDX_A7C0A43D81C06096kimai2_activities_meta/CREATE INDEX IDX_A7C0A43D81C06096 ON kimai2_activities_meta (activity_id)                DD  o T ? SO }$]U--mtablekimai2_timesheetkimai2_timesheetCREATE TABLE kimai2_timesheet (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, user INTEGER NOT NULL, activity_id INTEGER NOT NULL, project_id INTEGER NOT NULL, start_time DATETIME NOT NULL --(DC2Type:datetime) , timezone VARCHAR(64) NOT NULL COLLATE BINARY, duration INTEGER DEFAULT NULL, description CLOB DEFAULT NULL COLLATE BINARY, exported BOOLEAN NOT NULL, end_time DATETIME DEFAULT NULL --(DC2Type:datetime) , rate DOUBLE PRECISION NOT NULL, fixed_rate DOUBLE PRECISION DEFAULT NULL, hourly_rate DOUBLE PRECISION DEFAULT NULL, internal_rate DOUBLE PRECISION DEFAULT NULL, billable BOOLEAN DEFAULT '1', category VARCHAR(10) DEFAULT 'work' NOT NULL, modified_at DATETIME DEFAULT NULL)Ws!%windexroles_namekimai2_rolesKCREATE UNIQUE INDEX roles_name ON kimai2_roles (name) r%%Utablekimai2_roleskimai2_rolesJCREATE TABLE kimai2_roles (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name VARCHAR(50) NOT NULL)zo57indexIDX_9345D431296CD8AEkimai2_projects_teamsICREATE INDEX IDX_9345D431296CD8AE ON kimai2_projects_teams (team_id)}n57indexIDX_9345D431166D1F9Ckimai2_projects_teamsHCREATE INDEX IDX_9345D431166D1F9C ON kimai2_projects_teams (project_id)Im]7indexsqlite_autoindex_kimai2_projects_teams_1kimai2_projects_teamsG3l77tablekimai2_projects_teamskimai2_projects_teamsFCREATE TABLE kimai2_projects_teams (project_id INTEGER NOT NULL, team_id INTEGER NOT NULL, PRIMARY KEY(project_id, team_id))|k59indexIDX_50BD8388296CD8AEkimai2_customers_teamsECREATE INDEX IDX_50BD8388296CD8AE ON kimai2_customers_teams (team_id)j59indexIDX_50BD83889395C3F3kimai2_customers_teamsDCREATE INDEX IDX_50BD83889395C3F3 ON kimai2_customers_teams (customer_id)Ki_9indexsqlite_autoindex_kimai2_customers_teams_1kimai2_customers_teamsC8h99 tablekimai2_customers_teamskimai2_customers_teamsBCREATE TABLE kimai2_customers_teams (customer_id INTEGER NOT NULL, team_id INTEGER NOT NULL, PRIMARY KEY(customer_id, team_id))tg51indexIDX_B5E92CF8296CD8AEkimai2_users_teamsACREATE INDEX IDX_B5E92CF8296CD8AE ON kimai2_users_teams (team_id)tf51indexIDX_B5E92CF8A76ED395kimai2_users_teams?CREATE INDEX IDX_B5E92CF8A76ED395 ON kimai2_users_teams (user_id)CeW1indexsqlite_autoindex_kimai2_users_teams_1kimai2_users_teams>$d11stablekimai2_users_teamskimai2_users_teams=CREATE TABLE kimai2_users_teams (user_id INTEGER NOT NULL, team_id INTEGER NOT NULL, PRIMARY KEY(user_id, team_id))lc5% indexIDX_3BEDDC7F8F7DE5D7kimai2_teams