##// END OF EJS Templates
jro_apps » redmine
RSS
change new line 'LF' to 'CRLF' at db/migrate/001_setup.rb (#9510)...
Toshi MARUYAMA -
r7614:313965e68359
parent child
Show More
Side by Side Unified
Context file:
r7614:313965e68359 Loading diff...:
Show file before | Show file after | Hide comments
@@ -1,26 +1,26
1 # redMine - project management software
1 # redMine - project management software
2 # Copyright (C) 2006 Jean-Philippe Lang
2 # Copyright (C) 2006 Jean-Philippe Lang
3 #
3 #
4 # This program is free software; you can redistribute it and/or
4 # This program is free software; you can redistribute it and/or
5 # modify it under the terms of the GNU General Public License
5 # modify it under the terms of the GNU General Public License
6 # as published by the Free Software Foundation; either version 2
6 # as published by the Free Software Foundation; either version 2
7 # of the License, or (at your option) any later version.
7 # of the License, or (at your option) any later version.
8 #
8 #
9 # This program is distributed in the hope that it will be useful,
9 # This program is distributed in the hope that it will be useful,
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 # GNU General Public License for more details.
12 # GNU General Public License for more details.
13 #
13 #
14 # You should have received a copy of the GNU General Public License
14 # You should have received a copy of the GNU General Public License
15 # along with this program; if not, write to the Free Software
15 # along with this program; if not, write to the Free Software
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
16 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
17
17
18 class Setup < ActiveRecord::Migration
18 class Setup < ActiveRecord::Migration
19
19
20 class User < ActiveRecord::Base; end
20 class User < ActiveRecord::Base; end
21 # model removed
21 # model removed
22 class Permission < ActiveRecord::Base; end
22 class Permission < ActiveRecord::Base; end
23
23
24 def self.up
24 def self.up
25 create_table "attachments", :force => true do |t|
25 create_table "attachments", :force => true do |t|
26 t.column "container_id", :integer, :default => 0, :null => false
26 t.column "container_id", :integer, :default => 0, :null => false
@@ -34,23 +34,23 class Setup < ActiveRecord::Migration
34 t.column "author_id", :integer, :default => 0, :null => false
34 t.column "author_id", :integer, :default => 0, :null => false
35 t.column "created_on", :timestamp
35 t.column "created_on", :timestamp
36 end
36 end
37
37
38 create_table "auth_sources", :force => true do |t|
38 create_table "auth_sources", :force => true do |t|
39 t.column "type", :string, :limit => 30, :default => "", :null => false
39 t.column "type", :string, :limit => 30, :default => "", :null => false
40 t.column "name", :string, :limit => 60, :default => "", :null => false
40 t.column "name", :string, :limit => 60, :default => "", :null => false
41 t.column "host", :string, :limit => 60
41 t.column "host", :string, :limit => 60
42 t.column "port", :integer
42 t.column "port", :integer
43 t.column "account", :string, :limit => 60
43 t.column "account", :string, :limit => 60
44 t.column "account_password", :string, :limit => 60
44 t.column "account_password", :string, :limit => 60
45 t.column "base_dn", :string, :limit => 255
45 t.column "base_dn", :string, :limit => 255
46 t.column "attr_login", :string, :limit => 30
46 t.column "attr_login", :string, :limit => 30
47 t.column "attr_firstname", :string, :limit => 30
47 t.column "attr_firstname", :string, :limit => 30
48 t.column "attr_lastname", :string, :limit => 30
48 t.column "attr_lastname", :string, :limit => 30
49 t.column "attr_mail", :string, :limit => 30
49 t.column "attr_mail", :string, :limit => 30
50 t.column "onthefly_register", :boolean, :default => false, :null => false
50 t.column "onthefly_register", :boolean, :default => false, :null => false
51 end
51 end
52
52
53 create_table "custom_fields", :force => true do |t|
53 create_table "custom_fields", :force => true do |t|
54 t.column "type", :string, :limit => 30, :default => "", :null => false
54 t.column "type", :string, :limit => 30, :default => "", :null => false
55 t.column "name", :string, :limit => 30, :default => "", :null => false
55 t.column "name", :string, :limit => 30, :default => "", :null => false
56 t.column "field_format", :string, :limit => 30, :default => "", :null => false
56 t.column "field_format", :string, :limit => 30, :default => "", :null => false
@@ -58,23 +58,23 class Setup < ActiveRecord::Migration
58 t.column "regexp", :string, :default => ""
58 t.column "regexp", :string, :default => ""
59 t.column "min_length", :integer, :default => 0, :null => false
59 t.column "min_length", :integer, :default => 0, :null => false
60 t.column "max_length", :integer, :default => 0, :null => false
60 t.column "max_length", :integer, :default => 0, :null => false
61 t.column "is_required", :boolean, :default => false, :null => false
61 t.column "is_required", :boolean, :default => false, :null => false
62 t.column "is_for_all", :boolean, :default => false, :null => false
62 t.column "is_for_all", :boolean, :default => false, :null => false
63 end
63 end
64
64
65 create_table "custom_fields_projects", :id => false, :force => true do |t|
65 create_table "custom_fields_projects", :id => false, :force => true do |t|
66 t.column "custom_field_id", :integer, :default => 0, :null => false
66 t.column "custom_field_id", :integer, :default => 0, :null => false
67 t.column "project_id", :integer, :default => 0, :null => false
67 t.column "project_id", :integer, :default => 0, :null => false
68 end
68 end
69
69
70 create_table "custom_fields_trackers", :id => false, :force => true do |t|
70 create_table "custom_fields_trackers", :id => false, :force => true do |t|
71 t.column "custom_field_id", :integer, :default => 0, :null => false
71 t.column "custom_field_id", :integer, :default => 0, :null => false
72 t.column "tracker_id", :integer, :default => 0, :null => false
72 t.column "tracker_id", :integer, :default => 0, :null => false
73 end
73 end
74
74
75 create_table "custom_values", :force => true do |t|
75 create_table "custom_values", :force => true do |t|
76 t.column "customized_type", :string, :limit => 30, :default => "", :null => false
76 t.column "customized_type", :string, :limit => 30, :default => "", :null => false
77 t.column "customized_id", :integer, :default => 0, :null => false
77 t.column "customized_id", :integer, :default => 0, :null => false
78 t.column "custom_field_id", :integer, :default => 0, :null => false
78 t.column "custom_field_id", :integer, :default => 0, :null => false
79 t.column "value", :text
79 t.column "value", :text
80 end
80 end
@@ -85,8 +85,8 class Setup < ActiveRecord::Migration
85 t.column "title", :string, :limit => 60, :default => "", :null => false
85 t.column "title", :string, :limit => 60, :default => "", :null => false
86 t.column "description", :text
86 t.column "description", :text
87 t.column "created_on", :timestamp
87 t.column "created_on", :timestamp
88 end
88 end
89
89
90 add_index "documents", ["project_id"], :name => "documents_project_id"
90 add_index "documents", ["project_id"], :name => "documents_project_id"
91
91
92 create_table "enumerations", :force => true do |t|
92 create_table "enumerations", :force => true do |t|
@@ -97,8 +97,8 class Setup < ActiveRecord::Migration
97 create_table "issue_categories", :force => true do |t|
97 create_table "issue_categories", :force => true do |t|
98 t.column "project_id", :integer, :default => 0, :null => false
98 t.column "project_id", :integer, :default => 0, :null => false
99 t.column "name", :string, :limit => 30, :default => "", :null => false
99 t.column "name", :string, :limit => 30, :default => "", :null => false
100 end
100 end
101
101
102 add_index "issue_categories", ["project_id"], :name => "issue_categories_project_id"
102 add_index "issue_categories", ["project_id"], :name => "issue_categories_project_id"
103
103
104 create_table "issue_histories", :force => true do |t|
104 create_table "issue_histories", :force => true do |t|
@@ -122,14 +122,14 class Setup < ActiveRecord::Migration
122 t.column "tracker_id", :integer, :default => 0, :null => false
122 t.column "tracker_id", :integer, :default => 0, :null => false
123 t.column "project_id", :integer, :default => 0, :null => false
123 t.column "project_id", :integer, :default => 0, :null => false
124 t.column "subject", :string, :default => "", :null => false
124 t.column "subject", :string, :default => "", :null => false
125 t.column "description", :text
125 t.column "description", :text
126 t.column "due_date", :date
126 t.column "due_date", :date
127 t.column "category_id", :integer
127 t.column "category_id", :integer
128 t.column "status_id", :integer, :default => 0, :null => false
128 t.column "status_id", :integer, :default => 0, :null => false
129 t.column "assigned_to_id", :integer
129 t.column "assigned_to_id", :integer
130 t.column "priority_id", :integer, :default => 0, :null => false
130 t.column "priority_id", :integer, :default => 0, :null => false
131 t.column "fixed_version_id", :integer
131 t.column "fixed_version_id", :integer
132 t.column "author_id", :integer, :default => 0, :null => false
132 t.column "author_id", :integer, :default => 0, :null => false
133 t.column "lock_version", :integer, :default => 0, :null => false
133 t.column "lock_version", :integer, :default => 0, :null => false
134 t.column "created_on", :timestamp
134 t.column "created_on", :timestamp
135 t.column "updated_on", :timestamp
135 t.column "updated_on", :timestamp
@@ -151,8 +151,8 class Setup < ActiveRecord::Migration
151 t.column "description", :text
151 t.column "description", :text
152 t.column "author_id", :integer, :default => 0, :null => false
152 t.column "author_id", :integer, :default => 0, :null => false
153 t.column "created_on", :timestamp
153 t.column "created_on", :timestamp
154 end
154 end
155
155
156 add_index "news", ["project_id"], :name => "news_project_id"
156 add_index "news", ["project_id"], :name => "news_project_id"
157
157
158 create_table "permissions", :force => true do |t|
158 create_table "permissions", :force => true do |t|
@@ -176,8 +176,8 class Setup < ActiveRecord::Migration
176 t.column "name", :string, :limit => 30, :default => "", :null => false
176 t.column "name", :string, :limit => 30, :default => "", :null => false
177 t.column "description", :string, :default => "", :null => false
177 t.column "description", :string, :default => "", :null => false
178 t.column "homepage", :string, :limit => 60, :default => ""
178 t.column "homepage", :string, :limit => 60, :default => ""
179 t.column "is_public", :boolean, :default => true, :null => false
179 t.column "is_public", :boolean, :default => true, :null => false
180 t.column "parent_id", :integer
180 t.column "parent_id", :integer
181 t.column "projects_count", :integer, :default => 0
181 t.column "projects_count", :integer, :default => 0
182 t.column "created_on", :timestamp
182 t.column "created_on", :timestamp
183 t.column "updated_on", :timestamp
183 t.column "updated_on", :timestamp
@@ -186,13 +186,13 class Setup < ActiveRecord::Migration
186 create_table "roles", :force => true do |t|
186 create_table "roles", :force => true do |t|
187 t.column "name", :string, :limit => 30, :default => "", :null => false
187 t.column "name", :string, :limit => 30, :default => "", :null => false
188 end
188 end
189
189
190 create_table "tokens", :force => true do |t|
190 create_table "tokens", :force => true do |t|
191 t.column "user_id", :integer, :default => 0, :null => false
191 t.column "user_id", :integer, :default => 0, :null => false
192 t.column "action", :string, :limit => 30, :default => "", :null => false
192 t.column "action", :string, :limit => 30, :default => "", :null => false
193 t.column "value", :string, :limit => 40, :default => "", :null => false
193 t.column "value", :string, :limit => 40, :default => "", :null => false
194 t.column "created_on", :datetime, :null => false
194 t.column "created_on", :datetime, :null => false
195 end
195 end
196
196
197 create_table "trackers", :force => true do |t|
197 create_table "trackers", :force => true do |t|
198 t.column "name", :string, :limit => 30, :default => "", :null => false
198 t.column "name", :string, :limit => 30, :default => "", :null => false
@@ -209,7 +209,7 class Setup < ActiveRecord::Migration
209 t.column "admin", :boolean, :default => false, :null => false
209 t.column "admin", :boolean, :default => false, :null => false
210 t.column "status", :integer, :default => 1, :null => false
210 t.column "status", :integer, :default => 1, :null => false
211 t.column "last_login_on", :datetime
211 t.column "last_login_on", :datetime
212 t.column "language", :string, :limit => 2, :default => ""
212 t.column "language", :string, :limit => 2, :default => ""
213 t.column "auth_source_id", :integer
213 t.column "auth_source_id", :integer
214 t.column "created_on", :timestamp
214 t.column "created_on", :timestamp
215 t.column "updated_on", :timestamp
215 t.column "updated_on", :timestamp
@@ -222,8 +222,8 class Setup < ActiveRecord::Migration
222 t.column "effective_date", :date
222 t.column "effective_date", :date
223 t.column "created_on", :timestamp
223 t.column "created_on", :timestamp
224 t.column "updated_on", :timestamp
224 t.column "updated_on", :timestamp
225 end
225 end
226
226
227 add_index "versions", ["project_id"], :name => "versions_project_id"
227 add_index "versions", ["project_id"], :name => "versions_project_id"
228
228
229 create_table "workflows", :force => true do |t|
229 create_table "workflows", :force => true do |t|
@@ -254,7 +254,7 class Setup < ActiveRecord::Migration
254 Permission.create :controller => "issue_categories", :action => "destroy", :description => "button_delete", :sort => 422
254 Permission.create :controller => "issue_categories", :action => "destroy", :description => "button_delete", :sort => 422
255 # issues
255 # issues
256 Permission.create :controller => "projects", :action => "list_issues", :description => "button_list", :sort => 1000, :is_public => true
256 Permission.create :controller => "projects", :action => "list_issues", :description => "button_list", :sort => 1000, :is_public => true
257 Permission.create :controller => "projects", :action => "export_issues_csv", :description => "label_export_csv", :sort => 1001, :is_public => true
257 Permission.create :controller => "projects", :action => "export_issues_csv", :description => "label_export_csv", :sort => 1001, :is_public => true
258 Permission.create :controller => "issues", :action => "show", :description => "button_view", :sort => 1005, :is_public => true
258 Permission.create :controller => "issues", :action => "show", :description => "button_view", :sort => 1005, :is_public => true
259 Permission.create :controller => "issues", :action => "download", :description => "button_download", :sort => 1010, :is_public => true
259 Permission.create :controller => "issues", :action => "download", :description => "button_download", :sort => 1010, :is_public => true
260 Permission.create :controller => "projects", :action => "add_issue", :description => "button_add", :sort => 1050, :mail_option => 1, :mail_enabled => 1
260 Permission.create :controller => "projects", :action => "add_issue", :description => "button_add", :sort => 1050, :mail_option => 1, :mail_enabled => 1
@@ -269,7 +269,7 class Setup < ActiveRecord::Migration
269 Permission.create :controller => "projects", :action => "add_news", :description => "button_add", :sort => 1120
269 Permission.create :controller => "projects", :action => "add_news", :description => "button_add", :sort => 1120
270 Permission.create :controller => "news", :action => "edit", :description => "button_edit", :sort => 1121
270 Permission.create :controller => "news", :action => "edit", :description => "button_edit", :sort => 1121
271 Permission.create :controller => "news", :action => "destroy", :description => "button_delete", :sort => 1122
271 Permission.create :controller => "news", :action => "destroy", :description => "button_delete", :sort => 1122
272 # documents
272 # documents
273 Permission.create :controller => "projects", :action => "list_documents", :description => "button_list", :sort => 1200, :is_public => true
273 Permission.create :controller => "projects", :action => "list_documents", :description => "button_list", :sort => 1200, :is_public => true
274 Permission.create :controller => "documents", :action => "show", :description => "button_view", :sort => 1201, :is_public => true
274 Permission.create :controller => "documents", :action => "show", :description => "button_view", :sort => 1201, :is_public => true
275 Permission.create :controller => "documents", :action => "download", :description => "button_download", :sort => 1202, :is_public => true
275 Permission.create :controller => "documents", :action => "download", :description => "button_download", :sort => 1202, :is_public => true
@@ -285,22 +285,22 class Setup < ActiveRecord::Migration
285 Permission.create :controller => "versions", :action => "destroy_file", :description => "button_delete", :sort => 1322
285 Permission.create :controller => "versions", :action => "destroy_file", :description => "button_delete", :sort => 1322
286
286
287 # create default administrator account
287 # create default administrator account
288 user = User.create :login => "admin",
288 user = User.create :login => "admin",
289 :hashed_password => "d033e22ae348aeb5660fc2140aec35850c4da997",
289 :hashed_password => "d033e22ae348aeb5660fc2140aec35850c4da997",
290 :admin => true,
290 :admin => true,
291 :firstname => "Redmine",
291 :firstname => "Redmine",
292 :lastname => "Admin",
292 :lastname => "Admin",
293 :mail => "admin@example.net",
293 :mail => "admin@example.net",
294 :mail_notification => true,
294 :mail_notification => true,
295 :language => "en",
295 :language => "en",
296 :status => 1
296 :status => 1
297 end
297 end
298
298
299 def self.down
299 def self.down
300 drop_table :attachments
300 drop_table :attachments
301 drop_table :auth_sources
301 drop_table :auth_sources
302 drop_table :custom_fields
302 drop_table :custom_fields
303 drop_table :custom_fields_projects
303 drop_table :custom_fields_projects
304 drop_table :custom_fields_trackers
304 drop_table :custom_fields_trackers
305 drop_table :custom_values
305 drop_table :custom_values
306 drop_table :documents
306 drop_table :documents
@@ -316,9 +316,9 class Setup < ActiveRecord::Migration
316 drop_table :projects
316 drop_table :projects
317 drop_table :roles
317 drop_table :roles
318 drop_table :trackers
318 drop_table :trackers
319 drop_table :tokens
319 drop_table :tokens
320 drop_table :users
320 drop_table :users
321 drop_table :versions
321 drop_table :versions
322 drop_table :workflows
322 drop_table :workflows
323 end
323 end
324 end
324 end
General Comments 0
You need to be logged in to leave comments. Login now