2 files changed, 27 insertions, 0 deletions

diff --git a/db/migrate/20090129204750_create_nodes.rb b/db/migrate/20090129204750_create_nodes.rb
new file mode 100644
index 0000000..e7cd562
--- /dev/null
+++ b/db/migrate/20090129204750_create_nodes.rb
@@ -0,0 +1,14 @@
+class CreateNodes < ActiveRecord::Migration
+  def self.up
+    create_table :nodes do |t|
+      t.string :slug
+      t.string :unique_name
+
+      t.timestamps
+    end
+  end
+
+  def self.down
+    drop_table :nodes
+  end
+end
diff --git a/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb b/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb
new file mode 100644
index 0000000..f8f8404
--- /dev/null
+++ b/db/migrate/20090129205013_add_missing_columns_for_nested_set_for_node.rb
@@ -0,0 +1,13 @@
+class AddMissingColumnsForNestedSetForNode < ActiveRecord::Migration
+  def self.up
+    add_column :nodes, :lft, :integer
+    add_column :nodes, :rgt, :integer
+    add_column :nodes, :parent_id, :integer
+  end
+
+  def self.down
+    remove_column :nodes, :lft
+    remove_column :nodes, :rgt
+    remove_column :nodes, :parent_id
+  end
+end