myexperiment-hackers
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[myexperiment-hackers] [2092] trunk/db/migrate/073_remove_simple_pages.r


From: noreply
Subject: [myexperiment-hackers] [2092] trunk/db/migrate/073_remove_simple_pages.rb: db migration file to remove simple_pages tables
Date: Fri, 6 Feb 2009 11:55:36 -0500 (EST)

Revision
2092
Author
dgc
Date
2009-02-06 11:55:35 -0500 (Fri, 06 Feb 2009)

Log Message

db migration file to remove simple_pages tables

Added Paths

Diff

Added: trunk/db/migrate/073_remove_simple_pages.rb (0 => 2092)


--- trunk/db/migrate/073_remove_simple_pages.rb	                        (rev 0)
+++ trunk/db/migrate/073_remove_simple_pages.rb	2009-02-06 16:55:35 UTC (rev 2092)
@@ -0,0 +1,33 @@
+# myExperiment: db/migrate/001_create_users.rb
+#
+# Copyright (c) 2009 University of Manchester and the University of Southampton.
+# See license.txt for details.
+
+class RemoveSimplePages < ActiveRecord::Migration
+
+  def self.up
+    drop_table :simple_page_versions
+    drop_table :simple_pages
+  end
+
+  def self.down
+    create_table "simple_page_versions", :force => true do |t|
+      t.column "simple_page_id", :integer
+      t.column "version",        :integer
+      t.column "filename",       :string
+      t.column "title",          :string
+      t.column "content",        :text
+      t.column "created_at",     :datetime
+      t.column "updated_at",     :datetime
+    end
+
+    create_table "simple_pages", :force => true do |t|
+      t.column "filename",   :string
+      t.column "title",      :string
+      t.column "content",    :text
+      t.column "created_at", :datetime
+      t.column "updated_at", :datetime
+      t.column "version",    :integer
+    end
+  end
+end

reply via email to

[Prev in Thread] Current Thread [Next in Thread]