diff options
Diffstat (limited to 'data/english.awk')
-rw-r--r-- | data/english.awk | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/data/english.awk b/data/english.awk index 1828d2c..c5dc0aa 100644 --- a/data/english.awk +++ b/data/english.awk @@ -6,7 +6,7 @@ BEGIN { # Create english table print "CREATE TABLE IF NOT EXISTS \"english\" ( " \ - "\"word\" TEXT NOT NULL PRIMARY KEY," \ + "\"word\" TEXT NOT NULL PRIMARY KEY," \ "\"freq\" FLOAT NOT NULL DEFAULT(0)" \ ");"; @@ -16,10 +16,10 @@ BEGIN { } # Insert data into english table - { printf "INSERT INTO english (word, freq) VALUES (\"%s\", \"%f\");\n", $1, $2} + { printf "INSERT INTO english (word, freq) VALUES (\"%s\", %f);\n", $1, $2} #quit sqlite3 END { # Commit the transcation print "COMMIT;" -}
\ No newline at end of file +} |