|
Revision 15, 0.6 kB
(checked in by tommi, 8 months ago)
|
Added enqueue for sending messages.
Changed database layout for sending host.
Various.
|
| Line | |
|---|
| 1 |
DROP TABLE IF EXISTS phones; |
|---|
| 2 |
CREATE TABLE phones ( |
|---|
| 3 |
id int primary key auto_increment, |
|---|
| 4 |
phonename char(128) not null, |
|---|
| 5 |
phone_host char(128) not null, |
|---|
| 6 |
config char(128) not null, |
|---|
| 7 |
maxlength int not null default 160, |
|---|
| 8 |
state enum('idle', 'sending', 'failed') not null default 'idle' |
|---|
| 9 |
); |
|---|
| 10 |
|
|---|
| 11 |
|
|---|
| 12 |
DROP TABLE IF EXISTS messagequeue; |
|---|
| 13 |
CREATE TABLE messagequeue ( |
|---|
| 14 |
id int primary key auto_increment, |
|---|
| 15 |
number char(32) not null, |
|---|
| 16 |
message text not null, |
|---|
| 17 |
requested TIMESTAMP not null default CURRENT_TIMESTAMP, |
|---|
| 18 |
hostname char(128) not null, |
|---|
| 19 |
phone_id int default 0, |
|---|
| 20 |
state enum('queued', 'intransit', 'sent') not null default 'queued', |
|---|
| 21 |
sent TIMESTAMP |
|---|
| 22 |
); |
|---|
| 23 |
|
|---|
| 24 |
|
|---|
