Squirrelmail: Difference between revisions
From DWIKI
mNo edit summary |
m (→sasql) |
||
Line 3: | Line 3: | ||
==Interesting plugins== | ==Interesting plugins== | ||
===sasql=== | ===sasql=== | ||
grant all privileges on sasql.* to 'sasql'@'localhost' identified by 'sasqlpass'; | |||
flush privileges; | |||
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== | ==Notes== |
Revision as of 21:46, 26 April 2008
Interesting plugins
sasql
grant all privileges on sasql.* to 'sasql'@'localhost' identified by 'sasqlpass'; flush privileges; 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;