3 #if defined(HAVE_MSSQL) || defined(HAVE_SDB) 5 #define SQLBOX_MSSQL_CREATE_LOG_TABLE "CREATE TABLE %S ( \ 6 sql_id NUMERIC(10,0) IDENTITY NOT NULL PRIMARY KEY, \ 7 momt VARCHAR(3) NULL CHECK (momt IN ( 'MO', 'MT', 'DLR') OR momt IS NULL), \ 8 sender VARCHAR(20) NULL, receiver VARCHAR(20) NULL, \ 9 udhdata VARCHAR(4000) NULL, msgdata VARCHAR(4000) NULL, xtime INTEGER NULL, \ 10 smsc_id VARCHAR(255) NULL, service VARCHAR(255) NULL, account VARCHAR(255) NULL, \ 11 id INTEGER NULL, sms_type INTEGER NULL, mclass INTEGER NULL, mwi INTEGER NULL, \ 12 coding INTEGER NULL, compress INTEGER NULL, validity INTEGER NULL, deferred INTEGER NULL, \ 13 dlr_mask INTEGER NULL, dlr_url VARCHAR(255) NULL, pid INTEGER NULL, alt_dcs INTEGER NULL, \ 14 rpi INTEGER NULL, charset VARCHAR(255) NULL, boxc_id VARCHAR(255) NULL, \ 15 binfo VARCHAR(255) NULL, meta_data VARCHAR(4000) NULL, foreign_id VARCHAR(255) NULL)" 17 #define SQLBOX_MSSQL_CREATE_INSERT_TABLE "CREATE TABLE %S ( \ 18 sql_id NUMERIC(10,0) IDENTITY NOT NULL PRIMARY KEY, \ 19 momt VARCHAR(3) NULL CHECK (momt IN ( 'MO', 'MT', 'DLR') OR momt IS NULL), \ 20 sender VARCHAR(20) NULL, receiver VARCHAR(20) NULL, \ 21 udhdata VARCHAR(4000) NULL, msgdata VARCHAR(4000) NULL, xtime INTEGER NULL, \ 22 smsc_id VARCHAR(255) NULL, service VARCHAR(255) NULL, account VARCHAR(255) NULL, \ 23 id INTEGER NULL, sms_type INTEGER NULL, mclass INTEGER NULL, mwi INTEGER NULL, \ 24 coding INTEGER NULL, compress INTEGER NULL, validity INTEGER NULL, deferred INTEGER NULL, \ 25 dlr_mask INTEGER NULL, dlr_url VARCHAR(255) NULL, pid INTEGER NULL, alt_dcs INTEGER NULL, \ 26 rpi INTEGER NULL, charset VARCHAR(255) NULL, boxc_id VARCHAR(255) NULL, \ 27 binfo VARCHAR(255) NULL, meta_data VARCHAR(4000) NULL), foreign_id VARCHAR(255) NULL" 29 #define SQLBOX_MSSQL_SELECT_QUERY "SELECT TOP 1 sql_id, momt, sender, receiver, udhdata, msgdata, \ 30 xtime, smsc_id, service, account, id, sms_type, mclass, mwi, coding, compress, \ 31 validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data \ 34 #define SQLBOX_MSSQL_INSERT_QUERY "INSERT INTO %S (momt, sender, receiver, udhdata, msgdata, \ 35 xtime, smsc_id, service, account, sms_type, mclass, mwi, coding, compress, validity, \ 36 deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id, binfo, meta_data, foreign_id) VALUES (%S, \ 37 %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S, %S)" 39 #define SQLBOX_MSSQL_DELETE_QUERY "DELETE FROM %S WHERE sql_id = %S" 47 Msg *mssql_fetch_msg();
static XMLRPCDocument * msg
void(* sql_save_msg)(Msg *, Octstr *)