##// END OF EJS Templates
indexes added...
Jean-Philippe Lang -
r23:fbafa9579127
parent child
Show More
@@ -82,6 +82,8 class Setup < ActiveRecord::Migration
82 t.column "created_on", :timestamp
82 t.column "created_on", :timestamp
83 end
83 end
84
84
85 add_index "documents", ["project_id"], :name => "documents_project_id"
86
85 create_table "enumerations", :force => true do |t|
87 create_table "enumerations", :force => true do |t|
86 t.column "opt", :string, :limit => 4, :default => "", :null => false
88 t.column "opt", :string, :limit => 4, :default => "", :null => false
87 t.column "name", :string, :limit => 30, :default => "", :null => false
89 t.column "name", :string, :limit => 30, :default => "", :null => false
@@ -92,6 +94,8 class Setup < ActiveRecord::Migration
92 t.column "name", :string, :limit => 30, :default => "", :null => false
94 t.column "name", :string, :limit => 30, :default => "", :null => false
93 end
95 end
94
96
97 add_index "issue_categories", ["project_id"], :name => "issue_categories_project_id"
98
95 create_table "issue_histories", :force => true do |t|
99 create_table "issue_histories", :force => true do |t|
96 t.column "issue_id", :integer, :default => 0, :null => false
100 t.column "issue_id", :integer, :default => 0, :null => false
97 t.column "status_id", :integer, :default => 0, :null => false
101 t.column "status_id", :integer, :default => 0, :null => false
@@ -144,6 +148,8 class Setup < ActiveRecord::Migration
144 t.column "created_on", :timestamp
148 t.column "created_on", :timestamp
145 end
149 end
146
150
151 add_index "news", ["project_id"], :name => "news_project_id"
152
147 create_table "permissions", :force => true do |t|
153 create_table "permissions", :force => true do |t|
148 t.column "controller", :string, :limit => 30, :default => "", :null => false
154 t.column "controller", :string, :limit => 30, :default => "", :null => false
149 t.column "action", :string, :limit => 30, :default => "", :null => false
155 t.column "action", :string, :limit => 30, :default => "", :null => false
@@ -213,6 +219,8 class Setup < ActiveRecord::Migration
213 t.column "updated_on", :timestamp
219 t.column "updated_on", :timestamp
214 end
220 end
215
221
222 add_index "versions", ["project_id"], :name => "versions_project_id"
223
216 create_table "workflows", :force => true do |t|
224 create_table "workflows", :force => true do |t|
217 t.column "tracker_id", :integer, :default => 0, :null => false
225 t.column "tracker_id", :integer, :default => 0, :null => false
218 t.column "old_status_id", :integer, :default => 0, :null => false
226 t.column "old_status_id", :integer, :default => 0, :null => false
General Comments 0
You need to be logged in to leave comments. Login now