1 files changed, 25 insertions, 0 deletions
diff --git a/data/english.awk b/data/english.awk
new file mode 100644
index 0000000..1828d2c
--- /dev/null
+++ b/data/english.awk
@@ -0,0 +1,25 @@
+#!/usr/bin/awk
+
+BEGIN {
+    # Begin a transaction
+    print "BEGIN TRANSACTION;"
+
+    # Create english table
+    print "CREATE TABLE IF NOT EXISTS \"english\" ( "   \
+        "\"word\" TEXT NOT NULL PRIMARY KEY,"                       \
+        "\"freq\" FLOAT NOT NULL DEFAULT(0)"            \
+        ");";
+
+    # Create desc table
+    print "CREATE TABLE IF NOT EXISTS desc (name TEXT PRIMARY KEY, value TEXT);";
+    print "INSERT OR IGNORE INTO desc VALUES ('version', '1.2.0');";
+}
+
+    # Insert data into english table
+    {   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