r6167 - branches/bmas-staging/data/schema/mysql

[subve...@svn.freemedsoftware.org]

Author: jeff
Date: 2011-10-25 14:49:35 -0400 (Tue, 25 Oct 2011)
New Revision: 6167

Modified:
branches/bmas-staging/data/schema/mysql/photoid.sql
Log:
Typo.

Modified: branches/bmas-staging/data/schema/mysql/photoid.sql
===================================================================
--- branches/bmas-staging/data/schema/mysql/photoid.sql 2011-10-25 18:41:56 UTC (rev 6166)
+++ branches/bmas-staging/data/schema/mysql/photoid.sql 2011-10-25 18:49:35 UTC (rev 6167)
@@ -91,7 +91,7 @@

CREATE PROCEDURE photoid_GetLatest ( IN patient BIGINT(20) UNSIGNED )
BEGIN
- SELECT p_id FROM photoid WHERE p_patient = patient ORDER BY p_stamp DESC LIMIT 1;
+ SELECT id FROM photoid WHERE p_patient = patient ORDER BY p_stamp DESC LIMIT 1;
END;
//