aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorLuc Donnet2012-12-17 14:59:09 +0100
committerLuc Donnet2012-12-17 14:59:09 +0100
commit9b20cc52ee2dff4cc306b448dbbc7b688c1aae4a (patch)
tree8c081297841b463084e345cacbbbe269c51ad84d /db
parent948290ec960da8dac519adc931f114d61586582d (diff)
downloadchouette-core-9b20cc52ee2dff4cc306b448dbbc7b688c1aae4a.tar.bz2
Delete development database for travis
Diffstat (limited to 'db')
-rw-r--r--db/schema.rb47
1 files changed, 33 insertions, 14 deletions
diff --git a/db/schema.rb b/db/schema.rb
index d5d99ea89..cbbd696ab 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -115,8 +115,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
t.datetime "failed_at"
t.string "locked_by"
t.string "queue"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "delayed_jobs", ["priority", "run_at"], :name => "delayed_jobs_priority"
@@ -127,8 +127,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
t.string "arguments", :limit => 1000
t.integer "position"
t.string "severity"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "export_log_messages", ["export_id"], :name => "index_export_log_messages_on_export_id"
@@ -138,8 +138,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
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"
+ t.datetime "updated_at"
t.string "references_type"
t.string "reference_ids"
end
@@ -199,6 +199,16 @@ ActiveRecord::Schema.define(:version => 20121025112852) 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"
@@ -221,8 +231,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
t.string "arguments", :limit => 1000
t.integer "position"
t.string "severity"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
end
add_index "import_log_messages", ["import_id"], :name => "index_import_log_messages_on_import_id"
@@ -230,8 +240,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
create_table "imports", :force => true do |t|
t.integer "referential_id"
t.string "status"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.string "type"
t.string "options"
t.string "file_type"
@@ -324,11 +334,12 @@ ActiveRecord::Schema.define(:version => 20121025112852) 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"
+ t.datetime "updated_at"
t.string "prefix"
t.string "projection_type"
t.string "time_zone"
+ t.string "the_geom"
t.string "bounds"
t.integer "organisation_id"
end
@@ -355,6 +366,14 @@ ActiveRecord::Schema.define(:version => 20121025112852) 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
@@ -459,8 +478,8 @@ ActiveRecord::Schema.define(:version => 20121025112852) do
t.datetime "last_sign_in_at"
t.string "current_sign_in_ip"
t.string "last_sign_in_ip"
- t.datetime "created_at", :null => false
- t.datetime "updated_at", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
t.integer "organisation_id"
t.string "name"
t.string "confirmation_token"