diff options
| -rw-r--r-- | db/migrate/20130412094550_resize_columns.rb | 11 | ||||
| -rw-r--r-- | db/schema.rb | 46 |
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 |