diff options
| author | justanothercatgirl <sotov@twistea.su> | 2025-03-27 12:52:11 +0300 |
|---|---|---|
| committer | justanothercatgirl <sotov@twistea.su> | 2025-03-27 12:52:11 +0300 |
| commit | 82742d5d13dc7b0691a79c79f8e62782fcb16e10 (patch) | |
| tree | 48d077549ed667d2a54171b82eb7608cb8edaf3e /src/sql.c | |
| parent | 8542ec17d3df989f3df9fd03af7a447bf730dc13 (diff) | |
Doing SQL (work in progress)
Diffstat (limited to 'src/sql.c')
| -rw-r--r-- | src/sql.c | 13 |
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;"; |