Chris@1296
|
1 ActiveRecord::Schema.define(:version => 0) do
|
Chris@1296
|
2
|
Chris@1296
|
3 create_table :categories, :force => true do |t|
|
Chris@1296
|
4 t.column :name, :string
|
Chris@1296
|
5 t.column :parent_id, :integer
|
Chris@1296
|
6 t.column :lft, :integer
|
Chris@1296
|
7 t.column :rgt, :integer
|
Chris@1296
|
8 t.column :organization_id, :integer
|
Chris@1296
|
9 end
|
Chris@1296
|
10
|
Chris@1296
|
11 create_table :departments, :force => true do |t|
|
Chris@1296
|
12 t.column :name, :string
|
Chris@1296
|
13 end
|
Chris@1296
|
14
|
Chris@1296
|
15 create_table :notes, :force => true do |t|
|
Chris@1296
|
16 t.column :body, :text
|
Chris@1296
|
17 t.column :parent_id, :integer
|
Chris@1296
|
18 t.column :lft, :integer
|
Chris@1296
|
19 t.column :rgt, :integer
|
Chris@1296
|
20 t.column :notable_id, :integer
|
Chris@1296
|
21 t.column :notable_type, :string
|
Chris@1296
|
22 end
|
Chris@1296
|
23
|
Chris@1296
|
24 create_table :renamed_columns, :force => true do |t|
|
Chris@1296
|
25 t.column :name, :string
|
Chris@1296
|
26 t.column :mother_id, :integer
|
Chris@1296
|
27 t.column :red, :integer
|
Chris@1296
|
28 t.column :black, :integer
|
Chris@1296
|
29 end
|
Chris@1296
|
30
|
Chris@1296
|
31 create_table :things, :force => true do |t|
|
Chris@1296
|
32 t.column :body, :text
|
Chris@1296
|
33 t.column :parent_id, :integer
|
Chris@1296
|
34 t.column :lft, :integer
|
Chris@1296
|
35 t.column :rgt, :integer
|
Chris@1296
|
36 t.column :children_count, :integer
|
Chris@1296
|
37 end
|
Chris@1296
|
38
|
Chris@1296
|
39 create_table :brokens, :force => true do |t|
|
Chris@1296
|
40 t.column :name, :string
|
Chris@1296
|
41 t.column :parent_id, :integer
|
Chris@1296
|
42 t.column :lft, :integer
|
Chris@1296
|
43 t.column :rgt, :integer
|
Chris@1296
|
44 end
|
Chris@1296
|
45 end
|