spec/db/schema_postgis.rb in postgis_adapter-0.7.2 vs spec/db/schema_postgis.rb in postgis_adapter-0.7.5
- old
+ new
@@ -1,57 +1,57 @@
#add some postgis specific tables
ActiveRecord::Schema.define() do
create_table "table_points", :force => true do |t|
t.string "data"
- t.point "geom", :null=>false
+ t.point "geom", :null=>false, :srid => 4326
end
create_table "table_keyword_column_points", :force => true do |t|
- t.point "location", :null => false
+ t.point "location", :null => false, :srid => 4326
end
create_table "table_line_strings", :force => true do |t|
t.integer "value"
- t.line_string "geom", :null=>false
+ t.line_string "geom", :null=>false, :srid => 4326
end
create_table "table_polygons", :force => true do |t|
- t.polygon "geom", :null=>false
+ t.polygon "geom", :null=>false, :srid => 4326
end
create_table "table_multi_points", :force => true do |t|
- t.multi_point "geom", :null=>false
+ t.multi_point "geom", :null=>false, :srid => 4326
end
create_table "table_multi_line_strings", :force => true do |t|
- t.multi_line_string "geom", :null=>false
+ t.multi_line_string "geom", :null=>false, :srid => 4326
end
create_table "table_multi_polygons", :force => true do |t|
- t.multi_polygon "geom", :null=>false
+ t.multi_polygon "geom", :null=>false, :srid => 4326
end
create_table "table_geometries", :force => true do |t|
- t.geometry "geom", :null=>false
+ t.geometry "geom", :null=>false, :srid => 4326
end
create_table "table_geometry_collections", :force => true do |t|
- t.geometry_collection "geom", :null=>false
+ t.geometry_collection "geom", :null=>false, :srid => 4326
end
create_table "table3dz_points", :force => true do |t|
t.column "data", :string
- t.point "geom", :null => false , :with_z => true
+ t.point "geom", :null => false , :with_z => true, :srid => 4326
end
create_table "table3dm_points", :force => true do |t|
- t.point "geom", :null => false , :with_m => true
+ t.point "geom", :null => false , :with_m => true, :srid => 4326
end
create_table "table4d_points", :force => true do |t|
- t.point "geom", :null => false, :with_m => true, :with_z => true
+ t.point "geom", :null => false, :with_m => true, :with_z => true, :srid => 4326
end
create_table "table_srid_line_strings", :force => true do |t|
t.line_string "geom", :null => false , :srid => 4326
end
@@ -74,9 +74,15 @@
create_table :streets, :force => true do |t|
t.string :data, :limit => 100
t.integer :value
t.line_string :geom, :null => false, :srid => 4326
+ end
+
+ create_table :roads, :force => true do |t|
+ t.string :data, :limit => 100
+ t.integer :value
+ t.multi_line_string :geom, :null => false, :srid => 4326
end
create_table :common_geos, :force => true do |t|
t.string :data, :limit => 100
t.integer :value