1 DROP TABLE IF EXISTS sms;
5 uid INTEGER NOT NULL REFERENCES users(uid),
6 status TEXT NOT NULL DEFAULT 'Waiting',
8 message VARCHAR(140) NOT NULL,
9 cost NUMERIC(4,2) NOT NULL DEFAULT 0,
10 time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
13 CREATE INDEX sms_status_msgid_idx ON sms (status) WHERE msgid IS NULL;
15 DROP TABLE IF EXISTS clickatell;
17 CREATE TABLE clickatell (
19 username TEXT NOT NULL,
20 password TEXT NOT NULL,
21 PRIMARY KEY (api_id, username)