1 create database gofax;
2 use gofax;
4 CREATE TABLE faxlog (
5 id VARCHAR(20) NOT NULL,
6 status INTEGER NOT NULL,
7 status_message TEXT,
8 uid VARCHAR(20) NOT NULL,
9 queuing_time TIMESTAMP NOT NULL,
10 sender_msn VARCHAR(100),
11 sender_id VARCHAR(100),
12 receiver_msn VARCHAR(100),
13 receiver_id VARCHAR(100),
14 transfer_time INTEGER,
15 pages INTEGER
16 );
18 CREATE TABLE faxdata (
19 id VARCHAR(20) PRIMARY KEY,
20 fax_data BLOB
21 );
23 GRANT INSERT,SELECT ON gofax.faxlog TO logger@localhost IDENTIFIED BY 'somemysqlpass';
24 GRANT INSERT,SELECT,DELETE ON gofax.faxdata TO logger@localhost IDENTIFIED BY 'somemysqlpass';