007_create_articles.rb
1.25 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
class CreateArticles < ActiveRecord::Migration
def self.up
create_table :articles do |t|
# acts as filesystem
t.column :name, :string
t.column :slug, :string
t.column :path, :text, :default => ''
t.column :parent_id, :integer # acts as tree included
# main data
t.column :body, :text
t.column :abstract, :text
# belongs to profile
t.column :profile_id, :integer
# keep track of changes
t.column :updated_on, :datetime
t.column :created_on, :datetime
t.column :last_changed_by_id, :integer
# acts as versioned
t.column :version, :integer
t.column :lock_version, :integer
# single-table inheritance
t.column :type, :string
# attachment_fu data for all uploaded files
t.column :size, :integer # file size in bytes
t.column :content_type, :string # mime type, ex: application/mp3
t.column :filename, :string # sanitized filename
# attachment_fu data for images
t.column :height, :integer # in pixels
t.column :width, :integer # in pixels
end
Article.create_versioned_table
end
def self.down
Article.drop_versioned_table
drop_table :articles
end
end