diff options
Diffstat (limited to 'create/schema/gen.pl')
| -rwxr-xr-x | create/schema/gen.pl | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/create/schema/gen.pl b/create/schema/gen.pl index f47c51d8..53c03c76 100755 --- a/create/schema/gen.pl +++ b/create/schema/gen.pl @@ -38,7 +38,8 @@ local $output; "t_integer" => "integer", "t_time" => "integer", "t_serial" => "serial", - "t_double" => "double", + "t_double" => "double(16,4)", + "t_percentage" => "double(5,2)", "t_varchar" => "varchar", "t_char" => "char", "t_image" => "longblob", @@ -56,6 +57,7 @@ local $output; "t_time" => "ZBX_TYPE_INT", "t_serial" => "ZBX_TYPE_UINT", "t_double" => "ZBX_TYPE_FLOAT", + "t_percentage" => "ZBX_TYPE_FLOAT", "t_varchar" => "ZBX_TYPE_CHAR", "t_char" => "ZBX_TYPE_CHAR", "t_image" => "ZBX_TYPE_BLOB", @@ -92,8 +94,10 @@ static ZBX_TABLE tables[]={ "type" => "sql", "t_id" => "number(20)", "t_integer" => "number(10)", + "t_time" => "number(10)", "t_serial" => "number(20)", "t_double" => "number(20,4)", + "t_percentage" => "number(5,2)", "t_varchar" => "varchar2", "t_char" => "varchar2", "t_image" => "blob", @@ -111,7 +115,8 @@ static ZBX_TABLE tables[]={ "t_id" => "bigint", "t_integer" => "integer", "t_serial" => "serial", - "t_double" => "numeric", + "t_double" => "numeric(16,4)", + "t_percentage" => "numeric(5,2)", "t_varchar" => "varchar", "t_char" => "char", "t_image" => "bytea", @@ -128,8 +133,10 @@ static ZBX_TABLE tables[]={ "type" => "sql", "t_id" => "bigint", "t_integer" => "integer", + "t_time" => "integer", "t_serial" => "serial", - "t_double" => "double", + "t_double" => "double(16,4)", + "t_percentage" => "double(5,2)", "t_varchar" => "varchar", "t_char" => "char", "t_image" => "longblob", |