arghhhhhhhhh untested rails code and SQL fixed

diff --git a/app/views/user/account.rhtml b/app/views/user/account.rhtml
index 0f77aa29ded0016f67f1081eb4fcb8f34b343eb0..f969203a33185f928b10c0182697f327056005fc 100644 (file)
--- a/app/views/user/account.rhtml
+++ b/app/views/user/account.rhtml
@@ -57,7 +57,7 @@
     <% mlat = @user.home_lat %>
     <% lon =  @user.home_lon %>
     <% lat =  @user.home_lat  %>
-    <% zoom =  '14' %>
+    <% zoom =  '12' %>
 <script type="text/javascript">
   var mlat = <%= mlat %>;
   var mlon = <%= mlon %>;
@@ -117,7 +117,7 @@
   function init(){
 
     OpenLayers.Util.onImageLoadError = function() {
-      this.src = "http://www.openstreetmap.org/javascript/img/404.png";
+      this.src = "http://www.openstreetmap.org/javascripts/img/404.png";
     }
     map = new OpenLayers.Map( "map", 
         {maxExtent: new OpenLayers.Bounds(-20037508.34,-20037508.34,20037508.34,20037508.34), maxZoomLevel:18, maxResolution:156543, units:'meters', projection: "EPSG:41001"} );

diff --git a/db/migrate.sql b/db/migrate.sql
index 35c5a7659db1237f48e77b1555f4f7cdf3214f43..233ddd400240d7dc7318d6dc62c4a5e997306d56 100644 (file)
--- a/db/migrate.sql
+++ b/db/migrate.sql
@@ -45,8 +45,8 @@ alter table users add column home_zoom int(2) default 3);
 alter table users add column within_lon double default 2;
 alter table users add column within_lat double default 2;
 
-create table messages (id bigint not null auto_increment, user_id bigint(20) not null,  from_user_id bigint(20) not null, from_display_name varchar(255) default "", title varchar(255), body text, sent_on datetime, message_read boolean default 0, primary key(id));
+create table messages (id bigint not null auto_increment, user_id bigint(20) not null,  from_user_id bigint(20) not null, from_display_name varchar(255) default "", to_user_id bigint(20) not null, title varchar(255), body text, sent_on datetime, message_read boolean default 0, primary key(id));
 create index from_name_idx on messages(from_display_name);
 
-create table friends (id bigint not null auto_increment, user_id bigint(20) not null, friend_user_id(20) not null, primary key(id));
+create table friends (id bigint not null auto_increment, user_id bigint(20) not null, friend_user_id bigint(20) not null, primary key(id));
 create index user_id_idx on friends(friend_user_id);