From: Steve Coast <steve@asklater.com>
Date: Sun, 6 May 2007 10:20:40 +0000 (+0000)
Subject: arghhhhhhhhh untested rails code and SQL fixed
X-Git-Tag: live~8516
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/48183e2d53d41bcdf32153e64dcea968f3d90ae3

arghhhhhhhhh untested rails code and SQL fixed
---

diff --git a/app/views/user/account.rhtml b/app/views/user/account.rhtml
index 0f77aa29d..f969203a3 100644
--- 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 35c5a7659..233ddd400 100644
--- 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);