5 print "BEGIN TRANSACTION;"
8 print "CREATE TABLE IF NOT EXISTS \"strokes\" ( " \
9 "\"character\" TEXT NOT NULL," \
10 "\"sequence\" INTEGER NOT NULL," \
11 "\"strokes\" TEXT NOT NULL," \
12 "\"token\" INTEGER NOT NULL DEFAULT (0)" \
16 print "CREATE TABLE IF NOT EXISTS desc (name TEXT PRIMARY KEY, value TEXT);";
17 print "INSERT OR IGNORE INTO desc VALUES ('version', '1.2.0');";
20 # Insert data into english table
22 printf "INSERT INTO strokes (\"character\", \"sequence\", strokes, token) VALUES (\"%s\", %d, \"%s\", %d);\n", $1, $2, $3, $4;
27 # Commit the transcation