--
-- workflow__create_attribute/12
--
create or replace function workflow__create_attribute(
character varying,
character varying,
character varying,
character varying,
character varying,
character varying,
character varying,
character varying,
integer,
integer,
integer,
character varying
) returns int4 as $$
declare
create_attribute__workflow_key alias for $1;
create_attribute__attribute_name alias for $2;
create_attribute__datatype alias for $3;
create_attribute__pretty_name alias for $4;
create_attribute__pretty_plural alias for $5; -- default null
create_attribute__table_name alias for $6; -- default null
create_attribute__column_name alias for $7; -- default null
create_attribute__default_value alias for $8; -- default null
create_attribute__min_n_values alias for $9; -- default 1
create_attribute__max_n_values alias for $10; -- default 1
create_attribute__sort_order alias for $11; -- default null
create_attribute__storage alias for $12; -- default 'generic'
v_attribute_id integer;
begin
v_attribute_id := acs_attribute__create_attribute(
create_attribute__workflow_key,
create_attribute__attribute_name,
create_attribute__datatype,
create_attribute__pretty_name,
create_attribute__pretty_plural,
create_attribute__table_name,
create_attribute__column_name,
create_attribute__default_value,
create_attribute__min_n_values,
create_attribute__max_n_values,
create_attribute__sort_order,
create_attribute__storage,
'f'
);
return v_attribute_id;
end;$$ language plpgsql;