schema.rb in erp_app-3.1.9

- old
+ new

@@ -9,11 +9,11 @@
 # 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 => 20130422163134) do
+ActiveRecord::Schema.define(:version => 20130107214541) do
 
   create_table "app_containers", :force => true do |t|
     t.integer  "user_id"
     t.string   "description"
     t.string   "internal_identifier"
@@ -37,11 +37,11 @@
     t.string   "description"
     t.string   "icon"
     t.string   "internal_identifier"
     t.string   "javascript_class_name"
     t.string   "shortcut_id"
-    t.string   "xtype"
+    t.string   "base_url"
     t.string   "type"
     t.datetime "created_at",            :null => false
     t.datetime "updated_at",            :null => false
   end
 
@@ -196,41 +196,16 @@
     t.datetime "updated_at",          :null => false
   end
 
   add_index "category_classifications", ["classification_id", "classification_type"], :name => "classification_polymorphic"
 
-  create_table "compass_ae_instance_party_roles", :force => true do |t|
-    t.string   "description"
-    t.integer  "compass_ae_instance_id"
-    t.integer  "party_id"
-    t.integer  "role_type_id"
-    t.datetime "created_at",             :null => false
-    t.datetime "updated_at",             :null => false
-  end
-
-  add_index "compass_ae_instance_party_roles", ["compass_ae_instance_id"], :name => "compass_ae_instance_id_idx"
-  add_index "compass_ae_instance_party_roles", ["party_id"], :name => "party_id_idx"
-  add_index "compass_ae_instance_party_roles", ["role_type_id"], :name => "role_type_id_idx"
-
   create_table "compass_ae_instances", :force => true do |t|
-    t.string   "description"
-    t.string   "internal_identifier"
-    t.decimal  "version",             :precision => 8, :scale => 3
-    t.string   "type"
-    t.string   "schema",                                            :default => "public"
-    t.integer  "parent_id"
-    t.datetime "created_at",                                                              :null => false
-    t.datetime "updated_at",                                                              :null => false
-    t.string   "guid"
+    t.decimal  "version",    :precision => 8, :scale => 3
+    t.datetime "created_at",                               :null => false
+    t.datetime "updated_at",                               :null => false
   end
 
-  add_index "compass_ae_instances", ["guid"], :name => "guid_idx"
-  add_index "compass_ae_instances", ["internal_identifier"], :name => "iid_idx"
-  add_index "compass_ae_instances", ["parent_id"], :name => "parent_id_idx"
-  add_index "compass_ae_instances", ["schema"], :name => "schema_idx"
-  add_index "compass_ae_instances", ["type"], :name => "type_idx"
-
   create_table "configuration_item_types", :force => true do |t|
     t.integer  "parent_id"
     t.integer  "lft"
     t.integer  "rgt"
     t.string   "description"
@@ -488,18 +463,10 @@
     t.datetime "updated_at",                                                              :null => false
   end
 
   add_index "individuals", ["party_id"], :name => "index_individuals_on_party_id"
 
-  create_table "job_trackers", :force => true do |t|
-    t.string   "job_name"
-    t.string   "job_klass"
-    t.string   "run_time"
-    t.datetime "last_run_at"
-    t.datetime "next_run_at"
-  end
-
   create_table "money", :force => true do |t|
     t.string   "description"
     t.decimal  "amount",      :precision => 8, :scale => 2
     t.integer  "currency_id"
     t.datetime "created_at",                                :null => false
@@ -639,14 +606,12 @@
     t.string   "zip"
     t.string   "country"
     t.string   "description"
     t.integer  "geo_country_id"
     t.integer  "geo_zone_id"
-    t.datetime "created_at",                                    :null => false
-    t.datetime "updated_at",                                    :null => false
-    t.decimal  "latitude",       :precision => 12, :scale => 8
-    t.decimal  "longitude",      :precision => 12, :scale => 8
+    t.datetime "created_at",     :null => false
+    t.datetime "updated_at",     :null => false
   end
 
   add_index "postal_addresses", ["geo_country_id"], :name => "index_postal_addresses_on_geo_country_id"
   add_index "postal_addresses", ["geo_zone_id"], :name => "index_postal_addresses_on_geo_zone_id"
 
@@ -742,34 +707,9 @@
     t.datetime "updated_at", :null => false
   end
 
   add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
   add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
-
-  create_table "status_applications", :force => true do |t|
-    t.integer  "tracked_status_type_id"
-    t.integer  "status_application_record_id"
-    t.string   "status_application_record_type"
-    t.datetime "from_date"
-    t.datetime "thru_date"
-    t.datetime "created_at",                     :null => false
-    t.datetime "updated_at",                     :null => false
-  end
-
-  add_index "status_applications", ["from_date"], :name => "from_date_idx"
-  add_index "status_applications", ["status_application_record_id", "status_application_record_type"], :name => "status_applications_record_idx"
-  add_index "status_applications", ["thru_date"], :name => "thru_date_idx"
-  add_index "status_applications", ["tracked_status_type_id"], :name => "tracked_status_type_id_idx"
-
-  create_table "tracked_status_types", :force => true do |t|
-    t.string   "description"
-    t.string   "internal_identifier"
-    t.string   "external_identifier"
-    t.datetime "created_at",          :null => false
-    t.datetime "updated_at",          :null => false
-  end
-
-  add_index "tracked_status_types", ["internal_identifier"], :name => "tracked_status_types_iid_idx"
 
   create_table "tree_menu_node_defs", :force => true do |t|
     t.string   "node_type"
     t.integer  "parent_id"
     t.integer  "lft"