hi all, i've finalled gotten round to trying mysql storage. i compiled
mysql support in, and included the following in smskannel.conf:
group = mysql-connection
id = mydlr
host = localhost
username = kannel
password = kannel
database = kannel
max-connections = 1
group = dlr-db
id = mydlr
table = dlr
field-smsc = smsc
field-timestamp = ts
field-destination = destination
field-source = source
field-service = service
field-url = url
field-mask = mask
field-status = status
field-boxc-id = boxc
and then created a database kannel, with username kannel and password
kannel.
what i'm unsure of is how i should structure my database table. does
anyone have a suggested CREATE TABLE statement?
cheers
iain
