Skip to content

Instantly share code, notes, and snippets.

@NobodysNightmare

NobodysNightmare/schema.diff Secret

Created July 14, 2015 12:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NobodysNightmare/960f8719f36cf2f934f9 to your computer and use it in GitHub Desktop.
Save NobodysNightmare/960f8719f36cf2f934f9 to your computer and use it in GitHub Desktop.
Download ZIP
Diff between OpenProject Schema for PSQL and MySQL
Raw
schema.diff
diff --git a/db/my-schema.rb b/db/schema.rb
index 6cd1926..f753ec5 100644
--- a/db/my-schema.rb
+++ b/db/schema.rb
@@ -13,17 +13,16 @@
ActiveRecord::Schema.define(:version => 20150623151337) do
- create_table "aggregated_journals", :id => false, :force => true do |t|
- t.integer "id", :default => 0, :null => false
- t.integer "journable_id"
- t.string "journable_type"
- t.integer "user_id", :default => 0, :null => false
- t.text "notes"
- t.datetime "created_at", :null => false
- t.integer "version", :default => 0, :null => false
- t.string "activity_type"
+ create_table "announcements", :force => true do |t|
+ t.text "text"
+ t.date "show_until"
+ t.boolean "active", :default => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
+ add_index "announcements", ["show_until", "active"], :name => "index_announcements_on_show_until_and_active"
+
create_table "attachable_journals", :force => true do |t|
t.integer "journal_id", :null => false
t.integer "attachment_id", :null => false
@@ -89,12 +88,12 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
create_table "available_project_statuses", :force => true do |t|
t.integer "project_type_id"
t.integer "reported_project_status_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
- add_index "available_project_statuses", ["project_type_id"], :name => "index_timelines_available_project_statuses_on_project_type_id"
- add_index "available_project_statuses", ["reported_project_status_id"], :name => "index_avail_project_statuses_on_rep_project_status_id"
+ add_index "available_project_statuses", ["project_type_id"], :name => "index_taps_on_project_type_id"
+ add_index "available_project_statuses", ["reported_project_status_id"], :name => "index_taps_on_reported_project_status_id"
create_table "boards", :force => true do |t|
t.integer "project_id", :null => false
@@ -239,17 +238,16 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
end
create_table "custom_field_translations", :force => true do |t|
- t.integer "custom_field_id", :null => false
- t.string "locale", :null => false
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
- t.string "name"
+ t.integer "custom_field_id"
+ t.string "locale"
t.text "default_value"
t.text "possible_values"
+ t.string "name"
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
- add_index "custom_field_translations", ["custom_field_id"], :name => "index_custom_field_translations_on_custom_field_id"
- add_index "custom_field_translations", ["locale"], :name => "index_custom_field_translations_on_locale"
+ add_index "custom_field_translations", ["custom_field_id"], :name => "index_f42a0c96f950276606abbd14403e71f580e91394"
create_table "custom_fields", :force => true do |t|
t.string "type", :limit => 30, :default => "", :null => false
@@ -289,6 +287,7 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "customized_id", :default => 0, :null => false
t.integer "custom_field_id", :default => 0, :null => false
t.text "value"
+ t.integer "visible_to"
end
add_index "custom_values", ["custom_field_id"], :name => "index_custom_values_on_custom_field_id"
@@ -312,34 +311,13 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.datetime "locked_at"
t.datetime "failed_at"
t.string "locked_by"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.string "queue"
end
add_index "delayed_jobs", ["priority", "run_at"], :name => "delayed_jobs_priority"
- create_table "document_journals", :force => true do |t|
- t.integer "journal_id", :null => false
- t.integer "project_id", :default => 0, :null => false
- t.integer "category_id", :default => 0, :null => false
- t.string "title", :limit => 60, :default => "", :null => false
- t.text "description"
- t.datetime "created_on"
- end
-
- create_table "documents", :force => true do |t|
- t.integer "project_id", :default => 0, :null => false
- t.integer "category_id", :default => 0, :null => false
- t.string "title", :limit => 60, :default => "", :null => false
- t.text "description"
- t.datetime "created_on"
- end
-
- add_index "documents", ["category_id"], :name => "index_documents_on_category_id"
- add_index "documents", ["created_on"], :name => "index_documents_on_created_on"
- add_index "documents", ["project_id"], :name => "documents_project_id"
-
create_table "done_statuses_for_project", :id => false, :force => true do |t|
t.integer "project_id"
t.integer "status_id"
@@ -350,7 +328,7 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "name", :null => false
end
- add_index "enabled_modules", ["name"], :name => "index_enabled_modules_on_name", :length => {"name"=>8}
+ add_index "enabled_modules", ["name"], :name => "index_enabled_modules_on_name"
add_index "enabled_modules", ["project_id"], :name => "enabled_modules_project_id"
create_table "enumerations", :force => true do |t|
@@ -376,12 +354,6 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.text "description"
end
- create_table "foo", :force => true do |t|
- t.integer "user_id", :null => false
- t.datetime "created_at", :null => false
- t.string "foo", :limit => 50, :null => false
- end
-
create_table "group_users", :id => false, :force => true do |t|
t.integer "group_id", :null => false
t.integer "user_id", :null => false
@@ -389,6 +361,26 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
add_index "group_users", ["group_id", "user_id"], :name => "group_user_ids", :unique => true
+ create_table "issue_form_fields", :force => true do |t|
+ t.string "name", :null => false
+ t.text "default_value"
+ t.integer "position"
+ t.boolean "is_required"
+ t.boolean "is_hidden"
+ t.integer "issue_form_id"
+ t.boolean "set_default_value"
+ t.string "type"
+ t.integer "issue_custom_field_id"
+ end
+
+ create_table "issue_forms", :force => true do |t|
+ t.string "name", :null => false
+ t.text "description"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.integer "project_id"
+ end
+
create_table "journals", :force => true do |t|
t.integer "journable_id"
t.string "journable_type"
@@ -401,7 +393,6 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
add_index "journals", ["activity_type"], :name => "index_journals_on_activity_type"
add_index "journals", ["created_at"], :name => "index_journals_on_created_at"
- add_index "journals", ["journable_id", "journable_type", "version"], :name => "foo_index", :unique => true
add_index "journals", ["journable_id"], :name => "index_journals_on_journable_id"
add_index "journals", ["journable_type"], :name => "index_journals_on_journable_type"
add_index "journals", ["user_id"], :name => "index_journals_on_user_id"
@@ -414,25 +405,54 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.decimal "budget", :precision => 15, :scale => 4
end
+ create_table "landing_page_csses", :force => true do |t|
+ t.string "identifier"
+ t.text "css"
+ end
+
+ add_index "landing_page_csses", ["identifier"], :name => "index_landing_page_csses_on_identifier", :unique => true
+
+ create_table "landing_page_item_translations", :force => true do |t|
+ t.integer "landing_page_item_id"
+ t.string "locale"
+ t.text "html_content"
+ t.string "button_title"
+ t.string "title"
+ t.string "button_url"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ add_index "landing_page_item_translations", ["landing_page_item_id"], :name => "index_ee1598e9217f63d552b6c745fc0acab1bd681c6b"
+
+ create_table "landing_page_items", :force => true do |t|
+ t.string "name"
+ t.integer "position"
+ t.string "type"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.string "config", :default => "--- {}\n\n"
+ end
+
create_table "legacy_default_planning_element_types", :force => true do |t|
t.integer "project_type_id"
t.integer "planning_element_type_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
- add_index "legacy_default_planning_element_types", ["planning_element_type_id"], :name => "index_default_pe_types_on_pe_type_id"
- add_index "legacy_default_planning_element_types", ["project_type_id"], :name => "index_default_pe_types_on_project_type_id"
+ add_index "legacy_default_planning_element_types", ["planning_element_type_id"], :name => "index_tdpet_on_planning_element_type_id"
+ add_index "legacy_default_planning_element_types", ["project_type_id"], :name => "index_tdpet_on_project_type_id"
create_table "legacy_enabled_planning_element_types", :force => true do |t|
t.integer "project_id"
t.integer "planning_element_type_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
- add_index "legacy_enabled_planning_element_types", ["planning_element_type_id"], :name => "index_enabled_pe_types_on_pe_type_id"
- add_index "legacy_enabled_planning_element_types", ["project_id"], :name => "index_timelines_enabled_planning_element_types_on_project_id"
+ add_index "legacy_enabled_planning_element_types", ["planning_element_type_id"], :name => "index_tepet_on_planning_element_type_id"
+ add_index "legacy_enabled_planning_element_types", ["project_id"], :name => "index_tepet_on_project_id"
create_table "legacy_issues", :force => true do |t|
t.integer "tracker_id", :default => 0, :null => false
@@ -456,6 +476,10 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "root_id"
t.integer "lft"
t.integer "rgt"
+ t.integer "position"
+ t.integer "story_points"
+ t.float "remaining_hours"
+ t.integer "cost_object_id"
end
add_index "legacy_issues", ["assigned_to_id"], :name => "index_issues_on_assigned_to_id"
@@ -470,13 +494,13 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
add_index "legacy_issues", ["tracker_id"], :name => "index_issues_on_tracker_id"
create_table "legacy_journals", :force => true do |t|
- t.integer "journaled_id", :default => 0, :null => false
- t.integer "user_id", :default => 0, :null => false
+ t.integer "journaled_id", :default => 0, :null => false
+ t.integer "user_id", :default => 0, :null => false
t.text "notes"
- t.datetime "created_at", :null => false
- t.integer "version", :default => 0, :null => false
+ t.datetime "created_at", :null => false
+ t.integer "version", :default => 0, :null => false
t.string "activity_type"
- t.text "changed_data", :limit => 2147483647
+ t.text "changed_data"
t.string "type"
end
@@ -493,8 +517,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.boolean "is_default", :default => false, :null => false
t.integer "position", :default => 1
t.integer "color_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.integer "new_id"
end
@@ -511,8 +535,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "responsible_id"
t.integer "planning_element_type_id"
t.integer "planning_element_status_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.datetime "deleted_at"
t.integer "new_id"
end
@@ -550,8 +574,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "author_id"
t.text "text"
t.integer "lock_version"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.boolean "locked", :default => false
end
@@ -572,8 +596,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "name"
t.boolean "invited"
t.boolean "attended"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "meetings", :force => true do |t|
@@ -583,8 +607,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "location"
t.datetime "start_time"
t.float "duration"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "member_roles", :force => true do |t|
@@ -610,9 +634,9 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
create_table "menu_items", :force => true do |t|
t.string "name"
t.string "title"
+ t.integer "navigatable_id"
t.integer "parent_id"
t.text "options"
- t.integer "navigatable_id"
t.string "type"
end
@@ -694,15 +718,15 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "name", :null => false
t.string "hexcode", :null => false
t.integer "position", :default => 1
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "principal_roles", :force => true do |t|
t.integer "role_id", :null => false
t.integer "principal_id", :null => false
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "principal_roles", ["principal_id"], :name => "index_principal_roles_on_principal_id"
@@ -712,8 +736,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "project_a_id"
t.integer "project_b_id"
t.text "description"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "project_associations", ["project_a_id"], :name => "index_timelines_project_associations_on_project_a_id"
@@ -723,8 +747,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "name", :default => "", :null => false
t.boolean "allows_association", :default => true, :null => false
t.integer "position", :default => 1
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
create_table "projects", :force => true do |t|
@@ -739,7 +763,7 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "status", :default => 1, :null => false
t.integer "lft"
t.integer "rgt"
- t.text "summary"
+ t.text "summary", :default => ""
t.integer "project_type_id"
t.integer "responsible_id"
t.integer "work_packages_responsible_id"
@@ -799,8 +823,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "project_id"
t.integer "reporting_to_project_id"
t.integer "reported_project_status_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "reportings", ["project_id"], :name => "index_timelines_reportings_on_project_id"
@@ -808,14 +832,15 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
add_index "reportings", ["reporting_to_project_id"], :name => "index_timelines_reportings_on_reporting_to_project_id"
create_table "repositories", :force => true do |t|
- t.integer "project_id", :default => 0, :null => false
- t.string "url", :default => "", :null => false
- t.string "login", :limit => 60, :default => ""
- t.string "password", :default => ""
- t.string "root_url", :default => ""
+ t.integer "project_id", :default => 0, :null => false
+ t.string "url", :default => "", :null => false
+ t.string "login", :limit => 60, :default => ""
+ t.string "password", :default => ""
+ t.string "root_url", :default => ""
t.string "type"
- t.string "path_encoding", :limit => 64
- t.string "log_encoding", :limit => 64
+ t.string "path_encoding", :limit => 64
+ t.string "log_encoding", :limit => 64
+ t.text "checkout_settings"
end
add_index "repositories", ["project_id"], :name => "index_repositories_on_project_id"
@@ -905,8 +930,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
create_table "timelines", :force => true do |t|
t.string "name", :null => false
t.integer "project_id"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.text "options"
end
@@ -972,14 +997,15 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.string "identity_url"
t.string "mail_notification", :default => "", :null => false
t.boolean "first_login", :default => true, :null => false
- t.boolean "force_password_change", :default => false
+ t.boolean "force_password_reset", :default => false
t.integer "failed_login_count", :default => 0
t.datetime "last_failed_login_on"
+ t.boolean "force_password_change", :default => false
end
add_index "users", ["auth_source_id"], :name => "index_users_on_auth_source_id"
add_index "users", ["id", "type"], :name => "index_users_on_id_and_type"
- add_index "users", ["type", "login"], :name => "index_users_on_type_and_login", :length => {"type"=>nil, "login"=>255}
+ add_index "users", ["type", "login"], :name => "index_users_on_type_and_login"
add_index "users", ["type", "status"], :name => "index_users_on_type_and_status"
add_index "users", ["type"], :name => "index_users_on_type"
@@ -987,8 +1013,8 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "project_id"
t.integer "version_id"
t.integer "display"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "version_settings", ["project_id", "version_id"], :name => "index_version_settings_on_project_id_and_version_id"
@@ -1020,34 +1046,34 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
add_index "watchers", ["watchable_id", "watchable_type"], :name => "index_watchers_on_watchable_id_and_watchable_type"
create_table "wiki_content_journals", :force => true do |t|
- t.integer "journal_id", :null => false
- t.integer "page_id", :null => false
+ t.integer "journal_id", :null => false
+ t.integer "page_id", :null => false
t.integer "author_id"
- t.text "text", :limit => 2147483647
+ t.text "text"
end
add_index "wiki_content_journals", ["journal_id"], :name => "index_wiki_content_journals_on_journal_id"
create_table "wiki_content_versions", :force => true do |t|
- t.integer "wiki_content_id", :null => false
- t.integer "page_id", :null => false
+ t.integer "wiki_content_id", :null => false
+ t.integer "page_id", :null => false
t.integer "author_id"
- t.binary "data", :limit => 2147483647
- t.string "compression", :limit => 6, :default => ""
- t.string "comments", :default => ""
- t.datetime "updated_on", :null => false
- t.integer "version", :null => false
+ t.binary "data"
+ t.string "compression", :limit => 6, :default => ""
+ t.string "comments", :default => ""
+ t.datetime "updated_on", :null => false
+ t.integer "version", :null => false
end
add_index "wiki_content_versions", ["updated_on"], :name => "index_wiki_content_versions_on_updated_on"
add_index "wiki_content_versions", ["wiki_content_id"], :name => "wiki_content_versions_wcid"
create_table "wiki_contents", :force => true do |t|
- t.integer "page_id", :null => false
+ t.integer "page_id", :null => false
t.integer "author_id"
- t.text "text", :limit => 2147483647
- t.datetime "updated_on", :null => false
- t.integer "lock_version", :null => false
+ t.text "text"
+ t.datetime "updated_on", :null => false
+ t.integer "lock_version", :null => false
end
add_index "wiki_contents", ["author_id"], :name => "index_wiki_contents_on_author_id"
@@ -1132,10 +1158,10 @@ ActiveRecord::Schema.define(:version => 20150623151337) do
t.integer "root_id"
t.integer "lft"
t.integer "rgt"
- t.integer "cost_object_id"
t.integer "position"
t.integer "story_points"
t.float "remaining_hours"
+ t.integer "cost_object_id"
end
add_index "work_packages", ["assigned_to_id"], :name => "index_work_packages_on_assigned_to_id"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment