Hi,
Below is table format for send_sms table
CREATE TABLE IF NOT EXISTS %S (sql_id bigint(20) not null auto_increment
primary key, momt enum('MO', 'MT', 'DLR') null, sender varchar(20) null,
receiver varchar(20) null, udhdata blob null, msgdata text null, time
bigint(20) null, smsc_id varchar(255) null, service varchar(255) null,
account varchar(255) null, id bigint(20) null, sms_type bigint(20) null,
mclass bigint(20) null, mwi bigint(20) null, coding bigint(20) null,
compress bigint(20) null, validity bigint(20) null, deferred bigint(20)
null, dlr_mask bigint(20) null, dlr_url varchar(255) null, pid bigint(20)
null, alt_dcs bigint(20) null, rpi bigint(20) null, charset varchar(255)
null, boxc_id varchar(255) null, binfo varchar(255) null)
On 9/18/07, Jins <[EMAIL PROTECTED]> wrote:
>
>
> hello,
>
> i heard it is possible to sent sms by updating db and by using sqlbox...
> i have installed standalone sqlbox with kannel.can someone please tell me
> about the table design for the sqlbox to work
>
>
>
>
> --
> Jinson Abraham,
> Torque Technology Solutions,
> T-BIC, Park Center, Technopark,
> Trivandrum.
> www.torque.co.in
