Revision: 1099
Author:
joaquim....@gmail.com
Date: Fri Apr 17 16:37:10 2015 UTC
Log: Fixes problem with generating new rpersons ids
https://code.google.com/p/mhk/source/detail?r=1099
Modified:
/trunk/idb/etc/db/system/record_linking/rentities.sql
=======================================
--- /trunk/idb/etc/db/system/record_linking/rentities.sql Mon Nov 29
18:12:47 2010 UTC
+++ /trunk/idb/etc/db/system/record_linking/rentities.sql Fri Apr 17
16:37:10 2015 UTC
@@ -16,7 +16,7 @@
vobs TEXT,
OUT vid VARCHAR(64))
BEGIN
- insert into rpersons (sname,sex,status,obs)
VALUES(vsname,vsex,vstatus,vobs);
+ insert into rpersons (id,sname,sex,status,obs)
VALUES('**fake_ID**',vsname,vsex,vstatus,vobs);
SET vid:=concat('rp-',LAST_INSERT_ID());
update rpersons set id=vid where seq=LAST_INSERT_ID();
insert into rentities (id,the_class, description, status,user,obs)