From 82742d5d13dc7b0691a79c79f8e62782fcb16e10 Mon Sep 17 00:00:00 2001 From: justanothercatgirl Date: Thu, 27 Mar 2025 12:52:11 +0300 Subject: Doing SQL (work in progress) --- src/sql.c | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 src/sql.c (limited to 'src/sql.c') 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;"; -- cgit v1.2.3-70-g09d2