trunk/gosa-plugins/gofax/contrib/gofax.sql

   1 create database gofax;
   2 use gofax;
   3
   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         );
  17
  18 CREATE TABLE faxdata (
  19         id                    VARCHAR(20) PRIMARY KEY,
  20         fax_data              BLOB
  21         );
  22
  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';