Defect #23586 ยป key_too_long_fix.patch
| /opt/redmine-3.4.4/db/migrate/001_setup.rb 2018-01-11 17:49:27.117905131 +0200 | ||
|---|---|---|
| 25 | 25 |
class Permission < ActiveRecord::Base; end |
| 26 | 26 | |
| 27 | 27 |
def self.up |
| 28 |
create_table "attachments", :force => true do |t| |
|
| 28 |
create_table "attachments", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 29 | 29 |
t.column "container_id", :integer, :default => 0, :null => false |
| 30 | 30 |
t.column "container_type", :string, :limit => 30, :default => "", :null => false |
| 31 | 31 |
t.column "filename", :string, :default => "", :null => false |
| ... | ... | |
| 38 | 38 |
t.column "created_on", :timestamp |
| 39 | 39 |
end |
| 40 | 40 | |
| 41 |
create_table "auth_sources", :force => true do |t| |
|
| 41 |
create_table "auth_sources", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 42 | 42 |
t.column "type", :string, :limit => 30, :default => "", :null => false |
| 43 | 43 |
t.column "name", :string, :limit => 60, :default => "", :null => false |
| 44 | 44 |
t.column "host", :string, :limit => 60 |
| ... | ... | |
| 53 | 53 |
t.column "onthefly_register", :boolean, :default => false, :null => false |
| 54 | 54 |
end |
| 55 | 55 | |
| 56 |
create_table "custom_fields", :force => true do |t| |
|
| 56 |
create_table "custom_fields", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 57 | 57 |
t.column "type", :string, :limit => 30, :default => "", :null => false |
| 58 | 58 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 59 | 59 |
t.column "field_format", :string, :limit => 30, :default => "", :null => false |
| ... | ... | |
| 65 | 65 |
t.column "is_for_all", :boolean, :default => false, :null => false |
| 66 | 66 |
end |
| 67 | 67 | |
| 68 |
create_table "custom_fields_projects", :id => false, :force => true do |t| |
|
| 68 |
create_table "custom_fields_projects", :id => false, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 69 | 69 |
t.column "custom_field_id", :integer, :default => 0, :null => false |
| 70 | 70 |
t.column "project_id", :integer, :default => 0, :null => false |
| 71 | 71 |
end |
| 72 | 72 | |
| 73 |
create_table "custom_fields_trackers", :id => false, :force => true do |t| |
|
| 73 |
create_table "custom_fields_trackers", :id => false, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 74 | 74 |
t.column "custom_field_id", :integer, :default => 0, :null => false |
| 75 | 75 |
t.column "tracker_id", :integer, :default => 0, :null => false |
| 76 | 76 |
end |
| 77 | 77 | |
| 78 |
create_table "custom_values", :force => true do |t| |
|
| 78 |
create_table "custom_values", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 79 | 79 |
t.column "customized_type", :string, :limit => 30, :default => "", :null => false |
| 80 | 80 |
t.column "customized_id", :integer, :default => 0, :null => false |
| 81 | 81 |
t.column "custom_field_id", :integer, :default => 0, :null => false |
| 82 | 82 |
t.column "value", :text |
| 83 | 83 |
end |
| 84 | 84 | |
| 85 |
create_table "documents", :force => true do |t| |
|
| 85 |
create_table "documents", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 86 | 86 |
t.column "project_id", :integer, :default => 0, :null => false |
| 87 | 87 |
t.column "category_id", :integer, :default => 0, :null => false |
| 88 | 88 |
t.column "title", :string, :limit => 60, :default => "", :null => false |
| ... | ... | |
| 92 | 92 | |
| 93 | 93 |
add_index "documents", ["project_id"], :name => "documents_project_id" |
| 94 | 94 | |
| 95 |
create_table "enumerations", :force => true do |t| |
|
| 95 |
create_table "enumerations", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 96 | 96 |
t.column "opt", :string, :limit => 4, :default => "", :null => false |
| 97 | 97 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 98 | 98 |
end |
| 99 | 99 | |
| 100 |
create_table "issue_categories", :force => true do |t| |
|
| 100 |
create_table "issue_categories", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 101 | 101 |
t.column "project_id", :integer, :default => 0, :null => false |
| 102 | 102 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 103 | 103 |
end |
| 104 | 104 | |
| 105 | 105 |
add_index "issue_categories", ["project_id"], :name => "issue_categories_project_id" |
| 106 | 106 | |
| 107 |
create_table "issue_histories", :force => true do |t| |
|
| 107 |
create_table "issue_histories", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 108 | 108 |
t.column "issue_id", :integer, :default => 0, :null => false |
| 109 | 109 |
t.column "status_id", :integer, :default => 0, :null => false |
| 110 | 110 |
t.column "author_id", :integer, :default => 0, :null => false |
| ... | ... | |
| 114 | 114 | |
| 115 | 115 |
add_index "issue_histories", ["issue_id"], :name => "issue_histories_issue_id" |
| 116 | 116 | |
| 117 |
create_table "issue_statuses", :force => true do |t| |
|
| 117 |
create_table "issue_statuses", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 118 | 118 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 119 | 119 |
t.column "is_closed", :boolean, :default => false, :null => false |
| 120 | 120 |
t.column "is_default", :boolean, :default => false, :null => false |
| 121 | 121 |
t.column "html_color", :string, :limit => 6, :default => "FFFFFF", :null => false |
| 122 | 122 |
end |
| 123 | 123 | |
| 124 |
create_table "issues", :force => true do |t| |
|
| 124 |
create_table "issues", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 125 | 125 |
t.column "tracker_id", :integer, :default => 0, :null => false |
| 126 | 126 |
t.column "project_id", :integer, :default => 0, :null => false |
| 127 | 127 |
t.column "subject", :string, :default => "", :null => false |
| ... | ... | |
| 140 | 140 | |
| 141 | 141 |
add_index "issues", ["project_id"], :name => "issues_project_id" |
| 142 | 142 | |
| 143 |
create_table "members", :force => true do |t| |
|
| 143 |
create_table "members", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 144 | 144 |
t.column "user_id", :integer, :default => 0, :null => false |
| 145 | 145 |
t.column "project_id", :integer, :default => 0, :null => false |
| 146 | 146 |
t.column "role_id", :integer, :default => 0, :null => false |
| 147 | 147 |
t.column "created_on", :timestamp |
| 148 | 148 |
end |
| 149 | 149 | |
| 150 |
create_table "news", :force => true do |t| |
|
| 150 |
create_table "news", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 151 | 151 |
t.column "project_id", :integer |
| 152 | 152 |
t.column "title", :string, :limit => 60, :default => "", :null => false |
| 153 | 153 |
t.column "summary", :string, :limit => 255, :default => "" |
| ... | ... | |
| 158 | 158 | |
| 159 | 159 |
add_index "news", ["project_id"], :name => "news_project_id" |
| 160 | 160 | |
| 161 |
create_table "permissions", :force => true do |t| |
|
| 161 |
create_table "permissions", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 162 | 162 |
t.column "controller", :string, :limit => 30, :default => "", :null => false |
| 163 | 163 |
t.column "action", :string, :limit => 30, :default => "", :null => false |
| 164 | 164 |
t.column "description", :string, :limit => 60, :default => "", :null => false |
| ... | ... | |
| 168 | 168 |
t.column "mail_enabled", :boolean, :default => false, :null => false |
| 169 | 169 |
end |
| 170 | 170 | |
| 171 |
create_table "permissions_roles", :id => false, :force => true do |t| |
|
| 171 |
create_table "permissions_roles", :id => false, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 172 | 172 |
t.column "permission_id", :integer, :default => 0, :null => false |
| 173 | 173 |
t.column "role_id", :integer, :default => 0, :null => false |
| 174 | 174 |
end |
| 175 | 175 | |
| 176 | 176 |
add_index "permissions_roles", ["role_id"], :name => "permissions_roles_role_id" |
| 177 | 177 | |
| 178 |
create_table "projects", :force => true do |t| |
|
| 178 |
create_table "projects", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 179 | 179 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 180 | 180 |
t.column "description", :string, :default => "", :null => false |
| 181 | 181 |
t.column "homepage", :string, :limit => 60, :default => "" |
| ... | ... | |
| 186 | 186 |
t.column "updated_on", :timestamp |
| 187 | 187 |
end |
| 188 | 188 | |
| 189 |
create_table "roles", :force => true do |t| |
|
| 189 |
create_table "roles", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 190 | 190 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 191 | 191 |
end |
| 192 | 192 | |
| 193 |
create_table "tokens", :force => true do |t| |
|
| 193 |
create_table "tokens", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 194 | 194 |
t.column "user_id", :integer, :default => 0, :null => false |
| 195 | 195 |
t.column "action", :string, :limit => 30, :default => "", :null => false |
| 196 | 196 |
t.column "value", :string, :limit => 40, :default => "", :null => false |
| 197 | 197 |
t.column "created_on", :datetime, :null => false |
| 198 | 198 |
end |
| 199 | 199 | |
| 200 |
create_table "trackers", :force => true do |t| |
|
| 200 |
create_table "trackers", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 201 | 201 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 202 | 202 |
t.column "is_in_chlog", :boolean, :default => false, :null => false |
| 203 | 203 |
end |
| 204 | 204 | |
| 205 |
create_table "users", :force => true do |t| |
|
| 205 |
create_table "users", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 206 | 206 |
t.column "login", :string, :limit => 30, :default => "", :null => false |
| 207 | 207 |
t.column "hashed_password", :string, :limit => 40, :default => "", :null => false |
| 208 | 208 |
t.column "firstname", :string, :limit => 30, :default => "", :null => false |
| ... | ... | |
| 218 | 218 |
t.column "updated_on", :timestamp |
| 219 | 219 |
end |
| 220 | 220 | |
| 221 |
create_table "versions", :force => true do |t| |
|
| 221 |
create_table "versions", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 222 | 222 |
t.column "project_id", :integer, :default => 0, :null => false |
| 223 | 223 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 224 | 224 |
t.column "description", :string, :default => "" |
| ... | ... | |
| 229 | 229 | |
| 230 | 230 |
add_index "versions", ["project_id"], :name => "versions_project_id" |
| 231 | 231 | |
| 232 |
create_table "workflows", :force => true do |t| |
|
| 232 |
create_table "workflows", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 233 | 233 |
t.column "tracker_id", :integer, :default => 0, :null => false |
| 234 | 234 |
t.column "old_status_id", :integer, :default => 0, :null => false |
| 235 | 235 |
t.column "new_status_id", :integer, :default => 0, :null => false |
| /opt/redmine-3.4.4/db/migrate/007_create_journals.rb 2018-01-11 17:50:10.549801852 +0200 | ||
|---|---|---|
| 6 | 6 |
class Permission < ActiveRecord::Base; end |
| 7 | 7 | |
| 8 | 8 |
def self.up |
| 9 |
create_table :journals, :force => true do |t| |
|
| 9 |
create_table :journals, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 10 | 10 |
t.column "journalized_id", :integer, :default => 0, :null => false |
| 11 | 11 |
t.column "journalized_type", :string, :limit => 30, :default => "", :null => false |
| 12 | 12 |
t.column "user_id", :integer, :default => 0, :null => false |
| 13 | 13 |
t.column "notes", :text |
| 14 | 14 |
t.column "created_on", :datetime, :null => false |
| 15 | 15 |
end |
| 16 |
create_table :journal_details, :force => true do |t| |
|
| 16 |
create_table :journal_details, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 17 | 17 |
t.column "journal_id", :integer, :default => 0, :null => false |
| 18 | 18 |
t.column "property", :string, :limit => 30, :default => "", :null => false |
| 19 | 19 |
t.column "prop_key", :string, :limit => 30, :default => "", :null => false |
| ... | ... | |
| 41 | 41 |
drop_table :journal_details |
| 42 | 42 |
drop_table :journals |
| 43 | 43 | |
| 44 |
create_table "issue_histories", :force => true do |t| |
|
| 44 |
create_table "issue_histories", :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 45 | 45 |
t.column "issue_id", :integer, :default => 0, :null => false |
| 46 | 46 |
t.column "status_id", :integer, :default => 0, :null => false |
| 47 | 47 |
t.column "author_id", :integer, :default => 0, :null => false |
| /opt/redmine-3.4.4/db/migrate/008_create_user_preferences.rb 2018-01-11 17:50:34.142165359 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateUserPreferences < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :user_preferences do |t| |
|
| 3 |
create_table :user_preferences , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column "user_id", :integer, :default => 0, :null => false |
| 5 | 5 |
t.column "others", :text |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/010_create_comments.rb 2018-01-11 17:50:57.829558327 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateComments < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :comments do |t| |
|
| 3 |
create_table :comments , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :commented_type, :string, :limit => 30, :default => "", :null => false |
| 5 | 5 |
t.column :commented_id, :integer, :default => 0, :null => false |
| 6 | 6 |
t.column :author_id, :integer, :default => 0, :null => false |
| /opt/redmine-3.4.4/db/migrate/013_create_queries.rb 2018-01-11 17:51:17.734234477 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateQueries < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :queries, :force => true do |t| |
|
| 3 |
create_table :queries, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column "project_id", :integer |
| 5 | 5 |
t.column "name", :string, :default => "", :null => false |
| 6 | 6 |
t.column "filters", :text |
| /opt/redmine-3.4.4/db/migrate/015_create_repositories.rb 2018-01-11 17:51:36.142032676 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateRepositories < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :repositories, :force => true do |t| |
|
| 3 |
create_table :repositories, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column "project_id", :integer, :default => 0, :null => false |
| 5 | 5 |
t.column "url", :string, :default => "", :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/017_create_settings.rb 2018-01-11 17:52:12.109741473 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateSettings < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :settings, :force => true do |t| |
|
| 3 |
create_table :settings, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column "name", :string, :limit => 30, :default => "", :null => false |
| 5 | 5 |
t.column "value", :text |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/027_create_wikis.rb 2018-01-11 17:52:26.581842182 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateWikis < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :wikis do |t| |
|
| 3 |
create_table :wikis , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :project_id, :integer, :null => false |
| 5 | 5 |
t.column :start_page, :string, :limit => 255, :null => false |
| 6 | 6 |
t.column :status, :integer, :default => 1, :null => false |
| /opt/redmine-3.4.4/db/migrate/028_create_wiki_pages.rb 2018-01-11 17:42:23.625521133 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateWikiPages < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :wiki_pages do |t| |
|
| 3 |
create_table :wiki_pages , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :wiki_id, :integer, :null => false |
| 5 | 5 |
t.column :title, :string, :limit => 255, :null => false |
| 6 | 6 |
t.column :created_on, :datetime, :null => false |
| /opt/redmine-3.4.4/db/migrate/029_create_wiki_contents.rb 2018-01-11 17:52:48.165523804 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateWikiContents < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :wiki_contents do |t| |
|
| 3 |
create_table :wiki_contents , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :page_id, :integer, :null => false |
| 5 | 5 |
t.column :author_id, :integer |
| 6 | 6 |
t.column :text, :text |
| ... | ... | |
| 10 | 10 |
end |
| 11 | 11 |
add_index :wiki_contents, :page_id, :name => :wiki_contents_page_id |
| 12 | 12 | |
| 13 |
create_table :wiki_content_versions do |t| |
|
| 13 |
create_table :wiki_content_versions , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 14 | 14 |
t.column :wiki_content_id, :integer, :null => false |
| 15 | 15 |
t.column :page_id, :integer, :null => false |
| 16 | 16 |
t.column :author_id, :integer |
| /opt/redmine-3.4.4/db/migrate/032_create_time_entries.rb 2018-01-11 17:53:08.854285173 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateTimeEntries < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :time_entries do |t| |
|
| 3 |
create_table :time_entries , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :project_id, :integer, :null => false |
| 5 | 5 |
t.column :user_id, :integer, :null => false |
| 6 | 6 |
t.column :issue_id, :integer |
| /opt/redmine-3.4.4/db/migrate/034_create_changesets.rb 2018-01-11 17:53:22.646473832 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateChangesets < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :changesets do |t| |
|
| 3 |
create_table :changesets , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :repository_id, :integer, :null => false |
| 5 | 5 |
t.column :revision, :integer, :null => false |
| 6 | 6 |
t.column :committer, :string, :limit => 30 |
| /opt/redmine-3.4.4/db/migrate/035_create_changes.rb 2018-01-11 17:53:37.030638899 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateChanges < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :changes do |t| |
|
| 3 |
create_table :changes , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :changeset_id, :integer, :null => false |
| 5 | 5 |
t.column :action, :string, :limit => 1, :default => "", :null => false |
| 6 | 6 |
t.column :path, :string, :default => "", :null => false |
| /opt/redmine-3.4.4/db/migrate/039_create_watchers.rb 2018-01-11 17:53:51.454812222 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateWatchers < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :watchers do |t| |
|
| 3 |
create_table :watchers , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :watchable_type, :string, :default => "", :null => false |
| 5 | 5 |
t.column :watchable_id, :integer, :default => 0, :null => false |
| 6 | 6 |
t.column :user_id, :integer |
| /opt/redmine-3.4.4/db/migrate/040_create_changesets_issues.rb 2018-01-11 17:54:07.055932612 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateChangesetsIssues < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :changesets_issues, :id => false do |t| |
|
| 3 |
create_table :changesets_issues, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :changeset_id, :integer, :null => false |
| 5 | 5 |
t.column :issue_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/042_create_issue_relations.rb 2018-01-11 17:54:20.240200302 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateIssueRelations < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :issue_relations do |t| |
|
| 3 |
create_table :issue_relations , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :issue_from_id, :integer, :null => false |
| 5 | 5 |
t.column :issue_to_id, :integer, :null => false |
| 6 | 6 |
t.column :relation_type, :string, :default => "", :null => false |
| /opt/redmine-3.4.4/db/migrate/045_create_boards.rb 2018-01-11 17:54:53.423400368 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateBoards < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :boards do |t| |
|
| 3 |
create_table :boards , options: ' ROW_FORMAT=DYNAMIC ' , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :project_id, :integer, :null => false |
| 5 | 5 |
t.column :name, :string, :default => "", :null => false |
| 6 | 6 |
t.column :description, :string |
| /opt/redmine-3.4.4/db/migrate/046_create_messages.rb 2018-01-11 17:55:11.392450769 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateMessages < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :messages do |t| |
|
| 3 |
create_table :messages , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :board_id, :integer, :null => false |
| 5 | 5 |
t.column :parent_id, :integer |
| 6 | 6 |
t.column :subject, :string, :default => "", :null => false |
| /opt/redmine-3.4.4/db/migrate/067_create_wiki_redirects.rb 2018-01-11 17:44:33.926034005 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateWikiRedirects < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :wiki_redirects do |t| |
|
| 3 |
create_table :wiki_redirects , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :wiki_id, :integer, :null => false |
| 5 | 5 |
t.column :title, :string |
| 6 | 6 |
t.column :redirects_to, :string |
| /opt/redmine-3.4.4/db/migrate/068_create_enabled_modules.rb 2018-01-11 17:55:27.120634437 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateEnabledModules < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :enabled_modules do |t| |
|
| 3 |
create_table :enabled_modules , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :project_id, :integer |
| 5 | 5 |
t.column :name, :string, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/081_create_projects_trackers.rb 2018-01-11 17:55:44.600742033 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateProjectsTrackers < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :projects_trackers, :id => false do |t| |
|
| 3 |
create_table :projects_trackers, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :project_id, :integer, :default => 0, :null => false |
| 5 | 5 |
t.column :tracker_id, :integer, :default => 0, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/107_add_open_id_authentication_tables.rb 2018-01-11 17:56:05.393703042 +0200 | ||
|---|---|---|
| 1 | 1 |
class AddOpenIdAuthenticationTables < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :open_id_authentication_associations, :force => true do |t| |
|
| 3 |
create_table :open_id_authentication_associations, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.integer :issued, :lifetime |
| 5 | 5 |
t.string :handle, :assoc_type |
| 6 | 6 |
t.binary :server_url, :secret |
| 7 | 7 |
end |
| 8 | 8 | |
| 9 |
create_table :open_id_authentication_nonces, :force => true do |t| |
|
| 9 |
create_table :open_id_authentication_nonces, :force => true , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 10 | 10 |
t.integer :timestamp, :null => false |
| 11 | 11 |
t.string :server_url, :null => true |
| 12 | 12 |
t.string :salt, :null => false |
| /opt/redmine-3.4.4/db/migrate/20090503121501_create_member_roles.rb 2018-01-11 17:56:32.081403790 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateMemberRoles < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :member_roles do |t| |
|
| 3 |
create_table :member_roles , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :member_id, :integer, :null => false |
| 5 | 5 |
t.column :role_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20090704172355_create_groups_users.rb 2018-01-11 17:58:15.283723759 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateGroupsUsers < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :groups_users, :id => false do |t| |
|
| 3 |
create_table :groups_users, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :group_id, :integer, :null => false |
| 5 | 5 |
t.column :user_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20110902000000_create_changeset_parents.rb 2018-01-11 17:58:29.445123537 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateChangesetParents < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :changeset_parents, :id => false do |t| |
|
| 3 |
create_table :changeset_parents, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :changeset_id, :integer, :null => false |
| 5 | 5 |
t.column :parent_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20130602092539_create_queries_roles.rb 2018-01-11 17:58:43.004559245 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateQueriesRoles < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :queries_roles, :id => false do |t| |
|
| 3 |
create_table :queries_roles, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :query_id, :integer, :null => false |
| 5 | 5 |
t.column :role_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20130713104233_create_custom_fields_roles.rb 2018-01-11 17:58:57.900562776 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateCustomFieldsRoles < ActiveRecord::Migration |
| 2 | 2 |
def self.up |
| 3 |
create_table :custom_fields_roles, :id => false do |t| |
|
| 3 |
create_table :custom_fields_roles, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :custom_field_id, :integer, :null => false |
| 5 | 5 |
t.column :role_id, :integer, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20150113194759_create_email_addresses.rb 2018-01-11 17:59:13.061216736 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateEmailAddresses < ActiveRecord::Migration |
| 2 | 2 |
def change |
| 3 |
create_table :email_addresses do |t| |
|
| 3 |
create_table :email_addresses , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.column :user_id, :integer, :null => false |
| 5 | 5 |
t.column :address, :string, :null => false |
| 6 | 6 |
t.column :is_default, :boolean, :null => false, :default => false |
| /opt/redmine-3.4.4/db/migrate/20150528092912_create_roles_managed_roles.rb 2018-01-11 17:59:27.812922020 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateRolesManagedRoles < ActiveRecord::Migration |
| 2 | 2 |
def change |
| 3 |
create_table :roles_managed_roles, :id => false do |t| |
|
| 3 |
create_table :roles_managed_roles, :id => false , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.integer :role_id, :null => false |
| 5 | 5 |
t.integer :managed_role_id, :null => false |
| 6 | 6 |
end |
| /opt/redmine-3.4.4/db/migrate/20150730122707_create_imports.rb 2018-01-11 17:59:42.284666799 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateImports < ActiveRecord::Migration |
| 2 | 2 |
def change |
| 3 |
create_table :imports do |t| |
|
| 3 |
create_table :imports , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.string :type |
| 5 | 5 |
t.integer :user_id, :null => false |
| 6 | 6 |
t.string :filename |
| /opt/redmine-3.4.4/db/migrate/20150730122735_create_import_items.rb 2018-01-11 18:00:00.740088535 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateImportItems < ActiveRecord::Migration |
| 2 | 2 |
def change |
| 3 |
create_table :import_items do |t| |
|
| 3 |
create_table :import_items , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.integer :import_id, :null => false |
| 5 | 5 |
t.integer :position, :null => false |
| 6 | 6 |
t.integer :obj_id |
| /opt/redmine-3.4.4/db/migrate/20151025072118_create_custom_field_enumerations.rb 2018-01-11 18:00:15.731822744 +0200 | ||
|---|---|---|
| 1 | 1 |
class CreateCustomFieldEnumerations < ActiveRecord::Migration |
| 2 | 2 |
def change |
| 3 |
create_table :custom_field_enumerations do |t| |
|
| 3 |
create_table :custom_field_enumerations , options: ' ROW_FORMAT=DYNAMIC ' do |t|
|
|
| 4 | 4 |
t.integer :custom_field_id, :null => false |
| 5 | 5 |
t.string :name, :null => false |
| 6 | 6 |
t.boolean :active, :default => true, :null => false |