diff options
| author | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-03-05 13:22:52 +0000 |
|---|---|---|
| committer | sasha <sasha@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-03-05 13:22:52 +0000 |
| commit | ed2942140b3197844ca545f96e8ef908a9d5342b (patch) | |
| tree | 33ff0755e7578c4a51d61371f8f4da818fbb2d9a /create | |
| parent | e99897ec33423ccabd32fd15256dafbe65616668 (diff) | |
| download | zabbix-ed2942140b3197844ca545f96e8ef908a9d5342b.tar.gz zabbix-ed2942140b3197844ca545f96e8ef908a9d5342b.tar.xz zabbix-ed2942140b3197844ca545f96e8ef908a9d5342b.zip | |
- [DEV-105] Database changes
git-svn-id: svn://svn.zabbix.com/trunk@5442 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
| -rwxr-xr-x | create/schema/gen.pl | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/create/schema/gen.pl b/create/schema/gen.pl index 647a66b6..1156faf8 100755 --- a/create/schema/gen.pl +++ b/create/schema/gen.pl @@ -224,13 +224,13 @@ sub process_table $pkey=""; } - $ifexists = ""; + $ifnotexists = ""; if ($output{"database"} eq "sqlite") { - $ifexists = "IF EXISTS "; + $ifnotexists = "IF NOT EXISTS "; } - print "CREATE TABLE $ifexists$table_name (\n"; + print "CREATE TABLE $ifnotexists$table_name (\n"; } } @@ -303,19 +303,19 @@ sub process_index ($name,$fields)=split(/\|/, $line,2); - $ifexists = ""; + $ifnotexists = ""; if($output{"database"} eq "sqlite") { - $ifexists = "IF EXISTS "; + $ifnotexists = "IF NOT EXISTS "; } if($unique == 1) { - print "CREATE UNIQUE INDEX $ifexists${table_name}_$name\ on $table_name ($fields);\n"; + print "CREATE UNIQUE INDEX $ifnotexists${table_name}_$name\ on $table_name ($fields);\n"; } else { - print "CREATE INDEX $ifexists${table_name}_$name\ on $table_name ($fields);\n"; + print "CREATE INDEX $ifnotexists${table_name}_$name\ on $table_name ($fields);\n"; } } |