diff options
| author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-05-29 09:58:48 +0000 |
|---|---|---|
| committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2007-05-29 09:58:48 +0000 |
| commit | 2e2d3731b8e9b9e4d258159b112906b1979841a2 (patch) | |
| tree | c3996e8fa572e6b5bdf60c7fc4c8ca9c03e156ec /create/schema/gen.pl | |
| parent | 7793a01ae2f76d155ae263aedb7b1fae454e9475 (diff) | |
| download | zabbix-2e2d3731b8e9b9e4d258159b112906b1979841a2.tar.gz zabbix-2e2d3731b8e9b9e4d258159b112906b1979841a2.tar.xz zabbix-2e2d3731b8e9b9e4d258159b112906b1979841a2.zip | |
Minor Oracle related fixes.
git-svn-id: svn://svn.zabbix.com/trunk@4194 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/schema/gen.pl')
| -rwxr-xr-x | create/schema/gen.pl | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/create/schema/gen.pl b/create/schema/gen.pl index 2e1588df..f47c51d8 100755 --- a/create/schema/gen.pl +++ b/create/schema/gen.pl @@ -86,21 +86,21 @@ ZBX_TABLE static ZBX_TABLE tables[]={ "; -%oracle=("t_bigint" => "bigint", +%oracle=("t_bigint" => "number(20)", "before" => "", "after" => "", "type" => "sql", - "t_id" => "bigint", - "t_integer" => "integer", - "t_serial" => "serial", - "t_double" => "double", - "t_varchar" => "varchar", - "t_char" => "char", - "t_image" => "longblob", - "t_history_log" => "text", - "t_history_text"=> "text", - "t_blob" => "blob", - "t_item_param" => "varchar(2048)" + "t_id" => "number(20)", + "t_integer" => "number(10)", + "t_serial" => "number(20)", + "t_double" => "number(20,4)", + "t_varchar" => "varchar2", + "t_char" => "varchar2", + "t_image" => "blob", + "t_history_log" => "varchar2(2048)", + "t_history_text"=> "clob", + "t_blob" => "varchar2(2048)", + "t_item_param" => "varchar2(2048)" ); %postgresql=("t_bigint" => "bigint", |