schema.rb in erp_app-3.1.10

- 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 => 20130107214541) do
+ActiveRecord::Schema.define(:version => 20130422163134) 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   "base_url"
+    t.string   "xtype"
     t.string   "type"
     t.datetime "created_at",            :null => false
     t.datetime "updated_at",            :null => false
   end
 
@@ -196,16 +196,41 @@
     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.decimal  "version",    :precision => 8, :scale => 3
-    t.datetime "created_at",                               :null => false
-    t.datetime "updated_at",                               :null => false
+    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"
   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"
@@ -463,10 +488,18 @@
     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
@@ -606,12 +639,14 @@
     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.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
   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"
 
@@ -707,9 +742,34 @@
     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"