Squirrelmail: Difference between revisions
From DWIKI
m (→sasql) |
m (→sasql) |
||
Line 3: | Line 3: | ||
==Interesting plugins== | ==Interesting plugins== | ||
===sasql=== | ===sasql=== | ||
create table spamassassin; | |||
grant all privileges on | 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 21: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;