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