schema.rb in enju_manifestation_viewer-0.1.0.pre8

- old
+ new

@@ -9,12 +9,33 @@
 # 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 => 20110916091020) do
+ActiveRecord::Schema.define(:version => 20130506175834) do
 
+  create_table "identifier_types", :force => true do |t|
+    t.string   "name"
+    t.text     "display_name"
+    t.text     "note"
+    t.integer  "position"
+    t.datetime "created_at",   :null => false
+    t.datetime "updated_at",   :null => false
+  end
+
+  create_table "identifiers", :force => true do |t|
+    t.string   "body",               :null => false
+    t.integer  "identifier_type_id", :null => false
+    t.integer  "manifestation_id"
+    t.boolean  "primary"
+    t.integer  "position"
+    t.datetime "created_at",         :null => false
+    t.datetime "updated_at",         :null => false
+  end
+
+  add_index "identifiers", ["body", "identifier_type_id"], :name => "index_identifiers_on_body_and_identifier_type_id"
+
   create_table "manifestations", :force => true do |t|
     t.text     "original_title",                              :null => false
     t.text     "title_alternative"
     t.text     "title_transcription"
     t.string   "classification_number"
@@ -31,17 +52,10 @@
     t.integer  "start_page"
     t.integer  "end_page"
     t.integer  "height"
     t.integer  "width"
     t.integer  "depth"
-    t.string   "isbn"
-    t.string   "isbn10"
-    t.string   "wrong_isbn"
-    t.string   "nbn"
-    t.string   "lccn"
-    t.string   "oclc_number"
-    t.string   "issn"
     t.integer  "price"
     t.text     "fulltext"
     t.string   "volume_number_string"
     t.string   "issue_number_string"
     t.string   "serial_number_string"
@@ -55,20 +69,15 @@
     t.integer  "frequency_id",             :default => 1,     :null => false
     t.boolean  "subscription_master",      :default => false, :null => false
     t.integer  "volume_number"
     t.integer  "issue_number"
     t.integer  "serial_number"
+    t.string   "pub_date"
+    t.boolean  "periodical"
   end
 
   add_index "manifestations", ["access_address"], :name => "index_manifestations_on_access_address"
-  add_index "manifestations", ["carrier_type_id"], :name => "index_manifestations_on_carrier_type_id"
-  add_index "manifestations", ["frequency_id"], :name => "index_manifestations_on_frequency_id"
-  add_index "manifestations", ["isbn"], :name => "index_manifestations_on_isbn"
-  add_index "manifestations", ["issn"], :name => "index_manifestations_on_issn"
-  add_index "manifestations", ["lccn"], :name => "index_manifestations_on_lccn"
+  add_index "manifestations", ["date_of_publication"], :name => "index_manifestations_on_date_of_publication"
   add_index "manifestations", ["manifestation_identifier"], :name => "index_manifestations_on_manifestation_identifier"
-  add_index "manifestations", ["nbn"], :name => "index_manifestations_on_nbn"
-  add_index "manifestations", ["oclc_number"], :name => "index_manifestations_on_oclc_number"
-  add_index "manifestations", ["required_role_id"], :name => "index_manifestations_on_required_role_id"
   add_index "manifestations", ["updated_at"], :name => "index_manifestations_on_updated_at"
 
 end