1 files changed, 13 insertions, 0 deletions
diff --git a/src/sql.c b/src/sql.c
new file mode 100644
index 0000000..6054745
--- /dev/null
+++ b/src/sql.c
@@ -0,0 +1,13 @@
+#include "sql.h"
+
+const char 
+*INIT_SQL = 
+	"CREATE TABLE IF NOT EXISTS links ("
+			"id INTEGER PRIMARY KEY," 
+			"url STRING NOT NULL," 
+			"created INTEGER NOT NULL"
+	");",
+*INSERT_SQL =
+	"INSERT INTO links (url,created)"
+	"VALUES (?1, ?2);",
+*DELETE_SQL = "DELETE FROM links WHERE id = ?1;";