[db] Introduce a table for SMS
- created for the creation of the SMS
- sent the time the message was submitted
- sender_id the subscriber for the return path/report
- receiver_id the subscriber
- header the (optional) SMS PDU header
- payload the payload (utf8), raw data
diff --git a/src/db.c b/src/db.c
index 6979794..a7c4f3d 100644
--- a/src/db.c
+++ b/src/db.c
@@ -143,6 +143,24 @@
return 1;
}
dbi_result_free(result);
+
+ result = dbi_conn_query(conn,
+ "CREATE TABLE IF NOT EXISTS SMS ("
+ "id INTEGER PRIMARY KEY AUTOINCREMENT, "
+ "created TIMESTAMP NOT NULL, "
+ "sent TIMESTAMP, "
+ "sender_id NUMERIC NOT NULL, "
+ "receiver_id NUMERIC NOT NULL, "
+ "header NUMERIC, "
+ "text TEXT NOT NULL "
+ ")"
+ );
+ if (result==NULL) {
+ printf("DB: Failed to create Equipment table.\n");
+ return 1;
+ }
+ dbi_result_free(result);
+
return 0;
}