3 #if defined(HAVE_PGSQL) || defined(HAVE_SDB) 5 #define SQLBOX_PGSQL_CREATE_LOG_TABLE "CREATE TABLE %S (sql_id SERIAL PRIMARY KEY, \ 6 momt VARCHAR(3) CHECK(momt IN ('MO', 'MT', 'DLR', NULL)) DEFAULT NULL, \ 7 sender VARCHAR(20) NULL, receiver VARCHAR(20) NULL, udhdata VARCHAR(255) NULL, \ 8 msgdata TEXT NULL, time BIGINT NULL, smsc_id VARCHAR(255) NULL, \ 9 service VARCHAR(255) NULL, account VARCHAR(255) NULL, id BIGINT NULL, \ 10 sms_type BIGINT NULL, mclass BIGINT NULL, mwi BIGINT NULL, coding BIGINT NULL, \ 11 compress BIGINT NULL, validity BIGINT NULL, deferred BIGINT NULL, \ 12 dlr_mask BIGINT NULL, dlr_url VARCHAR(255) NULL, pid BIGINT NULL, \ 13 alt_dcs BIGINT NULL, rpi BIGINT NULL, charset VARCHAR(255) NULL, \ 14 boxc_id VARCHAR(255) NULL, binfo VARCHAR(255) NULL, meta_data TEXT NULL, foreign_id VARCHAR(255) NULL)" 16 #define SQLBOX_PGSQL_CREATE_INSERT_TABLE "CREATE TABLE %S (sql_id SERIAL PRIMARY KEY, \ 17 momt VARCHAR(3) CHECK(momt IN ('MO', 'MT', NULL)) DEFAULT NULL, \ 18 sender VARCHAR(20) NULL, receiver VARCHAR(20) NULL, udhdata VARCHAR(255) NULL, \ 19 msgdata TEXT NULL, time BIGINT NULL, smsc_id VARCHAR(255) NULL, \ 20 service VARCHAR(255) NULL, account VARCHAR(255) NULL, id BIGINT NULL, \ 21 sms_type BIGINT NULL, mclass BIGINT NULL, mwi BIGINT NULL, coding BIGINT NULL, \ 22 compress BIGINT NULL, validity BIGINT NULL, deferred BIGINT NULL, \ 23 dlr_mask BIGINT NULL, dlr_url VARCHAR(255) NULL, pid BIGINT NULL, \ 24 alt_dcs BIGINT NULL, rpi BIGINT NULL, charset VARCHAR(255) NULL, \ 25 boxc_id VARCHAR(255) NULL, binfo VARCHAR(255) NULL, meta_data TEXT NULL, foreign_id VARCHAR(255) NULL)" 27 #define SQLBOX_PGSQL_SELECT_QUERY "SELECT sql_id, momt, sender, receiver, udhdata, msgdata, \ 28 time, smsc_id, service, account, id, sms_type, mclass, mwi, coding, compress, validity, deferred, \ 29 dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data FROM %S LIMIT 1 OFFSET 0" 31 #define SQLBOX_PGSQL_INSERT_QUERY "INSERT INTO %S (momt, sender, receiver, udhdata, msgdata, \ 32 time, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, deferred, \ 33 dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data, foreign_id) VALUES (%S, %S, %S, \ 34 %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S)" 36 #define SQLBOX_PGSQL_DELETE_QUERY "DELETE FROM %S WHERE sql_id = %S" 43 #define sql_fetch_msg pgsql_fetch_msg 44 #define sql_save_msg pgsql_save_msg 45 #define sql_leave pgsql_leave 47 Msg *pgsql_fetch_msg();
50 void sqlbox_configure_pgsql(
Cfg *
cfg);
static XMLRPCDocument * msg
void(* sql_save_msg)(Msg *, Octstr *)