schema.rb in radiant-0.7.0

- old
+ new

@@ -1,17 +1,17 @@
 # This file is auto-generated from the current state of the database. Instead of editing this file, 
-# please use the migrations feature of ActiveRecord to incrementally modify your database, and
+# please use the migrations feature of Active Record to incrementally modify your database, and
 # then regenerate this schema definition.
 #
 # Note that this schema.rb definition is the authoritative source for your database schema. If you need
 # to create the application database on another system, you should be using db:schema:load, not running
 # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
 # you'll amass, the slower it'll run and the greater likelihood for issues).
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 21) do
+ActiveRecord::Schema.define(:version => 20081208005628) do
 
   create_table "config", :force => true do |t|
     t.string "key",   :limit => 40, :default => "", :null => false
     t.string "value",               :default => ""
   end
@@ -40,10 +40,12 @@
     t.string  "filter_id", :limit => 25
     t.text    "content"
     t.integer "page_id"
   end
 
+  add_index "page_parts", ["page_id", "name"], :name => "parts_by_page"
+
   create_table "pages", :force => true do |t|
     t.string   "title"
     t.string   "slug",          :limit => 100
     t.string   "breadcrumb",    :limit => 160
     t.string   "class_name",    :limit => 25
@@ -59,17 +61,22 @@
     t.integer  "lock_version",                 :default => 0
     t.string   "description"
     t.string   "keywords"
   end
 
+  add_index "pages", ["class_name"], :name => "pages_class_name"
+  add_index "pages", ["parent_id"], :name => "pages_parent_id"
+  add_index "pages", ["slug", "parent_id"], :name => "pages_child_slug"
+  add_index "pages", ["virtual", "status_id"], :name => "pages_published"
+
   create_table "sessions", :force => true do |t|
     t.string   "session_id"
     t.text     "data"
     t.datetime "updated_at"
   end
 
-  add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
   add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
+  add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
 
   create_table "snippets", :force => true do |t|
     t.string   "name",          :limit => 100, :default => "", :null => false
     t.string   "filter_id",     :limit => 25
     t.text     "content"