maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_createdevice(character varying, integer)
Parameters
Name
Type
Mode
serialnumber
character varying
IN
in_idmodeldevice
integer
IN
Definition
INSERT INTO device(iddevice,idtechnicalaccount,idmodeldevice,serialnumber,firmware,createbyuser,creationdate,lastmodifiedbyuser,lastmodificationdate,originatingsystem,longitude,latitude,ip,status) select nextval('sec_device'),5,in_idmodeldevice,$1,'UNKNOWN',0,now(),0,now(),'DBA',0.0,0.0,'127.0.0.1',1;