resize public tables foreign keys

2 files changed, 25 insertions, 32 deletions

diff --git a/db/migrate/20130412094550_resize_columns.rb b/db/migrate/20130412094550_resize_columns.rb
new file mode 100644
index 000000000..c780c752d
--- /dev/null
+++ b/db/migrate/20130412094550_resize_columns.rb
@@ -0,0 +1,11 @@
+class ResizeColumns < ActiveRecord::Migration
+  def change
+    change_column "referentials", "organisation_id", "integer", {:limit => 8}
+    change_column "imports", "referential_id", "integer", {:limit => 8}
+    change_column "import_log_messages", "import_id", "integer", {:limit => 8}
+    change_column "exports", "referential_id", "integer", {:limit => 8}
+    change_column "export_log_messages", "export_id", "integer", {:limit => 8}
+    change_column "file_validations", "organisation_id", "integer", {:limit => 8}
+    change_column "file_validation_log_messages", "file_validation_id", "integer", {:limit => 8}
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index fdc3fd5d9..abb811eb1 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,7 +10,7 @@
 #
 # It's strongly recommended to check this file into your version control system.
 
-ActiveRecord::Schema.define(:version => 20130412083423) do
+ActiveRecord::Schema.define(:version => 20130412094550) do
 
   create_table "access_links", :force => true do |t|
     t.integer  "access_point_id",                        :limit => 8
@@ -130,7 +130,7 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   add_index "delayed_jobs", ["priority", "run_at"], :name => "delayed_jobs_priority"
 
   create_table "export_log_messages", :force => true do |t|
-    t.integer  "export_id"
+    t.integer  "export_id",  :limit => 8
     t.string   "key"
     t.string   "arguments",  :limit => 1000
     t.integer  "position"
@@ -142,12 +142,12 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   add_index "export_log_messages", ["export_id"], :name => "index_export_log_messages_on_export_id"
 
   create_table "exports", :force => true do |t|
-    t.integer  "referential_id"
+    t.integer  "referential_id",  :limit => 8
     t.string   "status"
     t.string   "type"
     t.string   "options"
-    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.string   "references_type"
     t.string   "reference_ids"
   end
@@ -186,7 +186,7 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   end
 
   create_table "file_validation_log_messages", :force => true do |t|
-    t.integer  "file_validation_id"
+    t.integer  "file_validation_id", :limit => 8
     t.string   "key"
     t.string   "arguments",          :limit => 1000
     t.integer  "position"
@@ -204,17 +204,7 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
     t.string   "file_type"
     t.datetime "created_at",                      :null => false
     t.datetime "updated_at",                      :null => false
-    t.integer  "organisation_id"
-  end
-
-  create_table "geometry_columns", :id => false, :force => true do |t|
-    t.string  "f_table_catalog",   :limit => 256, :null => false
-    t.string  "f_table_schema",    :limit => 256, :null => false
-    t.string  "f_table_name",      :limit => 256, :null => false
-    t.string  "f_geometry_column", :limit => 256, :null => false
-    t.integer "coord_dimension",                  :null => false
-    t.integer "srid",                             :null => false
-    t.string  "type",              :limit => 30,  :null => false
+    t.integer  "organisation_id", :limit => 8
   end
 
   create_table "group_of_lines", :force => true do |t|
@@ -234,7 +224,7 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   end
 
   create_table "import_log_messages", :force => true do |t|
-    t.integer  "import_id"
+    t.integer  "import_id",  :limit => 8
     t.string   "key"
     t.string   "arguments",  :limit => 1000
     t.integer  "position"
@@ -246,10 +236,10 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   add_index "import_log_messages", ["import_id"], :name => "index_import_log_messages_on_import_id"
 
   create_table "imports", :force => true do |t|
-    t.integer  "referential_id"
+    t.integer  "referential_id", :limit => 8
     t.string   "status"
-    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.string   "type"
     t.string   "options"
     t.string   "file_type"
@@ -342,13 +332,13 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
   create_table "referentials", :force => true do |t|
     t.string   "name"
     t.string   "slug"
-    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.string   "prefix"
     t.string   "projection_type"
     t.string   "time_zone"
     t.string   "bounds"
-    t.integer  "organisation_id"
+    t.integer  "organisation_id", :limit => 8
   end
 
   create_table "routes", :force => true do |t|
@@ -373,14 +363,6 @@ ActiveRecord::Schema.define(:version => 20130412083423) do
     t.integer "line_id",      :limit => 8
   end
 
-  create_table "spatial_ref_sys", :id => false, :force => true do |t|
-    t.integer "srid",                      :null => false
-    t.string  "auth_name", :limit => 256
-    t.integer "auth_srid"
-    t.string  "srtext",    :limit => 2048
-    t.string  "proj4text", :limit => 2048
-  end
-
   create_table "stop_areas", :force => true do |t|
     t.integer  "parent_id",           :limit => 8
     t.string   "objectid",                                                         :null => false