SQLite format 3@ - H@}=+indexissue_histories_issue_idissue_historiesCREATE INDEX "issue_histories_issue_id" ON "issue_histories" ("issue_id")++etableissue_historiesissue_historiesCREATE TABLE "issue_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issue_id" integer DEFAULT 0 NOT NULL, "status_id" integer DEFAULT 0 NOT NULL, "author_id" integer DEFAULT 0 NOT NULL, "notes" text, "created_on" datetime)C-+indexissue_categories_project_idissue_categoriesCREATE INDEX "issue_categories_project_id" ON "issue_categories" ("project_id")O --Qtableissue_categoriesissue_categoriesCREATE TABLE "issue_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL)@ %%Ctableenumerationsenumerations CREATE TABLE "enumerations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "opt" varchar(4) DEFAULT '' NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL)k 5indexdocuments_project_iddocuments CREATE INDEX "documents_project_id" ON "documents" ("project_id") otabledocumentsdocuments CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "category_id" integer DEFAULT 0 NOT NULL, "title" varchar(60) DEFAULT '' NOT NULL, "description" text, "created_on" datetime) ''_tablecustom_valuescustom_values CREATE TABLE "custom_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customized_type" varchar(30) DEFAULT '' NOT NULL, "customized_id" integer DEFAULT 0 NOT NULL, "custom_field_id" integer DEFAULT 0 NOT NULL, "value" text)699tablecustom_fields_trackerscustom_fields_trackers CREATE TABLE "custom_fields_trackers" ("custom_field_id" integer DEFAULT 0 NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL)699tablecustom_fields_projectscustom_fields_projectsCREATE TABLE "custom_fields_projects" ("custom_field_id" integer DEFAULT 0 NOT NULL, "project_id" integer DEFAULT 0 NOT NULL)S''etablecustom_fieldscustom_fieldsCREATE TABLE "custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "field_format" varchar(30) DEFAULT '' NOT NULL, "possible_values" text, "regexp" varchar DEFAULT '', "min_length" integer DEFAULT 0 NOT NULL, "max_length" integer DEFAULT 0 NOT NULL, "is_required" boolean DEFAULT 'f' NOT NULL, "is_for_all" boolean DEFAULT 'f' NOT NULL)U%%mtableauth_sourcesauth_sourcesCREATE TABLE "auth_sources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(60) DEFAULT '' NOT NULL, "host" varchar(60), "port" integer, "account" varchar(60), "account_password" varchar(60), "base_dn" varchar(255), "attr_login" varchar(30), "attr_firstname" varchar(30), "attr_lastname" varchar(30), "attr_mail" varchar(30), "onthefly_register" boolean DEFAULT 'f' NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##GtableattachmentsattachmentsCREATE TABLE "attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "container_id" integer DEFAULT 0 NOT NULL, "container_type" varchar(30) DEFAULT '' NOT NULL, "filename" varchar DEFAULT '' NOT NULL, "disk_filename" varchar DEFAULT '' NOT NULL, "filesize" integer DEFAULT 0 NOT NULL, "content_type" varchar(60) DEFAULT '', "digest" varchar(40) DEFAULT '' NOT NULL, "downloads" integer DEFAULT 0 NOT NULL, "author_id" integer DEFAULT 0 NOT NULL, "created_on" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsqgQw<r"THe6T#>) ysmga[UOIC=71+% }wqke_YSMGA;5/)#   x f T B 0  | j X F 4 "  w d Q > +   m Z G 4 !  v c P = *  lYF3  ubO<)~kXE2 taN;(}jWD1 s`M:'~)20160519161300})20150705172511|)20150528093249{)20150528092912z)20150528084820y)20150526183158x)20150525103953w)20150510083747v)20150208105930u)20150113213955t)20150113213922s)20150113211532r)20150113194759q)20141122124142p)20141109112308o)20141029181824n)20141029181752m)20140920094058l)20140903143914k)20140228130325j)20131218183023i)20131215104612h)20131214094309g)20131210180802f)20131124175346e)20131005100610d)20131004113137c)20130911193200b)20130729070143a)20130713111657`)20130713104233_)20130710182539^)20130602092539])20130217094251\)20130215111141[)20130215111127Z)20130215073721Y)20130207181455X)20130207175206W)20130202090625V)20130201184705U)20130110122628T)20121213084931S)20121209123358R)20121209123234Q)20121026003537P)20121026002032O)20120930112914N)20120731164049M)20120714122200L)20120714122100K)20120714122000J)20120707064544I)20120705074331H)20120422150750G)20120301153455F)20120223110929E)20120205111326D)20120127174243C)20120115143126B)20120115143100A)20120115143024@)20111201201315?)20110902000000>)20110511000000=)20110412065600<)20110408103312;)20110401192910:)201102280001009)201102280000008)201102271257507)201102261201326)201102261201125)201102240000004)201102231809533)201102231809442)201102201606261)201011141153590)20101114115114/)20101107130441.)20101104182107-)20100819172912,)20100705164950+)20100313171051*)20100313132032))20100221100219()20100129193813')20100129193402&)20091227112908%)20091225164732$)20091220184736#)20091220183727")20091220183509!)20091205124427 )20091123212029)20091114105931)20091108092559)20091025163651)20091017214750)20091017214720)20091017214644)20091017214611)20091017214519)20091017214440)20091017214406)20091017214336)20091017214308)20091017214236)20091017214136)20091017214107)20091017214015)20091017213910)20091017213835 )20091017213757 )20091017213716 )20091017213642 )20091017213536 )20091017213444)20091017213332)20091017213257)20091017213228)20091017213151)20091017213113)20091017213027)20091017212938)20091017212644)20091017212457)20091017212227~)20091010093521})20090704172358|)20090704172355{)20090704172350z)20090614091200y)20090503121510x)20090503121505w)20090503121501v)20090425161243u)20090406161854t)20090403001910s)20090401231134r)20090401221305q)20090323224724p)20090318181151o)20090312194159n)20090312172426m)20090214190337l108k107j106i105h104g103f102e101d100c99b98a97`96_95^94]93\92[91Z90Y89X88W87V86U85T84S83R82Q81P80O79N78M77L76K75J74I73H72G71F70E69D68C67B66A65@64?63>62=61<60;59:58957856755654553452351250149048/47.46-45,44+43*42)41(40'39&38%37$36#35"34!33 32313029282726252423222120191817161514 13 12 11 10 987654321 E = 5 - %   ~ u b O < )   | h T @ ,   x d P < (  t ` L 8 $ p\H4  lXD0|hT@,xdP<(t`L8$p\H4  lXD0wpib[TMF?81*#{tmf_XQJC<5.'      x q j c \ U)20150528084820)20150526183158)20150525103953)20150510083747)20150208105930)20150113213955)20150113213922)20150113211532)20150113194759)20141122124142)20141109112308)20141029181824)20141029181752)20140920094058)20140903143914)20140228130325)20131218183023)20131215104612)20131214094309)20131210180802)20131124175346)20131005100610)20131004113137)20130911193200)20130729070143)20130713111657)20130713104233)20130710182539)20130602092539)20130217094251)20130215111141)20130215111127)20130215073721)20130207181455)20130207175206)20130202090625)20130201184705)20130110122628)20121213084931)20121209123358)20121209123234)20121026003537)20121026002032)20120930112914)20120731164049)20120714122200)20120714122100)20120714122000)20120707064544)20120705074331)20120422150750)20120301153455)20120223110929)20120205111326)20120127174243)20120115143126)20120115143100)20120115143024)20111201201315)20110902000000)20110511000000)20110412065600)20110408103312)20110401192910)20110228000100)20110228000000)20110227125750)20110226120132)20110226120112)20110224000000)20110223180953)20110223180944)20110220160626)20101114115359)20101114115114)20101107130441)20101104182107)20100819172912)20100705164950)20100313171051)20100313132032)20100221100219)20100129193813)20100129193402)20091227112908)20091225164732)20091220184736)20091220183727)20091220183509)20091205124427)20091123212029)20091114105931)20091108092559)20091025163651)20091017214750)20091017214720)20091017214644)20091017214611)20091017214519)20091017214440)20091017214406)20091017214336)20091017214308)20091017214236)20091017214136)20091017214107)20091017214015)20091017213910)20091017213835)20091017213757)20091017213716)20091017213642)20091017213536)20091017213444)20091017213332)20091017213257)20091017213228)20091017213151)20091017213113)20091017213027)20091017212938)20091017212644)20091017212457)20091017212227)20091010093521~)20090704172358})20090704172355|)20090704172350{)20090614091200z)20090503121510y)20090503121505x)20090503121501w)20090425161243v)20090406161854u)20090403001910t)20090401231134s)20090401221305r)20090323224724q)20090318181151p)20090312194159o)20090312172426n)20090214190337m108l107k106j105i104h103g102f101e100d99c98b97a96`95_94^93]92\91[90Z89Y88X87W86V85U84T83S82R81Q80P79O78N77M76L75K74J73I72H71G70F69E68D67C66B65A64@63?62>61=60<59;58:57956855754653552451350249148047/46.45-44,43+42*41)40(39'38&37%36$35#34"33!32 31302928272625242322212019181716151413 12 11 10 9 8765)20120115143100  + email_addresses watchers u users roles              n " iVnni --tableissue_categoriesissue_categoriesCREATE TABLE "issue_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "assigned_to_id" integer)AI''9tablecustom_fieldscustom_fieldsCREATE TABLE "custom_fields" ("id" INTEGER PRIMARY KEY Ad''tablecustom_fieldscustom_fieldsCREATE TABLE "custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "field_format" varchar(30) DEFAULT '' NOT NULL, "possible_values" text, "regexp" varchar DEFAULT '', "min_length" integer DEFAULT 0 NOT NULL, "max_length" integer DEFAULT 0 NOT NULL, "is_required" boolean DEFAULT 'f' NOT NULL, "is_for_all" boolean DEFAULT 'f' NOT NULL, "is_filter" boolean DEFAULT 'f' NOT NULL, "position" integer DEFAULT 1, "searchable" boolean DEFAULT 'f', "default_value" text, "editable" boolean DEFAULT 't', "visible" boolean DEFAULT 't' NOT NULL, "multiple" boolean DEFAULT 'f', "format_store" text, "description" text)C-+indexissue_categories_project_idissue_categoriesCREATE INDEX "issue_categories_project_id" ON "issue_categories" ("project_id") --Qtableissue_categoriesissue_categoriesCREATE TABLE "issue_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "projec %%Utableenumerationsenumerations CREATE TABLE "enumerations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "opt" varchar(4) DEFAULT '' NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "position" integer DEFAULT 1, "is_default" boolean DEFAULT 'f' NOT NULL)k 5indexdocuments_project_iddocuments CREATE INDEX "documents_project_id" ON "documents" ("project_id") otabledocumentsdocuments CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "category_id" integer DEFAULT 0 NOT NULL, "title" varchar(60) DEFAULT '' NOT NULL, "description" text, "created_on" datetime) ''_tablecustom_valuescustom_values CREATE TABLE "custom_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customized_type" varchar(30) DEFAULT '' NOT NULL, "customized_id" integer DEFAULT 0 NOT NULL, "custom_field_id" integer DEFAULT 0 NOT NULL, "value" text)699tablecustom_fields_trackerscustom_fields_trackers CREATE TABLE "custom_fields_trackers" ("custom_field_id" integer DEFAULT 0 NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL)699tablecustom_fields_projectscustom_fields_projectsCREATE TABLE "custom_fields_projects" ("custom_field_id" integer DEFAULT 0 NOT NULL, "project_id" integer DEFAULT 0 NOT NULL) %%mtableauth_sourcesauth_sourcesCREATE TABLE "auth_sources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(60) DEFAULT '' NOT NULL, "host" varchar(60), "port" integer, "account" varchar(60), "account_password" varchar(60), "base_dn" varchar(255), "attr_login" varchar(30), "attr_firstname" varchar(30), "attr_lastname" varchar(30), "attr_mail" varchar(30), "onthefly_register" boolean DEFAULT 'f' NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)##y%%5tableauth_sourcesauth_sourcesCREATE TABLE "auth_sources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(60) DEFAULT '' NOT NULL, "host" varchar(60), "port" integer, "account" varchar(60), "account_password" varchar(60), "base_dn" varchar(255), "attr_login" varchar(30), "attr_firstname" varchar(30), "attr_lastname" varchar(30), "attr_mail" varchar(30), "onthefly_register" boolean DEFAULT 'f' NOT NULL, "tls" boolean DEFAULT 'f' NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)  `   gL(otablequeriesqueries*CREATE TABLE "queries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer, "name" varchar DEFAULT '' NOT NULL, "filters" text, "user_id" integer DEFAULT 0 NOT NULL, "is_public" boolean DEFAULT 'f' NOT NULL, "column_names" text, "sort_criteria" text, "group_by" varchar, "type" varchar)"!tableworkflowsworkflows%CREATE TABLE "workflows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL, "old_status_id" integer DEFAULT 0 NOT NULL, "new_status_id" integer DEFAULT 0 NOT NULL, "role_id" integer DEFAULT 0 NOT NULL, "assignee" boolean DEFAULT 'f' NOT NULL, "author" boolean DEFAULT 'f' NOT NULL, "type" varchar(30), "field_name" varchar(30), "rule" varchar(30)) &#tableissuesissuesCREATE TABLE "issues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "subject" varchar DEFAULT '' NOT NULL, "description" text, "due_date" date, "category_id" integer, "status_id" intezOtableissuesissuesCREATE TABLE "issues" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "subject" varchar DEFAULT '' NOT NULL, "description" text, "due_date" date, "category_id" integer, "status_id" integer DEFAULT 0 NOT NULL, "assigned_to_id" integer, "priority_id" integer DEFAULT 0 NOT NULL, "fixed_vel(/tablequeriesqueries*CREATE TABLE "queries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer, "name" varchar DEFAULT '' NOT NULL, "filters" text, "user_id" integer DEFAULT 0 NOT NULL, "is_public" boolean DEFAULT 'f' NOT NULL, "column_names" text, "sort_criteria" text, "group_by" varchar, "type" varchar, "visibility" integer DEFAULT 0)<'KtablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "commented_type" varchar(30) DEFAULT '' NOT NULL, "commented_id" integer DEFAULT 0 NOT NULL, "author_id" integer DEFAULT 0 NOT NULL, "comments" text, "created_on" datetime NOT NULL, "updated_on" datetime NOT NULL)i&--tableuser_preferencesuser_preferencesCREATE TABLE "user_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer DEFAULT 0 NOT NULL, "others" text, "hide_mail" boolean DEFAULT 'f', "time_zone" varchar)$;Cindexjournals_journalized_idjournals(CREATE INDEX "journals_journalized_id" ON "journals" ("journalized_id", "journalized_type")5 tablejournalsjournals&CREATE TABLE "journals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "journalized_id" integer DEFAULT 0 NOT NULL, "journalized_type" varchar(30) DEFAULT '' NOT NULL, "user_id" integer DEFAULT 0 NOT NULL, "notes" text, "created_on" datetime NOT NULL)ctableworkflowI"etablejournalsjournals&CREATE TABLE "journals" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "journalized_id" integer DEFAULT 0 NOT NULL, "journalized_type" varchar(30) DEFAULT '' NOT NULL, "user_id" integer DEFAULT 0 NOT NULL, "notes" text, "created_on" datetime NOT NULL, "private_notes" boolean DEFAULT 'f' NOT NULL)yMtabletokenstokensCREATE TABLE "tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer DEFAULT 0 NOT NULL, "action" varchar(30) DEFAULT '' NOT NULL, "value" varchar(40) DEFAULT '' NOT NULL, "created_on" datetime NOT NULL)V+{indexnews_project_idnewsCREATE INDEX "news_project_id" ON "news" ("project_id")<[tablenewsnewsCREATE TABLE "news" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer, "title" varchar(60) DEFAULT '' NOT NULL, "summary" varchar(255) DEFAULT '', "description" text, "author_id" integer DEFAULT 0 NOT NULL, "created_on" datetime, "comments_count" integer DEFAULT 0 NOT NULL)a/indexissues_project_idissuesCREATE INDEX "issues_project_id" ON "issues" ("project_id")      qD Z , v Q  z N +  ] - o - vHW/pE\1{@p34H %3repositorieschangeslabel_change_pluraltff;G 1;wikidestroy_attachmentlabel_attachment_deletefff4F )5wikiadd_attachmentlabel_attachment_newfff&E 'wikidestroybutton_deletefff(D 'boardsdestroybutton_deletefff#C #boardseditbutton_editfff!B !boardsnewbutton_addfff9A +7issue_relationsdestroylabel_relation_deletef=ff2@ +1issue_relationsnewlabel_relation_newf8ff(? +timelogeditbutton_log_timefff,> /projectsfeedslabel_feed_pluraltff(= %projectssearchlabel_searchtff)< 'projectsroadmaplabel_roadmaptkff"; %repositoriesdiffdifftff6: %5repositoriesrevisionlabel_view_revisionstff79 %5repositoriesrevisionslabel_view_revisionstff$8 %repositoriesentryentrytff,7 %%repositoriesbrowselabel_browsetff)6 %#repositoriesshowbutton_viewtff,5 'projectsadd_querybutton_createfXff54 +5newsdestroy_commentlabel_comment_deletefmff.3 #/newsadd_commentlabel_comment_addfjff(2 'issueshistorylabel_historytff&1 #projectsganttlabel_gantttff,0 )projectscalendarlabel_calendartff,/ )projectsactivitylabel_activitytff.. !-issuesexport_pdflabel_export_pdftff7- /-projectsexport_issues_pdflabel_export_pdftff*, )issuesadd_notelabel_add_notef!tf,+ ##projectsmove_issuesbutton_movef%ff/* %'versionsdestroy_filebutton_deletef*ff() !projectsadd_filebutton_addf(tf-( +versionsdownloadbutton_downloadtff+' !#projectslist_filesbutton_listtff@& 1;documentsdestroy_attachmentlabel_attachment_deletefff9% )5documentsadd_attachmentlabel_attachment_newftf+$ 'documentsdestroybutton_deletefff&# #documentseditbutton_editfff," %!projectsadd_documentbutton_addftf.! +documentsdownloadbutton_downloadtff& #documentsshowbutton_viewtff/ )#projectslist_documentsbutton_listtff& 'newsdestroybutton_deletefbff! #newseditbutton_editfaff( !projectsadd_newsbutton_addf`ff! #newsshowbutton_viewtMff* #projectslist_newsbutton_listtLff= 1;issuesdestroy_attachmentlabel_attachment_deletef3ff6 )5issuesadd_attachmentlabel_attachment_newf.tf( 'issuesdestroybutton_deletef)ff4 '3issueschange_statuslabel_change_statusf$tt# #issueseditbutton_editfff) !projectsadd_issuebutton_addftt+ +issuesdownloadbutton_downloadtff# #issuesshowbutton_viewtff7 /-projectsexport_issues_csvlabel_export_csvtff, ##projectslist_issuesbutton_listtff2 -'issue_categoriesdestroybutton_deletefff- -#issue_categorieseditbutton_editfff2 1!projectsadd_issue_categorybutton_addfff* 'versionsdestroybutton_deletefBff% #versionseditbutton_editfAff+ #!projectsadd_versionbutton_addf@ff) 'membersdestroybutton_deletefff$ #memberseditbutton_editfff* !!projectsadd_memberbutton_addfff- %#projectslist_membersbutton_listtff% #projectseditbutton_editfff, )projectssettingslabel_settingsfff3 %3reportsissue_reportlabel_report_pluraltnff. -projectschangeloglabel_change_logtiff' )projectsshowlabel_overviewtdff    %!  3Non membert--- - :view_issues &3Anonymoust--- - :view_issues   TT8]/ )] AAMadminaa668b1001ce588461736e0556144456562351e3RedmineAdmint2016-06-23 15:57:01.6157202016-06-23 15:57:01.615720Useralla12a619027907c3a1e547c25706249e0f  Je&   J^cec>%tableusersusers!CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(30) DEFAULT '' NOT NULL, "hashed_password" varchar(40) DEFAULT '' NOT NULL, "firstname" varchar(30) DEFAULT '' NOT NULL, "lastname" varchar(30) DEFAULT '' NOT NULL, "mail" varchar(60) DEFAULT '' NOT NULL, "mail_notification" boolean DEFAULT 't' NOT NULL, "admin" boolean DEFAULT 'f' NOT NULL, "status" integer DEFAULT 1 NOT NULL, "last_login_on" datetime, "language" varchar(5) DEFAULT '', "auth_source_id" integer, "created_on" datetime, "updated_on" datetime, "type" varchar, "identity_url" varchar){=++-tableissue_relationsissue_relations@CREATE TABLE "issue_relations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issue_from_id" integer NOT NULL, "issue_to_id" integer NOT NULL, "relation_type" varchar DEFAULT '' NOT NULL, "delay" integer)<7/Kindexchangesets_issues_idschangesets_issues?CREATE UNIQUE INDEX "changesets_issues_ids" ON "changesets_issues" ("changeset_id", "issue_id");//Ktablechangesets_issueschangesets_issues>CREATE TABLE "changesets_issues" ("changeset_id" integer NOT NULL, "issue_id" integer NOT NULL)R:wtablewatcherswatchers=CREATE TABLE "watchers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "watchable_type" varchar DEFAULT '' NOT NULL, "watchable_id" integer DEFAULT 0 NOT NULL, "user_id" integer)q57%indextime_entries_issue_idtime_entries8CREATE INDEX "time_entries_issue_id" ON "time_entries" ("issue_id")w4;%indextime_entries_project_idtime_entries7CREATE INDEX "time_entries_project_id" ON "time_entries" ("project_id");3%%9tabletime_entriestime_entries5CREATE TABLE "time_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "user_id" integer NOT NULL, "issue_id" integer, "hours" float NOT NULL, "comments" varchar(255), "activity_id" integer NOT NULL, "spent_on" date NOT NULL, "tyear" integer NOT NULL, "tmonth" integer NOT NULL, "tweek" integer NOT NULL, "created_on" datetime NOT NULL, "updated_on" datetime NOT NULL)2A7=indexwiki_content_versions_wcidwiki_content_versions4CREATE INDEX "wiki_content_versions_wcid" ON "wiki_content_versions" ("wiki_content_id")t177tablewiki_content_versionswiki_content_versions3CREATE TABLE "wiki_content_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "wiki_content_id" integer NOT NULL, "page_id" integer NOT NULL, "author_id" integer, "data" blob, "compression" varchar(6) DEFAULT '', "comments" varchar(255) DEFAULT '', "updated_on" datetime NOT NULL, "version" integer NOT NULL)r07'indexwiki_contents_page_idwiki_contents2CREATE INDEX "wiki_contents_page_id" ON "wiki_contents" ("page_id")/''etablewiki_contentswiki_contents1CREATE TABLE "wiki_contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer NOT NULL, "author_id" integer, "text" text, "comments" varchar(255) DEFAULT '', "updated_on" datetime NOT NULL, "version" integer NOT NULL){.=!%indexwiki_pages_wiki_id_titlewiki_pages0CREATE INDEX "wiki_pages_wiki_id_title" ON "wiki_pages" ("wiki_id", "title")-!!Wtablewiki_pageswiki_pages/CREATE TABLE "wiki_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "wiki_id" integer NOT NULL, "title" varchar(255) NOT NULL, "created_on" datetime NOT NULL, "protected" boolean DEFAULT 'f' NOT NULL, "parent_id" integer)Z,-indexwikis_project_idwikis.CREATE INDEX "wikis_project_id" ON "wikis" ("project_id")E+itablewikiswikis-CREATE TABLE "wikis" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "start_page" varchar(255) NOT NULL, "status" integer DEFAULT 1 NOT NULL)9tablesettingssettings,CREATE TABLE "settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "value" text, "updated_on" datetime) "     '              Z \c1T))tableissue_statusesissue_statusesCREATE TABLE "issue_statuses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "is_closed" boolean DEFAULT 'f' NOT NULL, "is_default" boolean DEFAULT 'f' NOT NULL, "position" integer DEFAULT 1, "default_done_ratio" integer)F%%tableenumerationse'P!tabletrackerstrackers CREATE TABLE "trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "is_in_chlog" boolean DEFAULT 'f' NOT NULL, "position" integer DEFAULT 1, "is_in_roadmap" boolean DEFAULT 't' NOT NULL, "fields_bits" integer DEFAULT 0);OUtablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "position" integer DEFAULT 1, "assignable" boolean DEFAULT 't', "builtin" integer DEFAULT 0 NOT NULL, "permissions" text, "issues_visibility" varchar(30) DEFAULT 'default' NOT NULL)_R/indexboards_project_idboardsBCREATE INDEX "boards_project_id" ON "boards" ("project_id") qtableboardsboardsACREATE TABLE "boards" ("id" INTEGER PRIMARY KEY AUTO}I))5tablewiki_redirectswiki_redirectsCREATE TABLE "wiki_redirects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "wiki_id" integer NObO#tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "position" integer DEFAULT 1, "assignable" boolean DEFAULT 't', "builtin" integer DEFAULT 0 NOT NULL, "permissions" text, "issues_visibility" varchar(30) DEFAULT 'default' NOT NULL, "users_visibility" varchar(30) DEFAULT 'all' NOT NULL, "time_entries_visibility" varchar(30) DEFAULT 'all' NOT NULL, "all_roles_managed" boolean DEFAULT 't' NOT NULL)DP[tabletrackerstrackers CREATE TABLE "trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "is_in_chlog" boolean DEFAULT 'f' NOT NULL, "position" integer DEFAULT 1, "is_in_roadmap" boolean DEFAULT 't' NOT NULL, "fields_bits" integer DEFAULT 0, "default_status_id" integer)`QtableboardsboardsACREATE TABLE "boards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer NOT NULL, "name" varchar DEFAULT '' NOT NULL, "description" varchar, "position" integer DEFAULT 1, "topics_count" integer DEFAULT 0 NOT NULL, "messages_count" integer DEFAULT 0 NOT NULL, "last_message_id" integer, "parent_id" integer)LA+'indexenabled_modules_project_idenabled_modulesGCREATE INDEX "enabled_modules_project_id" ON "enabled_modules" ("project_id")*K++ tableenabled_modulesenabled_modulesFCREATE TABLE "enabled_modules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer, "name" varchar NOT NULL)nE)5indexwiki_redirects_wiki_id_titlewiki_redirectsCREATE INDEX "wiki_redirects_wiki_id_title" ON "wiki_redirects" ("wiki_id", "title")))utablewiki_redirectswiki_redirectsCREATE TABLE "wiki_redirects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "wiki_id" integer NOT NULL, "title" varchar, "redirects_to" varchar, "created_on" datetime NOT NULL)H='Kindexcustom_values_customizedcustom_valuesCREATE INDEX "custom_values_customized" ON "custom_values" ("customized_type", "customized_id")dC1indexmessages_parent_idmessagesECREATE INDEX "messages_parent_id" ON "messages" ("parent_id")aB/indexmessages_board_idmessagesDCREATE INDEX "messages_board_id" ON "messages" ("board_id")#AtablemessagesmessagesCCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "board_id" integer NOT NULL, "parent_id" integer, "subject" varchar DEFAULT '' NOT NULL, "content" text, "author_id" integer, "replies_count" integer DEFAULT 0 NOT NULL, "last_reply_id" integer, "created_on" datetime NOT NULL, "updated_on" datetime NOT NULL, "locked" boolean DEFAULT 'f', "sticky" integer DEFAULT 0)    9  ;      A       N nN WF}zi%%7tablegroups_useZUtableversionsversions"CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "name" varchar DEFAULT '' NOT NULL, "description" varchar DEFAULT '', "effective_date" date, "created_on" datetime, "updated_on" datetime, "wiki_page_title" varchar, "status" varchar DEFAULT 'open', "sharing" varchar DEFAULT 'none' NOT NULL)4e;tablesettingssettings,CREATE TABLE "settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) DEFAULT '' NOT NULL, "value" text, "updated_on" datetime) VE//indexprojects_trackers_project_idprojects_trackersJCREATE INDEX "projects_trackers_project_id" ON "projects_trackers" ("project_id")"U//stableprojects_trackersprojects_trackersICREATE TABLE "projects_trackers" ("project_id" integer DEFAULT 0 NOT NULL, "tracker_id" integer DEFAULT 0 NOT NULL)d=/Qindexprojects_trackers_uniqueprojects_trackersOCREATE UNIQUE INDEX "projects_trackers_unique" ON "projects_trackers" ("project_id", "tracker_id")zc7-indexwatchers_user_id_typewatchersNCREATE INDEX "watchers_user_id_type" ON "watchers" ("user_id", "watchable_type")rbGGctableopen_id_authentication_noncesopen_id_authentication_noncesMCREATE TABLE "open_id_authentication_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" integer NOT NULL, "server_url" varchar, "salt" varchar NOT NULL)'aSS5tableopen_id_authentication_associationsopen_id_authentication_associationsLCREATE TABLE "open_id_authentication_associations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issued" integer, "lifetime" integer, "handle" varchar, "assoc_type" varchar, "server_url" blob, "secret" blob) 6'itableprojectsprojectsCREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(30) DEFAULT '' NOT NULL, "description" text, "homepage" varchar DEFAULT '', "is_public" boolean DEFAULT 't' NOT NULL, "parent_id" integer, "created_on" datetime, "updated_on" datetime, "identifier" varchar(20), "status" integer DEFAULT 1 NOT NULL, "lft" integer, "rgt" integer) 6;indexchangesets_changeset_idchanges%%tableauth_sourcesauth_sourcesCREATE TABLE "auth_sources" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(30) DEFAULT '' NOT NULL, "name" varchar(60) DEFAULT '' NOT NULL, "host" varchar(60), "port" integer, "account" varchar, "account_password" varchar DEFAULT '', "base_dn" varchar(255), "attr_login" varchar(30), "attr_firstname" varchar(30), "attr_lastname" varchar(30), "attr_mail" varchar(30), "onthefly_register" boolean DEFAULT 'f' NOT NULL, "tls" boolean DEFAULT 'f' NOT NULL, "filter" varchar, "timeout" integer)    d     m me;7indexindex_projects_on_rgtprojectsCREATE INDEX "index_projects_on_rgt" ON "projects" ("rgt")e:7indexindex_projects_on_lftprojectsCREATE INDEX "index_projects_on_lft" ON "projects" ("lft")atableprojectsprojectsCREATE TABLE "projects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar DEFAULT '' NOT NULL, "description" text, "homepage" varchar DEFAULT '', "is_public" boolean DEFAULT 't' NOT NULL, "parent_id" integer, "created_on" datetime, "updated_on" datetime, "identifier" varchar(20), "status" integer DEFAULT 1 NOT NULL, "lft" integer, "rgt" integer) 8[Uindexindex_members_on_user_id_and_project_idmembersCREATE UNIQUE INDEX "index_members_on_user_id_and_project_id" ON "members" ("user_id", "project_id")o7;indexchangesets_changeset_idchanges61=60<59;58:57956855754653552451350249148047/46.45-44,43+42*41)40(39'38&37%36$35#34"33!32 3130?2928272625242322212019181716151413 12 11 10 *9 $8765 432 1 t`L8$p\H4  l X D 0   | h T @ ,   %  ~ w p i b [ T M G @ 9 2 + $      ~ w p i c \ U N G @ 9 2 + $      x q j c \ U N G @ 9)20160519161300)20150705172511)2015052809324999c98b97a96`95_94^93]92\91[90Z9 89Y88X87W86V85U84T83S82R81Q80P879O78N77M76L75K74J73I72H71G70F769E68D67C66B65A64@63?62>61=60<659;58:579568557546535524513502549148047/46.45-44,43+42*41)40(439'38&37%36$35#34"33!32 31303292827262524232221)20150528092912)20150528084820)20150526183158)20150525103953)20150510083747)20150208105930)20150113213955)20150113213922)20150113211532)20150113194759)20141122124142)20141109112308)20141029181824)20141029181752)20140920094058)20140903143914)20140228130325)20131218183023)20131215104612)20131214094309)20131210180802)20131124175346)20131005100610)20131004113137)20130911193200)20130729070143)20130713111657)20130713104233)20130710182539)20130602092539)20130217094251)20130215111141)20130215111127)20130215073721)20130207181455)20130207175206)20130202090625)20130201184705)20130110122628)20121213084931)20121209123358)20121209123234)20121026003537)20121026002032)20120930112914)20120731164049)20120714122200)20120714122100)20120714122000)20120707064544)20120705074331)20120422150750)20120301153455)20120223110929)20120205111326)20120127174243)20120115143126     #  !  " d"=;7indexentity_assignment_idx_toeasy_entity_assignmentsCREATE INDEX "entity_assignment_idx_to" ON "easy_entity_assignments" ("entity_to_id")A;?indexentity_assignment_idx_fromeasy_entity_assignmentsCREATE INDEX "entity_assignment_idx_from" ON "easy_entity_assignments" ("entity_from_id")K7;/indexentity_assignment_idxeasy_entity_assignmentsCREATE UNIQUE INDEX "entity_assignment_idx" ON "easy_entity_assignments" ("entity_from_type", "entity_from_id", "entity_to_type", "entity_to_id")*;;itableeasy_entity_assignmentseasy_entity_assignmentsCREATE TABLE "easy_entity_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "entity_from_id" integer, "entity_from_type" varchar, "entity_to_id" integer, "entity_to_type" varchar, "created_at" datetime, "updated_at" datetime)/~a'aindexindex_easy_settings_on_name_and_project_ideasy_settingsCREATE UNIQUE INDEX "index_easy_settings_on_name_and_project_id" ON "easy_settings" ("name", "project_id")}O'1indexindex_easy_settings_on_project_ideasy_settingsCREATE INDEX "index_easy_settings_on_project_id" ON "easy_settings" ("project_id"):|''1tableeasy_settingseasy_settingsCREATE TABLE "easy_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "name" varchar, "value" text, "project_id" integer)_{}3indexindex_roles_managed_roles_on_role_id_and_managed_role_idroles_managed_rolesCREATE UNIQUE INDEX "index_roles_managed_roles_on_role_id_and_managed_role_id" ON "roles_managed_roles" ("role_id", "managed_role_id")z33Stableroles_managed_rolesroles_managed_rolesCREATE TABLE "roles_managed_roles" ("role_id" integer NOT NULL, "managed_role_id" integer NOT NULL)~yG!indexindex_documents_on_created_ondocumentsCREATE INDEX "index_documents_on_created_on" ON "documents" ("created_on")xI%indexindex_documents_on_category_iddocumentsdCREATE INDEX "index_documents_on_category_id" ON "documents" ("category_id")kw5indexdocuments_project_iddocuments CREATE INDEX "documents_project_id" ON "documents" ("project_id") vgtabledocumentsdocuments CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "project_id" integer DEFAULT 0 NOT NULL, "category_id" integer DEFAULT 0 NOT NULL, "title" varchar DEFAULT '' NOT NULL, "description" text, "created_on" datetime) uM+-indexindex_email_addresses_on_user_idemail_addressesCREATE INDEX "index_email_addresses_on_user_id" ON "email_addresses" ("user_id")[t3yindexindex_users_on_typeusersCREATE INDEX "index_users_on_type" ON "users" ("type")ysG!indexindex_users_on_auth_source_idusers~CREATE INDEX "index_users_on_auth_source_id" ON "users" ("auth_source_id")orAindexindex_users_on_id_and_typeusers}CREATE INDEX "index_users_on_id_and_type" ON "users" ("id", "type")