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