Squirrelmail: Difference between revisions

From DWIKI
Line 3: Line 3:
==Interesting plugins==
==Interesting plugins==
===sasql===
===sasql===
 
create table spamassassin;
  grant all privileges on sasql.* to 'sasql'@'localhost' identified by 'sasqlpass';
  grant all privileges on spamassassin.* to 'sasql'@'localhost' identified by 'sasqlpass';
  flush privileges;
  flush privileges;
use spamassassin;
  CREATE TABLE userpref (
  CREATE TABLE userpref (
   username varchar(100) NOT NULL,
   username varchar(100) NOT NULL,

Revision as of 22:47, 26 April 2008

Interesting plugins

sasql

create table spamassassin;
grant all privileges on spamassassin.* to 'sasql'@'localhost' identified by 'sasqlpass';
flush privileges;
use spamassassin;
CREATE TABLE userpref (
 username varchar(100) NOT NULL,
 preference varchar(30) NOT NULL,
 value varchar(100) NOT NULL,
 prefid int(11) NOT NULL auto_increment,
 PRIMARY KEY (prefid),
 INDEX (username)
) TYPE=MyISAM;

Notes