@@ -80,7 +80,9 class Setup < ActiveRecord::Migration | |||||
80 | t.column "title", :string, :limit => 60, :default => "", :null => false |
|
80 | t.column "title", :string, :limit => 60, :default => "", :null => false | |
81 | t.column "description", :text, :default => "" |
|
81 | t.column "description", :text, :default => "" | |
82 | t.column "created_on", :timestamp |
|
82 | t.column "created_on", :timestamp | |
83 | end |
|
83 | end | |
|
84 | ||||
|
85 | add_index "documents", ["project_id"], :name => "documents_project_id" | |||
84 |
|
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 | |
@@ -90,7 +92,9 class Setup < ActiveRecord::Migration | |||||
90 | create_table "issue_categories", :force => true do |t| |
|
92 | create_table "issue_categories", :force => true do |t| | |
91 | t.column "project_id", :integer, :default => 0, :null => false |
|
93 | t.column "project_id", :integer, :default => 0, :null => false | |
92 | t.column "name", :string, :limit => 30, :default => "", :null => false |
|
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 | 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 | |
@@ -142,7 +146,9 class Setup < ActiveRecord::Migration | |||||
142 | t.column "description", :text, :default => "", :null => false |
|
146 | t.column "description", :text, :default => "", :null => false | |
143 | t.column "author_id", :integer, :default => 0, :null => false |
|
147 | t.column "author_id", :integer, :default => 0, :null => false | |
144 | t.column "created_on", :timestamp |
|
148 | t.column "created_on", :timestamp | |
145 | end |
|
149 | end | |
|
150 | ||||
|
151 | add_index "news", ["project_id"], :name => "news_project_id" | |||
146 |
|
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 | |
@@ -211,7 +217,9 class Setup < ActiveRecord::Migration | |||||
211 | t.column "effective_date", :date, :null => false |
|
217 | t.column "effective_date", :date, :null => false | |
212 | t.column "created_on", :timestamp |
|
218 | t.column "created_on", :timestamp | |
213 | t.column "updated_on", :timestamp |
|
219 | t.column "updated_on", :timestamp | |
214 | end |
|
220 | end | |
|
221 | ||||
|
222 | add_index "versions", ["project_id"], :name => "versions_project_id" | |||
215 |
|
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 |
General Comments 0
You need to be logged in to leave comments.
Login now