manage start_date and end_date for time_tables

4 files changed, 41 insertions, 36 deletions

diff --git a/db/migrate/20130412083016_add_shortcut_to_time_table.ninoxe_engine.rb b/db/migrate/20130412083016_add_shortcut_to_time_table.ninoxe_engine.rb
new file mode 100644
index 000000000..f4a351965
--- /dev/null
+++ b/db/migrate/20130412083016_add_shortcut_to_time_table.ninoxe_engine.rb
@@ -0,0 +1,7 @@
+# This migration comes from ninoxe_engine (originally 20130410063411)
+class AddShortcutToTimeTable < ActiveRecord::Migration
+  def change
+    add_column "time_tables", "start_date", "date"
+    add_column "time_tables", "end_date", "date"
+  end
+end
diff --git a/db/migrate/20130412083017_set_shortcut_to_existing_time_table.ninoxe_engine.rb b/db/migrate/20130412083017_set_shortcut_to_existing_time_table.ninoxe_engine.rb
new file mode 100644
index 000000000..b8cea84a5
--- /dev/null
+++ b/db/migrate/20130412083017_set_shortcut_to_existing_time_table.ninoxe_engine.rb
@@ -0,0 +1,11 @@
+# This migration comes from ninoxe_engine (originally 20130410100706)
+class SetShortcutToExistingTimeTable < ActiveRecord::Migration
+  def up
+    Chouette::TimeTable.all.each do |t|
+      t.shortcuts_update
+    end
+  end
+
+  def down
+  end
+end
diff --git a/db/migrate/20130412083423_resize_chouette_columns.ninoxe_engine.rb b/db/migrate/20130412083423_resize_chouette_columns.ninoxe_engine.rb
new file mode 100644
index 000000000..d32753d6f
--- /dev/null
+++ b/db/migrate/20130412083423_resize_chouette_columns.ninoxe_engine.rb
@@ -0,0 +1,6 @@
+# This migration comes from ninoxe_engine (originally 20130410143542)
+class ResizeChouetteColumns < ActiveRecord::Migration
+  def change
+    change_column "vehicle_journeys", "number", "integer", {:limit => 8}
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 22203c823..9110bede4 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -123,20 +123,20 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
     t.datetime "failed_at"
     t.string   "locked_by"
     t.string   "queue"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",                :null => false
+    t.datetime "updated_at",                :null => false
   end
 
   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"
     t.string   "severity"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",                 :null => false
+    t.datetime "updated_at",                 :null => false
   end
 
   add_index "export_log_messages", ["export_id"], :name => "index_export_log_messages_on_export_id"
@@ -146,8 +146,8 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
     t.string   "status"
     t.string   "type"
     t.string   "options"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    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 => 20130207123618) 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"
@@ -207,16 +207,6 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
     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
-  end
-
   create_table "group_of_lines", :force => true do |t|
     t.string   "objectid",       :null => false
     t.integer  "object_version"
@@ -234,13 +224,13 @@ ActiveRecord::Schema.define(:version => 20130207123618) 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"
     t.string   "severity"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",                 :null => false
+    t.datetime "updated_at",                 :null => false
   end
 
   add_index "import_log_messages", ["import_id"], :name => "index_import_log_messages_on_import_id"
@@ -248,8 +238,8 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
   create_table "imports", :force => true do |t|
     t.integer  "referential_id"
     t.string   "status"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",     :null => false
+    t.datetime "updated_at",     :null => false
     t.string   "type"
     t.string   "options"
     t.string   "file_type"
@@ -342,12 +332,11 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
   create_table "referentials", :force => true do |t|
     t.string   "name"
     t.string   "slug"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    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   "the_geom"
     t.string   "bounds"
     t.integer  "organisation_id"
   end
@@ -374,14 +363,6 @@ ActiveRecord::Schema.define(:version => 20130207123618) 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
@@ -486,8 +467,8 @@ ActiveRecord::Schema.define(:version => 20130207123618) do
     t.datetime "last_sign_in_at"
     t.string   "current_sign_in_ip"
     t.string   "last_sign_in_ip"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",                                           :null => false
+    t.datetime "updated_at",                                           :null => false
     t.integer  "organisation_id"
     t.string   "name"
     t.string   "confirmation_token"