diff options
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/data.c | 4 | ||||
| -rw-r--r-- | lib/list.c | 3 | 
2 files changed, 2 insertions, 5 deletions
| @@ -6,8 +6,8 @@  #include "../lib/util.h"  const char *insert_into = "INSERT INTO words (LINE) VALUES($VVV);"; -const char *select_words = "SELECT Id, Line FROM words WHERE line like $VVV LIMIT $NNN;"; -const char *create_table =  "CREATE TABLE IF NOT EXISTS words (ID INTEGER PRIMARY KEY AUTOINCREMENT, LINE TEXT NOT NULL);"; +const char *select_words = "SELECT Id, Line FROM words WHERE line MATCH $VVV LIMIT $NNN;"; +const char *create_table =  "CREATE VIRTUAL TABLE IF NOT EXISTS words USING fts4 (ID INTEGER PRIMARY KEY AUTOINCREMENT, LINE TEXT NOT NULL);";  Data* new_data(const char* con)  { @@ -36,9 +36,6 @@ LIST* list_remove(LIST* list, unsigned int pos)  void list_free(LIST* list)  { -    for (unsigned int x = 0; x < list->size; x++) -        free(list->list[x]); -      free(list->list);      free(list);  } | 
